open_targets.evidence_crispr
import bedrock_bio as bb
rel = bb.load_table('open_targets.evidence_crispr')
df = rel.limit(5).pl() # Polars
df = rel.limit(5).df() # Pandas
df.head()| id | targetFromSourceId | diseaseFromSourceMappedId | targetFromSource | diseaseFromSource | resourceScore | literature | datasourceId | datatypeId | diseaseCellLines | qualityControls | diseaseId | targetId | publicationDate | evidenceDate | score | version | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 57240fdbe4c74449abe1b5ff3cf56974cf3fd4fb | ENSG00000092531 | EFO_0000182 | SNAP23 | hepatocellular carcinoma | 44.799999 | [38215750] | crispr | affected_pathway | [{'id': 'SIDM01439', 'name': 'SNU-761', 'tissu... | [] | MONDO_0007256 | ENSG00000092531 | 2024-01-11 | 2024-01-11 | 0.448 | 26.09 |
| 1 | c3788688dcf92fbadaf7e592bbc5618a168a16c8 | ENSG00000103356 | EFO_0000182 | EARS2 | hepatocellular carcinoma | 37.599998 | [38215750] | crispr | affected_pathway | [{'id': 'SIDM01439', 'name': 'SNU-761', 'tissu... | [] | MONDO_0007256 | ENSG00000103356 | 2024-01-11 | 2024-01-11 | 0.415 | 26.09 |
| 2 | f1cb6c9c24db1564da52354918896bb79851d1b0 | ENSG00000105976 | MONDO_0018177 | MET | glioblastoma | 47.599998 | [38215750] | crispr | affected_pathway | [{'id': 'SIDM01421', 'name': 'U-343-MGa', 'tis... | [] | MONDO_0018177 | ENSG00000105976 | 2024-01-11 | 2024-01-11 | 0.476 | 26.09 |
| 3 | 9fc0709f6481d544857331e71013197d457ea4cb | ENSG00000122025 | EFO_0000222 | FLT3 | acute myeloid leukemia | 65.199997 | [38215750] | crispr | affected_pathway | [{'id': 'SIDM00437', 'name': 'MOLM-13', 'tissu... | [] | MONDO_0018874 | ENSG00000122025 | 2024-01-11 | 2024-01-11 | 0.652 | 26.09 |
| 4 | 43498fd37c2294667514567a6a59aae8c3c532b8 | ENSG00000038358 | MONDO_0044925 | EDC4 | oral cavity carcinoma | 42.900002 | [38215750] | crispr | affected_pathway | [{'id': 'SIDM00473', 'name': 'PE-CA-PJ15', 'ti... | [] | MONDO_0044925 | ENSG00000038358 | 2024-01-11 | 2024-01-11 | 0.429 | 26.09 |
library(bedrockbio)
lf <- load_table("open_targets.evidence_crispr")
df <- head(lf, 5) |> collect()
head(df)Sample output (5 rows, showing 8 of 17 columns) id | targetFromSourceId | diseaseFromSourceMappedId | targetFromSource | diseaseFromSource | resourceScore | datasourceId | datatypeId ------------------------ | ------------------ | ------------------------- | ---------------- | ------------------------ | ------------------ | ------------ | ---------------- 0 57240fdbe4c74449abe1b5f… | ENSG00000092531 | EFO_0000182 | SNAP23 | hepatocellular carcinoma | 44.79999923706055 | crispr | affected_pathway 1 c3788688dcf92fbadaf7e59… | ENSG00000103356 | EFO_0000182 | EARS2 | hepatocellular carcinoma | 37.599998474121094 | crispr | affected_pathway 2 f1cb6c9c24db1564da52354… | ENSG00000105976 | MONDO_0018177 | MET | glioblastoma | 47.599998474121094 | crispr | affected_pathway 3 9fc0709f6481d544857331e… | ENSG00000122025 | EFO_0000222 | FLT3 | acute myeloid leukemia | 65.19999694824219 | crispr | affected_pathway 4 43498fd37c2294667514567… | ENSG00000038358 | MONDO_0044925 | EDC4 | oral cavity carcinoma | 42.900001525878906 | crispr | affected_pathway
Description
Section titled “Description”Disease-target evidence from unified analysis of whole-genome CRISPR/Cas9 screens from ProjectScore project [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 |
targetFromSource |
TEXT |
Target name/synonym or non HGNC symbol in resource of origin |
diseaseFromSource |
TEXT |
Disease label from the original source |
resourceScore |
DOUBLE |
Score provided by datasource indicating strength of target-disease association |
literature |
TEXT[] |
List of PubMed or preprint reference identifiers |
datasourceId |
TEXT |
Identifer of the evidence source |
datatypeId |
TEXT |
Type of the evidence |
diseaseCellLines |
STRUCT(id TEXT, name TEXT, tissue TEXT, tissueId TEXT)[] |
Cancer cell lines used to generate evidence |
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. |