metadata: contig_metadata: 24 rows where bioproject = "PRJNA874604", tax_clade = "PVC group" and tax

24 rows where bioproject = "PRJNA874604", 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
2127071	2127071	PRJNA874604_P_NODE_35662_length_323_cov_1.232000_g35310_i0	PRJNA874604	35662	323	1.232	3.97936	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	409	1.56e-109	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g35310	i0	89.571	89.7244582043344	326	29	100	5	1	323	3832266	3832589	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	28981	409	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2127579	2127579	PRJNA874604_P_NODE_62682_length_261_cov_1.622340_g62330_i0	PRJNA874604	62682	261	1.62234	4.2343074	Pedosphaera	1032526	Bacteria	Bacteria	112	6.480000000000001e-27	NR	MCH2377984.1	2024890	g62330	i0	62.4	8.41379310344828	85	32	97.7	0	259	5	326	410	MCH2377984.1 Glu/Leu/Phe/Val dehydrogenase [Pedosphaera sp.]	diamond	2196	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.
12331616	12331616	PRJNA874604_P_NODE_75710_length_249_cov_0.875000_g75358_i0	PRJNA874604	75710	249	0.875	2.17875	Akkermansia muciniphila	239935	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1805960388\|gb\|CP029703.1\|	239935	g75358	i0	100	99.9518072289157	249	0	100	0	1	249	2158953	2159201	Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome	blastn	24888	460	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
16153938	16153938	PRJNA874604_P_NODE_100113_length_241_cov_0.916667_g99761_i0	PRJNA874604	100113	241	0.916667	2.20916747	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	124	5.209999999999999e-31	NR	MDF2376347.1	2026801	g99761	i0	73.1	1.95435684647303	78	21	97.1	0	8	241	649	726	MDF2376347.1 cytochrome c [Verrucomicrobiales bacterium]	diamond	471	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
17429670	17429670	PRJNA874604_P_NODE_20894_length_396_cov_2.993808_g20542_i0	PRJNA874604	20894	396	2.993808	11.85547968	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	453	8.89e-123	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g20542	i0	87.469	66.8181818181818	399	43	100	6	1	396	3833088	3833482	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	26460	453	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21254959	21254959	PRJNA874604_P_NODE_93737_length_243_cov_0.905882_g93385_i0	PRJNA874604	93737	243	0.905882	2.20129326	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	327	3.25e-85	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g93385	i0	90.947	1	243	22	100	0	1	243	3185334	3185576	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	243	327	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
23804221	23804221	PRJNA874604_P_NODE_50659_length_283_cov_1.209524_g50307_i0	PRJNA874604	50659	283	1.209524	3.42295292	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	468	2.19e-127	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g50307	i0	96.466	2.77031802120141	283	10	100	0	1	283	2345841	2346123	Luteolibacter sp. SL250 chromosome	blastn	784	468	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
25078133	25078133	PRJNA874604_P_NODE_53120_length_278_cov_1.502439_g52768_i0	PRJNA874604	53120	278	1.502439	4.17678042	Opitutaceae bacterium TAV5	794903	Bacteria	Bacteria	411	3.659999999999999e-110	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g52768	i0	93.478	98.5575539568345	276	18	99	0	1	276	2676580	2676855	Opitutaceae bacterium TAV5, complete genome	blastn	27399	411	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
26738263	26738263	PRJNA874604_P_NODE_76841_length_249_cov_0.863636_g76489_i0	PRJNA874604	76841	249	0.863636	2.15045364	Akkermansia sp.	1872421	Bacteria	Bacteria	138	1.88e-37	NR	WP_417005459.1	1872421	g76489	i0	86.6	1.96385542168675	82	11	98.8	0	3	248	132	213	WP_417005459.1 DUF3644 domain-containing protein [Akkermansia sp.]	diamond	489	138	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
26770401	26770401	PRJNA874604_P_NODE_95061_length_242_cov_1.644970_g94709_i0	PRJNA874604	95061	242	1.64497	3.9808274	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	44.7	0.00242	NR	MEO6754186.1	2811408	g94709	i0	37.5	0.694214876033058	56	35	69.4	0	25	192	16	71	MEO6754186.1 hypothetical protein [Chthoniobacteraceae bacterium]	diamond	168	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
27813603	27813603	PRJNA874604_P_NODE_97064_length_242_cov_0.911243_g96712_i0	PRJNA874604	97064	242	0.911243	2.20520806	Opitutaceae bacterium	2006848	Bacteria	Bacteria	64.3	9.33e-10	NR	MBK8477075.1	2006848	g96712	i0	44	2.05785123966942	84	43	99.2	2	240	1	384	467	MBK8477075.1 SMP-30/gluconolactonase/LRE family protein [Opitutaceae bacterium]	diamond	498	64.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28318479	28318479	PRJNA874604_P_NODE_60906_length_264_cov_1.612565_g60554_i0	PRJNA874604	60906	264	1.612565	4.2571716	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	43.1	0.0352	NR	MBL6763801.1	2499141	g60554	i0	31.8	0.75	66	45	75	0	249	52	22	87	MBL6763801.1 glycoside hydrolase family 130 protein [Verrucomicrobiia bacterium]	diamond	198	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28642473	28642473	PRJNA874604_P_NODE_49147_length_286_cov_1.098592_g48795_i0	PRJNA874604	49147	286	1.098592	3.14197312	Bacteria	2	Bacteria	Bacteria	47.8	0.00105	NR	MEZ5434667.1	2026801	g48795	i0	30.5	1.99300699300699	95	62	99.7	1	286	2	151	241	MEZ5434667.1 tetratricopeptide repeat protein [Verrucomicrobiales bacterium]	diamond	570	47.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
29210833	29210833	PRJNA874604_P_NODE_86109_length_245_cov_1.622093_g85757_i0	PRJNA874604	86109	245	1.622093	3.97412785	Luteolibacter	518753	Bacteria	Bacteria	108	4.14e-26	NR	MEK6230939.1	1962973	g85757	i0	57.9	6.34285714285714	76	32	93.1	0	17	244	1	76	MEK6230939.1 NAD(P)-dependent alcohol dehydrogenase [Luteolibacter sp.]	diamond	1554	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
29518253	29518253	PRJNA874604_P_NODE_59770_length_266_cov_1.595855_g59418_i0	PRJNA874604	59770	266	1.595855	4.2449743	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	76.6	5.05e-14	NR	MBM3831845.1	2026799	g59418	i0	47.7	2.0187969924812	88	38	99.2	1	264	1	151	230	MBM3831845.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	537	76.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29549730	29549730	PRJNA874604_P_NODE_85070_length_246_cov_0.890173_g84718_i0	PRJNA874604	85070	246	0.890173	2.18982558	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	102	1.57e-25	NR	HEV2390943.1	2499141	g84718	i0	59.8	2	82	33	100	0	246	1	33	114	HEV2390943.1 response regulator [Verrucomicrobiia bacterium]	diamond	492	102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29549733	29549733	PRJNA874604_P_NODE_88270_length_245_cov_0.895349_g87918_i0	PRJNA874604	88270	245	0.895349	2.19360505	Luteolibacter pohnpeiensis	454153	Bacteria	Bacteria	48.5	2.77e-4	NR	WP_200273321.1	454153	g87918	i0	33	1.18775510204082	97	46	95.5	3	9	242	136	232	WP_200273321.1 glycosyltransferase family 32 protein [Luteolibacter pohnpeiensis]	diamond	291	48.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter pohnpeiensis
30086732	30086732	PRJNA874604_P_NODE_44432_length_296_cov_2.582960_g44080_i0	PRJNA874604	44432	296	2.58296	7.6455616	Opitutales bacterium	2026772	Bacteria	Bacteria	50.1	1.83e-4	NR	MCC5808074.1	2026772	g44080	i0	54.4	0.577702702702703	57	26	57.8	0	124	294	343	399	MCC5808074.1 hypothetical protein [Opitutales bacterium]	diamond	171	50.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
30687016	30687016	PRJNA874604_P_NODE_64633_length_258_cov_1.194595_g64281_i0	PRJNA874604	64633	258	1.194595	3.0820551	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	95.1	1.56e-20	NR	HXP81690.1	2499141	g64281	i0	56.6	0.883720930232558	76	32	87.2	1	226	2	199	274	HXP81690.1 kelch repeat-containing protein [Verrucomicrobiia bacterium]	diamond	228	95.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30758437	30758437	PRJNA874604_P_NODE_70374_length_251_cov_0.865169_g70022_i0	PRJNA874604	70374	251	0.865169	2.17157419	Pseudomonadati	3379134	Bacteria	Bacteria	76.6	4.78e-14	NR	MES1166212.1	2026799	g70022	i0	49.5	2.17529880478088	91	38	99.2	3	249	1	506	596	MES1166212.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	546	76.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31264009	31264009	PRJNA874604_P_NODE_83975_length_246_cov_0.890173_g83623_i0	PRJNA874604	83975	246	0.890173	2.18982558	PVC group	1783257	Bacteria	Bacteria	95.5	4.2e-21	NR	HKB90947.1	2006848	g83623	i0	60.5	2.78048780487805	76	30	92.7	0	229	2	233	308	HKB90947.1 TIGR03364 family FAD-dependent oxidoreductase [Opitutaceae bacterium]	diamond	684	95.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31422103	31422103	PRJNA874604_P_NODE_97116_length_242_cov_0.911243_g96764_i0	PRJNA874604	97116	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	79.7	2.36e-15	NR	PAW70949.1	1982322	g96764	i0	87	1.1404958677686	46	6	57	0	241	104	322	367	PAW70949.1 MAG: hypothetical protein B9S35_14270 [Opitutia bacterium Tous-C5TDCM]	diamond	276	79.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium Tous-C5TDCM
31730239	31730239	PRJNA874604_P_NODE_53837_length_277_cov_1.377451_g53485_i0	PRJNA874604	53837	277	1.377451	3.81553927	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.1	0.0412	NR	MBV9490687.1	2026799	g53485	i0	33.3	0.617328519855596	57	36	61.7	1	40	210	291	345	MBV9490687.1 ABC transporter ATP-binding protein/permease [Verrucomicrobiota bacterium]	diamond	171	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32553271	32553271	PRJNA874604_P_NODE_88479_length_245_cov_0.895349_g88127_i0	PRJNA874604	88479	245	0.895349	2.19360505	Chthoniobacter flavus	191863	Bacteria	Bacteria	44.3	0.0113	NR	WP_131989126.1	191863	g88127	i0	45.6	1.39591836734694	57	26	69.8	2	66	236	1428	1479	WP_131989126.1 autotransporter domain-containing protein [Chthoniobacter flavus]	diamond	342	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus

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