metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA1002570" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA1002570" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
152127	152127	PRJNA1002570_P_NODE_15881_length_310_cov_2.810127_g15686_i0	PRJNA1002570	15881	310	2.810127	8.7113937	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	165	3.57e-36	NTclustered	gi\|2874253959\|emb\|OY970284.1\|	2651171	g15686	i0	87.413	9.82258064516129	143	18	46	0	165	307	3835786	3835928	MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1	blastn	3045	165	1	Bacteria		Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
152411	152411	PRJNA1002570_P_NODE_31841_length_262_cov_1.947090_g31646_i0	PRJNA1002570	31841	262	1.94709	5.1013758	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	172	1.76e-38	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g31646	i0	80.531	51.2709923664122	226	43	86	1	24	248	1310044	1309819	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	13433	172	1	Bacteria		Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
152495	152495	PRJNA1002570_P_NODE_37181_length_250_cov_0.870056_g36986_i0	PRJNA1002570	37181	250	0.870056	2.17514	Alloacidobacterium dinghuense	2763107	Bacteria	Bacteria	220	5.87e-53	NTclustered	gi\|1895675831\|gb\|CP060394.1\|	2763107	g36986	i0	83.83	94.22	235	34	93	4	3	235	296253	296485	Alloacidobacterium dinghuense strain 4Y35 chromosome, complete genome	blastn	23555	220	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Alloacidobacterium	Alloacidobacterium dinghuense
152606	152606	PRJNA1002570_P_NODE_43801_length_241_cov_1.672619_g43606_i0	PRJNA1002570	43801	241	1.672619	4.03101179	Acidobacterium capsulatum	33075	Bacteria	Bacteria	167	7.429999999999999e-37	NTclustered	gi\|225791207\|gb\|CP001472.1\|	240015	g43606	i0	81.683	5.02904564315353	202	35	83	2	39	239	3388130	3387930	Acidobacterium capsulatum ATCC 51196, complete genome	blastn	1212	167	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidobacterium	Acidobacterium capsulatum
1000572	1000572	PRJNA1002570_P_NODE_15701_length_310_cov_2.983122_g15506_i0	PRJNA1002570	15701	310	2.983122	9.2476782	Chloracidobacterium	458032	Bacteria	Bacteria	102	2.84e-17	NTclustered	gi\|2033643721\|gb\|CP072637.1\|	2821537	g15506	i0	86.17	4.28064516129032	94	13	30	0	54	147	342771	342678	Chloracidobacterium sp. 2 chromosome 2, complete sequence	blastn	1327	102	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium aggregatum
1426930	1426930	PRJNA1002570_P_NODE_19602_length_291_cov_2.637615_g19407_i0	PRJNA1002570	19602	291	2.637615	7.67545965	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	87.9	7.39e-13	NTclustered	gi\|2621704042\|emb\|OY760734.1\|	2910147	g19407	i0	91.935	17.0034364261168	62	5	21	0	64	125	5574577	5574638	MAG: Vicinamibacterales bacterium isolate 10b48155-431e-4809-9d43-759f23ff96f9 genome assembly, chromosome: 1	blastn	4948	87.9	1	Bacteria		Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
1426943	1426943	PRJNA1002570_P_NODE_20422_length_289_cov_2.143519_g20227_i0	PRJNA1002570	20422	289	2.143519	6.19476991	Mesoterricola sediminis	2927980	Bacteria	Bacteria	150	9.22e-32	NTclustered	gi\|2490895851\|dbj\|AP027081.1\|	2927980	g20227	i0	90.351	21.3910034602076	114	11	39	0	175	288	3894400	3894513	Mesoterricola sediminis W786 DNA, complete genome	blastn	6182	150	1	Bacteria		Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Mesoterricola	Mesoterricola sediminis
2275799	2275799	PRJNA1002570_P_NODE_25022_length_279_cov_2.203883_g24827_i0	PRJNA1002570	25022	279	2.203883	6.14883357	Pseudomonadati	3379134	Bacteria	Bacteria	130	1.15e-25	NTclustered	gi\|1037405666\|gb\|CP011806.1\|	1660251	g24827	i0	83.333	1.66666666666667	144	20	51	4	2	143	4004380	4004239	Acidobacteria bacterium Mor1 chromosome	blastn	465	130	1	Bacteria	Acidobacteriota subdivision 22	Pseudomonadati	Acidobacteriota					Acidobacteria bacterium Mor1
5254946	5254946	PRJNA1002570_P_NODE_12285_length_340_cov_2.220974_g12090_i0	PRJNA1002570	12285	340	2.220974	7.5513116	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	346	1.32e-90	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g12090	i0	86.392	5.48235294117647	316	43	93	0	21	336	2338250	2338565	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	1864	346	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
5255010	5255010	PRJNA1002570_P_NODE_16045_length_310_cov_2.662447_g15850_i0	PRJNA1002570	16045	310	2.662447	8.2535857	Geothrix sp. 21YS21S-2	3068893	Bacteria	Bacteria	102	2.84e-17	NTclustered	gi\|2566094019\|gb\|CP132910.1\|	3068893	g15850	i0	88.235	2.79032258064516	85	10	27	0	161	245	3458674	3458590	Geothrix sp. 21YS21S-2 chromosome, complete genome	blastn	865	102	1	Bacteria		Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-2
5255155	5255155	PRJNA1002570_P_NODE_25205_length_279_cov_1.490291_g25010_i0	PRJNA1002570	25205	279	1.490291	4.15791189	Bryobacterales bacterium	2026791	Bacteria	Bacteria	270	6.519999999999999e-68	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g25010	i0	84.229	2.18279569892473	279	42	99	2	1	278	3782104	3782381	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	609	270	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
5255471	5255471	PRJNA1002570_P_NODE_43725_length_241_cov_1.833333_g43530_i0	PRJNA1002570	43725	241	1.833333	4.41833253	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	193	1.23e-44	NTclustered	gi\|2893358436\|emb\|OZ220728.1\|	2910147	g43530	i0	81.25	43.7634854771784	240	43	100	2	1	239	4999839	5000077	MAG: Vicinamibacterales bacterium isolate 73bbec36-abbb-48ff-8f96-0d8513c84f17 genome assembly, chromosome: 1	blastn	10547	193	1	Bacteria		Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
5255555	5255555	PRJNA1002570_P_NODE_7505_length_411_cov_1.275148_g7311_i0	PRJNA1002570	7505	411	1.275148	5.24085828	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	265	4.66e-66	NTclustered	gi\|2891481964\|emb\|OZ219745.1\|	2910147	g7311	i0	82.132	37.8807785888078	319	48	76	8	1	314	1820544	1820858	MAG: Vicinamibacterales bacterium isolate d5a9b4ee-eb88-4731-bb2c-80bf662b4d04 genome assembly, chromosome: 2	blastn	15569	265	1	Bacteria		Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
7805013	7805013	PRJNA1002570_P_NODE_36687_length_250_cov_1.446328_g36492_i0	PRJNA1002570	36687	250	1.446328	3.61582	Terriglobia bacterium	2081523	Bacteria	Bacteria	193	1.28e-44	NTclustered	gi\|2874253655\|emb\|OY968796.1\|	2081523	g36492	i0	80.723	2.808	249	46	99	2	1	248	3163695	3163942	MAG: Terriglobia bacterium isolate MFD04463.bin.1.19 genome assembly, chromosome: 1	blastn	702	193	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
7805056	7805056	PRJNA1002570_P_NODE_39027_length_247_cov_1.672414_g38832_i0	PRJNA1002570	39027	247	1.672414	4.13086258	Bryobacterales bacterium	2026791	Bacteria	Bacteria	169	2.1199999999999996e-37	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g38832	i0	79.365	40.7692307692308	252	42	100	8	1	247	2512567	2512813	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	10070	169	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
10355476	10355476	PRJNA1002570_P_NODE_26049_length_277_cov_1.509804_g25854_i0	PRJNA1002570	26049	277	1.509804	4.18215708	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	126	1.48e-24	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g25854	i0	80.117	0.617328519855596	171	32	61	2	103	272	2619739	2619908	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	171	126	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
10355779	10355779	PRJNA1002570_P_NODE_43569_length_242_cov_0.881657_g43374_i0	PRJNA1002570	43569	242	0.881657	2.13360994	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	228	3.3699999999999986e-55	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g43374	i0	83.75	3.55371900826446	240	39	99	0	1	240	5660594	5660833	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	860	228	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
10355804	10355804	PRJNA1002570_P_NODE_45309_length_231_cov_4.987342_g45114_i0	PRJNA1002570	45309	231	4.987342	11.52076002	Occallatibacter riparius	1002689	Bacteria	Bacteria	183	7.02e-42	NTclustered	gi\|2304899767\|gb\|CP093313.1\|	1002689	g45114	i0	83.854	6.37229437229437	192	31	83	0	4	195	5252185	5252376	Occallatibacter riparius strain DSM 25168 chromosome, complete genome	blastn	1472	183	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Occallatibacter	Occallatibacter riparius
12906203	12906203	PRJNA1002570_P_NODE_36811_length_250_cov_0.870056_g36616_i0	PRJNA1002570	36811	250	0.870056	2.17514	Paludibaculum fermentans	1473598	Bacteria	Bacteria	259	1.24e-64	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g36616	i0	86.441	132.7	236	32	94	0	15	250	4787414	4787179	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	33175	259	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
15454811	15454811	PRJNA1002570_P_NODE_17293_length_301_cov_2.122807_g17098_i0	PRJNA1002570	17293	301	2.122807	6.38964907	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	163	1.24e-35	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g17098	i0	77.978	78.0232558139535	277	49	90	11	7	277	1872406	1872676	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	23485	163	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19277945	19277945	PRJNA1002570_P_NODE_29536_length_268_cov_2.353846_g29341_i0	PRJNA1002570	29536	268	2.353846	6.30830728	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	106	1.86e-18	NTclustered	gi\|2874253750\|emb\|OY969625.1\|	194844	g29341	i0	78.443	3.27238805970149	167	32	62	4	13	177	1396955	1396791	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1	blastn	877	106	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
20553336	20553336	PRJNA1002570_P_NODE_17577_length_299_cov_3.889381_g17382_i0	PRJNA1002570	17577	299	3.889381	11.62924919	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	117	9.72e-22	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g17382	i0	76.336	0.876254180602007	262	36	80	13	5	242	7037808	7037549	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	262	117	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
23104644	23104644	PRJNA1002570_P_NODE_33059_length_259_cov_1.650538_g32864_i0	PRJNA1002570	33059	259	1.650538	4.27489342	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	171	6.239999999999999e-38	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g32864	i0	86.25	9.11969111969112	160	18	61	4	35	193	2417885	2418041	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	2362	171	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24378406	24378406	PRJNA1002570_P_NODE_33840_length_257_cov_1.244565_g33645_i0	PRJNA1002570	33840	257	1.244565	3.19853205	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	76.8	1.39e-9	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g33645	i0	89.831	0.229571984435798	59	6	23	0	9	67	4895634	4895692	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	59	76.8	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183

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