First encountered in the pilot, "Emissary," the Prophets were actually beings that lived in the wormhole and existed outside linear time and space.

Source: https://screenrant.com/star-trek-space-gods-tos-vanished-why/

For the Emissary: Order must be present to contain and control those seeking the dangers of the Artifacts and the power of the Unity.

Source: https://gamerant.com/starfield-in-their-footsteps/

However, in order to have a chance of obtaining it, players will need to choose either the Emissary or no onethe Unearthed main story mission.

Source: https://gamerant.com/how-to-get-the-hunters-rifle-in-starfield-unmitigated-violence-gun/

I know, I know, it's highly unlikely, but I've got Faith in the Emissary.

Source: https://bleedingcool.com/tv/star-trek-picard-showrunner-terry-matalas-on-ds9-sisko-fan-theory/

Kai Winn was terrifyingly unsettling, with absolute, unquestioning conviction that placed her at direct odds with the Federation in general, and Captain Sisko as the Emissary in particular.

Source: https://screenrant.com/star-trek-best-supporting-characters-ranked/

Without the budget for a crossover and with the story idea vetoed by producer Rick Berman, an alternate story to link back to the events of "Emissary" was instead developed as the season 1 finale.

Source: https://screenrant.com/star-trek-ds9-season-1-tng-crossover/