{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["Genes and primers","RNAseq and qPCRs on same cDNA","qPCR on different cDNAs","summary"],"not_rendered":{"charts":3,"external_links":2,"defined_names":8},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Genes and primers","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"flags":["formulas_cached_only"]}
["Genes for qPCR"]
["Conting in our assembly","BLAST Description","Accession","Reported in","ID in qPCR"]
[88095,"chemosensory protein 12","ABH88185","Our work","CSP 12"]
[102208,"PREDICTED: G-protein coupled receptor Mth2-like","XP_003250433","Our work","Mth 2"]
[47160,"tyrosine aminotransferase-like","XP_001603572","Our work","TAT"]
[34202,"phosphoenolpyruvate carboxykinase, isoform B","NP_725802","Our work","PEPCK"]
[49891,"yellow-h","ABB81847","Our work","Yellow H"]
["Sg_CNS_NA4Plus202","---","---","Our work","NA202"]
[29324,"lcp9_drome ame: full=larval cuticle protein 9 ame: full=larval cuticle protein ix flags: precursor","P82384","Kang, L., et al. (2004). \"The analysis of large-scale gene expression correlated to the phase changes of the migratory locust.\" Proceedings of the National Academy of Sciences of the United States of America 101(51): 17611-17615.","LCP 9"]
[85647,"asparagine synthetase, putative","EEB18196","Kang, L., et al. (2004). \"The analysis of large-scale gene expression correlated to the phase changes of the migratory locust.\" Proceedings of the National Academy of Sciences of the United States of America 101(51): 17611-17615.","ASNS"]
["Sg_CNS_NA4Plus277","locusta migratoria heat shock protein 20.6 mRNA, complete cds","DQ355964","Guo, W., et al. (2011). \"CSP and takeout genes modulate the switch between attraction and repulsion during behavioral phase change in the migratory locust.\" PLoS Genet 7(2): e1001291.","HSP 20"]
[33921,"peptidyl-prolyl cis-trans rhodopsin-specific isozyme-like","XP_001602615","Guo, W., et al. (2011). \"CSP and takeout genes modulate the switch between attraction and repulsion during behavioral phase change in the migratory locust.\" PLoS Genet 7(2): e1001291.","PPI"]
[103230,"glia maturation factor","EEB15105","Badisco, L., et al. (2011). \"Microarray-based transcriptomic analysis of differences between long-term gregarious and solitarious desert locusts.\" PloS one 6(11): e28110.","GMF"]
[81383,"PREDICTED: similar to peroxiredoxin","XP_968419","Badisco, L., et al. (2011). \"Microarray-based transcriptomic analysis of differences between long-term gregarious and solitarious desert locusts.\" PloS one 6(11): e28110.","Peroxiredoxin"]
["Sg_CNS_NA4Plus4221","PREDICTED: Nasonia vitripennis troponin C (TpnC), mRNAasonia vitripennis troponin c mrna","XM_003424121","Kang, L., et al. (2004). \"The analysis of large-scale gene expression correlated to the phase changes of the migratory locust.\" Proceedings of the National Academy of Sciences of the United States of America 101(51): 17611-17615.","Troponin C","The qPCR did not work"]
[86113,"PREDICTED: ATP-dependent RNA helicase p62-like","XP_001604593","Guo, W., et al. (2011). \"CSP and takeout genes modulate the switch between attraction and repulsion during behavioral phase change in the migratory locust.\" PLoS Genet 7(2): e1001291.","RNA helicase","The qPCR did not work"]
[]
["qPCR primers"]
["Name","Sequence","Length","Tm","GC%"]
["CSP 12 Forward","CGCGCTACGACAACATCAAC",20,60.5,55]
["CSP 12 Reverse","TCCGCTTGTAGATGCCAGTG",20,60.11,55]
["Mth 2 Forward","GGCCGAAGAAGTAGGACCAG",20,59.82,60]
["Mth 2 Reverse","AGCTCACCAGCCACGTTATC",20,60.11,55]
["TAT Forward","CCCTACGACATTCGGCAACC",20,62.5,60]
["TAT Reverse","TCGACGCCAATAGACTCAGC",20,59.9,55]
["PEPCK Forward","ACACAAGAGGGACACCCTGAG",21,61.38,57.14]
["PEPCK Reverse","GTTGCTGCCACTAATGATGGAG",22,62.1,50]
["Yellow H Forward","ACCGGAAGTTGAACGAGTCC",20,59.97,55]
["Yellow H Reverse","CACCGCACTACGGAGGATAC",20,59.97,60]
["NA202 Forward","TTGAAGACTACGACGCCGAC",20,59.42,55]
["NA202 Reverse","CAGCAGTCACTCGTTGTGTG",20,60.11,55]
["PPI Forward","ATGTTTCTTCTGCAACTAGTGTTTC",25,60.9,36]
["PPI Reverse","TTTGTCATGGTCCTCTAGCATG",22,60.1,45]
["Peroxiredoxin Forward","CTTGACTCCTCGCTTCTGG",19,59.5,58]
["Peroxiredoxin Reverse","ATCGTACCAAACTTCACGGC",20,58.4,50]
["ASNS Forward","TCACTGCTTTGCTTGCAACTTTG",23,60.9,43]
["ASNS Reverse","ACATAGTCTGCCACACATTTGC",22,60.1,45]
["HSP 20 Forward","ACGTAGTCGACTGAGAACACC",21,61.2,52]
["HSP 20 Reverse","GTGTTGCACGAATAGCGCAG",20,60.5,55]
["GMF Forward","ACAAACCTTGGCTGATGGCT",20,60.2,50]
["GMF Reverse","GGCGCTGAAAGCATTTCGTT",20,60.3,50]
["LCP9 Forward","ACTGGCGTAGGATTGTTCCG",20,59.8,55]
["LCP9 Reverse","ACCATCAGCGTCAGGTACAC",20,60.3,55]
["RNA helicase Forward","TCATCGTCTCTTCCTGGTGC",20,59.5,55,"The qPCR did not work"]
["RNA helicase Reverse","GGAAAGACATATTCGCGGCA",20,58.7,50,"The qPCR did not work"]
["Troponin-C Forward","CCTGTTTTCAAGGCAGTTGGG",21,59.9,52.4,"The qPCR did not work"]
["Troponin-C Reverse","ACCACAGTCCTCCCAAGAGA",20,59.8,55,"The qPCR did not work"]

