smarts query

User 6b1e802ce9

01-06-2012 18:51:17

The following smarts will not return results in the PP chemaxon query component, but in IJC it does return results.


[CX3;$([R0][#6]),$([H1R0]):1](=[OX1])[F,Cl,Br,I:2]


PP chemaxon query component will return hits if each atom is explicit instead of having [F,Cl,Br,I:2]
[CX3;$([R0][#6]),$([H1R0]):1](=[OX1])[ClX1:2]
[CX3;$([R0][#6]),$([H1R0]):1](=[OX1])[BrX1:2]
[CX3;$([R0][#6]),$([H1R0]):1](=[OX1])[IX1:2]
[CX3;$([R0][#6]),$([H1R0]):1](=[OX1])[FX1:2]


Let me know, what information do I need to provide,

ChemAxon 9c0afc9aaf

01-06-2012 20:18:13

Hi,


Are you using the JChemSearch component on the same JChem table as with Instant JChem ?


Pleas let us know otherwise.


Please also let us know the settings (parameters) of the component (e.g. screenshot)


Please send us the version for both software.


In Pipeline Pilot you can find it at the top part of the output of  Component -> ChemAxon -> Utilities -> Show ChemAxon environment.


In IJC usually it's in the header or in Help -> About


Best regards,


Szilard


 


 

User 6b1e802ce9

04-06-2012 14:26:43



>>Are you using the JChemSearch component on the same JChem table as with Instant JChem ?



I used the same data set, imported the data into IJC and via jchem manager


>>Please also let us know the settings (parameters) of the component (e.g. screenshot)



ChemAxon For Pipeline Pilot System Information
  JChem version : 5.4.1.0
Component collection version : 1.8.1_j54
JVM: Sun Microsystems Inc.  Java HotSpot(TM) 64-Bit Server VM  1.6.0_01
Memory:  455.0 MB maximum  8.0 MB total  6.0 MB free


OS: amd64 Linux 2.6.18-92.1.18.el5
------------------------------------------------------------------



Instant JChem Version: 5.5.1 (build: 110721)
JChem Version:
5.5.1.0
JChem Table Version: 5050100
Marvin Version:
5.5.1.0 (build date: 2011-07-14)
Java: 1.6.0_31; Java
HotSpot(TM) 64-Bit Server VM 20.6-b01-415
System: Mac OS X
version 10.6.8 running on x86_64; MacRoman; en_US (instantjchem)
NetBeans
build:
110214-aec102d89c78
Userdir:
/Users/cchung/Library/Application Support/instantjchem/ijc_5_5
Java
Web Start:
No
Plugins:



  • chemaxon.ijc.updatecenter [5.5 110721]


  • chemaxon.jchem/1 [5.5.1 110721]


  • com.codehaus.groovy [1.7.10 110721]


  • com.compositesw.jdbc/1 [5.1.0 110721]


  • com.google.common.guava [8.0 110721]


  • com.im.commons [5.5 110721]


  • com.im.commons.db [5.5 110721]


  • com.im.commons.db.test [5.5 110721]


  • com.im.commons.nbcommons [5.5 110721]


  • com.im.commons.ui [5.5 110721]


  • com.im.db.composite/1 [5.5 110721]


  • com.im.df.api [5.5.1 110721]


  • com.im.df.api.friend [5.5 110721]


  • com.im.df.core.derby/1 [5.5 110721]


  • com.im.df.core.oracle/1 [5.5 110721]


  • com.im.df.db.mysql/1 [5.5 110721]


  • com.im.df.exportimport [5.5.1 110721]


  • com.im.df.localdb/1 [5.5 110721]


  • com.im.df.server.local [5.5 110721]


  • com.im.df/1 [5.5.1 110721]


  • com.im.ijc.autoupdate/1 [5.5 110721]


  • com.im.ijc.branding/1 [5.5.1 110721]


  • com.im.ijc.cf [5.5 110721]


  • com.im.ijc.chem.overlap/1 [5.5 110721]


  • com.im.ijc.core/1 [5.5.1 110721]


  • com.im.ijc.extraloaders [5.5 110721]


  • com.im.ijc.formview/1 [5.5.1 110721]


  • com.im.ijc.gridview/1 [5.5 110721]


  • com.im.ijc.groovy [5.5.1 110721]


  • com.im.ijc.io [5.5 110721]


  • com.im.ijc.jrprinting [5.5.1 110721]


  • com.im.ijc.logviewer [5.5 110721]


  • com.im.ijc.project/1 [5.5 110721]


  • com.im.ijc.querytextpanel [5.5 110721]


  • com.im.ijc.reactor/1 [5.5.1 110721]


  • com.im.ijc.renderers/1 [5.5 110721]


  • com.im.ijc.security/1 [5.5 110721]


  • com.im.ijc.server.api [5.5.1 110721]


  • com.im.ijc.server.impl [5.5 110721]


  • com.im.ijc.serverconnect [5.5 110721]


  • com.im.ijc.sfs [5.5 110721]


  • com.im.ijc.sketchreg [5.5.1 110721]


  • com.im.ijc.sketchreg.chemdraw [5.5.1 110721]


  • com.im.ijc.standardizer/1 [5.5 110721]


  • com.im.ijc.structurefiles/1 [5.5 110721]


  • com.im.ijc.training [5.5 110721]


  • com.im.ijc.update.pack [5.5.1 110721]


  • com.im.ijc.versionprovider [5.5.1 110721]


  • com.im.ijc.welcome/1 [5.5 110721]


  • com.im.ijc.widgets/1 [5.5.1 110721]


  • com.im.ijcs.test [5.5 110721]


  • com.im.uiutil [5.5 110721]


  • com.jacob.com [1.0 110721]


  • com.l2fprod.common.swing.outlookbar [1.0 110721]


  • com.lowagie.iia [2.1.7 110721]


  • com.michaelbaranov.microba/1 [0.4.4.3 110721]


  • com.mysql.jdbc/1 [5.1.13 110721]


  • it.tidalwave.image [0.9.6.1.1 110721]


  • net.sf.cglib/1 [2.1.3 110721]


  • net.sf.jasperreports/1 [3.7.6 110721]


  • o.mozilla.rhino/1 [1.7.2 110214-aec102d89c78]


  • oracle.jdbc/1 [11.2.0.2.0 110721]


  • org.acegisecurity/1 [3.0.5 110721]


  • org.apache.commons.beanutils/1 [1.8.3 110721]


  • org.apache.commons.collections/1 [3.2.1 110721]


  • org.apache.commons.dbcp/1 [1.4 110721]


  • org.apache.commons.digester/1 [2.1 110721]


  • org.apache.commons.lang/1 [2.5 110721]


  • org.apache.commons.pool/1 [1.5.5 110721]


  • org.apache.derby/1 [10.5.1.1.1 110721]


  • org.apache.poi [3.7 110721]


  • org.apache.tools.ant/1 [1.8.2 110721]


  • org.apache.xml.resolver [1.11.1.12 12 110214-aec102d89c78]


  • org.ccil.cowan.tagsoup [1.2 110721]


  • org.dom4j/1 [1.6.1 110721]


  • org.eclipse.jdt.core.compiler [5.3.1 110721]


  • org.freehep/1 [5.2.6 110721]


  • org.jdesktop.layout/1 [1.13.1 110214-aec102d89c78]


  • org.jfree.chart [1.0.13.1 110721]


  • org.netbeans.api.annotations.common/1 [1.5.1 110214-aec102d89c78]


  • org.netbeans.api.java.classpath/1 [1.25.1 110214-aec102d89c78]


  • org.netbeans.api.progress/1 [1.20.2 110214-aec102d89c78]


  • org.netbeans.api.visual [2.23.1.1 110214-aec102d89c78]


  • org.netbeans.api.xml/1 [1.22.1 110214-aec102d89c78]


  • org.netbeans.bootstrap/1 [2.33.2 110214-aec102d89c78]


  • org.netbeans.core.browser/1 [1.6.1.1 1 110214-aec102d89c78]


  • org.netbeans.core.execution/1 [1.20.1 110214-aec102d89c78]


  • org.netbeans.core.ide/1 [1.20.1 110214-aec102d89c78]


  • org.netbeans.core.io.ui/1 [1.8.1 110214-aec102d89c78]


  • org.netbeans.core.multiview/1 [1.18.1 110214-aec102d89c78]


  • org.netbeans.core.nativeaccess/1 [1.7.1 110214-aec102d89c78]


  • org.netbeans.core.netigso [1.4.3 110214-aec102d89c78]


  • org.netbeans.core.osgi [1.1.1 110214-aec102d89c78]


  • org.netbeans.core.output2/1 [1.18.2 110214-aec102d89c78]


  • org.netbeans.core.startup/1 [1.25.3 110214-aec102d89c78]


  • org.netbeans.core.ui/1 [1.22.1 110214-aec102d89c78]


  • org.netbeans.core.windows/2 [2.21.1.1 110214-aec102d89c78]


  • org.netbeans.core/2 [3.20.2.1 110214-aec102d89c78]


  • org.netbeans.insane/1 [1.9.1.1 1 110214-aec102d89c78]


  • org.netbeans.libs.commons_codec/1 [1.5.1 110214-aec102d89c78]


  • org.netbeans.libs.commons_logging/1 [1.13.1.11 11
    110214-aec102d89c78]


  • org.netbeans.libs.felix [1.1.1 110214-aec102d89c78]


  • org.netbeans.libs.freemarker/1 [2.11.1.238 238 110214-aec102d89c78]


  • org.netbeans.libs.jna/1 [1.7.2 110214-aec102d89c78]


  • org.netbeans.libs.jsr223/1 [1.15.1 110214-aec102d89c78]


  • org.netbeans.libs.junit4 [1.9.1 110214-aec102d89c78]


  • org.netbeans.libs.jzlib/1 [1.4.1.107 107 110214-aec102d89c78]


  • org.netbeans.libs.lucene/1 [2.10.1.232 232 110214-aec102d89c78]


  • org.netbeans.libs.nbi.ant [1.2.2 110214-aec102d89c78]


  • org.netbeans.libs.nbi.engine [1.1.1 110214-aec102d89c78]


  • org.netbeans.libs.osgi [1.1.1 110214-aec102d89c78]


  • org.netbeans.libs.swingx/1 [1.6.1 110214-aec102d89c78]


  • org.netbeans.libs.xerces/1 [1.18.1.280 280 110214-aec102d89c78]


  • org.netbeans.modules.applemenu/1 [1.16.1 110214-aec102d89c78]


  • org.netbeans.modules.autoupdate.services [1.20.1 110214-aec102d89c78]


  • org.netbeans.modules.autoupdate.ui [1.16.1 110214-aec102d89c78]


  • org.netbeans.modules.csl.api/2 [2.5.1.2.1.1.4 2 110214-aec102d89c78]


  • org.netbeans.modules.db.core [1.15.2 110214-aec102d89c78]


  • org.netbeans.modules.db.dataview [1.7.1 110214-aec102d89c78]


  • org.netbeans.modules.db.metadata.model/0 [0.9.1 110214-aec102d89c78]


  • org.netbeans.modules.db.sql.editor [1.15.1.30 110214-aec102d89c78]


  • org.netbeans.modules.db.sql.visualeditor/1 [2.9.1.30
    110214-aec102d89c78]


  • org.netbeans.modules.db/1 [1.38.2.30 30 110214-aec102d89c78]


  • org.netbeans.modules.dbapi [1.13.1.30 110214-aec102d89c78]


  • org.netbeans.modules.defaults/1 [1.11.1 110214-aec102d89c78]


  • org.netbeans.modules.derby [1.18.1 110214-aec102d89c78]


  • org.netbeans.modules.diff/1 [1.28.2.42.1 42 110214-aec102d89c78]


  • org.netbeans.modules.editor.actions/1 [1.5.1.2 110214-aec102d89c78]


  • org.netbeans.modules.editor.bookmarks/1 [1.13.1 110214-aec102d89c78]


  • org.netbeans.modules.editor.bracesmatching/0 [1.13.1
    110214-aec102d89c78]


  • org.netbeans.modules.editor.codetemplates/1 [1.17.1.1 1
    110214-aec102d89c78]


  • org.netbeans.modules.editor.completion/1 [1.20.1.1 1
    110214-aec102d89c78]


  • org.netbeans.modules.editor.deprecated.pre61settings/0
    [1.8.1.1.3.10.2 1 110214-aec102d89c78]


  • org.netbeans.modules.editor.errorstripe.api/1 [2.11.1.1 1
    110214-aec102d89c78]


  • org.netbeans.modules.editor.errorstripe/2 [2.12.1.1.1 1
    110214-aec102d89c78]


  • org.netbeans.modules.editor.fold/1 [1.18.1.2 110214-aec102d89c78]


  • org.netbeans.modules.editor.guards/1 [1.8.1 110214-aec102d89c78]


  • org.netbeans.modules.editor.indent.project/0 [1.1.1
    110214-aec102d89c78]


  • org.netbeans.modules.editor.indent/2 [1.19.1.10 110214-aec102d89c78]


  • org.netbeans.modules.editor.lib/2 [2.10.2.10.2 10
    110214-aec102d89c78]


  • org.netbeans.modules.editor.lib2/1 [1.28.1.2 2 110214-aec102d89c78]


  • org.netbeans.modules.editor.macros/0 [1.9.1.1.10 1
    110214-aec102d89c78]


  • org.netbeans.modules.editor.mimelookup.impl/1 [1.9.1
    110214-aec102d89c78]


  • org.netbeans.modules.editor.mimelookup/1 [1.16.1 110214-aec102d89c78]


  • org.netbeans.modules.editor.plain.lib/1 [1.13.1 110214-aec102d89c78]


  • org.netbeans.modules.editor.plain/2 [1.14.1 110214-aec102d89c78]


  • org.netbeans.modules.editor.settings.storage/1 [1.25.1
    110214-aec102d89c78]


  • org.netbeans.modules.editor.settings/1 [1.31.1 110214-aec102d89c78]


  • org.netbeans.modules.editor.structure/1 [1.24.1.1 1
    110214-aec102d89c78]


  • org.netbeans.modules.editor.util/1 [1.36.1 110214-aec102d89c78]


  • org.netbeans.modules.editor/3 [1.50.1.3.10.2 3 110214-aec102d89c78]


  • org.netbeans.modules.extbrowser/1 [1.19.1 110214-aec102d89c78]


  • org.netbeans.modules.favorites/1 [1.20.1 110214-aec102d89c78]


  • org.netbeans.modules.javahelp/1 [2.17.1 110214-aec102d89c78]


  • org.netbeans.modules.jumpto/1 [1.17.1 110214-aec102d89c78]


  • org.netbeans.modules.keyring [1.1.2 110214-aec102d89c78]


  • org.netbeans.modules.keyring.impl [1.0.1 110214-aec102d89c78]


  • org.netbeans.modules.lexer.nbbridge/1 [1.10.1.1 110214-aec102d89c78]


  • org.netbeans.modules.lexer/2 [1.35.1.1 1 110214-aec102d89c78]


  • org.netbeans.modules.masterfs/2 [2.25.2 110214-aec102d89c78]


  • org.netbeans.modules.nbjunit/1 [1.63.1 110214-aec102d89c78]


  • org.netbeans.modules.options.api/1 [1.18.1 110214-aec102d89c78]


  • org.netbeans.modules.options.editor/1 [1.21.1 110214-aec102d89c78]


  • org.netbeans.modules.options.keymap [1.10.1 110214-aec102d89c78]


  • org.netbeans.modules.parsing.api/1 [1.33.2.4 4 110214-aec102d89c78]


  • org.netbeans.modules.print.editor [7.6.1 110214-aec102d89c78]


  • org.netbeans.modules.progress.ui [1.12.1 110214-aec102d89c78]


  • org.netbeans.modules.projectapi/1 [1.31.1 110214-aec102d89c78]


  • org.netbeans.modules.projectui [1.21.3.8 110214-aec102d89c78]


  • org.netbeans.modules.projectuiapi/1 [1.47.2.8 8 110214-aec102d89c78]


  • org.netbeans.modules.queries/1 [1.19.1 110214-aec102d89c78]


  • org.netbeans.modules.refactoring.api [1.11.1 110214-aec102d89c78]


  • org.netbeans.modules.schema2beans/1 [1.25.1 110214-aec102d89c78]


  • org.netbeans.modules.sendopts/2 [2.9.1 110214-aec102d89c78]


  • org.netbeans.modules.server/0 [1.9.1 110214-aec102d89c78]


  • org.netbeans.modules.settings/1 [1.26.1 110214-aec102d89c78]


  • org.netbeans.modules.spi.actions/1 [1.7.1 110214-aec102d89c78]


  • org.netbeans.modules.swing.validation/1 [1.7.1 110214-aec102d89c78]


  • org.netbeans.modules.target.iterator/1 [1.2.1 110214-aec102d89c78]


  • org.netbeans.modules.usersguide/1 [1.28.1 110214-aec102d89c78]


  • org.netbeans.modules.utilities/1 [1.35.1 110214-aec102d89c78]


  • org.netbeans.modules.web.common [1.6.1 110214-aec102d89c78]


  • org.netbeans.modules.web.flyingsaucer/1 [1.8.1.1 1
    110214-aec102d89c78]


  • org.netbeans.modules.xml [1.9.1 110214-aec102d89c78]


  • org.netbeans.modules.xml.axi [1.10.1 110214-aec102d89c78]


  • org.netbeans.modules.xml.core/2 [1.21.1.4 4 110214-aec102d89c78]


  • org.netbeans.modules.xml.lexer [1.9.1 110214-aec102d89c78]


  • org.netbeans.modules.xml.retriever/1 [1.10.2 110214-aec102d89c78]


  • org.netbeans.modules.xml.schema.completion [1.9.2
    110214-aec102d89c78]


  • org.netbeans.modules.xml.schema.model/1 [1.10.1.1 1
    110214-aec102d89c78]


  • org.netbeans.modules.xml.text/2 [1.24.1.5 5 110214-aec102d89c78]


  • org.netbeans.modules.xml.xam/1 [1.10.2.1 1 110214-aec102d89c78]


  • org.netbeans.modules.xml.xdm/1 [1.11.2.1 1 110214-aec102d89c78]


  • org.netbeans.spi.editor.hints/0 [1.14.1.7.2 7 110214-aec102d89c78]


  • org.netbeans.spi.navigator/1 [1.13.1 110214-aec102d89c78]


  • org.netbeans.spi.palette/1 [1.22.1 110214-aec102d89c78]


  • org.netbeans.spi.quicksearch [1.6.1 110214-aec102d89c78]


  • org.netbeans.spi.tasklist/1 [1.11.1.1 1 110214-aec102d89c78]


  • org.netbeans.swing.dirchooser [1.8.1 110214-aec102d89c78]


  • org.netbeans.swing.outline [1.9.1 110214-aec102d89c78]


  • org.netbeans.swing.plaf [1.16.1 110214-aec102d89c78]


  • org.netbeans.swing.tabcontrol [1.21.1 110214-aec102d89c78]


  • org.openide.actions [6.16.1 110214-aec102d89c78]


  • org.openide.awt [7.23.1 110214-aec102d89c78]


  • org.openide.compat [6.13.1 110214-aec102d89c78]


  • org.openide.dialogs [7.15.1 110214-aec102d89c78]


  • org.openide.execution [1.18.1 110214-aec102d89c78]


  • org.openide.explorer [6.28.2 110214-aec102d89c78]


  • org.openide.filesystems [7.38.2 110214-aec102d89c78]


  • org.openide.io [1.23.1 110214-aec102d89c78]


  • org.openide.loaders [7.16.1 110214-aec102d89c78]


  • org.openide.modules [7.17.2 110214-aec102d89c78]


  • org.openide.nodes [7.16.1 110214-aec102d89c78]


  • org.openide.options [6.15.1 110214-aec102d89c78]


  • org.openide.text [6.30.1 110214-aec102d89c78]


  • org.openide.util [8.6.1 110214-aec102d89c78]


  • org.openide.util.lookup [8.3.1 110214-aec102d89c78]


  • org.openide.windows [6.33.1 110214-aec102d89c78]


  • org.openidex.util/3 [3.25.1 110214-aec102d89c78]


  • org.quartz/1 [1.8.4.1 110721]


  • org.springframework/1 [3.0.5 110721]


  • org.xhtmlrenderer [8.0 110721]


  • swingx/1 [1.6 110721]


ChemAxon 9c0afc9aaf

04-06-2012 14:40:17

Thank you for the detailed information !


Forgot to ask ... could you also attach at least one hit structure from IJC ?


It would help a lot in the investigation.


If the structures are confidential you can also send them in e-mail to our technical support e-mail. (support@...)

User 6b1e802ce9

04-06-2012 16:53:28

.

User 6b1e802ce9

04-06-2012 17:17:45

see attachments

User 6b1e802ce9

04-06-2012 17:34:29

In the attachments you should have:


-  the sdf export of a subset, around 800 structures


-  the PP protocol


-  screenshot of the IJC query results [CX3;$([R0][#6]),$([H1R0]):1](=[OX1])[F,Cl,Br,I:2]


 


I did run the query against the same table, this are my results


 


smarts                                                                                 |        PP              |                     IJC


[CX3;$([R0][#6]),$([H1R0]):1](=[OX1])[F,Cl,Br,I:2]        |    0                      |                     42
[CX3;$([R0][#6]),$([H1R0]):1](=[OX1])[ClX1:2]             |    51                   |                     39
[CX3;$([R0][#6]),$([H1R0]):1](=[OX1])[BrX1:2]             |      2                    |                      2     
[CX3;$([R0][#6]),$([H1R0]):1](=[OX1])[IX1:2]                |     0                     |                     0
[CX3;$([R0][#6]),$([H1R0]):1](=[OX1])[FX1:2]               |     1                     |                     1

ChemAxon 9c0afc9aaf

05-06-2012 00:42:34

Hi,


Thank you for the report and all the detailed information !


I could reproduce the problem.


The problem was simpler than I suspected.


When there is a need to convert between CXN and PP molecules, the mol (CTAB) format is used as the best available choice.


Unfortunately this format does not handle SMARTS features well.


The conversion may also depend on the PP version, in my case with 8.5 I got 54 hits, not 0 (42 is correct).


 Suggestion:


- Use "ChemAxon MolConverter" to read in your SMARTS queries


- Specify a property name for output source, e.g. "mrvquery", choose mrv format 


- Specify the same property for the "Query Source Property" parameter of JChemSearch.


This way I got 42 hits for the first query, which is the correct number.


Later we will enable "JChemSearch" to read queries from a file directly as well, simplifying this.


Please let us know if this helps.


Best regards,


Szilard

User 6b1e802ce9

05-06-2012 14:55:09

thank you!