metadata: contig_metadata: 21 rows where bioproject = "PRJNA876641" and tax

21 rows where bioproject = "PRJNA876641" 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
9781072	9781072	PRJNA876641_P_NODE_20668_length_244_cov_2.485380_g20594_i0	PRJNA876641	20668	244	2.48538	6.0643272	Bacteria	2	Bacteria	Bacteria	112	7.2099999999999985e-28	NR	MEK6230939.1	1962973	g20594	i0	60.3	4.70901639344262	78	31	95.9	0	235	2	1	78	MEK6230939.1 NAD(P)-dependent alcohol dehydrogenase [Luteolibacter sp.]	diamond	1149	113	0.991150442477876	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
17431450	17431450	PRJNA876641_P_NODE_3114_length_416_cov_0.880466_g3040_i0	PRJNA876641	3114	416	0.880466	3.66273856	Candidatus Methylacidiphilales bacterium	2720631	Bacteria	Bacteria	195	2.27e-57	NR	HSI86689.1	2720631	g3040	i0	70.3	6.95913461538461	138	41	99.5	0	2	415	191	328	HSI86689.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Candidatus Methylacidiphilales bacterium]	diamond	2895	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales			Candidatus Methylacidiphilales bacterium
22916138	22916138	PRJNA876641_P_NODE_18398_length_248_cov_0.880000_g18324_i0	PRJNA876641	18398	248	0.88	2.1824	Coraliomargarita	442430	Bacteria	Bacteria	244	3.45e-60	NTclustered	gi\|470486190\|ref\|NR_076741.1\|	395922	g18324	i0	85.714	229.112903225806	238	26	95	6	3	237	1776	1544	Coraliomargarita akajimensis strain 04OKA010-24 23S ribosomal RNA gene, complete sequence	blastn	56820	244	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita akajimensis
25465178	25465178	PRJNA876641_P_NODE_3740_length_389_cov_1.439873_g3666_i0	PRJNA876641	3740	389	1.439873	5.60110597	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	66.2	9.3e-10	NR	RYD71398.1	2026800	g3666	i0	34.3	1.34190231362468	102	66	78.7	1	81	386	14	114	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	522	66.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
26770412	26770412	PRJNA876641_P_NODE_21121_length_244_cov_0.900585_g21047_i0	PRJNA876641	21121	244	0.900585	2.1974274	Pelagicoccus mobilis	415221	Bacteria	Bacteria	62.4	4.48e-9	NR	WP_200358271.1	415221	g21047	i0	44.4	0.885245901639344	72	36	86.1	3	217	8	420	489	WP_200358271.1 arylsulfatase [Pelagicoccus mobilis]	diamond	216	62.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Pelagicoccaceae	Pelagicoccus	Pelagicoccus mobilis
27276610	27276610	PRJNA876641_P_NODE_2863_length_428_cov_2.563380_g2789_i0	PRJNA876641	2863	428	2.56338	10.9712664	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	129	4.03e-33	NR	RYD71398.1	2026800	g2789	i0	55	0.841121495327103	120	53	83.4	1	3	359	242	361	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	360	129	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27276617	27276617	PRJNA876641_P_NODE_963_length_655_cov_2.962199_g892_i0	PRJNA876641	963	655	2.962199	19.40240345	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	209	5.699999999999999e-63	NR	MDH4476108.1	2026800	g892	i0	62.7	2.28091603053435	166	61	76	1	655	158	191	355	MDH4476108.1 alkene reductase [Verrucomicrobiaceae bacterium]	diamond	1494	209	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28065916	28065916	PRJNA876641_P_NODE_11925_length_271_cov_1.333333_g11851_i0	PRJNA876641	11925	271	1.333333	3.61333243	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	107	1.49e-25	NR	HTG45312.1	2499141	g11851	i0	60	0.940959409594096	85	34	94.1	0	17	271	13	97	HTG45312.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	255	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28065930	28065930	PRJNA876641_P_NODE_24045_length_229_cov_2.378205_g23971_i0	PRJNA876641	24045	229	2.378205	5.44608945	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	68.9	1.86e-11	NR	MBS0645922.1	2026799	g23971	i0	63.5	0.681222707423581	52	19	68.1	0	17	172	782	833	MBS0645922.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	156	68.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28886775	28886775	PRJNA876641_P_NODE_9768_length_283_cov_2.004762_g9694_i0	PRJNA876641	9768	283	2.004762	5.67347646	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	94.4	4.43e-20	NR	MCB1205730.1	2499141	g9694	i0	54.3	0.996466431095406	94	37	99.6	1	283	2	201	288	MCB1205730.1 peroxiredoxin [Verrucomicrobiia bacterium]	diamond	282	94.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29076484	29076484	PRJNA876641_P_NODE_22928_length_241_cov_2.619048_g22854_i0	PRJNA876641	22928	241	2.619048	6.31190568	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	45.1	0.00376	NR	MEI6341235.1	2026799	g22854	i0	41.4	0.721991701244813	58	32	69.7	1	208	41	109	166	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	174	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29526504	29526504	PRJNA876641_P_NODE_1790_length_514_cov_1.374150_g1716_i0	PRJNA876641	1790	514	1.37415	7.063131	Bacteria	2	Bacteria	Bacteria	63.2	3.57e-8	NR	MBC8243713.1	2026799	g1716	i0	39.2	4.65175097276265	79	48	46.1	0	238	2	71	149	MBC8243713.1 Gfo/Idh/MocA family oxidoreductase [Verrucomicrobiota bacterium]	diamond	2391	63.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30000239	30000239	PRJNA876641_P_NODE_10731_length_278_cov_1.243902_g10657_i0	PRJNA876641	10731	278	1.243902	3.45804756	Bacteria	2	Bacteria	Bacteria	95.5	1.62e-20	NR	MCF6313004.1	2026801	g10657	i0	55.4	5.9568345323741	92	41	99.3	0	276	1	25	116	MCF6313004.1 FAD-dependent oxidoreductase [Verrucomicrobiales bacterium]	diamond	1656	95.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30908463	30908463	PRJNA876641_P_NODE_14694_length_256_cov_1.278689_g14620_i0	PRJNA876641	14694	256	1.278689	3.27344384	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	61.6	9.64e-9	NR	MEZ5304281.1	2026801	g14620	i0	42.5	0.9375	80	43	93.8	1	254	15	145	221	MEZ5304281.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	240	61.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31035010	31035010	PRJNA876641_P_NODE_18915_length_247_cov_0.885057_g18841_i0	PRJNA876641	18915	247	0.885057	2.18609079	Limisphaerales bacterium	2052186	Bacteria	Bacteria	78.6	1.92e-15	NR	MEI9863482.1	2052186	g18841	i0	54.5	0.801619433198381	66	30	80.2	0	246	49	31	96	MEI9863482.1 hypothetical protein [Limisphaerales bacterium]	diamond	198	78.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
31129117	31129117	PRJNA876641_P_NODE_12615_length_267_cov_1.530928_g12541_i0	PRJNA876641	12615	267	1.530928	4.08757776	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	68.9	2.46e-11	NR	RYD71398.1	2026800	g12541	i0	55.4	0.629213483146067	56	25	62.9	0	6	173	147	202	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	168	68.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
31603908	31603908	PRJNA876641_P_NODE_1416_length_560_cov_2.172485_g1343_i0	PRJNA876641	1416	560	2.172485	12.165916	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	213	4.36e-65	NR	RYD65414.1	2026800	g1343	i0	77.7	0.696428571428571	130	29	69.6	0	559	170	207	336	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	390	213	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32078334	32078334	PRJNA876641_P_NODE_12558_length_267_cov_2.097938_g12484_i0	PRJNA876641	12558	267	2.097938	5.60149446	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	54.3	3.73e-6	NR	MDH7503595.1	2026799	g12484	i0	54.2	0.539325842696629	48	22	53.9	0	82	225	34	81	MDH7503595.1 phosphatidylinositol-specific phospholipase C/glycerophosphodiester phosphodiesterase family protein [Verrucomicrobiota bacterium]	diamond	144	54.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32078346	32078346	PRJNA876641_P_NODE_23918_length_233_cov_2.406250_g23844_i0	PRJNA876641	23918	233	2.40625	5.6065625	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	70.1	1.95e-12	NR	RYD36583.1	2026800	g23844	i0	61.5	0.669527896995708	52	16	61.8	1	6	149	167	218	RYD36583.1 MAG: Mpv17/PMP22 family protein [Verrucomicrobiaceae bacterium]	diamond	156	70.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32268403	32268403	PRJNA876641_P_NODE_4418_length_366_cov_1.238908_g4344_i0	PRJNA876641	4418	366	1.238908	4.53440328	Haloferula luteola	595692	Bacteria	Bacteria	89.4	1.77e-18	NR	WP_184015085.1	595692	g4344	i0	41.2	3.71311475409836	119	66	94.3	1	3	347	159	277	WP_184015085.1 choice-of-anchor A family protein [Haloferula luteola]	diamond	1359	89.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula luteola
32773361	32773361	PRJNA876641_P_NODE_8820_length_289_cov_1.120370_g8746_i0	PRJNA876641	8820	289	1.12037	3.2378693	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	89	2.55e-18	NR	MEP6937692.1	2201154	g8746	i0	46.9	1.99307958477509	96	50	98.6	1	289	5	23	118	MEP6937692.1 fumarylacetoacetase [Chthoniobacterales bacterium]	diamond	576	89	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales 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);;