Per-target full view (5 layers) (view)

Data license: CC BY 4.0 · Data source: apt-scout automated curation pipeline (E. Dohi, NCNP) — values harvested from public databases; raw source stored per target

id

UniProt accession (primary key).

priority_score

apt-scout composite prioritisation score (0-1).

pdb_count_total

Number of PDB structures (source: RCSB PDB). Verify at rcsb.org.

alphafold_mean_pLDDT

Mean AlphaFold per-residue confidence (source: AlphaFold DB). NULL for 653 targets.

has_cryoEM

1 if a cryo-EM structure exists (source: PDB).

has_activation_state_pdb_pair

1 if a curated active/inactive PDB pair exists.

activation_state_pdb_active

PDB ID of the ACTIVE-state structure (human-curated; verify at rcsb.org).

activation_state_pdb_inactive

PDB ID of the INACTIVE-state structure (human-curated; verify at rcsb.org).

ppi_count

Protein-protein interaction count. NOT YET POPULATED (NULL).

drug_count_approved

Approved drugs (source: Open Targets / ChEMBL).

aptamer_count_pubmed

PubMed hits for aptamer/SELEX (source: PubMed query, stored in L3 raw_json with PMIDs).

has_known_aptamer

1 if any aptamer evidence found.

in_vesiclepedia

Member of Vesiclepedia EV proteome.

in_exocarta

Member of ExoCarta EV proteome.

in_cev_map

Member of EV-Map circulating-EV proteome (Rai 2025).

opentargets_top_disease_name

Top disease association (source: Open Targets).

opentargets_top_disease_score

Open Targets association score (0-1).

1 row where id = "P01112" sorted by priority_score descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: completed_utc (date)

CREATE VIEW v_target_full AS
SELECT
  t.id, t.priority_score, t.target_type, t.status, t.completed_utc,
  l1.pdb_count_total, l1.alphafold_mean_pLDDT, l1.has_cryoEM,
  l2.has_activation_state_pdb_pair,
  l2.activation_state_pdb_active,
  l2.activation_state_pdb_inactive,
  l3.ppi_count, l3.drug_count_approved,
  l3.aptamer_count_pubmed, l3.has_known_aptamer,
  l4.in_vesiclepedia, l4.in_exocarta, l4.in_cev_map,
  l5.opentargets_top_disease_name,
  l5.opentargets_top_disease_score,
  l5.ev_biomarker_disease
FROM targets t
LEFT JOIN target_layer1_structure    l1 ON t.id = l1.target_id
LEFT JOIN target_layer2_modification l2 ON t.id = l2.target_id
LEFT JOIN target_layer3_interaction  l3 ON t.id = l3.target_id
LEFT JOIN target_layer4_expression   l4 ON t.id = l4.target_id
LEFT JOIN target_layer5_disease      l5 ON t.id = l5.target_id;