open_targets.evidence_crispr_screen
import bedrock_bio as bb
rel = bb.load_table('open_targets.evidence_crispr_screen')
df = rel.limit(5).pl() # Polars
df = rel.limit(5).df() # Pandas
df.head()| id | targetFromSourceId | diseaseFromSourceMappedId | studyId | datatypeId | datasourceId | projectId | crisprScreenLibrary | studyOverview | cellType | ... | resourceScore | statisticalTestTail | log2FoldChangeValue | qualityControls | diseaseId | targetId | publicationDate | evidenceDate | score | version | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 11641a5c309e45c8bf14286035a07fb770b10630 | ABHD11 | MONDO_0005559 | Glutamatergic Neuron-Liperfluo-CRISPRi | affected_pathway | crispr_screen | crispr_brain | Genome-wide CRISPRi-v2 | Description | Glutamatergic Neuron | ... | 0.004911 | upper tail | 4.532442 | [] | MONDO_0005559 | ENSG00000106077 | 2021-05-24 | 2021-05-24 | 1.000000 | 26.09 |
| 1 | 121655cdc506b8a1605188560c7008d0126919f7 | MRPS17 | MONDO_0005559 | Glutamatergic Neuron-Survival-CRISPRi | affected_pathway | crispr_screen | crispr_brain | Genome-wide CRISPRi-v2 | Description | Glutamatergic Neuron | ... | 0.045924 | lower tail | -4.371229 | [] | MONDO_0005559 | ENSG00000239789 | 2021-05-24 | 2021-05-24 | 0.518467 | 26.09 |
| 2 | 1d048d149be526539168607fe80159a91acd1b15 | PKN1 | MONDO_0002561 | iAstrocyte-LAMP1-Veh-CRISPRi | affected_pathway | crispr_screen | crispr_brain | hCRISPRi_v2 H1 and H4 | Description | Astrocyte | ... | 0.012556 | upper tail | 2.322041 | [] | MONDO_0002561 | ENSG00000123143 | 2021-09-12 | 2021-09-12 | 0.800053 | 26.09 |
| 3 | 1f18729594273a91db414845ab2335ca2d7b9b04 | WDR20 | MONDO_0005559 | Glutamatergic Neuron-PSAP KO-Survival-CRISPRa | affected_pathway | crispr_screen | crispr_brain | Genome-wide CRISPRa-v2 | Description | Glutamatergic Neuron | ... | 0.003033 | upper tail | 3.819621 | [] | MONDO_0005559 | ENSG00000140153 | 2021-05-24 | 2021-05-24 | 1.000000 | 26.09 |
| 4 | 2398686f550965e8d5071a4b3abca2fe8580b653 | KCNH8 | MONDO_0005559 | Glutamatergic Neuron-No Antioxidants-Survival-... | affected_pathway | crispr_screen | crispr_brain | Genome-wide CRISPRi-v2 | Description | Glutamatergic Neuron | ... | 0.007392 | lower tail | -2.352059 | [] | MONDO_0005559 | ENSG00000183960 | 2021-05-24 | 2021-05-24 | 0.915109 | 26.09 |
library(bedrockbio)
lf <- load_table("open_targets.evidence_crispr_screen")
df <- head(lf, 5) |> collect()
head(df)Sample output (5 rows, showing 8 of 24 columns) id | targetFromSourceId | diseaseFromSourceMappedId | studyId | datatypeId | datasourceId | projectId | crisprScreenLibrary ------------------------ | ------------------ | ------------------------- | ------------------------ | ---------------- | ------------- | ------------ | ---------------------- 0 11641a5c309e45c8bf14286… | ABHD11 | MONDO_0005559 | Glutamatergic Neuron-Li… | affected_pathway | crispr_screen | crispr_brain | Genome-wide CRISPRi-v2 1 121655cdc506b8a16051885… | MRPS17 | MONDO_0005559 | Glutamatergic Neuron-Su… | affected_pathway | crispr_screen | crispr_brain | Genome-wide CRISPRi-v2 2 1d048d149be526539168607… | PKN1 | MONDO_0002561 | iAstrocyte-LAMP1-Veh-CR… | affected_pathway | crispr_screen | crispr_brain | hCRISPRi_v2 H1 and H4 3 1f18729594273a91db41484… | WDR20 | MONDO_0005559 | Glutamatergic Neuron-PS… | affected_pathway | crispr_screen | crispr_brain | Genome-wide CRISPRa-v2 4 2398686f550965e8d5071a4… | KCNH8 | MONDO_0005559 | Glutamatergic Neuron-No… | affected_pathway | crispr_screen | crispr_brain | Genome-wide CRISPRi-v2
Description
Section titled “Description”Disease-target evidence derived from systematic gene perturation assays of CRISPR knock-out screens [Target-Disease]
Partitions
Section titled “Partitions”Not partitioned.
Schema
Section titled “Schema”| Column | Type | Description |
|---|---|---|
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 |
studyId |
TEXT |
Identifier of the study generating the data |
datatypeId |
TEXT |
Type of the evidence |
datasourceId |
TEXT |
Identifer of the evidence source |
projectId |
TEXT |
The identifer of the project that generated the data |
crisprScreenLibrary |
TEXT |
Applied screening library in the CRISPR/Cas9 project |
studyOverview |
TEXT |
Description of the study |
cellType |
TEXT |
The studied cell type. Preferably the cell line ontology label |
geneticBackground |
TEXT |
Additional genetic background of the applied cell line in the CRISPR screen |
literature |
TEXT[] |
List of PubMed or preprint reference identifiers |
diseaseFromSource |
TEXT |
Disease label from the original source |
contrast |
TEXT |
Experiment contrast |
resourceScore |
DOUBLE |
Score provided by datasource indicating strength of target-disease association |
statisticalTestTail |
TEXT |
End of the distribution the target was picked from |
log2FoldChangeValue |
DOUBLE |
Log 2 fold expression change in contrast experiment |
qualityControls |
TEXT[] |
Evidence quality flags |
diseaseId |
TEXT |
Open Targets disease identifier |
targetId |
TEXT |
Open Targets target identifier |
publicationDate |
TEXT |
Date of the earliest publication supporting the evidence |
evidenceDate |
TEXT |
Earliest data for the evidence |
score |
DOUBLE |
Score of the evidence reflecting the strength of the disease/target relationship |
version |
TEXT |
Open Targets Platform release version (major.minor), e.g. 26.09. Added during ingest. |