metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA986547" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA986547" 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
974165	974165	PRJNA986547_P_NODE_15661_length_212_cov_5.633094_g15579_i0	PRJNA986547	15661	212	5.633094	11.94215928	Geothrix oryzae	2927975	Bacteria	Bacteria	161	2.9699999999999997e-35	NTclustered	gi\|2490888707\|dbj\|AP027079.1\|	2927975	g15579	i0	81.865	8.0188679245283	193	33	91	2	18	209	2959342	2959151	Geothrix oryzae Red222 DNA, complete genome	blastn	1700	161	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix oryzae
974191	974191	PRJNA986547_P_NODE_17001_length_200_cov_6.433071_g16919_i0	PRJNA986547	17001	200	6.433071	12.866142	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	182	2.12e-41	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g16919	i0	87.037	61.435	162	19	81	2	16	176	3617596	3617436	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	12287	182	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2249337	2249337	PRJNA986547_P_NODE_12322_length_240_cov_2.323353_g12240_i0	PRJNA986547	12322	240	2.323353	5.5760472	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	180	9.49e-41	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g12240	i0	83.77	17.7958333333333	191	29	79	2	1	190	3196907	3196718	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	4271	180	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
9902426	9902426	PRJNA986547_P_NODE_7188_length_260_cov_1.411765_g7106_i0	PRJNA986547	7188	260	1.411765	3.670589	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	265	2.8e-66	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g7106	i0	87.391	21.4692307692308	230	29	88	0	1	230	1917235	1917464	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	5582	265	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12453369	12453369	PRJNA986547_P_NODE_15810_length_210_cov_13.700730_g15728_i0	PRJNA986547	15810	210	13.70073	28.771533	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	344	2.7199999999999998e-90	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g15728	i0	96.19	233.104761904762	210	8	100	0	1	210	9342	9551	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	48952	344	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12453415	12453415	PRJNA986547_P_NODE_3090_length_310_cov_2.822785_g3008_i0	PRJNA986547	3090	310	2.822785	8.7506335	uncultured Holophaga sp.	188475	Bacteria	Bacteria	91.6	6.14e-14	NTclustered	gi\|2621785467\|emb\|OY781925.1\|	188475	g3008	i0	96.364	2.3258064516129	55	2	18	0	161	215	1283172	1283118	MAG: uncultured Holophaga sp. isolate 48fd71e5-2ffc-43bf-b6f5-ca4e00a42c30 genome assembly, chromosome: 1	blastn	721	91.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	uncultured Holophaga sp.
13727783	13727783	PRJNA986547_P_NODE_2631_length_310_cov_6.122363_g2549_i0	PRJNA986547	2631	310	6.122363	18.9793253	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	76.8	1.72e-9	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g2549	i0	92.593	0.619354838709677	54	2	17	2	180	233	8389664	8389613	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	192	76.8	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16277096	16277096	PRJNA986547_P_NODE_4813_length_281_cov_2.644231_g4731_i0	PRJNA986547	4813	281	2.644231	7.43028911	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	381	2.909999999999999e-101	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g4731	i0	91.135	417.708185053381	282	24	100	1	1	281	4356798	4357079	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	117376	381	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
17552173	17552173	PRJNA986547_P_NODE_9174_length_249_cov_0.875000_g9092_i0	PRJNA986547	9174	249	0.875	2.17875	Geothrix sp. PMB-07	3068640	Bacteria	Bacteria	165	2.77e-36	NTclustered	gi\|2563347696\|gb\|CP132333.1\|	3068640	g9092	i0	82.412	0.799196787148594	199	26	80	5	39	237	538145	537956	Geothrix sp. PMB-07 chromosome, complete genome	blastn	199	165	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. PMB-07
18825970	18825970	PRJNA986547_P_NODE_3955_length_291_cov_3.128440_g3873_i0	PRJNA986547	3955	291	3.12844	9.1037604	Edaphobacter flagellatus	1933044	Bacteria	Bacteria	117	9.43e-22	NTclustered	gi\|2304905232\|gb\|CP073697.1\|	1933044	g3873	i0	90.805	10.1718213058419	87	8	30	0	1	87	2946982	2946896	Edaphobacter flagellatus strain HZ411 chromosome, complete genome	blastn	2960	117	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter flagellatus
22651175	22651175	PRJNA986547_P_NODE_1298_length_396_cov_4.117647_g1216_i0	PRJNA986547	1298	396	4.117647	16.30588212	Chloracidobacterium validum	2821543	Bacteria	Bacteria	202	3.5599999999999996e-47	NTclustered	gi\|2033661925\|gb\|CP072649.1\|	2821543	g1216	i0	92.254	2.77272727272727	142	11	36	0	126	267	512518	512377	Chloracidobacterium validum strain BV2-C chromosome 2, complete sequence	blastn	1098	202	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium validum
25200323	25200323	PRJNA986547_P_NODE_14480_length_225_cov_4.743421_g14398_i0	PRJNA986547	14480	225	4.743421	10.67269725	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	80.5	9.18e-11	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g14398	i0	91.379	0.257777777777778	58	5	26	0	84	141	2324429	2324372	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	58	80.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
25200422	25200422	PRJNA986547_P_NODE_5000_length_279_cov_2.291262_g4918_i0	PRJNA986547	5000	279	2.291262	6.39262098	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	239	1.84e-58	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g4918	i0	83.594	2.83512544802867	256	40	91	2	1	255	4825959	4826213	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	791	239	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);;