metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA896758" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA896758" 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
2148255	2148255	PRJNA896758_P_NODE_6142_length_459_cov_1.316062_g5753_i0	PRJNA896758	6142	459	1.316062	6.04072458	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	577	5.939999999999999e-160	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g5753	i0	100	216.80174291939	312	0	68	0	1	312	312	1	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	99512	577	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4701380	4701380	PRJNA896758_P_NODE_18964_length_267_cov_1.474227_g18574_i0	PRJNA896758	18964	267	1.474227	3.93618609	uncultured Holophaga sp.	188475	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2621785467\|emb\|OY781925.1\|	188475	g18574	i0	100	0.112359550561798	30	0	11	0	89	118	878245	878216	MAG: uncultured Holophaga sp. isolate 48fd71e5-2ffc-43bf-b6f5-ca4e00a42c30 genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	uncultured Holophaga sp.
11076386	11076386	PRJNA896758_P_NODE_24509_length_245_cov_0.895349_g24119_i0	PRJNA896758	24509	245	0.895349	2.19360505	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	207	4.46e-49	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g24119	i0	84.434	531.134693877551	212	32	86	1	1	211	3298248	3298459	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	130128	207	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
16175651	16175651	PRJNA896758_P_NODE_6193_length_457_cov_1.617188_g5804_i0	PRJNA896758	6193	457	1.617188	7.39054916	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	54.7	0.012	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g5804	i0	100	0.0634573304157549	29	0	6	0	301	329	234563	234591	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19095444	19095444	PRJNA896758_P_NODE_23735_length_246_cov_1.832370_g23345_i0	PRJNA896758	23735	246	1.83237	4.5076302	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	422	1.47e-113	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g23345	i0	97.561	166.260162601626	246	6	100	0	1	246	3299771	3300016	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	40900	422	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);;