metadata: contig_metadata: 16 rows where bioproject = "PRJNA993416", tax_clade = "PVC group" and tax

16 rows where bioproject = "PRJNA993416", tax_clade = "PVC group" 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
975790	975790	PRJNA993416_P_NODE_13481_length_248_cov_0.880000_g13376_i0	PRJNA993416	13481	248	0.88	2.1824	Akkermansia muciniphila	239935	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1805906055\|gb\|CP027004.1\|	239935	g13376	i0	100	96.9798387096774	248	0	100	0	1	248	2514706	2514953	Akkermansia muciniphila strain EB-AMDK-28 chromosome, complete genome	blastn	24051	459	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
12454926	12454926	PRJNA993416_P_NODE_11450_length_260_cov_1.647059_g11345_i0	PRJNA993416	11450	260	1.647059	4.2823534	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	204	6.179999999999999e-48	NTclustered	gi\|226525317\|gb\|FJ872374.1\|	156588	g11345	i0	81.061	1.99615384615385	264	43	100	7	1	260	29209	28949	Uncultured Verrucomicrobia bacterium clone 184 genomic sequence	blastn	519	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
15003748	15003748	PRJNA993416_P_NODE_12132_length_253_cov_1.405556_g12027_i0	PRJNA993416	12132	253	1.405556	3.55605668	Verrucomicrobiota	74201	Bacteria	Bacteria	172	4.55e-48	NR	MBP7140302.1	2006848	g12027	i0	94	10.9565217391304	84	5	99.6	0	2	253	161	244	MBP7140302.1 molybdopterin oxidoreductase family protein [Opitutaceae bacterium]	diamond	2772	172	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
20102326	20102326	PRJNA993416_P_NODE_14996_length_244_cov_0.900585_g14891_i0	PRJNA993416	14996	244	0.900585	2.1974274	Akkermansia muciniphila	239935	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g14891	i0	100	100	244	0	100	0	1	244	2167892	2168135	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	24400	451	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
26931568	26931568	PRJNA993416_P_NODE_3822_length_432_cov_1.111421_g3717_i0	PRJNA993416	3822	432	1.111421	4.80133872	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	45.4	0.0284	NR	MBV9104492.1	2026799	g3717	i0	31.7	0.833333333333333	120	55	64.6	5	93	371	362	481	MBV9104492.1 urea ABC transporter permease subunit UrtB [Verrucomicrobiota bacterium]	diamond	360	45.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27500605	27500605	PRJNA993416_P_NODE_12263_length_251_cov_3.308989_g12158_i0	PRJNA993416	12263	251	3.308989	8.30556239	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.5	0.0154	NR	MEI6341235.1	2026799	g12158	i0	37.3	0.896414342629482	75	38	78.9	2	43	240	84	158	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	225	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27563332	27563332	PRJNA993416_P_NODE_15984_length_241_cov_2.232143_g15879_i0	PRJNA993416	15984	241	2.232143	5.37946463	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	48.5	3.42e-4	NR	MDE3066333.1	2026799	g15879	i0	33.8	1.9792531120332	77	46	95.9	1	231	1	863	934	MDE3066333.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	477	48.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27595324	27595324	PRJNA993416_P_NODE_11264_length_262_cov_1.608466_g11159_i0	PRJNA993416	11264	262	1.608466	4.21418092	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	75.5	1.27e-13	NR	PWU15473.1	2026799	g11159	i0	77.5	0.916030534351145	40	9	45.8	0	261	142	380	419	PWU15473.1 MAG: polyvinylalcohol dehydrogenase [Verrucomicrobiota bacterium]	diamond	240	75.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27626929	27626929	PRJNA993416_P_NODE_13304_length_249_cov_0.875000_g13199_i0	PRJNA993416	13304	249	0.875	2.17875	Candidatus Didemnitutus sp.	2814259	Bacteria	Bacteria	71.2	3.8e-12	NR	MDP1580755.1	2814259	g13199	i0	51.8	1	83	39	100	1	1	249	5	86	MDP1580755.1 autotransporter-associated beta strand repeat-containing protein [Candidatus Didemnitutus sp.]	diamond	249	71.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Candidatus Didemnitutus	Candidatus Didemnitutus sp.
28068757	28068757	PRJNA993416_P_NODE_11205_length_263_cov_1.094737_g11100_i0	PRJNA993416	11205	263	1.094737	2.87915831	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.9	0.0148	NR	MBI3878456.1	2026799	g11100	i0	37.7	0.695817490494297	61	36	67.3	1	182	6	5	65	MBI3878456.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	183	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29426283	29426283	PRJNA993416_P_NODE_10849_length_266_cov_1.595855_g10744_i0	PRJNA993416	10849	266	1.595855	4.2449743	Terrimicrobiaceae bacterium	2832348	Bacteria	Bacteria	50.1	2.53e-5	NR	MDD5199212.1	2832348	g10744	i0	41.3	0.710526315789474	63	36	71.1	1	30	218	15	76	MDD5199212.1 hypothetical protein [Terrimicrobiaceae bacterium]	diamond	189	50.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae		Terrimicrobiaceae bacterium
29457735	29457735	PRJNA993416_P_NODE_10110_length_273_cov_1.345000_g10005_i0	PRJNA993416	10110	273	1.345	3.67185	Opitutales bacterium	2026772	Bacteria	Bacteria	102	3.569999999999999e-23	NR	MCX6944840.1	2026772	g10005	i0	61.6	1.89010989010989	86	33	94.5	0	16	273	119	204	MCX6944840.1 ThiF family adenylyltransferase [Opitutales bacterium]	diamond	516	102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
29653041	29653041	PRJNA993416_P_NODE_1330_length_729_cov_1.059451_g1234_i0	PRJNA993416	1330	729	1.059451	7.72339779	root	1	Root_unresolved	Root_unresolved	73.2	7.66e-13	NR	NBR46345.1	2026799	g1234	i0	44	1.80658436213992	100	42	41.2	4	652	353	5	90	NBR46345.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	1317	73.9	0.990527740189445	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29716231	29716231	PRJNA993416_P_NODE_15970_length_242_cov_0.857988_g15865_i0	PRJNA993416	15970	242	0.857988	2.07633096	Opitutaceae	134623	Bacteria	Bacteria	101	1.54e-23	NR	MBA4136743.1	1913982	g15865	i0	62	1.95867768595041	79	30	97.9	0	239	3	261	339	MBA4136743.1 hypothetical protein [Opitutus sp.]	diamond	474	102	0.990196078431373	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
30000932	30000932	PRJNA993416_P_NODE_9111_length_282_cov_1.277512_g9006_i0	PRJNA993416	9111	282	1.277512	3.60258384	Verrucomicrobiota	74201	Bacteria	Bacteria	154	1.7799999999999994e-42	NR	RYD73312.1	2026800	g9006	i0	80.9	3	94	18	100	0	282	1	211	304	RYD73312.1 MAG: DUF1501 domain-containing protein [Verrucomicrobiaceae bacterium]	diamond	846	155	0.993548387096774	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
31106487	31106487	PRJNA993416_P_NODE_4815_length_380_cov_2.211726_g4710_i0	PRJNA993416	4815	380	2.211726	8.4045588	Bacteria	2	Bacteria	Bacteria	117	2.5199999999999997e-30	NR	MBA4136732.1	1913982	g4710	i0	63.2	1.39736842105263	87	32	68.7	0	380	120	80	166	MBA4136732.1 hypothetical protein [Opitutus sp.]	diamond	531	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus 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);;