metadata: contig_metadata: 10 rows where bioproject = "PRJNA485080", tax_clade = "PVC group" and tax

10 rows where bioproject = "PRJNA485080", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
14477712	14477712	PRJNA485080_P_NODE_26772_length_249_cov_0.875000_g26678_i0	PRJNA485080	26772	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	137	6.789999999999999e-37	NR	MBC8108210.1	2026778	g26678	i0	78.3	3.96385542168675	83	18	100	0	1	249	234	316	MBC8108210.1 phospho-N-acetylmuramoyl-pentapeptide-transferase [Phycisphaerae bacterium]	diamond	987	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
14477810	14477810	PRJNA485080_P_NODE_33072_length_246_cov_0.890173_g32978_i0	PRJNA485080	33072	246	0.890173	2.18982558	Humisphaera borealis	2807512	Bacteria	Bacteria	145	7.08e-39	NR	WP_206294808.1	2807512	g32978	i0	84.1	4	82	13	100	0	246	1	215	296	WP_206294808.1 hypothetical protein [Humisphaera borealis]	diamond	984	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
18300886	18300886	PRJNA485080_P_NODE_36755_length_244_cov_0.900585_g36661_i0	PRJNA485080	36755	244	0.900585	2.1974274	Limnoglobus roseus	2598579	Bacteria	Bacteria	329	9.08e-86	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g36661	i0	91.322	127.094262295082	242	19	99	2	1	241	2956909	2957149	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	31011	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
20850723	20850723	PRJNA485080_P_NODE_24517_length_250_cov_0.870056_g24423_i0	PRJNA485080	24517	250	0.870056	2.17514	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	84.3	9.62e-17	NR	MEX0777320.1	2026777	g24423	i0	57.1	3.996	84	35	99.6	1	250	2	1606	1689	MEX0777320.1 PQQ-dependent sugar dehydrogenase [Phycisphaeraceae bacterium]	diamond	999	84.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
29839640	29839640	PRJNA485080_P_NODE_23751_length_250_cov_0.870056_g23657_i0	PRJNA485080	23751	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	114	7.449999999999998e-30	NR	HVK15909.1	1914235	g23657	i0	71.4	3.336	70	20	84	0	211	2	3	72	HVK15909.1 SAM-dependent chlorinase/fluorinase [Fimbriiglobus sp.]	diamond	834	114	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus sp.
29949969	29949969	PRJNA485080_P_NODE_26771_length_249_cov_0.875000_g26677_i0	PRJNA485080	26771	249	0.875	2.17875	uncultured Rubinisphaera sp.	1678686	Bacteria	Bacteria	45.4	0.00349	NR	WP_339743927.1	1678686	g26677	i0	46	1.19277108433735	50	24	60.2	1	213	64	4	50	WP_339743927.1 immunity 26/phosphotriesterase HocA family protein [uncultured Rubinisphaera sp.]	diamond	297	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Rubinisphaera	uncultured Rubinisphaera sp.
30361135	30361135	PRJNA485080_P_NODE_29392_length_248_cov_0.880000_g29298_i0	PRJNA485080	29392	248	0.88	2.1824	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.7	0.00812	NR	MBL8726187.1	2026780	g29298	i0	38	0.604838709677419	50	30	60.5	1	23	172	285	333	MBL8726187.1 hypothetical protein [Planctomycetota bacterium]	diamond	150	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30992657	30992657	PRJNA485080_P_NODE_37134_length_244_cov_0.900585_g37040_i0	PRJNA485080	37134	244	0.900585	2.1974274	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	41.2	0.0427	NR	HCD32792.1	2052180	g37040	i0	53.3	0.368852459016393	30	14	36.9	0	216	127	21	50	HCD32792.1 hypothetical protein [Phycisphaerales bacterium]	diamond	90	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31340258	31340258	PRJNA485080_P_NODE_39776_length_243_cov_0.905882_g39682_i0	PRJNA485080	39776	243	0.905882	2.20129326	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.1	0.0266	NR	MEM9410775.1	2026780	g39682	i0	37.7	0.753086419753086	61	38	75.3	0	188	6	122	182	MEM9410775.1 STY4199 family HEPN domain-containing protein [Planctomycetota bacterium]	diamond	183	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31846234	31846234	PRJNA485080_P_NODE_34837_length_245_cov_0.895349_g34743_i0	PRJNA485080	34837	245	0.895349	2.19360505	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.4	0.0493	NR	MDP6361313.1	2026780	g34743	i0	33.9	0.759183673469388	62	35	74.7	2	37	219	83	139	MDP6361313.1 DUF6259 domain-containing protein [Planctomycetota bacterium]	diamond	186	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;