metadata: contig_metadata: 5 rows where bioproject = "PRJNA1069776", tax_kingdom = "Pseudomonadati" and tax

5 rows where bioproject = "PRJNA1069776", tax_kingdom = "Pseudomonadati" and tax_phylum = "Acidobacteriota"

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
23136872	23136872	PRJNA1069776_S_NODE_13479_length_276_cov_3.296137_g13165_i0	PRJNA1069776	13479	276	3.296137	9.09733812	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	444	3.58e-120	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g13165	i0	96.31	393.192028985507	271	8	98	2	7	276	4357216	4356947	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	108521	444	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
28385324	28385324	PRJNA1069776_S_NODE_30046_length_197_cov_1.993506_g29732_i0	PRJNA1069776	30046	197	1.993506	3.92720682	Bacteria	2	Bacteria	Bacteria	42.4	0.0271	NR	MCI0664218.1	1978231	g29732	i0	35.5	4.00507614213198	62	36	89.8	2	18	194	97	157	MCI0664218.1 SCO family protein [Acidobacteriota bacterium]	diamond	789	42.4	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28457084	28457084	PRJNA1069776_S_NODE_26066_length_209_cov_5.421687_g25752_i0	PRJNA1069776	26066	209	5.421687	11.33132583	Candidatus Solibacter sp.	2068625	Bacteria	Bacteria	42	0.0442	NR	HKA02632.1	2068625	g25752	i0	37.9	0.947368421052632	66	37	89	1	3	188	76	141	HKA02632.1 WD40 repeat domain-containing protein [Candidatus Solibacter sp.]	diamond	198	42	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter sp.
30193629	30193629	PRJNA1069776_S_NODE_32612_length_190_cov_2.469388_g32298_i0	PRJNA1069776	32612	190	2.469388	4.6918372	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	42.7	0.0187	NR	MDP9051418.1	1978231	g32298	i0	39.6	0.757894736842105	48	28	74.2	1	153	13	41	88	MDP9051418.1 glycosyltransferase family 39 protein [Acidobacteriota bacterium]	diamond	144	42.7	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32312294	32312294	PRJNA1069776_S_NODE_18979_length_240_cov_6.238579_g18665_i0	PRJNA1069776	18979	240	6.238579	14.9725896	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	42.4	0.0498	NR	MEJ2421560.1	1978231	g18665	i0	36.5	0.7875	63	36	78.8	1	189	1	212	270	MEJ2421560.1 C69 family dipeptidase [Acidobacteriota bacterium]	diamond	189	42.4	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);;