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

17 rows where bioproject = "PRJNA835051", 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
26611287	26611287	PRJNA835051_S_NODE_96041_length_172_cov_1.519380_g95745_i0	PRJNA835051	96041	172	1.51938	2.6133336	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	43.5	0.0078	NR	MFM8872525.1	2052180	g95745	i0	45.1	0.88953488372093	51	27	87.2	1	7	156	159	209	MFM8872525.1 hypothetical protein [Phycisphaerales bacterium]	diamond	153	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
26706160	26706160	PRJNA835051_S_NODE_31841_length_246_cov_2.034483_g31545_i0	PRJNA835051	31841	246	2.034483	5.00482818	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.5	0.0187	NR	MBL8696680.1	2026780	g31545	i0	37.7	0.646341463414634	53	26	56.1	1	233	96	202	254	MBL8696680.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Planctomycetota bacterium]	diamond	159	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27117630	27117630	PRJNA835051_S_NODE_85382_length_180_cov_2.000000_g85086_i0	PRJNA835051	85382	180	2	3.6	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	41.6	0.0432	NR	MEX2215741.1	2026777	g85086	i0	33.9	0.933333333333333	56	37	93.3	0	180	13	518	573	MEX2215741.1 isoleucine--tRNA ligase [Phycisphaeraceae bacterium]	diamond	168	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
27465591	27465591	PRJNA835051_S_NODE_24583_length_263_cov_1.745455_g24287_i0	PRJNA835051	24583	263	1.745455	4.59054665	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	42.7	0.039	NR	HKI18667.1	2691532	g24287	i0	38.3	0.684410646387833	60	32	62.7	1	202	38	160	219	HKI18667.1 ZIP family metal transporter [Isosphaeraceae bacterium]	diamond	180	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
27686841	27686841	PRJNA835051_S_NODE_79364_length_185_cov_1.922535_g79068_i0	PRJNA835051	79364	185	1.922535	3.55668975	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	42.4	0.0203	NR	NOT02072.1	2052180	g79068	i0	44.1	0.551351351351351	34	19	55.1	0	50	151	98	131	NOT02072.1 hypothetical protein [Phycisphaerales bacterium]	diamond	102	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27970569	27970569	PRJNA835051_S_NODE_23825_length_265_cov_1.819820_g23529_i0	PRJNA835051	23825	265	1.81982	4.822523	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.3	0.0142	NR	MEM1186518.1	2026780	g23529	i0	39.7	0.713207547169811	63	30	71.3	1	22	210	165	219	MEM1186518.1 serine/threonine-protein kinase [Planctomycetota bacterium]	diamond	189	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28223035	28223035	PRJNA835051_S_NODE_25406_length_261_cov_1.532110_g25110_i0	PRJNA835051	25406	261	1.53211	3.9988071	Phycisphaera sp.	2030824	Bacteria	Bacteria	42.4	0.0193	NR	MBI1336282.1	2030824	g25110	i0	35	0.919540229885057	80	47	92	1	240	1	6	80	MBI1336282.1 tyrosine-type recombinase/integrase [Phycisphaera sp.]	diamond	240	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
28475840	28475840	PRJNA835051_S_NODE_128866_length_152_cov_0.880734_g128570_i0	PRJNA835051	128866	152	0.880734	1.33871568	Planctomycetota bacterium	2026780	Bacteria	Bacteria	48.1	1.3e-4	NR	MEZ6189435.1	2026780	g128570	i0	43.5	0.907894736842105	46	25	90.8	1	150	13	4	48	MEZ6189435.1 AAA family ATPase [Planctomycetota bacterium]	diamond	138	48.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29075896	29075896	PRJNA835051_S_NODE_75768_length_188_cov_2.517241_g75472_i0	PRJNA835051	75768	188	2.517241	4.73241308	Tepidisphaerales bacterium	2795155	Bacteria	Bacteria	41.6	0.0454	NR	MFN4243212.1	2795155	g75472	i0	41.5	0.654255319148936	41	19	65.4	1	35	157	291	326	MFN4243212.1 glycosyltransferase [Tepidisphaerales bacterium]	diamond	123	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales			Tepidisphaerales bacterium
29770198	29770198	PRJNA835051_S_NODE_72251_length_192_cov_0.879195_g71955_i0	PRJNA835051	72251	192	0.879195	1.6880544	Candidatus Brocadiaceae bacterium	2094028	Bacteria	Bacteria	43.1	0.0138	NR	NLW49299.1	2094028	g71955	i0	38.8	0.765625	49	29	75	1	23	166	274	322	NLW49299.1 hypothetical protein [Candidatus Brocadiaceae bacterium]	diamond	147	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae		Candidatus Brocadiaceae bacterium
29833485	29833485	PRJNA835051_S_NODE_85871_length_180_cov_1.291971_g85575_i0	PRJNA835051	85871	180	1.291971	2.3255478	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0314	NR	MCB9916047.1	2026780	g85575	i0	43.8	0.8	48	24	80	1	10	153	11	55	MCB9916047.1 acyl-CoA dehydrogenase [Planctomycetota bacterium]	diamond	144	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30781314	30781314	PRJNA835051_S_NODE_39594_length_232_cov_2.148148_g39298_i0	PRJNA835051	39594	232	2.148148	4.98370336	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	41.2	0.0497	NR	HUX00694.1	2026778	g39298	i0	34	0.685344827586207	53	32	64.7	1	13	162	55	107	HUX00694.1 E2/UBC family protein [Phycisphaerae bacterium]	diamond	159	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30812876	30812876	PRJNA835051_S_NODE_122154_length_155_cov_1.705357_g121858_i0	PRJNA835051	122154	155	1.705357	2.64330335	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.2	0.0401	NR	HVG93258.1	2026780	g121858	i0	43.9	0.793548387096774	41	18	69.7	2	23	130	1141	1181	HVG93258.1 hypothetical protein [Planctomycetota bacterium]	diamond	123	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30876098	30876098	PRJNA835051_S_NODE_14874_length_296_cov_3.521739_g14578_i0	PRJNA835051	14874	296	3.521739	10.42434744	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	44.7	0.0131	NR	MDX9912115.1	2052180	g14578	i0	33.8	0.689189189189189	68	38	68.9	2	282	79	19	79	MDX9912115.1 acyl-ACP--UDP-N-acetylglucosamine O-acyltransferase [Phycisphaerales bacterium]	diamond	204	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31729679	31729679	PRJNA835051_S_NODE_27897_length_255_cov_1.122642_g27601_i0	PRJNA835051	27897	255	1.122642	2.8627371	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	43.5	0.0237	NR	MAE62428.1	2026779	g27601	i0	38.2	0.647058823529412	55	30	60	1	79	231	35	89	MAE62428.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	165	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32267752	32267752	PRJNA835051_S_NODE_108258_length_164_cov_0.958678_g107962_i0	PRJNA835051	108258	164	0.958678	1.57223192	Planctomycetes bacterium DG_23	1703414	Bacteria	Bacteria	48.5	1.16e-4	NR	KPJ62517.1	1703414	g107962	i0	50	0.98780487804878	54	26	97	1	162	4	475	528	KPJ62517.1 MAG: hypothetical protein AMS15_03585 [Planctomycetes bacterium DG_23]	diamond	162	48.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium DG_23
32835737	32835737	PRJNA835051_S_NODE_84540_length_181_cov_1.369565_g84244_i0	PRJNA835051	84540	181	1.369565	2.47891265	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.6	0.0426	NR	TVR45921.1	2026780	g84244	i0	34.5	0.911602209944751	55	26	74.6	1	156	22	70	124	TVR45921.1 MAG: NADH-quinone oxidoreductase subunit M [Planctomycetota bacterium]	diamond	165	41.6	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);;