Version VI of the ESTree db: an improved tool for peach transcriptome analysis
- Barbara Lazzari†1Email author,
- Andrea Caprera†1,
- Alberto Vecchietti1,
- Ivan Merelli2,
- Francesca Barale3,
- Luciano Milanesi2,
- Alessandra Stella1 and
- Carlo Pozzi1
© Lazzari et al.; licensee BioMed Central Ltd. 2008
Published: 26 March 2008
The ESTree database (db) is a collection of Prunus persica and Prunus dulcis EST sequences that in its current version encompasses 75,404 sequences from 3 almond and 19 peach libraries. Nine peach genotypes and four peach tissues are represented, from four fruit developmental stages. The aim of this work was to implement the already existing ESTree db by adding new sequences and analysis programs. Particular care was given to the implementation of the web interface, that allows querying each of the database features.
A Perl modular pipeline is the backbone of sequence analysis in the ESTree db project. Outputs obtained during the pipeline steps are automatically arrayed into the fields of a MySQL database. Apart from standard clustering and annotation analyses, version VI of the ESTree db encompasses new tools for tandem repeat identification, annotation against genomic Rosaceae sequences, and positioning on the database of oligomer sequences that were used in a peach microarray study. Furthermore, known protein patterns and motifs were identified by comparison to PROSITE. Based on data retrieved from sequence annotation against the UniProtKB database, a script was prepared to track positions of homologous hits on the GO tree and build statistics on the ontologies distribution in GO functional categories. EST mapping data were also integrated in the database. The PHP-based web interface was upgraded and extended. The aim of the authors was to enable querying the database according to all the biological aspects that can be investigated from the analysis of data available in the ESTree db. This is achieved by allowing multiple searches on logical subsets of sequences that represent different biological situations or features.
The version VI of ESTree db offers a broad overview on peach gene expression. Sequence analyses results contained in the database, extensively linked to external related resources, represent a large amount of information that can be queried via the tools offered in the web interface. Flexibility and modularity of the ESTree analysis pipeline and of the web interface allowed the authors to set up similar structures for different datasets, with limited manual intervention.
The ESTree db  is an Expressed Sequence Tags (ESTs) database that was developed by the Italian ESTree Interuniversitary Centre as a platform for easy genomics and functional genomics data integration and retrieval. Together with the GDR database , it represents the most complete online resource for peach EST analysis. The ESTree db sequence analysis is based on a semi-automated Perl pipeline that during its steps feeds the tables of a MySQL database. Queries to the database can be performed via a PHP-based web interface.
The first version of the ESTree db released in 2004 encompassed a restricted number of peach sequences, derived from four peach mesocarp in-house prepared libraries. In the following versions, public peach sequences were added to the collection, and in version III (released on April 2005)  the number of represented libraries was grown to eight. Further versions of the database were released in the past three years, each of which encompasses more sequences and more features. In the currently released version VI (as of March 2007), the collection has grown to 75,404 sequences: 10,847 derived from five in-house prepared libraries from peach fruits and the others downloaded from GenBank or kindly provided by other members of the ESTree Interuniversitary Centre. The database is mostly devoted to Prunus persica, but 3,864 Prunus dulcis sequences (i.e. the almond ESTs currently publicly available) were also added. The resulting dataset was composed of sequences obtained from twenty-two libraries (three from almond and nineteen from peach), seven of which were added to Version VI for the first time. The peach dataset, in particular, represented nine genotypes and four tissues, and mesocarp sequences were obtained from the four developmental stages describing the peach ripening process. The availability of a more extended sequence dataset allowed the authors to explore in more detail the differences in gene expression in the various tissues and developmental stages, making use of an extended version of the ESTree db pipeline that integrates a more comprehensive collection of sequence analysis programs.
The aim of this work is to describe the major changes and improvements brought to the ESTree db, and to inform users of the availability of this extended tool, for an easy exploration of peach and related species functional genomics.
Construction and content
The ESTree db sequence collection
The ESTree db encompasses peach and almond sequences. The few available almond sequences were introduced in the database to support mapping data produced on the TxE Prunus reference map based on an almond x peach F2 progeny. Almond sequences downloaded from GenBank were from pistils and embryo, plus a third library of unknown origin. The collection of peach sequences represents nine genotypes (Bolero, Loring, OroA, Red Haven, Suncrest, Yumeyong, O'Henry, Baby gold 5 and Fantasia), four tissues (mesocarp, skin, shoot, and leaf) and four mesocarp developmental stages (post-allegation, pit hardening, pre-climacteric, and post-climacteric). Distribution of sequences among libraries or developmental stages was unequal, the mesocarp post-climateric stage being the most represented. In program outputs displaying sequences from different libraries (i.e. contigs graphical displays or outputs from the putative SNP identification procedure), a colour code was assigned to relate sequences to the tissue and developmental stage of origin. Sequence names themselves were library-declarative, as library identifiers were used as sequence name prefixes.
Sequence analysis pipeline and database structures
The MySQL database where data are stored has expanded to contain all the new programs' outputs and all the tables that are queried to produce dynamic outputs upon users' requests.
Sequence clustering and putative SNP detection
The ESTree db statistics on sequences. Comparison of the main statistics on the ESTree db version VI, compared with the previously described version III.
Total nr of seq
Total nr of contigs
Average alignment depth
Total nr of singletons
Total nr of unigenes
In-house produced seq
Total almond seq
Total peach seq
Pp mesocarp seq
Pp skin seq
Pp shoot seq
Pp leaf seq
NCBI annotated seq (%)
GO annotated seq (%)
Genomic annotated seq (%)
Repeats-containing seq (%)
Putative SNP-containing seq (%)
PROSITE patterns-containing seq (%)
Seq associated to microarray data (%)
Metabolic pathways-associated seq (%)
Changes and improvements of the ESTree db annotation procedures
In the ESTree db, version VI, ESTs and contig consensus sequences were annotated against three different databases, with an E-value cutoff of ≤ e−10. The master annotation was performed by BLASTx against the GenBank nr db, in order to retrieve the highest number of annotations; a second annotation was performed by BLASTn against a custom-prepared database composed of 7,829 Rosaceae genomic DNA/RNA sequences downloaded from the GenBank CoreNucleotide db in October 2006. The already existing so-called “GO annotation” procedure - aimed to the identification of proteins homologs annotated according to the Gene Ontology (GO) project [11, 12] - was adapted to specific needs. In the preceding ESTree db versions, in fact, GO annotation was performed online, and not integrated into the ESTree pipeline, using the GOblet  program against the Viridiplantae subset of the GO database (a subset of sp-trembl). The number of sequences that had to be annotated, the need for frequent annotation updates, and the requirement to perform a more extensive annotation against the whole UniProtKB database, called for the improvement produced in version VI. A number of Perl scripts were prepared to create a table with all the protein-GO associations including a no-direct link due to “is_a” relations among different GO elements, starting from information contained in the GoA association file as well as in the GO DAG (Directed Acyclic Graph) file. Information contained in this table was used to produce statistics on the ontologies distribution that can be browsed on all the GO tree levels.
According to the adopted E-value cutoff, 78.6% of the sequences contained in the ESTree db were annotated against the GenBank nr db, 69.7% against the UniProtKB db, and 26.8% against the genomic Rosaceae db (Table 1).
Considering the high number of sequences that had to be annotated and the need to perform annotation against there different databases, a parallel approach was adopted to perform BLAST searches on a computer cluster , giving the possibility to retrieve results in reasonable times. When blast outputs are recovered, they are parsed, split in single-query files and stored in MySQL tables as such and in feature-dedicated fields.
Tandem repeats search
A repeat analysis feature was introduced in the ESTree db and the Tandem Repeats Finder program  was used for repeat identification. Prior to repeat identification, PolyA and PolyT tails were trimmed from sequences with TrimEST . The Tandem Repeats Finder algorithm locates and displays two or more adjacent, approximate copies of a pattern of nucleotides in DNA sequences. With the selected settings (2 7 7 80 10 50 1000), the program was able to identify repeats of variable period size (from single base stretches to very long base sequences) that were encountered in more than one copy within 1,000 base pairs. This allowed the identification of simple sequence repeats (SSR, with period size from 2 to 6 base pairs) as well as of longer and more dispersed tandem repeats that are present in the submitted sequences. The MISA software  was applied to the same dataset, and analogous results were retrieved (data not shown). In total, 12,068 repeat-containing sequences were identified in the ESTree collection, and among these 3,946 (32.7%) were SSRs.
In order to allow users to choose sets of repeats of given characteristics (i.e. intervals of period size and copy number), a search engine was prepared.
The ESTree mapping project
The aim of the ESTree Mapping Project is to map approximately 200 ESTs on a genetic map , as a prerequisite for further positioning on a physical framework map based on BAC clones fingerprinted at Clemson University . The preliminary mapping results were presented in the ESTree db, together with the peach ESTs map positions that were publicly available at the GDR web site. Currently, mapping information is available for 568 sequences. In the Sequence Report page, map information was linked to the CMap pages of the GDR.
A program that allows the automatic BIN assignment based on a TxE subset of plants  was prepared, and can either be used online or downloaded via the links that are given in the “ESTree Mapping Project” page.
Analyses on the inferred protein dataset
The ESTate package programs  were used to deduce from each EST and contig consensus a putative protein sequence. FrameFinder uses log odds hexamer frequency statistics and multiple dynamic programming frame-shifts models to predict the reading frame of CDSs, and, being error-tolerant, is particularly suitable for the analysis of EST sequences. To create log odds probabilities for FrameFinder, a training set, composed of Rosaceae mRNA sequences downloaded from the NCBI CoreNucleotide database was prepared and processed with fasta2usage (parameters: -w 6 -j 3) and wordprob. The FrameFinder output, encompassing the most probable putative protein sequence that was obtained from each input sequence, was compared to the PROSITE database  using the software scanPROSITE , and matching patterns were stored in the database. Frequently matching patterns and profiles were excluded from the analysis. In total, PROSITE patterns and domains were identified in 13,580 EST sequences and in 1,846 contig consensus sequences.
Upgrading the web interface
The PHP-based web interface was upgraded and modified in Version VI. The Sequence Report and Contig Report tables represent the standard format for data presentation in the ESTree db, and query outputs or selectable sequence subsets are presented with the same table structure. To integrate new data, more columns were added to the tables, so that each sequence feature is presented in table fields and linked to dedicated pages, internal to the ESTree db or belonging to related web resources. A column was added to associate the 4,699 oligomer sequences used in a peach microarray study  to the correspondent sequences contained in the database. This tabular structure allows complete overview of sequence-associated features simply by scrolling the tables. Query outputs can also be downloaded, both in tabular format or as multifasta file, encompassing sequences matching the query terms. Independent browsing of subsets of sequences was allowed. This is crucial for a deep insight in the different biological situations existing in the tissues and developmental stages that are represented in the database. Sequences can be partitioned according to the organism (peach or almond), the library, the tissue or developmental stage, whether they belong to a unigene, singlet or contig, the presence of repeats or putative SNPs and of map positions. In the “Download” page, download was allowed in multiple formats for EST sequences and contig consensus sequences, as well as for the CAP3 alignment and .ace files and for the AutoSNP SNP Reports.
Utility and discussion
The ESTree and the GDR databases represent the only existing online resources dedicated to peach EST analysis. The two databases are very similar in terms of entry number (71,540 peach sequences in the ESTree db, 70,939 in the GDR db), but quite different in terms of information and its retrieval. The ESTree db clustering procedure produced a dataset of 27,097 unigenes, 4,303 of which were derived from our in-house prepared libraries.
From the bioinformatic point of view, flexibility and modularity were the keywords in structuring the database. The authors prepared an EST analysis pipeline that could be conveniently applied to the analysis of data derived from other projects. The ESTree pipeline invokes standard public programs as well as custom prepared Perl modules. Adding or removing modules requires little manual intervention, making the pipeline easily adaptable to the specific requirements of different datasets. Nonetheless, because of the progressive introduction of new data and of the significant amount of data updating needed to compile the database tables, an effort was made to reduce the time required to complete the whole procedure. BLAST analyses were not included into the pipeline to allow a parallel approach on a computer cluster. Updates in the GO blast procedure call for the updating of the corresponding in-house prepared table upon which GO statistics are created, and this is another example of time-consuming task that is carried out independently from the main pipeline. In the whole ESTree db structure, the PHP-based web interface plays a fundamental role. All the graphical outputs that are presented in the web site are prepared on-the-fly by this interface, and are not stored in the database.
The ESTree project is still underway, and additional data are being produced. The integration of microarray-derived data and of EST frequency analyses in different tissues and developmental stages into the ESTree db will make it an exhaustive tool for interpretation of expression differences among the represented biological situations. Furthermore, new graphical interfaces to access sequences belonging to specific metabolic pathways will add value to the already available links to KEGG .
The version VI of ESTree db offers the possibility to access data concerning peach gene expression in an easy and complete way. ESTs multiple origins with respect to tissues and developmental stages allow a broad study of gene expression in a fruit tree. Ontologies analysis allows the comparison of the transcriptomes from different biological sets, and the creation of expression profiles, to be used in the study of patterns of gene expression (Vecchietti et al., in preparation).
Additional features of version VI of the ESTree db are the increased, more user-friendly, data retrieval systems according to custom-selected aspects implemented via the web interface. The continuous data production by the ESTree Interuniversitary Centre units will result in a growth of the ESTree db, that will be updated and upgraded according to the future peach genomic projects requirements.
Availability and requirements
The ESTree db is available without restrictions at the following URL: http://www.itb.cnr.it/estree/.
We acknowledge Dr David Edwards and Dr. Gary Barker for providing the AutoSNP program, Dr Alberto Montironi for preparing the program for automatic BIN assignment, Dr. Massoud Malek for help with the informatics work and Prof. Francesco Salamini for critical reading of the manuscript.
This work was supported by Parco Tecnologico Padano, Laboratory of Interdisciplinary Technologies in Bioinformatics (L.I.T.B.I.O.) and CISI and by the MIUR “Functional Genomics”, “Bioinformatics for Genome and Proteome” projects, the EU BIOINFOGRID project, and FIRB projects.
This article has been published as part of BMC Bioinformatics Volume 9 Supplement 2, 2008: Italian Society of Bioinformatics (BITS): Annual Meeting 2007. The full contents of the supplement are available online at http://www.biomedcentral.com/1471-2105/9?issue=S2
- ESTree database [http://www.itb.cnr.it/estree/]
- GDR: genome database for rosaceae [http://www.bioinfo.wsu.edu/gdr/]
- Lazzari B, Caprera A, Vecchietti A, Stella A, Milanesi L, Pozzi C: ESTree db: a tool for peach functional genomics. BMC Bioinformatics 2005, 6(Suppl 4):S16. PMID: 16351742 10.1186/1471-2105-6-S4-S16PubMed CentralView ArticlePubMedGoogle Scholar
- Lazzari B, Caprera A, Cosentino C, Stella A, Milanesi L, Viotti A: ESTuber db: an online database for Tuber borchii EST sequences. BMC Bioinformatics 2007, 8(Suppl 1):S13. PMID: 17430557 10.1186/1471-2105-8-S1-S13PubMed CentralView ArticlePubMedGoogle Scholar
- Caprera A, Lazzari B, Stella A, Merelli I, Caetano AR, Mariani P: GoSh: a web based database for goat and sheep EST sequences. Bioinformatics 2007, 23(8):1043–1045. Mar 24(Epub ahead of print), PMID: 17384426 10.1093/bioinformatics/btm063View ArticlePubMedGoogle Scholar
- Ewing B, Hiller L, Wendl M, Green P: Basecalling of automated sequence traces using phred. I. Accuracy assessment. Genome Research 1998, 8: 175–185.View ArticlePubMedGoogle Scholar
- Chou H-H, Holmes MH: DNA sequence quality trimming and vector removal. Bioinformatics 2001, 17(12):1093–1104. 10.1093/bioinformatics/17.12.1093View ArticlePubMedGoogle Scholar
- Barker G, Batley J, O'Sullivan H, Edwards KJ, Edwards D: Redundancy based detection of sequence polymorphisms in expressed sequence tag data using autoSNP. Bioinformatics 2003, 19(3):421–422. 10.1093/bioinformatics/btf881View ArticlePubMedGoogle Scholar
- Huan X, Madan A: CAP3: A DNA sequence assembly program. Genome Research 1999, 9: 868–877. 10.1101/gr.9.9.868View ArticleGoogle Scholar
- Pertea G, Huang X, Liang F, Antonescu V, Sultana R, Karamycheva S, Lee Y, White J, Cheung F, Parvizi B, Tsai J, Quackenbush J: TIGR Gene Indices clustering tools (TGICL): a software system for fast clustering of large EST datasets. Bioinformatics 2003, 19(5):651–652. (2) 10.1093/bioinformatics/btg034View ArticlePubMedGoogle Scholar
- The Gene Ontology Consortium: Gene Ontology: tool for the unification of biology Nature Genet 2000, 25: 25–29. 10.1038/75556Google Scholar
- Gene Ontology Home [http://www.geneontology.org/]
- Groth D, Lehrach H, Hennig S: GOblet: a platform for Gene Ontology annotation of anonymous sequence data. Nucleic Acids Res 2004, 32(Web server issue):W313-W317. 10.1093/nar/gkh406PubMed CentralView ArticlePubMedGoogle Scholar
- LITBIO [http://www.litbio.org]
- Benson G: Tandem repeats finder: a program to analyze DNA sequences. Nucleic Acid Res 1999, 27: 573–580. 10.1093/nar/27.2.573PubMed CentralView ArticlePubMedGoogle Scholar
- EMBOSS [http://emboss.sourceforge.net/apps/]
- MISA - MIcroSAtellite identification tool [http://pgrc.ipk-gatersleben.de/misa/]
- Howad W, Yamamoto T, Dirlewanger E, Testolin R, Cosson P, Cipriani G, Monforte AJ, Georgi L, Abbott AG, Aràs P: Mapping with a Few Plants: Using Selective Mapping for Microsatellite Saturation of the Prunus Reference Map. Genetics 2005, 171: 1305–1309. 10.1534/genetics.105.043661PubMed CentralView ArticlePubMedGoogle Scholar
- Joobeur T, Viruel MA, de Vicente MC, Jauregui B, Ballester J, Dettori MT, Verde I, Truco MJ, Messeguer R, Batlle I, Quarta R, Dirlewanger E, Aràs P: Construction of a saturated linkage map for Prunus using an almond x peach F2 progeny. Theor Appl Genet 1998, 97: 1034–1041. 10.1007/s001220050988View ArticleGoogle Scholar
- ESTate - Expressed Sequence Tag Analysis Tools [http://bioweb.pasteur.fr/docs/man/man/ESTate.1.html]
- Falquet L, Pagni M, Bucher P, Hulo N, Sigrist CJ, Hofmann K, Bairoch A: The PROSITE database, its status in 2002. Nucleic Acids Res. 2002, 30: 235–238. 10.1093/nar/30.1.235PubMed CentralView ArticlePubMedGoogle Scholar
- Gattiker A, Gasteiger E, Bairoch A: ScanPROSITE: a reference implementation of a PROSITE scanning tool. Appl. Bioinformatics 2002, 1: 107–108.PubMedGoogle Scholar
- Trainotti L, Bonghi C, Ziliotto F, Zanin D, Rasori A, Casadoro G, Ramina A, Tonutti P: The use of microarray μPEACH1.0 to investigate transcriptome changes during transition from pre-climacteric to climacteric phase in peach fruit. Plant Sci 2006, 170: 606–613. 10.1016/j.plantsci.2005.10.015View ArticleGoogle Scholar
- KEGG Pathway Database [http://www.genome.jp/kegg/pathway.html]
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.