ChEMBL · Schema
ChEMBL Activity
A bioactivity measurement from a ChEMBL assay, linking a compound to a biological target with a quantitative or qualitative measurement.
Drug DiscoveryBioactivityMoleculesCheminformaticsLife SciencesBioinformaticsPharmacologyEMBL-EBI
Properties
| Name | Type | Description |
|---|---|---|
| activity_id | integer | Unique numeric ID for the activity record |
| assay_chembl_id | string | ChEMBL ID of the assay |
| assay_description | stringnull | Description of the assay as extracted from the source document |
| assay_type | stringnull | Assay type code: B=Binding, F=Functional, A=ADME, T=Toxicity, P=Physicochemical, U=Unclassified |
| bao_endpoint | stringnull | BioAssay Ontology (BAO) endpoint term ID |
| bao_format | stringnull | BioAssay Ontology format term ID |
| bao_label | stringnull | Human-readable BAO endpoint label |
| canonical_smiles | stringnull | Canonical SMILES representation of the tested compound |
| data_validity_comment | stringnull | Comment on data validity or quality issues |
| document_chembl_id | stringnull | ChEMBL ID of the source document |
| document_journal | stringnull | Journal of the source publication |
| document_year | integernull | Year of the source publication |
| molecule_chembl_id | string | ChEMBL ID of the tested compound |
| pchembl_value | numbernull | Negative log10 of the molar activity value (comparable across activity types) |
| relation | stringnull | Relationship qualifier for the original reported activity value |
| standard_flag | booleannull | Whether this activity value was standardized |
| standard_relation | stringnull | Standardized relationship qualifier |
| standard_text_value | stringnull | Standardized text value for non-numeric activities |
| standard_type | stringnull | Standardized activity type (e.g., IC50, Ki, EC50, Kd, Potency) |
| standard_units | stringnull | Standardized units of the activity measurement (e.g., nM, uM) |
| standard_value | numbernull | Standardized numeric activity value |
| target_chembl_id | stringnull | ChEMBL ID of the biological target |
| target_organism | stringnull | Organism of the biological target |
| target_pref_name | stringnull | Preferred name of the biological target |
| target_tax_id | stringnull | NCBI taxonomy ID of the target organism |
| type | stringnull | Original activity type as reported in the source document |
| units | stringnull | Original units as reported in the source document |
| value | stringnull | Original numeric or text value as reported |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "https://www.ebi.ac.uk/chembl/schema/activity",
"title": "ChEMBL Activity",
"description": "A bioactivity measurement from a ChEMBL assay, linking a compound to a biological target with a quantitative or qualitative measurement.",
"type": "object",
"properties": {
"activity_id": {
"type": "integer",
"description": "Unique numeric ID for the activity record"
},
"assay_chembl_id": {
"type": "string",
"pattern": "^CHEMBL[0-9]+$",
"description": "ChEMBL ID of the assay"
},
"assay_description": {
"type": ["string", "null"],
"description": "Description of the assay as extracted from the source document"
},
"assay_type": {
"type": ["string", "null"],
"enum": ["B", "F", "A", "T", "P", "U", null],
"description": "Assay type code: B=Binding, F=Functional, A=ADME, T=Toxicity, P=Physicochemical, U=Unclassified"
},
"bao_endpoint": {
"type": ["string", "null"],
"description": "BioAssay Ontology (BAO) endpoint term ID"
},
"bao_format": {
"type": ["string", "null"],
"description": "BioAssay Ontology format term ID"
},
"bao_label": {
"type": ["string", "null"],
"description": "Human-readable BAO endpoint label"
},
"canonical_smiles": {
"type": ["string", "null"],
"description": "Canonical SMILES representation of the tested compound"
},
"data_validity_comment": {
"type": ["string", "null"],
"description": "Comment on data validity or quality issues"
},
"document_chembl_id": {
"type": ["string", "null"],
"pattern": "^CHEMBL[0-9]+$",
"description": "ChEMBL ID of the source document"
},
"document_journal": {
"type": ["string", "null"],
"description": "Journal of the source publication"
},
"document_year": {
"type": ["integer", "null"],
"description": "Year of the source publication"
},
"molecule_chembl_id": {
"type": "string",
"pattern": "^CHEMBL[0-9]+$",
"description": "ChEMBL ID of the tested compound"
},
"pchembl_value": {
"type": ["number", "null"],
"minimum": 0,
"maximum": 20,
"description": "Negative log10 of the molar activity value (comparable across activity types)"
},
"relation": {
"type": ["string", "null"],
"enum": ["=", ">", "<", ">=", "<=", "~", null],
"description": "Relationship qualifier for the original reported activity value"
},
"standard_flag": {
"type": ["boolean", "null"],
"description": "Whether this activity value was standardized"
},
"standard_relation": {
"type": ["string", "null"],
"enum": ["=", ">", "<", ">=", "<=", "~", null],
"description": "Standardized relationship qualifier"
},
"standard_text_value": {
"type": ["string", "null"],
"description": "Standardized text value for non-numeric activities"
},
"standard_type": {
"type": ["string", "null"],
"description": "Standardized activity type (e.g., IC50, Ki, EC50, Kd, Potency)"
},
"standard_units": {
"type": ["string", "null"],
"description": "Standardized units of the activity measurement (e.g., nM, uM)"
},
"standard_value": {
"type": ["number", "null"],
"description": "Standardized numeric activity value"
},
"target_chembl_id": {
"type": ["string", "null"],
"pattern": "^CHEMBL[0-9]+$",
"description": "ChEMBL ID of the biological target"
},
"target_organism": {
"type": ["string", "null"],
"description": "Organism of the biological target"
},
"target_pref_name": {
"type": ["string", "null"],
"description": "Preferred name of the biological target"
},
"target_tax_id": {
"type": ["string", "null"],
"description": "NCBI taxonomy ID of the target organism"
},
"type": {
"type": ["string", "null"],
"description": "Original activity type as reported in the source document"
},
"units": {
"type": ["string", "null"],
"description": "Original units as reported in the source document"
},
"value": {
"type": ["string", "null"],
"description": "Original numeric or text value as reported"
}
},
"required": ["activity_id", "assay_chembl_id", "molecule_chembl_id"],
"examples": [
{
"activity_id": 31863,
"assay_chembl_id": "CHEMBL1909072",
"assay_description": "Inhibition of human COX-2",
"assay_type": "B",
"canonical_smiles": "CC(=O)Oc1ccccc1C(=O)O",
"document_chembl_id": "CHEMBL1124375",
"document_journal": "J. Med. Chem.",
"document_year": 1999,
"molecule_chembl_id": "CHEMBL25",
"pchembl_value": 4.2,
"relation": "=",
"standard_relation": "=",
"standard_type": "IC50",
"standard_units": "nM",
"standard_value": 60000,
"target_chembl_id": "CHEMBL301",
"target_organism": "Homo sapiens",
"target_pref_name": "Cyclooxygenase-2",
"type": "IC50",
"units": "uM",
"value": "60"
}
]
}