USS Houston (NCC-97284)

The USS Houston (NCC-97284) was a dreadnought in service to Starfleet in 2409. She was either commanded by, or the flagship of, Admiral D'vak, and assigned to Star Fleet Battle Group Omega. 

In 2409 she led a task force containing five other ships against a large Borg fleet protecting a Borg Queen. Midway through the battle the Houston attacked a pair of Unimatrix 0047 command ships protecting the Queen's Borg tetrahedron. One command ship struck her amidships with a plasma lance, and the Houston exploded with all hands seconds later. 

Trivia
The Houston was presumably named for the city of Houston, Texas on Earth.