Seven arrives at the Artifact, a disabled Borg cube captured by the Romulans, after being summoned by Picard's companion Elnor. To save the former Borg onboard from execution at the hands of the Romulans, she temporarily connects herself to the cube inside the queencell, taking on the role of a Borg Queen.
By the time of the series finale, "Endgame", The Doctor had managed to remove the implant, allowing Seven to pursue a relationship with Chakotay. The alternative future seen at the start of the episode showed that Seven and Chakotay were eventually married, but she died while Voyager was still travelling home.
Originally Answered: Is the Borg Queen 7 of 9's mother? We know for a fact that she is not. The Queen was a member of Species 125, Erin Hansen was human and therefore a member of Species 5618.
The Cube in First Contact had a Queen, In Voyager there was the Queen in Unimatrix Zero despite the Queens death in FC, The Romulan Borg Cube in Picard had a Queens chamber that is probably on every Cube, also Seven seemed to be able to take direct control of the Cube from the Queens chamber.
Picard Season 3's Borg Queen Is Not the Same as Season 2's
Jurati during the events of Season 2, and reveals herself as the leader of a separate (and principled) Collective in Season 2, Episode 10, "Farewell." The latter version of the Borg Queen is presumably the "core universe" version from First Contact and Voyager.
Star Trek Voyager Cast: Then and Now (1995 vs 2024)
Are there two Borg queens?
Only one Queen exists at any given time; when she is destroyed, a new Queen takes her place. In Star Trek: Voyager, it's revealed that the Borg Queen isn't a singular entity, but the name given to any that serves as its host, possessing all previous Queen's collective consciousness.
Jurati returns as the Borg Queen. Upon returning from 2024 moments before the explosion, Picard canceled the auto-destruct and allowed the Borg Queen to proceed after realizing that it was the same Queen from an alternate timeline who had merged with Dr. Jurati.
The Borg, while still a powerful threat, are nothing compared to this type of power. The Q are not only able to defeat their entire race without breaking a sweat, but can also eradicate any trace of their existence altogether.
As far as I know, the "Bad Borg" hail from the Delta Quadrant, and though we don't know just how old that collective is, it is ancient. The "Good Borg", Jurati's Borg, were established in the Alpha Quadrant in the 21st century, when the queen from the alternate timeline and Jurati merged.
The Queen was seemingly killed by the Enterprise-E crew before they returned to 2373. However, the Borg Queen was subsequently resurrected and returned in Star Trek: Voyager, where the crew of the USS Voyager did battle with her on multiple occasions while traveling through the Delta Quadrant.
However, the Queen captures the admiral and begins to assimilate her into the Borg collective. Admiral Janeway then turns the tables by unleashing a pathogen she was carrying in her bloodstream into the collective, devastating it and killing the Queen.
Twenty-four years later, Seven, as she was later known, was liberated from life as a Borg drone by the crew of the USS Voyager and joined the crew under Captain Janeway's mentorship. She was critical in assisting the crew's return to the Alpha Quadrant in 2378.
The whole race, except for 10,000-20,000, has been assimilated. The Borg Queen mentions to Seven that she came from Species 125. This species originally devised the procedure that led to Seven's method to save Neelix with nanoprobes.
A Chakotay cameo would, therefore, have distracted from the overall story of Admiral Jean-Luc Picard (Patrick Stewart) confronting the trauma of his past. Chakotay being at the head of a fascist government also doesn't fit with his character, as he was a member of the Maquis, which fought against Cardassian oppression.
The reasons that Matalas was unable to include Janeway came down to budgetary constraints and not wanting to step on Star Trek: Prodigy's toes, but despite not appearing, Janeway was almost an honorary character in Star Trek: Picard season 3.
Kate Mulgrew prevented Janeway and Chakotay from becoming a couple on Star Trek: Voyager, prioritizing Janeway's likability and reputation. A potential romance between Janeway and Chakotay was also hindered by Starfleet rules, with Janeway focusing on her task of getting Voyager home.
Officially, the existence of a Borg homeworld is a hypothetical one as it has yet to be revealed in a canon Star Trek source. However, an identity for the Borg homeworld is given by the non-canon novel Lost Souls, which names it Arehaz.
Q seemed frightened of Guinan, telling Picard that she is "not what she appears to be," and that Picard should remove her from the Enterprise. Considering Q's abilities, it's unclear why he would be afraid of Guinan, and Star Trek has never offered a real explanation for Q's reaction.
However, a Hirogen can be seen during mind meld scenes in "Infinite Regress", indicating that Seven of Nine herself, or at least the Borg as a species, already had assimilated Hirogen before Seven's liberation from the Collective.
Tuvok, B'Elanna Torres, and Captain Kathryn Janeway have been assimilated as Borg drones aboard Tactical Cube 138, but their personalities remain intact thanks to a short-lived anti-assimilation inoculation developed by The Doctor.
Agnes Jurati's Borg Queen created confusion in Star Trek: Picard season 2, but they weren't the evil Borg Collective, just a small and separate group. Initially intended as a payoff for Picard season 2, Jurati's Borg wasn't meant to be a long-term storyline.
In Peter David's 2007 Star Trek: The Next Generation novel, Before Dishonor, which is set after the events of Star Trek: Nemesis, Janeway is assimilated by a rogue faction of the Borg, and becomes their new Borg Queen.
