{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Chi-squared test","Wilcoxon signed-rank test "],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Chi-squared test","index":0,"n_rows":110,"n_cols":5,"rows_kept":110,"merged":[[1,0,1,4],[12,0,12,4],[23,0,23,4],[34,0,34,4],[45,0,45,4],[56,0,56,4],[67,0,67,4],[78,0,78,4],[89,0,89,4],[100,0,100,4]],"flags":["formulas_cached_only"]}
["Species","Pangene","p-value","Adjusted p-value","Is there significant overrepresentation of genes in either upper or lower half (i.e., non-random distribution of genes)?"]
["A. salmonicida LFI1238 "]
["Chr 1","Core",{"v":1.857e-06,"d":"0.000"},{"v":3.72e-06,"d":"0.000"},"Yes"]
[null,"Softcore",{"v":3.549e-09,"d":"0.000"},{"v":1.42e-08,"d":"0.000"},"Yes"]
[null,"Shell",{"v":8.997e-08,"d":"0.000"},{"v":2.7e-07,"d":"0.000"},"Yes"]
[null,"Cloud",{"v":0.0004686,"d":"0.000"},{"v":0.000469,"d":"0.000"},"Yes"]
[]
["Chr 2","Core",{"v":0.1647,"d":"0.165"},{"v":0.33,"d":"0.330"},"No"]
[null,"Softcore",{"v":0.005926,"d":"0.006"},{"v":0.02372,"d":"0.024"},"Yes"]
[null,"Shell",{"v":0.01946,"d":"0.019"},{"v":0.0585,"d":"0.059"},"No"]
[null,"Cloud",0.285,{"v":0.33,"d":"0.330"},"No"]
[]
["V. natriegens ATCC 14048"]
["Chr 1","Core",{"v":1.953e-06,"d":"0.000"},{"v":3.9e-06,"d":"0.000"},"Yes"]
[null,"Softcore",{"v":1.896e-08,"d":"0.000"},{"v":5.7e-08,"d":"0.000"},"Yes"]
[null,"Shell",{"v":9.766e-15,"d":"0.000"},{"v":3.908e-14,"d":"0.000"},"Yes"]
[null,"Cloud",0.109,0.109,"No"]
[]
["Chr 2","Core",{"v":0.6362,"d":"0.636"},1,"No"]
[null,"Softcore",{"v":0.1423,"d":"0.142"},{"v":0.4269,"d":"0.427"},"No"]
[null,"Shell",{"v":0.6325,"d":"0.633"},1,"No"]
[null,"Cloud",{"v":1.65e-07,"d":"0.000"},{"v":6.6e-07,"d":"0.000"},"Yes"]
[]
["G. hollisae ATCC 33564 "]
["Chr 1","Core",{"v":6.454e-10,"d":"0.000"},{"v":1.935e-09,"d":"0.000"},"Yes"]
[null,"Softcore",{"v":2.2e-16,"d":"0.000"},{"v":8.8e-16,"d":"0.000"},"Yes"]
[null,"Shell",{"v":0.4662,"d":"0.466"},0.466,"No"]
[null,"Cloud",{"v":0.002233,"d":"0.002"},{"v":0.004466,"d":"0.004"},"No"]
[]
["Chr 2","Core",{"v":0.7149,"d":"0.715"},1,"No"]
[null,"Softcore",{"v":0.0001116,"d":"0.000"},{"v":0.0004464,"d":"0.000"},"No"]
[null,"Shell",{"v":0.1515,"d":"0.152"},0.456,"No"]
[null,"Cloud",{"v":0.6538,"d":"0.654"},1,"No"]
[]
["P. damselae KC-Na-1 "]
["Chr 1","Core",{"v":2.878e-12,"d":"0.000"},{"v":5.76e-12,"d":"0.000"},"Yes"]
[null,"Softcore",{"v":2.2e-16,"d":"0.000"},{"v":8.8e-16,"d":"0.000"},"Yes"]
[null,"Shell",{"v":2.2e-16,"d":"0.000"},{"v":8.8e-16,"d":"0.000"},"Yes"]
[null,"Cloud",{"v":9.214e-07,"d":"0.000"},{"v":9.21e-07,"d":"0.000"},"Yes"]
[]
["Chr 2","Core",{"v":0.3798,"d":"0.380"},{"v":0.7596,"d":"0.760"},"No"]
[null,"Softcore",{"v":0.1422,"d":"0.142"},{"v":0.4266,"d":"0.427"},"No"]
[null,"Shell",{"v":0.5474,"d":"0.547"},{"v":0.7596,"d":"0.760"},"No"]
[null,"Cloud",{"v":0.08874,"d":"0.089"},{"v":0.35496,"d":"0.355"},"No"]
[]
["V. anguillarum NB10 "]
["Chr 1","Core",{"v":0.003827,"d":"0.004"},{"v":0.011481,"d":"0.011"},"Yes"]
[null,"Softcore",{"v":0.003837,"d":"0.004"},{"v":0.011481,"d":"0.011"},"Yes"]
[null,"Shell",{"v":0.09474,"d":"0.095"},{"v":0.09474,"d":"0.095"},"No"]
[null,"Cloud",{"v":3.4e-06,"d":"0.000"},{"v":1.36e-05,"d":"0.000"},"Yes"]
[]
["Chr 2","Core",1,1,"No"]
[null,"Softcore",{"v":0.2935,"d":"0.294"},0.587,"No"]
[null,"Shell",{"v":0.03947,"d":"0.039"},{"v":0.11841,"d":"0.118"},"No"]
[null,"Cloud",{"v":9.811e-05,"d":"0.000"},{"v":0.0003924,"d":"0.000"},"Yes"]
[]
["V. campbelli ATCC BAA-1116 "]
["Chr 1","Core",{"v":1.013e-10,"d":"0.000"},{"v":3.03e-10,"d":"0.000"},"Yes"]
[null,"Softcore",{"v":1.037e-11,"d":"0.000"},{"v":4.16e-11,"d":"0.000"},"Yes"]
[null,"Shell",{"v":6.26e-10,"d":"0.000"},{"v":6.26e-10,"d":"0.000"},"Yes"]
[null,"Cloud",{"v":2.431e-10,"d":"0.000"},{"v":4.86e-10,"d":"0.000"},"Yes"]
[]
["Chr 2","Core",{"v":0.5306,"d":"0.531"},1,"No"]
[null,"Softcore",{"v":0.0003445,"d":"0.000"},{"v":0.001378,"d":"0.001"},"Yes"]
[null,"Shell",0.156,0.468,"No"]
[null,"Cloud",1,1,"No"]
[]
["V. cholerae biovar El Tor str. N16961 "]
["Chr 1","Core",{"v":2.748e-05,"d":"0.000"},{"v":5.5e-05,"d":"0.000"},"Yes"]
[null,"Softcore",{"v":2.2e-16,"d":"0.000"},{"v":8.8e-16,"d":"0.000"},"Yes"]
[null,"Shell",{"v":4.381e-09,"d":"0.000"},{"v":1.314e-08,"d":"0.000"},"Yes"]
[null,"Cloud",{"v":0.8228,"d":"0.823"},{"v":0.8228,"d":"0.823"},"No"]
[]
["Chr 2","Core",1,1,"No"]
[null,"Softcore",{"v":0.6636,"d":"0.664"},1,"No"]
[null,"Shell",{"v":0.0166,"d":"0.017"},{"v":0.0664,"d":"0.066"},"No"]
[null,"Cloud",{"v":0.7149,"d":"0.715"},1,"No"]
[]
["V. paraheamolyticus RIMD 2210633"]
["Chr 1","Core",{"v":4.701e-05,"d":"0.000"},{"v":9.4e-05,"d":"0.000"},"Yes"]
[null,"Softcore",{"v":1.211e-06,"d":"0.000"},{"v":3.63e-06,"d":"0.000"},"Yes"]
[null,"Shell",{"v":1.943e-08,"d":"0.000"},{"v":7.76e-08,"d":"0.000"},"Yes"]
[null,"Cloud",{"v":0.04849,"d":"0.048"},{"v":0.04849,"d":"0.048"},"Yes"]
[]
["Chr 2","Core",1,1,"No"]
[null,"Softcore",0.256,1,"No"]
[null,"Shell",0.348,1,"No"]
[null,"Cloud",{"v":0.4082,"d":"0.408"},1,"No"]
[]
["V. tasmaniensis LGP32 "]
["Chr 1","Core",{"v":2.878e-12,"d":"0.000"},{"v":8.64e-12,"d":"0.000"},"Yes"]
[null,"Softcore",{"v":2.2e-16,"d":"0.000"},{"v":8.8e-16,"d":"0.000"},"Yes"]
[null,"Shell",{"v":2.255e-06,"d":"0.000"},{"v":4.14e-06,"d":"0.000"},"Yes"]
[null,"Cloud",{"v":2.071e-06,"d":"0.000"},{"v":4.14e-06,"d":"0.000"},"Yes"]
[]
["Chr 2","Core",{"v":0.3798,"d":"0.380"},{"v":0.7596,"d":"0.760"},"No"]
[null,"Softcore",{"v":0.6395,"d":"0.640"},{"v":0.7596,"d":"0.760"},"No"]
[null,"Shell",{"v":1.781e-06,"d":"0.000"},{"v":7.12e-06,"d":"0.000"},"Yes"]
[null,"Cloud",{"v":2.071e-06,"d":"0.000"},{"v":7.12e-06,"d":"0.000"},"Yes"]
[]
["V. vulnificus ATCC 27562 "]
["Chr 1","Core",{"v":3.816e-06,"d":"0.000"},{"v":7.64e-06,"d":"0.000"},"Yes"]
[null,"Softcore",{"v":9.084e-08,"d":"0.000"},{"v":3.632e-07,"d":"0.000"},"Yes"]
[null,"Shell",{"v":1.041e-06,"d":"0.000"},{"v":3.12e-06,"d":"0.000"},"Yes"]
[null,"Cloud",{"v":0.0001933,"d":"0.000"},{"v":0.0001933,"d":"0.000"},"Yes"]
[]
["Chr 2","Core",{"v":0.2404,"d":"0.240"},{"v":0.4808,"d":"0.481"},"No"]
[null,"Softcore",{"v":3.543e-06,"d":"0.000"},{"v":1.062e-05,"d":"0.000"},"Yes"]
[null,"Shell",{"v":6.222e-15,"d":"0.000"},{"v":2.488e-14,"d":"0.000"},"Yes"]
[null,"Cloud",{"v":0.2415,"d":"0.242"},{"v":0.4808,"d":"0.481"},"No"]

