output/CPB_survival_ANONYMOUS.xlsx

Selected Cell

Cell:

Value:

screening_survival screening_weighing mesh_miniEXP_3rd4th mesh_1dpt_RNAseq__exp_potted MeJA_exp

100

0 dpt
biol repl	H2O	egfp (-)	vATPaseE (+)	alas	JHBP	mesh
1	10	10	10	10	10	10
2	10	10	10	10	10	10
3	10	10	10	10	10	10
4	10	10	10	10	10	10
average	10	10	10	10	10	10

1 dpt
biol repl	H2O	egfp (-)	vATPaseE (+)	alas	JHBP	mesh
1	10	10	10	10	10	10
2	10	10	10	10	10	10
3	10	10	10	9	10	9
4	10	10	10	9	10	10
average	10	10	10	9.5	10	9.75

2 dpt
biol repl	H2O	egfp (-)	vATPaseE (+)	alas	JHBP	mesh
1	10	10	10	10	10	10
2	10	8	10	10	10	10
3	10	9	10	9	10	9
4	10	10	10	9	10	8
average	10	9.25	10	9.5	10	9.25

3 dpt
biol repl	H2O	egfp (-)	vATPaseE (+)	alas	JHBP	mesh
1	10	9	10	10	10	10
2	10	7	10	9	10	8
3	10	9	10	9	10	8
4	10	9	9	9	10	8
average	10	8.5	9.75	9.25	10	8.5

4 dpt
biol repl	H2O	egfp (-)	vATPaseE (+)	alas	JHBP	mesh
1	9	8	9	10	9	4	(4 group middle size larvae were sampled for silencing confirmation)
2	10	7	10	8	9	6
3	9	9	9	8	9	4
4	10	8	7	9	10	5
average	9.5	8	8.75	8.75	9.25	4.75

5 dpt
biol repl	H2O	egfp (-)	vATPaseE (+)	alas	JHBP	mesh
1	5	4	3	5	5	0
2	10	6	10	8	9	2
3	8	9	6	8	8	2
4	10	8	3	6	9	1
average	8.25	6.75	5.5	6.75	7.75	1.25

6 dpt
biol repl	H2O	egfp (-)	vATPaseE (+)	alas	JHBP	mesh
1	5	4	1	4	5	0
2	10	6	6	6	9	0
3	8	9	3	8	7	0
4	9	8	2	6	9	1
average	8	6.75	3	6	7.5	0.25

7 dpt
biol repl	H2O	egfp (-)	vATPaseE (+)	alas	JHBP	mesh
1	5	4	1	4	4	0
2	10	6	3	4	9	0
3	8	8	3	6	7	0
4	9	8	0	7	9	1
average	8	6.5	1.75	5.25	7.25	0.25

8 dpt
biol repl	H2O	egfp (-)	vATPaseE (+)	alas	JHBP	mesh
1	5	3	1	4	4	0
2	10	6	1	4	8	0
3	6	7	0	6	7	0
4	9	8	0	6	8	0
average	7.5	6	0.5	5	6.75	0

9 dpt
biol repl	H2O	egfp (-)	vATPaseE (+)	alas	JHBP	mesh
1	3	3	0	4	3	0
2	9	6	1	2	8	0
3	6	7	0	6	5	0
4	8	6	0	6	6	0
average	6.5	5.5	0.25	4.5	5.5	0

10 dpt
biol repl	H2O	egfp (-)	vATPaseE (+)	alas	JHBP	mesh
1	3	3	0	4	3	0
2	8	6	0	2	8	0
3	6	7	0	6	6	0
4	7	5	0	5	6	0
average	6	5.25	0	4.25	5.75	0

11 dpt
biol repl	H2O	egfp (-)	vATPaseE (+)	alas	JHBP	mesh
1	2	3	0	4	3	0
2	7	6	0	2	8	0
3	5	7	0	6	6	0
4	7	5	0	4	6	0
average	5.25	5.25	0	4	5.75	0

12 dpt
biol repl	H2O	egfp (-)	vATPaseE (+)	alas	JHBP	mesh
1	2	3	0	4	3	0
2	6	6	0	2	8	0

901

902

903

904

905

906

907

908

909

910

911

912

913

914

915

916

917

918

919

920

921

922

923

924

925

926

927

928

929

930

931

932

933

934

935

936

937

938

939

940

941

942

943

944

945

946

947

948

949

950

951

952

953

954

955

956

957

958

959

960

961

962

963

964

965

966

967

968

969

970

971

972

973

974

975

976

977

978

979

980

981

982

983

984

985

986

987

988

989

990

991

992

993

994

995

996

997

998

999

1000

pupa

dead

pupa

dead

pupa

dead

average:

68.5

median:

68.5

SE:

