metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA662254" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA662254" and tax_phylum = "Planctomycetota"

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
628358	628358	PRJNA662254_P_NODE_51101_length_248_cov_0.880000_g50450_i0	PRJNA662254	51101	248	0.88	2.1824	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	324	4.31e-84	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g50450	i0	90.283	3.00403225806452	247	24	99	0	2	248	4053662	4053908	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	745	324	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
628367	628367	PRJNA662254_P_NODE_51821_length_248_cov_0.880000_g51170_i0	PRJNA662254	51821	248	0.88	2.1824	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	137	6.019999999999999e-28	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g51170	i0	82.803	3.19354838709677	157	23	63	4	92	246	7553897	7554051	Planctomyces sp. SH-PL14, complete genome	blastn	792	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
628385	628385	PRJNA662254_P_NODE_54821_length_246_cov_0.890173_g54170_i0	PRJNA662254	54821	246	0.890173	2.18982558	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	65.8	2.85e-6	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g54170	i0	97.368	0.66260162601626	38	1	16	0	118	155	2680590	2680553	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	163	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
628409	628409	PRJNA662254_P_NODE_58601_length_244_cov_0.900585_g57950_i0	PRJNA662254	58601	244	0.900585	2.1974274	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	207	4.44e-49	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g57950	i0	82.645	0.991803278688525	242	34	98	7	5	243	7052634	7052398	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	242	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
1904544	1904544	PRJNA662254_P_NODE_64862_length_241_cov_0.916667_g64211_i0	PRJNA662254	64862	241	0.916667	2.20916747	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	176	1.23e-39	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g64211	i0	80.083	1.98340248962656	241	44	99	4	1	239	6899739	6899977	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	478	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
3179285	3179285	PRJNA662254_P_NODE_60863_length_243_cov_0.905882_g60212_i0	PRJNA662254	60863	243	0.905882	2.20129326	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	385	1.8999999999999993e-102	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g60212	i0	95.436	7.69958847736626	241	11	99	0	1	241	1815374	1815134	Gemmata sp. SH-PL17, complete genome	blastn	1871	385	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
3179297	3179297	PRJNA662254_P_NODE_62063_length_243_cov_0.876471_g61412_i0	PRJNA662254	62063	243	0.876471	2.12982453	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	215	2.64e-51	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g61412	i0	83.404	0.967078189300412	235	35	96	4	8	240	3418866	3419098	Planctomyces sp. SH-PL62, complete genome	blastn	235	215	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
4456232	4456232	PRJNA662254_P_NODE_47984_length_250_cov_0.870056_g47333_i0	PRJNA662254	47984	250	0.870056	2.17514	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	259	1.24e-64	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g47333	i0	86.42	2.9	243	26	96	6	1	239	3121124	3120885	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	725	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
4456338	4456338	PRJNA662254_P_NODE_64204_length_241_cov_1.607143_g63553_i0	PRJNA662254	64204	241	1.607143	3.87321463	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	235	2.0099999999999997e-57	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g63553	i0	84.519	7.35269709543568	239	35	99	2	4	241	5914936	5914699	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	1772	235	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
7006924	7006924	PRJNA662254_P_NODE_44966_length_251_cov_0.865169_g44315_i0	PRJNA662254	44966	251	0.865169	2.17157419	Planctomycetia bacterium	2052181	Bacteria	Bacteria	220	5.89e-53	NTclustered	gi\|1927961636\|gb\|CP054187.1\|	2052181	g44315	i0	82.677	1.01195219123506	254	38	100	6	1	251	1749408	1749658	MAG: Planctomycetia bacterium isolate H1_PLA2 chromosome, complete genome	blastn	254	220	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
8281552	8281552	PRJNA662254_P_NODE_55267_length_246_cov_0.890173_g54616_i0	PRJNA662254	55267	246	0.890173	2.18982558	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	62.1	3.69e-5	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g54616	i0	92.857	0.170731707317073	42	3	17	0	37	78	5021616	5021657	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	42	62.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
8281625	8281625	PRJNA662254_P_NODE_65727_length_241_cov_0.916667_g65076_i0	PRJNA662254	65727	241	0.916667	2.20916747	Pirellulimonas nuda	2528009	Bacteria	Bacteria	58.4	4.66e-4	NTclustered	gi\|1712662089\|gb\|CP036291.1\|	2528009	g65076	i0	86.792	0.340248962655602	53	6	22	1	39	91	322385	322334	Pirellulimonas nuda strain Pla175 chromosome, complete genome	blastn	82	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Pirellulimonas	Pirellulimonas nuda
12107679	12107679	PRJNA662254_P_NODE_48230_length_250_cov_0.870056_g47579_i0	PRJNA662254	48230	250	0.870056	2.17514	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	152	2.17e-32	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g47579	i0	79.63	0.864	216	40	86	4	37	250	3103294	3103507	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	216	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
12107754	12107754	PRJNA662254_P_NODE_60770_length_243_cov_0.905882_g60119_i0	PRJNA662254	60770	243	0.905882	2.20129326	Phycisphaera mikurensis	547188	Bacteria	Bacteria	270	5.5499999999999986e-68	NTclustered	gi\|381385343\|dbj\|AP012338.1\|	1142394	g60119	i0	87.879	3.02057613168724	231	26	95	2	3	232	1804479	1804708	Phycisphaera mikurensis NBRC 102666 DNA, complete genome	blastn	734	270	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera mikurensis
13382397	13382397	PRJNA662254_P_NODE_49771_length_249_cov_0.875000_g49120_i0	PRJNA662254	49771	249	0.875	2.17875	Rohdeia mirabilis	2528008	Bacteria	Bacteria	233	7.5e-57	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g49120	i0	84.082	4.85943775100402	245	35	98	4	6	248	1745183	1744941	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	1210	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
13915887	13915887	PRJNA662254_P_NODE_17751_length_389_cov_0.841772_g17100_i0	PRJNA662254	17751	389	0.841772	3.27449308	Frigoriglobus	2774146	Bacteria	Bacteria	287	9.36e-73	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g17100	i0	81.285	3.94858611825193	358	63	92	4	10	365	1973834	1974189	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	1536	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
14657293	14657293	PRJNA662254_P_NODE_53672_length_247_cov_0.885057_g53021_i0	PRJNA662254	53672	247	0.885057	2.18609079	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	102	2.19e-17	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g53021	i0	93.056	0.291497975708502	72	2	28	2	170	238	4720194	4720265	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	72	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
17206435	17206435	PRJNA662254_P_NODE_63214_length_242_cov_0.911243_g62563_i0	PRJNA662254	63214	242	0.911243	2.20520806	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	250	7.2e-62	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g62563	i0	88.208	5.42148760330578	212	21	87	4	1	210	5720063	5719854	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	1312	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
19755245	19755245	PRJNA662254_P_NODE_46136_length_251_cov_0.865169_g45485_i0	PRJNA662254	46136	251	0.865169	2.17157419	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	102	2.23e-17	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g45485	i0	82.353	1.92430278884462	119	19	47	2	26	143	892031	891914	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	483	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
19755249	19755249	PRJNA662254_P_NODE_46896_length_250_cov_0.870056_g46245_i0	PRJNA662254	46896	250	0.870056	2.17514	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	241	4.5e-59	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g46245	i0	84	2.012	250	40	100	0	1	250	740518	740767	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	503	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
19755338	19755338	PRJNA662254_P_NODE_62036_length_243_cov_0.888235_g61385_i0	PRJNA662254	62036	243	0.888235	2.15841105	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	137	5.88e-28	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g61385	i0	86.508	2.25514403292181	126	15	65	2	5	129	1119740	1119616	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	548	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
19755360	19755360	PRJNA662254_P_NODE_65256_length_241_cov_0.916667_g64605_i0	PRJNA662254	65256	241	0.916667	2.20916747	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	209	1.22e-49	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g64605	i0	83.7	10.3651452282158	227	31	93	4	18	241	4638140	4637917	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	2498	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
21030885	21030885	PRJNA662254_P_NODE_51497_length_248_cov_0.880000_g50846_i0	PRJNA662254	51497	248	0.88	2.1824	Humisphaera borealis	2807512	Bacteria	Bacteria	65.8	2.88e-6	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g50846	i0	100	0.431451612903226	35	0	17	0	192	226	6262564	6262598	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	107	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
22305634	22305634	PRJNA662254_P_NODE_52318_length_248_cov_0.880000_g51667_i0	PRJNA662254	52318	248	0.88	2.1824	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	244	3.45e-60	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g51667	i0	84.553	1.12903225806452	246	38	99	0	1	246	6442238	6442483	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	280	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
22305713	22305713	PRJNA662254_P_NODE_65218_length_241_cov_0.916667_g64567_i0	PRJNA662254	65218	241	0.916667	2.20916747	Paludisphaera borealis	1387353	Bacteria	Bacteria	274	4.2499999999999997e-69	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g64567	i0	87.19	1.59336099585062	242	29	100	2	1	241	5246619	5246379	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	384	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
23580914	23580914	PRJNA662254_P_NODE_31899_length_294_cov_1.606335_g31248_i0	PRJNA662254	31899	294	1.606335	4.7226249	uncultured Phycisphaerae bacterium	904963	Bacteria	Bacteria	460	3.82e-125	NTclustered	gi\|451919418\|gb\|KC453282.1\|	904963	g31248	i0	95.189	96.8537414965986	291	14	99	0	4	294	293	3	Uncultured Phycisphaerae bacterium clone RLBp1823 16S ribosomal RNA gene, partial sequence	blastn	28475	460	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				uncultured Phycisphaerae bacterium
23580991	23580991	PRJNA662254_P_NODE_49059_length_249_cov_0.875000_g48408_i0	PRJNA662254	49059	249	0.875	2.17875	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	206	1.6299999999999998e-48	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g48408	i0	83.556	3.42168674698795	225	32	89	5	28	249	5823281	5823059	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	852	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24854658	24854658	PRJNA662254_P_NODE_58640_length_244_cov_0.900585_g57989_i0	PRJNA662254	58640	244	0.900585	2.1974274	Humisphaera borealis	2807512	Bacteria	Bacteria	167	7.529999999999998e-37	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g57989	i0	84.302	0.704918032786885	172	25	70	2	5	175	3099948	3099778	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	172	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
24854662	24854662	PRJNA662254_P_NODE_59280_length_244_cov_0.900585_g58629_i0	PRJNA662254	59280	244	0.900585	2.1974274	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	65.8	2.83e-6	NTclustered	gi\|2621705864\|emb\|OY763926.1\|	2813034	g58629	i0	97.368	12.1475409836066	38	1	16	0	9	46	2426235	2426272	MAG: Sedimentisphaerales bacterium isolate 7f5c64f7-1a0d-4936-834e-775057159072 genome assembly, chromosome: 1	blastn	2964	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
25388364	25388364	PRJNA662254_P_NODE_22380_length_348_cov_0.847273_g21729_i0	PRJNA662254	22380	348	0.847273	2.94851004	Gemmata	113	Bacteria	Bacteria	311	4.93e-80	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g21729	i0	83.68	88.0287356321839	337	47	97	5	2	337	6514524	6514853	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	30634	311	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus

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