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

31 rows where analysis = "blastn", bioproject = "PRJNA1095825" 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
200228	200228	PRJNA1095825_P_NODE_197761_length_278_cov_1.478049_g194698_i0	PRJNA1095825	197761	278	1.478049	4.10897622	Rhodopirellula baltica	265606	Bacteria	Bacteria	63.9	1.18e-5	NTclustered	gi\|32445988\|emb\|BX294148.1\|	243090	g194698	i0	95	0.262589928057554	40	2	14	0	23	62	151993	152032	Rhodopirellula baltica SH 1 complete genome; segment 16/24	blastn	73	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula baltica
200571	200571	PRJNA1095825_P_NODE_234561_length_252_cov_1.256983_g231498_i0	PRJNA1095825	234561	252	1.256983	3.16759716	Gemmataceae bacterium	2052164	Bacteria	Bacteria	84.2	8.1e-12	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g231498	i0	81.481	2.19047619047619	108	15	42	5	130	236	6862032	6861929	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	552	84.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
1475797	1475797	PRJNA1095825_P_NODE_292422_length_241_cov_1.833333_g289359_i0	PRJNA1095825	292422	241	1.833333	4.41833253	Congregicoccus parvus	3081749	Bacteria	Bacteria	128	3.4999999999999997e-25	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g289359	i0	91.398	1.3195020746888	93	8	40	0	149	241	3551252	3551344	Opitutales bacterium ASA1 DNA, complete genome	blastn	318	128	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
2751720	2751720	PRJNA1095825_P_NODE_276723_length_244_cov_0.900585_g273660_i0	PRJNA1095825	276723	244	0.900585	2.1974274	Horticoccus luteus	2862869	Bacteria	Bacteria	300	7.12e-77	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g273660	i0	89.451	25.0286885245902	237	25	97	0	2	238	3627573	3627809	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	6107	300	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
2751911	2751911	PRJNA1095825_P_NODE_297883_length_241_cov_0.910714_g294820_i0	PRJNA1095825	297883	241	0.910714	2.19482074	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	329	8.95e-86	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g294820	i0	91.286	98.7551867219917	241	21	100	0	1	241	1831839	1832079	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	23800	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
3569944	3569944	PRJNA1095825_P_NODE_183643_length_288_cov_1.432558_g180580_i0	PRJNA1095825	183643	288	1.432558	4.12576704	Gemmata	113	Bacteria	Bacteria	104	7.25e-18	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g180580	i0	89.286	2.16319444444444	84	8	29	1	205	287	3994286	3994203	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	623	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
4027091	4027091	PRJNA1095825_P_NODE_218324_length_263_cov_1.621053_g215261_i0	PRJNA1095825	218324	263	1.621053	4.26336939	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	418	2.0499999999999995e-112	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g215261	i0	95.437	207.3536121673	263	10	100	2	1	263	16910	17170	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	54534	418	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
4027398	4027398	PRJNA1095825_P_NODE_250764_length_249_cov_0.875000_g247701_i0	PRJNA1095825	250764	249	0.875	2.17875	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	244	3.46e-60	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g247701	i0	84.615	4.94779116465863	247	36	99	2	1	246	844292	844537	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	1232	244	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
4847630	4847630	PRJNA1095825_P_NODE_267924_length_246_cov_0.890173_g264861_i0	PRJNA1095825	267924	246	0.890173	2.18982558	Planctomycetia	203683	Bacteria	Bacteria	209	1.25e-49	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g264861	i0	83.945	10.1016260162602	218	35	89	0	27	244	5027051	5027268	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	2485	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
7853502	7853502	PRJNA1095825_P_NODE_254767_length_248_cov_0.880000_g251704_i0	PRJNA1095825	254767	248	0.88	2.1824	Gemmata sp. 28IL	1278135	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|443298398\|gb\|KC169940.1\|	1278135	g251704	i0	100	99.1895161290323	248	0	100	0	1	248	519	766	Gemmata sp. 28IL 16S ribosomal RNA gene, partial sequence	blastn	24599	459	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. 28IL
9127917	9127917	PRJNA1095825_P_NODE_195948_length_279_cov_1.776699_g192885_i0	PRJNA1095825	195948	279	1.776699	4.95699021	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	165	3.16e-36	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g192885	i0	86.275	7.8673835125448	153	19	54	2	1	152	406119	405968	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	2195	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
10404481	10404481	PRJNA1095825_P_NODE_290549_length_242_cov_0.911243_g287486_i0	PRJNA1095825	290549	242	0.911243	2.20520806	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	167	7.46e-37	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g287486	i0	82.234	1.69834710743802	197	31	81	4	27	221	1999724	1999530	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	411	167	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
12953695	12953695	PRJNA1095825_P_NODE_157811_length_310_cov_1.856540_g154748_i0	PRJNA1095825	157811	310	1.85654	5.755274	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	385	2.51e-102	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g154748	i0	89.474	5.50322580645161	304	32	98	0	1	304	3216188	3216491	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1706	385	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
12954727	12954727	PRJNA1095825_P_NODE_268571_length_246_cov_0.890173_g265508_i0	PRJNA1095825	268571	246	0.890173	2.18982558	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	196	9.7e-46	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g265508	i0	82.278	5.85772357723577	237	33	95	6	9	241	8180248	8180479	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1441	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14229720	14229720	PRJNA1095825_P_NODE_275152_length_244_cov_1.795322_g272089_i0	PRJNA1095825	275152	244	1.795322	4.38058568	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	322	1.52e-83	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g272089	i0	90.612	212.881147540984	245	19	100	3	1	244	7051061	7050820	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	51943	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14229942	14229942	PRJNA1095825_P_NODE_295372_length_241_cov_0.916667_g292309_i0	PRJNA1095825	295372	241	0.916667	2.20916747	Lignipirellula cremea	2528010	Bacteria	Bacteria	167	7.429999999999999e-37	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g292309	i0	79.424	1.85892116182573	243	44	99	3	2	241	2770415	2770654	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	448	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea
15047368	15047368	PRJNA1095825_P_NODE_90612_length_399_cov_0.886503_g87549_i0	PRJNA1095825	90612	399	0.886503	3.53714697	Candidatus Protochlamydia	282132	Bacteria	Bacteria	649	0	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g87549	i0	95.99	118.68671679198	399	16	100	0	1	399	1249454	1249056	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	47356	649	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
15502962	15502962	PRJNA1095825_P_NODE_200473_length_276_cov_1.517241_g197410_i0	PRJNA1095825	200473	276	1.517241	4.18758516	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g197410	i0	94.444	0.130434782608696	36	2	13	0	2	37	3393313	3393348	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	36	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
15503772	15503772	PRJNA1095825_P_NODE_285313_length_243_cov_0.905882_g282250_i0	PRJNA1095825	285313	243	0.905882	2.20129326	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	274	4.29e-69	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g282250	i0	86.939	7.81893004115226	245	30	100	2	1	243	8814558	8814802	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1900	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
16321955	16321955	PRJNA1095825_P_NODE_242673_length_250_cov_0.870056_g239610_i0	PRJNA1095825	242673	250	0.870056	2.17514	Botrimarina	2795782	Bacteria	Bacteria	209	1.27e-49	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g239610	i0	81.855	1.984	248	45	99	0	3	250	972906	973153	Planctomycetes bacterium K2D chromosome, complete genome	blastn	496	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
18052518	18052518	PRJNA1095825_P_NODE_260035_length_247_cov_0.885057_g256972_i0	PRJNA1095825	260035	247	0.885057	2.18609079	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	159	1.28e-34	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g256972	i0	87.77	2.75708502024291	139	13	55	3	110	244	568157	568019	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	681	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
19326487	19326487	PRJNA1095825_P_NODE_244976_length_250_cov_0.870056_g241913_i0	PRJNA1095825	244976	250	0.870056	2.17514	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	150	7.799999999999999e-32	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g241913	i0	90.351	1.948	114	11	46	0	132	245	3215874	3215987	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	487	150	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
20145907	20145907	PRJNA1095825_P_NODE_253736_length_248_cov_0.880000_g250673_i0	PRJNA1095825	253736	248	0.88	2.1824	Planctomycetia	203683	Bacteria	Bacteria	152	2.15e-32	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g250673	i0	85.333	25.2096774193548	150	18	60	4	101	248	3899640	3899787	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	6252	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
20601907	20601907	PRJNA1095825_P_NODE_252357_length_248_cov_1.582857_g249294_i0	PRJNA1095825	252357	248	1.582857	3.92548536	Tuwongella immobilis	692036	Bacteria	Bacteria	135	2.17e-27	NTclustered	gi\|1804913728\|emb\|LR593887.1\|	692036	g249294	i0	87.288	4.18145161290323	118	15	48	0	130	247	246476	246593	Tuwongella immobilis isolate MBLW1 genome assembly, chromosome: 1	blastn	1037	135	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Tuwongella	Tuwongella immobilis
20602287	20602287	PRJNA1095825_P_NODE_290297_length_242_cov_0.911243_g287234_i0	PRJNA1095825	290297	242	0.911243	2.20520806	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	250	7.2e-62	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g287234	i0	85.477	7.37603305785124	241	33	99	2	1	240	4658605	4658366	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	1785	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
20602296	20602296	PRJNA1095825_P_NODE_290977_length_242_cov_0.911243_g287914_i0	PRJNA1095825	290977	242	0.911243	2.20520806	Fontisphaera persica	2974023	Bacteria	Bacteria	381	2.449999999999999e-101	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g287914	i0	95.041	114.061983471074	242	12	100	0	1	242	3863201	3862960	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	27603	381	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
20602358	20602358	PRJNA1095825_P_NODE_296997_length_241_cov_0.916667_g293934_i0	PRJNA1095825	296997	241	0.916667	2.20916747	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	244	3.33e-60	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g293934	i0	85.232	70.0207468879668	237	35	98	0	1	237	1766674	1766910	Luteolibacter sp. LG18 DNA, complete genome	blastn	16875	244	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
23152521	23152521	PRJNA1095825_P_NODE_194779_length_280_cov_1.487923_g191716_i0	PRJNA1095825	194779	280	1.487923	4.1661844	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	121	6.969999999999999e-23	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g191716	i0	79.532	2.84285714285714	171	33	61	2	8	177	800764	800933	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	796	121	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
23153181	23153181	PRJNA1095825_P_NODE_268599_length_246_cov_0.890173_g265536_i0	PRJNA1095825	268599	246	0.890173	2.18982558	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	296	9.3e-76	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g265536	i0	88.843	38.2073170731707	242	25	98	2	6	246	1737945	1738185	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	9399	296	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24426308	24426308	PRJNA1095825_P_NODE_213380_length_267_cov_1.216495_g210317_i0	PRJNA1095825	213380	267	1.216495	3.24804165	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	219	2.2799999999999993e-52	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g210317	i0	83.691	0.872659176029963	233	36	87	2	1	232	3867367	3867136	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	233	219	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
25245873	25245873	PRJNA1095825_P_NODE_255720_length_248_cov_0.880000_g252657_i0	PRJNA1095825	255720	248	0.88	2.1824	Gemmata	113	Bacteria	Bacteria	171	5.94e-38	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g252657	i0	81.429	6.02822580645161	210	37	84	2	3	211	5328607	5328815	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	1495	171	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus

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