solanaceae , the nightshade family , as a group represents the third most valuable crop family in the us , exceeded only by the grasses and legumes , and the most valuable family in terms of vegetable crops providing important dietary contributions to human health and nutrition .
tomato ( solanum lycopersicum  until recently termed lycopersicon esculentum ) is the centerpiece system for genetic and molecular research in this family , and has recently been targeted for genome sequencing by an international consortium currently funded and supported by ten contributing countries ( 1 ) .
tomato has long served as an important model system for fleshy fruit development and ripening , more general plant genetics , disease response and numerous aspects of physiology , resulting in the accumulation of substantial information regarding the biology of this economically important organism .
recently , a large tomato est collection has been created which contains > 150  000 individual est sequences representing 30  000 unigenes from 27 different tissues / treatments ( 2 ) . a public cdna microarray with 12  000 elements representing 8700 unigenes has been developed based on this est collection and is widely used by the solanaceae research community ( ) .
large amounts of gene expression data are being generated using the public array , and it is important to have a systematic approach to archive this information and make it publicly available to derive maximum benefit from the numerous research efforts employing this tool .
our groups have also generated extensive time - course expression profiling data during fruit development and ripening in a normal tomato cultivar and well - defined ripening - related mutants ( 3 ) .
in addition , digital expression ( est abundance ) data from the analysis of the full tomato est collection has been created and is most effectively utilized through an interactive web - based data server ( 2 ) . in order to ( i ) provide a central repository for all gene expression data derived from the tomato microarray , ( ii ) disseminate public expression profiling data during normal and mutant fruit development and ripening , and ( iii ) present digital expression data for all available tissues and treatments represented in public est collections , we have generated display , query and analysis tools to assist in development and testing of biological hypotheses based on tomato gene expression data . to this end
, we have built an interactive online database  tomato expression database ( ted ) which can be accessed at .
ted is implemented as a 3-tier software architecture consisting of a web interface , a cgi middle tier which dynamically constructs and executes queries , and a relational database .
it operates on a red hat linux system under an apache web server , and uses mysql as the database management system .
cgi scripts connecting user queries to the database are implemented in perl , in conjunction with the dbi module that allows the scripts to connect to the back - end database .
basic statistical calculations are implemented as r or in - house perl scripts , while some time - consuming calculations , such as clustering algorithms , are implemented in c or by wrapping existing third - party tools .
ted includes the following three integrated components : the tomato microarray data warehouse , the tomato microarray expression database and the tomato digital expression database .
these three components serve different purposes , however they are tightly linked to each other through key gene identifiers [ e.g. clone identifier , tigr tentative consensus ( tc ) number ] and allow fluid passage among databases as required by the user . for example , a user querying the tomato microarray expression database for genes displaying a requested fruit development expression profile , can readily view digital expression data from a broader collection of tissues for any genes resulting from the initial query . similar to many other species - specific microarray databases , such as nascarrays ( 4 ) , sgmd ( 5 ) and barleybase ( 6 ) , the primary purpose of the tomato microarray data warehouse is to provide public storage / retrieval of raw microarray data and associated experiment information resulting from use of the publicly available tomato microarrays .
the database follows miame ( minimum information about microarray experiment ) guidelines thus facilitating the interpretation of results of a given experiment unambiguously and further allows independent verification and reproduction of the experimental findings ( 7 ) . to allow researchers to completely re - analyze published results and to facilitate further discovery , raw images and data files associated with each experiment are readily accessible in zipped format
however , some datasets are password protected prior to publication or upon authors ' request .
in addition to the data retrieval interface , a simple user - friendly , forms - based online data submission system was developed to facilitate the submission process .
once the data is submitted , instead of uploading it directly into the database , our staff will examine its compliance with miame standards and obtain from the authors any missing or improperly formatted information prior to uploading it to the database .
fruit is a major component of human nutrition contributing a significant portion of vitamins , minerals and fiber in a healthy diet .
the ripening of fleshy fruit is a coordinated regulatory process involving genetic , hormonal and environmentally controlled interactions leading to complex gene expression patterns ( 8) . in order to gain insights into the molecular basis of fruit development and dissect the regulatory network governing fruit ripening , we performed global expression profiling analysis during fruit development and ripening of tomato and various single mutant gene lines ( 3 ) .
currently , normalized and processed microarray data for ten time points with nine pair - wise comparisons during wild - type fruit development and ripening , and during development of an ethylene - insensitive , ripening impaired mutant ( never - ripe ; nr ) ( 9 ) , is included in this database .
in addition , dna sequence information of each est element on the tomato array is included as is corresponding annotation information that was developed for each array unigene sequence .
a number of useful query interfaces and data mining , analysis and visualization tools have been developed .
the annotation and sequence information in addition to the expression data can be retrieved for any specific est through the conventional gene identifier query or in batch using the corresponding data mining tools .
sequence similarity searches against all est sequences on the tomato array are also available through the blast ( 10 ) search interface .
in addition , data for a group of genes can be retrieved by using key word(s ) to query est functional annotations .
the said annotations are based on the annotations of sgn ( ) ( 11 ) unigenes to which corresponding ests belong .
ests that display simple or complex query patterns of interest can also be retrieved and the normalized ratios and p - values of each hybridization can be sorted .
tools to find genes with similar or inverse expression patterns to a given est and to compare expression profiles during fruit development for genes of interest in normal and mutant genotypes were also developed ( figure 1 ) .
both tools employ the pearson correlation coefficient to measure similarity of expression profiles . since the tomato microarray has occurrences of different ests corresponding to the same gene ( i.e. pseudo - replicates ) , we developed a tool to display expression profiles of all the pseudo - replicates representing one particular gene ( figure 2 ) .
while the majority of pseudo - replicates yield similar results and serve as a form of validation of the expression profiling results , infrequent instances where they do not yield the same expression profiles do occur and are discussed in alba et al .
in order to identify functionally related genes based on their expression profiles , we adapted several commonly used clustering programs .
linux version of cluster 3.0 ( 13 ) was wrapped for our hierarchical clustering algorithm .
the applet version of java treeview ( 14 ) and slcview ( ) were used to visualize the hierarchical clustering results in interactive and static mode , respectively .
perl module algorithm::cluster was used to implement k - means and som ( self - organizing maps ) clustering algorithms , and in - house cgi scripts were developed to visualize k - means and som results .
genes within each cluster generated from k - means and som can be further viewed in a heatmap ( figure 3b ) which is generated using matrix2png program ( 15 ) or in a table ( figure 3c ) .
it has been shown previously that est databases are a valid and reliable source of gene expression data ( 16 ) .
we analyzed a large tomato est dataset including > 150  000 ests derived from 27 different non - normalized cdna libraries to gain insights into differential expression among diverse plant tissues representing a range of developmental programs and biological responses ( 2 ) .
the resulting raw digital expression data for > 15  000 unigenes ( tigr tcs ) and normalized digital expression data for > 6000 tcs were included in this database ( 2 ) .
the raw and normalized digital expression data can be retrieved and visualized through gene identifier ( tc number ) queries .
an example of the visualization of normalized digital expression data is shown in figure 4 .
the returned page provides a link to the expression profile data during fruit development and ripening for the queried tc so that the digital expression profile and microarray expression profile of the same gene can be compared .
similar tools as those found in the tomato microarray expression database for blast searching against the whole unigene collection are included as are key word(s ) search functions .
in addition , we implemented online tools to ( i ) identify differentially expression genes between any two query tissues for which data is available ( 17 ) , ( ii ) identify highly abundant genes in a specific tissue , and ( iii ) compare digital gene expression among tomato and arabidopsis homologues .
furthermore , the raw and normalized digital gene expression data and corresponding analysis results ( e.g. tables of differentially expressed and tissue - specific genes ) from fei et al .
( 2 ) are publicly available through the database to all researchers for independent analysis .
similar to many other species - specific microarray databases , such as nascarrays ( 4 ) , sgmd ( 5 ) and barleybase ( 6 ) , the primary purpose of the tomato microarray data warehouse is to provide public storage / retrieval of raw microarray data and associated experiment information resulting from use of the publicly available tomato microarrays .
the database follows miame ( minimum information about microarray experiment ) guidelines thus facilitating the interpretation of results of a given experiment unambiguously and further allows independent verification and reproduction of the experimental findings ( 7 ) . to allow researchers to completely re - analyze published results and to facilitate further discovery , raw images and data files associated with each experiment are readily accessible in zipped format
however , some datasets are password protected prior to publication or upon authors ' request .
in addition to the data retrieval interface , a simple user - friendly , forms - based online data submission system was developed to facilitate the submission process .
once the data is submitted , instead of uploading it directly into the database , our staff will examine its compliance with miame standards and obtain from the authors any missing or improperly formatted information prior to uploading it to the database .
fruit is a major component of human nutrition contributing a significant portion of vitamins , minerals and fiber in a healthy diet .
the ripening of fleshy fruit is a coordinated regulatory process involving genetic , hormonal and environmentally controlled interactions leading to complex gene expression patterns ( 8) . in order to gain insights into the molecular basis of fruit development and dissect the regulatory network governing fruit ripening , we performed global expression profiling analysis during fruit development and ripening of tomato and various single mutant gene lines ( 3 ) .
currently , normalized and processed microarray data for ten time points with nine pair - wise comparisons during wild - type fruit development and ripening , and during development of an ethylene - insensitive , ripening impaired mutant ( never - ripe ; nr ) ( 9 ) , is included in this database .
in addition , dna sequence information of each est element on the tomato array is included as is corresponding annotation information that was developed for each array unigene sequence .
a number of useful query interfaces and data mining , analysis and visualization tools have been developed .
the annotation and sequence information in addition to the expression data can be retrieved for any specific est through the conventional gene identifier query or in batch using the corresponding data mining tools .
sequence similarity searches against all est sequences on the tomato array are also available through the blast ( 10 ) search interface . in addition , data for a group of genes can be retrieved by using key word(s ) to query est functional annotations .
the said annotations are based on the annotations of sgn ( ) ( 11 ) unigenes to which corresponding ests belong .
ests that display simple or complex query patterns of interest can also be retrieved and the normalized ratios and p - values of each hybridization can be sorted .
tools to find genes with similar or inverse expression patterns to a given est and to compare expression profiles during fruit development for genes of interest in normal and mutant genotypes were also developed ( figure 1 ) .
both tools employ the pearson correlation coefficient to measure similarity of expression profiles . since the tomato microarray has occurrences of different ests corresponding to the same gene ( i.e. pseudo - replicates ) , we developed a tool to display expression profiles of all the pseudo - replicates representing one particular gene ( figure 2 ) . while the majority of pseudo - replicates yield similar results and serve as a form of validation of the expression profiling results , infrequent instances where they do not yield the same expression profiles do occur and are discussed in alba et al .
in order to identify functionally related genes based on their expression profiles , we adapted several commonly used clustering programs .
linux version of cluster 3.0 ( 13 ) was wrapped for our hierarchical clustering algorithm .
the applet version of java treeview ( 14 ) and slcview ( ) were used to visualize the hierarchical clustering results in interactive and static mode , respectively .
perl module algorithm::cluster was used to implement k - means and som ( self - organizing maps ) clustering algorithms , and in - house cgi scripts were developed to visualize k - means and som results .
genes within each cluster generated from k - means and som can be further viewed in a heatmap ( figure 3b ) which is generated using matrix2png program ( 15 ) or in a table ( figure 3c ) .
it has been shown previously that est databases are a valid and reliable source of gene expression data ( 16 ) .
we analyzed a large tomato est dataset including > 150  000 ests derived from 27 different non - normalized cdna libraries to gain insights into differential expression among diverse plant tissues representing a range of developmental programs and biological responses ( 2 ) .
the resulting raw digital expression data for > 15  000 unigenes ( tigr tcs ) and normalized digital expression data for > 6000 tcs were included in this database ( 2 ) .
the raw and normalized digital expression data can be retrieved and visualized through gene identifier ( tc number ) queries .
an example of the visualization of normalized digital expression data is shown in figure 4 .
the returned page provides a link to the expression profile data during fruit development and ripening for the queried tc so that the digital expression profile and microarray expression profile of the same gene can be compared .
similar tools as those found in the tomato microarray expression database for blast searching against the whole unigene collection are included as are key word(s ) search functions .
in addition , we implemented online tools to ( i ) identify differentially expression genes between any two query tissues for which data is available ( 17 ) , ( ii ) identify highly abundant genes in a specific tissue , and ( iii ) compare digital gene expression among tomato and arabidopsis homologues .
furthermore , the raw and normalized digital gene expression data and corresponding analysis results ( e.g. tables of differentially expressed and tissue - specific genes ) from fei et al .
( 2 ) are publicly available through the database to all researchers for independent analysis .
we plan to add query interfaces ( e.g. capability to search experiments according to authors ) to the microarray data warehouse as more experiments are archived .
we will also add support to output experimental data sets in mage - ml format ( microarray gene expression - markup language ) ( 18 ) .
we will continue to implement additional clustering and classification tools ( e.g. principle component analysis 
additional analysis tools for expression profile comparison among multiple genotypes will be developed as more datasets are added to ted .
cross genotype comparison tool . comparison of expression profiles of 1 - 1 - 3.4.10.21 , a pto - like serine / threonine kinase , during normal tomato and nr mutant fruit development .
expression profiles of pseudo - replicates from unigene sgn - u212746 , a putative peptidyl - prolyl cis  trans isomerase , during normal tomato fruit development and ripening .
( b ) heatmap view of expression profiles of genes in one cluster from ( a ) ; ( c ) table view of expression profiles of genes in one cluster from ( a ) .
 the tomato expression database ( ted ) includes three integrated components . 
 the tomato microarray data warehouse serves as a central repository for raw gene expression data derived from the public tomato cdna microarray . 
 in addition to expression data , ted stores experimental design and array information in compliance with the miame guidelines and provides web interfaces for researchers to retrieve data for their own analysis and use . 
 the tomato microarray expression database contains normalized and processed microarray data for ten time points with nine pair - wise comparisons during fruit development and ripening in a normal tomato variety and nearly isogenic single gene mutants impacting fruit development and ripening . 
 finally , the tomato digital expression database contains raw and normalized digital expression ( est abundance ) data derived from analysis of the complete public tomato est collection containing > 150  000 ests derived from 27 different non - normalized est libraries . 
 this last component also includes tools for the comparison of tomato and arabidopsis digital expression data . 
 a set of query interfaces and analysis , and visualization tools have been developed and incorporated into ted , which aid users in identifying and deciphering biologically important information from our datasets . 
 ted can be accessed at . 
INTRODUCTION
DATABASE IMPLEMENTATION
DATABASE COMPONENTS AND FEATURES
Tomato microarray data warehouse
Tomato microarray expression database
Tomato digital expression database
FUTURE DIRECTIONS
Figures and Tables