metadata: contig_metadata: 31 rows where bioproject = "PRJNA401346" and tax

31 rows where bioproject = "PRJNA401346" and tax_phylum = "Bacteroidota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2356514	2356514	PRJNA401346_P_NODE_1862_length_359_cov_1.738255_g1841_i0	PRJNA401346	1862	359	1.738255	6.24033545	Fluviicola	332102	Bacteria	Bacteria	562	1.27e-155	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g1841	i0	94.986	256.729805013928	359	16	100	2	1	359	707	351	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	92166	562	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
5518037	5518037	PRJNA401346_P_NODE_565_length_614_cov_2.144665_g544_i0	PRJNA401346	565	614	2.144665	13.1682431	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	800	0	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g544	i0	91.122	482.92345276873	597	44	99	6	21	614	217657	217067	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	296515	800	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
8733929	8733929	PRJNA401346_P_NODE_947_length_478_cov_1.683453_g926_i0	PRJNA401346	947	478	1.683453	8.04690534	Flavobacterium	237	Bacteria	Bacteria	822	0	NTclustered	gi\|2279330881\|gb\|CP101751.1\|	2502784	g926	i0	97.704	465.445606694561	479	10	100	1	1	478	718257	717779	Flavobacterium cerinum strain C1 chromosome, complete genome	blastn	222483	822	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
10009161	10009161	PRJNA401346_P_NODE_108_length_1266_cov_1.982573_g100_i0	PRJNA401346	108	1266	1.982573	25.09937418	Fluviicola	332102	Bacteria	Bacteria	1720	0	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g100	i0	91.287	409.650078988942	1274	92	100	14	1	1266	519	1781	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	518617	1720	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
10618141	10618141	PRJNA401346_P_NODE_3849_length_269_cov_0.923077_g3828_i0	PRJNA401346	3849	269	0.923077	2.48307713	Candidatus Pedobacter colombiensis	3121371	Bacteria	Bacteria	460	3.45e-125	NTclustered	gi\|2457514890\|gb\|CP119313.1\|	3121371	g3828	i0	99.219	328.657992565056	256	1	95	1	15	269	5517	5262	MAG: Candidatus Pedobacter colombiensis isolate MAG_3858 chromosome, complete genome	blastn	88409	460	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Candidatus Pedobacter colombiensis
10618276	10618276	PRJNA401346_P_NODE_8109_length_203_cov_0.901408_g8088_i0	PRJNA401346	8109	203	0.901408	1.82985824	Bacteroidota	976	Bacteria	Bacteria	129	5.42e-36	NR	WP_166552624.1	976	g8088	i0	100	6.10344827586207	59	0	87.2	0	2	178	119	177	WP_166552624.1 MULTISPECIES: superoxide dismutase [Bacteroidota]	diamond	1239	129	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota
12559766	12559766	PRJNA401346_P_NODE_110_length_1265_cov_1.891196_g100_i1	PRJNA401346	110	1265	1.891196	23.9236294	Fluviicola	332102	Bacteria	Bacteria	1775	0	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g100	i1	92.072	437.321739130435	1274	81	100	15	1	1265	519	1781	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	553212	1775	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
13167983	13167983	PRJNA401346_P_NODE_3591_length_276_cov_0.944186_g3570_i0	PRJNA401346	3591	276	0.944186	2.60595336	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	396	1.02e-105	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g3570	i0	92.701	545.539855072464	274	20	99	0	1	274	786304	786577	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	150569	396	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
16383484	16383484	PRJNA401346_P_NODE_1533_length_390_cov_1.167173_g1512_i0	PRJNA401346	1533	390	1.167173	4.5519747	Weeksellaceae	2762318	Bacteria	Bacteria	686	0	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g1512	i0	98.705	483.320512820513	386	5	99	0	1	386	2158283	2158668	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	188495	691	0.992764109985528	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
16991882	16991882	PRJNA401346_P_NODE_8694_length_201_cov_0.914286_g8673_i0	PRJNA401346	8694	201	0.914286	1.83771486	Pedobacter heparinus	984	Bacteria	Bacteria	171	4.6299999999999996e-38	NTclustered	gi\|255342900\|gb\|CP001681.1\|	485917	g8673	i0	86.164	0.791044776119403	159	20	79	2	44	201	1724739	1724896	Pedobacter heparinus DSM 2366, complete genome	blastn	159	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter heparinus
18265805	18265805	PRJNA401346_P_NODE_2035_length_347_cov_1.951049_g2014_i0	PRJNA401346	2035	347	1.951049	6.77014003	Flavobacterium sp. N1994	2986827	Bacteria	Bacteria	531	3.4599999999999992e-146	NTclustered	gi\|2324023692\|gb\|CP109999.1\|	2986827	g2014	i0	94.236	716.780979827089	347	20	100	0	1	347	903425	903771	Flavobacterium sp. N1994 chromosome, complete genome	blastn	248723	531	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N1994
18265956	18265956	PRJNA401346_P_NODE_755_length_530_cov_1.371002_g734_i0	PRJNA401346	755	530	1.371002	7.2663106	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	610	6.84e-170	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g734	i0	88.583	251.309433962264	508	51	95	7	1	504	359553	359049	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	133194	610	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
19540107	19540107	PRJNA401346_P_NODE_7596_length_205_cov_0.888889_g7575_i0	PRJNA401346	7596	205	0.888889	1.82222245	Chryseobacterium gambrini	373672	Bacteria	Bacteria	379	7.229999999999999e-101	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g7575	i0	100	94.8731707317073	205	0	100	0	1	205	526531	526327	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	19449	379	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
22758034	22758034	PRJNA401346_P_NODE_2738_length_307_cov_1.308943_g2717_i0	PRJNA401346	2738	307	1.308943	4.01845501	Fluviicola	332102	Bacteria	Bacteria	534	2.33e-147	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g2717	i0	98.046	268.918566775244	307	6	100	0	1	307	2461	2155	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	82558	534	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
23366229	23366229	PRJNA401346_P_NODE_1219_length_429_cov_1.437500_g1198_i0	PRJNA401346	1219	429	1.4375	6.166875	Flavobacterium channae	2897181	Bacteria	Bacteria	344	6.1e-90	NTclustered	gi\|2164478757\|gb\|CP089096.1\|	2897181	g1198	i0	88.055	362.21678321678303	293	32	68	3	103	393	486073	485782	Flavobacterium channae strain KSM-R2A30 chromosome, complete genome	blastn	155391	344	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium channae
23366236	23366236	PRJNA401346_P_NODE_1399_length_403_cov_1.061404_g1378_i0	PRJNA401346	1399	403	1.061404	4.27745812	Pedobacter sp. KACC 23697	3149230	Bacteria	Bacteria	617	3.0399999999999997e-172	NTclustered	gi\|2739540447\|gb\|CP157485.1\|	3149230	g1378	i0	95.385	376.54094292804	390	14	100	4	16	403	13949	13562	Pedobacter sp. KACC 23697 chromosome, complete genome	blastn	151746	617	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. KACC 23697
27201653	27201653	PRJNA401346_P_NODE_942_length_480_cov_1.904535_g921_i0	PRJNA401346	942	480	1.904535	9.141768	Flavobacteriia bacterium	2044941	Bacteria	Bacteria	174	1.62e-50	NR	NBO60432.1	2044941	g921	i0	56.1	16.45625	155	64	94.4	3	4	456	164	318	NBO60432.1 hypothetical protein [Flavobacteriia bacterium]	diamond	7899	174	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia				Flavobacteriia bacterium
27739174	27739174	PRJNA401346_P_NODE_3484_length_279_cov_1.761468_g3463_i0	PRJNA401346	3484	279	1.761468	4.91449572	Flavobacterium cerinum	2502784	Bacteria	Bacteria	57.8	1.09e-8	NR	WP_256550751.1	2502784	g3463	i0	90.3	0.333333333333333	31	3	33.3	0	2	94	2	32	WP_256550751.1 hypothetical protein [Flavobacterium cerinum]	diamond	93	57.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
28275451	28275451	PRJNA401346_P_NODE_2926_length_300_cov_0.928870_g2905_i0	PRJNA401346	2926	300	0.92887	2.78661	Prevotella sp.	59823	Bacteria	Bacteria	100	1.02e-24	NR	MBO4719996.1	59823	g2905	i0	65.2	0.66	66	23	66	0	248	51	71	136	MBO4719996.1 hypothetical protein [Prevotella sp.]	diamond	198	100	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
29412143	29412143	PRJNA401346_P_NODE_5609_length_223_cov_1.771605_g5588_i0	PRJNA401346	5609	223	1.771605	3.95067915	Cellulophaga sp. BC115SP	2683263	Bacteria	Bacteria	57	6.09e-8	NR	WP_166552178.1	2683263	g5588	i0	97.1	0.457399103139013	34	1	45.7	0	120	221	86	119	WP_166552178.1 hypothetical protein [Cellulophaga sp. BC115SP]	diamond	102	57	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Cellulophaga	Cellulophaga sp. BC115SP
29538447	29538447	PRJNA401346_P_NODE_1570_length_386_cov_1.378462_g1549_i0	PRJNA401346	1570	386	1.378462	5.32086332	Bacteroides sp.	29523	Bacteria	Bacteria	63.9	7.09e-9	NR	MBQ8501021.1	29523	g1549	i0	41.4	1.0880829015544	70	37	54.4	1	1	210	685	750	MBQ8501021.1 hypothetical protein [Bacteroides sp.]	diamond	420	63.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp.
29917602	29917602	PRJNA401346_P_NODE_4631_length_247_cov_2.064516_g4610_i0	PRJNA401346	4631	247	2.064516	5.09935452	Bacteroidia bacterium	2044936	Bacteria	Bacteria	111	9.35e-29	NR	TXH57036.1	2044936	g4610	i0	66.3	1.0080971659919	83	27	99.6	1	246	1	68	150	TXH57036.1 MAG: pyridoxal-phosphate dependent enzyme [Bacteroidia bacterium]	diamond	249	111	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
30138236	30138236	PRJNA401346_P_NODE_5792_length_219_cov_1.215190_g5771_i0	PRJNA401346	5792	219	1.21519	2.6612661	Bacteroidota bacterium	1898104	Bacteria	Bacteria	47.4	6.48e-4	NR	MEM9819696.1	1898104	g5771	i0	47.9	2.94520547945205	71	24	90.4	4	203	6	1169	1231	MEM9819696.1 gliding motility-associated C-terminal domain-containing protein [Bacteroidota bacterium]	diamond	645	47.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30328722	30328722	PRJNA401346_P_NODE_4512_length_250_cov_1.666667_g4491_i0	PRJNA401346	4512	250	1.666667	4.1666675	Bacteroidia bacterium	2044936	Bacteria	Bacteria	140	1.22e-40	NR	MBL7936892.1	2044936	g4491	i0	98.6	0.876	73	1	87.6	0	249	31	88	160	MBL7936892.1 50S ribosomal protein L13 [Bacteroidia bacterium]	diamond	219	140	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
30454912	30454912	PRJNA401346_P_NODE_7253_length_206_cov_0.882759_g7232_i0	PRJNA401346	7253	206	0.882759	1.81848354	Bacteroidales bacterium	2030927	Bacteria	Bacteria	87.8	1.18e-18	NR	MBO5877806.1	2030927	g7232	i0	60.3	1.98058252427184	68	27	99	0	206	3	150	217	MBO5877806.1 replication initiation protein [Bacteroidales bacterium]	diamond	408	87.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
30517766	30517766	PRJNA401346_P_NODE_3193_length_289_cov_2.245614_g3172_i0	PRJNA401346	3193	289	2.2456140000000002	6.48982446	Flammeovirgaceae bacterium	2026740	Bacteria	Bacteria	148	2.49e-44	NR	MFM7855543.1	2026740	g3172	i0	79.3	0.85121107266436	82	17	85.1	0	283	38	1	82	MFM7855543.1 50S ribosomal protein L37e [Flammeovirgaceae bacterium]	diamond	246	148	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae		Flammeovirgaceae bacterium
30707262	30707262	PRJNA401346_P_NODE_1154_length_438_cov_1.933687_g1133_i0	PRJNA401346	1154	438	1.933687	8.46954906	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	128	1.19e-35	NR	MCC6447635.1	1869212	g1133	i0	72.8	0.554794520547945	81	22	55.5	0	245	3	1	81	MCC6447635.1 hypothetical protein [Chitinophagaceae bacterium]	diamond	243	128	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
31149242	31149242	PRJNA401346_P_NODE_7055_length_207_cov_0.876712_g7034_i0	PRJNA401346	7055	207	0.876712	1.81479384	Chryseobacterium	59732	Bacteria	Bacteria	129	1.91e-37	NR	WP_116097270.1	59732	g7034	i0	100	0.985507246376812	68	0	98.6	0	2	205	2	69	WP_116097270.1 MULTISPECIES: hypothetical protein [Chryseobacterium]	diamond	204	129	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium
31655499	31655499	PRJNA401346_P_NODE_797_length_516_cov_1.184615_g776_i0	PRJNA401346	797	516	1.184615	6.1126134	Flammeovirgaceae bacterium	2026740	Bacteria	Bacteria	145	9.189999999999998e-42	NR	MFM7854286.1	2026740	g776	i0	81.3	0.465116279069767	80	15	46.5	0	2	241	11	90	MFM7854286.1 WD40 repeat domain-containing protein [Flammeovirgaceae bacterium]	diamond	240	145	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae		Flammeovirgaceae bacterium
32066843	32066843	PRJNA401346_P_NODE_5858_length_217_cov_1.814103_g5837_i0	PRJNA401346	5858	217	1.814103	3.93660351	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	47	4.43e-4	NR	HRI35345.1	2202734	g5837	i0	45.8	1.70046082949309	48	24	65	2	214	74	31	77	HRI35345.1 hypothetical protein [Saprospiraceae bacterium]	diamond	369	47	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
32778568	32778568	PRJNA401346_P_NODE_4400_length_254_cov_0.994819_g4379_i0	PRJNA401346	4400	254	0.994819	2.52684026	Flavobacteriales	200644	Bacteria	Bacteria	104	3.16e-24	NR	WP_259130942.1	687846	g4379	i0	58.3	16.7716535433071	84	35	99.2	0	252	1	107	190	WP_259130942.1 antibiotic biosynthesis monooxygenase [Chryseobacterium ginsenosidimutans]	diamond	4260	105	0.990476190476191	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium ginsenosidimutans

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