metadata: contig_metadata: 13 rows where bioproject = "PRJNA560932", tax_clade = "FCB group" and tax

13 rows where bioproject = "PRJNA560932", 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
13298544	13298544	PRJNA560932_P_NODE_15731_length_442_cov_2.501355_g15376_i0	PRJNA560932	15731	442	2.501355	11.0559891	Bacteria	2	Bacteria	Bacteria	160	1.45e-46	NR	MCB0727610.1	2026749	g15376	i0	65.5	5.79638009049774	113	33	72.6	1	407	87	26	138	MCB0727610.1 peptide-methionine (S)-S-oxide reductase MsrA [Ignavibacteriota bacterium]	diamond	2562	160	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
22221819	22221819	PRJNA560932_P_NODE_4578_length_800_cov_4.154058_g4264_i0	PRJNA560932	4578	800	4.154058	33.232464	Chlorobi bacterium OLB4	1617411	Bacteria	Bacteria	421	8.55e-142	NR	KXK04718.1	1617411	g4264	i0	74.5	14.0175	267	66	99.8	2	3	800	122	387	KXK04718.1 MAG: Phosphoenolpyruvate carboxykinase (GTP) [Chlorobi bacterium OLB4]	diamond	11214	421	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Candidatus Tepidiaquacellales			Candidatus Tepidiaquacellales bacterium OLB4/UTCHB1
27458383	27458383	PRJNA560932_P_NODE_12323_length_498_cov_1.082353_g11969_i0	PRJNA560932	12323	498	1.082353	5.39011794	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	115	2.83e-26	NR	HOP49568.1	2049428	g11969	i0	50	1.46385542168675	124	59	72.9	2	134	496	2	125	HOP49568.1 molecular chaperone HtpG [Ignavibacteriales bacterium]	diamond	729	115	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
27836960	27836960	PRJNA560932_P_NODE_12104_length_502_cov_2.149184_g11750_i0	PRJNA560932	12104	502	2.149184	10.78890368	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	76.6	9.45e-13	NR	KAB2907579.1	2651163	g11750	i0	35.4	4.99003984063745	164	102	96.2	3	494	12	1135	1297	KAB2907579.1 MAG: choice-of-anchor A family protein [Ignavibacteriaceae bacterium]	diamond	2505	76.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
27837003	27837003	PRJNA560932_P_NODE_36804_length_300_cov_0.907489_g36448_i0	PRJNA560932	36804	300	0.907489	2.722467	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	65.5	7.19e-10	NR	MDP3445727.1	2053306	g36448	i0	30.3	0.99	99	69	99	0	297	1	146	244	MDP3445727.1 hypothetical protein [Ignavibacteria bacterium]	diamond	297	65.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
28166931	28166931	PRJNA560932_P_NODE_30345_length_327_cov_3.023622_g29989_i0	PRJNA560932	30345	327	3.023622	9.88724394	Bacteria	2	Bacteria	Bacteria	161	1.19e-47	NR	MCB0727610.1	2026749	g29989	i0	67.3	6.52293577981651	104	34	95.4	0	327	16	40	143	MCB0727610.1 peptide-methionine (S)-S-oxide reductase MsrA [Ignavibacteriota bacterium]	diamond	2133	161	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
29019657	29019657	PRJNA560932_P_NODE_60568_length_245_cov_1.110465_g60212_i0	PRJNA560932	60568	245	1.110465	2.72063925	Pseudomonadati	3379134	Bacteria	Bacteria	87.4	6.26e-18	NR	HEY5533600.1	2053306	g60212	i0	53.1	3.95510204081633	81	37	99.2	1	243	1	121	200	HEY5533600.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Ignavibacteria bacterium]	diamond	969	87.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
29699583	29699583	PRJNA560932_P_NODE_3570_length_895_cov_1.547445_g3290_i0	PRJNA560932	3570	895	1.547445	13.84963275	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	59.7	1.65e-6	NR	MCX6134544.1	2049428	g3290	i0	42.1	1.01899441340782	95	51	30.8	4	509	234	113	206	MCX6134544.1 ankyrin repeat domain-containing protein [Ignavibacteriales bacterium]	diamond	912	59.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
30363846	30363846	PRJNA560932_P_NODE_65552_length_242_cov_0.911243_g65196_i0	PRJNA560932	65552	242	0.911243	2.20520806	Ignavibacterium album	591197	Bacteria	Bacteria	73.9	3.8e-13	NR	WP_304129753.1	591197	g65196	i0	46.7	2.78925619834711	75	38	90.5	1	223	5	888	962	WP_304129753.1 ATP-binding protein [Ignavibacterium album]	diamond	675	73.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium album
31121288	31121288	PRJNA560932_P_NODE_34095_length_311_cov_1.273109_g33739_i0	PRJNA560932	34095	311	1.273109	3.95936899	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	99	8.64e-22	NR	MBI3194498.1	2026749	g33739	i0	51.5	2.91318327974277	101	43	97.4	1	8	310	183	277	MBI3194498.1 Glu/Leu/Phe/Val dehydrogenase [Ignavibacteriota bacterium]	diamond	906	99	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
31166925	31166925	PRJNA560932_P_NODE_19015_length_403_cov_3.136364_g18659_i0	PRJNA560932	19015	403	3.136364	12.63954692	Pseudomonadati	3379134	Bacteria	Bacteria	68.2	5.75e-11	NR	OGU74326.1	1798433	g18659	i0	33.3	4.18362282878412	129	83	96	2	393	7	3	128	OGU74326.1 MAG: hypothetical protein A2V93_04945 [Ignavibacteria bacterium RBG_16_34_14]	diamond	1686	68.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium RBG_16_34_14
32133958	32133958	PRJNA560932_P_NODE_47698_length_264_cov_1.518325_g47342_i0	PRJNA560932	47698	264	1.518325	4.008378	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	135	2.71e-35	NR	MBK6292019.1	2053306	g47342	i0	78.2	9.96590909090909	87	18	97.7	1	263	6	167	253	MBK6292019.1 aldehyde dehydrogenase [Ignavibacteria bacterium]	diamond	2631	135	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
32671083	32671083	PRJNA560932_P_NODE_38700_length_292_cov_1.406393_g38344_i0	PRJNA560932	38700	292	1.406393	4.10666756	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	99.8	2.41e-22	NR	MBV6479055.1	2053306	g38344	i0	52.1	3.83219178082192	94	42	93.5	1	7	279	205	298	MBV6479055.1 hypothetical protein [Ignavibacteria bacterium]	diamond	1119	99.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria 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);;