A new versatile database created for geneticists and breeders to link molecular and phenotypic data in perennial crops: the AppleBreed DataBase

Abstract

Objective: AppleBreed DataBase (DB) aims to store genotypic and phenotypic data from multiple pedigree verified plant populations (crosses, breeding selections and commercial cultivars) so that they are easily accessible for geneticists and breeders. It will help in elucidating the genetics of economically important traits, in identifying molecular markers associated with agronomic traits, in allele mining and in choosing the best parental cultivars for breeding. It also provides high traceability of data over generations, years and localities. AppleBreed DB could serve as a generic database design for other perennial crops with long economic lifespans, long juvenile periods and clonal propagation.

Results: AppleBreed DB is organized as a relational database. The core element is the GENOTYPE entity, which has two sub-classes at the physical level: TREE and DNA-SAMPLE. This approach facilitates all links between plant material, phenotypic and molecular data. The entities TREE, DNA-SAMPLE, PHENOTYPE and MOLECULAR DATA allow multi-annual observations to be stored as individual samples of individual trees, even if the nature of these observations differs greatly (e.g. molecular data on parts of the apple genome, physico-chemical measurements of fruit quality traits, and evaluation of disease resistance). AppleBreed DB also includes synonyms for cultivars and pedigrees. Finally, it can be loaded and explored through the web, and comes with tools to present basic statistical overviews and with validation procedures for phenotypic and marker data to certify data quality. AppleBreed DB was developed initially as a tool for scientists involved in apple genetics within the framework of the European project, 'High-quality Disease Resistance in Apples for Sustainable Agriculture' (HiDRAS), but it is also applicable to many other perennial crops.