output/DEbyBINs.xlsx

Selected Cell

Cell:

Value:

Pie_Charts Percent_of_all

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

###


###Counts of significantly DE genes in each group for each BIN					##Percentage of all DE genes by BINs
		low2	high1	high2			low2	###Remove all BINs with zero DE genes and combine those that have less than 3% in OTHER
1	1 photosynthesis	1	243	232	20	20 stress	10
2	2 major CHO metabolism	0	71	60	26	26 misc	18
3	3 minor CHO metabolism	3	48	41	27	27 RNA	19
4	4 glycolysis	1	34	28	30	30 signalling	20
5	5 fermentation	0	5	6	34	34 transport	27
6	6 gluconeogenesis	0	10	7	35	35 not assigned	27
7	7 OPP	0	19	13	28	28 DNA	36
8	8 TCA	2	40	27	29	29 protein	82
9	9 mitochondrial electron transport	0	32	17		OTHER	45
10	10 cell wall	3	143	94
11	11 lipid metabolism	6	200	144		OTHER	low2
12	12 N-metabolism	0	13	11	1	1 photosynthesis	1
13	13 amino acid metabolism	8	136	124	3	3 minor CHO metabolism	3
14	14 S-assimilation	0	9	9	4	4 glycolysis	1
15	15 metal handling	0	36	33	8	8 TCA	2
16	16 secondary metabolism	3	145	131	10	10 cell wall	3
17	17 horormone metabolism	7	168	129	11	11 lipid metabolism	6
18	18 co-factor and vitamine metabolism	0	29	29	16	16 secondary metabolism	3
19	19 tetrapyrrole synthesis	1	55	55	17	17 horormone metabolism	7
20	20 stress	10	309	281	19	19 tetrapyrrole synthesis	1
21	21 redox	0	87	85	23	23 nucleotide metabolism	2
22	22 polyamine metabolism	0	9	9	25	25 C1-metabolism	1
23	23 nucleotide metabolism	2	77	62	31	31 cell	3
24	24 biodegradation of xenobiotics	0	9	6	33	33 development	7
25	25 C1-metabolism	1	15	16		SUM	40
26	26 misc	18	511	399
27	27 RNA	19	875	702
28	28 DNA	36	209	163
29	29 protein	82	1249	1043
30	30 signalling	20	476	374
31	31 cell	3	271	206			high1
32	32 microRNA	0	0	0	11	11 lipid metabolism	200
33	33 development	7	163	139	28	28 DNA	209
34	34 transport	27	404	320	1	1 photosynthesis	243
35	35 not assigned	27	1769	1477	31	31 cell	271
	SUM	292	7869	6472	20	20 stress	309
					34	34 transport	404
					30	30 signalling	476
					26	26 misc	511
					27	27 RNA	875
					29	29 protein	1249
					35	35 not assigned	1769
						OTHER	1353

						OTHER	high1
					2	2 major CHO metabolism	71
					3	3 minor CHO metabolism	48
					4	4 glycolysis	34
					5	5 fermentation	5
					6	6 gluconeogenesis	10
					7	7 OPP	19
					8	8 TCA	40
					9	9 mitochondrial electron transport	32
					10	10 cell wall	143
					12	12 N-metabolism	13
					13	13 amino acid metabolism	136
					14	14 S-assimilation	9
					15	15 metal handling	36
					16	16 secondary metabolism	145
					17	17 horormone metabolism	168
					18	18 co-factor and vitamine metabolism	29
					19	19 tetrapyrrole synthesis	55
					21	21 redox	87
					22	22 polyamine metabolism	9
					23	23 nucleotide metabolism	77
					24	24 biodegradation of xenobiotics	9
					25	25 C1-metabolism	15
					33	33 development	163
						SUM	1353




							high2
					31	31 cell	206
					1	1 photosynthesis	232
					20	20 stress	281
					34	34 transport	320
					30	30 signalling	374
					26	26 misc	399
					27	27 RNA	702
					29	29 protein	1043
					35	35 not assigned	1477
						OTHER	1275


						OTHER	high2
					2	2 major CHO metabolism	60
					3	3 minor CHO metabolism	41
					4	4 glycolysis	28
					5	5 fermentation	6
					6	6 gluconeogenesis	7
					7	7 OPP	13
					8	8 TCA	27
					9	9 mitochondrial electron transport	17
					10	10 cell wall	94
					11	11 lipid metabolism	144
					12	12 N-metabolism	11
					13	13 amino acid metabolism	124
					14	14 S-assimilation	9
					15	15 metal handling	33
					16	16 secondary metabolism	131
					17	17 horormone metabolism	129
					18	18 co-factor and vitamine metabolism	29
					19	19 tetrapyrrole synthesis	55
					21	21 redox	85
					22	22 polyamine metabolism	9
					23	23 nucleotide metabolism	62
					24	24 biodegradation of xenobiotics	6
					25	25 C1-metabolism	16
					28	28 DNA	163
					33	33 development	139
						SUM	1438

