In 2022, we were engaged in a project with the Excellence in Breeding (EiB) platform to accompany AfricaRice staff as they transitioned from the BMS to the EBS, through our data curation expertise and experience in supporting Francophone users.
...
| Info |
|---|
AfricaRice BMS germplasm records with GIDs 8000000 or higher were migrated via the database backend, and have been curated as EBS Seed Names, and needed to be migrated via the database backend due to the absence of a germplasm import user interface in the EBS at the time. |
BMS - Germplasm Schema
...
EBS - Core Breeding Schema
...
Steps for migrating AfricaRice BMS germplasm records to EBS Core Breeding (CB) Germplasm
| Note |
|---|
BMS “lot” = EBS “package”. In the EBS, “packages” are program-specific, whereas “lots” are crop-specific (ie. shared across programs) in the BMS. There is a need to create at least one package for each EBS program where the germplasm is used in an experiment. |
A DBMS tool/software like MS Access can link the Germplasm and Names table from the BMS via ODBC driver.
...
EBS CB Program ID for BMS Programs - CB tenant.program table
For the AfricaRice instance in EBS, the IRRI has already assigned program_id for almost all of the programs/projects in the BMS.
The program_id (id) will be needed to assign seed record entries for each breeding team to be able to germplasm list from EBS.
BMS program name | id | program_code | program_name | program_type | description |
Hybrid | 227 | AR-HRB | AR - Hybrid Rice Breeding | breeding | Hybrid |
MANGROVE | 226 | AR-RLB | AR - Rainfed Lowland | breeding | Rainfed Lowland |
Rainfed Lowland | 226 | AR-RLB | AR - Rainfed Lowland | breeding | Rainfed Lowland |
High Elevation | 224 | AR-HEB | High Elevation Breeding | breeding | High Elevation |
Double Haploid | 223 | AR-DHB | AR -Double Haploid Breeding | breeding | Double Haploid |
Rainfed Upland | 228 | AR-RUB | AR - Rainfed Upland Breeding | breeding | Rainfed Upland |
Grain Quality | 230 | AR-GQ | AR - Grain Quality | breeding | Grain Quality |
Breeding Task Force | 187 | AR | AFRICA Rice | breeding | Africa Rice Center |
Plant Health | 229 | AR - PH | AR - Plant Health | breeding | Plant Health |
Irrigated Lowland | 225 | AR-ILB | AR - Irrigated Lowland Breeding | breeding | Irrigated Lowland |
RICE-FP4 | 232 | AR-PHENO | AR - Phenotyping | breeding | AR - Phenotyping |
Genotypage AR | 222 | AR-MB | AR - Molecular Breeding | breeding | MolecularBreeding |
...
Retrieve all variables of all variable types. Consult view AllValidStdVariables and export contents to CSV
...
Retrieve all distinct VARIABLE_ID and ALIAS from projectprop table for all non-deleted studies (study details, trial_instance/environment details (-ENVIRONMENT dataset), traits (-PLOTDATA dataset) - see view AllStudyVariables), along with variable definition (Property-Scale-Method) and categorical scale definitions where appropriate . See view AllValidStdVariables and export contents to CSV
...