open_targets.drug_warning

Python
R

import bedrock_bio as bb

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

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

	chemblIds	toxicityClass	country	description	id	references	warningType	year	efoTerm	efoId	efoIdForWarningClass	version
0	[CHEMBL4303288, CHEMBL1380]	hepatotoxicity	United States	None	1	[{'id': 'de109a2b-e36c-40d0-85fc-a67a9e7f1ae8'...	Black Box Warning	<NA>	None	None	EFO:0011052	26.09
1	[CHEMBL4303288, CHEMBL1380]	metabolic toxicity	United States	None	2	[{'id': 'de109a2b-e36c-40d0-85fc-a67a9e7f1ae8'...	Black Box Warning	<NA>	None	None	EFO:0011054	26.09
2	[CHEMBL4303288, CHEMBL1380]	immune system toxicity	United States	None	3	[{'id': 'de109a2b-e36c-40d0-85fc-a67a9e7f1ae8'...	Black Box Warning	<NA>	None	None	EFO:0011053	26.09
3	[CHEMBL3301581]	carcinogenicity	United States	None	4	[{'id': '712143d9-e21e-4013-bb3b-3426a21060a8'...	Black Box Warning	<NA>	None	None	EFO:0011046	26.09
4	[CHEMBL1252, CHEMBL2108570, CHEMBL1742992, CHE...	NaN	United States	None	5	[]	Black Box Warning	<NA>	None	None	NaN	26.09

library(bedrockbio)

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

head(df)

Sample output (5 rows, showing 8 of 12 columns)
   toxicityClass          | country       | description | id | warningType       | year | efoTerm | efoId
   ---------------------- | ------------- | ----------- | -- | ----------------- | ---- | ------- | -----
0  hepatotoxicity         | United States | —           | 1  | Black Box Warning | —    | —       | —
1  metabolic toxicity     | United States | —           | 2  | Black Box Warning | —    | —       | —
2  immune system toxicity | United States | —           | 3  | Black Box Warning | —    | —       | —
3  carcinogenicity        | United States | —           | 4  | Black Box Warning | —    | —       | —
4  —                      | United States | —           | 5  | Black Box Warning | —    | —       | —

Description

Blackbox and withdrawn information for drug molecules included in ChEMBL database [Drug]

Partitions

Not partitioned.

Schema

Column	Type	Description
`chemblIds`	`TEXT[]`	List of Open Targets molecule identifiers
`toxicityClass`	`TEXT`	Classification of toxicity type associated with the drug
`country`	`TEXT`	Country where the warning was issued
`description`	`TEXT`	Description of the drug adverse effect
`id`	`BIGINT`	Internal identifier for the drug warning record
`references`	`STRUCT(id TEXT, source TEXT, url TEXT)[]`	List of sources supporting the warning information
`warningType`	`TEXT`	Classification of action taken (drug is withdrawn or has a black box warning)
`year`	`INT`	Year when the warning was issued
`efoTerm`	`TEXT`	List of disease labels
`efoId`	`TEXT`	List of disease identifiers
`efoIdForWarningClass`	`TEXT`	Disease identifier categorising the type of warning
`version`	`TEXT`	Open Targets Platform release version (major.minor), e.g. 26.09. Added during ingest.