MangoBase

Intro
File format
Upload inventory
Fix missing seedlots problem
Try submitting inventory again

What is a seedlot inventory?
- Seedlots represent physical seed in packets.
- This seed can be from crosses or for named accessions.
- Seedlots can have a specific location, box, weight(g), and count.
- Seedlots can belong to breeding programs and organizations.
- Seedlots can be used in trials (e.g. they were planted in a plot) and they can be harvested from a plot or plant (e.g. a cross was performed and seeds were collected.)
- A seedlot inventory consists of giving a location and current weight(g) to your seedlots. The seedlot name is the unique identifier for each seedlot and so should be encoded in a barcode on each seedlot packet.
- You can use the "Inventory" Android Application to scan seedlot barcodes and record weight. If you prefer you can create your own CSV file and upload that, if you do not want to use the Inventory Application. For info about the format of the file to upload, go to the next tab.
- For more info about the "Seed Inventory" Android Application go to Inventory.
- It is also possible to manually enter a transaction by going to the seedlot detail page and clicking "Add New Transaction".
Make sure you are collecting seedlot inventory in the following format

The "Seed Inventory" Android Application will export this same exact format by default.
Select your file and upload seedlot inventory

Upload File (.csv):
Fixing the missing seedlot(s) problem
- Seedlots must exist in the database prior to updating or adding inventory. The reason for this is that the inventory does not give information about the content (a named accession or a cross name) and this information is required for a seedlot to exist 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.
Seedlot Inventory Upload Error Messages
Submit your inventory 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 seedlot inventory is in the database

The seedlot inventory file was uploaded successfully

You may want to proceed to the seedlot detail page(s) for the seedlot(s) you just updated.
You can print barcodes for the seedlots.

Finished! Your seedlot inventory is in the database

The seedlot inventory file was uploaded successfully

You may want to proceed to the seedlot detail page(s) for the seedlot(s) you just updated.
You can print barcodes for the seedlots.

Seedlots may be uploaded in a CSV file (.csv)
(Excel .xls and .xlsx format not supported)

Header:
The first row (header) should contain the following:

box_id	seed_id	inventory_date	inventory_person	weight_gram

Required fields:

box_id (the name of the box that the seedlot is in. also called box_name.)
seed_id (unique identifier for the seedlot. must exist in the database. also called seedlot_name)
inventory_date (a timestamp for when the seedlot was inventoried)
inventory_person (the name of the person doing the inventory. can be any name. also called operator_name)
weight_gram (the weight in grams of the seedlot)

Intro
What seedlots do you have?
File format
Upload seedlots
Fix errors in file
Try submitting seedlots again

What are seedlots?
- Seedlots represent physical seed in packets.
- This seed can be from crosses or for named accessions.
- Seedlots can have a specific location, box, weight(g), and count.
- Seedlots can belong to breeding programs and organizations.
- Seedlots can be used in trials (e.g. they were planted in a plot) and they can be harvested from a plot or plant (e.g. a cross was performed and seeds were collected.)
Seedlots fall into two categories

Select One:
Make sure your file matches the correct file format
Provide basic information about the seedlots and upload your file

Breeding Program:

Location of seedlot storage:

Organization Name:

Upload File (.xls):

Upload File (.xls):
Fix all errors in your file
- Accessions must exist in the database prior to adding seedlots of them. The reason for this is that an accession can be exist in many seedlots 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.
- Crosses must exist in the database before adding your seed lots. The reason for this is that a cross can produce many seed lots and so the cross must exists as a separate entity in the database. We also want to be careful about adding new crosses into the database because we do not want data to be incorrectly linked to duplicates.
- When adding crosses into the database, you can upload an Excel file or you can add seedlots one at a time.
Seedlot Upload Error Messages
Submit your seedlots 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 seedlots are now in the database

The seedlot file was uploaded successfully

You may want to proceed to the seedlot detail page(s) for the seedlot(s) you just created.
You can print barcodes for the seedlots.

Finished! Your seedlots are now in the database

The seedlot file was uploaded successfully

You may want to proceed to the seedlot detail page(s) for the seedlot(s) you just created.
You can print barcodes for the seedlots.

