metadata: contig_metadata: 57 rows where bioproject = "PRJNA737474", tax_kingdom = "Pseudomonadati" and tax

57 rows where bioproject = "PRJNA737474", tax_kingdom = "Pseudomonadati" 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
25631102	25631102	PRJNA737474g_S_NODE_336145_length_249_cov_1.113636_g334851_i0	PRJNA737474	336145	249	1.113636	2.77295364	Bacteria	2	Bacteria	Bacteria	62.1	3.74e-5	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g334851	i0	100	0.397590361445783	33	0	13	0	30	62	868464	868496	Borreliella garinii strain 17-54Z3 chromosome	blastn	99	62.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
25712055	25712055	PRJNA737474e_S_NODE_4306_length_511_cov_1.694064_g3430_i0	PRJNA737474	4306	511	1.694064	8.65666704	Leptospira sp. severe_	178	Bacteria	Bacteria	444	7.06e-120	NTclustered	gi\|2120242214\|gb\|CP075692.1\|	2838237	g3430	i0	84.444	9.40900195694716	450	70	88	0	62	511	216614	216165	Leptospira sp. severe_002 chromosome 1	blastn	4808	444	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. severe_002
25712134	25712134	PRJNA737474e_S_NODE_5434_length_458_cov_2.714286_g4554_i0	PRJNA737474	5434	458	2.714286	12.43142988	Treponema sp.	166	Bacteria	Bacteria	158	2.2899999999999998e-43	NR	MFC2330103.1	166	g4554	i0	98.7	0.497816593886463	76	1	49.8	0	225	452	1	76	MFC2330103.1 argininosuccinate synthase [Treponema sp.]	diamond	228	158	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
25765555	25765555	PRJNA737474f_S_NODE_289914_length_240_cov_110.544910_g289236_i0	PRJNA737474	289914	240	110.54491	265.307784	root	1	Root_unresolved	Root_unresolved	67.6	7.71e-7	NTclustered	gi\|2592016017\|gb\|CP117912.1\|	29519	g289236	i0	100	24.6416666666667	36	0	15	0	150	185	20766	20801	Borreliella garinii strain NG-Z6 plasmid lp17	blastn	5914	67.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
25765677	25765677	PRJNA737474f_S_NODE_365202_length_210_cov_3573.861314_g364524_i0	PRJNA737474	365202	210	3573.861314	7505.1087594	Bacteria	2	Bacteria	Bacteria	67.6	6.58e-7	NTclustered	gi\|2592016017\|gb\|CP117912.1\|	29519	g364524	i0	100	3.38571428571429	36	0	17	0	144	179	20766	20801	Borreliella garinii strain NG-Z6 plasmid lp17	blastn	711	67.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
25767405	25767405	PRJNA737474g_S_NODE_330738_length_250_cov_0.864407_g329444_i0	PRJNA737474	330738	250	0.864407	2.1610175	Pseudomonadati	3379134	Bacteria	Bacteria	65.8	2.91e-6	NTclustered	gi\|2592016017\|gb\|CP117912.1\|	29519	g329444	i0	100	0.552	35	0	14	0	201	235	20766	20800	Borreliella garinii strain NG-Z6 plasmid lp17	blastn	138	65.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
25767915	25767915	PRJNA737474g_S_NODE_465586_length_235_cov_3.320988_g464292_i0	PRJNA737474	465586	235	3.320988	7.8043218	Bacteria	2	Bacteria	Bacteria	62.1	3.5e-5	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g464292	i0	100	0.451063829787234	33	0	14	0	186	218	868496	868464	Borreliella garinii strain 17-54Z3 chromosome	blastn	106	62.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
25859678	25859678	PRJNA737474g_S_NODE_405067_length_243_cov_1044.882353_g403773_i0	PRJNA737474	405067	243	1044.882353	2539.06411779	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	73.1	1.68e-8	NTclustered	gi\|2166239570\|dbj\|LC662868.1\|	1898206	g403773	i0	95.652	176.156378600823	46	1	19	1	30	75	31	75	Spirochaetaceae bacterium ARSSAG-00002195 DNA, putative prophage region, clone: 00002195_pp3	blastn	42806	73.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
25860603	25860603	PRJNA737474g_S_NODE_494891_length_229_cov_864.262821_g493597_i0	PRJNA737474	494891	229	864.262821	1979.16186009	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	75	4.36e-9	NTclustered	gi\|2166239570\|dbj\|LC662868.1\|	1898206	g493597	i0	95.745	187.07423580786	47	1	21	1	154	200	76	31	Spirochaetaceae bacterium ARSSAG-00002195 DNA, putative prophage region, clone: 00002195_pp3	blastn	42840	75	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
25901391	25901391	PRJNA737474f_S_NODE_256427_length_244_cov_0.923977_g255749_i0	PRJNA737474	256427	244	0.923977	2.25450388	Bacteria	2	Bacteria	Bacteria	62.1	3.66e-5	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g255749	i0	100	0.405737704918033	33	0	14	0	15	47	868464	868496	Borreliella garinii strain 17-54Z3 chromosome	blastn	99	62.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
25901410	25901410	PRJNA737474f_S_NODE_269739_length_243_cov_0.788235_g269061_i0	PRJNA737474	269739	243	0.788235	1.91541105	Bacteria	2	Bacteria	Bacteria	62.1	3.64e-5	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g269061	i0	100	0.423868312757202	33	0	14	0	24	56	868464	868496	Borreliella garinii strain 17-54Z3 chromosome	blastn	103	62.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
25903401	25903401	PRJNA737474g_S_NODE_356643_length_247_cov_3.827586_g355349_i0	PRJNA737474	356643	247	3.827586	9.45413742	Borrelia	138	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2668652688\|gb\|CP129313.1\|	142	g355349	i0	100	0.226720647773279	28	0	11	0	185	212	11682	11655	Borrelia turicatae strain BTCAM1 plasmid lp32, complete sequence	blastn	56	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia turicatae
25997355	25997355	PRJNA737474g_S_NODE_589900_length_206_cov_47.180451_g588606_i0	PRJNA737474	589900	206	47.180451	97.19172906	Borreliella garinii	29519	Bacteria	Bacteria	65.8	2.31e-6	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g588606	i0	100	0.62621359223301	35	0	17	0	24	58	868464	868498	Borreliella garinii strain 17-54Z3 chromosome	blastn	129	65.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
26036803	26036803	PRJNA737474e_S_NODE_14796_length_320_cov_1.817814_g13914_i0	PRJNA737474	14796	320	1.817814	5.8170048	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	81.6	2.01e-15	NR	MCF0237448.1	2791017	g13914	i0	46	2.925	100	39	87.2	4	42	320	225	316	MCF0237448.1 family 43 glycosylhydrolase [Sphaerochaetaceae bacterium]	diamond	936	81.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
26112450	26112450	PRJNA737474b_S_NODE_17941_length_378_cov_3.836066_g16902_i0	PRJNA737474	17941	378	3.836066	14.50032948	Treponema endosymbiont of Eucomonympha sp.	1580831	Bacteria	Bacteria	228	1.52e-74	NR	WP_187152238.1	1580831	g16902	i0	93.9	0.912698412698413	115	7	91.3	0	32	376	7	121	WP_187152238.1 alginate export family protein, partial [Treponema endosymbiont of Eucomonympha sp.]	diamond	345	228	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema endosymbiont of Eucomonympha sp.
26175803	26175803	PRJNA737474g_S_NODE_346829_length_248_cov_1.200000_g345535_i0	PRJNA737474	346829	248	1.2	2.976	Bacteria	2	Bacteria	Bacteria	62.1	3.73e-5	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g345535	i0	100	0.399193548387097	33	0	13	0	197	229	868496	868464	Borreliella garinii strain 17-54Z3 chromosome	blastn	99	62.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
26253014	26253014	PRJNA737474d_S_NODE_11510_length_453_cov_7.692105_g10925_i0	PRJNA737474	11510	453	7.692105	34.84523565	Spirochaetales bacterium	2026792	Bacteria	Bacteria	55.1	1.75e-5	NR	MEI8096416.1	2026792	g10925	i0	27.5	0.721854304635762	109	67	64.2	1	7	297	670	778	MEI8096416.1 fibronectin type III domain-containing protein [Spirochaetales bacterium]	diamond	327	55.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
26268367	26268367	PRJNA737474g_S_NODE_430734_length_241_cov_824.166667_g429440_i0	PRJNA737474	430734	241	824.166667	1986.24166747	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	75	4.63e-9	NTclustered	gi\|2166239570\|dbj\|LC662868.1\|	1898206	g429440	i0	97.674	176.44398340249	43	1	18	0	166	208	76	34	Spirochaetaceae bacterium ARSSAG-00002195 DNA, putative prophage region, clone: 00002195_pp3	blastn	42523	75	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
26269583	26269583	PRJNA737474g_S_NODE_580630_length_208_cov_10476.925926_g579336_i0	PRJNA737474	580630	208	10476.925926	21792.00592608	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	76.8	1.08e-9	NTclustered	gi\|2166239570\|dbj\|LC662868.1\|	1898206	g579336	i0	95.833	206.548076923077	48	1	23	1	130	177	77	31	Spirochaetaceae bacterium ARSSAG-00002195 DNA, putative prophage region, clone: 00002195_pp3	blastn	42962	76.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
26312244	26312244	PRJNA737474g_S_NODE_572958_length_211_cov_5.000000_g571664_i0	PRJNA737474	572958	211	5	10.55	Bacteria	2	Bacteria	Bacteria	63.9	8.56e-6	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g571664	i0	100	0.483412322274882	34	0	16	0	17	50	868463	868496	Borreliella garinii strain 17-54Z3 chromosome	blastn	102	63.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
26448002	26448002	PRJNA737474g_S_NODE_41247_length_446_cov_12.394102_g39957_i0	PRJNA737474	41247	446	12.394102	55.27769492	Bacteria	2	Bacteria	Bacteria	62.1	7.17e-5	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g39957	i0	100	0.291479820627803	33	0	7	0	412	444	868496	868464	Borreliella garinii strain 17-54Z3 chromosome	blastn	130	62.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
26529692	26529692	PRJNA737474f_S_NODE_134304_length_273_cov_1.985000_g133626_i0	PRJNA737474	134304	273	1.985	5.41905	Leptospira sp. severe_	178	Bacteria	Bacteria	255	1.7800000000000001e-63	NTclustered	gi\|2120242214\|gb\|CP075692.1\|	2838237	g133626	i0	85.656	40.8461538461538	244	33	89	2	14	256	18030	18272	Leptospira sp. severe_002 chromosome 1	blastn	11151	255	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. severe_002
26533474	26533474	PRJNA737474f_S_NODE_63640_length_321_cov_2.435484_g62962_i0	PRJNA737474	63640	321	2.435484	7.81790364	Leptospira noguchii	28182	Bacteria	Bacteria	119	2.93e-22	NTclustered	gi\|2218393545\|gb\|CP091953.1\|	28182	g62962	i0	83.077	1.21495327102804	130	22	40	0	74	203	3910566	3910437	Leptospira noguchii strain IP1605021 chromosome 1, complete sequence	blastn	390	119	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira noguchii
26541554	26541554	PRJNA737474g_S_NODE_582248_length_208_cov_1048.725926_g580954_i0	PRJNA737474	582248	208	1048.725926	2181.34992608	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	75	3.89e-9	NTclustered	gi\|2166239570\|dbj\|LC662868.1\|	1898206	g580954	i0	95.745	206.903846153846	47	1	23	1	133	179	76	31	Spirochaetaceae bacterium ARSSAG-00002195 DNA, putative prophage region, clone: 00002195_pp3	blastn	43036	75	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
26583432	26583432	PRJNA737474g_S_NODE_297736_length_254_cov_1.000000_g296442_i0	PRJNA737474	297736	254	1	2.54	Bacteria	2	Bacteria	Bacteria	63.9	1.07e-5	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g296442	i0	100	0.767716535433071	34	0	13	0	29	62	868463	868496	Borreliella garinii strain 17-54Z3 chromosome	blastn	195	63.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
26583718	26583718	PRJNA737474g_S_NODE_358176_length_247_cov_1.287356_g356882_i0	PRJNA737474	358176	247	1.287356	3.17976932	Bacteria	2	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g356882	i0	100	0.340080971659919	28	0	11	0	220	247	868496	868469	Borreliella garinii strain 17-54Z3 chromosome	blastn	84	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
32919634	32919634	PRJNA737474f_S_NODE_246633_length_245_cov_1.139535_g245955_i0	PRJNA737474	246633	245	1.139535	2.79186075	Treponema sp.	166	Bacteria	Bacteria	52.4	1.21e-5	NR	HBG64917.1	166	g245955	i0	42.6	1.71428571428571	61	34	73.5	1	214	35	78	138	HBG64917.1 glycosyl transferase [Treponema sp.]	diamond	420	52.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32920646	32920646	PRJNA737474g_S_NODE_36209_length_474_cov_9.109726_g34922_i0	PRJNA737474	36209	474	9.109726	43.18010124	Spirochaetota bacterium	2202144	Bacteria	Bacteria	65.9	3.55e-9	NR	MEW5816844.1	2202144	g34922	i0	44.4	0.39873417721519	63	31	39.9	1	11	199	538	596	MEW5816844.1 alpha-amylase family glycosyl hydrolase [Spirochaetota bacterium]	diamond	189	65.9	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32924688	32924688	PRJNA737474g_S_NODE_279577_length_257_cov_1.804348_g278283_i0	PRJNA737474	279577	257	1.804348	4.63717436	Pleomorphochaeta	1920504	Bacteria	Bacteria	106	6.870000000000001e-27	NR	MDC7244240.1	1920505	g278283	i0	59	1.93774319066148	83	33	95.7	1	250	5	89	171	MDC7244240.1 phosphoribosyltransferase [Pleomorphochaeta sp.]	diamond	498	107	0.990654205607477	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Pleomorphochaeta	Pleomorphochaeta sp.
32937813	32937813	PRJNA737474g_S_NODE_356785_length_247_cov_2.149425_g355491_i0	PRJNA737474	356785	247	2.149425	5.30907975	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	47	0.00108	NR	MCB1169781.1	2026757	g355491	i0	35.4	2.96356275303644	79	42	96	2	9	245	169	238	MCB1169781.1 dioxygenase [Leptospiraceae bacterium]	diamond	732	47	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
32941470	32941470	PRJNA737474b_S_NODE_25329_length_318_cov_9.824490_g24290_i0	PRJNA737474	25329	318	9.82449	31.2418782	Bacteria	2	Bacteria	Bacteria	79	1.76e-14	NR	MDF1567988.1	1898206	g24290	i0	85	4.52830188679245	40	6	37.7	0	297	178	592	631	MDF1567988.1 formate--tetrahydrofolate ligase [Spirochaetaceae bacterium]	diamond	1440	79.7	0.991217063989962	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
32953111	32953111	PRJNA737474c_S_NODE_4826_length_489_cov_1.932692_g3999_i0	PRJNA737474	4826	489	1.932692	9.45086388	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	173	3.3e-47	NR	MCF0237448.1	2791017	g3999	i0	50.9	0.975460122699387	159	78	97.5	0	484	8	360	518	MCF0237448.1 family 43 glycosylhydrolase [Sphaerochaetaceae bacterium]	diamond	477	173	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
32953679	32953679	PRJNA737474e_S_NODE_34210_length_235_cov_3.716049_g33328_i0	PRJNA737474	34210	235	3.716049	8.73271515	Spirochaetales bacterium	2026792	Bacteria	Bacteria	108	1.64e-25	NR	MDD7200396.1	2026792	g33328	i0	64.1	1.99148936170213	78	25	95.7	1	2	226	102	179	MDD7200396.1 family 43 glycosylhydrolase [Spirochaetales bacterium]	diamond	468	108	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
32958909	32958909	PRJNA737474f_S_NODE_28674_length_401_cov_1.832317_g27997_i0	PRJNA737474	28674	401	1.832317	7.34759117	root	1	Root_unresolved	Root_unresolved	112	5.8200000000000006e-27	NR	MCE9502068.1	178	g27997	i0	57.7	1.76558603491272	78	33	58.4	0	399	166	264	341	MCE9502068.1 cyclopropane-fatty-acyl-phospholipid synthase family protein [Leptospira sp.]	diamond	708	112	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp.
32970242	32970242	PRJNA737474c_S_NODE_30274_length_232_cov_2.893082_g29443_i0	PRJNA737474	30274	232	2.893082	6.71195024	Treponema endosymbiont of Eucomonympha sp.	1580831	Bacteria	Bacteria	137	1.26e-39	NR	WP_187149558.1	1580831	g29443	i0	98.5	0.853448275862069	66	1	85.3	0	200	3	9	74	WP_187149558.1 alginate export family protein, partial [Treponema endosymbiont of Eucomonympha sp.]	diamond	198	137	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema endosymbiont of Eucomonympha sp.
32970889	32970889	PRJNA737474f_S_NODE_13226_length_554_cov_3.222453_g12561_i0	PRJNA737474	13226	554	3.222453	17.85238962	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	115	1.38e-26	NR	MFA6688828.1	2791017	g12561	i0	55.1	1.07761732851986	98	44	53.1	0	1	294	348	445	MFA6688828.1 diaminobutyrate--2-oxoglutarate transaminase [Sphaerochaetaceae bacterium]	diamond	597	115	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
32970935	32970935	PRJNA737474f_S_NODE_146474_length_268_cov_1.287179_g145796_i0	PRJNA737474	146474	268	1.287179	3.44963972	Spirochaetales bacterium	2026792	Bacteria	Bacteria	84.3	4.59e-17	NR	MBN2509503.1	2026792	g145796	i0	44.9	1.58955223880597	69	38	77.2	0	207	1	133	201	MBN2509503.1 zinc-ribbon domain-containing protein [Spirochaetales bacterium]	diamond	426	84.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
32976234	32976234	PRJNA737474g_S_NODE_394274_length_244_cov_1.350877_g392980_i0	PRJNA737474	394274	244	1.350877	3.29613988	Pseudomonadati	3379134	Bacteria	Bacteria	48.5	2.45e-4	NR	MCL2044507.1	166	g392980	i0	45.9	6.34426229508197	61	30	75	1	30	212	165	222	MCL2044507.1 HAD family hydrolase [Treponema sp.]	diamond	1548	48.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
33004230	33004230	PRJNA737474c_S_NODE_8683_length_374_cov_4.697674_g7852_i0	PRJNA737474	8683	374	4.697674	17.56930076	Spirochaetales bacterium	2026792	Bacteria	Bacteria	156	1.08e-41	NR	MDD7200396.1	2026792	g7852	i0	71.4	3.44117647058824	105	30	84.2	0	52	366	32	136	MDD7200396.1 family 43 glycosylhydrolase [Spirochaetales bacterium]	diamond	1287	156	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
33005397	33005397	PRJNA737474f_S_NODE_92403_length_296_cov_1.197309_g91725_i0	PRJNA737474	92403	296	1.197309	3.54403464	Candidatus Gallitreponema excrementavium	2840840	Bacteria	Bacteria	46.2	5.69e-4	NR	MBO8458629.1	2840840	g91725	i0	42.6	0.547297297297297	54	30	54.7	1	14	175	36	88	MBO8458629.1 30S ribosomal protein S15 [Candidatus Gallitreponema excrementavium]	diamond	162	46.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales		Candidatus Gallitreponema	Candidatus Gallitreponema excrementavium
33009946	33009946	PRJNA737474f_S_NODE_141131_length_270_cov_2.304569_g140453_i0	PRJNA737474	141131	270	2.304569	6.2223363	Bacteria candidate phyla	1783234	Bacteria	Bacteria	80.9	2.72e-16	NR	WP_012671820.1	159	g140453	i0	56.2	6.72222222222222	73	31	81.1	1	258	40	153	224	WP_012671820.1 pseudouridine synthase [Brachyspira hyodysenteriae]	diamond	1815	81.6	0.991421568627451	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
33021381	33021381	PRJNA737474d_S_NODE_17092_length_371_cov_3.184564_g16498_i0	PRJNA737474	17092	371	3.184564	11.81473244	Treponema endosymbiont of Eucomonympha sp.	1580831	Bacteria	Bacteria	157	1.19e-46	NR	WP_228378758.1	1580831	g16498	i0	97.6	0.671159029649596	83	2	67.1	0	122	370	1	83	WP_228378758.1 DoxX family protein, partial [Treponema endosymbiont of Eucomonympha sp.]	diamond	249	157	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema endosymbiont of Eucomonympha sp.
33022411	33022411	PRJNA737474f_S_NODE_42004_length_357_cov_1.447183_g41326_i0	PRJNA737474	42004	357	1.447183	5.16644331	Spirochaetota bacterium	2202144	Bacteria	Bacteria	87	5.9e-18	NR	MFC1669629.1	2202144	g41326	i0	39	0.991596638655462	118	67	97.5	2	352	5	85	199	MFC1669629.1 SDR family NAD(P)-dependent oxidoreductase [Spirochaetota bacterium]	diamond	354	87	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
33023037	33023037	PRJNA737474g_S_NODE_220980_length_271_cov_2.035354_g219686_i0	PRJNA737474	220980	271	2.035354	5.51580934	Spirochaetes bacterium GWB1_36_13	1802174	Bacteria	Bacteria	68.9	3.21e-11	NR	OHD11784.1	1802174	g219686	i0	33	5.87822878228782	91	60	99.6	1	2	271	489	579	OHD11784.1 MAG: hypothetical protein A2Y41_09870 [Spirochaetes bacterium GWB1_36_13]	diamond	1593	68.9	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium GWB1_36_13
33027083	33027083	PRJNA737474f_S_NODE_159172_length_263_cov_2.026316_g158494_i0	PRJNA737474	159172	263	2.026316	5.32921108	Pseudomonadati	3379134	Bacteria	Bacteria	78.6	1.18e-14	NR	HQH99510.1	2202144	g158494	i0	65.3	2.21292775665399	49	17	55.9	0	247	101	733	781	HQH99510.1 PEP/pyruvate-binding domain-containing protein [Spirochaetota bacterium]	diamond	582	78.6	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
33044092	33044092	PRJNA737474f_S_NODE_22372_length_437_cov_2.802198_g21695_i0	PRJNA737474	22372	437	2.802198	12.24560526	Pleomorphochaeta	1920504	Bacteria	Bacteria	79.7	1.88e-15	NR	MDC7244240.1	1920505	g21695	i0	55.4	1.33180778032037	65	28	43.9	1	324	133	107	171	MDC7244240.1 phosphoribosyltransferase [Pleomorphochaeta sp.]	diamond	582	80.5	0.990062111801242	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Pleomorphochaeta	Pleomorphochaeta sp.
33044175	33044175	PRJNA737474f_S_NODE_66716_length_318_cov_1.065306_g66038_i0	PRJNA737474	66716	318	1.065306	3.38767308	Leptospira	171	Bacteria	Bacteria	123	1.72e-33	NR	WP_135760341.1	1193500	g66038	i0	79.2	2.71698113207547	72	15	67.9	0	94	309	43	114	WP_135760341.1 VOC family protein [Leptospira idonii]	diamond	864	124	0.991935483870968	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira idonii
33044372	33044372	PRJNA737474g_S_NODE_42340_length_441_cov_1.967391_g41050_i0	PRJNA737474	42340	441	1.967391	8.67619431	PVC group	1783257	Bacteria	Bacteria	45.8	0.0228	NR	WP_074931079.1	163	g41050	i0	21.8	6.22448979591837	133	103	90.5	1	9	407	36	167	WP_074931079.1 ABC transporter ATP-binding protein [Treponema bryantii]	diamond	2745	46.2	0.991341991341991	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema bryantii
33057573	33057573	PRJNA737474g_S_NODE_60157_length_384_cov_1.073955_g58864_i0	PRJNA737474	60157	384	1.073955	4.1239872	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	169	2.23e-46	NR	MCF0237448.1	2791017	g58864	i0	58.3	0.9921875	127	53	99.2	0	382	2	285	411	MCF0237448.1 family 43 glycosylhydrolase [Sphaerochaetaceae bacterium]	diamond	381	169	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
33073258	33073258	PRJNA737474f_S_NODE_229165_length_247_cov_1.327586_g228487_i0	PRJNA737474	229165	247	1.327586	3.27913742	Brachyspira catarrhinii	2528966	Bacteria	Bacteria	46.2	0.0023	NR	WP_137997320.1	2528966	g228487	i0	39	0.995951417004049	82	47	96	1	237	1	123	204	WP_137997320.1 hypothetical protein [Brachyspira catarrhinii]	diamond	246	46.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira catarrhinii
33074253	33074253	PRJNA737474g_S_NODE_318485_length_251_cov_0.865169_g317191_i0	PRJNA737474	318485	251	0.865169	2.17157419	Leptospira ognonensis	2484945	Bacteria	Bacteria	56.6	5.05e-7	NR	WP_135625295.1	2484945	g317191	i0	36.9	3.14342629482072	84	40	86.1	2	238	23	198	280	WP_135625295.1 NHL repeat-containing protein [Leptospira ognonensis]	diamond	789	56.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira ognonensis
33095309	33095309	PRJNA737474f_S_NODE_18614_length_472_cov_1.736842_g17939_i0	PRJNA737474	18614	472	1.736842	8.19789424	Pseudomonadati	3379134	Bacteria	Bacteria	60.1	3.4e-7	NR	PKL30934.1	2013833	g17939	i0	31.7	3.05720338983051	123	76	77.5	4	77	442	62	177	PKL30934.1 MAG: hypothetical protein CVV45_15785 [Spirochaetae bacterium HGW-Spirochaetae-10]	diamond	1443	60.1	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetae bacterium HGW-Spirochaetae-10
33124405	33124405	PRJNA737474f_S_NODE_185487_length_255_cov_0.840659_g184809_i0	PRJNA737474	185487	255	0.840659	2.14368045	Leptospira sp.	178	Bacteria	Bacteria	52	2.28e-5	NR	MCZ8157590.1	178	g184809	i0	35.4	0.764705882352941	65	41	76.5	1	60	254	81	144	MCZ8157590.1 DASS family sodium-coupled anion symporter [Leptospira sp.]	diamond	195	52	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp.
33124799	33124799	PRJNA737474f_S_NODE_64575_length_320_cov_1.639676_g63897_i0	PRJNA737474	64575	320	1.639676	5.2469632	Spirochaetales bacterium	2026792	Bacteria	Bacteria	61.6	2.11e-8	NR	HOX48843.1	2026792	g63897	i0	60	1.153125	50	20	46.9	0	270	121	174	223	HOX48843.1 ankyrin repeat domain-containing protein [Spirochaetales bacterium]	diamond	369	61.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
33140587	33140587	PRJNA737474c_S_NODE_22071_length_264_cov_2.633508_g21240_i0	PRJNA737474	22071	264	2.633508	6.95246112	Pleomorphochaeta sp.	1920505	Bacteria	Bacteria	63.2	3.06e-9	NR	MDC7243778.1	1920505	g21240	i0	44.9	0.886363636363636	78	41	88.6	1	2	235	338	413	MDC7243778.1 hypothetical protein [Pleomorphochaeta sp.]	diamond	234	63.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Pleomorphochaeta	Pleomorphochaeta sp.
33159232	33159232	PRJNA737474g_S_NODE_196856_length_279_cov_0.932039_g195562_i0	PRJNA737474	196856	279	0.932039	2.60038881	Treponema berlinense	225004	Bacteria	Bacteria	51.6	4.38e-5	NR	WP_078931423.1	225004	g195562	i0	38.1	1.80645161290323	84	45	87.1	3	23	265	525	604	WP_078931423.1 DNA polymerase I [Treponema berlinense]	diamond	504	51.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema berlinense
33163374	33163374	PRJNA737474f_S_NODE_153800_length_265_cov_2.182292_g153122_i0	PRJNA737474	153800	265	2.182292	5.7830738	Bacteria	2	Bacteria	Bacteria	55.5	1.21e-6	NR	MCK4542822.1	2026792	g153122	i0	42.6	6.24905660377359	61	35	69.1	0	242	60	18	78	MCK4542822.1 DnaJ domain-containing protein [Spirochaetales bacterium]	diamond	1656	55.8	0.99462365591397806	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium

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);;