Spectral investigations of photoionized plasmas induced in atomic and molecular gases using nanosecond extreme ultraviolet (EUV) pulses