Chemistry Cartridge: TAUTOMERS
Daylight 4.61, dayblob 46107, Oracle Server 8.13
The Chemistry Cartridge adds the TAUTOMERS operator to SQL.
When applied to a SMILES-containing column in a table, all rows containing
possible tautomers of a given SMILES will be selected.
For this purpose, structures are considered tautomers if they have same
molecular graph, molecular formula (including hydrogen count) and net charge.
I.e., they can be changed into one another by moving only electrons and
hydrogen atoms.
This is a fast search which is done by indexed (hashed) retrieval.
Other examples are also available.
Oracle table: COMPOUND_118616 (nci95 structures)
Look for the following structure:
NCCc1ccc(O)c(O)c1
SQLPLUS session follows
(show .sql file):
TO_CHAR(SYSDATE,'MM:
--------------------
10:21:1998, 04:44:50
Elapsed: 00:00:00.00
old 1: select compound_id, smiles from COMPOUND_118616 where Tautomers(smiles,'&1')=1
new 1: select compound_id, smiles from COMPOUND_118616 where Tautomers(smiles,'NCCc1ccc(O)c(O)c1')=1
ID SMILES
------- ------------------
8779 NCCc1ccc(O)c(O)c1
Elapsed: 00:00:00.71
TO_CHAR(SYSDATE,'MM:
--------------------
10:21:1998, 04:44:51
Daylight Chemical Information Systems, Inc.
info@daylight.com