Break Molecule into its fragments / Merge Fragments together

User 7b0ee04e66

09-07-2008 13:20:32

Good afternoon





Using the Molecule API in java, I can


count the framgents for a Molecule - molecule.getFragCount();


split the Molecule into fragments - molecule.convertToFrags();


fuse Fragments together - combinedMolecules.fuse(molecule, false);





Is there a jc operator or jcf function which would allow me to do the same thing from PL/SQL?





Thanks


Catherine

ChemAxon e08c317633

09-07-2008 14:53:37

Hi Catherine,





In JChem 5.1 there will be a fragmentCount Chemical Terms function (you can use it with jc_evaluate) which will count the fragments of a Molecule.





Adding the other two functions to Chemical Terms is also in our feature request list, now we have increased its priority.





Zsolt

User 7b0ee04e66

09-07-2008 15:45:53

Thanks


Catherine

User d90f4e1cc8

21-03-2013 12:49:22

Hello,


Are the jc-functions now available for PL/SQL?




Thanks,


Mike

ChemAxon 61b4fee994

21-03-2013 14:56:26

Hi, Mike!


The jc_evaluate and jc_evaluate_x operator can be used with JChem Cartridge indices and we have functions that can be used without creating an index in the jcf package. For example, now he fragment count and fragments can be selected like this:


With the operators:


select ,jc_evaluate(<indexed_coluumn>,'fragmentCount()') from <table_name> where ...;


select jc_evaluate_x(<indexed_coluumn>,'chemTerms:fragments()') from <table_name> where ...;


With the jcf package functions:


select jcf.evaluate('C.C','fragmentCount()') from dual;

select jcf.evaluate_x('C.C','chemTerms:fragments()') from dual;


 


You can see more examples in the documentation here:


https://www.chemaxon.com/jchem/doc/dev/cartridge/cartapi.html#jc_evaluate


 


Regards,


Tamas

User d90f4e1cc8

22-03-2013 14:00:36

Hi Tamas,


 


Thank you for the functions for getting the fragments. Are there functions available to combine 2 molecules to a single one like the fuse-method in the Java API?


 


Regards,


 


Mike

ChemAxon 61b4fee994

22-03-2013 14:07:34

Hi,


We realized that the
"fuse" function does not really fit into Chemical Terms because
CT functions are executed on a single molecule and the fuse
function would require at least two molecules.


Let us know if you really need
the fuse function, and please describe your use case.


Thank you,


Tamas

User d90f4e1cc8

22-03-2013 16:14:59

Hi Tamas,


I'd need this function to add a salt structure to the main molecule.


Currently we get the information which salt we have to add in database API (pl/sql job). It would be great to change the molecule using the cartridge without the need of an external program (e. g. Java).


 


Best regards,


 


Mike

ChemAxon 61b4fee994

25-03-2013 11:31:53

Hi,


I'm not exactly sure that I understand it perfectly, but I think that in your case fuse in the Molecule API adds a new fragment to the existing Molecule with the fused molecule. You can achieve it is by converting your molecule to a smiles or smarts type format with the jc_molconvert function, and after that you only have to concatenate the two strings separated by a dot (.) character which means new fragment in those formats.


Regards,


Tamas

User d90f4e1cc8

25-03-2013 14:22:09

Hi Tamas,


That's correct. I have to combine 2 molecules into 1. The convertion using the smiles format might work, but I'll loose the position information of the atoms and maybe I'll break some of our drawing rules.


 


Best regards,


 


Mike

ChemAxon 61b4fee994

26-03-2013 16:44:56

Hi,


We agree that it is not the perfect solution, so we can add a new overloaded version of the jc_molconvert function, which can accept two input parameters, and the parameters can be fused together without conversion and manual string concatenation.


We can provide this feature in version 6.1, which is planned to be released at the end of this summer. Is itacceptable for you, or do you require a more urgent solution?


Regards,


Tamas

User d90f4e1cc8

26-03-2013 17:34:59

Hi Tamas,


Thank you very much for your support.


It would be great to have the functionality available in 6.1.


 


Best regards,


 


Mike

ChemAxon 61b4fee994

27-03-2013 09:49:00

Hi,


We actually decided not to overload the jc_molcovert function, but we will create a seperate jc_fuse function with two input molecules. It will work the same way as I described earlier and will be ready for the 6.1 version.


Regards,


Tamas

ChemAxon 61b4fee994

13-09-2013 09:35:53

Hi,


We have the 6.1 version released with the new jc_fuse function.


Regards,


Tamas

User d90f4e1cc8

16-09-2013 13:23:21

Hi Tamas,


Thank you very much. I will try it, as soon as we we upgraded our cartridge.


Mike