metadata: contig_metadata: 10 rows where bioproject = "PRJNA692200", tax_phylum = "Acidobacteriota" and tax

10 rows where bioproject = "PRJNA692200", 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
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.
14701821	14701821	PRJNA692200_S_NODE_2732_length_349_cov_415.153333_g2675_i0	PRJNA692200	2732	349	415.153333	1448.88513217	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	73.2	2.56e-12	NR	MBX3265733.1	1978231	g2675	i0	43.2	0.636103151862464	74	38	61	3	345	133	159	231	MBX3265733.1 hypothetical protein [Acidobacteriota bacterium]	diamond	222	73.2	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
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
29419227	29419227	PRJNA692200_S_NODE_11309_length_212_cov_1.889571_g11252_i0	PRJNA692200	11309	212	1.889571	4.00589052	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	44.3	0.00716	NR	MBP7146994.1	1978231	g11252	i0	46.9	1.35849056603774	49	17	69.3	1	206	60	260	299	MBP7146994.1 C1 family peptidase [Acidobacteriota bacterium]	diamond	288	44.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30840919	30840919	PRJNA692200_S_NODE_10854_length_216_cov_1.041916_g10797_i0	PRJNA692200	10854	216	1.041916	2.25053856	Geothrix sp. 21YS21S-4	3068889	Bacteria	Bacteria	109	7.12e-26	NR	WP_306591297.1	3068889	g10797	i0	67.6	0.986111111111111	71	23	98.6	0	213	1	321	391	WP_306591297.1 TonB-dependent receptor [Geothrix sp. 21YS21S-4]	diamond	213	109	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-4
30872420	30872420	PRJNA692200_S_NODE_1054_length_437_cov_29.443299_g1008_i0	PRJNA692200	1054	437	29.443299	128.66721663	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	81.6	3.64e-15	NR	MDR3737318.1	2052142	g1008	i0	41.9	0.851258581235698	124	68	83.1	3	427	65	186	308	MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium]	diamond	372	81.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
31188093	31188093	PRJNA692200_S_NODE_15755_length_184_cov_2.259259_g15698_i0	PRJNA692200	15755	184	2.259259	4.15703656	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	67.4	5.7e-13	NR	MBA3600496.1	1978231	g15698	i0	56.9	8.51086956521739	58	25	94.6	0	3	176	18	75	MBA3600496.1 homogentisate 1,2-dioxygenase [Acidobacteriota bacterium]	diamond	1566	67.4	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);;