Biology-ECO计算模板.xls

590 nmO.D.12345678A1.0182.4091.7532.4870.3932.862.5952.372B1.7920.9972.4922.7021.6241.7892.6032.398C2.1241.4140.1270.981.9640.5590.1370.73D2.3232.2451.3182.391.9262.491.7992.399E2.2722.5961.5532.3671.8672.5851.8782.23F2.6571.7061.411.9562.3581.191.3621.363G2.5931.9831.660.8752.2671.4541.5580.706H1.6052.2762.2942.162.7962.571.061.961分别减A1，A5，A9空白值(请注意，此处对小于零的负数按0计算，如果要计算基尼系数，则修改算法保留负值)1234567801.3910.7351.46902.4672.2021.9790.77401.4741.6841.2311.3962.212.0051.1060.396001.5710.16600.3371.3051.2270.31.3721.5332.0971.4062.0061.2541.5780.5351.3491.4742.1921.4851.8371.6390.6880.3920.9381.9650.7970.9690.971.5750.9650.64201.8741.0611.1650.3130.5871.2581.2761.1422.4032.1770.6671.56831种碳源的平均值1234A0.0001.4481.2031.226AWCD值=0.848B0.6680.4651.3171.370C0.8920.1870.0000.112多样性指数U=5.253785D0.9461.1660.5691.126E1.0341.4590.6731.062多样性指数H=3.284346F1.2780.4950.4540.636G1.2540.6750.6020.104H1.1711.1450.6480.903转换为单列数据，用于后期的数据处理，如用SPSS进行主成份分析和聚类分析注意：此为单个时间点的数据，不包括空白孔0.6680.8920.9461.0341.2781.2541.1711.4480.4650.1871.1661.4590.4950.6751.1451.2031.3170.0000.5690.6730.4540.6020.6481.2261.3700.1121.1261.0620.6360.1040.90391011122.0472.5342.7192.278 注：原始数据590nm的吸光度值请拷贝覆盖此区域1.9021.3552.3142.468 A1，A5，A9为三个空白对照1.9331.1060.160.7831.8262.2221.2461.6332.4222.6540.7831.3752.2780.8460.761.7122.3591.8061.1090.1962.571.6470.9530.779910111200.4870.6720.231000.2670.421000000.175000.3750.607000.2310000.312000-2.898840.523000Pi=每个孔吸光度/所有吸光度之和Pi*LnPi0.0000.0550.0460.0470-0.15969-0.141130.0250.0180.0500.052-0.09335-0.0714-0.149970.0340.0070.0000.004-0.11482-0.0352300.0360.0440.0220.043-0.11963-0.1382-0.082920.0390.0550.0260.040-0.12729-0.16046-0.093860.0490.0190.0170.024-0.14702-0.07479-0.070050.0480.0260.0230.004-0.14511-0.09406-0.086510.0450.0440.0250.034-0.13858-0.13648-0.09123吸光度之和=26.292以下数据为各碳源种类的平均吸光度减背景后)单糖糖苷聚合糖类平均吸光度=1.047B2，D-木糖 H1,a-D-乳糖A2,-甲基D-葡萄糖苷 G2,葡萄糖-1-磷酸盐 E1,a-环状糊精F1,肝糖G1,D-纤维二糖氨基酸类，平均吸光度=0.922A4，L-精氨酸，B4，L-天冬酰胺酸 C4 L-苯基丙氨酸D4,L-丝氨酸E4，L-苏氨酸(请注意，此处对小于零的负数按0计算，如果要计算基尼系数，则修改算法保留负值)F4，甘氨酰-L-谷氨酸 酯类平均吸光度=0.927B1,丙酮酸甲酯C1,吐温40D1,吐温80A3,D-半乳糖酸内酯醇类平均吸光度=0.833C2,I-赤藻糖醇D2,D-甘露醇H2,D,L-a-甘油胺类平均吸光度=0.822G4,苯乙基胺H4,腐胺E2,N-乙酰基-D-葡萄胺 酸类平均吸光度=0.595B3,D-半乳糖醛酸F2 D-氨基葡萄糖酸C3,2-羟苯甲酸D3,4-羟基苯甲酸E3,r-羟基丁酸F3,衣康酸G3,a-丁酮酸H3,D-苹果酸-0.14297-0.15395-0.02331-0.13493-0.12963-0.09003-0.02194-0.11582590 nmO.D.12345678910A1.0182.4091.7532.4870.3932.862.5952.3722.0472.534B1.7920.9972.4922.7021.6241.7892.6032.3981.9021.355C2.1241.4140.1270.981.9640.5590.1370.731.9331.106D2.3232.2451.3182.391.9262.491.7992.3991.8262.222E2.2722.5961.5532.3671.8672.5851.8782.232.4222.654F2.6571.7061.411.9562.3581.191.3621.3632.2780.846G2.5931.9831.660.8752.2671.4541.5580.7062.3591.806H1.6052.2762.2942.162.7962.571.061.9612.571.647750 nmO.D.12345678910A0.4470.8940.761.2120.2471.0981.0871.1360.8030.967B0.5650.5190.8911.1020.6780.7471.0111.0040.6530.641C0.7510.5960.0870.3940.7020.290.1070.3430.6320.512D0.5520.8290.5140.9280.5920.9050.740.970.4790.769E0.9840.870.6230.940.7540.8890.7940.8631.1411.011F1.0850.7460.50.7120.8950.5080.4590.5960.910.409G1.1590.9910.8390.4651.0430.7880.7270.4041.0740.789H0.8790.9151.120.8951.4471.0830.5110.8081.190.749590-750nmO.D.12345678910A0.5711.5150.9931.2750.1461.7621.5081.2361.2441.567B1.2270.4781.6011.6000.9461.0421.5921.3941.2490.714C1.3730.8180.0400.5861.2620.2690.0300.3871.3010.594D1.7711.4160.8041.4621.3341.5851.0591.4291.3471.453E1.2881.7260.9301.4271.1131.6961.0841.3671.2811.643F1.5720.9600.9101.2441.4630.6820.9030.7671.3680.437G1.4340.9920.8210.4101.2240.6660.8310.3021.2851.017H0.7261.3611.1741.2651.3491.4870.5491.1531.3800.898以下数据为各碳源种类的平均吸光度(减背景后)单糖糖苷聚合糖类B2，D-木糖 H1,a-D-乳糖A2,-甲基D葡萄糖苷 G2,葡萄糖-1-磷酸盐 E1,a-环状糊精F1,肝糖G1,D-纤维二糖氨基酸类，A4，L-精氨酸，B4，L-天冬酰胺酸 C4 L-苯基丙氨酸D4,L-丝氨酸E4，L-苏氨酸 F4，甘氨酰-L-谷氨酸 酯类B1,丙酮酸甲酯C1,吐温40D1,吐温80A3,D-半乳糖酸内酯醇类C2,I-赤藻糖醇D2,D-甘露醇H2,D,L-a-甘油胺类G4,苯乙基胺H4,腐胺E2,N-乙酰基-D-葡萄胺 酸类B3,D-半乳糖醛酸F2 D-氨基葡萄糖酸C3,2-羟苯甲酸D3,4-羟基苯甲酸E3,r-羟基丁酸F3,衣康酸G3,a-丁酮酸H3,D-苹果酸11122.7192.278 注：原始数据590nm的吸光度值请拷贝覆盖此区域2.3142.468 A1，A5，A9为三个空白对照0.160.7831.2461.6330.7831.3750.761.7121.1090.1960.9530.77911121.0851.11 注：原始数据750nm的吸光度值请拷贝覆盖此区域0.8920.982 A1，A5，A9为三个空白对照0.120.3490.4850.6590.350.5340.2840.6440.5070.140.4360.358再减空白值(请注意，此处对小于零的负数按0计算,如果要计算基尼系数，则要改变算法，保留负数)11121234561.6341.16800.9440.4220.70401.6161.4221.4860.65601.031.0290.80.8960.0400.4340.8020.24700.0151.1160.1230.7610.9741.20.8450.2330.8911.1881.4390.4330.8410.7171.1550.3590.8560.9671.550.4761.0681.0010.3890.3390.6731.3170.5360.6020.0560.8630.4210.2501.0780.520.5170.4210.1550.790.6030.6941.2031.34131种碳源的平均值，不同颜色代表不同种类的碳源1234A0.0000.9610.7250.598B0.4870.2990.8850.840C0.6580.1230.0000.085D0.8300.8310.3820.725E0.5741.0350.4320.692F0.8140.3080.3650.431G0.6610.3140.3120.052H0.4980.7100.3350.567转换为单列数据，用于后期的数据处理，如用SPSS进行主成份分析和聚类分析平均吸光度=0.634注意：此为单个时间点的数据，不包括空白孔0.4870.6580.8300.5740.8140.6610.498以下数据为各碳源种类的平均吸光度(减背景后)A2,-甲基D-葡萄糖苷 G2,葡萄糖-1-磷酸盐 0.9610.299平均吸光度=0.5620.1230.8311.0350.3080.3140.7100.7250.885平均吸光度=0.6750.0000.3820.4320.3650.312平均吸光度=0.5550.3350.5980.8400.0850.725平均吸光度=0.5510.6920.4310.0520.567平均吸光度=0.377C4 L-苯基丙氨酸F4，甘氨酰-L-谷氨酸 A3,D-半乳糖酸内酯E2,N-乙酰基-D-葡萄胺 7891011121.3621.0900.3230.3901.4461.2480.00500.1780.24200.2410.0570000.9131.2830.1030.209000.9381.2210.0370.399000.7570.6210.1240000.6850.1560.0410000.4031.0070.136000Pi=每个孔吸光度/所有吸光度之和Pi*LnPiAWCD值=0.5330.0000.0580.0440.0360.0000.0290.0180.0540.051-0.104多样性指数U=3.3303990.0400.0070.0000.005-0.1280.0500.0500.0230.044-0.150多样性指数H=3.2765670.0350.0630.0260.042-0.1170.0490.0190.0220.026-0.1480.0400.0190.0190.003-0.1290.0300.0430.0200.034-0.106吸光度之和=16.529(请注意，此处对小于零的负数按0计算,如果要计算基尼系数，则要改变算法，保留负数)转换为单列数据，用于后期的数据处理，如用SPSS进行主成份分析和聚类分析-0.165-0.137-0.120-0.073-0.157-0.151-0.0370.000-0.027-0.150-0.087-0.137-0.173-0.095-0.133-0.074-0.084-0.095-0.075-0.075-0.018-0.135-0.079-0.116