metadata: contig_metadata: 26 rows where bioproject = "PRJNA527965", tax_clade = "PVC group" and tax

26 rows where bioproject = "PRJNA527965", 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
1772021	1772021	PRJNA527965_S_NODE_2062_length_271_cov_4.826271_g1979_i0	PRJNA527965	2062	271	4.826271	13.07919441	Symmachiella dynata	2527995	Bacteria	Bacteria	379	1e-100	NTclustered	gi\|1712609668\|gb\|CP036276.1\|	2527995	g1979	i0	93.05	123.332103321033	259	18	96	0	10	268	1042810	1043068	Symmachiella dynata strain Mal52 chromosome, complete genome	blastn	33423	379	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Symmachiella	Symmachiella dynata
1772046	1772046	PRJNA527965_S_NODE_3122_length_215_cov_3.366667_g3039_i0	PRJNA527965	3122	215	3.366667	7.23833405	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	327	2.81e-85	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g3039	i0	94.366	135.251162790698	213	12	99	0	3	215	7052054	7051842	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	29079	327	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
1772091	1772091	PRJNA527965_S_NODE_5042_length_167_cov_1.234848_g4959_i0	PRJNA527965	5042	167	1.234848	2.06219616	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	195	2.2e-45	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g4959	i0	90.066	176.550898203593	151	13	90	2	7	156	3097494	3097643	Pirellula sp. SH-Sr6A, complete genome	blastn	29484	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
5600706	5600706	PRJNA527965_S_NODE_285_length_587_cov_10.193841_g211_i0	PRJNA527965	285	587	10.193841	59.83784667	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	575	2.779999999999999e-159	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g211	i0	91.647	424.265758091993	419	30	71	4	172	587	3096588	3097004	Pirellula sp. SH-Sr6A, complete genome	blastn	249044	575	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
6874532	6874532	PRJNA527965_S_NODE_2966_length_221_cov_30.806452_g2883_i0	PRJNA527965	2966	221	30.806452	68.08225892	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	370	4.76e-98	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g2883	i0	96.833	288.072398190045	221	7	100	0	1	221	1868502	1868282	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	63664	370	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
6874604	6874604	PRJNA527965_S_NODE_866_length_387_cov_2.627841_g783_i0	PRJNA527965	866	387	2.627841	10.16974467	planctomycete str. 449	79870	Bacteria	Bacteria	520	8.43e-143	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g783	i0	91.821	140.695090439276	379	22	97	8	13	387	1418	1045	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	54449	520	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
7492409	7492409	PRJNA527965_S_NODE_5646_length_157_cov_8.819672_g5563_i0	PRJNA527965	5646	157	8.819672	13.84688504	Schlesneria	656899	Bacteria	Bacteria	207	2.61e-49	NTclustered	gi\|2806767875\|gb\|CP124747.2\|	3044399	g5563	i0	90.506	115.624203821656	158	14	100	1	1	157	6999324	6999167	Schlesneria sp. DSM 10557 chromosome, complete genome	blastn	18153	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria sp. DSM 10557
8149875	8149875	PRJNA527965_S_NODE_3507_length_203_cov_3.380952_g3424_i0	PRJNA527965	3507	203	3.380952	6.86333256	Limnoglobus roseus	2598579	Bacteria	Bacteria	309	9.51e-80	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g3424	i0	94.118	156.088669950739	204	11	100	1	1	203	2956915	2957118	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	31686	309	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
8767312	8767312	PRJNA527965_S_NODE_4307_length_182_cov_2.435374_g4224_i0	PRJNA527965	4307	182	2.435374	4.43238068	Planctomycetia	203683	Bacteria	Bacteria	196	6.76e-46	NTclustered	gi\|1712609668\|gb\|CP036276.1\|	2527995	g4224	i0	91.034	82.5549450549451	145	13	80	0	3	147	1042307	1042163	Symmachiella dynata strain Mal52 chromosome, complete genome	blastn	15025	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Symmachiella	Symmachiella dynata
9425075	9425075	PRJNA527965_S_NODE_148_length_750_cov_16.317483_g98_i0	PRJNA527965	148	750	16.317483	122.3811225	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	915	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g98	i0	88.727	149.677333333333	754	78	99	7	1	749	1867999	1867248	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	112258	915	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
9425106	9425106	PRJNA527965_S_NODE_28_length_1359_cov_14.352719_g16_i0	PRJNA527965	28	1359	14.352719	195.05345121	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	1509	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g16	i0	87.738	596.922737306843	1313	136	96	19	17	1319	1867481	1866184	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	811218	1509	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
10042861	10042861	PRJNA527965_S_NODE_5448_length_160_cov_4.136000_g5365_i0	PRJNA527965	5448	160	4.136	6.6176	Schlesneria	656899	Bacteria	Bacteria	178	2.1e-40	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g5365	i0	87.342	27.64375	158	17	98	3	3	158	480	324	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	4423	178	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
10700923	10700923	PRJNA527965_S_NODE_889_length_383_cov_21.307471_g806_i0	PRJNA527965	889	383	21.307471	81.60761393	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	569	8.16e-158	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g806	i0	93.473	125.250652741514	383	25	100	0	1	383	1868323	1867941	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	47971	569	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
11975615	11975615	PRJNA527965_S_NODE_2130_length_265_cov_4.339130_g2047_i0	PRJNA527965	2130	265	4.33913	11.4986945	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	274	4.749999999999998e-69	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g2047	i0	86.154	304.233962264151	260	28	98	4	1	259	4956397	4956649	Planctomyces sp. SH-PL14, complete genome	blastn	80622	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
13250713	13250713	PRJNA527965_S_NODE_2291_length_255_cov_1.659091_g2208_i0	PRJNA527965	2291	255	1.659091	4.23068205	Bremerella volcania	2527984	Bacteria	Bacteria	187	6.089999999999998e-43	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g2208	i0	82.71	450.878431372549	214	34	83	3	2	213	2674437	2674649	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	114974	187	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
13250765	13250765	PRJNA527965_S_NODE_4651_length_174_cov_1.676259_g4568_i0	PRJNA527965	4651	174	1.676259	2.91669066	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	316	4.7e-82	NTclustered	gi\|1710291850\|gb\|MN235841.1\|	120965	g4568	i0	99.425	96.9022988505747	174	1	100	0	1	174	74	247	Uncultured Planctomycetota bacterium clone oligPB-51 16S ribosomal RNA gene, partial sequence	blastn	16861	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
13250785	13250785	PRJNA527965_S_NODE_5951_length_153_cov_3.855932_g5868_i0	PRJNA527965	5951	153	3.855932	5.89957596	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	231	1.4999999999999997e-56	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g5868	i0	97.08	108.483660130719	137	4	90	0	17	153	7051648	7051512	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	16598	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14525740	14525740	PRJNA527965_S_NODE_2232_length_259_cov_1.799107_g2149_i0	PRJNA527965	2232	259	1.799107	4.65968713	planctomycete str. 449	79870	Bacteria	Bacteria	418	2.0199999999999998e-112	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g2149	i0	95.753	303.397683397683	259	11	100	0	1	259	435	693	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	78580	418	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
17074233	17074233	PRJNA527965_S_NODE_6254_length_150_cov_2.617391_g6171_i0	PRJNA527965	6254	150	2.617391	3.9260865	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	200	4.119999999999999e-47	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g6171	i0	90.728	351.786666666667	151	12	100	2	1	150	557911	557762	Gemmata sp. SH-PL17, complete genome	blastn	52768	200	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
19622864	19622864	PRJNA527965_S_NODE_1776_length_292_cov_8.241245_g1693_i0	PRJNA527965	1776	292	8.241245	24.0644354	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	442	1.3699999999999994e-119	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g1693	i0	93.898	297.397260273973	295	15	100	3	1	292	2003170	2003464	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	86840	442	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
19622869	19622869	PRJNA527965_S_NODE_1996_length_276_cov_88.551867_g1913_i0	PRJNA527965	1996	276	88.551867	244.40315292	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	381	2.849999999999999e-101	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g1913	i0	91.636	202.300724637681	275	23	99	0	2	276	2192764	2192490	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	55835	381	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
19622962	19622962	PRJNA527965_S_NODE_6096_length_152_cov_1.299145_g6013_i0	PRJNA527965	6096	152	1.299145	1.9747004	Polystyrenella longa	2528007	Bacteria	Bacteria	172	9.14e-39	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g6013	i0	87.417	55.125	151	18	99	1	1	150	1418166	1418316	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	8379	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
20899037	20899037	PRJNA527965_S_NODE_5057_length_166_cov_7.122137_g4974_i0	PRJNA527965	5057	166	7.122137	11.82274742	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	211	2.17e-50	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g4974	i0	89.697	125.861445783133	165	17	99	0	1	165	1868941	1868777	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	20893	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
22173713	22173713	PRJNA527965_S_NODE_6218_length_150_cov_1307.695652_g6135_i0	PRJNA527965	6218	150	1307.695652	1961.543478	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	239	8.74e-59	NTclustered	gi\|1938775668\|gb\|CP054178.1\|	2026777	g6135	i0	95.333	225.993333333333	150	7	100	0	1	150	192396	192247	MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome	blastn	33899	239	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
23449322	23449322	PRJNA527965_S_NODE_939_length_376_cov_3.451613_g856_i0	PRJNA527965	939	376	3.451613	12.97806488	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	490	6.399999999999998e-134	NTclustered	gi\|162289087\|gb\|EU300514.1\|	120965	g856	i0	94.375	84.4601063829787	320	16	85	2	59	376	186	505	Uncultured planctomycete clone GASP-KC3W2_F04 16S ribosomal RNA gene, partial sequence	blastn	31757	490	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
24722931	24722931	PRJNA527965_S_NODE_3920_length_192_cov_1.866242_g3837_i0	PRJNA527965	3920	192	1.866242	3.58318464	Stratiformator vulcanicus	2527980	Bacteria	Bacteria	255	1.17e-63	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g3837	i0	91.444	320.911458333333	187	14	97	2	5	190	3080736	3080921	Stratiformator vulcanicus strain Pan189 chromosome	blastn	61615	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus

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