getgetapplication/xml20TrueNo default provided.A single related resource. Can be either a URI or set of nested resource data.Trueto_oneNo default provided.Primary key. Type of action of the drug e.g., agonist, antagonistTruestringTrueaction typeNo default provided.Description of how the action type is usedstringdescriptionNo default provided.Higher-level grouping of action types e.g., positive vs negative actionTruestringparent typeexactiexactisnullinexactiexactisnullinexactiexactisnullinaction_typedescriptionparent_typerelatedaction typeNo default provided.Describes non-numeric activities i.e. 'Slighty active', 'Not determined'Truestringactivity commentTrueUnique ID for the activity rowTrueintegerTrueactivity idTrueNo default provided.Many related resources. Can be either a list of URIs or list of individually nested resource data.Trueto_manyNo default provided.A Comment.TruestringcommentsNo default provided.Symbol constraining the value (e.g. >, <, =)TruestringrelationA flag to indicate, if set to 1, that this type is a dependent variable/result (e.g., slope) rather than an independent variable/parameter (0, the default).integerresult flagNo default provided.Standardised form of the RELATIONTruestringstandard relationNo default provided.Standardised form of the TEXT_VALUETruestringstandard text valueNo default provided.Standardised form of the TYPETruestringstandard typeNo default provided.Standardised form of the UNITSTruestringstandard unitsNo default provided.Standardised form of the VALUETruedecimalstandard valueNo default provided.Non-numerical value of the parameter or propertyTruestringtext valueTrueThe parameter or property typestringtypeNo default provided.Units of measurementTruestringunitsNo default provided.Numberical value for the parameter or propertyTruedecimalvalueexactiexactisnullinexactiexactisnullinexactiexactisnullinexactiexactisnullinexactiexactisnullinexactiexactisnullinexactiexactisnullinexactrangegtgteltlteinisnullexactiexactisnullinexactiexactisnullinexactiexactisnullinexactrangegtgteltlteinisnulltyperelationvalueunitstext_valuestandard_typestandard_relationstandard_valuestandard_unitsstandard_text_valuecommentsresult_flagrelatedactivity propertiesTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringassay chembl idTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringassay descriptionTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringassay typeTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringassay variant accessionTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringassay variant mutationTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringbao endpointTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringbao formatTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringbao labelTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringcanonical smilesTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringdata validity commentTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringdata validity descriptionTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringdocument chembl idTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringdocument journalTrueNo default provided.Integer data. Ex: 2673Trueintegerdocument yearTrueNo default provided.A single related resource. Can be either a URI or set of nested resource data.Trueto_oneNo default provided.Binding Efficiency Index = p(XC50) *1000/MW_freebaseTruedecimalbeiNo default provided.Ligand Efficiency = deltaG/heavy_atoms [from the Hopkins DDT paper 2004]TruedecimalleNo default provided.Lipophilic Ligand Efficiency = -logKi-ALogP. [from Leeson NRDD 2007]TruedecimallleNo default provided.Surface Efficiency Index = p(XC50)*100/PSATruedecimalseiexactrangegtgteltlteinisnullexactrangegtgteltlteinisnullexactrangegtgteltlteinisnullexactrangegtgteltlteinisnullbeiseilellerelatedligand efficiencyNo default provided.Annotates the designed compound modality (e.g. Targeted Protein Degradation). Contrasting with the ACTION_TYPE field, a compound captured in the MODALITY field may be active or inactive at a target.TruestringmodalityTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringmolecule chembl idTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringmolecule pref nameTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringparent molecule chembl idNo default provided.Negative log of selected concentration-response activity values (IC50/EC50/XC50/AC50/Ki/Kd/Potency)Truedecimalpchembl valueNo default provided.When set to 1, indicates that the value is likely to be a repeat citation of a value reported in a previous ChEMBL paper, rather than a new, independent measurement. Note: value of zero does not guarantee that the measurement is novel/independent thoughTrueintegerpotential duplicateNo default provided.ID for the corresponding unit in QUDT Ontology (based on standard_units)Truestringqudt unitsTrueNo default provided.Integer data. Ex: 2673Trueintegerrecord idNo default provided.Symbol constraining the activity value (e.g. >, <, =), as it appears in the original datasetTruestringrelationTrueNo default provided.Integer data. Ex: 2673Trueintegersrc idNo default provided.Shows whether the standardised columns have been curated/set (1) or just default to the published data (0).Trueintegerstandard flagNo default provided.Symbol constraining the activity value (e.g. >, <, =)Truestringstandard relationNo default provided.Standardized version of non-numeric measurementTruestringstandard text valueNo default provided.Standardised version of the published_activity_type (e.g. IC50 rather than Ic-50/Ic50/ic50/ic-50)Truestringstandard typeNo default provided.Selected 'Standard' units for data type: e.g. concentrations are in nM.Truestringstandard unitsNo default provided.Where the activity is a range, this represents the standardised version of the highest value of the range (with the lower value represented by STANDARD_VALUE)Truedecimalstandard upper valueNo default provided.Same as PUBLISHED_VALUE but transformed to common units: e.g. mM concentrations converted to nM.Truedecimalstandard valueTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringtarget chembl idTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringtarget organismTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringtarget pref nameTrueNo default provided.Unicode string data. Ex: "Hello World"Truestringtarget tax idNo default provided.Non-numeric value for measurement as in original datasetTruestringtext valueNo default provided.The Test Occassion IdentifierTrueintegertoidNo default provided.Type of end-point measurement: e.g. IC50, LD50, %inhibition etc, as it appears in the original datasetstringtypeNo default provided.Units of measurement as they appear in the original datasetTruestringunitsNo default provided.ID for the corresponding unit in Unit Ontology (based on standard_units)Truestringuo unitsNo default provided.Where the activity is a range, this represents the highest value of the range (numerically), while the PUBLISHED_VALUE column represents the lower valueTruedecimalupper valueNo default provided.Datapoint value as it appears in the original dataset.Truedecimalvalue2exactiexactisnullinexactrangegtgteltlteinisnull21exactiexactisnullinexactiexactisnullinexactiexactisnullinexactiexactisnullin1exactisnull11exactiexactisnullinexactrangegtgteltlteinisnull2exactiexactisnullin1exactiexactisnullin1exactrangegtgteltlteinisnullexactisnullexactiexactisnullinexactrangegtgteltlteinisnullexactiexactisnullinexactisnullexactiexactisnullinexactiexactisnullinexactiexactisnullinexactiexactisnullinexactrangegtgteltlteinisnullexactrangegtgteltlteinisnullexactiexactisnullinexactiexactisnullinexactiexactisnullinexactrangegtgteltlteinisnullexactiexactisnullinexactiexactisnullinexactiexactisnullinexactiexactisnullinexactrangegtgteltlteinisnullexactrangegtgteltlteinisnullactivity_propertiesaction_typeactivity_idassay_chembl_idassay_typebao_endpointtarget_chembl_iddocument_chembl_iddocument_journaldocument_yearmolecule_chembl_idmolecule_pref_namemodalityparent_molecule_chembl_idpchembl_valuepotential_duplicatequdt_unitsrecord_idrelationstandard_flagstandard_relationstandard_text_valuestandard_typestandard_unitsstandard_upper_valuestandard_valuetarget_pref_nametarget_organismtarget_tax_idtext_valuetypeunitsuo_unitsupper_valuevalueligand_efficiencyassay_variant_accessionassay_variant_mutation