Advanced Extracts

trial and pedigree data extract the trial and pedigree data extract lists individual raw observation data from one or more trials, for specified traits and assessment ages it can also provide associated pedigree details for the participating genetic entities, with many options for inclusion of additional output information the default output options are shown below note that genotype codes are used to represent pedigree data within the file outputs, with these codes unique to individual trees or plants trait counts (by entity) extract the trait counts (by entity) extract lists the number of individual plants or trees assessed (by age) for one or more selected trials and traits results are presented according to the number of measurements per trial and genetic entity, with the header rows in the extract file describing trial name trait code (used as a short form reference for the trait name and description) months of age at recording date plant statistics extract the plant statistics extract provides summary statistics for individual plants or trees assessed (by age) for one or more selected traits users can select from a wide range of statistical outputs, with these results automatically calculated as part of the extract process pedigree data can also be generated (on a separate tab) for selected entities as required trial statistics extract the trial statistics extract provides a range of summary statistics for genetic entities assessed (by age) for one or more selected trials and traits this extract also provides options for a wide variety of additional output options with the business 'rules' for this extract outlined below default inclusion of some columns is determined by user preferences for those summary types where the column is available and optional field code and alternate name (name in trial) are unavailable when summarising for genetic entity, optional when summarising for trial entry entity type is mandatory when summarising for genetic entity, optional otherwise experimental role, tested as, and propagation method are mandatory when summarising per trial entry, unavailable (and off) when summarising per genetic entity summary statistics extract the summary statistics extract builds on the trial statistics https //docs gemnetics com/advanced extracts#gl trial statistics extract extract by enabling inclusion of a range of breeding value and index data within a single file these can be included by ticking the 'include bv and index results \[optional]' menu item within the initial selection strategy the 'geneitc entity must also be in the trial' and will automatically be included when this option is selected