Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Standardize the structure before inserting into the database columns:

    Code Block
    INSERT INTO <your_table> (mol, ... ) VALUES (standardize(<your structure>:: Molecule('sample')), ... )


  2. Store both the not standardized and the standardized structures:


    Code Block
    INSERT INTO <your_table> (mol,standardized_mol ... ) VALUES (<your structure>:: Molecule('sample'), standardize(<your structure>:: Molecule('sample')), ... )


  3. Standardize on the fly before calling chemical terms:

    Code Block
    select chemterm(<your_chemical_terms>, standardize(<your_structure>:: Molecule('sample')):: Molecule);


Standardize
Anchor
standardize
standardize

...

The standardization steps are determined by the molecule type definition. The returned value is a the the standardized structure in MRV format

...

Code Block
languagesql
SELECT standardize('C1=CC=CC=C1':: Molecule('sample'));

Molconvert
Anchor
molconvert
molconvert

...