MAD: a suite of tools for microarray data management and processing

SUMMARY: Microarray data management and processing (MAD) is a set of Windows integrated software for microarray analysis. It consists of a relational database for data storage with many user-interfaces for data manipulation, several text file parsers and Microsoft Excel macros for automation of data processing, and a generator to produce text files that are ready for cluster analysis. AVAILABILITY: Executable is available free of charge on http://pompous.swmed.edu. The source code is also available upon request.     

GeneCruiser: a web service for the annotation of microarray data

SUMMARY: GeneCruiser is a web service allowing users to annotate their genomic data by mapping microarray feature identifiers to gene identifiers from databases, such as UniGene, while providing links to web resources, such as the UCSC Genome Browser. It relies on a regularly updated database that retrieves and indexes the mappings between microarray probes and genomic databases. Genes are identified using the Life Sciences Identifier standard. AVAILABILITY: GeneCruiser is freely available in the following forms: Web service and Web application, http://www.genecruiser.org; GenePattern, GeneCruiser access has been integrated into our microarray analysis platform, GenePattern. http://www.genepattern.org.     

KMD

The Keck Microarray Database (KMD) is a port of the ArrayExpress database from Oracle to the MySQL environment. The requirements for a locally available, open-source microarray database solution based on ArrayExpress are analysed in this article. The differences between the Oracle and MySQL environments are identified and the method to port to MySQL is described, providing a unified relational database management system (RDBMS) platform for both MIAMExpress and ArrayExpress. AVAILABILITY: The software and documentation are available from the Keck Graduate Institute of Applied Life Sciences website at http://public.kgi.edu/~jmainguy/applied-bioinformatics.htm.     

'Harvester': a fast meta search engine of human protein resources

SUMMARY: We have developed a Web-based tool named 'Harvester' that bulk-collects bioinformatic data on human proteins from various databases and prediction servers. The information on every single protein is assembled on a single HTML page as a combination of database screen-shots and plain text. A full text meta search engine, similar to Google trade mark, allows screening of the whole genome proteome for current protein functions and predictions in a few seconds. With Harvester it is now possible to compare and check the quality of different database entries and prediction algorithms on a single page. A feedback forum allows users to comment on Harvester and to report database inconsistencies. AVAILABILITY: The service is freely available to the academic community at http://harvester.embl.de.     

Olfactory receptor database: a sensory chemoreceptor resource

The Olfactory Receptor Database (ORDB) is a WWW-accessible database that has been expanded from an olfactory receptor resource to a chemoreceptor resource. It stores data on six classes of G-protein-coupled sensory chemoreceptors: (i) olfactory receptor-like proteins, (ii) vomeronasal receptors, (iii) insect olfactory receptors, (iv) worm chemo-receptors, (v) taste papilla receptors and (vi) fungal pheromone receptors. A complementary database of the ligands of these receptors (OdorDB) has been constructed and is publicly available in a pilot mode. The database schema of ORDB has been changed from traditional relational to EAV/CR (Entity-Attribute-Value with Classes and Relationships), which allows the interoperability of ORDB with other related databases as well as the creation of intra-database associations among objects. This inter-operability facilitates users to follow information from odor molecule binding to its putative receptor, to the properties of the neuron expressing the receptor, to a computational model of activity of olfactory bulb neurons. In addition, tools and resources have been added allowing users to access interactive phylogenetic trees and alignments of sensory chemoreceptors. ORDB is available via the WWW at http://ycmi.med. yale.edu/senselab/ordb/     

A deductive database system PACADE for analyzing 3-D and secondary structures of protein

We have developed a deductive database system PACADE for analyzing3-D and secondary structures of protein. The PA CADE systemconsists of a relational database created from Protein DataBank and a deductive engine DEE based on logic programming.It has the following features: (1) The system has an inferencemechanism. This means by which users can easily write and checkbiological hypotheses using logical and declarative rules insteadof procedural programs. (2) The relational database of the PACADE system stores data on bath 3-D and secondwy structuresof protein. The integration of this two level structure makesfeasible an abstract representation of the protein structure.We describe herein the design, functions, and implementationof this PACADE system.     

PACSY, a relational database management system for protein structure and chemical shift analysis

