{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["16S rRNA compare result","LEGEND"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"16S rRNA compare result","index":0,"n_rows":19,"n_cols":61,"rows_kept":19,"flags":["formulas_cached_only"]}
["OTU no.","Read length (nt)","HOMD clone name","Reads per OTU","% of OTUs","% of OTUs Treated samples","% of OTUs Not Treated Samples","Identities (%)","Mismatch","Identities (no gaps & non-AGCTU)(%)","Mismatch (no gaps & non-AGCTU)","Score (bits)","Query End","Subject End","Azithromycin Responders (n=5)",{"$nulls":15},"Azithromycin Non-responders (n=3)",{"$nulls":9},"Placebo (n=5)",{"$nulls":19},"Sequence"]
[{"$nulls":14},"106V2","106V3","106V6","115V2","115V3","115V6","126V2","126V3","126V6","129V2","129V3","129V6","142V2","142V3","142V6",null,"110V2","110V3","110V6","122V2","122V3","122V6","151V2","151V3","151V6",null,"101V2","101V3","101V6","101V7","104V2","104V3","104V6","104V7","111V2","111V3","111V6","111V7","112V2","112V3","112V6","112V7","121V2","121V3","121V6","121V7"]
[{"$nulls":14},"NT","T","T","NT","T","T","NT","T","T","NT","T","T","NT","T","T",null,"NT","T","T","NT","T","T","NT","T","T",null,"NT","NT","NT","NT","NT","NT","NT","NT","NT","NT","NT","NT","NT","NT","NT","NT","NT","NT","NT","NT"]
[41,380,"Megasphaera micronuciformis |  HOT_122 | Clone_C3MLM013 | AY278622 | Named",2859,{"v":7.588788023570633,"d":"7.59"},{"v":7.046227902730517,"d":"7.05"},{"v":7.84390243902439,"d":"7.84"},99.7,"1/350",99.7,"1/350",544,350,350,17,20,33,84,1,1,204,107,143,{"$nulls":3},37,38,166,null,33,212,128,7,null,null,7,{"$nulls":3},54,32,58,16,2,45,24,29,9,74,207,115,34,57,9,90,213,162,294,97,"GACGAACGCTGGCGGCGTGCTTAACACATGCAAGTCGAACGAGAGCGTAGAGAAAGCTTGCTTTTTCTACAATCTAGTGGCAAACGGGTGAGTAACGCGTAAACAACCTGCCCTACGGATGGGGACAACAGCTGGAAACGGCTGCTAATACCGAATACGTTCCGAAAGTCGCATGACTGTCGGAAGAAAGGATGGCCTCTATTTATAAGCTATCGCCGGAGGAGGGGTTTGCGTCTGATTAGCTAGTTGGAGGGG"]
[99,377,"Actinomyces sp. |  HOT_170 | Clone_AP064 | AF287749 | Unnamed",157,{"v":0.41673302542867763,"d":"0.42"},{"v":1.1287243754668437,"d":"1.13"},{"v":0.08195121951219513,"d":"0.08"},98.6,"5/347",98.8,"4/346",523,347,346,null,null,2,null,13,8,null,9,10,12,57,35,1,{"$nulls":7},1,null,null,1,null,null,1,6,null,1,{"$nulls":16},"GACGAACGCTGGCGGCGTGCTTAACACATGCAAGTCGAACGGTGAAGCGCCTTCCTTTGTGGTGGGTGTGGATGAGTGGCGAACGGGTGAGTAACACGTGAGTAACCTGCCCCCTTCTTCTGGATAACCGCATGAAAGTGTGGCTAATACGGGATATTCTGTGCCTGCTGCATGGTGGGTGTGGGAAAGATTGCGCCTTTTGGGTGTTTTTGGTGGGGGATGGGCTCGCGGCCTATCAGCTTGTTGGTGGGGTGA"]
[303,366,"Prevotella melaninogenica |  HOT_469 | Clone_GI030 | AY349395 | Named",401,{"v":1.0643945426554122,"d":"1.06"},{"v":1.303012698149224,"d":"1.30"},{"v":0.9521951219512195,"d":"0.95"},98.2,"6/342",98.8,"4/340",510,341,341,4,5,7,7,null,1,7,14,8,{"$nulls":3},8,1,7,null,6,19,29,1,1,1,8,43,21,null,14,2,13,3,5,9,5,14,4,7,15,12,6,5,13,26,13,10,16,11,"GATGAACGCTAGCTACAGGCTTAACACATGCAAGTCGAGGGGGAAACGGCATTTAGTGCTTGCACTGAATGGACGTCGACCGGCGCACGGGTGAGTAACGCGTATCCAACCTACCCATTACTGTGGGATAACCTGCCGAAAGGCAGACTAATACCGCATAGTCTTCGATGACGGCATCAGATTTGAAGTAAAGATTTATCGGTAATGGATGGGGATGCGTCTGATTAGCTTGTTGGCGGGGTAACGGCCCACCAA"]
[357,364,"Streptococcus salivarius  |  HOT_755 | Strain_ATCC 13419 | M58839 | Named",205,{"v":0.5441418484896746,"d":"0.54"},{"v":0.979334384596232,"d":"0.98"},{"v":0.33951219512195124,"d":"0.34"},99.1,"3/334",99.1,"3/334",512,334,334,5,7,4,1,5,3,null,5,null,null,7,9,3,7,11,null,5,11,6,null,2,1,1,30,10,null,1,{"$nulls":4},2,null,5,null,14,4,6,1,1,5,15,4,6,3,5,"GATGAACGCTGGCGGCGTGCCTAATACATGCAAGTAGAACGCTGAAGAGAGGAGCTTGCTCTTCTTGGATGAGTTGCGAACGGGTGAGTAACGCGTAGGTAACCTGCCTTGTAGCGGGGGATAACTATTGGAAACGATAGCTAATACCGCATAACAATGGATGACACATGTCATTTATTTGAAAGGGGCAATTGCTCCACTACAAGATGGACCTGCGTTGTATTAGCTAGTAGGTGAGGTAACGGCTCACCTAGG"]
[397,365,"Prevotella veroralis |  HOT_572 | Strain_ATCC 33779 | L16473 | Named",162,{"v":0.43000477783086477,"d":"0.43"},{"v":0.2323844302431737,"d":"0.23"},{"v":0.5229268292682927,"d":"0.52"},97.7,"8/341",97.9,"7/340",503,340,341,1,1,1,1,null,1,4,2,null,2,null,null,2,1,null,null,1,2,1,5,17,null,1,2,null,null,15,7,3,3,1,null,1,{"$nulls":3},1,2,31,10,4,4,23,6,4,2,"GATGAACGCTAGCTACAGGCTTAACACATGCAAGTCGAGGGGAAACGGCGTTGAGTGCTTGCACTCTTCGGACGTCGACCGGCGCACGGGTGAGTAACGCGTATCCAACCTTCCCATAACTAAGGGATAACCTACCGAAAGGCAGACTAATACCTTATGTAATTCTTAGATGACATCAGAAGAGAATGAAAGATTTATCGGTTATGGATGGGGATGCGTCTGATTAGCTTGTTGGCGGGGTAACAGCCCACCAAG"]
[438,360,"Actinomyces sp. |  HOT_172 | Clone_CT047 | AF385504 | Unnamed",2285,{"v":6.065190847799544,"d":"6.07"},{"v":2.4151381857415553,"d":"2.42"},{"v":7.781463414634146,"d":"7.78"},97.6,"8/332",98.5,"5/329",485,330,331,48,null,88,4,{"$nulls":3},3,null,5,{"$nulls":3},2,null,null,45,112,86,2,null,null,2,{"$nulls":3},238,74,269,103,57,92,29,50,36,116,175,188,7,63,53,41,168,9,66,54,"GACGAACGCTGGCGGCGTGCTTAACACATGCAAGTCGAACGCTGAAGCCTGGCTTTTGTTGGGTGGATGAGTGGCGAACGGGTGAGTAACACGTGAGTAACCTGCCCTCTTCTTTGGGATAACGCCCGGAAACGGGTGCTAATACTGGATATTCACTTGCCTTCGCATGGGGGTGGGTGGAAAGGGTTTTTTCTGGTGGGGGATGGGCTCGCGGCCTATCAGCTTGTTGGTGGGGTGATGGCTTACCAAGGCTTT"]
[505,364,"Streptococcus salivarius  |  HOT_755 | Strain_ATCC 13419 | M58839 | Named",14804,{"v":39.29500451239581,"d":"39.30"},{"v":71.84828616482696,"d":"71.85"},{"v":23.98829268292683,"d":"23.99"},99.4,"2/334",99.4,"2/334",515,334,334,213,1060,588,880,1327,405,8,602,79,50,234,511,54,284,1222,null,153,780,244,17,86,91,37,729,415,null,39,113,88,47,25,208,106,170,5,269,1115,1071,14,20,370,522,115,249,86,103,"GACGAACGCTGGCGGCGTGCCTAATACATGCAAGTAGAACGCTGAAGAGAGGAGCTTGCTCTTCTTGGATGAGTTGCGAACGGGTGAGTAACGCGTAGGTAACCTGCCTTGTAGCGGGGGATAACTATTGGAAACGATAGCTAATACCGCATAACAATGGGTGACTCATGTCATTTATTTGAAAGGGGCAAATGCTCCACTACAAGATGGACCTGCGTTGTATTAGCTAGTAGGTGAGGTAACGGCTCACCTAGG"]
[681,353,"Leptotrichia wadei |  HOT_222 | Strain_A39FD | AF287816 | Named",12832,{"v":34.06062536497319,"d":"34.06"},{"v":10.93036766536642,"d":"10.93"},{"v":44.93658536585366,"d":"44.94"},98.1,"6/323",98.1,"6/323",484,323,323,148,2,20,26,108,6,2277,null,1082,4,4,null,832,2,10,null,6,3,45,7,6,27,275,2,null,null,64,45,446,386,1041,1583,353,1490,105,135,127,73,180,384,39,59,348,260,542,280,"GATGAACGCTGACAGAATGCTTAACACATGCAAGTCTTTGGCGAAGCTGTGCTTGCACAGCCTAGCCAAGGCGGACGGGTGAGTAACGCGTAAGGAACTTGCCCTGCAGTCAGGGATAACAGACGGAAACGACTGATAAGACCTGGTAAAGTCAGGCGGACTCATGTCCAGCCTGATGAAAAGAGATGCTGCAGGAGAGCCTTGCGTCCTATTAGCTTGTTGGTGGGGTAACGGCCCACCAAGGCGATGATAGGT"]
[703,359,"Rothia aeria |  HOT_188 | Strain_CCUG 25688 | Y13025 | Named",154,{"v":0.4087699739873653,"d":"0.41"},{"v":0.15768943480786787,"d":"0.16"},{"v":0.526829268292683,"d":"0.53"},99.7,"1/329",99.7,"1/329",511,329,329,1,null,2,4,null,null,2,6,null,47,null,2,3,1,1,null,2,null,7,2,{"$nulls":6},10,8,14,11,1,4,4,null,2,3,11,4,null,null,2,{"$nulls":5},"GACGAACGCTGGCGGCGTGCTTAACACATGCAAGTCGAACGATGAAGCGGTGCTTGCACCGTGGATTAGTGGCGAACGGGTGAGTAATACGTGAGTGACCTACCTTTGACTCTGGGATAAGCCTGGGAAACTGGGTCTAATACCGGATACGACCAATCTCTGCATGGGGTGTTGGTGGAAAGCGTTATGGAGTGGTTTTAGATGGGCTCACGGCCTATCAGCTTGTTGGTGAGGTAATGGCTTACCAAGGCGACG"]
[705,356,"Fusobacterium nucleatum ss vincentii |  HOT_200 | Clone__R002 | AF287806 | Named",705,{"v":1.871317088708393,"d":"1.87"},{"v":1.1619221512158686,"d":"1.16"},{"v":2.204878048780488,"d":"2.20"},100,"0/326",100,"0/326",510,326,326,3,null,null,1,{"$nulls":5},2,null,1,10,3,5,null,39,null,null,274,3,128,{"$nulls":4},5,3,null,null,39,21,24,7,1,2,32,6,10,37,7,2,3,13,8,16,"GATGAACGCTGACAGAATGCTTAACACATGCAAGTCTACTTGAATTTGGGTTTTTAACTTAGGTTTGGGTGGCGGACGGGTGAGTAACGCGTAAAGAACTTGCCTCACAGCTAGGGACAACATTTAGAAATGAATGCTAATACCTAATATTATGATAATAGGGCATCCTATAATTATGAAAGCTATATGCGCTGTGAGAGAGCTTTGCGTCCCATTAGCTAGTTGGAGAGGTAACGGCTCACCAAGGCGATGATG"]
[823,353,"Leptotrichia wadei |  HOT_222 | Strain_A39FD | AF287816 | Named",95,{"v":0.2521632956415565,"d":"0.25"},{"v":0.016598887874512407,"d":"0.02"},{"v":0.36292682926829267,"d":"0.36"},97.2,"9/323",97.2,"9/323",474,323,323,{"$nulls":3},1,null,null,21,null,2,{"$nulls":3},7,{"$nulls":9},4,{"$nulls":5},2,null,7,5,1,14,null,1,null,null,1,5,null,1,9,2,6,6,"GATGAACGCTAGCTACAGGCTTAACACATGCAAGTCTTTGGCGAAGCTGTGCTTGCACAGCCTAGCCAAGGCGGACGGGTGAGTAACGCGTAAGGAACTTGCCCTGCAGTCAGGGATAACAGACGGAAACGACTGATAAGACCTGGTAAAGTCAGGCGGACTCATGTCCAGCCTGATGAAAAGAGATGCTGCAGGAGAGCCTTGCGTCCTATTAGCTTGTTGGTGGGGTAACGGCCCACCAAGGCGATGATAGGT"]
[827,352,"Leptotrichia wadei |  HOT_222 | Strain_A39FD | AF287816 | Named",328,{"v":0.8706269575834793,"d":"0.87"},{"v":0.2323844302431737,"d":"0.23"},{"v":1.170731707317073,"d":"1.17"},98.8,"4/323",99.1,"3/322",489,322,323,2,null,null,7,2,null,55,null,17,{"$nulls":3},23,{"$nulls":5},2,null,null,6,6,1,{"$nulls":3},3,11,8,24,26,7,29,3,6,1,null,10,17,2,2,16,3,26,13,"GATGAACGCTGACAGAATGCTTAACACATGCAAGTCTTTGGCAAGCTGTGCTTGCACAGCCTAGCCAAGGCGGACGGGTGAGTAACGCGTAAGGAACTTGCCCTGCAGTCAGGGATAACAGACGGAAACGACTGATAAGACCTGGTAAAGTCAGGCGGACTCATGTCCAGCCTGATGAAAAGAGATGCTGCAGGAGAGCCTTGCGTCCTATTAGCTTGTTGGTGGGGTAACGGCCCACCAAGGCGATGATAGGTA"]
[854,353,"Leptotrichia sp. |  HOT_417 | Clone_C3MKM102 | AY278621 | Phylotype",2330,{"v":6.184636619419228,"d":"6.18"},{"v":2.473234293302349,"d":"2.47"},{"v":7.9297560975609755,"d":"7.93"},96.89999999999999,"10/323",96.9,"10/323",470,323,323,6,null,null,13,1,null,196,null,296,{"$nulls":3},103,{"$nulls":3},1,null,1,{"$nulls":3},54,{"$nulls":7},91,163,31,139,2,9,3,1,70,156,5,8,645,75,132,129,"GATGAACGCTGACAGAATGCTTAACACATGCAAGTCTTTGGCAAAGCTGTGCTTGCACAGTCTAGCCAAGGCGGACGGGTGAGTAACGCGTAAGGAACTTGCCCTGCAGTCAGGGATAACAGACGGAAACGACTGATAAAACCTGATAAAGTCAGACGGACTCATGTCCAGTCTGATGAAAAGAAATGCTGCAGGAGAGCCTTGCGTCCTATTAGCTTGTTGGTGGGGTAACGGCCCACCAAGGCAATGATAGGT"]
[857,353,"Leptotrichia hofstadii |  HOT_224 | Strain_FAC5 | AF287813 | Named",149,{"v":0.3954982215851781,"d":"0.40"},{"v":0.06639555149804963,"d":"0.07"},{"v":0.5502439024390244,"d":"0.55"},99.1,"3/323",99.1,"3/323",495,323,323,3,null,null,5,{"$nulls":5},41,null,null,3,null,8,null,1,{"$nulls":10},5,null,1,1,1,1,2,6,13,6,16,null,4,null,null,4,7,13,8,"GATGAACGCTGACAGAATGCTTAACACATGCAAGTCTTTGGCGAATCTGTGCTTGCACAGGCTAGCCAAGGCGGACGGGTGAGTAACGCGTAAAGAACTTGCCCTGCAGACAGGGATAACAGACGGAAACGACTGACAACACCTGATACAGTTGCCGGCACGCATGTGCCTGGCAATGAAAAGAGATGCTGCGGGAGAGCTTTGCGTCCTATTAGCTTGTTGGCGGGGTAACGGCCCACCAAGGCGATGATAGGT"]
[916,353,"Leptotrichia sp. |  HOT_225 | Strain_FEA2 | GQ422731 | Unnamed",208,{"v":0.5521048999309869,"d":"0.55"},{"v":0.008299443937256203,"d":"0.01"},{"v":0.8078048780487805,"d":"0.81"},98.1,"6/323",98.1,"6/323",484,323,323,10,null,null,16,{"$nulls":5},69,1,null,23,{"$nulls":9},3,{"$nulls":5},1,3,5,3,5,7,11,5,3,6,null,1,null,2,9,6,9,10,"GATGAACGCTGACAGAATGCTTAACACATGCAAGTCTTTGGCAAATCTGTGCTTGCACAGCCTAGCCAAGGCGGACGGGTGAGTAACGCGTAAAGAACTTGCCCTGCAGACAGGGATAACAGACGGAAACGACTGATAACACCTGATACAGTTGCCGGCACGCATGTGCCTGGCAATGAAAAGAGATGCTGCGGGAGAGCTTTGCGTCCTATTAGCTTGTTGGTGAGGTGACGGCTCACCAAGGCGATGATAGGT"]
[{"$nulls":14},461,1095,745,1050,1457,425,2774,748,1637,232,303,558,1109,339,1430,null,292,1139,549,315,116,254,398,808,446,null,441,298,905,582,1299,2162,591,1956,184,654,1700,1500,364,760,509,772,1570,808,1205,734,"Total per sample"]

{"sheet":"LEGEND","index":1,"n_rows":3,"n_cols":1,"rows_kept":3,"flags":["formulas_cached_only"]}
["NT: non-azithromycin (AZ)-treated (Visit 2), or all visits for placebo group"]
["T: AZ-treated (Visits 3 and 6)"]
["PT: post-treatment (Visit 7)"]