metadata: contig_metadata: 9 rows where bioproject = "PRJNA917598", tax_clade = "PVC group" and tax

9 rows where bioproject = "PRJNA917598", 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
12731160	12731160	PRJNA917598_P_NODE_88290_length_246_cov_0.890173_g87346_i0	PRJNA917598	88290	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	150	4.09e-41	NR	MBL6922653.1	2562705	g87346	i0	85.2	7.90243902439024	81	12	98.8	0	2	244	42	122	MBL6922653.1 adenosylhomocysteinase [Akkermansiaceae bacterium]	diamond	1944	150	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
16199343	16199343	PRJNA917598_P_NODE_59213_length_293_cov_2.077273_g58269_i0	PRJNA917598	59213	293	2.077273	6.08640989	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	294	4.09e-75	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g58269	i0	85.274	123.156996587031	292	36	99	7	1	289	3989696	3989983	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	36085	294	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
21298766	21298766	PRJNA917598_P_NODE_72057_length_268_cov_0.846154_g71113_i0	PRJNA917598	72057	268	0.846154	2.26769272	Pedosphaera parvula	1032527	Bacteria	Bacteria	388	1.65e-103	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g71113	i0	93.182	84.9365671641791	264	18	99	0	1	264	941	1204	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	22763	388	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
23848780	23848780	PRJNA917598_P_NODE_61859_length_287_cov_2.228972_g60915_i0	PRJNA917598	61859	287	2.228972	6.39714964	uncultured Ruficoccus sp.	2175960	Bacteria	Bacteria	279	1.12e-70	NTclustered	gi\|2907625921\|emb\|OZ223481.1\|	2175960	g60915	i0	85.874	105.435540069686	269	30	92	7	23	287	741277	741013	MAG: uncultured Ruficoccus sp. isolate b2a3d85c-2e17-47e2-9e32-7ac6437316b9 genome assembly, chromosome: 10	blastn	30260	279	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Ruficoccus	uncultured Ruficoccus sp.
26866669	26866669	PRJNA917598_P_NODE_82881_length_249_cov_0.875000_g81937_i0	PRJNA917598	82881	249	0.875	2.17875	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	56.6	1.12e-7	NR	PYJ10251.1	2026799	g81937	i0	38.2	1.89156626506024	76	47	91.6	0	17	244	56	131	PYJ10251.1 MAG: hypothetical protein DMF06_07005 [Verrucomicrobiota bacterium]	diamond	471	56.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27031827	27031827	PRJNA917598_P_NODE_59782_length_292_cov_1.050228_g58838_i0	PRJNA917598	59782	292	1.050228	3.06666576	Bacteria	2	Bacteria	Bacteria	147	1.15e-38	NR	MEO6034374.1	2026799	g58838	i0	67.7	4.86986301369863	96	31	98.6	0	3	290	795	890	MEO6034374.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	1422	148	0.993243243243243	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29424439	29424439	PRJNA917598_P_NODE_3229_length_1391_cov_1.602428_g2682_i0	PRJNA917598	3229	1391	1.602428	22.28977348	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	114	1.08e-22	NR	MCX6897038.1	2026799	g2682	i0	34.5	0.474478792235802	220	124	43.8	5	1390	782	500	716	MCX6897038.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	660	114	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30719692	30719692	PRJNA917598_P_NODE_76014_length_259_cov_1.241935_g75070_i0	PRJNA917598	76014	259	1.241935	3.21661165	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	53.1	3.41e-6	NR	HEY3931881.1	2499141	g75070	i0	28.6	2.93050193050193	84	60	97.3	0	6	257	11	94	HEY3931881.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	759	53.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31896773	31896773	PRJNA917598_P_NODE_86297_length_247_cov_0.885057_g85353_i0	PRJNA917598	86297	247	0.885057	2.18609079	Pseudomonadati	3379134	Bacteria	Bacteria	54.3	3.06e-6	NR	MCX6894423.1	2026799	g85353	i0	43.1	1.36032388663968	58	30	66.8	1	246	82	16	73	MCX6894423.1 tetratricopeptide repeat protein [Verrucomicrobiota bacterium]	diamond	336	54.3	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);;