metadata: contig_metadata: 27 rows where bioproject = "PRJNA1032461" and tax

27 rows where bioproject = "PRJNA1032461" and tax_clade = "PVC group"

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
3993651	3993651	PRJNA1032461_S_NODE_9424_length_199_cov_4.640000_g9326_i0	PRJNA1032461	9424	199	4.64	9.2336	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	250	5.71e-62	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g9326	i0	90.526	233.35175879397	190	17	95	1	9	197	4317089	4317278	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	46437	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
5269984	5269984	PRJNA1032461_S_NODE_9365_length_200_cov_1.357616_g9267_i0	PRJNA1032461	9365	200	1.357616	2.715232	Kiritimatiellales bacterium	2202731	Bacteria	Bacteria	94	1.93e-20	NR	MFA6174838.1	2202731	g9267	i0	62.1	0.99	66	25	99	0	199	2	829	894	MFA6174838.1 glycosyl hydrolase [Kiritimatiellales bacterium]	diamond	198	94	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales			Kiritimatiellales bacterium
6545109	6545109	PRJNA1032461_S_NODE_16646_length_167_cov_0.881356_g16548_i0	PRJNA1032461	16646	167	0.881356	1.47186452	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	150	4.83e-32	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g16548	i0	98.81	16.0239520958084	84	1	50	0	71	154	388132	388215	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	2676	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
9094621	9094621	PRJNA1032461_S_NODE_19188_length_164_cov_0.904348_g19090_i0	PRJNA1032461	19188	164	0.904348	1.48313072	Humisphaera sp.	2807514	Bacteria	Bacteria	66.2	6.52e-11	NR	HEX8911139.1	2807514	g19090	i0	63.8	0.859756097560976	47	17	86	0	17	157	734	780	HEX8911139.1 tetratricopeptide repeat protein [Humisphaera sp.]	diamond	141	66.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera sp.
10370295	10370295	PRJNA1032461_S_NODE_16189_length_167_cov_0.881356_g16091_i0	PRJNA1032461	16189	167	0.881356	1.47186452	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	281	1.64e-71	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g16091	i0	97.006	201.556886227545	167	5	100	0	1	167	4957069	4957235	Planctomyces sp. SH-PL14, complete genome	blastn	33660	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
19292905	19292905	PRJNA1032461_S_NODE_20136_length_163_cov_0.912281_g20038_i0	PRJNA1032461	20136	163	0.912281	1.48701803	Opitutaceae bacterium	2006848	Bacteria	Bacteria	82	1.72e-16	NR	HEY1110425.1	2006848	g20038	i0	76	0.920245398773006	50	12	92	0	152	3	155	204	HEY1110425.1 reverse transcriptase domain-containing protein [Opitutaceae bacterium]	diamond	150	82	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
24393107	24393107	PRJNA1032461_S_NODE_14240_length_169_cov_0.866667_g14142_i0	PRJNA1032461	14240	169	0.866667	1.46466723	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	65.5	1.32e-10	NR	MDB5296279.1	2052180	g14142	i0	73.2	0.994082840236686	56	15	99.4	0	168	1	296	351	MDB5296279.1 hypothetical protein [Phycisphaerales bacterium]	diamond	168	65.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
26623510	26623510	PRJNA1032461_S_NODE_21281_length_162_cov_0.920354_g21183_i0	PRJNA1032461	21281	162	0.920354	1.49097348	Luteolibacter sp. SL25	1962973	Bacteria	Bacteria	58.9	6.71e-10	NR	WP_267671668.1	2995170	g21183	i0	87.2	0.87037037037037	47	6	87	0	162	22	19	65	WP_267671668.1 hypothetical protein [Luteolibacter sp. SL250]	diamond	141	58.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
27066628	27066628	PRJNA1032461_S_NODE_14262_length_169_cov_0.866667_g14164_i0	PRJNA1032461	14262	169	0.866667	1.46466723	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	105	3.24e-25	NR	HZZ44900.1	2876886	g14164	i0	83.9	4.97041420118343	56	9	99.4	0	169	2	249	304	HZZ44900.1 tryptophan--tRNA ligase [Tepidisphaeraceae bacterium]	diamond	840	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
27098299	27098299	PRJNA1032461_S_NODE_10202_length_193_cov_1.444444_g10104_i0	PRJNA1032461	10202	193	1.444444	2.78777692	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	73.2	3.59e-13	NR	MDQ3622138.1	2026799	g10104	i0	62.5	0.994818652849741	64	24	99.5	0	2	193	146	209	MDQ3622138.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	192	73.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28393165	28393165	PRJNA1032461_S_NODE_18586_length_165_cov_0.896552_g18488_i0	PRJNA1032461	18586	165	0.896552	1.4793108	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	98.2	4.309999999999999e-23	NR	MBC7782760.1	2026778	g18488	i0	77.8	0.981818181818182	54	10	98.2	1	163	2	149	200	MBC7782760.1 sugar phosphate isomerase/epimerase [Phycisphaerae bacterium]	diamond	162	98.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
28551228	28551228	PRJNA1032461_S_NODE_20987_length_162_cov_1.292035_g20889_i0	PRJNA1032461	20987	162	1.292035	2.0930967	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	64.3	2.89e-10	NR	HEY0008825.1	2876886	g20889	i0	56.6	0.981481481481482	53	23	98.1	0	160	2	245	297	HEY0008825.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	159	64.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
29025005	29025005	PRJNA1032461_S_NODE_21808_length_162_cov_0.920354_g21710_i0	PRJNA1032461	21808	162	0.920354	1.49097348	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	87	4.96e-19	NR	HEY0007872.1	2876886	g21710	i0	75.5	0.981481481481482	53	13	98.1	0	3	161	71	123	HEY0007872.1 peptidoglycan editing factor PgeF [Tepidisphaeraceae bacterium]	diamond	159	87	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
29561271	29561271	PRJNA1032461_S_NODE_17230_length_166_cov_0.888889_g17132_i0	PRJNA1032461	17230	166	0.888889	1.47555574	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	108	8.34e-27	NR	HEY0010190.1	2876886	g17132	i0	100	0.993975903614458	55	0	99.4	0	2	166	217	271	HEY0010190.1 sigma-70 family RNA polymerase sigma factor [Tepidisphaeraceae bacterium]	diamond	165	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
29624070	29624070	PRJNA1032461_S_NODE_20250_length_163_cov_0.912281_g20152_i0	PRJNA1032461	20250	163	0.912281	1.48701803	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	87.4	1.82e-18	NR	MEO6436920.1	2876886	g20152	i0	73.6	0.975460122699387	53	14	97.5	0	5	163	131	183	MEO6436920.1 phenylalanine--tRNA ligase subunit beta [Tepidisphaeraceae bacterium]	diamond	159	87.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
29719011	29719011	PRJNA1032461_S_NODE_16970_length_166_cov_1.290598_g16872_i0	PRJNA1032461	16970	166	1.290598	2.14239268	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	60.5	7.27e-9	NR	HEX8339410.1	2876886	g16872	i0	60.5	0.77710843373494	43	17	77.7	0	4	132	147	189	HEX8339410.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	129	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
30414596	30414596	PRJNA1032461_S_NODE_20213_length_163_cov_0.912281_g20115_i0	PRJNA1032461	20213	163	0.912281	1.48701803	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	60.5	5.56e-9	NR	MDB5318774.1	2052180	g20115	i0	52.9	1.87730061349693	51	24	93.9	0	6	158	191	241	MDB5318774.1 6-phosphogluconate dehydrogenase [Phycisphaerales bacterium]	diamond	306	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30603748	30603748	PRJNA1032461_S_NODE_16633_length_167_cov_0.881356_g16535_i0	PRJNA1032461	16633	167	0.881356	1.47186452	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	88.2	1.28e-18	NR	HEV7402119.1	2811408	g16535	i0	87.3	0.988023952095808	55	7	98.8	0	2	166	269	323	HEV7402119.1 ComEC/Rec2 family competence protein [Chthoniobacteraceae bacterium]	diamond	165	88.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
30667022	30667022	PRJNA1032461_S_NODE_16753_length_167_cov_0.881356_g16655_i0	PRJNA1032461	16753	167	0.881356	1.47186452	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	84.3	1e-17	NR	HEV7298138.1	2876886	g16655	i0	72.7	0.988023952095808	55	15	98.8	0	167	3	116	170	HEV7298138.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	165	84.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
30761911	30761911	PRJNA1032461_S_NODE_17234_length_166_cov_0.888889_g17136_i0	PRJNA1032461	17234	166	0.888889	1.47555574	Planctomycetota bacterium	2026780	Bacteria	Bacteria	72.4	4.57e-13	NR	GIW70785.1	2026780	g17136	i0	60	8.94578313253012	55	22	99.4	0	2	166	100	154	GIW70785.1 MAG: hypothetical protein KatS3mg102_0327 [Planctomycetota bacterium]	diamond	1485	72.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31299011	31299011	PRJNA1032461_S_NODE_18195_length_165_cov_0.896552_g18097_i0	PRJNA1032461	18195	165	0.896552	1.4793108	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	59.7	1.31e-8	NR	MCC7291256.1	2052180	g18097	i0	54.9	1.81818181818182	51	23	92.7	0	5	157	387	437	MCC7291256.1 hypothetical protein [Phycisphaerales bacterium]	diamond	300	59.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31520603	31520603	PRJNA1032461_S_NODE_15756_length_168_cov_0.873950_g15658_i0	PRJNA1032461	15756	168	0.87395	1.468236	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	79.7	1.22e-15	NR	HAM71517.1	2026801	g15658	i0	63.6	1.96428571428571	55	20	98.2	0	166	2	424	478	HAM71517.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	330	79.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32184899	32184899	PRJNA1032461_S_NODE_21818_length_162_cov_0.920354_g21720_i0	PRJNA1032461	21818	162	0.920354	1.49097348	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	69.7	3.93e-12	NR	MFL6519441.1	2201154	g21720	i0	63	3.03703703703704	54	20	100	0	1	162	1161	1214	MFL6519441.1 choice-of-anchor Q domain-containing protein [Chthoniobacterales bacterium]	diamond	492	69.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32271889	32271889	PRJNA1032461_S_NODE_10338_length_192_cov_1.454545_g10240_i0	PRJNA1032461	10338	192	1.454545	2.7927264	Pseudomonadati	3379134	Bacteria	Bacteria	49.3	8.94e-5	NR	MEZ6060731.1	2026779	g10240	i0	43.5	1.421875	46	26	71.9	0	53	190	3	48	MEZ6060731.1 amidohydrolase family protein [Planctomycetaceae bacterium]	diamond	273	49.7	0.991951710261569	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32374786	32374786	PRJNA1032461_S_NODE_13639_length_171_cov_1.245902_g13541_i0	PRJNA1032461	13639	171	1.245902	2.13049242	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	65.1	1.79e-10	NR	WP_411826179.1	3135776	g13541	i0	50.9	0.964912280701754	55	27	96.5	0	169	5	107	161	WP_411826179.1 PIG-L family deacetylase [Luteolibacter sp. AS25]	diamond	165	65.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
32533083	32533083	PRJNA1032461_S_NODE_16359_length_167_cov_0.881356_g16261_i0	PRJNA1032461	16359	167	0.881356	1.47186452	Candidatus Laterigemmans baculatus	2770505	Bacteria	Bacteria	69.3	5.59e-12	NR	WP_164103099.1	2770505	g16261	i0	65.5	0.988023952095808	55	19	98.8	0	167	3	836	890	WP_164103099.1 secretin N-terminal domain-containing protein [Candidatus Laterigemmans baculatus]	diamond	165	69.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Candidatus Laterigemmans	Candidatus Laterigemmans baculatus
32713923	32713923	PRJNA1032461_S_NODE_19120_length_164_cov_0.904348_g19022_i0	PRJNA1032461	19120	164	0.904348	1.48313072	Bacteria	2	Bacteria	Bacteria	50.4	2.41e-5	NR	RMF91215.1	2026780	g19022	i0	59.1	4.11585365853659	44	18	80.5	0	33	164	8	51	RMF91215.1 MAG: N-acetylgalactosamine-6-sulfatase [Planctomycetota bacterium]	diamond	675	50.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);;