Josephson spectroscopy of single atoms in a scanning tunneling microscope