metadata: contig_metadata: 25 rows where bioproject = "PRJNA1120203", tax_kingdom = "Pseudomonadati" and tax

25 rows where bioproject = "PRJNA1120203", 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
1028045	1028045	PRJNA1120203_P_NODE_66301_length_276_cov_1.517241_g65285_i0	PRJNA1120203	66301	276	1.517241	4.18758516	Bacteria	2	Bacteria	Bacteria	510	3.48e-140	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g65285	i0	100	107.673913043478	276	0	100	0	1	276	317046	317321	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	29718	510	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
2302969	2302969	PRJNA1120203_P_NODE_28062_length_451_cov_1.648148_g27047_i0	PRJNA1120203	28062	451	1.648148	7.43314748	Bacteria	2	Bacteria	Bacteria	833	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g27047	i0	100	127.483370288248	451	0	100	0	1	451	313438	313888	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	57495	833	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
4856004	4856004	PRJNA1120203_P_NODE_67584_length_273_cov_1.925000_g66568_i0	PRJNA1120203	67584	273	1.925	5.25525	root	1	Root_unresolved	Root_unresolved	505	1.6e-138	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g66568	i0	100	133.655677655678	273	0	100	0	1	273	312429	312701	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	36488	505	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
6130715	6130715	PRJNA1120203_P_NODE_48245_length_325_cov_1.920635_g47229_i0	PRJNA1120203	48245	325	1.920635	6.24206375	Treponema	157	Bacteria	Bacteria	595	1.1299999999999995e-165	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g47229	i0	99.692	182.249230769231	325	1	100	0	1	325	2078265	2077941	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	59231	595	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
7405423	7405423	PRJNA1120203_P_NODE_16006_length_698_cov_2.166400_g15029_i0	PRJNA1120203	16006	698	2.1664	15.121472	Treponema	157	Bacteria	Bacteria	1223	0	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g15029	i0	98.283	197.116045845272	699	10	100	2	1	698	2078507	2079204	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	137587	1234	0.991085899513776	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
7405597	7405597	PRJNA1120203_P_NODE_41186_length_355_cov_1.287234_g40171_i0	PRJNA1120203	41186	355	1.287234	4.5696807	Bacteria	2	Bacteria	Bacteria	651	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g40171	i0	99.718	79.0647887323944	355	1	100	0	1	355	321214	320860	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	28068	651	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
8681270	8681270	PRJNA1120203_P_NODE_74047_length_259_cov_1.650538_g73031_i0	PRJNA1120203	74047	259	1.650538	4.27489342	root	1	Root_unresolved	Root_unresolved	479	9.13e-131	NTclustered	gi\|1318779104\|gb\|CP019600.1\|	159	g73031	i0	100	129	259	0	100	0	1	259	2036890	2036632	Brachyspira hyodysenteriae strain BH718 chromosome, complete genome	blastn	33411	479	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
13028701	13028701	PRJNA1120203_P_NODE_48331_length_325_cov_1.222222_g47315_i0	PRJNA1120203	48331	325	1.222222	3.9722215	Treponema succinifaciens	167	Bacteria	Bacteria	403	7.32e-108	NTclustered	gi\|2189493055\|gb\|CP091738.1\|	167	g47315	i0	89.164	2.84923076923077	323	35	99	0	1	323	2297394	2297716	MAG: Treponema succinifaciens isolate nC27_bin.114.fa chromosome	blastn	926	403	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema succinifaciens
13781181	13781181	PRJNA1120203_P_NODE_56771_length_299_cov_1.588496_g55755_i0	PRJNA1120203	56771	299	1.588496	4.74960304	Bacteria	2	Bacteria	Bacteria	547	2.9099999999999987e-151	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g55755	i0	99.666	101	299	1	100	0	1	299	320007	319709	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	30199	547	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
16330531	16330531	PRJNA1120203_P_NODE_73233_length_261_cov_1.356383_g72217_i0	PRJNA1120203	73233	261	1.356383	3.54015963	Treponema	157	Bacteria	Bacteria	191	4.83e-44	NTclustered	gi\|2265193197\|gb\|CP058347.1\|	158	g72217	i0	93.75	45.9693486590038	128	7	49	1	135	261	1119137	1119010	Treponema denticola strain OKA3 chromosome, complete genome	blastn	11998	191	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
17605644	17605644	PRJNA1120203_P_NODE_61014_length_288_cov_1.339535_g59998_i0	PRJNA1120203	61014	288	1.339535	3.8578608	Bacteria	2	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g59998	i0	100	89.8680555555556	288	0	100	0	1	288	320507	320220	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	25882	532	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
18879547	18879547	PRJNA1120203_P_NODE_57775_length_296_cov_1.919283_g56759_i0	PRJNA1120203	57775	296	1.919283	5.68107768	Treponema	157	Bacteria	Bacteria	350	8.700000000000001e-92	NTclustered	gi\|1928027651\|gb\|CP061839.1\|	409322	g56759	i0	88.136	184.851351351351	295	34	99	1	1	295	389097	389390	Treponema pedis strain KS1 chromosome, complete genome	blastn	54716	350	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema pedis
18879869	18879869	PRJNA1120203_P_NODE_98355_length_243_cov_2.264706_g97339_i0	PRJNA1120203	98355	243	2.264706	5.50323558	Bacteria	2	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g97339	i0	100	63.3456790123457	243	0	100	0	1	243	316286	316044	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	15393	449	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
20154269	20154269	PRJNA1120203_P_NODE_50236_length_319_cov_1.252033_g49220_i0	PRJNA1120203	50236	319	1.252033	3.99398527	Bacteria	2	Bacteria	Bacteria	590	5.1299999999999986e-164	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g49220	i0	100	106.974921630094	319	0	100	0	1	319	314306	313988	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	34125	590	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
21429569	21429569	PRJNA1120203_P_NODE_16717_length_672_cov_1.532554_g15731_i0	PRJNA1120203	16717	672	1.532554	10.29876288	Bacteria	2	Bacteria	Bacteria	1230	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g15731	i0	99.702	106.989583333333	672	2	100	0	1	672	322284	322955	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	71897	1242	0.990338164251208	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
21429691	21429691	PRJNA1120203_P_NODE_35277_length_389_cov_1.218354_g34262_i0	PRJNA1120203	35277	389	1.218354	4.73939706	Bacteria	2	Bacteria	Bacteria	719	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g34262	i0	100	82.7095115681234	389	0	100	0	1	389	316689	316301	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	32174	719	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
23227501	23227501	PRJNA1120203_P_NODE_68639_length_271_cov_1.474747_g67623_i0	PRJNA1120203	68639	271	1.474747	3.99656437	Treponema parvum	138851	Bacteria	Bacteria	285	2.25e-72	NTclustered	gi\|2023447176\|gb\|CP054142.1\|	138851	g67623	i0	86.142	189.970479704797	267	33	97	4	1	264	452815	452550	Treponema parvum strain ATCC 700770 chromosome, complete genome	blastn	51482	285	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema parvum
23979969	23979969	PRJNA1120203_P_NODE_32559_length_409_cov_1.693452_g31544_i0	PRJNA1120203	32559	409	1.693452	6.92621868	Bacteria	2	Bacteria	Bacteria	756	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g31544	i0	100	63.0146699266504	409	0	100	0	1	409	314704	315112	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	25773	756	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
23980145	23980145	PRJNA1120203_P_NODE_49879_length_320_cov_1.732794_g48863_i0	PRJNA1120203	49879	320	1.732794	5.5449408	Treponema	157	Bacteria	Bacteria	575	1.44e-159	NTclustered	gi\|2265193197\|gb\|CP058347.1\|	158	g48863	i0	99.062	116.75625	320	3	100	0	1	320	1666317	1665998	Treponema denticola strain OKA3 chromosome, complete genome	blastn	37362	575	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
28112265	28112265	PRJNA1120203_P_NODE_97745_length_244_cov_0.900585_g96729_i0	PRJNA1120203	97745	244	0.900585	2.1974274	Spirochaetia bacterium	2053615	Bacteria	Bacteria	108	1.46e-25	NR	MFP4385519.1	2053615	g96729	i0	60	0.983606557377049	80	32	98.4	0	240	1	188	267	MFP4385519.1 extracellular solute-binding protein [Spirochaetia bacterium]	diamond	240	108	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
28206901	28206901	PRJNA1120203_P_NODE_95466_length_245_cov_0.895349_g94450_i0	PRJNA1120203	95466	245	0.895349	2.19360505	Spirochaetota bacterium	2202144	Bacteria	Bacteria	119	1.42e-30	NR	HOS40595.1	2202144	g94450	i0	65.4	0.991836734693878	81	28	99.2	0	1	243	217	297	HOS40595.1 SGNH/GDSL hydrolase family protein [Spirochaetota bacterium]	diamond	243	119	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
29490796	29490796	PRJNA1120203_P_NODE_78750_length_251_cov_0.865169_g77734_i0	PRJNA1120203	78750	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	73.2	1.69e-14	NR	HNJ05950.1	2026757	g77734	i0	100	1.29083665338645	36	0	43	0	249	142	78	113	HNJ05950.1 polysaccharide deacetylase family protein [Leptospiraceae bacterium]	diamond	324	73.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
29722331	29722331	PRJNA1120203_P_NODE_97550_length_244_cov_0.900585_g96534_i0	PRJNA1120203	97550	244	0.900585	2.1974274	Spirochaetia bacterium	2053615	Bacteria	Bacteria	87.4	2.57e-19	NR	MDA3939969.1	2053615	g96534	i0	51.9	0.995901639344262	81	39	99.6	0	1	243	65	145	MDA3939969.1 NUDIX hydrolase [Spirochaetia bacterium]	diamond	243	87.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
30670330	30670330	PRJNA1120203_P_NODE_79873_length_251_cov_0.865169_g78857_i0	PRJNA1120203	79873	251	0.865169	2.17157419	uncultured Brachyspira sp.	221953	Bacteria	Bacteria	149	8.99e-41	NR	WP_288695409.1	221953	g78857	i0	97.6	0.99203187250996006	83	2	99.2	0	2	250	302	384	WP_288695409.1 lipopolysaccharide biosynthesis protein [uncultured Brachyspira sp.]	diamond	249	149	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	uncultured Brachyspira sp.
32693680	32693680	PRJNA1120203_P_NODE_58820_length_293_cov_2.350000_g57804_i0	PRJNA1120203	58820	293	2.35	6.8855	Treponema sp. OMZ 855	1643512	Bacteria	Bacteria	45.1	0.00324	NR	WP_253673698.1	1643512	g57804	i0	72	0.255972696245734	25	7	25.6	0	153	227	100	124	WP_253673698.1 Bbp16 family capsid cement protein [Treponema sp. OMZ 855]	diamond	75	45.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 855

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