SGN Documentation

View the Project on GitHub solgenomics/sgn

Home   3. Managing Breeding Data  

3.4 Managing Seed Lots

Seedlots are different from Accessions in that they represent the physical seed being evaluated in an experiment. Seedlots have things like physical storage locations and seed quantities, which accessions do not. The seed in seedlots can be from crosses or can be named accessions. Seedlots from crosses would represent seed harvested. Click Manage and then Seed Lots to begin.

3.4.1 Add New Seedlot(s)

To add a single new seedlot, click on “Add Seedlot”. This will bring up the following dialog where you enter information about where the seedlot exists, what accession or cross is contained in it, and how many seeds there are. A seedlot must contain either an accession or a cross, and not both. A seedlot must have a weight in grams or a seed count or both of these.

In the case where you have many seedlots to add to the database, you can upload an excel XLS file instead. Click “Upload Seedlots” to see the following dialog.

3.4.2 Seedlot Transactions

Seedlots are capable of tracking where seeds came from, such as from crosses, and to where seeds go, such as to plots in the field. If you navigate to a seedlot detail page you will see the following.

On this page you see and can edit information regarding a single seedlot, such as its name and location. You will also see a table indicating all t he transactions that a seedlot has been involved in, such as if it was planted in a plot in the field. Transactions to field plots are created when adding or uploading a new trial or from a trial’s detail page. Clicking on “Add New Transaction” let you add a transaction from between this seedlot and another seedlot. This kind of transaction is useful for representing if you have distributed seed to different locations.

3.4.3 Seed Inventory

To inventory your seed: 1) Make sure your seedlots are in the database. Use “Add New Seedlot” to add a single seedlot or “Upload New Seedlots” to add many. 2) Make sure your seedlots are barcoded. You can print these barcodes from the database. 3) Use the “Inventory” Android Application to scan seedlot barcodes and record weight. Then use “Upload Inventory” to upload this info into database. If you prefer you can create your own CSV file and upload that, if you do not want to use the Inventory Application. For more info about the “Inventory” Android Application go to Inventory.

Clicking the “Upload Inventory” button will bring the following dialog:

The CSV file that should contain your inventory should meet these Template requirements. The Seed Inventory Android Application exports this exact file.

3.4.4 Find Seedlots For a List of Accessions

A convenient tool for searching available seedlots for a list of accessions is available in the list tool. First open up your list of accessions. For help opening a list of accessions please see the List section help. There is a button called “See Available Seedlots”.

Once you click this, you will see the following table in a dialog. From here you can create a list of seedlots using the checkboxes and the input at the bottom.

3.4.5 Create a seedlot for an Accession or Cross

Complementary to what we saw above for creating seedlots from the “Manage Seedlots” page, it is possible to create a new seedlot from an accession’s detail page or from the cross detail page. On the accession detail page, this is visible in the “Related Stocks” section as seen below. The cross detail page has an identical section. Notice the link for creating a new seedlot, which streamlines adding the seedlot.

3.4.6 Add quality data to a seedlot

Quality information can be added to a seedlot in the quality field. This is also available as a column in the file upload format. It is recommended to use a controlled vocabulary, defined by the user, for the quality field. For example, good quality seed should be labelled “ok”, whereas other quality descriptors could be “moldy”, “insect damage”, or “low sprouting”, etc.

3.4.7 Seedlot Maintenance Events

For some crops, such as sugar kelp, a “seedlot” requires routine maintenance for the successful long-term storage of the seedlot. (For example, a Seedlot Maintenance Event for sugar kelp would be the routine change of the water that gametophytes are kept it). Breedbase can now store a record of these Seedlot Maintenance Events associated directly with existing Seedlots. Maintenance Events can be uploaded using a simple Excel template or recorded directly on the website.

Setup

Each Breedbase instance needs to be configured to support the storage of Seedlot Maintenance Events since each crop will have their own distinct set of maintenance events for their seedlots. To check if your Breedbase instance supports this feature, go to the Manage menu and select the Seed Lots page. Make sure you are logged in and look for the Seedlot Maintenance button near the top, next to the Create Seedlot(s) and Upload Inventory buttons. If you don’t see this button, contact the developer(s) supporting your Breedbase instance and ask if they can setup this feature.

The Manage Seedlots page showing the location of the Seedlot Maintenance button The location of the Seedlot Maintenance button on the Manage > Seed Lots page

Adding Events

Seedlot Maintenance Events can be added using two methods: 1) Uploading an Excel template or 2) Recording events directly on the website

Uploading Events with Excel Template

To bulk-upload a file of Seedlot Maintenance Events, first create an Excel (.xls) file with the following headers:

Once you have an Excel file with the events filled out, follow these steps to upload the events to the database:

  1. Make sure you are logged in to your Breedbase instance
  2. Go to the Manage > Seed Lots page
  3. Select the Seedlot Maintenance button
  4. Select the Upload Maintenance button
  5. Choose your Excel (.xls) file to upload
  6. Select the Upload button

The Seedlot Maintenance upload dialog The Seedlot Maintenance upload dialog, showing the supported event types and values (for sugar kelp)

Recording Events on Website

To add individual Seedlot Maintenance Events to the database in real time, as they’re being recorded, use the Record Maintenance page. Follow these steps to record Seedlot Maintenance Events:

  1. Make sure you are logged in to your Breedbase instance
  2. Go to the Manage > Seed Lots page
  3. Select the Seedlot Maintenance button
  4. Select the Record Maintenance button
  5. Enter the Seedlot Name or scan a barcode that has the Seedlot Name encoded. Once entered, the box at the top of the page will display basic information about the Seedlot as well its recently recorded events.
  6. Select or Enter the values of individual events
  7. Optionally, notes button next to each event to add additional notes/comments about that specific event
  8. Make sure the operator/username and timestamp are correct
  9. Select the Submit button to add the recorded events to the database. NOTE: any events that remain selected as “Not Recorded” will not be submitted to the database.

The Seedlot Maintenance record page The Seedlot Maintenance record page, as configured for sugar kelp

Displaying Events

Recently recorded Seedlot Maintenance Events are displayed in a table from the main Seedlot Maintenance page, as well as the detail page for individual Seedlots.

Unfiltered table of recent Seedlot Maintenance events Unfiltered table of recent Seedlot Maintenance events

The events displayed in these tables are sorted by timestamp, with the most recently recorded events displayed first. The displayed events can be filtered using any number of supported filter criteria, such as:

Select the properties of the filter(s) you want to apply, then select the Add button next to the button to add the filter to the list of applied filters. Once you’re done adding filters, select the Filter button to search the database for the filtered events.

A filtered table of Seedlot Maintenance events A filtered table of Seedlot Maintenance events

The filtered events can be downloaded directly from the table using the Excel or CSV buttons at the top of the table. Or Seedlot Maintenance Events can be bulk-downloaded (this includes all events for a Seedlot) using a list of Seedlots from the main downloads page (see below).

Downloading Events

To bulk-download all events for a specific subset of Seedlots:

  1. Create a list containing the Seelots you are interested in.
  2. Go to the Download Using Lists page (Manage > Download)
  3. Find the Download Seedlot Maintenance Events section
  4. Select your list of Seedlots
  5. Select the Download button to generate the download file

The downloaded file will follow the same format as the upload template and will contain all recorded Seedlot Maintenance Events for each Seedlot in the list.