Towards the integration of mouse databases - definition and implementation of solutions to two use-cases in mouse functional genomics
© Gruenberger et al; licensee BioMed Central Ltd. 2010
Received: 17 November 2009
Accepted: 22 January 2010
Published: 22 January 2010
The integration of information present in many disparate biological databases represents a major challenge in biomedical research. To define the problems and needs, and to explore strategies for database integration in mouse functional genomics, we consulted the biologist user community and implemented solutions to two user-defined use-cases.
We organised workshops, meetings and used a questionnaire to identify the needs of biologist database users in mouse functional genomics. As a result, two use-cases were developed that can be used to drive future designs or extensions of mouse databases. Here, we present the use-cases and describe some initial computational solutions for them. The application for the gene-centric use-case, "MUSIG-Gen" starts from a list of gene names and collects a wide range of data types from several distributed databases in a "shopping cart"-like manner. The iterative user-driven approach is a response to strongly articulated requests from users, especially those without computational biology backgrounds. The application for the phenotype-centric use-case, "MUSIG-Phen", is based on a similar concept and starting from phenotype descriptions retrieves information for associated genes.
The use-cases created, and their prototype software implementations should help to better define biologists' needs for database integration and may serve as a starting point for future bioinformatics solutions aimed at end-user biologists.
At present, we are just beginning to appreciate the complexity of genotype-phenotype association in humans, but more detailed and comprehensive analyses in basic research are urgently needed. Although studies in humans are important, they are limited because of the size of cohorts, strong but often unknown environmental influences, poor and inconsistently coded diagnosis, and lack of repeatability. Therefore, animal models are absolutely essential to complement human studies; they allow the investigation of underlying biological mechanisms in well-controlled experimental systems.
In particular, the mouse is an ideal model system for studying genetic factors that contribute to diseases because genetic reference populations (GRPs) with a large number of allelic variants in many genes, combinations thereof, and many knock-out mouse lines with deletions in single genes are available . Research on mouse model systems has generated valuable discoveries for our understanding of the biological mechanisms of the normal function of the immune system as well as immune abnormalities, cardiovascular diseases, cancer, and infectious diseases .
Consequently, funding agencies around the world have supported an increasing number of functional genomics projects focused on the use of the laboratory mouse as a model for human disease. The results obtained have been collected in various databases. However, in most cases, these databases represent single project outputs and are maintained at different sites. Exceptions are, for example, the mouse genome database (MGD) database of MGI , the mouse phenome database (MPD) , Europhenome  and the GeneNetwork database , which have collected information from many different sources. MGD is a database which has been optimized for researchers in the field of mouse functional genetics and genomics. It is constantly updated and manually curated and thus contains information of extremely high quality. Similarly, the GeneNetwork database contains phenotype and genotype information on mouse GRPs from the literature and directly entered source data, as well as tools to map quantitative trait loci. Both databases are extensively linked to other informatics resources.
However, there is a large volume of data in distributed databases that is not contained in MGI (Mouse Genome Informatics) or GeneNetwork and which are important for functional genomics studies (see the Mouse Resource Browser MRB ). Ad-hoc integration of these databases is very difficult. Many databases require a separate login procedure and need to be accessed using different methods (e.g. via a website, downloadable files or web services). Several resources do not adopt common standards e.g. using the same identifier for a given gene or protein . In this case, a user may need to convert their gene identifiers to whatever the particular resource understands, e.g. MGI or Ensembl/mouse IDs, before starting a search.
As a first step towards new concepts for database integration, we have established a network of scientists from Europe, North America, Japan and Australia. The network is funded as a Coordination Action by the European Commission and called CASIMIR (Coordination and Sustainability of International Mouse Informatics Resources) . The Coordination Action is aimed at recommending standards to allow data sharing and integration between different projects.
Much can already be achieved using query tools that ease selection and joining of distributed data, such as BioMart , and/or workflow tools that support stepwise data retrieval, conversion and integration, such as Taverna  and Galaxy . A prerequisite is that sources provide programmatic interfaces for queries or workflow tools that can be used to access or import the original data. However, such interfaces are often not available. This challenge was addressed by Smedley et al. who federated BioMart and MOLGENIS [13, 14] in a Taverna workflow . But these solutions are still too involved for many bench biologists to use directly for their research. Task-oriented user interfaces are needed on top of all these tools to more closely support biologists in their integrative analyses.
In order to gather the perspective of the end-users, the biologists, who will perform the actual data mining we designed use-cases together with biologists. Subsequently, two software implementations were developed on the basis of these use-cases to provide tools which could carry out the tasks requested by the users in the most practical format. Here, we describe two use-cases that arose as a result of our discussions with biologist-users during workshops, meetings and via a questionnaire. Furthermore, we demonstrate the first steps towards their implementation.
Methods and Results
Definition of the use-cases
During the first sessions with different user groups, some principle needs for data mining became apparent. These needs were further confirmed in subsequent meetings and demonstrations of development steps to biologist users. A user-friendly interface should not only query multiple databases but also allow for multiple search terms, allow iterative interactions, and contain a tool that allows storage of the results. Furthermore, most of the currently performed data mining in functional mouse genomics concerns genes, their functions and variants on one side; and phenotype descriptions on the other side. Based on these discussions, we designed two generic use-cases that should be suitable to a larger scientific community: a gene-centric and a phenotype-centric use-case.
The advent of high-throughput technologies in biology, such as gene expression microarrays, makes it now possible to identify, with the help of statistical and bioinformatics tools, large groups of candidate genes changing their expression levels in different experimental conditions. However, of the genes identified in this way, usually a few hundred, only a limited number of genes (in the order of 20-50) can feasibly be studied experimentally in the laboratory. Therefore, researchers prioritize the gene lists based on their own knowledge, literature, and additional information from many different web accessible databases, such as gene and protein descriptions, genetic diversity information, expression patterns in different tissues, etc. Since the searching of all these web databases by hand is very laborious and time-consuming, our user groups decided to describe a gene-centric use-case starting with an input of a limited number of gene names and aiming to facilitate easy and automatic collection of information about these genes from different sources. This process should be performed in an interactive fashion and allow storage and export of the results obtained.
Following the above principle, the integration of mouse databases via a gene-centric use-case should allow candidate gene symbols to be entered into a query form which then automatically collects basic information like synonyms, gene IDs, descriptions and genome locations for the entries (Fig. 1). Based on this information the user will then be able to refine the gene hit list by selecting the interesting genes and removing false hits. The final list will then be saved as a 'shopping cart' which can be revisited, modified, refined or extended. Finally, it should be possible to export the gene list in Excel-readable CSV format (Fig. 1).
A difficulty often encountered when performing analyses on genes, is that they have several synonyms and that in many scientific publications the systematic gene nomenclature is not followed (see ). Examples are RANTES (correct gene symbol Ccl5), MIP1a (Ccl3) and IP-10 (Cxcl10). For other genes, it may be not known to the researcher that they represent members of large gene families, and one has to choose one or all to proceed with the analysis. Examples are Hox, Fgf, Inhibin, and interferon genes. Here, we consider as the "correct gene name" the name which is given by the international nomenclature committees: Mouse (International Committee on Standardized Genetic Nomenclature for Mice ), human (HUGO Gene Nomenclature Committee ), and rat (Rat Gene Nomenclature Committee ).
It is thus important that the use-case allows entering any gene name, synonyms, incomplete names, etc., but still makes sure that the correct genes will be found. For this, entries will be searched in a first step against the MGI database for disambiguation . For each gene name multiple hits may appear and the user is then able to select the correct ones and add them to the cart.
In a second step, it is possible to collect additional information from different databases for the genes in the cart list. Examples of databases are MGI and ENSEMBL/mouse for information on gene structure and links to other resources; Eurexpress , SymAtlas  and ArrayExpress  for gene expression information; and INTACT  for gene interaction data. After retrieval of this information the user may refine his gene list in a given cart by searching for other genes or deleting genes in the current list.
The list of collected genes in a shopping cart can then be used to perform meta-analyses. For example, an analysis of GO-terms will allow finding out if certain GO-categories are over-represented in the particular gene list, indicating that the genes may belong to a specific pathway or biological process. Similarly, an analysis of expression patterns may reveal if there is a certain tissue in which the genes from the list are preferentially expressed.
At present, only few of the currently existing databases offer some of the above-described functionalities, the most comprehensive one being MGI. And thus far, only BioMart represents an initiative which aims to allow the user to design queries on information from otherwise disparate databases. Also, BioMart allows refining searches and filtering out relevant information. However, Biomart is currently aimed at the advanced and trained user and is not yet designed for simple querying and collection of results in a shopping cart to which new genes and information can be added.
At present, the most extensive and well structured phenotype ontology for the mouse is the Mammalian Phenotype (MP) ontology , accessible at MGI. MP is therefore used as a first standard which will allow querying MGI but also other databases that are using MP terms for phenotype descriptions, like EuroPhenome .
In the future, cross-referencing mouse MP terms with ontologies that describe diseases (such as the Disease Ontology - DO ) and phenotypes in humans (such as the Human Phenotype Ontology HPO  and Mouse Pathology Ontology MPATH ) should allow users to make cross-species searches by starting from phenotype descriptions. This will be particularly useful for human clinician researchers who are not familiar with mouse databases but who would like to know if there is a mouse model available for a given human disease.
The results from the phenotype-driven searches should then be linked to gene names associated with a given phenotype. These genes are presented as a list from which the user can choose the genes of interest and save them in a shopping cart. It is then possible to feed the genes into the gene-centric use-case and perform a more detailed data mining or meta-analysis.
The description and further development of the phenotype-driven use-case may represent a very useful concept for scientists and clinicians outside the mouse community. For example the Human Phenotype Ontology HPO is based on OMIM  and a search may be generated using HPO as a starting point to retrieve disease ID's from OMIM which can then be linked to gene symbols. The Drosophilia phenotype ontology  developed by the Flybase group could be used to retrieve gene symbols and thereby gene function information from Flybase . Or the C. elegans phenotype ontology  could be used to retrieve gene symbols from Wormbase . Gene symbols retrieved from these databases could then be stored in a shopping cart.
Implementation of the use-cases: MUSIG-Gen and MUSIG-Phen
Web services for database integration
A prerequisite for computer-supported data integration is programmatic access to select and retrieve data from distributed resources. As described by  there are several possible technical solutions to integrate data from different mouse informatics databases. The "CASIMIR strategy" is based on semantic standardization or wrapping of information transferred by web services. Currently the most popular implementations of web services use the SOAP/WSDL or the XML-REST protocols. The advantages of opening APIs and transferring information using XML schemas are discussed in .
For Europhenome and Mugen  SOAP/WSDL web services were available which could be used for MUSIG-Phen, and we set up a BioMart web service for part of the MGI data. Other databases such as the Ontology Lookup Service (OLS ) for ontology data and INTACT already had web services.
Users may want to integrate their local database or other databases. To demonstrate how this can be achieved, we generated web services for accessing GNF SymAtlas expression data. For this, we first saved the SymAtlas data locally. We then defined the Entrez Gene ID's as a common field which could be retrieved from the MGI Biomart and matched to the records in the local SymAtlas database. We then used MOLGENIS to create the relevant SOAP web services to retrieve the data from the local database, to subsequently load and display them in the shopping cart interface.
Implementation of MUSIG-Gen
After having defined the use-cases we wanted to provide users and developers with a first implementation which may then be tested and further revised in the future. Thus, certain parts of the use-case scheme outlined in Fig. 1 were implemented in the application MUSIG-Gen http://www.casimir.org.uk/usecase1/. In the following, we describe this tool from the perspective of the scientific user.
New genes can be easily added to an existing cart by calling up the entry form from within a cart and follow the same procedure as described above.
As a final step, we added an export function to the shopping cart which allows the user to export his data in CSV format and then perform highly customized analysis locally.
Technical aspects of the implementation of MUSIG-Gen
The shopping cart system uses a Postgresql database to store user data. The data stored comprises the user's personal data (which is integrated into our web site management system to allow for a single login system) as well as the data retrieved from the different web services. The system imposes no limits as to how many data fields or data values a user can download and store in his shopping carts.
The application initially retrieves gene nomenclature and genome location data based on gene symbol: By default, nomenclature and genome location data is loaded from our MGI BioMart http://www.casimir.org.uk/biomart/martview/. Other data from the MGI BioMart can also be loaded, such as MGI, Ensembl, EntrezGene IDs as well as GO and MP ontologies. The Ensembl BioMart can also be queried at this stage for Uniprot IDs. Both BioMarts are accessed using the default BioMart XML-REST services. For this, we developed and used a generic BioMart XML-REST PHP client class which can be used to query any BioMarts.
Data may also be loaded from the Eurexpress BioMart or from the GNF and INTACT SOAP web services (using generic PHP SOAP libraries). There are also some fields which have the option of loading additional information, e.g. the GO and MP ID fields. The user can choose to load the ontology term names which are loaded from the OLS SOAP web service.
The source code and documentation for the MUSIG-Gen prototype may be downloaded form the following web server: http://www.casimir.org.uk/sourcecode/
Implementation of MUSIG-Phen
Based on the scheme outlined in Fig. 7, certain parts of the phenotype-centric use-case were implemented in the application MUSIG-Phen http://www.casimir.org.uk/usecase2/. The MUSIG-Phen prototype starts from a phenotype description, collects the genes associated with this phenotype in a cart and then performs all the analyses described above for MUSIG-Gen.
At this stage, the implementation is very similar to the services already provided by MGI. Thus, in addition to the current MGI search options, we implemented the possibility to query other external databases which contain phenotype descriptions based on MP terms. We demonstrated feasibility of this feature for searches of the Mugen and Europhenome databases.
At the present state, the MUSIG-Phen software was not designed for more sophisticated queries, because discussions with users revealed that further detailed queries very soon become highly specialized and complex for certain user subgroups. However, the present use-case implementation may already serve to query nascent databases (e.g. phenotype data from EUMODIC) and represents a very useful platform to test new developments which aim to connect mouse and human phenotype databases.
Technical aspects of the implementation of MUSIG-Phen
The implementation of the phenotype-centric use-case uses three SOAP/WSDL web services and our MGI BioMart web service: Initially the Mammalian Phenotype (MP) ontology is loaded from the OLS web service. The user-selected MP term is sent as query input to the MGI, EuroPhenome and MUGEN web services and matching gene symbols are returned. Gene symbols can then be selected and sent to the gene-centric use-case shopping cart.
Basic information about web services, such as type (for example BioMart or SOAP) and location URL is currently stored in a separate table. However, a larger web service catalogue such as BioMoby , Biocatalogue  or the mouse-centric MRB could easily be integrated and used to create a wider array of services. These services could also be linked to create a Taverna-like workflow tool which automatically matches IDs and fields from different services. The current limitation to this approach is the lack of standardization across databases and web services with respect to the use of ontologies and the naming of web service fields. For example a field for MGI gene IDs could be called mgi_id, gene_id, MGIGeneId etc. which would make automatic matching impossible. We therefore favor the idea to develop a web service field ontology which should be integrated into MRB or Biocatalogue to provide a look-up service for field names. Currently developments are ongoing within the Biocatalogue project to create a web service ontology to which web service developers annotate their fields which may provide a suitable solution to this problem.
The source code and documentation for the MUSIG-Phen prototype may be downloaded form the following web server: http://www.casimir.org.uk/sourcecode/
Discussion and Conclusion
The aim of generating the MUSIG-Gen and MUSIG-Phen applications was to provide a first set of solutions to user-defined use-cases and thereby generate a test environment for a fully distributed integration strategy. We also presented the applications to various user groups and collected their feed-back. All users appreciated the tools which were able to integrate data from several databases, and they especially liked the principle of the shopping cart. An additional, often mentioned suggestion was to link the genes in MUSIG-Gen to mouse mutants and phenotypes as well as gene expression information. We are planning to add these functionalities to future prototypes.
Our plan for a third use-case is to define the needs for an integration of mouse and human functional genomics databases. Here, we believe that the phenotype-centric use case may serve as a valuable basis to provide an entry point for clinical researchers. The concept would be to enter descriptions of human disease phenotypes as queries and to obtain mouse phenotype descriptions which relate to these terms. However, for such a query, it will first be necessary to relate the human phenotype descriptions with MP terms or with more detailed EQ-based phenotype descriptions.
We thank George Gkoutos for helpful discussions on the technical developments of the use cases and all the members of the international advisory board of the CASIMIR consortium http://www.casimir.org.uk/ for their helpful comments and support.
This work was supported by the Commission of the European Community, Framework Programme 6 contract no. LSHG-CT-2006-037811, NWO Rubicon, grant 825.09.008, CASIMIR and the HZI program Infection & Immunity.
- Peters LL, Robledo RF, Bult CJ, Churchill GA, Paigen BJ, Svenson KL: The mouse as a model for human biology: a resource guide for complex trait analysis. Nat Rev Genet. 2007, 8: 58-69.PubMedView Article
- Rosenthal N, Brown S: The mouse ascending: perspectives for human-disease models. Nat Cell Biol. 2007, 9: 993-9.PubMedView Article
- Bult CJ, Eppig JT, Kadin JA, Richardson JE, Blake JA: The Mouse Genome Database (MGD): mouse biology and model systems. Nucl Acids Res. 2008, 36: D724-8.PubMed CentralPubMedView Article
- Bogue MA, Grubb SC, Maddatu TP, Bult CJ: Mouse Phenome Database (MPD). Nucl Acids Res. 2007, 35: D643-9.PubMed CentralPubMedView Article
- Mallon AM, Blake A, Hancock JM: EuroPhenome and EMPReSS: online mouse phenotyping resource. Nucl Acids Res. 2008, 36: D715-8.PubMed CentralPubMedView Article
- Wang J, Williams RW, Manly KF: WebQTL: Web-based complex trait analysis. Neuroinformatics. 2003, 1: 299-308.PubMedView Article
- Zouberakis M, Chandras C, Hancock JM, Schofield PN, Aidinis V: The Mouse Resource Browser (MRB) - A near-complete registry of mouse resources. BioInformatics and BioEngineering. BIBE 2008. 8th IEEE International Conference on (2008). 2008, 1-5.View Article
- Hancock J, Chandras C, Zouberakis M, Aidinis V, Schofield PN: Integrating information from EU-funded mouse functional genomics projects: a questionnaire-based analysis. BioInformatics and BioEngineering. BIBE 2008. 8th IEEE International Conference on (2008). 2008, 1-5.View Article
- Hancock J, Schofield PN, Chandras C, Zouberakis M, Aidinis V, Smedley D, Rosenthal N, Schughart K: CASIMIR: Coordination and Sustainability of International Mouse Informatics Resources. BioInformatics and BioEngineering. BIBE 2008. 8th IEEE International Conference on (2008). 2008, 1-5.View Article
- Smedley D, Haider S, Ballester B, Holland R, London D, Thorisson G, Kasprzyk A: Bio-Mart--biological queries made easy. BMC Genomics. 2009, 10: 22-PubMed CentralPubMedView Article
- Hull D, Wolstencroft K, Stevens R, Goble C, Pocock MR, Li P, Oinn T: Taverna: a tool for building and running workflows of services. Nucl Acids Res. 2006, W729-32. 34 Web Server
- Galaxy. [http://galaxy.psu.edu/]
- Swertz MA, De Brock EO, Van Hijum SA, De Jong A, Buist G, Baerends RJ, Kok J, Kuipers OP, Jansen RC: Molecular Genetics Information System (MOLGENIS): alternatives in developing local experimental genomics databases. Bioinformatics. 2004, 20: 2075-83.PubMedView Article
- Swertz MA, Jansen RC: Beyond standardization: dynamic software infrastructures for systems biology. Nat Rev Genet. 2007, 8: 235-43.PubMedView Article
- Smedley D, Swertz MA, Wolstencroft K, Proctor G, Zouberakis M, Bard J, Hancock JM, Schofield P: Solutions for data integration in functional genomics: a critical assessment and case study. Brief Bioinform. 2008, 9: 532-44.PubMedView Article
- Sundberg J, Schofield P: A mouse by any other name. Journal of Investigative Dermatology. 2009, 129: 1599-1601.PubMed CentralPubMedView Article
- Guidelines for Nomenclature of Mouse and Rat Strains. [http://www.informatics.jax.org/mgihome/nomen/strains.shtml]
- HUGO Gene Nomenclature Committee. [http://www.genenames.org/]
- Rat Genome and Nomenclature Committee. [http://ratmap.gen.gu.se/RGNC/]
- Eppig JT, Blake JA, Bult CJ, Richardson JE, Kadin JA, Ringwald M: Mouse genome informatics (MGI) resources for pathology and toxicology. Toxicol Pathol. 2007, 35: 456-7.PubMedView Article
- Eurexpress. [http://www.eurexpress.org/ee/]
- BioGPS. [http://biogps.gnf.org/?referer=symatlas#goto=welcome]
- Parkinson : ArrayExpress update--from an archive of functional genomics experiments to the atlas of gene expression. Nucleic Acids Res. 2009, D868-72. 37 Database
- Hermjakob H: IntAct - an open source molecular interaction database. Nucl Acids Res. 2004, 32: D452-D455.PubMed CentralPubMedView Article
- Smith CL, Goldsmith CA, Eppig JT: The Mammalian Phenotype Ontology as a tool for annotating, analyzing and comparing phenotypic information. Genome Biol. 2005, 6: R7-PubMed CentralPubMedView Article
- Eumodic. [http://www.eumodic.org/aboutus.html]
- Disease Ontology. [http://diseaseontology.sourceforge.net/]
- Robinson PN, Kohler S, Bauer S, Seelow D, Horn D, Mundlos S: The Human Phenotype Ontology: a tool for annotating and analyzing human hereditary disease. Am J Hum Genet. 2008, 83: 610-5.PubMed CentralPubMedView Article
- Schofield : Pathbase: a database of mutant mouse pathology. Nucl Acids Res. 2004, D512-5.
- Online Mendelian Inheritance in Man, OMIM (TM). 2009, McKusick-Nathans Institute of Genetic Medicine, Johns Hopkins University (Baltimore, MD) and National Center for Biotechnology Information, National Library of Medicine (Bethesda, MD), [http://www.ncbi.nlm.nih.gov/omim/]
- Fly phenotype ontology. [http://subversion.flymine.org/tags/flymine_release_2_1/flymine/model/phenotype/phenotype.ontology]
- Tweedie S: FlyBase: enhancing Drosophila Gene Ontology annotations. Nucl Acids Res. 2009, 37: D555-D559.PubMed CentralPubMedView Article
- C. elegans phenotype ontology. [http://www.obofoundry.org/cgi-bin/detail.cgi?id=worm_phenotype]
- Tamberlyn Bieri: WormBase: new content and better access. Nucl Acids Res. 2007, 35: D506-10.View Article
- Aidinis V: MUGEN mouse database; animal models of human immunological diseases. Nucl Acids Res. 2008, D1048-54.
- Cote RG, Jones P, Apweiler R, Hermjakob H: The ontology lookup service, a lightweight cross-platform tool for controlled vocabulary queries. BMC Bioinformatics. 2006, 7: 97-PubMed CentralPubMedView Article
- HTML-AJAX. [http://pear.php.net/package/HTML_AJAX]
- Wilkinson MD, Links M: BioMOBY: an open source biological web services proposal. Brief Bioinform. 2002, 331-41.
- Goble CA, Stevens RD, Hull D, Wolstencroft K, Lopez R: Data Curation + Process Curation = Data Integration + Science. Brief Bioinform. 2008, 9: 506-517.PubMedView Article
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 cited.