metadata: contig_metadata: 63 rows where bioproject = "PRJNA557436" and tax

63 rows where bioproject = "PRJNA557436" 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
13289736	13289736	PRJNA557436_S_NODE_5511_length_178_cov_1.615385_g5463_i0	PRJNA557436	5511	178	1.615385	2.8753853	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	97.1	2.1e-22	NR	MFA6690275.1	2791017	g5463	i0	89.1	1.85393258426966	55	6	92.7	0	176	12	169	223	MFA6690275.1 site-specific DNA-methyltransferase [Sphaerochaetaceae bacterium]	diamond	330	97.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
18387597	18387597	PRJNA557436_S_NODE_5115_length_183_cov_1.493243_g5067_i0	PRJNA557436	5115	183	1.493243	2.73263469	Leptospira andrefontaineae	2484976	Bacteria	Bacteria	56.6	2.17e-7	NR	WP_135776020.1	2484976	g5067	i0	50.9	0.901639344262295	55	26	90.2	1	1	165	205	258	WP_135776020.1 hypothetical protein [Leptospira andrefontaineae]	diamond	165	56.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira andrefontaineae
25354526	25354526	PRJNA557436_S_NODE_3000_length_223_cov_1.712766_g2952_i0	PRJNA557436	3000	223	1.712766	3.81946818	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	143	3.67e-40	NR	HNA09524.1	2026757	g2952	i0	98.6	0.982062780269058	73	1	98.2	0	221	3	8	80	HNA09524.1 hypothetical protein [Leptospiraceae bacterium]	diamond	219	143	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
26603774	26603774	PRJNA557436_S_NODE_8121_length_157_cov_1.262295_g8073_i0	PRJNA557436	8121	157	1.262295	1.98180315	Turneriella sp.	2717305	Bacteria	Bacteria	43.9	0.00443	NR	HNA77841.1	2717305	g8073	i0	51	0.974522292993631	51	25	97.5	0	155	3	827	877	HNA77841.1 hypothetical protein [Turneriella sp.]	diamond	153	43.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella sp.
26762249	26762249	PRJNA557436_S_NODE_4201_length_196_cov_1.993789_g4153_i0	PRJNA557436	4201	196	1.993789	3.90782644	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	126	7.58e-36	NR	MBK9499499.1	2026757	g4153	i0	96.8	0.964285714285714	63	2	96.4	0	8	196	33	95	MBK9499499.1 hypothetical protein [Leptospiraceae bacterium]	diamond	189	126	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
26794073	26794073	PRJNA557436_S_NODE_4821_length_186_cov_2.132450_g4773_i0	PRJNA557436	4821	186	2.13245	3.966357	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	127	4.02e-36	NR	MBK9499490.1	2026757	g4773	i0	96.7	0.983870967741935	61	2	98.4	0	3	185	46	106	MBK9499490.1 hypothetical protein [Leptospiraceae bacterium]	diamond	183	127	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
26825849	26825849	PRJNA557436_S_NODE_4441_length_192_cov_1.745223_g4393_i0	PRJNA557436	4441	192	1.745223	3.35082816	Rectinema sp.	1937017	Bacteria	Bacteria	45.4	0.00215	NR	HQB08030.1	1937017	g4393	i0	37	3.1875	54	29	76.6	2	34	180	158	211	HQB08030.1 ADP-ribosyltransferase [Rectinema sp.]	diamond	612	45.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Rectinemataceae	Rectinema	Rectinema sp.
26920682	26920682	PRJNA557436_S_NODE_9582_length_150_cov_1.286957_g9534_i0	PRJNA557436	9582	150	1.286957	1.9304355	Spirochaetes bacterium GWB1_59_5	1802176	Bacteria	Bacteria	62	1.36e-9	NR	OHD17988.1	1802176	g9534	i0	56.5	0.92	46	20	92	0	12	149	58	103	OHD17988.1 MAG: hypothetical protein A2Y38_06350 [Spirochaetes bacterium GWB1_59_5]	diamond	138	62	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium GWB1_59_5
27078837	27078837	PRJNA557436_S_NODE_7062_length_164_cov_1.395349_g7014_i0	PRJNA557436	7062	164	1.395349	2.28837236	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	109	2.03e-26	NR	MBK9499492.1	2026757	g7014	i0	100	0.98780487804878	54	0	98.8	0	164	3	321	374	MBK9499492.1 hypothetical protein [Leptospiraceae bacterium]	diamond	162	109	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
27205038	27205038	PRJNA557436_S_NODE_9562_length_150_cov_1.391304_g9514_i0	PRJNA557436	9562	150	1.391304	2.086956	Spirochaetia bacterium	2053615	Bacteria	Bacteria	70.1	1.88e-12	NR	NCB03712.1	2053615	g9514	i0	62	2	50	19	100	0	150	1	54	103	NCB03712.1 hypothetical protein [Spirochaetia bacterium]	diamond	300	70.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
27331867	27331867	PRJNA557436_S_NODE_4563_length_190_cov_1.658065_g4515_i0	PRJNA557436	4563	190	1.658065	3.1503235	Spirochaetes bacterium GWB1_59_5	1802176	Bacteria	Bacteria	94.4	1e-20	NR	OHD25442.1	1802176	g4515	i0	75.8	0.978947368421053	62	15	97.9	0	1	186	291	352	OHD25442.1 MAG: hypothetical protein A2Y38_12850 [Spirochaetes bacterium GWB1_59_5]	diamond	186	94.4	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium GWB1_59_5
27331879	27331879	PRJNA557436_S_NODE_8803_length_153_cov_1.974576_g8755_i0	PRJNA557436	8803	153	1.974576	3.02110128	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	67	6.34e-12	NR	HMW08754.1	2026757	g8755	i0	74.4	0.843137254901961	43	11	84.3	0	139	11	131	173	HMW08754.1 hypothetical protein [Leptospiraceae bacterium]	diamond	129	67	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
27395097	27395097	PRJNA557436_S_NODE_8843_length_153_cov_1.567797_g8795_i0	PRJNA557436	8843	153	1.567797	2.39872941	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	43.1	0.00257	NR	MBK9499503.1	2026757	g8795	i0	72.4	0.568627450980392	29	8	56.9	0	65	151	1	29	MBK9499503.1 hypothetical protein [Leptospiraceae bacterium]	diamond	87	43.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
27521156	27521156	PRJNA557436_S_NODE_8923_length_153_cov_1.186441_g8875_i0	PRJNA557436	8923	153	1.186441	1.81525473	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	59.7	1.16e-8	NR	HNA10320.1	2026757	g8875	i0	52	0.980392156862745	50	24	98	0	150	1	1450	1499	HNA10320.1 hypothetical protein [Leptospiraceae bacterium]	diamond	150	59.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
27868386	27868386	PRJNA557436_S_NODE_3765_length_204_cov_2.088757_g3717_i0	PRJNA557436	3765	204	2.088757	4.26106428	Spirochaetota bacterium	2202144	Bacteria	Bacteria	50.8	3.07e-5	NR	TXH11508.1	2202144	g3717	i0	46.3	0.794117647058823	54	29	79.4	0	13	174	231	284	TXH11508.1 MAG: hypothetical protein E6R04_02675 [Spirochaetota bacterium]	diamond	162	50.8	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
27931663	27931663	PRJNA557436_S_NODE_1285_length_322_cov_2.452962_g1237_i0	PRJNA557436	1285	322	2.452962	7.89853764	Spirochaetia bacterium	2053615	Bacteria	Bacteria	82.8	4.26e-18	NR	NBU99057.1	2053615	g1237	i0	52.7	0.68944099378882	74	35	68.9	0	224	3	19	92	NBU99057.1 hypothetical protein [Spirochaetia bacterium]	diamond	222	82.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
27931667	27931667	PRJNA557436_S_NODE_2505_length_240_cov_1.492683_g2457_i0	PRJNA557436	2505	240	1.492683	3.5824392	Leptospira interrogans	173	Bacteria	Bacteria	52.4	1.4e-5	NR	WP_061226151.1	173	g2457	i0	33.3	1.125	90	47	96.3	2	232	2	144	233	WP_061226151.1 phage portal protein [Leptospira interrogans]	diamond	270	52.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira interrogans
27963232	27963232	PRJNA557436_S_NODE_8285_length_156_cov_1.305785_g8237_i0	PRJNA557436	8285	156	1.305785	2.0370246	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	74.7	5.22e-16	NR	MBK8396180.1	2026757	g8237	i0	66.7	0.923076923076923	48	16	92.3	0	1	144	17	64	MBK8396180.1 hypothetical protein [Leptospiraceae bacterium]	diamond	144	74.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28026472	28026472	PRJNA557436_S_NODE_1845_length_274_cov_2.719665_g1797_i0	PRJNA557436	1845	274	2.719665	7.4518821	Spirochaetota bacterium	2202144	Bacteria	Bacteria	52.4	2.07e-6	NR	TXH11435.1	2202144	g1797	i0	79.3	0.317518248175182	29	6	31.8	0	2	88	67	95	TXH11435.1 MAG: hypothetical protein E6R04_02295 [Spirochaetota bacterium]	diamond	87	52.4	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28247248	28247248	PRJNA557436_S_NODE_5406_length_179_cov_2.347222_g5358_i0	PRJNA557436	5406	179	2.347222	4.20152738	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	98.6	6.83e-25	NR	MBK9499490.1	2026757	g5358	i0	80.7	0.955307262569832	57	11	95.5	0	177	7	48	104	MBK9499490.1 hypothetical protein [Leptospiraceae bacterium]	diamond	171	98.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28342160	28342160	PRJNA557436_S_NODE_6946_length_165_cov_1.176923_g6898_i0	PRJNA557436	6946	165	1.176923	1.94192295	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	90.1	2.08e-19	NR	MBK9499492.1	2026757	g6898	i0	84.6	0.945454545454545	52	8	94.5	0	157	2	23	74	MBK9499492.1 hypothetical protein [Leptospiraceae bacterium]	diamond	156	90.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28419515	28419515	PRJNA557436_S_NODE_8446_length_155_cov_1.550000_g8398_i0	PRJNA557436	8446	155	1.55	2.4025	Leptospira	171	Bacteria	Bacteria	46.6	3.68e-4	NR	WP_017850419.1	173	g8398	i0	66.7	1.16129032258065	30	10	58.1	0	3	92	68	97	WP_017850419.1 hypothetical protein [Leptospira interrogans]	diamond	180	47	0.991489361702128	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira interrogans
28545919	28545919	PRJNA557436_S_NODE_2687_length_233_cov_1.530303_g2639_i0	PRJNA557436	2687	233	1.530303	3.56560599	root	1	Root_unresolved	Root_unresolved	141	9.66e-38	NR	HMW08365.1	2026757	g2639	i0	85.7	2.97424892703863	77	11	99.1	0	233	3	365	441	HMW08365.1 baseplate J/gp47 family protein [Leptospiraceae bacterium]	diamond	693	141	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28626476	28626476	PRJNA557436_S_NODE_5507_length_178_cov_1.650350_g5459_i0	PRJNA557436	5507	178	1.65035	2.937623	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	53.1	2.97e-7	NR	MBK8396135.1	2026757	g5459	i0	54	0.842696629213483	50	23	84.3	0	154	5	29	78	MBK8396135.1 hypothetical protein [Leptospiraceae bacterium]	diamond	150	53.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28657990	28657990	PRJNA557436_S_NODE_3367_length_213_cov_1.567416_g3319_i0	PRJNA557436	3367	213	1.567416	3.33859608	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	130	4.98e-34	NR	MBK7057051.1	2026757	g3319	i0	98.6	0.985915492957746	70	1	98.6	0	3	212	210	279	MBK7057051.1 DUF1073 domain-containing protein [Leptospiraceae bacterium]	diamond	210	130	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28689657	28689657	PRJNA557436_S_NODE_3187_length_218_cov_1.726776_g3139_i0	PRJNA557436	3187	218	1.726776	3.76437168	Spirochaetota bacterium	2202144	Bacteria	Bacteria	45.1	0.0027	NR	TXH08891.1	2202144	g3139	i0	51.6	0.426605504587156	31	15	42.7	0	208	116	148	178	TXH08891.1 MAG: hypothetical protein E6R04_09795 [Spirochaetota bacterium]	diamond	93	45.1	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28783986	28783986	PRJNA557436_S_NODE_607_length_451_cov_2.161058_g559_i0	PRJNA557436	607	451	2.161058	9.74637158	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	206	1.71e-63	NR	HNN81708.1	2026757	g559	i0	81.6	1.6629711751663	125	23	83.1	0	392	18	1	125	HNN81708.1 DUF2213 domain-containing protein [Leptospiraceae bacterium]	diamond	750	206	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28783987	28783987	PRJNA557436_S_NODE_6427_length_169_cov_1.395522_g6379_i0	PRJNA557436	6427	169	1.395522	2.35843218	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	93.6	1.34e-20	NR	HMW08386.1	2026757	g6379	i0	86	0.887573964497041	50	7	88.8	0	3	152	428	477	HMW08386.1 terminase family protein [Leptospiraceae bacterium]	diamond	150	93.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28815454	28815454	PRJNA557436_S_NODE_3768_length_204_cov_1.940828_g3720_i0	PRJNA557436	3768	204	1.940828	3.95928912	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	68.2	9.37e-12	NR	HRG49191.1	2026757	g3720	i0	91.9	0.544117647058823	37	3	54.4	0	202	92	209	245	HRG49191.1 hypothetical protein [Leptospiraceae bacterium]	diamond	111	68.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28878773	28878773	PRJNA557436_S_NODE_6908_length_165_cov_1.476923_g6860_i0	PRJNA557436	6908	165	1.476923	2.43692295	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	54.3	4.41e-8	NR	MBK8393640.1	2026757	g6860	i0	61.9	0.763636363636364	42	16	76.4	0	38	163	17	58	MBK8393640.1 hypothetical protein [Leptospiraceae bacterium]	diamond	126	54.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28910141	28910141	PRJNA557436_S_NODE_4728_length_187_cov_2.467105_g4680_i0	PRJNA557436	4728	187	2.467105	4.61348635	Sphaerochaeta sp.	1972642	Bacteria	Bacteria	49.3	7.64e-5	NR	MCK9598329.1	1972642	g4680	i0	36.7	0.786096256684492	49	31	78.6	0	7	153	48	96	MCK9598329.1 hypothetical protein [Sphaerochaeta sp.]	diamond	147	49.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta sp.
29051024	29051024	PRJNA557436_S_NODE_9408_length_151_cov_1.077586_g9360_i0	PRJNA557436	9408	151	1.077586	1.62715486	root	1	Root_unresolved	Root_unresolved	58.5	2.83e-8	NR	MFA7167479.1	2791017	g9360	i0	56.8	4.74834437086093	44	19	87.4	0	20	151	549	592	MFA7167479.1 hypothetical protein [Sphaerochaetaceae bacterium]	diamond	717	58.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
29068487	29068487	PRJNA557436_S_NODE_5928_length_173_cov_3.014493_g5880_i0	PRJNA557436	5928	173	3.014493	5.21507289	Spirochaetota bacterium	2202144	Bacteria	Bacteria	43.5	0.00769	NR	TXH11508.1	2202144	g5880	i0	54.5	0.763005780346821	44	19	76.3	1	173	42	62	104	TXH11508.1 MAG: hypothetical protein E6R04_02675 [Spirochaetota bacterium]	diamond	132	43.5	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
29099980	29099980	PRJNA557436_S_NODE_2008_length_264_cov_2.048035_g1960_i0	PRJNA557436	2008	264	2.048035	5.4068124	Spirochaetota bacterium	2202144	Bacteria	Bacteria	47	0.00163	NR	TXH11437.1	2202144	g1960	i0	34.8	1.01136363636364	89	53	96.6	2	264	10	630	717	TXH11437.1 MAG: hypothetical protein E6R04_02305 [Spirochaetota bacterium]	diamond	267	47	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
29163307	29163307	PRJNA557436_S_NODE_7749_length_159_cov_1.709677_g7701_i0	PRJNA557436	7749	159	1.709677	2.71838643	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	75.9	8.82e-16	NR	MBK9499508.1	2026757	g7701	i0	69.2	0.981132075471698	52	16	98.1	0	2	157	29	80	MBK9499508.1 hypothetical protein [Leptospiraceae bacterium]	diamond	156	75.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
29257543	29257543	PRJNA557436_S_NODE_8909_length_153_cov_1.237288_g8861_i0	PRJNA557436	8909	153	1.237288	1.89305064	uncultured Treponema sp.	162155	Bacteria	Bacteria	44.7	0.00211	NR	WP_307771091.1	162155	g8861	i0	58.8	1.47058823529412	34	14	66.7	0	15	116	128	161	WP_307771091.1 hypothetical protein [uncultured Treponema sp.]	diamond	225	44.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	uncultured Treponema sp.
29510230	29510230	PRJNA557436_S_NODE_2210_length_254_cov_1.337900_g2162_i0	PRJNA557436	2210	254	1.3379	3.398266	Leptospira interrogans	173	Bacteria	Bacteria	49.3	2.06e-4	NR	WP_061226151.1	173	g2162	i0	37.8	0.968503937007874	82	36	83.9	3	238	26	68	145	WP_061226151.1 phage portal protein [Leptospira interrogans]	diamond	246	49.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira interrogans
29541837	29541837	PRJNA557436_S_NODE_8050_length_157_cov_1.983607_g8002_i0	PRJNA557436	8050	157	1.983607	3.11426299	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	103	2.0299999999999998e-24	NR	MBP7284242.1	2026757	g8002	i0	98	3.89808917197452	51	1	97.5	0	155	3	18	68	MBP7284242.1 replication protein [Leptospiraceae bacterium]	diamond	612	103	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
29573335	29573335	PRJNA557436_S_NODE_6790_length_166_cov_1.496183_g6742_i0	PRJNA557436	6790	166	1.496183	2.48366378	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	97.4	4.73e-22	NR	MBK9499492.1	2026757	g6742	i0	82.7	1.87951807228916	52	9	94	0	9	164	273	324	MBK9499492.1 hypothetical protein [Leptospiraceae bacterium]	diamond	312	97.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
29825955	29825955	PRJNA557436_S_NODE_4031_length_199_cov_1.701220_g3983_i0	PRJNA557436	4031	199	1.70122	3.3854278	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	121	1.25e-33	NR	MBP7284253.1	2026757	g3983	i0	89.1	0.964824120603015	64	7	96.5	0	199	8	16	79	MBP7284253.1 hypothetical protein [Leptospiraceae bacterium]	diamond	192	121	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
30047059	30047059	PRJNA557436_S_NODE_6091_length_172_cov_1.525547_g6043_i0	PRJNA557436	6091	172	1.525547	2.62394084	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	67.8	6.56e-13	NR	HNN81047.1	2026757	g6043	i0	73.8	1.46511627906977	42	11	73.3	0	170	45	66	107	HNN81047.1 hypothetical protein [Leptospiraceae bacterium]	diamond	252	67.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
30078689	30078689	PRJNA557436_S_NODE_1712_length_284_cov_1.823293_g1664_i0	PRJNA557436	1712	284	1.823293	5.17815212	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	117	9.55e-30	NR	HMW08384.1	2026757	g1664	i0	75	1.43661971830986	68	17	71.8	0	5	208	243	310	HMW08384.1 minor capsid protein [Leptospiraceae bacterium]	diamond	408	117	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
30204949	30204949	PRJNA557436_S_NODE_9472_length_150_cov_2.321739_g9424_i0	PRJNA557436	9472	150	2.321739	3.4826085	Spirochaetota bacterium	2202144	Bacteria	Bacteria	47	3.28e-4	NR	TXG81565.1	2202144	g9424	i0	53.8	0.78	39	18	78	0	118	2	407	445	TXG81565.1 MAG: hypothetical protein E6R13_06085 [Spirochaetota bacterium]	diamond	117	47	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
30458380	30458380	PRJNA557436_S_NODE_4993_length_184_cov_2.362416_g4945_i0	PRJNA557436	4993	184	2.362416	4.34684544	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	112	6.33e-28	NR	MBK7057053.1	2026757	g4945	i0	100	1.76086956521739	54	0	88	0	23	184	68	121	MBK7057053.1 hypothetical protein [Leptospiraceae bacterium]	diamond	324	112	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
30521137	30521137	PRJNA557436_S_NODE_3773_length_204_cov_1.727811_g3725_i0	PRJNA557436	3773	204	1.727811	3.52473444	Leptospira andrefontaineae	2484976	Bacteria	Bacteria	42.4	0.0301	NR	WP_135775963.1	2484976	g3725	i0	39.2	0.75	51	31	75	0	155	3	35	85	WP_135775963.1 hypothetical protein [Leptospira andrefontaineae]	diamond	153	42.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira andrefontaineae
30521140	30521140	PRJNA557436_S_NODE_4833_length_186_cov_1.980132_g4785_i0	PRJNA557436	4833	186	1.980132	3.68304552	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	92	1.44e-21	NR	HNN81036.1	2026757	g4785	i0	85.2	0.870967741935484	54	8	87.1	0	162	1	1	54	HNN81036.1 hypothetical protein [Leptospiraceae bacterium]	diamond	162	92	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
30552613	30552613	PRJNA557436_S_NODE_2953_length_224_cov_2.370370_g2905_i0	PRJNA557436	2953	224	2.37037	5.3096288	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	157	7.61e-45	NR	MBK7057053.1	2026757	g2905	i0	100	1.98214285714286	74	0	99.1	0	224	3	147	220	MBK7057053.1 hypothetical protein [Leptospiraceae bacterium]	diamond	444	157	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
30566558	30566558	PRJNA557436_S_NODE_5713_length_176_cov_1.106383_g5665_i0	PRJNA557436	5713	176	1.106383	1.94723408	Leptospira	171	Bacteria	Bacteria	52	8.06e-6	NR	WP_075918725.1	28183	g5665	i0	46.4	3.81818181818182	56	30	95.5	0	1	168	266	321	WP_075918725.1 hypothetical protein [Leptospira santarosai]	diamond	672	52	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira santarosai
30678961	30678961	PRJNA557436_S_NODE_5373_length_180_cov_1.310345_g5325_i0	PRJNA557436	5373	180	1.310345	2.358621	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	92	1.91e-20	NR	HNN81045.1	2026757	g5325	i0	84.9	0.883333333333333	53	8	88.3	0	178	20	131	183	HNN81045.1 DUF2184 domain-containing protein [Leptospiraceae bacterium]	diamond	159	92	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
30805563	30805563	PRJNA557436_S_NODE_5974_length_173_cov_1.637681_g5926_i0	PRJNA557436	5974	173	1.637681	2.83318813	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	114	3.5099999999999993e-31	NR	MBK7057054.1	2026757	g5926	i0	100	1.97687861271676	57	0	98.8	0	3	173	46	102	MBK7057054.1 hypothetical protein [Leptospiraceae bacterium]	diamond	342	114	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
30977738	30977738	PRJNA557436_S_NODE_2294_length_250_cov_1.627907_g2246_i0	PRJNA557436	2294	250	1.627907	4.0697675	root	1	Root_unresolved	Root_unresolved	53.5	6.11e-6	NR	OHD25441.1	1802176	g2246	i0	70.3	0.84	37	11	44.4	0	3	113	478	514	OHD25441.1 MAG: terminase [Spirochaetes bacterium GWB1_59_5]	diamond	210	53.5	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium GWB1_59_5
31089883	31089883	PRJNA557436_S_NODE_5735_length_175_cov_2.392857_g5687_i0	PRJNA557436	5735	175	2.392857	4.18749975	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	97.4	1.71e-22	NR	HNN81045.1	2026757	g5687	i0	87.3	0.942857142857143	55	5	90.9	1	17	175	201	255	HNN81045.1 DUF2184 domain-containing protein [Leptospiraceae bacterium]	diamond	165	97.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
31184391	31184391	PRJNA557436_S_NODE_3035_length_222_cov_1.711230_g2987_i0	PRJNA557436	3035	222	1.71123	3.7989306	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	146	4.209999999999999e-40	NR	MBK7057051.1	2026757	g2987	i0	97.3	1	74	2	100	0	222	1	350	423	MBK7057051.1 DUF1073 domain-containing protein [Leptospiraceae bacterium]	diamond	222	146	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
31279423	31279423	PRJNA557436_S_NODE_755_length_408_cov_1.949062_g707_i0	PRJNA557436	755	408	1.949062	7.95217296	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	208	4.97e-63	NR	HNA09502.1	2026757	g707	i0	75.6	0.992647058823529	135	33	99.3	0	407	3	127	261	HNA09502.1 DUF1073 domain-containing protein [Leptospiraceae bacterium]	diamond	405	208	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
31532765	31532765	PRJNA557436_S_NODE_436_length_527_cov_2.402439_g392_i0	PRJNA557436	436	527	2.402439	12.66085353	Spirochaetota bacterium	2202144	Bacteria	Bacteria	48.1	0.00363	NR	TXH10286.1	2202144	g392	i0	51	0.278937381404175	49	22	27.9	1	149	3	55	101	TXH10286.1 MAG: hypothetical protein E6R04_05805 [Spirochaetota bacterium]	diamond	147	48.1	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31817125	31817125	PRJNA557436_S_NODE_3657_length_207_cov_1.110465_g3609_i0	PRJNA557436	3657	207	1.110465	2.29866255	Spirochaetes bacterium GWB1_59_5	1802176	Bacteria	Bacteria	45.8	0.00112	NR	OHD23650.1	1802176	g3609	i0	48.9	0.681159420289855	47	22	65.2	1	73	207	19	65	OHD23650.1 MAG: hypothetical protein A2Y38_23415 [Spirochaetes bacterium GWB1_59_5]	diamond	141	45.8	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium GWB1_59_5
32323840	32323840	PRJNA557436_S_NODE_6979_length_164_cov_2.759690_g6931_i0	PRJNA557436	6979	164	2.75969	4.5258916	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	65.9	8.88e-11	NR	MCB1180341.1	2026757	g6931	i0	57.8	0.823170731707317	45	19	82.3	0	137	3	419	463	MCB1180341.1 hypothetical protein [Leptospiraceae bacterium]	diamond	135	65.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
32481819	32481819	PRJNA557436_S_NODE_6259_length_170_cov_1.985185_g6211_i0	PRJNA557436	6259	170	1.985185	3.3748145	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	50.8	1.93e-5	NR	HNC55866.1	2026757	g6211	i0	58.8	0.6	34	14	60	0	2	103	583	616	HNC55866.1 hypothetical protein [Leptospiraceae bacterium]	diamond	102	50.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
32670887	32670887	PRJNA557436_S_NODE_5400_length_179_cov_2.784722_g5352_i0	PRJNA557436	5400	179	2.784722	4.98465238	Spirochaetota bacterium	2202144	Bacteria	Bacteria	69.7	1.63e-12	NR	TXH11504.1	2202144	g5352	i0	56.9	1.94413407821229	58	25	97.2	0	2	175	164	221	TXH11504.1 MAG: hypothetical protein E6R04_02655 [Spirochaetota bacterium]	diamond	348	69.7	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32702387	32702387	PRJNA557436_S_NODE_2180_length_255_cov_3.200000_g2132_i0	PRJNA557436	2180	255	3.2	8.16	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	71.6	1.59e-13	NR	HNC57047.1	2026757	g2132	i0	47.5	0.941176470588235	80	35	87.1	3	14	235	56	134	HNC57047.1 NUDIX hydrolase [Leptospiraceae bacterium]	diamond	240	71.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
32702392	32702392	PRJNA557436_S_NODE_3920_length_201_cov_1.716867_g3872_i0	PRJNA557436	3920	201	1.716867	3.45090267	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	131	3.27e-34	NR	MBP7284245.1	2026757	g3872	i0	95.5	0.985074626865672	66	3	98.5	0	3	200	66	131	MBP7284245.1 hypothetical protein [Leptospiraceae bacterium]	diamond	198	131	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
32734137	32734137	PRJNA557436_S_NODE_7520_length_161_cov_1.055556_g7472_i0	PRJNA557436	7520	161	1.055556	1.69944516	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	46.2	6.52e-5	NR	MBP7284250.1	2026757	g7472	i0	61.8	0.633540372670807	34	13	63.4	0	105	4	9	42	MBP7284250.1 hypothetical protein [Leptospiraceae bacterium]	diamond	102	46.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
32828534	32828534	PRJNA557436_S_NODE_8020_length_157_cov_2.729508_g7972_i0	PRJNA557436	8020	157	2.729508	4.28532756	Leptospira andrefontaineae	2484976	Bacteria	Bacteria	58.2	4.71e-9	NR	WP_135776011.1	2484976	g7972	i0	49	0.936305732484076	49	25	93.6	0	1	147	7	55	WP_135776011.1 hypothetical protein [Leptospira andrefontaineae]	diamond	147	58.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira andrefontaineae

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