A size comparison of the spaceships of Star Trek by Metaball Studios who qualifies it thus:
Not all the ships of Star Trek. Only the most important.
Photon torpedoes fired.
Related: Star Trek: Just The Spaceships
And the mother of them all: Know Your Spaceships