Create a Seedlot

A "Seedlot" in the database represents a single vial/flask/container of a stored gametophyte. A single gametophyte genotype might been found in more than one container and would have a separate Seedlot entry in the database for each container, each with a unique name (...-LOTA, ...-LOTB, etc).

Each Seedlot has a "contents" property, which is the name of an Accession entry in the database. This links each Seedlot back to the gametophyte genotype that it contains.

Seedlot Name Seedlot Contents (Accession Name)
SL18-OD-S6-MG1-LOTA SL18-OD-S6-MG1
SL18-OD-S6-MG1-LOTB SL18-OD-S6-MG1
SL18-TI-S1-MG5-LOTA SL18-TI-S1-MG5

Create a New Seedlot

Accessions

Before creating a new Seedlot, it is important to check if the gametophyte exists in the database as an Accession entry. For example, if you're creating a new Seedlot for the gametophyte SL18-OD-S3-MG1, "SL18-OD-S3-MG1" must be an Accession entry.

To check if an Accession exists:

  1. Go to the Search > Accessions page
  2. Enter the name "SL18-OD-S3-MG1" in the search field
  3. Click the Search button to search the database

If the Accession entry exists, you can skip ahead to creating the Seedlot. If not, the Accession entry will have to be added first.

Accessions are added to the database by uploading an Excel file (.xls, old format). At a minimum, the Accession name and species are required. If you're creating multiple Seedlots, multiple Accessions can be added to the Excel file and uploaded at the same time.

Tip: If you want to add the pedigree information, you should also include the parent(s) of any new Accession entries so that way the pedigrees can be updated in the next step. For example, if you're adding a new gametophyte as an Accession, you should also add the sporophyte as an Accession so that way they can be linked together.

An example of an Accession upload file:

accession_name species_name population_name organization_name synonym PUI accession number country of origin notes organization variety
SL18-OD-S3-MG1 Saccharina latissima
SL18-OD-S3 Saccharina latissima
Additional Accessions...

To upload the Accession Excel file:

  1. Go to the Manage > Accessions page
  2. Click the Add Accessions Or Upload Accession Info link near the top-right corner
  3. Select the Uploading a File tab
  4. Choose your Excel file
  5. Click the Continue button to upload your file and check it for errors

Pedigrees

Once the gametophytes and their sporophyte parents have been added to the database, they can be linked together by uploading a Pedigree file. The file format for the pedigree file is a plain-text, tab-delimited file. The easiest way to create a file in this format is to use Excel and save the spreadsheet as a "Tab delimited text (.txt)" file.

An example of a pedigree table:

progeny name female parent accession male parent accession type
SL18-OD-S3-MG1 SL18-OD-S3 SL18-OD-S3 self

To upload the Pedigrees text file:

  1. Go to the Manage > Accessions page
  2. Click the Upload Pedigree File link near the top-right corner
  3. Choose your text file
  4. Click the Validate button to upload your file and check it for errors

At this point, you have your gametophytes and their sporophyte parents added as Accession entries in the database. You can now create Seedlot entries for the gametophytes.


Seedlots

Once you have the gametophytes loaded as Accessions in the database, you can create Seedlot entries for them. There are two ways to add a Seedlot to the database. The first is to fill out a form for each individual Seedlot. If you have many Seedlots to add to the database, you can upload an Excel file with the information to add them in bulk.

To create a single Seedlot:

  1. Go to the Manage > Seedlots page
  2. Click the Create Seedlots button and select Add New Seedlot
  3. Fill out the properties of the Seedlot:
    • Name: unique name of the Seedlot, ex: SL18-OD-S3-MG1-LOTA
    • Breeding Program: Mariner5
    • Location: Where the Seedlot is stored, ex: WHOI or University of Connecticut
    • Box Name: Lab location of the Seedlot, ex: shelf/tray/room code
    • Contents: Accession name, ex: SL18-OD-S3-MG1
    • Amount (number of seeds): 1 for all Seedlots, since it's required
    • Organization: WHOI or UCONN
  4. Click the OK button to add the Seedlot to the database



To upload multiple Seedlots:

Create an Excel (.xls, old format) file with the following information:

seedlot_name accession_name operator_name amount weight(g) description box_name quality source
SL18-OD-S3-MG1-LOTA SL18-OD-S3-MG1 your database username 1 shelf/tray/room code
Additional Seedlots...

Once you have your Excel file, you can upload it to the database by:

  1. Go to the Manage > Seedlots page
  2. Click the Create Seedlots button and select Upload Seedlots
  3. On Step 2 of the workflow, Select the option for named accessions
  4. On Step 4 of the workflow:
    • Location = WHOI or University of Connecticut
    • Organization = WHOI or UCONN
    • Choose your Excel file
  5. Click the Upload Seedlots button to upload your file and check for errors


Split an Existing Seedlot

If an existing Seedlot has been split into another container, the easiest way to create a new Seedlot entry for the new Seedlot is to use the "Split Seedlot" tool. This will duplicate the properties of the existing Seedlot and give the new Seedlot a new -LOT{abc} identifier.

  1. Go to the Manage > Seedlot Maintenance page
  2. Expand the Seedlot Maintenance Tools section
  3. In the Split Seedlot tool, enter the name of the existing Seedlot to split
  4. The new Seedlot attributes will be automatically added, adjust any that need to be changed
  5. Enter 1 for the Amount / Count of the New Seedlot Contents
  6. Click the Create Seedlot button to create the new Seedlot



Powered By


Version
164667ad5   sgn-404.0
Fri Dec 20 07:29:02 2024 -0500