metadata: contig_metadata: 22 rows where bioproject = "PRJNA217180", tax_clade = "PVC group" and tax

22 rows where bioproject = "PRJNA217180", 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
5470437	5470437	PRJNA217180_P_NODE_12465_length_167_cov_0.864407_g12365_i0	PRJNA217180	12465	167	0.864407	1.44355969	Nibricoccus	2576890	Bacteria	Bacteria	119	5.67e-30	NR	MDP3073946.1	2006848	g12365	i0	90.9	12.8443113772455	55	5	98.8	0	3	167	339	393	MDP3073946.1 deoxyribodipyrimidine photo-lyase [Opitutaceae bacterium]	diamond	2145	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
26630844	26630844	PRJNA217180_P_NODE_13961_length_164_cov_0.886957_g13861_i0	PRJNA217180	13961	164	0.886957	1.45460948	Prosthecobacter algae	1144682	Bacteria	Bacteria	83.6	3.49e-17	NR	WP_345736208.1	1144682	g13861	i0	67.9	0.969512195121951	53	17	97	0	3	161	52	104	WP_345736208.1 hypothetical protein [Prosthecobacter algae]	diamond	159	83.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter algae
27136750	27136750	PRJNA217180_P_NODE_11522_length_174_cov_1.384000_g11422_i0	PRJNA217180	11522	174	1.384	2.40816	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	50.1	3.87e-5	NR	MBN9689887.1	2026799	g11422	i0	67.6	0.637931034482759	37	12	63.8	0	61	171	1	37	MBN9689887.1 bifunctional methionine sulfoxide reductase B/A protein [Verrucomicrobiota bacterium]	diamond	111	50.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27421851	27421851	PRJNA217180_P_NODE_14423_length_163_cov_0.894737_g14323_i0	PRJNA217180	14423	163	0.894737	1.45842131	Luteolibacter sp.	1962973	Bacteria	Bacteria	51.2	9.38e-6	NR	HEX7261125.1	1962973	g14323	i0	55.6	0.993865030674847	54	24	99.4	0	2	163	51	104	HEX7261125.1 hypothetical protein [Luteolibacter sp.]	diamond	162	51.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
27453384	27453384	PRJNA217180_P_NODE_11043_length_178_cov_1.480620_g10943_i0	PRJNA217180	11043	178	1.48062	2.6355036	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	110	1.19e-27	NR	MBP7947989.1	2026799	g10943	i0	96.4	0.926966292134832	55	2	92.7	0	2	166	266	320	MBP7947989.1 phage major capsid protein [Verrucomicrobiota bacterium]	diamond	165	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27453387	27453387	PRJNA217180_P_NODE_13623_length_165_cov_0.879310_g13523_i0	PRJNA217180	13623	165	0.87931	1.4508615	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	51.6	9.79e-6	NR	MFN6271039.1	2562705	g13523	i0	56.4	1	55	20	100	1	165	1	28	78	MFN6271039.1 phage major capsid protein [Akkermansiaceae bacterium]	diamond	165	51.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
27516338	27516338	PRJNA217180_P_NODE_13863_length_164_cov_0.886957_g13763_i0	PRJNA217180	13863	164	0.886957	1.45460948	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	62.8	9.47e-10	NR	MCL4785581.1	2026799	g13763	i0	60.4	1.75609756097561	48	19	87.8	0	18	161	99	146	MCL4785581.1 GDP-mannose 4,6-dehydratase [Verrucomicrobiota bacterium]	diamond	288	62.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27990053	27990053	PRJNA217180_P_NODE_10925_length_179_cov_1.553846_g10825_i0	PRJNA217180	10925	179	1.553846	2.78138434	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	63.9	5.3e-10	NR	MEY3898822.1	2026799	g10825	i0	58.9	2.76536312849162	56	23	93.9	0	175	8	209	264	MEY3898822.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	495	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28639409	28639409	PRJNA217180_P_NODE_10427_length_183_cov_1.455224_g10327_i0	PRJNA217180	10427	183	1.455224	2.66305992	Prosthecobacter	48463	Bacteria	Bacteria	81.3	6.06e-17	NR	WP_377170520.1	445931	g10327	i0	61.7	8.85245901639344	60	23	98.4	0	2	181	79	138	WP_377170520.1 hypothetical protein [Prosthecobacter fluviatilis]	diamond	1620	82	0.991463414634146	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fluviatilis
28684783	28684783	PRJNA217180_P_NODE_13367_length_165_cov_0.879310_g13267_i0	PRJNA217180	13367	165	0.87931	1.4508615	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	46.2	7.47e-4	NR	MBK28601.1	2026801	g13267	i0	46.9	0.890909090909091	49	24	85.5	1	141	1	87	135	MBK28601.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	147	46.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28796870	28796870	PRJNA217180_P_NODE_14327_length_163_cov_0.894737_g14227_i0	PRJNA217180	14327	163	0.894737	1.45842131	Pseudomonadati	3379134	Bacteria	Bacteria	50.1	1.45e-5	NR	HQF39034.1	2006848	g14227	i0	47.8	2.59509202453988	46	24	84.7	0	20	157	17	62	HQF39034.1 HNH endonuclease signature motif containing protein [Opitutaceae bacterium]	diamond	423	50.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28905352	28905352	PRJNA217180_P_NODE_14128_length_164_cov_0.886957_g14028_i0	PRJNA217180	14128	164	0.886957	1.45460948	Prosthecobacter sp.	1965333	Bacteria	Bacteria	49.3	6.21e-5	NR	MEQ1752006.1	1965333	g14028	i0	73.3	0.548780487804878	30	8	54.9	0	4	93	693	722	MEQ1752006.1 hypothetical protein [Prosthecobacter sp.]	diamond	90	49.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
28968838	28968838	PRJNA217180_P_NODE_9808_length_188_cov_1.294964_g9708_i0	PRJNA217180	9808	188	1.294964	2.43453232	Opitutaceae bacterium	2006848	Bacteria	Bacteria	63.2	1.13e-9	NR	HVS53099.1	2006848	g9708	i0	50.8	0.973404255319149	61	30	97.3	0	185	3	606	666	HVS53099.1 response regulator [Opitutaceae bacterium]	diamond	183	63.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
29252662	29252662	PRJNA217180_P_NODE_15389_length_161_cov_0.910714_g15289_i0	PRJNA217180	15389	161	0.910714	1.46624954	Prosthecobacter dejongeii	48465	Bacteria	Bacteria	75.9	2.34e-14	NR	WP_184208875.1	48465	g15289	i0	71.2	0.968944099378882	52	15	96.9	0	3	158	273	324	WP_184208875.1 CHC2 zinc finger domain-containing protein [Prosthecobacter dejongeii]	diamond	156	75.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
29631520	29631520	PRJNA217180_P_NODE_14870_length_162_cov_0.902655_g14770_i0	PRJNA217180	14870	162	0.902655	1.4623011	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	60.1	5.77e-10	NR	HBA85984.1	2026799	g14770	i0	57.8	0.833333333333333	45	19	83.3	0	6	140	50	94	HBA85984.1 HNH endonuclease [Verrucomicrobiota bacterium]	diamond	135	60.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29979188	29979188	PRJNA217180_P_NODE_14111_length_164_cov_0.886957_g14011_i0	PRJNA217180	14111	164	0.886957	1.45460948	Lacunisphaera sp.	1961806	Bacteria	Bacteria	78.6	3.39e-17	NR	HQY06965.1	1961806	g14011	i0	68.5	0.98780487804878	54	17	98.8	0	162	1	9	62	HQY06965.1 hypothetical protein [Lacunisphaera sp.]	diamond	162	78.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
30073832	30073832	PRJNA217180_P_NODE_12212_length_168_cov_1.546218_g12112_i0	PRJNA217180	12212	168	1.546218	2.59764624	Verrucomicrobia bacterium RIFCSPHIGHO2_12_FULL_41_1	1802433	Bacteria	Bacteria	94.7	3.9200000000000006e-21	NR	OHE76725.1	1802433	g12112	i0	83.6	0.982142857142857	55	9	98.2	0	167	3	201	255	OHE76725.1 MAG: transposase [Verrucomicrobia bacterium RIFCSPHIGHO2_12_FULL_41_10]	diamond	165	94.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium RIFCSPHIGHO2_12_FULL_41_10
30453373	30453373	PRJNA217180_P_NODE_12113_length_169_cov_1.375000_g12013_i0	PRJNA217180	12113	169	1.375	2.32375	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	65.9	9.61e-11	NR	MDB6169026.1	2026799	g12013	i0	48.2	0.994082840236686	56	29	99.4	0	168	1	208	263	MDB6169026.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	168	65.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32413641	32413641	PRJNA217180_P_NODE_14799_length_162_cov_0.902655_g14699_i0	PRJNA217180	14799	162	0.902655	1.4623011	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	70.5	2e-12	NR	MEY3894838.1	2026799	g14699	i0	54.7	0.981481481481482	53	24	98.1	0	3	161	350	402	MEY3894838.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	159	70.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32431424	32431424	PRJNA217180_P_NODE_12699_length_167_cov_0.864407_g12599_i0	PRJNA217180	12699	167	0.864407	1.44355969	root	1	Root_unresolved	Root_unresolved	44.3	0.00359	NR	OUU25843.1	1986791	g12599	i0	80	2.67664670658683	25	5	44.9	0	6	80	228	252	OUU25843.1 MAG: hypothetical protein CBC04_06025 [Verrucomicrobia bacterium TMED44]	diamond	447	44.7	0.991051454138702	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium TMED44
32476984	32476984	PRJNA217180_P_NODE_15059_length_162_cov_0.902655_g14959_i0	PRJNA217180	15059	162	0.902655	1.4623011	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	92	5.95e-21	NR	MBJ7392213.1	2201154	g14959	i0	82.7	0.962962962962963	52	9	96.3	0	2	157	42	93	MBJ7392213.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	156	92	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32603213	32603213	PRJNA217180_P_NODE_12860_length_166_cov_0.871795_g12760_i0	PRJNA217180	12860	166	0.871795	1.4471797	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	50.1	3.31e-5	NR	MBX3747309.1	2499141	g12760	i0	45.3	0.957831325301205	53	29	95.8	0	161	3	107	159	MBX3747309.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	159	50.1	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);;