This haunting theme is the main title from Star Trek: First Contact. This 1996 film is a continuation of a story begun in “The Best of Both Worlds Parts One and Two”, the third season finale and season four opener to Star Trek: The Next Generation. In those episodes, Captain Picard (Patrick Stewart) was kidnapped by the Borg and forcibly turned into a cyborg himself. Now, six years later, the Borg have returned and Picard must confront his greatest enemy once and for all. I always found this theme to be incredibly beautiful. In fact, composer Jerry Goldsmith originally wrote this theme for the earlier film Star Trek V: The Final Frontier. In that earlier film, this theme represented “friendship,” namely the friendship that existed between Kirk, Spock and McCoy, who would literally do anything to help each other. To hear the theme in that movie, watch the opening scene when Kirk is climbing El Capitan, and you can hear a brief echo of the theme, which returns later in the campfire scene.
I hope you enjoy it.