metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA1059246" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA1059246" 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
176963	176963	PRJNA1059246_P_NODE_29641_length_403_cov_1.633333_g29016_i0	PRJNA1059246	29641	403	1.633333	6.58233199	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|2893358397\|emb\|OZ220688.1\|	2651171	g29016	i0	100	0.0719602977667494	29	0	7	0	124	152	4550005	4549977	MAG: Thermoanaerobaculia bacterium isolate 17c936d4-adfa-4882-ba3e-7fd0bc385902 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
177511	177511	PRJNA1059246_P_NODE_70741_length_243_cov_0.870588_g70115_i0	PRJNA1059246	70741	243	0.870588	2.11552884	Bryobacterales bacterium	2026791	Bacteria	Bacteria	163	9.7e-36	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g70115	i0	97.872	35.0493827160494	94	2	39	0	1	94	2772281	2772188	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	8517	163	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
1451452	1451452	PRJNA1059246_P_NODE_21322_length_490_cov_1.836930_g20703_i0	PRJNA1059246	21322	490	1.83693	9.000957	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	547	5e-151	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g20703	i0	87.195	130.263265306122	492	49	100	6	1	490	3557827	3557348	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	63829	547	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
4003753	4003753	PRJNA1059246_P_NODE_584_length_2695_cov_2.324943_g521_i0	PRJNA1059246	584	2695	2.324943	62.65721385	Tunturiibacter empetritectus	3069691	Bacteria	Bacteria	82.4	3.57e-10	NTclustered	gi\|2750692779\|gb\|CP132932.1\|	3069691	g521	i0	96	0.36178107606679	50	2	2	0	2271	2320	1035522	1035473	Tunturiibacter empetritectus strain M8UP23 chromosome	blastn	975	82.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Tunturiibacter	Tunturiibacter empetritectus
4003768	4003768	PRJNA1059246_P_NODE_60004_length_256_cov_1.683060_g59378_i0	PRJNA1059246	60004	256	1.68306	4.3086336	Bryobacterales bacterium	2026791	Bacteria	Bacteria	230	1e-55	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g59378	i0	82.946	10.48828125	258	40	100	4	1	256	6659362	6659617	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	2685	230	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
4839603	4839603	PRJNA1059246_P_NODE_69144_length_244_cov_0.900585_g68518_i0	PRJNA1059246	69144	244	0.900585	2.1974274	Holophagaceae	574976	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|84452199\|emb\|AM180897.1\|	171953	g68518	i0	100	1.60655737704918	28	0	11	0	10	37	1030	1057	Uncultured Acidobacteria bacterium partial 23S rRNA gene, clone LS_LKC11_kan4	blastn	392	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5279976	5279976	PRJNA1059246_P_NODE_51865_length_283_cov_2.385714_g51239_i0	PRJNA1059246	51865	283	2.385714	6.75157062	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	394	3.77e-105	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g51239	i0	91.667	244.070671378092	288	19	100	1	1	283	634275	634562	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	69072	394	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
5280192	5280192	PRJNA1059246_P_NODE_69585_length_244_cov_0.900585_g68959_i0	PRJNA1059246	69585	244	0.900585	2.1974274	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	93.5	1.3e-14	NTclustered	gi\|2621704939\|emb\|OY762226.1\|	2910147	g68959	i0	78.767	1.55737704918033	146	25	59	6	102	244	5808508	5808650	MAG: Vicinamibacterales bacterium isolate 0d5134ca-f8ab-4963-ab29-a032ed897002 genome assembly, chromosome: 1	blastn	380	93.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
6554745	6554745	PRJNA1059246_P_NODE_19066_length_524_cov_2.033259_g18448_i0	PRJNA1059246	19066	524	2.033259	10.65427716	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	710	0	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g18448	i0	91.098	187.833969465649	528	41	100	5	1	524	4356169	4355644	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	98425	710	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6555262	6555262	PRJNA1059246_P_NODE_60466_length_254_cov_6.679558_g59840_i0	PRJNA1059246	60466	254	6.679558	16.96607732	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	387	5.569999999999998e-103	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g59840	i0	94.094	97.2716535433071	254	15	100	0	1	254	11320	11573	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	24707	387	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6555285	6555285	PRJNA1059246_P_NODE_62106_length_251_cov_0.865169_g61480_i0	PRJNA1059246	62106	251	0.865169	2.17157419	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	187	5.98e-43	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g61480	i0	80.242	28.6772908366534	248	49	99	0	4	251	2609112	2608865	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	7198	187	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
7829923	7829923	PRJNA1059246_P_NODE_62227_length_251_cov_0.865169_g61601_i0	PRJNA1059246	62227	251	0.865169	2.17157419	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	132	2.84e-26	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g61601	i0	87.611	32.5697211155378	113	14	45	0	22	134	1743132	1743244	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	8175	132	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9104646	9104646	PRJNA1059246_P_NODE_36208_length_357_cov_6.936620_g35582_i0	PRJNA1059246	36208	357	6.93662	24.7637334	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	616	9.559999999999999e-172	NTclustered	gi\|339646197\|gb\|JN038586.1\|	171953	g35582	i0	97.759	98.5182072829132	357	8	100	0	1	357	360	4	Uncultured Acidobacteria bacterium clone MA-R3 16S ribosomal RNA gene, partial sequence	blastn	35171	616	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9104722	9104722	PRJNA1059246_P_NODE_42988_length_321_cov_2.810484_g42362_i0	PRJNA1059246	42988	321	2.810484	9.02165364	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	503	6.92e-138	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g42362	i0	95.016	99.3707165109034	321	14	100	2	1	321	1822094	1821776	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	31898	503	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
10380727	10380727	PRJNA1059246_P_NODE_68609_length_245_cov_0.895349_g67983_i0	PRJNA1059246	68609	245	0.895349	2.19360505	Luteitalea pratensis	1855912	Bacteria	Bacteria	281	2.59e-71	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g67983	i0	87.347	1	245	31	100	0	1	245	2157676	2157432	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	245	281	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
10380761	10380761	PRJNA1059246_P_NODE_71589_length_242_cov_0.911243_g70963_i0	PRJNA1059246	71589	242	0.911243	2.20520806	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	104	5.93e-18	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g70963	i0	82.759	3.56198347107438	116	20	48	0	42	157	1503686	1503801	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	862	104	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11655353	11655353	PRJNA1059246_P_NODE_19810_length_512_cov_1.478360_g19192_i0	PRJNA1059246	19810	512	1.47836	7.5692032	Granulicella sp. 5B5	1617967	Bacteria	Bacteria	333	1.6e-86	NTclustered	gi\|1886125103\|gb\|CP046444.1\|	1617967	g19192	i0	79.216	95.71875	510	82	97	20	5	502	2542937	2543434	Granulicella sp. 5B5 chromosome, complete genome	blastn	49008	333	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella sp. 5B5
12930633	12930633	PRJNA1059246_P_NODE_27751_length_419_cov_2.115607_g27126_i0	PRJNA1059246	27751	419	2.115607	8.86439333	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	573	6.959999999999999e-159	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g27126	i0	91.866	130.114558472554	418	23	99	9	5	419	359860	360269	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	54518	573	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
14206059	14206059	PRJNA1059246_P_NODE_66432_length_247_cov_0.885057_g65806_i0	PRJNA1059246	66432	247	0.885057	2.18609079	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	226	1.2399999999999997e-54	NTclustered	gi\|31789410\|gb\|AY281354.1\|	171953	g65806	i0	88.77	68.6356275303644	187	17	100	4	1	185	38057	38241	Uncultured Acidobacteria bacterium clone 38c7 genomic sequence	blastn	16953	226	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15039220	15039220	PRJNA1059246_P_NODE_55512_length_272_cov_1.281407_g54886_i0	PRJNA1059246	55512	272	1.281407	3.48542704	Luteitalea	2004797	Bacteria	Bacteria	329	1.0299999999999998e-85	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g54886	i0	88.686	308.011029411765	274	25	100	4	1	272	656220	655951	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	83779	329	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
16754031	16754031	PRJNA1059246_P_NODE_41974_length_326_cov_1.952569_g41348_i0	PRJNA1059246	41974	326	1.952569	6.36537494	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	525	1.5e-144	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g41348	i0	95.706	162.355828220859	326	14	100	0	1	326	10726	11051	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	52928	525	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18028807	18028807	PRJNA1059246_P_NODE_36755_length_354_cov_2.483986_g36129_i0	PRJNA1059246	36755	354	2.483986	8.79331044	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	521	2.1199999999999993e-143	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g36129	i0	93.239	446.415254237288	355	22	100	2	1	354	4355640	4355993	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	158031	521	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18028815	18028815	PRJNA1059246_P_NODE_37815_length_348_cov_2.229091_g37189_i0	PRJNA1059246	37815	348	2.229091	7.75723668	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	566	9.519999999999999e-157	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g37189	i0	95.989	121.229885057471	349	12	100	2	1	348	640724	640377	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	42188	566	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
18028840	18028840	PRJNA1059246_P_NODE_40615_length_333_cov_2.446154_g39989_i0	PRJNA1059246	40615	333	2.446154	8.14569282	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	532	9.19e-147	NTclustered	gi\|2874254056\|emb\|OY970380.1\|	2651171	g39989	i0	95.495	225.702702702703	333	15	100	0	1	333	2980624	2980956	MAG: Thermoanaerobaculia bacterium isolate MFD05537.bin.c.2 genome assembly, chromosome: 1	blastn	75159	532	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
21413621	21413621	PRJNA1059246_P_NODE_57877_length_264_cov_1.287958_g57251_i0	PRJNA1059246	57877	264	1.287958	3.40020912	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	377	3.4999999999999996e-100	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g57251	i0	95.745	126.268939393939	235	8	88	1	1	233	3300015	3299781	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	33335	377	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
21853755	21853755	PRJNA1059246_P_NODE_24578_length_452_cov_1.155673_g23954_i0	PRJNA1059246	24578	452	1.155673	5.22364196	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	625	2.06e-174	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g23954	i0	91.611	111.639380530973	453	37	100	1	1	452	2908444	2908896	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	50461	625	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21853886	21853886	PRJNA1059246_P_NODE_36918_length_353_cov_2.385714_g36292_i0	PRJNA1059246	36918	353	2.385714	8.42157042	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	538	2.1e-148	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g36292	i0	97.17	90.8328611898017	318	9	100	0	36	353	11075	11392	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	32064	538	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23129391	23129391	PRJNA1059246_P_NODE_39699_length_338_cov_1.701887_g39073_i0	PRJNA1059246	39699	338	1.701887	5.75237806	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	460	4.4699999999999997e-125	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g39073	i0	91.42	108.62426035503	338	25	99	4	3	338	633901	634236	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	36715	460	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
23129456	23129456	PRJNA1059246_P_NODE_439_length_2971_cov_4.119393_g389_i0	PRJNA1059246	439	2971	4.119393	122.38716603	Tunturiibacter gelidiferens	3069689	Bacteria	Bacteria	65.8	3.97e-5	NTclustered	gi\|2750677617\|gb\|CP132938.1\|	3069689	g389	i0	93.182	0.244698754628071	44	3	1	0	1855	1898	318616	318659	Tunturiibacter gelidoferens strain M8UP39 chromosome	blastn	727	65.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Tunturiibacter	Tunturiibacter gelidiferens
23129773	23129773	PRJNA1059246_P_NODE_71499_length_242_cov_0.911243_g70873_i0	PRJNA1059246	71499	242	0.911243	2.20520806	Mesoterricola sediminis	2927980	Bacteria	Bacteria	165	2.68e-36	NTclustered	gi\|2490895851\|dbj\|AP027081.1\|	2927980	g70873	i0	81.373	62.3884297520661	204	36	84	2	13	215	682304	682102	Mesoterricola sediminis W786 DNA, complete genome	blastn	15098	165	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Mesoterricola	Mesoterricola sediminis
24402712	24402712	PRJNA1059246_P_NODE_14300_length_622_cov_1.630237_g13706_i0	PRJNA1059246	14300	622	1.630237	10.14007414	Paludibaculum fermentans	1473598	Bacteria	Bacteria	599	1.7599999999999994e-166	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g13706	i0	84.395	91.4501607717042	628	78	100	16	1	622	4785850	4786463	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	56882	599	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
24403114	24403114	PRJNA1059246_P_NODE_46020_length_307_cov_1.696581_g45394_i0	PRJNA1059246	46020	307	1.696581	5.20850367	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	150	9.869999999999998e-32	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g45394	i0	84.516	3.85016286644951	155	21	50	3	12	164	3097074	3097227	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	1182	150	1	Bacteria	Pseudomonadati	Acidobacteriota					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);;