Excel应用于方差分析的实训教学探究

针对国内应用型本科湖南文理学院院校概率统计课程的实训教学越来越多地注重Excel作为初学者操作平台的现状,就非平衡数据和嵌套结构的数据在Excel中实现方差分析的过程进行探究。突出以组内矫正数为主线整理数据后简化平方和分解公式的理念,使得Excel中进行方差分析时,数据整理流程完全格式化,平方和的分解步骤更为简洁,自由度分解、F检验等步骤不再繁琐,为非统计专业本科阶段借助Excel电子表格率先实现概率统计课程实训教学的宽口径模式提供借鉴。     

Genome-wide Association Study of Teats Number Traits in Kele Pigs

Teats number is one of the most important reproductive traits,and closely related to the economic benefit in pig industry.In order to reveal the underlying genetics of left teats number,right teats number and total teats number traits,a genome-wide association study（GWAS）was performed.Samples of DNA were collected to genotyping for 22 Kele pigs using the Illumina Porcine SNP 60K Chip.The GWAS was performed using a mixed-effects model and linear regression approach.When a genome-wide threshold was determined using the Bonferroni method（P<2.06E-5),4 single nucleotide polymorphism（SNP）markers were potentially associated with left teats number,right teats number and total teat number.However,3 SNPs were significant associated and 18 SNPs were potentially associated in chromosomes level.304 Ensembl genes were retrieved around 1 cM of the associated SNPs.The candidate genes in Wnt and Fgf signaling pathway（BTRC,FGF5,FGF8,BMP3,RASGEF1B and HMGB3）might have effect on target traits.These results provided valuable information about the selective breeding for Kele pigs.     

不同燕麦基因型源库关系对穗粒数形成过程的影响

为了解燕麦穗粒数形成过程与源、库特征之间的关系，连续两年以10个不同来源、熟期、穗型、株型、小穗数的燕麦品种为试验材料，测定三叶期至拔节期的幼穗分化阶段及抽穗期源库特征，采用方差分析、聚类分析、逐步回归分析等方法，分析不同燕麦基因型源库特征及对穗粒数形成过程的影响。结果表明，燕麦穗粒数形成过程存在基因型差异，幼穗分化较好品种的穗粒数较全部品种平均值高11.22%~65.43%；幼穗分化较好品种的光合势、干物质量、粒数叶比、收获指数显著高于幼穗分化较差品种，其中粒数叶比和收获指数是影响穗粒数形成的主要因素，粒数叶比和收获指数较全部品种平均值分别高0.99%~68.74%和0.85%~13.80%。综上所述，源库协调是燕麦幼穗分化良好的生理基础，可通过提高光合势和干物质量达到增源的目的，进而提高穗粒数。     

未确知有理数在农业投资方案决策中的应用

利用未确知有理数方法进行农业投资方案决策,在理论上可行,所得结果是可信的。该方法可用于多层次决策,步骤简单,有效。     

Assessing the deposition and canopy penetration of nozzles with different spray qualities in an oat (Avena sativa L.) canopy

Consistent spray coverage that is evenly distributed throughout the canopy is necessary to control pest populations that can negatively affect yield. As applicators are switching to Coarser spray quality nozzles to reduce risk and liability of pesticide spray drift, concerns about efficacy loss are growing. Previous research has indicated that small droplets are the most effective at penetrating through crop canopies, but newer nozzle technologies have improved the effectiveness of larger droplet or Coarser sprays. Research was conducted to assess the canopy penetration of nozzles that produce Coarse, Very-Coarse and Extremely-Coarse spray qualities compared to nozzles that produce Fine and Medium spray qualities. Kromekote collectors were positioned in four configurations in an oat (Avena sativa L.) var. ‘Yarran’ (AusWest Seeds, Forbes, NSW, Australia) crop to quantify the coverage and droplet number densities (droplets cm⁻²) across three application carrier volume rates: 50, 75 and 100 L ha⁻¹. Applications were made in the field in 30 cm tall, tillering oats, with collectors arranged in a randomised complete block design with three replications. The entire study was repeated on the following day. Results showed that droplet number densities were inversely related to the droplet size produced by the nozzles, yet coverage was increased more by application volume rate than droplet size. Thus, both spray drift reduction and improved canopy penetration can be achieved with proper nozzle selection and operation parameters for the control of agronomic pests.     

