metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA495917" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA495917" and tax_clade = "PVC group"

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
1752475	1752475	PRJNA495917_S_NODE_1762_length_362_cov_6.507645_g1568_i0	PRJNA495917	1762	362	6.507645	23.5576749	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	377	4.99e-100	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g1568	i0	91.912	143.185082872928	272	19	77	3	2	272	1155850	1156119	Planctomyces sp. SH-PL62, complete genome	blastn	51833	377	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
3028428	3028428	PRJNA495917_S_NODE_15443_length_153_cov_4.161017_g15249_i0	PRJNA495917	15443	153	4.161017	6.36635601	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	156	9.29e-34	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g15249	i0	87.143	135.993464052288	140	15	91	3	15	153	3454131	3453994	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	20807	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
3028473	3028473	PRJNA495917_S_NODE_4083_length_245_cov_2.828571_g3889_i0	PRJNA495917	4083	245	2.828571	6.92999895	Pedosphaera parvula	1032527	Bacteria	Bacteria	307	4.2700000000000006e-79	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g3889	i0	90	98.4040816326531	240	20	97	4	6	242	961	1199	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	24109	307	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
4304388	4304388	PRJNA495917_S_NODE_2064_length_339_cov_6.365132_g1870_i0	PRJNA495917	2064	339	6.365132	21.57779748	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	483	9.579999999999998e-132	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g1870	i0	92.375	170.185840707965	341	22	100	4	1	339	1156438	1156776	Planctomyces sp. SH-PL62, complete genome	blastn	57693	483	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
5581037	5581037	PRJNA495917_S_NODE_1425_length_397_cov_9.453039_g1231_i0	PRJNA495917	1425	397	9.453039	37.52856483	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	401	3.279999999999999e-107	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g1231	i0	85.567	152.2040302267	388	51	96	5	1	383	2002940	2002553	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	60425	401	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
5581186	5581186	PRJNA495917_S_NODE_9965_length_175_cov_1.307143_g9771_i0	PRJNA495917	9965	175	1.307143	2.28750025	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	204	3.85e-48	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g9771	i0	89.024	6.2	164	18	94	0	1	164	2191716	2191553	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	1085	204	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
6855141	6855141	PRJNA495917_S_NODE_2546_length_306_cov_133.029520_g2352_i0	PRJNA495917	2546	306	133.02952	407.0703312	Luteolibacter sp.	1962973	Bacteria	Bacteria	462	1.11e-125	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g2352	i0	94.631	265.513071895425	298	16	97	0	1	298	1009079	1008782	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	81247	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
7485977	7485977	PRJNA495917_S_NODE_2406_length_314_cov_7.483871_g2212_i0	PRJNA495917	2406	314	7.483871	23.49935494	Frigoriglobus	2774146	Bacteria	Bacteria	342	1.5599999999999997e-89	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g2212	i0	86.581	163.93949044586	313	39	99	2	2	314	3457525	3457216	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	51477	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
9405478	9405478	PRJNA495917_S_NODE_4208_length_242_cov_2.024155_g4014_i0	PRJNA495917	4208	242	2.024155	4.8984551	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	250	7.2e-62	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g4014	i0	88.372	210.743801652893	215	16	89	3	26	240	2190748	2190543	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	51000	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
9405490	9405490	PRJNA495917_S_NODE_5088_length_223_cov_21.409574_g4894_i0	PRJNA495917	5088	223	21.409574	47.74335002	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	396	7.939999999999995e-106	NTclustered	gi\|633869078\|gb\|KJ127967.1\|	100233	g4894	i0	98.655	118.502242152466	223	3	100	0	1	223	714	936	Uncultured Planctomycetaceae bacterium clone NJFU_SLX-S92 16S ribosomal RNA gene, partial sequence	blastn	26426	396	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
10681161	10681161	PRJNA495917_S_NODE_2529_length_307_cov_183.069853_g2335_i0	PRJNA495917	2529	307	183.069853	562.02444871	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	455	1.87e-123	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g2335	i0	93.485	170.882736156352	307	18	100	1	1	307	4319585	4319889	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	52461	455	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
10681166	10681166	PRJNA495917_S_NODE_3069_length_280_cov_2.685714_g2875_i0	PRJNA495917	3069	280	2.685714	7.5199992	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	241	5.130000000000001e-59	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g2875	i0	82.784	150.735714285714	273	44	97	3	1	272	1317348	1317078	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	42206	241	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13231381	13231381	PRJNA495917_S_NODE_4111_length_244_cov_3.684211_g3917_i0	PRJNA495917	4111	244	3.684211	8.98947484	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	399	6.819999999999998e-107	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g3917	i0	96.311	364.401639344262	244	7	100	2	1	244	3411668	3411427	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	88914	399	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
13861499	13861499	PRJNA495917_S_NODE_13751_length_158_cov_3.747967_g13557_i0	PRJNA495917	13751	158	3.747967	5.92178786	Verrucomicrobiales	48461	Bacteria	Bacteria	231	1.5599999999999998e-56	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g13557	i0	93.038	71.4240506329114	158	11	100	0	1	158	3411389	3411232	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	11285	231	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
14506265	14506265	PRJNA495917_S_NODE_5572_length_215_cov_2.638889_g5378_i0	PRJNA495917	5572	215	2.638889	5.67361135	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	130	8.51e-26	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g5378	i0	78.341	275.139534883721	217	35	97	11	1	209	7050415	7050627	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	59155	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14506305	14506305	PRJNA495917_S_NODE_9052_length_180_cov_2.813793_g8858_i0	PRJNA495917	9052	180	2.813793	5.0648274	Luteolibacter sp.	1962973	Bacteria	Bacteria	243	8.439999999999999e-60	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g8858	i0	92.398	16.8055555555556	171	12	95	1	10	180	1010378	1010209	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	3025	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
15780144	15780144	PRJNA495917_S_NODE_2893_length_288_cov_5.241107_g2699_i0	PRJNA495917	2893	288	5.241107	15.09438816	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	220	6.8999999999999985e-53	NTclustered	gi\|2916415364\|gb\|CP170459.1\|	2026799	g2699	i0	89.266	18.4097222222222	177	18	61	1	78	254	2577506	2577331	MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome	blastn	5302	220	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
17054816	17054816	PRJNA495917_S_NODE_14734_length_155_cov_6.700000_g14540_i0	PRJNA495917	14734	155	6.7	10.385	Paludisphaera borealis	1387353	Bacteria	Bacteria	193	7.2e-45	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g14540	i0	89.103	13.5806451612903	156	16	100	1	1	155	123424	123579	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	2105	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
17054932	17054932	PRJNA495917_S_NODE_8474_length_184_cov_3.993289_g8280_i0	PRJNA495917	8474	184	3.993289	7.34765176	Planctomycetales bacterium ZRK34	2723666	Bacteria	Bacteria	169	1.4899999999999998e-37	NTclustered	gi\|1898316769\|gb\|CP050848.1\|	2723666	g8280	i0	94.495	81.9619565217391	109	6	59	0	76	184	593141	593249	Planctomycetales bacterium ZRK34 chromosome, complete genome	blastn	15081	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium ZRK34
17054945	17054945	PRJNA495917_S_NODE_954_length_484_cov_5.118040_g764_i0	PRJNA495917	954	484	5.11804	24.7713136	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	372	3.19e-98	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g764	i0	82.759	196.431818181818	435	58	87	15	1	423	3990449	3990020	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	95073	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
18329036	18329036	PRJNA495917_S_NODE_10435_length_172_cov_3.656934_g10241_i0	PRJNA495917	10435	172	3.656934	6.28992648	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	265	1.7e-66	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g10241	i0	94.706	226.866279069767	170	9	99	0	3	172	1522	1353	Luteolibacter sp. SL250 chromosome	blastn	39021	265	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
18329180	18329180	PRJNA495917_S_NODE_6595_length_201_cov_4.433735_g6401_i0	PRJNA495917	6595	201	4.433735	8.91180735	Luteolibacter sp.	1962973	Bacteria	Bacteria	294	2.63e-75	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g6401	i0	93.035	93.8407960199005	201	14	100	0	1	201	1010042	1010242	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	18862	294	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
18329183	18329183	PRJNA495917_S_NODE_695_length_553_cov_3.617761_g521_i0	PRJNA495917	695	553	3.617761	20.00621833	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	754	0	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g521	i0	91.351	168.26582278481	555	43	100	5	1	553	4317532	4318083	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	93051	754	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
19603481	19603481	PRJNA495917_S_NODE_556_length_612_cov_7.798960_g395_i0	PRJNA495917	556	612	7.79896	47.7296352	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	765	0	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g395	i0	89.577	463.205882352941	614	49	99	11	3	606	5936167	5936775	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	283482	765	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
20234329	20234329	PRJNA495917_S_NODE_3956_length_248_cov_302.023474_g3762_i0	PRJNA495917	3956	248	302.023474	749.01821552	Fontisphaera	3050007	Bacteria	Bacteria	342	1.1899999999999999e-89	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g3762	i0	91.633	115.201612903226	251	15	100	5	1	248	1316814	1317061	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	28570	342	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20234348	20234348	PRJNA495917_S_NODE_5896_length_210_cov_11.028571_g5702_i0	PRJNA495917	5896	210	11.028571	23.1599991	Isosphaeraceae	1763524	Bacteria	Bacteria	355	1.25e-93	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g5702	i0	97.143	180.771428571429	210	6	100	0	1	210	5180611	5180402	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	37962	355	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
20879257	20879257	PRJNA495917_S_NODE_11557_length_167_cov_1.310606_g11363_i0	PRJNA495917	11557	167	1.310606	2.18871202	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	174	2.87e-39	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g11363	i0	85.799	7.05988023952096	169	19	99	5	1	165	2190974	2191141	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	1179	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
22784958	22784958	PRJNA495917_S_NODE_118_length_1150_cov_11.729148_g65_i0	PRJNA495917	118	1150	11.729148	134.885202	Bacteria	2	Bacteria	Bacteria	1234	0	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g65	i0	86.239	316.315652173913	1170	123	99	29	7	1150	3453709	3454866	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	363763	1234	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
23429857	23429857	PRJNA495917_S_NODE_13279_length_160_cov_1.560000_g13085_i0	PRJNA495917	13279	160	1.56	2.496	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	63.9	6.13e-6	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g13085	i0	95.122	0.25625	41	1	25	1	41	80	915874	915834	Lacunisphaera limnophila strain IG16b, complete genome	blastn	41	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
24059750	24059750	PRJNA495917_S_NODE_1339_length_408_cov_6.367292_g1145_i0	PRJNA495917	1339	408	6.367292	25.97855136	Singulisphaera	466152	Bacteria	Bacteria	455	2.56e-123	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g1145	i0	87.317	93.1470588235294	410	37	99	11	1	406	162	560	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	38004	455	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
24703566	24703566	PRJNA495917_S_NODE_860_length_504_cov_22.899787_g674_i0	PRJNA495917	860	504	22.899787	115.41492648	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	540	8.63e-149	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g674	i0	86.106	175.242063492063	511	60	100	11	1	504	2003174	2002668	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	88322	540	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured 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);;