metadata: contig_metadata: 6 rows where bioproject = "PRJNA770361" and tax

6 rows where bioproject = "PRJNA770361" 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_species
27379151	27379151	PRJNA770361_P_NODE_7403_length_345_cov_1.433824_g7308_i0	PRJNA770361	7403	345	1.433824	4.9466928	Bacteria	2	Bacteria	Bacteria	82	1.92e-15	NR	OGU61300.1	1798430	g7308	i0	45.7	9.55652173913044	92	49	79.1	1	273	1	6	97	OGU61300.1 MAG: aldehyde dehydrogenase [Ignavibacteria bacterium GWF2_33_9]	diamond	3297	82.4	0.995145631067961	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria		Ignavibacteria bacterium GWF2_33_9
27527160	27527160	PRJNA770361_P_NODE_14383_length_252_cov_0.865922_g14288_i0	PRJNA770361	14383	252	0.865922	2.18212344	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	88.6	1.06e-20	NR	MCY7362321.1	2053306	g14288	i0	64.1	3	64	23	76.2	0	1	192	33	96	MCY7362321.1 decarboxylase [Ignavibacteria bacterium]	diamond	756	88.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria		Ignavibacteria bacterium
28042059	28042059	PRJNA770361_P_NODE_15725_length_249_cov_0.886364_g15630_i0	PRJNA770361	15725	249	0.886364	2.20704636	Bacteria	2	Bacteria	Bacteria	135	1.09e-38	NR	MBI5645417.1	2026749	g15630	i0	79.3	2.96385542168675	82	17	98.8	0	2	247	13	94	MBI5645417.1 OsmC family protein [Ignavibacteriota bacterium]	diamond	738	136	0.992647058823529	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota			Ignavibacteriota bacterium
29800420	29800420	PRJNA770361_P_NODE_11251_length_281_cov_1.500000_g11156_i0	PRJNA770361	11251	281	1.5	4.215	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	43.9	0.0196	NR	MCK7523973.1	2049428	g11156	i0	40	0.480427046263345	45	24	48	1	1	135	194	235	MCK7523973.1 hypothetical protein [Ignavibacteriales bacterium]	diamond	135	43.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriales bacterium
32519605	32519605	PRJNA770361_P_NODE_18159_length_244_cov_0.912281_g18064_i0	PRJNA770361	18159	244	0.912281	2.22596564	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	95.1	2.87e-23	NR	RPI66236.1	2026749	g18064	i0	50.6	4.86885245901639	79	39	97.1	0	239	3	26	104	RPI66236.1 MAG: hypothetical protein EHM43_11705, partial [Ignavibacteriota bacterium]	diamond	1188	95.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota			Ignavibacteriota bacterium
32582699	32582699	PRJNA770361_P_NODE_13639_length_253_cov_0.866667_g13544_i0	PRJNA770361	13639	253	0.866667	2.19266751	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	67.8	5.02e-11	NR	MBK6536501.1	2053306	g13544	i0	100	0.367588932806324	31	0	36.8	0	94	2	1	31	MBK6536501.1 site-2 protease family protein [Ignavibacteria bacterium]	diamond	93	67.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);;