metadata: contig_metadata: 28 rows where bioproject = "PRJNA758088", tax_kingdom = "Pseudomonadati" and tax

28 rows where bioproject = "PRJNA758088", 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
1203779	1203779	PRJNA758088_P_NODE_33421_length_817_cov_1.189516_g27487_i0	PRJNA758088	33421	817	1.189516	9.71834572	Bacteria	2	Bacteria	Bacteria	1504	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g27487	i0	99.878	114.914320685435	817	1	100	0	1	817	316484	317300	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	93885	1504	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
2478995	2478995	PRJNA758088_P_NODE_273022_length_255_cov_1.269231_g266051_i0	PRJNA758088	273022	255	1.269231	3.23653905	root	1	Root_unresolved	Root_unresolved	472	1.5e-128	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g266051	i0	100	121.941176470588	255	0	100	0	1	255	312355	312101	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	31095	472	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
5031558	5031558	PRJNA758088_P_NODE_202764_length_299_cov_1.022124_g195793_i0	PRJNA758088	202764	299	1.022124	3.05615076	Bacteria	2	Bacteria	Bacteria	553	6.25e-153	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g195793	i0	100	93.6254180602007	299	0	100	0	1	299	314682	314980	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	27994	553	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
5841165	5841165	PRJNA758088_P_NODE_339125_length_244_cov_0.900585_g332154_i0	PRJNA758088	339125	244	0.900585	2.1974274	Brachyspira pilosicoli	52584	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|2514077256\|gb\|CP098750.1\|	52584	g332154	i0	99.18	9.90983606557377	244	2	100	0	1	244	1683484	1683241	Brachyspira pilosicoli strain ZH1243 chromosome, complete genome	blastn	2418	440	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira pilosicoli
7581577	7581577	PRJNA758088_P_NODE_28266_length_909_cov_1.729665_g22821_i0	PRJNA758088	28266	909	1.729665	15.72265485	Bacteria	2	Bacteria	Bacteria	1631	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g22821	i0	99.334	92.2222222222222	901	6	99	0	1	901	322075	322975	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	83830	1642	0.993300852618758	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
8391715	8391715	PRJNA758088_P_NODE_50127_length_629_cov_1.483813_g43412_i0	PRJNA758088	50127	629	1.483813	9.33318377	Spirochaetia bacterium	2053615	Bacteria	Bacteria	154	7.77e-45	NR	MFO7729640.1	2053615	g43412	i0	93.9	0.391096979332273	82	3	39.1	1	1	246	22	101	MFO7729640.1 hypothetical protein [Spirochaetia bacterium]	diamond	246	154	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
9664653	9664653	PRJNA758088_P_NODE_241428_length_274_cov_1.149254_g234457_i0	PRJNA758088	241428	274	1.149254	3.14895596	Treponema rectale	744512	Bacteria	Bacteria	195	3.95e-45	NTclustered	gi\|1919550644\|gb\|CP031517.1\|	744512	g234457	i0	79.487	0.996350364963504	273	56	99	0	1	273	240005	240277	Treponema rectale strain CHPA chromosome, complete genome	blastn	273	195	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema rectale
9665539	9665539	PRJNA758088_P_NODE_301648_length_249_cov_0.875000_g294677_i0	PRJNA758088	301648	249	0.875	2.17875	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	167	7.709999999999999e-37	NTclustered	gi\|2621786047\|emb\|OY782505.1\|	2791017	g294677	i0	82.888	0.751004016064257	187	30	75	2	41	226	2151850	2151665	MAG: Sphaerochaetaceae bacterium isolate dbdf49c1-f841-4570-9102-cd3a9ce64f89 genome assembly, chromosome: 1	blastn	187	167	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
16037041	16037041	PRJNA758088_P_NODE_12513_length_1477_cov_9.440883_g9473_i0	PRJNA758088	12513	1477	9.440883	139.44184191	Spirochaetota bacterium	2202144	Bacteria	Bacteria	171	4.01e-37	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g9473	i0	84.27	26.451591062965495	178	25	12	3	688	863	74549	74373	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	39069	171	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
16040062	16040062	PRJNA758088_P_NODE_322193_length_246_cov_0.890173_g315222_i0	PRJNA758088	322193	246	0.890173	2.18982558	Treponema sp. OMZ 838	1539298	Bacteria	Bacteria	198	2.7e-46	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g315222	i0	82.805	11.1991869918699	221	38	90	0	1	221	164233	164453	Treponema sp. OMZ 838, complete genome	blastn	2755	198	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
16506992	16506992	PRJNA758088_P_NODE_79593_length_476_cov_1.084367_g72628_i0	PRJNA758088	79593	476	1.084367	5.16158692	Bacteria	2	Bacteria	Bacteria	880	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g72628	i0	100	95.1008403361345	476	0	100	0	1	476	320476	320951	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	45268	880	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
20330454	20330454	PRJNA758088_P_NODE_55036_length_593_cov_1.401923_g48226_i0	PRJNA758088	55036	593	1.401923	8.31340339	Bacteria	2	Bacteria	Bacteria	1090	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g48226	i0	99.831	110.414839797639	593	1	100	0	1	593	314051	314643	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	65476	1090	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
20330498	20330498	PRJNA758088_P_NODE_64496_length_538_cov_1.402151_g57567_i0	PRJNA758088	64496	538	1.402151	7.54357238	Bacteria	2	Bacteria	Bacteria	989	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g57567	i0	99.814	118.998141263941	538	1	100	0	1	538	317981	317444	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	64021	989	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
21141415	21141415	PRJNA758088_P_NODE_70117_length_512_cov_1.612756_g63164_i0	PRJNA758088	70117	512	1.612756	8.25731072	Spirochaetia bacterium	2053615	Bacteria	Bacteria	154	1.97e-45	NR	MFO7729640.1	2053615	g63164	i0	93.9	0.48046875	82	3	48	1	1	246	22	101	MFO7729640.1 hypothetical protein [Spirochaetia bacterium]	diamond	246	154	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
21606303	21606303	PRJNA758088_P_NODE_7797_length_1846_cov_1.530175_g5806_i0	PRJNA758088	7797	1846	1.530175	28.2470305	Bacteria	2	Bacteria	Bacteria	3404	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g5806	i0	99.946	81.395991332611	1846	1	100	0	1	1846	318390	320235	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	150257	3404	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
22881115	22881115	PRJNA758088_P_NODE_25118_length_979_cov_2.200883_g20016_i0	PRJNA758088	25118	979	2.200883	21.54664457	root	1	Root_unresolved	Root_unresolved	1808	0	NTclustered	gi\|1318779104\|gb\|CP019600.1\|	159	g20016	i0	100	128.73544433095	979	0	100	0	1	979	2036504	2037482	Brachyspira hyodysenteriae strain BH718 chromosome, complete genome	blastn	126032	1808	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
22881898	22881898	PRJNA758088_P_NODE_99678_length_420_cov_1.726225_g92708_i0	PRJNA758088	99678	420	1.726225	7.250145	Bacteria	2	Bacteria	Bacteria	776	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g92708	i0	100	75.0619047619048	420	0	100	0	1	420	316082	316501	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	31526	776	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
24155329	24155329	PRJNA758088_P_NODE_28779_length_899_cov_1.667070_g23276_i0	PRJNA758088	28779	899	1.66707	14.9869593	Bacteria	2	Bacteria	Bacteria	1661	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g23276	i0	100	115.202447163515	899	0	100	0	1	899	316081	315183	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	103567	1661	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
26736041	26736041	PRJNA758088_P_NODE_109621_length_400_cov_1.654434_g102651_i0	PRJNA758088	109621	400	1.654434	6.617736	Treponema sp.	166	Bacteria	Bacteria	67.4	2.25e-10	NR	MDR1307607.1	166	g102651	i0	34.6	5.2125	107	66	80.3	2	325	5	138	240	MDR1307607.1 CAP domain-containing protein [Treponema sp.]	diamond	2085	67.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
26831496	26831496	PRJNA758088_P_NODE_168081_length_327_cov_0.870079_g161110_i0	PRJNA758088	168081	327	0.870079	2.84515833	Alkalispirochaeta sp.	2024959	Bacteria	Bacteria	44.7	0.0154	NR	MFO8042912.1	2024959	g161110	i0	41.2	0.623853211009174	68	32	59.6	3	221	27	7	69	MFO8042912.1 isoprenylcysteine carboxylmethyltransferase family protein [Alkalispirochaeta sp.]	diamond	204	44.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Alkalispirochaeta	Alkalispirochaeta sp.
28000769	28000769	PRJNA758088_P_NODE_281885_length_251_cov_0.865169_g274914_i0	PRJNA758088	281885	251	0.865169	2.17157419	Treponema sp.	166	Bacteria	Bacteria	119	4.79e-31	NR	MBQ5876354.1	166	g274914	i0	68.3	0.9800796812749	82	26	98	0	249	4	103	184	MBQ5876354.1 ATP-binding protein [Treponema sp.]	diamond	246	119	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28442716	28442716	PRJNA758088_P_NODE_24066_length_1006_cov_0.884244_g19106_i0	PRJNA758088	24066	1006	0.884244	8.89549464	Spirochaetia bacterium	2053615	Bacteria	Bacteria	120	4.15e-30	NR	MFO7729640.1	2053615	g19106	i0	62.6	0.271371769383698	91	33	26.8	1	171	440	11	101	MFO7729640.1 hypothetical protein [Spirochaetia bacterium]	diamond	273	120	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
29052429	29052429	PRJNA758088_P_NODE_291128_length_250_cov_0.870056_g284157_i0	PRJNA758088	291128	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	73.9	4.18e-13	NR	MFP4152743.1	2024959	g284157	i0	43.4	6.948	83	47	99.6	0	2	250	410	492	MFP4152743.1 AMP-dependent synthetase/ligase [Alkalispirochaeta sp.]	diamond	1737	73.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Alkalispirochaeta	Alkalispirochaeta sp.
29926756	29926756	PRJNA758088_P_NODE_281511_length_251_cov_0.865169_g274540_i0	PRJNA758088	281511	251	0.865169	2.17157419	Treponema sp.	166	Bacteria	Bacteria	59.3	5.94e-8	NR	MBD5446779.1	166	g274540	i0	57.1	1.00398406374502	42	18	50.2	0	247	122	637	678	MBD5446779.1 hypothetical protein [Treponema sp.]	diamond	252	59.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30021527	30021527	PRJNA758088_P_NODE_167491_length_327_cov_1.212598_g160520_i0	PRJNA758088	167491	327	1.212598	3.96519546	Treponema sp.	166	Bacteria	Bacteria	86.7	1.91e-17	NR	MCR5061661.1	166	g160520	i0	43.1	1	109	60	99.1	2	1	324	208	315	MCR5061661.1 Ig-like domain-containing protein [Treponema sp.]	diamond	327	86.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30052850	30052850	PRJNA758088_P_NODE_204751_length_297_cov_1.946429_g197780_i0	PRJNA758088	204751	297	1.946429	5.78089413	Treponema sp.	166	Bacteria	Bacteria	79.7	4.69e-16	NR	MBR5095864.1	166	g197780	i0	37.8	0.909090909090909	90	56	90.9	0	271	2	80	169	MBR5095864.1 hypothetical protein [Treponema sp.]	diamond	270	79.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30147525	30147525	PRJNA758088_P_NODE_37292_length_762_cov_1.033382_g31078_i0	PRJNA758088	37292	762	1.033382	7.87437084	Spirochaetia bacterium	2053615	Bacteria	Bacteria	180	3.47e-50	NR	NBU97020.1	2053615	g31078	i0	49	0.779527559055118	198	98	77.6	2	597	7	228	423	NBU97020.1 hypothetical protein [Spirochaetia bacterium]	diamond	594	180	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
30843000	30843000	PRJNA758088_P_NODE_71734_length_505_cov_1.611111_g64775_i0	PRJNA758088	71734	505	1.611111	8.13611055	Spirochaetia bacterium	2053615	Bacteria	Bacteria	49.7	0.00168	NR	NBU97020.1	2053615	g64775	i0	56.1	0.243564356435644	41	15	23.2	2	433	317	386	425	NBU97020.1 hypothetical protein [Spirochaetia bacterium]	diamond	123	49.7	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);;