metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA611476" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA611476" 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
3140105	3140105	PRJNA611476_P_NODE_22223_length_425_cov_1.531250_g21432_i0	PRJNA611476	22223	425	1.53125	6.5078125	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	52.8	0.041	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g21432	i0	100	0.0658823529411765	28	0	7	0	315	342	1346857	1346830	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3699475	3699475	PRJNA611476_P_NODE_35483_length_352_cov_1.956989_g34692_i0	PRJNA611476	35483	352	1.956989	6.88860128	Granulicella	940557	Bacteria	Bacteria	628	1.2099999999999999e-175	NTclustered	gi\|470487846\|ref\|NR_076839.1\|	940615	g34692	i0	98.867	109.301136363636	353	3	100	1	1	352	2494	2846	Granulicella tundricola strain MP5ACTX9 23S ribosomal RNA gene, complete sequence	blastn	38474	634	0.990536277602524	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella tundricola
5692729	5692729	PRJNA611476_P_NODE_14825_length_511_cov_1.251142_g14035_i0	PRJNA611476	14825	511	1.251142	6.39333562	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g14035	i0	94.444	0.0704500978473581	36	2	7	0	90	125	7056270	7056305	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	36	56.5	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5693063	5693063	PRJNA611476_P_NODE_39205_length_339_cov_2.150376_g38414_i0	PRJNA611476	39205	339	2.150376	7.28977464	uncultured Thermoanaerobaculia bacterium	3036248	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|2518540615\|emb\|OX638294.1\|	3036248	g38414	i0	100	0.0825958702064897	28	0	8	0	161	188	4345176	4345149	MAG: uncultured Thermoanaerobaculia bacterium isolate 42478a12-5572-4d71-959b-92ffd854a98d genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria		Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				uncultured Thermoanaerobaculia bacterium
6967989	6967989	PRJNA611476_P_NODE_53206_length_299_cov_2.663717_g52415_i0	PRJNA611476	53206	299	2.663717	7.96451383	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	370	6.76e-98	NTclustered	gi\|217038918\|gb\|EU811009.1\|	171953	g52415	i0	89	141.515050167224	300	31	100	2	1	299	327	29	Uncultured Acidobacteria bacterium clone 01QCX 23S ribosomal RNA gene, partial sequence	blastn	42313	370	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7525750	7525750	PRJNA611476_P_NODE_46326_length_318_cov_1.069388_g45535_i0	PRJNA611476	46326	318	1.069388	3.40065384	Granulicella	940557	Bacteria	Bacteria	549	8.669999999999997e-152	NTclustered	gi\|470487846\|ref\|NR_076839.1\|	940615	g45535	i0	97.806	168.022012578616	319	5	100	2	1	318	1871	1554	Granulicella tundricola strain MP5ACTX9 23S ribosomal RNA gene, complete sequence	blastn	53431	549	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella tundricola
8800518	8800518	PRJNA611476_P_NODE_12747_length_549_cov_2.283613_g11959_i0	PRJNA611476	12747	549	2.283613	12.53703537	Bacteria	2	Bacteria	Bacteria	67.6	1.93e-6	NTclustered	gi\|2626255659\|emb\|OY843766.1\|	1241325	g11959	i0	78.095	0.316939890710383	105	23	19	0	146	250	1228143	1228039	MAG: uncultured Granulicella sp. isolate e6d70442-04f8-4699-a368-e2225de37168 genome assembly, chromosome: 1	blastn	174	67.6	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	uncultured Granulicella sp.
9517989	9517989	PRJNA611476_P_NODE_56288_length_292_cov_1.054795_g55497_i0	PRJNA611476	56288	292	1.054795	3.0800014	Bryobacterales bacterium	2026791	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2814788340\|emb\|OY729428.2\|	2026791	g55497	i0	92.308	1.16780821917808	39	3	13	0	72	110	790138	790100	MAG: Bryobacterales bacterium isolate 40538f42-96db-4fd0-a274-5305745f95c5 genome assembly, chromosome: 2	blastn	341	56.5	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
13901985	13901985	PRJNA611476_P_NODE_5331_length_837_cov_1.327225_g4600_i0	PRJNA611476	5331	837	1.327225	11.10887325	Granulicella	940557	Bacteria	Bacteria	1482	0	NTclustered	gi\|470487846\|ref\|NR_076839.1\|	940615	g4600	i0	98.57	102.688172043011	839	10	100	2	1	837	1213	375	Granulicella tundricola strain MP5ACTX9 23S ribosomal RNA gene, complete sequence	blastn	85950	1482	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella tundricola
14618642	14618642	PRJNA611476_P_NODE_56972_length_290_cov_1.419355_g56181_i0	PRJNA611476	56972	290	1.419355	4.1161295	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2874253849\|emb\|OY969905.1\|	171953	g56181	i0	100	0.096551724137931	28	0	10	0	122	149	837918	837945	MAG: uncultured Acidobacteriota bacterium isolate MFD09222.bin.c.1 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14618784	14618784	PRJNA611476_P_NODE_68132_length_270_cov_1.395939_g67341_i0	PRJNA611476	68132	270	1.395939	3.7690353	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	372	1.67e-98	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g67341	i0	91.481	73.8222222222222	270	23	100	0	1	270	4527787	4528056	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	19932	372	1	Bacteria		Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
15176388	15176388	PRJNA611476_P_NODE_58092_length_288_cov_1.432558_g57301_i0	PRJNA611476	58092	288	1.432558	4.12576704	Pseudomonadati	3379134	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2814788349\|emb\|OY760650.2\|	2081523	g57301	i0	96.875	0.309027777777778	32	1	11	0	7	38	88067	88098	MAG: Terriglobia bacterium isolate 5d79d33f-5ea2-468b-941e-0445094ce055 genome assembly, chromosome: 1	blastn	89	54.7	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
15891896	15891896	PRJNA611476_P_NODE_110413_length_243_cov_0.905882_g109622_i0	PRJNA611476	110413	243	0.905882	2.20129326	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	316	7.03e-82	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g109622	i0	92.727	40.6584362139918	220	15	91	1	9	228	1689585	1689367	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	9880	316	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15892325	15892325	PRJNA611476_P_NODE_3413_length_1062_cov_1.402427_g2775_i0	PRJNA611476	3413	1062	1.402427	14.89377474	Bryobacterales bacterium	2026791	Bacteria	Bacteria	54.7	0.03	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g2775	i0	100	0.0273069679849341	29	0	3	0	1022	1050	1747583	1747555	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
19715827	19715827	PRJNA611476_P_NODE_25916_length_398_cov_1.867692_g25125_i0	PRJNA611476	25916	398	1.867692	7.43341416	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	52.8	0.038	NTclustered	gi\|2874253750\|emb\|OY969625.1\|	194844	g25125	i0	100	0.070351758793969807	28	0	7	0	369	396	2298581	2298554	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
19716086	19716086	PRJNA611476_P_NODE_44936_length_322_cov_1.144578_g44145_i0	PRJNA611476	44936	322	1.144578	3.68554116	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	464	3.28e-126	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g44145	i0	92.593	196.39751552795	324	22	100	2	1	322	284998	285321	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	63240	464	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
19716719	19716719	PRJNA611476_P_NODE_94996_length_247_cov_0.885057_g94205_i0	PRJNA611476	94996	247	0.885057	2.18609079	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	219	2.08e-52	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g94205	i0	84.298	4.1336032388664	242	19	96	16	3	238	706784	707012	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	1021	219	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
20991634	20991634	PRJNA611476_P_NODE_2777_length_1189_cov_3.916667_g2200_i0	PRJNA611476	2777	1189	3.916667	46.56917063	Mesoterricola sediminis	2927980	Bacteria	Bacteria	56.5	0.009	NTclustered	gi\|2490895851\|dbj\|AP027081.1\|	2927980	g2200	i0	96.97	0.0277544154751892	33	1	3	0	63	95	2604258	2604290	Mesoterricola sediminis W786 DNA, complete genome	blastn	33	56.5	1	Bacteria		Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Mesoterricola	Mesoterricola sediminis
20991934	20991934	PRJNA611476_P_NODE_50397_length_307_cov_0.987179_g49606_i0	PRJNA611476	50397	307	0.987179	3.03063953	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	150	9.869999999999998e-32	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g49606	i0	89.256	9.90553745928339	121	11	39	2	2	121	3444415	3444296	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	3041	150	1	Bacteria		Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
24816508	24816508	PRJNA611476_P_NODE_96440_length_246_cov_2.196532_g95649_i0	PRJNA611476	96440	246	2.196532	5.40346872	Acidobacteria bacterium Mor1	1660251	Bacteria	Bacteria	62.1	3.69e-5	NTclustered	gi\|1037405666\|gb\|CP011806.1\|	1660251	g95649	i0	97.222	0.146341463414634	36	1	15	0	161	196	2419582	2419547	Acidobacteria bacterium Mor1 chromosome	blastn	36	62.1	1	Bacteria	Acidobacteriota subdivision 22	Pseudomonadati	Acidobacteriota					Acidobacteria bacterium Mor1
25374461	25374461	PRJNA611476_P_NODE_65460_length_275_cov_1.321782_g64669_i0	PRJNA611476	65460	275	1.321782	3.6349005	Granulicella	940557	Bacteria	Bacteria	420	6.01e-113	NTclustered	gi\|470487846\|ref\|NR_076839.1\|	940615	g64669	i0	94.224	123.512727272727	277	12	100	4	1	275	64	338	Granulicella tundricola strain MP5ACTX9 23S ribosomal RNA gene, complete sequence	blastn	33966	420	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella tundricola

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