100

101

102

103



						#Number of all Nb genes assigned to each BIN	#Percent of DE genes in each BIN
		low2	high1	high2		All_genes			low2	high1	high2		low2
1	1 photosynthesis	6	243	232	1 photosynthesis	694	1	1 photosynthesis	0.008645533141210375	0.35014409221902015	0.33429394812680113	28 DNA	0.033210332103321034
2	2 major CHO metabolism	0	71	60	2 major CHO metabolism	252	2	2 major CHO metabolism	0	0.28174603174603174	0.23809523809523808	25 C1-metabolism	0.01818181818181818
3	3 minor CHO metabolism	3	48	41	3 minor CHO metabolism	188	3	3 minor CHO metabolism	0.015957446808510637	0.2553191489361702	0.21808510638297873	3 minor CHO metabolism	0.015957446808510637
4	4 glycolysis	1	34	28	4 glycolysis	154	4	4 glycolysis	0.006493506493506494	0.22077922077922077	0.18181818181818182	34 transport	0.014143530644316397
5	5 fermentation	0	5	6	5 fermentation	41	5	5 fermentation	0	0.12195121951219512	0.14634146341463414	29 protein	0.013524657760184727
6	6 gluconeogenesis	0	10	7	6 gluconeogenesis	28	6	6 gluconeogenesis	0	0.35714285714285715	0.25	8 TCA	0.012195121951219513
7	7 OPP	0	19	13	7 OPP	60	7	7 OPP	0	0.31666666666666665	0.21666666666666667	13 amino acid metabolism	0.011904761904761904
8	8 TCA	2	40	27	8 TCA	164	8	8 TCA	0.012195121951219513	0.24390243902439024	0.16463414634146342	19 tetrapyrrole synthesis	0.01
9	9 mitochondrial electron transport	0	32	17	9 mitochondrial electron transport	327	9	9 mitochondrial electron transport	0	0.09785932721712538	0.05198776758409786	1 photosynthesis	0.008645533141210375
10	10 cell wall	3	143	94	10 cell wall	885	10	10 cell wall	0.003389830508474576	0.1615819209039548	0.10621468926553672	33 development	0.00798175598631699
11	11 lipid metabolism	6	200	144	11 lipid metabolism	767	11	11 lipid metabolism	0.007822685788787484	0.2607561929595828	0.1877444589308996	30 signalling	0.007971303308090873
12	12 N-metabolism	0	13	11	12 N-metabolism	52	12	12 N-metabolism	0	0.25	0.21153846153846154	11 lipid metabolism	0.007822685788787484
13	13 amino acid metabolism	8	136	124	13 amino acid metabolism	672	13	13 amino acid metabolism	0.011904761904761904	0.20238095238095238	0.18452380952380953	17 horormone metabolism	0.007551240560949299
14	14 S-assimilation	0	9	9	14 S-assimilation	25	14	14 S-assimilation	0	0.36	0.36	26 misc	0.007272727272727273
15	15 metal handling	0	36	33	15 metal handling	140	15	15 metal handling	0	0.2571428571428571	0.2357142857142857	4 glycolysis	0.006493506493506494
16	16 secondary metabolism	3	145	131	16 secondary metabolism	717	16	16 secondary metabolism	0.0041841004184100415	0.20223152022315202	0.18270571827057183	23 nucleotide metabolism	0.006309148264984227
17	17 horormone metabolism	7	168	129	17 horormone metabolism	927	17	17 horormone metabolism	0.007551240560949299	0.18122977346278318	0.13915857605177995	20 stress	0.005543237250554324
18	18 co-factor and vitamine metabolism	0	29	29	18 co-factor and vitamine metabolism	211	18	18 co-factor and vitamine metabolism	0	0.13744075829383887	0.13744075829383887	16 secondary metabolism	0.0041841004184100415
19	19 tetrapyrrole synthesis	1	55	55	19 tetrapyrrole synthesis	100	19	19 tetrapyrrole synthesis	0.01	0.55	0.55	27 RNA	0.004062433183664742
20	20 stress	10	309	281	20 stress	1804	20	20 stress	0.005543237250554324	0.1712860310421286	0.1557649667405765	10 cell wall	0.003389830508474576
21	21 redox	0	87	85	21 redox	301	21	21 redox	0	0.28903654485049834	0.2823920265780731	35 not assigned	0.002529037092544024
22	22 polyamine metabolism	0	9	9	22 polyamine metabolism	37	22	22 polyamine metabolism	0	0.24324324324324326	0.24324324324324326	31 cell	0.0021929824561403508
23	23 nucleotide metabolism	2	77	62	23 nucleotide metabolism	317	23	23 nucleotide metabolism	0.006309148264984227	0.24290220820189273	0.19558359621451105
24	24 biodegradation of xenobiotics	0	9	6	24 biodegradation of xenobiotics	43	24	24 biodegradation of xenobiotics	0	0.20930232558139536	0.13953488372093023
25	25 C1-metabolism	1	15	16	25 C1-metabolism	55	25	25 C1-metabolism	0.01818181818181818	0.2727272727272727	0.2909090909090909
26	26 misc	18	511	399	26 misc	2475	26	26 misc	0.007272727272727273	0.20646464646464646	0.16121212121212122
27	27 RNA	19	875	702	27 RNA	4677	27	27 RNA	0.004062433183664742	0.1870857387214026	0.150096215522771		high1
28	28 DNA	36	209	163	28 DNA	1084	28	28 DNA	0.033210332103321034	0.19280442804428044	0.1503690036900369	19 tetrapyrrole synthesis	0.55
29	29 protein	82	1249	1043	29 protein	6063	29	29 protein	0.013524657760184727	0.20600362856671614	0.17202704931552038	14 S-assimilation	0.36
30	30 signalling	20	476	374	30 signalling	2509	30	30 signalling	0.007971303308090873	0.18971701873256278	0.1490633718612993	6 gluconeogenesis	0.35714285714285715
31	31 cell	3	271	206	31 cell	1368	31	31 cell	0.0021929824561403508	0.19809941520467836	0.15058479532163743	1 photosynthesis	0.35014409221902015
32	32 microRNA	0	0	0	32 microRNA	2	32	32 microRNA	0	0	0	7 OPP	0.31666666666666665
33	33 development	7	163	139	33 development	877	33	33 development	0.00798175598631699	0.18586088939566706	0.15849486887115166	21 redox	0.28903654485049834
34	34 transport	27	404	320	34 transport	1909	34	34 transport	0.014143530644316397	0.21162912519643792	0.1676270298585647	2 major CHO metabolism	0.28174603174603174
35	35 not assigned	27	1769	1477	35 not assigned	10676	35	35 not assigned	0.002529037092544024	0.16569876358186586	0.13834769576620456	25 C1-metabolism	0.2727272727272727
												11 lipid metabolism	0.2607561929595828
												15 metal handling	0.2571428571428571
												3 minor CHO metabolism	0.2553191489361702
												12 N-metabolism	0.25
												8 TCA	0.24390243902439024
												22 polyamine metabolism	0.24324324324324326
												23 nucleotide metabolism	0.24290220820189273
												4 glycolysis	0.22077922077922077
												34 transport	0.21162912519643792
												24 biodegradation of xenobiotics	0.20930232558139536
												26 misc	0.20646464646464646
												29 protein	0.20600362856671614
												13 amino acid metabolism	0.20238095238095238
												16 secondary metabolism	0.20223152022315202
												31 cell	0.19809941520467836
												28 DNA	0.19280442804428044
												30 signalling	0.18971701873256278
												27 RNA	0.1870857387214026
												33 development	0.18586088939566706
												17 horormone metabolism	0.18122977346278318
												20 stress	0.1712860310421286
												35 not assigned	0.16569876358186586
												10 cell wall	0.1615819209039548
												18 co-factor and vitamine metabolism	0.13744075829383887
												5 fermentation	0.12195121951219512
												9 mitochondrial electron transport	0.09785932721712538



													high2
												19 tetrapyrrole synthesis	0.55
												14 S-assimilation	0.36
												1 photosynthesis	0.33429394812680113
												25 C1-metabolism	0.2909090909090909
												21 redox	0.2823920265780731
												6 gluconeogenesis	0.25
												22 polyamine metabolism	0.24324324324324326
												2 major CHO metabolism	0.23809523809523808
												15 metal handling	0.2357142857142857
												3 minor CHO metabolism	0.21808510638297873
												7 OPP	0.21666666666666667
												12 N-metabolism	0.21153846153846154
												23 nucleotide metabolism	0.19558359621451105
												11 lipid metabolism	0.1877444589308996
												13 amino acid metabolism	0.18452380952380953
												16 secondary metabolism	0.18270571827057183
												4 glycolysis	0.18181818181818182
												29 protein	0.17202704931552038
												34 transport	0.1676270298585647
												8 TCA	0.16463414634146342
												26 misc	0.16121212121212122
												33 development	0.15849486887115166
												20 stress	0.1557649667405765
												31 cell	0.15058479532163743
												28 DNA	0.1503690036900369
												27 RNA	0.150096215522771
												30 signalling	0.1490633718612993
												5 fermentation	0.14634146341463414
												24 biodegradation of xenobiotics	0.13953488372093023
												17 horormone metabolism	0.13915857605177995
												35 not assigned	0.13834769576620456
												18 co-factor and vitamine metabolism	0.13744075829383887
												10 cell wall	0.10621468926553672
												9 mitochondrial electron transport	0.05198776758409786