Phenotype Upload Instructions

These instructions will guide you through the process of creating a phenotype trial and uploading the results of the trial to T3. In order to submit data, you must first Create an Account and Login.

If you have any questions about the process, please feel free to Contact Us.

Breeding Program

All data (such as Accessions and Trials) are associated with a particular Breeding Program. Generally, we have a Breeding Program for each University / Institution that submits data to the database.

  1. Make sure your Breeding Program exists in the Database
  2. If it is not listed, add it to the Database (by using the Add New Program button at the bottom of the page)

Locations

A phenotyping trial must be linked to a specific location. Generally, the location of a trial is set as the closest town to the actual field site.

  1. Make sure the Location of your Trial(s) exist in the Databse
  2. If the one or more of your Locations don't exist in the database, you can add them by:
    • Finding the location on the Map, clicking, and filling out the location details form.
    • Uploading a File of location information.
    • View the Managing Locations manual page for more information.
  3. Make sure your Breeding Program is associated with the location.
    • In the Location Table on the Manage > Locations page, the Program column lists all of the Breeding Programs associated with each Location.
    • If your Breeding Program is NOT associated with the Location:
      1. Find the location on the map
      2. Click the Edit link
      3. In the Program select box, ctrl-click / command-click your Breeding Program from the list to add it to the existing Breeding Programs already associated with the location.
      4. Click the Store Location Details button to save your changes.

Accessions

Each Accession / line that is observed in a phenotype trial must have its own entry in the database. In addition, the names used in your trial design must match the names of the Accessions in the database.

  1. Make sure your Accessions exist in the Database
  2. If one or more of your Accessions don't exist in the database, you can add them on the Manage > Accessions page by clicking the Add Accessions or Upload Accession Info link in the top-right corner of that page.
    • View the Managing Accessions manual page for more information.
    • If uploading a spreadsheet of Accessions, a minimum of these columns should be filled in:
      • accession_name: the unique name of the accession
      • species_name: Triticum aestivum
      • organization_names(s): The Breeding Program(s) that originated the Accession

Trials

A phenotyping trial must exist in the database before the results can be added. The Trial contains information about its location, plot and field size, design type, and plot layout. A Trial can be added in two ways:

  • Using the trial design wizard: This will design a plot layout for you given lists of Accessions used as entries and controls, a trial design type, and layout parameters. To design a new trial:
    1. Make sure you have the Accessions used as entries (and optionally as controls) in a List
    2. Go to the Manage > Field Trials page
    3. Click the Design New Trial button in the top-right corner
  • View the Trial Design manual page for more information on adding a trial using the trial design wizard.
  • View the Working with Lists manual page for more information on creating and managing lists

  • Uploading a plot layout spreadhsheet: This option can be used if you've already generated the plot layout and you can create a spreadsheet describing the plot layout for the trial. To upload an existing trial design:
    1. Go to the Manage > Field Trials page
    2. Click the Upload Existing Trial button in the top-right corner
  • View the Trial Upload manual page for more information on uploading a trial design file.

Results

Once a Trial has been created, phenotype observations can be added to the Trial. If you use the Field Book tablet app, you can create a file for recording your observations directly on Field Book. If you already have data, you can download a spreadsheet template specifically for the trial.

  • Using Field Book:
    1. Go to the Trial detail page for your trial
      • Go to the Trial Search page
      • Find your trial
      • Click the name of your trial in the table to open the Trial detail page
    2. Open the Upload Data Files section
    3. Click the Create Field Book button
      • This file can then be used as a field layout file to collect data using the Android Field Book app
    4. After data collection: Click the Upload button next to Android Field Book Exported
    5. Additional files, such as images or raw data files can be uploaded in the Upload Additional Files section
  • View the Using Field Book App section in the manual for more information on collecting field data using the Android tablet app.

  • Uploading Existing Data:
    1. Create a list of Traits that were observed in your trial
    2. Go to the Trial detail page for your trial
      • Go to the Trial Search page
      • Find your trial
      • Click the name of your trial in the table to open the Trial detail page
    3. Open the Upload Data Files section
    4. Click the Create Spreadsheet button next to Phenotyping Spreadsheets
      • Trait List: The list of Traits observed in this Trial
      • Spreadsheet Format: Simple
      • Data Level: Plots (for both plot-level data AND trial-mean data)
        • For plot-level data: Observations at the individual plots can be recorded in each separate plot
        • For trial-mean data: Trial means for each trait will be recorded as a single observation in one plot for each Accession
      • This will create a template, for this specific trial, for adding phenotype observations to
    5. Once data has been entered into the template: Click the Upload button next to Phenotyping Spreadsheets to add the recorded observations.
    6. Additional files, such as images or raw data files can be uploaded in the Upload Additional Files section
  • View the Uploading Spreadsheet Phenotypes manual page for more information on uploading phenotype data as a spreadsheet.
  • View the Working with Lists manual page for more information on creating and managing lists