evidence__sourceId=chembl

evidence__sourceId=chembl PARQUET_TABLE OK

Source path: evidence__sourceId=chembl
Format: parquet
Files: 200
Rows: 573124
Compression: SNAPPY
Row groups: 200
Detected by: parquet_part_folder
Processor: 1.0.0

Schema (88 fields)

#	Field	Type	Nullable
0	datasourceId	string	yes
1	targetId	string	yes
2	alleleOrigins	list<element: string>	yes
3	allelicRequirements	list<element: string>	yes
4	ancestry	string	yes
5	ancestryId	string	yes
6	beta	double	yes
7	betaConfidenceIntervalLower	double	yes
8	betaConfidenceIntervalUpper	double	yes
9	biologicalModelAllelicComposition	string	yes
10	biologicalModelGeneticBackground	string	yes
11	biologicalModelId	string	yes
12	biomarkerName	string	yes
13	biomarkers	struct<geneExpression: list<element: struct<id: string, name: string>>, geneticVariation: list<element: struct<functionalConsequenceId: string, id: string, name: string>>>	yes
14	biosamplesFromSource	list<element: string>	yes
15	cellType	string	yes
16	clinicalPhase	double	yes
17	clinicalSignificances	list<element: string>	yes
18	clinicalStatus	string	yes
19	cohortDescription	string	yes
20	cohortId	string	yes
21	cohortPhenotypes	list<element: string>	yes
22	cohortShortName	string	yes
23	confidence	string	yes
24	contrast	string	yes
25	crisprScreenLibrary	string	yes
26	datatypeId	string	yes
27	diseaseCellLines	list<element: struct<id: string, name: string, tissue: string, tissueId: string>>	yes
28	diseaseFromSource	string	yes
29	diseaseFromSourceId	string	yes
30	diseaseFromSourceMappedId	string	yes
31	diseaseModelAssociatedHumanPhenotypes	list<element: struct<id: string, label: string>>	yes
32	diseaseModelAssociatedModelPhenotypes	list<element: struct<id: string, label: string>>	yes
33	drugFromSource	string	yes
34	drugId	string	yes
35	drugResponse	string	yes
36	geneticBackground	string	yes
37	literature	list<element: string>	yes
38	log2FoldChangePercentileRank	int64	yes
39	log2FoldChangeValue	double	yes
40	mutatedSamples	list<element: struct<functionalConsequenceId: string, numberMutatedSamples: double, numberSamplesTested: double, numberSamplesWithMutationType: int64>>	yes
41	oddsRatio	double	yes
42	oddsRatioConfidenceIntervalLower	double	yes
43	oddsRatioConfidenceIntervalUpper	double	yes
44	pValueExponent	int64	yes
45	pValueMantissa	double	yes
46	pathways	list<element: struct<id: string, name: string>>	yes
47	projectId	string	yes
48	reactionId	string	yes
49	reactionName	string	yes
50	releaseDate	string	yes
51	releaseVersion	string	yes
52	resourceScore	double	yes
53	sex	list<element: string>	yes
54	significantDriverMethods	list<element: string>	yes
55	statisticalMethod	string	yes
56	statisticalMethodOverview	string	yes
57	statisticalTestTail	string	yes
58	studyCases	int64	yes
59	studyCasesWithQualifyingVariants	int64	yes
60	studyId	string	yes
61	studyOverview	string	yes
62	studySampleSize	int64	yes
63	studyStartDate	string	yes
64	studyStopReason	string	yes
65	studyStopReasonCategories	list<element: string>	yes
66	targetFromSource	string	yes
67	targetFromSourceId	string	yes
68	targetInModel	string	yes
69	targetInModelEnsemblId	string	yes
70	targetInModelMgiId	string	yes
71	targetModulation	string	yes
72	urls	list<element: struct<niceName: string, url: string>>	yes
73	variantAminoacidDescriptions	list<element: string>	yes
74	variantFromSourceId	string	yes
75	variantFunctionalConsequenceId	string	yes
76	variantHgvsId	string	yes
77	variantId	string	yes
78	variantRsId	string	yes
79	pmcIds	list<element: string>	yes
80	publicationYear	int64	yes
81	studyLocusId	string	yes
82	textMiningSentences	list<element: struct<dEnd: int64, dStart: int64, section: string, tEnd: int64, tStart: int64, text: string>>	yes
83	diseaseId	string	yes
84	id	string	yes
85	score	double	yes
86	variantEffect	string	yes
87	directionOnTrait	string	yes

Field

Type

Nullable

Partition

datasourceId

string

yes

targetId

string

yes

alleleOrigins

list<element: string>

yes

allelicRequirements

list<element: string>

yes

ancestry

string

yes

ancestryId

string

yes

beta

double

yes

betaConfidenceIntervalLower

double

