Skip to content
bedrock.bio

open_targets.evidence_clinical_precedence

import bedrock_bio as bb

rel = bb.load_table('open_targets.evidence_clinical_precedence')

df = rel.limit(5).pl()  # Polars
df = rel.limit(5).df()  # Pandas
df.head()
targetId id targetFromSourceId diseaseFromSourceMappedId clinicalReportId clinicalStage trialWhyStopped trialStopReasonCategories studyStartDate evidenceDate ... drugId datasourceId datatypeId qualityControls diseaseId publicationDate score directionOnTrait directionOnTarget version
0 ENSG00000101162 003c319d6577e8d841c1bcfee224e122d90d995d ENSG00000101162 MONDO_0007254 nct00785291 PHASE_3 None <NA> 2008-10-13 2008-10-13 ... CHEMBL1201752 clinical_precedence clinical [] MONDO_0007254 2015-06-08 0.7 protect LoF 26.09
1 ENSG00000132170 0045d9a6cc0f0f922df8942e12a73be1519bd27f ENSG00000132170 MONDO_0005101 75a96561-6f52-4c11-a105-391fbbfe4827 APPROVAL None <NA> NaN NaN ... CHEMBL1201013 clinical_precedence clinical [] MONDO_0005101 NaN 1.0 protect GoF 26.09
2 ENSG00000198900 004c8b6769e89e0eef3828abc084d1b006b5ea2a ENSG00000198900 MONDO_0015686 nct00003523 PHASE_2 None <NA> 1999-01-31 1999-01-31 ... CHEMBL274070 clinical_precedence clinical [] MONDO_0015686 2005-01-01 0.2 protect LoF 26.09
3 ENSG00000022355 00899b681d87df6050558e64dd34cb33b4bc8691 ENSG00000022355 MONDO_0005383 31dacbaf-4245-4172-9da4-514be309f341 APPROVAL None <NA> NaN NaN ... CHEMBL661 clinical_precedence clinical [] MONDO_0005383 NaN 1.0 protect GoF 26.09
4 ENSG00000171848 009540155309a564115af18d91ee9a5dedc40291 ENSG00000171848 MONDO_0021335 nct00987766 PHASE_1 None <NA> 2009-11-30 2009-11-30 ... CHEMBL1637 clinical_precedence clinical [] MONDO_0021335 NaN 0.1 protect LoF 26.09

Description

Section titled “Description”

Disease-target evidence based on clinical trials, drug indications, and mechanism of action [Target-Disease]

Partitions

Section titled “Partitions”

Not partitioned.

Schema

Section titled “Schema”
Column Type Description
targetId TEXT Open Targets target identifier
id TEXT Identifer of the disease/target evidence
targetFromSourceId TEXT Target ID in resource of origin (accepted sources include Ensembl gene ID, Uniprot ID, gene symbol), only capital letters are accepted
diseaseFromSourceMappedId TEXT Mapped Open Targets disease identifier
clinicalReportId TEXT Identifier of the clinical report
clinicalStage TEXT Clinical stage of the drug-disease pair
trialWhyStopped TEXT Reason why the trial was stopped, as reported
trialStopReasonCategories TEXT[] Categorised reason(s) why the trial was stopped
studyStartDate TEXT Start date of study in a YYYY-MM-DD format
evidenceDate TEXT Earliest data for the evidence
literature TEXT[] PubMed or preprint reference identifiers
diseaseFromSource TEXT Disease label from the original source
drugFromSource TEXT Drug name/family in resource of origin
drugId TEXT Open Targets drug identifier [bioregistry:chembl]
datasourceId TEXT Identifer of the evidence source
datatypeId TEXT Type of the evidence
qualityControls TEXT[] Evidence quality flags
diseaseId TEXT Open Targets disease identifier
publicationDate TEXT Publication date of the literature reference
score DOUBLE Score of the evidence reflecting the strength of the disease/target relationship
directionOnTrait TEXT Predicted direction of effect on the trait
directionOnTarget TEXT Gain or loss of function effect of the evidence on the target based on the type of drug mechanism of action
version TEXT Open Targets Platform release version (major.minor), e.g. 26.09. Added during ingest.