{"sheet":"RNAseq and qPCRs on same cDNA","index":1,"n_rows":21,"n_cols":14,"rows_kept":21,"merged":[[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,10,2,11]],"flags":["formulas_cached_only"]}
["means of the three qPCRs per gene (the cDNA was from a pool of individuals--see mean text)"]
[{"$nulls":3},"qPCR"]
["Trial",null,null,"RQ",null,"Standard Deviation",null,"RAW READS",null,null,"FPKM"]
[{"$nulls":3},"GRE","SOL","GRE","SOL","GRE","SOL","LENGTH","GRE","SOL","Increase in gregarious RNAseq","Increase in gregarious RNAseq"]
["qPCRs 1","Reference gene","Actin",1,0.7664126272957427,0.20101268236238407,0.29951342894673405]
[null,"Reference gene","Tubulin",1,1.2335873727042574,0.10257641544140919,0.9717514364870654]
[null,null,"Yellow H",1,0.00544642986859967,0.1695024785432601,0.007117861675955887,1953,47,1655,16.654603136269905,0.40080202120055586,183.60651364764746,41.5531914893617]
[null,null,"CSP 12",1,0.2375319088472509,0.2253527980104837,0.09501599169422954,5105,842,609,118.30647020468597,19.513035830038312,4.209960694767404,6.062945368171022]
[null,null,"NA202",1,0.001961527444222856,0.14558841115976467,0.0008432703512037512,14079,133,608,326.8122092482764,3.0872948242077394,509.80678498545984,105.85714285714286]
[null,null,"TAT",1,0.4525638442316001,0.12315153323995295,0.17596910949978986,2015,998,2714,10.478406688331141,5.189801426776416,2.209632989347352,2.0190380761523046]
[null,null,"PEPCK",1,0.05605006680079231,0.17820758743665502,0.05579508481269741,4168,240,1940,30.321872936195245,1.7459811671513576,17.84119193923716,17.366666666666667]
[null,null,"Mth 2",1,0.33864835728624715,0.3128518602875319,0.5720546173596412,3011,1940,3023,14.057323893108267,9.057193076263713,2.9529155493724613,1.552061855670103]
[]
["qPCRs 2","Reference gene","Actin",1,0.9250498750186629,0.28959121806336263,0.14182605636669074]
[null,"Reference gene","Tubulin",1,1.0749501249813371,0.18772647274931697,0.16157649303925115]
[null,null,"Peroxiredoxin",1,1.2462582519005587,2.101438516749417,1.235933435577506,63,51,339,2.622834540919849,1.4434938773187833,0.8024019086533534,1.8170042714636456]
[null,null,"PPI",1,0.2433216150824014,0.5985798485828763,0.12115113730387438,23,12,201,1.6149601923361023,0.5728351471010448,4.109786956910292,2.819240754532879]
[null,null,"GMF",1,0.5694349928473202,0.16623494172564574,0.27042866259510984,558,391,471,16.720271877783862,7.965266639387511,1.7561267090379271,2.0991477918772556]
[null,null,"ASNS",1,0.39619146984580245,0.1694316014845301,0.12015169717366962,3296,2494,6491,7.166475773022838,3.686627923674718,2.524032131204641,1.943910782805419]
[null,null,"HSP 20",1,0.9687992974230032,0.20011436407734978,0.16465951084612487,317,153,194,23.061501249457514,7.567181820789704,1.0322055379891277,3.047568010867596]
[null,null,"LCP 9",1,0.5991280941095201,0.1446503672865633,0.09640641944057592,86,47,408,2.974872323606337,1.1053050724394549,1.6690921521319961,2.6914490829583078]