10.499999999999998

11.532562594670797

dead larvae:

0.4722222222222222

0.4444444444444444

0.6388888888888888

0.5277777777777778

pupating:

0.3055555555555556

0.3888888888888889

0.2222222222222222

0.3055555555555556

adults:

0.19444444444444445

0.1111111111111111

0.05555555555555555

0.1388888888888889

adults/pupae:

0.4117647058823529

0.2222222222222222

0.3333333333333333

28 dpt

biol repl

larva No

H2O

egfp (-)

vATPaseE (+)

alas

JHBP

mesh

115

pupa

dead

adult

dead

adult

pupa

dead

pupa

dead

pupa

dead

pupa

dead

adult

dead

adult

dead

adult

dead

adult

dead

pupa

adult

dead

adult

dead

pupa

adult

dead

adult

dead

pupa

dead

pupa

dead

pupa

dead

pupa

dead

adult

dead

pupa

dead

adult

dead

adult

dead

adult

dead

pupa

dead

pupa

adult

dead

pupa

dead

pupa

dead

pupa

dead

pupa

dead

pupa

dead

adult

dead

pupa

adult

dead

adult

dead

pupa

dead

adult

dead

pupa

dead

adult

pupa

dead

pupa

dead

pupa

dead

pupa

dead

pupa

dead

average:

115

median:

115

SE:

13.999999999999998

dead larvae:

0.4722222222222222

0.4444444444444444

0.6666666666666666

0.5277777777777778

pupating:

0.2222222222222222

0.25

0.2777777777777778

adults:

0.2777777777777778

0.25

0.05555555555555555

0.19444444444444445

adults/pupae:

0.5882352941176471

0.5

0.2222222222222222

0.4666666666666667

30 dpt

biol repl

larva No

H2O

egfp (-)

vATPaseE (+)

alas

JHBP

mesh

adult

dead

adult

dead

adult

pupa

dead

adult

pupa

dead

pupa

dead

pupa

dead

adult

dead

adult

dead

adult

dead

adult

dead

pupa

adult

dead

adult

dead

pupa

adult

dead

adult

dead

pupa

adult

dead

adult

dead

pupa

adult

dead

pupa

dead

adult

dead

adult

dead

adult

dead

adult

dead

adult

dead

adult

pupa

dead

adult

dead

adult

pupa

dead

adult

dead

pupa

dead

pupa

dead

pupa

dead

5x larvae 3rd instar, 5x 4th instar reared on small leaves in petri dish

0 dpt
larva No	younger (3rd)	older (4th)
1	11	45
2	10	40
3	8	42
4	10	40
5	11	42
average:	10	41.8
median:	10	42
SD:	1.224744871391589	2.04939015319192

1 dpt
larva No	younger (3rd)	older (4th)
1	15	57
2	20	62
3	16	57
4	17	56
5	dead	dead
average:	17	58
median:	16.5	57
SD:	2.160246899469287	2.70801280154532

2 dpt
larva No	younger (3rd)	older (4th)
1	11	48
2	11	47
3	15	53
4	11	42
5	dead	dead
average:	12	47.5
median:	11	47.5
SD:	2	4.509249752822894

3 dpt
larva No	younger (3rd)	older (4th)
1	10	43	sampling guts from 4th instar larvae and whole 3rd instar larvae (RI067-072)
2	8	43
3	13	dead
4	8	dead
5	dead	dead
average:	9.75	43
median:	9	43
SD:	2.362907813126304	0
END OF EXPERIMENT

0 dpt - 15.6. (4th instar larvae to be disected and gut tissue and contents sampled for RNAseq)				1 dpt (4th instar larvae to be disected and gut tissue and contents sampled for RNAseq)
biol repl	larva No	mesh	egfp	biol repl	larva No	mesh	egfp
1	1	95	142	1	1	132	dead (85)
1	2	111	119	1	2	133	123
1	3	89	85	1	3	140	117
1	4	112	101	1	4	120	110
2	1	95	93	2	1	148	112
2	2	97	96	2	2	126	107
2	3	100	117	2	3	106	163
2	4	119	88	2	4	139	114
3	1	119	141	3	1	134	188
3	2	80	111	3	2	147	151
3	3	137	122	3	3	141	138
3	4	103	111	3	4	78	did not eat (102)
4	1	143	127	4	1	114	127
4	2	138	136	4	2	104	96
4	3	91	110	4	3	161	100
4	4	88	98	4	4	165	116
average:		107.3125	112.3125	average:		130.5	125.85714285714286
median:		101.5	111	median:		133.5	116.5
SD:		19.334662310644752	18.183211120884746	SD:		22.29200155511688	25.87798928955513
t-test p-val			0.4570031741260364	t-test p-val			0.60159510254477
				END OF EXPERIMENT