PACSY (Protein structure And Chemical Shift NMR spectroscopY) is a relational database management system that integrates information from the Protein Data Bank, the Biological Magnetic Resonance Data Bank, and the Structural Classification of Proteins database. PACSY provides three-dimensional coordinates and chemical shifts of atoms along with derived information such as torsion angles, solvent accessible surface areas, and hydrophobicity scales. PACSY consists of six relational table types linked to one another for coherence by key identification numbers. Database queries are enabled by advanced search functions supported by an RDBMS server such as MySQL or PostgreSQL. PACSY enables users to search for combinations of information from different database sources in support of their research. Two software packages, PACSY Maker for database creation and PACSY Analyzer for database analysis, are available from http://pacsy.nmrfam.wisc.edu.     

The MUSC DNA Microarray Database

SUMMARY: The Medical University of South Carolina (MUSC) DNA Microarray Database is a web-accessible archive of DNA microarray data. The database was developed using the DNA microarray project/data management system, micro ArrayDB. Annotations for each DNA microarray project and associated cRNA target information are stored in a MySQL relational database and linked to array hybridization data (raw and normalized). At the discretion of investigators, data are placed into the public domain where they can be interrogated and downloaded through a web browser. In addition to serving as an online resource of gene expression data, the MUSC DNA Microarray Database is a model for other academic DNA microarray data repositories. AVAILABILITY: Browsing and downloading of MUSC DNA Microarray Database information can be done after registration at http://proteogenomics.musc.edu/pss/home.php.     

PPMdb: a plant plasma membrane database

PPMdb is a proteome database dedicated to proteins from plant plasma membranes. It provides comprehensive two-dimensional polyacrylamide gel electrophoresis (2-D PAGE) maps, partial amino acid sequences and expression data. All this information is gathered and structured in a relational database, after being analyzed and annotated. PPMdb includes active links to related biological databases (EMBL, GenBank, GenPep, and SWISS-PROT and TrEMBL) as well as to MEDLINE abstracts. Information on specific protein spots can be displayed by clicking on the 2-D maps. In addition, users can query the database by accession number, protein name, pI and MW, and cellular location. Access to PPMdb is available at the following URL: http://sphinx.rug. ac.be:8080.     

Open source system for analyzing, validating, and storing protein identification data

This paper describes an open-source system for analyzing, storing, and validating proteomics information derived from tandem mass spectrometry. It is based on a combination of data analysis servers, a user interface, and a relational database. The database was designed to store the minimum amount of information necessary to search and retrieve data obtained from the publicly available data analysis servers. Collectively, this system was referred to as the Global Proteome Machine (GPM). The components of the system have been made available as open source development projects. A publicly available system has been established, comprised of a group of data analysis servers and one main database server.     

The ArrayExpress gene expression database: a software engineering and implementation perspective

MOTIVATION: The lack of microarray data management systems and databases is still one of the major problems faced by many life sciences laboratories. While developing the public repository for microarray data ArrayExpress we had to find novel solutions to many non-trivial software engineering problems. Our experience will be both relevant and useful for most bioinformaticians involved in developing information systems for a wide range of high-throughput technologies. RESULTS: ArrayExpress has been online since February 2002, growing exponentially to well over 10,000 hybridizations (as of September 2004). It has been demonstrated that our chosen design and implementation works for databases aimed at storage, access and sharing of high-throughput data. AVAILABILITY: The ArrayExpress database is available at http://www.ebi.ac.uk/arrayexpress/. The software is open source. CONTACT: ugis@ebi.ac.uk.     

USAGE: a web-based approach towards the analysis of SAGE data. Serial Analysis of Gene Expression

MOTIVATION: SAGE enables the determination of genome-wide mRNA expression profiles. A comprehensive analysis of SAGE data requires software, which integrates (statistical) data analysis methods with a database system. Furthermore, to facilitate data sharing between users, the application should reside on a central server and be accessed via the internet. Since such an application was not available we developed the USAGE package. RESULTS: USAGE is a web-based application that comprises an integrated set of tools, which offers many functions for analysing and comparing SAGE data. Additionally, USAGE includes a statistical method for the planning of new SAGE experiments. USAGE is available in a multi-user environment giving users the option of sharing data. USAGE is interfaced to a relational database to store data and analysis results. The USAGE query editor allows the composition of queries for searching this database. Several database functions have been included which enable the selection and combination of data. USAGE provides the biologist increased functionality and flexibility for analysing SAGE data. AVAILABILITY: USAGE is freely accessible for academic institutions at http://www.cmbi.kun.nl/usage/. The source code of USAGE is freely available for academic institutions on request from the first author.