metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA1160211" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA1160211" 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
310579	310579	PRJNA1160211_S_NODE_53461_length_565_cov_27.957317_g52289_i0	PRJNA1160211	53461	565	27.957317	157.95884105	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	75	1.19e-8	NTclustered	gi\|2874253959\|emb\|OY970284.1\|	2651171	g52289	i0	86.301	0.330973451327434	73	4	12	6	344	413	5357218	5357287	MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1	blastn	187	75	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
310664	310664	PRJNA1160211_S_NODE_64701_length_535_cov_3.645022_g63504_i0	PRJNA1160211	64701	535	3.645022	19.5008677	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	808	0	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g63504	i0	94.798	91.7738317757009	519	25	97	2	18	535	4355616	4356133	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	49099	808	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1585385	1585385	PRJNA1160211_S_NODE_76142_length_507_cov_4.843318_g74928_i0	PRJNA1160211	76142	507	4.843318	24.55562226	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	651	0	NTclustered	gi\|112980875\|gb\|DQ829679.1\|	171953	g74928	i0	90.928	174.562130177515	485	42	95	2	24	507	43	526	Uncultured Acidobacteria bacterium clone DON5 23S ribosomal RNA gene, partial sequence	blastn	88503	651	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2859865	2859865	PRJNA1160211_S_NODE_110923_length_437_cov_3.065934_g109694_i0	PRJNA1160211	110923	437	3.065934	13.39813158	Geothrix sp. 21YS21S-2	3068893	Bacteria	Bacteria	52.8	0.042	NTclustered	gi\|2566094019\|gb\|CP132910.1\|	3068893	g109694	i0	100	0.0640732265446224	28	0	6	0	72	99	3145768	3145741	Geothrix sp. 21YS21S-2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-2
2861559	2861559	PRJNA1160211_S_NODE_70603_length_520_cov_5.246085_g69396_i0	PRJNA1160211	70603	520	5.246085	27.279642	Luteitalea pratensis	1855912	Bacteria	Bacteria	819	0	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g69396	i0	96.378	104.859615384615	497	18	96	0	1	497	653746	653250	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	54527	819	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
5412728	5412728	PRJNA1160211_S_NODE_203345_length_307_cov_1.974359_g202112_i0	PRJNA1160211	203345	307	1.974359	6.06128213	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	523	5.049999999999998e-144	NTclustered	gi\|76574295\|gb\|DQ139443.1\|	171953	g202112	i0	97.394	105.71661237785	307	8	100	0	1	307	595	901	Uncultured Acidobacteria bacterium clone CAL2 23S ribosomal RNA gene, partial sequence	blastn	32455	523	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5413709	5413709	PRJNA1160211_S_NODE_65585_length_532_cov_41.588235_g64386_i0	PRJNA1160211	65585	532	41.588235	221.2494102	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	54.7	0.015	NTclustered	gi\|2891481964\|emb\|OZ219745.1\|	2910147	g64386	i0	100	0.109022556390977	29	0	5	0	300	328	169584	169556	MAG: Vicinamibacterales bacterium isolate d5a9b4ee-eb88-4731-bb2c-80bf662b4d04 genome assembly, chromosome: 2	blastn	58	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
6687133	6687133	PRJNA1160211_S_NODE_136686_length_394_cov_7.616822_g135454_i0	PRJNA1160211	136686	394	7.616822	30.01027868	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	409	1.94e-109	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g135454	i0	87.052	133.390862944162	363	46	92	1	23	384	3298163	3298525	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	52556	409	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
6688781	6688781	PRJNA1160211_S_NODE_87446_length_482_cov_10.674817_g86224_i0	PRJNA1160211	87446	482	10.674816999999999	51.45261794	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	532	1.38e-146	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g86224	i0	87.852	90.195020746888	461	46	95	10	1	457	3557509	3557963	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	43474	532	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
7963841	7963841	PRJNA1160211_S_NODE_56387_length_557_cov_12.568182_g55210_i0	PRJNA1160211	56387	557	12.568182	70.00477374	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	599	1.5599999999999993e-166	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g55210	i0	86.989	159.879712746858	538	63	96	7	1	534	317786	317252	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	89053	599	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
9237888	9237888	PRJNA1160211_S_NODE_234028_length_276_cov_1.512315_g232795_i0	PRJNA1160211	234028	276	1.512315	4.1739894	Sulfidibacter corallicola	2818388	Bacteria	Bacteria	228	3.9299999999999985e-55	NTclustered	gi\|2013124720\|gb\|CP071793.1\|	2818388	g232795	i0	82.528	93.1739130434783	269	37	96	10	3	266	3734396	3734133	Sulfidibacter corallicola strain M133 chromosome, complete genome	blastn	25716	228	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Acanthopleuribacterales	Acanthopleuribacteraceae	Sulfidibacter	Sulfidibacter corallicola
9238306	9238306	PRJNA1160211_S_NODE_299088_length_206_cov_8.037594_g297855_i0	PRJNA1160211	299088	206	8.037594	16.55744364	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	213	7.81e-51	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g297855	i0	87.634	24.2912621359223	186	20	89	3	23	206	317248	317432	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	5004	213	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
13063014	13063014	PRJNA1160211_S_NODE_160411_length_360_cov_3.881533_g159178_i0	PRJNA1160211	160411	360	3.881533	13.9735188	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	396	1.37e-105	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g159178	i0	87.324	93.6916666666667	355	34	97	10	11	360	716248	715900	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	33729	396	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14338037	14338037	PRJNA1160211_S_NODE_119752_length_421_cov_15.183908_g118523_i0	PRJNA1160211	119752	421	15.183908	63.92425268	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	496	1.56e-135	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g118523	i0	89.367	121.710213776722	395	41	94	1	4	398	4648794	4648401	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	51240	496	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
16341063	16341063	PRJNA1160211_S_NODE_229573_length_280_cov_1.961353_g228340_i0	PRJNA1160211	229573	280	1.961353	5.4917884	Bacteria	2	Bacteria	Bacteria	379	1.04e-100	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g228340	i0	91.003	121.2	289	14	100	8	1	280	715441	715726	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	33936	379	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18161435	18161435	PRJNA1160211_S_NODE_216915_length_292_cov_6.059361_g215682_i0	PRJNA1160211	216915	292	6.059361	17.69333412	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	383	8.45e-102	NTclustered	gi\|1015624362\|gb\|AH012920.2\|	171953	g215682	i0	92.509	89.2123287671233	267	20	91	0	1	267	29353	29619	Uncultured Acidobacteria bacterium clone 46h5 hypothetical protein, putative O-linked GlcNAc transferase, putative two-component response regulator, hypothetical protein, putative penicillin-resistance DD-carboxypeptidase, putative glycosyl transferase, hypothetical protein, conserved hypothetical protein, hypothetical protein, putative MaoC family dehydratase, putative D-3-phosphoglycerate dehydrogenase, putative magnesium and cobalt transport protein, putative phosphatidyl-glycerophosphatase, putative 2-methylthioadenine synthetase, hypothetical protein, putative glutamine cyclotransferase, and hypothetical protein genes, complete cds; 5S ribosomal RNA, 23S ribosomal RNA, tRNA-Ala, tRNA-Met, tRNA-Ile, and 16S ribosomal RNA genes, complete sequence; and hypothetical protein genes, complete cds	blastn	26050	383	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19434972	19434972	PRJNA1160211_S_NODE_105936_length_446_cov_3.305630_g104708_i0	PRJNA1160211	105936	446	3.30563	14.7431098	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	143	2.4899999999999996e-29	NTclustered	gi\|2893358444\|emb\|OZ220736.1\|	2910147	g104708	i0	73.16	3.10762331838565	462	99	99	21	2	443	503006	503462	MAG: Vicinamibacterales bacterium isolate e96e4bd8-36b5-4932-a7c8-d2011ef2eb69 genome assembly, chromosome: 1	blastn	1386	143	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
19435594	19435594	PRJNA1160211_S_NODE_190136_length_322_cov_3.377510_g188903_i0	PRJNA1160211	190136	322	3.37751	10.8755822	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	337	7.449999999999997e-88	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g188903	i0	87.797	90.6863354037267	295	26	89	7	36	321	3558269	3557976	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	29201	337	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
20712295	20712295	PRJNA1160211_S_NODE_94517_length_468_cov_3.858228_g93292_i0	PRJNA1160211	94517	468	3.858228	18.05650704	Luteitalea pratensis	1855912	Bacteria	Bacteria	793	0	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g93292	i0	97.629	284.551282051282	464	8	99	1	1	461	655179	654716	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	133170	793	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
21440984	21440984	PRJNA1160211_S_NODE_87937_length_481_cov_9.203431_g86715_i0	PRJNA1160211	87937	481	9.203431	44.26850311	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	492	2.329999999999999e-134	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g86715	i0	86.087	123.760914760915	460	60	95	4	1	458	458	1	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	59529	496	0.991935483870968	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21986221	21986221	PRJNA1160211_S_NODE_173718_length_342_cov_7.457249_g172485_i0	PRJNA1160211	173718	342	7.457249	25.50379158	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	459	1.6299999999999999e-124	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g172485	i0	92.331	107.666666666667	326	19	94	6	1	323	335	13	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	36822	459	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21986414	21986414	PRJNA1160211_S_NODE_19958_length_709_cov_55.918239_g18957_i0	PRJNA1160211	19958	709	55.918239	396.46031451	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	843	0	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g18957	i0	88.97	75.6868829337095	689	66	97	4	1	686	4840784	4840103	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	53662	843	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22715614	22715614	PRJNA1160211_S_NODE_273278_length_246_cov_0.942197_g272045_i0	PRJNA1160211	273278	246	0.942197	2.31780462	Bacteria	2	Bacteria	Bacteria	158	4.58e-34	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g272045	i0	88.462	62.1260162601626	130	15	53	0	117	246	714947	714818	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	15283	158	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24536000	24536000	PRJNA1160211_S_NODE_251860_length_260_cov_2.812834_g250627_i0	PRJNA1160211	251860	260	2.812834	7.3133684	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	327	3.52e-85	NTclustered	gi\|31789387\|gb\|AY281353.1\|	171953	g250627	i0	91.02	369.469230769231	245	18	93	4	1	243	30918	30676	Uncultured Acidobacteria bacterium clone 32d1 genomic sequence	blastn	96062	327	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24536258	24536258	PRJNA1160211_S_NODE_290900_length_230_cov_3.974522_g289667_i0	PRJNA1160211	290900	230	3.974522	9.1414006	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	224	4.11e-54	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g289667	i0	85.321	6.96521739130435	218	30	94	2	1	217	270	54	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	1602	224	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);;