metadata: contig_metadata: 56 rows where bioproject = "PRJNA565584", tax_kingdom = "Pseudomonadati" and tax

56 rows where bioproject = "PRJNA565584", 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
1831491	1831491	PRJNA565584_P_NODE_196182_length_245_cov_0.895349_g195030_i0	PRJNA565584	196182	245	0.895349	2.19360505	Gracilinema caldarium	215591	Bacteria	Bacteria	97.1	3e-21	NR	WP_013969729.1	215591	g195030	i0	55.6	4.93469387755102	81	36	99.2	0	243	1	870	950	WP_013969729.1 ligand-binding sensor domain-containing diguanylate cyclase [Gracilinema caldarium]	diamond	1209	97.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Gracilinema	Gracilinema caldarium
5658388	5658388	PRJNA565584_P_NODE_119445_length_282_cov_1.473684_g118293_i0	PRJNA565584	119445	282	1.473684	4.15578888	Leptospira mgodei	3235172	Bacteria	Bacteria	516	7.67e-142	NTclustered	gi\|2777195838\|gb\|CP162139.1\|	3235172	g118293	i0	99.645	1	282	1	100	0	1	282	1824465	1824184	Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence	blastn	282	516	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
5661668	5661668	PRJNA565584_P_NODE_92485_length_310_cov_2.746835_g91333_i0	PRJNA565584	92485	310	2.746835	8.5151885	Treponema sp. Marseille-Q4132	2766701	Bacteria	Bacteria	464	3.14e-126	NTclustered	gi\|1897717435\|gb\|CP060591.1\|	2766701	g91333	i0	92.605	3.10322580645161	311	21	99	1	2	310	2464696	2465006	Treponema sp. Marseille-Q4132 chromosome	blastn	962	464	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. Marseille-Q4132
10062584	10062584	PRJNA565584_P_NODE_146528_length_264_cov_2.204188_g145376_i0	PRJNA565584	146528	264	2.204188	5.81905632	Treponema	157	Bacteria	Bacteria	466	7.27e-127	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g145376	i0	98.485	12.9734848484848	264	4	100	0	1	264	1125897	1125634	Treponema sp. OMZ 838, complete genome	blastn	3425	466	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
10759308	10759308	PRJNA565584_P_NODE_135489_length_272_cov_1.185930_g134337_i0	PRJNA565584	135489	272	1.18593	3.2257296	Leptospira cinconiae	3235173	Bacteria	Bacteria	497	2.67e-136	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g134337	i0	99.632	1	272	1	100	0	1	272	1335280	1335009	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	272	497	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
16437169	16437169	PRJNA565584_P_NODE_196493_length_245_cov_0.895349_g195341_i0	PRJNA565584	196493	245	0.895349	2.19360505	Pseudomonadati	3379134	Bacteria	Bacteria	85.1	2.74e-17	NR	MBX7059936.1	2604146	g195341	i0	50	1.98367346938776	78	36	91.8	1	244	20	272	349	MBX7059936.1 catalase family protein [Leptospirales bacterium]	diamond	486	85.9	0.990686845168801	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales			Leptospirales bacterium
17132364	17132364	PRJNA565584_P_NODE_123494_length_279_cov_2.733010_g122342_i0	PRJNA565584	123494	279	2.73301	7.6250979	Treponema vincentii	69710	Bacteria	Bacteria	433	7.85e-117	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g122342	i0	94.624	5	279	15	100	0	1	279	1181273	1181551	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	1395	433	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
17712392	17712392	PRJNA565584_P_NODE_196574_length_245_cov_0.895349_g195422_i0	PRJNA565584	196574	245	0.895349	2.19360505	Treponema	157	Bacteria	Bacteria	147	9.86e-31	NTclustered	gi\|2265141765\|gb\|CP051199.1\|	2563664	g195422	i0	98.78	40.9836734693878	82	1	61	0	61	142	1330157	1330238	Treponema sp. OMZ 788 chromosome, complete genome	blastn	10041	147	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 788
19682248	19682248	PRJNA565584_P_NODE_183196_length_248_cov_0.880000_g182044_i0	PRJNA565584	183196	248	0.88	2.1824	Treponema vincentii	69710	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2265115921\|gb\|CP051153.1\|	69710	g182044	i0	99.597	5	248	1	100	0	1	248	2423206	2423453	Treponema vincentii strain OMZ 862 chromosome, complete genome	blastn	1240	453	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
26636229	26636229	PRJNA565584_P_NODE_75921_length_341_cov_1.149254_g74770_i0	PRJNA565584	75921	341	1.149254	3.91895614	Spirochaetia bacterium	2053615	Bacteria	Bacteria	44.7	0.0238	NR	GHV25216.1	2053615	g74770	i0	31.8	0.967741935483871	110	68	90.6	1	322	14	263	372	GHV25216.1 hypothetical protein FACS189498_3240 [Spirochaetia bacterium]	diamond	330	44.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
26667561	26667561	PRJNA565584_P_NODE_126261_length_278_cov_1.209756_g125109_i0	PRJNA565584	126261	278	1.209756	3.36312168	Spirochaetia bacterium	2053615	Bacteria	Bacteria	144	1.2999999999999998e-38	NR	GHV24167.1	2053615	g125109	i0	77.8	1.94244604316547	90	20	97.1	0	3	272	385	474	GHV24167.1 capsular polysaccharide biosynthesis protein [Spirochaetia bacterium]	diamond	540	144	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
26903388	26903388	PRJNA565584_P_NODE_195941_length_245_cov_0.895349_g194789_i0	PRJNA565584	195941	245	0.895349	2.19360505	Pleomorphochaeta	1920504	Bacteria	Bacteria	103	1.3399999999999999e-25	NR	MDC7244240.1	1920505	g194789	i0	62.2	5.84081632653061	82	30	99.2	1	3	245	90	171	MDC7244240.1 phosphoribosyltransferase [Pleomorphochaeta sp.]	diamond	1431	103	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Pleomorphochaeta	Pleomorphochaeta sp.
27205501	27205501	PRJNA565584_P_NODE_135562_length_272_cov_1.160804_g134410_i0	PRJNA565584	135562	272	1.160804	3.15738688	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	102	3.25e-23	NR	MDA3852253.1	1898206	g134410	i0	60.5	2.93382352941176	86	31	94.9	2	13	270	73	155	MDA3852253.1 asparagine--tRNA ligase [Spirochaetaceae bacterium]	diamond	798	102	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
27458724	27458724	PRJNA565584_P_NODE_124043_length_279_cov_1.495146_g122891_i0	PRJNA565584	124043	279	1.495146	4.17145734	Treponema sp.	166	Bacteria	Bacteria	51.2	5.79e-5	NR	MBS7294236.1	166	g122891	i0	34.2	0.817204301075269	76	48	79.6	2	230	9	351	426	MBS7294236.1 hypothetical protein [Treponema sp.]	diamond	228	51.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27616589	27616589	PRJNA565584_P_NODE_200104_length_244_cov_0.900585_g198952_i0	PRJNA565584	200104	244	0.900585	2.1974274	Treponema sp.	166	Bacteria	Bacteria	73.6	4.68e-13	NR	MCL2478242.1	166	g198952	i0	44	0.922131147540984	75	42	92.2	0	239	15	180	254	MCL2478242.1 hypothetical protein [Treponema sp.]	diamond	225	73.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27679958	27679958	PRJNA565584_P_NODE_195384_length_245_cov_0.895349_g194232_i0	PRJNA565584	195384	245	0.895349	2.19360505	Spirochaetota bacterium	2202144	Bacteria	Bacteria	60.8	1.52e-8	NR	MDH5680916.1	2202144	g194232	i0	55.3	0.575510204081633	47	21	57.6	0	3	143	48	94	MDH5680916.1 phosphoglucosamine mutase [Spirochaetota bacterium]	diamond	141	60.8	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
27756729	27756729	PRJNA565584_P_NODE_53404_length_407_cov_1.383234_g52253_i0	PRJNA565584	53404	407	1.383234	5.62976238	Pseudomonadati	3379134	Bacteria	Bacteria	60.8	9.77e-8	NR	MBU45438.1	1898206	g52253	i0	39.3	3.90663390663391	89	46	60.4	4	4	249	289	376	MBU45438.1 NADP-dependent succinic semialdehyde dehydrogenase [Spirochaetaceae bacterium]	diamond	1590	60.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
27837356	27837356	PRJNA565584_P_NODE_208664_length_242_cov_0.911243_g207512_i0	PRJNA565584	208664	242	0.911243	2.20520806	Treponema phagedenis	162	Bacteria	Bacteria	122	3.02e-31	NR	WP_024753216.1	162	g207512	i0	73.4	0.979338842975207	79	20	96.7	1	6	239	296	374	WP_024753216.1 alanine racemase [Treponema phagedenis]	diamond	237	122	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema phagedenis
28121764	28121764	PRJNA565584_P_NODE_97525_length_303_cov_0.995652_g96373_i0	PRJNA565584	97525	303	0.995652	3.01682556	Spirochaetales bacterium	2026792	Bacteria	Bacteria	108	2.99e-25	NR	MBT3272796.1	2026792	g96373	i0	53	10.1683168316832	100	44	96	2	301	11	317	416	MBT3272796.1 CotH kinase family protein [Spirochaetales bacterium]	diamond	3081	108	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
28293111	28293111	PRJNA565584_P_NODE_39606_length_477_cov_1.363861_g38455_i0	PRJNA565584	39606	477	1.363861	6.50561697	Bacteria	2	Bacteria	Bacteria	50.8	2.92e-4	NR	MDR0554012.1	166	g38455	i0	29.4	3.57861635220126	136	82	81.8	3	466	77	13	140	MDR0554012.1 rhomboid family intramembrane serine protease [Treponema sp.]	diamond	1707	51.2	0.9921875	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28532291	28532291	PRJNA565584_P_NODE_190947_length_246_cov_0.890173_g189795_i0	PRJNA565584	190947	246	0.890173	2.18982558	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	61.2	1.11e-8	NR	MBK8398112.1	2026757	g189795	i0	40.2	2.80487804878049	82	45	100	2	246	1	171	248	MBK8398112.1 alpha/beta fold hydrolase [Leptospiraceae bacterium]	diamond	690	61.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28595485	28595485	PRJNA565584_P_NODE_27687_length_586_cov_2.157895_g26546_i0	PRJNA565584	27687	586	2.157895	12.6452647	Spirochaetales bacterium	2026792	Bacteria	Bacteria	63.5	2.14e-8	NR	MBN2874962.1	2026792	g26546	i0	57.4	0.486348122866894	47	20	24.1	0	393	533	181	227	MBN2874962.1 CAP domain-containing protein [Spirochaetales bacterium]	diamond	285	63.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
28595499	28595499	PRJNA565584_P_NODE_49907_length_421_cov_1.767241_g48756_i0	PRJNA565584	49907	421	1.767241	7.44008461	Spirochaetota bacterium	2202144	Bacteria	Bacteria	65.9	4.23e-10	NR	HSA14422.1	2202144	g48756	i0	32.1	1.94536817102138	137	85	97.6	3	412	2	41	169	HSA14422.1 hypothetical protein [Spirochaetota bacterium]	diamond	819	65.9	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28627080	28627080	PRJNA565584_P_NODE_197587_length_245_cov_0.895349_g196435_i0	PRJNA565584	197587	245	0.895349	2.19360505	Spirochaetia bacterium	2053615	Bacteria	Bacteria	67.8	5.71e-11	NR	GHV80811.1	2053615	g196435	i0	47.3	1.91020408163265	74	37	90.6	1	238	17	410	481	GHV80811.1 hypothetical protein AGMMS49944_26020 [Spirochaetia bacterium]	diamond	468	67.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
28690167	28690167	PRJNA565584_P_NODE_142467_length_267_cov_1.587629_g141315_i0	PRJNA565584	142467	267	1.587629	4.23896943	Candidatus Ornithospirochaeta stercorigallinarum	2840898	Bacteria	Bacteria	123	1.9e-31	NR	HIS14517.1	2840898	g141315	i0	97.1	0.764044943820225	68	2	76.4	0	3	206	305	372	HIS14517.1 patatin-like phospholipase family protein [Candidatus Ornithospirochaeta stercorigallinarum]	diamond	204	123	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Candidatus Ornithospirochaeta	Candidatus Ornithospirochaeta stercorigallinarum
28766788	28766788	PRJNA565584_P_NODE_7607_length_1230_cov_4.222126_g6902_i0	PRJNA565584	7607	1230	4.222126	51.9321498	Treponema	157	Bacteria	Bacteria	84	3.13e-14	NR	MDR2632347.1	166	g6902	i0	27.5	1.84634146341463	193	116	43.2	5	1186	656	80	264	MDR2632347.1 CAP domain-containing protein [Treponema sp.]	diamond	2271	84.3	0.99644128113879	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28910788	28910788	PRJNA565584_P_NODE_60708_length_381_cov_1.996753_g59557_i0	PRJNA565584	60708	381	1.996753	7.60762893	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	57	4.22e-8	NR	MCB1177358.1	2026757	g59557	i0	49.1	0.417322834645669	53	26	40.9	1	163	8	1	53	MCB1177358.1 hypothetical protein [Leptospiraceae bacterium]	diamond	159	57	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28942888	28942888	PRJNA565584_P_NODE_204528_length_243_cov_0.905882_g203376_i0	PRJNA565584	204528	243	0.905882	2.20129326	Spirochaetia bacterium	2053615	Bacteria	Bacteria	126	1.08e-31	NR	HUI71271.1	2053615	g203376	i0	66.3	1.97530864197531	80	27	98.8	0	1	240	88	167	HUI71271.1 hypothetical protein [Spirochaetia bacterium]	diamond	480	126	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
29069013	29069013	PRJNA565584_P_NODE_143288_length_266_cov_3.373057_g142136_i0	PRJNA565584	143288	266	3.373057	8.97233162	Spirochaetae bacterium HGW-Spirochaetae-3	2013835	Bacteria	Bacteria	45.1	0.00745	NR	PKL23071.1	2013835	g142136	i0	35.3	0.958646616541353	85	48	95.9	1	256	2	27	104	PKL23071.1 MAG: hypothetical protein CVV47_16305 [Spirochaetae bacterium HGW-Spirochaetae-3]	diamond	255	45.1	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetae bacterium HGW-Spirochaetae-3
29082690	29082690	PRJNA565584_P_NODE_70928_length_353_cov_1.100000_g69777_i0	PRJNA565584	70928	353	1.1	3.883	Pseudomonadati	3379134	Bacteria	Bacteria	54.3	2.53e-6	NR	WP_272532658.1	1513297	g69777	i0	34.5	1.47875354107649	87	55	73.1	2	298	41	17	102	WP_272532658.1 hypothetical protein [Leptospira sp. GIMC2001]	diamond	522	54.7	0.992687385740402	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. GIMC2001
29384732	29384732	PRJNA565584_P_NODE_186949_length_247_cov_0.885057_g185797_i0	PRJNA565584	186949	247	0.885057	2.18609079	Candidatus Treponema excrementipullorum	2838768	Bacteria	Bacteria	181	2.6499999999999998e-52	NR	MBU3849231.1	2838768	g185797	i0	100	0.983805668016194	81	0	98.4	0	245	3	146	226	MBU3849231.1 asparagine synthase B [Candidatus Treponema excrementipullorum]	diamond	243	181	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Candidatus Treponema excrementipullorum
29461126	29461126	PRJNA565584_P_NODE_133290_length_273_cov_1.540000_g132138_i0	PRJNA565584	133290	273	1.54	4.2042	Pseudomonadati	3379134	Bacteria	Bacteria	80.1	4.19e-16	NR	MDR3341879.1	166	g132138	i0	44.9	3.68131868131868	89	49	97.8	0	5	271	78	166	MDR3341879.1 CAP domain-containing protein [Treponema sp.]	diamond	1005	80.5	0.995031055900621	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
29573907	29573907	PRJNA565584_P_NODE_50550_length_418_cov_2.234783_g49399_i0	PRJNA565584	50550	418	2.234783	9.34139294	Oceanispirochaeta crateris	2518645	Bacteria	Bacteria	71.2	2.65e-11	NR	WP_149486566.1	2518645	g49399	i0	37.3	1.01913875598086	142	76	98.3	4	416	6	161	294	WP_149486566.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Oceanispirochaeta crateris]	diamond	426	71.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Oceanispirochaeta	Oceanispirochaeta crateris
29618918	29618918	PRJNA565584_P_NODE_124850_length_279_cov_1.116505_g123698_i0	PRJNA565584	124850	279	1.116505	3.11504895	Treponema	157	Bacteria	Bacteria	65.1	7.84e-10	NR	MDR2951739.1	166	g123698	i0	37	5.90322580645161	92	54	98.9	1	4	279	368	455	MDR2951739.1 caspase family protein [Treponema sp.]	diamond	1647	65.5	0.993893129770992	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
29636896	29636896	PRJNA565584_P_NODE_58730_length_388_cov_0.977778_g57579_i0	PRJNA565584	58730	388	0.977778	3.79377864	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	170	1.9899999999999995e-47	NR	MFA7188483.1	2791017	g57579	i0	88.4	0.734536082474227	95	11	73.5	0	102	386	1	95	MFA7188483.1 hypothetical protein [Sphaerochaetaceae bacterium]	diamond	285	170	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
29713637	29713637	PRJNA565584_P_NODE_11650_length_980_cov_1.143330_g10690_i0	PRJNA565584	11650	980	1.14333	11.204634	Pseudomonadati	3379134	Bacteria	Bacteria	148	1.17e-37	NR	WP_135766052.1	2484901	g10690	i0	30.1	5.76428571428571	322	178	86.6	7	867	19	29	342	WP_135766052.1 catalase family protein [Leptospira ilyithenensis]	diamond	5649	148	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira ilyithenensis
29731636	29731636	PRJNA565584_P_NODE_132190_length_274_cov_1.328358_g131038_i0	PRJNA565584	132190	274	1.328358	3.63970092	Spirochaetes bacterium GWB1_59_5	1802176	Bacteria	Bacteria	58.9	4.21e-8	NR	OHD18884.1	1802176	g131038	i0	42.5	2.9014598540146	87	48	93.1	1	259	5	66	152	OHD18884.1 MAG: hypothetical protein A2Y38_14560 [Spirochaetes bacterium GWB1_59_5]	diamond	795	58.9	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium GWB1_59_5
30079283	30079283	PRJNA565584_P_NODE_39232_length_479_cov_2.985222_g38081_i0	PRJNA565584	39232	479	2.985222	14.29921338	Spirochaetia bacterium	2053615	Bacteria	Bacteria	85.1	1.31e-17	NR	MDH5656459.1	2053615	g38081	i0	68.5	0.338204592901879	54	17	33.8	0	317	478	19	72	MDH5656459.1 50S ribosomal protein L13 [Spirochaetia bacterium]	diamond	162	85.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
30142161	30142161	PRJNA565584_P_NODE_145592_length_265_cov_1.598958_g144440_i0	PRJNA565584	145592	265	1.598958	4.2372387	Spirochaetia bacterium	2053615	Bacteria	Bacteria	112	1.88e-27	NR	HKJ85084.1	2053615	g144440	i0	56.8	0.99622641509434	88	37	99.6	1	265	2	213	299	HKJ85084.1 hypothetical protein [Spirochaetia bacterium]	diamond	264	112	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
30174164	30174164	PRJNA565584_P_NODE_57852_length_391_cov_0.952830_g56701_i0	PRJNA565584	57852	391	0.95283	3.7255653	Turneriella parva	29510	Bacteria	Bacteria	232	5.7899999999999996e-74	NR	WP_014802630.1	29510	g56701	i0	77.3	2.9079283887468	128	29	98.2	0	389	6	148	275	WP_014802630.1 hypothetical protein [Turneriella parva]	diamond	1137	232	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
30314759	30314759	PRJNA565584_P_NODE_28052_length_581_cov_1.921260_g26909_i0	PRJNA565584	28052	581	1.92126	11.1625206	root	1	Root_unresolved	Root_unresolved	70.9	4.18e-11	NR	MCL2480986.1	1898206	g26909	i0	34.9	7.46127366609294	106	64	54.7	1	1	318	115	215	MCL2480986.1 30S ribosomal protein S3 [Spirochaetaceae bacterium]	diamond	4335	70.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
30900954	30900954	PRJNA565584_P_NODE_154754_length_259_cov_1.650538_g153602_i0	PRJNA565584	154754	259	1.650538	4.27489342	Treponema sp.	166	Bacteria	Bacteria	42.7	0.04	NR	MDA8424982.1	166	g153602	i0	32.1	0.972972972972973	84	55	96.1	2	4	252	24	106	MDA8424982.1 hypothetical protein [Treponema sp.]	diamond	252	42.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30995802	30995802	PRJNA565584_P_NODE_72514_length_349_cov_1.126812_g71363_i0	PRJNA565584	72514	349	1.126812	3.93257388	Spirochaetia bacterium	2053615	Bacteria	Bacteria	51.2	1.28e-4	NR	MCE9599478.1	2053615	g71363	i0	36.1	0.713467048710602	83	48	71.3	1	98	346	6	83	MCE9599478.1 aldo/keto reductase [Spirochaetia bacterium]	diamond	249	51.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
31311598	31311598	PRJNA565584_P_NODE_161355_length_255_cov_1.076923_g160203_i0	PRJNA565584	161355	255	1.076923	2.74615365	Treponema sp.	166	Bacteria	Bacteria	68.6	3.41e-11	NR	MCR5623533.1	166	g160203	i0	47.2	0.847058823529412	72	38	84.7	0	10	225	72	143	MCR5623533.1 hypothetical protein [Treponema sp.]	diamond	216	68.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
31641593	31641593	PRJNA565584_P_NODE_64936_length_368_cov_3.393220_g63785_i0	PRJNA565584	64936	368	3.39322	12.4870496	Treponema	157	Bacteria	Bacteria	67.8	9.66e-11	NR	MBR4374040.1	166	g63785	i0	48.3	0.978260869565217	60	31	48.9	0	2	181	187	246	MBR4374040.1 CAP domain-containing protein [Treponema sp.]	diamond	360	67.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
31785927	31785927	PRJNA565584_P_NODE_142577_length_267_cov_1.561856_g141425_i0	PRJNA565584	142577	267	1.561856	4.17015552	Spirochaetae bacterium HGW-Spirochaetae-3	2013835	Bacteria	Bacteria	153	5.07e-44	NR	PKL23227.1	2013835	g141425	i0	87.6	1	89	11	100	0	267	1	146	234	PKL23227.1 MAG: molybdopterin dehydrogenase [Spirochaetae bacterium HGW-Spirochaetae-3]	diamond	267	153	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetae bacterium HGW-Spirochaetae-3
31894707	31894707	PRJNA565584_P_NODE_156537_length_258_cov_1.432432_g155385_i0	PRJNA565584	156537	258	1.432432	3.69567456	Bacteria	2	Bacteria	Bacteria	47.4	0.00102	NR	MDR1252473.1	166	g155385	i0	59.5	2.18604651162791	37	15	43	0	14	124	131	167	MDR1252473.1 fibronectin type III domain-containing protein [Treponema sp.]	diamond	564	47.8	0.99163179916318	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32052932	32052932	PRJNA565584_P_NODE_204738_length_243_cov_0.905882_g203586_i0	PRJNA565584	204738	243	0.905882	2.20129326	Pseudomonadati	3379134	Bacteria	Bacteria	47	7.87e-4	NR	MCI1208542.1	166	g203586	i0	43.4	3.20987654320988	53	30	65.4	0	7	165	143	195	MCI1208542.1 ATP-dependent Clp protease proteolytic subunit [Treponema sp.]	diamond	780	47.4	0.991561181434599	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32070869	32070869	PRJNA565584_P_NODE_172938_length_250_cov_0.870056_g171786_i0	PRJNA565584	172938	250	0.870056	2.17514	Treponema sp.	166	Bacteria	Bacteria	118	7.17e-29	NR	MEL3907153.1	166	g171786	i0	69.9	0.996	83	25	99.6	0	1	249	64	146	MEL3907153.1 methyl-accepting chemotaxis protein [Treponema sp.]	diamond	249	118	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32134212	32134212	PRJNA565584_P_NODE_113858_length_286_cov_1.084507_g112706_i0	PRJNA565584	113858	286	1.084507	3.10169002	Spirochaetota bacterium	2202144	Bacteria	Bacteria	43.1	0.0242	NR	MEM7181493.1	2202144	g112706	i0	32.4	0.713286713286713	68	34	58.7	2	285	118	88	155	MEM7181493.1 hypothetical protein [Spirochaetota bacterium]	diamond	204	43.1	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32197529	32197529	PRJNA565584_P_NODE_185858_length_247_cov_1.132184_g184706_i0	PRJNA565584	185858	247	1.132184	2.79649448	Spirochaetales bacterium	2026792	Bacteria	Bacteria	104	9.76e-25	NR	MBN1697184.1	2026792	g184706	i0	56.6	10.9068825910931	76	33	92.3	0	229	2	20	95	MBN1697184.1 paraslipin [Spirochaetales bacterium]	diamond	2694	104	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
32356011	32356011	PRJNA565584_P_NODE_66239_length_365_cov_1.335616_g65088_i0	PRJNA565584	66239	365	1.335616	4.8749984	Brachyspira intermedia	84377	Bacteria	Bacteria	45.8	0.0098	NR	WP_300741451.1	84377	g65088	i0	47.9	0.764383561643836	48	24	39.5	1	210	353	20	66	WP_300741451.1 ankyrin repeat domain-containing protein [Brachyspira intermedia]	diamond	279	45.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira intermedia
32419076	32419076	PRJNA565584_P_NODE_220259_length_231_cov_2.689873_g219107_i0	PRJNA565584	220259	231	2.689873	6.21360663	Spirochaetota bacterium	2202144	Bacteria	Bacteria	124	8.35e-33	NR	HPJ41256.1	2202144	g219107	i0	81.1	0.961038961038961	74	14	96.1	0	224	3	178	251	HPJ41256.1 hypothetical protein [Spirochaetota bacterium]	diamond	222	124	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32450953	32450953	PRJNA565584_P_NODE_96679_length_304_cov_1.666667_g95527_i0	PRJNA565584	96679	304	1.666667	5.06666768	Spirochaetia bacterium	2053615	Bacteria	Bacteria	47.8	1.97e-4	NR	MFO7729640.1	2053615	g95527	i0	92.9	0.276315789473684	28	0	27.6	1	86	3	8	33	MFO7729640.1 hypothetical protein [Spirochaetia bacterium]	diamond	84	47.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
32765980	32765980	PRJNA565584_P_NODE_214140_length_241_cov_0.916667_g212988_i0	PRJNA565584	214140	241	0.916667	2.20916747	Spirochaetota bacterium	2202144	Bacteria	Bacteria	42	0.0296	NR	MCX7040941.1	2202144	g212988	i0	27.4	0.908713692946058	73	53	90.9	0	220	2	26	98	MCX7040941.1 type II toxin-antitoxin system RelE/ParE family toxin [Spirochaetota bacterium]	diamond	219	42	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32891935	32891935	PRJNA565584_P_NODE_87500_length_318_cov_0.844898_g86348_i0	PRJNA565584	87500	318	0.844898	2.68677564	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	52	4.22e-5	NR	MBK8398971.1	2026757	g86348	i0	30.6	2.83962264150943	85	54	77.4	2	299	54	211	293	MBK8398971.1 hypothetical protein [Leptospiraceae bacterium]	diamond	903	52	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae 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);;