MCPD view/report
Passport data (MCPD) is the common information that the users want to see. Although most of those data are in the accession detail section, a view/report would be useful for one or a group of accessions.
Here the "mapping" between MCPD and GRIN-Global.
The rows highlighted in color grey
are not considered in GRIN-Global mapping.
Ref | Acronym (MCPD) | Description (MCPD) | GG-table | GG-field | Comments |
---|---|---|---|---|---|
0 |
PUID |
Persistent unique identifier |
|||
1 | INSTCODE | Institute code | Site | fao_institute_number | |
2 | ACCENUMB | Accession number | Accession | Accession_number_part1, Accession_number_part2 ,Accession_number_part3 | |
3 | COLLNUMB | Collecting number | Accession_Inv_Name | Plant_name | Add category_code COLLNUMB |
4 | COLLCODE | Collecting institute code | Accession_source / Accession_source_map | Accession_source_type / cooperator_id | Add code value "COLLCODE" to ACCESSION_SOURCE_TYPE code group |
4.1 | COLLNAME | Collecting institute name | Cooperator | All fields | |
4.1.1 | COLLINSTADDRDRESS | Collecting institute address | Cooperator | ||
4.2 |
COLLMISSID |
Collecting mission identifier |
|||
5 | GENUS | Genus | taxonomy_genus | genus_name | |
6 | SPECIES | Species | taxonomy_species | species_name | |
7 | SPAUTHOR | Species authority | taxonomy_species | species_authority | |
8 | SUBTAXA | Subtaxon | taxonomy_species | subspecies_name | |
9 | SUBTAUTHOR | Subtaxon authority | taxonomy_species | subspecies_authority | |
10 | CROPNAME | Common crop name | Crop | name | |
11 | ACCENAME | Accession name | Accession_Inv_Name | Plant_name | The name with the lowest number in plant_name_rank / collection name? |
12 | ACQDATE | Acquisition date(YYYYMMDD) | Accession | initial_received_date | |
13 | ORIGCTY | Country of origin | Accession_source | geography_id | |
14 | COLLSITE | Location of collecting site | Accession_source | collector_verbatim_locality | |
15.1 | DECLATITUDE | Latitude of collecting site(Decimal format) | Accession_source | latitude | |
15.2 | LATITUDE |
Latitude of collecting site(Degrees, Minutes, Second format) |
|||
15.3 | DECLONGITUDE | Longitude of collecting site (Decimal degrees format) | Accession_source | longitude | |
15.4 | LONGITUDE |
Longitude of collecting site (Degrees, Minutes, Seconds format) |
|||
15.5 | COORDUNCERT | Coordinate uncertainty [m] | Accession_source | uncertainty | |
15.6 | COORDDATUM | Coordinate datum | Accession_source | georeference_datum | |
15.7 | GEOREFMETH | Georeferencing method | Accession_source | georeference_protocol_code | |
16 | ELEVATION | Elevation of collecting site [masl] | Accession_source | elevation_meters | |
17 | COLLDATE | Collecting date of sample [YYYYMMDD] | Accession_source | Source_date | |
18 | BREDCODE | Breeding institute code | Accession_source / Accession_source_map | Accession_source_type / cooperator_id | Add code value "BREDCODE" to ACCESSION_SOURCE_TYPE code group |
18.1 | BREDNAME | Breeding institute name | Cooperator | All fields | |
19 | SAMPSTAT | Biological status of accession | Accession | improvement_status_code | Add code values to IMPROVEMENT_LEVEL code group |
20 | ANCEST | Ancestral data | Accession_pedigree | description | |
21 | COLLSRC | Collecting/acquisition source | Accession_source | acquisition_source_code | Add code values to ACCESSION_SOURCE_HABITAT_TYPE code group |
22 | DONORCODE | Donor institute code | Accession_source / Accession_source_map | Accession_source_type / cooperator_id | Add code value "DONORCODE" to ACCESSION_SOURCE_TYPE code group |
22.1 | DONORNAME | Donor institute name | Cooperator | All fields | |
23 | DONORNUMB | Donor accession number | Accession_Inv_Name | Plant_name | Add category_code DONORNUMB |
24 | OTHERNUMB | Other identifiers associated with the accession | Accession_Inv_Name | Plant_name | Add category_code OTHERNUMB |
25 | DUPLSITE | Location of safety duplicates | Accession | Backup_location1_site & Backup_location2_site | |
25.1 | DUPLINSTNAME | Institute maintaining safety duplicates | Site | fao_institute_number | |
26 | STORAGE | Type of germplasm storage | Inventory | preservation_method_id (--> Method's table) ? | |
27 | MLSSTAT | MLS status of the accession | Accession_ipr | type_code | |
28 | REMARKS | Remarks | Accession | Note | |
URL | added in app_setting table(optional) | ||||
DOI | DOI | Accession | DOI |
Note. You can find more information on GRIN-Global-Genesys wizard here including the get_passport_data dataview.
@1cgiar