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

4 rows where analysis = "diamond", bioproject = "PRJNA886442" 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
13615456	13615456	PRJNA886442_P_NODE_12051_length_249_cov_0.886364_g11887_i0	PRJNA886442	12051	249	0.886364	2.20704636	Thermicanus aegyptius	94009	Bacteria	Bacteria	163	4.5499999999999995e-45	NR	WP_005583113.1	94009	g11887	i0	95.2	1.98795180722892	83	4	100	0	1	249	470	552	WP_005583113.1 ATP-dependent zinc metalloprotease FtsH [Thermicanus aegyptius]	diamond	495	163	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Thermicanus	Thermicanus aegyptius
29108208	29108208	PRJNA886442_P_NODE_2848_length_420_cov_1.573487_g2684_i0	PRJNA886442	2848	420	1.573487	6.6086454	Hydrogenibacillus schlegelii	1484	Bacteria	Bacteria	46.6	0.0108	NR	WP_273000906.1	1484	g2684	i0	48.1	0.771428571428571	54	17	38.6	2	6	167	160	202	WP_273000906.1 bifunctional metallophosphatase/5'-nucleotidase, partial [Hydrogenibacillus schlegelii]	diamond	324	46.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Hydrogenibacillus	Hydrogenibacillus schlegelii
31604136	31604136	PRJNA886442_P_NODE_7776_length_286_cov_1.098592_g7612_i0	PRJNA886442	7776	286	1.098592	3.14197312	Bacillota bacterium	1879010	Bacteria	Bacteria	56.6	8.41e-8	NR	HOJ49100.1	1879010	g7612	i0	51.7	1.81468531468531	58	28	60.8	0	5	178	54	111	HOJ49100.1 hypothetical protein [Bacillota bacterium]	diamond	519	56.6	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
31983598	31983598	PRJNA886442_P_NODE_6438_length_308_cov_1.327660_g6274_i0	PRJNA886442	6438	308	1.32766	4.0891928	Bacillota bacterium	1879010	Bacteria	Bacteria	62	1.62e-9	NR	MBI2914668.1	1879010	g6274	i0	37.6	0.905844155844156	93	55	90.6	1	295	17	55	144	MBI2914668.1 LysM peptidoglycan-binding domain-containing protein [Bacillota bacterium]	diamond	279	62	1	Bacteria	Bacillati	Bacillota					Bacillota 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);;