metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA1245487" and tax

22 rows where analysis = "blastn", 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
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

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);;