I am working on evaluating the RD Kit Postgresql data cartridge for use as the back end of a Web Application. The app will use a JavaScript sketcher to allow the user to input a SMILES of SMARTS that will be sent to the RD Kit cartridge. In evaluating RD Kit I found that it doesn't support aromatic normalization on SMARTS. As a test case I used Marvin JS to generate a SMARTS: C(=CN=C1)C(=C1N2)N=C2
Used it as a query: select structure_id from rdk.mols where m@>mol_adjust_query_properties(mol_from_smarts('C(=CN=C1)C(=C1N2)N=C2')); structure_id -------------- (0 rows) Not surprisingly it had no hits. Looked at the mol_adjust_query_properties function: select mol_adjust_query_properties(mol_from_smarts('C(=CN=C1)C(=C1N2)N=C2')); mol_adjust_query_properties ----------------------------- c1cc2ncnc2cn1 That looked good. select structure_id from rdk.mols where m@>mol_adjust_query_properties(mol_from_smarts('c1cc2ncnc2cn1')); structure_id -------------- 30183725 (1 row) But wait there should be more hits! select count(*) from rdk.mols where m@>'c1cc2ncnc2cn1'::qmol; count ------- 27 Then I tried this: select structure_id from rdk.mols where m@>mol_adjust_query_properties(mol_from_smarts('c1cc2ncnc2cn1'),'{"adjustDegree":false}'); (27 rows) OK, but what I really need to have work is this: select structure_id from rdk.mols where m@>mol_adjust_query_properties(mol_from_smarts('C(=CN=C1)C(=C1N2)N=C2'),'{"adjustDegree":false}'); structure_id -------------- (0 rows) Which it does not. Is mol_adjust_query_properties misnamed? It doesn't really seem to want a query. Am I missing an option? Unless I can make this work I don't see how I can use RD Kit in my application. What am I missing? Or does RD Kit just not allow for normalizing SMARTS? Thanks Webster Homer This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Merck KGaA, Darmstadt, Germany and any of its subsidiaries do not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Merck KGaA, Darmstadt, Germany and any of its subsidiaries do not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith. Click http://www.merckgroup.com/disclaimer to access the German, French, Spanish and Portuguese versions of this disclaimer.
_______________________________________________ Rdkit-discuss mailing list Rdkit-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rdkit-discuss