mesh experiment in greenhouse condition on potted plants
0 dpt; 4th instar larvae grown on potted plants left for observation of pupation/adult emergence
larva No	H2O	egfp	mesh					5 dpt; checking how many larvae died
1	151	120	135						H2O	egfp	mesh
2	117	167	104					died	1	2	1
3	150	145	120					pupating	29	28	28
4	120	95	135
5	96	120	161					12 dpt; checking how many larvae died
6	131	91	129						H2O	egfp	mesh
7	170	124	130					died	1	2	2
8	108	118	104					pupating	29	28	28
9	146	142	85
10	163	182	119					checking beetle emergence
11	147	82	105					dpt	water	dsegfp	dsmesh
12	161	133	117					12	0	0	0
13	91	146	156					16	0	5	0
14	125	136	101					17	1	17	0
15	133	132	156					18	8	22	0
16	111	84	123					19	15	22	1
17	101	118	128					20	20	22	3
18	112	144	169					21	22	22	3
19	93	81	124					22	21	22	3
20	198	165	111					24	21	22	0
21	139	130	168
22	122	124	132
23	132	156	113
24	127	163	72					checking beetle emergence %
25	121	147	179					dpt	H2O	egfp	mesh
26	141	154	140					12	0	0	0
27	147	142	205					16	0	0.17857142857142858	0
28	135	149	155					17	0.034482758620689655	0.6071428571428571	0
29	125	96	122					18	0.27586206896551724	0.7857142857142857	0
30	140	146	160					19	0.5172413793103449	0.7857142857142857	0.03571428571428571
average:	131.76666666666668	131.06666666666666	131.93333333333334					20	0.6896551724137931	0.7857142857142857	0.10714285714285714
median:	131.5	134.5	128.5					21	0.7586206896551724	0.7857142857142857	0.10714285714285714
SD:	24.01534471143803	26.786426482047954	28.93027686594494					22	0.7241379310344828	0.7857142857142857	0.10714285714285714
t-test p-val		0.9154993663912261	0.9807162073779172					24	0.7241379310344828	0.7857142857142857	0

24dpt; alive beetle weights								24dpt; checking beetle survival
	H2O	egfp							H2O	egfp	mesh
1	111	115						emerged adults - alive	21	22	0
2	185	115						emerged adults - dead	0	0	3
3	135	106						adults found dead in soil	0	0	6	from the six adults, four looked clearly deformed
4	124	189						larvae found dead in soil	0	0	2
5	167	131
6	158	148
7	116	127
8	99	176
9	127	174
10	158	164
11	140	142
12	137	133
13	170	155
14	136	184
15	164	138
16	129	188
17	139	133
18	139	128
19	115	153
20	160	133
21	133	150
22		136
average:	140.0952380952381	146.27272727272728
median:	137	140
SD:	21.96338945132277	24.233353281281808
t-test p-val		0.38583742913544683

END OF EXPERIMENT

100

