A Statistics and Analyses System of Microbial Community Level Physiological Profiles (CLPP) Based on Excel

Molecular Soil Biology Pub Date : 2019-08-30 DOI:10.5376/msb.2019.10.0001

Lin Li, Yanjie Zhu, Songyan Tian, Qian Du, Shenkui Liu

{"title":"A Statistics and Analyses System of Microbial Community Level Physiological Profiles (CLPP) Based on Excel","authors":"Lin Li, Yanjie Zhu, Songyan Tian, Qian Du, Shenkui Liu","doi":"10.5376/msb.2019.10.0001","DOIUrl":null,"url":null,"abstract":"Microbial community level physiological profiles (CLPP) assessed using Biolog MicroPlates has effectively demonstrated the metabolic activities of multiple microbes. Due to a large volume of data, and complicated calculation process, the conventional low efficiency calculations delay the study. To empower researchers to quickly tabulate, compute, analyze and present data, we introduced A Biolog EcoPlate data statistics and analyses system (A-BEP-DSAS). It is implemented with Biolog EcoPlate data tested by an ELISA microplate reader (Molecular Devices Versamax). The data input-output process and visual calculation flow are performed using Excel table linked with built-in VBA programming language. We tested A-BEP-DSAS by data from a soil sample, and rapidly and accurately obtained the average well color development (AWCD) data, carbon source utilization, six common diversity indices and other calculation results. A-BEP-DSAS is an automated program based on Microsoft Excel VBA, with the advantages of easy operation, rapid analysis, process visualization, and also allows the user to choose the data source and optimum time for analysis.","PeriodicalId":365098,"journal":{"name":"Molecular Soil Biology","volume":"1 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2019-08-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"2","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Molecular Soil Biology","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.5376/msb.2019.10.0001","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 2

Abstract

Microbial community level physiological profiles (CLPP) assessed using Biolog MicroPlates has effectively demonstrated the metabolic activities of multiple microbes. Due to a large volume of data, and complicated calculation process, the conventional low efficiency calculations delay the study. To empower researchers to quickly tabulate, compute, analyze and present data, we introduced A Biolog EcoPlate data statistics and analyses system (A-BEP-DSAS). It is implemented with Biolog EcoPlate data tested by an ELISA microplate reader (Molecular Devices Versamax). The data input-output process and visual calculation flow are performed using Excel table linked with built-in VBA programming language. We tested A-BEP-DSAS by data from a soil sample, and rapidly and accurately obtained the average well color development (AWCD) data, carbon source utilization, six common diversity indices and other calculation results. A-BEP-DSAS is an automated program based on Microsoft Excel VBA, with the advantages of easy operation, rapid analysis, process visualization, and also allows the user to choose the data source and optimum time for analysis.

查看原文

微信好友朋友圈 QQ好友复制链接

本刊更多论文

基于Excel的微生物群落水平生理剖面统计分析系统

使用Biolog MicroPlates评估的微生物群落水平生理特征(CLPP)有效地展示了多种微生物的代谢活动。由于数据量大，计算过程复杂，传统的低效率计算耽误了研究。为了使研究人员能够快速制表，计算，分析和呈现数据，我们引入了Biolog EcoPlate数据统计和分析系统(A- bep - dsas)。它是用ELISA微孔板读取器(Molecular Devices Versamax)测试的Biolog EcoPlate数据实现的。数据的输入输出过程和可视化的计算流程采用Excel表格与内置的VBA编程语言进行链接。利用土壤样品数据对a - bep - dsas进行了测试，快速准确地获得了平均井色发育(AWCD)数据、碳源利用率、6个常见多样性指数等计算结果。A-BEP-DSAS是基于Microsoft Excel VBA的自动化程序，具有操作简便、分析快速、过程可视化等优点，并允许用户选择数据源和最佳分析时间。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

求助全文

约1分钟内获得全文去求助

来源期刊

Molecular Soil Biology

自引率

0.00%

发文量

期刊最新文献

Purification and Optimization of Prokaryotic Expression of CSN5B Protein of Arabidopsis thaliana A Statistics and Analyses System of Microbial Community Level Physiological Profiles (CLPP) Based on Excel Research Progress of Urea Transporter DUR3 in Plants and Fungi Expression and Purification of Arabidopsis CASPL1D2 Protein Research Progress of Plant Rab Proteins