The super-hive is a Wraith hive ship that was modified to draw energy from Zero Point Modules. With the abundance of new energy, the Hive had increased incredibly in size and power. It was eventually destroyed over Earth during the Battle of the Super-hive by Lt. Colonel John Sheppard with an F-302 fighter-interceptor, which had a Nuclear warhead, he snuck on board the Hive. Sheppard was able to do that because Atlantis arrived there just in time.