{"sheet":"Wilcoxon signed-rank test ","index":1,"n_rows":33,"n_cols":5,"rows_kept":33,"merged":[[12,0,12,4],[23,0,23,4]],"flags":["formulas_cached_only"]}
["Species","Pangene","p-value","Adjusted p-value","Is RPKM median on upper half significantly different than RPKM median on lower half?"]
["A. salmonicida LFI1238"]
["Chr 1","Core",{"v":0.3499,"d":"0.350"},{"v":0.7174,"d":"0.717"},"no"]
[null,"Softcore",{"v":0.002338,"d":"0.002"},{"v":0.014524,"d":"0.015"},"yes"]
[null,"Shell",{"v":2.081e-08,"d":"0.000"},{"v":1.0405e-07,"d":"0.000"},"yes"]
[null,"Cloud",{"v":5.194e-11,"d":"0.000"},{"v":2.925e-10,"d":"0.000"},"yes"]
[]
["Chr 2","Core",{"v":0.02381,"d":"0.024"},{"v":0.02381,"d":"0.024"},"yes"]
[null,"Softcore",{"v":0.0005922,"d":"0.001"},{"v":0.0023688,"d":"0.002"},"yes"]
[null,"Shell",{"v":0.005386,"d":"0.005"},{"v":0.010772,"d":"0.011"},"yes"]
[null,"Cloud",{"v":0.0009068,"d":"0.001"},{"v":0.0027204,"d":"0.003"},"yes"]
[]
["V. natriegens ATCC  14048 slow-growth"]
["Chr 1","Core",{"v":0.1603,"d":"0.160"},{"v":0.3206,"d":"0.321"},"no"]
[null,"Softcore",{"v":5.304e-07,"d":"0.000"},{"v":2.652e-06,"d":"0.000"},"yes"]
[null,"Shell",{"v":2.2e-16,"d":"0.000"},{"v":1.32e-15,"d":"0.000"},"yes"]
[null,"Cloud",{"v":0.001857,"d":"0.002"},{"v":0.005571,"d":"0.006"},"yes"]
[]
["Chr 2","Core",{"v":0.1043,"d":"0.104"},{"v":0.3129,"d":"0.313"},"no"]
[null,"Softcore",{"v":0.2432,"d":"0.243"},{"v":0.4864,"d":"0.486"},"no"]
[null,"Shell",{"v":1.668e-15,"d":"0.000"},{"v":6.672e-15,"d":"0.000"},"yes"]
[null,"Cloud",{"v":0.7632,"d":"0.763"},{"v":0.7632,"d":"0.763"},"no"]
[]
["V. natriegens ATCC  14048 fast-growth"]
["Chr 1","Core",{"v":9.752e-05,"d":"0.000"},{"v":0.00019504,"d":"0.000"},"yes"]
[null,"Softcore",{"v":1.157e-12,"d":"0.000"},{"v":5.785e-12,"d":"0.000"},"yes"]
[null,"Shell",{"v":2.2e-16,"d":"0.000"},{"v":1.32e-15,"d":"0.000"},"yes"]
[null,"Cloud",{"v":3.027e-06,"d":"0.000"},{"v":9.081e-06,"d":"0.000"},"yes"]
[]
["Chr 2","Core",{"v":0.01863,"d":"0.019"},{"v":0.07452,"d":"0.075"},"no"]
[null,"Softcore",{"v":0.9113,"d":"0.911"},{"v":0.9113,"d":"0.911"},"no"]
[null,"Shell",{"v":0.3654,"d":"0.365"},{"v":0.7308,"d":"0.731"},"no"]
[null,"Cloud",{"v":0.1695,"d":"0.170"},{"v":0.5085,"d":"0.509"},"no"]