Extracts

trial layout extract the trial layout extract enables users to download planting information of any selected trial according to trial name field code variety section (often referred to as 'block') position within the section (or 'block') plant id (optional field used to describe a unique plant identifier, which may be used as a substitute for section/tree position) name in trial (genetic entity name or alternate name used within the trial) a range of additional data may also be provided including section or plant/tree user defined fields (udf's) udfs are often used for information such as rep, row or column position within the trial note that this extract enables data to be downloaded and edited in a form that can be directly uploaded back into the database by administrators (dataservices\@gemnetics com) trial data counts extract the trial data counts extract reports on the total number of plants with numerical measurements in one or more selected trials results are presented in tabular format, with the number of measurements reported for each trait by age within trial survival is the only exception to this rule, with data linked to the survival trait showing the number of surviving plants or trees at assessment age (as opposed to the number assessed) shading has been used to indicate binary and non numerical trait data graphical and tabular views of this information have also been made available within the trial data interactive report single trial and trait extract the single trial and trait extract outputs data from all plants in a trial for a single trait in a format suitable for editing and re importing there is the option to include only trees with observations for selected trait or all trees the output file which is sorted according to section and position or plant id, shows measurement data for the selected trait by age the file can then be filtered to obtain the most recent measurement by age, and then used as a template for data recording and checking within the field note that results collected using this file format can be saved and sent to dataservices\@gemnetics com for loading please include the recording date information to ensure age at measurement is correctly captured within the database where planted (by entity) extract the where planted (by entity) extract uses the genetic entity selection strategy to filter results according to a genetic entity list, or all genetic entities included within one or more trials there is a range of options that can be included in the output file base outputs genetic entity name genetic entity type (selection, full sib family, seedlot) count of individuals plants or trees for that entity within the trial recommended additional outputs (default settings) name in trial tested as (seedlot, full sib family, half sib, selection codes) field codes (assigned to a genetic entity and used as an identifier within the trial layout map) individual plant/tree locations including section and plant/tree udfs and individual plant codes, if loaded note that individual plant and tree location data is shown within a separate tab of the exported file with the examples of the 'where planted' file extracts shown below genetic entity data extract the genetic entity data extract uses the genetic entity selection strategy to filter results according to a genetic list, or all genetic entities included within one or more trials users can then select one or more traits of interest, and also any relevant breeding values or index information available, and export the information to an excel or csv file for viewing and analysis pedigree data extract the pedigree data extract uses an advanced version of the genetic entity selection strategy where users can also choose to extract pedigree data for all selections included within the database or for parents of full sib families this extract also includes options to display the mating design (crosses) for entities within the one or more trials calculate co ancestry statistics calculate in breeding statistics outputs a worksheet titled 'pedigree' is always included with the pedigree extract the pedigree is presented as three columns, one for selection (which is a genotype name), one for that selection's mother, and one for that selection's father the choose outputs screen is used to select a range of additional outputs pedigree tab additional information can also be included such as full sib family, species, selection details, other names, owner and/or selection notes note that ancestors can also be included within the pedigree information providing the "by trial" selection strategy isn't used mating design (co ancestry tab) a mating design is a matrix of the full sib crosses in a trial or set of trials when the by trial (include all selections and parents in specified trials) option is selected, then the 'mating design' tab will be included if the specified trials include at least one full sib family the choices in the mating design box allow you to choose one of three options for what data is shown in the body of the matrix for each full sib family the options are co ancestry (which equals the inbreeding of the offspring), number of plants in the trial, or name in trial coancestry tab coancestry statistics can also be generated for all entities included within the selection these statistics reflect the probability that 2 individuals are identical by descent, with results presented as either a matrix or a list inbreeding tab inbreeding statistics can also be automatically calculated by selecting the "include inbreeding coefficient and status number" option note that the colours used in coancestry statistics can be adjusted using the conditional formating colour scheme options which can be found under the settings/exporting tab '