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

27 rows where bioproject = "PRJEB4632", tax_clade = "PVC group" and tax_kingdom = "Pseudomonadati"

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
61613	61613	PRJEB4632_P_NODE_121_length_762_cov_5.586357_g85_i0	PRJEB4632	121	762	5.586357	42.56804034	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	1264	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g85	i0	96.588	284.866141732283	762	26	100	0	1	762	4716428	4717189	Luteolibacter sp. SL250 chromosome	blastn	217068	1264	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
2265288	2265288	PRJEB4632_P_NODE_862_length_246_cov_7.005780_g824_i0	PRJEB4632	862	246	7.00578	17.2342188	Prosthecobacter	48463	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|219846430\|ref\|NR_026021.1\|	48465	g824	i0	100	99.8861788617886	246	0	100	0	1	246	1434	1189	Prosthecobacter dejongeii strain FC1 16S ribosomal RNA, partial sequence	blastn	24572	455	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
2611501	2611501	PRJEB4632_P_NODE_463_length_323_cov_1.328000_g425_i0	PRJEB4632	463	323	1.328	4.28944	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	348	3.4500000000000003e-91	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g425	i0	86.28	81.8297213622291	328	36	100	7	1	323	1316321	1315998	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	26431	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
3540575	3540575	PRJEB4632_P_NODE_1023_length_231_cov_2.278481_g985_i0	PRJEB4632	1023	231	2.278481	5.26329111	Opitutus	178440	Bacteria	Bacteria	307	3.99e-79	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g985	i0	92.558	29.1904761904762	215	14	93	2	18	231	1493	1280	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	6743	307	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
3887682	3887682	PRJEB4632_P_NODE_44_length_1400_cov_4.911078_g27_i0	PRJEB4632	44	1400	4.911078	68.755092	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	2508	0	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g27	i0	99	249.266428571429	1400	14	100	0	1	1400	191	1590	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	348973	2508	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
6439700	6439700	PRJEB4632_P_NODE_466_length_322_cov_6.144578_g428_i0	PRJEB4632	466	322	6.144578	19.78554116	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	446	1.1899999999999999e-120	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g428	i0	91.9	59.9627329192547	321	23	99	3	1	319	508	189	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	19308	446	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
7713969	7713969	PRJEB4632_P_NODE_887_length_245_cov_1.668605_g849_i0	PRJEB4632	887	245	1.668605	4.08808225	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	364	2.5e-96	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g849	i0	93.469	178.70612244898	245	16	100	0	1	245	3831025	3830781	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	43783	364	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9918223	9918223	PRJEB4632_P_NODE_608_length_283_cov_1.733333_g570_i0	PRJEB4632	608	283	1.733333	4.90533239	Schlesneria	656899	Bacteria	Bacteria	403	6.26e-108	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g570	i0	92.308	148.946996466431	286	18	100	4	1	283	1780	1496	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	42152	403	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
10264400	10264400	PRJEB4632_P_NODE_529_length_306_cov_2.309013_g491_i0	PRJEB4632	529	306	2.309013	7.06557978	uncultured Terrimicrobium sp.	1758082	Bacteria	Bacteria	544	3.86e-150	NTclustered	gi\|2518609723\|gb\|OR128325.1\|	1758082	g491	i0	98.693	100.013071895425	306	4	100	0	1	306	76	381	Uncultured Terrimicrobium sp. clone 748a464ea190c92309074b4379e01e2e 16S ribosomal RNA gene, partial sequence	blastn	30604	544	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	uncultured Terrimicrobium sp.
12815021	12815021	PRJEB4632_P_NODE_251_length_474_cov_2.488778_g213_i0	PRJEB4632	251	474	2.488778	11.79680772	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	745	0	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g213	i0	94.937	267.949367088608	474	24	100	0	1	474	1156	683	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	127008	745	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
14089954	14089954	PRJEB4632_P_NODE_172_length_582_cov_4.361493_g134_i0	PRJEB4632	172	582	4.361493	25.38388926	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	667	0	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g134	i0	87.288	162.707903780069	590	67	100	4	1	582	1899	1310	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	94696	667	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
14089959	14089959	PRJEB4632_P_NODE_572_length_294_cov_2.126697_g534_i0	PRJEB4632	572	294	2.126697	6.25248918	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	425	1.39e-114	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g534	i0	92.857	284.721088435374	294	20	100	1	1	294	2300	2008	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	83708	425	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
14089960	14089960	PRJEB4632_P_NODE_592_length_289_cov_1.226852_g554_i0	PRJEB4632	592	289	1.226852	3.54560228	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	292	1.45e-74	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g554	i0	85.274	365.98615916955	292	34	99	9	1	288	2002077	2001791	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	105770	292	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
15363784	15363784	PRJEB4632_P_NODE_113_length_806_cov_7.439291_g77_i0	PRJEB4632	113	806	7.439291	59.96068546	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	989	0	NTclustered	gi\|164510704\|emb\|AJ966883.1\|	48466	g77	i0	89.308	288.179900744417	795	75	98	10	1	791	4018	4806	Prosthecobacter vanneervenii 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 12252	blastn	232273	989	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
15363786	15363786	PRJEB4632_P_NODE_213_length_522_cov_1.766147_g175_i0	PRJEB4632	213	522	1.766147	9.21928734	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	891	0	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g175	i0	97.51	118.787356321839	522	12	100	1	1	522	2834547	2834027	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	62007	891	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
15363800	15363800	PRJEB4632_P_NODE_873_length_246_cov_0.890173_g835_i0	PRJEB4632	873	246	0.890173	2.18982558	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	228	3.4399999999999986e-55	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g835	i0	83.806	284.483739837398	247	33	99	7	2	244	654897	655140	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	69983	228	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
17567869	17567869	PRJEB4632_P_NODE_734_length_254_cov_1.375691_g696_i0	PRJEB4632	734	254	1.375691	3.49425514	Verrucomicrobiales	48461	Bacteria	Bacteria	326	1.23e-84	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g696	i0	89.844	84.248031496063	256	22	100	4	1	254	3411392	3411139	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	21399	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
17913085	17913085	PRJEB4632_P_NODE_1015_length_232_cov_3.610063_g977_i0	PRJEB4632	1015	232	3.610063	8.37534616	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	388	1.39e-103	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g977	i0	96.97	280.064655172414	231	7	99	0	2	232	2218361	2218591	Luteolibacter sp. LG18 DNA, complete genome	blastn	64975	388	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
20116586	20116586	PRJEB4632_P_NODE_296_length_430_cov_6.885154_g258_i0	PRJEB4632	296	430	6.885154	29.6061622	Luteolibacter	518753	Bacteria	Bacteria	730	0	NTclustered	gi\|765490541\|gb\|KP717457.1\|	100234	g258	i0	97.436	100.5	429	9	99	2	2	430	13	439	Uncultured Verrucomicrobiales bacterium clone R2-16 16S ribosomal RNA gene, partial sequence	blastn	43215	730	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			uncultured Verrucomicrobiales bacterium
21392125	21392125	PRJEB4632_P_NODE_457_length_324_cov_3.179283_g419_i0	PRJEB4632	457	324	3.179283	10.30087692	Verrucomicrobiota	74201	Bacteria	Bacteria	547	3.18e-151	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g419	i0	97.5	41.1327160493827	320	8	99	0	5	324	5154429	5154748	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	13327	549	0.996357012750455	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23942367	23942367	PRJEB4632_P_NODE_739_length_253_cov_1.627778_g701_i0	PRJEB4632	739	253	1.627778	4.11827834	Candidatus Protochlamydia	282132	Bacteria	Bacteria	405	1.53e-108	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g701	i0	99.55	103.624505928854	222	1	88	0	1	222	1250568	1250347	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	26217	405	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
24287384	24287384	PRJEB4632_P_NODE_20_length_1696_cov_8.703635_g10_i0	PRJEB4632	20	1696	8.703635	147.6136496	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	1404	0	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g10	i0	82.009	265.284787735849	1712	252	100	40	1	1696	456156	454485	Luteolibacter sp. AS25 chromosome, complete genome	blastn	449923	1404	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
25216181	25216181	PRJEB4632_P_NODE_440_length_330_cov_1.280156_g402_i0	PRJEB4632	440	330	1.280156	4.2245148	Planctomycetaceae	126	Bacteria	Bacteria	313	1.29e-80	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g402	i0	91.928	81.7878787878788	223	18	68	0	31	253	4421661	4421439	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	26990	315	0.993650793650794	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
29970280	29970280	PRJEB4632_P_NODE_891_length_245_cov_0.895349_g853_i0	PRJEB4632	891	245	0.895349	2.19360505	Lentisphaerae bacterium GWF2_44_16	1798571	Bacteria	Bacteria	48.5	1.44e-4	NR	OGV49611.1	1798571	g853	i0	43.4	0.648979591836735	53	30	64.9	0	2	160	103	155	OGV49611.1 MAG: hypothetical protein A2017_16305 [Lentisphaerae bacterium GWF2_44_16]	diamond	159	48.5	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium GWF2_44_16
31076256	31076256	PRJEB4632_P_NODE_935_length_243_cov_0.905882_g897_i0	PRJEB4632	935	243	0.905882	2.20129326	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	147	6.3e-41	NR	MBN1556907.1	1932692	g897	i0	82.7	6	81	14	100	0	243	1	25	105	MBN1556907.1 sugar kinase [Lentisphaerota bacterium]	diamond	1458	147	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
31701913	31701913	PRJEB4632_P_NODE_937_length_243_cov_0.905882_g899_i0	PRJEB4632	937	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	82.8	1.33e-16	NR	MSU67472.1	2006848	g899	i0	92.9	1.03703703703704	42	3	51.9	0	3	128	290	331	MSU67472.1 MBL fold metallo-hydrolase [Opitutaceae bacterium]	diamond	252	82.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31923289	31923289	PRJEB4632_P_NODE_817_length_249_cov_0.875000_g779_i0	PRJEB4632	817	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	139	2.18e-38	NR	PIU40455.1	1974742	g779	i0	88	2	83	10	100	0	1	249	190	272	PIU40455.1 MAG: amino acid transporter, partial [Candidatus Omnitrophica bacterium CG07_land_8_20_14_0_80_50_8]	diamond	498	139	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophica bacterium CG07_land_8_20_14_0_80_50_8

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