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

21 rows where bioproject = "PRJNA1158727", 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
303549	303549	PRJNA1158727_P_NODE_122061_length_265_cov_1.260417_g114600_i0	PRJNA1158727	122061	265	1.260417	3.34010505	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	107	1.26e-24	NR	MFM7181164.1	2026801	g114600	i0	64.2	1.91320754716981	81	29	91.7	0	264	22	3523	3603	MFM7181164.1 filamentous hemagglutinin family protein [Verrucomicrobiales bacterium]	diamond	507	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
2855194	2855194	PRJNA1158727_P_NODE_157143_length_243_cov_0.905882_g149681_i0	PRJNA1158727	157143	243	0.905882	2.20129326	Opitutaceae bacterium	2006848	Bacteria	Bacteria	134	1.67e-34	NR	HEX9784308.1	2006848	g149681	i0	78.8	4.9382716049382704	80	17	98.8	0	241	2	375	454	HEX9784308.1 isoleucine--tRNA ligase [Opitutaceae bacterium]	diamond	1200	134	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
9965696	9965696	PRJNA1158727_P_NODE_143908_length_248_cov_0.880000_g136446_i0	PRJNA1158727	143908	248	0.88	2.1824	Opitutia bacterium	2026771	Bacteria	Bacteria	110	2.9e-27	NR	MBI5423102.1	2026771	g136446	i0	77.9	1.64516129032258	68	15	82.3	0	247	44	13	80	MBI5423102.1 pantoate--beta-alanine ligase [Opitutia bacterium]	diamond	408	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
11782523	11782523	PRJNA1158727_P_NODE_135670_length_251_cov_0.865169_g128208_i0	PRJNA1158727	135670	251	0.865169	2.17157419	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	226	1.2699999999999999e-54	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g128208	i0	83.004	3.25498007968128	253	39	100	4	1	251	7901533	7901283	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	817	226	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
27281057	27281057	PRJNA1158727_P_NODE_144063_length_248_cov_0.880000_g136601_i0	PRJNA1158727	144063	248	0.88	2.1824	Prosthecobacter	48463	Bacteria	Bacteria	159	4.27e-43	NR	WP_294380376.1	1965333	g136601	i0	89	14.8548387096774	82	9	99.2	0	2	247	802	883	WP_294380376.1 sulfatase-like hydrolase/transferase [Prosthecobacter sp.]	diamond	3684	160	0.99375	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
27293190	27293190	PRJNA1158727_P_NODE_106103_length_284_cov_1.473934_g98642_i0	PRJNA1158727	106103	284	1.473934	4.18597256	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	112	4.66e-28	NR	HEY8903241.1	2201154	g98642	i0	58.5	3.97183098591549	94	39	99.3	0	2	283	67	160	HEY8903241.1 SDR family oxidoreductase [Chthoniobacterales bacterium]	diamond	1128	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
27735609	27735609	PRJNA1158727_P_NODE_115144_length_273_cov_1.520000_g107683_i0	PRJNA1158727	115144	273	1.52	4.1496	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	158	8.82e-43	NR	HEY2569136.1	2665650	g107683	i0	92.2	0.989010989010989	90	7	98.9	0	272	3	341	430	HEY2569136.1 ABC transporter permease [Candidatus Udaeobacter sp.]	diamond	270	158	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
28335199	28335199	PRJNA1158727_P_NODE_122026_length_265_cov_1.317708_g114565_i0	PRJNA1158727	122026	265	1.317708	3.4919262	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	82	7.08e-16	NR	KAB2638976.1	2026799	g114565	i0	67.3	2.49056603773585	55	18	62.3	0	263	99	603	657	KAB2638976.1 MAG: transketolase [Verrucomicrobiota bacterium]	diamond	660	82	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28651017	28651017	PRJNA1158727_P_NODE_157687_length_243_cov_0.905882_g150225_i0	PRJNA1158727	157687	243	0.905882	2.20129326	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	98.6	5.79e-22	NR	WP_338288885.1	2819286	g150225	i0	82	1.50617283950617	61	11	75.3	0	2	184	411	471	WP_338288885.1 hypothetical protein [Luteolibacter sp. LG18]	diamond	366	98.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
28777169	28777169	PRJNA1158727_P_NODE_141647_length_249_cov_0.875000_g134185_i0	PRJNA1158727	141647	249	0.875	2.17875	Prosthecobacter debontii	48467	Bacteria	Bacteria	164	4.08e-45	NR	WP_078812045.1	48467	g134185	i0	97.6	1	83	2	100	0	249	1	566	648	WP_078812045.1 vWA domain-containing protein [Prosthecobacter debontii]	diamond	249	164	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
29219442	29219442	PRJNA1158727_P_NODE_108889_length_281_cov_1.173077_g101428_i0	PRJNA1158727	108889	281	1.173077	3.29634637	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	132	2.51e-33	NR	MBI5687343.1	2026799	g101428	i0	67.7	3.96085409252669	93	29	98.2	1	4	279	586	678	MBI5687343.1 DUF4838 domain-containing protein [Verrucomicrobiota bacterium]	diamond	1113	132	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30040320	30040320	PRJNA1158727_P_NODE_138731_length_250_cov_0.870056_g131269_i0	PRJNA1158727	138731	250	0.870056	2.17514	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	176	4.14e-51	NR	RYD49461.1	2026800	g131269	i0	96.4	1.992	83	3	99.6	0	2	250	322	404	RYD49461.1 MAG: carbohydrate porin [Verrucomicrobiaceae bacterium]	diamond	498	176	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30261736	30261736	PRJNA1158727_P_NODE_106372_length_284_cov_1.327014_g98911_i0	PRJNA1158727	106372	284	1.327014	3.76871976	Chthoniobacter sp.	2510640	Bacteria	Bacteria	92.8	5.65e-22	NR	WP_348544159.1	2510640	g98911	i0	60.5	0.802816901408451	76	29	79.2	1	226	2	17	92	WP_348544159.1 hypothetical protein [Chthoniobacter sp.]	diamond	228	92.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
30608931	30608931	PRJNA1158727_P_NODE_141633_length_249_cov_0.875000_g134171_i0	PRJNA1158727	141633	249	0.875	2.17875	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	45.1	0.00586	NR	MDF1753436.1	2026801	g134171	i0	34.2	0.91566265060241	76	41	88	2	6	224	330	399	MDF1753436.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	228	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30956794	30956794	PRJNA1158727_P_NODE_149954_length_246_cov_0.890173_g142492_i0	PRJNA1158727	149954	246	0.890173	2.18982558	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	127	9.999999999999999e-34	NR	MES2921495.1	2026799	g142492	i0	75.6	4.98780487804878	82	20	100	0	246	1	109	190	MES2921495.1 GH25 family lysozyme [Verrucomicrobiota bacterium]	diamond	1227	127	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31208912	31208912	PRJNA1158727_P_NODE_119535_length_268_cov_1.184615_g112074_i0	PRJNA1158727	119535	268	1.184615	3.1747682	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	145	2.5499999999999998e-40	NR	RYD65414.1	2026800	g112074	i0	85.2	0.985074626865672	88	13	98.5	0	5	268	56	143	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	264	145	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
31430700	31430700	PRJNA1158727_P_NODE_118876_length_268_cov_3.733333_g111415_i0	PRJNA1158727	118876	268	3.733333	10.00533244	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	77.4	1.66e-14	NR	MBI60809.1	2026801	g111415	i0	50.7	2.36194029850746	69	34	77.2	0	62	268	108	176	MBI60809.1 phosphate starvation-inducible protein PhoH [Verrucomicrobiales bacterium]	diamond	633	77.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31873556	31873556	PRJNA1158727_P_NODE_143497_length_248_cov_0.880000_g136035_i0	PRJNA1158727	143497	248	0.88	2.1824	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	157	1.43e-42	NR	HEY3662717.1	2201154	g136035	i0	92.7	0.991935483870968	82	6	99.2	0	246	1	621	702	HEY3662717.1 protein kinase [Chthoniobacterales bacterium]	diamond	246	157	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32190060	32190060	PRJNA1158727_P_NODE_119678_length_268_cov_0.994872_g112217_i0	PRJNA1158727	119678	268	0.994872	2.66625696	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	143	1.42e-39	NR	RYD65414.1	2026800	g112217	i0	78.4	0.985074626865672	88	19	98.5	0	264	1	210	297	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	264	143	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32632412	32632412	PRJNA1158727_P_NODE_142580_length_248_cov_1.577143_g135118_i0	PRJNA1158727	142580	248	1.577143	3.91131464	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	129	1.58e-33	NR	HZJ14823.1	2811408	g135118	i0	69.5	0.991935483870968	82	25	99.2	0	3	248	187	268	HZJ14823.1 metallophosphoesterase family protein [Chthoniobacteraceae bacterium]	diamond	246	129	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
32884403	32884403	PRJNA1158727_P_NODE_111500_length_277_cov_3.348039_g104039_i0	PRJNA1158727	111500	277	3.348039	9.27406803	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	87	7.24e-18	NR	RYD71398.1	2026800	g104039	i0	49	1.03971119133574	96	38	98.6	4	275	3	169	258	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	288	87	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae 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);;