open_targets.clinical_target

Python

In [1]:

import bedrock_bio as bb

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

df = rel.limit(5).pl()  # Polars
df = rel.limit(5).df()  # Pandas
df.head()

Out[1]:

	id	drugId	targetId	diseases	clinicalReportIds	maxClinicalStage	version
0	3b7ad4b95a794fe4e04bea03d9823ceb5645f49f67058f...	CHEMBL515914	ENSG00000114491	[--, {'diseaseFromSource': 'psoriasis vulgaris...	[0031dba951c368a84dccf46b2a9f977a8e3f2b03fee1a...	WITHDRAWAL	26.09
1	7b4cac0d68b61249246271262a4baaafb64323f8c0f67a...	CHEMBL646	ENSG00000166206	[--, {'diseaseFromSource': 'ocular procedures'...	[0079802afc17b4a4b0cd2324303df0465109fca4641ad...	WITHDRAWAL	26.09
2	421f0d1f55ceb232c7bbb394c3c30efc0b2cb2e2df2293...	CHEMBL646	ENSG00000145864	[--, {'diseaseFromSource': 'ocular procedures'...	[0079802afc17b4a4b0cd2324303df0465109fca4641ad...	WITHDRAWAL	26.09
3	71672b87829b0d67855f3c4f5ff8fa63ff331b920c5d3a...	CHEMBL646	ENSG00000182256	[--, {'diseaseFromSource': 'ocular procedures'...	[0079802afc17b4a4b0cd2324303df0465109fca4641ad...	WITHDRAWAL	26.09
4	6070950e95a8c5e445cfc6deba41e76cd13123a835c524...	CHEMBL646	ENSG00000113327	[--, {'diseaseFromSource': 'ocular procedures'...	[0079802afc17b4a4b0cd2324303df0465109fca4641ad...	WITHDRAWAL	26.09

R

In [1]:

library(bedrockbio)

lf <- load_table("open_targets.clinical_target")
df <- head(lf, 5) |> collect()

head(df)

Out[1]:

Sample output (5 rows, showing 5 of 7 columns)
   id                       | drugId       | targetId        | maxClinicalStage | version
   ------------------------ | ------------ | --------------- | ---------------- | -------
0  3b7ad4b95a794fe4e04bea0… | CHEMBL515914 | ENSG00000114491 | WITHDRAWAL       | 26.09
1  7b4cac0d68b612492462712… | CHEMBL646    | ENSG00000166206 | WITHDRAWAL       | 26.09
2  421f0d1f55ceb232c7bbb39… | CHEMBL646    | ENSG00000145864 | WITHDRAWAL       | 26.09
3  71672b87829b0d67855f3c4… | CHEMBL646    | ENSG00000182256 | WITHDRAWAL       | 26.09
4  6070950e95a8c5e445cfc6d… | CHEMBL646    | ENSG00000113327 | WITHDRAWAL       | 26.09

Description

Target-drug associations derived from clinical reports, capturing the maximum clinical stage and associated diseases for each target-drug pair [Drug, Target]

Partitions

Not partitioned.

Schema

Column	Type	Description
id	TEXT	Unique identifier for the clinical target-drug association
drugId	TEXT	Open Targets molecule identifier
targetId	TEXT	Open Targets target identifier
diseases	STRUCT(diseaseFromSource TEXT, diseaseId TEXT)[]	Diseases associated with this target-drug clinical pair
clinicalReportIds	TEXT[]	List of clinical report identifiers associated with this target-drug pair
maxClinicalStage	TEXT	Maximum clinical stage reached for this target-drug pair
version	TEXT	Open Targets Platform release version (major.minor), e.g. 26.09. Added during ingest.