4 dpt - 26.6. (2nd instar larvae were placed at 0 dpt on MeJA-induced and non-induced leaves; weighing and survival count was performed every 2 days; fresh non-induced and MeJA-induced leaves were replaced every day)
biol repl	larva No	egfp_NI	egfp_MeJA	alas_NI	alas_MeJA	JHBP_NI	JHBP_MeJA
1	1	13	12	12	27	29	15		mean larval mass						mass SE
1	2	16	16	22	22	27	24	dpt	egfp_NI	egfp_MeJA	alas_NI	alas_MeJA	JHBP_NI	JHBP_MeJA	egfp_NI	egfp_MeJA	alas_NI	alas_MeJA	JHBP_NI	JHBP_MeJA
1	3	11	21	12	28	12	14	4	15.833333333333334	12.736842105263158	12.368421052631579	18.57894736842105	21.473684210526315	15.3	1.0202204042277407	1.0283755010352873	0.7422524842563567	1.4024118520499187	1.4992559968755956	1.0287959237047832
1	4	15	17	16	24	20	15	6	25.705882352941178	19.5	15.352941176470589	22.055555555555557	35.166666666666664	20.2	1.7080361656746605	1.8563616111556902	1.2512969050695677	2.540485546487118	2.5389128443829163	1.5670958725247828
1	5	11	23	11	12	15	16	8	36.9375	30.333333333333332	19.357142857142858	26.8	48.72222222222222	28.294117647058822	2.9459983452133844	3.510076198693544	2.473168415094118	3.104834939252004	3.8988900344024975	2.6426433762126953
1	6	19	13	13	11	19	23	10	47.57142857142857	38	19.928571428571427	40.8	57	33.294117647058826	4.4656371580805265	4.7855092624608835	2.2100278097655712	4.857525661852497	4.522005021200741	4.3384097671795
1	7	15	11	12	11	32	17	12	54.642857142857146	44.583333333333336	21.8	38.7	72.125	39.38461538461539	6.239370867531914	5.042934351018947	2.489087293679263	4.580271704701468	5.734308298885461	5.63930626477486
1	8	13	11	10	10	13	22	14	75.16666666666667	53.3	21.666666666666668	38.888888888888886	77.13333333333334	45.125	7.357570141278874	6.501367377542802	2.7131367660166177	5.888888888888888	5.7733927193690455	7.436487025855305
1	9	11	11	10	25	33	6
1	10	17	dead	7	dead	22	13
2	1	dead	13	14	23	13	15
2	2	18	10	14	18	16	18
2	3	10	5	10	14	20	13
2	4	dead	8	13	20	29	18
2	5	17	14	10	12	17	9
2	6	26	12	15	18	28	13
2	7	24	7	14	17	20	11
2	8	14	13	11	14	21	10
2	9	17	9	dead	28	22	19
2	10	18	16	9	19	dead	15
average:		15.833333333333334	12.736842105263158	12.368421052631579	18.57894736842105	21.473684210526315	15.3
median:		15.5	12	12	18	20	15
SE:		1.0202204042277407	1.0283755010352873	0.7422524842563567	1.4024118520499187	1.4992559968755956	1.0287959237047832
dead larvae:		0.05555555555555555	0.027777777777777776	0.027777777777777776	0.027777777777777776	0.027777777777777776	0
t-test p-val			0.039615307238862085		5.457226925340392E-4		0.0018373413204380523
			expected		strange!!!		expected
















									very interesting that the mass of larvae improves when feeding larvae with MeJA-induced potato leaves + alas dsRNA!!!
									HAS TO BE REPEATED TO CONFIRM!!!
									for ALAS could D-Aminolevulinic acid (ALA) formed in induced potato would rescue the silenced alas_RNAi phenotype?? ALA is accumulated by wounding in plants!
									for JHBP_NI the results are different compared to first experiment - there mass gain was similar to that of egfp group or slightly lower


6 dpt
biol repl	larva No	egfp_NI	egfp_MeJA	alas_NI	alas_MeJA	JHBP_NI	JHBP_MeJA
1	1	27	22	13	10	21	23
1	2	27	16	7	47	49	6
1	3	16	25	11	18	26	30
1	4	16	29	14	31	41	18
1	5	18	39	26	10	52	34
1	6	18	11	16	33	57	16
1	7	30	25	14	36	36	21
1	8	16	15	26	6	26	20
1	9	30	dead	16	dead	30	29
1	10	23	dead	11	dead	30	19
2	1	35	8	13	18	22	22
2	2	23	18	13	16	32	26
2	3	32	25	18	16	43	8
2	4	39	16	18	32	30	14
2	5	30	20	11	10	31	18
2	6	29	27	13	29	49	13
2	7	28	15	21	21	27	23
2	8	dead	8	dead	23	31	16
2	9	dead	15	dead	19	dead	24
2	10	dead	17	dead	22	dead	24
average:		25.705882352941178	19.5	15.352941176470589	22.055555555555557	35.166666666666664	20.2
median:		27	17.5	14	20	31	20.5
SE:		1.7080361656746605	1.8563616111556902	1.2512969050695677	2.540485546487118	2.5389128443829163	1.5670958725247828
dead larvae:		0.08333333333333333	0.05555555555555555	0.08333333333333333	0.05555555555555555	0.05555555555555555	0
t-test p-val			0.01931115539181824		0.026099324301616683		2.4906674642273268E-5
			expected		strange!!!		expected



								JHBP silencing has NO effect on larval mass gain when fed with induced plants!!!!

									mortality %
								dpt	egfp_NI	egfp_MeJA	alas_NI	alas_MeJA	JHBP_NI	JHBP_MeJA
								0	0	0	0	0	0	0
								4	0.05555555555555555	0.027777777777777776	0.027777777777777776	0.027777777777777776	0.027777777777777776	0
								6	0.08333333333333333	0.05555555555555555	0.08333333333333333	0.05555555555555555	0.05555555555555555	0
								8	0.1111111111111111	0.1388888888888889	0.16666666666666666	0.1388888888888889	0.05555555555555555	0.08333333333333333
								10	0.16666666666666666	0.16666666666666666	0.16666666666666666	0.2777777777777778	0.08333333333333333	0.08333333333333333
								12	0.16666666666666666	0.2222222222222222	0.2777777777777778	0.2777777777777778	0.1111111111111111	0.19444444444444445
								14	0.2222222222222222	0.2777777777777778	0.3055555555555556	0.3055555555555556	0.1388888888888889	0.3333333333333333