metadata: contig_metadata: 30 rows where bioproject = "PRJNA498309", tax_clade = "PVC group" and tax

30 rows where bioproject = "PRJNA498309", 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
482333	482333	PRJNA498309_S_NODE_39241_length_217_cov_402.401099_g37073_i0	PRJNA498309	39241	217	402.401099	873.21038483	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	178	3.03e-40	NTclustered	gi\|2916415364\|gb\|CP170459.1\|	2026799	g37073	i0	85.227	26.3778801843318	176	22	80	4	13	186	2576966	2577139	MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome	blastn	5724	178	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
4309243	4309243	PRJNA498309_S_NODE_3924_length_1562_cov_16.523248_g2725_i0	PRJNA498309	3924	1562	16.523248	258.09313376	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1059	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g2725	i0	79.315	97.8085787451985	1547	292	98	27	23	1553	4130601	4129067	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	152777	1059	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9408895	9408895	PRJNA498309_P_NODE_48128_length_387_cov_1.934286_g45992_i0	PRJNA498309	48128	387	1.934286	7.48568682	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	322	2.55e-83	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g45992	i0	83.286	159.103359173127	353	56	91	3	35	387	1449	1100	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	61573	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
10684141	10684141	PRJNA498309_P_NODE_26689_length_555_cov_10.922780_g24731_i0	PRJNA498309	26689	555	10.92278	60.621429	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	532	1.5999999999999993e-146	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g24731	i0	85.799	254.897297297297	507	66	91	6	22	525	631700	632203	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	141468	532	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
13236433	13236433	PRJNA498309_S_NODE_5231_length_1274_cov_9.265537_g2192_i1	PRJNA498309	5231	1274	9.265537	118.04294138	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	2113	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g2192	i1	96.708	293.061224489796	1276	30	100	11	1	1274	1224	2489	Luteolibacter sp. SL250 chromosome	blastn	373360	2113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
14509666	14509666	PRJNA498309_P_NODE_48932_length_382_cov_4.414493_g46794_i0	PRJNA498309	48932	382	4.414493	16.86336326	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	606	6.199999999999998e-169	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g46794	i0	97.222	269.780104712042	360	7	94	2	23	382	2506	2150	Luteolibacter sp. SL250 chromosome	blastn	103056	606	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
15782708	15782708	PRJNA498309_P_NODE_109833_length_173_cov_1.698529_g107684_i0	PRJNA498309	109833	173	1.698529	2.93845517	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	95.1	2.95e-22	NR	HOY60684.1	2026799	g107684	i0	81.8	4.76878612716763	55	10	95.4	0	2	166	52	106	HOY60684.1 TIGR00730 family Rossman fold protein [Verrucomicrobiota bacterium]	diamond	825	95.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
18961125	18961125	PRJNA498309_S_NODE_25715_length_358_cov_3.944272_g23547_i0	PRJNA498309	25715	358	3.9442719999999998	14.12049376	Verrucomicrobiaceae	203557	Bacteria	Bacteria	318	3.03e-82	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g23547	i0	85.806	121.329608938547	310	32	86	8	29	332	631147	631450	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	43436	320	0.99375	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
19608659	19608659	PRJNA498309_S_NODE_7676_length_973_cov_67.288913_g2192_i2	PRJNA498309	7676	973	67.288913	654.72112349	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	1062	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g2192	i2	87.866	191.230215827338	923	89	94	20	1	916	2489	1583	Luteolibacter sp. SL250 chromosome	blastn	186067	1062	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
20884467	20884467	PRJNA498309_S_NODE_43677_length_192_cov_16.031847_g41509_i0	PRJNA498309	43677	192	16.031847	30.781146240000002	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	261	2.52e-65	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g41509	i0	91.146	247.723958333333	192	17	100	0	1	192	2216692	2216883	Luteolibacter sp. LG18 DNA, complete genome	blastn	47563	261	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
23434772	23434772	PRJNA498309_S_NODE_37759_length_228_cov_2.015544_g35591_i0	PRJNA498309	37759	228	2.015544	4.59544032	uncultured Verrucomicrobiaceae bacterium	257470	Bacteria	Bacteria	327	3.02e-85	NTclustered	gi\|672229328\|emb\|HE860821.1\|	257470	g35591	i0	97.895	76.8684210526316	190	3	83	1	24	213	29	217	Uncultured Verrucomicrobiaceae bacterium partial 16S rRNA gene, clone2A_22	blastn	17526	327	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		uncultured Verrucomicrobiaceae bacterium
26792286	26792286	PRJNA498309_P_NODE_39261_length_442_cov_8.743210_g37166_i0	PRJNA498309	39261	442	8.74321	38.6449882	Prosthecobacter sp.	1965333	Bacteria	Bacteria	126	4.48e-31	NR	HYF37212.1	1965333	g37166	i0	58	0.760180995475113	112	44	75.3	3	387	55	362	471	HYF37212.1 terminase family protein [Prosthecobacter sp.]	diamond	336	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
26792288	26792288	PRJNA498309_P_NODE_4761_length_1530_cov_9.099799_g3735_i0	PRJNA498309	4761	1530	9.099799	139.2269247	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	311	5.7900000000000005e-97	NR	HEY4285092.1	2201154	g3735	i0	74.5	0.384313725490196	196	50	38.4	0	3	590	250	445	HEY4285092.1 DNA methyltransferase [Chthoniobacterales bacterium]	diamond	588	311	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
26997433	26997433	PRJNA498309_P_NODE_19602_length_657_cov_6.604839_g17807_i0	PRJNA498309	19602	657	6.604839	43.39379223	Brevifollis	1383070	Bacteria	Bacteria	234	2.83e-75	NR	WP_146850614.1	748831	g17807	i0	71.8	1.44292237442922	163	45	74.4	1	529	41	1	162	WP_146850614.1 hypothetical protein [Brevifollis gellanilyticus]	diamond	948	234	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus
27077036	27077036	PRJNA498309_P_NODE_27682_length_544_cov_3.952663_g25717_i0	PRJNA498309	27682	544	3.952663	21.50248672	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	235	4.359999999999999e-74	NR	PYM04037.1	2026799	g25717	i0	94.4	1.35661764705882	126	7	69.5	0	383	6	1	126	PYM04037.1 MAG: hypothetical protein DMF13_02355 [Verrucomicrobiota bacterium]	diamond	738	235	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27171659	27171659	PRJNA498309_P_NODE_8442_length_1059_cov_3.559687_g7113_i0	PRJNA498309	8442	1059	3.559687	37.69708533	Horticoccus sp. 23ND18S-11	3391832	Bacteria	Bacteria	458	6.609999999999998e-157	NR	WP_414660626.1	3391832	g7113	i0	83.2	0.773371104815864	273	46	77.3	0	239	1057	1	273	WP_414660626.1 MFS transporter [Horticoccus sp. 23ND18S-11]	diamond	819	458	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus sp. 23ND18S-11
27693022	27693022	PRJNA498309_P_NODE_43964_length_411_cov_6.716578_g41839_i0	PRJNA498309	43964	411	6.716578	27.60513558	Bacteria	2	Bacteria	Bacteria	95.1	1.67e-21	NR	MBV9130075.1	2026799	g41839	i0	49	3.52554744525547	100	51	73	0	371	72	52	151	MBV9130075.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	1449	95.5	0.995811518324607	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27709271	27709271	PRJNA498309_P_NODE_102624_length_188_cov_1.529801_g100475_i0	PRJNA498309	102624	188	1.529801	2.87602588	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	82.4	3.69e-17	NR	MBS0628556.1	2026799	g100475	i0	69.1	2.60106382978723	55	17	87.8	0	167	3	197	251	MBS0628556.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	489	82.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27929872	27929872	PRJNA498309_P_NODE_45125_length_404_cov_5.874659_g42993_i0	PRJNA498309	45125	404	5.874659	23.73362236	Rariglobus sp.	2706526	Bacteria	Bacteria	79.3	3.63e-14	NR	MET0262465.1	2706526	g42993	i0	42.2	0.861386138613861	116	59	83.2	3	27	362	737	848	MET0262465.1 glycosyltransferase [Rariglobus sp.]	diamond	348	79.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Rariglobus	Rariglobus sp.
27993151	27993151	PRJNA498309_S_NODE_26645_length_344_cov_340.990291_g24477_i0	PRJNA498309	26645	344	340.990291	1173.00660104	Luteolibacter algae	454151	Bacteria	Bacteria	165	2.41e-47	NR	WP_386818584.1	454151	g24477	i0	80.4	1.62209302325581	92	18	80.2	0	300	25	80	171	WP_386818584.1 glycosyltransferase family 4 protein [Luteolibacter algae]	diamond	558	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter algae
28435145	28435145	PRJNA498309_P_NODE_98406_length_198_cov_1.645963_g96257_i0	PRJNA498309	98406	198	1.645963	3.25900674	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	52.4	7.86e-6	NR	HEV3149135.1	2201154	g96257	i0	49	2.28787878787879	49	25	74.2	0	191	45	275	323	HEV3149135.1 ABC transporter permease [Chthoniobacterales bacterium]	diamond	453	52.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
28529938	28529938	PRJNA498309_S_NODE_13687_length_631_cov_12.588926_g11764_i0	PRJNA498309	13687	631	12.588926	79.43612306	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	313	5.999999999999999e-103	NR	HEX7860182.1	2499141	g11764	i0	90.1	1.62599049128368	171	17	81.3	0	98	610	1	171	HEX7860182.1 putative DNA modification/repair radical SAM protein [Verrucomicrobiia bacterium]	diamond	1026	313	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29192987	29192987	PRJNA498309_P_NODE_5729_length_1354_cov_9.129841_g3735_i1	PRJNA498309	5729	1354	9.129841	123.61804714	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	311	9.06e-98	NR	HEY4285092.1	2201154	g3735	i1	74.5	0.434268833087149	196	50	43.4	0	3	590	250	445	HEY4285092.1 DNA methyltransferase [Chthoniobacterales bacterium]	diamond	588	311	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29413763	29413763	PRJNA498309_P_NODE_95549_length_205_cov_1.785714_g93400_i0	PRJNA498309	95549	205	1.785714	3.6607137	Luteolibacter yonseiensis	1144680	Bacteria	Bacteria	72.4	2.37e-13	NR	WP_200350434.1	1144680	g93400	i0	55	1.71219512195122	60	26	86.3	1	26	202	13	72	WP_200350434.1 hypothetical protein [Luteolibacter yonseiensis]	diamond	351	72.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter yonseiensis
29445190	29445190	PRJNA498309_P_NODE_21210_length_629_cov_5.839527_g19363_i0	PRJNA498309	21210	629	5.839527	36.730624829999996	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	261	3.51e-78	NR	MEI6034466.1	2499141	g19363	i0	66.5	1.96502384737679	203	66	95.9	1	24	626	2	204	MEI6034466.1 Hsp70 family protein [Verrucomicrobiia bacterium]	diamond	1236	261	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29729355	29729355	PRJNA498309_S_NODE_5330_length_1259_cov_11.385621_g3946_i0	PRJNA498309	5330	1259	11.385621	143.34496839	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	305	8.259999999999999e-96	NR	HEY4285092.1	2201154	g3946	i0	76.6	0.438443208895949	184	43	43.8	0	26	577	262	445	HEY4285092.1 DNA methyltransferase [Chthoniobacterales bacterium]	diamond	552	305	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30234960	30234960	PRJNA498309_P_NODE_113292_length_166_cov_2.395349_g111143_i0	PRJNA498309	113292	166	2.395349	3.97627934	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	72.4	2.53e-13	NR	MCX7713875.1	2201154	g111143	i0	100	0.578313253012048	32	0	57.8	0	97	2	231	262	MCX7713875.1 endonuclease/exonuclease/phosphatase family protein [Chthoniobacterales bacterium]	diamond	96	72.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30740481	30740481	PRJNA498309_P_NODE_21074_length_631_cov_8.378788_g19229_i0	PRJNA498309	21074	631	8.378788	52.87015228	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	313	5.999999999999999e-103	NR	HEX7860182.1	2499141	g19229	i0	90.1	1.62599049128368	171	17	81.3	0	98	610	1	171	HEX7860182.1 putative DNA modification/repair radical SAM protein [Verrucomicrobiia bacterium]	diamond	1026	313	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31277658	31277658	PRJNA498309_P_NODE_78835_length_254_cov_2.783410_g76686_i0	PRJNA498309	78835	254	2.78341	7.0698614	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	42.7	0.0432	NR	HUA59632.1	2499141	g76686	i0	33.8	0.767716535433071	65	39	73.2	2	19	204	321	384	HUA59632.1 serine/threonine-protein kinase [Verrucomicrobiia bacterium]	diamond	195	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31324776	31324776	PRJNA498309_P_NODE_38775_length_446_cov_1.640587_g36696_i0	PRJNA498309	38775	446	1.640587	7.31701802	Terrimicrobium	1649503	Bacteria	Bacteria	212	3.54e-65	NR	HEY5770585.1	1965319	g36696	i0	74.1	1.8632286995515699	139	36	93.5	0	22	438	1	139	HEY5770585.1 DUF4126 domain-containing protein [Terrimicrobium sp.]	diamond	831	214	0.990654205607477	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sp.

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