metadata: contig_metadata: 30 rows where bioproject = "PRJNA399711", tax_clade = "PVC group" and tax

30 rows where bioproject = "PRJNA399711", 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
9341546	9341546	PRJNA399711_P_NODE_11248_length_190_cov_2.457516_g11182_i0	PRJNA399711	11248	190	2.457516	4.6692804	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	78.7	2.69e-10	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g11182	i0	95.918	1.52105263157895	49	1	26	1	139	187	864884	864837	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	289	78.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
25565303	25565303	PRJNA399711_S_NODE_93585_length_159_cov_0.959016_g93443_i0	PRJNA399711	93585	159	0.959016	1.52483544	Gemmataceae bacterium	2052164	Bacteria	Bacteria	134	4.5700000000000005e-27	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g93443	i0	82.781	7.11320754716981	151	24	94	2	10	159	3658678	3658529	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	1131	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
25701220	25701220	PRJNA399711_S_NODE_85714_length_164_cov_1.519685_g85572_i0	PRJNA399711	85714	164	1.519685	2.4922834	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	132	1.71e-26	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g85572	i0	90.816	0.597560975609756	98	9	60	0	1	98	5284056	5284153	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	98	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
25835887	25835887	PRJNA399711_S_NODE_47019_length_203_cov_8.566265_g46877_i0	PRJNA399711	47019	203	8.566265	17.38951795	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	261	2.7000000000000007e-65	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g46877	i0	91.935	91.9064039408867	186	15	92	0	1	186	5171963	5171778	Lacipirellula limnantheis strain I41 chromosome	blastn	18657	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
25972112	25972112	PRJNA399711_S_NODE_45404_length_206_cov_3.650888_g45262_i0	PRJNA399711	45404	206	3.650888	7.52082928	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	80.5	8.26e-11	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g45262	i0	84.524	2.04854368932039	84	9	40	2	93	174	4666888	4666969	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	422	80.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
26244572	26244572	PRJNA399711_S_NODE_52782_length_195_cov_3.772152_g52640_i0	PRJNA399711	52782	195	3.772152	7.3556964	Singulisphaera acidiphila DSM 18658	886293	Bacteria	Bacteria	224	3.369999999999999e-54	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g52640	i0	87.374	2.98974358974359	198	22	100	2	1	195	4804725	4804922	Singulisphaera acidiphila DSM 18658, complete genome	blastn	583	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
26245115	26245115	PRJNA399711_S_NODE_67558_length_178_cov_6.000000_g67416_i0	PRJNA399711	67558	178	6	10.68	Stieleria varia	2528005	Bacteria	Bacteria	62.1	2.5e-5	NTclustered	gi\|2720418917\|gb\|CP151726.1\|	2528005	g67416	i0	97.222	1.38202247191011	36	1	21	0	131	166	155766	155801	Stieleria varia strain Pla52n chromosome, complete genome	blastn	246	62.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria varia
26516398	26516398	PRJNA399711_S_NODE_47792_length_202_cov_5.109091_g47650_i0	PRJNA399711	47792	202	5.109091	10.32036382	Alienimonas californiensis	2527989	Bacteria	Bacteria	95.3	2.88e-15	NTclustered	gi\|1712468061\|gb\|CP036265.1\|	2527989	g47650	i0	88.75	0.396039603960396	80	6	39	3	62	139	1854549	1854627	Alienimonas californiensis strain CA12 chromosome	blastn	80	95.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Alienimonas	Alienimonas californiensis
26695457	26695457	PRJNA399711_P_NODE_20301_length_160_cov_2.796748_g20235_i0	PRJNA399711	20301	160	2.796748	4.4747968	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	55.8	2.85e-7	NR	MCW5774847.1	2026777	g20235	i0	57.1	1.5375	42	18	78.8	0	144	19	271	312	MCW5774847.1 Fic family protein [Phycisphaeraceae bacterium]	diamond	246	55.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
26839216	26839216	PRJNA399711_P_NODE_11881_length_187_cov_2.240000_g11815_i0	PRJNA399711	11881	187	2.24	4.1888	Urbifossiella	2807415	Bacteria	Bacteria	106	5.3999999999999985e-25	NR	MFO0847791.1	2052164	g11815	i0	77	5.8716577540107	61	14	97.9	0	185	3	947	1007	MFO0847791.1 glutamate synthase-related protein [Gemmataceae bacterium]	diamond	1098	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27486231	27486231	PRJNA399711_P_NODE_6243_length_226_cov_1.878307_g6177_i0	PRJNA399711	6243	226	1.878307	4.24497382	Gemmataceae bacterium	2052164	Bacteria	Bacteria	95.5	7.669999999999999e-23	NR	HXG08538.1	2052164	g6177	i0	66.2	0.902654867256637	68	22	88.9	1	202	2	45	112	HXG08538.1 hypothetical protein [Gemmataceae bacterium]	diamond	204	95.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28086017	28086017	PRJNA399711_P_NODE_5325_length_236_cov_2.613065_g5259_i0	PRJNA399711	5325	236	2.613065	6.1668334	Candidatus Laterigemmans baculatus	2770505	Bacteria	Bacteria	87	6.27e-18	NR	WP_164101238.1	2770505	g5259	i0	82	3.38135593220339	50	9	63.6	0	85	234	205	254	WP_164101238.1 tagaturonate epimerase family protein [Candidatus Laterigemmans baculatus]	diamond	798	87	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Candidatus Laterigemmans	Candidatus Laterigemmans baculatus
30233387	30233387	PRJNA399711_P_NODE_21152_length_157_cov_2.900000_g21086_i0	PRJNA399711	21152	157	2.9	4.553	Aureliella helgolandensis	2527968	Bacteria	Bacteria	68.2	8.47e-12	NR	WP_145074375.1	2527968	g21086	i0	59.6	1.79617834394904	47	19	89.8	0	13	153	252	298	WP_145074375.1 metallophosphoesterase family protein [Aureliella helgolandensis]	diamond	282	68.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
30928590	30928590	PRJNA399711_P_NODE_22674_length_153_cov_1.120690_g22608_i0	PRJNA399711	22674	153	1.12069	1.7146557	Gemmataceae bacterium	2052164	Bacteria	Bacteria	50.1	2.78e-5	NR	MBX3399266.1	2052164	g22608	i0	46.9	0.96078431372549	49	25	94.1	1	5	148	9	57	MBX3399266.1 hypothetical protein [Gemmataceae bacterium]	diamond	147	50.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32917914	32917914	PRJNA399711_S_NODE_88489_length_162_cov_1.808000_g88347_i0	PRJNA399711	88489	162	1.808	2.92896	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	40	0.0492	NR	MCU0981790.1	2699754	g88347	i0	37.5	0.740740740740741	40	25	74.1	0	42	161	25	64	MCU0981790.1 hypothetical protein [Pirellulaceae bacterium]	diamond	120	40	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
32952012	32952012	PRJNA399711_S_NODE_42250_length_211_cov_9.471264_g42108_i0	PRJNA399711	42250	211	9.471264	19.98436704	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	42	0.0446	NR	MCA9023924.1	2026779	g42108	i0	38.5	0.554502369668246	39	24	55.5	0	146	30	251	289	MCA9023924.1 glycogen synthase GlgA [Planctomycetaceae bacterium]	diamond	117	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32958453	32958453	PRJNA399711_S_NODE_44610_length_207_cov_7.205882_g44468_i0	PRJNA399711	44610	207	7.205882	14.91617574	Bacteria	2	Bacteria	Bacteria	90.5	3.01e-19	NR	MCC8180781.1	2026780	g44468	i0	80.4	30.6376811594203	46	9	66.7	0	3	140	441	486	MCC8180781.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Planctomycetota bacterium]	diamond	6342	91.3	0.991237677984666	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32975545	32975545	PRJNA399711_S_NODE_16122_length_296_cov_9.374517_g15980_i0	PRJNA399711	16122	296	9.374517	27.74857032	Pseudomonadati	3379134	Bacteria	Bacteria	90.5	4.2e-19	NR	MFQ5655497.1	2026780	g15980	i0	47.8	7.24662162162162	90	47	91.2	0	15	284	2	91	MFQ5655497.1 DEAD/DEAH box helicase [Planctomycetota bacterium]	diamond	2145	90.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32986248	32986248	PRJNA399711_S_NODE_48763_length_201_cov_2.012195_g48621_i0	PRJNA399711	48763	201	2.012195	4.04451195	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	91.3	1.79e-19	NR	MBC7772492.1	2052180	g48621	i0	65.2	3.94029850746269	66	23	98.5	0	198	1	1029	1094	MBC7772492.1 PAS domain S-box protein [Phycisphaerales bacterium]	diamond	792	91.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32986340	32986340	PRJNA399711_S_NODE_62611_length_183_cov_7.547945_g62469_i0	PRJNA399711	62611	183	7.547945	13.81273935	Planctomycetota bacterium	2026780	Bacteria	Bacteria	56.6	2.08e-7	NR	MFK5955477.1	2026780	g62469	i0	71	2.68852459016393	31	9	50.8	0	50	142	545	575	MFK5955477.1 HAMP domain-containing sensor histidine kinase [Planctomycetota bacterium]	diamond	492	56.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
33003209	33003209	PRJNA399711_S_NODE_50803_length_198_cov_2.403727_g50661_i0	PRJNA399711	50803	198	2.403727	4.75937946	Planctomycetota bacterium	2026780	Bacteria	Bacteria	65.5	1.09e-10	NR	MCI0333487.1	2026780	g50661	i0	58.1	0.939393939393939	62	23	93.9	2	13	198	203	261	MCI0333487.1 PEP-CTERM sorting domain-containing protein [Planctomycetota bacterium]	diamond	186	65.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
33020108	33020108	PRJNA399711_S_NODE_3228_length_487_cov_3.831111_g3102_i0	PRJNA399711	3228	487	3.831111	18.65751057	Rhodopirellula sp.	2024855	Bacteria	Bacteria	164	1.32e-46	NR	MAQ88887.1	2024855	g3102	i0	56.4	7.36139630390144	149	60	89.3	2	44	478	1	148	MAQ88887.1 single-stranded DNA-binding protein [Rhodopirellula sp.]	diamond	3585	164	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula sp.
33020464	33020464	PRJNA399711_S_NODE_89484_length_161_cov_3.395161_g89342_i0	PRJNA399711	89484	161	3.395161	5.46620921	Symmachiella dynata	2527995	Bacteria	Bacteria	90.9	1.32e-19	NR	WP_145424057.1	2527995	g89342	i0	80.8	1.93788819875776	52	10	96.9	0	3	158	227	278	WP_145424057.1 AAA family ATPase [Symmachiella dynata]	diamond	312	90.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Symmachiella	Symmachiella dynata
33071098	33071098	PRJNA399711_S_NODE_18141_length_285_cov_4.153226_g17999_i0	PRJNA399711	18141	285	4.153226	11.8366941	Planctomycetota bacterium	2026780	Bacteria	Bacteria	54.7	2.49e-6	NR	RMF81201.1	2026780	g17999	i0	40.6	0.726315789473684	69	41	72.6	0	208	2	67	135	RMF81201.1 MAG: PEP-CTERM sorting domain-containing protein [Planctomycetota bacterium]	diamond	207	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
33077855	33077855	PRJNA399711_S_NODE_91389_length_160_cov_2.235772_g91247_i0	PRJNA399711	91389	160	2.235772	3.5772352	Planctomycetia	203683	Bacteria	Bacteria	102	3.669999999999999e-24	NR	MCB9941545.1	2026779	g91247	i0	92.3	1.95	52	4	97.5	0	158	3	158	209	MCB9941545.1 putative zinc-binding metallopeptidase [Planctomycetaceae bacterium]	diamond	312	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
33088448	33088448	PRJNA399711_S_NODE_43166_length_210_cov_3.132948_g43024_i0	PRJNA399711	43166	210	3.132948	6.5791908	Planctomycetota bacterium	2026780	Bacteria	Bacteria	52	4.47e-6	NR	REJ65432.1	2026780	g43024	i0	67.7	0.442857142857143	31	10	44.3	0	2	94	75	105	REJ65432.1 MAG: hypothetical protein DWQ31_18235 [Planctomycetota bacterium]	diamond	93	52	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
33088764	33088764	PRJNA399711_S_NODE_88390_length_162_cov_2.072000_g88248_i0	PRJNA399711	88390	162	2.072	3.35664	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	43.5	0.00662	NR	MFO1044496.1	2026779	g88248	i0	73.1	0.481481481481481	26	7	48.1	0	80	3	7	32	MFO1044496.1 AAA family ATPase [Planctomycetaceae bacterium]	diamond	78	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
33105332	33105332	PRJNA399711_S_NODE_15198_length_302_cov_6.184906_g15056_i0	PRJNA399711	15198	302	6.184906	18.67841612	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	67	6.53e-11	NR	MCA9111532.1	2026779	g15056	i0	45.2	1.46026490066225	73	33	65.6	1	105	302	81	153	MCA9111532.1 restriction endonuclease subunit S [Planctomycetaceae bacterium]	diamond	441	67	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
33139563	33139563	PRJNA399711_S_NODE_34775_length_226_cov_11.010582_g34633_i0	PRJNA399711	34775	226	11.010582	24.88391532	Planctomycetia bacterium	2052181	Bacteria	Bacteria	75.1	9.69e-14	NR	QOJ14017.1	2052181	g34633	i0	50.7	0.915929203539823	69	27	91.6	1	213	7	210	271	QOJ14017.1 MAG: hypothetical protein HRU75_04920 [Planctomycetia bacterium]	diamond	207	75.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
33180208	33180208	PRJNA399711_S_NODE_11160_length_334_cov_2.414141_g11018_i0	PRJNA399711	11160	334	2.414141	8.06323094	Bacteria	2	Bacteria	Bacteria	169	4.119999999999999e-47	NR	HVK08270.1	2052164	g11018	i0	76.7	4.57185628742515	103	24	92.5	0	331	23	137	239	HVK08270.1 Gfo/Idh/MocA family oxidoreductase [Gemmataceae bacterium]	diamond	1527	170	0.994117647058824	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium

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