Data Template
Templatephenotypedownload
Headers
ColumnDescription
* dataset_nameName of the phenotyping dataset. It should match a 'dataset_name' column entry in the 'Dataset' sheet.
* stock_nameID of the stock that has been phenotyped. It should match a 'stock_name' column entry in the 'Stock' sheet or 'progeny_name' column entry 'Progeny' sheet.
* genusGenus of the stock
* speciesSpecies of the stock
* sample_IDThe ID of the smallest sample or sub-sample that was tested (Each row should have unique sample_ID). If there is no unique sample ID, users can concatenate a set of columns that gives a unique phenotypic value and those columns become required fields. For example, if a combination of dataset_name, ID, phenotyping_date is unique for the specific phenotype, those three can be concatenated with '_' in between.
primary_orderThe primary order of a sample
secondary_orderThe secondary order of a sample
clone_IDID of a spefic clone if available (eg. individual tree).
evaluatorPerson who did the phenotyping. Multiple person can be entered with ';' in between. It should match 'contact_name' of the Contact sheet.
site_nameSite information where the stock for the phenotyping is planted. It should match 'site_name' in the 'Site' sheet.
rootstockName of the rootstock if the plant is grafted to a rootstock. It should match a 'stock_name' column of the 'Stock' sheet. If the organism of the rootstock and the sample are different, add the organism as prefix of rootstock separated by double colon '::'. You need to add '#' to separate genus and species.
scionName of scion if the stock is rootstock. It should match a 'stock_name' column of the 'Stock' sheet. If the organism of the scion and the sample are different, add the organism as prefix of scion separated by double colon '::'. You need to add '#' to separate genus and species.
previous_entrystock ID of the previous entry.
data_yearPhenotyping date if only year is known.
institutional_nameInstitutional name of the sample.
repAny repetition number.
plotPlot name.
rowRow.
blockBlock.
positionPosition of the plant.
plant_dateDate of the planting.
pick_dateDate of the sample collection if the collection is done on a different date than the phenotype evaluation.
evaluation_dateDate of phenotype evaluation.
storage_timeTime between collection and phenotyping.
storage_regimeThe condition of sample storage between the collection and phenotyping.
fiber_pkgGroup of samples for phenotyping, can contain samples from multiple germplasm.
commentsAny comments for the phenotyping.
#descriptor_nameSpecial columns (#) : followed by descriptor name.
##property_nameSpecial columns (##) : followed by name of the custom property.
* Required field