Seedlots may be uploaded in an Excel file (.xls)
(.xlsx format not supported)

Header:
The first row (header) must contain the following:

seedlot_name	accession_name	operator_name	amount	weight(g)	description	box_name	quality	source

Required fields:

seedlot_name (must be unique)
accession_name (must exist in the database. the accession_name is the unique identifier for the named genotype)
operator_name (the name of the person who oversaw the inventory process. can be any name.)
amount (number of seeds in seedlot. can be provided in conjunction with weight(g). must provide a value for amount or weight(g) or both.)
AND/OR
weight(g) (weight in grams of seedlot. can be provided in conjunction with amount. must provide a value for amount or weight(g) or both.)
box_name (the box name that the seed is located in. can be any name.)

Optional fields:

description (information about why this seedlot is being added)
quality (status of the seedlot, for example "ok", "moldy", "insect damage" etc.
source (an alternate source, such as a plot or plant identifier from which the seed was sourced if no specific cross experiment was entered in the database)

Note that the columns have to be arranged in the order presented above and carry the correct column headers.

Seedlots may be uploaded in an Excel file (.xls)
(.xlsx format not supported)

Header:
The first row (header) must contain the following:

seedlot_name	cross_unique_id	operator_name	amount	weight(g)	description	box_name	quality	source

Required fields:

seedlot_name (must be unique)
cross_unique_id (must exist in the database. a cross_unique_id can represent a cross between accessions e.g. AxB, but a cross can also represent a cross between specific plots in the field if you have this information)
operator_name (the name of the person who oversaw the inventory process. can be any name.)
amount (number of seeds in seedlot. can be provided in conjunction with weight(g). must provide a value for amount or weight(g) or both.)
AND/OR
weight(g) (weight in grams of seedlot. can be provided in conjunction with amount. must provide a value for amount or weight(g) or both.)
box_name (the box name that the seed is located in. can be any name.)

Optional fields:

description (information about why this seedlot is being added)
quality (brief description of quality, e.g., "ok", "moldy", "insect damage", etc)
source (an alternate source, such as a plot or plant identifier from which the seed was sourced if no specific cross experiment was entered in the database)

Accessions may be uploaded in an Excel file (.xls)
(.xlsx format not supported)

Header:
The first row (header) should contain the following:

accession_name	species_name	population_name	organization_name	synonym	PUI	accession number	acquisition date	biological status of accession code	country of origin	donor	donor PUI	donor institute	genome_structure	institute code	institute name	introgression_backcross_parent	introgression_chromosome	introgression_end_position_bp	introgression_map_version	introgression_parent	introgression_start_position_bp	location_code	ncbi_taxonomy_id	notes	organization	ploidy_level	seed source	state	transgenic	type of germplasm storage code	variety

Comma Separated Fields:

The following fields can take comma-separated values to indicate there are several values for the accession: organization_name, synonym , PUI, accession number, acquisition date, biological status of accession code, country of origin, donor, donor PUI, donor institute, genome_structure, institute code, institute name, introgression_backcross_parent, introgression_chromosome, introgression_end_position_bp, introgression_map_version, introgression_parent, introgression_start_position_bp, location_code, ncbi_taxonomy_id, notes, organization, ploidy_level, seed source, state, transgenic, type of germplasm storage code, variety

Required Fields:

accession_name (must be unique)
species_name (must exist in the database)

Optional Fields:

population_name (a population is a grouping of accessions. if the population already exists in the database, the accession will be added into it, otherwise, the new population will be created.)
organization_name (the name(s) of the organization(s) which use this accession e.g. NARO,IITA)
synonym (an accession can be known by many names including local popular names. a synonym name can be used instead of the accession_name throughout the database; because of this, synonyms must themselves be unique. e.g. accession_synonym1,accession_synonym001)
PUI (permanent unique identifier(s) of the accession)
accession number (accession number(s) for accession from germplasm bank)
acquisition date (date(s) of acquisition YYYYMMDD for accession)
biological status of accession code (code(s) indicating the state of accession)
country of origin (the country(s) of origin)
donor (the accession_name(s) of the donor accession and should be used in conjunction with donor institute and donor PUI)
donor PUI (the permanent unique identifier(s) of the donor accession)
donor institute (the institute(s) of the donor accession(s))
genome_structure (genome structure(s) for accession which take into account ploidy and ancestral genome info e.g. AAA or AB)
institute code ( the institute code(s) of origin)
institute name (the institute name(s) of origin)
introgression_backcross_parent (the backcross parent for introducing an introgression into the accession being added)
introgression_chromosome (the chromosome number that the introgression is on)
introgression_end_position_bp (the end position of the introgression in base pairs)
introgression_map_version (the map version for identifying the start and stop position of the introgression. e.g. AGPv2)
introgression_parent (if the accession you are adding has an introgression that originated from one of the parents you can specify the parent here)
introgression_start_position_bp (the start position of the introgression in base pairs)
location_code (location code(s) for the accession)
ncbi_taxonomy_id (no definition available)
notes (free text for notes)
organization (no definition available)
ploidy_level (no definition available)
seed source (origin(s) of seed source)
state (the state(s) of origin)
transgenic (indicates if accession is transgenic. Please indicate 1 if transgenic and empty if otherwise.)
type of germplasm storage code (code(s) indicating the type of germplasm storage)
variety (variety(s) can be defined as a group of individuals or plants having similar traits that can be reproduced true to type from generation to generation)

Intro
Crossing experiment
Upload your crosses

What are crosses?
- Crosses represent any pollination that occurs.
- Crosses can be of different types (biparental, self, open, backcross, sib, polycross, bulk, bulk_self, bulk_open, or doubled_haploid)
- Depending on the cross type, an individual cross can be defined as between two accessions (e.g. accession A is the female and accession B is the male in a biparental cross)
- For an open pollinated cross, the cross can be defined as between female accession A and male population P1 (populations in the database are only defined as groups of accessions), or between female accession A and unknown male parents
- For backcross cross type, cross unique id can be used as one of the parents.
- An individual cross can be linked to the specific female plot or plant, as well as the specific male plot or plant.
- A cross can have a number of properties associated to it, such as number of flowers, pollination date, etc.
- A cross can produce seed, which goes into a seedlot.
- A cross can ultimately produce progeny, which then become named accessions in the database.
Select a crossing experiment for your crosses

Crossing experiments are for grouping crosses together. The grouping is most often done for crosses derived from the same field trial, the same year, or for crosses that have the same breeding objective.

Enter basic information about the crosses and upload your file

Select a Crossing Experiment:

Select a File Format:

Finished! Your crosses are now in the database

The crosses file was uploaded successfully

You may want to proceed to the cross detail page(s) for the cross(es) you just created.
You can print barcodes for the crosses.
You can add crossing information as it becomes available (e.g. number of seeds, progeny, etc).

Finished! Your crosses are now in the database

The crosses file was uploaded successfully

You may want to proceed to the cross detail page(s) for the cross(es) you just created.
You can print barcodes for the crosses.
You can add crossing information as it becomes available (e.g. number of seeds, progeny, etc).

Crosses may be uploaded in an Excel file (.xls)
(.xlsx format not supported)

Header:
To set up crosses in the database, please provide required information. The first row (header) must contain the following:

cross_unique_id

cross_combination

cross_type

female_parent

male_parent

Required columns:

cross_unique_id (must NOT exist in the database)
cross_combination (required in the header, but value for cross combination (e.g. female accession/male accession) may be left blank)
cross_type (must be one of the following: biparental, self, open, sib, polycross, bulk, bulk_self, bulk_open, or doubled_haploid)
- cross type descriptions:
female_parent (accession names or population names must exist as uniquenames in the database)
male_parent (required in the header, but value may be left blank for most cross types. Must be specified for biparental, sib, polycross and bulk cross types. When specified, accession names or population names must exist as uniquenames in the database)

Additional cross information:

After you establish cross unique ids in the database, you can add additional cross info (e.g. pollination date, total number of flowers pollinated, total number of fruits set) or progenies to the corresponding cross unique ids.
Cross info and progenies can be uploaded via links in crossing experiment detail page or can be added directly in each cross detail page.

Crosses may be uploaded in an Excel file (.xls)
(.xlsx format not supported)

Header:
To set up crosses in the database, please provide required information. The first row (header) must contain the following:

cross_unique_id

cross_combination

cross_type

female_parent

male_parent

female_plot

male_plot

Required columns:

cross_unique_id (must NOT exist in the database)
cross_combination (required in the header, but value for cross combination (e.g. female accession/male accession) may be left blank)
cross_type (must be one of the following: biparental, self, open, sib, polycross, bulk, bulk_self, bulk_open, or doubled_haploid)
- cross type descriptions:
female_parent (accession names must exist as uniquenames in the database)
male_parent (required in the header, but value may be left blank for most cross types. Must be specified for biparental, sib, polycross and bulk cross types. When specified, accession or population names must exist as uniquenames in the database)
female_plot (Plot names must exist in the database)
male_plot (Plot names must exist in the database)

Additional cross information:

After you establish cross unique ids in the database, you can add additional cross info (e.g. pollination date, total number of flowers pollinated, total number of fruits set) or progenies to the corresponding cross unique ids.
Cross info and progenies can be uploaded via links in crossing experiment detail page or can be added directly in each cross detail page.

Crosses may be uploaded in an Excel file (.xls)
(.xlsx format not supported)

Header:
To set up crosses in the database, please provide required information. The first row (header) must contain the following:

cross_unique_id

cross_combination

cross_type

female_parent

male_parent

female_plant

male_plant

Required columns:

cross_unique_id (must NOT exist in the database)
cross_combination (required in the header, but value for cross combination (e.g. female accession/male accession) may be left blank)
cross_type (must be one of the following: biparental, self, open, sib, polycross, bulk, bulk_self, bulk_open, or doubled_haploid)
- cross type descriptions:
female_parent (accession names must exist as uniquenames in the database)
male_parent (required in the header, but value may be left blank for most cross types. Must be specified for biparental, sib, polycross and bulk cross types. When specified, accession or population names must exist as uniquenames in the database)
female_plant (Plant names must exist in the database)
male_plant (Plant names must exist in the database)

Additional cross information:

After you establish cross unique ids in the database, you can add additional cross info (e.g. pollination date, total number of flowers pollinated, total number of fruits set) or progenies to the corresponding cross unique ids.
Cross info and progenies can be uploaded via links in crossing experiment detail page or can be added directly in each cross detail page.

Intro
Add a crossing experiment

What are crossing experiments?

Crossing experiments group crosses. The grouping can reflect crosses done in the same field trial, crosses in a breeding program in a given year, or crosses that have the same breeding objective. This grouping can be used to encapsulate all the crosses done in a crossing block field trial that you have saved in the database (e.g. in Manage Trials your crossing block will appear as a field trial with plots)
Enter basic information about the crossing experiment

Crossing Experiment Name:

Breeding Program:

Location of crossing experiment:

Year:

Description:

Finished! Your crossing experiment is now in the database

Crossing experiment was added successfully

You may want to proceed to the crossing experiment detail page you just created.
You can add or upload crosses into your crossing experiment as they become available.
You can add crossing information as it becomes available (e.g. number of seeds, progeny, etc).

Finished! Your crossing experiment is now in the database

Crossing experiment was added successfully

You may want to proceed to the crossing experiment detail page you just created.
You can add or upload crosses into your crossing experiment as they become available.
You can add crossing information as it becomes available (e.g. number of seeds, progeny, etc).

Accessions	Seedlots
Accessions		Breeding Program	Seedlot Name	Contents	Seedlot Location	Count	Weight(g)

Attribute	Value
Project Name:
Start Date:
End Date:
Event Type:
Event Description:
Event Web URL:

Notice

Before creating a new account, please check if you already have an account using the directory search.
A link will be emailed to you. Please click on it to activate the account.
All fields are required.

First Name:

Last Name:

Organization:

Username:

Username must be at least 7 characters long.

Password:

Password must be at least 7 characters long and different from your username.

Confirm Password:

Password must be at least 7 characters long and different from your username.

Email Address:

An email will be sent to this address requiring you to confirm its receipt to activate your account.

Add New Accessions for Progeny:	Number of progeny:
Use Prefix and/or Suffix:	Prefix: Suffix:

Available Seedlots