As the pg_bio autonomous night pipeline continues its sweep of the biological unknown, we set our sights on a fascinating target: Aquaporin, the molecular plumbing that regulates water flow in almost every living organism.
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: From Garden to Salt Mine
Using our newly built UniProt SQL Foreign Data Wrapper (bio_search_uniprot), we dynamically enriched the raw vector search directly inside the database, uncovering a remarkable connection:
| Category | Known Bait | Orphan Discovery |
|---|---|---|
| UniProt ID | P61837 |
A0A8J7Y890 |
| Organism | Arabidopsis thaliana | Haloarcula limicola |
| Status | Characterized | Uncharacterized |
| Cosine Distance | - | 0.5894 |
Our “bait” is a well-characterized homolog (a gene inherited in two species by a common ancestor) from Arabidopsis thaliana. Commonly known as thale cress, this humble plant is the superstar model organism of plant biology. Specifically, we used Aquaporin PIP1-1, a water channel that also moonlights as a transporter for carbon dioxide!
In stark contrast, our discovery comes from Haloarcula limicola, a mud-dwelling “haloarchaea” that thrives in hypersaline environments like salt flats and salt mines. Until now, this specific protein in H. limicola was classified as an orphan protein—a biological enigma with no obvious family ties or recognizable relatives in standard databases.
Bait: P61837
Discovery: A0A8J7Y890
The Power of Mathematical Biology
To find this connection, we didn’t just look at the amino acid sequence or rely on synteny (the preserved order of genes on a chromosome across different species). Instead, our system utilizes structural embeddings—complex mathematical representations of a protein’s 3D shape—to find hidden similarities that traditional sequence alignment would miss.
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 = 'P61837')) 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;
🔬 Did You Know? Curiosities of the Extremes
- Saline Survivors: Haloarcula limicola doesn’t just tolerate extreme salt; it requires it to keep its proteins from falling apart. When faced with sudden changes in salinity (osmotic shock), it uses specialized mechanosensitive channels to rapidly balance its internal pressure so its cells don’t burst!
- A Plant in Space: Our bait organism, Arabidopsis thaliana, is so tough and well-studied that it was the very first plant to have its genome sequenced, and it has even been grown aboard the International Space Station to study how plants adapt to microgravity.
Related Discoveries
Since Aquaporin PIP1-1 is known to transport CO₂ alongside water, it’s fascinating to look at other enzymes handling extreme carbon dioxide challenges. Check out our recent dive into Carbonic Anhydrase in the Dark Proteome.
This automated discovery was generated by the pg_bio continuous discovery script.
Check out more of our pipeline’s findings in the Bioinformatics discoveries section!