metadata: contig_metadata: 18 rows where bioproject = "PRJNA700095", tax_clade = "PVC group" and tax

18 rows where bioproject = "PRJNA700095", 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
17261178	17261178	PRJNA700095_P_NODE_5114_length_873_cov_6.411250_g4125_i0	PRJNA700095	5114	873	6.41125	55.9702125	Bacteria	2	Bacteria	Bacteria	236	4.359999999999999e-74	NR	WP_286763893.1	265488	g4125	i0	53.7	4.48453608247423	216	92	71.8	3	785	159	1	215	WP_286763893.1 MULTISPECIES: CatB-related O-acetyltransferase [Rhodopirellula]	diamond	3915	238	0.991596638655462	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula
22360494	22360494	PRJNA700095_P_NODE_58538_length_246_cov_0.867052_g57274_i0	PRJNA700095	58538	246	0.867052	2.13294792	Humisphaera borealis	2807512	Bacteria	Bacteria	348	2.53e-91	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g57274	i0	92.245	126.089430894309	245	19	99	0	1	245	5064312	5064556	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	31018	348	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
27493604	27493604	PRJNA700095_P_NODE_58903_length_245_cov_1.668605_g57639_i0	PRJNA700095	58903	245	1.668605	4.08808225	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.7	0.0371	NR	MBN8643811.1	2026780	g57639	i0	36.2	0.710204081632653	58	35	71	1	16	189	283	338	MBN8643811.1 radical SAM family heme chaperone HemW [Planctomycetota bacterium]	diamond	174	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28230665	28230665	PRJNA700095_P_NODE_31746_length_303_cov_2.521739_g30482_i0	PRJNA700095	31746	303	2.521739	7.64086917	Bacteria	2	Bacteria	Bacteria	113	1.17e-27	NR	MAT16774.1	37635	g30482	i0	65.9	6.76237623762376	82	26	80.2	2	59	301	1	81	MAT16774.1 alkene reductase [Planctomyces sp.]	diamond	2049	114	0.991228070175439	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp.
28925448	28925448	PRJNA700095_P_NODE_5408_length_848_cov_1.998710_g4393_i0	PRJNA700095	5408	848	1.99871	16.9490608	Bacteria	2	Bacteria	Bacteria	137	1.9e-34	NR	MCE9592223.1	2026780	g4393	i0	40.6	5.43042452830189	192	98	63.7	5	4	543	127	314	MCE9592223.1 ROK family glucokinase [Planctomycetota bacterium]	diamond	4605	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29462005	29462005	PRJNA700095_P_NODE_31970_length_302_cov_1.602620_g30706_i0	PRJNA700095	31970	302	1.60262	4.8399124	Pseudomonadati	3379134	Bacteria	Bacteria	117	8.91e-29	NR	MFN7731082.1	117	g30706	i0	55.1	5.80132450331126	98	42	97.4	1	296	3	288	383	MFN7731082.1 endo-1,4-beta-xylanase [Pirellula sp.]	diamond	1752	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
30525056	30525056	PRJNA700095_P_NODE_47313_length_259_cov_1.311828_g46049_i0	PRJNA700095	47313	259	1.311828	3.39763452	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	151	6.47e-44	NR	MBY0308619.1	2052180	g46049	i0	85.9	0.984555984555985	85	12	98.5	0	3	257	44	128	MBY0308619.1 hypothetical protein [Phycisphaerales bacterium]	diamond	255	151	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31219858	31219858	PRJNA700095_P_NODE_32755_length_298_cov_1.368889_g31491_i0	PRJNA700095	32755	298	1.368889	4.07928922	Pirellulales bacterium	2715253	Bacteria	Bacteria	60.5	6.71e-9	NR	MEX2113528.1	2715253	g31491	i0	38.9	0.906040268456376	90	52	90.6	1	297	28	61	147	MEX2113528.1 hypothetical protein [Pirellulales bacterium]	diamond	270	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
31568372	31568372	PRJNA700095_P_NODE_58236_length_246_cov_0.884393_g56972_i0	PRJNA700095	58236	246	0.884393	2.17560678	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	82.8	8.88e-17	NR	HEY2588895.1	2876886	g56972	i0	56.3	2.8780487804878	80	33	95.1	2	240	7	199	278	HEY2588895.1 GNAT family N-acetyltransferase [Tepidisphaeraceae bacterium]	diamond	708	82.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
32212136	32212136	PRJNA700095_P_NODE_41658_length_271_cov_4.434343_g40394_i0	PRJNA700095	41658	271	4.434343	12.01706953	Pseudomonadati	3379134	Bacteria	Bacteria	79.7	2.95e-15	NR	WP_074305062.1	1882752	g40394	i0	64.8	20.169741697417	54	19	59.8	0	162	1	3	56	WP_074305062.1 alcohol dehydrogenase AdhP [Singulisphaera sp. GP187]	diamond	5466	80.1	0.995006242197254	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. GP187
32517504	32517504	PRJNA700095_P_NODE_63599_length_242_cov_1.360947_g62335_i0	PRJNA700095	63599	242	1.360947	3.29349174	Planctomycetota bacterium	2026780	Bacteria	Bacteria	80.1	1.55e-15	NR	MEC7233350.1	2026780	g62335	i0	48.8	0.991735537190083	80	41	99.2	0	2	241	220	299	MEC7233350.1 hypothetical protein [Planctomycetota bacterium]	diamond	240	80.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32528658	32528658	PRJNA700095_P_NODE_58379_length_246_cov_0.884393_g57115_i0	PRJNA700095	58379	246	0.884393	2.17560678	Bacteria	2	Bacteria	Bacteria	88.6	1.51e-18	NR	OYV85702.1	1970542	g57115	i0	59.2	8.37804878048781	76	31	92.7	0	3	230	175	250	OYV85702.1 MAG: hypothetical protein B7Z73_13060, partial [Planctomycetia bacterium 21-64-5]	diamond	2061	88.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium 21-64-5
32654262	32654262	PRJNA700095_P_NODE_17600_length_429_cov_2.792135_g16337_i0	PRJNA700095	17600	429	2.792135	11.97825915	Pseudomonadati	3379134	Bacteria	Bacteria	63.9	4.34e-9	NR	HWG44280.1	2052164	g16337	i0	33.6	1.71328671328671	116	70	79.7	2	388	47	128	238	HWG44280.1 SGNH/GDSL hydrolase family protein [Gemmataceae bacterium]	diamond	735	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32674748	32674748	PRJNA700095_P_NODE_68460_length_230_cov_2.254777_g67195_i0	PRJNA700095	68460	230	2.254777	5.1859871	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.0119	NR	MBI3269025.1	2026780	g67195	i0	38.1	1.34347826086957	63	39	82.2	0	15	203	99	161	MBI3269025.1 hypothetical protein [Planctomycetota bacterium]	diamond	309	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32706289	32706289	PRJNA700095_P_NODE_36080_length_286_cov_1.441315_g34816_i0	PRJNA700095	36080	286	1.441315	4.1221609	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	55.1	2.88e-6	NR	MAX22098.1	2026779	g34816	i0	37.9	4.36363636363636	95	48	99.7	3	2	286	540	623	MAX22098.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	1248	55.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32738055	32738055	PRJNA700095_P_NODE_14860_length_481_cov_2.115196_g13599_i0	PRJNA700095	14860	481	2.115196	10.17409276	Planctomycetota bacterium	2026780	Bacteria	Bacteria	48.5	0.00413	NR	MCH7685976.1	2026780	g13599	i0	26.8	0.767151767151767	123	88	76.1	2	34	399	451	572	MCH7685976.1 hypothetical protein [Planctomycetota bacterium]	diamond	369	48.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32800707	32800707	PRJNA700095_P_NODE_33380_length_295_cov_2.648649_g32116_i0	PRJNA700095	33380	295	2.648649	7.81351455	Blastopirellula sp.	2024826	Bacteria	Bacteria	87.4	1.22e-17	NR	PHR99523.1	2024826	g32116	i0	78.7	0.477966101694915	47	10	47.8	0	154	294	3	49	PHR99523.1 MAG: adenylosuccinate lyase [Blastopirellula sp.]	diamond	141	87.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula sp.
32843375	32843375	PRJNA700095_P_NODE_49740_length_254_cov_1.270718_g48476_i0	PRJNA700095	49740	254	1.270718	3.22762372	Bacteria	2	Bacteria	Bacteria	75.5	1.11e-14	NR	WP_105336449.1	124	g48476	i0	44.3	1.90157480314961	79	44	93.3	0	18	254	55	133	WP_105336449.1 hypothetical protein [Blastopirellula marina]	diamond	483	75.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula marina

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