中国农业科学 ›› 2020, Vol. 53 ›› Issue (16): 3404-3411.doi: 10.3864/j.issn.0578-1752.2020.16.017

• 研究简报 • 上一篇    下一篇

中国玉米品种及其亲本系谱数据库的创建与利用

李建新1(),席蒙慧2,张嘉玮1,席蒙娟3,田丁4,鲁懿哲1,陈晓阳1,李卫华1,张雪海1(),汤继华1   

  1. 1河南农业大学农学院/省部共建小麦玉米作物学国家重点实验室,郑州 450002
    2南阳师范学院化学与制药工程学院,河南南阳 473061
    3新乡医学院管理学院,河南新乡 450003
    4郑州工程技术学院中德学院,郑州 450000
  • 收稿日期:2020-04-28 接受日期:2020-06-18 出版日期:2020-08-16 发布日期:2020-08-27
  • 通讯作者: 张雪海
  • 作者简介:李建新,E-mail:bnmvbncvb@qq.com
  • 基金资助:
    河南省科技攻关项目(202102110012);河南省科技攻关项目(182102110349);河南省高等学校重点科研项目(20A210003);河南农业大学科技创新基金(KJCX2019A01);2016年度河南省高等学校青年骨干教师培养计划(2016GGJS-034);郑州市重大科技创新专项(188PCXZX803)

Construction and Utilization of Database for Chinese Maize Varieties and Their Genealogy

LI JianXin1(),XI MengHui2,ZHANG JiaWei1,XI MengJuan3,TIAN Ding4,LU YiZhe1,CHEN XiaoYang1,LI WeiHua1,ZHANG XueHai1(),TANG JiHua1   

  1. 1College of Agronomy, Henan Agricultural University/National Key Laboratory of Wheat and Maize Crop Science, Zhengzhou 450002
    2School of Chemistry and Chemical Engineering, Nanyang Normal University, Nanyang 473061, Henan
    3School of Management, Xinxiang Medical University, Xinxiang 450003, Henan
    4Sino-Germany College, Zhengzhou Institute of Technology, Zhengzhou 450000
  • Received:2020-04-28 Accepted:2020-06-18 Online:2020-08-16 Published:2020-08-27
  • Contact: XueHai ZHANG

摘要:

【目的】新品种的选育与推广是促进中国玉米产量不断提高的重要因素,而优良自交系的选育是组配强优势杂交组合的前提。明确不同自交系的亲缘与系谱关系是玉米自交系改良、杂种优势类群划分和杂交组合组配的重要依据。为破解中国玉米自交系血缘关系不明确、查询不方便的现状,迫切需要对现有品种的系谱进行全面梳理,并构建相应的系谱数据库。【方法】基于LNMP(Linux平台+Nginx服务器软件+MySQL数据库管理系统+PHP超文本预处理软件)服务器环境配置设计MySQL数据库;搜集和整理中华人民共和国农业农村部、各省农业农村厅、中国种业大数据平台等网站及玉米品种系谱相关文献及书本中自交系信息及历年玉米品种审定信息,并导入MySQL数据库;利用织梦内容管理系统(DedeCMS)管理和更新MySQL数据库;通过AJAX(Asynchronous Javascript and XML)异步请求方式提交查询请求并经PHP处理后将提取的自交系及品种信息进行处理,最终以详细信息及系谱树的形式返回网页前端,创建了中国玉米品种及其亲本系谱数据库(https://www.maizedata.cn);此外,使用phpMyAdmin软件对数据库结构进行后期优化及新功能添加。【结果】数据库收录了中国不同年代选育的玉米自交系、省级以上审定品种信息10 000余条,涉及自交系1 218个,杂交种7 823个,每个杂交种因审定编号不同,收录的品种信息从1至10条不等。此外,还添加了玉米自交系及品种系谱信息的增加、修改和删除等功能。【结论】基于LNMP服务器环境配置,创建了中国玉米品种及其亲本系谱数据库,收录自交系及品种信息10 000余条,涉及自交系1 218个,杂交种7 823个。该数据库实现了品种信息检索、系谱追溯、子代查询、定制化查询、用户上传及纠错系谱信息等功能,便于中国玉米育种家及科研工作者快捷查询玉米自交系及品种的信息及系谱关系。

关键词: 玉米, 自交系, 品种, 系谱, 数据库

Abstract:

【Objective】 The breeding and popularization of new varieties are important for promoting the continuous improvement of maize yield in China. Breeding elite inbred lines is the prerequisite for strong heterotic combinations. To determine the kinship and genealogy relationship among maize inbred lines is the important basis for improvement of maize inbred, classification of heterotic groups and cross combination. It is imperative to sort out the genealogy of existing varieties and construct the corresponding genealogy database, so as to solve unclear consanguinity and inconvenient inquiry of maize inbred lines in China. 【Method】 A network MySQL database (https://www.maizedata.cn) of Chinese maize inbred lines, varieties and their genealogies was built based on the LNMP (Linux system, Nginx server software, MySQL database management system and PHP hypertext preprocessing software) server environment configuration. In addition, information of inbred lines and approval information of maize varieties in past years from the websites of Ministry of Agriculture and Rural Affairs of the People's Republic of China, Provincial Agricultural and Rural Affairs Departments, the big data platform of China’s seeds, as well as related literature and books were collected, collated and imported into MySQL database. Then, dream-weaving content management system (DedeCMS) was used to manage and update MySQL database. Query requests were submitted through AJAX (Asynchronous Javascript and XML) asynchronous processing, and the extracted inbred line and variety information were processed by PHP. Finally, the detailed genealogy information and genealogy tree were returned and displayed on the front-end web pages. In addition, phpMyAdmin software was applied to optimize the database structure and add new functions. 【Result】 In this database, more than 10 000 maize varieties that examined and approved by the provincial level or above, and their parents were collected, including 1218 inbred lines and 7823 varieties that have 1 to 10 pieces of information with different approved numbers and across eras in China. Variety information retrieval, genealogy tracing, filial generation query and customized query are the core functions of the database. Additionally, functions, such as addition, modification and deletion of maize inbred lines and variety pedigree information, haven been also integrated in the database. 【Conclusion】 Based on the LNMP server environment configuration, a database for Chinese maize varieties and their genealogies was constructed, which covers more than 10 000 maize varieties, including 1218 inbred lines and 7823 varieties. Core functions contain variety information retrieval, genealogy tracing, filial generation query, customized query, data uploading and updating. As an effective tool for Chinese maize breeders and researchers to quickly search the information and pedigree of maize inbred and varieties, the database can promote the breeding of elite maize inbred lines.

Key words: maize, inbred line, variety, genealogy, database