# Presentation: 815223

## Expansion of the USDA-ARS Germplasm Resources Information Network (GRIN) Database to Accommodate Molecular Data

- Gayle Volk , Christopher Richards
- USDA-ARS-National Center for Genetic Resources Preservation, 1111 S. Mason St., Ft. Collins, CO 80521
- Mark Bohning, Quinn Sinnott
- USDA-ARS-National Germplasm Resources Laboratory, 10300 Baltimore Avenue, Bldg. 003 BARC-West, Beltsville, MD 20705

**Relationships among molecular tables (not shaded) and connected pre-existing tables within GRIN (shaded).**

_**Genetic observation table (gob): raw data matrix (allele calls or sequence alignment) for each individual within an inventory**_
-   Genetic observation number (gobno)
-   Genotypic assay number (gano)
-   Inventory identifier (ivid)
-   Individual (indiv)
-   Genetic observation (gob)
-   Genbank link (genbank_link)
-   Image link (image_link)

_**Genotypic assay table (ga): Laboratory methods to collect genotypic data**_
-   Genotypic assay number (gano)
-   Marker number (mrkno)
-   Evaluation number (eno)
-   Method (method)
-   Scoring method (scoring_method)
-   Control values (control_values)
-   Number of observed alleles (no_obs_alleles)
-   Maximum observed alleles (max_gob_alleles)
-   Size alleles (size_alleles)
-   Unusual alleles (unusual_alleles)
-   Comment (cmt)

_**Marker table (mrk): Information about the markers used in the assay**_
-   Marker nmber (mrkno)
-   Crop number (cropno)
-   Site code (site)
-   Marker (marker)
-   Synonyms (synonyms)
-   Repeat motif (repeat_motif)
-   Primers (primers)
-   Standard assay conditions (assay_conditions)
-   Range products (range_products)
-   Genbank number (genbank_no)
-   Map location (map_location)
-   Position (position)
-   Comment (cmt)
-   Polymorphic type (poly_type)

_**Marker Citation Table (mcit):     **_Citation number (citno)
-   Marker number (mrkno)
-   Reference abbreviation (abbr)
-   Citation title (cittitle)
-   Author of publication (author)
-   Citation year (cityr)
-   Citation reference (citref)
-   Comment (cmt)

**Columns within Genetic Marker/observation area of GRIN. **

**REFERENCES**

- Casstevens T.M. and E.S. Buckler.  2004.  GDPC: connecting researchers with multiple integrated data sources.  Bioinformatics 20: 2839-2840.
- Mowder J.D. and A.K. Stoner. 1988. Information systems.  Plant Breed. Rev. 7:57-65.
- Perry M., A.K. Stoner and J.D. Mowder. 1988. Plant germplasm information management system: Germplasm Resources Information Network.  HortScience 23:57-60.
- USDA, ARS, National Genetic Resources Laboratory. 2008. *Germplasm Resources Information Network - (GRIN)*. [Online Database] National Germplasm Resources Laboratory, Beltsville, Maryland. 15 Feb. 2008.  < _[http://www.ars-grin.gov/npgs/](http://www.ars-grin.gov/npgs/)_>
- Volk G.M. and C.M. Richards. 2008. Availability of genotypic data for USDA-ARS National Plant Germplasm System accessions using the Genetic Resources Information Network (GRIN) database.  HortScience (in press).

**RATIONALE AND SCOPE**
- USDA’s National Plant Germplasm System (NPGS) maintains the world’s largest living collection of plant genetic resources.  The NPGS is tasked with acquiring, preserving, characterizing, and distributing over 450,000 accessions.  Major components of the system include more than 20 active field evaluation sites, a base collection for long term storage, quarantine, taxonomy, and plant exploration units.  Critical information, including passport data and phenotypic characteristics about these plant materials, is available through the Genetic Resources Information Network (GRIN) database (Mowder and Stoner 1988; Perry et al. 1988; USDA, ARS, National Genetic Resources Laboratory 2008).
- The new molecular tables in GRIN add the capacity to associate genotypic data with the existing phenotypic data (Volk and Richards 2008).  The revised tables accommodate multiple marker types, provide raw data for individuals, accept polyploid data, provide a record of methods, standards, and control values. Presentation of data at the individual level is a new feature for GRIN; now specific seeds (or individuals) within an inventory can be genotyped and documented. The revised tables also are structured so that interoperability with other databases will be possible.

- The genomics community continues to generate large data sets comprised of sequence data from expressed sequence tag (EST) studies, mapping projects and fragment analysis for diverse species. The development of GRIN molecular tables serves as a resource for a great number of taxa for which there currently exists no alternative database model organism databases for sequence data.  The four new tables added to GRIN accommodate specific molecular data types: amplified fragment length polymorphism, allozyme, sequence, microsatellite, restriction fragment length polymorphism and their variants.  In addition, sequence-based markers will be accommodated including genomic and single nucleotide polymorphisms (SNPs).
- The improved capacity for holding genotypic data in GRIN has made apple, pear, blueberry, hops, hazelnut, and cacao allelic data publicly available.  Additional data will be uploaded as datasets are published. It is currently possible to download tables of allelic data from GRIN.
- Databases must evolve to become interoperable with other genomic, genebank, and environmental (or geographical information system) databases. Interoperability allows for the combination and synthesis of data from disparate sources using middleware services (Casstevens and Buckler 2004).  An example of interoperability in the biodiversity discipline is the Global Biodiversity Information Facility (www.gbif.org) of which the NPGS is a data provider.  Additionally, direct links have already been established between sequence data in GRIN and NCBI. It is also recognized that model organism and clade organism databases provide users with valuable map, marker, and genomic data.  Complementary features of these databases and the passport and phenotypic data available in GRIN enhance the prospects of future interoperability.