In the same way as the origin of X rays is the excitation of electrons, what is the origin of radio and infrared radiations in this respect?
They can be caused by the same principles as the X-rays, since the differences between them are just the frequency. When you have moving charges, they create a magnetic field that is propagating outwards at the speed of light. But if you accelerate them, the magnetic field changes. And changing magnetic fields create an electric field. Bassicaly you get light or electromagnetic waves.
The faster you are changing the speed of electrons, the bigger the frequency of that "light". Infrared frequency is light you would get if you had an AC current in a wire with the same frequency (roughly 10 to 14th). Obviously we can't reach those frequencies on a large scale, but we can do it on atomic levels where the speeds of electrons are much MUCH greater. If we would keep increasing the frequency we would eventualy reach the spectrum of visible light and you could see the wire emmiting light. Go even higher and you reach the X-rays. These are practicaly not achievable by these means, but if you heat up the matterial to let's say 5000 K, it Will glow red, because the speeds at which the atoms inside it are moving back and forth are on the order of that frequency of red light. Hope this explains sufficiently how light is created. Radiowaves are nothing different, they just have lower frequency.
Indeed, Xrays and infrared are just photons, of different energy. However, since they correspond to different frequencies and thus to different energies, they can be linked to other characterictic phenomena. For example while Xrays are commonly linked to their occurence in electronic spectra (the "Characteristic Xrays" mentioned in the question), IR radiation is commonly linked to lower energy phenomena like radiation of a black body at room temperature (cfr. Planck's law of radiation!). Even lower in energy is microwave radiation, which is famous for being produced 'by the universe itself' as cosmological background radiation. After microwaves, we have the radiowaves but these are so low in energy that I cannot come up with a 'natural' phenomenon in which they are produced! They are important in a lot of practical applications, like MRI. Extremely low energy phenomena, in any case.
There are a number of ways of generating radio waves.
The simple acceleration of electrons in a transmitting dipole will generate radio waves. I guess as you might have been using wi-fi to write your question, you knew this and are more concerned with "natural" sources of radio waves?
Basically, electromagnetic radiation of all wavelengths can be produced by bound-bound, free-bound or free-free transitions of electrons that may be bound in atoms or molecules.
Where bound electrons are involved, then it is typically the spacings between molecular rotational and vibrational levels that are responsible for infrared emission. Longer wavelength bound-bound transitions can occur between hyperfine transitions with small energy differences. e.g. The famous 21cm radiation comes from a hyperfine transition in hydrogen atoms.
The are also a number of mechanisms involving the acceleration of unbound electrons that produce continuum emission at long wavelengths. The most commonly occurring are bremsstrahlung -the acceleration of electrons in the electric fields of ions - which can produce all wavelengths down to a short wavelength roll-off that depends on the gas temperature; and synchrotron continua that are produced by electrons spiralling at relativistic velocities in magnetic fields.
Infrared and radio radiation has the same origin as X rays. When a photon 'crashes' with an electron, that electron gains the energy from the photon (if the photon has high frequency it gains a lot of energy, if it has low frequency it gains little energy). Then, the electron goes to a more energetic energy level, farther away from the nucleus. Then, the electron sends off a photon and goes back to the original energy level. That applies to all kinds of radiation. X rays, infrared and radio radiation are all photons, of different frequencies.