metadata: contig_metadata: 5 rows where bioproject = "PRJEB12296", tax_phylum = "Acidobacteriota" and tax

5 rows where bioproject = "PRJEB12296", 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
25500622	25500622	PRJEB12296_S_NODE_10233_length_172_cov_1.591241_g10201_i0	PRJEB12296	10233	172	1.591241	2.73693452	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	189	1.0499999999999996e-43	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g10201	i0	87.425	2.76162790697674	167	17	95	3	9	172	4840649	4840484	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	475	189	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
25500768	25500768	PRJEB12296_S_NODE_417_length_483_cov_23.343750_g390_i0	PRJEB12296	417	483	23.34375	112.7503125	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	486	1.0899999999999999e-132	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g390	i0	85.3	165.933747412008	483	57	98	14	1	475	317721	317245	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	80146	486	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
25908911	25908911	PRJEB12296_S_NODE_2740_length_265_cov_3.782609_g2708_i0	PRJEB12296	2740	265	3.782609	10.02391385	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	259	1.33e-64	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g2708	i0	87.013	75.8830188679245	231	29	87	1	36	265	3298166	3298396	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	20109	259	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
26015240	26015240	PRJEB12296_S_NODE_7940_length_183_cov_3.763514_g7908_i0	PRJEB12296	7940	183	3.763514	6.88723062	Luteitalea	2004797	Bacteria	Bacteria	158	3.21e-34	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g7908	i0	87.97	126.426229508197	133	16	73	0	31	163	653383	653251	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	23136	158	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
26045176	26045176	PRJEB12296_S_NODE_9725_length_174_cov_2.705036_g9693_i0	PRJEB12296	9725	174	2.705036	4.70676264	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	235	1.3499999999999998e-57	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g9693	i0	91.716	138.379310344828	169	14	97	0	1	169	715765	715933	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	24078	235	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured 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);;