{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Libraries","metrics","graphs"],"not_rendered":{"charts":3,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Libraries","index":0,"n_rows":15,"n_cols":19,"rows_kept":15}
[null,"Type","MaSurCa_prefix","insert size"," +/-","SRA_name","colony","sampling location","tissue","sequencer","technology","date","read_length","reads_1(or2)","total_bases","coverage"]
[null,"PE","p4",190,40,"Crub130114_kaust_PE1_1/2","CR130114","Banuyls_sur_mer","colony-wide","KAUST","HiSeq","Apr2015",101,{"v":95138707,"d":"9.51E+07"},{"$f":"N2*M2*2","v":{"v":19218018814,"d":"1.92E+10"}},{"$f":"O2/$S$11","v":{"v":29.32739968904899,"d":"29.3"}}]
[null,"PE","p1",400,100,"Crub130114_EMBL_PE2_1/2","CR130114","Banuyls_sur_mer","colony-wide","EMBL","HiSeq","July2013",101,{"v":27478793,"d":"2.75E+07"},{"v":5550716186,"d":"5.55E+09"},{"$f":"O3/$S$11","v":{"v":8.470595940342573,"d":"8.5"}}]
[null,"PE","p2",280,50,"Crub130114_EMBL_PE1_1/2","CR130114","Banuyls_sur_mer","colony-wide","EMBL","HiSeq","Fev2013",104,{"v":141868055,"d":"1.42E+08"},{"v":29508555440,"d":"2.95E+10"},{"v":45.03113499945712,"d":"45.0"}]
[null,"PE","p3",280,50,"Crub130114_EMBL_PE3_1/2","CR130114","Banuyls_sur_mer","colony-wide","EMBL","HiSeq","May2014",101,{"v":148167711,"d":"1.48E+08"},{"v":29929877622,"d":"2.99E+10"},{"v":45.67408806079843,"d":"45.7"}]
[null,"PE","m1",380,90,"Crub130114_EMBL_miseq1_1/2","CR130114","Banuyls_sur_mer","colony-wide","EMBL","miSeq","Apr2013",251,{"v":5798437,"d":"5.80E+06"},{"v":2910815374,"d":"2.91E+09"},{"v":4.442010735890135,"d":"4.4"}]
[null,"PE","m2",380,90,"Crub130114_EMBL_miseq2_1/2","CR130114","Banuyls_sur_mer","colony-wide","EMBL","miSeq","May2013",251,{"v":6626822,"d":"6.63E+06"},{"v":3326664644,"d":"3.33E+09"},{"v":5.076611933324953,"d":"5.1"}]
[null,"PE","m3",400,100,"Crub130114_EMBL_miseq3_1/2","CR130114","Banuyls_sur_mer","colony-wide","EMBL","miSeq","July2013",301,{"v":4682762,"d":"4.68E+06"},{"v":2819022724,"d":"2.82E+09"},{"v":4.3019317942925825,"d":"4.3"}]
[null,"JUMP","j5",4400,650,"Crub130114_EMBL_MP3_1/2","CR130114","Banuyls_sur_mer","colony-wide","EMBL","MP_nextera"," Aug2014",101,{"v":21919527,"d":"2.19E+07"},{"v":4427744454,"d":"4.43E+09"},{"v":6.756899999953761,"d":"6.8"}]
[null,"JUMP","j4",3600,600,"Crub130114_kaustMPr4_1/2","CR130114","Banuyls_sur_mer","colony-wide","KAUST","MP_nextera","Apr2015",101,{"v":49511831,"d":"4.95E+07"},{"v":10001389862,"d":"1.00E+10"},{"v":15.262486771799894,"d":"15.3"},null,"total base",{"$f":"SUM(O2:O14)","v":{"v":151974442220,"d":"1.52E+11"}}]
[null,"JUMP","j3",6000,900,"Crub130114_kaustMPr3_1/2","CR130114","Banuyls_sur_mer","colony-wide","KAUST","MP_nextera","Apr2015",101,{"v":45285965,"d":"4.53E+07"},{"v":9147764930,"d":"9.15E+09"},{"v":13.959823900689372,"d":"14.0"},null,"CSM_Crub_V152",{"v":655292287,"d":"6.55E+08"}]
[null,"JUMP","j2",8500,1200,"Crub130114_kaustMPr2_1/2","CR130114","Banuyls_sur_mer","colony-wide","KAUST","MP_nextera","Apr2015",101,{"v":52282693,"d":"5.23E+07"},{"v":10561103986,"d":"1.06E+10"},{"v":16.116630998893477,"d":"16.1"},null,"coverage",{"$f":"S10/S11","v":{"v":231.91855792436635,"d":"232"}}]
[null,"JUMP","j1",11000,2000,"Crub130114_kaustMPr1_1/2","CR130114","Banuyls_sur_mer","colony-wide","KAUST","MP_nextera","Apr2015",101,{"v":38456260,"d":"3.85E+07"},{"v":7768164520,"d":"7.77E+09"},{"v":11.854503210412425,"d":"11.9"}]
[null,"PacBio",{"$nulls":3},"Crub130114_Kaust_PacBio_min1500","CR130114","Banuyls_sur_mer","colony-wide","KAUST","PacBioRS II/P6_C4","  June2016","1500-70000",{"v":1828519,"d":"1.83E+06"},{"v":16804603664,"d":"1.68E+10"},{"v":25.64443988946264,"d":"25.6"}]
[{"$nulls":14},{"$f":"SUM(O2:O14)","v":{"v":151974442220,"d":"1.52E+11"}},{"$f":"SUM(P2:P14)","v":{"v":231.91855792436635,"d":"231.9"}}]

