1 / 32

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

Council Regulation (EC) N°870/2004 AGRI GEN RES #008 GrapeGen06. Second Annual Workshop of GrapeGen06 Gödöllő, Hungary – 8th to 10th July 2008. WP 6 Database improvement and enrichment Leading partner : JKI Germany, E. Maul. The European Vitis Database ( www.eu-vitis.de ).

nate
Download Presentation

WP 6 Database improvement and enrichment Leading partner : JKI 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 GrapeGen06 Second Annual Workshop of GrapeGen06 Gödöllő, Hungary – 8th to 10th July 2008 WP 6 Database improvement and enrichment Leading partner : JKI Germany, E. Maul

  2. The European Vitis Database (www.eu-vitis.de) Short to medium term objectives: • Storage and retrieval of • MCPD-data • ampelographic descriptor data • photos • SSR-marker data • On-farm maintenance • Vitis sylvestris preservation • Trueness to type ascertainment Establishment of a procedure for a continuous follow up even after termination of the project Genetic resources management and monitoring

  3. The European Vitis Database (www.eu-vitis.de) Achievements until June 2008: Public access • Quick search - (MCPD) • Advanced search - (MCPD, descriptor data are not yet available) • Photo search Descriptors Links

  4. The European Vitis Database (www.eu-vitis.de) Tabular listing: - Status quo and future options of the database

  5. The European Vitis Database (www.eu-vitis.de)

  6. The European Vitis Database (www.eu-vitis.de)

  7. The European Vitis Database (www.eu-vitis.de)

  8. The European Vitis Database (www.eu-vitis.de) Advanced search: characterization and evaluation data Ampelographic data 2007 2008 2008 etc. SSR-marker data 2008 2008 etc. Photos X X etc. Exportation of the data • Passport data • Characterisation data • SSR-marker data

  9. The European Vitis Database (www.eu-vitis.de) Advanced search: characterization and evaluation data Accename Color of berry skin Cultivar name Holding institution Accession number Species Country of origin of the cultivar Year of observation

  10. The European Vitis Database (www.eu-vitis.de) • Summary of applications intended to be developed until the end of 2008: • Set up of 3 different access levels (public access, all partner access and partner specific access) • Search function for descriptor data • Development of modules enabling partner specific modification of data records: addition, updating and deletion of single records • Uploading of data files • Downloading of records • Development of a log book documenting the user activities, encompassing user id, update-time and summarizing the intervention • Photo gallery

  11. The European Vitis Database (www.eu-vitis.de) • Additional programming work to be arried out: • GrapeGen06 specific modules: • On-farm maintenance • Vitis sylvestris preservation • Trueness to type ascertainment

  12. The European Vitis Database (www.eu-vitis.de) Discussion: - MCPD-lists? Encountered difficulties - Importance of a unique accession number - Partner contact data, expertise - Descriptor data: static or dynamic search? - Cultivar name, accession name and synonyms. How to sort out collections respectively the database and to assign cultivar names? - Layout, functionality etc. of the database - Photo gallery necessary?

  13. The European Vitis Database (www.eu-vitis.de) Discussion: - MCPD-lists? Encountered difficulties - Importance of a unique accession number - Partner contact data, expertise - Descriptor data: static or dynamic search? - Cultivar name, accession name and synonyms. How to sort out collections respectively the database and to assign cultivar names? - Layout, functionality etc. of the database - Photo gallery necessary?

  14. The European Vitis Database (www.eu-vitis.de) Importance of the accession number: Multi crop passport descriptor data Key field = accession number Ampelographic descriptor data Photos SSR-marker data Trueness to type ascertainement On farm data Location data Genotype data Vitis vinifera subsp. sylvestris data Population data Genotype data

  15. The European Vitis Database (www.eu-vitis.de) Discussion: - MCPD-lists? Encountered difficulties - Importance of a unique accession number - Partner contact data, expertise - Descriptor data: static or dynamic search? - Cultivar name, accession name and synonyms. How to sort out collections respectively the database and to assign cultivar names? - Layout, functionality etc. of the database - Photo gallery necessary?

  16. Presentation of participating institutes as in Genres#081

  17. Partners of Genres#081: verification of additional information New partners within GrapeGen06: transmisson of additional information

  18. The European Vitis Database (www.eu-vitis.de) Discussion: - MCPD-lists? Encountered difficulties - Importance of a unique accession number - Partner contact data, expertise - Descriptor data: static or dynamic search? - Cultivar name, accession name and synonyms. How to sort out collections respectively the database and to assign cultivar names? - Layout, functionality etc. of the database - Photo gallery necessary?

  19. The European Vitis Database (www.eu-vitis.de) Static search form

  20. The European Vitis Database (www.eu-vitis.de) Discussion: - MCPD-lists? Encountered difficulties - Importance of a unique accession number - Partner contact data, expertise - Descriptor data: static or dynamic search? - Cultivar name, accession name and synonyms. How to sort out collections respectively the database and to assign cultivar names? - Layout, functionality etc. of the database - Photo gallery necessary?

  21. The European Vitis Database (www.eu-vitis.de) Sorting out of collections: assignment of accession names to cultivar names Proposition of a table comprising the following criteria: Accession number Accession name Cultivar name Cultivar number Trueness to type Confirmation by ampelography Confirmation by SSR-markers Confirmation by bibliography (no) Bibliography (volume) Bibliography (page)

  22. The European Vitis Database (www.eu-vitis.de) Discussion: - MCPD-lists? Encountered difficulties - Importance of a unique accession number - Partner contact data, expertise - Descriptor data: static or dynamic search? - Cultivar name, accession name and synonyms. How to sort out collections respectively the database and to assign cultivar names? - Layout, functionality etc. of the database - Photo gallery necessary?

  23. The European Vitis Database (www.eu-vitis.de) WP 6: 2nd year activities Deadline: before December 31, 2008 Accomplishment of the most important database applications (MCPD and characterisation data, on-line working) Deadline: before September 30, 2008 Sending of partner specific information and passport data in the MCPD Format Deadline: before November 30, 2008 Sending of WP1 – WP5 data

  24. 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.

  25. 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

  26. 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

  27. 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)

  28. 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

  29. Characterization and evaluation data

More Related