metadata: contig_metadata: 26 rows where bioproject = "PRJNA546018", tax_clade = "PVC group" and tax

26 rows where bioproject = "PRJNA546018", 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
3670659	3670659	PRJNA546018_S_NODE_8283_length_612_cov_2.010889_g7972_i0	PRJNA546018	8283	612	2.010889	12.30664068	Verrucomicrobiota	74201	Bacteria	Bacteria	946	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g7972	i0	96.075	103.392156862745	586	14	95	6	6	585	5153531	5152949	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	63276	952	0.993697478991597	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
6888568	6888568	PRJNA546018_S_NODE_2926_length_1092_cov_12.659554_g2741_i0	PRJNA546018	2926	1092	12.659554	138.24232968	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1164	0	NTclustered	gi\|2874254040\|emb\|OY970364.1\|	412056	g2741	i0	86.397	168.71978021978	1088	121	98	26	20	1092	2168185	2169260	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1	blastn	184242	1164	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
6889030	6889030	PRJNA546018_S_NODE_55666_length_205_cov_0.902778_g55341_i0	PRJNA546018	55666	205	0.902778	1.8506949	Lacunisphaera sp.	1961806	Bacteria	Bacteria	96.7	1.02e-21	NR	MDB6113615.1	1961806	g55341	i0	90	1.46341463414634	50	5	73.2	0	55	204	206	255	MDB6113615.1 putative FAD-linked oxidoreductase [Lacunisphaera sp.]	diamond	300	96.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
9439703	9439703	PRJNA546018_S_NODE_55788_length_204_cov_2.853147_g55463_i0	PRJNA546018	55788	204	2.853147	5.82041988	Actomonas aquatica	2866162	Bacteria	Bacteria	152	1.71e-32	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g55463	i0	81.967	21.7696078431373	183	30	89	3	23	203	3833904	3834085	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	4441	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica
10715051	10715051	PRJNA546018_S_NODE_30469_length_284_cov_3.044843_g30144_i0	PRJNA546018	30469	284	3.044843	8.64735412	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	374	4.93e-99	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g30144	i0	92.366	47.6971830985916	262	20	92	0	2	263	513332	513071	Lacunisphaera limnophila strain IG16b, complete genome	blastn	13546	374	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
11322391	11322391	PRJNA546018_S_NODE_49669_length_215_cov_2.110390_g49344_i0	PRJNA546018	49669	215	2.11039	4.5373385	Bacteria	2	Bacteria	Bacteria	115	1.1599999999999999e-28	NR	MBN8246459.1	2026799	g49344	i0	79.7	3.57209302325581	64	13	89.3	0	213	22	150	213	MBN8246459.1 efflux RND transporter permease subunit [Verrucomicrobiota bacterium]	diamond	768	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
11989431	11989431	PRJNA546018_S_NODE_12710_length_474_cov_4.426150_g12386_i0	PRJNA546018	12710	474	4.42615	20.979951	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	302	4.15e-77	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g12386	i0	79.186	1.11814345991561	442	86	93	5	22	460	1270089	1270527	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	530	302	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
15813751	15813751	PRJNA546018_S_NODE_33193_length_270_cov_3.095694_g32868_i0	PRJNA546018	33193	270	3.095694	8.3583738	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	333	7.8899999999999995e-87	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g32868	i0	91.358	2.6037037037037	243	21	90	0	7	249	3492672	3492430	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	703	333	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
19637243	19637243	PRJNA546018_S_NODE_39796_length_244_cov_1.546448_g39471_i0	PRJNA546018	39796	244	1.546448	3.77333312	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	407	4.08e-109	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g39471	i0	97.872	175.561475409836	235	5	96	0	10	244	501	735	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	42837	407	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
22187676	22187676	PRJNA546018_S_NODE_26538_length_308_cov_2.906883_g26213_i0	PRJNA546018	26538	308	2.906883	8.95319964	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	326	1.53e-84	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g26213	i0	87.197	19.0097402597403	289	33	93	4	22	308	2630169	2630455	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	5855	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
23463416	23463416	PRJNA546018_S_NODE_44739_length_229_cov_1.160714_g44414_i0	PRJNA546018	44739	229	1.160714	2.65803506	Lacunisphaera	1961799	Bacteria	Bacteria	96.3	1.24e-21	NR	HEY8993145.1	1961806	g44414	i0	81.1	1.40174672489083	53	10	69.4	0	14	172	103	155	HEY8993145.1 YCF48-related protein [Lacunisphaera sp.]	diamond	321	96.7	0.995863495346432	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
27362676	27362676	PRJNA546018_S_NODE_53443_length_208_cov_1.163265_g53118_i0	PRJNA546018	53443	208	1.163265	2.4195912	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	137	1.6199999999999998e-35	NR	MFL6504060.1	2665650	g53118	i0	92.8	0.995192307692308	69	5	99.5	0	207	1	446	514	MFL6504060.1 FAD-binding and (Fe-S)-binding domain-containing protein [Candidatus Udaeobacter sp.]	diamond	207	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
27787850	27787850	PRJNA546018_S_NODE_28904_length_293_cov_2.125000_g28579_i0	PRJNA546018	28904	293	2.125	6.22625	Horticoccus	2986286	Bacteria	Bacteria	101	2.1399999999999994e-23	NR	PAW64921.1	1982319	g28579	i0	59.3	1.5358361774744	81	33	82.9	0	263	21	2	82	PAW64921.1 MAG: hypothetical protein B9S34_11765 [Opitutia bacterium Tous-C1TDCM]	diamond	450	102	0.990196078431373	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium Tous-C1TDCM
27962313	27962313	PRJNA546018_S_NODE_37985_length_251_cov_1.026316_g37660_i0	PRJNA546018	37985	251	1.026316	2.57605316	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	138	2.09e-36	NR	WP_165201968.1	2711231	g37660	i0	89.5	0.908366533864542	76	8	90.8	0	23	250	354	429	WP_165201968.1 preprotein translocase subunit SecY [Roseimicrobium sp. ORNL1]	diamond	228	138	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
28040385	28040385	PRJNA546018_S_NODE_30225_length_286_cov_0.866667_g29900_i0	PRJNA546018	30225	286	0.866667	2.47866762	Opitutaceae	134623	Bacteria	Bacteria	115	8.27e-29	NR	HEY8995874.1	1961806	g29900	i0	66.3	1.93006993006993	92	30	96.5	1	11	286	136	226	HEY8995874.1 hypothetical protein [Lacunisphaera sp.]	diamond	552	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
28404362	28404362	PRJNA546018_S_NODE_18966_length_373_cov_9.131410_g18641_i0	PRJNA546018	18966	373	9.13141	34.0601593	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	64.3	4.59e-9	NR	MEN7973604.1	2026799	g18641	i0	53.6	0.450402144772118	56	25	44.2	1	347	183	733	788	MEN7973604.1 reverse transcriptase domain-containing protein [Verrucomicrobiota bacterium]	diamond	168	64.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28657097	28657097	PRJNA546018_S_NODE_3407_length_1009_cov_3.419831_g3208_i0	PRJNA546018	3407	1009	3.419831	34.50609479	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	185	1.25e-48	NR	MBI5387454.1	2026799	g3208	i0	53.3	1.02279484638256	167	77	49.7	1	48	548	1	166	MBI5387454.1 PAS domain S-box protein [Verrucomicrobiota bacterium]	diamond	1032	185	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28877850	28877850	PRJNA546018_S_NODE_32668_length_273_cov_1.533019_g32343_i0	PRJNA546018	32668	273	1.533019	4.18514187	Opitutaceae bacterium	2006848	Bacteria	Bacteria	133	2.21e-35	NR	HEY0944486.1	2006848	g32343	i0	75.9	0.912087912087912	83	20	91.2	0	10	258	49	131	HEY0944486.1 transaldolase family protein [Opitutaceae bacterium]	diamond	249	133	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28941347	28941347	PRJNA546018_S_NODE_54148_length_207_cov_1.034247_g53823_i0	PRJNA546018	54148	207	1.034247	2.14089129	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	128	1.4399999999999999e-32	NR	MBN8460050.1	2026799	g53823	i0	85.3	0.985507246376812	68	10	98.6	0	206	3	259	326	MBN8460050.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	204	128	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29193902	29193902	PRJNA546018_S_NODE_32789_length_272_cov_3.218009_g32464_i0	PRJNA546018	32789	272	3.218009	8.75298448	Brevifollis gellanilyticus	748831	Bacteria	Bacteria	131	8.19e-34	NR	WP_170266582.1	748831	g32464	i0	89.5	0.838235294117647	76	8	83.8	0	24	251	55	130	WP_170266582.1 S41 family peptidase [Brevifollis gellanilyticus]	diamond	228	131	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus
29951566	29951566	PRJNA546018_S_NODE_57571_length_202_cov_0.921986_g57246_i0	PRJNA546018	57571	202	0.921986	1.86241172	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	77.4	2.26e-16	NR	HON08814.1	2026799	g57246	i0	52.3	4.81188118811881	65	31	96.5	0	201	7	45	109	HON08814.1 glycosyl hydrolase [Verrucomicrobiota bacterium]	diamond	972	77.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31784528	31784528	PRJNA546018_S_NODE_49757_length_215_cov_1.610390_g49432_i0	PRJNA546018	49757	215	1.61039	3.4623385	Opitutaceae bacterium	2006848	Bacteria	Bacteria	94.4	1.77e-20	NR	MDR1280815.1	2006848	g49432	i0	73.4	0.893023255813953	64	17	89.3	0	13	204	556	619	MDR1280815.1 hypothetical protein [Opitutaceae bacterium]	diamond	192	94.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
32069372	32069372	PRJNA546018_S_NODE_23278_length_332_cov_1.833948_g22953_i0	PRJNA546018	23278	332	1.833948	6.08870736	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	59.7	4.26e-8	NR	MBN8709212.1	2026799	g22953	i0	61.1	0.487951807228916	54	20	47.9	1	266	108	153	206	MBN8709212.1 TetR family transcriptional regulator [Verrucomicrobiota bacterium]	diamond	162	59.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32196041	32196041	PRJNA546018_S_NODE_58458_length_198_cov_2.094891_g58133_i0	PRJNA546018	58458	198	2.094891	4.14788418	Opitutaceae bacterium	2006848	Bacteria	Bacteria	94.7	9.93e-21	NR	MBL9188591.1	2006848	g58133	i0	95.7	0.696969696969697	46	2	69.7	0	197	60	287	332	MBL9188591.1 TonB-dependent receptor [Opitutaceae bacterium]	diamond	138	94.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
32638319	32638319	PRJNA546018_S_NODE_35320_length_261_cov_1.840000_g34995_i0	PRJNA546018	35320	261	1.84	4.8024	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.5	0.0247	NR	MEN9359760.1	2026799	g34995	i0	33.8	0.816091954022989	71	47	81.6	0	258	46	282	352	MEN9359760.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	213	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32795794	32795794	PRJNA546018_S_NODE_41560_length_238_cov_4.926554_g41235_i0	PRJNA546018	41560	238	4.926554	11.72519852	Candidatus Synoicihabitans palmerolidicus	2818510	Bacteria	Bacteria	113	4.160000000000001e-27	NR	MCC5025902.1	2818510	g41235	i0	74	0.920168067226891	73	19	92	0	221	3	1762	1834	MCC5025902.1 polyketide synthase dehydratase domain-containing protein [Candidatus Synoicihabitans palmerolidicus]	diamond	219	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Synoicihabitans	Candidatus Synoicihabitans palmerolidicus

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