metadata: contig_metadata: 34 rows where bioproject = "PRJNA577580", tax_clade = "PVC group" and tax

34 rows where bioproject = "PRJNA577580", 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
1839585	1839585	PRJNA577580_P_NODE_9702_length_293_cov_3.290909_g9624_i0	PRJNA577580	9702	293	3.290909	9.64236337	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	276	1.48e-69	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g9624	i0	84.407	106.37542662116	295	31	98	14	1	287	1316336	1316623	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	31168	276	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2413536	2413536	PRJNA577580_P_NODE_3842_length_459_cov_2.168394_g3764_i0	PRJNA577580	3842	459	2.168394	9.95292846	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	120	1.27e-30	NR	NBD37953.1	2026799	g3764	i0	48.5	1.69934640522876	130	64	85	2	15	404	118	244	NBD37953.1 ZIP family metal transporter [Verrucomicrobiota bacterium]	diamond	780	120	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
3114891	3114891	PRJNA577580_P_NODE_10603_length_282_cov_1.545455_g10525_i0	PRJNA577580	10603	282	1.545455	4.3581831	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	379	1.05e-100	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g10525	i0	91.103	93.3794326241135	281	24	99	1	2	282	1315200	1314921	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	26333	379	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4391550	4391550	PRJNA577580_P_NODE_7564_length_328_cov_1.529412_g7486_i0	PRJNA577580	7564	328	1.529412	5.01647136	Verrucomicrobiota	74201	Bacteria	Bacteria	186	1.65e-53	NR	MSU35657.1	2024890	g7486	i0	82.6	15.9512195121951	109	19	99.7	0	2	328	349	457	MSU35657.1 urease subunit alpha [Pedosphaera sp.]	diamond	5232	186	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.
4391568	4391568	PRJNA577580_P_NODE_9484_length_296_cov_3.143498_g9406_i0	PRJNA577580	9484	296	3.143498	9.30475408	Fontisphaera persica	2974023	Bacteria	Bacteria	361	4.02e-95	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g9406	i0	88.487	167.932432432432	304	27	100	2	1	296	3862987	3862684	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	49708	361	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
5667751	5667751	PRJNA577580_P_NODE_2745_length_545_cov_1.372881_g2667_i0	PRJNA577580	2745	545	1.372881	7.48220145	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	342	4.42e-117	NR	HEX5218415.1	2499141	g2667	i0	93.9	1.99266055045872	181	11	99.6	0	544	2	44	224	HEX5218415.1 ABC transporter ATP-binding protein [Verrucomicrobiia bacterium]	diamond	1086	342	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
6942204	6942204	PRJNA577580_P_NODE_16806_length_234_cov_2.869565_g16728_i0	PRJNA577580	16806	234	2.869565	6.7147821	Fontisphaera persica	2974023	Bacteria	Bacteria	137	5.62e-28	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g16728	i0	78.059	35.7051282051282	237	38	98	11	5	234	3862460	3862689	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	8355	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
8217241	8217241	PRJNA577580_P_NODE_5407_length_384_cov_3.077170_g5329_i0	PRJNA577580	5407	384	3.07717	11.8163328	Verrucomicrobiota	74201	Bacteria	Bacteria	207	2.61e-62	NR	EIP97614.1	278956	g5329	i0	80.3	15.875	127	25	99.2	0	382	2	205	331	EIP97614.1 nucleotide sugar dehydrogenase [Opitutaceae bacterium TAV1]	diamond	6096	208	0.995192307692308	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV1
9492375	9492375	PRJNA577580_P_NODE_1028_length_874_cov_4.686642_g963_i0	PRJNA577580	1028	874	4.686642	40.96125108	Methylacidiphilum caldifontis	2795386	Bacteria	Bacteria	54.7	0.025	NTclustered	gi\|1999107441\|gb\|CP065957.1\|	2795386	g963	i0	100	0.0331807780320366	29	0	3	0	458	486	88122	88150	Methylacidiphilum caldifontis strain IT6 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales	Methylacidiphilaceae	Methylacidiphilum (ex Ratnadevi et al. 2023)	Methylacidiphilum caldifontis
12043168	12043168	PRJNA577580_P_NODE_790_length_985_cov_3.639254_g734_i0	PRJNA577580	790	985	3.639254	35.8466519	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1447	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g734	i0	93.219	243.881218274112	988	60	99	7	4	985	1316328	1315342	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	240223	1447	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20264641	20264641	PRJNA577580_P_NODE_6456_length_354_cov_1.032028_g6378_i0	PRJNA577580	6456	354	1.032028	3.65337912	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	157	1.1e-42	NR	HXJ59385.1	2499141	g6378	i0	69.2	2.64406779661017	104	32	88.1	0	38	349	342	445	HXJ59385.1 efflux transporter outer membrane subunit [Verrucomicrobiia bacterium]	diamond	936	157	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
23516465	23516465	PRJNA577580_P_NODE_3639_length_472_cov_2.862155_g3561_i0	PRJNA577580	3639	472	2.862155	13.5093716	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	359	2.42e-94	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g3561	i0	87.5	148.845338983051	312	38	66	1	7	317	1315231	1314920	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	70255	359	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24790132	24790132	PRJNA577580_P_NODE_10460_length_284_cov_1.189573_g10382_i0	PRJNA577580	10460	284	1.189573	3.37838732	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	73.6	1.13e-13	NR	MBK8000252.1	2026799	g10382	i0	67.8	0.623239436619718	59	19	62.3	0	108	284	20	78	MBK8000252.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Verrucomicrobiota bacterium]	diamond	177	73.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
24790192	24790192	PRJNA577580_P_NODE_3860_length_458_cov_1.750649_g3782_i0	PRJNA577580	3860	458	1.750649	8.01797242	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	569	9.919999999999996e-158	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g3782	i0	89.254	67.410480349345	456	48	99	1	1	455	1316065	1316520	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	30874	569	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
27237643	27237643	PRJNA577580_P_NODE_7743_length_324_cov_1.968127_g7665_i0	PRJNA577580	7743	324	1.968127	6.37673148	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	52.8	2.78e-5	NR	HZO85033.1	2499141	g7665	i0	46	0.462962962962963	50	27	46.3	0	20	169	13	62	HZO85033.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	150	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27648502	27648502	PRJNA577580_P_NODE_9664_length_294_cov_1.565611_g9586_i0	PRJNA577580	9664	294	1.565611	4.60289634	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	73.9	5.74e-13	NR	HXR32065.1	2499141	g9586	i0	43.6	1.91836734693878	94	52	95.9	1	3	284	282	374	HXR32065.1 glycoside hydrolase family 27 protein [Verrucomicrobiia bacterium]	diamond	564	73.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27693669	27693669	PRJNA577580_P_NODE_15684_length_244_cov_2.842105_g15606_i0	PRJNA577580	15684	244	2.842105	6.9347362	root	1	Root_unresolved	Root_unresolved	56.2	6.6e-7	NR	MEI7552038.1	2026799	g15606	i0	37.2	3.70081967213115	78	43	95.9	2	236	3	760	831	MEI7552038.1 PQQ-binding-like beta-propeller repeat protein [Verrucomicrobiota bacterium]	diamond	903	56.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27711918	27711918	PRJNA577580_P_NODE_15464_length_245_cov_1.755814_g15386_i0	PRJNA577580	15464	245	1.755814	4.3017443	Opitutia bacterium	2026771	Bacteria	Bacteria	83.2	5.42e-17	NR	NCA83349.1	2026771	g15386	i0	59.7	4.60408163265306	72	28	88.2	1	23	238	69	139	NCA83349.1 methionyl-tRNA formyltransferase [Opitutia bacterium]	diamond	1128	83.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
28184836	28184836	PRJNA577580_P_NODE_15326_length_246_cov_0.901734_g15248_i0	PRJNA577580	15326	246	0.901734	2.21826564	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	131	9.19e-37	NR	MBK7997734.1	2026799	g15248	i0	92.8	0.841463414634146	69	5	84.1	0	245	39	36	104	MBK7997734.1 molybdopterin-dependent oxidoreductase [Verrucomicrobiota bacterium]	diamond	207	131	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28279604	28279604	PRJNA577580_P_NODE_8586_length_310_cov_1.189873_g8508_i0	PRJNA577580	8586	310	1.189873	3.6886063	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	165	6.02e-48	NR	HXJ59386.1	2499141	g8508	i0	92.1	1.72258064516129	89	7	86.1	0	308	42	214	302	HXJ59386.1 efflux RND transporter periplasmic adaptor subunit [Verrucomicrobiia bacterium]	diamond	534	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28482761	28482761	PRJNA577580_P_NODE_9886_length_291_cov_1.747706_g9808_i0	PRJNA577580	9886	291	1.747706	5.08582446	Bacteria	2	Bacteria	Bacteria	98.6	6.72e-23	NR	MEM9159604.1	2026799	g9808	i0	54.4	1.80412371134021	90	39	92.8	2	286	17	155	242	MEM9159604.1 IMP cyclohydrolase [Verrucomicrobiota bacterium]	diamond	525	99.4	0.991951710261569	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30079511	30079511	PRJNA577580_P_NODE_5692_length_375_cov_5.380795_g5614_i0	PRJNA577580	5692	375	5.380795	20.17798125	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	85.1	1.74e-17	NR	MBS0615478.1	2026799	g5614	i0	40	2.552	105	55	84	1	355	41	119	215	MBS0615478.1 carbonic anhydrase [Verrucomicrobiota bacterium]	diamond	957	85.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30237644	30237644	PRJNA577580_P_NODE_2452_length_578_cov_3.110891_g2374_i0	PRJNA577580	2452	578	3.110891	17.98094998	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	168	2.57e-44	NR	MDW8349745.1	2499141	g2374	i0	45	3.01038062283737	191	104	99.1	1	3	575	497	686	MDW8349745.1 S8 family serine peptidase [Verrucomicrobiia bacterium]	diamond	1740	168	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30301299	30301299	PRJNA577580_P_NODE_11972_length_267_cov_1.783505_g11894_i0	PRJNA577580	11972	267	1.783505	4.76195835	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	153	1.01e-44	NR	MBI3417133.1	2026799	g11894	i0	83.1	1	89	14	100	1	267	1	76	163	MBI3417133.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	267	153	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30396044	30396044	PRJNA577580_P_NODE_373_length_1285_cov_8.315182_g339_i0	PRJNA577580	373	1285	8.315182	106.8500887	Pedosphaera sp.	2024890	Bacteria	Bacteria	48.9	0.0068	NR	MSU27303.1	2024890	g339	i0	32.8	0.156420233463035	67	45	15.6	0	1272	1072	1	67	MSU27303.1 WG repeat-containing protein [Pedosphaera sp.]	diamond	201	48.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.
30490463	30490463	PRJNA577580_P_NODE_13193_length_255_cov_3.241758_g13115_i0	PRJNA577580	13193	255	3.241758	8.2664829	Akkermansia sp.	1872421	Bacteria	Bacteria	112	1.4e-28	NR	MBQ3524635.1	1872421	g13115	i0	59	0.976470588235294	83	29	97.6	1	251	3	90	167	MBQ3524635.1 glucosamine-6-phosphate deaminase [Akkermansia sp.]	diamond	249	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
30964467	30964467	PRJNA577580_P_NODE_11394_length_273_cov_1.560000_g11316_i0	PRJNA577580	11394	273	1.56	4.2588	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	75.5	1.63e-13	NR	MDW8349745.1	2499141	g11316	i0	44.2	0.945054945054945	86	47	93.4	1	14	268	577	662	MDW8349745.1 S8 family serine peptidase [Verrucomicrobiia bacterium]	diamond	258	75.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31059443	31059443	PRJNA577580_P_NODE_2755_length_544_cov_1.698514_g2677_i0	PRJNA577580	2755	544	1.698514	9.23991616	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	71.6	7.6e-11	NR	HJT81847.1	2201154	g2677	i0	41.1	1.18014705882353	107	55	57.4	2	230	541	738	839	HJT81847.1 SdrD B-like domain-containing protein [Chthoniobacterales bacterium]	diamond	642	71.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31311932	31311932	PRJNA577580_P_NODE_14495_length_249_cov_1.289773_g14417_i0	PRJNA577580	14495	249	1.289773	3.21153477	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	57.8	2.05e-7	NR	MBU1910439.1	2026799	g14417	i0	41.8	2.43373493975904	67	38	80.7	1	10	210	211	276	MBU1910439.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	606	57.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31311945	31311945	PRJNA577580_P_NODE_8075_length_318_cov_1.661224_g7997_i0	PRJNA577580	8075	318	1.661224	5.28269232	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	99.4	5.85e-23	NR	HEV3209181.1	2201154	g7997	i0	55.3	0.886792452830189	94	41	88.7	1	318	37	16	108	HEV3209181.1 SDR family oxidoreductase [Chthoniobacterales bacterium]	diamond	282	99.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31470315	31470315	PRJNA577580_P_NODE_16136_length_243_cov_0.917647_g16058_i0	PRJNA577580	16136	243	0.917647	2.22988221	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	42.4	0.0491	NR	HEY5895732.1	2201154	g16058	i0	33.3	0.777777777777778	63	38	77.8	1	230	42	104	162	HEY5895732.1 SIR2 family protein [Chthoniobacterales bacterium]	diamond	189	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31547070	31547070	PRJNA577580_P_NODE_15736_length_244_cov_1.590643_g15658_i0	PRJNA577580	15736	244	1.590643	3.88116892	Luteolibacter	518753	Bacteria	Bacteria	60.8	1.56e-8	NR	RYD48720.1	2026800	g15658	i0	39.5	2.98770491803279	81	46	99.6	1	244	2	462	539	RYD48720.1 MAG: hypothetical protein EOP83_26130, partial [Verrucomicrobiaceae bacterium]	diamond	729	61.2	0.993464052287582	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32293042	32293042	PRJNA577580_P_NODE_14939_length_247_cov_1.758621_g14861_i0	PRJNA577580	14939	247	1.758621	4.34379387	Luteolibacter sp.	1962973	Bacteria	Bacteria	53.5	6.2e-6	NR	WP_348212548.1	1962973	g14861	i0	46.7	0.910931174089069	75	37	88.7	3	244	26	350	423	WP_348212548.1 ankyrin repeat domain-containing protein [Luteolibacter sp.]	diamond	225	53.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
32496160	32496160	PRJNA577580_P_NODE_9139_length_301_cov_1.368421_g9061_i0	PRJNA577580	9139	301	1.368421	4.11894721	Bacteria	2	Bacteria	Bacteria	69.3	2.78e-11	NR	HEU5080173.1	2006848	g9061	i0	68.9	2.36212624584718	45	14	44.9	0	299	165	315	359	HEU5080173.1 chorismate synthase [Opitutaceae bacterium]	diamond	711	69.7	0.994261119081779	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae 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);;