肉鸡腹脂率双向选择系群体表型数据库设计及其功能实现
发布时间：2019-05-29 11:30
【摘要】：表型性状的准确记录及其有效管理和分析是选育优良畜禽品种(系)工作的一项重要内容。东北农业大学肉鸡腹脂率双向选择系(Northeast Agricultural University High and Low Fat,NEAUHLF)进行了20多年的选育工作,并积累了大量同肉鸡脂肪沉积的分子遗传基础研究相关的表型性状记录。为了有效和系统地存储、管理、分析和利用这些表型数据,本研究设计并构建了东北农业大学肉鸡腹脂率双向选择系群体表型数据库管理系统(NEAUHLF Phenome Database,NEAUHLFPD)。该数据库管理系统存储记录了多项表型性状记录信息和数据,还可同时满足筛选、检索和计算等功能。数据库的具体内容、设置以及功能相关信息如下:一、NEAUHLFPD表型数据库涵盖的主要表型记录和信息(1)1-17世代系谱记录:具体涉及家系编号、个体序号、个体编号、父母代编号、全同胞家系编号、半同胞家系编号等;(2)29项表型数据:分别为鸡体尺性状、不同周龄体重性状、屠体性状以及腹脂率、肝脂率、内脏比率等性状信息。二、NEAUHLFPD表型数据库的架构和设计过程(1)架构信息:选择Apache环境作为NEAUHLFPD表型数据库搭建的WEB服务器;选择My SQL数据库系统软件作为数据库搭建工具;选择Navicat作为数据库管理工具;选择PHP作为动态交互性站点创建的服务器端脚本语言;选择HTML作为超文本标记语言。(2)结构信息:主界面上有数据库整体组成及功能详细介绍,以及数据库各部分基本结构的索引按钮。数据库功能模块主要包含两方面内容。第一模块,为表型(phenotype)数据的物理存储空间,主要用于实现数据指标的选定、范围设定、筛选、和查找等功能;第二模块,为表型数据的基本描述性统计计算(descriptive statistics),主要用于实现对条件筛选后的数据进行基本统计量(平均数、标准差、方差、众数以及中位数等)的计算,同时还可实现对筛选数据的按条件排序等功能。NEAUHLFPD不仅可以用于有效储存和管理表型数据,还可以在今后的研究工作中兼容高通量基因组学数据,进一步对其内容和功能进行扩充和开发。NEAUHLFPD表型数据库的构建有利于今后深入开展鸡脂肪组织生长发育的分子遗传基础研究,以及推进低脂肉鸡的选育工作。
[Abstract]:Accurate recording, effective management and analysis of phenotypic traits is an important part of breeding excellent livestock and poultry breeds (lines). The two-way selection line (Northeast Agricultural University High and Low Fat,NEAUHLF of broilers in Northeast Agricultural University has been selected for more than 20 years, and a large number of phenotypic traits related to the molecular genetic basis of fat deposition in broilers have been accumulated. In order to store, manage, analyze and utilize these phenotypic data effectively and systematically, a population phenotypic database management system (NEAUHLF Phenome Database,NEAUHLFPD) for two-way selection of abdominal fat percentage of broilers in Northeast Agricultural University was designed and constructed. The database management system stores and records a number of phenotypic traits recording information and data, and can also meet the functions of screening, retrieval and calculation at the same time. The specific contents, settings and functional information of the database are as follows: first, the main phenotypic records and information covered by the NEAUHLFPD phenotypic database (1) 1 / 17 generation pedigree records: specifically related to family number, individual sequence number, individual number, Parent generation number, whole sibling family number, half sibling family number, etc. (2) 29 phenotypic data: chicken body size traits, weight traits of different weeks of age, butcher traits, abdominal fat rate, liver fat rate, visceral ratio and other traits. Second, the architecture and design process of NEAUHLFPD phenotypic database (1) Architecture information: select Apache environment as WEB server built by NEAUHLFPD phenotypic database, select My SQL database system software as database building tool, select My SQL database system software as database building tool, select My SQL database system software as database building tool, select My SQL database system software as database building tool. Select Navicat as the database management tool, PHP as the server-side script language created by the dynamic interactive site, and select PHP as the server-side script language created by the dynamic interactive site. HTML is selected as hypertext markup language. (2) structure information: the overall composition and function of the database are introduced in detail on the main interface, as well as the index button of the basic structure of each part of the database. The database function module mainly consists of two aspects. The first module is the physical storage space of phenotypic (phenotype) data, which is mainly used to realize the functions of data index selection, range setting, screening, and search. In the second module, the basic descriptive statistical calculation of phenotypic data (descriptive statistics), is mainly used to calculate the basic statistics (average, standard deviation, variance, number of numbers and median, etc.) of the data after conditional screening. At the same time, it can also realize the function of sorting the screened data according to the condition. NEAUHLFPD can not only be used to effectively store and manage phenotypic data, but also be compatible with high-throughput genomic data in future research work. Further expansion and development of its content and function. The construction of NEAUHLFPD phenotypic database is helpful to carry out the molecular genetic basis of chicken adipose tissue growth and development in the future, and to promote the breeding of low-fat broilers.
【学位授予单位】：东北农业大学
【学位级别】：硕士
【学位授予年份】：2017
【分类号】：TP311.13;S831
[Abstract]:Accurate recording, effective management and analysis of phenotypic traits is an important part of breeding excellent livestock and poultry breeds (lines). The two-way selection line (Northeast Agricultural University High and Low Fat,NEAUHLF of broilers in Northeast Agricultural University has been selected for more than 20 years, and a large number of phenotypic traits related to the molecular genetic basis of fat deposition in broilers have been accumulated. In order to store, manage, analyze and utilize these phenotypic data effectively and systematically, a population phenotypic database management system (NEAUHLF Phenome Database,NEAUHLFPD) for two-way selection of abdominal fat percentage of broilers in Northeast Agricultural University was designed and constructed. The database management system stores and records a number of phenotypic traits recording information and data, and can also meet the functions of screening, retrieval and calculation at the same time. The specific contents, settings and functional information of the database are as follows: first, the main phenotypic records and information covered by the NEAUHLFPD phenotypic database (1) 1 / 17 generation pedigree records: specifically related to family number, individual sequence number, individual number, Parent generation number, whole sibling family number, half sibling family number, etc. (2) 29 phenotypic data: chicken body size traits, weight traits of different weeks of age, butcher traits, abdominal fat rate, liver fat rate, visceral ratio and other traits. Second, the architecture and design process of NEAUHLFPD phenotypic database (1) Architecture information: select Apache environment as WEB server built by NEAUHLFPD phenotypic database, select My SQL database system software as database building tool, select My SQL database system software as database building tool, select My SQL database system software as database building tool, select My SQL database system software as database building tool. Select Navicat as the database management tool, PHP as the server-side script language created by the dynamic interactive site, and select PHP as the server-side script language created by the dynamic interactive site. HTML is selected as hypertext markup language. (2) structure information: the overall composition and function of the database are introduced in detail on the main interface, as well as the index button of the basic structure of each part of the database. The database function module mainly consists of two aspects. The first module is the physical storage space of phenotypic (phenotype) data, which is mainly used to realize the functions of data index selection, range setting, screening, and search. In the second module, the basic descriptive statistical calculation of phenotypic data (descriptive statistics), is mainly used to calculate the basic statistics (average, standard deviation, variance, number of numbers and median, etc.) of the data after conditional screening. At the same time, it can also realize the function of sorting the screened data according to the condition. NEAUHLFPD can not only be used to effectively store and manage phenotypic data, but also be compatible with high-throughput genomic data in future research work. Further expansion and development of its content and function. The construction of NEAUHLFPD phenotypic database is helpful to carry out the molecular genetic basis of chicken adipose tissue growth and development in the future, and to promote the breeding of low-fat broilers.
【学位授予单位】：东北农业大学
【学位级别】：硕士
【学位授予年份】：2017
【分类号】：TP311.13;S831
【参考文献】
相关期刊论文 前10条
1 李辉;杜志强;王守志;冷丽;;白羽快大型肉鸡育种的过去、现在和将来[J];中国家禽;2016年19期
2 杨朝武;蒋小松;杜华锐;李晴云;张增荣;邱莫寒;;国际肉鸡育种发展现状及未来趋势[J];中国家禽;2016年15期
3 王业华;张欣欣;宋庆庆;李玉和;宫利娜;关平原;;猪繁殖与呼吸综合征病毒强弱毒株全基因序列比对分析[J];中国畜牧兽医;2016年07期
4 许丽;王s，
本文编号：2487903
本文链接：https://www.wllwen.com/yixuelunwen/dongwuyixue/2487903.html
