chembl_downloader
Getting Started
Installation
SQL Usage
SDF Usage
Fingerprints
Reference
SQL Queries
Functions
Variables
ACTIVITIES_QUERY
CHEBI_UNMAPPED_SQL
CHEBI_UNMAPPED_SQL
COUNT_ACTIVITIES_SQL
COUNT_ASSAYS_SQL
COUNT_COMPOUNDS_SQL
COUNT_NAMED_COMPOUNDS_SQL
COUNT_QUERY_SQL
DRUG_INDICATIONS_SQL
ID_NAME_QUERY
Extras
Configuration
Command Line Interface
chembl_downloader
SQL Queries
CHEBI_UNMAPPED_SQL
View page source
CHEBI_UNMAPPED_SQL
CHEBI_UNMAPPED_SQL
=
'SELECT\n
chembl_id,\n
pref_name\nFROM
MOLECULE_DICTIONARY\nWHERE\n
chebi_par_id
IS
NULL\n
AND
pref_name
IS
NOT
NULL\n'
A SQL query for ChEMBL molecules that are unmapped to ChEBI