metadata: contig_metadata: 10 rows where bioproject = "PRJNA743294" and tax

10 rows where bioproject = "PRJNA743294" 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_species
1998253	1998253	PRJNA743294_P_NODE_7542_length_570_cov_1.595573_g7090_i0	PRJNA743294	7542	570	1.595573	9.0947661	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	195	1.6400000000000002e-58	NR	NUM70300.1	2651163	g7090	i0	71.8	3.51578947368421	131	36	68.9	1	50	442	1	130	NUM70300.1 cysteine synthase A [Ignavibacteriaceae bacterium]	diamond	2004	195	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
27495038	27495038	PRJNA743294_P_NODE_33603_length_289_cov_2.277778_g33147_i0	PRJNA743294	33603	289	2.277778	6.58277842	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	43.1	0.0476	NR	MCX7874762.1	2614255	g33147	i0	29.3	0.85121107266436	82	51	77.9	2	50	274	400	481	MCX7874762.1 carboxy terminal-processing peptidase [Melioribacteraceae bacterium]	diamond	246	43.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
27694802	27694802	PRJNA743294_P_NODE_54624_length_244_cov_0.912281_g54168_i0	PRJNA743294	54624	244	0.912281	2.22596564	Pseudomonadati	3379134	Bacteria	Bacteria	44.7	0.00596	NR	MBK8550991.1	2053306	g54168	i0	47.7	3.89754098360656	44	23	54.1	0	21	152	104	147	MBK8550991.1 tetratricopeptide repeat protein [Ignavibacteria bacterium]	diamond	951	44.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
28158311	28158311	PRJNA743294_P_NODE_4605_length_708_cov_4.344882_g4185_i0	PRJNA743294	4605	708	4.344882	30.76176456	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	116	3.05e-28	NR	MBN8571020.1	2053306	g4185	i0	46.7	0.516949152542373	122	65	51.7	0	3	368	23	144	MBN8571020.1 glycosyltransferase [Ignavibacteria bacterium]	diamond	366	116	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
29610147	29610147	PRJNA743294_P_NODE_7990_length_555_cov_2.487552_g7535_i0	PRJNA743294	7990	555	2.487552	13.8059136	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	172	4.56e-51	NR	MBN8571020.1	2053306	g7535	i0	51	0.805405405405405	149	73	80.5	0	109	555	45	193	MBN8571020.1 glycosyltransferase [Ignavibacteria bacterium]	diamond	447	172	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
30337466	30337466	PRJNA743294_P_NODE_57292_length_239_cov_2.331325_g56836_i0	PRJNA743294	57292	239	2.331325	5.57186675	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	87.4	4.83e-19	NR	MCB0745511.1	2026749	g56836	i0	56.6	0.95397489539749	76	32	95.4	1	235	8	146	220	MCB0745511.1 hypothetical protein [Ignavibacteriota bacterium]	diamond	228	87.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
30463759	30463759	PRJNA743294_P_NODE_22273_length_346_cov_2.054945_g21817_i0	PRJNA743294	22273	346	2.054945	7.1101097	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	55.1	2.97e-6	NR	MCU0413637.1	2651163	g21817	i0	51.1	1.03179190751445	45	22	39	0	243	109	168	212	MCU0413637.1 carbonate dehydratase [Ignavibacteriaceae bacterium]	diamond	357	55.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
30526514	30526514	PRJNA743294_P_NODE_4533_length_713_cov_4.970313_g4118_i0	PRJNA743294	4533	713	4.970313	35.43833169	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	133	8.31e-34	NR	MCX6164492.1	2026749	g4118	i0	36.6	0.94249649368864	224	129	90.9	6	657	10	33	251	MCX6164492.1 serine hydrolase [Ignavibacteriota bacterium]	diamond	672	133	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
31221452	31221452	PRJNA743294_P_NODE_51695_length_247_cov_0.896552_g51239_i0	PRJNA743294	51695	247	0.896552	2.21448344	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	47.4	8.93e-4	NR	MBI5404520.1	2026749	g51239	i0	56.3	1.16599190283401	32	14	38.9	0	218	123	74	105	MBI5404520.1 S9 family peptidase [Ignavibacteriota bacterium]	diamond	288	47.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
31885802	31885802	PRJNA743294_P_NODE_23437_length_338_cov_4.652830_g22981_i0	PRJNA743294	23437	338	4.65283	15.7265654	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	50.4	2e-4	NR	HMS35124.1	2053306	g22981	i0	28.9	1.38461538461538	83	59	73.7	0	72	320	269	351	HMS35124.1 META domain-containing protein [Ignavibacteria bacterium]	diamond	468	50.4	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);;