拷贝数变异在畜禽中的研究进展

拷贝数变异（copy number variation,CNV）具有多种形式的变异结构,在品种多样性、生物进化和疾病相关性等研究中起着重要作用,并具有片段长度大、覆盖范围广等特点。随着分子生物学的发展及DNA测序技术的日渐成熟,人们对遗传变异的研究不断向DNA分子水平深入,多态性标记在畜禽育种中已逐渐成为动物育种研究的趋势和主流。由于CNV对基因的调控和表达所造成的影响更为显著,因此,CNV在重要畜禽中的研究越来越多。目前,已检测出大量有关畜禽重要经济性状的基因序列变异,并有许多研究均表明CNV与动物的重要经济特征及疾病的发生有关。笔者主要通过参考国内外相关的研究报道,简述了CNV的相关研究背景、概念、突变机制,归纳总结了CNV对牛、羊、猪、鸡的经济性状、繁殖性状和疾病调控的影响,以期通过对这些重要畜禽的基因组学研究揭示其适应性遗传机理和表型性状差异的遗传基础,开发相应的分子遗传标记,为畜禽的标记辅助选育提供理论基础。     

Analysis on Polymorphisms of Three CNV Regions in Five Pig Breeds

The paper was aimed to investigate the polymorphism of copy number variation (CNV) in different pig breeds.Three CNV regions of CNVR91,CNVR92 and CNVR143 were chosen from the porcine SNP60 chip genotyping results.The polymorphisms of three CNVs were determined by Real-time quantitative PCR method,taking five pig breeds as samples,including Yorkshire pig,Xiang pig,Kele pig,Nuogu pig and Rongchang pig breeds.The results showed that the dominant status of CNVR91 was loss in Xiang pig,while it was normal in other four pig breeds.The major type of CNVR92 was deletion in Xiang pig,Yorkshire pig,Kele pig and Rongchang pig breeds,with a high normal percent in Nuogu pig.For CNVR143,the dominant event was gain in Xiang pig and Nuogu pig breeds,but it was not diverse in other three pig breeds.These results indicated that three CNV regions emerged with polymorphism in five pig breeds,which might have effects on gene expression in CNV regions and physiological function by dosage effect especially in Xiang pig,Nuogu pig and Kele pig breeds.     

基于全基因组填充重测序关联分析鉴别影响苏山猪初生体尺与乳头数性状的遗传位点

旨在鉴别影响苏山猪初生体尺和乳头数性状的遗传位点,开发可用于辅助育种的分子标记,为苏山猪生长和繁殖性能的持续选育提供理论基础。本试验对269头苏山猪初生仔猪(出生后24 h内)的体尺和乳头数表型进行测定,并采集耳组织样品。基于全基因组重测序及基因型填充策略,利用全基因组关联分析(genome-wide association study, GWAS)和群体分化指数(fixation index,Fst)的方法挖掘与目的性状强关联位点,并对位置功能候选基因开展GO和KEGG分析,确定最有可能的主效基因。本研究共鉴别到4个候选位点,分布在13、14和X染色体上,其中与初生体尺性状显著关联的位点有2个,与乳头数性状显著关联的位点有2个。本研究筛选出1个与体长性状相关的候选基因ACTA2;1个与胸围性状相关的候选基因COL4A6;3个与乳头数性状相关的候选基因ACTA2、CRTAP和SEPTIN6,为苏山猪初生体尺性状和乳头数性状的遗传改良提供了重要的分子标记。     

低雷诺数工况下锯齿型翅片性能的参数化研究

基于田口方法,结合均匀设计法对低雷诺数工况下错列锯齿型翅片进行三维参数化数值研究。以单层翅片组件为测试对象,对6种试件的试验表明,仿真结果与试验数据的趋势吻合良好,而存在差异的主要原因是试件加工工艺引起翅片表面存在毛刺。按照均匀设计法得到6因子5水平的11种仿真方案,引入田口方法的信噪比和贡献率,研究各几何参数对翅片性能的影响程度,依次为齿距、齿高、齿型角、错齿距、齿开窗宽度和齿厚。根据各水平下各可控因子的信噪比分布得到翅片的优化模型,并通过仿真验证了优化模型的有效性。