View source for Journal:SistematX, an online web-based cheminformatics tool for data management of secondary metabolites

{{Infobox journal article
|name         = 
|image        = 
|alt          = <!-- Alternative text for images -->
|caption      = 
|title_full   = SistematX, an online web-based cheminformatics tool for data management of secondary metabolites
|journal      = ''Molecules''
|authors      = Scotti, Marcus T.; Herrera-Acevedo, Chonny; Oliveira, Tiago B.; Costa, Renan P.O.; de Oliveira Santos, Silas Y.K.;<br />Rodrigues, Ricardo P.; Scotti, Luciana; Da-Costa, Fernando B. 
|affiliations = Federal University of Paraíba, Federal University of Sergipe, University of São Paulo
|contact      = Phone: +55-83-99869-0415
|editors      = 
|pub_year     = 2018
|vol_iss      = '''23'''(1)
|pages        = 103
|doi          = [http://doi.org/10.3390/molecules23010103 10.3390/molecules23010103]
|issn         = 1420-3049
|license      = [http://creativecommons.org/licenses/by/4.0/ Creative Commons Attribution 4.0 International]
|website      = [http://www.mdpi.com/1420-3049/23/1/103/htm http://www.mdpi.com/1420-3049/23/1/103/htm]
|download     = [http://www.mdpi.com/1420-3049/23/1/103/pdf http://www.mdpi.com/1420-3049/23/1/103/pdf] (PDF)
}}
{{ombox	
| type      = content	
| style    = width: 500px;	
| text      = This article should not be considered complete until this message box has been removed. This is a work in progress.	
}}
==Abstract==
The traditional work of a natural products researcher consists in large part of time-consuming experimental work, collecting biota to prepare, extracts to analyze, and innovative metabolites to identify. However, along this long scientific path, much information is lost or restricted to a specific niche. The large amounts of data already produced and the science of metabolomics reveal new questions: Are these compounds known or new? How fast can this information be obtained? To answer these and other relevant questions, an appropriate procedure to correctly store [[information]] on the data retrieved from the discovered metabolites is necessary. The SistematX (http://sistematx.ufpb.br) interface is implemented considering the following aspects: (a) the ability to search by structure, [[SMILES (language)|SMILES]] (Simplified Molecular-Input Line-Entry System) code, compound name, and species; (b) the ability to save chemical structures found by searching; (c) the ability to display compound data results, including important characteristics for natural products chemistry; and (d) the user's ability to find specific information for taxonomic rank (from family to species) of the plant from which the compound was isolated, the searched-for molecule, and the bibliographic reference and Global Positioning System (GPS) coordinates. The SistematX homepage allows the user to log into the data management area using a login name and password and gain access to administration pages. In this article, we introduce a modern and innovative web interface for the management of a secondary metabolite database. With its multi-platform design, it is able to be properly consulted via the internet and managed from any accredited computer. The interface provided by SistematX contains a wealth of useful information for the scientific community about natural products, highlighting the locations of species from which compounds are isolated.

'''Keywords''': SistematX, secondary metabolites, data management, online web-based tool

==Introduction==
The traditional work of a natural products researcher can be summarized as the collection of biological samples, preparation of extracts for biological screening or bioassay-guided fractionation, and isolation and purification of (bioactive or not) compounds. However, the first question that may arise is the following: are these compounds known or new? In addition, metabolomics studies have introduced a new question: how fast can this information be obtained?<ref name="BluntIsThere14">{{cite book |chapter=22. Is There an Ideal Database for Natural Products Research? |title=Natural Products: Discourse, Diversity, and Design |author=Blunt, J.W.; Munro, M.H.G. |editor=Osbourn, A.; Goss, R.J.; Carter, G.T. |publisher=John Wiley & Sons, Inc |year=2014 |pages=413–431 |doi=10.1002/9781118794623.ch22 |isbn=9781118794623}}</ref>

The stage of dereplication, a process known as the rapid characterization of previously known compounds in mixtures without their prior purification, has become a strategically important area for natural products research involved in screening programs in several commercial and non-commercial databases.<ref name="HarveyTheRe15">{{cite journal |title=The re-emergence of natural products for drug discovery in the genomics era |journal=Nature Reviews Drug Discovery |author=Harvey, A.L.; Edrada-Ebel, R.; Quinn, R.J. |volume=14 |issue=2 |pages=111–29 |year=2015 |doi=10.1038/nrd4510 |pmid=25614221}}</ref><ref name="CorleyStrategies94">{{cite journal |title=Strategies for Database Dereplication of Natural Products |journal=Journal of Natural Products |author=Corley, D.G.; Durley, R.C. |volume=57 |issue=11 |pages=1484–1490 |year=1994 |doi=10.1021/np50113a002}}</ref><ref name="OliveiraTemporal13">{{cite journal |title=Temporal characteristics of a natural products in-house database |journal=Planta Medica |author=Oliveira, T.; Chagas-Paula, D.; Rosa, A. et al. |volume=79 |pages=1113–1114 |year=2013 |doi=10.1055/s-0033-1351852}}</ref> These databases can be searched with minimal information, such as structural chemical and biological data from compounds; however, dereplication now requires additional information, such as biogeographical and taxonomic information, or the presence of a certain compound (new or known) in other individuals of the same species, genus, subfamily, and family. This information can also help to reduce the number of hits during chemical identification by dereplication.

Large structure-based data collections, such as ChemSpider<ref name="PenceChemSpider10">{{cite journal |title=ChemSpider: An Online Chemical Information Resource |journal=Journal of Chemical Education |author=Pence, H.E.; Williams, A. |volume=87 |issue=11 |pages=1123–1124 |year=2010 |doi=10.1021/ed100697w}}</ref>, PubChem<ref name="BoltonPubChem08">{{cite book |chapter=Chapter 12 - PubChem: Integrated Platform of Small Molecules and Biological Activities |title=Annual Reports in Computational Chemistry |volume=4 |author=Bolton, E.E.; Wang, Y.; Thiessen, P.A.; Bryant, S.H. |editor=Wheeler, R.A.; Spellmeyer, D.C. |publisher=Elsevier Ltd |year=2008 |pages=217-241 |doi=10.1016/S1574-1400(08)00012-1 |isbn=9780444532503}}</ref>, ChEBI<ref name="DegtyarenkoChEBI08">{{cite journal |title=ChEBI: A database and ontology for chemical entities of biological interest |journal=Nucleic Acids Research |author=Degtyarenko, K.; de Matos, P.; Ennis, M. et al. |volume=36 |issue=DB1 |pages=D344-50 |year=2008 |doi=10.1093/nar/gkm791 |pmid=17932057 |pmc=PMC2238832}}</ref>, and ZINC<ref name="IrwinZINC05">{{cite journal |title=ZINC: A free database of commercially available compounds for virtual screening |journal=Journal of Chemical Information and Modeling |author=Irwin, J.J.; Shoichet, B.K. |volume=45 |issue=1 |pages=177–82 |year=2005 |doi=10.1021/ci049714+ |pmid=15667143 |pmc=PMC1360656}}</ref> can be used for this purpose.<ref name="WilliamsDerep15">{{cite journal |title=Dereplication of natural products using minimal NMR data inputs |journal=Organic & Biomolecular Chemistry |author=Williams, R.B.; O'Neil-Johnson, M.; Williams, A.J. et al. |volume=13 |issue=39 |pages=9957–62 |year=2015 |doi=10.1039/c5ob01713k |pmid=26381222}}</ref><ref name="EugsterRetention14">{{cite journal |title=Retention time prediction for dereplication of natural products (CxHyOz) in LC-MS metabolite profiling |journal=Phytochemistry |author=Eugster, P.J.; Boccard, J.; Debrus, B. et al. |volume=108 |pages=196–207 |year=2014 |doi=10.1016/j.phytochem.2014.10.005 |pmid=25457501}}</ref> However, these databases are not specialized in secondary metabolite information that is valuable to the natural products researchers, for example, botanical occurrence and geographical localization. For this reason, a number of specialized natural products databases were developed that are commercially or freely available and only contain restricted information, for example, the Dictionary of Natural Products (DNP)<ref name="CRCDictionary">{{cite web |url=http://dnp.chemnetbase.com/ |title=Dictionary of Natural Products |publisher=CRC Press |accessdate=04 March 2017}}</ref>, NAPRALERT<ref name="GrahamTheNAPRALERT10">{{cite book |chapter=The NAPRALERT database as an aid for discovery of novel bioactive compounds |title=Comprehensive Natural Products II: Chemistry and Biology |author=Graham, J.G.; Farnsworth, N.R. |volume=3 |publisher=Elsevier Ltd |year=2010 |pages=81–94 |isbn=9780080453828}}</ref>, Marinlit for marine natural products<ref name="DabbMarinLit">{{cite journal |title=MarinLit: Database and essential tools for the marine natural products community |journal=Proceedings of the 248th National Meeting of the American-Chemical-Society (ACS) |author=Dabb, S.; Blunt, J.; Munro, M. |volume=248 |year=2014}}</ref>, and Antibase for microorganisms and higher fungi materials. Nevertheless, none of these provide structural collections in a format that can be rapidly integrated into software such as ACD/Structure Elucidator and others.<ref name="WilliamsDerep15" />

Other natural products databases provide natural products extracted from various resources and contain various associated information such as toxicity prediction, but so far, little or nothing is known about these resources, for example, SUPER NATURAL II.<ref name="BanerjeeSuper15">{{cite journal |title=Super Natural II:A database of natural products |journal=Nucleic Acids Research |author=Banerjee, P.; Erehman, J.; Gohlke, B.O. et al. |volume=43 |issue=DB1 |pages=D935–9 |year=2015 |doi=10.1093/nar/gku886 |pmid=25300487 |pmc=PMC4384003}}</ref> Natural products databases exhibit a huge range of structural complexity and thus are expected to contribute to the ability of such databases to provide positive hits.<ref name="HarveyTheRe15" /><ref name="DrewryEnhance10">{{cite journal |title=Enhancements of screening collections to address areas of unmet medical need: An industry perspective |journal=Current Opinions in Chemical Biology |author=Drewry, D.H.; Macarron, R. |volume=14 |issue=3 |pages=289–98 |year=2010 |doi=10.1016/j.cbpa.2010.03.024 |pmid=20413343}}</ref> These structures are available in regional databases, for example NeBBEDB<ref name="ValliDevelop13">{{cite journal |title=Development of a natural products database from the biodiversity of Brazil |journal=Journal of Natural Products |author=Valli, M.; dos Santos, R.N.; Figueira, L.D. et al. |volume=76 |issue=3 |pages=439-44 |year=2013 |doi=10.1021/np3006875 |pmid=23330984}}</ref>, SANCDB<ref name="HatherleySANCDB15">{{cite journal |title=SANCDB: A South African natural compound database |journal=Journal of Cheminformatics |author=Hatherley, R.; Brown, D.K.; Musyoka, T.M. et al. |volume=7 |pages=29 |year=2015 |doi=10.1186/s13321-015-0080-8 |pmid=26097510 |pmc=PMC4471313}}</ref>, TM-CM<ref name="KimTM-MC15">{{cite journal |title=TM-MC: A database of medicinal materials and chemical compounds in Northeast Asian traditional medicine |journal=BMC Complementary and Alternative Medicine |author=Kim, S.K.; Nam, S.; Jang, H. et al. |volume=15 |pages=218 |year=2015 |doi=10.1186/s12906-015-0758-5 |pmid=26156871 |pmc=PMC4495939}}</ref>, TCM-Database@Taiwan<ref name="ChenTCM11">{{cite journal |title=TCM Database@Taiwan: The world's largest traditional Chinese medicine database for drug screening in silico |journal=PLoS One |author=Chen, C.Y. |volume=6 |issue=1 |pages=e15939 |year=2011 |doi=10.1371/journal.pone.0015939 |pmid=21253603 |pmc=PMC3017089}}</ref>, NANPDB<ref name="NtieNANPDB17">{{cite journal |title=NANPDB: A Resource for Natural Products from Northern African Sources |journal=Journal of Natural Products |author=Ntie-Kang, F.; Telukunta, K.K.; Döring, K. et al. |volume=80 |issue=7 |pages=2067-2076 |year=2017 |doi=10.1021/acs.jnatprod.7b00283 |pmid=28641017}}</ref>, and TCMID.<ref name="XueTCMID13">{{cite journal |title=TCMID: Traditional Chinese Medicine integrative database for herb molecular mechanism analysis |journal=Nucleic Acids Research |author=Xue, R.; Fang, Z.; Zhang, M. et al. |volume=41 |issue=DB1 |pages=D1089-95 |year=2013 |doi=10.1093/nar/gks1100 |pmid=23203875 |pmc=PMC3531123}}</ref> Many have been used in virtual screening research studies. In addition to the database information described above that uses two-dimensional (2D) structures, several databases have selected methods and tools for generating three-dimensional (3D) structures of small organic molecules, often for use in structure-based drug design.

In addition, databases of natural products with a focus on metabolomic studies with relationships between species-metabolites include the KNApSAcK Family<ref name="AfendiKNApSAcK12">{{cite journal |title=KNApSAcK family databases: Integrated metabolite-plant species databases for multifaceted plant research |journal=Plsnt & Cell Physiology |author=Afendi, F.M.; Okada, T.; Yamazaki, M. et al. |volume=53 |issue=2 |pages=e1 |year=2012 |doi=10.1093/pcp/pcr165 |pmid=22123792}}</ref>, TIPdb-3D<ref name="TungTIPdb14">{{cite journal |title=TIPdb-3D: The three-dimensional structure database of phytochemicals from Taiwan indigenous plants |journal=Database |author=Tung, C.W.; Lin, Y.C.; Chang, H.S. et al. |volume=2014 |pages=bau055 |year=2014 |doi=10.1093/database/bau055 |pmid=24930145 |pmc=PMC4057645}}</ref>, and AsterDB<ref name="ABCAsterDB">{{cite web |url=http://www.asterbiochem.org/asterdb |title=AsterDB |publisher=AsterBioChem |accessdate=04 March 2017}}</ref>, which enable searches for chemical structures by plant species names and other taxonomic information. Nevertheless, some data are still lacking for the purpose of exact dereplication. Information such as exact mass and geographic data can be very important for this type of study.<ref name="SampaioEffect16">{{cite journal |title=Effect of the environment on the secondary metabolic profile of Tithonia diversifolia: A model for environmental metabolomics of plants |journal=Scientific Reports |author=Sampaio, B.L.; Edrada-Ebel, R.; Da Costa, F.B. |volume=6 |pages=29265 |year=2016 |doi=10.1038/srep29265 |pmid=27383265 |pmc=PMC4935878}}</ref><ref name="SchmidtLarrea12">{{cite journal |title=Larrea tridentata—Absolute configuration of its epoxylignans and investigations on its antiprotozoal activity |journal=Phytochemistry Letters |author=Schmidt, T.J.; Rzeppa, S.; Kaiser, M.; Brun, R. |volume=5 |issue=3 |pages=632-638 |year=2012 |doi=10.1016/j.phytol.2012.06.011}}</ref><ref name="GaquerelComput13">{{cite journal |title=Computational annotation of plant metabolomics profiles via a novel network-assisted approach |journal=Metabolomics |author=Gaquerel, E.; Kuhl, C.; Neumann, S. |volume=9 |issue=4 |pages=904–918 |year=2013 |doi=10.1007/s11306-013-0504-2}}</ref>

It is not enough simply to focus on the information contained in a database. A clean and user-friendly interface, fast search, and consistency between currently available operating systems (Microsoft Windows, Mac, and Linux) can be just as important. For this purpose, the SistematX software was developed to provide the abovementioned information for chemosystematics studies, dereplication, and botanical correlations.

==Results and discussion==
===Utility and discussion===
The SistematX homepage is shown in Figure 1A. After the user enters the website (http://sistematx.ufpb.br), the “Structure search” option is seen with the MarvinJS API (Application Programming Interface) at the top of the screen. Another three search options can be exhibited in the interface. The initial screen of the system also shows the SMILES (Simplified Molecular-Input Line-Entry System) code (Figure 1B), compound name (Figure 1C) and plant species search modes (Figure 1D).


[[File:Fig1 Scotti Molecules2018 23-1.png|1000px]]
{{clear}}
{| 
 | STYLE="vertical-align:top;"|
{| border="0" cellpadding="5" cellspacing="0" width="1000px"
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"| <blockquote>'''Figure 1.''' SistematX homepage with different search options: '''(A)''' by structure; '''(B)''' by Simplified Molecular-Input Line-Entry System (SMILES); '''(C)''' by compound name; and '''(D)''' by plant species</blockquote>
 |- 
|}
|}

In the first option, the user can perform the search using the drawn full structure or molecular skeleton, fragments, or substructures, which is important in cases when the user only knows a structural characteristic of the structure such as functional groups or when studies require structural similarity, structural groups, or families of compounds. It is possible to use the similarity search option that is currently available in SistematX. The search results page shows all compounds that correspond to the value above the cut off provided by the user in the decreasing order of similarity, showing the similarity values on the top. A substructure and similarity search is performed using a hashed fingerprint. Special molecular features are present in the query (e.g., stereochemistry, charge), only those targets match that also contain the feature. However, if a feature is missing from the query, it is not required to be missing.

In addition, it is possible to search by SMILES code, a chemical notation system capable of representing even the most complex organic compounds using a simple grammar that is very well known to organic chemistry researchers; for this reason we add this option separately from the structure search using the MarvinJS API, being friendly for one just to copy and paste the SMILES code (Figure 1B); by common (usual) name or IUPAC (International Union of Pure and Applied Chemistry) name (or part of one of these); and by species, although in this option, it is necessary to first insert the name of the genus (which presents an autocompletion option). After being selected, the system presents all species available for the user to select for the search.

When performing a search, the mechanism generates a search results page (six results per page), using common names; if the compound does not have one, it shows the IUPAC name (Figure 2). The user can set the number of structure results per page. When a result is selected, the user has access to the data for that molecule, which are classified into six different groups (Figure 3).


[[File:Fig2 Scotti Molecules2018 23-1.png|1100px]]
{{clear}}
{| 
 | STYLE="vertical-align:top;"|
{| border="0" cellpadding="5" cellspacing="0" width="1100px"
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"| <blockquote>'''Figure 2.''' SistematX results page</blockquote>
 |- 
|}
|}

[[File:Fig3 Scotti Molecules2018 23-1.png|1100px]]
{{clear}}
{| 
 | STYLE="vertical-align:top;"|
{| border="0" cellpadding="5" cellspacing="0" width="1100px"
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"| <blockquote>'''Figure 3.''' SistematX screen for molecular data</blockquote>
 |- 
|}
|}

The first group of results that appears is related to the structural representation of the searched molecule. The 2D structure is observed in the interface; on top, this appears as the option to amplify. After this is clicked, the system displays the visualization of the molecule in 2D and 3D (ChemDoodle, iChemLabs, Piscataway, NJ, USA) and an additional option for saving the 2D or 3D structure in an MDL (Molecular Design Limited, San Ramon, CA, USA) Molfile. The second type of result exhibited by the systems associated with compound identification, such as common name, SMILES code, IUPAC name, InChI (IUPAC International Chemical Identifier, Research Triangle Park, NC, USA) code, InChIKey code and CAS (Chemical Abstracts Service, Columbus, OH, USA) number. Except for the common name, which is optional and registered by the administrator, all parameters are provided by the JChem API.

Compound data results include important characteristics for natural products chemistry. The class of secondary metabolite of the searched molecule and its skeleton provide information about its biosynthetic pathway and assists in chemosystematics and chemotaxonomic studies. Oxidation number (NOX), which is calculated based on the Hendrickson rules<ref name="HendricksonOrganic70">{{cite book |title=Organic Chemistry |author=Hendrickson, J.B.; Cram, D.J.; Hammond, G.S. |publisher=McGraw-Hill |year=1970 |isbn=070281505}}</ref>, has been fundamental in chemotaxonomy since Gottlieb related the oxidation grade of molecules to species evolution.<ref name="GottliebTheRole89">{{cite journal |title=The role of oxygen in phytochemical evolution towards diversity |journal=Phytochemistry |author=Gottlieb, O. |volume=28 |pages=2545–2558 |year=1989}}</ref> Molecular mass is calculated using the most abundant isotope of each element (exact mass) and the average atomic mass of each element (relative mass); these data are important for users working on purification processes and for structural elucidation of molecules, due to the mass information, which is essential for determining the purity of secondary metabolites.

In the botanical data field, the user can find specific information such as the taxonomic rank (from family to species) of the plant from which the compound was isolated, the searched molecule, and the bibliographic reference, which includes journal name, volume, page, and year. Because many different species can biosynthesize the same molecule, there is one register per species. Meanwhile, the biological data exhibit results obtained in studies related to the biological activity of the searched molecule, the type of activity, system, units, activity value and bibliographic reference are available in this section.

Plant species have revealed clear genetic signals for local adaptation.<ref name="ZüstNatural12">{{cite journal |title=Natural enemies drive geographic variation in plant defenses |journal=Science |author=Züst, T.; Heichinger, C.; Grossniklaus, U. et al. |volume=338 |issue=6103 |pages=116–9 |year=2012 |doi=10.1126/science.1226397 |pmid=23042895}}</ref> One species can synthesize a secondary metabolite depending on its location, and there are observed variations in compound concentrations at different sites. Because geographical data is an important parameter in natural products research, SistematX shows geographical coordinates (latitude and longitude) for a searched molecule and an approximate location of the species from which this metabolite was isolated. Using the Google Maps API, the user can observe the species location on the world map.

===Data management===
On the SistematX homepage, the user can also log into the data management area using login name and password (Figure 4A) and from there access the administration pages to edit or register new molecules. Once the corresponding information has been accepted, the data management interface appears.


[[File:Fig4 Scotti Molecules2018 23-1.png|1100px]]
{{clear}}
{| 
 | STYLE="vertical-align:top;"|
{| border="0" cellpadding="5" cellspacing="0" width="1100px"
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"| <blockquote>'''Figure 4.''' SistematX creates new registers through an administrator: '''(A)''' login and password option; '''(B)''' structure view and '''(C)''' molecule selection</blockquote>
 |- 
|}
|}

The first requirement to register a new molecule is to insert the structure in the MarvinJS API (Figure 4B). Several methods can be used to accomplish this step: drawing, copying SMILES code, or importing the molecule in a compatible format (e.g., sdf, cdx, mol, mol2). The molecule selection option then appears (Figure 4C), and if the molecule is new to the system, it appears with the option "New." If this option is selected, a blank register page with four subdivisions is shown: Basic Data, Extra Data, Botanical Data, and Geographical Data. However, if the molecule already exists in the system, another box with the drawn molecule appears, and after choosing this box, the register page for the structure containing all previously registered information appears (Figure 5).


[[File:Fig5 Scotti Molecules2018 23-1.png|1100px]]
{{clear}}
{| 
 | STYLE="vertical-align:top;"|
{| border="0" cellpadding="5" cellspacing="0" width="1100px"
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"| <blockquote>'''Figure 5.''' SistematX data management interface</blockquote>
 |- 
|}
|}

Immediately after the New option is selected, it appears in the register page, including some basic data generated by the MarvinJS API: SMILES, IUPAC name, InChI, InChIKey, NOX, exact mass, and relative mass. The class and skeleton of metabolites must be chosen to register a new structure in the system; this is a sequential process, and thus, the class must first be selected to make the skeleton structure option available. Classes and skeletons not already registered in the system can be registered via the Class and Skeleton tab on the top of the screen. Common name and CAS are optional registration options.

The Extra Data subdivision allows insertion of all structural spectroscopic information, such as 1H- and 13C-NMR (Nuclear Magnetic Resonance) and mass spectra. In addition, it is possible to find 2D NMR information through the HMBC (Heteronuclear Multiple Bond Correlation) technique to establish the relationship between 13C- and 1H-shifts. In the NMR data, the administrator must first select the deuterated solvent used in the spectroscopic studies. If this information does not exist in the options, it can be registered by selecting the Solvent tab on the top of the screen. After the structure appears with an atomic numeration assigned by the MarvinJS API (identified as Atom), it is always necessary to verify these numbers for the biogenetic numeration (identified as “Biogenetic”) and finally to add the chemical shift value for each atom. For 1H-NMR, it is also possible to register H–H coupling constants (J in Hz). Mass spectrum information, molecular mass, and intensity of fragments can also be being registered.

To create a new registry for botanical data of a certain species, the following information is required: journal, year, volume, first page, and last page information. Journal, genus, and species are drop-down lists, and these last two must be filled in this order. If any information relevant to these three fields does not exist, it can be inserted by clicking in "Journal" and "References" and writing the journal name (autocomplete tab) or by clicking in "Botanical Data," where taxonomic data are registered. Biological activity data appear as activity, system, system type, value, journal, year, and pages. Drop-down lists can be filled with previously registered data or by entering new data in the Biological Activity tab.

Finally, the administrator can register geographical data using the Google maps API. For any structure, it is possible to register latitude and longitude of the corresponding species studied. The genus and species boxes are filled in the same manner described above. Longitude and latitude can be inserted in two ways, first by writing the coordinates in the spaces; once registered, they appear on the world map as a red indicator showing the location. Another method is to select the place by clicking on the red pin on the map; when the pin is released, the values of longitude and latitude appear in the respective boxes.

Currently, our database has more than 1300 sesquiterpene lactones and 850 flavonoids and chalcones, with more than 4000 botanical occurrences of the ''Asteraceae'' family; approximately 500 alkaloids, which represents more than 750 botanical occurrences of the ''Apocynaceae'' family; and several terpenes and alkaloids of ''Annonaceae'', ''Apocynaceae'', and ''Asteraceae'' that correspond to more than 800 botanical occurrences.

==Material and methods==
===Implementation===
SistematX was developed in the Java programming language (version 8 or higher), using JSP (JavaServer Pages) technology version 2.1 or higher and [[MySQL]] database version 5.5.46-0 for Linux<ref name="MySQLDownload">{{cite web |url=https://dev.mysql.com/downloads/mysql/ |title=Download MySQL Community Server |publisher=Oracle Corporation |accessdate=31 January 2017}}</ref> to maintain the system data. An initial version of SistematX web was published in the proceedings of MOL2NET in 2015 to demonstrate its functionalities to the academic community and, with feedback, to improve old functionalities and add new tools.<ref name="ScottiSistematiX15">{{cite journal |title=SISTEMAT X - A Web Tool to Manage Databases of
Secondary Metabolites |journal=Proceedings of MOL2NET, International Conference on Multidisciplinary Sciences |author=Scotti, M.T.; Da Silva Junior, R.O.; De Oliveira Santos, S.Y.K. et al. |volume=1 |issue=Section F |pages=1–6 |year=2015 |url=https://sciforum.net/conference/MOL2NET-1/paper/3348/download/pdf}}</ref> In the current version, including automatically relative mass, exact mass, CAS number, and InChI (in the previous version only the InChIKey was available) for each compound. The CAS number if not generated automatically but can be added manually, and geographical localization of species where the compound was isolated is now available. It is also possible to perform a structural search by similarity index.

The system uses JSP to create pages with specific information for each molecule and dynamic page changes by clicking on certain buttons. Intermediary pages are used to recover information from the database and insert it in the JSP. The system creates a DAO (data access object) to organize the data on intermediary pages, working like a bridge from the DAO to JSP. For each database table needed in a request, a DAO is created specifically for that table, containing all attributes from the database table.

Bootstrap version 3.3.5<ref name="Bootstrap">{{cite web |url=http://getbootstrap.com/ |title=Bootstrap |publisher=Bootstrap Development Team |accessdate=10 January 2017}}</ref> — a graphical interface web framework that uses HTML (HyperText Markup Language), CSS (Cascading Style Sheets) and JavaScript — is employed for a better appearance on HTML pages, adapting some functions and styles to aid in the website design. The system also uses jQuery framework version 2.1.4<ref name="jQuery">{{cite web |url=http://jquery.com/ |title=jQuery - Write less, do more |publisher=The jQuery Foundation |accessdate=17 January 2017}}</ref>, a powerful JavaScript tool to manipulate HTML DOM (document object model) events. Another framework, jQuery AutoComplete version 1.2.18<ref name="jQueryAuto">{{cite web |url=http://jqueryui.com/autocomplete/ |title=jQuery - User interface |publisher=The jQuery Foundation |accessdate=20 January 2017}}</ref>, is used to generate autocomplete inputs.

Several APIs are used in the SistematX implementation (Table 1). MarvinJS version 15.7.20, from ChemAxon<ref name="MarvinJS">{{cite web |url=https://chemaxon.com/products/marvin-js |title=Marvin JS |publisher=ChemAxon Ltd |accessdate=24 January 2017}}</ref>, is the drawing API that is integrated with ChemAxon JChem WebService<ref name="jChemEngine">{{cite web |url=https://chemaxon.com/products/jchem-engines |title=JChem Engines |publisher=ChemAxon Ltd |accessdate=24 January 2017}}</ref>, an external online service that transforms the drawn structure into SMILES code, after which a JChem API function turns it into a binary fingerprint. This fingerprint is used to search for molecules — using substructure or similarity — in the database via their structure. The molecule converted to the fingerprint is used as a fragment in the search, comparing it to the database molecule’s fingerprints to determine if it exists inside as a fragment. This API utilizes HTML, CSS, and JavaScript to perform the transformations. We use the standardizer API of Chemaxon JChem Web Services to not only standardize nitro groups but also aromatize the structure search results as correctly as possible, making a query and the database with similar representation.

{| 
 | STYLE="vertical-align:top;"|
{| class="wikitable" border="1" cellpadding="5" cellspacing="0" width="100%"
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;" colspan="3"|'''Table 1.''' Summary of the Application Programming Interface (API) implemented by SistematX
 |-
  ! style="background-color:#dddddd; padding-left:10px; padding-right:10px;"|API
  ! style="background-color:#dddddd; padding-left:10px; padding-right:10px;"|Description
  ! style="background-color:#dddddd; padding-left:10px; padding-right:10px;"|Engine
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px; text-align:center;" colspan="3"|'''1. Structure'''
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"|'''2D drawing'''
  | style="background-color:white; padding-left:10px; padding-right:10px;"|Allows drawing and visualization of chemical structures
  | style="background-color:white; padding-left:10px; padding-right:10px;"|ChemAxon
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"|'''3D generator'''
  | style="background-color:white; padding-left:10px; padding-right:10px;"|Uses 2D drawing to generate a 3D representation of the molecule
  | style="background-color:white; padding-left:10px; padding-right:10px;"|ChemAxon
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"|'''3D'''
  | style="background-color:white; padding-left:10px; padding-right:10px;"|Graphical visualization of 3D molecules with JavaScript
  | style="background-color:white; padding-left:10px; padding-right:10px;"|ChemDoodl
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px; text-align:center;" colspan="3"|'''2. Compound Identification'''
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"|'''SMILES'''
  | style="background-color:white; padding-left:10px; padding-right:10px;"|Simplified Molecular Input Line Entry System
  | style="background-color:white; padding-left:10px; padding-right:10px;"|ChemAxon
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"|'''IUPAC'''
  | style="background-color:white; padding-left:10px; padding-right:10px;"|IUPAC Nomenclature
  | style="background-color:white; padding-left:10px; padding-right:10px;"|ChemAxon
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"|'''InChI'''
  | style="background-color:white; padding-left:10px; padding-right:10px;"|IUPAC International Chemical Identifier
  | style="background-color:white; padding-left:10px; padding-right:10px;"|ChemAxon
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"|'''InChIKey'''
  | style="background-color:white; padding-left:10px; padding-right:10px;"|InChIKey is a compact format of the InChI code
  | style="background-color:white; padding-left:10px; padding-right:10px;"|ChemAxon
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"|'''CAS'''
  | style="background-color:white; padding-left:10px; padding-right:10px;"|Chemical Abstracts Service Registry Number
  | style="background-color:white; padding-left:10px; padding-right:10px;"|ChemAxon
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px; text-align:center;" colspan="3"|'''3. Compound Data'''
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"|'''NOX'''
  | style="background-color:white; padding-left:10px; padding-right:10px;"|Oxidation number (NOX) of an organic compound
  | style="background-color:white; padding-left:10px; padding-right:10px;"|ChemAxon
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"|'''Exact Mass'''
  | style="background-color:white; padding-left:10px; padding-right:10px;"|Uses the mass of the most abundant isotope of each element
  | style="background-color:white; padding-left:10px; padding-right:10px;"|ChemAxon
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"|'''Relative Mass'''
  | style="background-color:white; padding-left:10px; padding-right:10px;"|Uses the average atomic mass of each element
  | style="background-color:white; padding-left:10px; padding-right:10px;"|ChemAxon
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px; text-align:center;" colspan="3"|'''4. Geographic Data'''
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"|'''Latitude'''
  | style="background-color:white; padding-left:10px; padding-right:10px;"|Can be inserted by the administrator or appears by clicking in the world map
  | style="background-color:white; padding-left:10px; padding-right:10px;"|Google Inc.
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"|'''Longitude'''
  | style="background-color:white; padding-left:10px; padding-right:10px;"|Can be inserted by the administrator or appears by clicking in the world map
  | style="background-color:white; padding-left:10px; padding-right:10px;"|Google Inc.
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"|'''Approximate'''
  | style="background-color:white; padding-left:10px; padding-right:10px;"|Using the latitude and longitude, appears an an approximate location of the species
  | style="background-color:white; padding-left:10px; padding-right:10px;"|Google Inc.
 |-
  | style="background-color:white; padding-left:10px; padding-right:10px;"|'''Visualization'''
  | style="background-color:white; padding-left:10px; padding-right:10px;"|Uses the world map to possible to visualize the localization of the species
  | style="background-color:white; padding-left:10px; padding-right:10px;"|Google Inc.
 |-
|}
|}

==References==
{{Reflist|colwidth=30em}}

==Notes==
This presentation is faithful to the original, with only a few minor changes to presentation. In some cases important information was missing from the references, and that information was added.

<!--Place all category tags here-->
[[Category:LIMSwiki journal articles (added in 2018)‎]]
[[Category:LIMSwiki journal articles (all)‎]]
[[Category:LIMSwiki journal articles on chemical informatics‎‎]]
[[Category:LIMSwiki journal articles on software‎‎]]