metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA753704" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA753704" 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
3282438	3282438	PRJNA753704_P_NODE_27203_length_244_cov_2.678363_g26842_i0	PRJNA753704	27203	244	2.678363	6.53520572	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	169	2.09e-37	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g26842	i0	82.178	112.483606557377	202	30	80	5	49	244	360506	360707	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	27446	169	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
4559611	4559611	PRJNA753704_P_NODE_4304_length_542_cov_4.174840_g3945_i0	PRJNA753704	4304	542	4.17484	22.6276328	Chloracidobacterium validum	2821543	Bacteria	Bacteria	344	7.8499999999999985e-90	NTclustered	gi\|2033659757\|gb\|CP072648.1\|	2821543	g3945	i0	78.919	532.055350553505	555	81	99	28	3	542	105741	105208	Chloracidobacterium validum strain BV2-C chromosome 1, complete sequence	blastn	288374	344	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium validum
5834539	5834539	PRJNA753704_P_NODE_13385_length_325_cov_14.626984_g13024_i0	PRJNA753704	13385	325	14.626984	47.537698	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	207	6.16e-49	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g13024	i0	83.193	3.29230769230769	238	29	72	9	51	283	4985352	4985583	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	1070	207	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
5834571	5834571	PRJNA753704_P_NODE_16305_length_298_cov_1.386667_g15944_i0	PRJNA753704	16305	298	1.386667	4.13226766	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	121	7.489999999999999e-23	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g15944	i0	85.965	1.64429530201342	114	14	38	2	186	298	590012	590124	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	490	121	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
5834613	5834613	PRJNA753704_P_NODE_19865_length_272_cov_4.497487_g19504_i0	PRJNA753704	19865	272	4.497487	12.23316464	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	143	1.44e-29	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g19504	i0	79.386	42.8602941176471	228	28	84	12	1	228	6748469	6748261	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	11658	143	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5834743	5834743	PRJNA753704_P_NODE_30125_length_228_cov_2.012903_g29764_i0	PRJNA753704	30125	228	2.012903	4.5894188400000004	Bryobacterales bacterium	2026791	Bacteria	Bacteria	152	1.9499999999999998e-32	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g29764	i0	78.97	3.37280701754386	233	41	100	7	1	228	2775829	2776058	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	769	152	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
7109658	7109658	PRJNA753704_P_NODE_12026_length_342_cov_2.966543_g11665_i0	PRJNA753704	12026	342	2.966543	10.14557706	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	516	9.54e-142	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g11665	i0	93.86	104.143274853801	342	21	100	0	1	342	4357991	4357650	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	35617	516	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7109766	7109766	PRJNA753704_P_NODE_23166_length_254_cov_2.000000_g22805_i0	PRJNA753704	23166	254	2	5.08	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	318	2.0599999999999998e-82	NTclustered	gi\|76574293\|gb\|DQ139441.1\|	171953	g22805	i0	89.6	269.637795275591	250	26	98	0	1	250	27	276	Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence	blastn	68488	318	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8384381	8384381	PRJNA753704_P_NODE_24847_length_250_cov_0.881356_g24486_i0	PRJNA753704	24847	250	0.881356	2.20339	Geothrix oryzae	2927975	Bacteria	Bacteria	65.8	2.91e-6	NTclustered	gi\|2490888707\|dbj\|AP027079.1\|	2927975	g24486	i0	97.436	2.712	39	0	16	1	193	230	416567	416529	Geothrix oryzae Red222 DNA, complete genome	blastn	678	65.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix oryzae
8384473	8384473	PRJNA753704_P_NODE_5387_length_491_cov_1.437799_g5026_i0	PRJNA753704	5387	491	1.437799	7.05959309	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	446	1.88e-120	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g5026	i0	83.57	125.13849287169	493	63	100	11	1	491	3298660	3298184	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	61443	446	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
10934960	10934960	PRJNA753704_P_NODE_12149_length_340_cov_16.734082_g11788_i0	PRJNA753704	12149	340	16.734082	56.8958788	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	268	2.9299999999999994e-67	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g11788	i0	81.322	1.40882352941176	348	49	100	15	1	340	6081979	6082318	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	479	268	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
11405816	11405816	PRJNA753704_P_NODE_15109_length_308_cov_3.834043_g14748_i0	PRJNA753704	15109	308	3.834043	11.80885244	Edaphobacter	388463	Bacteria	Bacteria	169	2.7399999999999997e-37	NTclustered	gi\|2304905232\|gb\|CP073697.1\|	1933044	g14748	i0	81.034	89.4967532467532	232	27	70	12	83	299	3266912	3266683	Edaphobacter flagellatus strain HZ411 chromosome, complete genome	blastn	27565	169	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter flagellatus
13484780	13484780	PRJNA753704_P_NODE_16411_length_297_cov_1.392857_g16050_i0	PRJNA753704	16411	297	1.392857	4.13678529	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	121	7.46e-23	NTclustered	gi\|2893358450\|emb\|OZ220742.1\|	2651171	g16050	i0	79.032	75.0875420875421	186	32	61	5	3	183	745863	746046	MAG: Thermoanaerobaculia bacterium isolate 0db66e92-d31a-4200-8262-fff8455c21c0 genome assembly, chromosome: 1	blastn	22301	121	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
13484892	13484892	PRJNA753704_P_NODE_26111_length_247_cov_0.896552_g25750_i0	PRJNA753704	26111	247	0.896552	2.21448344	Edaphobacter flagellatus	1933044	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2304905232\|gb\|CP073697.1\|	1933044	g25750	i0	100	125.607287449393	247	0	100	0	1	247	3268131	3267885	Edaphobacter flagellatus strain HZ411 chromosome, complete genome	blastn	31025	457	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter flagellatus
16033634	16033634	PRJNA753704_P_NODE_18533_length_281_cov_1.995192_g18172_i0	PRJNA753704	18533	281	1.995192	5.60648952	Bryobacterales bacterium	2026791	Bacteria	Bacteria	302	2.3300000000000007e-77	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g18172	i0	89.754	73.0142348754448	244	13	87	6	1	244	4646306	4646537	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	20517	302	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
17309123	17309123	PRJNA753704_P_NODE_17374_length_289_cov_2.069444_g17013_i0	PRJNA753704	17374	289	2.069444	5.98069316	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	315	3.09e-81	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g17013	i0	86.532	82.0415224913495	297	27	99	12	1	288	4649760	4650052	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	23710	315	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
17309295	17309295	PRJNA753704_P_NODE_3814_length_574_cov_4.514970_g3457_i0	PRJNA753704	3814	574	4.51497	25.9159278	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	845	0	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g3457	i0	93.38	91.6811846689895	574	32	100	1	1	574	4232802	4232235	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	52625	845	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22408353	22408353	PRJNA753704_P_NODE_12658_length_334_cov_2.704981_g12297_i0	PRJNA753704	12658	334	2.704981	9.03463654	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	481	3.39e-131	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g12297	i0	93.051	342.72754491018	331	20	99	3	3	331	4357188	4356859	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	114471	481	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24957499	24957499	PRJNA753704_P_NODE_13960_length_319_cov_4.983740_g13599_i0	PRJNA753704	13960	319	4.98374	15.8981306	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	139	2.23e-28	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g13599	i0	89.381	2.2257053291536	113	9	35	3	6	117	1676902	1677012	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	710	139	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae 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);;