{"sheet":"qPCR on different cDNAs","index":2,"n_rows":27,"n_cols":13,"rows_kept":27,"merged":[[1,1,1,2],[1,3,1,4]],"flags":["formulas_cached_only"]}
["Means of the 12 qpPCRs per gene"]
[null,"Q",null,"Standard Deviation"]
[null,"Solitarious","Gregarious","Solitarious","Gregarious","Increase in gregarious"]
["CSP12",0.7435003675909257,1.0419292627774037,0.4537454025218161,0.35696900501143836,1.4013836552003882]
["TAT",4.915938365138984,1.8596991084214765,0.4092847264061501,0.6920315975257098,0.3782999236950154]
["PEPCK",0.7195961914999427,1.0042874329678118,0.23119894681516429,0.106640142501559,1.3956263871748016]
["YELLOW-H (2)",0.6694335636646462,1.0240922503273076,0.11777207595604326,0.25346507254526285,1.5297892216834352]
["MTH2 (2)",1.2030320280190927,1.1748303757531777,0.2680288199430748,0.1447876306643515,0.9765578541476143]
["NA202 (2)",0.9585809456026102,1.1042914550568326,0.26417550187183597,0.5142917146698265,1.1520064738639486]
["ASNS (2)",0.9673498996247591,1.1716249506766836,0.5518834908164457,0.799368756713392,1.2111697650779352]
["PXRS (2)",1.5615427549951142,1.100955649918455,0.32169640847947056,0.5481815576762773,0.7050435515753135]
["GMF (2)",1.1100670658391503,1.144215096602965,0.6856876885099431,0.637110126848141,1.0307621330410344]
["LCP9",0.7431929426818131,1.0927277146669552,0.656021167461169,0.4834034827302164,1.4703149773245225]
["PPI",1.5327063553449618,0.68023721915734,0.6296738019676436,0.6306448120099808,0.44381444415961924]
["HSP20",0.4989647725142208,0.627203781252488,0.34991031375250803,0.16211042475526416,1.2570101454098392]
[]
[]
["Means of the three replicates per each of the eight tested locusts"]
["ID","CSP12","TAT","PEPCK","YELLOW-H","MTH2","NA202","ASNS","PXRS","GMF","LCP9","PPI","HSP20"]
["Solitarious1",1.25483702254054,4.848370667807181,"NA",0.5335702003384105,0.9292680213016746,1.1871481605688539,0.9564976527670868,1.7890164669143054,1.8483654144625221,0.3518217712220164,1.556080467782458,0.1640832638967194]
["Solitarious2","NA",4.5446420464585735,0.8176658732884692,"NA","NA","NA",1.8414386507869305,"NA",0.39949517946616114,1.6677657509402963,"NA",0.330449106504446]
["Solitarious3",0.38890777975300445,"NA",0.49070118709608795,0.7322543007713751,1.2148964334581633,1.019244378595078,0.33390277765767595,1.334069043075923,0.6718681286484669,0.21113680590651934,0.8916709575575664,0.9743418912017058]
["Solitarious4",0.5867563004792328,5.354802381151196,0.8504215141152708,0.742476189884153,1.46493162929744,0.6693502976438986,0.7375605172873434,"NA",1.5205395407794506,0.7420474426584205,2.150367640694861,0.5269848284540121]
["Gregarious1",1.5306735899561448,1.5520409970002722,0.9490679797839113,0.8548540301411232,"NA",0.49683314692996994,0.4968331469299693,0.5928887525544635,0.5145025027121999,0.5139084693068385,0.43868278571435954,0.5125744006070091]
["Gregarious2",1.0848533252098032,"NA",1.1143867425958933,1.228657948462064,1.332528755958823,1.5628362958449833,0.9122492722449956,1.3035988640211755,0.6812470582119005,1.4368571780218462,1.3959526433240528,0.7418331618979668]
["Gregarious3",0.7868533409655949,0.41203343975752105,1.0702268779126105,1.25302627454936,1.0478992383750683,0.8600545067752505,0.9466042689064682,1.780768526912224,1.6202876974005298,1.541765481768903,"NA","NA"]
["Gregarious4",0.7653367949780724,0.3023238427608944,0.883468131578832,0.7598307481566831,1.1440631329256419,1.4974418706771262,2.3308131146253013,0.7265664561859567,1.7608231280872293,0.8783797295702332,0.2060762284336079,"NA"]

