Cheops class warship

Ra's flagship was built in the shape of a pyramid. Jack O'Neill and Daniel Jackson destroyed it, along with Ra, using a naquadah-enhanced nuclear bomb, which Ra had been planning to send back to Earth through the Stargate.