{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["data","meta-data"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"data","index":0,"n_rows":49,"n_cols":21,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["ID","Strain Abbreviation","sample","site","reserve","soil","clade","total.genes","ref.genes","denovo2.genes","denovo1.genes","ODni","ODty","focal","matches 16S seq","ALL1","ALL2","FOCAL1","FOCAL2","FOCAL.AVG.1","FOCAL.AVG.2"]
["L103C105A0","NM2","s_3_GGCTAC",103.0,"M","N",8.0,5174.0,4433.0,741.0,44.0,0.149908333,0.332975,true,true,0.0,1.0,0.153,0.847,0.917657143,0.082342857]
["L103C119B0","NM3","s_5_CTTGTA",103.0,"M","N",8.0,5143.0,4384.0,759.0,132.0,0.1727,0.440408333,true,true,0.0,1.0,0.043,0.957,0.870371429,0.129628571]
["L103C120A0","NM1","s_2_TTAGGC",103.0,"M","N",8.0,5123.0,4378.0,745.0,90.0,0.1339,0.305183333,true,true,0.0,1.0,0.132,0.868,0.935542857,0.064457143]
["L103C131B0","NM5","s_1_GATCAG",103.0,"M","N",8.0,5146.0,4407.0,739.0,75.0,0.169941667,0.317541667,true,true,0.0,1.0,0.048,0.952,0.899742857,0.100257143]
["L103C565B0","NM4","s_1_CGATGT",103.0,"M","N",8.0,4883.0,4192.0,691.0,33.0,0.241391667,0.325783333,true,true,0.0,1.0,0.041,0.959,0.891485714,0.108514286]
["L2C054A000","SM5","s_4_ATCACG",2.0,"M","S",8.0,4966.0,4341.0,625.0,52.0,0.395625,0.322733333,true,true,0.0,1.0,0.082,0.918,0.911057143,0.088942857]
["L2C066B000","SM4","s_3_CGATGT",2.0,"M","S",8.0,5009.0,4284.0,725.0,116.0,0.429541667,0.430908333,true,true,0.0,1.0,0.172,0.828,0.8266,0.1734]
["L2C067A000","SM3","s_2_CTTGTA",2.0,"M","S",8.0,5098.0,4337.0,761.0,72.0,0.232354167,0.273229167,true,true,0.0,1.0,0.147,0.853,0.9068,0.0932]
["L2C084A000","SM2","s_2_ACAGTG",2.0,"M","S",4.0,5165.0,4556.0,609.0,528.0,0.735666667,0.376408333,false,true,0.884,0.116,"NA","NA","NA","NA"]
["L2C085B000","SM7","s_5_TTAGGC",2.0,"M","S",8.0,5071.0,4361.0,710.0,70.0,0.3673,0.515341667,true,true,0.0,1.0,0.007,0.993,0.975685714,0.024314286]
["L2C089B000","SM1","s_1_TGACCA",2.0,"M","S",8.0,5179.0,4409.0,770.0,47.0,0.605108333,0.447383333,true,true,0.0,1.0,0.055,0.945,0.905314286,0.094685714]
["L48C026A00","SM6","s_4_TGACCA",48.0,"M","S",2.0,4501.0,3929.0,572.0,953.0,0.222775,0.37715,false,true,0.807,0.193,"NA","NA","NA","NA"]
["LNHC209A00","NH4","s_3_CTTGTA","NH","H","N",6.0,5347.0,4764.0,583.0,150.0,0.113941667,0.540208333,false,true,1.0,0.0,"NA","NA","NA","NA"]
["LNHC220B00","NH5","s_5_CGATGT","NH","H","N",8.0,5392.0,4785.0,607.0,126.0,0.257241667,0.504475,false,false,1.0,0.0,"NA","NA","NA","NA"]
["LNHC221B00","NH1","s_1_TAGCTT","NH","H","N",1.0,5640.0,4853.0,787.0,271.0,0.157008333,0.628316667,false,true,1.0,0.0,"NA","NA","NA","NA"]
["LNHC229A00","NH3","s_3_ATCACG","NH","H","N",6.0,5407.0,4763.0,644.0,164.0,0.118533333,0.591475,false,true,1.0,0.0,"NA","NA","NA","NA"]
["LNHC232B00","NH6","s_5_GATCAG","NH","H","N",1.0,5698.0,4905.0,793.0,279.0,0.131775,0.547791667,false,true,1.0,0.0,"NA","NA","NA","NA"]
["LNHC252B00","NH2","s_2_GGCTAC","NH","H","N",4.0,5129.0,4521.0,608.0,429.0,0.240016667,0.524566667,false,true,0.886,0.114,"NA","NA","NA","NA"]
["LNJC372A00","NJ10","s_5_ACTTGA","NJ","J","N",8.0,5086.0,4353.0,733.0,24.0,0.113829167,0.292620833,true,true,0.0,1.0,0.014,0.986,0.998085714,0.001914286]
["LNJC374B00","NJ4","s_2_GCCAAT","NJ","J","N",8.0,5069.0,4360.0,709.0,23.0,0.108433333,0.38995,true,true,0.0,1.0,0.028,0.972,0.998114286,0.001885714]
["LNJC380A00","NJ2","s_2_CAGATC","NJ","J","N",8.0,4752.0,4120.0,632.0,10.0,0.122330556,0.2498,true,true,0.0,1.0,0.146,0.854,0.839228571,0.160771429]
["LNJC384A00","NJ8","s_3_TGACCA","NJ","J","N",8.0,5070.0,4340.0,730.0,69.0,0.176733333,0.380475,true,true,0.0,1.0,0.763,0.237,0.071542857,0.928457143]
["LNJC386A00","NJ6","s_3_CAGATC","NJ","J","N",8.0,4843.0,4182.0,661.0,43.0,0.117175,0.268275,true,true,0.0,1.0,0.145,0.855,0.806228571,0.193771429]
["LNJC391B00","NJ3","s_2_CGATGT","NJ","J","N",8.0,5005.0,4339.0,666.0,42.0,0.115175,0.404658333,true,true,0.0,1.0,0.296,0.704,0.620342857,0.379657143]
["LNJC394B00","NJ11","s_5_TGACCA","NJ","J","N",8.0,5064.0,4380.0,684.0,50.0,0.127558333,0.490466667,true,true,0.0,1.0,0.088,0.912,0.855314286,0.144685714]
["LNJC395A00","NJ5","s_3_ACTTGA","NJ","J","N",8.0,4977.0,4312.0,665.0,77.0,0.093783333,0.300666667,true,true,0.0,1.0,0.175,0.825,0.823057143,0.176942857]
["LNJC398B00","NJ1","s_1_ACAGTG","NJ","J","N",8.0,4776.0,4152.0,624.0,36.0,0.116941667,0.328041667,true,true,0.0,1.0,0.164,0.836,0.810171429,0.189828571]
["LNJC399B00","NJ9","s_5_ACAGTG","NJ","J","N",8.0,5109.0,4365.0,744.0,35.0,0.125766667,0.429683333,true,true,0.0,1.0,0.016,0.984,0.926314286,0.073685714]
["LNJC403B00","NJ7","s_1_ATCACG","NJ","J","N",8.0,4936.0,4246.0,690.0,31.0,0.113341667,0.273075,true,true,0.0,1.0,0.088,0.912,0.856285714,0.143714286]
["LNJC405B00","NJ12","s_1_GCCAAT","NJ","J","N",8.0,5100.0,4373.0,727.0,105.0,0.122383333,0.398341667,true,true,0.0,1.0,0.02,0.98,0.887828571,0.112171429]
["LSHC412B00","SH6","s_4_CGATGT","SH","H","S",8.0,5064.0,4366.0,698.0,89.0,0.372908333,0.3347,true,true,0.0,1.0,0.162,0.838,0.889228571,0.110771429]
["LSHC414A00","SH2","s_2_ACTTGA","SH","H","S",8.0,5079.0,4371.0,708.0,79.0,0.324583333,0.291175,true,true,0.0,1.0,0.999,0.001,0.0,1.0]
["LSHC416B00","SH3","s_2_TGACCA","SH","H","S",8.0,5250.0,4451.0,799.0,17.0,0.5838,0.426183333,true,true,0.0,1.0,0.003,0.997,0.999885714,1.14286E-4]
["LSHC420B00","SH1","s_1_TTAGGC","SH","H","S",3.0,4988.0,4192.0,796.0,413.0,0.596275,0.517841667,false,true,0.857,0.143,"NA","NA","NA","NA"]
["LSHC422A00","SH10","s_1_GGCTAC","SH","H","S",8.0,5172.0,4390.0,782.0,51.0,0.3258,0.26435,true,true,0.0,1.0,0.052,0.948,0.892628571,0.107371429]
["LSHC424B00","SH8","s_5_GCCAAT","SH","H","S",8.0,5214.0,4433.0,781.0,13.0,0.55915,0.46845,true,true,0.0,1.0,0.002,0.998,0.999657143,3.42857E-4]
["LSHC426A00","SH5","s_3_GATCAG","SH","H","S",8.0,5127.0,4411.0,716.0,11.0,0.455233333,0.395475,true,true,0.0,1.0,0.003,0.997,0.999771429,2.28571E-4]
["LSHC432A00","SH9","s_5_TAGCTT","SH","H","S",8.0,4806.0,4184.0,622.0,9.0,0.3542,0.282483333,true,true,0.0,1.0,0.999,0.001,0.0,1.0]
["LSHC440A00","SH4","s_3_ACAGTG","SH","H","S",8.0,5138.0,4361.0,777.0,17.0,0.274891667,0.25325,true,true,0.0,1.0,0.999,0.001,0.0,1.0]
["LSHC440B00","SH7","s_1_CAGATC","SH","H","S",8.0,5143.0,4380.0,763.0,18.0,0.337166667,0.271033333,true,true,0.0,1.0,0.999,0.001,0.0,1.0]
["LSJC255A00","SJ3","s_3_GCCAAT","SJ","J","S",8.0,5139.0,4363.0,776.0,81.0,0.358433333,0.298066667,true,true,0.0,1.0,0.999,0.001,0.0,1.0]
["LSJC264A00","SJ4","s_3_TAGCTT","SJ","J","S",8.0,4999.0,4270.0,729.0,88.0,0.377941667,0.225091667,true,true,0.0,1.0,0.099,0.901,0.898885714,0.101114286]
["LSJC265A00","SJ8","s_1_CTTGTA","SJ","J","S",8.0,5241.0,4403.0,838.0,61.0,0.57345,0.476733333,true,true,0.0,1.0,0.021,0.979,0.939542857,0.060457143]
["LSJC268A00","SJ1","s_2_GATCAG","SJ","J","S",8.0,5080.0,4386.0,694.0,64.0,0.567033333,0.463591667,true,true,0.0,1.0,0.016,0.984,0.978057143,0.021942857]
["LSJC269B00","SJ6","s_5_CAGATC","SJ","J","S",8.0,5110.0,4357.0,753.0,49.0,0.452941667,0.349391667,true,true,0.0,1.0,0.105,0.895,0.8912,0.1088]
["LSJC277A00","SJ2","s_1_ACTTGA","SJ","J","S",8.0,5085.0,4344.0,741.0,71.0,0.389736111,0.458888889,true,true,0.0,1.0,0.046,0.954,0.907885714,0.092114286]
["LSJC280B00","SJ5","s_3_TTAGGC","SJ","J","S",7.0,5037.0,4240.0,797.0,453.0,0.6191,0.371333333,false,true,0.857,0.143,"NA","NA","NA","NA"]
["LSJC285A00","SJ7","s_5_GGCTAC","SJ","J","S",8.0,5217.0,4408.0,809.0,75.0,0.34635,0.290566667,true,true,0.0,1.0,0.103,0.897,0.917428571,0.082571429]

{"sheet":"meta-data","index":1,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Column","Explanation"]
["ID","Strain identifier in Genbank and Porter & Rice (2013)"]
["sample","Illumina sequencing reference"]
["Strain Abbreviation","Abbreviation displayed on Figures 1, 3 and 6. "]
["site","collection site (reserve and soil)"]
["reserve","reserve that strain was collected from"]
["soil","soil type (serpentine vs non-serpentine) that strain was collected from"]
["clade","which phylogenetic clade the strain belongs to"]
["total.genes","the number of genes identified in the strain, excluding singleton genes (since we have low confidence in them)"]
["ref.genes","number of genes in the strain that have a homolg in M. loti"]
["denovo2.genes","number of genes in the strain without a homolog in M. loti but with a homolog in at least one other wild strain"]
["denovo1.genes","number of genes in the strain without a homolog in M. loti with no homologs in other wild strains"]
["ODni","optical density in TY with 1 mM nickel"]
["ODty","optical density in TY with no nickel"]
["focal","whether the strain is in the focal clade"]
["matches 16S seq","whether the strain's draft genome 16S matches its Sanger 16S sequence"]
["ALL1","STRUCTURE assignment to group 1 for the strain in the set of 48 wild strains"]
["ALL2","STRUCTURE assignment  to group 2 for the strain in the set of 48 wild strains"]
["FOCAL1","STRUCTURE assignment to group 1 for the strain in the set of 38 wild strains for one run"]
["FOCAL2","STRUCTURE assignment to group 2 for the strain in the set of 38 wild strains for one run"]
["FOCAL.AVG.1","STRUCTURE assignment to group 1 for the strain in the set of 38 wild strains averaged across 10 runs with independently sampled loci"]
["FOCAL.AVG.2","STRUCTURE assignment to group 2 for the strain in the set of 38 wild strains averaged across 10 runs with independently sampled loci"]