Yeah, it's generally between Science and Nature in terms of greatest publication prestige. Most scientists work their butts off to get their works published in either of those, only to get their work desk-rejected and ultimately published in "less prestigious", field-specific journals.
That's not to say the Science and Nature are the end all be all of scientific journals; there are many journals specific to each field that is also prestigious.
I'm a fan of 'your inner fish' by Neil Shubin. Slightly dated, but the information is still good.