yes

betaConfidenceIntervalUpper

double

yes

biologicalModelAllelicComposition

string

yes

biologicalModelGeneticBackground

string

yes

biologicalModelId

string

yes

biomarkerName

string

yes

biomarkers

struct<geneExpression: list<element: struct<id: string, name: string>>, geneticVariation: list<element: struct<functionalConsequenceId: string, id: string, name: string>>>

yes

biosamplesFromSource

list<element: string>

yes

cellType

string

yes

clinicalPhase

double

yes

clinicalSignificances

list<element: string>

yes

clinicalStatus

string

yes

cohortDescription

string

yes

cohortId

string

yes

cohortPhenotypes

list<element: string>

yes

cohortShortName

string

yes

confidence

string

yes

contrast

string

yes

crisprScreenLibrary

string

yes

datatypeId

string

yes

diseaseCellLines

list<element: struct<id: string, name: string, tissue: string, tissueId: string>>

yes

diseaseFromSource

string

yes

diseaseFromSourceId

string

yes

diseaseFromSourceMappedId

string

yes

diseaseModelAssociatedHumanPhenotypes

list<element: struct<id: string, label: string>>

yes

diseaseModelAssociatedModelPhenotypes

list<element: struct<id: string, label: string>>

yes

drugFromSource

string

yes

drugId

string

yes

drugResponse

string

yes

geneticBackground

string

yes

literature

list<element: string>

yes

log2FoldChangePercentileRank

int64

yes

log2FoldChangeValue

double

yes

mutatedSamples

list<element: struct<functionalConsequenceId: string, numberMutatedSamples: double, numberSamplesTested: double, numberSamplesWithMutationType: int64>>

yes

oddsRatio

double

yes

oddsRatioConfidenceIntervalLower

double

yes

oddsRatioConfidenceIntervalUpper

double

yes

pValueExponent

int64

yes

pValueMantissa

double

yes

pathways

list<element: struct<id: string, name: string>>

yes

projectId

string

yes

reactionId

string

yes

reactionName

string

yes

releaseDate

string

yes

releaseVersion

string

yes

resourceScore

double

yes

sex

list<element: string>

yes

significantDriverMethods

list<element: string>

yes

statisticalMethod

string

yes

statisticalMethodOverview

string

yes

statisticalTestTail

string

yes

studyCases

int64

yes

studyCasesWithQualifyingVariants

int64

yes

studyId

string

yes

studyOverview

string

yes

studySampleSize

int64

yes

studyStartDate

string

yes

studyStopReason

string

yes

studyStopReasonCategories

list<element: string>

yes

targetFromSource

string

yes

targetFromSourceId

string

yes

targetInModel

string

yes

targetInModelEnsemblId

string

yes

targetInModelMgiId

string

yes

targetModulation

string

yes

urls

list<element: struct<niceName: string, url: string>>

yes

variantAminoacidDescriptions

list<element: string>

yes

variantFromSourceId

string

yes

variantFunctionalConsequenceId

string

yes

variantHgvsId

string

yes

variantId

string

yes

variantRsId

string

yes

pmcIds

list<element: string>

yes

publicationYear

int64

yes

studyLocusId

string

yes

textMiningSentences

list<element: struct<dEnd: int64, dStart: int64, section: string, tEnd: int64, tStart: int64, text: string>>

yes

diseaseId

string

yes

string

yes

score

double

yes

variantEffect

string

yes

directionOnTrait

string

yes

Candidate relationships

Evidence-backed candidates, not authoritative foreign keys.

Kind	Related asset	Confidence	Evidence
shared_fields	known_drug	0.40	{'shared_keys': ['diseaseid', 'drugid', 'targetid', 'urls']}
shared_fields	target	0.40	{'shared_keys': ['id', 'pathways']}
shared_fields	association_by_datasource_direct	0.40	{'shared_keys': ['datasourceid', 'datatypeid', 'diseaseid', 'score', 'targetid']}
shared_fields	association_overall_direct	0.40	{'shared_keys': ['diseaseid', 'score', 'targetid']}

Kind

Related asset

Confidence

Evidence

shared_fields

known_drug

0.40

{'shared_keys': ['diseaseid', 'drugid', 'targetid', 'urls']}

shared_fields

target

0.40

{'shared_keys': ['id', 'pathways']}

shared_fields

association_by_datasource_direct

0.40

{'shared_keys': ['datasourceid', 'datatypeid', 'diseaseid', 'score', 'targetid']}

shared_fields

association_overall_direct

0.40

{'shared_keys': ['diseaseid', 'score', 'targetid']}

Bounded preview

Your identity does not have preview permission for this dataset. Metadata discovery is still available.

Annotations

PIPELINE_EXTRACTED enrichment_candidate APPROVED

Selected for summary, tags enrichment.