metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1253698" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1253698" and tax_phylum = "Bacillota"

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
27547735	27547735	PRJNA1253698_S_NODE_10084_length_217_cov_0.922619_g9718_i0	PRJNA1253698	10084	217	0.922619	2.00208323	Clostridiales bacterium	1898207	Bacteria	Bacteria	94	2.01e-20	NR	HHT97153.1	1898207	g9718	i0	63.9	0.995391705069124	72	26	99.5	0	1	216	307	378	HHT97153.1 Flp pilus assembly complex ATPase component TadA [Clostridiales bacterium]	diamond	216	94	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
28115973	28115973	PRJNA1253698_S_NODE_23265_length_162_cov_0.920354_g22899_i0	PRJNA1253698	23265	162	0.920354	1.49097348	Streptococcus sp. DORA_1	1306	Bacteria	Bacteria	91.3	3.03e-20	NR	ETI96549.1	1403937	g22899	i0	100	0.981481481481482	53	0	98.1	0	161	3	15	67	ETI96549.1 MAG: Brp/Blh family beta-carotene 15,15'-monooxygenase, partial [Streptococcus sp. DORA_10]	diamond	159	91.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. DORA_10
28670855	28670855	PRJNA1253698_S_NODE_10287_length_215_cov_1.030120_g9921_i0	PRJNA1253698	10287	215	1.03012	2.214758	Bacillati	1783272	Bacteria	Bacteria	102	1.8499999999999998e-23	NR	HHT97924.1	1898207	g9921	i0	69	1.98139534883721	71	22	99.1	0	2	214	689	759	HHT97924.1 DEAD/DEAH box helicase [Clostridiales bacterium]	diamond	426	102	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
31274465	31274465	PRJNA1253698_S_NODE_17875_length_169_cov_0.866667_g17509_i0	PRJNA1253698	17875	169	0.866667	1.46466723	Jeotgalicoccus aerolatus	709510	Bacteria	Bacteria	113	7.8e-29	NR	WP_092599687.1	709510	g17509	i0	100	0.976331360946746	55	0	97.6	0	4	168	56	110	WP_092599687.1 VOC family protein [Jeotgalicoccus aerolatus]	diamond	165	113	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Jeotgalicoccus	Jeotgalicoccus aerolatus
32823460	32823460	PRJNA1253698_S_NODE_9620_length_222_cov_1.167630_g9254_i0	PRJNA1253698	9620	222	1.16763	2.5921386	Clostridiales bacterium	1898207	Bacteria	Bacteria	81.3	7.32e-16	NR	HHT97136.1	1898207	g9254	i0	56.8	1	74	31	98.6	1	2	220	289	362	HHT97136.1 CpaF family protein [Clostridiales bacterium]	diamond	222	81.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales 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);;