With 20+ years of experience, I specialize in database optimization, system architecture, and performance tuning large-scale applications.
Currently working as a Senior Software Engineer at Hubstaff, and former Developer Advocate at Timescale.
I'm also a community builder, a cyclist and a permaculture enthusiast.
Featured Content
Latest Talks
Explore my recent presentations at conferences and meetups around the world.
View TalksInteractive Hub & Tools
Apps & Playgrounds
Check out the interactive tools directory, featuring the Semantic Learning journey, full-screen Drawing Recorder, 7m Geodesic Dome Builder, and the new Truck Camper Bamboo Builder.
Explore AppsMandala Drawings
Explore the Mandala Synth and Playground. Draw mandalas, sonify visuals, and experiment with complex geometries mapped to audio.
Launch PlaygroundLatest Post
Auto-Seeding the Dark Proteome: A 0.61 Å DUF1684 Disulfide-Clamped Fold (TM = 0.957) Across Divergent Halophilic Archaea
November 04, 2026 bioinformatics pgvector structural-biology alphafold protein-design postgresql rust
When an autonomous graph crawler explores a protein similarity network by following nearest-neighbor HNSW edges (<=>), it eventually runs into a classic graph-theory bottleneck: connected-component saturation. Yesterday morning at 06:38 AM, our pg_bio Swarm Discovery daemon finished exploring all 287,904 reachable edges in its initial connected component (0 Pending, 0 Exploring), leaving 1,475,830 unvisited real ESM-2 proteins sitting in isolated islands across our 2.34M-protein PostgreSQL 18 table.
Last night, we deployed three major upgrades to break out of that first continent:
- Historical Twilight-Zone Backfill (
backfill_twilight_batch): Scored190,850historical edges (including100%of all85,280tight edges with cosine distance<= 0.065) using compiled Rust Smith-Waterman (smith_waterman_score) and the Bell-Curve Twilight-Zone Index (twilight_score). - Autonomous Dark-Proteome Island Seeding (
auto_seed_new_island): Taught the daemon to automatically jump into unvisited ESM-2 islands (UncharacterizedandDUF— Domain of Unknown Function — families) whenever the frontier queue drains. In just 10.5 hours overnight, the seeder generated59,723new Dark Proteome Island edges (expanding the graph to347,627edges) and placed four brand-newDUFfamilies into the All-Time Top 6 Twilight-Zone Leaderboard. - Standalone Full-Screen 3D Compare Lab (
/compare): Decoupled our 3D Kabsch SVD & RosettaCommons Chaperone workbench from the heatmap modal so any discovery pair can be inspected in a dedicated full-viewport laboratory (/compare/A0ABD5QTT5/A0AA41FYQ3).
Sitting at #1 among all 59,723 newly seeded Dark Proteome Island discoveries (Edge #345587, twilight_score = 0.8377) is a breathtaking cross-family archaeal pair: A0ABD5QTT5 (182 aa, 20.8 kDa) from Halorubrum glutamatedens (Halorubraceae) and A0AA41FYQ3 (181 aa, 20.8 kDa) from Haloarcula salina (Haloarculaceae). Despite diverging across two distinct taxonomic families (52.2% normalized Smith-Waterman similarity) and A0AA41FYQ3 lacking any InterPro domain annotation (domains = []), their 3D AlphaFold backbones lock together at a sub-angstrom 0.61 Å C$\alpha$ RMSD across 175 of 181 residues (96.7% coverage, TM-score = 0.957), preserving a 2.04 Å Cys151–X7–Cys159 C-terminal disulfide clamp, a 0.06 Å Trp167 aromatic anchor, and a 0.950 per-residue solvent-accessibility correlation!
🏝️ Why Connected Components Stall—and How Auto-Island Seeding Unlocked 7 New DUF Families
In high-dimensional protein language model spaces (320-D ESM-2 embeddings indexed via pgvector HNSW), tight distance thresholds (cosine_distance <= 0.12) partition the dark proteome into thousands of distinct topological islands. Once our crawler finished all 287,904 edges reachable from the original seed set, Pending dropped to 0.
By adding auto_seed_new_island() to swarm_discovery.py, the agent now detects queue exhaustion, samples an unvisited real ESM-2 protein (WHERE p.name LIKE '%OS=%' AND (p.name ILIKE '%uncharacterized%' OR p.name ILIKE '%DUF%')), evaluates its top HNSW neighbors inline with smith_waterman_score, interface_complementarity, sequence_entropy, and chaperone_lineage_hash, and seeds a new frontier:
| Overnight Metric (10.5h Run) | Before Upgrade | After Auto-Island Seeder + Backfill | Net Gain |
|---|---|---|---|
Total Graph Edges (orphan_discoveries) |
287,904 |
347,627 |
+59,723 new Dark Proteome Island edges |
Edges Scored with twilight_score |
65,639 (22.8%) |
256,489 (73.8%) |
+190,850 edges evaluated in SQL |
Unscored Tight Historical Edges (<= 0.065) |
85,280 |
0 (100% complete) |
Every tight historical edge audited |
Active Frontier Queue (status = 'Pending') |
0 (stalled) |
13,948 |
Self-sustaining multi-island traversal |
Here are the top new Dark Proteome Island discoveries uncovered overnight across seven untouched DUF families:
| All-Time Rank | Edge ID | Dark Family | Bait (len) — Organism |
Discovery (len) — Organism |
Cosine (<=>) |
SW Sim (%) |
twilight_score |
3D Core RMSD / TM-Score |
|---|---|---|---|---|---|---|---|---|
| #3 (🆕 #1 Island) | 345587 |
DUF1684 |
A0ABD5QTT5 (182 aa) — Halorubrum glutamatedens |
A0AA41FYQ3 (181 aa) — Haloarcula salina |
0.0751 |
52.2% |
0.8377 |
0.61 Å (175 CA) / TM = 0.957 |
| #4 (🆕 #2 Island) | 318140 |
DUF302 |
A0ABD5SLL6 (145 aa) — Natrinema soli |
M0LYV8 (145 aa) — Halococcus hamelinensis 100A6 (Shark Bay stromatolite) |
0.0803 |
55.5% |
0.8355 |
0.64 Å (144 CA) / TM = 0.975 |
| #5 (🆕 #3 Island) | 326543 |
DUF7995 |
M0D3I5 (163 aa) — Halogeometricum pallidum |
U2YSQ3 (161 aa) — Halarchaeum acidiphilum MH1-52-1 (pH 4.4 halophile) |
0.0650 |
48.1% |
0.8327 |
0.72 Å (159 CA) / TM = 0.970 |
| #6 (🆕 #4 Island) | 298897 |
DUF373 |
A0A3A6QKX6 (370 aa) — Halonotius pteroides |
M0A243 (373 aa) — Natrialba hulunbeirensis (soda lake) |
0.0753 |
49.1% |
0.8122 |
Multi-domain haloalkaliphile |
| #10 (🆕 #5 Island) | 301946 |
DUF63 |
A0A5D5AFN6 (375 aa) — Natrialba swarupiae |
A0ABD5QWL6 (385 aa) — Halorubrum glutamatedens |
0.0604 |
31.7% |
0.7015 |
Deep twilight homology |
| #12 (🆕 #6 Island) | 341938 |
DUF4258 |
H1Z0V4 (106 aa) — Methanoplanus limicola |
A0A7D5IMP5 (105 aa) — Methanolobus zinderi (coalbed methanogen) |
0.0724 |
29.0% |
0.6961 |
Cross-order methanogen fold |
| #13 (🆕 #7 Island) | 323725 |
DUF7838 |
M0N1T2 (56 aa) — Halococcus salifodinae (Permian rock salt) |
A0A8T8WBG0 (56 aa) — Halobaculum magnesiiphilum |
0.0571 |
25.0% |
0.6668 |
Ultra-divergent micro-protein |
💻 The SQL: Auditing Edge #345587 (DUF1684) Across Sequence, Vector, and Layer 13 Chaperone Physics
Here is the exact pg_bio SQL query that surfaces Edge #345587 (A0ABD5QTT5 vs. A0AA41FYQ3) and executes a single-pass Layer 13 RosettaCommons Chaperone biophysical audit (bio_rasa, audit_hydrogen_bonds, evaluate_chaperone_block, chaperone_lineage_hash) alongside our vector (<=>) and hybrid (<~>) operators:
SELECT
o.id AS edge_id,
o.bait_id,
o.bait_organism,
o.orphan_id AS discovery_id,
o.orphan_organism,
-- 1. Vector (<=>) & Hybrid (<~>) Distances
ROUND((p1.embedding <=> p2.embedding)::numeric, 4) AS cosine_dist,
ROUND((
ROW(p1.embedding::vector, p1.sequence)::bio_feature
<~> ROW(p2.embedding::vector, p2.sequence)::bio_feature
)::numeric, 4) AS hybrid_dist,
-- 2. Smith-Waterman & Bell-Curve Twilight-Zone Index
smith_waterman_score(p1.sequence, p2.sequence, 2, -1, -2) AS sw_raw_score,
o.seq_identity_pct AS sw_norm_sim_pct,
ROUND(o.twilight_score::numeric, 4) AS twilight_score,
-- 3. Layer 8 PPI Interface Complementarity & Sequence Entropy
ROUND(interface_complementarity(p1.embedding::vector::real[], p2.embedding::vector::real[])::numeric, 4) AS ppi_icomp,
ROUND(sequence_entropy(p1.sequence)::numeric, 3) AS entropy_bait,
ROUND(sequence_entropy(p2.sequence)::numeric, 3) AS entropy_disc,
-- 4. Layer 13 RosettaCommons Chaperone Lineage Provenance
chaperone_lineage_hash('SwarmCompare', o.bait_id, p2.sequence, 1) AS chaperone_lineage_id
FROM orphan_discoveries o
JOIN proteins p1 ON p1.uniprot_id = o.bait_id
JOIN proteins p2 ON p2.uniprot_id = o.orphan_id
WHERE o.id = 345587;
Multi-Layer Biophysical Audit Table (A0ABD5QTT5 vs. A0AA41FYQ3)
| Biophysical Layer & Metric | Bait: A0ABD5QTT5 (Halorubrum glutamatedens) |
Discovery: A0AA41FYQ3 (Haloarcula salina) |
Structural & Evolutionary Interpretation |
|---|---|---|---|
| Taxonomy (Family) | Halorubraceae (Halorubrum) |
Haloarculaceae (Haloarcula) |
Cross-family divergence across two distinct Halobacteriales lineages |
| Sequence Length & Mass | 182 aa (20.8 kDa) |
181 aa (20.8 kDa) |
Near-isometric polypeptide length (len_ratio = 0.9945) |
| Domain Annotation | IPR012467 / PF07920 (DUF1684) |
Unannotated ([] in InterPro) |
Transfers DUF1684 annotation to an unannotated Haloarcula orphan |
ESM-2 Vector Distance (<=>) |
0.0751 (92.49% cosine similarity) |
0.0751 (92.49% cosine similarity) |
Deep latent-space structural convergence |
Hybrid Distance (<~>) |
0.1252 |
0.1252 |
Combined embedding + sequence-kmer distance |
| Smith-Waterman Similarity | 52.2% (119 / 181 identical superposed CA) |
52.2% (sw_score = 313) |
Right inside the sweet spot of the Twilight-Zone (0.8377) |
3D Kabsch Core RMSD (bio_rmsd) |
0.61 Å across 175 CA atoms |
0.61 Å (96.7% coverage) |
Sub-angstrom atomic lock across virtually the entire protein |
Sequential TM-Score (bio_tm_score) |
0.957 |
0.957 |
Far above the 0.50 same-global-fold threshold |
Mean AlphaFold Confidence (pLDDT) |
90.9 |
90.8 |
Very high confidence across the entire $\alpha+\beta$ barrel core |
Shrake-Rupley RASA (bio_rasa) |
0.310 (40.7% buried = 74 aa) |
0.303 (40.9% buried = 74 aa) |
Per-residue RASA Pearson correlation $r = 0.950$ |
Surface Apolar Fraction (surf_hydro) |
10.3% |
10.3% |
Identical ultra-low surface hydrophobicity (prevents salting-out) |
3D H-Bond Network (bio_hbond_network) |
184 H-bonds (37 BUNS) |
196 H-bonds (35 BUNS) |
Haloarcula salina adds +12 stabilizing H-bonds and reduces BUNS by 2 |
Acidic Brine Shell (Asp + Glu %) |
22.0% (40 D/E, pI = 4.27, GRAVY = -0.73) |
24.3% (44 D/E, pI = 4.32, GRAVY = -0.87) |
Extreme negative hydration armor for saturated $\text{NaCl}$ brines |
C-Terminal Cys–X7–Cys Clamp |
Cys151–Cys159 (2.04 Å $\text{S}\gamma-\text{S}\gamma$ disulfide) |
Cys153–Cys161 (3.76 Å $\text{S}\gamma-\text{S}\gamma$ dithiol switch) |
Conserved PFCAYS[E/D]TF[A/S]CP loop clamped by Trp167/Trp169 (0.06 Å) |
🧬 Biological Deep Dive: A 2.04 Å Disulfide Clamp and a 0.06 Å Tryptophan Gatekeeper in Saturated Brines
Why do two halophilic archaea from different taxonomic families—Halorubrum glutamatedens (isolated from high-salinity solar salterns where glutamate acts as a compatible osmolyte) and Haloarcula salina (a classic square/triangular solar-saltern archaeon that accumulates molar intracellular $\text{KCl}$)—preserve a 181-residue DUF1684 protein (PF07920) at 0.61 Å C$\alpha$ RMSD while allowing nearly half of their surface sequences to drift?
When we inspect the 3D atomic coordinates superposed in our new standalone /compare/A0ABD5QTT5/A0AA41FYQ3 workbench, three extraordinary structural invariants jump out:
- The
Cys151–X7–Cys159(PFCAYSETFACP) C-Terminal Disulfide / Redox Clamp: Near the C-terminus ofA0ABD5QTT5(residues150–160:PFCAYSETFACP) andA0AA41FYQ3(residues152–162:PFCAYSDTFSCP), two invariant cysteines bracket a 7-residue $\beta$-turn cap. In the Halorubrum bait (A0ABD5QTT5), the sulfur atoms ($\text{S}\gamma$) ofCys151andCys159sit2.04 Åapart—forming a direct covalent intramolecular disulfide bridge! In the Haloarcula discovery (A0AA41FYQ3),Cys153andCys161sit3.76 Åapart (withCys153$\text{S}\gamma$ positioned just0.53 ÅfromCys151$\text{S}\gamma$ in 3D space), poised to toggle between a reduced dithiol or metal-coordinating state and an oxidized disulfide staple. - The
0.06 ÅTrp167/Trp169Aromatic Anchor and0.07 ÅPFRDKTTGQQTYCatalytic/Ligand Loop: Immediately downstream of theCys–X7–Cysclamp sits an invariant tryptophan (165-ENWLE-169inA0ABD5QTT5vs.167-SNWLE-171inA0AA41FYQ3) whose C$\alpha$ atoms superimpose with an astonishing0.06 Ådeviation (pLDDT = 96.6)! Packing directly against the central core is a 12-residue signature loop—108-VPFRDKTTGQQTY-120(A0ABD5QTT5) vs.110-VPFRDKTTGQQTY-122(A0AA41FYQ3)—wherePhe109/Phe111superimposes at0.07 Å,Arg110/Arg112at0.11 Å, andLys112/Lys114at0.16 Å. Together with the conservedHis24/His25(0.36 Å) andHis58/His59(0.16 Å) imidazole rings, this forms a rigid, electrostatically tuned ligand-binding cleft. - Hyper-Acidic Surface Armor (
24.3%Asp/Glu) &+12Extra Hydrogen Bonds in Haloarcula salina: Layer 13’sbio_rasaShrake-Rupley solver reveals why neither protein aggregates in $4\text{ M }\text{NaCl}$: both architectures bury exactly74core residues (40.7%vs40.9%) with a per-residue RASA correlation of $r = 0.950$, while restricting exposed hydrophobic side chains to an identical10.3%of surface area. To survive even harsher water-activity deprivation, Haloarcula salina (A0AA41FYQ3) upgrades its exterior hydration shell to44acidic residues (24.3%Asp+Glu,GRAVY = -0.87) and weaves196intramolecular hydrogen bonds (+12more thanA0ABD5QTT5), lowering its buried unsatisfied polar atoms (BUNS) from37down to35.
🔬 Interactive 3Dmol.js Structural Validation & Chemistry Lab
Both structures below (/assets/models/AF-A0ABD5QTT5.pdb and /assets/models/AF-A0AA41FYQ3.pdb) are centered at the origin (0, 0, 0) and pre-aligned in the exact same 3D Kabsch coordinate frame (0.61 Å C$\alpha$ RMSD across 175 residues, TM-score = 0.957).
- Double-click either viewer to lock/unlock synchronized 3D camera rotation (
pg_bio_sync.js), or click any residue to highlight its counterpart across both proteins. - Use the 6 interactive chemistry buttons below to inspect the
0.61 Åsuperposed core, the2.04 ÅCys151–Cys159disulfide clamp, the0.07 ÅPFRDKTTGQQTY+His24/His58pocket, the Chaperone CSR H-bond hubs, and the24.3%acidic brine shell!
182 aa | pLDDT: 90.9 | pI: 4.27 | GRAVY: -0.73 | 184 H-Bonds | Cys151–Cys159: 2.04 Å
181 aa | pLDDT: 90.8 | pI: 4.32 | GRAVY: -0.87 | 196 H-Bonds | RMSD: 0.61 Å (TM = 0.957)
A0ABD5QTT5 (Halorubrum glutamatedens) and A0AA41FYQ3 (Haloarcula salina) lock 175 of 181 Cα atoms within 0.61 Å RMSD (TM-score = 0.957, RASA Pearson r = 0.950) while clamping their C-terminal cap with a conserved Cys–X7–Cys + Trp167 (0.06 Å) module.
🔭 The Horizon: Future Research Ideas
The Bait (A0ABD5QTT5 from *Halorubrum glutamatedens) can maintain a 0.61 Å DUF1684 $\alpha+\beta$ fold with a permanently oxidized 2.04 Å Cys151–Cys159 disulfide clamp and 22.0% acidic surface armor in glutamate-buffered solar salterns, but lacks the denser hydrogen-bond cage and reversible dithiol flexibility required when transitioning across fluctuating redox gradients and extreme $\text{KCl}/\text{NaCl}$ saturation, whereas our new Discovery (A0AA41FYQ3 from Haloarcula salina) executes the exact same 175-residue 3D architecture (0.61 Å RMSD, TM = 0.957, RASA r = 0.950) while adding +12 intramolecular hydrogen bonds (196 total), expanding its acidic hydration shell to 24.3% Asp/Glu (GRAVY = -0.87), and poising its Cys153–Cys161 pair at 3.76 Å as a reversible redox/metal switch—making it an ideal scaffold for redox-tunable halophilic biocatalysts, hypersaline biosensors, and Chaperone-guided Foundry-MPNN protein design.*
Here are three concrete computational and wet-lab pipelines where A0ABD5QTT5 and A0AA41FYQ3 can be slotted in immediately:
- Automated Functional Annotation Transfer for Unannotated
HaloarculaProteomes: BecauseA0AA41FYQ3has0InterPro/Pfam annotations in public databases (domains = []) despite sharing a0.61 ÅC$\alpha$ RMSD (TM = 0.957) and a0.07 ÅVPFRDKTTGQQTYcatalytic/ligand motif withA0ABD5QTT5(IPR012467 / PF07920),pg_bio’s combinedtwilight_score >= 0.80+bio_tm_score >= 0.90SQL filter can be run across TrEMBL to automatically assign structural family labels to thousands of “invisible” halophilic proteins. - Redox-Tunable C-Terminal Disulfide Stapling in Haloarcula & Haloferax Chassis: The natural contrast between the covalent
2.04 ÅCys151–Cys159disulfide bond inA0ABD5QTT5and the3.76 ÅCys153–Cys161dithiol switch inA0AA41FYQ3—both anchored against an invariant0.06 ÅTrp167/Trp169residue—provides a plug-and-play11-residueC-terminal redox staple (PFCAYS[E/D]TF[A/S]CP) for stabilizing industrial enzymes in high-salt bioreactors. - RosettaCommons Chaperone Surface Resurfacing Templates (
10.3%Apolar Ceiling): When designing de novo proteins withRFD3 -> Foundry-MPNNfor high-ionic-strength buffers, standard MPNN weights frequently over-pack surface hydrophobics (>25%), leading to instant salting-out. UsingA0AA41FYQ3’sevaluate_chaperone_blockprofile (surf_hydro = 10.3%,24.3%Asp/Glu,196H-bonds,RASA r = 0.950) as a SQL constraint insidepg_bioguarantees that only halophile-grade designs advance to wet-lab synthesis.