metadata: contig_metadata: 23 rows where bioproject = "PRJNA438572", tax_clade = "PVC group" and tax

23 rows where bioproject = "PRJNA438572", 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
435059	435059	PRJNA438572_P_NODE_24121_length_242_cov_0.923077_g24002_i0	PRJNA438572	24121	242	0.923077	2.23384634	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	364	2.4699999999999992e-96	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g24002	i0	93.802	177.099173553719	242	15	100	0	1	242	5171957	5171716	Lacipirellula limnantheis strain I41 chromosome	blastn	42858	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
5538709	5538709	PRJNA438572_P_NODE_19425_length_249_cov_0.886364_g19306_i0	PRJNA438572	19425	249	0.886364	2.20704636	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	114	5.119999999999999e-28	NR	HEV3165845.1	2691532	g19306	i0	63.4	4.93975903614458	82	30	98.8	0	3	248	21	102	HEV3165845.1 exodeoxyribonuclease VII large subunit [Isosphaeraceae bacterium]	diamond	1230	114	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
5538713	5538713	PRJNA438572_P_NODE_19525_length_249_cov_0.886364_g19406_i0	PRJNA438572	19525	249	0.886364	2.20704636	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	265	2.6599999999999997e-66	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g19406	i0	86.722	40.8353413654619	241	28	96	3	11	249	1830851	1830613	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	10168	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
8088095	8088095	PRJNA438572_P_NODE_12927_length_288_cov_0.855814_g12808_i0	PRJNA438572	12927	288	0.855814	2.46474432	Lacipirellula parvula	2650471	Bacteria	Bacteria	318	2.3799999999999995e-82	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g12808	i0	87.368	124.604166666667	285	26	98	8	1	281	5162957	5163235	Lacipirellula parvula PX69 DNA, complete genome	blastn	35886	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
9362999	9362999	PRJNA438572_P_NODE_18608_length_250_cov_2.220339_g18489_i0	PRJNA438572	18608	250	2.220339	5.5508475	Urbifossiella limnaea	2528023	Bacteria	Bacteria	285	2.05e-72	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g18489	i0	87.2	1	250	32	100	0	1	250	2521034	2520785	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	250	285	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
10638776	10638776	PRJNA438572_P_NODE_11749_length_300_cov_1.030837_g11630_i0	PRJNA438572	11749	300	1.030837	3.092511	Aeoliella mucimassa	2527972	Bacteria	Bacteria	392	1.4499999999999994e-104	NTclustered	gi\|1712622222\|gb\|CP036278.1\|	2527972	g11630	i0	90.635	116.666666666667	299	23	99	5	1	296	2043155	2043451	Aeoliella mucimassa strain Pan181 chromosome, complete genome	blastn	35000	392	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Aeoliella	Aeoliella mucimassa
11913973	11913973	PRJNA438572_P_NODE_9450_length_332_cov_1.806950_g9331_i0	PRJNA438572	9450	332	1.80695	5.999074	Planctomycetota bacterium	2026780	Bacteria	Bacteria	176	8.66e-51	NR	MBF0197637.1	2026780	g9331	i0	73.6	3.97590361445783	110	29	99.4	0	2	331	97	206	MBF0197637.1 adenosylhomocysteinase [Planctomycetota bacterium]	diamond	1320	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27455413	27455413	PRJNA438572_P_NODE_23663_length_243_cov_0.917647_g23544_i0	PRJNA438572	23663	243	0.917647	2.22988221	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.7	0.0351	NR	MCC8180000.1	2026780	g23544	i0	42.2	0.555555555555556	45	26	55.6	0	157	23	244	288	MCC8180000.1 alcohol dehydrogenase catalytic domain-containing protein [Planctomycetota bacterium]	diamond	135	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28623623	28623623	PRJNA438572_P_NODE_17847_length_252_cov_0.871508_g17728_i0	PRJNA438572	17847	252	0.871508	2.19620016	Planctomycetota bacterium	2026780	Bacteria	Bacteria	112	1.81e-27	NR	MES2792330.1	2026780	g17728	i0	92.6	1.28571428571429	54	4	64.3	0	3	164	315	368	MES2792330.1 Gfo/Idh/MocA family oxidoreductase [Planctomycetota bacterium]	diamond	324	112	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28686863	28686863	PRJNA438572_P_NODE_18867_length_250_cov_0.881356_g18748_i0	PRJNA438572	18867	250	0.881356	2.20339	Gemmataceae bacterium	2052164	Bacteria	Bacteria	44.3	0.0117	NR	HEY7424931.1	2052164	g18748	i0	40.5	1.488	42	25	50.4	0	217	92	246	287	HEY7424931.1 serine/threonine-protein kinase [Gemmataceae bacterium]	diamond	372	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28734534	28734534	PRJNA438572_P_NODE_19587_length_249_cov_0.886364_g19468_i0	PRJNA438572	19587	249	0.886364	2.20704636	Pseudomonadati	3379134	Bacteria	Bacteria	56.2	7.18e-7	NR	HEY3322391.1	2026780	g19468	i0	37.5	2.89156626506024	80	40	96.4	2	9	248	687	756	HEY3322391.1 PA14 domain-containing protein [Planctomycetota bacterium]	diamond	720	56.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28844294	28844294	PRJNA438572_P_NODE_17688_length_252_cov_0.871508_g17569_i0	PRJNA438572	17688	252	0.871508	2.19620016	Candidatus Uabimicrobium amorphum	2596890	Bacteria	Bacteria	90.1	8.51e-19	NR	WP_151967754.1	2596890	g17569	i0	59.4	0.821428571428571	69	28	82.1	0	237	31	244	312	WP_151967754.1 nicotinate phosphoribosyltransferase [Candidatus Uabimicrobium amorphum]	diamond	207	90.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium amorphum
29349744	29349744	PRJNA438572_P_NODE_21149_length_247_cov_0.896552_g21030_i0	PRJNA438572	21149	247	0.896552	2.21448344	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	45.1	8.64e-4	NR	HYO24935.1	2691534	g21030	i0	70.4	0.327935222672065	27	8	32.8	0	178	98	54	80	HYO24935.1 WGxxGxxG family protein [Lacipirellulaceae bacterium]	diamond	81	45.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
30044323	30044323	PRJNA438572_P_NODE_7931_length_361_cov_1.083333_g7812_i0	PRJNA438572	7931	361	1.083333	3.91083213	Posidoniimonas polymericola	2528002	Bacteria	Bacteria	55.5	5.14e-6	NR	WP_146583982.1	2528002	g7812	i0	30.3	1.88642659279778	109	76	90.6	0	1	327	717	825	WP_146583982.1 LamG domain-containing protein [Posidoniimonas polymericola]	diamond	681	55.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Posidoniimonas	Posidoniimonas polymericola
30265864	30265864	PRJNA438572_P_NODE_20812_length_247_cov_0.896552_g20693_i0	PRJNA438572	20812	247	0.896552	2.21448344	Planctomycetota bacterium	2026780	Bacteria	Bacteria	48.5	3.45e-4	NR	MEK7411798.1	2026780	g20693	i0	48.4	0.753036437246964	62	31	74.1	1	184	2	7	68	MEK7411798.1 hypothetical protein [Planctomycetota bacterium]	diamond	186	48.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30313999	30313999	PRJNA438572_P_NODE_14972_length_269_cov_1.193878_g14853_i0	PRJNA438572	14972	269	1.193878	3.21153182	Pseudomonadati	3379134	Bacteria	Bacteria	144	1.33e-39	NR	MBV8128625.1	2026779	g14853	i0	70.8	24.5576208178439	89	26	99.3	0	267	1	104	192	MBV8128625.1 phosphoenolpyruvate carboxykinase (GTP) [Planctomycetaceae bacterium]	diamond	6606	144	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30739450	30739450	PRJNA438572_P_NODE_154_length_1774_cov_9.566138_g133_i0	PRJNA438572	154	1774	9.566138	169.70328812	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	63.9	2.2e-6	NR	MFN0136844.1	2026778	g133	i0	39.8	0.272266065388952	161	82	26.2	6	1161	1625	1145	1296	MFN0136844.1 choice-of-anchor tandem repeat NxxGxxAF-containing protein [Phycisphaerae bacterium]	diamond	483	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30960758	30960758	PRJNA438572_P_NODE_20794_length_247_cov_0.896552_g20675_i0	PRJNA438572	20794	247	0.896552	2.21448344	Gemmataceae bacterium	2052164	Bacteria	Bacteria	44.3	0.0112	NR	HEV3255801.1	2052164	g20675	i0	37.5	0.874493927125506	72	37	77.7	1	197	6	975	1046	HEV3255801.1 protein kinase [Gemmataceae bacterium]	diamond	216	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31181524	31181524	PRJNA438572_P_NODE_17935_length_251_cov_2.617978_g17816_i0	PRJNA438572	17935	251	2.617978	6.57112478	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	44.7	0.00804	NR	MBY0307982.1	2052180	g17816	i0	27.6	0.908366533864542	76	54	90.8	1	4	231	60	134	MBY0307982.1 hypothetical protein [Phycisphaerales bacterium]	diamond	228	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31719529	31719529	PRJNA438572_P_NODE_3237_length_547_cov_1.388186_g3119_i0	PRJNA438572	3237	547	1.388186	7.59337742	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	73.9	1.28e-11	NR	MCA8985046.1	2026779	g3119	i0	28.2	1.90859232175503	174	101	89.4	4	537	49	896	1056	MCA8985046.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	1044	73.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32289378	32289378	PRJNA438572_P_NODE_13559_length_282_cov_1.248804_g13440_i0	PRJNA438572	13559	282	1.248804	3.52162728	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	66.2	2.68e-10	NR	HEX7010758.1	2026777	g13440	i0	45.7	2.21276595744681	70	38	74.5	0	2	211	155	224	HEX7010758.1 signal peptide peptidase SppA [Phycisphaeraceae bacterium]	diamond	624	66.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
32542369	32542369	PRJNA438572_P_NODE_23539_length_243_cov_0.917647_g23420_i0	PRJNA438572	23539	243	0.917647	2.22988221	Gimesia chilikensis	2605989	Bacteria	Bacteria	50.8	4.98e-5	NR	WP_145042384.1	2605989	g23420	i0	33.3	1.92592592592593	78	51	96.3	1	2	235	58	134	WP_145042384.1 serpin family protein [Gimesia chilikensis]	diamond	468	50.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia chilikensis
32762602	32762602	PRJNA438572_P_NODE_20860_length_247_cov_0.896552_g20741_i0	PRJNA438572	20860	247	0.896552	2.21448344	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	102	1.2299999999999997e-23	NR	MAX25395.1	2026777	g20741	i0	66.7	1.96761133603239	72	24	87.4	0	246	31	312	383	MAX25395.1 hypothetical protein [Phycisphaeraceae bacterium]	diamond	486	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;