metadata: contig_metadata: 34 rows where bioproject = "PRJNA846486" and tax

34 rows where bioproject = "PRJNA846486" 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
2506937	2506937	PRJNA846486_P_NODE_70402_length_174_cov_1.248000_g70306_i0	PRJNA846486	70402	174	1.248	2.17152	Opitutus	178440	Bacteria	Bacteria	145	2.35e-30	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g70306	i0	82.249	7.66091954022988	169	29	97	1	1	168	1371	1203	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	1333	145	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
5936471	5936471	PRJNA846486_P_NODE_58405_length_187_cov_1.130435_g58309_i0	PRJNA846486	58405	187	1.130435	2.11391345	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	111	2.6e-20	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g58309	i0	83.471	1.62032085561497	121	18	64	2	1	120	300727	300846	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	303	111	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
26611402	26611402	PRJNA846486_P_NODE_64201_length_180_cov_1.458015_g64105_i0	PRJNA846486	64201	180	1.458015	2.624427	Prosthecobacter sp.	1965333	Bacteria	Bacteria	110	1.02e-26	NR	WP_409213618.1	1965333	g64105	i0	98.2	0.933333333333333	56	1	93.3	0	169	2	98	153	WP_409213618.1 UDP-2,4-diacetamido-2,4,6-trideoxy-beta-L-altropyranose hydrolase [Prosthecobacter sp.]	diamond	168	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
26611403	26611403	PRJNA846486_P_NODE_69081_length_175_cov_1.563492_g68985_i0	PRJNA846486	69081	175	1.563492	2.736111	Luteolibacter pohnpeiensis	454153	Bacteria	Bacteria	69.7	1.34e-13	NR	WP_200274501.1	454153	g68985	i0	71.1	1.54285714285714	45	13	77.1	0	174	40	13	57	WP_200274501.1 hypothetical protein, partial [Luteolibacter pohnpeiensis]	diamond	270	69.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter pohnpeiensis
26833347	26833347	PRJNA846486_P_NODE_86481_length_165_cov_0.896552_g86385_i0	PRJNA846486	86481	165	0.896552	1.4793108	Chthoniobacter sp.	2510640	Bacteria	Bacteria	43.9	8.2e-4	NR	MEA3211282.1	2510640	g86385	i0	51.4	0.672727272727273	37	18	67.3	0	163	53	40	76	MEA3211282.1 hypothetical protein [Chthoniobacter sp.]	diamond	111	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
26865201	26865201	PRJNA846486_P_NODE_84061_length_166_cov_0.888889_g83965_i0	PRJNA846486	84061	166	0.888889	1.47555574	Luteolibacter marinus	2776705	Bacteria	Bacteria	70.5	2.09e-12	NR	WP_226895735.1	2776705	g83965	i0	63.6	0.993975903614458	55	19	97.6	1	3	164	265	319	WP_226895735.1 phage portal protein family protein [Luteolibacter marinus]	diamond	165	70.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter marinus
27117757	27117757	PRJNA846486_P_NODE_77122_length_169_cov_0.866667_g77026_i0	PRJNA846486	77122	169	0.866667	1.46466723	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	51.6	1.01e-5	NR	MCC6880916.1	2026801	g77026	i0	58.8	1.54437869822485	51	18	88.8	3	20	169	223	271	MCC6880916.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	261	51.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27465741	27465741	PRJNA846486_P_NODE_88803_length_164_cov_0.904348_g88707_i0	PRJNA846486	88803	164	0.904348	1.48313072	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	67	1.8e-11	NR	MBK7998840.1	2026799	g88707	i0	75.6	0.75	41	10	75	0	38	160	62	102	MBK7998840.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	123	67	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28160406	28160406	PRJNA846486_P_NODE_43925_length_208_cov_1.188679_g43829_i0	PRJNA846486	43925	208	1.188679	2.47245232	Haloferula sp. BvORR	2497595	Bacteria	Bacteria	95.5	4.31e-21	NR	WP_081886239.1	1396141	g43829	i0	66.2	1.96153846153846	68	23	98.1	0	3	206	321	388	WP_081886239.1 DnaB-like helicase C-terminal domain-containing protein [Haloferula sp. BvORR071]	diamond	408	95.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula sp. BvORR071
28602350	28602350	PRJNA846486_P_NODE_89067_length_164_cov_0.904348_g88971_i0	PRJNA846486	89067	164	0.904348	1.48313072	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	75.1	5.63e-16	NR	MBA2242150.1	2201154	g88971	i0	62.3	0.969512195121951	53	20	97	0	3	161	13	65	MBA2242150.1 M15 family peptidase [Chthoniobacterales bacterium]	diamond	159	75.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
28791537	28791537	PRJNA846486_P_NODE_79167_length_168_cov_0.873950_g79071_i0	PRJNA846486	79167	168	0.87395	1.468236	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	58.5	7.21e-9	NR	MBE7496984.1	2026800	g79071	i0	100	0.517857142857143	29	0	51.8	0	88	2	1	29	MBE7496984.1 hypothetical protein [Verrucomicrobiaceae bacterium]	diamond	87	58.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28949786	28949786	PRJNA846486_P_NODE_93928_length_162_cov_0.920354_g93832_i0	PRJNA846486	93928	162	0.920354	1.49097348	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	97.1	9.09e-22	NR	MBK8041157.1	2026800	g93832	i0	80	0.925925925925926	50	10	92.6	0	11	160	276	325	MBK8041157.1 PriCT-2 domain-containing protein [Verrucomicrobiaceae bacterium]	diamond	150	97.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29391713	29391713	PRJNA846486_P_NODE_91109_length_163_cov_0.912281_g91013_i0	PRJNA846486	91109	163	0.912281	1.48701803	Opitutia bacterium	2026771	Bacteria	Bacteria	61.6	1.11e-9	NR	MBN37138.1	2026771	g91013	i0	54.9	1.71165644171779	51	23	93.9	0	10	162	138	188	MBN37138.1 hypothetical protein [Opitutia bacterium]	diamond	279	61.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
29706895	29706895	PRJNA846486_P_NODE_79650_length_168_cov_0.873950_g79554_i0	PRJNA846486	79650	168	0.87395	1.468236	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	95.1	2.17e-22	NR	MDR3459556.1	2499141	g79554	i0	75.9	0.964285714285714	54	13	96.4	0	3	164	82	135	MDR3459556.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	162	95.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29738627	29738627	PRJNA846486_P_NODE_46830_length_203_cov_1.162338_g46734_i0	PRJNA846486	46830	203	1.162338	2.35954614	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	42.4	0.02	NR	HMG04027.1	2201154	g46734	i0	35.4	0.960591133004926	65	33	87.2	2	17	193	56	117	HMG04027.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	195	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30149350	30149350	PRJNA846486_P_NODE_28132_length_248_cov_1.045226_g28036_i0	PRJNA846486	28132	248	1.045226	2.59216048	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	51.2	3.46e-5	NR	MEN9534770.1	2026799	g28036	i0	57.5	0.483870967741935	40	15	48.4	1	127	246	2	39	MEN9534770.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	120	51.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30474071	30474071	PRJNA846486_P_NODE_79593_length_168_cov_0.873950_g79497_i0	PRJNA846486	79593	168	0.87395	1.468236	Luteolibacter	518753	Bacteria	Bacteria	88.2	1.17e-18	NR	WP_264486054.1	1581411	g79497	i0	87.3	2.92857142857143	55	7	98.2	0	168	4	142	196	WP_264486054.1 hypothetical protein [Luteolibacter arcticus]	diamond	492	89	0.991011235955056	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter arcticus
30505558	30505558	PRJNA846486_P_NODE_88313_length_164_cov_0.904348_g88217_i0	PRJNA846486	88313	164	0.904348	1.48313072	Bacteria	2	Bacteria	Bacteria	111	9.48e-27	NR	MBI3882554.1	2026799	g88217	i0	88.9	3.95121951219512	54	6	98.8	0	3	164	672	725	MBI3882554.1 c-type cytochrome [Verrucomicrobiota bacterium]	diamond	648	111	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30591817	30591817	PRJNA846486_P_NODE_55813_length_190_cov_1.276596_g55717_i0	PRJNA846486	55813	190	1.276596	2.4255324	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	60.5	1.03e-8	NR	MDQ5979716.1	2026799	g55717	i0	100	0.552631578947368	35	0	55.3	0	189	85	245	279	MDQ5979716.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	105	60.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30813019	30813019	PRJNA846486_P_NODE_82714_length_166_cov_1.538462_g82618_i0	PRJNA846486	82714	166	1.538462	2.55384692	Opitutaceae bacterium	2006848	Bacteria	Bacteria	45.8	0.00104	NR	MBP8256065.1	2006848	g82618	i0	44.2	0.939759036144578	52	28	92.2	1	12	164	41	92	MBP8256065.1 hypothetical protein [Opitutaceae bacterium]	diamond	156	45.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31097304	31097304	PRJNA846486_P_NODE_80975_length_167_cov_0.966102_g80879_i0	PRJNA846486	80975	167	0.966102	1.61339034	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	93.2	6.6300000000000006e-21	NR	RYD65414.1	2026800	g80879	i0	83.3	0.970059880239521	54	9	97	0	164	3	79	132	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	162	93.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
31255428	31255428	PRJNA846486_P_NODE_79195_length_168_cov_0.873950_g79099_i0	PRJNA846486	79195	168	0.87395	1.468236	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	90.9	1.35e-19	NR	MBE7502859.1	2026801	g79099	i0	80	11.0178571428571	55	11	98.2	0	3	167	99	153	MBE7502859.1 serine/threonine protein kinase [Verrucomicrobiales bacterium]	diamond	1851	90.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31255436	31255436	PRJNA846486_P_NODE_91335_length_163_cov_0.912281_g91239_i0	PRJNA846486	91335	163	0.912281	1.48701803	Cerasicoccaceae	3056374	Bacteria	Bacteria	75.1	8e-15	NR	WP_220622115.1	3056374	g91239	i0	74	0.920245398773006	50	13	92	0	163	14	36	85	WP_220622115.1 MULTISPECIES: class I SAM-dependent methyltransferase [Cerasicoccaceae]	diamond	150	75.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae
31413628	31413628	PRJNA846486_P_NODE_81076_length_167_cov_0.881356_g80980_i0	PRJNA846486	81076	167	0.881356	1.47186452	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	100	8.06e-26	NR	MEI6819993.1	2026799	g80980	i0	85.5	0.988023952095808	55	8	98.8	0	2	166	1	55	MEI6819993.1 NadS family protein [Verrucomicrobiota bacterium]	diamond	165	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31477042	31477042	PRJNA846486_P_NODE_93436_length_162_cov_0.920354_g93340_i0	PRJNA846486	93436	162	0.920354	1.49097348	Opitutaceae bacterium	2006848	Bacteria	Bacteria	46.2	7.34e-4	NR	HEU5081320.1	2006848	g93340	i0	52.4	2.33333333333333	42	20	77.8	0	130	5	144	185	HEU5081320.1 hypothetical protein [Opitutaceae bacterium]	diamond	378	46.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31603467	31603467	PRJNA846486_P_NODE_84076_length_166_cov_0.888889_g83980_i0	PRJNA846486	84076	166	0.888889	1.47555574	Opitutaceae bacterium	2006848	Bacteria	Bacteria	51.6	9.85e-6	NR	MBX3751415.1	2006848	g83980	i0	58.3	0.867469879518072	48	17	81.3	1	11	145	117	164	MBX3751415.1 hypothetical protein [Opitutaceae bacterium]	diamond	144	51.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31643241	31643241	PRJNA846486_P_NODE_42056_length_211_cov_1.864198_g41960_i0	PRJNA846486	42056	211	1.864198	3.93345778	Bacteria	2	Bacteria	Bacteria	42	0.0476	NR	MEI7955037.1	2026799	g41960	i0	31.8	1.91943127962085	66	45	93.8	0	1	198	161	226	MEI7955037.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	405	42.4	0.990566037735849	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31982881	31982881	PRJNA846486_P_NODE_27058_length_252_cov_1.216749_g26962_i0	PRJNA846486	27058	252	1.216749	3.06620748	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	61.6	3.79e-9	NR	HET6407436.1	2811408	g26962	i0	65.9	0.488095238095238	41	14	48.8	0	242	120	176	216	HET6407436.1 hypothetical protein [Chthoniobacteraceae bacterium]	diamond	123	61.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
31982889	31982889	PRJNA846486_P_NODE_81318_length_167_cov_0.881356_g81222_i0	PRJNA846486	81318	167	0.881356	1.47186452	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	50.1	7.01e-6	NR	MDB4617239.1	2026801	g81222	i0	60	0.718562874251497	40	16	71.9	0	123	4	29	68	MDB4617239.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	120	50.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32077872	32077872	PRJNA846486_P_NODE_94398_length_162_cov_0.920354_g94302_i0	PRJNA846486	94398	162	0.920354	1.49097348	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	59.7	1.14e-8	NR	MBA3385997.1	2201154	g94302	i0	60.9	1.7037037037037	46	18	85.2	0	138	1	72	117	MBA3385997.1 aldo/keto reductase [Chthoniobacterales bacterium]	diamond	276	59.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32236478	32236478	PRJNA846486_P_NODE_93278_length_162_cov_0.920354_g93182_i0	PRJNA846486	93278	162	0.920354	1.49097348	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.1	0.00903	NR	MEI6175396.1	2026799	g93182	i0	76.7	1.59259259259259	30	7	55.6	0	92	3	1	30	MEI6175396.1 sulfatase-like hydrolase/transferase [Verrucomicrobiota bacterium]	diamond	258	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32299749	32299749	PRJNA846486_P_NODE_43839_length_208_cov_1.308176_g43743_i0	PRJNA846486	43839	208	1.308176	2.72100608	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	82	3.42e-16	NR	MEI7912283.1	2026799	g43743	i0	51.5	0.951923076923077	66	32	95.2	0	202	5	156	221	MEI7912283.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	198	82	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32804394	32804394	PRJNA846486_P_NODE_33540_length_231_cov_1.142857_g33444_i0	PRJNA846486	33540	231	1.142857	2.63999967	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	54.3	1.31e-6	NR	MFM8549929.1	2026799	g33444	i0	39.5	7.84415584415584	76	45	97.4	1	226	2	117	192	MFM8549929.1 lysophospholipid acyltransferase family protein [Verrucomicrobiota bacterium]	diamond	1812	54.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32898775	32898775	PRJNA846486_P_NODE_91160_length_163_cov_0.912281_g91064_i0	PRJNA846486	91160	163	0.912281	1.48701803	Prosthecobacter sp.	1965333	Bacteria	Bacteria	81.3	2.11e-17	NR	WP_395741040.1	1965333	g91064	i0	64	0.920245398773006	50	18	92	0	152	3	37	86	WP_395741040.1 hypothetical protein [Prosthecobacter sp.]	diamond	150	81.3	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);;