metadata: contig_metadata: 4 rows where bioproject = "PRJNA1166865" and tax

4 rows where bioproject = "PRJNA1166865" 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
14341649	14341649	PRJNA1166865_P_NODE_35392_length_364_cov_1.587629_g35151_i0	PRJNA1166865	35392	364	1.587629	5.77896956	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	58.5	4.15e-7	NR	HEY5536461.1	2053306	g35151	i0	59.1	0.725274725274725	44	18	36.3	0	232	363	38	81	HEY5536461.1 C39 family peptidase [Ignavibacteria bacterium]	diamond	264	58.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
28619743	28619743	PRJNA1166865_P_NODE_77387_length_250_cov_0.870056_g77146_i0	PRJNA1166865	77387	250	0.870056	2.17514	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	53.5	6.7e-6	NR	HPI36860.1	2651163	g77146	i0	37.3	0.996	83	41	99.6	2	250	2	490	561	HPI36860.1 FkbM family methyltransferase [Ignavibacteriaceae bacterium]	diamond	249	53.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
29661067	29661067	PRJNA1166865_P_NODE_87510_length_245_cov_0.895349_g87269_i0	PRJNA1166865	87510	245	0.895349	2.19360505	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	66.6	1.5e-10	NR	MBI2416483.1	2049428	g87269	i0	41.5	4.3469387755102	65	38	79.6	0	206	12	738	802	MBI2416483.1 T9SS type A sorting domain-containing protein [Ignavibacteriales bacterium]	diamond	1065	66.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
30451451	30451451	PRJNA1166865_P_NODE_17353_length_515_cov_1.219457_g17112_i0	PRJNA1166865	17353	515	1.219457	6.28020355	Ignavibacterium sp.	2651167	Bacteria	Bacteria	75.5	2.36e-12	NR	MEJ5261863.1	2651167	g17112	i0	30.1	0.966990291262136	166	107	93.8	5	7	489	214	375	MEJ5261863.1 T9SS type A sorting domain-containing protein [Ignavibacterium sp.]	diamond	498	75.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium sp.

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