1 / 29

WP 6 Database improvement and enrichment Leading partner : BAZ Germany, E. Maul

Council Regulation (EC) N°870/2004 AGRI GEN RES #008 GrapeGen006. WP 6 Database improvement and enrichment Leading partner : BAZ Germany, E. Maul. Short to long term objective : European Vitis database comprising Genres081 data GrapeGen06 data

Download Presentation

WP 6 Database improvement and enrichment Leading partner : BAZ Germany, E. Maul

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Council Regulation (EC) N°870/2004 AGRI GEN RES #008 GrapeGen006 WP 6 Database improvement and enrichment Leading partner : BAZ Germany, E. Maul Short to long term objective: European Vitis database comprising Genres081 data GrapeGen06 data Establishment of a procedure for a continuous follow up even after termination of the project

  2. European Vitis Database: modifications • ECPGR European Central Crop Database • ECPGR Vitis Database: http://www.ecpgr.cgiar.org/Databases/Crops/Vitis.htm • Adaptation of homepage to Prunus Database • Recommendation of the ECPGR Fruit Network Coordinating Group (March 2006) • Adoption of the EURISCO-format • Creation of a partner specific access with option for on-line working (deletion, additions, changes of records) • Download options

  3. Passport descriptors Characterisation and evaluation descriptors SSR-marker descriptors ---------------------------------------- GENRES #081 ---------------------------------------- AGRI RES GEN #008 http://www.bioversityinternational.org/networks/ecpgr/links/ecpgr_search.asp

  4. The European Prunus database

  5. The European Prunus database

  6. The European Prunus database

  7. European Vitis Database: 1st year activities • Partner data • Updating of • Adresses • Collection specifications • Scientists involved • Expertise • Passport data • ØReplacement of the former format by the Multicrop Passport Data Descriptor Format of the EURISCO Database • Ø     Update of the Genres081 partners collection’s passport data, • addition of further collection’s passport data

  8. Partners of Genres#081: verification of adresses

  9. Partners of Genres#081: verification of information

  10. Passport data FAO / IPGRIMULTI-CROP PASSPORT DESCRIPTORS 0 - TRUENESS_TO_TYPE yes, no, not checked 1 - INSTCODE (Institute code) Example: GRC051 2 - ACCENUMB (Accession number) Example: DEU098-1993-296 3 - COLLNUMB 4 - COLLCODE 5 - GENUS. Example : Vitis 6 - SPECIES Example : vinifera 7 - SPAUTHOR Example: L.

  11. Passport data FAO / IPGRIMULTI-CROP PASSPORT DESCRIPTORS 8 - SUBTAXA Example: ssp. sylvestris 9 - SUBAUTHOR 10 - CROPNAME (Common crop name – utilization) Wine grape, table grape, raisin grape, rootstock (ornamental grape, wild grape). If multi-use exists, different uses have to be separated by semicolon without spaces. Example: wine grape;table grape 11 - ACCENAME (Accession name) Designation of the accession Example: Ruländer 12 - ACQDATE (Acquisition date) Date on which the accession entered the collection as YYYYMMDD Example: 1968 Example: 20020620

  12. Passport data FAO / IPGRIMULTI-CROP PASSPORT DESCRIPTORS 13 - ORIGCTY 14 - COLLSITE 15  - LATITUDE 16 - LONGITUDE 17 - ELEVATION 18 - COLLDATE 19 - BREDCODE (Breeding institute code) FAO Institute Code of the institute that has bred the material Example: AUT024 20 - SAMPSTAT (Biological status of accession) Example: 110) Natural = Vitis vinifera ssp. sylvestris Example: 300) Traditional cultivar/landrace = Gouais blanc Example: 412) Hybrid = Geilweilerhof 3-28-46 Example: 500) Advanced/improved cultivar = Rathay 21 - ANCEST (Ancestral data) Example: Pinot x Heunisch Example: Pinot noir open pollination Example: Pinot noir self pollination

  13. Passport data FAO / IPGRIMULTI-CROP PASSPORT DESCRIPTORS • - COLLSCR (Collecting/acquisition source) • 40) Institute, Experimental station, Research organization, Genebank (most cases) • - DONORCODE (Donor institute code) • - DONORNUMB (Donor accession number) • - OTHERNUMB (Other identification (numbers) associated with the • accession) • 26 - DUPLSITE (Location of safety duplicates) • 27 - STORAGE (Type of germplasm storage) • 20) Field collection (most cases) 28 - REMARKS (Remarks) 29 - COLLDESCR (Decoded collecting institute) 30 - BREDDESRC (Decoded breeding institute) 31 - DONORDESCR (Decoded donor institute)

  14. Passport data FAO / IPGRIMULTI-CROP PASSPORT DESCRIPTORS B. Berry color Color of the berry skin: green, green-grey, green-rose, green-red, green-black, grey, grey-rose, rose, red, red-violet, black, black-red, black-grey Example: green-rose C. Country of origin of the variety Code of the country in which the variety originated Example: ARM D. BREDYEAR (Year of crossing) Year in which the variety was created as YYYY Example: 1926 32 - DUPLDESCR (Decoded safety duplication location) 33 - ACCEURL (Accession URL) Vitis specific descriptors: A. Variety Name Name of the variety, after it has been identified with certainty Example: Prokupaz

  15. Passport data • The following data files are provided on CD: • Partner specific passport data from Genres#081 (extracted from the European Vitis database) in the MCPD-format. „vitis_id“ and „partner#accession_number“ have to be maintained and not to be changed. • For non Genres#081 participants an empty data file in the MCPD-format. • Example file from DEU098. • FAO WIEWS Institute Code-list. All partners are requested to verify their adress, phone and fax-numbers and e-mail adress. • Multicrop passport descriptors • Passport data and descriptor recording rules for the compilation of the European Vitis Database (Appendix II of the ECPGR Vitis working group meeting, Palic June 2003)

  16. Characterization and evaluation data

  17. Characterization and evaluation data

  18. Characterization and evaluation data

  19. Characterization and evaluation data

  20. WP 6 Database improvement and enrichment Leading partner : BAZ Germany, E. Maul European Vitis Database: 1st year activities Deadline: Sending of partner specific information and passport data in the MCPD Format Before June 30, 2007

  21. Characterization and evaluation data

  22. Characterization / evaluation search criteria: Characterization/Evaluation/data Select descriptor condition value •  and • and • and •  and •  and •  and •  and •  and •  and Search BACK HOME

  23. Characterization / evaluation search criteria: Characterization/Evaluation/data Select descriptor condition value  and  and  and  and    between 1=closed 3=half open 5=fully open Search BACK HOME

  24. Start/home Grapevine field collection of CZE041 Research Station for Viticulture Praha 6 – Ruzyne CZ - 26718 Karlstein • Multi-crop passport descriptor data, primary and secondary descriptor data, photos • Search criteria: • field collection • sorted by: accession number • accession name • berry color • year of plantation • trueness-to-type • Vitis species • country of origin • use • virus infection • accession number • accession name

  25. Start/home Multi-crop passport descriptor data of CZE041 sorted by accession number new accessions can be added etc.

  26. Start/home Primary and secondary descriptor data of the accession Ryzlink Rynsky Modifications, additions can be carried out new descriptors can be added

  27. Designation of germplasm accessions to AEGIS • Responsibilities: • Ensure the long-term conservation according to agreed quality standards • Provide for safety duplication in another genbank, preferably in a different country • Facilitate access and availability • Documentation of passport, characterization and evaluation data • Keep the aboce mentioned information updated in the ECPGR Vitis database

More Related