metadata: contig_metadata: 18 rows where bioproject = "PRJNA1111082", tax_clade = "PVC group" and tax

18 rows where bioproject = "PRJNA1111082", 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
4042248	4042248	PRJNA1111082_P_NODE_7104_length_303_cov_1.134783_g7059_i0	PRJNA1111082	7104	303	1.134783	3.43839249	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	303	7.06e-78	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g7059	i0	85.099	4.89108910891089	302	39	99	4	1	299	3216247	3216545	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1482	303	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
9142963	9142963	PRJNA1111082_P_NODE_3188_length_430_cov_1.092437_g3143_i0	PRJNA1111082	3188	430	1.092437	4.6974791	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	326	2.21e-84	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g3143	i0	81.022	2.81860465116279	411	76	95	2	21	430	4559574	4559983	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1212	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
12969241	12969241	PRJNA1111082_P_NODE_4611_length_366_cov_0.962457_g4566_i0	PRJNA1111082	4611	366	0.962457	3.52259262	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	222	2.5e-53	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g4566	i0	84.932	43.4535519125683	219	33	60	0	131	349	1050706	1050488	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	15904	222	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15518037	15518037	PRJNA1111082_P_NODE_6733_length_310_cov_1.729958_g6688_i0	PRJNA1111082	6733	310	1.729958	5.3628698	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	512	1.11e-140	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g6688	i0	96.452	231.81935483871	310	11	100	0	1	310	2748601	2748292	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	71864	512	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
26878205	26878205	PRJNA1111082_P_NODE_10181_length_255_cov_1.236264_g10136_i0	PRJNA1111082	10181	255	1.236264	3.1524732	Luteolibacter flavescens	1859460	Bacteria	Bacteria	86.3	4.46e-19	NR	WP_264499937.1	1859460	g10136	i0	49.4	0.976470588235294	83	42	97.6	0	253	5	48	130	WP_264499937.1 hypothetical protein [Luteolibacter flavescens]	diamond	249	86.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter flavescens
27573300	27573300	PRJNA1111082_P_NODE_6884_length_307_cov_1.303419_g6839_i0	PRJNA1111082	6884	307	1.303419	4.00149633	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	62.4	1.04e-8	NR	HYE22022.1	2499141	g6839	i0	55.7	0.596091205211726	61	27	59.6	0	184	2	682	742	HYE22022.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	183	62.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28109917	28109917	PRJNA1111082_P_NODE_10565_length_252_cov_0.871508_g10520_i0	PRJNA1111082	10565	252	0.871508	2.19620016	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	81.6	6.16e-16	NR	MES2706727.1	2026799	g10520	i0	47.1	1.03571428571429	87	37	98.8	2	3	251	88	169	MES2706727.1 PDZ domain-containing protein [Verrucomicrobiota bacterium]	diamond	261	81.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29017303	29017303	PRJNA1111082_P_NODE_8248_length_282_cov_1.784689_g8203_i0	PRJNA1111082	8248	282	1.784689	5.03282298	Haloferula	574899	Bacteria	Bacteria	89.7	2.37e-20	NR	RYD84606.1	2026800	g8203	i0	66.2	1.38297872340426	65	22	69.1	0	22	216	91	155	RYD84606.1 MAG: hypothetical protein EOP84_05050 [Verrucomicrobiaceae bacterium]	diamond	390	90.5	0.991160220994475	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29593656	29593656	PRJNA1111082_P_NODE_4290_length_378_cov_1.022951_g4245_i0	PRJNA1111082	4290	378	1.022951	3.86675478	Candidatus Didemnitutus sp.	2814259	Bacteria	Bacteria	114	7.630000000000001e-27	NR	MDP1580708.1	2814259	g4245	i0	53.2	0.880952380952381	111	47	84.1	2	61	378	21	131	MDP1580708.1 hypothetical protein [Candidatus Didemnitutus sp.]	diamond	333	114	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Candidatus Didemnitutus	Candidatus Didemnitutus sp.
29625140	29625140	PRJNA1111082_P_NODE_11090_length_249_cov_1.767045_g11045_i0	PRJNA1111082	11090	249	1.767045	4.39994205	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	99.8	9.5e-23	NR	MCX6874534.1	2026799	g11045	i0	61.5	0.939759036144578	78	30	94	0	11	244	283	360	MCX6874534.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	234	99.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29720081	29720081	PRJNA1111082_P_NODE_10350_length_253_cov_1.055556_g10305_i0	PRJNA1111082	10350	253	1.055556	2.67055668	Akkermansia muciniphila	239935	Bacteria	Bacteria	44.7	9.53e-4	NR	QHV64829.1	239935	g10305	i0	68.6	0.41501976284585	35	11	41.5	0	251	147	34	68	QHV64829.1 transcriptional regulator [Akkermansia muciniphila]	diamond	105	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
30058854	30058854	PRJNA1111082_P_NODE_12151_length_244_cov_1.216374_g12106_i0	PRJNA1111082	12151	244	1.216374	2.96795256	Luteolibacter	518753	Bacteria	Bacteria	114	1.4700000000000002e-27	NR	WP_200272054.1	454153	g12106	i0	69	2.04098360655738	84	23	99.6	2	2	244	379	462	WP_200272054.1 hypothetical protein [Luteolibacter pohnpeiensis]	diamond	498	115	0.991304347826087	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter pohnpeiensis
30099216	30099216	PRJNA1111082_P_NODE_10092_length_256_cov_1.163934_g10047_i0	PRJNA1111082	10092	256	1.163934	2.97967104	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	58.2	4.42e-8	NR	MEY2905681.1	2026799	g10047	i0	76.5	0.3984375	34	8	39.8	0	107	6	3	36	MEY2905681.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	102	58.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30604818	30604818	PRJNA1111082_P_NODE_8813_length_274_cov_1.164179_g8768_i0	PRJNA1111082	8813	274	1.164179	3.18985046	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	80.1	3.97e-15	NR	MEI6607885.1	2026799	g8768	i0	47	0.908759124087591	83	43	89.8	1	25	270	632	714	MEI6607885.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	249	80.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30975407	30975407	PRJNA1111082_P_NODE_2754_length_458_cov_1.976623_g2709_i0	PRJNA1111082	2754	458	1.976623	9.05293334	Verrucomicrobiota	74201	Bacteria	Bacteria	239	4.509999999999999e-74	NR	WP_075080497.1	690879	g2709	i0	77.2	2.84934497816594	145	32	94.3	1	12	443	131	275	WP_075080497.1 outer membrane beta-barrel protein [Terrimicrobium sacchariphilum]	diamond	1305	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sacchariphilum
31417829	31417829	PRJNA1111082_P_NODE_11336_length_248_cov_0.891429_g11291_i0	PRJNA1111082	11336	248	0.891429	2.21074392	Verrucomicrobiota	74201	Bacteria	Bacteria	46.6	0.00131	NR	WP_256200393.1	2736	g11291	i0	68.8	2.20161290322581	32	10	38.7	0	163	68	172	203	WP_256200393.1 hypothetical protein [Verrucomicrobium spinosum]	diamond	546	46.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
32154247	32154247	PRJNA1111082_P_NODE_8038_length_286_cov_1.098592_g7993_i0	PRJNA1111082	8038	286	1.098592	3.14197312	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	47.8	7.3e-5	NR	WP_009963016.1	2736	g7993	i0	54.8	0.440559440559441	42	19	44.1	0	94	219	22	63	WP_009963016.1 hypothetical protein [Verrucomicrobium spinosum]	diamond	126	47.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
32407415	32407415	PRJNA1111082_P_NODE_7039_length_304_cov_1.528139_g6994_i0	PRJNA1111082	7039	304	1.528139	4.64554256	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	49.7	2.79e-4	NR	KAB2673889.1	2026799	g6994	i0	31.6	0.9375	95	62	93.8	1	19	303	396	487	KAB2673889.1 MAG: hypothetical protein DVB31_02920 [Verrucomicrobiota bacterium]	diamond	285	49.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;