{"sheet":"metrics","index":1,"n_rows":61,"n_cols":33,"rows_kept":61,"merged":[[0,1,0,2],[0,4,0,5],[0,7,0,8],[0,10,0,11],[0,13,0,14],[0,16,0,17],[0,19,0,20],[0,22,0,23],[0,25,0,26],[0,28,0,29],[0,31,0,32]]}
[null,"MasurCa_V151 (Illumina only)",null,null,"Canu16 (PacBio) ",null,null,"1_Masurca_hybrid_V152 (illumina+PacBio)",null,null,"2_V152-LRNA_scaffolder",null,null,"3_V152-Rascaf",null,null,"4_V152-Sspace",null,null,"5_Metassembler_V151-152",null,null,"6_Metassembler_Canu16-V151-152",null,null,"7_V152s-Pillon",null,null,"8_V152s-GapCloser",null,null,"9_Final-Pillon = Crub Genome(V152)"]
["Scaffold distribution"]
[]
["number contigs (>=500)",185364,null,null,13329,null,null,9326,null,null,8921,null,null,7912,null,null,5591,null,null,4127,null,null,2910,null,null,2910,null,null,2910,null,null,2910]
["number contigs (>=1000)",61815,null,null,13329,null,null,9318,null,null,8913,null,null,7901,null,null,5584,null,null,4122,null,null,2910,null,null,2910,null,null,2910,null,null,2910]
["number contigs (>=5000)",41733,null,null,12994,null,null,7366,null,null,6981,null,null,6043,null,null,4353,null,null,3863,null,null,2896,null,null,2896,null,null,2896,null,null,2896]
["number contigs (>=10000)",33133,null,null,11968,null,null,6394,null,null,6031,null,null,5109,null,null,3854,null,null,3603,null,null,2858,null,null,2858,null,null,2858,null,null,2858]
["number contigs (>=50000)",358,null,null,1636,null,null,3608,null,null,3369,null,null,2724,null,null,2413,null,null,2408,null,null,2282,null,null,2284,null,null,2284,null,null,2284]
["number contigs (>=100000)",25,null,null,283,null,null,2217,null,null,2142,null,null,1789,null,null,1711,null,null,1709,null,null,1695,null,null,1694,null,null,1696,null,null,1695]
["number contigs (>=500000)",0,null,null,1,null,null,117,null,null,139,null,null,268,null,null,342,null,null,342,null,null,344,null,null,345,null,null,346,null,null,345]
["number contigs (>=1000000)",0,null,null,0,null,null,4,null,null,9,null,null,46,null,null,66,null,null,66,null,null,66,null,null,66,null,null,66,null,null,66]
[]
["===================="]
["Scaffolds ","withGaps","withoutGaps",null," withGaps "," withoutGaps",null," withGaps "," withoutGaps",null," withGaps "," withoutGaps",null," withGaps "," withoutGaps",null," withGaps "," withoutGaps",null," withGaps "," withoutGaps",null," withGaps "," withoutGaps",null," withGaps "," withoutGaps",null," withGaps "," withoutGaps",null," withGaps "," withoutGaps"]
["===================="]
["#Seqs  ",185364,null,null,13329,null,null,{"v":9326,"d":"9,326"},null,null,8921,null,null,7912,null,null,5591,null,null,4127,null,null,2910,null,null,2910,null,null,2910,null,null,2910]
["Min    ",500,439,null,1003,1003,null,666,666,null,666,666,null,518,518,null,518,518,null,518,518,null,1107,1107,null,1102,1102,null,1102,1102,null,1102,1102]
["1st Qu.",596,596,null,13427,13427,null,{"v":6662,"d":"6,662"},{"v":6649,"d":"6,649"},null,6288,6274,null,5475,5468,null,6364,6292,null,21944,21408,null,57659,56744,null,57864,56503,null,57925,56959,null,57859,56943]
["Median ",759,758,null,20506,20506,null,{"v":27201,"d":"27,201"},{"v":26687,"d":"26,687"},null,24990,24605,null,19996,19721,null,33184,31773,null,71129,69032,null,130686,127637,null,131975,128069,null,132121,129940,null,131758,129916]
["Mean   ",4947,2994,null,28054,28054,null,{"v":73520,"d":"73,520"},{"v":72480,"d":"72,480"},null,76863,75770,null,86516,85436,null,122813,120903,null,164388,161806,null,224995,221691,null,225235,221967,null,225417,223269,null,225186,223046]
["3rd Qu.",1437,1286,null,33663,33663,null,{"v":94648,"d":"94,648"},{"v":92685,"d":"92,685"},null,94969,92811,null,85947,84482,null,139050,136307,null,199384,194777,null,288670,285264,null,288773,284960,null,288780,285914,null,288395,285198]
["Max    ",266240,225106,null,564541,564541,null,{"v":1398118,"d":"1,398,118"},{"v":1397140,"d":"1,397,140"},null,1398118,1397140,null,2896117,2869046,null,3638373,3613253,null,3634678,3613985,null,3639898,3619588,null,3638516,3618527,null,3641674,3627731,null,3638999,3625056]
["Total  ",917076888,555067588,null,373939768,373939768,null,{"v":685655901,"d":"685,655,901"},{"v":675952301,"d":"675,952,301"},null,685697746,675952301,null,684516179,675974794,null,686652264,675974240,null,678433144,667777423,null,654737759,645123308,null,655434967,645925668,null,655963883,649714261,null,655292287,649066396]
["n50    ",21384,13859,null,35852,35852,null,{"v":188714,"d":"188,714"},{"v":187018,"d":"187,018"},null,215138,212923,null,311590,308629,null,392659,391128,null,401311,396244,null,421147,417327,null,421858,417795,null,421861,417688,null,421555,417651]
["n90    ",1147,753,null,14069,14069,null,{"v":42464,"d":"42,464"},{"v":41400,"d":"41,400"},null,44964,43914,null,50187,48989,null,76746,74661,null,83100,81649,null,104028,103074,null,104847,103909,null,104936,104008,null,104816,104096]
["n95    ",696,607,null,11511,11511,null,{"v":22612,"d":"22,612"},{"v":21851,"d":"21,851"},null,23162,22580,null,24389,24024,null,41088,40578,null,49540,48713,null,69430,68125,null,69454,68514,null,69456,68998,null,69334,68911]
[]
["===================="]
["Contigs ","withNs","withoutNs",null," withNs "," withoutNs",null," withNs "," withoutNs",null," withNs "," withoutNs",null," withNs "," withoutNs",null," withNs "," withoutNs",null," withNs "," withoutNs",null," withNs "," withoutNs",null," withNs "," withoutNs",null," withNs "," withoutNs",null," withNs "," withoutNs"]
["===================="]
["#Seqs  ",296721,null,null,13329,null,null,{"v":14218,"d":"14,218"},null,null,14218,null,null,12617,null,null,12140,null,null,10720,null,null,9104,null,null,8943,null,null,6571,null,null,6545]
["Min    ",64,64,null,1003,1003,null,64,64,null,64,64,null,64,64,null,64,64,null,64,64,null,64,64,null,50,50,null,69,69,null,55,55]
["1st Qu.",614,614,null,13427,13427,null,{"v":5913,"d":"5,913"},{"v":5913,"d":"5,913"},null,5913,5913,null,5211,5211,null,5258,5258,null,8432,8432,null,10898,10898,null,11284,11279,null,16875,16873,null,17024,17024]
["Median ",860,860,null,20506,20506,null,{"v":20222,"d":"20,222"},{"v":20222,"d":"20,222"},null,20222,20222,null,18748,18748,null,19739,19739,null,26243,26243,null,33827,33827,null,34493,34493,null,49062,49061,null,49238,49235]
["Mean   ",1870,1867,null,28054,28054,null,{"v":47542,"d":"47,542"},{"v":47538,"d":"47,538"},null,47542,47538,null,53576,53574,null,55681,55679,null,62292,62290,null,70861,70858,null,72226,72205,null,98876,98873,null,99169,99167]
["3rd Qu.",1756,1754,null,33663,33663,null,{"v":57060,"d":"57,060"},{"v":57060,"d":"57,060"},null,57060,57060,null,58824,58812,null,61509,61493,null,71423,71423,null,86326,86326,null,87957,87917,null,123719,123716,null,124251,124251]
["Max    ",138436,138436,null,564541,564541,null,{"v":1054964,"d":"1,054,964"},{"v":1054904,"d":"1,054,904"},null,1054964,1054904,null,1089105,1089054,null,1089105,1089054,null,1089105,1089054,null,1089105,1089054,null,1092046,1091705,null,1467381,1467350,null,1465330,1465299]
["Total  ",555067588,554025716,null,373939768,373939768,null,{"v":675952301,"d":"675,952,301"},{"v":675901695,"d":"675,901,695"},null,675952301,675901695,null,675974794,675948019,null,675974240,675946644,null,667777423,667749003,null,645123308,645096017,null,645925668,645729366,null,649714261,649695500,null,649066396,649048687]
["n50    ",3603,3590,null,35852,35852,null,{"v":114393,"d":"114,393"},{"v":114393,"d":"114,393"},null,114393,114393,null,150922,150922,null,154294,154277,null,154140,154135,null,159155,159138,null,161409,161332,null,216293,216293,null,216279,216277]
["n90    ",680,680,null,14069,14069,null,{"v":24799,"d":"24,799"},{"v":24799,"d":"24,799"},null,24799,24799,null,27829,27829,null,29284,29284,null,31713,31713,null,36610,36610,null,36999,37001,null,50022,50020,null,50075,50073]
["n95    ",575,574,null,11511,11511,null,{"v":14928,"d":"14,928"},{"v":14928,"d":"14,928"},null,14928,14928,null,15956,15956,null,16914,16912,null,19059,19058,null,23047,23047,null,23468,23457,null,31904,31904,null,31967,31967]
[]
["===================="]
["Gaps"]
["===================="]
["#Seqs  ",111357,{"$nulls":5},{"v":4892,"d":"4,892"},null,null,5297,null,null,4705,null,null,6549,null,null,6593,null,null,6194,null,null,6033,null,null,3661,null,null,3635]
["Min    ",25,{"$nulls":5},25,null,null,25,null,null,26,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25]
["1st Qu.",1150,{"$nulls":5},535,null,null,381,null,null,367,null,null,407,null,null,399,null,null,333,null,null,356,null,null,449,null,null,454]
["Median ",2752,{"$nulls":5},{"v":1334,"d":"1,334"},null,null,1178,null,null,1150,null,null,1071,null,null,1060,null,null,987,null,null,1017,null,null,1128,null,null,1135]
["Mean   ",3250,{"$nulls":5},{"v":1983,"d":"1,983"},null,null,1839,null,null,1815,null,null,1630,null,null,1616,null,null,1552,null,null,1576,null,null,1707,null,null,1712]
["3rd Qu.",4981,{"$nulls":5},{"v":2847,"d":"2,847"},null,null,2671,null,null,2626,null,null,2241,null,null,2219,null,null,2143,null,null,2172,null,null,2308,null,null,2315]
["Max    ",9999,{"$nulls":5},{"v":9914,"d":"9,914"},null,null,9914,null,null,9914,null,null,9914,null,null,9914,null,null,9914,null,null,9914,null,null,9530,null,null,9530]
["Total  ",362009300,{"$f":"(B53+B59)/B23","v":{"v":0.3958786626841696,"d":"39.59%"}},null,0,"na",null,{"v":9703600,"d":"9,703,600"},{"$f":"(H53+H59)/H23","v":{"v":0.014226095021969335,"d":"1.42%"}},null,9745445,{"$f":"(K53+K59)/K23","v":{"v":0.014286252298691383,"d":"1.43%"}},null,8541385,{"$f":"(N53+N59)/N23","v":{"v":0.012517103704571458,"d":"1.25%"}},null,10678024,{"$f":"(Q53+Q59)/Q23","v":{"v":0.01559103575605483,"d":"1.56%"}},null,10655721,{"$f":"(T53+T59)/T23","v":{"v":0.015748259197666793,"d":"1.57%"}},null,9614451,{"$f":"(W53+W59)/W23","v":{"v":0.014726112657266189,"d":"1.47%"}},null,9509299,{"$f":"(Z53+Z59)/Z23","v":{"v":0.014807877956868297,"d":"1.48%"}},null,6249622,{"$f":"(AC53+AC59)/AC23","v":{"v":9.555988008565405E-3,"d":"0.96%"}},null,6225891,{"$f":"(AF53+AF59)/AF23","v":{"v":0.009527961985610858,"d":"0.95%"}}]
["n50    ",5054,{"$nulls":5},{"v":3504,"d":"3,504"},null,null,3499,null,null,3490,null,null,2886,null,null,2864,null,null,2851,null,null,2856,null,null,2953,null,null,2967]
["n90    ",1862,{"$nulls":5},{"v":1063,"d":"1,063"},null,null,1038,null,null,1020,null,null,886,null,null,881,null,null,867,null,null,870,null,null,909,null,null,910]
["n95    ",1260,{"$nulls":5},697,null,null,660,null,null,650,null,null,590,null,null,585,null,null,575,null,null,580,null,null,607,null,null,610]
[]
["===================="]
["Non-gapped Ns Count:  ",1041872,null,null,0,null,null,50606,null,null,50606,null,null,26775,null,null,27596,null,null,28420,null,null,27291,null,null,196302,null,null,18761,null,null,17709]
[]
["===================="]

