Title: ARM Germplasm Manager AGM
1ARM Germplasm Manager (AGM)
- Add-In for ARM 8
- Gylling Data Management, Inc.www.gdmdata.com
2AGM Introduction
- Database system for managing crop improvement
research - Is an add-in for ARM version 8
- Uses ARM to enter, manage, and report individual
trials - Uses ARM ST (ST) to summarize and report trial
series (ST is also an ARM add-in)
3AGM Introduction
4Components
- Database
- Use any SQL-compliant relational database.
- Default is single-user Microsoft Access database.
- Networked, multi-user DB servers are supported.
- User Interface
- Simplifies accessing data in the database.
- Provides software tools to automate many of the
repetitive tasks required to document cultivar
improvement.
5Database
- Relational design links records associated with
development of improved varieties. - Integrates with ARM and ST to manage multi-year
crop performance trials. - Simplifies documenting the release of new lines
and varieties.
6User Interface
- Point and click interface to find all information
related to a cultivar under development. - Simplifies entering crosses and selections.
- Standardizes pedigree and selection naming
conventions.
7User Interface, cont.
- Users typically access the database through two
types of dialog - Germplasm dialogs, representing crosses and
populations - Germplasm Collection dialogs, representing
nurseries and cross blocks.
8Germplasm Dialogs
- Include sub-views that display genealogy
- Backward (parentage)
- Forward (selections and crosses).
- Include tables for related information
- Trials
- Documentation
- Images
9Germplasm Dialogs
10Germplasm Collection Dialogs
- Allow users to group together crosses or
populations. - Sub-views show related
- ARM trials (Nurseries)
- Combinations of parents (Cross Blocks)
11Germplasm Collection Dialogs
12Example 1
- The next three slides contain paragraphs quoted
from the published registration of Expedition
winter wheat. (Crop Science 441470-1471. 2004).
13Crop Sci 441470 (2004)
Expedition (Reg. no. CV-947, PI 629060) hard
red winter wheat (Triticum aestivum L.) was
developed by the South Dakota Agricultural
Experiment Station and released to seed producers
in August 2002. Expedition was released on the
basis of its excellent winter survival and high
grain yield potential in South Dakota and the
northern Great Plains region.
14Crop Sci 441470 (2004), cont.
Expedition was derived from the cross
Tomahawk/Bennett made during 1993. Tomahawk
(PI 552814) is a hard red winter wheat developed
by Agripro Biosciences, Inc. and released in
1991. Bennett (CItr 17723) (Schmidt et al., 1981)
is a hard red winter wheat developed
cooperatively by the Nebraska Agric. Exp. Stn.
and USDA-ARS. Expedition was developed by means
of the bulk breeding method. The cross (coded
X93184) was advanced to the F3 generation as a
bulk sample.
15Crop Sci 441470 (2004), cont.
Expedition was derived as an F34 head row
selected by S. D. Haley in 1997. Expedition was
evaluated as SD97457 in the South Dakota Early
Yield Trial nursery in 1998. It was advanced
beyond the Preliminary Yield Trial to the South
Dakota Advanced Yield Trial in 1999 because of
superior performance. It was tested in the South
Dakota Crop Performance Testing (CPT) Variety
Trial between 2000 and 2002 and in the Northern
Regional Performance Nursery during 2001 and 2002.
16Viewing Historical Data
The next slides show the history of Expedition,
as documented in Crop Science, viewed using AGM.
17Population Dialog - Details
Expedition (Reg. no. CV-947, PI 629060) hard
red winter wheat was developed by the South
Dakota Agricultural Experiment Station and
released to seed producers in August 2002.
18Population Dialog - Genealogy
Expedition was derived from the cross
Tomahawk/Bennett made during 1993. The
cross (coded X93184)
19Population Dialog - Documents
Bennett (CItr 17723) (Schmidt et al., 1981) is a
hard red winter wheat developed cooperatively by
the Nebraska Agric. Exp. Stn. and USDA-ARS.
20Population Dialog - Source
Expedition was evaluated as SD97457 derived as
an F34 head row selected by S. D. Haley in 1997
21Population Dialog - Trials
Expedition was evaluated as SD97457 in the South
Dakota Early Yield Trial 1998 the South
Dakota Advanced Yield Trial 1999 tested in
the South Dakota Crop Performance Testing (CPT)
Variety Trial 2000 in the Northern Regional
Performance Nursery 2001
22Example 2
- A winter winter line, tested as SD97W609, is
ready to be released to growers. - The breeder needs to prepare a manuscript for
publication in Crop Science.
23Manuscript Preparation
- Information required for registration in Crop
Science includes - Experimental number or designation
- Names of agencies, organization or institutions
- Breeding procedures and pedigree
- Comparative performance data
- References for parental germplasm
24Preparing Data
- Import or enter in AGM the historical data
relating to the development of SD97W609 -
crosses, selections and trials, dating to 1992. - Export trials from AGM to ARM ST for analysis.
- Print two reports, one initiated from AGM and one
from ARM ST, to provide a summary of SD97W609
development and testing.
25SD97W609 History
- View most SD97W609 information using the
Population dialog. - Print a report for complete information,
including data from parent lines.
26SD97W609 Report
- Germplasm report
- Summarizes information in the Population dialog.
- Includes information extracted from parent lines.
27SD97W609 Report
- Germplasm report also lists trials for the
selected population.
28Summarizing Trials
In Population, Data -gt ARM Trials, select the
trials to be summarized. A menu click starts an
ST summary.
29Run ST
- Use ST to select
- Traits to analyze
- Entries to compare with released cultivar
30Crop Performance Summary
ST report provides summary of crop performance
trials for
- Released cultivar
- Selected check varieties
- In format that is ready to include in
registration
31List of Summarized Trials
Compare the trials listed in the ARM ST
report withtrials listed in the germplasm
report tocross-check the analysis.
32Other Components
- AGM also includes tools to simplify many common
tasks associated with cultivar improvement,
including - Managing cross blocks and pedigrees
- Crop performance testing and selection
- Cultivar phenotyping
- Tracking seed lots and seed inventory
- Managing historical data
33Summary
- AGM is a database plus software interface
- AGM manages and reports crop improvement trials
- AGM is an add-in to ARM
- AGM uses ARM to manage trials
- AGM uses ST to summarize across trials (ST is
also an ARM add-in)