metadata: contig_metadata: 5 rows where bioproject = "PRJNA534016", tax_phylum = "Acidobacteriota" and tax

5 rows where bioproject = "PRJNA534016", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

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_species
6885070	6885070	PRJNA534016_P_NODE_12946_length_256_cov_1.300546_g12856_i0	PRJNA534016	12946	256	1.300546	3.32939776	Pseudomonadati	3379134	Bacteria	Bacteria	88.2	3.26e-18	NR	MFL6414582.1	2212468	g12856	i0	56.5	6.97265625	85	36	98.4	1	254	3	47	131	MFL6414582.1 DEAD/DEAH box helicase [Bryobacteraceae bacterium]	diamond	1785	88.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacteraceae bacterium
22184257	22184257	PRJNA534016_P_NODE_1498_length_670_cov_2.097152_g1412_i0	PRJNA534016	1498	670	2.097152	14.0509184	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	350	4.3099999999999985e-112	NR	MBO08892.1	1978231	g1412	i0	77.1	0.998507462686567	223	51	99.9	0	670	2	135	357	MBO08892.1 hypothetical protein [Acidobacteriota bacterium]	diamond	669	350	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
27472047	27472047	PRJNA534016_P_NODE_18743_length_235_cov_3.956790_g18653_i0	PRJNA534016	18743	235	3.95679	9.2984565	Pseudomonadati	3379134	Bacteria	Bacteria	112	1.22e-28	NR	MBP8273776.1	1978231	g18653	i0	65.8	1.94042553191489	76	26	97	0	5	232	102	177	MBP8273776.1 hypothetical protein [Acidobacteriota bacterium]	diamond	456	112	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
27867349	27867349	PRJNA534016_P_NODE_5705_length_349_cov_1.615942_g5615_i0	PRJNA534016	5705	349	1.615942	5.63963758	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	44.3	0.0326	NR	UCF81812.1	1978231	g5615	i0	44.6	0.481375358166189	56	28	48.1	1	166	333	185	237	UCF81812.1 MAG: AmmeMemoRadiSam system radical SAM enzyme [Acidobacteriota bacterium]	diamond	168	44.3	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
31531704	31531704	PRJNA534016_P_NODE_13296_length_253_cov_1.711111_g13206_i0	PRJNA534016	13296	253	1.711111	4.32911083	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	43.5	0.0227	NR	MCU0289736.1	1978231	g13206	i0	38	1.73122529644269	71	35	84.2	3	29	241	527	588	MCU0289736.1 putative DNA binding domain-containing protein [Acidobacteriota bacterium]	diamond	438	43.5	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota 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);;