open_targets.chemical_probe
import bedrock_bio as bb
rel = bb.load_table('open_targets.chemical_probe')
df = rel.limit(5).pl() # Polars
df = rel.limit(5).df() # Pandas
df.head()| targetFromSourceId | drugFromSource | drugFromSourceId | drugId | mechanismOfAction | origin | control | isHighQuality | probesDrugsScore | scoreInCells | scoreInOrganisms | urls | targetId | version | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | B2RXH2 | ML001 | PD016117 | CHEMBL1612647 | <NA> | [experimental] | NaN | False | 20.0 | NaN | NaN | [{'niceName': 'MLP Probes', 'url': 'http://www... | ENSG00000235268 | 26.09 |
| 1 | B2RXH2 | ML157 | PD015979 | CHEMBL1459090 | <NA> | [experimental] | NaN | False | 40.0 | NaN | NaN | [{'niceName': 'MLP Probes', 'url': 'http://www... | ENSG00000235268 | 26.09 |
| 2 | B2RXH2 | ML324 | PD010259 | CHEMBL1398529 | [inhibitor] | [experimental] | NaN | False | 20.0 | NaN | NaN | [{'niceName': 'MLP Probes', 'url': 'http://www... | ENSG00000235268 | 26.09 |
| 3 | O00141 | PROTAC SGK3 degrader-1 | PD142034 | CHEMBL4795354 | <NA> | [experimental] | cisSGK3-PROTAC1 | True | 33.2 | NaN | NaN | [{'niceName': 'Chemical Probes.org', 'url': 'h... | ENSG00000118515 | 26.09 |
| 4 | O00141 | SGK1-IN-1 | PD053941 | CHEMBL3092468 | [inhibitor] | [experimental, calculated] | NaN | True | 90.0 | 50.0 | 0.0 | [{'niceName': 'Chemical Probes.org', 'url': 'h... | ENSG00000118515 | 26.09 |
library(bedrockbio)
lf <- load_table("open_targets.chemical_probe")
df <- head(lf, 5) |> collect()
head(df)Sample output (5 rows, showing 8 of 14 columns) targetFromSourceId | drugFromSource | drugFromSourceId | drugId | control | isHighQuality | probesDrugsScore | scoreInCells ------------------ | ---------------------- | ---------------- | ------------- | --------------- | ------------- | ---------------- | ------------ 0 B2RXH2 | ML001 | PD016117 | CHEMBL1612647 | — | false | 20 | NaN 1 B2RXH2 | ML157 | PD015979 | CHEMBL1459090 | — | false | 40 | NaN 2 B2RXH2 | ML324 | PD010259 | CHEMBL1398529 | — | false | 20 | NaN 3 O00141 | PROTAC SGK3 degrader-1 | PD142034 | CHEMBL4795354 | cisSGK3-PROTAC1 | true | 33.2 | NaN 4 O00141 | SGK1-IN-1 | PD053941 | CHEMBL3092468 | — | true | 90 | 50
Description
Section titled “Description”Chemical probes and their molecular characteristics, resolved to Ensembl target identifiers [Target]
Partitions
Section titled “Partitions”Not partitioned.
Schema
Section titled “Schema”| Column | Type | Description |
|---|---|---|
targetFromSourceId |
TEXT |
Gene symbol or protein accession identifying the target as reported by the probe source, prior to ENSG resolution |
drugFromSource |
TEXT |
Compound name of the chemical probe |
drugFromSourceId |
TEXT |
Probe identifier from the source, used to cross-reference drug information |
drugId |
TEXT |
Open Targets molecule identifier of the drug associated with the chemical probe |
mechanismOfAction |
TEXT[] |
Mechanism of action of the chemical probe |
origin |
TEXT[] |
Origin of the chemical probe (e.g. experimental, calculated) |
control |
TEXT |
Whether the chemical probe serves as a control |
isHighQuality |
BOOLEAN |
Indicates if the chemical probe is high quality |
probesDrugsScore |
DOUBLE |
Score for chemical probes related to druggability |
scoreInCells |
DOUBLE |
Score indicating chemical probe activity in cells |
scoreInOrganisms |
DOUBLE |
Score indicating chemical probe activity in organisms |
urls |
STRUCT(niceName TEXT, url TEXT)[] |
URLs linking to more information about the chemical probe |
targetId |
TEXT |
Ensembl gene identifier of the target, resolved from targetFromSourceId via output/target [bioregistry:ensembl] |
version |
TEXT |
Open Targets Platform release version (major.minor), e.g. 26.09. Added during ingest. |