metadata: contig_metadata: 3 rows where analysis = "blastn", bioproject = "PRJNA846110" and tax

3 rows where analysis = "blastn", bioproject = "PRJNA846110" 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
2108467	2108467	PRJNA846110_P_NODE_19982_length_263_cov_1.552632_g19737_i0	PRJNA846110	19982	263	1.552632	4.08342216	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	233	7.99e-57	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g19737	i0	82.9	2.86311787072243	269	37	100	7	1	263	2347693	2347958	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	753	233	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
12710934	12710934	PRJNA846110_P_NODE_22690_length_251_cov_0.865169_g22445_i0	PRJNA846110	22690	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	196	9.93e-46	NTclustered	gi\|1015624362\|gb\|AH012920.2\|	171953	g22445	i0	87.952	65.5896414342629	166	20	66	0	55	220	30335	30170	Uncultured Acidobacteria bacterium clone 46h5 hypothetical protein, putative O-linked GlcNAc transferase, putative two-component response regulator, hypothetical protein, putative penicillin-resistance DD-carboxypeptidase, putative glycosyl transferase, hypothetical protein, conserved hypothetical protein, hypothetical protein, putative MaoC family dehydratase, putative D-3-phosphoglycerate dehydrogenase, putative magnesium and cobalt transport protein, putative phosphatidyl-glycerophosphatase, putative 2-methylthioadenine synthetase, hypothetical protein, putative glutamine cyclotransferase, and hypothetical protein genes, complete cds; 5S ribosomal RNA, 23S ribosomal RNA, tRNA-Ala, tRNA-Met, tRNA-Ile, and 16S ribosomal RNA genes, complete sequence; and hypothetical protein genes, complete cds	blastn	16463	196	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23785373	23785373	PRJNA846110_P_NODE_24879_length_248_cov_0.880000_g24634_i0	PRJNA846110	24879	248	0.88	2.1824	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	265	2.6499999999999997e-66	NTclustered	gi\|2874253750\|emb\|OY969625.1\|	194844	g24634	i0	85.887	93.4153225806452	248	35	100	0	1	248	1681179	1681426	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1	blastn	23167	265	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae 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);;