metadata: contig_metadata: 26 rows where analysis = "diamond", bioproject = "PRJNA1092581" and tax

26 rows where analysis = "diamond", bioproject = "PRJNA1092581" 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
5300538	5300538	PRJNA1092581_P_NODE_72825_length_305_cov_141.000000_g72292_i0	PRJNA1092581	72825	305	141	430.05	Luteolibacter sp.	1962973	Bacteria	Bacteria	159	1.94e-44	NR	MFT4177135.1	1962973	g72292	i0	78.5	1.82950819672131	93	20	91.5	0	300	22	267	359	MFT4177135.1 aminopeptidase P N-terminal domain-containing protein [Luteolibacter sp.]	diamond	558	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
5300705	5300705	PRJNA1092581_P_NODE_79585_length_290_cov_2.834101_g79052_i0	PRJNA1092581	79585	290	2.834101	8.2188929	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	97.4	8.24e-23	NR	WP_069962304.1	1838286	g79052	i0	61.7	0.972413793103448	94	26	93.1	2	290	21	28	115	WP_069962304.1 flagellar basal body-associated FliL family protein [Lacunisphaera limnophila]	diamond	282	97.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
26655811	26655811	PRJNA1092581_P_NODE_23501_length_574_cov_5.113772_g22975_i0	PRJNA1092581	23501	574	5.113772	29.35305128	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	61.6	1.24e-8	NR	MCX8511623.1	2811408	g22975	i0	44.1	0.355400696864112	68	38	35.5	0	226	23	16	83	MCX8511623.1 GIY-YIG nuclease family protein [Chthoniobacteraceae bacterium]	diamond	204	61.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
26940889	26940889	PRJNA1092581_P_NODE_118582_length_226_cov_2.718954_g118049_i0	PRJNA1092581	118582	226	2.718954	6.14483604	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	72.8	1.06e-13	NR	HEX8311414.1	2811408	g118049	i0	53.1	0.849557522123894	64	30	85	0	221	30	93	156	HEX8311414.1 hypothetical protein [Chthoniobacteraceae bacterium]	diamond	192	72.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
26972582	26972582	PRJNA1092581_P_NODE_48962_length_385_cov_3.371795_g48429_i0	PRJNA1092581	48962	385	3.371795	12.98141075	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	200	1.59e-60	NR	MBS0629289.1	2026799	g48429	i0	79.3	0.942857142857143	121	25	94.3	0	22	384	1	121	MBS0629289.1 23S rRNA (adenine(2503)-C(2))-methyltransferase RlmN [Verrucomicrobiota bacterium]	diamond	363	200	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27257198	27257198	PRJNA1092581_P_NODE_117823_length_227_cov_3.337662_g117290_i0	PRJNA1092581	117823	227	3.337662	7.57649274	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	107	5.25e-25	NR	HKX61339.1	2499141	g117290	i0	75.4	0.859030837004405	65	16	85.9	0	15	209	290	354	HKX61339.1 1-acyl-sn-glycerol-3-phosphate acyltransferase [Verrucomicrobiia bacterium]	diamond	195	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27478354	27478354	PRJNA1092581_P_NODE_101183_length_251_cov_2.573034_g100650_i0	PRJNA1092581	101183	251	2.573034	6.45831534	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	159	3.2599999999999993e-43	NR	MFN4874371.1	2562705	g100650	i0	94.9	0.932270916334661	78	4	93.2	0	235	2	319	396	MFN4874371.1 DUF6288 domain-containing protein [Akkermansiaceae bacterium]	diamond	234	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
27731302	27731302	PRJNA1092581_P_NODE_92604_length_265_cov_1.588542_g92071_i0	PRJNA1092581	92604	265	1.588542	4.2096363	Prosthecobacter sp.	1965333	Bacteria	Bacteria	49.7	1.78e-4	NR	WP_294227263.1	1965333	g92071	i0	51.9	0.588679245283019	52	17	58.9	1	109	264	577	620	WP_294227263.1 caspase family protein [Prosthecobacter sp.]	diamond	156	49.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
27762796	27762796	PRJNA1092581_P_NODE_111644_length_237_cov_4.573171_g111111_i0	PRJNA1092581	111644	237	4.573171	10.83841527	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	87.8	4.61e-18	NR	XHR26832.1	2811408	g111111	i0	54.2	0.911392405063291	72	33	91.1	0	226	11	216	287	XHR26832.1 MAG: heparinase II/III family protein [Chthoniobacteraceae bacterium]	diamond	216	87.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
28015248	28015248	PRJNA1092581_P_NODE_124685_length_208_cov_4.111111_g124152_i0	PRJNA1092581	124685	208	4.111111	8.55111088	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	122	2.8699999999999997e-30	NR	MDQ3118317.1	2026799	g124152	i0	87.1	0.894230769230769	62	8	89.4	0	12	197	126	187	MDQ3118317.1 molybdopterin-dependent oxidoreductase [Verrucomicrobiota bacterium]	diamond	186	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28038219	28038219	PRJNA1092581_P_NODE_107885_length_243_cov_1.164706_g107352_i0	PRJNA1092581	107885	243	1.164706	2.83023558	root	1	Root_unresolved	Root_unresolved	115	4.5e-29	NR	OYV03690.1	2015575	g107352	i0	67.5	8.90123456790123	80	26	98.8	0	240	1	64	143	OYV03690.1 MAG: hypothetical protein CFE26_20825 [Verrucomicrobiales bacterium VVV1]	diamond	2163	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium VVV1
28078177	28078177	PRJNA1092581_P_NODE_101105_length_251_cov_3.067416_g100572_i0	PRJNA1092581	101105	251	3.067416	7.69921416	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	90.9	4.88e-19	NR	MBI3869869.1	2026799	g100572	i0	61	0.920318725099602	77	30	92	0	21	251	1910	1986	MBI3869869.1 VCBS repeat-containing protein [Verrucomicrobiota bacterium]	diamond	231	90.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28835993	28835993	PRJNA1092581_P_NODE_33448_length_477_cov_4.059406_g32916_i0	PRJNA1092581	33448	477	4.059406	19.36336662	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	166	3.1599999999999996e-47	NR	MEC7609401.1	2026799	g32916	i0	56.8	0.918238993710692	146	62	91.8	1	445	8	90	234	MEC7609401.1 ribonuclease H family protein [Verrucomicrobiota bacterium]	diamond	438	166	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28930874	28930874	PRJNA1092581_P_NODE_92588_length_265_cov_1.604167_g92055_i0	PRJNA1092581	92588	265	1.604167	4.25104255	Verrucomicrobia bacterium Tous-C9LFEB	1982333	Bacteria	Bacteria	140	1.45e-39	NR	PAW78676.1	1982333	g92055	i0	92.7	0.928301886792453	82	6	92.8	0	253	8	128	209	PAW78676.1 MAG: deoxyribose-phosphate aldolase [Verrucomicrobia bacterium Tous-C9LFEB]	diamond	246	140	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium Tous-C9LFEB
28962572	28962572	PRJNA1092581_P_NODE_10228_length_846_cov_5.944373_g9793_i0	PRJNA1092581	10228	846	5.944373	50.28939558	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	239	9.15e-76	NR	MBI2927909.1	2026799	g9793	i0	84.5	0.549645390070922	155	23	54.6	1	8	469	38	192	MBI2927909.1 DUF2589 domain-containing protein [Verrucomicrobiota bacterium]	diamond	465	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29088751	29088751	PRJNA1092581_P_NODE_74248_length_302_cov_4.685590_g73715_i0	PRJNA1092581	74248	302	4.68559	14.1504818	Prosthecobacter debontii	48467	Bacteria	Bacteria	186	1.78e-56	NR	WP_078812677.1	48467	g73715	i0	91.6	3.77483443708609	95	8	94.4	0	286	2	146	240	WP_078812677.1 ROK family protein [Prosthecobacter debontii]	diamond	1140	186	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
29174952	29174952	PRJNA1092581_P_NODE_59889_length_342_cov_10.434944_g59356_i0	PRJNA1092581	59889	342	10.434944	35.68750848	Opitutus	178440	Bacteria	Bacteria	141	1.17e-36	NR	MCS6244044.1	1913982	g59356	i0	85.2	2.20175438596491	81	12	71.1	0	80	322	5	85	MCS6244044.1 hypothetical protein [Opitutus sp.]	diamond	753	142	0.992957746478873	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
29530720	29530720	PRJNA1092581_P_NODE_102970_length_249_cov_1.397727_g102437_i0	PRJNA1092581	102970	249	1.397727	3.48034023	Chthoniobacter sp.	2510640	Bacteria	Bacteria	77.8	2.46e-15	NR	MDB6150894.1	2510640	g102437	i0	48.6	0.891566265060241	74	37	89.2	1	23	244	9	81	MDB6150894.1 hypothetical protein [Chthoniobacter sp.]	diamond	222	77.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
29624935	29624935	PRJNA1092581_P_NODE_71230_length_310_cov_1.341772_g70697_i0	PRJNA1092581	71230	310	1.341772	4.1594932	Luteolibacter sp. SL25	1962973	Bacteria	Bacteria	155	2.68e-41	NR	WP_267670376.1	2995170	g70697	i0	83.1	0.861290322580645	89	15	86.1	0	21	287	613	701	WP_267670376.1 ATP-dependent helicase HrpB [Luteolibacter sp. SL250]	diamond	267	155	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
30099021	30099021	PRJNA1092581_P_NODE_69832_length_313_cov_5.162500_g69299_i0	PRJNA1092581	69832	313	5.1625	16.158625	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	60.5	1.51e-8	NR	MDC0319417.1	2026799	g69299	i0	54	1.87859424920128	63	29	60.4	0	297	109	24	86	MDC0319417.1 ankyrin repeat domain-containing protein [Verrucomicrobiota bacterium]	diamond	588	60.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30383938	30383938	PRJNA1092581_P_NODE_39033_length_438_cov_6.323288_g38500_i0	PRJNA1092581	39033	438	6.323288	27.69600144	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	73.6	4.88e-13	NR	MBI2927908.1	2026799	g38500	i0	57.7	0.534246575342466	78	31	53.4	1	1	234	107	182	MBI2927908.1 DUF2589 domain-containing protein [Verrucomicrobiota bacterium]	diamond	234	73.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30446910	30446910	PRJNA1092581_P_NODE_33193_length_479_cov_5.687192_g32661_i0	PRJNA1092581	33193	479	5.687192	27.24164968	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	70.1	8.91e-11	NR	HST77250.1	2499141	g32661	i0	56.5	0.388308977035491	62	25	38.2	2	187	5	1	61	HST77250.1 DUF932 domain-containing protein [Verrucomicrobiia bacterium]	diamond	186	70.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30857407	30857407	PRJNA1092581_P_NODE_91294_length_267_cov_3.175258_g90761_i0	PRJNA1092581	91294	267	3.175258	8.47793886	Opitutia bacterium AMD-G1	1982316	Bacteria	Bacteria	170	5.219999999999998e-47	NR	PAZ03914.1	1982316	g90761	i0	96.4	1.86516853932584	83	3	93.3	0	259	11	259	341	PAZ03914.1 MAG: hypothetical protein CAK86_06585 [Opitutia bacterium AMD-G1]	diamond	498	170	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium AMD-G1
31489917	31489917	PRJNA1092581_P_NODE_48296_length_388_cov_2.828571_g47763_i0	PRJNA1092581	48296	388	2.828571	10.97485548	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	113	2.9100000000000004e-26	NR	MES2660535.1	2026799	g47763	i0	73	1.77835051546392	115	31	88.9	0	366	22	459	573	MES2660535.1 right-handed parallel beta-helix repeat-containing protein [Verrucomicrobiota bacterium]	diamond	690	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32217357	32217357	PRJNA1092581_P_NODE_76478_length_297_cov_2.397321_g75945_i0	PRJNA1092581	76478	297	2.397321	7.12004337	Prosthecobacter sp.	1965333	Bacteria	Bacteria	185	5.02e-53	NR	HEY1081139.1	1965333	g75945	i0	96.8	3.75757575757576	93	3	93.9	0	279	1	81	173	HEY1081139.1 response regulator [Prosthecobacter sp.]	diamond	1116	185	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
32375612	32375612	PRJNA1092581_P_NODE_37699_length_447_cov_3.122995_g37167_i0	PRJNA1092581	37699	447	3.122995	13.95978765	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	178	2.33e-52	NR	MFM7183049.1	2026801	g37167	i0	60.8	0.959731543624161	143	55	96	1	18	446	15	156	MFM7183049.1 methyltransferase domain-containing protein [Verrucomicrobiales bacterium]	diamond	429	178	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales 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);;