Construction and Utilization of Database for Chinese Maize Varieties and Their Genealogy
LI JianXin,1, XI MengHui2, ZHANG JiaWei1, XI MengJuan3, TIAN Ding4, LU YiZhe1, CHEN XiaoYang1, LI WeiHua1, ZHANG XueHai,1, TANG JiHua11College 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
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. Keywords:maize;inbred line;variety;genealogy;database
PDF (572KB)元数据多维度评价相关文章导出EndNote|Ris|Bibtex收藏本文 本文引用格式 李建新, 席蒙慧, 张嘉玮, 席蒙娟, 田丁, 鲁懿哲, 陈晓阳, 李卫华, 张雪海, 汤继华. 中国玉米品种及其亲本系谱数据库的创建与利用[J]. 中国农业科学, 2020, 53(16): 3404-3411 doi:10.3864/j.issn.0578-1752.2020.16.017 LI JianXin, XI MengHui, ZHANG JiaWei, XI MengJuan, TIAN Ding, LU YiZhe, CHEN XiaoYang, LI WeiHua, ZHANG XueHai, TANG JiHua. Construction and Utilization of Database for Chinese Maize Varieties and Their Genealogy[J]. Scientia Acricultura Sinica, 2020, 53(16): 3404-3411 doi:10.3864/j.issn.0578-1752.2020.16.017
在服务器上运行织梦内容管理系统(DedeCMS),用于数据库管理、网站制作及对数据库进行快速操作[35]。系谱树的实现通过AJAX(Asynchronous Javascript And XML)异步请求方式向服务器提交查询请求,经PHP处理后从数据库提取相关自交系及品种信息,并将处理后的信息以详细信息及系谱树返回给网页前端展现给用户(图1和图2)。
SUNQ, LIW C, ZHANGF J, YUY L, ZHANGQ W, DOUS Q, MENGZ D. Analysis on the pedigree of the parental lines of the maize hybrids approved by the nation from 2001 to 2012 Journal of Maize Sciences, 2014,22(6):6-11. (in Chinese) [本文引用: 2]
WANGM Q, SUJ, LIC X, GONGS C, ZHANGR Y, SONGX Z, YANS Q, LIG L, HUG H, GUANH T, WANGW W, CAOS L, CAOJ H. The genetic diversity of parents inbred lines from parts of released corn hybrids in Heilongjiang province Chinese Agricultural Science Bulletin, 2009(22):274-279. (in Chinese) URL [本文引用: 1]
WANGX F, CAIZ. Era of maize breeding 4.0 Journal of Maize Sciences, 2019,27(1):1-9. (in Chinese) [本文引用: 1]
沈一, 鄂志国, 刘永惠, 陈志德. 中国花生品种及其系谱数据库的构建 , 2015,37(4):571-575. DOI:10.7505/j.issn.1007-9084.2015.04.021URL [本文引用: 1] 本文通过ASP.net/VB.net等技术,以SQL Server 2008为数据库架构,创建了基于网络的中国花生品种及其系谱数据库。数据库收录了育成品种(系)、农家品种和外引品种合计2 498份,其中,省级以上审(鉴、认)定品种565份,大面积推广品种254份。品种检索、系谱追溯和骨干亲本评价是数据库的主要功能。 SHENY, E Z G, LIUY H, CHENZ D. Database construction of Chinese peanut varieties and their genealogy Chinese Journal of Oil Crop Sciences, 2015,37(4):571-575. (in Chinese) DOI:10.7505/j.issn.1007-9084.2015.04.021URL [本文引用: 1] 本文通过ASP.net/VB.net等技术,以SQL Server 2008为数据库架构,创建了基于网络的中国花生品种及其系谱数据库。数据库收录了育成品种(系)、农家品种和外引品种合计2 498份,其中,省级以上审(鉴、认)定品种565份,大面积推广品种254份。品种检索、系谱追溯和骨干亲本评价是数据库的主要功能。
CHENC, LINX F, CHENQ P, YUANW K. Analysis of germplasm basis and heterotic model of maize varieties registered and approved by Guangxi from 2008 to 2014 Journal of Southern Agriculture, 2015,46(7):1160-1165. (in Chinese) [本文引用: 2]
LIUX, JINGX Q, HEJ, LIF Z, CHEND Y, ZHAOW Y, QUJ B, LIY. Analysis of maize germplasm foundation and heterosis model of Liaoning province in the last twenty years Journal of Maize Sciences, 2008,16(6):33-37. (in Chinese) [本文引用: 1]
LIC L, WANGM, MENGL C, LüQ X, LIY, NINGQ, Analysis of germplasm base and certified maize varieties from 2001 to 2013 in Jilin province Journal of Maize Sciences, 2016,24(5):15-25. (in Chinese) [本文引用: 1]
TANGW M, YANGH, TONGS H, ZHAOC H. Utilization of lvda red cob group inbred lines in breeding and production of maize in Liaoning province Xiandai Nongye Keji, 2013,595(5):65-66. (in Chinese)
于明彦, 柳迎春, 夏远峰, 刘爱华, 代秀云. , 2009(1):93-96.
YUM Y, LIUY C, XIAY F, LIUA H, DAIX Y. Utilization of Tang Sipingtou inbred lines in breeding and production of maize in Jilin province Crops, 2009(1):93-96. (in Chinese)
黎裕, 王天宇. 我国玉米育种种质基础与骨干亲本的形成 , 2010,18(5):1-8.
LIY, WANGT Y. Germplasm base of maize breeding in China and formation of foundation parents Journal of Maize Sciences, 2010,18(5):1-8. (in Chinese)
CHENC, LINX F, CHENQ P, YUANW K. Analysis of germplasm basis and heterotic model of maize varieties registered and approved by Guangxi from 2008 to 2014 Journal of Southern Agriculture, 2015,46(7):1160-1165. (in Chinese)
ZHENGD H, LIY R, JINF X, JIANGJ J. Pedigree and germplasm base of inbreds of the lancaster heterotic group of maize in China Scientia Agricultura Sinica, 2002,35(7):750-757. (in Chinese)
GAOX W, DONGL, JINY, YUT J, ZHANGS L. Study on classification for heterotic group of maize inbred lines in Heilongjiang province Journal of Maize Sciences, 2010,18(6):8-10, 14. (in Chinese)
任转滩, 马毅. 浅谈我国玉米杂交种种质来源及其利用途径 , 2004,12(2):30-33.
RENZ T, MAY. Brief talk on the source and utilization of maize hybrid germplasm in China Journal of Maize Sciences, 2004,12(2):30-33. (in Chinese)
SHIX H, SONGZ H, LIUE X, LIUY X. Pedigree analysis of main maize hybrids in Shandong Journal of Maize Sciences, 1995,3(2):4-6. (in Chinese)
徐芹, 郭东全, 刘金根. 玉米种质资源系谱研究 , 2005,24(10):44-47.
XUQ, GUOD Q, LIUJ G. Genealogy of maize germplasm resources research Seed, 2005,24(10):44-47. (in Chinese)
焦仁海, 李凤任. 吉林省主米杂交种系谱分析 , 1999,24(1):32-35.
JIAOR H, LIF R. Pedigree analysis of main maize hybrids in Jilin province Jilin Agricultural Sciences, 1999,24(1):32-35. (in Chinese)
ZHANGX, ZHANGH, LIL J, LANH, RENZ Y, LIUD, WUL, LIUH L, JAQUETHJ, LIB L, PANG T, GAOS B. Characterizing the population structure and genetic diversity of maize breeding germplasm in Southwest China using genome-wide SNP markers , 2016,17(1):697.
JIAOY P, ZHAOH N, RENL H, SONGW B, ZENGB, GUOJ J, WANGB B, LIUZ P, CHENJ, LIW, ZHANGM, XIES J, LAIJ S. Genome-wide genetic changes during modern breeding of maize , 2012(44):812-815.
WANGB B, LINZ C, LIX, ZHAOY P, ZHAOB B, WUG X, MAX J, WANGH, XIEY R, LIQ Q, SONGG S, KONGD X, ZHENGZ G, WEIH B, SHENR X, WUH, CHENC X, MENGZ D, WANGT Y, LIY, LIX H, CHENY H, LAIJ S, BHUFFORD M, ROSS-IBARRAJ, HEH, WANGH Y. Genome-wide selection and genetic improvement during modern maize breeding , 2020, https://doi.org/10.1038/s41588-020-0616-3. URLPMID:32632335 [本文引用: 1]
SONGJ. Design and implementation of structured data extraction platform based on LNMP framework [D]. Beijing: Beijing Jiaotong University, 2016. (in Chinese) [本文引用: 1]
AIY, TANC Y, TIEJ, CHANGJ. The design of interactive platform based on LNMP The Science Education Article Cultures, 2013(25):83-84. (in Chinese) [本文引用: 1]
XIAOJ W. Deployment of Moodle curriculum learning management system based on LNMP platform Information and Computer: Theoretical Edition, 2019,426(8):78-81. (in Chinese) [本文引用: 1]
WENG. Design and implementation of Han Tang online bookstore based on PHP [D]. Sichuan: University of Electronic Science and Technology, 2011. (in Chinese) [本文引用: 1]
LIY H, ZHENGZ G. Website design and implementation based on DedeCMS technology--taking Xi'an University alliance network as an example China Education Technology & Equipment, 2013(36):38-39. (in Chinese) [本文引用: 1]