title: Chado use case: storing genomic, genetic and breeding data of Rosaceae and Gossypium crops in Chado.
abstract: The Genome Database for Rosaceae (GDR) and CottonGen are comprehensive online data repositories that provide access to integrated genomic, genetic and breeding data through search, visualization and analysis tools for Rosaceae crops and Gossypium (cotton). These online databases use Chado, an open-source, generic and ontology-driven database schema for biological data, as the primary data storage platform. Chado is highly normalized and uses ontologies to indicate the 'types' of data. Therefore, Chado is flexible such that it has been used to house genomic, genetic and breeding data for GDR and CottonGen. These data include whole genome sequence and annotation, transcripts, molecular markers, genetic maps, Quantitative Trait Loci, Mendelian Trait Loci, traits, germplasm, pedigrees, large scale phenotypic and genotypic data, ontologies and publications. We provide information about how to store these types of data in Chado using GDR and CottonGen as examples sites that were converted from an older legacy infrastructure. Database URL: GDR (www.rosaceae.org), CottonGen (www.cottongen.org).
authors.affiliation: Department of Horticulture, Washington State University Pullman, WA, USA sookjc@gmail.com.
authors.forename: Sook
authors.initials: S
authors.lastname: Jung
authors.affiliation: Department of Horticulture, Washington State University Pullman, WA, USA.
authors.forename: Taein
authors.initials: T
authors.lastname: Lee
authors.affiliation: Department of Horticulture, Washington State University Pullman, WA, USA.
authors.forename: Stephen
authors.initials: S
authors.lastname: Ficklin
authors.affiliation: Department of Horticulture, Washington State University Pullman, WA, USA.
authors.forename: Jing
authors.initials: J
authors.lastname: Yu
authors.affiliation: Department of Horticulture, Washington State University Pullman, WA, USA.
authors.forename: Chun-Huai
authors.initials: CH
authors.lastname: Cheng
authors.affiliation: Department of Horticulture, Washington State University Pullman, WA, USA.
authors.forename: Dorrie
authors.initials: D
authors.lastname: Main
mesh_terms: D001947:Breeding; D018556:Crops, Agricultural / Q000235:genetics*; D030541:Databases, Genetic; D063990:Gene Ontology; D005819:Genetic Markers; D018745:Genome, Plant; D023281:Genomics / Q000379:methods*; D005838:Genotype; D003368:Gossypium / Q000235:genetics*; D010641:Phenotype; D040641:Quantitative Trait Loci / Q000235:genetics; D027824:Rosaceae / Q000235:genetics*; D012639:Seeds / Q000235:genetics
chemical_list: D005819:Genetic Markers