metadata: contig_metadata: 27 rows where bioproject = "PRJNA572587", tax_clade = "PVC group" and tax

27 rows where bioproject = "PRJNA572587", 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
558664	558664	PRJNA572587_P_NODE_12261_length_333_cov_43.031690_g11933_i0	PRJNA572587	12261	333	43.03169	143.2955277	Planctomycetota bacterium	2026780	Bacteria	Bacteria	107	3.13e-25	NR	RLT03977.1	2026780	g11933	i0	78.8	0.594594594594595	66	14	59.5	0	20	217	28	93	RLT03977.1 MAG: serine/threonine protein kinase, partial [Planctomycetota bacterium]	diamond	198	107	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
559089	559089	PRJNA572587_P_NODE_3781_length_668_cov_99.817447_g3493_i0	PRJNA572587	3781	668	99.817447	666.78054596	Pirellula staleyi	125	Bacteria	Bacteria	671	0	NTclustered	gi\|283436255\|gb\|CP001848.1\|	530564	g3493	i0	85.54	190.711077844311	657	77	96	11	27	668	3346595	3347248	Pirellula staleyi DSM 6068 chromosome, complete genome	blastn	127395	671	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
559125	559125	PRJNA572587_P_NODE_4261_length_623_cov_76.367596_g3962_i0	PRJNA572587	4261	623	76.367596	475.77012308	Aureliella sp.	2795609	Bacteria	Bacteria	747	0	NTclustered	gi\|2626244095\|emb\|OY829846.1\|	2795609	g3962	i0	95.319	122.534510433387	470	22	98	0	1	470	5638308	5638777	MAG: Aureliella sp. isolate e39ea203-26a8-405f-9782-9267d5c1de48 genome assembly, chromosome: 1	blastn	76339	747	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella sp.
3109701	3109701	PRJNA572587_P_NODE_20383_length_250_cov_51.203980_g20055_i0	PRJNA572587	20383	250	51.20398	128.00995	Caulifigura coniformis	2527983	Bacteria	Bacteria	368	1.98e-97	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g20055	i0	95.633	14.344	229	10	92	0	20	248	2924955	2925183	Caulifigura coniformis strain Pan44 chromosome	blastn	3586	368	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
4386529	4386529	PRJNA572587_P_NODE_39044_length_175_cov_10.452381_g38716_i0	PRJNA572587	39044	175	10.452381	18.29166675	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	196	6.44e-46	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g38716	i0	89.744	14.8857142857143	156	12	87	3	23	175	7051358	7051512	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	2605	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
5662664	5662664	PRJNA572587_P_NODE_27625_length_212_cov_11.932515_g27297_i0	PRJNA572587	27625	212	11.932515	25.2969318	Caulifigura coniformis	2527983	Bacteria	Bacteria	300	6.03e-77	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g27297	i0	96.667	173.882075471698	180	6	85	0	11	190	2925545	2925366	Caulifigura coniformis strain Pan44 chromosome	blastn	36863	300	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
7513772	7513772	PRJNA572587_P_NODE_16826_length_278_cov_45.995633_g16498_i0	PRJNA572587	16826	278	45.995633	127.86785974	Planctopirus	1649480	Bacteria	Bacteria	342	1.36e-89	NTclustered	gi\|470485078\|ref\|NR_076683.1\|	120	g16498	i0	91.016	121.834532374101	256	19	91	4	3	256	1038	785	Planctomyces limnophilus strain Mue 290 23S ribosomal RNA gene, complete sequence	blastn	33870	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus limnophila
8211895	8211895	PRJNA572587_P_NODE_24507_length_227_cov_5.146067_g24179_i0	PRJNA572587	24507	227	5.146067	11.68157209	planctomycete str. 140	69477	Bacteria	Bacteria	268	1.84e-67	NTclustered	gi\|12583968\|gb\|AF245372.1\|AF245372	69477	g24179	i0	93.37	11.0044052863436	181	12	80	0	29	209	199	19	Planctomycete str. 140 23S ribosomal RNA gene, partial sequence	blastn	2498	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 140
9487468	9487468	PRJNA572587_P_NODE_44048_length_165_cov_2.784483_g43720_i0	PRJNA572587	44048	165	2.784483	4.59439695	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	169	1.31e-37	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g43720	i0	85.714	50.5515151515152	161	21	97	2	1	160	7631057	7630898	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	8341	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
10763124	10763124	PRJNA572587_P_NODE_20009_length_253_cov_20.696078_g19681_i0	PRJNA572587	20009	253	20.696078	52.36107734	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	243	1.27e-59	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g19681	i0	85.593	10.7628458498024	236	29	92	5	21	252	2480404	2480170	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	2723	243	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10763522	10763522	PRJNA572587_P_NODE_8549_length_413_cov_6.123626_g8223_i0	PRJNA572587	8549	413	6.123626	25.29057538	Fimbriiglobus sp.	1914235	Bacteria	Bacteria	202	8.73e-58	NR	MCU0702671.1	1914235	g8223	i0	79.5	0.958837772397094	132	27	95.9	0	18	413	305	436	MCU0702671.1 ComEC/Rec2 family competence protein [Fimbriiglobus sp.]	diamond	396	202	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus sp.
12038067	12038067	PRJNA572587_P_NODE_33410_length_191_cov_12.119718_g33082_i0	PRJNA572587	33410	191	12.119718	23.14866138	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	98.6	1.1e-22	NR	MFN0195270.1	2026779	g33082	i0	94.1	0.801047120418848	51	3	80.1	0	37	189	101	151	MFN0195270.1 flotillin-like protein FloA [Planctomycetaceae bacterium]	diamond	153	98.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
17136619	17136619	PRJNA572587_P_NODE_3054_length_749_cov_21.682857_g2797_i0	PRJNA572587	3054	749	21.682857	162.40459893	Stratiformator vulcanicus	2527980	Bacteria	Bacteria	636	1.6299999999999995e-177	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g2797	i0	83.287	69.8651535380507	724	87	96	18	26	746	3083397	3082705	Stratiformator vulcanicus strain Pan189 chromosome	blastn	52329	636	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
18410769	18410769	PRJNA572587_P_NODE_23955_length_230_cov_3.729282_g23627_i0	PRJNA572587	23955	230	3.729282	8.5773486	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	270	5.21e-68	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g23627	i0	90.385	131.295652173913	208	17	90	3	1	206	2665602	2665396	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	30198	270	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
19685369	19685369	PRJNA572587_P_NODE_25976_length_219_cov_120.982353_g25648_i0	PRJNA572587	25976	219	120.982353	264.95135307	Lacipirellula parvula	2650471	Bacteria	Bacteria	344	2.85e-90	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g25648	i0	98.958	29.2739726027397	192	2	88	0	24	215	5164241	5164050	Lacipirellula parvula PX69 DNA, complete genome	blastn	6411	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
20960873	20960873	PRJNA572587_P_NODE_1617_length_999_cov_32.985263_g1464_i0	PRJNA572587	1617	999	32.985263	329.52277736999997	Gemmatales bacterium	2838789	Bacteria	Bacteria	518	4.61e-179	NR	GIW78573.1	2838789	g1464	i0	82.9	1.8978978978979	316	54	94.9	0	24	971	226	541	GIW78573.1 MAG: ATPase [Gemmatales bacterium]	diamond	1896	518	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales			Gemmatales bacterium
26984522	26984522	PRJNA572587_P_NODE_2202_length_874_cov_4.721212_g2008_i0	PRJNA572587	2202	874	4.721212	41.26339288	Pirellula staleyi DSM 6	125	Bacteria	Bacteria	104	4.52e-22	NR	ADB17639.1	530564	g2008	i0	64.6	1.15675057208238	79	28	27.1	0	5	241	162	240	ADB17639.1 Alpha/beta hydrolase fold-3 domain protein [Pirellula staleyi DSM 6068]	diamond	1011	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
27680068	27680068	PRJNA572587_P_NODE_11704_length_342_cov_75.675768_g11376_i0	PRJNA572587	11704	342	75.675768	258.81112656	Planctomycetota bacterium	2026780	Bacteria	Bacteria	74.7	1.49e-14	NR	MEK7992869.1	2026780	g11376	i0	53.2	0.675438596491228	77	36	67.5	0	319	89	27	103	MEK7992869.1 hypothetical protein [Planctomycetota bacterium]	diamond	231	74.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28595582	28595582	PRJNA572587_P_NODE_9407_length_390_cov_8.645161_g9080_i0	PRJNA572587	9407	390	8.645161	33.7161279	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	64.3	4.88e-9	NR	MDB5324827.1	2052180	g9080	i0	42.2	0.638461538461538	83	44	60.8	1	136	372	90	172	MDB5324827.1 hypothetical protein [Phycisphaerales bacterium]	diamond	249	64.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29006276	29006276	PRJNA572587_P_NODE_31148_length_199_cov_2.946667_g30820_i0	PRJNA572587	31148	199	2.946667	5.86386733	Planctomycetota bacterium	2026780	Bacteria	Bacteria	47.8	2.77e-4	NR	MFM1872725.1	2026780	g30820	i0	88	1.76381909547739	25	3	37.7	0	116	42	204	228	MFM1872725.1 transporter ATP-binding protein YtrE [Planctomycetota bacterium]	diamond	351	47.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29447690	29447690	PRJNA572587_P_NODE_8090_length_426_cov_15.366048_g7765_i0	PRJNA572587	8090	426	15.366048	65.45936448	Paludisphaera sp.	2017432	Bacteria	Bacteria	107	1.29e-25	NR	WP_337174015.1	2017432	g7765	i0	64.8	0.619718309859155	88	29	61.3	2	54	314	167	253	WP_337174015.1 amidohydrolase family protein [Paludisphaera sp.]	diamond	264	107	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera sp.
29731831	29731831	PRJNA572587_P_NODE_31890_length_196_cov_14.619048_g31562_i0	PRJNA572587	31890	196	14.619048	28.65333408	Pirellulales bacterium	2715253	Bacteria	Bacteria	70.9	1.81e-12	NR	HUS39610.1	2715253	g31562	i0	73.3	1.36224489795918	45	12	68.9	0	12	146	292	336	HUS39610.1 hypothetical protein [Pirellulales bacterium]	diamond	267	70.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
30521814	30521814	PRJNA572587_P_NODE_26273_length_218_cov_14.289941_g25945_i0	PRJNA572587	26273	218	14.289941	31.15207138	Gemmataceae bacterium	2052164	Bacteria	Bacteria	111	3.7400000000000006e-27	NR	MFL5327886.1	2052164	g25945	i0	75.4	0.894495412844037	65	16	89.4	0	14	208	22	86	MFL5327886.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Gemmataceae bacterium]	diamond	195	111	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31059292	31059292	PRJNA572587_P_NODE_3295_length_722_cov_12.817236_g3027_i0	PRJNA572587	3295	722	12.817236	92.54044392	Planctomycetia bacterium	2052181	Bacteria	Bacteria	69.7	1.5e-9	NR	MCX7424011.1	2052181	g3027	i0	52.9	0.282548476454294	68	30	27.4	1	702	505	746	813	MCX7424011.1 cadherin domain-containing protein [Planctomycetia bacterium]	diamond	204	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
31090556	31090556	PRJNA572587_P_NODE_19975_length_253_cov_72.196078_g19647_i0	PRJNA572587	19975	253	72.196078	182.65607734	Planctomycetes bacterium RIFOXYC2_FULL_41_27	1801986	Bacteria	Bacteria	81.3	3.42e-16	NR	OHC06474.1	1801986	g19647	i0	84	1.25691699604743	50	8	59.3	0	97	246	2	51	OHC06474.1 MAG: hypothetical protein A3J92_04500 [Planctomycetes bacterium RIFOXYC2_FULL_41_27]	diamond	318	81.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium RIFOXYC2_FULL_41_27
31185074	31185074	PRJNA572587_P_NODE_36595_length_182_cov_2.330827_g36267_i0	PRJNA572587	36595	182	2.330827	4.24210514	Gemmataceae bacterium	2052164	Bacteria	Bacteria	62	2.23e-9	NR	MFL5244936.1	2052164	g36267	i0	65.1	2.42307692307692	43	15	70.9	0	45	173	27	69	MFL5244936.1 hypothetical protein [Gemmataceae bacterium]	diamond	441	62	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32559517	32559517	PRJNA572587_P_NODE_12939_length_323_cov_26.175182_g12611_i0	PRJNA572587	12939	323	26.175182	84.54583786	root	1	Root_unresolved	Root_unresolved	81.3	2.81e-15	NR	NHZ86096.1	2052181	g12611	i0	55.1	1.42105263157895	69	31	64.1	0	82	288	285	353	NHZ86096.1 hypothetical protein [Planctomycetia bacterium]	diamond	459	81.6	0.996323529411765	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia 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);;