metadata: contig_metadata: 21 rows where bioproject = "PRJNA627467", tax_clade = "PVC group" and tax

21 rows where bioproject = "PRJNA627467", 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
1150898	1150898	PRJNA627467_P_NODE_4421_length_316_cov_1.749064_g4353_i0	PRJNA627467	4421	316	1.749064	5.52704224	Candidatus Moanibacter	2480624	Bacteria	Bacteria	145	4.75e-30	NTclustered	gi\|2225500096\|gb\|CP095464.1\|	2026799	g4353	i0	95.604	18.6708860759494	91	2	28	1	222	310	594141	594051	MAG: Verrucomicrobia bacterium isolate LL51 chromosome, complete genome	blastn	5900	145	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
5702714	5702714	PRJNA627467_P_NODE_12205_length_180_cov_2.259542_g12136_i0	PRJNA627467	12205	180	2.259542	4.0671756	Fontisphaera persica	2974023	Bacteria	Bacteria	281	1.79e-71	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g12136	i0	95.48	232.361111111111	177	7	98	1	5	180	3861932	3861756	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	41825	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
6977659	6977659	PRJNA627467_P_NODE_20926_length_154_cov_3.704762_g20857_i0	PRJNA627467	20926	154	3.704762	5.70533348	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	191	2.57e-44	NTclustered	gi\|2518556548\|emb\|OX638380.1\|	412056	g20857	i0	88.961	99.7012987012987	154	17	100	0	1	154	3920482	3920635	MAG: uncultured Verrucomicrobiae bacterium isolate efd5e50e-5b6a-4a0f-a0a2-e496bae301b3 genome assembly, chromosome: 1	blastn	15354	191	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10803404	10803404	PRJNA627467_P_NODE_2449_length_316_cov_2.614232_g2381_i0	PRJNA627467	2449	316	2.614232	8.26097312	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	71.3	8.17e-8	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g2381	i0	85.333	0.569620253164557	75	3	22	5	25	95	4019792	4019722	Lacunisphaera limnophila strain IG16b, complete genome	blastn	180	71.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
14628043	14628043	PRJNA627467_P_NODE_12892_length_178_cov_1.550388_g12823_i0	PRJNA627467	12892	178	1.550388	2.75969064	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	209	8.44e-50	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g12823	i0	88.439	21.6741573033708	173	20	97	0	6	178	2711	2539	Luteolibacter sp. SL250 chromosome	blastn	3858	209	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
15902068	15902068	PRJNA627467_P_NODE_13333_length_176_cov_2.913386_g13264_i0	PRJNA627467	13333	176	2.913386	5.12755936	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	191	3.02e-44	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g13264	i0	87.006	61.875	177	13	98	7	4	175	3047994	3047823	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	10890	191	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
17177122	17177122	PRJNA627467_P_NODE_19194_length_161_cov_1.785714_g19125_i0	PRJNA627467	19194	161	1.785714	2.87499954	Pedosphaera parvula	1032527	Bacteria	Bacteria	182	1.64e-41	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g19125	i0	90	13.944099378882	140	14	87	0	18	157	2372	2233	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	2245	182	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
26744893	26744893	PRJNA627467_P_NODE_11621_length_182_cov_2.165414_g11552_i0	PRJNA627467	11621	182	2.165414	3.94105348	Pseudomonadati	3379134	Bacteria	Bacteria	75.9	1.2e-16	NR	ADI16723.1	710995	g11552	i0	72	1.45054945054945	50	14	82.4	0	154	5	1	50	ADI16723.1 hypothetical protein [uncultured Verrucomicrobiales bacterium HF0010_05E02]	diamond	264	75.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			uncultured Verrucomicrobiales bacterium HF0010_05E02
26891015	26891015	PRJNA627467_P_NODE_12341_length_180_cov_1.251908_g12272_i0	PRJNA627467	12341	180	1.251908	2.2534344	Opitutus sp. ER46	2161864	Bacteria	Bacteria	108	1.04e-25	NR	WP_107834408.1	2161864	g12272	i0	93.1	0.966666666666667	58	4	96.7	0	5	178	825	882	WP_107834408.1 valine--tRNA ligase [Opitutus sp. ER46]	diamond	174	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. ER46
26953840	26953840	PRJNA627467_P_NODE_2902_length_316_cov_2.299625_g2834_i0	PRJNA627467	2902	316	2.299625	7.266815	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	75.5	1.37e-13	NR	GBL26153.1	2026799	g2834	i0	93.8	1.23417721518987	32	2	30.4	0	314	219	150	181	GBL26153.1 hypothetical protein EMGBS8_01010 [Verrucomicrobiota bacterium]	diamond	390	75.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27156250	27156250	PRJNA627467_P_NODE_19342_length_161_cov_0.910714_g19273_i0	PRJNA627467	19342	161	0.910714	1.46624954	Bacteria	2	Bacteria	Bacteria	88.2	8.99e-19	NR	PYL05533.1	2026799	g19273	i0	73.6	4.91925465838509	53	14	98.8	0	159	1	60	112	PYL05533.1 MAG: hypothetical protein DME34_11235, partial [Verrucomicrobiota bacterium]	diamond	792	88.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27333642	27333642	PRJNA627467_P_NODE_2303_length_316_cov_2.771536_g2235_i0	PRJNA627467	2303	316	2.7715360000000002	8.75805376	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	65.9	6.33e-10	NR	MEP7014928.1	2026799	g2235	i0	93.8	3.34177215189873	32	2	30.4	0	219	314	214	245	MEP7014928.1 NCS1 family nucleobase:cation symporter-1 [Verrucomicrobiota bacterium]	diamond	1056	65.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27586172	27586172	PRJNA627467_P_NODE_20804_length_155_cov_2.339623_g20735_i0	PRJNA627467	20804	155	2.339623	3.62641565	Spartobacteria bacterium	2052183	Bacteria	Bacteria	73.9	2.37e-15	NR	NBS53893.1	2052183	g20735	i0	92.1	0.735483870967742	38	3	73.5	0	40	153	1	38	NBS53893.1 DUF2442 domain-containing protein [Spartobacteria bacterium]	diamond	114	73.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria				Spartobacteria bacterium
27996700	27996700	PRJNA627467_P_NODE_20645_length_155_cov_4.509434_g20576_i0	PRJNA627467	20645	155	4.509434	6.9896227	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	83.6	4.54e-17	NR	MFM2198789.1	2026799	g20576	i0	76	0.967741935483871	50	12	96.8	0	153	4	908	957	MFM2198789.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	150	83.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28009543	28009543	PRJNA627467_P_NODE_14805_length_171_cov_3.598361_g14736_i0	PRJNA627467	14805	171	3.598361	6.15319731	root	1	Root_unresolved	Root_unresolved	73.6	1.89e-13	NR	WP_205576064.1	239935	g14736	i0	69.2	6.35087719298246	52	14	91.2	1	5	160	578	627	WP_205576064.1 hypothetical protein [Akkermansia muciniphila]	diamond	1086	74.3	0.990578734858681	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
28754340	28754340	PRJNA627467_P_NODE_9307_length_190_cov_2.198582_g9238_i0	PRJNA627467	9307	190	2.198582	4.1773058	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	97.8	1.93e-24	NR	HEU4772675.1	2665650	g9238	i0	91.9	1.95789473684211	62	5	97.9	0	187	2	16	77	HEU4772675.1 hypothetical protein [Candidatus Udaeobacter sp.]	diamond	372	97.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
28944111	28944111	PRJNA627467_P_NODE_21228_length_153_cov_2.711538_g21159_i0	PRJNA627467	21228	153	2.711538	4.14865314	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	100	2.4599999999999994e-23	NR	HEV8419696.1	2665650	g21159	i0	89.8	1.92156862745098	49	5	96.1	0	148	2	31	79	HEV8419696.1 NnrS family protein [Candidatus Udaeobacter sp.]	diamond	294	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
30491403	30491403	PRJNA627467_P_NODE_9613_length_189_cov_1.821429_g9544_i0	PRJNA627467	9613	189	1.821429	3.44250081	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	75.5	5.13e-14	NR	HXI73658.1	2499141	g9544	i0	63.3	0.952380952380952	60	22	95.2	0	6	185	168	227	HXI73658.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	180	75.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31818925	31818925	PRJNA627467_P_NODE_4697_length_316_cov_1.692884_g4629_i0	PRJNA627467	4697	316	1.692884	5.34951344	Opitutales bacterium	2026772	Bacteria	Bacteria	45.8	0.0072	NR	MFP4157167.1	2026772	g4629	i0	70	0.588607594936709	30	9	28.5	0	314	225	953	982	MFP4157167.1 chemotaxis protein CheW [Opitutales bacterium]	diamond	186	45.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
32135524	32135524	PRJNA627467_P_NODE_10258_length_187_cov_1.376812_g10189_i0	PRJNA627467	10258	187	1.376812	2.57463844	Roseimicrobium sp.	3069589	Bacteria	Bacteria	75.9	2.05e-14	NR	HSH95181.1	3069589	g10189	i0	55.7	1.9572192513369	61	27	97.9	0	186	4	101	161	HSH95181.1 DUF6268 family outer membrane beta-barrel protein [Roseimicrobium sp.]	diamond	366	75.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp.
32874410	32874410	PRJNA627467_P_NODE_9480_length_189_cov_3.564286_g9411_i0	PRJNA627467	9480	189	3.564286	6.73650054	Prosthecobacter	48463	Bacteria	Bacteria	71.2	6.4e-13	NR	MFN7563283.1	1965333	g9411	i0	68.1	2.23809523809524	47	15	74.6	0	27	167	87	133	MFN7563283.1 hypothetical protein [Prosthecobacter sp.]	diamond	423	71.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.

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