Scientia Agricultura Sinica ›› 2020, Vol. 53 ›› Issue (16): 3404-3411.doi: 10.3864/j.issn.0578-1752.2020.16.017

• RESEARCH NOTES • Previous Articles     Next Articles

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 E-mail:bnmvbncvb@qq.com;xuehai85@126.com

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

Fig. 1

The processing flowchart of an ajax request sent by the client to the server"

Fig. 2

The principle of genealogical tree"

Fig. 3

Advanced Search page"

Fig. 4

Genealogical of Bixiang 101"

Fig. 5

Offsprings of Huang Zaosi and their offsprings"

[1] YAN J B, WARBURTON M, CROUCH J. Association mapping for enhancing maize (Zea mays L.) genetic improvement. Crop Science, 2011,51(2):433-449.
[2] 李建生. 玉米分子育种研究进展. 中国农业科技导报, 2007,9(2):10-13.
LI J S. Progress of molecular breeding in maize. China Agricultural Science and Technology, 2007,9(2):10-13. (in Chinese)
[3] 孙琦, 李文才, 张发军, 于彦丽, 张庆伟, 窦圣强, 孟昭东. 2001~2012年国审玉米品种亲本自交系系谱来源分析. 玉米科学, 2014,22(6):6-11.
SUN Q, LI W C, ZHANG F J, YU Y L, ZHANG Q W, DOU S Q, MENG Z 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)
[4] 王明泉, 苏俊, 李春霞, 龚士琛, 张瑞英, 宋锡章, 闫淑琴, 李国良, 扈光辉, 关海涛, 王伟威, 曹士亮, 曹娟华. 黑龙江省部分审定玉米品种亲本自交系的遗传多样性分析. 中国农学通报, 2009(22):274-279.
WANG M Q, SU J, LI C X, GONG S C, ZHANG R Y, SONG X Z, YAN S Q, LI G L, HU G H, GUAN H T, WANG W W, CAO S L, CAO J 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)
[5] 王向峰, 才卓. 中国种业科技创新的智能时代——“玉米育种4.0”. 玉米科学, 2019,27(1):1-9.
WANG X F, CAI Z. Era of maize breeding 4.0. Journal of Maize Sciences, 2019,27(1):1-9. (in Chinese)
[6] 沈一, 鄂志国, 刘永惠, 陈志德. 中国花生品种及其系谱数据库的构建. 中国油料作物学报, 2015,37(4):571-575.
doi: 10.7505/j.issn.1007-9084.2015.04.021
SHEN Y, E Z G , LIU Y H, CHEN Z 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.021
[7] 鄂志国, 王磊. 中国水稻品种及其系谱数据库. 中国水稻科学, 2011,25(5):565-566.
doi: 10.3969/j.issn.10017216.2011.05.017
E Z G, WANG L. Construction of database for Chinese rice varieties and their genealogy. Chinese Journal of Rice Science, 2011,25(5):565-566. (in Chinese)
doi: 10.3969/j.issn.10017216.2011.05.017
[8] 种业商务网. https://www.chinaseed114.com/seed/yumi/..
Seed business affairs website. https://www.chinaseed114.com/seed/ yumi/..(in Chinese)
[9] 中国种业大数据平台. http://202.127.42.47:6010/SDSite/Home/ Index..
Big data platform of China's seeds. http://202.127.42.47:6010/SDSite/ Home/Index..(in Chinese)
[10] 第一种业网. http://www.a-seed.cn..
The first seed industry website. http://www.a-seed.cn..(in Chinese)
[11] 汪黎明, 王庆成, 孟昭东. 中国玉米品种及其系谱. 上海: 上海科学技术出版社, 2010.
WANG L M, WANG Q C, MENG Z D. Chinese Maize Varieties and Their Genealogy. Shanghai: Shanghai Science and Technology Press, 2010. (in Chinese)
[12] 陈灿, 林秀芳, 陈勤平, 袁维科. 2008~2014年广西审定玉米品种种质基础及杂优模式分析. 南方农业学报, 2015,46(7):1160-1165.
CHEN C, LIN X F, CHEN Q P, YUAN W 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)
[13] 刘纪鳞. 玉米育种学. 北京: 中国农业出版社, 2002.
LIU J L. Maize Breeding. Beijing: China Agricultural Publishing Press, 2002. (in Chinese)
[14] 曹广才, 徐雨昌. 实用玉米自交系. 北京: 气象出版社, 2000.
CAO G C, XU Y C. Practical Maize Inbred Line. Beijing: Meteorological Press, 2000. (in Chinese)
[15] 李维岳, 才卓, 赵化春. 吉林玉米. 长春: 吉林科学技术出版社, 2000.
LI W C, CAI Z, ZHAO H C. Jilin Maize. Changchun: Jilin Science and Technology Press, 2000. (in Chinese)
[16] 刘旭, 景希强, 何晶, 李芳志, 陈得义, 赵文媛, 曲江波, 李媛. 二十年来辽宁省玉米种质基础及杂优模式分析. 玉米科学, 2008,16(6):33-37.
LIU X, JING X Q, HE J, LI F Z, CHEN D Y, ZHAO W Y, QU J B, LI Y. 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)
[17] 李春雷, 王敏, 孟令聪, 吕庆雪, 李洋, 宁恰. 吉林省玉米种质基础及2001~2013年品种推广分析. 玉米科学, 2016,24(5):15-25.
LI C L, WANG M, MENG L C, LÜ Q X, LI Y, NING Q, 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)
[18] 唐文明, 杨辉, 佟圣辉, 赵成昊. 旅大红骨种群自交系在辽宁省玉米育种和生产中的应用. 现代农业科技, 2013,595(5):65-66.
TANG W M, YANG H, TONG S H, ZHAO C 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)
[19] 于明彦, 柳迎春, 夏远峰, 刘爱华, 代秀云. 塘四平头种群自交系在吉林省玉米育种和生产中的利用. 作物杂志, 2009(1):93-96.
YU M Y, LIU Y C, XIA Y F, LIU A H, DAI X Y. Utilization of Tang Sipingtou inbred lines in breeding and production of maize in Jilin province. Crops, 2009(1):93-96. (in Chinese)
[20] 黎裕, 王天宇. 我国玉米育种种质基础与骨干亲本的形成. 玉米科学, 2010,18(5):1-8.
LI Y, WANG T Y. Germplasm base of maize breeding in China and formation of foundation parents. Journal of Maize Sciences, 2010,18(5):1-8. (in Chinese)
[21] 陈灿, 林秀芳, 陈勤平, 袁维科. 2008~2014年广西审定玉米品种种质基础及杂优模式分析. 南方农业学报, 2015,46(7):1160-1165.
CHEN C, LIN X F, CHEN Q P, YUAN W 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)
[22] 郑大浩, 李艳茹, 金锋学, 蒋基建. 中国玉米Lancaster杂种优势群自交系的系谱、种质基础分析. 中国农业科学, 2002,35(7):750-757.
ZHENG D H, LI Y R, JIN F X, JIANG J 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)
[23] 高兴武, 董玲, 金益, 于天江, 张士龙. 黑龙江省常用玉米自交系的杂种优势类群研究. 玉米科学, 2010,18(6):8-10, 14.
GAO X W, DONG L, JIN Y, YU T J, ZHANG S 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)
[24] 任转滩, 马毅. 浅谈我国玉米杂交种种质来源及其利用途径. 玉米科学, 2004,12(2):30-33.
REN Z T, MA Y. Brief talk on the source and utilization of maize hybrid germplasm in China. Journal of Maize Sciences, 2004,12(2):30-33. (in Chinese)
[25] 史新海, 宋再华, 刘恩训, 柳玉学. 山东省主要玉米杂交种系谱分析. 玉米科学, 1995,3(2):4-6.
SHI X H, SONG Z H, LIU E X, LIU Y X. Pedigree analysis of main maize hybrids in Shandong. Journal of Maize Sciences, 1995,3(2):4-6. (in Chinese)
[26] 徐芹, 郭东全, 刘金根. 玉米种质资源系谱研究. 种子, 2005,24(10):44-47.
XU Q, GUO D Q, LIU J G. Genealogy of maize germplasm resources research. Seed, 2005,24(10):44-47. (in Chinese)
[27] 焦仁海, 李凤任. 吉林省主米杂交种系谱分析. 吉林农业科学, 1999,24(1):32-35.
JIAO R H, LI F R. Pedigree analysis of main maize hybrids in Jilin province. Jilin Agricultural Sciences, 1999,24(1):32-35. (in Chinese)
[28] ZHANG X, ZHANG H, LI L J, LAN H, REN Z Y, LIU D, WU L, LIU H L, JAQUETH J, LI B L, PAN G T, GAO S B. Characterizing the population structure and genetic diversity of maize breeding germplasm in Southwest China using genome-wide SNP markers. BMC Genomics, 2016,17(1):697.
[29] JIAO Y P, ZHAO H N, REN L H, SONG W B, ZENG B, GUO J J, WANG B B, LIU Z P, CHEN J, LI W, ZHANG M, XIE S J, LAI J S. Genome-wide genetic changes during modern breeding of maize. Nature Genetics, 2012(44):812-815.
[30] WANG B B, LIN Z C, LI X, ZHAO Y P, ZHAO B B, WU G X, MA X J, WANG H, XIE Y R, LI Q Q, SONG G S, KONG D X, ZHENG Z G, WEI H B, SHEN R X, WU H, CHEN C X, MENG Z D, WANG T Y, LI Y, LI X H, CHEN Y H, LAI J S, B HUFFORD M, ROSS-IBARRA J, HE H, WANG H Y. Genome-wide selection and genetic improvement during modern maize breeding. Nature Genetics, 2020, https://doi.org/10.1038/s41588-020-0616-3.
pmid: 32632335
[31] 宋静. 基于LNMP框架的结构化数据抽取平台的设计与实现[D]. 北京: 北京交通大学, 2016.
SONG J. Design and implementation of structured data extraction platform based on LNMP framework[D]. Beijing: Beijing Jiaotong University, 2016. (in Chinese)
[32] 艾勇, 谭成予, 帖军, 常军. 基于LNMP架构的教学互动平台的设计. 科教文汇, 2013(25):83-84.
AI Y, TAN C Y, TIE J, CHANG J. The design of interactive platform based on LNMP. The Science Education Article Cultures, 2013(25):83-84. (in Chinese)
[33] 肖剑伟. 基于LNMP平台Moodle课程学习管理系统部署. 信息与电脑: 理论版, 2019,426(8):78-81.
XIAO J W. Deployment of Moodle curriculum learning management system based on LNMP platform. Information and Computer: Theoretical Edition, 2019,426(8):78-81. (in Chinese)
[34] 文广. 基于PHP的汉唐网上书店的设计与实现[D]. 四川: 电子科技大学, 2011.
WEN G. Design and implementation of Han Tang online bookstore based on PHP[D]. Sichuan: University of Electronic Science and Technology, 2011. (in Chinese)
[35] 李云海, 郑志高. 基于DedeCMS技术的网站设计与实现--以西安市高校联盟网为例. 中国教育技术装备, 2013(36):38-39.
LI Y H, ZHENG Z 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] WANG YaFei, YAN Peng, XUE JinTao, DONG XueRui, MENG FanQi, GUO LiNa, LUO Yi, ZHANG Juan, DONG ZhiQiang, LU Lin. Effects of Ethephon-Glycine Betaine-Salicylic Acid Mixture on Root System Architecture, Physiological Function and Yield of Maize Under Heat Stress [J]. Scientia Agricultura Sinica, 2026, 59(7): 1439-1455.
[2] WANG JiaNuo, CHEN GuiPing, LI Pan, WANG LiPing, NAN YunYou, HE Wei, FAN ZhiLong, HU FaLong, CHAI Qiang, YIN Wen, ZHAO LiaoHao. Photo-Physiological Mechanism at Grain Filling Stage of No-Tillage with Plastic Re-Mulching to Increase Maize Yield in Oasis Irrigation Areas [J]. Scientia Agricultura Sinica, 2026, 59(6): 1189-1202.
[3] ZHOU XinJie, REN Hao, CHEN YingLong, ZHANG JiWang, ZHAO Bin, REN BaiZhao, LIU Peng, WANG HongZhang. Effects of Calcium Peroxide on Root Morphology and Yield Formation of Summer Maize in Waterlogging Farmland [J]. Scientia Agricultura Sinica, 2026, 59(6): 1203-1216.
[4] HE JiHang, ZHANG Qing, LÜ XiangYue, XUE JiQuan, XU ShuTu, LIU JianChao. Evaluation of Nitrogen Efficiency of Different Stay-Green Maize Hybrids [J]. Scientia Agricultura Sinica, 2026, 59(6): 1217-1230.
[5] LI YongJuan, ZHANG YueTong, WANG YiBo, ZHAO ChangJiang, SONG Jie, CHEN XueLi, YAO Qin. Effects of Biochar Application on the Abundance and Community Composition of Nitrogen-Fixing Microbial nifH Gene in Soybean Rotation and Continuous Cropping Systems [J]. Scientia Agricultura Sinica, 2026, 59(6): 1272-1285.
[6] LI SiYuan, LI HongPing, CHANG HongQing, ZHANG SenYan, LI SiJia, CUI XinFei, QIAO Po, ZENG Bo, LIU GuiZhen, LIU TianXue, TANG JiHua, LI ChaoHai. Effects of Density Increase on Dynamic Change of Yield and Agronomic Traits of Maize Cultivars with Different Plant Heights [J]. Scientia Agricultura Sinica, 2026, 59(5): 967-984.
[7] DONG JinLong, ZHAO Ying, YU HaiBing, LÜ JianYe, QIN JiaQi, LIANG Chen, MING Bo, LI ShaoKun. Multi-Model Elucidating of Nutritional Quality Contributions to Maize Kernel Test Weight and Regional Heterogeneity [J]. Scientia Agricultura Sinica, 2026, 59(5): 985-995.
[8] CHEN GuiPing, WEI JinGui, GUO Yao, LI Pan, WANG FeiEr, QIU HaiLong, FENG FuXue, YIN Wen. Synergistic Effects of Wide-Narrow Row and Density Enhancement on the Photosynthetic Characteristics and Resource Utilization of Maize in Oasis Irrigation Areas [J]. Scientia Agricultura Sinica, 2026, 59(2): 278-291.
[9] ZHANG ZhiYong, TAN ShiChao, XIONG ShuPing, MA XinMing, WEI YiHao, WANG XiaoChun. Effects of Annual Water and Nitrogen Optimization on Yield and Nitrogen Migration of Wheat-Maize Rotation System in Irrigation Area of Northern Henan [J]. Scientia Agricultura Sinica, 2026, 59(2): 336-353.
[10] WEI WenHua, LI Pan, SHAO GuanGui, FAN ZhiLong, HU FaLong, FAN Hong, HE Wei, CHAI Qiang, YIN Wen, ZHAO LianHao. Response of Silage Maize Yield and Quality to Reduced Irrigation and Combined Organic-Inorganic Fertilizer in Northwest Irrigation Areas [J]. Scientia Agricultura Sinica, 2025, 58(8): 1521-1534.
[11] XUE YuQi, ZHAO JiYu, SUN WangSheng, REN BaiZhao, ZHAO Bin, LIU Peng, ZHANG JiWang. Effects of Different Nitrogen Forms on Yield and Quality of Summer Maize [J]. Scientia Agricultura Sinica, 2025, 58(8): 1535-1549.
[12] CHEN GuiPing, LI Pan, SHAO GuanGui, WU XiaYu, YIN Wen, ZHAO LianHao, FAN ZhiLong, HU FaLong. The Regulatory Effect of Reduced Irrigation and Combined Organic- Inorganic Fertilizer Application on Stay-Green Characteristics in Silage Maize Leaves After Tasseling Stage [J]. Scientia Agricultura Sinica, 2025, 58(7): 1381-1396.
[13] YUE RunQing, LI WenLan, DING ZhaoHua, MENG ZhaoDong. Molecular Characteristics and Resistance Evaluation of Transgenic Maize LD05 with Stacked Insect and Herbicide Resistance Traits [J]. Scientia Agricultura Sinica, 2025, 58(7): 1269-1283.
[14] ZHAO Yao, CHENG Qian, XU TianJun, LIU Zheng, WANG RongHuan, ZHAO JiuRan, LU DaLei, LI CongFeng. Effects of Plant Type Improvement on Root-Canopy Characteristics and Grain Yield of Spring Maize Under High Density Condition [J]. Scientia Agricultura Sinica, 2025, 58(7): 1296-1310.
[15] ZOU XiaoWei, XIA Lei, ZHU XiaoMin, SUN Hui, ZHOU Qi, QI Ji, ZHANG YaFeng, ZHENG Yan, JIANG ZhaoYuan. Analysis of Disease Resistance Induced by Ustilago maydis Strain with Overexpressed UM01240 Based on Transcriptome Sequencing [J]. Scientia Agricultura Sinica, 2025, 58(6): 1116-1130.
Viewed
Full text


Abstract

Cited

  Shared   
  Discussed   
No Suggested Reading articles found!