metadata: contig_metadata: 33 rows where bioproject = "PRJNA385073" and tax

33 rows where bioproject = "PRJNA385073" 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
405876	405876	PRJNA385073_P_NODE_32101_length_273_cov_1.475000_g31939_i0	PRJNA385073	32101	273	1.475	4.02675	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	128	3.67e-32	NR	GDY20605.1	2026799	g31939	i0	72.2	3.95604395604396	90	25	98.9	0	271	2	440	529	GDY20605.1 ATPase [Verrucomicrobiota bacterium]	diamond	1080	128	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
406108	406108	PRJNA385073_P_NODE_42881_length_250_cov_1.446328_g42719_i0	PRJNA385073	42881	250	1.446328	3.61582	Opitutaceae bacterium TAV5	794903	Bacteria	Bacteria	97.1	1.03e-15	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g42719	i0	86.022	1.116	93	10	37	3	100	191	7252435	7252345	Opitutaceae bacterium TAV5, complete genome	blastn	279	97.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
406121	406121	PRJNA385073_P_NODE_43561_length_250_cov_0.870056_g43399_i0	PRJNA385073	43561	250	0.870056	2.17514	Pedosphaera parvula	1032527	Bacteria	Bacteria	355	1.54e-93	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g43399	i0	92.4	77.032	250	17	100	1	1	250	1953	2200	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	19258	355	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
5509782	5509782	PRJNA385073_P_NODE_4045_length_582_cov_1.489194_g3889_i0	PRJNA385073	4045	582	1.489194	8.66710908	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1048	0	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g3889	i0	99.141	95.2285223367698	582	5	100	0	1	582	737394	736813	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	55423	1048	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8058792	8058792	PRJNA385073_P_NODE_15427_length_349_cov_1.115942_g15266_i0	PRJNA385073	15427	349	1.115942	3.89463758	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	214	1.6e-66	NR	MBR5605082.1	2026799	g15266	i0	91.3	1.97707736389685	115	10	98.9	0	347	3	140	254	MBR5605082.1 elongation factor Tu [Verrucomicrobiota bacterium]	diamond	690	214	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
15708417	15708417	PRJNA385073_P_NODE_23313_length_302_cov_3.026201_g23151_i0	PRJNA385073	23313	302	3.026201	9.13912702	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	117	9.83e-22	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g23151	i0	78.977	0.582781456953642	176	34	58	3	1	176	5027136	5027308	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	176	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
15708979	15708979	PRJNA385073_P_NODE_49513_length_246_cov_1.410405_g49351_i0	PRJNA385073	49513	246	1.410405	3.4695963	uncultured Verrucomicrobiales bacterium	100234	Bacteria	Bacteria	263	9.430000000000001e-66	NTclustered	gi\|192805056\|emb\|FM175858.1\|	100234	g49351	i0	94.186	70.4024390243902	172	10	70	0	74	245	1	172	Uncultured Verrucomicrobiales bacterium partial 16S rRNA gene, clone CL3.D142	blastn	17319	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			uncultured Verrucomicrobiales bacterium
16983871	16983871	PRJNA385073_P_NODE_60874_length_234_cov_4.136646_g60712_i0	PRJNA385073	60874	234	4.136646	9.67975164	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	372	1.42e-98	NTclustered	gi\|226525317\|gb\|FJ872374.1\|	156588	g60712	i0	97.285	268.264957264957	221	3	94	3	15	234	3077	2859	Uncultured Verrucomicrobia bacterium clone 184 genomic sequence	blastn	62774	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
17653919	17653919	PRJNA385073_P_NODE_48214_length_247_cov_0.885057_g48052_i0	PRJNA385073	48214	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	257	4.41e-64	NTclustered	gi\|2076416356\|gb\|CP076040.1\|	2684114	g48052	i0	85.484	88.2550607287449	248	34	99	2	1	246	4362819	4362572	Opitutia bacterium ISCC 52 isolate E3 chromosome, complete genome	blastn	21799	257	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium ISCC 52
19532374	19532374	PRJNA385073_P_NODE_62756_length_226_cov_3.830065_g62594_i0	PRJNA385073	62756	226	3.830065	8.6559469	Opitutaceae bacterium	2006848	Bacteria	Bacteria	104	3.07e-25	NR	MBK8856971.1	2006848	g62594	i0	74.3	1.95132743362832	74	19	98.2	0	224	3	181	254	MBK8856971.1 formate dehydrogenase accessory sulfurtransferase FdhD [Opitutaceae bacterium]	diamond	441	104	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
20807556	20807556	PRJNA385073_P_NODE_36117_length_263_cov_1.115789_g35955_i0	PRJNA385073	36117	263	1.115789	2.93452507	Fontisphaera persica	2974023	Bacteria	Bacteria	268	2.1899999999999998e-67	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g35955	i0	85.496	0.996197718631179	262	33	99	5	4	263	1624604	1624346	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	262	268	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
23357995	23357995	PRJNA385073_P_NODE_35259_length_265_cov_1.302083_g35097_i0	PRJNA385073	35259	265	1.302083	3.45051995	Bacteria	2	Bacteria	Bacteria	153	1.49e-44	NR	MEY2499979.1	2026799	g35097	i0	83	8.96603773584906	88	15	99.6	0	2	265	94	181	MEY2499979.1 7-cyano-7-deazaguanine synthase [Verrucomicrobiota bacterium]	diamond	2376	154	0.993506493506494	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
23358289	23358289	PRJNA385073_P_NODE_48879_length_247_cov_0.885057_g48717_i0	PRJNA385073	48879	247	0.885057	2.18609079	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	435	1.9e-117	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g48717	i0	98.381	88.2834008097166	247	4	100	0	1	247	15867	15621	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	21806	435	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
26726614	26726614	PRJNA385073_P_NODE_31181_length_275_cov_4.297030_g31019_i0	PRJNA385073	31181	275	4.29703	11.8168325	Verrucomicrobiales bacterium VVV1	2015575	Bacteria	Bacteria	176	8.28e-53	NR	OYV04468.1	2015575	g31019	i0	98.9	1.98545454545455	91	1	99.3	0	3	275	16	106	OYV04468.1 MAG: enoyl-CoA hydratase [Verrucomicrobiales bacterium VVV1]	diamond	546	176	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium VVV1
26917026	26917026	PRJNA385073_P_NODE_63802_length_215_cov_4.119718_g63640_i0	PRJNA385073	63802	215	4.119718	8.8573937	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	126	1.38e-32	NR	KAB2646977.1	2026799	g63640	i0	91.5	0.990697674418605	71	6	99.1	0	214	2	345	415	KAB2646977.1 MAG: aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Verrucomicrobiota bacterium]	diamond	213	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28370004	28370004	PRJNA385073_P_NODE_39866_length_254_cov_1.453039_g39704_i0	PRJNA385073	39866	254	1.453039	3.69071906	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	141	1.15e-39	NR	HEU0009020.1	2499141	g39704	i0	77.4	3.95669291338583	84	19	99.2	0	253	2	25	108	HEU0009020.1 3-deoxy-manno-octulosonate cytidylyltransferase [Verrucomicrobiia bacterium]	diamond	1005	141	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28433260	28433260	PRJNA385073_P_NODE_29586_length_280_cov_1.603865_g29424_i0	PRJNA385073	29586	280	1.603865	4.490822	Chthoniobacter sp.	2510640	Bacteria	Bacteria	167	1.07e-47	NR	MCE9609141.1	2510640	g29424	i0	88.2	1.97142857142857	93	11	99.6	0	2	280	13	105	MCE9609141.1 DUF1501 domain-containing protein [Chthoniobacter sp.]	diamond	552	167	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
28496506	28496506	PRJNA385073_P_NODE_49687_length_246_cov_0.890173_g49525_i0	PRJNA385073	49687	246	0.890173	2.18982558	Candidatus Methylacidiphilales bacterium	2720631	Bacteria	Bacteria	59.7	3.75e-8	NR	MDX6765977.1	2720631	g49525	i0	93.3	0.365853658536585	30	2	36.6	0	1	90	310	339	MDX6765977.1 hypothetical protein [Candidatus Methylacidiphilales bacterium]	diamond	90	59.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales			Candidatus Methylacidiphilales bacterium
28496511	28496511	PRJNA385073_P_NODE_59107_length_241_cov_0.916667_g58945_i0	PRJNA385073	59107	241	0.916667	2.20916747	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	181	7.4e-53	NR	MBL9169239.1	2026801	g58945	i0	100	0.995850622406639	80	0	99.6	0	1	240	61	140	MBL9169239.1 DUF1501 domain-containing protein [Verrucomicrobiales bacterium]	diamond	240	181	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
29018709	29018709	PRJNA385073_P_NODE_37928_length_258_cov_4.081081_g37766_i0	PRJNA385073	37928	258	4.081081	10.52918898	Pseudomonadati	3379134	Bacteria	Bacteria	92.4	6.09e-20	NR	MBS0648531.1	2026799	g37766	i0	55.9	9.02325581395349	68	30	79.1	0	54	257	1	68	MBS0648531.1 glycosyltransferase [Verrucomicrobiota bacterium]	diamond	2328	92.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29064816	29064816	PRJNA385073_P_NODE_39388_length_255_cov_1.692308_g39226_i0	PRJNA385073	39388	255	1.692308	4.3153854	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	145	1.4e-40	NR	MEW6157827.1	2026799	g39226	i0	81.4	1.01176470588235	86	15	100	1	1	255	194	279	MEW6157827.1 type II secretion system protein [Verrucomicrobiota bacterium]	diamond	258	145	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29222765	29222765	PRJNA385073_P_NODE_42089_length_251_cov_0.865169_g41927_i0	PRJNA385073	42089	251	0.865169	2.17157419	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	72.8	4.22e-13	NR	MDB4617038.1	2026801	g41927	i0	58	0.597609561752988	50	21	59.8	0	251	102	218	267	MDB4617038.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	150	72.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
29727477	29727477	PRJNA385073_P_NODE_45330_length_249_cov_0.875000_g45168_i0	PRJNA385073	45330	249	0.875	2.17875	Akkermansia sp.	1872421	Bacteria	Bacteria	42.7	0.0412	NR	MBQ3525357.1	1872421	g45168	i0	40.8	0.855421686746988	71	38	84.3	2	37	246	473	540	MBQ3525357.1 4Fe-4S dicluster domain-containing protein [Akkermansia sp.]	diamond	213	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
29980451	29980451	PRJNA385073_P_NODE_60911_length_234_cov_3.335404_g60749_i0	PRJNA385073	60911	234	3.335404	7.80484536	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	63.2	2e-9	NR	MBA3544279.1	2201154	g60749	i0	84.8	0.423076923076923	33	5	42.3	0	134	36	392	424	MBA3544279.1 IS256 family transposase [Chthoniobacterales bacterium]	diamond	99	63.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30233178	30233178	PRJNA385073_P_NODE_53652_length_244_cov_0.900585_g53490_i0	PRJNA385073	53652	244	0.900585	2.1974274	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	138	1.4e-36	NR	HWL53260.1	2811408	g53490	i0	76.5	0.995901639344262	81	19	99.6	0	1	243	75	155	HWL53260.1 nitronate monooxygenase [Chthoniobacteraceae bacterium]	diamond	243	138	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
30833490	30833490	PRJNA385073_P_NODE_58614_length_241_cov_0.916667_g58452_i0	PRJNA385073	58614	241	0.916667	2.20916747	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	164	2.08e-45	NR	NCC60166.1	2499141	g58452	i0	96.3	0.995850622406639	80	3	99.6	0	240	1	197	276	NCC60166.1 squalene--hopene cyclase [Verrucomicrobiia bacterium]	diamond	240	164	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30928393	30928393	PRJNA385073_P_NODE_49194_length_246_cov_3.225434_g49032_i0	PRJNA385073	49194	246	3.225434	7.93456764	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	119	5.48e-30	NR	MBM3835062.1	2026799	g49032	i0	64.6	2.98780487804878	82	29	100	0	1	246	154	235	MBM3835062.1 Gfo/Idh/MocA family oxidoreductase [Verrucomicrobiota bacterium]	diamond	735	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30991587	30991587	PRJNA385073_P_NODE_56514_length_242_cov_0.911243_g56352_i0	PRJNA385073	56514	242	0.911243	2.20520806	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	63.2	2.29e-9	NR	MEO6755104.1	2811408	g56352	i0	45.3	1.06611570247934	86	41	99.2	1	240	1	271	356	MEO6755104.1 hypothetical protein [Chthoniobacteraceae bacterium]	diamond	258	63.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
31324342	31324342	PRJNA385073_P_NODE_63555_length_218_cov_4.889655_g63393_i0	PRJNA385073	63555	218	4.889655	10.6594479	Chthoniobacter	295577	Bacteria	Bacteria	120	3.1599999999999997e-32	NR	MEA3211714.1	2510640	g63393	i0	80.3	4.87155963302752	71	14	97.7	0	3	215	62	132	MEA3211714.1 dependent ligase domain [Chthoniobacter sp.]	diamond	1062	121	0.991735537190083	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
31718740	31718740	PRJNA385073_P_NODE_60757_length_235_cov_2.537037_g60595_i0	PRJNA385073	60757	235	2.537037	5.96203695	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	44.7	7.87e-4	NR	PYJ33491.1	2026799	g60595	i0	49	0.651063829787234	51	25	65.1	1	231	79	9	58	PYJ33491.1 MAG: hypothetical protein DME79_06080 [Verrucomicrobiota bacterium]	diamond	153	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31971742	31971742	PRJNA385073_P_NODE_62638_length_227_cov_2.500000_g62476_i0	PRJNA385073	62638	227	2.5	5.675	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	63.5	1.37e-9	NR	MDB6173931.1	2811408	g62476	i0	78	3.29074889867841	41	9	54.2	0	226	104	413	453	MDB6173931.1 Fis family transcriptional regulator [Chthoniobacteraceae bacterium]	diamond	747	63.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
32288544	32288544	PRJNA385073_P_NODE_35099_length_265_cov_2.078125_g34937_i0	PRJNA385073	35099	265	2.078125	5.50703125	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	107	4.9300000000000005e-27	NR	MEI6342320.1	2026799	g34937	i0	60.3	0.883018867924528	78	31	88.3	0	237	4	2	79	MEI6342320.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	234	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32573185	32573185	PRJNA385073_P_NODE_40579_length_252_cov_2.374302_g40417_i0	PRJNA385073	40579	252	2.374302	5.98324104	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	102	3.11e-24	NR	HEV8543894.1	2499141	g40417	i0	59.8	1.97619047619048	82	33	97.6	0	7	252	190	271	HEV8543894.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	498	102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia 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);;