metadata: contig_metadata: 17 rows where bioproject = "PRJNA846110", tax_clade = "PVC group" and tax

17 rows where bioproject = "PRJNA846110", 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
3783216	3783216	PRJNA846110_P_NODE_28483_length_243_cov_0.905882_g28238_i0	PRJNA846110	28483	243	0.905882	2.20129326	Gemmata	113	Bacteria	Bacteria	448	2.39e-121	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g28238	i0	100	114.555555555556	242	0	99	0	2	243	1038325	1038084	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	27837	448	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
4661561	4661561	PRJNA846110_P_NODE_30544_length_237_cov_2.542683_g30299_i0	PRJNA846110	30544	237	2.542683	6.02615871	Phycisphaera mikurensis	547188	Bacteria	Bacteria	174	4.3499999999999997e-39	NTclustered	gi\|381385343\|dbj\|AP012338.1\|	1142394	g30299	i0	80.258	16.4092827004219	233	44	98	2	4	235	2591861	2592092	Phycisphaera mikurensis NBRC 102666 DNA, complete genome	blastn	3889	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera mikurensis
5936217	5936217	PRJNA846110_P_NODE_22745_length_251_cov_0.865169_g22500_i0	PRJNA846110	22745	251	0.865169	2.17157419	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	106	2.97e-26	NR	MDB5385041.1	2026779	g22500	i0	70.8	0.860557768924303	72	21	86.1	0	35	250	1	72	MDB5385041.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	216	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
11435137	11435137	PRJNA846110_P_NODE_27729_length_244_cov_0.900585_g27484_i0	PRJNA846110	27729	244	0.900585	2.1974274	Gemmata	113	Bacteria	Bacteria	276	1.1999999999999998e-69	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g27484	i0	87.008	6.68852459016393	254	22	100	9	1	244	1130589	1130841	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	1632	278	0.992805755395683	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
13586783	13586783	PRJNA846110_P_NODE_30751_length_232_cov_2.465409_g30506_i0	PRJNA846110	30751	232	2.465409	5.71974888	Urbifossiella limnaea	2528023	Bacteria	Bacteria	213	8.99e-51	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g30506	i0	84.163	0.952586206896552	221	33	95	2	13	232	5942494	5942275	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	221	213	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
21235046	21235046	PRJNA846110_P_NODE_15797_length_283_cov_2.161905_g15552_i0	PRJNA846110	15797	283	2.161905	6.11819115	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	139	3.64e-38	NR	MBX6312976.1	2691532	g15552	i0	62.3	2.41696113074205	114	17	93.3	1	3	266	192	305	MBX6312976.1 sugar phosphate isomerase/epimerase [Isosphaeraceae bacterium]	diamond	684	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
26865182	26865182	PRJNA846110_P_NODE_29121_length_242_cov_0.964497_g28876_i0	PRJNA846110	29121	242	0.964497	2.33408274	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.3	0.00958	NR	HRV81266.1	2026780	g28876	i0	40	2.25619834710744	65	34	75.6	3	38	220	54	117	HRV81266.1 alpha/beta fold hydrolase [Planctomycetota bacterium]	diamond	546	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26991220	26991220	PRJNA846110_P_NODE_15442_length_285_cov_1.584906_g15197_i0	PRJNA846110	15442	285	1.584906	4.5169821	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	88.6	4.77e-18	NR	HET6425812.1	2026779	g15197	i0	53.7	1	95	41	96.8	1	5	280	467	561	HET6425812.1 PQQ-binding-like beta-propeller repeat protein [Planctomycetaceae bacterium]	diamond	285	88.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27402508	27402508	PRJNA846110_P_NODE_30543_length_237_cov_2.567073_g30298_i0	PRJNA846110	30543	237	2.567073	6.08396301	Planctomycetota bacterium	2026780	Bacteria	Bacteria	60.1	1.4e-8	NR	MCA8965807.1	2026780	g30298	i0	50	0.734177215189873	58	28	72.2	1	236	66	175	232	MCA8965807.1 class I SAM-dependent methyltransferase [Planctomycetota bacterium]	diamond	174	60.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27411086	27411086	PRJNA846110_P_NODE_20403_length_261_cov_1.526596_g20158_i0	PRJNA846110	20403	261	1.526596	3.98441556	Candidatus Bathyanammoxibius	2983802	Bacteria	Bacteria	43.1	0.0165	NR	MEE9200699.1	2760054	g20158	i0	63.6	0.758620689655172	22	8	25.3	0	79	14	28	49	MEE9200699.1 cytochrome C [Candidatus Brocadiales bacterium]	diamond	198	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales			Candidatus Brocadiales bacterium
28665506	28665506	PRJNA846110_P_NODE_22167_length_252_cov_1.474860_g21922_i0	PRJNA846110	22167	252	1.47486	3.7166472	Planctomycetota bacterium	2026780	Bacteria	Bacteria	154	1.33e-41	NR	RLS51729.1	2026780	g21922	i0	89.2	0.988095238095238	83	9	98.8	0	251	3	113	195	RLS51729.1 MAG: ATP-binding cassette domain-containing protein, partial [Planctomycetota bacterium]	diamond	249	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29612242	29612242	PRJNA846110_P_NODE_30630_length_235_cov_2.425926_g30385_i0	PRJNA846110	30630	235	2.425926	5.7009261	Roseimaritima sediminicola	2662066	Bacteria	Bacteria	82	7.95e-17	NR	WP_153557960.1	2662066	g30385	i0	52.7	2.01702127659574	74	35	94.5	0	234	13	101	174	WP_153557960.1 RsmE family RNA methyltransferase [Roseimaritima sediminicola]	diamond	474	82	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Roseimaritima	Roseimaritima sediminicola
30434263	30434263	PRJNA846110_P_NODE_28413_length_243_cov_0.905882_g28168_i0	PRJNA846110	28413	243	0.905882	2.20129326	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	131	2.73e-33	NR	MDX1968795.1	2026779	g28168	i0	76.9	0.962962962962963	78	18	96.3	0	235	2	230	307	MDX1968795.1 glycosyl hydrolase family 28-related protein [Planctomycetaceae bacterium]	diamond	234	131	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30686515	30686515	PRJNA846110_P_NODE_23173_length_250_cov_1.299435_g22928_i0	PRJNA846110	23173	250	1.299435	3.2485875	Planctomycetota bacterium	2026780	Bacteria	Bacteria	143	2.18e-38	NR	RLS56198.1	2026780	g22928	i0	80.7	0.996	83	16	99.6	0	2	250	95	177	RLS56198.1 MAG: MFS transporter [Planctomycetota bacterium]	diamond	249	143	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31571915	31571915	PRJNA846110_P_NODE_16976_length_278_cov_1.209756_g16731_i0	PRJNA846110	16976	278	1.209756	3.36312168	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	155	1.27e-41	NR	HMO26238.1	2876886	g16731	i0	78.3	2.97841726618705	92	20	99.3	0	3	278	127	218	HMO26238.1 ABC transporter permease subunit [Tepidisphaeraceae bacterium]	diamond	828	155	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
32181372	32181372	PRJNA846110_P_NODE_22658_length_251_cov_0.865169_g22413_i0	PRJNA846110	22658	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	143	2.36e-39	NR	MBX6315968.1	2691532	g22413	i0	81.9	1.9840637450199201	83	15	99.2	0	1	249	223	305	MBX6315968.1 chloromuconate cycloisomerase [Isosphaeraceae bacterium]	diamond	498	143	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
32457740	32457740	PRJNA846110_P_NODE_28559_length_243_cov_0.905882_g28314_i0	PRJNA846110	28559	243	0.905882	2.20129326	Fimbriiglobus ruber	1908690	Bacteria	Bacteria	54.3	4.46e-7	NR	WP_088258636.1	1908690	g28314	i0	38.5	0.962962962962963	78	42	93.8	2	238	11	39	112	WP_088258636.1 hypothetical protein [Fimbriiglobus ruber]	diamond	234	54.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus ruber

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);;