metadata: contig_metadata: 61 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax

61 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Spirochaetota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
298620	298620	PRJNA1148190_P_NODE_659321_length_247_cov_1.011494_g648148_i0	PRJNA1148190	659321	247	1.011494	2.49839018	Turneriella parva	29510	Bacteria	Bacteria	359	1.1699999999999999e-94	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g648148	i0	93.061	0.991902834008097	245	17	99	0	3	247	1384173	1384417	Turneriella parva DSM 21527, complete genome	blastn	245	359	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
298696	298696	PRJNA1148190_P_NODE_666241_length_247_cov_0.885057_g655068_i0	PRJNA1148190	666241	247	0.885057	2.18609079	Leptospira sp. GIMC2001	1513297	Bacteria	Bacteria	137	5.9899999999999985e-28	NTclustered	gi\|2440388381\|gb\|CP115468.1\|	1513297	g655068	i0	81.176	0.688259109311741	170	32	69	0	3	172	3478077	3478246	Leptospira sp. GIMC2001 chromosome 1, complete sequence	blastn	170	137	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. GIMC2001
1035614	1035614	PRJNA1148190_P_NODE_544161_length_258_cov_1.405405_g532988_i0	PRJNA1148190	544161	258	1.405405	3.6259449	Leptospira	171	Bacteria	Bacteria	449	7.13e-122	NTclustered	gi\|167774246\|gb\|CP000777.1\|	355278	g532988	i0	98.062	2	258	5	100	0	1	258	3056380	3056637	Leptospira biflexa serovar Patoc strain 'Patoc 1 (Ames)' chromosome I, complete sequence	blastn	516	449	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira biflexa
1035864	1035864	PRJNA1148190_P_NODE_61381_length_729_cov_424.253049_g50380_i0	PRJNA1148190	61381	729	424.253049	3092.80472721	Borreliella	64895	Bacteria	Bacteria	54.7	0.02	NTclustered	gi\|2668341218\|gb\|CP143564.1\|	62088	g50380	i0	100	0.358024691358025	29	0	4	0	17	45	175430	175458	Borreliella valaisiana strain 100B40 chromosome, complete genome	blastn	261	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella valaisiana
1571493	1571493	PRJNA1148190_P_NODE_528602_length_261_cov_1.388298_g517429_i0	PRJNA1148190	528602	261	1.388298	3.62345778	Turneriella parva	29510	Bacteria	Bacteria	250	7.86e-62	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g517429	i0	83.908	1	261	42	100	0	1	261	4148013	4147753	Turneriella parva DSM 21527, complete genome	blastn	261	250	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
1572571	1572571	PRJNA1148190_P_NODE_611122_length_250_cov_0.870056_g599949_i0	PRJNA1148190	611122	250	0.870056	2.17514	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2907625910\|emb\|OZ223470.1\|	2791017	g599949	i0	100	0.116	29	0	12	0	60	88	2915331	2915359	MAG: Sphaerochaetaceae bacterium isolate cd985c71-0469-48ce-9ce8-6ec3774ccd9a genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
2309231	2309231	PRJNA1148190_P_NODE_141742_length_442_cov_0.834688_g130577_i0	PRJNA1148190	141742	442	0.834688	3.68932096	Pseudomonadati	3379134	Bacteria	Bacteria	431	4.7e-116	NTclustered	gi\|1914387368\|gb\|CP043893.1\|	312175	g130577	i0	85.542	77.89592760181	415	57	93	1	1	412	1874767	1874353	Leptospira interrogans serovar Bataviae strain 1489 chromosome 1, complete sequence	blastn	34430	435	0.990804597701149	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira interrogans
3585156	3585156	PRJNA1148190_P_NODE_309723_length_316_cov_0.950617_g298550_i0	PRJNA1148190	309723	316	0.950617	3.00394972	root	1	Root_unresolved	Root_unresolved	54.7	0.008	NTclustered	gi\|2355083728\|gb\|CP112976.1\|	29507	g298550	i0	100	3.12025316455696	29	0	9	0	231	259	1181734	1181762	Leptospira kirschneri strain I-7 chromosome 1, complete sequence	blastn	986	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira kirschneri
3585841	3585841	PRJNA1148190_P_NODE_488183_length_269_cov_1.234694_g477010_i0	PRJNA1148190	488183	269	1.234694	3.32132686	Pseudomonadati	3379134	Bacteria	Bacteria	67.6	8.8e-7	NTclustered	gi\|2265193197\|gb\|CP058347.1\|	158	g477010	i0	100	14.0520446096654	36	0	13	0	56	91	36621	36656	Treponema denticola strain OKA3 chromosome, complete genome	blastn	3780	67.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
4121892	4121892	PRJNA1148190_P_NODE_384504_length_289_cov_1.662037_g373331_i0	PRJNA1148190	384504	289	1.662037	4.80328693	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	69.4	2.66e-7	NTclustered	gi\|2108229087\|gb\|CP070696.1\|	1898206	g373331	i0	93.617	0.162629757785467	47	1	16	2	39	84	1175546	1175501	MAG: Spirochaetaceae bacterium isolate bin59 chromosome	blastn	47	69.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
4124349	4124349	PRJNA1148190_P_NODE_565544_length_254_cov_1.353591_g554371_i0	PRJNA1148190	565544	254	1.353591	3.43812114	Marispirochaeta aestuarii	1963862	Bacteria	Bacteria	178	3.65e-40	NTclustered	gi\|2621706252\|emb\|OY764158.1\|	1963862	g554371	i0	80.889	16.5511811023622	225	43	89	0	30	254	2339278	2339502	MAG: Marispirochaeta aestuarii isolate 3e1d039b-c9f6-42e3-8811-4df9f69fa931 genome assembly, chromosome: 1	blastn	4204	178	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Marispirochaeta	Marispirochaeta aestuarii
4125148	4125148	PRJNA1148190_P_NODE_626564_length_249_cov_0.875000_g615391_i0	PRJNA1148190	626564	249	0.875	2.17875	Turneriella parva	29510	Bacteria	Bacteria	230	9.699999999999995e-56	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g615391	i0	83.401	0.991967871485944	247	41	99	0	3	249	2604500	2604746	Turneriella parva DSM 21527, complete genome	blastn	247	230	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
4127392	4127392	PRJNA1148190_P_NODE_80984_length_607_cov_1.485019_g69859_i0	PRJNA1148190	80984	607	1.485019	9.01406533	Brachyspira hampsonii	1287055	Bacteria	Bacteria	54.7	0.017	NTclustered	gi\|1214564172\|gb\|CP019914.1\|	1287055	g69859	i0	100	0.0477759472817133	29	0	5	0	119	147	2744436	2744408	Brachyspira hampsonii strain NSH-16 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hampsonii
5396469	5396469	PRJNA1148190_P_NODE_277905_length_330_cov_0.770428_g266734_i0	PRJNA1148190	277905	330	0.770428	2.5424124	Brachyspira murdochii	84378	Bacteria	Bacteria	60.2	1.86e-4	NTclustered	gi\|296016874\|gb\|CP001959.1\|	526224	g266734	i0	92.857	0.127272727272727	42	2	13	1	9	50	1100363	1100323	Brachyspira murdochii DSM 12563, complete genome	blastn	42	60.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira murdochii
5401119	5401119	PRJNA1148190_P_NODE_610385_length_250_cov_0.870056_g599212_i0	PRJNA1148190	610385	250	0.870056	2.17514	Turneriella parva	29510	Bacteria	Bacteria	152	2.17e-32	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g599212	i0	96.703	0.64	91	3	64	0	1	91	1280273	1280363	Turneriella parva DSM 21527, complete genome	blastn	160	152	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
5401792	5401792	PRJNA1148190_P_NODE_664345_length_247_cov_0.885057_g653172_i0	PRJNA1148190	664345	247	0.885057	2.18609079	Turneriella parva	29510	Bacteria	Bacteria	279	9.41e-71	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g653172	i0	87.295	0.987854251012146	244	31	99	0	3	246	3123799	3124042	Turneriella parva DSM 21527, complete genome	blastn	244	279	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
5402125	5402125	PRJNA1148190_P_NODE_692005_length_246_cov_0.890173_g680832_i0	PRJNA1148190	692005	246	0.890173	2.18982558	Spirochaetia bacterium	2053615	Bacteria	Bacteria	135	2.14e-27	NTclustered	gi\|2621700913\|emb\|OY759747.1\|	2053615	g680832	i0	84.672	56.6463414634146	137	19	55	2	111	246	2149355	2149490	MAG: Spirochaetia bacterium isolate 029c9a96-c795-42b2-9c0d-59f5314b817a genome assembly, chromosome: 1	blastn	13935	135	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
6670009	6670009	PRJNA1148190_P_NODE_203666_length_374_cov_0.737542_g192496_i0	PRJNA1148190	203666	374	0.737542	2.75840708	Brachyspira hyodysenteriae	159	Bacteria	Bacteria	75	7.6e-9	NTclustered	gi\|2021755399\|gb\|CP046930.1\|	159	g192496	i0	92.308	1.14973262032086	52	4	14	0	61	112	1874276	1874327	Brachyspira hyodysenteriae strain BHZ375 chromosome, complete genome	blastn	430	75	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
6672886	6672886	PRJNA1148190_P_NODE_391306_length_288_cov_1.269767_g380133_i0	PRJNA1148190	391306	288	1.269767	3.65692896	Turneriella parva	29510	Bacteria	Bacteria	178	4.209999999999999e-40	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g380133	i0	95.495	9.80902777777778	111	5	40	0	1	111	3557512	3557622	Turneriella parva DSM 21527, complete genome	blastn	2825	178	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
6675925	6675925	PRJNA1148190_P_NODE_611586_length_250_cov_0.870056_g600413_i0	PRJNA1148190	611586	250	0.870056	2.17514	Turneriella parva	29510	Bacteria	Bacteria	327	3.36e-85	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g600413	i0	90.4	24.152	250	22	99	2	1	249	2749722	2749970	Turneriella parva DSM 21527, complete genome	blastn	6038	327	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
6676319	6676319	PRJNA1148190_P_NODE_642126_length_248_cov_0.880000_g630953_i0	PRJNA1148190	642126	248	0.88	2.1824	Turneriella parva	29510	Bacteria	Bacteria	228	3.469999999999999e-55	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g630953	i0	91.566	0.669354838709677	166	13	67	1	1	165	1341440	1341605	Turneriella parva DSM 21527, complete genome	blastn	166	228	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
7943995	7943995	PRJNA1148190_P_NODE_133847_length_455_cov_1.494764_g122684_i0	PRJNA1148190	133847	455	1.494764	6.8011762	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	52.8	0.044	NTclustered	gi\|2621786047\|emb\|OY782505.1\|	2791017	g122684	i0	100	0.0615384615384615	28	0	6	0	9	36	3011464	3011491	MAG: Sphaerochaetaceae bacterium isolate dbdf49c1-f841-4570-9102-cd3a9ce64f89 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
7951156	7951156	PRJNA1148190_P_NODE_617787_length_249_cov_1.676136_g606614_i0	PRJNA1148190	617787	249	1.676136	4.17357864	Treponema phagedenis	162	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1732601887\|gb\|CP042818.1\|	162	g606614	i0	96.875	1.285140562249	32	0	12	1	163	193	3264671	3264702	Treponema phagedenis strain B43.1 chromosome, complete genome	blastn	320	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema phagedenis
7951171	7951171	PRJNA1148190_P_NODE_619067_length_249_cov_1.448864_g607894_i0	PRJNA1148190	619067	249	1.448864	3.60767136	Treponema putidum	221027	Bacteria	Bacteria	163	9.980000000000001e-36	NTclustered	gi\|2277012563\|gb\|CP038802.1\|	221027	g607894	i0	78.884	2.98393574297189	251	45	99	7	1	247	902071	902317	Treponema putidum strain OMZ 847 chromosome, complete genome	blastn	743	163	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema putidum
7953267	7953267	PRJNA1148190_P_NODE_787827_length_241_cov_0.916667_g776654_i0	PRJNA1148190	787827	241	0.916667	2.20916747	Turneriella parva	29510	Bacteria	Bacteria	346	8.89e-91	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g776654	i0	92.857	1.49377593360996	238	17	99	0	1	238	1475970	1476207	Turneriella parva DSM 21527, complete genome	blastn	360	346	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
9223593	9223593	PRJNA1148190_P_NODE_427268_length_281_cov_1.192308_g416095_i0	PRJNA1148190	427268	281	1.192308	3.35038548	Turneriella parva	29510	Bacteria	Bacteria	303	6.48e-78	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g416095	i0	86.121	1	281	39	100	0	1	281	1293458	1293738	Turneriella parva DSM 21527, complete genome	blastn	281	303	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
10497008	10497008	PRJNA1148190_P_NODE_279649_length_329_cov_1.054688_g268478_i0	PRJNA1148190	279649	329	1.054688	3.46992352	Salinispira pacifica	1307761	Bacteria	Bacteria	95.3	5.07e-15	NTclustered	gi\|565679415\|gb\|CP006939.1\|	1307761	g268478	i0	86.813	21.9452887537994	91	5	26	7	127	213	3772285	3772372	Salinispira pacifica strain L21-RPul-D2, complete genome	blastn	7220	95.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Salinispira	Salinispira pacifica
10498861	10498861	PRJNA1148190_P_NODE_401709_length_286_cov_1.262911_g390536_i0	PRJNA1148190	401709	286	1.262911	3.61192546	Leptospira sp. severe_002	2838237	Bacteria	Bacteria	174	5.41e-39	NTclustered	gi\|2120242214\|gb\|CP075692.1\|	2838237	g390536	i0	79.918	0.853146853146853	244	43	84	4	3	243	139378	139138	Leptospira sp. severe_002 chromosome 1	blastn	244	174	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. severe_002
11774297	11774297	PRJNA1148190_P_NODE_432090_length_280_cov_1.212560_g420917_i0	PRJNA1148190	432090	280	1.21256	3.395168	Spirochaetia bacterium	2053615	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2891482181\|emb\|OZ219914.1\|	2053615	g420917	i0	96.774	0.110714285714286	31	1	11	0	175	205	2594477	2594507	MAG: Spirochaetia bacterium isolate 65460407-d738-4661-97af-02a88c6845d9 genome assembly, chromosome: 2	blastn	31	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
11778301	11778301	PRJNA1148190_P_NODE_747990_length_243_cov_0.905882_g736817_i0	PRJNA1148190	747990	243	0.905882	2.20129326	Spirochaetia bacterium	2053615	Bacteria	Bacteria	228	3.389999999999999e-55	NTclustered	gi\|2621700913\|emb\|OY759747.1\|	2053615	g736817	i0	84.416	106.600823045267	231	36	95	0	3	233	5592181	5592411	MAG: Spirochaetia bacterium isolate 029c9a96-c795-42b2-9c0d-59f5314b817a genome assembly, chromosome: 1	blastn	25904	228	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
11778965	11778965	PRJNA1148190_P_NODE_79990_length_612_cov_1.406308_g68865_i0	PRJNA1148190	79990	612	1.406308	8.60660496	Spirochaetia bacterium	2053615	Bacteria	Bacteria	387	1.46e-102	NTclustered	gi\|2891482181\|emb\|OZ219914.1\|	2053615	g68865	i0	78.885	17.8758169934641	592	109	95	14	1	584	4193005	4192422	MAG: Spirochaetia bacterium isolate 65460407-d738-4661-97af-02a88c6845d9 genome assembly, chromosome: 2	blastn	10940	387	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
12514979	12514979	PRJNA1148190_P_NODE_743410_length_243_cov_0.905882_g732237_i0	PRJNA1148190	743410	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	178	3.4599999999999993e-40	NTclustered	gi\|2891482181\|emb\|OZ219914.1\|	2053615	g732237	i0	83.42	90.1275720164609	193	30	79	2	7	198	1856860	1857051	MAG: Spirochaetia bacterium isolate 65460407-d738-4661-97af-02a88c6845d9 genome assembly, chromosome: 2	blastn	21901	178	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
13047427	13047427	PRJNA1148190_P_NODE_310371_length_315_cov_2.012397_g299198_i0	PRJNA1148190	310371	315	2.012397	6.33905055	Marispirochaeta aestuarii	1963862	Bacteria	Bacteria	99	3.73e-16	NTclustered	gi\|2621706252\|emb\|OY764158.1\|	1963862	g299198	i0	91.667	19.8857142857143	72	5	23	1	244	315	1417390	1417320	MAG: Marispirochaeta aestuarii isolate 3e1d039b-c9f6-42e3-8811-4df9f69fa931 genome assembly, chromosome: 1	blastn	6264	99	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Marispirochaeta	Marispirochaeta aestuarii
13050363	13050363	PRJNA1148190_P_NODE_515511_length_263_cov_2.473684_g504338_i0	PRJNA1148190	515511	263	2.473684	6.50578892	Turneriella parva	29510	Bacteria	Bacteria	248	2.8499999999999997e-61	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g504338	i0	84.375	0.973384030418251	256	37	96	1	1	253	1742814	1743069	Turneriella parva DSM 21527, complete genome	blastn	256	248	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
13051762	13051762	PRJNA1148190_P_NODE_622791_length_249_cov_0.875000_g611618_i0	PRJNA1148190	622791	249	0.875	2.17875	Turneriella parva	29510	Bacteria	Bacteria	220	5.84e-53	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g611618	i0	83.761	0.939759036144578	234	36	94	2	17	249	269324	269092	Turneriella parva DSM 21527, complete genome	blastn	234	220	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
13052260	13052260	PRJNA1148190_P_NODE_659891_length_247_cov_0.885057_g648718_i0	PRJNA1148190	659891	247	0.885057	2.18609079	Turneriella parva	29510	Bacteria	Bacteria	246	9.54e-61	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g648718	i0	84.615	1.11336032388664	247	38	100	0	1	247	633962	634208	Turneriella parva DSM 21527, complete genome	blastn	275	246	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
14325705	14325705	PRJNA1148190_P_NODE_514712_length_264_cov_1.157068_g503539_i0	PRJNA1148190	514712	264	1.157068	3.05465952	Turneriella parva	29510	Bacteria	Bacteria	187	6.34e-43	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g503539	i0	79.767	0.973484848484849	257	52	97	0	8	264	1811482	1811226	Turneriella parva DSM 21527, complete genome	blastn	257	187	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
15064023	15064023	PRJNA1148190_P_NODE_773772_length_241_cov_1.750000_g762599_i0	PRJNA1148190	773772	241	1.75	4.2175	Bacteria	2	Bacteria	Bacteria	379	8.759999999999998e-101	NTclustered	gi\|2265163189\|gb\|CP051302.1\|	158	g762599	i0	95.397	46.1410788381743	239	9	99	2	2	239	1563201	1562964	Treponema denticola strain OMZ 853 chromosome, complete genome	blastn	11120	379	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
15594917	15594917	PRJNA1148190_P_NODE_197393_length_378_cov_2.468852_g186223_i0	PRJNA1148190	197393	378	2.468852	9.33226056	Treponema sp.	166	Bacteria	Bacteria	71.3	9.94e-8	NTclustered	gi\|2189480979\|gb\|CP091737.1\|	166	g186223	i0	93.617	0.656084656084656	47	3	12	0	112	158	121370	121324	MAG: Treponema sp. isolate nC27_bin.160.fa chromosome	blastn	248	71.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
15602600	15602600	PRJNA1148190_P_NODE_754473_length_242_cov_1.609467_g743300_i0	PRJNA1148190	754473	242	1.609467	3.89491014	Spirochaetia bacterium	2053615	Bacteria	Bacteria	167	7.46e-37	NTclustered	gi\|2621717749\|emb\|OY776146.1\|	2053615	g743300	i0	85.185	1.33884297520661	162	24	67	0	16	177	1304991	1304830	MAG: Spirochaetia bacterium isolate efeffb62-48c8-43b6-be4a-4368b18f5a81 genome assembly, chromosome: 1	blastn	324	167	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
15602707	15602707	PRJNA1148190_P_NODE_763293_length_242_cov_0.911243_g752120_i0	PRJNA1148190	763293	242	0.911243	2.20520806	Turneriella parva	29510	Bacteria	Bacteria	204	5.69e-48	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g752120	i0	82.041	1.01239669421488	245	38	100	4	1	242	1313212	1313453	Turneriella parva DSM 21527, complete genome	blastn	245	204	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
16870568	16870568	PRJNA1148190_P_NODE_288194_length_325_cov_1.194444_g277023_i0	PRJNA1148190	288194	325	1.194444	3.881943	Turneriella parva	29510	Bacteria	Bacteria	254	7.799999999999999e-63	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g277023	i0	80.938	1.09846153846154	320	61	98	0	1	320	102997	103316	Turneriella parva DSM 21527, complete genome	blastn	357	254	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
16872544	16872544	PRJNA1148190_P_NODE_424374_length_281_cov_1.899038_g413201_i0	PRJNA1148190	424374	281	1.899038	5.33629678	Turneriella parva	29510	Bacteria	Bacteria	296	1.08e-75	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g413201	i0	95.676	11.6405693950178	185	7	78	1	21	205	3666812	3666995	Turneriella parva DSM 21527, complete genome	blastn	3271	296	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
16874801	16874801	PRJNA1148190_P_NODE_589874_length_251_cov_0.865169_g578701_i0	PRJNA1148190	589874	251	0.865169	2.17157419	Leptospira sp. severe_002	2838237	Bacteria	Bacteria	287	5.73e-73	NTclustered	gi\|2120242214\|gb\|CP075692.1\|	2838237	g578701	i0	87.251	98.199203187251	251	32	100	0	1	251	76522	76272	Leptospira sp. severe_002 chromosome 1	blastn	24648	287	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. severe_002
18143501	18143501	PRJNA1148190_P_NODE_181375_length_393_cov_1.093750_g170206_i0	PRJNA1148190	181375	393	1.09375	4.2984375	Turneriella parva	29510	Bacteria	Bacteria	429	1.4899999999999999e-115	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g170206	i0	86.445	25.1781170483461	391	53	99	0	1	391	2687019	2686629	Turneriella parva DSM 21527, complete genome	blastn	9895	429	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
18148092	18148092	PRJNA1148190_P_NODE_487455_length_269_cov_1.352041_g476282_i0	PRJNA1148190	487455	269	1.352041	3.63699029	Turneriella parva	29510	Bacteria	Bacteria	287	6.21e-73	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g476282	i0	86.77	0.955390334572491	257	34	96	0	5	261	4288641	4288385	Turneriella parva DSM 21527, complete genome	blastn	257	287	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
19422949	19422949	PRJNA1148190_P_NODE_518256_length_263_cov_1.373684_g507083_i0	PRJNA1148190	518256	263	1.373684	3.61278892	Turneriella parva	29510	Bacteria	Bacteria	331	2.75e-86	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g507083	i0	89.354	1	263	28	100	0	1	263	358907	358645	Turneriella parva DSM 21527, complete genome	blastn	263	331	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
19424455	19424455	PRJNA1148190_P_NODE_632056_length_249_cov_0.875000_g620883_i0	PRJNA1148190	632056	249	0.875	2.17875	Turneriella parva	29510	Bacteria	Bacteria	329	9.3e-86	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g620883	i0	91.286	0.967871485943775	241	21	97	0	1	241	49169	49409	Turneriella parva DSM 21527, complete genome	blastn	241	329	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
19425707	19425707	PRJNA1148190_P_NODE_732516_length_243_cov_2.352941_g721343_i0	PRJNA1148190	732516	243	2.352941	5.71764663	Turneriella parva	29510	Bacteria	Bacteria	209	1.23e-49	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g721343	i0	82.305	1	243	41	100	2	1	243	3370814	3370574	Turneriella parva DSM 21527, complete genome	blastn	243	209	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
19426281	19426281	PRJNA1148190_P_NODE_781816_length_241_cov_0.916667_g770643_i0	PRJNA1148190	781816	241	0.916667	2.20916747	Turneriella parva	29510	Bacteria	Bacteria	285	1.96e-72	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g770643	i0	87.967	22.1203319502075	241	29	100	0	1	241	1382648	1382888	Turneriella parva DSM 21527, complete genome	blastn	5331	285	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
20696374	20696374	PRJNA1148190_P_NODE_383357_length_289_cov_3.203704_g372184_i0	PRJNA1148190	383357	289	3.203704	9.25870456	Leptospira sp. GIMC2001	1513297	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2440388381\|gb\|CP115468.1\|	1513297	g372184	i0	100	0.0968858131487889	28	0	10	0	78	105	947555	947582	Leptospira sp. GIMC2001 chromosome 1, complete sequence	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. GIMC2001
20701161	20701161	PRJNA1148190_P_NODE_747717_length_243_cov_0.905882_g736544_i0	PRJNA1148190	747717	243	0.905882	2.20129326	Borrelia miyamotoi	47466	Bacteria	Bacteria	78.7	3.61e-10	NTclustered	gi\|2058273330\|dbj\|AP024400.1\|	47466	g736544	i0	86.957	12.6995884773663	69	9	28	0	1	69	257438	257506	Borrelia miyamotoi Y14T18 DNA, complete genome	blastn	3086	78.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia miyamotoi
21968017	21968017	PRJNA1148190_P_NODE_147678_length_433_cov_1.091667_g136512_i0	PRJNA1148190	147678	433	1.091667	4.72691811	Turneriella parva	29510	Bacteria	Bacteria	479	1.6199999999999996e-130	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g136512	i0	86.605	1	433	58	100	0	1	433	3973934	3974366	Turneriella parva DSM 21527, complete genome	blastn	433	479	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
21972085	21972085	PRJNA1148190_P_NODE_410858_length_284_cov_1.421801_g399685_i0	PRJNA1148190	410858	284	1.421801	4.03791484	Turneriella parva	29510	Bacteria	Bacteria	298	3.05e-76	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g399685	i0	86.232	0.971830985915493	276	37	97	1	8	282	799746	799471	Turneriella parva DSM 21527, complete genome	blastn	276	298	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
21974386	21974386	PRJNA1148190_P_NODE_580338_length_251_cov_1.606742_g569165_i0	PRJNA1148190	580338	251	1.606742	4.03292242	Turneriella parva	29510	Bacteria	Bacteria	255	1.62e-63	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g569165	i0	85.317	1.00398406374502	252	32	99	4	1	249	3782946	3782697	Turneriella parva DSM 21527, complete genome	blastn	252	255	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
22713311	22713311	PRJNA1148190_P_NODE_79518_length_614_cov_1.756007_g68394_i0	PRJNA1148190	79518	614	1.756007	10.78188298	Pseudomonadati	3379134	Bacteria	Bacteria	97.1	2.77e-15	NTclustered	gi\|1782081900\|gb\|CP046389.1\|	47466	g68394	i0	89.744	4.28664495114007	78	4	12	4	100	175	688490	688565	Borrelia miyamotoi strain CZ-F1E chromosome, complete genome	blastn	2632	97.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia miyamotoi
22713313	22713313	PRJNA1148190_P_NODE_795398_length_237_cov_2.250000_g784225_i0	PRJNA1148190	795398	237	2.25	5.3325	Borreliella	64895	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2668341218\|gb\|CP143564.1\|	62088	g784225	i0	100	9.72573839662447	29	0	12	0	17	45	175430	175458	Borreliella valaisiana strain 100B40 chromosome, complete genome	blastn	2305	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella valaisiana
24522328	24522328	PRJNA1148190_P_NODE_488860_length_269_cov_1.178571_g477687_i0	PRJNA1148190	488860	269	1.178571	3.17035599	Turneriella parva	29510	Bacteria	Bacteria	276	1.34e-69	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g477687	i0	85.294	1.01115241635688	272	35	100	5	1	269	923392	923661	Turneriella parva DSM 21527, complete genome	blastn	272	276	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
24522989	24522989	PRJNA1148190_P_NODE_538960_length_259_cov_1.424731_g527787_i0	PRJNA1148190	538960	259	1.424731	3.69005329	Borreliella lusitaniae	100177	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2591853082\|gb\|CP132461.1\|	100177	g527787	i0	96.97	0.382239382239382	33	1	13	0	220	252	396768	396736	Borreliella lusitaniae strain PoHL-1 chromosome, complete genome	blastn	99	56.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella lusitaniae
24524544	24524544	PRJNA1148190_P_NODE_659060_length_247_cov_1.155172_g647887_i0	PRJNA1148190	659060	247	1.155172	2.85327484	Borrelia miyamotoi	47466	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1782081900\|gb\|CP046389.1\|	47466	g647887	i0	100	0.566801619433198	28	0	11	0	109	136	572766	572793	Borrelia miyamotoi strain CZ-F1E chromosome, complete genome	blastn	140	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia miyamotoi
25261389	25261389	PRJNA1148190_P_NODE_407120_length_285_cov_1.207547_g395947_i0	PRJNA1148190	407120	285	1.207547	3.44150895	Borreliaceae	1643685	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2537412674\|gb\|CP124022.1\|	57863	g395947	i0	100	0.305263157894737	29	0	10	0	130	158	684429	684401	Borreliella turdi strain 047-3 chromosome, complete genome	blastn	87	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella turdi

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;