metadata: contig_metadata: 29 rows where bioproject = "PRJNA1020854", tax_clade = "PVC group" and tax

29 rows where bioproject = "PRJNA1020854", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"

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
1435730	1435730	PRJNA1020854_S_NODE_26282_length_205_cov_7.465909_g23518_i0	PRJNA1020854	26282	205	7.465909	15.30511345	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	316	5.75e-82	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g23518	i0	94.634	36.7121951219512	205	10	100	1	1	205	2834516	2834313	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	7526	316	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
2710971	2710971	PRJNA1020854_S_NODE_11143_length_379_cov_62.034286_g8391_i0	PRJNA1020854	11143	379	62.034286	235.10994394	uncultured Verrucomicrobium sp.	114704	Bacteria	Bacteria	462	1.4099999999999999e-125	NTclustered	gi\|296172422\|emb\|FN668204.2\|	114704	g8391	i0	97.091	68.1187335092348	275	7	72	1	106	379	451	725	Uncultured Verrucomicrobium sp. partial 16S rRNA gene, clone ZS-4-361	blastn	25817	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	uncultured Verrucomicrobium sp.
3987798	3987798	PRJNA1020854_S_NODE_42724_length_151_cov_14.959016_g39960_i0	PRJNA1020854	42724	151	14.959016	22.58811416	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	263	5.23e-66	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g39960	i0	98.013	17.3973509933775	151	3	100	0	1	151	2497266	2497116	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	2627	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
4831346	4831346	PRJNA1020854_S_NODE_30284_length_187_cov_7.000000_g27520_i0	PRJNA1020854	30284	187	7	13.09	Verrucomicrobiota	74201	Bacteria	Bacteria	283	5.209999999999999e-72	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g27520	i0	98.148	31.5828877005348	162	3	87	0	1	162	944	783	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	5906	283	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
5264202	5264202	PRJNA1020854_S_NODE_7565_length_544_cov_1035.833010_g4941_i0	PRJNA1020854	7565	544	1035.83301	5634.9315744	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	547	5.599999999999998e-151	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g4941	i0	87.5	97.2628676470588	480	53	88	6	18	494	693	218	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	52911	547	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
9088364	9088364	PRJNA1020854_S_NODE_19348_length_252_cov_6.089686_g16584_i0	PRJNA1020854	19348	252	6.089686	15.34600872	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	438	1.5e-118	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g16584	i0	98.016	76.5436507936508	252	5	100	0	1	252	2833844	2834095	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	19289	438	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
9088617	9088617	PRJNA1020854_S_NODE_32328_length_180_cov_2.417219_g29564_i0	PRJNA1020854	32328	180	2.417219	4.3509942	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	62.1	2.54e-5	NTclustered	gi\|2916415364\|gb\|CP170459.1\|	2026799	g29564	i0	92.857	0.233333333333333	42	3	23	0	1	42	4677726	4677767	MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome	blastn	42	62.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
12914620	12914620	PRJNA1020854_S_NODE_25951_length_207_cov_3.707865_g23187_i0	PRJNA1020854	25951	207	3.707865	7.67528055	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	333	5.779999999999999e-87	NTclustered	gi\|2874253793\|emb\|OY969777.1\|	412056	g23187	i0	95.673	36.8743961352657	208	7	100	2	1	207	2364784	2364990	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1	blastn	7633	333	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14189812	14189812	PRJNA1020854_S_NODE_39472_length_159_cov_1.938462_g36708_i0	PRJNA1020854	39472	159	1.938462	3.08215458	Luteolibacter sp.	1962973	Bacteria	Bacteria	147	5.869999999999999e-31	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g36708	i0	86.466	2.42138364779874	133	18	84	0	1	133	1722194	1722326	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	385	147	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
15463528	15463528	PRJNA1020854_S_NODE_19313_length_252_cov_2328.807175_g16549_i0	PRJNA1020854	19313	252	2328.807175	5868.594081	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	250	7.55e-62	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g16549	i0	93.064	412.777777777778	173	9	68	2	55	225	2833210	2833381	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	104020	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
16737597	16737597	PRJNA1020854_S_NODE_12414_length_348_cov_971.579937_g9650_i0	PRJNA1020854	12414	348	971.579937	3381.09818076	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	333	1.05e-86	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g9650	i0	86.842	137.827586206897	304	32	86	5	1	300	1903093	1902794	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	47964	333	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
16737880	16737880	PRJNA1020854_S_NODE_25314_length_210_cov_13.977901_g22550_i0	PRJNA1020854	25314	210	13.977901	29.3535921	Opitutus sp. VeGlc2	134634	Bacteria	Bacteria	335	1.6299999999999994e-87	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g22550	i0	95.673	26.4761904761905	208	9	99	0	3	210	2450	2243	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	5560	335	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
16738173	16738173	PRJNA1020854_S_NODE_41594_length_154_cov_2.408000_g38830_i0	PRJNA1020854	41594	154	2.408	3.70832	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	250	4.18e-62	NTclustered	gi\|2874253793\|emb\|OY969777.1\|	412056	g38830	i0	96.104	38.1363636363636	154	5	100	1	1	154	2365569	2365417	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1	blastn	5873	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18012541	18012541	PRJNA1020854_S_NODE_16935_length_277_cov_5.705645_g14171_i0	PRJNA1020854	16935	277	5.705645	15.80463665	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	457	4.62e-124	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g14171	i0	96.403	27.9819494584838	278	9	100	1	1	277	2834757	2834480	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	7751	457	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
18855018	18855018	PRJNA1020854_S_NODE_30775_length_185_cov_1980.756410_g28011_i0	PRJNA1020854	30775	185	1980.75641	3664.3993585	Terrimicrobium sp.	1965319	Bacteria	Bacteria	82.8	1.3e-16	NR	MET0224303.1	1965319	g28011	i0	64.4	0.956756756756757	59	18	90.8	1	169	2	252	310	MET0224303.1 DUF4157 domain-containing protein [Terrimicrobium sp.]	diamond	177	82.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sp.
19286661	19286661	PRJNA1020854_S_NODE_28656_length_194_cov_4.624242_g25892_i0	PRJNA1020854	28656	194	4.624242	8.97102948	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	101	4.789999999999999e-23	NR	HUI06118.1	2499141	g25892	i0	74.2	1.85567010309278	62	16	95.9	0	187	2	400	461	HUI06118.1 family 78 glycoside hydrolase catalytic domain [Verrucomicrobiia bacterium]	diamond	360	101	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
21405201	21405201	PRJNA1020854_S_NODE_13977_length_319_cov_3.993103_g11213_i0	PRJNA1020854	13977	319	3.993103	12.73799857	Bacteria	2	Bacteria	Bacteria	331	3.43e-86	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g11213	i0	85.804	242.46394984326	317	40	99	5	5	319	27751	28064	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	77346	331	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
23113213	23113213	PRJNA1020854_S_NODE_25519_length_209_cov_6.238889_g22755_i0	PRJNA1020854	25519	209	6.238889	13.03927801	Opitutus sp. VeGlc2	134634	Bacteria	Bacteria	209	1.03e-49	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g22755	i0	84.834	246.55980861244	211	28	100	3	1	209	2634	2426	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	51531	209	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
24387062	24387062	PRJNA1020854_S_NODE_28100_length_197_cov_2.630952_g25336_i0	PRJNA1020854	28100	197	2.630952	5.18297544	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	88.2	1.97e-18	NR	HWY77382.1	2499141	g25336	i0	64.6	0.989847715736041	65	23	99	0	1	195	512	576	HWY77382.1 response regulator [Verrucomicrobiia bacterium]	diamond	195	88.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27382673	27382673	PRJNA1020854_S_NODE_42283_length_152_cov_4.528455_g39519_i0	PRJNA1020854	42283	152	4.528455	6.8832516	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	92	4.57e-20	NR	HTS17928.1	2499141	g39519	i0	76	3.94736842105263	50	12	98.7	0	152	3	445	494	HTS17928.1 family 78 glycoside hydrolase catalytic domain [Verrucomicrobiia bacterium]	diamond	600	92	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28582531	28582531	PRJNA1020854_S_NODE_33407_length_176_cov_3.598639_g30643_i0	PRJNA1020854	33407	176	3.598639	6.33360464	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	70.1	1.74e-12	NR	MFO1478276.1	2026799	g30643	i0	58.2	1.92613636363636	55	23	93.8	0	167	3	156	210	MFO1478276.1 aminotransferase class IV [Verrucomicrobiota bacterium]	diamond	339	70.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28803148	28803148	PRJNA1020854_S_NODE_29168_length_192_cov_3.368098_g26404_i0	PRJNA1020854	29168	192	3.368098	6.46674816	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	73.9	1.9e-13	NR	MBS0634256.1	2026799	g26404	i0	49.3	1.046875	67	31	100	2	1	192	106	172	MBS0634256.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	201	73.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28953732	28953732	PRJNA1020854_S_NODE_34948_length_171_cov_3.394366_g32184_i0	PRJNA1020854	34948	171	3.394366	5.80436586	Bacteria	2	Bacteria	Bacteria	88.2	1.41e-18	NR	MFM9954827.1	2006848	g32184	i0	96.4	1.92982456140351	55	2	96.5	0	4	168	575	629	MFM9954827.1 putative Ig domain-containing protein [Opitutaceae bacterium]	diamond	330	88.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30224392	30224392	PRJNA1020854_S_NODE_29692_length_190_cov_2.521739_g26928_i0	PRJNA1020854	29692	190	2.521739	4.7913041	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	97.8	7.47e-22	NR	MEN9632757.1	2026799	g26928	i0	94.4	0.852631578947368	54	3	85.3	0	28	189	504	557	MEN9632757.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	162	97.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30288041	30288041	PRJNA1020854_S_NODE_18312_length_262_cov_4.064378_g15548_i0	PRJNA1020854	18312	262	4.064378	10.64867036	Terrimicrobium sp.	1965319	Bacteria	Bacteria	100	1.65e-22	NR	MET0224303.1	1965319	g15548	i0	59.6	1.01908396946565	89	34	99.6	1	262	2	363	451	MET0224303.1 DUF4157 domain-containing protein [Terrimicrobium sp.]	diamond	267	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sp.
30856348	30856348	PRJNA1020854_S_NODE_40554_length_156_cov_3.086614_g37790_i0	PRJNA1020854	40554	156	3.086614	4.81511784	Candidatus Methylacidiphilales bacterium	2720631	Bacteria	Bacteria	63.9	3.87e-10	NR	HEX4141034.1	2720631	g37790	i0	56.1	1.55769230769231	41	18	78.8	0	156	34	488	528	HEX4141034.1 glycosyltransferase family 39 protein [Candidatus Methylacidiphilales bacterium]	diamond	243	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales			Candidatus Methylacidiphilales bacterium
31077696	31077696	PRJNA1020854_S_NODE_28915_length_193_cov_3.707317_g26151_i0	PRJNA1020854	28915	193	3.707317	7.15512181	Opitutia bacterium Tous-C4FEB	1982321	Bacteria	Bacteria	75.9	3.93e-14	NR	PAW86723.1	1982321	g26151	i0	94.9	0.606217616580311	39	1	59.1	1	16	129	435	473	PAW86723.1 MAG: hypothetical protein B9S26_15375 [Opitutia bacterium Tous-C4FEB]	diamond	117	75.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium Tous-C4FEB
31108988	31108988	PRJNA1020854_S_NODE_37815_length_163_cov_2.686567_g35051_i0	PRJNA1020854	37815	163	2.686567	4.37910421	Opitutaceae bacterium	2006848	Bacteria	Bacteria	98.6	2.5e-24	NR	NBR59932.1	2006848	g35051	i0	86.5	0.957055214723926	52	7	95.7	0	3	158	49	100	NBR59932.1 hypothetical protein [Opitutaceae bacterium]	diamond	156	98.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31583686	31583686	PRJNA1020854_S_NODE_28736_length_194_cov_2.775758_g25972_i0	PRJNA1020854	28736	194	2.775758	5.38497052	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	52.4	1.62e-6	NR	NBV87385.1	2026799	g25972	i0	38.1	1.94845360824742	63	39	97.4	0	192	4	52	114	NBV87385.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	378	52.4	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);;