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

4 rows where bioproject = "PRJNA756891" 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
4560400	4560400	PRJNA756891_P_NODE_12024_length_251_cov_1.426966_g11955_i0	PRJNA756891	12024	251	1.426966	3.58168466	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	87.8	5.82e-18	NR	NUN09265.1	2651163	g11955	i0	54.2	6.94422310756972	83	31	99.2	2	250	2	1716	1791	NUN09265.1 PAS domain S-box protein [Ignavibacteriaceae bacterium]	diamond	1743	87.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
27852375	27852375	PRJNA756891_P_NODE_724_length_922_cov_3.578327_g675_i0	PRJNA756891	724	922	3.578327	32.99217494	root	1	Root_unresolved	Root_unresolved	138	2.3e-33	NR	WP_014856245.1	1134405	g675	i0	35.7	15.2472885032538	280	155	86.6	12	118	915	24	292	WP_014856245.1 PQQ-dependent sugar dehydrogenase [Melioribacter roseus]	diamond	14058	139	0.992805755395683	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacter	Melioribacter roseus
28253029	28253029	PRJNA756891_P_NODE_9026_length_289_cov_2.134259_g8957_i0	PRJNA756891	9026	289	2.134259	6.16800851	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	43.5	0.0344	NR	MBK7253964.1	2053306	g8957	i0	32	1.00692041522491	97	52	86.2	2	254	6	518	614	MBK7253964.1 right-handed parallel beta-helix repeat-containing protein [Ignavibacteria bacterium]	diamond	291	43.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
32180945	32180945	PRJNA756891_P_NODE_7478_length_316_cov_1.267490_g7409_i0	PRJNA756891	7478	316	1.26749	4.0052684	Bacteria	2	Bacteria	Bacteria	196	7.660000000000001e-59	NR	HPS65444.1	2053306	g7409	i0	83.8	36.7689873417722	105	17	99.7	0	2	316	174	278	HPS65444.1 phosphoenolpyruvate carboxykinase (GTP) [Ignavibacteria bacterium]	diamond	11619	197	0.99492385786802	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);;