home

scout

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

Custom SQL query

Queries

  • Activation-state-selective targets
  • EV-associated targets with known aptamers
  • Top-priority targets

Tables

sqlite_sequence

name, seq

0 rows

target_aptamer_pmids

target_id, aptamer_pmids, aptamer_pubmed_query

7,197 rows

target_layer1_structure

target_id, pdb_count_total, pdb_count_detailed, pdb_best_resolution_A, alphafold_mean_pLDDT, alphafold_model_count, emdb_count, has_cryoEM, has_xray, has_NMR, raw_json, recorded_utc

7,197 rows

target_layer2_modification

target_id, ptm_count, ptm_phospho_count, ptm_glyco_count, ptm_ubiq_count, has_activation_state_pdb_pair, activation_state_pdb_active, activation_state_pdb_inactive, conformational_states_count, raw_json, recorded_utc

7,197 rows

target_layer3_interaction

target_id, ppi_count, drug_count_approved, drug_count_clinical, aptamer_count_pubmed, aptamer_count_aptagen, antibody_count_hpa, has_known_aptamer, raw_json, recorded_utc

7,197 rows

target_layer4_expression

target_id, hpa_tissue_count, hpa_tissue_jsons, gtex_protein_id, ev_proteome_pride_id, in_vesiclepedia, in_exocarta, in_cev_map, raw_json, recorded_utc, cev_map_in, cev_map_is_ev_hallmark, cev_map_is_nonev_hallmark, cev_map_conservation_pct, cev_map_isolation, cev_map_detection, cev_map_n_samples, cev_map_source_doi

7,198 rows

target_layer5_disease

target_id, opentargets_top_disease_name, opentargets_top_disease_score, opentargets_disease_count, omim_count, clinvar_pathogenic_count, ev_biomarker_disease, ev_biomarker_pubmed_count, raw_json, recorded_utc, clinvar_likely_pathogenic_count, clinvar_benign_count, clinvar_vus_count

7,197 rows

target_names

target_id, gene_symbol, protein_name

7,198 rows

targets

id, target_type, seed_source, status, priority_score, added_utc, started_utc, completed_utc, error, tier, worker_host

7,198 rows

... and 4 hidden tables

Views

  • v_target_full
  • v_targets_by_tier
  • v_targets

Download SQLite DB: scout.db 109.7 MB

Powered by Datasette · Queries took 4.559ms · 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