The stellar content of the ROSAT all-sky survey