metadata: contig_metadata: 29 rows where bioproject = "PRJNA1245487" and tax

29 rows where bioproject = "PRJNA1245487" 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
4178335	4178335	PRJNA1245487_P_NODE_18744_length_255_cov_3.318681_g18406_i0	PRJNA1245487	18744	255	3.318681	8.46263655	Terriglobia bacterium	2081523	Bacteria	Bacteria	424	4.26e-114	NTclustered	gi\|2874253966\|emb\|OY970291.1\|	2081523	g18406	i0	96.498	379.38431372549	257	7	100	2	1	255	141061	141317	MAG: Terriglobia bacterium isolate MFD05513.bin.c.1 genome assembly, chromosome: 1	blastn	96743	424	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
4178370	4178370	PRJNA1245487_P_NODE_21344_length_244_cov_1.754386_g21006_i0	PRJNA1245487	21344	244	1.754386	4.28070184	Blastocatellia bacterium	2052146	Bacteria	Bacteria	133	6.02e-34	NR	HET9530953.1	2052146	g21006	i0	72.2	5.76639344262295	79	22	97.1	0	1	237	813	891	HET9530953.1 PIG-L family deacetylase [Blastocatellia bacterium]	diamond	1407	133	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
5454523	5454523	PRJNA1245487_P_NODE_15005_length_292_cov_1.799087_g14667_i0	PRJNA1245487	15005	292	1.799087	5.25333404	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	381	3.0399999999999996e-101	NTclustered	gi\|2874253693\|emb\|OY969419.1\|	194844	g14667	i0	94.444	411.619863013699	252	7	85	6	1	249	5897241	5896994	MAG: uncultured Acidobacteriaceae bacterium isolate MFD03346.bin.1.13 genome assembly, chromosome: 1	blastn	120193	381	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
5454592	5454592	PRJNA1245487_P_NODE_20345_length_248_cov_1.245714_g20007_i0	PRJNA1245487	20345	248	1.245714	3.08937072	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	121	6.059999999999999e-23	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g20007	i0	81.41	3.79032258064516	156	21	61	8	6	157	4464699	4464850	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	940	121	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
7429043	7429043	PRJNA1245487_P_NODE_10006_length_377_cov_2.865132_g9668_i0	PRJNA1245487	10006	377	2.865132	10.80154764	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	508	1.77e-139	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g9668	i0	91.029	65.7320954907162	379	31	100	3	1	377	3298575	3298198	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	24781	508	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
8004339	8004339	PRJNA1245487_P_NODE_13727_length_309_cov_2.364407_g13389_i0	PRJNA1245487	13727	309	2.364407	7.30601763	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	521	1.8299999999999998e-143	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g13389	i0	97.394	136.734627831715	307	7	99	1	1	306	1689912	1689606	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	42251	521	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8004488	8004488	PRJNA1245487_P_NODE_5447_length_536_cov_6.911447_g5112_i0	PRJNA1245487	5447	536	6.911447	37.04535592	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	675	0	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g5112	i0	89.425	142.152985074627	539	51	100	5	1	536	3918092	3917557	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	76194	675	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10555264	10555264	PRJNA1245487_P_NODE_4409_length_596_cov_11.458891_g4079_i0	PRJNA1245487	4409	596	11.458891	68.29499036	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	952	0	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g4079	i0	95.485	156.337248322148	598	24	100	3	1	596	3298923	3299519	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	93177	952	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
10555310	10555310	PRJNA1245487_P_NODE_9529_length_389_cov_3.401899_g9191_i0	PRJNA1245487	9529	389	3.401899	13.23338711	Bryobacterales bacterium	2026791	Bacteria	Bacteria	525	1.8199999999999993e-144	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g9191	i0	91.049	104.611825192802	391	31	100	4	1	389	2776312	2776700	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	40694	525	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
11829684	11829684	PRJNA1245487_P_NODE_15770_length_283_cov_3.985714_g15432_i0	PRJNA1245487	15770	283	3.985714	11.27957062	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	185	2.4699999999999998e-42	NTclustered	gi\|217038898\|gb\|EU810988.1\|	171953	g15432	i0	84.103	231.982332155477	195	27	68	4	91	283	187	379	Uncultured Acidobacteria bacterium clone 01QD8 23S ribosomal RNA gene, partial sequence	blastn	65651	185	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13104881	13104881	PRJNA1245487_P_NODE_10131_length_374_cov_2.936877_g9793_i0	PRJNA1245487	10131	374	2.936877	10.98391998	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	573	6.139999999999999e-159	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g9793	i0	94.4	155.104278074866	375	18	100	3	1	374	2367720	2367348	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	58009	573	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13804857	13804857	PRJNA1245487_P_NODE_3571_length_663_cov_2.845763_g3245_i0	PRJNA1245487	3571	663	2.845763	18.86740869	Alloacidobacterium	2951993	Bacteria	Bacteria	994	0	NTclustered	gi\|1895675831\|gb\|CP060394.1\|	2763107	g3245	i0	93.825	106.770739064857	664	36	100	5	1	663	4008868	4008209	Alloacidobacterium dinghuense strain 4Y35 chromosome, complete genome	blastn	70789	994	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Alloacidobacterium	Alloacidobacterium dinghuense
15078880	15078880	PRJNA1245487_P_NODE_16912_length_271_cov_7.196970_g16574_i0	PRJNA1245487	16912	271	7.19697	19.5037887	Bacteria	2	Bacteria	Bacteria	359	1.31e-94	NTclustered	gi\|2874253940\|emb\|OY970265.1\|	171953	g16574	i0	91.288	100.405904059041	264	21	97	2	9	271	3792180	3792442	MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.1.56 genome assembly, chromosome: 1	blastn	27210	361	0.994459833795014	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15654100	15654100	PRJNA1245487_P_NODE_17733_length_264_cov_3.785340_g17395_i0	PRJNA1245487	17733	264	3.78534	9.9932976	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	248	2.87e-61	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g17395	i0	83.929	112.015151515152	280	24	99	12	3	264	3298453	3298177	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	29572	248	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
16928220	16928220	PRJNA1245487_P_NODE_11334_length_349_cov_2.985507_g10996_i0	PRJNA1245487	11334	349	2.985507	10.41941943	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	472	2.13e-128	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g10996	i0	91.117	117.14899713467	349	29	100	1	1	349	3919297	3918951	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	40885	472	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16928348	16928348	PRJNA1245487_P_NODE_21394_length_244_cov_1.087719_g21056_i0	PRJNA1245487	21394	244	1.087719	2.65403436	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	350	6.969999999999998e-92	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g21056	i0	93.033	121.83196721311501	244	9	98	7	3	241	3175343	3175583	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	29727	350	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
18202707	18202707	PRJNA1245487_P_NODE_10355_length_369_cov_3.942568_g10017_i0	PRJNA1245487	10355	369	3.942568	14.54807592	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	455	2.29e-123	NTclustered	gi\|217038899\|gb\|EU810989.1\|	171953	g10017	i0	93.485	286.241192411924	307	19	83	1	1	307	306	1	Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence	blastn	105623	455	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20752577	20752577	PRJNA1245487_P_NODE_15857_length_282_cov_4.889952_g15519_i0	PRJNA1245487	15857	282	4.889952	13.78966464	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	339	1.78e-88	NTclustered	gi\|2874253802\|emb\|OY969786.1\|	194844	g15519	i0	88.38	105.716312056738	284	29	100	4	1	282	4573164	4572883	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09671.bin.c.1 genome assembly, chromosome: 1	blastn	29812	339	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
22027812	22027812	PRJNA1245487_P_NODE_15438_length_287_cov_1.962617_g15100_i0	PRJNA1245487	15438	287	1.962617	5.63271079	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	276	1.45e-69	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g15100	i0	84.912	104.578397212544	285	30	98	12	4	284	3175501	3175776	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	30014	276	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
22728189	22728189	PRJNA1245487_P_NODE_17138_length_269_cov_2.760204_g16800_i0	PRJNA1245487	17138	269	2.760204	7.42494876	Bacteria	2	Bacteria	Bacteria	448	2.6899999999999995e-121	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g16800	i0	96.667	104.654275092937	270	7	100	2	1	269	4839854	4840122	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	28152	448	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23303482	23303482	PRJNA1245487_P_NODE_18639_length_256_cov_2.666667_g18301_i0	PRJNA1245487	18639	256	2.666667	6.82666752	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	252	2.14e-62	NTclustered	gi\|2621703956\|emb\|OY762911.1\|	2651171	g18301	i0	85.537	136.546875	242	34	94	1	16	256	474049	473808	MAG: Thermoanaerobaculia bacterium isolate 14c23368-4dca-4d55-9b94-f295180eceef genome assembly, chromosome: 1	blastn	34956	252	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
23303563	23303563	PRJNA1245487_P_NODE_6279_length_496_cov_4.569740_g5943_i0	PRJNA1245487	6279	496	4.56974	22.6659104	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	531	5.099999999999998e-146	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g5943	i0	86.056	92.3004032258064	502	60	100	9	1	496	3557923	3557426	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	45781	531	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
24003284	24003284	PRJNA1245487_P_NODE_13499_length_312_cov_3.347280_g13161_i0	PRJNA1245487	13499	312	3.34728	10.4435136	Acidobacteriaceae	204434	Bacteria	Bacteria	311	4.36e-80	NTclustered	gi\|358750971\|gb\|CP003130.1\|	682795	g13161	i0	84.906	54.8461538461538	318	37	100	11	1	312	695029	695341	Granulicella mallensis MP5ACTX8 chromosome, complete genome	blastn	17112	311	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella mallensis
29662591	29662591	PRJNA1245487_P_NODE_15470_length_287_cov_1.308411_g15132_i0	PRJNA1245487	15470	287	1.308411	3.75513957	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	75.9	1.23e-13	NR	MEO8679489.1	2910147	g15132	i0	47.3	0.773519163763066	74	36	77.4	1	231	10	32	102	MEO8679489.1 thrombospondin type-1 domain-containing protein [Vicinamibacterales bacterium]	diamond	222	75.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
29662595	29662595	PRJNA1245487_P_NODE_21470_length_244_cov_0.912281_g21132_i0	PRJNA1245487	21470	244	0.912281	2.22596564	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	80.9	8.08e-17	NR	PYS87729.1	1978231	g21132	i0	58.7	0.922131147540984	75	31	92.2	0	242	18	111	185	PYS87729.1 MAG: hypothetical protein DMF62_11470 [Acidobacteriota bacterium]	diamond	225	80.9	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31228901	31228901	PRJNA1245487_P_NODE_20475_length_248_cov_0.891429_g20137_i0	PRJNA1245487	20475	248	0.891429	2.21074392	Bacteria	2	Bacteria	Bacteria	98.2	1.2300000000000002e-21	NR	MBK6587192.1	1978231	g20137	i0	67.9	1.88709677419355	78	23	91.9	1	230	3	875	952	MBK6587192.1 LamG domain-containing protein [Acidobacteriota bacterium]	diamond	468	98.2	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31292283	31292283	PRJNA1245487_P_NODE_22035_length_242_cov_0.923077_g21697_i0	PRJNA1245487	22035	242	0.923077	2.23384634	Bacteria	2	Bacteria	Bacteria	152	1.04e-40	NR	MEP7149289.1	1978231	g21697	i0	93.8	1.98347107438017	80	5	99.2	0	242	3	102	181	MEP7149289.1 efflux RND transporter permease subunit [Acidobacteriota bacterium]	diamond	480	152	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31938366	31938366	PRJNA1245487_P_NODE_19957_length_250_cov_0.881356_g19619_i0	PRJNA1245487	19957	250	0.881356	2.20339	Candidatus Angelobacter sp.	2976921	Bacteria	Bacteria	56.2	5.39e-7	NR	HXA27752.1	2976921	g19619	i0	47.2	1.692	53	28	63.6	0	161	3	4	56	HXA27752.1 thioesterase family protein [Candidatus Angelobacter sp.]	diamond	423	56.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia			Candidatus Angelobacter	Candidatus Angelobacter sp.
32413258	32413258	PRJNA1245487_P_NODE_15819_length_283_cov_1.485714_g15481_i0	PRJNA1245487	15819	283	1.485714	4.20457062	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	74.3	4.2e-13	NR	MEW6732442.1	1978231	g15481	i0	63	0.975265017667845	92	29	93.3	2	9	272	208	298	MEW6732442.1 hypothetical protein [Acidobacteriota bacterium]	diamond	276	74.3	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);;