metadata: contig_metadata: 5 rows where bioproject = "PRJEB75230" and tax

5 rows where bioproject = "PRJEB75230" 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
27981847	27981847	PRJEB75230_P_NODE_116705_length_251_cov_1.730337_g116523_i0	PRJEB75230	116705	251	1.730337	4.34314587	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	68.2	2.21e-11	NR	HOI30057.1	2614255	g116523	i0	69.6	0.549800796812749	46	14	55	0	109	246	9	54	HOI30057.1 SDR family oxidoreductase [Melioribacteraceae bacterium]	diamond	138	68.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
31045621	31045621	PRJEB75230_P_NODE_62655_length_296_cov_1.659193_g62473_i0	PRJEB75230	62655	296	1.659193	4.91121128	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	43.5	0.0346	NR	MBI3587084.1	2049428	g62473	i0	33.3	0.942567567567568	93	43	82.1	2	273	31	248	333	MBI3587084.1 homocysteine S-methyltransferase family protein [Ignavibacteriales bacterium]	diamond	279	43.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
31234720	31234720	PRJEB75230_P_NODE_1675_length_1002_cov_3.538213_g1538_i0	PRJEB75230	1675	1002	3.538213	35.45289426	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	180	3.3e-50	NR	MAT57736.1	2026749	g1538	i0	35.3	1.83832335329341	306	171	91.6	4	4	921	24	302	MAT57736.1 fatty acid desaturase [Ignavibacteriota bacterium]	diamond	1842	180	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
31551406	31551406	PRJEB75230_P_NODE_109896_length_256_cov_1.404372_g109714_i0	PRJEB75230	109896	256	1.404372	3.59519232	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	64.7	7.72e-10	NR	MCX6158926.1	2026749	g109714	i0	45.2	1.72265625	73	38	85.5	1	255	37	341	411	MCX6158926.1 ammonium transporter [Ignavibacteriota bacterium]	diamond	441	64.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
31740802	31740802	PRJEB75230_P_NODE_145497_length_247_cov_0.885057_g145315_i0	PRJEB75230	145497	247	0.885057	2.18609079	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	42.4	0.0489	NR	MFI5144091.1	2053306	g145315	i0	37.3	0.910931174089069	75	42	87.4	3	7	222	18	90	MFI5144091.1 DUF5131 family protein [Ignavibacteria bacterium]	diamond	225	42.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);;