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

5 rows where analysis = "blastn", bioproject = "PRJNA692200" 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
9601342	9601342	PRJNA692200_S_NODE_4708_length_294_cov_230.734694_g4651_i0	PRJNA692200	4708	294	230.734694	678.36000036	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	353	6.68e-93	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g4651	i0	94.737	112.700680272109	228	11	77	1	1	227	4233972	4233745	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	33134	353	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9601421	9601421	PRJNA692200_S_NODE_7228_length_253_cov_1948.039216_g7171_i0	PRJNA692200	7228	253	1948.039216	4928.53921648	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	263	9.74e-66	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g7171	i0	89.252	97.5849802371542	214	18	83	5	42	252	317462	317251	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	24689	263	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
13426339	13426339	PRJNA692200_S_NODE_12771_length_201_cov_2.513158_g12714_i0	PRJNA692200	12771	201	2.513158	5.05144758	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	93.5	1.03e-14	NTclustered	gi\|76574296\|gb\|DQ139444.1\|	171953	g12714	i0	82.857	2.47761194029851	105	16	52	2	5	109	1407	1509	Uncultured Acidobacteria bacterium clone CAL5 23S ribosomal RNA gene, partial sequence	blastn	498	93.5	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13933221	13933221	PRJNA692200_S_NODE_11171_length_213_cov_2.170732_g11114_i0	PRJNA692200	11171	213	2.170732	4.62365916	Geothrix	44675	Bacteria	Bacteria	322	1.29e-83	NTclustered	gi\|2515262989\|gb\|CP126625.1\|	1962974	g11114	i0	93.981	168.070422535211	216	7	100	5	1	213	1293982	1293770	MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome	blastn	35799	322	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
18524647	18524647	PRJNA692200_S_NODE_16595_length_180_cov_1.564885_g16538_i0	PRJNA692200	16595	180	1.564885	2.816793	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	97.1	6.95e-16	NTclustered	gi\|2621701418\|emb\|OY760136.1\|	2910147	g16538	i0	78.125	20.4444444444444	160	30	88	5	23	180	1699475	1699319	MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1	blastn	3680	97.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales 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);;