{"sheet":"summary","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"flags":["formulas_cached_only"]}
["Comparaison of the RNAseq and qPCR results for each gene"]
[null,null,"Increase in gregarious locusts",null,null,"log2 of the increase in gregarious locusts"]
["Gene","RNAseq","qPCR on same cDNA","qPCR on different cDNA"]
["Yellow H",41.5531914893617,183.60651364764746,1.5297892216834352,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["CSP 12",6.062945368171022,4.209960694767404,1.4013836552003882,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["NA202",105.85714285714286,509.80678498545984,1.1520064738639486,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["TAT",2.0190380761523046,2.209632989347352,0.3782999236950154,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["PEPCK",17.366666666666667,17.84119193923716,1.3956263871748016,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["Mth 2",1.552061855670103,2.9529155493724613,0.9765578541476143,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["Peroxiredoxin",1.8170042714636456,0.8024019086533534,0.7050435515753135,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["PPI",2.819240754532879,4.109786956910292,0.44381444415961924,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["GMF",2.0991477918772556,1.7561267090379271,1.0307621330410344,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["ASNS",1.943910782805419,2.524032131204641,1.2111697650779352,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["HSP 20",3.047568010867596,1.0322055379891277,1.2570101454098392,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["LCP 9",2.6914490829583078,1.6690921521319961,1.4703149773245225,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]