As the pg_bio autonomous night pipeline continues its sweep of the dark proteome, we set our sights on Phosphatase.
Our native PostgreSQL multiomics engine scanned millions of vectors and found a high-confidence structural match that bridges two completely different biological worlds.
The Discovery
Using our newly built UniProt SQL Foreign Data Wrapper (bio_search_uniprot), we dynamically enriched the raw vector search directly inside the database:
| Category | Known Bait | Orphan Discovery |
|---|---|---|
| UniProt ID | P77625 |
A0A830GQ55 |
| Organism | Escherichia coli (strain K12) | Haloarcula pellucida |
| Status | Characterized | Uncharacterized |
| Cosine Distance | - | 0.6281 |
Bait: P77625
Discovery: A0A830GQ55
The SQL Pipeline
This discovery was completely automated natively in PostgreSQL using our custom Z-Order indexing and the new UniProt SRF:
WITH closest AS (
SELECT uniprot_id, name, embedding,
(embedding <=> (SELECT embedding FROM proteins WHERE uniprot_id = 'P77625')) as dist
FROM proteins
WHERE name ILIKE '%uncharacterized%'
ORDER BY dist ASC LIMIT 1
)
SELECT c.uniprot_id, c.dist, u.organism
FROM closest c
CROSS JOIN LATERAL bio_search_uniprot('accession:' || c.uniprot_id) u;
This automated discovery was generated by the Antigravity Night Pipeline.
