metadata: contig_metadata: 56 rows where analysis = "blastn", bioproject = "PRJNA293022" and tax

56 rows where analysis = "blastn", bioproject = "PRJNA293022" 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
373225	373225	PRJNA293022_P_NODE_23901_length_289_cov_2.479167_g23164_i0	PRJNA293022	23901	289	2.479167	7.16479263	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	429	1.06e-115	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g23164	i0	93.448	41.9723183391003	290	17	100	2	1	289	1156419	1156131	Planctomyces sp. SH-PL62, complete genome	blastn	12130	429	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
373269	373269	PRJNA293022_P_NODE_36781_length_230_cov_2.779006_g36044_i0	PRJNA293022	36781	230	2.779006	6.3917138	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	326	1.1e-84	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g36044	i0	94.34	175.552173913043	212	12	92	0	3	214	2003750	2003961	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	40377	326	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
373326	373326	PRJNA293022_P_NODE_53821_length_190_cov_1.219858_g53084_i0	PRJNA293022	53821	190	1.219858	2.3177302	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	265	1.93e-66	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g53084	i0	94.253	45.6526315789474	174	9	91	1	16	188	7050765	7050592	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	8674	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
1059768	1059768	PRJNA293022_P_NODE_59641_length_180_cov_1.480916_g58904_i0	PRJNA293022	59641	180	1.480916	2.6656488	Planctopirus	1649480	Bacteria	Bacteria	150	5.26e-32	NTclustered	gi\|470485078\|ref\|NR_076683.1\|	120	g58904	i0	84.615	40.7111111111111	156	18	84	5	1	152	1584	1431	Planctomyces limnophilus strain Mue 290 23S ribosomal RNA gene, complete sequence	blastn	7328	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus limnophila
1647946	1647946	PRJNA293022_P_NODE_20842_length_311_cov_8.305344_g20105_i0	PRJNA293022	20842	311	8.305344	25.82961984	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	440	5.309999999999997e-119	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g20105	i0	92.063	154.881028938907	315	21	100	3	1	311	2004079	2004393	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	48168	440	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
1648111	1648111	PRJNA293022_P_NODE_58362_length_182_cov_1.548872_g57625_i0	PRJNA293022	58362	182	1.548872	2.81894704	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	193	8.739999999999999e-45	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g57625	i0	86.932	163.994505494505	176	18	95	5	1	172	4422270	4422444	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	29847	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2923897	2923897	PRJNA293022_P_NODE_27963_length_266_cov_2.364055_g27226_i0	PRJNA293022	27963	266	2.364055	6.2883863	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	261	3.7100000000000003e-65	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g27226	i0	84.586	59.0375939849624	266	38	99	3	2	266	1866374	1866637	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	15704	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
2923911	2923911	PRJNA293022_P_NODE_32223_length_246_cov_4.847716_g31486_i0	PRJNA293022	32223	246	4.847716	11.92538136	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	446	8.719999999999999e-121	NTclustered	gi\|391226078\|gb\|JQ958727.1\|	120965	g31486	i0	99.59	100.589430894309	244	1	99	0	2	245	460	217	Uncultured planctomycete clone ER4 16S ribosomal RNA gene, partial sequence	blastn	24745	446	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
3610240	3610240	PRJNA293022_P_NODE_57283_length_184_cov_1.362963_g56546_i0	PRJNA293022	57283	184	1.362963	2.50785192	Rhodopirellula	265488	Bacteria	Bacteria	327	2.3299999999999996e-85	NTclustered	gi\|32445988\|emb\|BX294148.1\|	243090	g56546	i0	99.444	380.478260869565	180	1	98	0	3	182	36024	36203	Rhodopirellula baltica SH 1 complete genome; segment 16/24	blastn	70008	327	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula baltica
4200358	4200358	PRJNA293022_P_NODE_26344_length_275_cov_1.278761_g25607_i0	PRJNA293022	26344	275	1.278761	3.51659275	Aquisphaera giovannonii	406548	Bacteria	Bacteria	429	9.989999999999999e-116	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g25607	i0	94.891	85.5345454545455	274	14	99	0	2	275	5178920	5179193	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	23522	429	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
4887597	4887597	PRJNA293022_P_NODE_20404_length_315_cov_2.458647_g19667_i0	PRJNA293022	20404	315	2.458647	7.74473805	Planctomycetaceae	126	Bacteria	Bacteria	459	1.49e-124	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g19667	i0	93.791	123.571428571429	306	17	97	2	11	315	1417684	1417988	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	38925	459	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
4887657	4887657	PRJNA293022_P_NODE_44544_length_209_cov_1.593750_g43807_i0	PRJNA293022	44544	209	1.59375	3.3309375	Bremerella	2714594	Bacteria	Bacteria	372	1.24e-98	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g43807	i0	99.034	60.2200956937799	207	2	99	0	1	207	2674275	2674481	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	12586	372	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
5476814	5476814	PRJNA293022_P_NODE_545_length_1523_cov_16.469471_g355_i0	PRJNA293022	545	1523	16.469471	250.83004333	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	1947	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g355	i0	90.435	481.032173342088	1495	119	97	23	28	1507	2001610	2003095	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	732612	1947	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
6162477	6162477	PRJNA293022_P_NODE_32265_length_246_cov_3.126904_g31528_i0	PRJNA293022	32265	246	3.126904	7.69218384	Pirellula	123	Bacteria	Bacteria	276	1.21e-69	NTclustered	gi\|470485626\|ref\|NR_076710.1\|	125	g31528	i0	90.821	76.2560975609756	207	17	84	2	1	206	1757	1552	Pirellula staleyi strain DSM 6068 23S ribosomal RNA gene, complete sequence	blastn	18759	276	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
6751018	6751018	PRJNA293022_P_NODE_5726_length_591_cov_4.188192_g5031_i0	PRJNA293022	5726	591	4.188192	24.75221472	Gimesia panareensis	2527978	Bacteria	Bacteria	337	1.4399999999999993e-87	NTclustered	gi\|1712615819\|gb\|CP036277.1\|	2527978	g5031	i0	80.042	91.3502538071066	476	77	79	13	95	560	2209575	2210042	Gimesia panareensis strain Pan110 chromosome, complete genome	blastn	53988	337	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia panareensis
6751041	6751041	PRJNA293022_P_NODE_60346_length_179_cov_1.200000_g59609_i0	PRJNA293022	60346	179	1.2	2.148	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	248	1.8e-61	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g59609	i0	98.571	21.9217877094972	140	2	78	0	39	178	1867663	1867802	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	3924	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
9301290	9301290	PRJNA293022_P_NODE_22888_length_296_cov_4.453441_g22151_i0	PRJNA293022	22888	296	4.453441	13.18218536	Rhodopirellula baltica	265606	Bacteria	Bacteria	545	1.03e-150	NTclustered	gi\|32445988\|emb\|BX294148.1\|	243090	g22151	i0	100	72.0608108108108	295	0	99	0	2	296	37450	37156	Rhodopirellula baltica SH 1 complete genome; segment 16/24	blastn	21330	545	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula baltica
9301363	9301363	PRJNA293022_P_NODE_40968_length_218_cov_1.538462_g40231_i0	PRJNA293022	40968	218	1.538462	3.35384716	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	350	6.1e-92	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g40231	i0	96.244	139.821100917431	213	8	98	0	6	218	4319268	4319480	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	30481	350	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
9987810	9987810	PRJNA293022_P_NODE_308_length_1805_cov_5.601936_g62_i2	PRJNA293022	308	1805	5.601936	101.1149448	Schlesneria	656899	Bacteria	Bacteria	1871	0	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g62	i2	85.722	116.37783933518	1807	216	99	31	4	1791	1806	23	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	210062	1881	0.994683678894205	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
10577150	10577150	PRJNA293022_P_NODE_25229_length_281_cov_2.185345_g24492_i0	PRJNA293022	25229	281	2.185345	6.14081945	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	261	3.9500000000000004e-65	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g24492	i0	83.737	61.6548042704626	289	33	100	13	1	281	1843997	1844279	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	17325	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
10577439	10577439	PRJNA293022_P_NODE_7929_length_508_cov_2.956427_g7206_i0	PRJNA293022	7929	508	2.956427	15.01864916	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	689	0	NTclustered	gi\|730837966\|gb\|KM506791.1\|	120965	g7206	i0	91.159	124.167322834646	509	44	100	1	1	508	661	153	Uncultured planctomycete clone AGB-PT004 23S ribosomal RNA gene, partial sequence	blastn	63077	689	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
11852108	11852108	PRJNA293022_P_NODE_75970_length_164_cov_0.904348_g75233_i0	PRJNA293022	75970	164	0.904348	1.48313072	Urbifossiella limnaea	2528023	Bacteria	Bacteria	211	2.13e-50	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g75233	i0	90.123	64.5914634146341	162	16	99	0	1	162	2019855	2019694	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	10593	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
13126983	13126983	PRJNA293022_P_NODE_13511_length_389_cov_3.061765_g12774_i0	PRJNA293022	13511	389	3.061765	11.91026585	planctomycete str. 449	79870	Bacteria	Bacteria	573	6.419999999999999e-159	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g12774	i0	94.837	119.13881748072	368	18	94	1	21	387	1482	1115	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	46345	573	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
13127117	13127117	PRJNA293022_P_NODE_45411_length_207_cov_1.544304_g44674_i0	PRJNA293022	45411	207	1.544304	3.19670928	Aureliella helgolandensis	2527968	Bacteria	Bacteria	333	5.779999999999999e-87	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g44674	i0	95.652	193.140096618357	207	9	100	0	1	207	6999408	6999202	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	39980	333	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
14402190	14402190	PRJNA293022_P_NODE_35332_length_235_cov_1.682796_g34595_i0	PRJNA293022	35332	235	1.682796	3.9545706	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	361	3.08e-95	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g34595	i0	94.468	48.8893617021277	235	12	100	1	1	235	1155485	1155252	Planctomyces sp. SH-PL62, complete genome	blastn	11489	361	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
14402259	14402259	PRJNA293022_P_NODE_50612_length_196_cov_1.176871_g49875_i0	PRJNA293022	50612	196	1.176871	2.30666716	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	265	2e-66	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g49875	i0	92.147	42.7704081632653	191	10	99	5	7	195	4318040	4317853	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	8383	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
14402281	14402281	PRJNA293022_P_NODE_56612_length_185_cov_1.514706_g55875_i0	PRJNA293022	56612	185	1.514706	2.8022061	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	294	2.38e-75	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g55875	i0	95.628	124.859459459459	183	8	99	0	1	183	2583667	2583849	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	23099	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
15675908	15675908	PRJNA293022_P_NODE_12253_length_408_cov_2.222841_g11516_i0	PRJNA293022	12253	408	2.222841	9.06919128	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	667	0	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g11516	i0	96.314	506.475490196078	407	13	99	2	3	408	265934	266339	Tautonia plasticadhaerens strain ElP chromosome	blastn	206642	667	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
15675913	15675913	PRJNA293022_P_NODE_13313_length_392_cov_3.804665_g12576_i0	PRJNA293022	13313	392	3.804665	14.9142868	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	636	8.139999999999998e-178	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g12576	i0	96.154	116.510204081633	390	13	99	1	1	390	265782	265395	Tautonia plasticadhaerens strain ElP chromosome	blastn	45672	636	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
15675941	15675941	PRJNA293022_P_NODE_22773_length_297_cov_3.963710_g22036_i0	PRJNA293022	22773	297	3.96371	11.7722187	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	401	2.3799999999999993e-107	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g22036	i0	91.186	139.239057239057	295	26	99	0	1	295	4957890	4958184	Planctomyces sp. SH-PL14, complete genome	blastn	41354	401	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
15675975	15675975	PRJNA293022_P_NODE_29513_length_259_cov_0.828571_g28776_i0	PRJNA293022	29513	259	0.828571	2.14599889	Rohdeia mirabilis	2528008	Bacteria	Bacteria	108	4.96e-19	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g28776	i0	75.094	1.62548262548263	265	49	98	15	6	259	3893210	3892952	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	421	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
15676234	15676234	PRJNA293022_P_NODE_77993_length_162_cov_6.309735_g77256_i0	PRJNA293022	77993	162	6.309735	10.2217707	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|391226078\|gb\|JQ958727.1\|	120965	g77256	i0	100	100.759259259259	162	0	100	0	1	162	574	413	Uncultured planctomycete clone ER4 16S ribosomal RNA gene, partial sequence	blastn	16323	300	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
15676245	15676245	PRJNA293022_P_NODE_81153_length_158_cov_2.357798_g80416_i0	PRJNA293022	81153	158	2.357798	3.72532084	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	198	1.5899999999999999e-46	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g80416	i0	90.789	36.9936708860759	152	9	94	4	1	149	1600741	1600592	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	5845	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
16950869	16950869	PRJNA293022_P_NODE_82534_length_154_cov_2.838095_g81797_i0	PRJNA293022	82534	154	2.838095	4.3706663	Humisphaera borealis	2807512	Bacteria	Bacteria	150	4.359999999999999e-32	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g81797	i0	87.597	6.86363636363636	129	16	84	0	6	134	5063179	5063051	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	1057	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
17637298	17637298	PRJNA293022_P_NODE_22274_length_301_cov_2.007937_g21537_i0	PRJNA293022	22274	301	2.007937	6.04389037	Rhodopirellula	265488	Bacteria	Bacteria	475	1.4e-129	NTclustered	gi\|32445988\|emb\|BX294148.1\|	243090	g21537	i0	95.667	124.401993355482	300	5	99	2	2	301	38609	38318	Rhodopirellula baltica SH 1 complete genome; segment 16/24	blastn	37445	475	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula baltica
17637320	17637320	PRJNA293022_P_NODE_3374_length_744_cov_5.620144_g2818_i0	PRJNA293022	3374	744	5.620144	41.81387136	Schlesneria	656899	Bacteria	Bacteria	640	1.25e-178	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g2818	i0	82.685	328.416666666667	745	106	99	16	5	742	735	7	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	244342	640	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
18911140	18911140	PRJNA293022_P_NODE_44855_length_208_cov_2.270440_g44118_i0	PRJNA293022	44855	208	2.27044	4.7225152	Schlesneria	656899	Bacteria	Bacteria	300	5.89e-77	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g44118	i0	93.564	160.730769230769	202	11	97	2	4	205	2812	2613	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	33432	300	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
19499129	19499129	PRJNA293022_P_NODE_27576_length_268_cov_2.100457_g26839_i0	PRJNA293022	27576	268	2.100457	5.62922476	Rhodopirellula baltica	265606	Bacteria	Bacteria	479	9.499999999999996e-131	NTclustered	gi\|32445988\|emb\|BX294148.1\|	243090	g26839	i0	98.881	144.324626865672	268	3	100	0	1	268	38305	38038	Rhodopirellula baltica SH 1 complete genome; segment 16/24	blastn	38679	479	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula baltica
20185760	20185760	PRJNA293022_P_NODE_35376_length_235_cov_1.333333_g34639_i0	PRJNA293022	35376	235	1.333333	3.13333255	Gemmata	113	Bacteria	Bacteria	353	5.16e-93	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g34639	i0	95.111	150.114893617021	225	9	95	2	3	225	3633704	3633928	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	35277	353	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
20185798	20185798	PRJNA293022_P_NODE_50956_length_195_cov_1.767123_g50219_i0	PRJNA293022	50956	195	1.767123	3.44588985	Bremerella	2714594	Bacteria	Bacteria	355	1.15e-93	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g50219	i0	99.487	137.871794871795	195	1	100	0	1	195	2674230	2674036	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	26885	355	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
20185843	20185843	PRJNA293022_P_NODE_68656_length_168_cov_1.470588_g67919_i0	PRJNA293022	68656	168	1.470588	2.47058784	Rhodopirellula	265488	Bacteria	Bacteria	302	1.27e-77	NTclustered	gi\|32445988\|emb\|BX294148.1\|	243090	g67919	i0	99.398	50.0892857142857	166	1	99	0	1	166	38723	38888	Rhodopirellula baltica SH 1 complete genome; segment 16/24	blastn	8415	302	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula baltica
20774661	20774661	PRJNA293022_P_NODE_20777_length_312_cov_2.338403_g20040_i0	PRJNA293022	20777	312	2.338403	7.29581736	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	477	4.06e-130	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g20040	i0	94.231	76.0288461538462	312	18	100	0	1	312	266709	266398	Tautonia plasticadhaerens strain ElP chromosome	blastn	23721	477	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
20774952	20774952	PRJNA293022_P_NODE_76317_length_163_cov_3.763158_g75580_i0	PRJNA293022	76317	163	3.763158	6.13394754	Bremerella volcania	2527984	Bacteria	Bacteria	292	7.35e-75	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g75580	i0	99.379	54.9386503067485	161	1	99	0	3	163	2673306	2673146	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	8955	292	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
20774979	20774979	PRJNA293022_P_NODE_79337_length_162_cov_0.920354_g78600_i0	PRJNA293022	79337	162	0.920354	1.49097348	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	167	4.609999999999999e-37	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g78600	i0	85.366	64.9382716049383	164	20	99	3	3	162	2004226	2004389	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	10520	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20774998	20774998	PRJNA293022_P_NODE_9397_length_467_cov_2.691388_g8666_i0	PRJNA293022	9397	467	2.691388	12.56878196	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	488	2.9199999999999994e-133	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g8666	i0	85.991	135.152034261242	464	56	98	6	1	459	4956077	4956536	Planctomyces sp. SH-PL14, complete genome	blastn	63116	488	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
21461426	21461426	PRJNA293022_P_NODE_22517_length_299_cov_2.732000_g21780_i0	PRJNA293022	22517	299	2.732	8.16868	Planctomycetia	203683	Bacteria	Bacteria	344	4.099999999999999e-90	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g21780	i0	92.5	173.655518394649	240	18	80	0	1	240	615	376	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	51923	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
21461436	21461436	PRJNA293022_P_NODE_24857_length_283_cov_3.072650_g24120_i0	PRJNA293022	24857	283	3.07265	8.6955995	Rhodopirellula	265488	Bacteria	Bacteria	520	5.96e-143	NTclustered	gi\|321442579\|gb\|HQ845494.1\|	265606	g24120	i0	100	99.2932862190813	281	0	99	0	3	283	4	284	Rhodopirellula baltica strain MsF4 16S ribosomal RNA gene, partial sequence	blastn	28100	520	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula baltica
21461441	21461441	PRJNA293022_P_NODE_28337_length_264_cov_3.525581_g27600_i0	PRJNA293022	28337	264	3.525581	9.30753384	Rhodopirellula	265488	Bacteria	Bacteria	477	3.359999999999999e-130	NTclustered	gi\|32445988\|emb\|BX294148.1\|	243090	g27600	i0	99.242	121.393939393939	264	2	100	0	1	264	37852	37589	Rhodopirellula baltica SH 1 complete genome; segment 16/24	blastn	32048	477	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula baltica
22049588	22049588	PRJNA293022_P_NODE_10078_length_451_cov_3.271144_g9344_i0	PRJNA293022	10078	451	3.271144	14.75285944	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	680	0	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g9344	i0	94.183	124.789356984479	447	25	99	1	1	446	7628672	7628226	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	56280	680	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
22049627	22049627	PRJNA293022_P_NODE_19378_length_324_cov_1.221818_g18641_i0	PRJNA293022	19378	324	1.221818	3.95869032	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	525	1.4899999999999996e-144	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g18641	i0	96.25	168.487654320988	320	12	99	0	3	322	4955911	4956230	Planctomyces sp. SH-PL14, complete genome	blastn	54590	525	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
22049745	22049745	PRJNA293022_P_NODE_43418_length_212_cov_1.042945_g42681_i0	PRJNA293022	43418	212	1.042945	2.2110434	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	158	3.8399999999999998e-34	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g42681	i0	91.379	58.7264150943396	116	8	55	2	30	145	1867777	1867664	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	12450	158	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
22049748	22049748	PRJNA293022_P_NODE_43738_length_211_cov_1.537037_g43001_i0	PRJNA293022	43738	211	1.537037	3.24314807	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	265	2.19e-66	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g43001	i0	90.863	200.123222748815	197	18	95	0	9	205	5936229	5936425	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	42226	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
23325532	23325532	PRJNA293022_P_NODE_839_length_1300_cov_4.299760_g592_i0	PRJNA293022	839	1300	4.29976	55.89688	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	1639	0	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g592	i0	89.534	112.976153846154	1309	116	99	18	1	1296	7629759	7631059	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	146869	1639	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
24011690	24011690	PRJNA293022_P_NODE_75079_length_164_cov_1.600000_g74342_i0	PRJNA293022	75079	164	1.6	2.624	Pirellulaceae	2691357	Bacteria	Bacteria	287	3.45e-73	NTclustered	gi\|1727550343\|gb\|CP042914.1\|	980254	g74342	i0	99.367	147.90243902439	158	1	96	0	3	160	6159756	6159913	Roseimaritima ulvae strain UC8 chromosome, complete genome	blastn	24256	289	0.993079584775087	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Roseimaritima	Roseimaritima ulvae
24599593	24599593	PRJNA293022_P_NODE_840_length_1300_cov_4.191847_g592_i1	PRJNA293022	840	1300	4.191847	54.494011	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	1533	0	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g592	i1	88.092	115.168461538462	1310	133	99	20	5	1300	7631059	7629759	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	149719	1533	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
25285767	25285767	PRJNA293022_P_NODE_21760_length_305_cov_1.535156_g21023_i0	PRJNA293022	21760	305	1.535156	4.6822258	Rhodopirellula	265488	Bacteria	Bacteria	558	1.37e-154	NTclustered	gi\|32445988\|emb\|BX294148.1\|	243090	g21023	i0	99.672	166.652459016393	305	1	100	0	1	305	36866	36562	Rhodopirellula baltica SH 1 complete genome; segment 16/24	blastn	50829	558	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula baltica

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