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

30 rows where bioproject = "PRJNA1031674", 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
166551	166551	PRJNA1031674_P_NODE_12921_length_284_cov_1.227488_g12710_i0	PRJNA1031674	12921	284	1.227488	3.48606592	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	497	2.8e-136	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g12710	i0	98.239	107.961267605634	284	5	100	0	1	284	2833761	2833478	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	30661	497	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
166775	166775	PRJNA1031674_P_NODE_27021_length_242_cov_2.733728_g26810_i0	PRJNA1031674	27021	242	2.733728	6.61562176	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	63.9	1.01e-5	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g26810	i0	95.122	0.169421487603306	41	1	17	1	21	61	5696895	5696934	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	41	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
1006860	1006860	PRJNA1031674_P_NODE_24141_length_247_cov_2.477011_g23930_i0	PRJNA1031674	24141	247	2.477011	6.11821717	Akkermansia	239934	Bacteria	Bacteria	84.2	7.92e-12	NTclustered	gi\|2051350654\|gb\|CP072036.1\|	2927224	g23930	i0	96.154	20.6558704453441	52	1	21	1	196	247	2906574	2906524	Akkermansia massiliensis strain Akk1573 chromosome, complete genome	blastn	5102	84.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia massiliensis
2717060	2717060	PRJNA1031674_P_NODE_1523_length_603_cov_2.179245_g1317_i0	PRJNA1031674	1523	603	2.179245	13.14084735	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	375	3.119999999999999e-99	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g1317	i0	87.202	128.426202321725	336	35	55	8	1	330	3990515	3990848	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	77441	375	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
2717227	2717227	PRJNA1031674_P_NODE_25483_length_245_cov_1.418605_g25272_i0	PRJNA1031674	25483	245	1.418605	3.47558225	Pedosphaera parvula	1032527	Bacteria	Bacteria	339	1.5199999999999998e-88	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g25272	i0	92.766	189.440816326531	235	16	96	1	8	242	890	657	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	46413	339	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
2717259	2717259	PRJNA1031674_P_NODE_28003_length_241_cov_0.916667_g27792_i0	PRJNA1031674	28003	241	0.916667	2.20916747	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	375	1.1299999999999998e-99	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g27792	i0	95.708	0.966804979253112	233	10	97	0	1	233	3497534	3497302	Luteolibacter sp. SL250 chromosome	blastn	233	375	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
6544790	6544790	PRJNA1031674_P_NODE_20986_length_255_cov_1.439560_g20775_i0	PRJNA1031674	20986	255	1.43956	3.670878	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	399	7.179999999999999e-107	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g20775	i0	94.902	122.890196078431	255	13	100	0	1	255	1405581	1405835	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	31337	399	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
7819384	7819384	PRJNA1031674_P_NODE_22387_length_250_cov_2.265537_g22176_i0	PRJNA1031674	22387	250	2.265537	5.6638425	Bacteria	2	Bacteria	Bacteria	111	2.94e-28	NR	MBV8970391.1	2026799	g22176	i0	72	11.76	82	23	98.4	0	4	249	26	107	MBV8970391.1 zinc-binding dehydrogenase [Verrucomicrobiota bacterium]	diamond	2940	112	0.991071428571429	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
10369877	10369877	PRJNA1031674_P_NODE_17729_length_267_cov_2.974227_g17518_i0	PRJNA1031674	17729	267	2.974227	7.94118609	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	488	1.5699999999999998e-133	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g17518	i0	99.625	108.98127340824	267	1	100	0	1	267	2558671	2558405	Lacunisphaera limnophila strain IG16b, complete genome	blastn	29098	488	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
14195232	14195232	PRJNA1031674_P_NODE_1552_length_596_cov_2.592734_g1346_i0	PRJNA1031674	1552	596	2.592734	15.45269464	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	841	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g1346	i0	92.114	73.6107382550336	596	47	100	0	1	596	5154176	5153581	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	43872	841	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15034641	15034641	PRJNA1031674_P_NODE_7452_length_323_cov_2.320000_g7241_i0	PRJNA1031674	7452	323	2.32	7.4936	Opitutus	178440	Bacteria	Bacteria	532	8.879999999999998e-147	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g7241	i0	96.573	35.3684210526316	321	11	99	0	1	321	714	1034	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	11424	532	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
16743660	16743660	PRJNA1031674_P_NODE_22494_length_250_cov_1.615819_g22283_i0	PRJNA1031674	22494	250	1.615819	4.0395475	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	392	1.1699999999999999e-104	NTclustered	gi\|2874253974\|emb\|OY970299.1\|	412056	g22283	i0	95.161	92.964	248	12	99	0	3	250	1258157	1258404	MAG: uncultured Verrucomicrobiae bacterium isolate MFD09603.bin.1.43 genome assembly, chromosome: 1	blastn	23241	392	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19292455	19292455	PRJNA1031674_P_NODE_17736_length_267_cov_2.783505_g17525_i0	PRJNA1031674	17736	267	2.783505	7.43195835	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	185	2.31e-42	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g17525	i0	79.688	12.2172284644195	256	52	96	0	12	267	684084	683829	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	3262	185	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
20133317	20133317	PRJNA1031674_P_NODE_4396_length_393_cov_2.409375_g4186_i0	PRJNA1031674	4396	393	2.409375	9.46884375	Bacteria	2	Bacteria	Bacteria	614	3.819999999999999e-171	NTclustered	gi\|351694033\|gb\|JN656847.1\|	156588	g4186	i0	94.924	99.6539440203562	394	16	99	2	2	393	205	596	Uncultured Verrucomicrobia bacterium clone KWK12S.02 16S ribosomal RNA gene, partial sequence	blastn	39164	614	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
20567704	20567704	PRJNA1031674_P_NODE_13197_length_283_cov_1.385714_g12986_i0	PRJNA1031674	13197	283	1.385714	3.92157062	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	490	4.67e-134	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g12986	i0	97.88	265.127208480565	283	6	100	0	1	283	3894809	3894527	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	75031	490	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21843700	21843700	PRJNA1031674_P_NODE_28138_length_240_cov_2.407186_g27927_i0	PRJNA1031674	28138	240	2.407186	5.7772464	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	366	6.79e-97	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g27927	i0	94.167	109.6375	240	14	100	0	1	240	2834665	2834904	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	26313	366	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
24392735	24392735	PRJNA1031674_P_NODE_1940_length_545_cov_1.347458_g1732_i0	PRJNA1031674	1940	545	1.347458	7.3436461	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	785	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g1732	i0	92.701	125.220183486239	548	35	100	5	1	545	5152323	5152868	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	68245	785	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
26845473	26845473	PRJNA1031674_P_NODE_19021_length_263_cov_1.094737_g18810_i0	PRJNA1031674	19021	263	1.094737	2.87915831	Opitutaceae bacterium	2006848	Bacteria	Bacteria	74.7	2.64e-13	NR	MBH54129.1	2006848	g18810	i0	50	2.78326996197719	82	36	93.5	1	8	253	448	524	MBH54129.1 hypothetical protein [Opitutaceae bacterium]	diamond	732	74.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28329912	28329912	PRJNA1031674_P_NODE_15646_length_275_cov_1.524752_g15435_i0	PRJNA1031674	15646	275	1.524752	4.193068	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	115	2.12e-28	NR	HAV65000.1	2026801	g15435	i0	62.6	2.96727272727273	91	34	99.3	0	273	1	66	156	HAV65000.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	816	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28361481	28361481	PRJNA1031674_P_NODE_15226_length_276_cov_2.014778_g15015_i0	PRJNA1031674	15226	276	2.014778	5.5607872800000004	Verrucomicrobia bacterium LW23	2161867	Bacteria	Bacteria	115	9.239999999999999e-30	NR	PTY01923.1	2161867	g15015	i0	83.1	0.771739130434783	71	12	77.2	0	213	1	1	71	PTY01923.1 branched-chain amino acid ABC transporter ATP-binding protein [Verrucomicrobia bacterium LW23]	diamond	213	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium LW23
28361484	28361484	PRJNA1031674_P_NODE_18966_length_263_cov_1.431579_g18755_i0	PRJNA1031674	18966	263	1.431579	3.76505277	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	87.8	4.17e-19	NR	MBA2272013.1	2201154	g18755	i0	60.7	0.958174904942966	84	30	94.7	2	251	3	62	143	MBA2272013.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	252	87.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
28424886	28424886	PRJNA1031674_P_NODE_4606_length_387_cov_1.942675_g4396_i0	PRJNA1031674	4606	387	1.942675	7.51815225	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	46.2	0.00591	NR	MEI6341235.1	2026799	g4396	i0	33.7	0.643410852713178	83	46	57.4	2	77	298	84	166	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	249	46.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28961745	28961745	PRJNA1031674_P_NODE_9568_length_299_cov_3.353982_g9357_i0	PRJNA1031674	9568	299	3.353982	10.02840618	Lacunisphaera sp.	1961806	Bacteria	Bacteria	98.2	1.3100000000000002e-21	NR	HEY0864151.1	1961806	g9357	i0	96	0.501672240802676	50	2	50.2	0	150	299	90	139	HEY0864151.1 FAD-dependent oxidoreductase [Lacunisphaera sp.]	diamond	150	98.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
30058585	30058585	PRJNA1031674_P_NODE_8651_length_310_cov_2.611814_g8440_i0	PRJNA1031674	8651	310	2.611814	8.0966234	Lacunisphaera	1961799	Bacteria	Bacteria	96.3	1.34e-20	NR	WP_069963418.1	1838286	g8440	i0	100	7.58709677419355	49	0	47.4	0	148	2	214	262	WP_069963418.1 bifunctional aspartate kinase/homoserine dehydrogenase I [Lacunisphaera limnophila]	diamond	2352	96.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
30193004	30193004	PRJNA1031674_P_NODE_25472_length_245_cov_1.459302_g25261_i0	PRJNA1031674	25472	245	1.459302	3.5752899	Opitutaceae bacterium	2006848	Bacteria	Bacteria	129	9.34e-33	NR	MBL9215566.1	2006848	g25261	i0	77.8	0.991836734693878	81	18	99.2	0	245	3	407	487	MBL9215566.1 GAF domain-containing protein [Opitutaceae bacterium]	diamond	243	129	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30667013	30667013	PRJNA1031674_P_NODE_15553_length_275_cov_1.915842_g15342_i0	PRJNA1031674	15553	275	1.915842	5.2685655	Lacunisphaera sp.	1961806	Bacteria	Bacteria	53.5	8.67e-6	NR	HEY0865052.1	1961806	g15342	i0	30.8	0.992727272727273	91	56	94.9	3	13	273	59	146	HEY0865052.1 prolyl oligopeptidase family serine peptidase [Lacunisphaera sp.]	diamond	273	53.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
31362463	31362463	PRJNA1031674_P_NODE_19236_length_262_cov_1.322751_g19025_i0	PRJNA1031674	19236	262	1.322751	3.46560762	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	90.9	5.53e-19	NR	MEY2879255.1	2026799	g19025	i0	54	0.99618320610687	87	40	99.6	0	2	262	284	370	MEY2879255.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	261	90.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31386111	31386111	PRJNA1031674_P_NODE_22416_length_250_cov_1.932203_g22205_i0	PRJNA1031674	22416	250	1.932203	4.8305075	Lacunisphaera	1961799	Bacteria	Bacteria	81.6	2.93e-17	NR	MEJ1971517.1	1961806	g22205	i0	48.8	7.728	82	42	98.4	0	1	246	9	90	MEJ1971517.1 hypothetical protein [Lacunisphaera sp.]	diamond	1932	81.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
32279932	32279932	PRJNA1031674_P_NODE_24879_length_246_cov_1.583815_g24668_i0	PRJNA1031674	24879	246	1.583815	3.8961849	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	44.7	0.00828	NR	HTJ73330.1	2499141	g24668	i0	55.6	1.24390243902439	36	15	43.9	1	1	108	628	662	HTJ73330.1 phage tail tip lysozyme [Verrucomicrobiia bacterium]	diamond	306	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32374775	32374775	PRJNA1031674_P_NODE_20419_length_257_cov_1.673913_g20208_i0	PRJNA1031674	20419	257	1.673913	4.30195641	Luteolibacter rhizosphaerae	2989719	Bacteria	Bacteria	127	1.04e-31	NR	WP_264513945.1	2989719	g20208	i0	81.1	0.863813229571984	74	13	86.4	1	257	36	1117	1189	WP_264513945.1 pilus assembly PilX family protein [Luteolibacter rhizosphaerae]	diamond	222	127	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter rhizosphaerae

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