metadata: contig_metadata: 44 rows where bioproject = "PRJNA879067" and tax

44 rows where bioproject = "PRJNA879067" 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
855722	855722	PRJNA879067_P_NODE_62741_length_431_cov_2.966480_g59256_i0	PRJNA879067	62741	431	2.96648	12.7855288	Leptospira cinconiae	3235173	Bacteria	Bacteria	732	0	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g59256	i0	99.502	178.983758700696	402	2	93	0	30	431	753237	753638	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	77142	732	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
2131723	2131723	PRJNA879067_P_NODE_90402_length_297_cov_1.375000_g86916_i0	PRJNA879067	90402	297	1.375	4.08375	Brachyspira murdochii	84378	Bacteria	Bacteria	499	8.2e-137	NTclustered	gi\|296016874\|gb\|CP001959.1\|	526224	g86916	i0	99.634	1.01683501683502	273	1	92	0	25	297	514628	514900	Brachyspira murdochii DSM 12563, complete genome	blastn	302	499	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira murdochii
3404664	3404664	PRJNA879067_P_NODE_108583_length_244_cov_0.900585_g105097_i0	PRJNA879067	108583	244	0.900585	2.1974274	Brachyspira murdochii	84378	Bacteria	Bacteria	60.2	1.32e-4	NTclustered	gi\|296016874\|gb\|CP001959.1\|	526224	g105097	i0	94.737	0.418032786885246	38	2	16	0	201	238	3184156	3184119	Brachyspira murdochii DSM 12563, complete genome	blastn	102	60.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira murdochii
3405423	3405423	PRJNA879067_P_NODE_29643_length_770_cov_11.177905_g26343_i0	PRJNA879067	29643	770	11.177905	86.0698685	Spirochaetia bacterium	2053615	Bacteria	Bacteria	170	2.22e-49	NR	NCB03113.1	2053615	g26343	i0	89.2	0.397402597402597	102	11	39.7	0	306	1	59	160	NCB03113.1 hypothetical protein [Spirochaetia bacterium]	diamond	306	170	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
3790788	3790788	PRJNA879067_P_NODE_21723_length_955_cov_21.062358_g18715_i0	PRJNA879067	21723	955	21.062358	201.1455189	root	1	Root_unresolved	Root_unresolved	54.7	0.027	NTclustered	gi\|2537508579\|gb\|CP124112.1\|	64897	g18715	i0	100	0.0910994764397906	29	0	3	0	829	857	99	127	Borreliella bissettiae strain Pgeb plasmid lp54, complete sequence	blastn	87	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella bissettiae
4684270	4684270	PRJNA879067_P_NODE_71604_length_379_cov_7.196078_g68119_i0	PRJNA879067	71604	379	7.196078	27.27313562	Treponema peruense	2787628	Bacteria	Bacteria	640	6.059999999999999e-179	NTclustered	gi\|1946838279\|gb\|CP064936.1\|	2787628	g68119	i0	99.157	142.390501319261	356	1	94	2	1	355	1009822	1009468	Treponema peruense strain RCC2812 chromosome, complete genome	blastn	53966	640	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema peruense
5958791	5958791	PRJNA879067_P_NODE_58845_length_457_cov_4.216146_g55360_i0	PRJNA879067	58845	457	4.216146	19.26778722	Leptospira cinconiae	3235173	Bacteria	Bacteria	486	1.0299999999999999e-132	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g55360	i0	87.215	0.958424507658643	438	43	93	6	31	457	3490218	3489783	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	438	486	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
8509372	8509372	PRJNA879067_P_NODE_93887_length_284_cov_1.497630_g90401_i0	PRJNA879067	93887	284	1.49763	4.2532692	Leptospira cinconiae	3235173	Bacteria	Bacteria	342	1.3899999999999999e-89	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g90401	i0	90.945	0.894366197183099	254	23	89	0	3	256	39076	38823	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	254	342	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
8509434	8509434	PRJNA879067_P_NODE_95927_length_277_cov_1.465686_g92441_i0	PRJNA879067	95927	277	1.465686	4.05995022	Leptospira cinconiae	3235173	Bacteria	Bacteria	291	4.96e-74	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g92441	i0	85.56	1	277	40	100	0	1	277	3365652	3365376	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	277	291	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
8892179	8892179	PRJNA879067_P_NODE_80607_length_336_cov_2.973384_g77121_i0	PRJNA879067	80607	336	2.973384	9.99057024	Treponema	157	Bacteria	Bacteria	337	7.81e-88	NTclustered	gi\|470488561\|ref\|NR_076878.1\|	81028	g77121	i0	87.586	96.5119047619048	290	36	86	0	14	303	290	1	Treponema brennaborense strain DD5/3 23S ribosomal RNA gene, complete sequence	blastn	32428	340	0.991176470588235	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
11059302	11059302	PRJNA879067_P_NODE_6229_length_2016_cov_29.138446_g4624_i0	PRJNA879067	6229	2016	29.138446	587.43107136	Treponema denticola	158	Bacteria	Bacteria	3607	0	NTclustered	gi\|2277007739\|gb\|CP038800.1\|	158	g4624	i0	99.008	28.6666666666667	2016	15	100	4	1	2016	2050029	2052039	Treponema denticola strain ATCC 700768 chromosome, complete genome	blastn	57792	3607	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
12333386	12333386	PRJNA879067_P_NODE_20590_length_990_cov_45.406761_g17638_i0	PRJNA879067	20590	990	45.406761	449.5269339	Leptospira cinconiae	3235173	Bacteria	Bacteria	963	0	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g17638	i0	84.861	0.980808080808081	971	129	97	17	26	987	3255592	3256553	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	971	963	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
12334334	12334334	PRJNA879067_P_NODE_48150_length_540_cov_33.520343_g44672_i0	PRJNA879067	48150	540	33.520343	181.0098522	Borreliella garinii	29519	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|2646141648\|gb\|CP117840.1\|	29519	g44672	i0	100	0.0555555555555556	30	0	6	0	319	348	3935	3964	Borreliella garinii strain 17-63N1 plasmid p_cp26, complete sequence	blastn	30	56.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
12718812	12718812	PRJNA879067_P_NODE_76110_length_356_cov_4.162544_g72624_i0	PRJNA879067	76110	356	4.162544	14.81865664	Pseudomonadati	3379134	Bacteria	Bacteria	60.2	2.01e-4	NTclustered	gi\|2612877174\|gb\|CP136243.1\|	173	g72624	i0	100	40.4494382022472	32	0	9	0	325	356	2183964	2183995	Leptospira interrogans strain CUDO5 chromosome I, complete sequence	blastn	14400	60.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira interrogans
12718918	12718918	PRJNA879067_P_NODE_90110_length_298_cov_1.711111_g86624_i0	PRJNA879067	90110	298	1.711111	5.09911078	root	1	Root_unresolved	Root_unresolved	52.8	0.028	NTclustered	gi\|225213769\|gb\|CP001357.1\|	565034	g86624	i0	100	0.187919463087248	28	0	9	0	198	225	2151293	2151320	Brachyspira hyodysenteriae WA1, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
14882480	14882480	PRJNA879067_P_NODE_25172_length_863_cov_11.665823_g21997_i0	PRJNA879067	25172	863	11.665823	100.67605249	Treponema	157	Bacteria	Bacteria	147	2.74e-38	NR	WP_253689418.1	158	g21997	i0	53.7	1.27578215527231	121	56	42.1	0	374	736	161	281	WP_253689418.1 GerMN domain-containing protein [Treponema denticola]	diamond	1101	148	0.993243243243243	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
19980723	19980723	PRJNA879067_P_NODE_14036_length_1275_cov_9.971714_g11503_i0	PRJNA879067	14036	1275	9.971714	127.1393535	Leptospira saintgironsiae	2023183	Bacteria	Bacteria	177	9.84e-51	NR	WP_100711110.1	2023183	g11503	i0	76.7	0.282352941176471	120	28	28.2	0	1080	721	1	120	WP_100711110.1 hypothetical protein [Leptospira saintgironsiae]	diamond	360	177	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira saintgironsiae
19982627	19982627	PRJNA879067_P_NODE_73596_length_369_cov_2.050676_g70111_i0	PRJNA879067	73596	369	2.050676	7.56699444	Treponema peruense	2787628	Bacteria	Bacteria	244	5.389999999999999e-60	NTclustered	gi\|1946838279\|gb\|CP064936.1\|	2787628	g70111	i0	80.757	1.21138211382114	317	57	85	4	28	342	1354837	1355151	Treponema peruense strain RCC2812 chromosome, complete genome	blastn	447	244	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema peruense
22531432	22531432	PRJNA879067_P_NODE_31058_length_746_cov_6.332838_g27727_i0	PRJNA879067	31058	746	6.332838	47.24297148	Leptospira cinconiae	3235173	Bacteria	Bacteria	1168	0	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g27727	i0	95.027	72.3793565683646	744	36	99	1	1	744	2680210	2680952	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	53995	1168	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
22916864	22916864	PRJNA879067_P_NODE_71598_length_379_cov_9.258170_g68113_i0	PRJNA879067	71598	379	9.25817	35.0884643	Treponema	157	Bacteria	Bacteria	643	4.679999999999999e-180	NTclustered	gi\|2189493055\|gb\|CP091738.1\|	167	g68113	i0	100	58.3324538258575	348	0	92	0	1	348	286643	286296	MAG: Treponema succinifaciens isolate nC27_bin.114.fa chromosome	blastn	22108	643	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema succinifaciens
22916883	22916883	PRJNA879067_P_NODE_74018_length_367_cov_1.571429_g70533_i0	PRJNA879067	74018	367	1.571429	5.76714443	Sphaerochaeta	399320	Bacteria	Bacteria	326	1.86e-84	NTclustered	gi\|324025087\|gb\|CP002541.1\|	158189	g70533	i0	85.761	106.359673024523	309	42	84	2	37	344	1241515	1241822	Sphaerochaeta globosa str. Buddy, complete genome	blastn	39034	326	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta globosa
25082286	25082286	PRJNA879067_P_NODE_84680_length_319_cov_2.890244_g81194_i0	PRJNA879067	84680	319	2.890244	9.21987836	Treponema succinifaciens	167	Bacteria	Bacteria	545	1.13e-150	NTclustered	gi\|328447254\|gb\|CP002631.1\|	869209	g81194	i0	100	1.85266457680251	295	0	92	0	1	295	1050075	1049781	Treponema succinifaciens DSM 2489, complete genome	blastn	591	545	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema succinifaciens
26770436	26770436	PRJNA879067_P_NODE_36181_length_669_cov_10.414430_g32771_i0	PRJNA879067	36181	669	10.41443	69.6725367	Leptospira neocaledonica	2023192	Bacteria	Bacteria	209	2.8399999999999997e-61	NR	WP_244283330.1	2023192	g32771	i0	79.2	0.538116591928251	120	25	53.8	0	22	381	187	306	WP_244283330.1 hypothetical protein [Leptospira neocaledonica]	diamond	360	209	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira neocaledonica
26865698	26865698	PRJNA879067_P_NODE_39141_length_633_cov_4.871429_g35701_i0	PRJNA879067	39141	633	4.871429	30.83614557	Spirochaetales bacterium	2026792	Bacteria	Bacteria	271	2.17e-88	NR	MCI6115212.1	2026792	g35701	i0	99.2	0.630331753554502	133	1	63	0	233	631	1	133	MCI6115212.1 nucleoside triphosphate pyrophosphohydrolase [Spirochaetales bacterium]	diamond	399	271	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
27339892	27339892	PRJNA879067_P_NODE_88303_length_305_cov_1.327586_g84817_i0	PRJNA879067	88303	305	1.327586	4.0491373	uncultured Treponema sp.	162155	Bacteria	Bacteria	91.7	5.39e-19	NR	WP_288724535.1	162155	g84817	i0	57.1	0.757377049180328	77	33	75.7	0	233	3	1710	1786	WP_288724535.1 LPD23 domain-containing protein [uncultured Treponema sp.]	diamond	231	91.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	uncultured Treponema sp.
28413388	28413388	PRJNA879067_P_NODE_111326_length_239_cov_2.783133_g107840_i0	PRJNA879067	111326	239	2.783133	6.65168787	Leptospira saintgironsiae	2023183	Bacteria	Bacteria	155	4.44e-44	NR	WP_100711056.1	2023183	g107840	i0	93.7	0.99163179916318	79	5	99.2	0	1	237	71	149	WP_100711056.1 AI-2E family transporter [Leptospira saintgironsiae]	diamond	237	155	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira saintgironsiae
28445028	28445028	PRJNA879067_P_NODE_102146_length_254_cov_1.701657_g98660_i0	PRJNA879067	102146	254	1.701657	4.32220878	Treponema denticola	158	Bacteria	Bacteria	80.5	2.13e-15	NR	WP_255811157.1	158	g98660	i0	66	0.625984251968504	53	18	62.6	0	159	1	1	53	WP_255811157.1 hypothetical protein [Treponema denticola]	diamond	159	80.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
28760515	28760515	PRJNA879067_P_NODE_81807_length_331_cov_2.434109_g78321_i0	PRJNA879067	81807	331	2.434109	8.05690079	uncultured Treponema sp.	162155	Bacteria	Bacteria	176	8.83e-53	NR	WP_288515970.1	162155	g78321	i0	96.7	0.833836858006042	92	3	83.4	0	313	38	173	264	WP_288515970.1 tRNA (guanosine(37)-N1)-methyltransferase TrmD [uncultured Treponema sp.]	diamond	276	176	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	uncultured Treponema sp.
28886807	28886807	PRJNA879067_P_NODE_99688_length_263_cov_2.705263_g96202_i0	PRJNA879067	99688	263	2.705263	7.11484169	Leptospira fletcheri	2484981	Bacteria	Bacteria	70.9	3.6e-12	NR	WP_135766764.1	2484981	g96202	i0	69	0.479087452471483	42	13	47.9	0	261	136	9	50	WP_135766764.1 IS1595 family transposase [Leptospira fletcheri]	diamond	126	70.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira fletcheri
29486575	29486575	PRJNA879067_P_NODE_43990_length_580_cov_3.487179_g40529_i0	PRJNA879067	43990	580	3.487179	20.2256382	Treponema endosymbiont of Eucomonympha sp.	1580831	Bacteria	Bacteria	213	5.33e-65	NR	WP_228378571.1	1580831	g40529	i0	86.7	1.30344827586207	128	16	66.2	1	23	406	9	135	WP_228378571.1 HAMP domain-containing protein, partial [Treponema endosymbiont of Eucomonympha sp.]	diamond	756	213	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema endosymbiont of Eucomonympha sp.
29675939	29675939	PRJNA879067_P_NODE_84510_length_320_cov_1.781377_g81024_i0	PRJNA879067	84510	320	1.781377	5.7004064	Leptospira wolffii	409998	Bacteria	Bacteria	176	1.56e-53	NR	WP_135699651.1	409998	g81024	i0	81.2	0.946875	101	19	94.7	0	17	319	72	172	WP_135699651.1 SOS response-associated peptidase [Leptospira wolffii]	diamond	303	176	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira wolffii
30126277	30126277	PRJNA879067_P_NODE_94112_length_283_cov_2.128571_g90626_i0	PRJNA879067	94112	283	2.128571	6.02385593	Treponema	157	Bacteria	Bacteria	168	4.52e-49	NR	MEE1211719.1	166	g90626	i0	89.7	1.82332155477032	87	9	92.2	0	2	262	82	168	MEE1211719.1 hypothetical protein [Treponema sp.]	diamond	516	169	0.994082840236686	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30403260	30403260	PRJNA879067_P_NODE_74093_length_366_cov_5.068259_g70608_i0	PRJNA879067	74093	366	5.068259	18.54982794	Leptospira licerasiae	447106	Bacteria	Bacteria	204	1.4999999999999999e-58	NR	WP_135665384.1	447106	g70608	i0	92.9	0.918032786885246	112	8	91.8	0	365	30	545	656	WP_135665384.1 efflux RND transporter permease subunit [Leptospira licerasiae]	diamond	336	204	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira licerasiae
30442580	30442580	PRJNA879067_P_NODE_57253_length_468_cov_13.668354_g53768_i0	PRJNA879067	57253	468	13.668354	63.96789672	Leptospira	171	Bacteria	Bacteria	253	1.3799999999999999e-76	NR	WP_135757370.1	2484904	g53768	i0	78.8	3.73717948717949	146	31	93.6	0	468	31	245	390	WP_135757370.1 SpoIIE family protein phosphatase [Leptospira dzoumogneensis]	diamond	1749	255	0.992156862745098	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira dzoumogneensis
30687076	30687076	PRJNA879067_P_NODE_93013_length_287_cov_1.869159_g89527_i0	PRJNA879067	93013	287	1.869159	5.36448633	Leptospira dzoumogneensis	2484904	Bacteria	Bacteria	156	6.3e-42	NR	WP_135755157.1	2484904	g89527	i0	93	0.898954703832753	86	6	89.9	0	2	259	418	503	WP_135755157.1 MMPL family transporter [Leptospira dzoumogneensis]	diamond	258	156	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira dzoumogneensis
31003217	31003217	PRJNA879067_P_NODE_79914_length_339_cov_2.552632_g76428_i0	PRJNA879067	79914	339	2.552632	8.65342248	Leptospira johnsonii	1917820	Bacteria	Bacteria	182	3.0499999999999995e-54	NR	GBF40215.1	1917820	g76428	i0	95.2	0.920353982300885	104	5	92	0	337	26	8	111	GBF40215.1 putative membrane protein [Leptospira johnsonii]	diamond	312	182	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira johnsonii
31035043	31035043	PRJNA879067_P_NODE_71355_length_381_cov_1.564935_g67870_i0	PRJNA879067	71355	381	1.564935	5.96240235	Treponema endosymbiont of Eucomonympha sp.	1580831	Bacteria	Bacteria	224	2.39e-69	NR	WP_202966463.1	1580831	g67870	i0	93.3	0.937007874015748	119	8	93.7	0	357	1	259	377	WP_202966463.1 response regulator [Treponema endosymbiont of Eucomonympha sp.]	diamond	357	224	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema endosymbiont of Eucomonympha sp.
31382582	31382582	PRJNA879067_P_NODE_63116_length_429_cov_1.289326_g59631_i0	PRJNA879067	63116	429	1.289326	5.53120854	Leptospira licerasiae	447106	Bacteria	Bacteria	198	1.5299999999999998e-60	NR	WP_008594126.1	447106	g59631	i0	94.5	1.52447552447552	109	6	76.2	0	39	365	192	300	WP_008594126.1 ABC transporter permease subunit [Leptospira licerasiae]	diamond	654	198	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira licerasiae
31414152	31414152	PRJNA879067_P_NODE_88716_length_303_cov_2.552174_g85230_i0	PRJNA879067	88716	303	2.552174	7.73308722	Leptospira neocaledonica	2023192	Bacteria	Bacteria	172	6.219999999999999e-48	NR	WP_100768953.1	2023192	g85230	i0	91.6	1.88118811881188	95	8	94.1	0	1	285	219	313	WP_100768953.1 sensor histidine kinase [Leptospira neocaledonica]	diamond	570	172	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira neocaledonica
32141731	32141731	PRJNA879067_P_NODE_81678_length_332_cov_1.177606_g78192_i0	PRJNA879067	81678	332	1.177606	3.90965192	Spirochaetales bacterium	2026792	Bacteria	Bacteria	191	8.539999999999998e-55	NR	MCI6113922.1	2026792	g78192	i0	90	0.993975903614458	110	11	99.4	0	331	2	395	504	MCI6113922.1 response regulator [Spirochaetales bacterium]	diamond	330	191	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
32394926	32394926	PRJNA879067_P_NODE_79079_length_343_cov_2.007407_g75593_i0	PRJNA879067	79079	343	2.007407	6.88540601	Brevinematia bacterium	3121702	Bacteria	Bacteria	48.9	9.09e-5	NR	MFN4245853.1	3121702	g75593	i0	58.3	0.524781341107872	60	21	52.5	1	341	162	38	93	MFN4245853.1 hypothetical protein [Brevinematia bacterium]	diamond	180	48.9	1	Bacteria	Pseudomonadati	Spirochaetota	Brevinematia				Brevinematia bacterium
32592667	32592667	PRJNA879067_P_NODE_63919_length_423_cov_6.308571_g60434_i0	PRJNA879067	63919	423	6.308571	26.68525533	Leptospira	171	Bacteria	Bacteria	215	1.02e-61	NR	WP_135679645.1	2484982	g60434	i0	95.3	1.52482269503546	107	5	75.9	0	325	5	70	176	WP_135679645.1 PD40 domain-containing protein [Leptospira selangorensis]	diamond	645	215	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira selangorensis
32742156	32742156	PRJNA879067_P_NODE_22320_length_936_cov_4.427578_g19282_i0	PRJNA879067	22320	936	4.427578	41.44213008	Spirochaetes bacterium GWB1_59_5	1802176	Bacteria	Bacteria	291	5.29e-92	NR	OHD25442.1	1802176	g19282	i0	57	0.826923076923077	258	109	82.4	2	146	916	2	258	OHD25442.1 MAG: hypothetical protein A2Y38_12850 [Spirochaetes bacterium GWB1_59_5]	diamond	774	291	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium GWB1_59_5
32804919	32804919	PRJNA879067_P_NODE_33260_length_711_cov_2.855799_g29893_i0	PRJNA879067	33260	711	2.855799	20.30473089	Spirochaetota bacterium	2202144	Bacteria	Bacteria	318	2.08e-103	NR	MBP9024482.1	2202144	g29893	i0	84.6	0.713080168776371	169	26	71.3	0	173	679	1	169	MBP9024482.1 DDE-type integrase/transposase/recombinase [Spirochaetota bacterium]	diamond	507	318	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota 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);;