metadata: contig_metadata: 28 rows where bioproject = "PRJNA550047", tax_clade = "FCB group" and tax

28 rows where bioproject = "PRJNA550047", tax_clade = "FCB group" and tax_phylum = "Ignavibacteriota"

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
3067446	3067446	PRJNA550047_P_NODE_446163_length_248_cov_9.542857_g444191_i0	PRJNA550047	446163	248	9.542857	23.66628536	Ignavibacterium sp.	2651167	Bacteria	Bacteria	63.9	1.04e-5	NTclustered	gi\|2108406931\|gb\|CP070637.1\|	2651167	g444191	i0	100	2.02822580645161	34	0	14	0	125	158	1477381	1477348	MAG: Ignavibacterium sp. isolate bin94 chromosome	blastn	503	63.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium sp.
9443512	9443512	PRJNA550047_P_NODE_330788_length_292_cov_5.716895_g328818_i0	PRJNA550047	330788	292	5.716895	16.6933334	Bacteria	2	Bacteria	Bacteria	173	1.08e-50	NR	MBK7630925.1	2049428	g328818	i0	82.1	2.17808219178082	106	10	99.7	1	2	292	120	225	MBK7630925.1 N-acetyl-alpha-D-glucosaminyl L-malate synthase BshA [Ignavibacteriales bacterium]	diamond	636	173	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
10722410	10722410	PRJNA550047_P_NODE_593889_length_200_cov_4.456693_g591916_i0	PRJNA550047	593889	200	4.456693	8.913386	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	73.2	3.17e-14	NR	NWF88492.1	2651163	g591916	i0	52.5	0.885	59	28	88.5	0	200	24	107	165	NWF88492.1 TlpA family protein disulfide reductase [Ignavibacteriaceae bacterium]	diamond	177	73.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
15149906	15149906	PRJNA550047_P_NODE_498672_length_231_cov_4.132911_g496699_i0	PRJNA550047	498672	231	4.132911	9.54702441	Pseudomonadati	3379134	Bacteria	Bacteria	268	1.88e-67	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g496699	i0	87.879	225.679653679654	231	25	100	3	1	231	1603478	1603705	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	52132	268	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
27331195	27331195	PRJNA550047_P_NODE_66003_length_345_cov_13.242647_g64043_i0	PRJNA550047	66003	345	13.242647	45.68713215	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	65.1	1.03e-10	NR	MCB0713276.1	2026749	g64043	i0	80	0.304347826086957	35	7	30.4	0	301	197	1	35	MCB0713276.1 nuclear transport factor 2 family protein [Ignavibacteriota bacterium]	diamond	105	65.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
27551848	27551848	PRJNA550047_P_NODE_498284_length_231_cov_6.044304_g496311_i0	PRJNA550047	498284	231	6.044304	13.96234224	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	133	4.98e-34	NR	MBD1211072.1	2053306	g496311	i0	92.1	0.987012987012987	76	6	98.7	0	229	2	4706	4781	MBD1211072.1 VCBS repeat-containing protein [Ignavibacteria bacterium]	diamond	228	133	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
28120386	28120386	PRJNA550047_P_NODE_539585_length_217_cov_8.097222_g537612_i0	PRJNA550047	539585	217	8.097222	17.57097174	Ignavibacterium album	591197	Bacteria	Bacteria	110	4.600000000000001e-28	NR	WP_304043429.1	591197	g537612	i0	100	0.76036866359447	55	0	76	0	3	167	54	108	WP_304043429.1 lipoate--protein ligase family protein [Ignavibacterium album]	diamond	165	110	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium album
28214833	28214833	PRJNA550047_P_NODE_378306_length_273_cov_14.235000_g376334_i0	PRJNA550047	378306	273	14.235	38.86155	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	146	1.47e-40	NR	MBD1208444.1	2053306	g376334	i0	82.4	1	91	16	100	0	273	1	122	212	MBD1208444.1 GNAT family N-acetyltransferase [Ignavibacteria bacterium]	diamond	273	146	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
28688902	28688902	PRJNA550047_P_NODE_369587_length_277_cov_5.715686_g367616_i0	PRJNA550047	369587	277	5.715686	15.83245022	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	139	3.58e-36	NR	MCB0722442.1	2026749	g367616	i0	68.5	0.996389891696751	92	29	99.6	0	1	276	519	610	MCB0722442.1 asparagine synthase (glutamine-hydrolyzing) [Ignavibacteriota bacterium]	diamond	276	139	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
29162554	29162554	PRJNA550047_P_NODE_375589_length_274_cov_16.870647_g373617_i0	PRJNA550047	375589	274	16.870647	46.22557278	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	55.1	2.44e-6	NR	NWG26902.1	2651163	g373617	i0	38.7	1.01824817518248	93	52	96.4	1	265	2	218	310	NWG26902.1 T9SS type A sorting domain-containing protein [Ignavibacteriaceae bacterium]	diamond	279	55.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
29288519	29288519	PRJNA550047_P_NODE_497469_length_231_cov_9.746835_g495496_i0	PRJNA550047	497469	231	9.746835	22.51518885	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	155	1e-41	NR	MBN8584573.1	2053306	g495496	i0	100	0.987012987012987	76	0	98.7	0	230	3	963	1038	MBN8584573.1 FAD-dependent oxidoreductase [Ignavibacteria bacterium]	diamond	228	155	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
29320125	29320125	PRJNA550047_P_NODE_478129_length_238_cov_2.442424_g476156_i0	PRJNA550047	478129	238	2.442424	5.81296912	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	107	5.93e-25	NR	HOP50536.1	2049428	g476156	i0	98.3	0.73109243697479	58	1	73.1	0	176	3	468	525	HOP50536.1 ATP-dependent chaperone ClpB [Ignavibacteriales bacterium]	diamond	174	107	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
29541176	29541176	PRJNA550047_P_NODE_596690_length_199_cov_6.690476_g594717_i0	PRJNA550047	596690	199	6.690476	13.31404724	Ignavibacterium sp.	2651167	Bacteria	Bacteria	125	5.6e-33	NR	MDD5608654.1	2651167	g594717	i0	97	2.98492462311558	66	2	99.5	0	2	199	225	290	MDD5608654.1 flagellar hook-basal body complex protein [Ignavibacterium sp.]	diamond	594	125	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium sp.
29603988	29603988	PRJNA550047_P_NODE_351330_length_284_cov_13.526066_g349359_i0	PRJNA550047	351330	284	13.526066	38.41402744	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	166	3.6e-45	NR	MBD1209521.1	2053306	g349359	i0	87.2	0.992957746478873	94	12	99.3	0	1	282	2	95	MBD1209521.1 choice-of-anchor D domain-containing protein [Ignavibacteria bacterium]	diamond	282	166	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
29761939	29761939	PRJNA550047_P_NODE_131591_length_345_cov_5.937500_g129631_i0	PRJNA550047	131591	345	5.9375	20.484375	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	60.8	2.22e-8	NR	MDP2037175.1	2053306	g129631	i0	59	0.71304347826087	39	16	33.9	0	199	315	174	212	MDP2037175.1 ClpX C4-type zinc finger protein [Ignavibacteria bacterium]	diamond	246	60.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
30394455	30394455	PRJNA550047_P_NODE_309633_length_296_cov_5.600897_g307664_i0	PRJNA550047	309633	296	5.600897	16.57865512	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	127	1.26e-31	NR	HOP49183.1	2049428	g307664	i0	42.9	2.27027027027027	224	2	99.3	1	295	2	289	512	HOP49183.1 bifunctional aspartate kinase/homoserine dehydrogenase I [Ignavibacteriales bacterium]	diamond	672	127	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
30472075	30472075	PRJNA550047_P_NODE_509053_length_227_cov_14.844156_g507080_i0	PRJNA550047	509053	227	14.844156	33.69623412	Bacteria	2	Bacteria	Bacteria	135	1.78e-35	NR	MBK7229725.1	2049428	g507080	i0	94.7	7.9295154185022	75	4	99.1	0	225	1	371	445	MBK7229725.1 2-oxo acid dehydrogenase subunit E2 [Ignavibacteriales bacterium]	diamond	1800	136	0.992647058823529	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
30551899	30551899	PRJNA550047_P_NODE_444553_length_249_cov_1.818182_g442581_i0	PRJNA550047	444553	249	1.818182	4.52727318	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	155	1.7799999999999994e-42	NR	HOP51038.1	2049428	g442581	i0	98.7	0.951807228915663	79	1	95.2	0	12	248	56	134	HOP51038.1 hypothetical protein [Ignavibacteriales bacterium]	diamond	237	155	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
30709859	30709859	PRJNA550047_P_NODE_293034_length_298_cov_4.688889_g291065_i0	PRJNA550047	293034	298	4.688889	13.97288922	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	100	3.72e-23	NR	MBD1209698.1	2053306	g291065	i0	94	0.503355704697987	50	3	50.3	0	4	153	104	153	MBD1209698.1 alpha/beta hydrolase [Ignavibacteria bacterium]	diamond	150	100	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
30836419	30836419	PRJNA550047_P_NODE_526094_length_221_cov_18.952703_g524121_i0	PRJNA550047	526094	221	18.952703	41.88547363	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	155	3.04e-44	NR	HOP49718.1	2049428	g524121	i0	98.6	0.990950226244344	73	1	99.1	0	1	219	14	86	HOP49718.1 radical SAM family heme chaperone HemW [Ignavibacteriales bacterium]	diamond	219	155	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
31057892	31057892	PRJNA550047_P_NODE_359715_length_281_cov_6.091346_g357744_i0	PRJNA550047	359715	281	6.091346	17.11668226	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	91.3	4.72e-19	NR	HOP50152.1	2049428	g357744	i0	100	0.491103202846975	46	0	49.1	0	2	139	480	525	HOP50152.1 nucleoside recognition domain-containing protein [Ignavibacteriales bacterium]	diamond	138	91.3	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
31152032	31152032	PRJNA550047_P_NODE_592835_length_200_cov_8.653543_g590862_i0	PRJNA550047	592835	200	8.653543	17.307086	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	43.5	0.0116	NR	MBM2814435.1	2053306	g590862	i0	36.2	0.87	58	37	87	0	27	200	751	808	MBM2814435.1 hypothetical protein [Ignavibacteria bacterium]	diamond	174	43.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
31848062	31848062	PRJNA550047_P_NODE_422897_length_256_cov_9.677596_g420925_i0	PRJNA550047	422897	256	9.677596	24.77464576	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	97.4	1.97e-21	NR	MBK7630177.1	2049428	g420925	i0	82.7	0.609375	52	9	60.9	0	156	1	1	52	MBK7630177.1 phosphotransferase [Ignavibacteriales bacterium]	diamond	156	97.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
31989311	31989311	PRJNA550047_P_NODE_303238_length_297_cov_4.428571_g301269_i0	PRJNA550047	303238	297	4.428571	13.15285587	Bacteria	2	Bacteria	Bacteria	106	3.46e-24	NR	MBI2417066.1	2049428	g301269	i0	47.2	2.56565656565657	127	38	99	1	2	295	983	1109	MBI2417066.1 T9SS type A sorting domain-containing protein [Ignavibacteriales bacterium]	diamond	762	106	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
32101233	32101233	PRJNA550047_P_NODE_404878_length_263_cov_6.531579_g402906_i0	PRJNA550047	404878	263	6.531579	17.17805277	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	167	1.1399999999999999e-46	NR	MDP2363814.1	2053306	g402906	i0	93.1	2.97718631178707	87	6	99.2	0	3	263	452	538	MDP2363814.1 membrane protein insertase YidC [Ignavibacteria bacterium]	diamond	783	167	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
32337700	32337700	PRJNA550047_P_NODE_484499_length_235_cov_17.623457_g482526_i0	PRJNA550047	484499	235	17.623457	41.41512395	Bacteria	2	Bacteria	Bacteria	124	1.56e-32	NR	QKJ99851.1	2026749	g482526	i0	92.5	3.42127659574468	67	5	85.5	0	35	235	1	67	QKJ99851.1 MAG: guanosine monophosphate reductase [Ignavibacteriota bacterium]	diamond	804	125	0.992	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
32576028	32576028	PRJNA550047_P_NODE_447039_length_248_cov_5.400000_g445067_i0	PRJNA550047	447039	248	5.4	13.392	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	95.9	1.34e-23	NR	MDP3682456.1	2053306	g445067	i0	67.8	2.17741935483871	59	19	71.4	0	1	177	39	97	MDP3682456.1 glycoside hydrolase family 97 C-terminal domain-containing protein [Ignavibacteria bacterium]	diamond	540	95.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
32607216	32607216	PRJNA550047_P_NODE_293320_length_298_cov_4.417778_g291351_i0	PRJNA550047	293320	298	4.417778	13.16497844	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	73.9	7.86e-13	NR	HEY6436914.1	2651163	g291351	i0	68	0.503355704697987	50	16	50.3	0	2	151	555	604	HEY6436914.1 glycoside hydrolase family 38 C-terminal domain-containing protein [Ignavibacteriaceae bacterium]	diamond	150	73.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae 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);;