metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA670521" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA670521" and tax_kingdom = "Thermotogati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
5741935	5741935	PRJNA670521_P_NODE_86765_length_244_cov_0.900585_g86020_i0	PRJNA670521	86765	244	0.900585	2.1974274	Deinococcus budaensis	1665626	Bacteria	Bacteria	127	2.21e-33	NR	WP_184025918.1	1665626	g86020	i0	83.8	0.983606557377049	80	13	98.4	0	242	3	169	248	WP_184025918.1 LLM class flavin-dependent oxidoreductase [Deinococcus budaensis]	diamond	240	127	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus budaensis
28218428	28218428	PRJNA670521_P_NODE_15466_length_469_cov_0.805556_g14724_i0	PRJNA670521	15466	469	0.805556	3.77805764	Meiothermus hypogaeus	884155	Bacteria	Bacteria	44.7	0.047	NR	WP_119342060.1	884155	g14724	i0	31	0.454157782515991	71	43	41.6	1	171	365	2	72	WP_119342060.1 lysophospholipid acyltransferase family protein [Meiothermus hypogaeus]	diamond	213	44.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus hypogaeus
31978230	31978230	PRJNA670521_P_NODE_72958_length_250_cov_0.870056_g72213_i0	PRJNA670521	72958	250	0.870056	2.17514	Deinococcus aestuarii	2774531	Bacteria	Bacteria	98.6	6.84e-22	NR	WP_216328793.1	2774531	g72213	i0	63.4	0.984	82	26	98.4	1	5	250	45	122	WP_216328793.1 bifunctional UDP-N-acetylglucosamine diphosphorylase/glucosamine-1-phosphate N-acetyltransferase GlmU [Deinococcus aestuarii]	diamond	246	98.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aestuarii
32516443	32516443	PRJNA670521_P_NODE_83839_length_245_cov_0.895349_g83094_i0	PRJNA670521	83839	245	0.895349	2.19360505	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	129	8.88e-33	NR	WP_386843300.1	536443	g83094	i0	98.4	0.783673469387755	64	1	78.4	0	52	243	434	497	WP_386843300.1 hypothetical protein [Deinococcus taklimakanensis]	diamond	192	129	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis

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