metadata: contig_metadata: 54 rows where bioproject = "PRJNA724011", tax_kingdom = "Pseudomonadati" and tax

54 rows where bioproject = "PRJNA724011", 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
3745602	3745602	PRJNA724011_P_NODE_37403_length_440_cov_2.918256_g36380_i0	PRJNA724011	37403	440	2.918256	12.8403264	Bacteria	2	Bacteria	Bacteria	201	2.51e-58	NR	MDA3948758.1	28185	g36380	i0	71	37.1727272727273	138	40	94.1	0	440	27	486	623	MDA3948758.1 glycoside hydrolase family 15 protein [Spirochaeta sp.]	diamond	16356	203	0.990147783251232	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta sp.
4538719	4538719	PRJNA724011_P_NODE_100164_length_247_cov_0.885057_g99141_i0	PRJNA724011	100164	247	0.885057	2.18609079	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	129	1.45e-36	NR	MCB1159828.1	2026757	g99141	i0	72.2	0.959514170040486	79	22	96	0	246	10	34	112	MCB1159828.1 peptidylprolyl isomerase [Leptospiraceae bacterium]	diamond	237	129	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
10914422	10914422	PRJNA724011_P_NODE_109069_length_241_cov_1.726190_g108046_i0	PRJNA724011	109069	241	1.72619	4.1601179	root	1	Root_unresolved	Root_unresolved	118	7.17e-29	NR	MCE9501212.1	178	g108046	i0	74.4	25.2821576763485	78	20	97.1	0	239	6	620	697	MCE9501212.1 sodium-translocating pyrophosphatase [Leptospira sp.]	diamond	6093	119	0.991596638655462	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp.
14739418	14739418	PRJNA724011_P_NODE_105092_length_244_cov_0.900585_g104069_i0	PRJNA724011	105092	244	0.900585	2.1974274	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	153	3.099999999999999e-43	NR	HBK59060.1	1898206	g104069	i0	92.6	2.95081967213115	81	6	99.6	0	244	2	163	243	HBK59060.1 methylmalonyl Co-A mutase-associated GTPase MeaB [Spirochaetaceae bacterium]	diamond	720	153	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
19837390	19837390	PRJNA724011_P_NODE_176_length_4730_cov_3.600387_g132_i0	PRJNA724011	176	4730	3.600387	170.2983051	Bacteria	2	Bacteria	Bacteria	74.7	1.75e-10	NR	MCL2480986.1	1898206	g132	i0	33.3	0.76553911205074	135	80	8.6	3	4083	4487	91	215	MCL2480986.1 30S ribosomal protein S3 [Spirochaetaceae bacterium]	diamond	3621	74.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
19837823	19837823	PRJNA724011_P_NODE_81536_length_274_cov_1.527363_g80513_i0	PRJNA724011	81536	274	1.527363	4.18497462	Leptospira mgodei	3235172	Bacteria	Bacteria	62.1	4.18e-5	NTclustered	gi\|2777195838\|gb\|CP162139.1\|	3235172	g80513	i0	92.857	0.153284671532847	42	3	15	0	199	240	3099605	3099564	Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence	blastn	42	62.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
26925568	26925568	PRJNA724011_P_NODE_39122_length_428_cov_1.056338_g38099_i0	PRJNA724011	39122	428	1.056338	4.52112664	Spirochaetia bacterium	2053615	Bacteria	Bacteria	68.2	1.72e-10	NR	GHV76060.1	2053615	g38099	i0	48.1	1.5981308411215	77	28	49.8	3	103	315	94	164	GHV76060.1 carbonic anhydrase [Spirochaetia bacterium]	diamond	684	68.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
27252145	27252145	PRJNA724011_P_NODE_81783_length_273_cov_2.800000_g80760_i0	PRJNA724011	81783	273	2.8	7.644	FCB group	1783270	Bacteria	Bacteria	130	5.83e-35	NR	WP_076489348.1	159291	g80760	i0	62.9	10.8351648351648	89	33	97.8	0	5	271	107	195	WP_076489348.1 HAD-IIA family hydrolase [Alkalispirochaeta americana]	diamond	2958	131	0.99236641221374	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Alkalispirochaeta	Alkalispirochaeta americana
27589447	27589447	PRJNA724011_P_NODE_81284_length_274_cov_3.870647_g80261_i0	PRJNA724011	81284	274	3.870647	10.60557278	Spirochaetota bacterium	2202144	Bacteria	Bacteria	53.9	6.33e-6	NR	MFH0977623.1	2202144	g80261	i0	53.1	1.01824817518248	49	19	49.3	1	270	136	60	108	MFH0977623.1 hypothetical protein [Spirochaetota bacterium]	diamond	279	53.9	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
27841766	27841766	PRJNA724011_P_NODE_83184_length_271_cov_1.161616_g82161_i0	PRJNA724011	83184	271	1.161616	3.14797936	Treponema sp.	166	Bacteria	Bacteria	50.4	1.04e-4	NR	MCL2266568.1	166	g82161	i0	58.7	0.509225092250922	46	19	50.9	0	159	22	482	527	MCL2266568.1 ankyrin repeat domain-containing protein [Treponema sp.]	diamond	138	50.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27852135	27852135	PRJNA724011_P_NODE_18744_length_684_cov_1.757774_g17739_i0	PRJNA724011	18744	684	1.757774	12.02317416	root	1	Root_unresolved	Root_unresolved	50.4	0.00209	NR	MBR6153969.1	166	g17739	i0	51	6.99122807017544	51	25	22.4	0	527	679	179	229	MBR6153969.1 LON peptidase substrate-binding domain-containing protein [Treponema sp.]	diamond	4782	50.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27904702	27904702	PRJNA724011_P_NODE_19545_length_666_cov_4.032040_g18539_i0	PRJNA724011	19545	666	4.03204	26.8533864	Treponema sp.	166	Bacteria	Bacteria	67.4	1.63e-9	NR	MBQ9205232.1	166	g18539	i0	36.9	2.23423423423423	122	70	55	2	386	21	70	184	MBQ9205232.1 CAP domain-containing protein [Treponema sp.]	diamond	1488	67.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27936672	27936672	PRJNA724011_P_NODE_36905_length_444_cov_1.746631_g35882_i0	PRJNA724011	36905	444	1.746631	7.75504164	Sphaerochaeta sp.	1972642	Bacteria	Bacteria	55.1	1.51e-5	NR	MDD3902469.1	1972642	g35882	i0	31.5	0.858108108108108	127	74	79.1	5	14	364	3	126	MDD3902469.1 FAD-dependent oxidoreductase [Sphaerochaeta sp.]	diamond	381	55.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta sp.
27936748	27936748	PRJNA724011_P_NODE_83905_length_269_cov_1.979592_g82882_i0	PRJNA724011	83905	269	1.979592	5.32510248	Spirochaetia bacterium	2053615	Bacteria	Bacteria	47	0.00132	NR	MDH5717300.1	2053615	g82882	i0	43.6	1.31598513011152	55	31	61.3	0	248	84	116	170	MDH5717300.1 tetratricopeptide repeat protein [Spirochaetia bacterium]	diamond	354	47	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
27999904	27999904	PRJNA724011_P_NODE_24825_length_569_cov_5.729839_g23809_i0	PRJNA724011	24825	569	5.729839	32.60278391	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	55.5	3.31e-5	NR	MBO5237082.1	1898206	g23809	i0	25	1.68189806678383	164	109	85.4	3	35	520	60	211	MBO5237082.1 ankyrin repeat domain-containing protein [Spirochaetaceae bacterium]	diamond	957	55.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
28062745	28062745	PRJNA724011_P_NODE_12245_length_886_cov_3.767528_g11360_i0	PRJNA724011	12245	886	3.767528	33.38029808	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	126	5.88e-32	NR	MCB1142831.1	2026757	g11360	i0	43.8	0.487584650112867	144	77	47.4	1	481	62	5	148	MCB1142831.1 DUF2062 domain-containing protein [Leptospiraceae bacterium]	diamond	432	126	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28283588	28283588	PRJNA724011_P_NODE_14186_length_813_cov_2.494595_g13255_i0	PRJNA724011	14186	813	2.494595	20.28105735	Sphaerochaeta sp.	1972642	Bacteria	Bacteria	57.8	2.07e-5	NR	MDD3902469.1	1972642	g13255	i0	32.3	0.468634686346863	127	73	43.2	5	799	449	3	126	MDD3902469.1 FAD-dependent oxidoreductase [Sphaerochaeta sp.]	diamond	381	57.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta sp.
28315537	28315537	PRJNA724011_P_NODE_44786_length_392_cov_1.369906_g43763_i0	PRJNA724011	44786	392	1.369906	5.37003152	Candidatus Ornithospirochaeta stercorigallinarum	2840898	Bacteria	Bacteria	69.7	5.74e-11	NR	HIS14589.1	2840898	g43763	i0	35	3.75765306122449	123	61	93.4	3	373	8	167	271	HIS14589.1 redox-regulated ATPase YchF [Candidatus Ornithospirochaeta stercorigallinarum]	diamond	1473	69.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Candidatus Ornithospirochaeta	Candidatus Ornithospirochaeta stercorigallinarum
28610045	28610045	PRJNA724011_P_NODE_23427_length_591_cov_4.581081_g22412_i0	PRJNA724011	23427	591	4.581081	27.07418871	Leptospira	171	Bacteria	Bacteria	48.1	0.00469	NR	WP_135762925.1	2484901	g22412	i0	25	3.06598984771574	124	79	62.9	2	500	129	2	111	WP_135762925.1 DUF6962 family protein [Leptospira ilyithenensis]	diamond	1812	48.5	0.991752577319588	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira ilyithenensis
28631384	28631384	PRJNA724011_P_NODE_16967_length_728_cov_2.157252_g15982_i0	PRJNA724011	16967	728	2.157252	15.70479456	Leptospirales bacterium	2604146	Bacteria	Bacteria	46.6	0.00983	NR	MBL8018365.1	2604146	g15982	i0	57.1	0.144230769230769	35	15	14.4	0	693	589	29	63	MBL8018365.1 cysteine rich repeat-containing protein [Leptospirales bacterium]	diamond	105	46.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales			Leptospirales bacterium
28631478	28631478	PRJNA724011_P_NODE_87267_length_263_cov_1.215789_g86244_i0	PRJNA724011	87267	263	1.215789	3.19752507	Spirochaetota bacterium	2202144	Bacteria	Bacteria	42.7	0.0448	NR	HQL81226.1	2202144	g86244	i0	37.1	0.707224334600761	62	36	67.3	1	181	5	10	71	HQL81226.1 class I SAM-dependent methyltransferase [Spirochaetota bacterium]	diamond	186	42.7	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28662850	28662850	PRJNA724011_P_NODE_16547_length_739_cov_3.893393_g15571_i0	PRJNA724011	16547	739	3.893393	28.77217427	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	74.3	6.8e-12	NR	MBK7054861.1	2026757	g15571	i0	43.2	0.450608930987821	111	59	45.1	3	739	407	126	232	MBK7054861.1 hypothetical protein [Leptospiraceae bacterium]	diamond	333	74.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28757476	28757476	PRJNA724011_P_NODE_96507_length_249_cov_1.312500_g95484_i0	PRJNA724011	96507	249	1.3125	3.268125	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	56.2	6.78e-7	NR	MBI40340.1	2026757	g95484	i0	39.3	0.734939759036145	61	37	73.5	0	248	66	38	98	MBI40340.1 cyclic nucleotide-binding protein [Leptospiraceae bacterium]	diamond	183	56.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28830917	28830917	PRJNA724011_P_NODE_111808_length_229_cov_2.871795_g110785_i0	PRJNA724011	111808	229	2.871795	6.57641055	root	1	Root_unresolved	Root_unresolved	50.4	5.85e-5	NR	MBR0031804.1	166	g110785	i0	39.1	3.20960698689956	64	39	83.8	0	227	36	268	331	MBR0031804.1 ankyrin repeat domain-containing protein [Treponema sp.]	diamond	735	50.8	0.992125984251969	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
29010496	29010496	PRJNA724011_P_NODE_50648_length_364_cov_1.020619_g49625_i0	PRJNA724011	50648	364	1.020619	3.71505316	Leptospira interrogans str. 2	173	Bacteria	Bacteria	42.4	0.0429	NR	EMM79905.1	1001590	g49625	i0	28.4	0.782967032967033	95	52	75.8	3	9	284	19	100	EMM79905.1 hypothetical protein LEP1GSC037_4770 [Leptospira interrogans str. 2006001854]	diamond	285	42.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira interrogans
29178480	29178480	PRJNA724011_P_NODE_107529_length_242_cov_1.479290_g106506_i0	PRJNA724011	107529	242	1.47929	3.5798818	root	1	Root_unresolved	Root_unresolved	55.1	1.57e-6	NR	MDR2576344.1	166	g106506	i0	50	3.3099173553719	44	22	54.5	0	241	110	322	365	MDR2576344.1 CAP domain-containing protein [Treponema sp.]	diamond	801	55.5	0.992792792792793	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
29199669	29199669	PRJNA724011_P_NODE_13429_length_840_cov_2.409387_g12512_i0	PRJNA724011	13429	840	2.409387	20.2388508	Treponema sp.	166	Bacteria	Bacteria	80.9	4.46e-13	NR	MCR5763801.1	166	g12512	i0	47.2	0.317857142857143	89	39	31.8	2	284	18	503	583	MCR5763801.1 response regulator [Treponema sp.]	diamond	267	80.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
29830966	29830966	PRJNA724011_P_NODE_41111_length_414_cov_1.568915_g40088_i0	PRJNA724011	41111	414	1.568915	6.4953081	Treponema sp.	166	Bacteria	Bacteria	52	1.26e-4	NR	MDR1787852.1	166	g40088	i0	54	0.36231884057971	50	20	36.2	1	408	259	157	203	MDR1787852.1 CAP domain-containing protein [Treponema sp.]	diamond	150	52	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
29862530	29862530	PRJNA724011_P_NODE_16931_length_729_cov_1.670732_g15948_i0	PRJNA724011	16931	729	1.670732	12.17963628	Spirochaetales bacterium	2026792	Bacteria	Bacteria	66.6	1.17e-8	NR	MBN1525752.1	2026792	g15948	i0	29	0.753086419753086	183	114	73.7	7	140	676	138	308	MBN1525752.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Spirochaetales bacterium]	diamond	549	66.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
29894264	29894264	PRJNA724011_P_NODE_100051_length_247_cov_0.885057_g99028_i0	PRJNA724011	100051	247	0.885057	2.18609079	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	64.3	9.57e-10	NR	MCB1139649.1	2026757	g99028	i0	38.6	1.0080971659919	83	50	99.6	1	2	247	249	331	MCB1139649.1 ion transporter [Leptospiraceae bacterium]	diamond	249	64.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
29925961	29925961	PRJNA724011_P_NODE_66111_length_311_cov_1.390756_g65088_i0	PRJNA724011	66111	311	1.390756	4.32525116	Spirochaetota bacterium	2202144	Bacteria	Bacteria	56.2	1.44e-6	NR	MEI6386064.1	2202144	g65088	i0	64.3	2.83601286173633	42	14	40.5	1	185	310	9	49	MEI6386064.1 FAD-dependent oxidoreductase [Spirochaetota bacterium]	diamond	882	56.2	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
30020672	30020672	PRJNA724011_P_NODE_108711_length_242_cov_0.911243_g107688_i0	PRJNA724011	108711	242	0.911243	2.20520806	Spirochaetota bacterium	2202144	Bacteria	Bacteria	65.1	1.77e-10	NR	MDH7554994.1	2202144	g107688	i0	40.6	4.73553719008264	64	38	79.3	0	50	241	132	195	MDH7554994.1 ribonuclease HI family protein [Spirochaetota bacterium]	diamond	1146	65.1	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
30188823	30188823	PRJNA724011_P_NODE_16252_length_747_cov_5.905045_g15278_i0	PRJNA724011	16252	747	5.905045	44.11068615	Spirochaetia	203692	Bacteria	Bacteria	94	2.53e-19	NR	WP_029408900.1	409322	g15278	i0	33.2	2.76305220883534	190	114	74.3	5	186	740	29	210	WP_029408900.1 CAP domain-containing protein [Treponema pedis]	diamond	2064	94	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema pedis
30209939	30209939	PRJNA724011_P_NODE_84452_length_268_cov_1.589744_g83429_i0	PRJNA724011	84452	268	1.589744	4.26051392	Brachyspira pilosicoli	52584	Bacteria	Bacteria	44.3	0.0148	NR	WP_219677442.1	52584	g83429	i0	32.5	2.49626865671642	83	55	92.9	1	267	19	678	759	WP_219677442.1 ankyrin repeat domain-containing protein [Brachyspira pilosicoli]	diamond	669	44.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira pilosicoli
30220473	30220473	PRJNA724011_P_NODE_97032_length_249_cov_0.875000_g96009_i0	PRJNA724011	97032	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	67.8	6.25e-11	NR	MBQ7167640.1	166	g96009	i0	41.7	14.1566265060241	84	44	100	2	249	1	679	758	MBQ7167640.1 leucine--tRNA ligase [Treponema sp.]	diamond	3525	67.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30252300	30252300	PRJNA724011_P_NODE_107772_length_242_cov_0.911243_g106749_i0	PRJNA724011	107772	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	46.2	0.00224	NR	OHD11179.1	1802174	g106749	i0	41.5	1.48760330578512	53	31	65.7	0	217	59	802	854	OHD11179.1 MAG: hypothetical protein A2Y41_07365 [Spirochaetes bacterium GWB1_36_13]	diamond	360	46.2	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium GWB1_36_13
30905325	30905325	PRJNA724011_P_NODE_33254_length_474_cov_1.643392_g32235_i0	PRJNA724011	33254	474	1.643392	7.78967808	Leptospira stimsonii	2202203	Bacteria	Bacteria	82.8	2.94e-15	NR	WP_167883772.1	2202203	g32235	i0	40.4	1.44303797468354	114	67	72.2	1	469	128	255	367	WP_167883772.1 ankyrin repeat domain-containing protein [Leptospira stimsonii]	diamond	684	82.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira stimsonii
31094699	31094699	PRJNA724011_P_NODE_12435_length_879_cov_1.836228_g11545_i0	PRJNA724011	12435	879	1.836228	16.14044412	Leptospira bandrabouensis	2484903	Bacteria	Bacteria	62.4	4.25e-7	NR	WP_238777145.1	2484903	g11545	i0	25.6	1.16723549488055	172	123	57	3	604	104	106	277	WP_238777145.1 ankyrin repeat domain-containing protein [Leptospira bandrabouensis]	diamond	1026	62.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira bandrabouensis
31126004	31126004	PRJNA724011_P_NODE_19495_length_667_cov_2.809764_g18489_i0	PRJNA724011	19495	667	2.809764	18.74112588	Treponema sp.	166	Bacteria	Bacteria	73.9	2.61e-11	NR	MBO7638336.1	166	g18489	i0	39	0.553223388305847	123	58	52.6	3	363	13	288	399	MBO7638336.1 response regulator [Treponema sp.]	diamond	369	73.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
31189224	31189224	PRJNA724011_P_NODE_44875_length_391_cov_2.650943_g43852_i0	PRJNA724011	44875	391	2.650943	10.36518713	Treponema sp.	166	Bacteria	Bacteria	44.3	0.0483	NR	MDR1419958.1	166	g43852	i0	32	0.790281329923274	103	65	78.3	3	345	40	82	180	MDR1419958.1 HD domain-containing protein [Treponema sp.]	diamond	309	44.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
31284311	31284311	PRJNA724011_P_NODE_15515_length_770_cov_2.355811_g14550_i0	PRJNA724011	15515	770	2.355811	18.1397447	Spirochaetales bacterium	2026792	Bacteria	Bacteria	118	6.62e-28	NR	MDC7242197.1	2026792	g14550	i0	32.7	0.798701298701299	205	136	79.9	1	759	145	67	269	MDC7242197.1 cyclic nucleotide-binding domain-containing protein [Spirochaetales bacterium]	diamond	615	118	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
31421388	31421388	PRJNA724011_P_NODE_52276_length_357_cov_1.327465_g51253_i0	PRJNA724011	52276	357	1.327465	4.73905005	root	1	Root_unresolved	Root_unresolved	156	4.57e-43	NR	MDR1506793.1	166	g51253	i0	59.5	8.84873949579832	116	47	97.5	0	8	355	124	239	MDR1506793.1 aspartate aminotransferase family protein [Treponema sp.]	diamond	3159	157	0.993630573248408	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
31537711	31537711	PRJNA724011_P_NODE_54556_length_348_cov_1.127273_g53533_i0	PRJNA724011	54556	348	1.127273	3.92291004	Spirochaetota bacterium	2202144	Bacteria	Bacteria	92.4	1.09e-19	NR	MBN1897484.1	2202144	g53533	i0	51.7	2.30172413793103	89	42	76.7	1	268	2	4	91	MBN1897484.1 histone deacetylase [Spirochaetota bacterium]	diamond	801	92.4	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31790357	31790357	PRJNA724011_P_NODE_62637_length_321_cov_1.342742_g61614_i0	PRJNA724011	62637	321	1.342742	4.31020182	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	72.8	2.52e-12	NR	HMV79507.1	2026757	g61614	i0	40.2	1.62616822429907	87	49	81.3	2	57	317	382	465	HMV79507.1 kelch repeat-containing protein [Leptospiraceae bacterium]	diamond	522	72.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
31822061	31822061	PRJNA724011_P_NODE_80257_length_277_cov_1.132353_g79234_i0	PRJNA724011	80257	277	1.132353	3.13661781	Spirochaetales bacterium	2026792	Bacteria	Bacteria	61.6	1.22e-8	NR	MBN1409614.1	2026792	g79234	i0	54.3	0.498194945848375	46	21	49.8	0	276	139	120	165	MBN1409614.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Spirochaetales bacterium]	diamond	138	61.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
31853704	31853704	PRJNA724011_P_NODE_53737_length_351_cov_1.381295_g52714_i0	PRJNA724011	53737	351	1.381295	4.84834545	Spirochaetales bacterium	2026792	Bacteria	Bacteria	56.2	2.48e-6	NR	MBQ3922691.1	2026792	g52714	i0	32.6	0.786324786324786	92	55	78.6	2	351	76	557	641	MBQ3922691.1 translation initiation factor IF-2 [Spirochaetales bacterium]	diamond	276	56.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
31948657	31948657	PRJNA724011_P_NODE_96337_length_249_cov_1.727273_g95314_i0	PRJNA724011	96337	249	1.727273	4.30090977	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	43.5	0.0208	NR	MDD4220450.1	2791017	g95314	i0	45.9	0.734939759036145	61	31	71.1	1	181	5	39	99	MDD4220450.1 leucyl aminopeptidase [Sphaerochaetaceae bacterium]	diamond	183	43.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
32012056	32012056	PRJNA724011_P_NODE_75878_length_286_cov_2.154930_g74855_i0	PRJNA724011	75878	286	2.15493	6.1630998	Spirochaetota bacterium	2202144	Bacteria	Bacteria	66.6	2.47e-10	NR	MCU0821199.1	2202144	g74855	i0	60	4.24825174825175	55	22	57.7	0	286	122	532	586	MCU0821199.1 acetate--CoA ligase [Spirochaetota bacterium]	diamond	1215	66.6	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32012057	32012057	PRJNA724011_P_NODE_76278_length_285_cov_2.636792_g75255_i0	PRJNA724011	76278	285	2.636792	7.5148572	Spirochaetales bacterium	2026792	Bacteria	Bacteria	57.8	2.58e-7	NR	MBN1524513.1	2026792	g75255	i0	43.4	0.873684210526316	83	40	87.4	2	15	263	223	298	MBN1524513.1 VWA domain-containing protein [Spirochaetales bacterium]	diamond	249	57.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
32043607	32043607	PRJNA724011_P_NODE_26398_length_548_cov_1.823158_g25382_i0	PRJNA724011	26398	548	1.823158	9.99090584	Brachyspira sp. G79	1358104	Bacteria	Bacteria	77.4	4.64e-14	NR	WP_096736838.1	1358104	g25382	i0	29.6	6.77737226277372	179	80	98	4	540	4	33	165	WP_096736838.1 guanylate kinase [Brachyspira sp. G79]	diamond	3714	77.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira sp. G79
32075312	32075312	PRJNA724011_P_NODE_7458_length_1160_cov_2.848206_g6785_i0	PRJNA724011	7458	1160	2.848206	33.0391896	Spirochaeta thermophila	154	Bacteria	Bacteria	78.2	1.79e-12	NR	WP_014625618.1	154	g6785	i0	36.5	1.03448275862069	126	71	32.1	3	576	205	2	120	WP_014625618.1 response regulator transcription factor [Spirochaeta thermophila]	diamond	1200	78.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Winmispirales	Winmispiraceae	Winmispira	Winmispira thermophila
32170368	32170368	PRJNA724011_P_NODE_1118_length_2453_cov_9.847899_g935_i0	PRJNA724011	1118	2453	9.847899	241.56896247	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	50.4	0.0244	NR	HMY67815.1	2026757	g935	i0	30.1	0.325315939665715	133	78	15.8	5	124	510	34	155	HMY67815.1 C2 family cysteine protease [Leptospiraceae bacterium]	diamond	798	50.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
32612866	32612866	PRJNA724011_P_NODE_110540_length_240_cov_2.035928_g109517_i0	PRJNA724011	110540	240	2.035928	4.8862272	Brachyspira pilosicoli	52584	Bacteria	Bacteria	43.1	0.0257	NR	WP_219711719.1	52584	g109517	i0	72	0.3125	25	7	31.3	0	6	80	1	25	WP_219711719.1 BspA family leucine-rich repeat surface protein, partial [Brachyspira pilosicoli]	diamond	75	43.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira pilosicoli
32675682	32675682	PRJNA724011_P_NODE_11980_length_898_cov_2.606061_g11099_i0	PRJNA724011	11980	898	2.606061	23.40242778	Spirochaetia bacterium	2053615	Bacteria	Bacteria	73.6	1.18e-10	NR	MBR4684268.1	2053615	g11099	i0	36.6	0.547884187082405	164	71	53.8	7	164	646	52	185	MBR4684268.1 polynucleotide adenylyltransferase PcnB [Spirochaetia bacterium]	diamond	492	73.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia 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);;