metadata: contig_metadata: 9 rows where bioproject = "PRJNA624323" and tax

9 rows where bioproject = "PRJNA624323" 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
10800622	10800622	PRJNA624323_P_NODE_3709_length_381_cov_2.827922_g3547_i0	PRJNA624323	3709	381	2.827922	10.77438282	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	135	3.5100000000000004e-27	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g3547	i0	91.837	2.54855643044619	98	6	26	2	189	286	3097255	3097160	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	971	135	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
12075731	12075731	PRJNA624323_P_NODE_7010_length_269_cov_2.275510_g6848_i0	PRJNA624323	7010	269	2.27551	6.1211219	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	420	5.86e-113	NTclustered	gi\|112980873\|gb\|DQ829677.1\|	171953	g6848	i0	94.815	382.71375464684	270	12	100	2	1	269	1531	1263	Uncultured Acidobacteria bacterium clone DON3 23S ribosomal RNA gene, partial sequence	blastn	102950	420	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13350554	13350554	PRJNA624323_P_NODE_6951_length_271_cov_0.989899_g6789_i0	PRJNA624323	6951	271	0.989899	2.68262629	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	239	1.78e-58	NTclustered	gi\|2874253849\|emb\|OY969905.1\|	171953	g6789	i0	84.436	98.3690036900369	257	25	92	15	1	249	3103816	3103567	MAG: uncultured Acidobacteriota bacterium isolate MFD09222.bin.c.1 genome assembly, chromosome: 1	blastn	26658	239	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14625305	14625305	PRJNA624323_P_NODE_8832_length_245_cov_1.790698_g8670_i0	PRJNA624323	8832	245	1.790698	4.3872101	Chloracidobacterium validum	2821543	Bacteria	Bacteria	211	3.45e-50	NTclustered	gi\|2033659757\|gb\|CP072648.1\|	2821543	g8670	i0	83.051	253.518367346939	236	37	96	3	1	235	105691	105458	Chloracidobacterium validum strain BV2-C chromosome 1, complete sequence	blastn	62112	211	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium validum
15899300	15899300	PRJNA624323_P_NODE_4233_length_354_cov_5.181495_g4071_i0	PRJNA624323	4233	354	5.181495	18.3424923	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	137	8.989999999999999e-28	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g4071	i0	74.648	3.85593220338983	355	68	99	19	3	351	4464736	4465074	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	1365	137	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
17728041	17728041	PRJNA624323_P_NODE_7454_length_260_cov_1.636364_g7292_i0	PRJNA624323	7454	260	1.636364	4.2545464	Chloracidobacterium	458032	Bacteria	Bacteria	219	2.21e-52	NTclustered	gi\|2033641525\|gb\|CP072636.1\|	2821537	g7292	i0	82.591	68.4884615384615	247	43	95	0	1	247	1332558	1332804	Chloracidobacterium sp. 2 chromosome 1, complete sequence	blastn	17807	219	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium aggregatum
20998682	20998682	PRJNA624323_P_NODE_6657_length_277_cov_2.794118_g6495_i0	PRJNA624323	6657	277	2.794118	7.73970686	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	424	4.69e-114	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g6495	i0	95.149	101.602888086643	268	13	97	0	1	268	4356828	4356561	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	28144	424	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
28122850	28122850	PRJNA624323_P_NODE_6785_length_274_cov_1.402985_g6623_i0	PRJNA624323	6785	274	1.402985	3.8441789	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	92	6.170000000000001e-21	NR	MEP7039316.1	1978231	g6623	i0	62.1	2.60583941605839	87	33	95.3	0	274	14	79	165	MEP7039316.1 Spy/CpxP family protein refolding chaperone [Acidobacteriota bacterium]	diamond	714	92	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31028604	31028604	PRJNA624323_P_NODE_9475_length_241_cov_0.916667_g9313_i0	PRJNA624323	9475	241	0.916667	2.20916747	Acidobacteria bacterium OLB17	1617423	Bacteria	Bacteria	75.1	9.42e-16	NR	KXJ97965.1	1617423	g9313	i0	55.4	0.809128630705394	65	28	79.7	1	48	239	1	65	KXJ97965.1 MAG: hypothetical protein UZ17_ACD001002855 [Acidobacteria bacterium OLB17]	diamond	195	75.1	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteria bacterium OLB17

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