JChem cartdridge SQL to get Euclidean distance

Hi,

Quick question.

I am trying to return all SMILES structures from a database that have a euclidean distance below a certain threshold for a particular query smiles.  I assume I should be using the jc_compare and the dissimilarity("CF:Euclidean", "N=C=O") function in the SQL but am not clear on the most performant way to write the query. I haven't been able to find much about euclidean metrics in the cartidge docs and examples, perhaps I am looking in the wrong place, though this has been useful:

http://www.chemaxon.com/marvin/help/chemicalterms/EvaluatorTables.html#descriptors />
Any help much appreciated.

Thanks

Derek

Hi Derek,

You can use jc_evaluate for Chemical Terms (R).

Thanks

Peter