- Open Access
FluxTransgenics: a flexible LIMS-based tool for management of plant transformation experimental data
© Hanke et al.; licensee BioMed Central Ltd. 2014
Received: 17 October 2013
Accepted: 16 April 2014
Published: 26 June 2014
The production and commercial release of Genetically Modified Organisms (GMOs) are currently the focus of important discussions. In order to guarantee the quality and reliability of their trials, companies and institutions working on this subject must adopt new approaches on management, organization and recording of laboratory conditions where field studies are performed. Computational systems for management and storage of laboratory data known as Laboratory Information Management Systems (LIMS) are essential tools to achieve this.
In this work, we have used the SIGLa system – a workflow based LIMS as a framework to develop the FluxTransgenics system for a GMOs laboratory of Empresa Brasileira de Pesquisa Agropecuária (EMBRAPA) Maize and Sorghum (Sete Lagoas, MG - Brazil). A workflow representing all stages of the transgenic maize plants generation has been developed and uploaded in FluxTransgenics. This workflow models the activities involved in maize and sorghum transformation using the Agrobacterium tumefaciens method. By uploading this workflow in the SIGLa system we have created Fluxtransgenics, a complete LIMS for managing plant transformation data.
FluxTransgenics presents a solution for the management of the data produced by a laboratory of genetically modified plants that is efficient and supports different kinds of information. Its adoption will contribute to guarantee the quality of activities and products in the process of transgenic production and enforce the use of Good Laboratory Practices (GLP).
The adoption of the transformation protocol associated to the use of FluxTransgenics has made it possible to increase productivity by at least 300%, increasing the efficiency of the experiments from between 0.5 and 1 percent to about 3%. This has been achieved by an increase in the number of experiments performed and a more accurate choice of parameters, all of which have been made possible because it became easier to identify which were the most promising next steps of the experiments. The FluxTransgenics system is available for use by other laboratories, and the workflows that have been developed can be adapted to other contexts.
The amount of data generated by experimental processes has been growing significantly. As a consequence, the management of data and processes from laboratories has been the subject of debate. Stafford  has discussed the need of computational tools designed to manage all laboratory information — including, but not limited to, the data produced by these laboratories — highlighting the relevance of such systems. These applications are referred to as Laboratory Information Management Systems (LIMS) and are characterized by data storage and tracking functionalities, management of the laboratory processes, quality assurance and integration with other systems and equipments. Several LIMS are currently available as academic, proprietary and open source solutions. Some examples of these include SQL LIMS , LabSoft , LabWare , FreeLIMS  and the systems developed by Hendrick , Quo , Tharayil  and Sanchez .
The available LIMS are usually restricted to the needs of the laboratories involved in their development and are specific to the context of these laboratories. SQL LIMS, for example, has distinct solutions for pharmaceutical, chemical, nourishing, forensic and water analysis laboratories. Other systems present functionalities varying from data management from an academic micro chip fabrication facility  or a cancer research laboratory , to a maize mapping project  or a service based LIMS focused on the integration of the data stored in biological databases . These systems have been designed to manage specific data for one kind of laboratory and therefore present some limitations when customization is necessary.
Table containing a comparison between FluxTransgenics and similar systems
Web Application, can be accessed from any OS.
Mac OS or Microsoft Windows.
Web Application, can be accessed from any OS.
MySQL Relational Database.
MySQL Relational Database.
Most laboratory processes. Adaptable to any workflow.
Adaptable to any workflow.
Permissions are granted to user or roles. Roles, or groups, can be created by administrator user.
Permissions are granted only to users. The concept of roles is non existent.
Permissions are granted to user or roles. But the roles are fixed (cannot be created).
Furthermore, the SIGLa system shares some key features with Electronic Laboratory Notebooks (ELN), such as record keeping, online data sharing and retrieval, support to different types of data formats, collaboration, permissions system, inventory and file management and audit trail. The SIGLa system is web based but can also operate offline by simply installing the complete client-server architecture in a stand alone machine. There are other ELNs available, such as eJournal [16, 17], eCAT  and E-WorkBook Suite (EWBS) , and even the web application Evernote  that can be used to manage data. However, these systems lack the flexibility and workflow perspective of LIMS-based systems such as SIGLa.
In this work, we propose the construction of workflows to be used in the SIGLa system for data management of a plant transformation facility and modifications in SIGLa to comply with the needs of these complex processes. By uploading the workflows to the SIGLa system the LIMS system is created. These workflows can serve as a model for similar laboratories. The system proposed is called FluxTransgenics and has been designed to manage data of the Cellular Biology and Plant Tissue Culture Laboratory at EMBRAPA Maize and Sorghum — MG — Brazil. This facility works on the analysis and production of transgenic maize and sorghum plants. A complex workflow has been constructed for data management considering one of the main methods used for maize transformation: the use of the bacteria Agrobacterium tumefaciens. Transformation through A. tumefaciens uses the bacteria natural system of gene transferring . This process has a significant number of activities with specific attributes that are defined with great detail during workflow construction.
FluxTransgenics has been developed in collaboration with EMBRAPA Maize and Sorghum — MG — Brazil, an institution that works, among other things, in the production of transgenic plants. EMBRAPA has initiated the use of the Good Laboratory Practices (GLP) to fulfill the demand for quality at the production and commercialization of genetically modified organisms. GLP are a set of management principles for research laboratories activities that provide a framework within which studies are planned and performed in order to ensure results consistency and reliability . In order to enforce the GLP adoption it is important to demonstrate that information produced and processes applied to obtain it are correct and traceable. The use of automated systems as FluxTransgenics to follow each step of the research in a laboratory is essential to ensure the quality of the production.
The FluxTransgenics system has been used to manage data from experiments starting on September 2011. Up to September 2012, it has stored data of 67 experiments, including complete and ongoing experiments. From these experiments, 20 transgenic plants have been successfully generated. These 67 experiments have been performed during the initial setup phase of the transformation laboratory. The small number of plants generated is a consequence of the problems encountered during the protocol standardization. Currently the laboratory produces between 6 to 15 plants per experiment, which generates an amount of data that requires more efficient management tools.
Our next step in the research is to perform a data mining analysis of this data, searching for patterns that could identify the ideal conditions for a successful experiment. It is important to note that this analysis will be possible only because the data is stored in a structured representation, where not only each experiment is stored, but also which experiment is derived from which one, making it possible to track and relate all experimental data.
Access to the FluxTransgenics system is available at the address http://www.luar.dcc.ufmg.br/FluxTransgenics(login/password: guest/guest). The definition of the transformation process is completely included in the workflow, modifications for other protocols require only a change in the workflow definition. So, adaptations for other laboratories do not require changes in the source code of the system, only in its description. The workflow definition is available for download at the address above. In addition to this, the source code of the SIGLa system is also available for code developers as well.
The SIGLa system
The construction of the FluxTransgenics LIMS
The construction of the FluxTransgenics LIMS consisted of the development of the plant transformation workflow and its upload to the SIGLa system. In this workflow each activity corresponds to an experimental step, and its attributes identify the types of information that are generated in this experimental step. The sequence of activities then contain all the steps of the transformation protocol. The attributes in each activity store the specific information of that activity. As a consequence, the workflow has the complete description of the data being managed, all the steps and for each step the required data.
Because of this, the FluxTransgenics system has been fully developed by specifying the workflow, without changing the code of the SIGLa system. Other workflows, or adaptations to this workflow can be developed by changing the workflow files in the editor, without changing the SIGLa system. The information managed by the FluxTransgenics system is completely contained in its workflow, the SIGLa system is the engine that drives the workflow, in the same way as experimental data can be stored in an Excel spreadsheet file. This file contains the data and all of the formulas that are required to understand it, the Excel program is merely an engine to understand this data.
There are several different types of attributes, each fulfilling a specific need in storing and managing laboratory data. For example, to specify which reagents are used in an experimental step, one attribute “reagent” can be specified. This information is entered by the user when registering the experiment. There are several ways in which a reagent can be specified. One way is to let the user type a string with the reagent name. Another is to let the name be chosen from a list of specified names. Yet another is to let the user determine which are the valid reagent names in another menu. Which option will be used is specified in the workflow.
Other features of the SIGLa system can be defined in the workflow, such as the protocol used, or the callus identifiers. Protocols are usually specified in a type of attribute, called register, which lets the user choose from a list of pre-specified names. Each name, when defined, can allow a text file (in plain text, Word or any other format) to be stored with the description of the protocol. In this way, a list of allowed protocols is stored, together with the full information about the protocol.
Callus identifiers use a different feature, called auto increment. When an attribute has this type, its value is not entered by the user, but defined when the activity is registered, as a unique identifier generated by the SIGLa engine. In this way the system guarantees its uniqueness, and can even generate bar codes to be attached to the samples, if needed.
This information is stored by the SIGLa system in dynamically defined tables in the database. The entities in this database are activities, which are related to one another by the relation is derived from, with a cardinality of 1:n, i.e., an activity can generate several “daughter” activities, but each activity has exactly one “parent” activity, except for the first activity. For example, the second activity in an experiment is derived from the first activity, but this first activity is not derived from any other.
Tables have a dynamic content, because each activity is defined by different attributes. So each item stored in the attributes table is a line containing, basically, the tuple (activity,attribute _name,value), where activity defines which activity in the workflow it refers to, attribute_name defines which attribute, and value defines the value of the attribute entered by the user. The SIGLa system is responsible for reconstructing, from the activities table and an experiment identifier, the data pertaining to that experiment.
It is important to emphasize that the SIGLa system is used in this work as an engine that drives the plant transformation workflow creating the FluxTransgenics LIMS. All of the information relating to plant transformation and experimental data is stored in the workflow.
Workflow construction and transformation protocol
The FluxTransgenics workflow — developed to represent the transformation process — presents a comprehensive set of attributes designed to allow recording and managing of all activities performed during the transformation process and the definition of the details regarding those activities for an easy retrieval by the user for reports production.
The FluxTransgenics system has been successfully tested by the researchers at EMBRAPA Maize and Sorghum as a tool to track the plant transformation process.
The process of producing GMO plants is complex involving a large number of steps and it may take a long time. For maize, for example, it may take up to six months to complete an experiment. During this time, researchers are looking for what is called an elite event that is, a result that has the ideal characteristics to produce the desired outcome. An elite event must contain a small number of copies of the implanted gene, express the heterologous protein at high levels, and this protein must be the only difference between this new lineage and the previous one. In our lab, about twenty events are produced for each gene, in search of an elite event.
However, due to the long duration of the experiments, it is not always possible to wait until it is known that an event will be a successful one before initiating a new one and therefore several experiments are performed simultaneously. An accurate management of the samples and experimental steps is necessary to be able to identify the more promising results. However, with so many different ongoing experiments being performed by different laboratory analysts, the link between an elite event and its related experiments can be easily lost. The use of standard protocols and computational aids are essential to follow results efficiently and accurately.
By using the protocol developed by [24–26], and implementing it using FluxTransgenics, EMBRAPA’S lab has been able to increase the number of experiments performed at it from one to two a week to up to 16 (4 transformations with 4 different genic constructions) after protocol standardization. It has become much more efficient to identify the best conditions to generate a transgenic event and to coordinate the different steps of the various experiments to be performed daily. Moreover, modifications of the protocols can not only be easily implemented, but also can be easily related to which experiments use it instead of the original ones.
Previously, the efficiency of the transformation process at EMBRAPA’S lab was very low, only between 0.5 and 1 percent of the experiments were successful. As a consequence of the work described, the efficiency has increased to about 3 percent, an increase of 300 to 600 percent.
Sixty-seven experiments have been performed and twenty transgenic plants have been produced using FluxTransgenics to manage the steps of the process. These experiments represent one year of experimental data that have been successfully stored in the system.
In spite of the low productivity of the initial experiments, the use of an automated management system was very important. Because so few experiments were successful, identifying those and the reasons for their success was crucial for the establishment of a productive laboratory. Current productivity in the laboratory has since increased to performing on average one experiment a day, and each experiment generating from 6 to 15 plants.
A new version of the system is under development with additional features, including a workflow for management of data from transformation performed using microparticles bombardment and the design of new workflows to manage processes that are indirectly related to the processes of plant transformation.
FluxTransgenics is a LIMS that has been customized to attend the needs of the Cellular Biology and Plant Tissue Culture Laboratory at EMBRAPA Maize and Sorghum. It is currently being used in its production. It can be accessed at the URL: http://www.luar.dcc.ufmg.br/FluxTransgenics (login/password: guest/guest). At this address the system can be used to store a limited amount of experimental data, and to access the system source code.
The system can be easily adapted to similar laboratories by modifying the workflow description. A description of how to adapt the workflow to other laboratories is outside the scope of this paper, but is available at the address given. Potential users are welcome to use the system and contact the authors for modifications for other processes and different laboratories.
The production and commercial release of Genetically Modified Organisms (GMOs) are currently the focus of important discussions. Thus, efficient management methods to assess the conditions under which GMO laboratories experiments are carried out are needed. As a developer of GMOs, EMBRAPA Maize and Sorghum (Brazil) has enforced the use of the Good Laboratory Practices (GLP) to ensure quality on the processes of producing modified genetically plants and needs a computational system to support the use of GLP.
In this work, we present FluxTransgenics, a system for management of data on the process of plant transformation by A. tumefaciens to be used as a computational aid. The system is able to manage the information and the correct sequence of activities of the transformation performed at the Cellular Biology and Plant Tissue Culture Laboratory at EMBRAPA Maize and Sorghum. It is possible by using FluxTransgenics to track the stored data during the execution of each activity of the plant transformation, ensuring the quality required by GLP.
The authors wish to thank the Brazilian agencies CAPES (Coordenação de Aperfeiçoamento de Pessoal de Nível Superior), FAPEMIG (Fundação de Amparo à Pesquisa do Estado de Minas Gerais) and CNPq (Conselho Nacional de Desenvolvimento Científico e Tecnológico) for financial support.
- Stafford JEH:Lims: an automating or informating technology?. Lab Automation Inf Manage. 1998, 33 (3): 163-168.View ArticleGoogle Scholar
- SQL*LIMS. [http://www.sqllims.com],
- Computing Solutions I. [http://www.labsoftlims.com],
- LabWare LIMS Solutions. [http://www.labware.com],
- Geeknet, Inc - FreeLIMS. [http://sourceforge.net/projects/freelims/],
- Hendricks RW, Learn MR:A laboratory information management system (lims) for an academic microchip fabrication facility. University/Government/Industry Microelectronics Symposium. 2003, 88-93.Google Scholar
- Quo B, Wu C:Development of a laboratory information system for cancer collaboration projects. 27th Annual Int Conf Eng Med Biol Soc. 2005, 3: 2859-2862.Google Scholar
- Tharayil SM, Kalbfleisch T, Kumar A:Service-oriented laboratory information management system for life sciences research. IEEE International Conference on Services Computing. 2007, 621-627.View ArticleGoogle Scholar
- Sanchez-Villeda H, Schroeder S, Polacco M, McMullen M, Havermann S, Davis G, Vroh-Bi I, Cone K, Sharopova N, Yim Y, Schultz L, Duru N, Musket T, Houchins K, Fang Z, Gardiner J, Coe E:Development of an integrated laboratory information management system for the maize mapping project. Bioinformatics. 2003, 19 (16): 2022-2030.View ArticlePubMedGoogle Scholar
- Transgenic Software Inc.:Villager transgenic animal management system. [http://www.trademarkia.com/villager-transgenic-animal-management-system-78363691.html],
- Nieuwland J, Sornay E, Marchbank A, de Graaf BH, Murray JA:Phytotracker, an information management system for easy recording and tracking of plants, seeds and plasmids. Plant Methods. 2012, 8 (1): 43-PubMed CentralView ArticlePubMedGoogle Scholar
- Palla P, Frau G, Vargiu L, Rodriguez-Tomé P:QTreds: a flexible LIMS for omics laboratories. EMBnet.journal. 2012, 18 (B): 41-View ArticleGoogle Scholar
- Melo A, Faria-Campos A, DeLaat D, Keller R, Abreu V, Campos S:Sigla: an adaptable lims for multiple laboratories. BMC Genomics. 2010, 11 (Suppl 5): 8-View ArticleGoogle Scholar
- Workflow Management Coalition. [http://www.wfmc.org/],
- Wilkins MR, Arthur JW, Junius FK, Harrison MJ, Traini MD, Bizannes P, Doggett PE, McDonald W:Information management for proteomics: a perspective. Expert Rev Proteomics. 2008, 5 (5): 663-678.View ArticlePubMedGoogle Scholar
- Voegele C, Bouchereau B, Robinot N, McKay J, Damiecki P, Alteyrac L:A universal open-source electronic laboratory notebook. Bioinformatics. 2013, 29 (13): 1710-1712.View ArticlePubMedGoogle Scholar
- Fakas GJ, Nguyen AV, Gillet D:The electronic laboratory journal: a collaborative and cooperative learning environment for web-based experimentation. Comput Supported Cooperative Work (CSCW). 2005, 14 (3): 189-216.View ArticleGoogle Scholar
- Goddard NH, Macneil R, Ritchie J:eCAT: online electronic lab notebook for scientific research. Autom Exp. 2009, 1 (1): 4-PubMed CentralView ArticlePubMedGoogle Scholar
- Beato B, Pisek A, White J, Grever T, Engel B, Pugh M, Schneider M, Carel B, Branstrator L, Shoup R:Going paperless: implementing an electronic laboratory notebook in a bioanalytical laboratory. Bioanalysis. 2011, 3 (13): 1457-1470.View ArticlePubMedGoogle Scholar
- Walsh E, Cho I:Using Evernote as an electronic lab notebook in a translational science laboratory. J Lab Autom. 2013, 18 (3): 229-234.View ArticlePubMedGoogle Scholar
- Gelvin SB:Agrobacterium-mediated plant transformation: the biology behind the “gene-jockeying” tool. Microbiol Mol Biol Rev. 2003, 67 (1): 16-37.PubMed CentralView ArticlePubMedGoogle Scholar
- Santos PE:Boas Práticas de Laboratório (BPL), – Uma questão de qualidade. Revista Intertox de Toxicologia, Risco Ambiental e Sociedade. 2010, 3 (2): 37-39.Google Scholar
- Together Workflow Editor. [http://www.together.at/prod/workflow/twe],
- Frame BR, Shou H, Chikwamba RK, Zhang Z, Xiang C, Fonger TM, Pegg SE, Li B, Nettleton DS, Pei D, Wang K:Agrobacterium tumefaciens-mediated transformation of maize embryos using a standard binary vector system. Plant Physiol. 2002, 129 (1): 13-22.PubMed CentralView ArticlePubMedGoogle Scholar
- Vega JM, Yu W, Kennon AR, Chen X, Zhang ZJ:Improvement of Agrobacterium-mediated transformation in Hi-II maize (Zea mays) using standard binary vectors. Plant Cell Rep. 2008, 27 (2): 297-305.View ArticlePubMedGoogle Scholar
- Petrillo CP, Carneiro NP, Purcino AAC, Carvalho CHS, Alves JD, Carneiro AA:Optimization of particle bombardment parameters for the genetic transformation of Brazilian maize inbred lines. Pesquisa Agropecuária Brasileira. 2008, 43 (3): 371-378.View ArticleGoogle Scholar
This article is published under license to BioMed Central Ltd. This is an Open Access article distributed under the terms of the Creative Commons Attribution License (http://creativecommons.org/licenses/by/2.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly credited. The Creative Commons Public Domain Dedication waiver (http://creativecommons.org/publicdomain/zero/1.0/) applies to the data made available in this article, unless otherwise stated.