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

5 rows where analysis = "diamond", bioproject = "PRJNA811714" 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
8462371	8462371	PRJNA811714_P_NODE_24027_length_235_cov_2.851852_g23834_i0	PRJNA811714	24027	235	2.851852	6.7018522	Streptococcus agalactiae	1311	Bacteria	Bacteria	129	2.68e-35	NR	WP_249631429.1	1311	g23834	i0	100	1.94042553191489	77	0	98.3	0	233	3	142	218	WP_249631429.1 hypothetical protein, partial [Streptococcus agalactiae]	diamond	456	129	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus agalactiae
29012513	29012513	PRJNA811714_P_NODE_23448_length_236_cov_5.631902_g23255_i0	PRJNA811714	23448	236	5.631902	13.29128872	Paenibacillus terrigena	369333	Bacteria	Bacteria	42.7	0.033	NR	WP_018758219.1	369333	g23255	i0	39.5	0.546610169491525	43	26	54.7	0	137	9	6	48	WP_018758219.1 acetyl-CoA C-acetyltransferase [Paenibacillus terrigena]	diamond	129	42.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus terrigena
29453865	29453865	PRJNA811714_P_NODE_20050_length_247_cov_2.344828_g19857_i0	PRJNA811714	20050	247	2.344828	5.79172516	Bacillus thuringiensis	1428	Bacteria	Bacteria	41.2	0.0478	NR	WP_197266154.1	1428	g19857	i0	36.2	0.704453441295547	58	31	66.8	2	46	210	26	80	WP_197266154.1 DUF3992 domain-containing protein [Bacillus thuringiensis]	diamond	174	41.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
31349949	31349949	PRJNA811714_P_NODE_11376_length_291_cov_24.385321_g11183_i0	PRJNA811714	11376	291	24.385321	70.96128411	Erysipelotrichaceae bacterium	2049044	Bacteria	Bacteria	43.9	0.0261	NR	MEA5061696.1	2049044	g11183	i0	31.9	0.742268041237113	72	42	69.1	2	240	40	179	248	MEA5061696.1 ComEC/Rec2 family competence protein [Erysipelotrichaceae bacterium]	diamond	216	43.9	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae bacterium
31982338	31982338	PRJNA811714_P_NODE_16958_length_259_cov_2.419355_g16765_i0	PRJNA811714	16958	259	2.419355	6.26612945	Clostridia bacterium	2044939	Bacteria	Bacteria	48.5	1.35e-4	NR	MBQ8287733.1	2044939	g16765	i0	35.1	0.857142857142857	74	45	84.6	2	31	249	43	114	MBQ8287733.1 GNAT family N-acetyltransferase [Clostridia bacterium]	diamond	222	48.5	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia 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);;