metadata: contig_metadata: 35 rows where bioproject = "PRJNA1255065", tax_clade = "PVC group" and tax

35 rows where bioproject = "PRJNA1255065", tax_clade = "PVC group" 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
4187791	4187791	PRJNA1255065_P_NODE_90964_length_185_cov_1.117647_g88736_i0	PRJNA1255065	90964	185	1.117647	2.06764695	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	255	1.12e-63	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g88736	i0	91.489	105.697297297297	188	12	100	4	1	185	7051230	7051044	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	19554	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
4881114	4881114	PRJNA1255065_P_NODE_121344_length_167_cov_0.881356_g119116_i0	PRJNA1255065	121344	167	0.881356	1.47186452	Gemmata	113	Bacteria	Bacteria	287	3.53e-73	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g119116	i0	97.605	147.904191616766	167	4	100	0	1	167	1796	1630	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	24700	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
6737689	6737689	PRJNA1255065_P_NODE_123306_length_166_cov_0.888889_g121078_i0	PRJNA1255065	123306	166	0.888889	1.47555574	Isosphaera pallida	128	Bacteria	Bacteria	158	2.8599999999999993e-34	NTclustered	gi\|319748837\|gb\|CP002353.1\|	575540	g121078	i0	83.721	1.03614457831325	172	22	100	3	1	166	4927515	4927344	Isosphaera pallida ATCC 43644, complete genome	blastn	172	158	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
11839058	11839058	PRJNA1255065_P_NODE_62670_length_238_cov_1.555556_g60442_i0	PRJNA1255065	62670	238	1.555556	3.70222328	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	281	2.5e-71	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g60442	i0	90	69.0588235294118	220	19	92	3	20	238	4317253	4317036	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	16436	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13114466	13114466	PRJNA1255065_P_NODE_76231_length_207_cov_1.367089_g74003_i0	PRJNA1255065	76231	207	1.367089	2.82987423	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	292	9.8e-75	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g74003	i0	92.271	172.342995169082	207	14	99	2	2	207	2002624	2002829	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	35675	292	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
15081208	15081208	PRJNA1255065_P_NODE_89512_length_187_cov_0.826087_g87284_i0	PRJNA1255065	89512	187	0.826087	1.54478269	Planctomycetia	203683	Bacteria	Bacteria	220	4.15e-53	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g87284	i0	93.289	238.604278074866	149	10	80	0	27	175	522	670	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	44619	222	0.990990990990991	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
15663241	15663241	PRJNA1255065_P_NODE_40113_length_354_cov_1.039344_g37891_i0	PRJNA1255065	40113	354	1.039344	3.67927776	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	531	3.5299999999999993e-146	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g37891	i0	94.985	126.813559322034	339	15	96	1	16	354	558744	558408	Gemmata sp. SH-PL17, complete genome	blastn	44892	531	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
22036521	22036521	PRJNA1255065_P_NODE_113938_length_168_cov_0.873950_g111710_i0	PRJNA1255065	113938	168	0.87395	1.468236	Aureliella helgolandensis	2527968	Bacteria	Bacteria	305	9.81e-79	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g111710	i0	99.405	113.446428571429	168	1	100	0	1	168	6999517	6999684	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	19059	305	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
26598673	26598673	PRJNA1255065_P_NODE_141821_length_163_cov_0.912281_g139593_i0	PRJNA1255065	141821	163	0.912281	1.48701803	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	42.7	0.0127	NR	MBL8760154.1	2026778	g139593	i0	46.5	0.791411042944785	43	23	79.1	0	26	154	7	49	MBL8760154.1 acyl carrier protein [Phycisphaerae bacterium]	diamond	129	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
26789112	26789112	PRJNA1255065_P_NODE_111501_length_168_cov_0.873950_g109273_i0	PRJNA1255065	111501	168	0.87395	1.468236	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	102	9.249999999999999e-24	NR	MBY0112615.1	2052180	g109273	i0	96.4	0.982142857142857	55	2	98.2	0	2	166	542	596	MBY0112615.1 hypothetical protein [Phycisphaerales bacterium]	diamond	165	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
26789123	26789123	PRJNA1255065_P_NODE_88501_length_188_cov_1.266187_g86273_i0	PRJNA1255065	88501	188	1.266187	2.38043156	Planctomycetia bacterium	2052181	Bacteria	Bacteria	64.3	4.4e-10	NR	MDZ4780293.1	2052181	g86273	i0	55.7	0.973404255319149	61	27	97.3	0	183	1	908	968	MDZ4780293.1 hypothetical protein [Planctomycetia bacterium]	diamond	183	64.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
27091738	27091738	PRJNA1255065_P_NODE_114302_length_168_cov_0.873950_g112074_i0	PRJNA1255065	114302	168	0.87395	1.468236	Bacteria	2	Bacteria	Bacteria	68.6	1.08e-11	NR	MDA1053221.1	2026780	g112074	i0	67.3	2.80357142857143	52	17	92.9	0	7	162	210	261	MDA1053221.1 hypothetical protein [Planctomycetota bacterium]	diamond	471	68.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27358461	27358461	PRJNA1255065_P_NODE_143703_length_163_cov_0.912281_g141475_i0	PRJNA1255065	143703	163	0.912281	1.48701803	Planctomycetota bacterium	2026780	Bacteria	Bacteria	71.6	7.86e-13	NR	HTF89847.1	2026780	g141475	i0	68.5	2.98159509202454	54	17	99.4	0	1	162	210	263	HTF89847.1 NTP transferase domain-containing protein [Planctomycetota bacterium]	diamond	486	71.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27358464	27358464	PRJNA1255065_P_NODE_152543_length_162_cov_0.920354_g150315_i0	PRJNA1255065	152543	162	0.920354	1.49097348	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	87.4	6.16e-21	NR	MFO0918092.1	2026779	g150315	i0	77.4	0.981481481481482	53	12	98.1	0	2	160	12	64	MFO0918092.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	159	87.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27390071	27390071	PRJNA1255065_P_NODE_145303_length_163_cov_0.912281_g143075_i0	PRJNA1255065	145303	163	0.912281	1.48701803	Planctomycetota bacterium	2026780	Bacteria	Bacteria	83.6	3.34e-19	NR	MBW3596167.1	2026780	g143075	i0	85.4	0.883435582822086	48	6	86.5	1	3	143	55	102	MBW3596167.1 hypothetical protein [Planctomycetota bacterium]	diamond	144	83.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27579297	27579297	PRJNA1255065_P_NODE_137524_length_164_cov_0.904348_g135296_i0	PRJNA1255065	137524	164	0.904348	1.48313072	Urbifossiella sp.	2807431	Bacteria	Bacteria	45.4	0.00131	NR	HYH66308.1	2807431	g135296	i0	87.5	2.06707317073171	24	3	43.9	0	1	72	226	249	HYH66308.1 DUF932 domain-containing protein [Urbifossiella sp.]	diamond	339	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella sp.
27706013	27706013	PRJNA1255065_P_NODE_144364_length_163_cov_0.912281_g142136_i0	PRJNA1255065	144364	163	0.912281	1.48701803	Gemmataceae bacterium	2052164	Bacteria	Bacteria	99	5.9e-23	NR	MFO0849825.1	2052164	g142136	i0	94.4	0.993865030674847	54	3	99.4	0	162	1	232	285	MFO0849825.1 hypothetical protein [Gemmataceae bacterium]	diamond	162	99	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27926648	27926648	PRJNA1255065_P_NODE_136325_length_164_cov_0.904348_g134097_i0	PRJNA1255065	136325	164	0.904348	1.48313072	Planctomycetota bacterium	2026780	Bacteria	Bacteria	73.9	1.26e-13	NR	MEX1023767.1	2026780	g134097	i0	66	0.969512195121951	53	18	97	0	3	161	421	473	MEX1023767.1 PQQ-binding-like beta-propeller repeat protein [Planctomycetota bacterium]	diamond	159	73.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28210627	28210627	PRJNA1255065_P_NODE_123286_length_166_cov_0.888889_g121058_i0	PRJNA1255065	123286	166	0.888889	1.47555574	Planctomycetota bacterium	2026780	Bacteria	Bacteria	98.6	6.859999999999999e-23	NR	MDA1039982.1	2026780	g121058	i0	88.7	0.957831325301205	53	6	95.8	0	6	164	258	310	MDA1039982.1 DUF3500 domain-containing protein [Planctomycetota bacterium]	diamond	159	98.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28242219	28242219	PRJNA1255065_P_NODE_140046_length_164_cov_0.904348_g137818_i0	PRJNA1255065	140046	164	0.904348	1.48313072	Singulisphaera sp. Ch	1906241	Bacteria	Bacteria	41.6	0.0328	NR	WP_406701222.1	3120278	g137818	i0	41.9	1.57317073170732	43	25	78.7	0	148	20	130	172	WP_406701222.1 recombinase family protein [Singulisphaera sp. Ch08]	diamond	258	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
28589857	28589857	PRJNA1255065_P_NODE_140147_length_164_cov_0.904348_g137919_i0	PRJNA1255065	140147	164	0.904348	1.48313072	Planctomycetales bacterium	2053591	Bacteria	Bacteria	73.2	2.35e-13	NR	MCX7408675.1	2053591	g137919	i0	57.4	0.98780487804878	54	23	98.8	0	2	163	263	316	MCX7408675.1 hypothetical protein [Planctomycetales bacterium]	diamond	162	73.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
29221368	29221368	PRJNA1255065_P_NODE_112069_length_168_cov_0.873950_g109841_i0	PRJNA1255065	112069	168	0.87395	1.468236	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	60.5	4.83e-9	NR	MBC7835745.1	2052180	g109841	i0	55.4	1	56	25	100	0	168	1	124	179	MBC7835745.1 PHP domain-containing protein [Phycisphaerales bacterium]	diamond	168	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29568431	29568431	PRJNA1255065_P_NODE_132890_length_165_cov_0.896552_g130662_i0	PRJNA1255065	132890	165	0.896552	1.4793108	Pirellulimonas nuda	2528009	Bacteria	Bacteria	57	1.18e-7	NR	WP_231954236.1	2528009	g130662	i0	46.2	3.67272727272727	52	28	94.5	0	158	3	436	487	WP_231954236.1 peroxidase family protein [Pirellulimonas nuda]	diamond	606	57	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Pirellulimonas	Pirellulimonas nuda
29726088	29726088	PRJNA1255065_P_NODE_144390_length_163_cov_0.912281_g142162_i0	PRJNA1255065	144390	163	0.912281	1.48701803	Gemmata palustris	2822762	Bacteria	Bacteria	67.8	1.86e-11	NR	WP_210653772.1	2822762	g142162	i0	72.2	0.993865030674847	54	15	99.4	0	1	162	325	378	WP_210653772.1 DNA repair protein RecN [Gemmata palustris]	diamond	162	67.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata palustris
29852741	29852741	PRJNA1255065_P_NODE_111271_length_168_cov_0.873950_g109043_i0	PRJNA1255065	111271	168	0.87395	1.468236	Pirellulales bacterium	2715253	Bacteria	Bacteria	90.1	2.71e-19	NR	MFO0943857.1	2715253	g109043	i0	80	0.982142857142857	55	11	98.2	0	166	2	665	719	MFO0943857.1 efflux RND transporter permease subunit [Pirellulales bacterium]	diamond	165	90.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
30136624	30136624	PRJNA1255065_P_NODE_116752_length_167_cov_0.881356_g114524_i0	PRJNA1255065	116752	167	0.881356	1.47186452	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	42.7	0.0133	NR	MBG81366.1	2026778	g114524	i0	58.3	0.431137724550898	24	10	43.1	0	66	137	315	338	MBG81366.1 glycerate kinase [Phycisphaerae bacterium]	diamond	72	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30547717	30547717	PRJNA1255065_P_NODE_108693_length_169_cov_0.866667_g106465_i0	PRJNA1255065	108693	169	0.866667	1.46466723	Planctomycetota bacterium	2026780	Bacteria	Bacteria	86.3	8.05e-19	NR	MBM4067801.1	2026780	g106465	i0	70.4	0.958579881656805	54	16	95.9	0	3	164	162	215	MBM4067801.1 c-type cytochrome [Planctomycetota bacterium]	diamond	162	86.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30674014	30674014	PRJNA1255065_P_NODE_132073_length_165_cov_0.896552_g129845_i0	PRJNA1255065	132073	165	0.896552	1.4793108	Pirellulales bacterium	2715253	Bacteria	Bacteria	67.4	2.54e-11	NR	HEY2893489.1	2715253	g129845	i0	59.3	1.96363636363636	54	21	98.2	1	164	3	213	265	HEY2893489.1 PQQ-binding-like beta-propeller repeat protein [Pirellulales bacterium]	diamond	324	67.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
30800381	30800381	PRJNA1255065_P_NODE_119834_length_167_cov_0.881356_g117606_i0	PRJNA1255065	119834	167	0.881356	1.47186452	Planctomycetota bacterium	2026780	Bacteria	Bacteria	110	2.16e-26	NR	MFN7590958.1	2026780	g117606	i0	96.4	0.988023952095808	55	2	98.8	0	167	3	8	62	MFN7590958.1 M20/M25/M40 family metallo-hydrolase [Planctomycetota bacterium]	diamond	165	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30958590	30958590	PRJNA1255065_P_NODE_119954_length_167_cov_0.881356_g117726_i0	PRJNA1255065	119954	167	0.881356	1.47186452	Planctomycetota bacterium	2026780	Bacteria	Bacteria	92.4	6.57e-22	NR	MFM8413133.1	2026780	g117726	i0	91.7	0.862275449101796	48	4	86.2	0	3	146	96	143	MFM8413133.1 hypothetical protein [Planctomycetota bacterium]	diamond	144	92.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31116232	31116232	PRJNA1255065_P_NODE_68115_length_224_cov_0.828571_g65887_i0	PRJNA1255065	68115	224	0.828571	1.85599904	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.3	0.00806	NR	MCE9619567.1	2026780	g65887	i0	31.6	0.763392857142857	57	35	76.3	1	184	14	111	163	MCE9619567.1 prolipoprotein diacylglyceryl transferase [Planctomycetota bacterium]	diamond	171	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31685537	31685537	PRJNA1255065_P_NODE_112157_length_168_cov_0.873950_g109929_i0	PRJNA1255065	112157	168	0.87395	1.468236	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	97.8	1.7000000000000002e-22	NR	HEX2476892.1	2691534	g109929	i0	83.9	1	56	9	100	0	1	168	235	290	HEX2476892.1 hypothetical protein [Lacipirellulaceae bacterium]	diamond	168	97.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
32096925	32096925	PRJNA1255065_P_NODE_123478_length_166_cov_0.888889_g121250_i0	PRJNA1255065	123478	166	0.888889	1.47555574	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	91.3	3.12e-20	NR	MFO0889695.1	2691532	g121250	i0	86.8	1.93373493975904	53	7	95.8	0	164	6	178	230	MFO0889695.1 threonine/serine dehydratase [Isosphaeraceae bacterium]	diamond	321	91.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
32413467	32413467	PRJNA1255065_P_NODE_111199_length_168_cov_0.873950_g108971_i0	PRJNA1255065	111199	168	0.87395	1.468236	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	50.1	2.46e-5	NR	MBL9125353.1	2026779	g108971	i0	77.8	0.482142857142857	27	6	48.2	0	167	87	190	216	MBL9125353.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	81	50.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32697364	32697364	PRJNA1255065_P_NODE_145960_length_163_cov_0.912281_g143732_i0	PRJNA1255065	145960	163	0.912281	1.48701803	Pirellula sp.	117	Bacteria	Bacteria	78.2	1.51e-16	NR	MBA4105285.1	117	g143732	i0	75.5	0.975460122699387	53	13	97.5	0	163	5	19	71	MBA4105285.1 hypothetical protein [Pirellula sp.]	diamond	159	78.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.

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