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

16 rows where bioproject = "PRJNA1010662", 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
1429761	1429761	PRJNA1010662_S_NODE_3602_length_180_cov_0.846715_g3557_i0	PRJNA1010662	3602	180	0.846715	1.524087	Fontisphaera persica	2974023	Bacteria	Bacteria	267	5.009999999999999e-67	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g3557	i0	93.785	23.15	177	11	98	0	1	177	3861699	3861875	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	4167	267	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
2705192	2705192	PRJNA1010662_P_NODE_9363_length_189_cov_1.357143_g9304_i0	PRJNA1010662	9363	189	1.357143	2.56500027	Terrimicrobium	1649503	Bacteria	Bacteria	91.3	9.19e-20	NR	WP_075080710.1	690879	g9304	i0	71	2.95238095238095	62	18	98.4	0	2	187	241	302	WP_075080710.1 phosphoglycerate kinase [Terrimicrobium sacchariphilum]	diamond	558	91.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sacchariphilum
26622894	26622894	PRJNA1010662_P_NODE_14821_length_165_cov_0.887931_g14762_i0	PRJNA1010662	14821	165	0.887931	1.46508615	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	41.2	0.0416	NR	MCH5284881.1	2562705	g14762	i0	53.1	0.581818181818182	32	15	58.2	0	10	105	85	116	MCH5284881.1 ankyrin repeat domain-containing protein [Akkermansiaceae bacterium]	diamond	96	41.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
26805427	26805427	PRJNA1010662_P_NODE_16801_length_162_cov_0.911504_g16742_i0	PRJNA1010662	16801	162	0.911504	1.47663648	Pseudomonadati	3379134	Bacteria	Bacteria	67.4	2.42e-11	NR	MBD9270101.1	1872421	g16742	i0	64.2	26.5	53	19	98.1	0	2	160	148	200	MBD9270101.1 hypothetical protein [Akkermansia sp.]	diamond	4293	67.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
26844880	26844880	PRJNA1010662_P_NODE_14301_length_166_cov_0.880342_g14242_i0	PRJNA1010662	14301	166	0.880342	1.46136772	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	40.4	0.0184	NR	MEI6082433.1	2026799	g14242	i0	90.9	0.795180722891566	22	2	39.8	0	164	99	59	80	MEI6082433.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	132	40.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27026964	27026964	PRJNA1010662_P_NODE_17082_length_159_cov_2.818182_g17023_i0	PRJNA1010662	17082	159	2.818182	4.48090938	Pseudomonadati	3379134	Bacteria	Bacteria	58.9	2.26e-8	NR	GBL30501.1	2026771	g17023	i0	50	12.622641509434	52	26	98.1	0	158	3	214	265	GBL30501.1 protein F37C4.5 [Opitutia bacterium]	diamond	2007	58.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
28739908	28739908	PRJNA1010662_P_NODE_11007_length_177_cov_2.414062_g10948_i0	PRJNA1010662	11007	177	2.414062	4.27288974	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	46.6	6.58e-4	NR	HYV20656.1	2499141	g10948	i0	52.5	0.677966101694915	40	15	64.4	2	44	157	119	156	HYV20656.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	120	46.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28897644	28897644	PRJNA1010662_P_NODE_8548_length_195_cov_2.493151_g8489_i0	PRJNA1010662	8548	195	2.493151	4.86164445	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	44.7	0.00402	NR	HPY31280.1	2026799	g8489	i0	52.4	1.49230769230769	42	16	64.6	1	11	136	42	79	HPY31280.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	291	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29939935	29939935	PRJNA1010662_P_NODE_1871_length_371_cov_0.860248_g1812_i0	PRJNA1010662	1871	371	0.860248	3.19152008	Chthoniobacter sp.	2510640	Bacteria	Bacteria	47.8	0.00243	NR	MEI9896589.1	2510640	g1812	i0	34.3	0.54177897574124	67	36	47.7	1	259	83	137	203	MEI9896589.1 ATP-binding protein [Chthoniobacter sp.]	diamond	201	47.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
29971332	29971332	PRJNA1010662_P_NODE_4571_length_249_cov_1.025000_g4512_i0	PRJNA1010662	4571	249	1.025	2.55225	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	79	7.31e-15	NR	PYJ03144.1	2026799	g4512	i0	56.6	0.91566265060241	76	32	90.4	1	228	4	422	497	PYJ03144.1 MAG: hypothetical protein DME25_13240, partial [Verrucomicrobiota bacterium]	diamond	228	79	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30224017	30224017	PRJNA1010662_P_NODE_16752_length_162_cov_0.911504_g16693_i0	PRJNA1010662	16752	162	0.911504	1.47663648	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	66.6	4.22e-11	NR	MFK7911771.1	2562705	g16693	i0	58.5	4.87037037037037	53	19	98.1	1	3	161	215	264	MFK7911771.1 phosphonopyruvate decarboxylase [Akkermansiaceae bacterium]	diamond	789	66.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
30792771	30792771	PRJNA1010662_S_NODE_3874_length_174_cov_1.839695_g3829_i0	PRJNA1010662	3874	174	1.839695	3.2010693	Opitutales bacterium	2026772	Bacteria	Bacteria	122	9.42e-32	NR	MBP3357811.1	2026772	g3829	i0	100	1.96551724137931	57	0	98.3	0	3	173	41	97	MBP3357811.1 DUF5009 domain-containing protein [Opitutales bacterium]	diamond	342	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
31203084	31203084	PRJNA1010662_P_NODE_10855_length_178_cov_2.387597_g10796_i0	PRJNA1010662	10855	178	2.387597	4.24992266	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	84.3	1.59e-17	NR	RYD65414.1	2026800	g10796	i0	74.5	0.926966292134832	55	13	92.7	1	14	178	175	228	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	165	84.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
31646207	31646207	PRJNA1010662_P_NODE_12157_length_170_cov_1.966942_g12098_i0	PRJNA1010662	12157	170	1.966942	3.3438014	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	60.1	1.01e-8	NR	MBX3733285.1	2499141	g12098	i0	60	0.882352941176471	50	20	88.2	0	167	18	35	84	MBX3733285.1 Gfo/Idh/MocA family oxidoreductase [Verrucomicrobiia bacterium]	diamond	150	60.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31646209	31646209	PRJNA1010662_P_NODE_12777_length_168_cov_1.546218_g12718_i0	PRJNA1010662	12777	168	1.546218	2.59764624	Opitutales bacterium	2026772	Bacteria	Bacteria	42	0.0251	NR	NRA25691.1	2026772	g12718	i0	60	1.60714285714286	30	7	53.6	1	6	95	455	479	NRA25691.1 NADP-dependent isocitrate dehydrogenase [Opitutales bacterium]	diamond	270	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
32342630	32342630	PRJNA1010662_P_NODE_13599_length_167_cov_0.881356_g13540_i0	PRJNA1010662	13599	167	0.881356	1.47186452	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.1	0.00977	NR	MBS0626245.1	2026799	g13540	i0	42	1.81437125748503	50	27	89.8	1	16	165	83	130	MBS0626245.1 sugar porter family MFS transporter [Verrucomicrobiota bacterium]	diamond	303	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;