SQL Queries

A collection of query strings for ChEMBL.

Functions

get_assay_sql(assay_chembl_id)	Get the SQL for the given assay.
get_document_molecule_sql(document_chembl_id)	Get all molecules mentioned in a document.
get_target_sql(target_id[, target_type, ...])	Get the SQL for all chemicals inhibiting the target.

Variables

ACTIVITIES_QUERY	A SQL query for all activities
CHEBI_UNMAPPED_SQL	A SQL query for ChEMBL molecules that are unmapped to ChEBI
COUNT_ACTIVITIES_SQL	Count the number of activity records
COUNT_ASSAYS_SQL	Count the number of assay records
COUNT_COMPOUNDS_SQL	Count the number of compound records
COUNT_NAMED_COMPOUNDS_SQL	Return the count of molecules
COUNT_QUERY_SQL	Old name
DRUG_INDICATIONS_SQL	A SQL query for all drug-indication relationships
ID_NAME_QUERY	This query yields tuples of ChEMBL identifiers and their preferred names, omitting pairs where there is no name or if there's no structure