metadata: contig_metadata: 10 rows where bioproject = "PRJEB75227", tax_phylum = "Acidobacteriota" and tax

10 rows where bioproject = "PRJEB75227", 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
11614158	11614158	PRJEB75227_P_NODE_6470_length_280_cov_1.507246_g6299_i0	PRJEB75227	6470	280	1.507246	4.2202888	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	159	3.49e-47	NR	HWJ55282.1	2910147	g6299	i0	87	0.985714285714286	92	12	98.6	0	278	3	101	192	HWJ55282.1 TonB-dependent receptor plug domain-containing protein [Vicinamibacterales bacterium]	diamond	276	159	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
13749087	13749087	PRJEB75227_P_NODE_6991_length_272_cov_1.221106_g6820_i0	PRJEB75227	6991	272	1.221106	3.32140832	Terriglobales bacterium	2282142	Bacteria	Bacteria	190	2.7599999999999996e-56	NR	HZU45273.1	2282142	g6820	i0	97.8	0.992647058823529	90	2	99.3	0	272	3	181	270	HZU45273.1 phosphoenolpyruvate carboxykinase (ATP) [Terriglobales bacterium]	diamond	270	190	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
20536578	20536578	PRJEB75227_P_NODE_8357_length_253_cov_0.866667_g8186_i0	PRJEB75227	8357	253	0.866667	2.19266751	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	307	4.44e-79	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g8186	i0	88.803	122.830039525692	259	18	100	11	1	253	3175453	3175706	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	31076	307	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
21812405	21812405	PRJEB75227_P_NODE_10438_length_246_cov_0.901734_g10267_i0	PRJEB75227	10438	246	0.901734	2.21826564	Pseudomonadati	3379134	Bacteria	Bacteria	149	7.64e-41	NR	MCA1590932.1	1978231	g10267	i0	86.1	19.1829268292683	79	11	96.3	0	238	2	49	127	MCA1590932.1 energy-dependent translational throttle protein EttA [Acidobacteriota bacterium]	diamond	4719	150	0.993333333333333	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
26970770	26970770	PRJEB75227_P_NODE_4302_length_343_cov_1.155556_g4131_i0	PRJEB75227	4302	343	1.155556	3.96355708	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	107	2.31e-27	NR	MDQ7008654.1	1978231	g4131	i0	82.9	0.612244897959184	70	11	61.2	1	341	132	43	111	MDQ7008654.1 hypothetical protein [Acidobacteriota bacterium]	diamond	210	107	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27192076	27192076	PRJEB75227_P_NODE_3862_length_364_cov_1.288660_g3691_i0	PRJEB75227	3862	364	1.28866	4.6907224	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	96.7	3.37e-21	NR	KAA0253286.1	1978231	g3691	i0	41.8	1.80494505494505	122	69	98.9	1	362	3	69	190	KAA0253286.1 MAG: zinc metalloprotease [Acidobacteriota bacterium]	diamond	657	96.7	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27318786	27318786	PRJEB75227_P_NODE_3083_length_418_cov_1.130435_g2912_i0	PRJEB75227	3083	418	1.130435	4.7252183	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	91.7	5.74e-19	NR	MDR3737318.1	2052142	g2912	i0	43.5	0.940191387559809	131	70	91.9	3	410	27	178	307	MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium]	diamond	393	91.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
27698006	27698006	PRJEB75227_P_NODE_9884_length_248_cov_0.891429_g9713_i0	PRJEB75227	9884	248	0.891429	2.21074392	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	82.8	2.15e-16	NR	HZT32585.1	2212468	g9713	i0	48.3	1.07661290322581	89	36	95.6	2	12	248	166	254	HZT32585.1 AAA family ATPase [Bryobacteraceae bacterium]	diamond	267	82.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
29402595	29402595	PRJEB75227_P_NODE_9289_length_250_cov_0.881356_g9118_i0	PRJEB75227	9289	250	0.881356	2.20339	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	142	4.19e-41	NR	HEX7793620.1	2910147	g9118	i0	78.3	3.984	83	18	99.6	0	2	250	10	92	HEX7793620.1 7-cyano-7-deazaguanine synthase [Vicinamibacterales bacterium]	diamond	996	142	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
31899122	31899122	PRJEB75227_P_NODE_9557_length_249_cov_0.886364_g9386_i0	PRJEB75227	9557	249	0.886364	2.20704636	Candidatus Acidiferrum sp.	3069120	Bacteria	Bacteria	51.6	2.48e-6	NR	HEX8838167.1	3069120	g9386	i0	43.8	1.5421686746988	64	31	77.1	2	248	57	23	81	HEX8838167.1 hypothetical protein [Candidatus Acidiferrum sp.]	diamond	384	51.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrum	Candidatus Acidiferrum sp.

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);;