Targets — browse / sort / filter (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 (human). Links to uniprot.org.
- gene_symbol
- Gene symbol (e.g. ITGB3).
- protein_name
- Protein name (UniProt).
- tier
- Tier 1 = PDB-anchored; Tier 1.5 = AlphaFold-confident.
- has_structure
- 1 if the target protein has a reported experimental 3D structure (PDB). This is the CORE requirement the aptamer-Kd layer is built around — filter to 1 for the structure-backed set.
- evidence_priority
- DETERMINISTIC, reproducible prioritisation (0-1) computed at build time from real harvested columns: 0.35*experimental-structure(PDB=1 / AlphaFold-only=0.3) + 0.30*Open-Targets-top-disease-score + 0.20*PREDICTED-surface-accessibility(A_surface=1) + 0.15*EV-detection(EV-Map). A transparent ranking AID, not a validation; the surface/EV terms are PREDICTIONS/DETECTIONS, not measured EV-surface exposure. Recomputable exactly from this DB.
- has_activation_state_pdb_pair
- 1 if a curated ACTIVE/INACTIVE PDB pair exists (only 11 targets).
- in_cev_map
- Detected in the EV-Map plasma-EV dataset (Rai & Greening 2025, Nat Cell Biol, 10.1038/s41556-025-01795-7) = 3,422 apt-scout targets (broad detected proteome). The EV-Map CONSERVED EV proteome is 182 proteins (42 non-EV); apt-scout matches 104 of these conserved EV-hallmark proteins as targets by gene (the other 78 are not apt-scout targets). Use the ev_hallmark_targets query for that subset. IMPORTANT: EV-Map detection means the protein is EV CARGO (present in the vesicle) — it does NOT mean surface-exposed. Rai & Greening 2025 run a separate membrane-impermeant biotinylation assay giving a 151-protein SURFACEOME, and show the conserved SDCBP/syntenin is luminal (not surface-accessible). For genuine EV-surface accessibility use that 151-protein set, not EV-Map presence.
- has_known_aptamer
- 1 if PubMed '(gene) AND (aptamer OR SELEX)' returned any hit (KEYWORD co-mention, includes false positives — NOT a verified aptamer). For verified aptamers with Kd, see the Binding-affinities (v_kd) layer.
- opentargets_top_disease_score
- Open Targets association score (0-1).
- aptamer_count_pubmed
- Number of PubMed hits for (this protein) AND (aptamer OR SELEX). Keyword co-occurrence — verify each (many co-mention without a real aptamer).
- aptamer_pmids
- The actual PubMed IDs behind the aptamer evidence — click each to read the paper. This is the source of the 'has aptamer' claim.
- surface_class
- PREDICTED membrane topology (HPA-derived, not a measurement): A_surface = integral/ecto cell-surface (predicted EV-surface accessible); A2_pm_peripheral = plasma-membrane cytoplasmic-leaflet (SRC/LYN/RHOA, predicted not reachable); A_assoc = secreted/corona; B_cargo = luminal cargo; unknown = no HPA localization. Lipid asymmetry can partially flip (PS via scramblase); confirm by protease-protection / intact-EV surface labelling. See v_surface_targets.
85 rows where has_cryoEM = 1, surface_class = "A_assoc" and tier = "Tier 1" sorted by evidence_priority descending
This data as json, CSV (advanced)
tier 1
- Tier 1 · 85 ✖
surface_class 1
- A_assoc · 85 ✖
has_structure 1
- 1 85
has_cryoEM 1
- 1 · 85 ✖
has_activation_state_pdb_pair 1
- 0 85
| id | gene_symbol | protein_name | tier | evidence_priority ▲ | has_structure | surface_class | pdb_count_total | alphafold_mean_pLDDT | has_cryoEM | has_activation_state_pdb_pair | activation_state_pdb_active | activation_state_pdb_inactive | has_known_aptamer | aptamer_count_pubmed | aptamer_pmids | in_cev_map | opentargets_top_disease_name | opentargets_top_disease_score |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| P00451 | F8 | Coagulation factor VIII | Tier 1 | 0.873 | 1 | A_assoc | 25 | 60.75 | 1 | 0 | 1 | 13 | 40727755, 40266188, 28791655, 21144556, 41587892, 40009491, 38992298, 38752747, 31493779, 29609491, 28979328, 21389323, 20589313 | 1 | hemophilia A | 0.9108044347811838 | ||
| P12883 | MYH7 | Myosin-7 | Tier 1 | 0.871 | 1 | A_assoc | 43 | 74.25 | 1 | 0 | 0 | 0 | 1 | hypertrophic cardiomyopathy | 0.9029865147265421 | |||
| P02452 | COL1A1 | Collagen alpha-1(I) chain | Tier 1 | 0.854 | 1 | A_assoc | 14 | 52.72 | 1 | 0 | 1 | 3 | 40407197, 35905589, 15132764 | 1 | osteogenesis imperfecta type 2 | 0.8471150130101988 | ||
| P45379 | TNNT2 | Troponin T, cardiac muscle | Tier 1 | 0.85 | 1 | A_assoc | 25 | 78.31 | 1 | 0 | 1 | 4 | 41020397, 40313273, 31782481, 30979922 | 1 | hypertrophic cardiomyopathy | 0.8329996050513441 | ||
| P00747 | PLG | Plasminogen | Tier 1 | 0.847 | 1 | A_assoc | 49 | 82.81 | 1 | 0 | 1 | 51 | 24641476, 41699153, 41371773, 41335958, 38963794, 37533140, 37360033, 37149949, 36882463, 36859809, 36358641, 36203210, 36156780, 35715131, 35563278, 35197258, 33918821, 33859620, 33674695, 32199927, 31870256, 30197987, 30015643, 28051346, 27813404, 27755560, 27679852, 26926041, 26876003, 26163061, 25855589, 25793507, 25620243, 25582325, 24922319, 24682699, 24138169, 24012635, 23038812, 22103403, 21147843, 21142878, 20962041, 20594164, 20387790, 20050927, 19485299, 19284310, 18713263, 15560078, 15303967 | 1 | hypoplasminogenemia | 0.8240321266100769 | ||
| P02649 | APOE | Apolipoprotein E | Tier 1 | 0.845 | 1 | A_assoc | 29 | 75.5 | 1 | 0 | 1 | 41 | 41437270, 41316897, 41276911, 40501769, 38895620, 38559166, 38397086, 38377941, 38256230, 36980195, 36579647, 35966595, 35869074, 35415203, 35359181, 34814699, 34757788, 34016094, 31878307, 31461490, 31385390, 29258991, 24589243, 22110600, 41505229, 40429697, 39939919, 36048760, 32831200, 30613278, 29214237, 24121966 | 1 | coronary artery disease | 0.81626595063263 | ||
| P12259 | F5 | Coagulation factor V | Tier 1 | 0.839 | 1 | A_assoc | 17 | 61.91 | 1 | 0 | 1 | 4 | 32696338, 15496523, 24629635, 17878169 | 1 | thrombophilia due to activated protein C resistance | 0.7962069693286362 | ||
| P00488 | F13A1 | Coagulation factor XIII A chain | Tier 1 | 0.838 | 1 | A_assoc | 15 | 90.88 | 1 | 0 | 0 | 0 | 1 | Factor XIII subunit A deficiency | 0.7939842013132387 | |||
| P10643 | C7 | Complement component C7 | Tier 1 | 0.836 | 1 | A_assoc | 8 | 79.94 | 1 | 0 | 1 | 14 | 39226699, 36428893, 35247355, 33334063, 29846697, 29594379, 26947566, 26057195, 24641476, 23657986, 22058017, 15687383, 13129354, 12169610 | 1 | Immunodeficiency due to a late component of complements deficiency | 0.7859621873711432 | ||
| A6XGL2 | INS | Insulin | Tier 1 | 0.835 | 1 | A_assoc | 2 | 47.72 | 1 | 0 | 1 | 243 | 40789983, 40321580, 39657876, 39296939, 38682836, 38513471, 36239972, 36120079, 35749972, 35745014, 35573794, 34538325, 33802772, 32831200, 31924009, 31627812, 31594568, 31465835, 31407274, 31165873, 31147037, 30965174, 30794054, 30639182, 29527194, 26994877, 26588795, 25976342, 25549616, 24871672, 24763820, 23831227, 22740651, 22438927, 21520951, 18539116, 18374645, 15324817, 15256575, 11557344, 11306470, 41699153, 41648807, 41574708, 41325160, 41307103, 41297941, 41283885, 41280530, 41226313, 41217025, 41107610, 40997970, 40603733, 40591341, 40554308, 40519041, 40380000, 40243681, 40125440, 39847085, 39616898, 39602324, 39546403, 39366648, 39317671, 39263947, 39225423, 39029996, 38928037, 38811951, 38809225, 38794182, 38760847, 38585969, 38497478, 38477735, 38397086, 38384162, 38256230, 38172533, 38082853, 38060303, 38059276, 38039734, 37982669, 37779149, 37772688, 37566081 | 1 | diabetes mellitus, permanent neonatal 4 | 0.784300463357018 | ||
| P02647 | APOA1 | Apolipoprotein A-I | Tier 1 | 0.832 | 1 | A_assoc | 32 | 73.56 | 1 | 0 | 1 | 10 | 41773457, 38397086, 36756582, 36340071, 31493779, 35517584, 24008390, 41925578, 30834248 | 1 | hypoalphalipoproteinemia, primary, 2 | 0.7727382344191134 | ||
| P02787 | TF | Serotransferrin | Tier 1 | 0.832 | 1 | A_assoc | 66 | 93.12 | 1 | 0 | 1 | 114 | 41863075, 41824296, 41799016, 41495882, 41477872, 41473960, 41261862, 40903577, 40848288, 40677726, 40598892, 40491004, 40205063, 39794309, 39713350, 39644990, 39605729, 39605530, 39605368, 39605320, 39519666, 39374798, 39271116, 39117705, 39082193, 38776649, 38568408, 38517697, 38352411, 38293094, 38130056, 37769388, 37480814, 37387534, 37219924, 37190227, 37177995, 36797351, 36778047, 36636745, 36334191, 36200779, 35811788, 35668324, 35659235, 34755879, 34534646, 34524404, 34465294, 34448158 | 1 | atransferrinemia | 0.7724190608888654 | ||
| P27918 | CFP | Properdin | Tier 1 | 0.828 | 1 | A_assoc | 14 | 83.31 | 1 | 0 | 1 | 18 | 40359808, 39744100, 33965026, 31473812, 28454652, 26513286, 24968239, 23056492, 22189104, 12678711, 41155459, 40243681, 37566081, 36619572, 34183667, 32366845, 31482734, 28104543 | 1 | Properdin deficiency | 0.7610265174382485 | ||
| P13671 | C6 | Complement component C6 | Tier 1 | 0.826 | 1 | A_assoc | 11 | 79.62 | 1 | 0 | 1 | 31 | 41255414, 39736202, 39680325, 38188151, 36290981, 36165950, 34535250, 33034309, 32414072, 32119944, 31819445, 30039760, 29594379, 29408200, 28024568, 27940247, 26588795, 26316749, 26107993, 24512500, 24309623, 23657986, 22973579, 22527269, 21944470, 21788069, 21645749, 21071077, 20008986, 19469583, 15473710 | 1 | Immunodeficiency due to a late component of complements deficiency | 0.75437296887129 | ||
| P01042 | KNG1 | Kininogen-1 | Tier 1 | 0.824 | 1 | A_assoc | 19 | 65.88 | 1 | 0 | 1 | 3 | 34248840, 36980195 | 1 | congenital high-molecular-weight kininogen deficiency | 0.7480490551878497 | ||
| P03952 | KLKB1 | Plasma kallikrein | Tier 1 | 0.812 | 1 | A_assoc | 22 | 87.88 | 1 | 0 | 1 | 6 | 40008515, 36859809, 33674695, 28959386, 28632925, 23692437 | 1 | inherited prekallikrein deficiency | 0.7077440022291496 | ||
| P02768 | ALB | Albumin | Tier 1 | 0.81 | 1 | A_assoc | 100 | 92.69 | 1 | 0 | 1 | 428 | 40380000, 38959435, 38585969, 38071774, 33334063, 27886058, 42008845, 41963275, 41951078, 41943241, 41853972, 41730466, 41726995, 41688234, 41627846, 41589449, 41564481, 41440282, 41327249, 41287526, 41285542, 41275719, 41221651, 41187986, 41172700, 41123957, 41057289, 41016289, 40931580, 40929740, 40904334, 40893093, 40817942, 40755409, 40750470, 40727755, 40693866, 40651419, 40578264, 40550187, 40516722, 40513168, 40441110, 40295020, 40266188, 40258621, 40233536, 40187290, 40139042, 40083648, 40019314, 39875991, 39807818, 39714093, 39705506, 39624124 | 1 | hyperthyroxinemia | 0.7006021736736501 | ||
| P01189 | POMC | Pro-opiomelanocortin | Tier 1 | 0.809 | 1 | A_assoc | 13 | 57.66 | 1 | 0 | 1 | 1 | 30161145 | 1 | obesity due to pro-opiomelanocortin deficiency | 0.6958797353500403 | ||
| P09871 | C1S | Complement C1s subcomponent | Tier 1 | 0.808 | 1 | A_assoc | 14 | 87.88 | 1 | 0 | 1 | 1 | 29635179 | 1 | Ehlers-Danlos syndrome, periodontal type 2 | 0.6936620421207419 | ||
| P18206 | VCL | Vinculin | Tier 1 | 0.808 | 1 | A_assoc | 37 | 86.56 | 1 | 0 | 1 | 4 | 40321028, 36107718, 30929122, 30697465 | 1 | hypertrophic cardiomyopathy | 0.6924271529635582 | ||
| P23284 | PPIB | Peptidyl-prolyl cis-trans isomerase B | Tier 1 | 0.799 | 1 | A_assoc | 8 | 91.81 | 1 | 0 | 1 | 3 | 35999181, 24152208, 22484812 | 1 | osteogenesis imperfecta type 9 | 0.6629329652595439 | ||
| P48200 | IREB2 | Iron-responsive element-binding protein 2 | Tier 1 | 0.799 | 1 | A_assoc | 1 | 86.75 | 1 | 0 | 0 | 0 | 1 | neurodegeneration, early-onset, with choreoathetoid movements and microcytic anemia | 0.664403876125082 | |||
| P22004 | BMP6 | Bone morphogenetic protein 6 | Tier 1 | 0.795 | 1 | A_assoc | 5 | 68.94 | 1 | 0 | 1 | 1 | 24808863 | 1 | Tangier disease | 0.6511246985190833 | ||
| P02745 | C1QA | Complement C1q subcomponent subunit A | Tier 1 | 0.79 | 1 | A_assoc | 11 | 82.62 | 1 | 0 | 0 | 0 | 1 | C1Q deficiency 1 | 0.6319053256658114 | |||
| P02747 | C1QC | Complement C1q subcomponent subunit C | Tier 1 | 0.787 | 1 | A_assoc | 11 | 80.56 | 1 | 0 | 0 | 0 | 1 | C1Q deficiency | 0.6233532074390745 | |||
| P14210 | HGF | Hepatocyte growth factor | Tier 1 | 0.777 | 1 | A_assoc | 36 | 83.5 | 1 | 0 | 1 | 64 | 41873087, 41601428, 41123956, 40189053, 40041032, 39853766, 39355222, 38963794, 38923378, 37965838, 37075136, 36935149, 36826373, 36477303, 36126144, 34424707, 34165951, 31967847, 31825565, 31595614, 30444610, 30353654, 30312735, 28627727, 26658271, 26592704, 25223895, 23615526, 21546514, 20594164, 16225393, 38925633, 38876234, 34142433, 31381313, 30237882, 29944203, 29416033, 27679852, 27363484, 26131766, 11753087 | 1 | hearing loss, autosomal recessive | 0.5910507391848663 | ||
| P00738 | HP | Haptoglobin | Tier 1 | 0.771 | 1 | A_assoc | 15 | 84.81 | 1 | 0 | 1 | 76 | 41855944, 41638958, 40968672, 40231802, 39880691, 39880501, 39835381, 39804483, 39788927, 39613489, 39435559, 38585969, 38545293, 38218089, 38185050, 38047083, 38039678, 37879039, 37701520, 37696275, 37560929, 37104434, 36863194, 36564526, 36291832, 36201958, 35868696, 35686646, 35439614, 35394406, 35195734, 35081018, 34647930, 34556234, 34520834, 34064911, 34038999, 33896635, 33534888, 33404555, 33395442, 33234387, 33214769, 33131243, 31892078, 31820139, 31665673, 31655906, 31655383, 31494507, 38916796, 34183667, 34117903 | 1 | Hypercholesterolemia | 0.5684135700226365 | ||
| A8K2U0 | A2ML1 | Alpha-2-macroglobulin-like protein 1 | Tier 1 | 0.764 | 1 | A_assoc | 5 | 80.5 | 1 | 0 | 0 | 0 | 1 | Otitis media | 0.5479914512784171 | |||
| Q08043 | ACTN3 | Alpha-actinin-3 | Tier 1 | 0.752 | 1 | A_assoc | 3 | 84.19 | 1 | 0 | 0 | 0 | 1 | Abnormality of the skeletal system | 0.5080072819822437 | |||
| P02788 | LTF | Lactotransferrin | Tier 1 | 0.751 | 1 | A_assoc | 34 | 94.94 | 1 | 0 | 1 | 3 | 33534888, 33398328, 30340834 | 1 | tuberculosis | 0.5046393442671729 | ||
| P05161 | ISG15 | Ubiquitin-like protein ISG15 | Tier 1 | 0.74 | 1 | A_assoc | 22 | 85.88 | 1 | 0 | 0 | 0 | 1 | COVID-19 | 0.4668295741563516 | |||
| Q99969 | RARRES2 | Retinoic acid receptor responder protein 2 | Tier 1 | 0.739 | 1 | A_assoc | 12 | 86.31 | 1 | 0 | 1 | 2 | 38238732, 31878307 | 1 | Abnormality of the skeletal system | 0.4617522712277723 | ||
| Q9BVC4 | MLST8 | Target of rapamycin complex subunit LST8 | Tier 1 | 0.733 | 1 | A_assoc | 45 | 91.62 | 1 | 0 | 0 | 0 | 1 | neurodegenerative disease | 0.4440338170862142 | |||
| Q12884 | FAP | Prolyl endopeptidase FAP | Tier 1 | 0.721 | 1 | A_assoc | 4 | 95.62 | 1 | 0 | 1 | 7 | 40046817, 39710916, 39026723, 37192373, 36838669, 36494579, 35879297 | 1 | psoriasis | 0.40173767366839236 | ||
| P05109 | S100A8 | Protein S100-A8 | Tier 1 | 0.711 | 1 | A_assoc | 13 | 93.06 | 1 | 0 | 1 | 5 | 41654945, 41111484, 32964813, 32478041, 22353892 | 1 | inborn error of immunity | 0.37050380432141355 | ||
| P01011 | SERPINA3 | Alpha-1-antichymotrypsin | Tier 1 | 0.703 | 1 | A_assoc | 26 | 85.19 | 1 | 0 | 1 | 4 | 31878307, 30553167, 27836219, 36980195 | 1 | prostate carcinoma | 0.34451913095860076 | ||
| P29460 | IL12B | Interleukin-12 subunit beta | Tier 1 | 0.687 | 1 | A_assoc | 20 | 91.12 | 1 | 0 | 0 | 0 | 0 | psoriasis | 0.7914863943708039 | |||
| P05019 | IGF1 | Insulin-like growth factor 1 | Tier 1 | 0.68 | 1 | A_assoc | 32 | 59.53 | 1 | 0 | 1 | 23 | 38384162, 35859339, 35591468, 33977395, 33467925, 32511241, 31930684, 26245346, 24832383, 23933187, 23373648, 16019422, 41283885, 39263947, 38497478, 33888746, 15231297 | 0 | growth delay due to insulin-like growth factor type 1 deficiency | 0.7650418939376437 | ||
| Q9GZV9 | FGF23 | Fibroblast growth factor 23 | Tier 1 | 0.679 | 1 | A_assoc | 6 | 76.62 | 1 | 0 | 1 | 11 | 39007037, 38079395, 35415885, 32065590, 30297602, 30197987, 41226313, 36705086 | 0 | autosomal dominant hypophosphatemic rickets | 0.762326334964193 | ||
| P35225 | IL13 | Interleukin-13 | Tier 1 | 0.669 | 1 | A_assoc | 13 | 85.62 | 1 | 0 | 1 | 9 | 41463156, 35356877, 33742062, 32784904, 27640094, 29949702, 21793788 | 0 | atopic eczema | 0.7297489019498119 | ||
| P01023 | A2M | Alpha-2-macroglobulin | Tier 1 | 0.669 | 1 | A_assoc | 13 | 81.5 | 1 | 0 | 1 | 2 | 24121966, 9382799 | 1 | refractive error | 0.2285030343788678 | ||
| Q2MKA7 | RSPO1 | R-spondin-1 | Tier 1 | 0.669 | 1 | A_assoc | 12 | 74.69 | 1 | 0 | 0 | 0 | 0 | palmoplantar keratoderma-XX sex reversal-predisposition to squamous cell carcinoma syndrome | 0.7285342885472184 | |||
| P05305 | EDN1 | Endothelin-1 | Tier 1 | 0.666 | 1 | A_assoc | 17 | 65.19 | 1 | 0 | 1 | 2 | 40438585, 37198662 | 0 | auriculocondylar syndrome | 0.7193561828311311 | ||
| P12272 | PTHLH | Parathyroid hormone-related protein | Tier 1 | 0.666 | 1 | A_assoc | 11 | 62.88 | 1 | 0 | 0 | 0 | 0 | brachydactyly type E | 0.7203484375635054 | |||
| P01270 | PTH | Parathyroid hormone | Tier 1 | 0.664 | 1 | A_assoc | 26 | 72.12 | 1 | 0 | 1 | 9 | 40464222, 40108760, 39880691, 38079395, 25901535, 41303575, 41226313 | 0 | hypoparathyroidism, familial isolated 1 | 0.7147450451832739 | ||
| Q8N300 | SVBP | Small vasohibin-binding protein | Tier 1 | 0.649 | 1 | A_assoc | 24 | 85.06 | 1 | 0 | 0 | 0 | 0 | neurodevelopmental disorder with ataxia, hypotonia, and microcephaly | 0.6640118055835142 | |||
| P05113 | IL5 | Interleukin-5 | Tier 1 | 0.642 | 1 | A_assoc | 5 | 86.69 | 1 | 0 | 1 | 12 | 40972397, 35487180, 35356877, 34831332, 32784904, 32038731, 29881374, 28062796, 26048585 | 0 | asthma | 0.6399821251487101 | ||
| Q16552 | IL17A | Interleukin-17A | Tier 1 | 0.641 | 1 | A_assoc | 44 | 84.31 | 1 | 0 | 1 | 30 | 42017161, 41754778, 41482938, 41477217, 40410820, 39376102, 38091227, 38031342, 37879125, 37238999, 36517803, 36375248, 36326540, 35724603, 32784904, 32387307, 31316164, 27827561, 24056860, 21524680, 20967861, 37563071, 34531951 | 0 | psoriasis | 0.6367521314106471 | ||
| P49913 | CAMP | Cathelicidin antimicrobial peptide | Tier 1 | 0.636 | 1 | A_assoc | 20 | 80.0 | 1 | 0 | 1 | 30 | 41316897, 40997974, 40501769, 39429683, 39045230, 38471488, 37947789, 35479481, 34957366, 33832411, 31940088, 31099939, 26843427, 26358810, 25659966, 25437358, 25390494, 25048161, 25044725, 24814025, 24325980, 23748105, 23744070, 21673794, 18165929, 12569622, 10913311, 10780486, 37400771 | 1 | prostate carcinoma | 0.11970033909944687 | ||
| Q9UHF0 | TAC3 | Tachykinin-3 | Tier 1 | 0.63 | 1 | A_assoc | 2 | 64.88 | 1 | 0 | 0 | 0 | 0 | hypogonadotropic hypogonadism 10 with or without anosmia | 0.5995324402695232 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW v_targets AS
SELECT f.id, n.gene_symbol, n.protein_name, tg.tier,
-- evidence_priority: DETERMINISTIC, reproducible from real DB columns (no LLM).
-- Transparent weights over harvested evidence: structure 0.35, disease importance
-- 0.30 (Open Targets top-disease score), PREDICTED surface accessibility 0.20,
-- EV detection 0.15. A heuristic ranking aid, not a validation; surface/EV terms
-- are predictions/detections, NOT measured EV-surface exposure.
ROUND(
0.35*(CASE WHEN CAST(COALESCE(f.pdb_count_total,'0') AS INTEGER)>0 THEN 1.0
WHEN CAST(COALESCE(NULLIF(f.alphafold_mean_pLDDT,''),'0') AS REAL)>0 THEN 0.3 ELSE 0.0 END)
+ 0.30*MIN(CAST(COALESCE(NULLIF(f.opentargets_top_disease_score,''),'0') AS REAL), 1.0)
+ 0.20*(CASE sc.surface_class WHEN 'A_surface' THEN 1.0 WHEN 'A_assoc' THEN 0.5 WHEN 'A2_pm_peripheral' THEN 0.2 ELSE 0.0 END)
+ 0.15*(CASE WHEN CAST(COALESCE(f.in_cev_map,0) AS INTEGER)=1 THEN 1.0 ELSE 0.0 END)
, 3) AS evidence_priority,
(CASE WHEN CAST(COALESCE(f.pdb_count_total,'0') AS INTEGER)>0 THEN 1 ELSE 0 END) AS has_structure,
sc.surface_class,
f.pdb_count_total, f.alphafold_mean_pLDDT, f.has_cryoEM,
f.has_activation_state_pdb_pair, f.activation_state_pdb_active, f.activation_state_pdb_inactive,
f.has_known_aptamer, f.aptamer_count_pubmed, ap.aptamer_pmids,
f.in_cev_map, f.opentargets_top_disease_name, f.opentargets_top_disease_score
FROM v_target_full f
LEFT JOIN target_names n ON n.target_id=f.id
LEFT JOIN targets tg ON tg.id=f.id
LEFT JOIN target_aptamer_pmids ap ON ap.target_id=f.id
LEFT JOIN membrane_surface_class sc ON sc.target_id=f.id;