metadata: contig_metadata: 27 rows where bioproject = "PRJNA812715" and tax

27 rows where bioproject = "PRJNA812715" 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
811871	811871	PRJNA812715_P_NODE_107421_length_248_cov_0.880000_g105620_i0	PRJNA812715	107421	248	0.88	2.1824	Fontisphaera persica	2974023	Bacteria	Bacteria	115	2.82e-21	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g105620	i0	98.462	23.7258064516129	65	1	26	0	184	248	1847312	1847376	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	5884	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
4642448	4642448	PRJNA812715_P_NODE_62484_length_330_cov_0.898833_g60685_i0	PRJNA812715	62484	330	0.898833	2.9661489	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	418	2.66e-112	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g60685	i0	89.634	82.0666666666667	328	34	99	0	2	329	3573445	3573118	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	27082	418	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
7190832	7190832	PRJNA812715_P_NODE_22186_length_702_cov_1.944356_g20516_i0	PRJNA812715	22186	702	1.944356	13.64937912	Candidatus Xiphinematobacter sp.	1903058	Bacteria	Bacteria	545	2.64e-150	NTclustered	gi\|1966850802\|gb\|CP068472.1\|	1903058	g20516	i0	93.048	0.871794871794872	374	24	53	2	271	643	244070	244442	MAG: Candidatus Xiphinematobacter sp. isolate P3-11 chromosome, complete genome	blastn	612	545	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp.
9742668	9742668	PRJNA812715_P_NODE_84408_length_277_cov_1.995098_g82608_i0	PRJNA812715	84408	277	1.995098	5.52642146	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	486	5.9e-133	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g82608	i0	98.545	143.942238267148	275	4	99	0	3	277	737014	737288	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	39872	486	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11018110	11018110	PRJNA812715_P_NODE_72709_length_299_cov_1.703540_g70909_i0	PRJNA812715	72709	299	1.70354	5.0935846	Pseudomonadati	3379134	Bacteria	Bacteria	150	3.05e-41	NR	MFV1994506.1	2026801	g70909	i0	74.5	4.89632107023411	98	24	98.3	1	3	296	61	157	MFV1994506.1 IS110 family transposase [Verrucomicrobiales bacterium]	diamond	1464	150	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
19941231	19941231	PRJNA812715_P_NODE_84576_length_277_cov_1.509804_g82776_i0	PRJNA812715	84576	277	1.509804	4.18215708	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	64.3	8.45e-11	NR	MBU6401876.1	2026799	g82776	i0	53.2	1.32129963898917	62	26	63.9	1	186	10	1	62	MBU6401876.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	366	64.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27307369	27307369	PRJNA812715_P_NODE_77623_length_288_cov_1.600000_g75823_i0	PRJNA812715	77623	288	1.6	4.608	Verrucomicrobiia bacterium Tous-C4TDCM	1982332	Bacteria	Bacteria	44.3	0.0179	NR	PAW68231.1	1982332	g75823	i0	35	0.833333333333333	80	46	78.1	3	12	236	28	106	PAW68231.1 MAG: hypothetical protein B9S38_11415 [Verrucomicrobiia bacterium Tous-C4TDCM]	diamond	240	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium Tous-C4TDCM
27623160	27623160	PRJNA812715_P_NODE_103724_length_250_cov_0.870056_g101923_i0	PRJNA812715	103724	250	0.870056	2.17514	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	90.9	1.31e-19	NR	MDB6053684.1	2026801	g101923	i0	64.5	0.912	76	27	91.2	0	247	20	242	317	MDB6053684.1 transaldolase-like [Verrucomicrobiales bacterium]	diamond	228	90.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27695203	27695203	PRJNA812715_P_NODE_52204_length_371_cov_1.771812_g50406_i0	PRJNA812715	52204	371	1.771812	6.57342252	Bacteria	2	Bacteria	Bacteria	99.4	2.35e-21	NR	MCF7764028.1	2026799	g50406	i0	43.7	2.88679245283019	119	65	94.6	2	2	352	533	651	MCF7764028.1 thioredoxin domain-containing protein [Verrucomicrobiota bacterium]	diamond	1071	99.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27718157	27718157	PRJNA812715_P_NODE_95384_length_260_cov_1.647059_g93583_i0	PRJNA812715	95384	260	1.647059	4.2823534	Prosthecobacter sp.	1965333	Bacteria	Bacteria	152	7.62e-44	NR	WP_300203647.1	1965333	g93583	i0	89.4	1.96153846153846	85	9	98.1	0	258	4	121	205	WP_300203647.1 pyridoxine 5'-phosphate synthase [Prosthecobacter sp.]	diamond	510	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
27749519	27749519	PRJNA812715_P_NODE_119804_length_242_cov_0.911243_g118003_i0	PRJNA812715	119804	242	0.911243	2.20520806	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	40.8	0.0407	NR	HYJ04583.1	2201154	g118003	i0	37	0.669421487603306	54	34	66.9	0	164	3	24	77	HYJ04583.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	162	40.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
28673746	28673746	PRJNA812715_P_NODE_121227_length_241_cov_0.916667_g119426_i0	PRJNA812715	121227	241	0.916667	2.20916747	Pseudomonadati	3379134	Bacteria	Bacteria	76.3	4.36e-14	NR	HWW50164.1	2499141	g119426	i0	42.9	2.87551867219917	77	44	95.9	0	240	10	273	349	HWW50164.1 amidohydrolase family protein [Verrucomicrobiia bacterium]	diamond	693	76.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28705396	28705396	PRJNA812715_P_NODE_38687_length_458_cov_1.457143_g36896_i0	PRJNA812715	38687	458	1.457143	6.67371494	Bacteria	2	Bacteria	Bacteria	132	1.04e-33	NR	MBC8245344.1	2026799	g36896	i0	52.7	5.04366812227074	110	52	72.1	0	458	129	307	416	MBC8245344.1 aromatic ring-hydroxylating dioxygenase subunit alpha [Verrucomicrobiota bacterium]	diamond	2310	132	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29233409	29233409	PRJNA812715_P_NODE_74469_length_294_cov_2.746606_g72669_i0	PRJNA812715	74469	294	2.746606	8.07502164	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	158	1.7799999999999994e-42	NR	MEK7676769.1	2026799	g72669	i0	70.4	3	98	28	99	1	2	292	407	504	MEK7676769.1 N-6 DNA methylase [Verrucomicrobiota bacterium]	diamond	882	158	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29431237	29431237	PRJNA812715_P_NODE_53909_length_363_cov_1.900000_g52110_i0	PRJNA812715	53909	363	1.9	6.897	root	1	Root_unresolved	Root_unresolved	144	9.929999999999999e-40	NR	HCP06138.1	2026801	g52110	i0	63.8	1.90909090909091	116	38	95.9	1	16	363	171	282	HCP06138.1 transaldolase [Verrucomicrobiales bacterium]	diamond	693	144	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
29643381	29643381	PRJNA812715_P_NODE_122370_length_238_cov_3.272727_g120569_i0	PRJNA812715	122370	238	3.272727	7.78909026	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	78.2	9.25e-15	NR	MEI6338739.1	2026799	g120569	i0	50	1.94117647058824	78	39	98.3	0	3	236	215	292	MEI6338739.1 acetyl esterase [Verrucomicrobiota bacterium]	diamond	462	78.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29674999	29674999	PRJNA812715_P_NODE_56590_length_352_cov_1.082437_g54791_i0	PRJNA812715	56590	352	1.082437	3.81017824	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	149	2.55e-41	NR	MDP4647811.1	2562705	g54791	i0	58.6	6.92045454545455	116	48	98.9	0	3	350	141	256	MDP4647811.1 ROK family protein [Akkermansiaceae bacterium]	diamond	2436	149	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
30347953	30347953	PRJNA812715_P_NODE_23012_length_682_cov_1.896552_g21328_i0	PRJNA812715	23012	682	1.896552	12.93448464	PVC group	1783257	Bacteria	Bacteria	59.3	3.19e-6	NR	MDF1816644.1	2026801	g21328	i0	32.7	1.0733137829912	113	62	44	4	2	301	114	225	MDF1816644.1 protein kinase [Verrucomicrobiales bacterium]	diamond	732	59.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30812525	30812525	PRJNA812715_P_NODE_106094_length_249_cov_0.875000_g104293_i0	PRJNA812715	106094	249	0.875	2.17875	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	53.9	3.84e-6	NR	HTM06905.1	2499141	g104293	i0	41.1	5.51807228915663	73	35	81.9	3	215	12	209	278	HTM06905.1 vitamin K epoxide reductase family protein [Verrucomicrobiia bacterium]	diamond	1374	53.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30970689	30970689	PRJNA812715_P_NODE_114154_length_245_cov_0.895349_g112353_i0	PRJNA812715	114154	245	0.895349	2.19360505	Prosthecobacter sp.	1965333	Bacteria	Bacteria	171	2.84e-49	NR	WP_395733751.1	1965333	g112353	i0	93.8	3.96734693877551	81	5	99.2	0	245	3	273	353	WP_395733751.1 SBBP repeat-containing protein [Prosthecobacter sp.]	diamond	972	171	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
31010876	31010876	PRJNA812715_P_NODE_68474_length_310_cov_2.966245_g66674_i0	PRJNA812715	68474	310	2.966245	9.1953595	Pseudomonadati	3379134	Bacteria	Bacteria	85.5	7.48e-17	NR	HEX3730016.1	2006848	g66674	i0	79.6	2.91290322580645	49	10	47.4	0	150	4	172	220	HEX3730016.1 carboxylesterase family protein [Opitutaceae bacterium]	diamond	903	86.3	0.990730011587486	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31517014	31517014	PRJNA812715_P_NODE_59896_length_339_cov_1.447368_g58097_i0	PRJNA812715	59896	339	1.447368	4.90657752	PVC group	1783257	Bacteria	Bacteria	61.6	2.68e-8	NR	MDB6077804.1	2562705	g58097	i0	38.8	1.3716814159292	85	48	71.7	2	323	81	107	191	MDB6077804.1 Por secretion system C-terminal sorting protein [Akkermansiaceae bacterium]	diamond	465	61.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
31666090	31666090	PRJNA812715_P_NODE_62497_length_330_cov_0.856031_g60698_i0	PRJNA812715	62497	330	0.856031	2.8249023	Chthoniobacter sp.	2510640	Bacteria	Bacteria	135	1.49e-34	NR	MCE9611332.1	2510640	g60698	i0	73	2.42727272727273	89	24	80.9	0	325	59	572	660	MCE9611332.1 transketolase [Chthoniobacter sp.]	diamond	801	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
31729357	31729357	PRJNA812715_P_NODE_121757_length_241_cov_0.916667_g119956_i0	PRJNA812715	121757	241	0.916667	2.20916747	Terrimicrobiaceae bacterium	2832348	Bacteria	Bacteria	101	4.34e-25	NR	HEY5779780.1	2832348	g119956	i0	65.9	1.79253112033195	82	26	99.6	2	1	240	7	88	HEY5779780.1 hypothetical protein [Terrimicrobiaceae bacterium]	diamond	432	101	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae		Terrimicrobiaceae bacterium
31982403	31982403	PRJNA812715_P_NODE_49918_length_383_cov_1.248387_g48121_i0	PRJNA812715	49918	383	1.248387	4.78132221	Chthoniobacter sp.	2510640	Bacteria	Bacteria	174	3.55e-48	NR	HEY3901011.1	2510640	g48121	i0	69.4	0.971279373368146	124	38	97.1	0	381	10	272	395	HEY3901011.1 transketolase [Chthoniobacter sp.]	diamond	372	174	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
32267493	32267493	PRJNA812715_P_NODE_77078_length_289_cov_1.425926_g75278_i0	PRJNA812715	77078	289	1.425926	4.12092614	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	177	1.2799999999999999e-52	NR	MDB6060895.1	2026800	g75278	i0	82.1	0.986159169550173	95	17	98.6	0	3	287	111	205	MDB6060895.1 dihydrodipicolinate reductase [Verrucomicrobiaceae bacterium]	diamond	285	177	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32330903	32330903	PRJNA812715_P_NODE_118999_length_242_cov_0.911243_g117198_i0	PRJNA812715	118999	242	0.911243	2.20520806	Verrucomicrobia bacterium LW23	2161867	Bacteria	Bacteria	71.6	2.4e-12	NR	PTY02311.1	2161867	g117198	i0	43.8	0.991735537190083	80	43	96.7	1	9	242	436	515	PTY02311.1 hypothetical protein DB346_09375 [Verrucomicrobia bacterium LW23]	diamond	240	71.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium LW23

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