The Odyssey post Asgard upgrades is a great ship. With the Asgard core's capabilities combined with the shields, energy weapons, transporter technology, hyperdrive, etc...this ship was pretty tough. That with cloaking technology, they only used once but I assume was based on Atlantean though I can't remember, and the Alteran/Ancient phase shifting technology, and you've got a nearly unbeatable ship esp when if they boost its capabilities with a ZPM.