metadata: contig_metadata: 30 rows where bioproject = "PRJNA1164198" and tax

30 rows where bioproject = "PRJNA1164198" 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
2862779	2862779	PRJNA1164198_P_NODE_16203_length_307_cov_2.632479_g15934_i0	PRJNA1164198	16203	307	2.632479	8.08171053	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	239	2.05e-58	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g15934	i0	82.394	189.296416938111	284	40	91	10	1	279	3047224	3047502	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	58114	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
2862868	2862868	PRJNA1164198_P_NODE_31643_length_229_cov_3.166667_g31374_i0	PRJNA1164198	31643	229	3.166667	7.25166743	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	145	3.28e-30	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g31374	i0	82.249	0.737991266375546	169	29	73	1	1	168	588717	588549	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	169	145	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
6689890	6689890	PRJNA1164198_P_NODE_21146_length_270_cov_1.517766_g20877_i0	PRJNA1164198	21146	270	1.517766	4.0979682	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	342	1.31e-89	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g20877	i0	89.63	133.048148148148	270	27	100	1	1	270	3992068	3991800	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	35923	342	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
7965180	7965180	PRJNA1164198_P_NODE_16167_length_308_cov_1.174468_g15898_i0	PRJNA1164198	16167	308	1.174468	3.61736144	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	525	1.4099999999999995e-144	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g15898	i0	97.403	244.857142857143	308	8	100	0	1	308	2488	2795	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	75416	525	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
7965191	7965191	PRJNA1164198_P_NODE_18627_length_287_cov_1.518692_g18358_i0	PRJNA1164198	18627	287	1.518692	4.35864604	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	420	6.31e-113	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g18358	i0	93.056	115.257839721254	288	18	100	2	1	287	1249726	1250012	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	33079	420	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
13065601	13065601	PRJNA1164198_P_NODE_2991_length_725_cov_3.254601_g2770_i0	PRJNA1164198	2991	725	3.254601	23.59585725	Prosthecobacter dejongeii	48465	Bacteria	Bacteria	1201	0	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g2770	i0	96.556	128.51724137931	726	24	100	1	1	725	1070	1795	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	93175	1201	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
13792836	13792836	PRJNA1164198_P_NODE_9311_length_408_cov_2.259701_g9046_i0	PRJNA1164198	9311	408	2.259701	9.21958008	Planctopirus	1649480	Bacteria	Bacteria	749	0	NTclustered	gi\|470485078\|ref\|NR_076683.1\|	120	g9046	i0	99.755	133.252450980392	408	1	100	0	1	408	2794	2387	Planctomyces limnophilus strain Mue 290 23S ribosomal RNA gene, complete sequence	blastn	54367	754	0.993368700265252	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus limnophila
16889127	16889127	PRJNA1164198_P_NODE_5994_length_513_cov_3.020455_g5739_i0	PRJNA1164198	5994	513	3.020455	15.49493415	Prosthecobacter debontii	48467	Bacteria	Bacteria	898	0	NTclustered	gi\|164510703\|emb\|AJ966882.1\|	48467	g5739	i0	98.252	274.009746588694	515	5	100	3	1	513	4544	4032	Prosthecobacter debontii 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ala gene, tRNA-Ile gene and ITS1, strain DSM 14044	blastn	140567	898	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
18163607	18163607	PRJNA1164198_P_NODE_28835_length_245_cov_0.906977_g28566_i0	PRJNA1164198	28835	245	0.906977	2.22209365	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	298	2.57e-76	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g28566	i0	88.71	247.408163265306	248	23	100	3	1	245	7051213	7051458	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	60615	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
19437961	19437961	PRJNA1164198_P_NODE_29136_length_245_cov_0.906977_g28867_i0	PRJNA1164198	29136	245	0.906977	2.22209365	Planctopirus limnophila	120	Bacteria	Bacteria	137	5.93e-28	NTclustered	gi\|296012614\|gb\|CP001744.1\|	521674	g28867	i0	97.5	1.11428571428571	80	2	55	0	166	245	2052389	2052468	Planctopirus limnophila DSM 3776 chromosome, complete genome	blastn	273	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus limnophila
19437975	19437975	PRJNA1164198_P_NODE_30756_length_242_cov_0.923077_g30487_i0	PRJNA1164198	30756	242	0.923077	2.23384634	Chlamydia ibidis	1405396	Bacteria	Bacteria	69.3	9.3e-14	NR	EPP34946.1	1405396	g30487	i0	93.8	0.396694214876033	32	2	39.7	0	20	115	1	32	EPP34946.1 hypothetical protein CP10139811_1351, partial [Chlamydia ibidis]	diamond	96	69.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia ibidis
20713330	20713330	PRJNA1164198_P_NODE_27937_length_247_cov_0.896552_g27668_i0	PRJNA1164198	27937	247	0.896552	2.21448344	Urbifossiella limnaea	2528023	Bacteria	Bacteria	255	1.59e-63	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g27668	i0	85.714	5.05668016194332	245	31	98	4	5	247	204870	204628	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	1249	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
23264192	23264192	PRJNA1164198_P_NODE_2079_length_859_cov_2.913486_g1894_i0	PRJNA1164198	2079	859	2.913486	25.02684474	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	1459	0	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g1894	i0	97.322	272.527357392317	859	23	100	0	1	859	1052	194	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	234101	1459	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
26977101	26977101	PRJNA1164198_P_NODE_19982_length_277_cov_1.632353_g19713_i0	PRJNA1164198	19982	277	1.632353	4.52161781	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.1	0.0369	NR	MBM4009064.1	2026780	g19713	i0	37.5	0.346570397111913	32	20	34.7	0	3	98	145	176	MBM4009064.1 DMT family transporter [Planctomycetota bacterium]	diamond	96	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27439255	27439255	PRJNA1164198_P_NODE_28563_length_246_cov_0.901734_g28294_i0	PRJNA1164198	28563	246	0.901734	2.21826564	Luteolibacter	518753	Bacteria	Bacteria	95.5	1.04e-20	NR	WP_200266655.1	454153	g28294	i0	63	1.8780487804878	81	29	97.6	1	5	244	30	110	WP_200266655.1 TonB-dependent hemoglobin/transferrin/lactoferrin family receptor [Luteolibacter pohnpeiensis]	diamond	462	95.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter pohnpeiensis
27704209	27704209	PRJNA1164198_P_NODE_1264_length_1061_cov_2.638664_g1118_i0	PRJNA1164198	1264	1061	2.638664	27.99622504	Pirellula sp.	117	Bacteria	Bacteria	78.2	1.44e-11	NR	MFN7731751.1	117	g1118	i0	37.5	0.452403393025448	160	91	43	4	861	406	184	342	MFN7731751.1 beta strand repeat-containing protein [Pirellula sp.]	diamond	480	78.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
28165212	28165212	PRJNA1164198_P_NODE_22745_length_260_cov_2.085561_g22476_i0	PRJNA1164198	22745	260	2.085561	5.4224586	Bacteria	2	Bacteria	Bacteria	71.2	4.33e-12	NR	MFQ5590482.1	2026778	g22476	i0	48.3	5.00769230769231	89	36	99.2	4	259	2	1255	1336	MFQ5590482.1 hypothetical protein [Phycisphaerae bacterium]	diamond	1302	71.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
28777285	28777285	PRJNA1164198_P_NODE_6287_length_502_cov_1.247086_g6029_i0	PRJNA1164198	6287	502	1.247086	6.26037172	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	223	2.3999999999999996e-69	NR	RYD65414.1	2026800	g6029	i0	71.7	0.99203187250996006	166	44	98.6	2	500	6	89	252	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	498	223	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28859669	28859669	PRJNA1164198_P_NODE_21648_length_267_cov_1.577320_g21379_i0	PRJNA1164198	21648	267	1.57732	4.2114444	Pseudomonadati	3379134	Bacteria	Bacteria	94.4	3e-20	NR	MDR3625161.1	2047757	g21379	i0	50	12.7078651685393	86	43	96.6	0	1	258	344	429	MDR3625161.1 leucyl aminopeptidase [Chlamydiales bacterium]	diamond	3393	94.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28872013	28872013	PRJNA1164198_P_NODE_23808_length_254_cov_1.624309_g23539_i0	PRJNA1164198	23808	254	1.624309	4.12574486	Chlamydia psittaci	83554	Bacteria	Bacteria	79	1.68e-17	NR	EPP28643.1	1112246	g23539	i0	87.8	0.484251968503937	41	5	48.4	0	4	126	6	46	EPP28643.1 hypothetical protein CP082626L3_1561, partial [Chlamydia psittaci 08-2626_L3]	diamond	123	79	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
29377291	29377291	PRJNA1164198_P_NODE_20169_length_276_cov_1.522167_g19900_i0	PRJNA1164198	20169	276	1.522167	4.20118092	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	45.1	0.00454	NR	HEU5395808.1	2499141	g19900	i0	44.7	0.41304347826087	38	21	41.3	0	153	266	110	147	HEU5395808.1 DUF6600 domain-containing protein [Verrucomicrobiia bacterium]	diamond	114	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29471706	29471706	PRJNA1164198_P_NODE_27590_length_247_cov_1.045977_g27321_i0	PRJNA1164198	27590	247	1.045977	2.58356319	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	43.5	0.0195	NR	HEX8203040.1	2691532	g27321	i0	39.4	0.862348178137652	71	35	76.5	1	239	51	62	132	HEX8203040.1 MATE family efflux transporter [Isosphaeraceae bacterium]	diamond	213	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
30514374	30514374	PRJNA1164198_P_NODE_27613_length_247_cov_0.896552_g27344_i0	PRJNA1164198	27613	247	0.896552	2.21448344	Gemmatales bacterium	2838789	Bacteria	Bacteria	87.4	4.56e-18	NR	HQR41952.1	2838789	g27344	i0	56.6	2.01619433198381	83	35	99.6	1	2	247	159	241	HQR41952.1 CAP domain-containing protein [Gemmatales bacterium]	diamond	498	87.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales			Gemmatales bacterium
30577342	30577342	PRJNA1164198_P_NODE_28253_length_246_cov_0.901734_g27984_i0	PRJNA1164198	28253	246	0.901734	2.21826564	Candidatus Uabimicrobium amorphum	2596890	Bacteria	Bacteria	54.7	2.26e-6	NR	WP_151971075.1	2596890	g27984	i0	49.1	0.646341463414634	53	24	62.2	2	23	175	337	388	WP_151971075.1 serine hydrolase domain-containing protein [Candidatus Uabimicrobium amorphum]	diamond	159	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium amorphum
30893699	30893699	PRJNA1164198_P_NODE_27754_length_247_cov_0.896552_g27485_i0	PRJNA1164198	27754	247	0.896552	2.21448344	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	116	3.71e-28	NR	MBN9693850.1	2026799	g27485	i0	86.4	0.801619433198381	66	9	80.2	0	3	200	279	344	MBN9693850.1 CHASE3 domain-containing protein [Verrucomicrobiota bacterium]	diamond	198	116	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31133682	31133682	PRJNA1164198_P_NODE_16515_length_304_cov_1.653680_g16246_i0	PRJNA1164198	16515	304	1.65368	5.0271872	Pseudomonadati	3379134	Bacteria	Bacteria	73.6	1.11e-12	NR	HWL94019.1	2026778	g16246	i0	40.2	4.6875	97	56	93.8	1	12	296	327	423	HWL94019.1 hypothetical protein [Phycisphaerae bacterium]	diamond	1425	73.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31272787	31272787	PRJNA1164198_P_NODE_25295_length_251_cov_0.876404_g25026_i0	PRJNA1164198	25295	251	0.876404	2.19977404	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	63.9	1.45e-9	NR	MBI3878789.1	2026799	g25026	i0	46.9	2.54581673306773	81	43	96.8	0	7	249	2229	2309	MBI3878789.1 tandem-95 repeat protein [Verrucomicrobiota bacterium]	diamond	639	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31462750	31462750	PRJNA1164198_P_NODE_26416_length_249_cov_0.886364_g26147_i0	PRJNA1164198	26416	249	0.886364	2.20704636	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	42.7	0.038	NR	MCB1071097.1	2212473	g26147	i0	29.9	0.927710843373494	77	52	91.6	2	9	236	212	287	MCB1071097.1 ABC transporter permease [Kiritimatiellia bacterium]	diamond	231	42.7	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
31892958	31892958	PRJNA1164198_P_NODE_24857_length_252_cov_0.871508_g24588_i0	PRJNA1164198	24857	252	0.871508	2.19620016	root	1	Root_unresolved	Root_unresolved	48.5	1.32e-4	NR	WP_158265140.1	124	g24588	i0	46.4	2.57142857142857	56	29	65.5	1	40	204	76	131	WP_158265140.1 CBS domain-containing protein [Blastopirellula marina]	diamond	648	48.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula marina
32127039	32127039	PRJNA1164198_P_NODE_25858_length_250_cov_0.881356_g25589_i0	PRJNA1164198	25858	250	0.881356	2.20339	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	106	3.96e-25	NR	MBI5800971.1	2026799	g25589	i0	71.2	3.96	66	19	79.2	0	199	2	1	66	MBI5800971.1 glutathionylspermidine synthase family protein [Verrucomicrobiota bacterium]	diamond	990	106	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;