[Artifacts] Populate structural_data (PDB/UniProt/AlphaFold) for top 15 demo targets to activate Mol* viewer

← All Specs

[Artifacts] Populate structural_data (PDB/UniProt/AlphaFold) for top 15 demo targets to activate Mol* viewer

ID: f3f89c06-7ff Priority: 88 Type: one_shot Status: open

Goal

Populate structural_data JSON in the targets table for the top 15 demo targets with known UniProt IDs, PDB structure IDs, and AlphaFold availability flags. This activates the Mol* 3D protein viewer (added in task:08d47950) which renders when pdb_ids is non-empty or alphafold=True + uniprot_id is present.

Acceptance Criteria

☐ Top 15 demo targets have structural_data populated with UniProt IDs
☐ Targets with PDB structures have pdb_ids list and pdb_available=True
☐ AlphaFold flag set to True for all human proteins (comprehensive coverage)
☐ At least 5 target pages show the embedded Mol* viewer with working PDB structures
☐ Work log updated with timestamped entry

Known UniProt/PDB Mappings

GeneTarget IDUniProtKey PDB IDs
TREM2target-trem2Q9NZC25ELI, 5UD7, 5UTT
APOEtarget-apoeP026491GS9, 1NFN, 2KC3
CYP46A1target-cyp46a1Q9Y6A22Q9F, 3MDM, 3MDL
HDAC3target-hdac3O153794A69, 4QX2, 4QXO
BRD4target-brd4O608852OSS, 2YEL, 3MUK
SIRT1target-sirt1Q96EB64KXQ, 5BTR, 4IG9
TARDBPtarget-tardbpQ131482N3X, 2KXN, 4IUF
TET2target-tet2Q6N0214NM6, 5D9Y
PRKAA1target-prkaa1Q131314RER, 2LTW
ACSL4target-acsl4O604884WD1

Implementation

Write enrich_target_structures.py that:

  • Uses a hard-coded dict of gene → {uniprot_id, pdb_ids, pdb_count, alphafold, cryo_em}
  • Updates structural_data column in targets table via sqlite3
  • Also sets pdb_available=True for targets with pdb_ids
  • Runs as a one-off migration
  • Work Log

    2026-04-04 — Spec created

    • Task created after verifying all target pages now return 200 (clinical_phase bug fixed)
    • Protein viewer code is deployed but no targets have structural_data populated
    • This task will activate the viewer for key demo targets

    Tasks using this spec (1)
    [Artifacts] Populate structural_data (PDB/UniProt/AlphaFold)
    Artifacts done P88
    File: f3f89c06_7ff_spec.md
    Modified: 2026-05-01 20:13
    Size: 2.1 KB