metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA429937" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA429937" 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
425696	425696	PRJNA429937_P_NODE_116121_length_258_cov_3.179039_g93495_i0	PRJNA429937	116121	258	3.179039	8.20192062	Terriglobia bacterium	2081523	Bacteria	Bacteria	344	3.46e-90	NTclustered	gi\|2874253966\|emb\|OY970291.1\|	2081523	g93495	i0	94.248	62.577519379845	226	12	87	1	1	225	141538	141763	MAG: Terriglobia bacterium isolate MFD05513.bin.c.1 genome assembly, chromosome: 1	blastn	16145	344	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
1701249	1701249	PRJNA429937_P_NODE_28022_length_691_cov_2.478852_g16907_i0	PRJNA429937	28022	691	2.478852	17.12886732	Edaphobacter sp. 12200R-103	2703788	Bacteria	Bacteria	122	5.1799999999999987e-23	NTclustered	gi\|1804497213\|gb\|CP048114.1\|	2703788	g16907	i0	90.323	2.4862518089725	93	9	13	0	566	658	2787980	2788072	Edaphobacter sp. 12200R-103 chromosome, complete genome	blastn	1718	122	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter sp. 12200R-103
1701258	1701258	PRJNA429937_P_NODE_28322_length_686_cov_4.185693_g15048_i3	PRJNA429937	28322	686	4.185693	28.71385398	Granulicella mallensis	940614	Bacteria	Bacteria	165	8.43e-36	NTclustered	gi\|358750971\|gb\|CP003130.1\|	682795	g15048	i3	80.275	14.4256559766764	218	43	32	0	185	402	647800	648017	Granulicella mallensis MP5ACTX8 chromosome, complete genome	blastn	9896	165	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella mallensis
1702473	1702473	PRJNA429937_P_NODE_89762_length_334_cov_2.914754_g67188_i0	PRJNA429937	89762	334	2.914754	9.73527836	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	305	2.19e-78	NTclustered	gi\|2621704042\|emb\|OY760734.1\|	2910147	g67188	i0	87.739	76.3502994011976	261	32	78	0	3	263	3984503	3984763	MAG: Vicinamibacterales bacterium isolate 10b48155-431e-4809-9d43-759f23ff96f9 genome assembly, chromosome: 1	blastn	25501	305	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
2977785	2977785	PRJNA429937_P_NODE_60463_length_445_cov_3.045673_g40678_i0	PRJNA429937	60463	445	3.045673	13.55324485	Geothrix sp. 21YS21S-2	3068893	Bacteria	Bacteria	159	2.47e-34	NTclustered	gi\|2566094019\|gb\|CP132910.1\|	3068893	g40678	i0	83.051	4.93033707865169	177	28	40	2	14	189	4563590	4563415	Geothrix sp. 21YS21S-2 chromosome, complete genome	blastn	2194	159	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-2
4252763	4252763	PRJNA429937_P_NODE_122644_length_242_cov_1.624413_g100018_i0	PRJNA429937	122644	242	1.624413	3.93107946	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	143	1.2599999999999998e-29	NTclustered	gi\|2874253889\|emb\|OY970064.1\|	194844	g100018	i0	96.512	30.1446280991736	86	3	67	0	1	86	1411239	1411154	MAG: uncultured Acidobacteriaceae bacterium isolate MFD06092.bin.c.1 genome assembly, chromosome: 1	blastn	7295	143	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
4254533	4254533	PRJNA429937_P_NODE_90084_length_333_cov_2.944079_g67509_i0	PRJNA429937	90084	333	2.944079	9.80378307	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	309	1.6900000000000002e-79	NTclustered	gi\|2621704042\|emb\|OY760734.1\|	2910147	g67509	i0	87.594	76.996996996997	266	33	80	0	1	266	3984763	3984498	MAG: Vicinamibacterales bacterium isolate 10b48155-431e-4809-9d43-759f23ff96f9 genome assembly, chromosome: 1	blastn	25640	309	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
4915501	4915501	PRJNA429937_P_NODE_155544_length_161_cov_3.689394_g132917_i0	PRJNA429937	155544	161	3.689394	5.93992434	Candidatus Solibacter	332162	Bacteria	Bacteria	279	5.64e-71	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g132917	i0	98.125	51.1801242236025	160	3	99	0	1	160	585	744	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	8240	279	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus
4915831	4915831	PRJNA429937_P_NODE_73044_length_391_cov_2.403315_g51157_i0	PRJNA429937	73044	391	2.403315	9.39696165	Occallatibacter	1742983	Bacteria	Bacteria	62.1	6.21e-5	NTclustered	gi\|2874253852\|emb\|OY969908.1\|	194844	g51157	i0	95	0.39386189258312	40	1	10	1	4	42	5570561	5570600	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09286.bin.1.44 genome assembly, chromosome: 1	blastn	154	62.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
6804782	6804782	PRJNA429937_P_NODE_58866_length_452_cov_77.510638_g39461_i0	PRJNA429937	58866	452	77.510638	350.34808376	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	652	0	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g39461	i0	93.968	99.3296460176991	431	26	95	0	22	452	2907970	2907540	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	44897	652	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8079640	8079640	PRJNA429937_P_NODE_25187_length_731_cov_4.024217_g15048_i0	PRJNA429937	25187	731	4.024217	29.41702627	Granulicella mallensis	940614	Bacteria	Bacteria	165	9.01e-36	NTclustered	gi\|358750971\|gb\|CP003130.1\|	682795	g15048	i0	80.275	13.5376196990424	218	43	30	0	129	346	647800	648017	Granulicella mallensis MP5ACTX8 chromosome, complete genome	blastn	9896	165	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella mallensis
8081000	8081000	PRJNA429937_P_NODE_96687_length_312_cov_2.833922_g74088_i0	PRJNA429937	96687	312	2.833922	8.84183664	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	305	2.03e-78	NTclustered	gi\|2621704042\|emb\|OY760734.1\|	2910147	g74088	i0	87.739	81.4967948717949	261	32	84	0	3	263	3984503	3984763	MAG: Vicinamibacterales bacterium isolate 10b48155-431e-4809-9d43-759f23ff96f9 genome assembly, chromosome: 1	blastn	25427	305	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
9354560	9354560	PRJNA429937_P_NODE_28928_length_678_cov_4.058552_g15048_i4	PRJNA429937	28928	678	4.058552	27.51698256	Granulicella mallensis	940614	Bacteria	Bacteria	165	8.320000000000001e-36	NTclustered	gi\|358750971\|gb\|CP003130.1\|	682795	g15048	i4	80.275	14.5958702064897	218	43	32	0	129	346	647800	648017	Granulicella mallensis MP5ACTX8 chromosome, complete genome	blastn	9896	165	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella mallensis
9355690	9355690	PRJNA429937_P_NODE_85808_length_347_cov_2.713836_g63271_i0	PRJNA429937	85808	347	2.713836	9.41701092	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	305	2.28e-78	NTclustered	gi\|2621704042\|emb\|OY760734.1\|	2910147	g63271	i0	87.739	73.2766570605187	261	32	75	0	3	263	3984503	3984763	MAG: Vicinamibacterales bacterium isolate 10b48155-431e-4809-9d43-759f23ff96f9 genome assembly, chromosome: 1	blastn	25427	305	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
10630179	10630179	PRJNA429937_P_NODE_24049_length_749_cov_2.225000_g14362_i0	PRJNA429937	24049	749	2.225	16.66525	Edaphobacter sp. 12200R-103	2703788	Bacteria	Bacteria	122	5.64e-23	NTclustered	gi\|1804497213\|gb\|CP048114.1\|	2703788	g14362	i0	90.323	2.29372496662216	93	9	12	0	624	716	2787980	2788072	Edaphobacter sp. 12200R-103 chromosome, complete genome	blastn	1718	122	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter sp. 12200R-103
11905252	11905252	PRJNA429937_P_NODE_32570_length_636_cov_3.172982_g19994_i0	PRJNA429937	32570	636	3.172982	20.18016552	Acidisarcina polymorpha	2211140	Bacteria	Bacteria	224	1.27e-53	NTclustered	gi\|1431854037\|gb\|CP030840.1\|	2211140	g19994	i0	77.344	0.60377358490566	384	83	60	3	253	634	4814845	4814464	Acidisarcina polymorpha strain SBC82 chromosome, complete genome	blastn	384	224	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidisarcina	Acidisarcina polymorpha
14455710	14455710	PRJNA429937_P_NODE_47252_length_518_cov_2.897751_g30629_i0	PRJNA429937	47252	518	2.897751	15.01035018	Luteitalea pratensis	1855912	Bacteria	Bacteria	169	4.83e-37	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g30629	i0	88.971	0.262548262548263	136	15	26	0	283	418	2097278	2097143	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	136	169	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
15728996	15728996	PRJNA429937_P_NODE_25593_length_725_cov_2.314655_g15303_i0	PRJNA429937	25593	725	2.314655	16.78124875	Edaphobacter sp. 12200R-103	2703788	Bacteria	Bacteria	122	5.449999999999999e-23	NTclustered	gi\|1804497213\|gb\|CP048114.1\|	2703788	g15303	i0	90.323	2.36965517241379	93	9	13	0	600	692	2787980	2788072	Edaphobacter sp. 12200R-103 chromosome, complete genome	blastn	1718	122	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter sp. 12200R-103
15729604	15729604	PRJNA429937_P_NODE_52113_length_488_cov_48.089325_g34294_i0	PRJNA429937	52113	488	48.089325	234.675906	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	625	2.2399999999999995e-174	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g34294	i0	90.249	122.907786885246	482	42	98	5	1	480	2907524	2907046	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	59979	625	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
17002831	17002831	PRJNA429937_P_NODE_100854_length_299_cov_27.644444_g78243_i0	PRJNA429937	100854	299	27.644444	82.65688756	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	398	3.1000000000000003e-106	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g78243	i0	92.171	94.8628762541806	281	22	94	0	19	299	2365655	2365935	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	28364	398	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
17003672	17003672	PRJNA429937_P_NODE_27614_length_696_cov_3.923538_g15048_i1	PRJNA429937	27614	696	3.923538	27.30782448	Granulicella mallensis	940614	Bacteria	Bacteria	165	8.56e-36	NTclustered	gi\|358750971\|gb\|CP003130.1\|	682795	g15048	i1	80.275	14.2183908045977	218	43	31	0	129	346	647800	648017	Granulicella mallensis MP5ACTX8 chromosome, complete genome	blastn	9896	165	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella mallensis
18278031	18278031	PRJNA429937_P_NODE_28115_length_689_cov_3.977273_g15048_i2	PRJNA429937	28115	689	3.977273	27.40341097	Granulicella mallensis	940614	Bacteria	Bacteria	165	8.46e-36	NTclustered	gi\|358750971\|gb\|CP003130.1\|	682795	g15048	i2	80.275	14.3628447024673	218	43	32	0	188	405	647800	648017	Granulicella mallensis MP5ACTX8 chromosome, complete genome	blastn	9896	165	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella mallensis
20828849	20828849	PRJNA429937_P_NODE_64877_length_424_cov_6.336709_g44209_i0	PRJNA429937	64877	424	6.336709	26.86764616	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	374	7.679999999999998e-99	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g44209	i0	83.623	103.408018867925	403	60	94	6	1	400	4731857	4732256	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	43845	374	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20829315	20829315	PRJNA429937_P_NODE_93737_length_321_cov_3.010274_g71147_i0	PRJNA429937	93737	321	3.010274	9.66297954	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	309	1.62e-79	NTclustered	gi\|2621704042\|emb\|OY760734.1\|	2910147	g71147	i0	84.036	88.3333333333333	332	42	100	3	1	321	3984432	3984763	MAG: Vicinamibacterales bacterium isolate 10b48155-431e-4809-9d43-759f23ff96f9 genome assembly, chromosome: 1	blastn	28355	309	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
22103661	22103661	PRJNA429937_P_NODE_61638_length_439_cov_3.648780_g41607_i0	PRJNA429937	61638	439	3.64878	16.0181442	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	470	9.889999999999998e-128	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g41607	i0	85.965	100.626423690205	456	45	100	10	1	439	635148	635601	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	44175	470	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
22104230	22104230	PRJNA429937_P_NODE_95978_length_314_cov_3.333333_g73381_i0	PRJNA429937	95978	314	3.333333	10.46666562	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	366	9.24e-97	NTclustered	gi\|2621704042\|emb\|OY760734.1\|	2910147	g73381	i0	87.821	97.2006369426752	312	38	99	0	3	314	3984503	3984814	MAG: Vicinamibacterales bacterium isolate 10b48155-431e-4809-9d43-759f23ff96f9 genome assembly, chromosome: 1	blastn	30521	366	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
23379232	23379232	PRJNA429937_P_NODE_60419_length_445_cov_3.790865_g40651_i0	PRJNA429937	60419	445	3.790865	16.86934925	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	518	3.53e-142	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g40651	i0	87.472	94.076404494382	447	47	100	6	1	445	635162	635601	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	41864	518	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
23379731	23379731	PRJNA429937_P_NODE_88559_length_338_cov_2.906149_g65991_i0	PRJNA429937	88559	338	2.906149	9.82278362	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	305	2.22e-78	NTclustered	gi\|2621704042\|emb\|OY760734.1\|	2910147	g65991	i0	87.739	74.094674556213	261	32	77	0	1	261	3984763	3984503	MAG: Vicinamibacterales bacterium isolate 10b48155-431e-4809-9d43-759f23ff96f9 genome assembly, chromosome: 1	blastn	25044	305	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
25313383	25313383	PRJNA429937_P_NODE_112320_length_268_cov_2.983264_g89697_i0	PRJNA429937	112320	268	2.983264	7.99514752	Bacteria	2	Bacteria	Bacteria	412	9.77e-111	NTclustered	gi\|112980876\|gb\|DQ829680.1\|	171953	g89697	i0	94.717	86.3917910447761	265	14	99	0	4	268	1433	1169	Uncultured Acidobacteria bacterium clone DON6 23S ribosomal RNA gene, partial sequence	blastn	23153	412	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);;