On stardate 50984.3 the Borg faced their destruction after they invaded Species 8472's fluidic space with intent to assimilate this species. Unfortunately – for the Borg – Species 8472 DNA encoding was so dense that nanoprobes could not assimilate their cells.
Locating the Queen's ship above Jupiter, Picard confronts her, and the Borg Queen explains that following the events of "Endgame," the Borg were decimated to the point of near destruction by the future Janeway's pathogen, leaving only the Borg Queen, a handful of drones and a single Borg Cube by the time that Picard ...
In removing Jack from the Collective, and destroying the Queen's Borg Cube, the crew of the USS Enterprise-D destroyed the original Star Trek: The Next Generation Borg once and for all.
Whilst the Borg are primarily a nomadic space-bearing race they do however occupy planets with a typical population of nine billion drones primarily for the purposes of strip-mining the planets of all natural resources.
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.
Species 8472 possessed superior bio-technology to the Borg Collective, and used it to swiftly destroy multiple Borg Cubes. Species 8472 launched their own invasion of Borg space, something that Janeway believed to be a major threat to the future of the Delta Quadrant.
Summary. Admiral Janeway cameo considered for Picard Season 3, but showrunner Terry Matalas feared it would overshadow Seven of Nine's story. Seven of Nine's journey in Picard Season 3 was one of the best story arcs, starting as First Officer and ending as Captain of the Enterprise-G.
Jack Crusher was a pivotal character in Star Trek: Picard season 3. The son of Jean-Luc Picard and Dr. Beverly Crusher (Gates McFadden) was revealed to be the linchpin of the Borg Queen's (Alice Krige) plot to assimilate Starfleet, evolve the Borg, and exact revenge on the United Federation of Planets.
Jack is indeed the biological son of Jean-Luc Picard and Dr. Beverly Crusher, but as much as he wanted to deny it, the young Crusher is also the son of Locutus and the Borg Queen, who pondered Latin names for Jack like Regenerati (Rebirth) or Puer Dei (Child of God) before she chose to name him Vox.
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.
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 logical implication is the Borg were wiped out by Picard and the USS Enterprise-D, thus they never made it past Star Trek: Picard's early 25th century. This explains why the Borg have not been mentioned in Star Trek: Discovery seasons 3 and 4.
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.
Q. The Q are potentially the least likely to get assimilated, for not just one reason but two. Firstly, their near omnipotence and god-like powers would make it almost impossible for a Borg, or even all Borg working together, to capture a Q.
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.
Species 8472 were introduced in Star Trek: Voyager as the deadly aliens that scared the Borg Collective, impressing viewers with their CGI design. Captain Janeway formed an alliance with the Borg to combat the dangerous Species 8472, who had the ability to wipe out all life in their galaxy.
The Borg learn everything they know about an enemy through assimilating beings. The Borg couldn't assimilate Species 8472 because their immune systems were hyper-advanced.
The pathogen completely decimated the Borg Queen and left the entire Collective in ruins, and while Picard and the crew of the USS Enterprise-D dealt the final killing blow, it was Janeway who originally crippled the Collective permanently.
The society of species 1 consisted of female drones and a queen for each colony. There were males, but they were only used for mating, much like ants on earth. Through millions of years, species 1 developed a collective consciousness on the colony level, with each colony having its own.
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.
The borg collective as a whole didn't join the federation it was just a small splinter group of the borg that joined the federation the main borg collective is still an enemy of the federation and would mostly likely never join the federation instead would keep on trying to assimilate the federation.
