metadata: contig_metadata: 8 rows where bioproject = "PRJNA833575", tax_phylum = "Acidobacteriota" and tax

8 rows where bioproject = "PRJNA833575", 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
18675880	18675880	PRJNA833575_P_NODE_44135_length_229_cov_0.900000_g43998_i0	PRJNA833575	44135	229	0.9	2.061	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	77.8	6.91e-16	NR	HEX7720739.1	2283092	g43998	i0	88.1	4.19213973799127	42	5	55	0	126	1	14	55	HEX7720739.1 carboxylating nicotinate-nucleotide diphosphorylase [Pyrinomonadaceae bacterium]	diamond	960	77.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
26999672	26999672	PRJNA833575_P_NODE_25742_length_293_cov_1.602679_g25605_i0	PRJNA833575	25742	293	1.602679	4.69584947	Bacteria	2	Bacteria	Bacteria	84	2.22e-16	NR	MCU1229546.1	1978231	g25605	i0	48.5	6.95221843003413	97	40	99.3	2	2	292	311	397	MCU1229546.1 Zinc metalloproteinase precursor/aureolysin [Acidobacteriota bacterium]	diamond	2037	84.3	0.99644128113879	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
28294818	28294818	PRJNA833575_P_NODE_40906_length_232_cov_0.883436_g40769_i0	PRJNA833575	40906	232	0.883436	2.04957152	Bacteria	2	Bacteria	Bacteria	69.7	1.03e-11	NR	PYT79533.1	1978231	g40769	i0	36.7	4.03448275862069	79	41	99.6	2	232	2	244	315	PYT79533.1 MAG: hypothetical protein DMG40_15605 [Acidobacteriota bacterium]	diamond	936	69.7	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
28886134	28886134	PRJNA833575_P_NODE_38908_length_235_cov_0.849398_g38771_i0	PRJNA833575	38908	235	0.849398	1.9960853	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	42.4	0.045	NR	MDA1313252.1	1978231	g38771	i0	42.1	0.485106382978723	38	18	48.5	1	28	141	299	332	MDA1313252.1 glycosyltransferase [Acidobacteriota bacterium]	diamond	114	42.4	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
29075876	29075876	PRJNA833575_P_NODE_46108_length_226_cov_1.662420_g45971_i0	PRJNA833575	46108	226	1.66242	3.7570692	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	69.7	7.2e-13	NR	MDX2000632.1	2651171	g45971	i0	54.2	1.73893805309735	59	27	78.3	0	17	193	29	87	MDX2000632.1 helix-turn-helix domain-containing protein [Thermoanaerobaculia bacterium]	diamond	393	69.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia			Thermoanaerobaculia bacterium
30189461	30189461	PRJNA833575_P_NODE_46272_length_226_cov_0.917197_g46135_i0	PRJNA833575	46272	226	0.917197	2.07286522	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	80.5	1.52e-15	NR	HYI08790.1	2651171	g46135	i0	52.6	6.83628318584071	76	32	96.9	2	219	1	215	289	HYI08790.1 M4 family metallopeptidase [Thermoanaerobaculia bacterium]	diamond	1545	80.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia			Thermoanaerobaculia bacterium
32172882	32172882	PRJNA833575_P_NODE_14318_length_386_cov_1.362776_g14181_i0	PRJNA833575	14318	386	1.362776	5.26031536	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	48.5	6.78e-4	NR	HVF46496.1	2283092	g14181	i0	35.9	1.28238341968912	78	49	60.6	1	134	367	54	130	HVF46496.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	495	48.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
32394244	32394244	PRJNA833575_P_NODE_33919_length_254_cov_1.167568_g33782_i0	PRJNA833575	33919	254	1.167568	2.96562272	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	42.7	0.0431	NR	HEV8581698.1	2651171	g33782	i0	36.1	0.850393700787402	72	44	82.7	1	211	2	630	701	HEV8581698.1 hypothetical protein [Thermoanaerobaculia bacterium]	diamond	216	42.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia			Thermoanaerobaculia 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);;