{"sheet":"graphs","index":2,"n_rows":59,"n_cols":31,"rows_kept":59,"merged":[[0,2,0,4],[0,5,0,7],[0,8,0,9],[0,10,0,12],[0,20,0,22],[0,23,0,25],[0,26,0,27],[0,28,0,30],[43,2,43,12]]}
[null,null,"assembling",null,null,"scaffolding",null,null,"metassembling",null,"polishing",{"$nulls":9},"assembling",null,null,"scaffolding",null,null,"metassembling",null,"polishing"]
["Scaffold distribution",null,"V151","Canu16","1_v152",2,3,4,5,6,7,8,9,{"$nulls":7},"V151","Canu16","1_v152",2,3,4,5,6,7,8,9]
[null,">=500",185364,13329,9326,8921,7912,5591,4127,2910,2910,2910,2910,{"$nulls":5},"Scaffolds","Scaff_n50",21384,35852,{"v":188714,"d":"188,714"},215138,311590,392659,401311,421147,421858,421861,421555]
[null,">=1000",61815,13329,9318,8913,7901,5584,4122,2910,2910,2910,2910,{"$nulls":6},"Scaff_n90",1147,14069,{"v":42464,"d":"42,464"},44964,50187,76746,83100,104028,104847,104936,104816]
[null,">=5000",41733,12994,7366,6981,6043,4353,3863,2896,2896,2896,2896]
[null,">=10000",33133,11968,6394,6031,5109,3854,3603,2858,2858,2858,2858,{"$nulls":5},"contigs","Contig_n50    ",3603,35852,{"v":114393,"d":"114,393"},114393,150922,154294,154140,159155,161409,216293,216279]
[null,">=50000",358,1636,3608,3369,2724,2413,2408,2282,2284,2284,2284,{"$nulls":6},"Contig_n90",680,14069,{"v":24799,"d":"24,799"},24799,27829,29284,31713,36610,36999,50022,50075]
[null,">=100000",25,283,2217,2142,1789,1711,1709,1695,1694,1696,1695]
[null,">=500000",0,1,117,139,268,342,342,344,345,346,345,{"$nulls":6},"#sequences",null,13329,9364,8921,7912,5591,4127,2910,2910,2910,2910]
[null,">=1000000",0,0,4,9,46,66,66,66,66,66,66]
{"$rows_empty":33}
[null,null,"assembly step"]
[null,null,"V151","Canu16","1_v152",2,3,4,5,6,7,8,9]
[1,">=1000000",{"$f":"C10","v":0},0,4,{"$f":"F10","v":9},46,66,66,66,66,66,66]
[2,">=500000",{"$f":"C9-C10","v":0},1,113,{"$f":"F9-F10","v":130},222,276,276,278,279,280,279]
[3,">=100000",{"$f":"C8-C9","v":25},282,2100,{"$f":"F8-F9","v":2003},1521,1369,1367,1351,1349,1350,1350]
[4,">=50000",{"$f":"C7-C8","v":333},1353,1391,{"$f":"F7-F8","v":1227},935,702,699,587,590,588,589]
[5,">=10000",{"$f":"C6-C7","v":32775},10332,2786,{"$f":"F6-F7","v":2662},2385,1441,1195,576,574,574,574]
[6,">=5000",{"$f":"C5-C6","v":8600},1026,972,{"$f":"F5-F6","v":950},934,499,260,38,38,38,38]
[7,">=1000",{"$f":"C4-C5","v":20082},335,1952,{"$f":"F4-F5","v":1932},1858,1231,259,14,14,14,14]
[8,">=500",{"$f":"C3-C4","v":123549},0,8,{"$f":"F3-F4","v":8},11,7,5,0,0,0,0]
[null,"Total",{"$f":"SUM(C46:C53)","v":185364},{"$f":"SUM(D46:D53)","v":13329},{"$f":"SUM(E46:E53)","v":9326},8921,7912,5591,4127,2910,2910,2910,2910]
[null,"% Ns",{"v":0.37599519346095706,"d":"37.60%"},{"v":0,"d":"0%"},{"v":0.015620550742282597,"d":"1.56%"},{"v":0.014286252298691383,"d":"1.43%"},{"v":0.012517103704571458,"d":"1.25%"},{"v":0.01559103575605483,"d":"1.56%"},{"v":0.015748259197666793,"d":"1.57%"},{"v":0.014726112657266189,"d":"1.47%"},{"v":0.014807877956868297,"d":"1.48%"},{"v":9.555988008565405E-3,"d":"0.96%"},{"v":0.009527961985610858,"d":"0.95%"}]
[]
[]
[null,null,"V151","v152"]
[null,"% Ns",{"v":0.3958786626841696,"d":"39.6%"},{"v":0.014226095021969335,"d":"1.4%"}]