As the pg_bio autonomous night pipeline continues its sweep of the dark proteome, we set our sights on Collagenase.
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 | A0A062V3Q9 |
W0JSR4 |
| Organism | Candidatus Methanoperedens nitratireducens | Halostagnicola larsenii XH-48 |
| Status | Characterized | Uncharacterized |
| Cosine Distance | - | 0.0464 |
Bait: A0A062V3Q9
Discovery: W0JSR4
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 = 'A0A062V3Q9')) 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.
