metadata: contig_metadata: 9 rows where bioproject = "PRJNA929952", tax_kingdom = "Pseudomonadati" and tax

9 rows where bioproject = "PRJNA929952", tax_kingdom = "Pseudomonadati" 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_species
3460058	3460058	PRJNA929952_P_NODE_2523_length_760_cov_101.871409_g1859_i0	PRJNA929952	2523	760	101.871409	774.2227084	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	941	0	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g1859	i0	89.812	150.857894736842	746	59	96	13	28	760	3176846	3176105	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	114652	941	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
6012405	6012405	PRJNA929952_P_NODE_18965_length_225_cov_2.530612_g17671_i0	PRJNA929952	18965	225	2.530612	5.693877	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	259	1.1e-64	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g17671	i0	95.679	346.893333333333	162	6	99	1	64	224	4357069	4356908	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	78051	259	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
8562065	8562065	PRJNA929952_P_NODE_12047_length_317_cov_4.593750_g10754_i0	PRJNA929952	12047	317	4.59375	14.5621875	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	108	6.25e-19	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g10754	i0	92.105	0.429022082018927	76	6	24	0	242	317	4676964	4676889	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	136	108	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
8562104	8562104	PRJNA929952_P_NODE_23827_length_159_cov_7.007692_g22533_i0	PRJNA929952	23827	159	7.007692	11.14223028	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	76.8	7.81e-10	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g22533	i0	100	25.9874213836478	41	0	26	0	1	41	4838366	4838406	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	4132	76.8	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
12388293	12388293	PRJNA929952_P_NODE_11950_length_319_cov_750.134483_g10657_i0	PRJNA929952	11950	319	750.134483	2392.92900077	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	361	4.38e-95	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g10657	i0	88.411	195.554858934169	302	31	94	4	19	318	2365634	2365933	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	62382	361	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
13662795	13662795	PRJNA929952_P_NODE_22771_length_171_cov_2.922535_g21477_i0	PRJNA929952	22771	171	2.922535	4.99753485	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	215	1.73e-51	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g21477	i0	89.881	193	168	16	98	1	1	167	4233618	4233451	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	33003	215	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
18760807	18760807	PRJNA929952_P_NODE_9615_length_377_cov_1710.396552_g8337_i0	PRJNA929952	9615	377	1710.396552	6448.19500104	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	446	1.41e-120	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g8337	i0	93.355	82.2546419098143	301	20	80	0	77	377	4647286	4647586	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	31010	446	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
20035788	20035788	PRJNA929952_P_NODE_4996_length_558_cov_93.854442_g3970_i0	PRJNA929952	4996	558	93.854442	523.70778636	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	652	0	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g3970	i0	88.787	380.016129032258	544	45	96	14	1	536	715736	716271	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	212049	652	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
22586138	22586138	PRJNA929952_P_NODE_19058_length_224_cov_2.841026_g17764_i0	PRJNA929952	19058	224	2.841026	6.36389824	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	302	1.79e-77	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g17764	i0	92.488	8.62946428571429	213	13	95	3	1	212	498721	498511	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	1933	302	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);;