This site uses cookies to provide logins and other features. Please accept the use of cookies by clicking Accept.
New to the database?
What are you interested in? For General Help
Upload an experimental field trial into the database that you have saved on your computer in Excel
Design a completely new experimental field trial in the database
Catalog your available seed inventory into the database
Upload phenotypic data into the database that you have saved on your computer in Excel
Plan tissue sampling
Upload crosses and crossing information into the database
Print barcode labels for my experiment (for your plots or plants or tissue samples in the field, or for your 96 well plate and tissue samples)
Analyze phenotypic performance across trials
Prepare a 96 or 384 well plate for a genotyping experiment
Upload VCF genotypic data
Tissue Sampling
- Intro
- Sampling Level
- Select a field trial
- Plant Entries
- Create Tissue Sample Entries
-
This workflow will guide you through tissue sampling an experiment
Tissue samples collected from the field are linked to a single plant, which is in turn linked to a single plot.
Many tissue samples can be created for each plant.
Each tissue sample has a globally unique name.
A unique tissue sample is present in each well of a genotyping plate (96 or 384 well plates).
The tissue sample in a 96 well plate can originate from another tissue sample name, plant name, plot name, or accession name.
-
Accession Level: The sample is not from a field trial entity and only the accession name is known.
At which level do you plan to keep track of your sampling?
Plot Level: Each plot in the field has a unique identifier, ideally with a barcode label.
Plant Level: Each plant in the field has a unique identifier, ideally with a barcode label.
Tissue Sample Level: Each tissue sample collected from the field has a unique identifier, ideally with a barcode label.
-
Select a field trial
Field trial is not relevant for the type of tissue sampling you selected. Go to next step.
Select Trial name Description Breeding program Folder Year Location Trial type Design Planting Date Harvest Date Download
-
Plant entries in your field trial
Plant entries not relevant for the type of tissue sampling you selected. Go to next step.
Plant entries exist for this trial. Go to next step.
Please create plant entries for this trial.
-
Create tissue sample entries for this trial
Field trial tissue sample entries not relevant for the type of tissue sampling you selected. Go to next step.
Tissue sample entries exist for this trial. Go to next step.
Complete! You have all the entities you need to conduct your sampling.
- All of the entities that you want to sample are saved in the database and available to use!
- You can print barcodes for the entities you intend to sample on. These barcodes can be attached to your collection vials/containers to assist during sampling.
- After you have finished sampling, you can use these entities as source material for a genotyping plate (96 or 384 well plate). Click the button below to create a genotyping plate now, if you will create a 96 or 384 well plate.
- The Android Coordinate application can help you create 96 or 384 well plates. Alternatively you can create your plate layout in Excel and upload it.
Complete! You have all the entities you need to conduct your sampling.
- All of the entities that you want to sample are saved in the database and available to use!
- You can print barcodes for the entities you intend to sample on. These barcodes can be attached to your collection vials/containers to assist during sampling.
- After you have finished sampling, you can use these entities as source material for a genotyping plate (96 or 384 well plate). Click the button below to create a genotyping plate now, if you will create a 96 or 384 well plate.
- The Android Coordinate application can help you create 96 or 384 well plates. Alternatively you can create your plate layout in Excel and upload it.
Workflow for seedlot inventory
I have new seedlots that need to be added into the database.
I conducted an inventory (in weight(g)) and want to update the database to reflect the current state of the inventory.
Upload Existing Trial(s)
- Intro
- File Formatting
- Enter trial information
- Trial Linkage
- Fix missing accessions problem
- Fix missing seedlots problem
- Try submitting trial again
-
This workflow will guide you through uploading a new trial or trials into the database
A field trial represents plots in the field where each plot has a globally unique plot_name, a sequential plot_number that is unique in the trial (e.g. 101, 102, 103 for three separate plots), and an accession_name representing the genotype being tested in that plot. In cases where a cross/family is being evaluated (e.g. F1 hybrid, backcrossing), a cross_unique_id or a family_name can be used instead of an accession_name. Each plot can belong to different blocks (block_number) and reps (rep_number) depending on the experimental design you are using (e.g. complete block vs augmented design). Each plot can have a row_number and col_number indicating the relative position of the plot in the field.
If a specific accession is a check or control, you can indicate the plots that that accession is planted in as controls using is_a_control.
You can provide the specific seedlot_name planted in each plot, along with the number of seeds (num_seed_per_plot) and/or the weight (g) of seed (weight_gram_seed_per_plot) that were used. For plots of family name stock type, seedlots of cross members in the family can be used.
A trial can represent a yield trial, a phenotyping trial, a crossing block, a greenhouse, a nursery, etc.
A plot can have many plants, which the database can track as separate entities, allowing you to record plant level observations and information.
Plots can be named manually, automatically by the database, or in accordance with a plot naming template. Visit the Autogenerated Name Metadata section of your breeding program page to create plot name templates.
-
File format information
Single trial spreadsheet
Single Trial Designs may be uploaded using any of the supported file types: MS Excel (.xls or .xlsx), comma-separated file (.csv), LibreOffice / OpenOffice OpenDocument spreadsheet (.ods), tab-delimited file (.txt or .tsv), or semicolon-separated file (.ssv).
Optional columns may be left out, if not used in your data.
File format information
Multiple trial spreadsheet
Multiple Trial Designs may be uploaded using any of the supported file types: MS Excel (.xls or .xlsx), comma-separated file (.csv), LibreOffice / OpenOffice OpenDocument spreadsheet (.ods), tab-delimited file (.txt or .tsv), or semicolon-separated file (.ssv).
Optional columns may be left out, if not used in your data.
-
Enter information about the experiment and upload your trial layout
-
Is your trial linked with other field trials, genotyping plates, or crossing experiments in the database? If you are unsure, you can skip this. This information can be added from the trial detail page after the trial is saved.
If you go on to collect tissue samples for creating a 96 well plate for genotyping, when adding the genotyping plate (96 well plate layout) to the database you can use plot names or plant names or tissue sample names from this field trial. By doing so, we can create linkage between this field trial and the genotyping plate.
If you go on to perform crosses on this field trial, each cross can be linked to specific female and male plots. When you upload these crosses we can then automatically link this field trial to the crossing experiment in the database.
Check this box to ignore any possible warning messages and save the trial to the database.
-
Fixing the missing accession(s) problem
- Accessions tested in your trial must exist in the database prior to adding your trial. The reason for this is that an accession can be tested in many trials and therefore exists as a separate entity in the database. We also want to be careful about adding new accessions into the database because we do not want incorrectly duplicated data.
- When adding accessions into the database, you can use either a list of accessions or an Excel file.
Trial Upload Error Messages
-
Fixing the missing seedlot(s) problem
- Seedlots tested in your experimental trial must exist in the database prior to adding your trial. The reason for this is that a seedlot can be tested in many trials and therefore exists as a separate entity in the database. We also want to be careful about adding new seedlots into the database because we do not want data to be incorrectly linked to duplicates.
- When adding seedlots into the database, you can upload an Excel file or you can add seedlots one at a time.
Trial Upload Error Messages
-
Submit your trial again. You should have corrected all errors by now, but if not please take a look at the errors in the red box below. You can continue to modify your file and then click Upload until it works.
There exist these problems in your file:
Finished! Your trial is now in the database
The trial file was uploaded successfully
- You may want to proceed to the trial detail page for the trial you just created.
- You can print barcodes for the plots or plants or tissue samples in this trial.
- You an add phenotypes for the plots or plants in this trial now.
Finished! Your trial is now in the database
The trial file was uploaded successfully
- You may want to proceed to the trial detail page for the trial you just created.
- You can print barcodes for the plots or plants or tissue samples in this trial.
- You an add phenotypes for the plots or plants in this trial now.
Upload Template Information
Stock type being evaluated in this trial: accession
Stock type being evaluated in this trial: accession
|
The first row (header) must contain the following:
| plot_name | accession_name | plot_number | block_number | is_a_control | rep_number | range_number | row_number | col_number | seedlot_name | num_seed_per_plot | weight_gram_seed_per_plot | entry_number |
plot_name,accession_name,plot_number,block_number,is_a_control,rep_number,range_number,row_number,col_number,seedlot_name,num_seed_per_plot,weight_gram_seed_per_plot,entry_number
Stock type being evaluated in this trial: cross unique id
Stock type being evaluated in this trial: cross unique id
|
The first row (header) must contain the following:
| plot_name | cross_unique_id | plot_number | block_number | is_a_control | rep_number | range_number | row_number | col_number | seedlot_name | num_seed_per_plot | weight_gram_seed_per_plot | entry_number |
plot_name,cross_unique_id,plot_number,block_number,is_a_control,rep_number,range_number,row_number,col_number,seedlot_name,num_seed_per_plot,weight_gram_seed_per_plot,entry_number
Stock type being evaluated in this trial: family name
Stock type being evaluated in this trial: family name
|
The first row (header) must contain the following:
| plot_name | family_name | plot_number | block_number | is_a_control | rep_number | range_number | row_number | col_number | seedlot_name | num_seed_per_plot | weight_gram_seed_per_plot | entry_number |
plot_name,family_name,plot_number,block_number,is_a_control,rep_number,range_number,row_number,col_number,seedlot_name,num_seed_per_plot,weight_gram_seed_per_plot,entry_number
- accession_name or cross_unique_id or family_name (must exist in the database. This is the accession or cross unique id or family name being tested in the plot.)
- plot_number (a sequential number for the plot in the field (e.g. 1001, 1002, 2001, 2002). These numbers should be unique for the trial.)
- block_number (a design parameter indicating which block the plot is in)
- plot_name (must be unique across entire database. If not provided in the file, it will be automatically generated as
{trial_name}-PLOT_{plot_number}, or according to a plot name template if specified.) - is_a_control (type 1 in this field if the plot is a control, otherwise leave blank. generally you will have accessions/cross unique ids/family names that are controls, so you should indicate the plots of those accessions/cross unique ids/family names as a control.)
- rep_number (replicate number, numeric)
- range_number (range number. often synonymous with col_number, numeric)
- row_number (row number. If the field is a grid, this represents the y coordinate, numeric, required for field map generation.)
- col_number (column number. If the field is a grid, this represents the x coordinate. Sometimes called range_number, numeric, required for field map generation.)
- seedlot_name (the seedlot from where the planted seed originated. Must exist in the database. For plots of family name stock type, seedlots of cross members in the family can be used.)
- num_seed_per_plot (number seeds per plot. Seed is transferred from seedlot mentioned in seedlot_name. Numeric)
- weight_gram_seed_per_plot (weight in gram of seeds in plot. seed is transferred from seedlot mentioned in seedlot name. Numeric)
- entry_number (a trial-level entry number assigned to the stock. Numeric)
- intercrop_accession_name (the name(s) of additional accessions that are planted in this plot along with the primary accession. the name(s) must already exist in the database. if you have more than one intercropped accession, you can include each name separated by a comma in one column or include additional columns with this header.)
- Experimental treatments are handled in much the same way as phenotypes, and can be uploaded from the trial detail page after trial creation. They may also be included as additional columns in a trial upload, formatted as
experimental treatment|EXPERIMENT_TREATMENT:0000001
Only the required fields are necessary to include in the upload template. You may add any additional optional fields. The fields can be in any order.
Upload Template Information
Multiple Trial Designs:
Header:
The first row (header) must contain the following, which is an expansion of the single trial design header:
| trial_name | breeding_program | location | year | transplanting_date | design_type | description | trial_type | trial_stock_type | plot_width | plot_length | field_size | planting_date | harvest_date | plot_name | accession_name | plot_number | block_number | is_a_control | rep_number | range_number | row_number | col_number | seedlot_name | num_seed_per_plot | weight_gram_seed_per_plot | entry_number |
trial_name,breeding_program,location,year,transplanting_date,design_type,description,trial_type,trial_stock_type,plot_width,plot_length,field_size,planting_date,harvest_date,plot_name,accession_name,plot_number,block_number,is_a_control,rep_number,range_number,row_number,col_number,seedlot_name,num_seed_per_plot,weight_gram_seed_per_plot,entry_number
Notes:If the stocks that are being evaluated in any trial are crosses or family names, trial_stock_type column is required and indicates as 'cross' or 'family_name'. All rows for the same trial must have the same trial stock type.
Required fields:- trial_name (Must be unique across entire database. It is often a concatenation of the year, transplanting_date, purpose, unique number, and location.)
- breeding_program (The name of breeding program that managed the trial, must exist in the database.)
- location (The name or abbreviation of the location where the trial was held, must exist in the database.)
- year (The year the trial was held.)
- design_type (The shorthand for the design type, must exist in the database. Possible values include CRD (Completely Randomized Design), RCBD (Randomized Complete Block Design), RRC (Resolvable Row-Column), DRRC (Doubly-Resolvable Row-Column), URDD (Un-Replicated Diagonal Design), ARC (Augmented Row-Column), Alpha (Alpha Lattice Design), Lattice (Lattice Design), Augmented (Augmented Design), MAD (Modified Augmented Design), greenhouse (undesigned Nursery/Greenhouse), splitplot (Split Plot), stripplot (Strip Plot / Split Block), p-rep (Partially Replicated), Westcott (Westcott Design))
- description (Additional text with any other relevant information about the trial.)
- accession_name OR cross_unique_id OR family_name (The accession, cross, or family being tested in the plot, must exist in the database.)
- plot_number (A sequential number for the plot in the field (e.g. 1001, 1002, 2001, 2002). These numbers should be unique for the trial.)
- block_number (A design parameter indicating which block the plot is in.)
- plot_name (Must be unique across entire database. If not provided in the file, it will be automatically generated as
{trial_name}-PLOT_{plot_number}) - plot_name_template (The name of a saved plot name template. Must be coherent with the breeding program supplied, and only one is allowed per trial. Can be used in place of plot_name.)
- trial_type (The name of the trial type, must exist in the database. Possible values include Seedling Nursery, phenotyping_trial, Advanced Yield Trial, Preliminary Yield Trial, Uniform Yield Trial, Variety Release Trial, Clonal Evaluation, genetic_gain_trial, storage_trial, heterosis_trial, health_status_trial, grafting_trial, Screen House, Seed Multiplication, crossing_block_trial, Specialty Trial)
- trial_stock_type (The type of stocks that are being evaluated in the trial. Can be either 'accession', 'cross', or 'family_name'. When not provided, 'accession' is used as the default)
- plot_width (plot width in meters)
- plot_length (plot length in meters)
- field_size (field size in hectares)
- planting_date (Date of Planting in YYYY-MM-DD format)
- transplanting_date(The transplanting_date of the trial was conducted. Date in YYYY-MM-DD format)
- harvest_date (Date of Harvest in YYYY-MM-DD format)
- is_a_control (type 1 in this field if the plot is a control, otherwise 0 or leave blank. generally you will have accessions that are controls, so you should indicate the plots that that accession is in as a control.)
- rep_number (replicate number, must be numeric)
- range_number (range number. often synonymous with col_number, must be numeric)
- row_number (row number. if the field is a grid, this represents the y coordinate, numeric, required for field map generation.)
- col_number (column number. if the field is a grid, this represents the x coordinate. sometimes called range_number, numeric, required for field map generation.)
- seedlot_name (the seedlot from where the planted seed originated. must exist in the database. For plots of family name stock type, seedlots of cross members in the family can be used.)
- num_seed_per_plot (number seeds per plot. seed is transferred from seedlot mentioned in seedlot_name. numeric)
- weight_gram_seed_per_plot (weight in gram of seeds in plot. seed is transferred from seedlot mentioned in seedlot name. numeric)
- entry_number (a trial-level entry number assigned to the stock. Numeric)
- intercrop_accession_name (the name(s) of additional accessions that are planted in this plot along with the primary accession. the name(s) must already exist in the database. if you have more than one intercropped accession, you can include each name separated by a comma in one column or include additional columns with this header.)
- Experimental treatments are handled in much the same way as phenotypes, and can be uploaded from the trial detail page after trial creation. They may also be included as additional columns in a trial upload, formatted as
experimental treatment|EXPERIMENT_TREATMENT:0000001
Trials may be uploaded using any of the supported file types: MS Excel (.xls or .xlsx), comma-separated file (.csv), LibreOffice / OpenOffice OpenDocument spreadsheet (.ods), tab-delimited file (.txt or .tsv), or semicolon-separated file (.ssv).
Optional columns may be left out, if not used in your data.
Upload Trial Metadata
This upload can be used to update the metadata of trials that have already been added to the database
Any metadata provided in the upload file will replace any existing metadata. Blank values in the upload file will leave the existing metadata unchanged.
|
|
File format information
|
Trial Metadata may be uploaded using any of the supported file types: MS Excel (.xls or .xlsx), comma-separated file (.csv), LibreOffice / OpenOffice OpenDocument spreadsheet (.ods), tab-delimited file (.txt or .tsv), or semicolon-separated file (.ssv).
Optional columns may be left out, if not used in your data.
Upload Trial Metadata Template Information
The first row (header) should contain the following:
| trial_name | breeding_program | folder | location | year | transplanting_date | planting_date | harvest_date | design_type | description | trial_type | plot_width | plot_length | field_size |
- trial_name: the name of the trial (must already exist in the database)
Optional values:
- new_trial_name (A new name for the trial, must not already exist in the database)
- breeding_program (The name of breeding program that managed the trial, must exist in the database.)
- folder (The name of the folder to display the trial in on the Manage > Field Trials page. If the folder does not exist, a new one will be created under the trial's breeding program)
- location (The name or abbreviation of the location where the trial was held, must exist in the database.)
- year (The year the trial was held.)
- transplanting_date (The transplanting_date of the trial was conducted. Date in YYYY-MM-DD format or 'remove' to remove the date)
- planting_date (Date of Planting in YYYY-MM-DD format or 'remove' to remove the date)
- harvest_date (Date of Harvest in YYYY-MM-DD format or 'remove' to remove the date)
- design_type (The shorthand for the design type, must exist in the database. Possible values include CRD (Completely Randomized Design), RCBD (Randomized Complete Block Design), RRC (Resolvable Row-Column), DRRC (Doubly-Resolvable Row-Column), URDD (Un-Replicated Diagonal Design), ARC (Augmented Row-Column), Alpha (Alpha Lattice Design), Lattice (Lattice Design), Augmented (Augmented Design), MAD (Modified Augmented Design), greenhouse (undesigned Nursery/Greenhouse), splitplot (Split Plot), p-rep (Partially Replicated), Westcott (Westcott Design))
- description (Additional text with any other relevant information about the trial.)
- trial_type (The name of the trial type, must exist in the database. Possible values include Seedling Nursery, phenotyping_trial, Advanced Yield Trial, Preliminary Yield Trial, Uniform Yield Trial, Variety Release Trial, Clonal Evaluation, genetic_gain_trial, storage_trial, heterosis_trial, health_status_trial, grafting_trial, Screen House, Seed Multiplication, crossing_block_trial, Specialty Trial)
- plot_width (plot width in meters)
- plot_length (plot length in meters)
- field_size (field size in hectares)
Trial Metadata may be uploaded using any of the supported file types: MS Excel (.xls or .xlsx), comma-separated file (.csv), LibreOffice / OpenOffice OpenDocument spreadsheet (.ods), tab-delimited file (.txt or .tsv), or semicolon-separated file (.ssv).
Optional columns may be left out, if not used in your data.
Stock type being evaluated in this trial: accession
Stock type being evaluated in this trial: accession

