metadata: contig_metadata: 9 rows where bioproject = "PRJNA825466", tax_phylum = "Acidobacteriota" and tax

9 rows where bioproject = "PRJNA825466", 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_genus	tax_species
26810001	26810001	PRJNA825466_P_NODE_2801_length_434_cov_1.343490_g2700_i0	PRJNA825466	2801	434	1.34349	5.8307466	Bacteria	2	Bacteria	Bacteria	70.1	7.93e-11	NR	HEY3053523.1	2651171	g2700	i0	42.1	1.97695852534562	140	69	91.9	7	13	411	360	494	HEY3053523.1 hypothetical protein [Thermoanaerobaculia bacterium]	diamond	858	70.5	0.994326241134752	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
27528355	27528355	PRJNA825466_P_NODE_10663_length_283_cov_2.152381_g10562_i0	PRJNA825466	10663	283	2.152381	6.09123823	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	50.8	8.2e-5	NR	NNF01029.1	2283092	g10562	i0	44.6	0.593639575971731	56	29	58.3	2	281	117	343	397	NNF01029.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	168	50.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
29746981	29746981	PRJNA825466_P_NODE_6370_length_328_cov_1.074510_g6269_i0	PRJNA825466	6370	328	1.07451	3.5243928	Pseudomonadati	3379134	Bacteria	Bacteria	138	2.5e-35	NR	MBS1768271.1	1978231	g6269	i0	56.9	1.99390243902439	109	47	99.7	0	1	327	442	550	MBS1768271.1 hypothetical protein [Acidobacteriota bacterium]	diamond	654	138	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30559745	30559745	PRJNA825466_P_NODE_28113_length_241_cov_1.553571_g28012_i0	PRJNA825466	28113	241	1.553571	3.74410611	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	42.7	0.0141	NR	MBX7173915.1	2283092	g28012	i0	43.8	0.597510373443983	48	27	59.8	0	147	4	7	54	MBX7173915.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	144	42.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
30970842	30970842	PRJNA825466_P_NODE_11734_length_276_cov_1.517241_g11633_i0	PRJNA825466	11734	276	1.517241	4.18758516	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	59.3	8.23e-8	NR	QQS40408.1	1978231	g11633	i0	44.8	0.630434782608696	58	32	63	0	5	178	506	563	QQS40408.1 MAG: hypothetical protein IPM63_13700 [Acidobacteriota bacterium]	diamond	174	59.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31603165	31603165	PRJNA825466_P_NODE_20756_length_248_cov_0.880000_g20655_i0	PRJNA825466	20756	248	0.88	2.1824	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	63.5	1.85e-9	NR	HVS14393.1	2651171	g20655	i0	57.6	0.713709677419355	59	22	71.4	1	69	245	628	683	HVS14393.1 protein kinase [Thermoanaerobaculia bacterium]	diamond	177	63.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
31919401	31919401	PRJNA825466_S_NODE_1697_length_246_cov_0.890173_g1691_i0	PRJNA825466	1697	246	0.890173	2.18982558	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	162	3.11e-44	NR	MCD9184828.1	2283092	g1691	i0	98.8	1	82	1	100	0	246	1	772	853	MCD9184828.1 C25 family cysteine peptidase [Pyrinomonadaceae bacterium]	diamond	246	162	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
32299426	32299426	PRJNA825466_P_NODE_1699_length_535_cov_2.008658_g1600_i0	PRJNA825466	1699	535	2.008658	10.7463203	Geothrix sp.	1962974	Bacteria	Bacteria	68.2	1.9e-10	NR	MCM2249838.1	1962974	g1600	i0	37.5	2.01308411214953	112	63	62.8	2	494	159	78	182	MCM2249838.1 CAP domain-containing protein [Geothrix sp.]	diamond	1077	68.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
32299427	32299427	PRJNA825466_P_NODE_23659_length_245_cov_0.895349_g23558_i0	PRJNA825466	23659	245	0.895349	2.19360505	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	62.4	4.54e-9	NR	HUO32357.1	2212468	g23558	i0	44.3	2.86530612244898	79	43	95.5	1	235	2	67	145	HUO32357.1 choice-of-anchor D domain-containing protein [Bryobacteraceae bacterium]	diamond	702	62.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae 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);;