wdi.cgi

Server: User: Pass:
Query:

SMILES/SMARTS:    Isomeric

   Exact structure match
   Similar structures    Tversky  A:  B:
   Substructure
   SMARTS match
NAME: Exact Substring  Case sensitive
DXRN:
CAS:
Output options:

Datatypes:

Show SQL:   Hide form:   Show duplicates:   Show # of hits only:  
Col width:   Max output lines:
DayCart debug level: 0,1,5,9
SQL:
      

SET PAGESIZE 100;
COLUMN ACTIVITY HEADING ActivityKeywds FORMAT A20;
COLUMN DXRN HEADING DXRN FORMAT A20;
COLUMN SMILES HEADING SMILES FORMAT A20;
SELECT DISTINCT ACTIVITY,WDI.DXRN,SMILES
	FROM WDI
	WHERE exact(SMILES,smi2cansmi('CNC(=C[N+](=O)[O-])NCCSCc1ccc(CN(C)C)o1',0))=1;
QUIT;


SQL*Plus: Release 8.1.5.0.0 - Production on Mon Aug 20 07:49:49 2001

(c) Copyright 1999 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.2 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production


ActivityKeywds	     DXRN		  SMILES
-------------------- -------------------- --------------------
ANTIHISTAMINES-H2; G RANITIDIN		  CNC(=C[N+](=O)[O-])N
ASTRIC-SECRETION-INH			  CCSCc1ccc(CN(C)C)o1
IBITORS; ANTIULCERS

TRIAL-PREP.; ANTIHIS DR9500269		  CNC(=C[N+](=O)[O-])N
TAMINES-H2; GASTRIC-			  CCSCc1ccc(CN(C)C)o1
SECRETION-INHIBITORS


Disconnected from Oracle8i Enterprise Edition Release 8.1.5.0.2 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
Daylight Chemical Information Systems Inc.
support@daylight.com