metadata: contig_metadata: 19 rows where bioproject = "PRJNA1188114", tax_clade = "PVC group" and tax

19 rows where bioproject = "PRJNA1188114", 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
1594687	1594687	PRJNA1188114_P_NODE_18402_length_162_cov_0.902655_g18350_i0	PRJNA1188114	18402	162	0.902655	1.4623011	Paludisphaera borealis	1387353	Bacteria	Bacteria	150	4.65e-32	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g18350	i0	83.436	21.5555555555556	163	25	100	2	1	162	2034338	2034177	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	3492	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
9247964	9247964	PRJNA1188114_P_NODE_8988_length_179_cov_1.853846_g8936_i0	PRJNA1188114	8988	179	1.853846	3.31838434	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	100	5.079999999999999e-23	NR	MDB5327853.1	2052180	g8936	i0	74.6	0.988826815642458	59	15	98.9	0	179	3	306	364	MDB5327853.1 Beta,4-xylanase [Phycisphaerales bacterium]	diamond	177	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
14349032	14349032	PRJNA1188114_P_NODE_17632_length_162_cov_2.530973_g17580_i0	PRJNA1188114	17632	162	2.530973	4.10017626	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	113	6.1e-21	NTclustered	gi\|1712720622\|gb\|CP036427.1\|	2527974	g17580	i0	85.849	1.64814814814815	106	15	65	0	9	114	122633	122738	Tautonia plasticadhaerens strain ElP plasmid pElP_1, complete sequence	blastn	267	113	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
15622758	15622758	PRJNA1188114_P_NODE_17933_length_162_cov_0.902655_g17881_i0	PRJNA1188114	17933	162	0.902655	1.4623011	Urbifossiella limnaea	2528023	Bacteria	Bacteria	220	3.49e-53	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g17881	i0	91.304	7.37037037037037	161	14	99	0	1	161	6656581	6656741	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	1194	220	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
21996659	21996659	PRJNA1188114_P_NODE_10778_length_172_cov_1.601626_g10726_i0	PRJNA1188114	10778	172	1.601626	2.75479672	Urbifossiella limnaea	2528023	Bacteria	Bacteria	115	1.81e-21	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g10726	i0	90	0.523255813953488	90	8	52	1	56	145	1120352	1120440	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	90	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
24546114	24546114	PRJNA1188114_P_NODE_9960_length_175_cov_1.619048_g9908_i0	PRJNA1188114	9960	175	1.619048	2.833334	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	281	1.73e-71	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g9908	i0	97.006	44.0571428571429	167	5	95	0	1	167	4317534	4317368	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	7710	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
26660542	26660542	PRJNA1188114_P_NODE_10721_length_172_cov_1.658537_g10669_i0	PRJNA1188114	10721	172	1.658537	2.85268364	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	114	6.47e-31	NR	MDB5326561.1	2052180	g10669	i0	92.9	0.976744186046512	56	4	97.7	0	168	1	70	125	MDB5326561.1 hydrolase [Phycisphaerales bacterium]	diamond	168	114	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
26711244	26711244	PRJNA1188114_P_NODE_19581_length_161_cov_0.910714_g19529_i0	PRJNA1188114	19581	161	0.910714	1.46624954	Bacteria	2	Bacteria	Bacteria	67.4	1.84e-11	NR	MCH8006341.1	2026780	g19529	i0	58	1.86335403726708	50	21	93.2	0	159	10	234	283	MCH8006341.1 endonuclease/exonuclease/phosphatase family protein [Planctomycetota bacterium]	diamond	300	67.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26787660	26787660	PRJNA1188114_P_NODE_19281_length_161_cov_0.910714_g19229_i0	PRJNA1188114	19281	161	0.910714	1.46624954	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	42.4	0.0168	NR	MCS5630876.1	2699754	g19229	i0	47.8	2.53416149068323	46	24	85.7	0	155	18	341	386	MCS5630876.1 DUF1549 and DUF1553 domain-containing protein [Pirellulaceae bacterium]	diamond	408	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
27451811	27451811	PRJNA1188114_P_NODE_16783_length_163_cov_0.894737_g16731_i0	PRJNA1188114	16783	163	0.894737	1.45842131	Planctomycetota bacterium	2026780	Bacteria	Bacteria	89.7	1.63e-19	NR	MBN9120584.1	2026780	g16731	i0	84.9	0.975460122699387	53	8	97.5	0	159	1	84	136	MBN9120584.1 HD domain-containing protein [Planctomycetota bacterium]	diamond	159	89.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27956820	27956820	PRJNA1188114_P_NODE_7545_length_185_cov_1.500000_g7493_i0	PRJNA1188114	7545	185	1.5	2.775	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	60.5	9.46e-9	NR	HEY2156819.1	2691532	g7493	i0	93.1	4.24864864864865	29	2	47	0	3	89	466	494	HEY2156819.1 aconitate hydratase AcnA [Isosphaeraceae bacterium]	diamond	786	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
28101929	28101929	PRJNA1188114_P_NODE_15065_length_165_cov_0.879310_g15013_i0	PRJNA1188114	15065	165	0.87931	1.4508615	PVC group	1783257	Bacteria	Bacteria	55.8	6.06e-8	NR	HIB69429.1	2052180	g15013	i0	65.2	1.8	46	16	83.6	0	1	138	9	54	HIB69429.1 hypothetical protein [Phycisphaerales bacterium]	diamond	297	55.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28272314	28272314	PRJNA1188114_P_NODE_14546_length_165_cov_0.879310_g14494_i0	PRJNA1188114	14546	165	0.87931	1.4508615	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	100	1.22e-24	NR	WP_171473219.1	2774151	g14494	i0	88.2	0.927272727272727	51	6	92.7	0	11	163	1	51	WP_171473219.1 metallophosphoesterase family protein [Frigoriglobus tundricola]	diamond	153	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
30451735	30451735	PRJNA1188114_P_NODE_1713_length_325_cov_1.213768_g1661_i0	PRJNA1188114	1713	325	1.213768	3.944746	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	60.5	5.72e-8	NR	MFM8580792.1	2026779	g1661	i0	49.3	1.91076923076923	69	35	63.7	0	302	96	424	492	MFM8580792.1 collagen binding domain-containing protein [Planctomycetaceae bacterium]	diamond	621	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31052082	31052082	PRJNA1188114_P_NODE_16815_length_163_cov_0.894737_g16763_i0	PRJNA1188114	16815	163	0.894737	1.45842131	Lacipirellula sp.	2691419	Bacteria	Bacteria	85.9	1.54e-19	NR	HEX6961070.1	2691419	g16763	i0	75	2.9079754601227	52	13	95.7	0	158	3	57	108	HEX6961070.1 hypothetical protein [Lacipirellula sp.]	diamond	474	85.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula sp.
31494598	31494598	PRJNA1188114_P_NODE_9096_length_179_cov_1.269231_g9044_i0	PRJNA1188114	9096	179	1.269231	2.27192349	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	68.9	5.01e-12	NR	HEV8293106.1	2876886	g9044	i0	69.5	0.988826815642458	59	18	98.9	0	178	2	113	171	HEV8293106.1 ABC transporter permease [Tepidisphaeraceae bacterium]	diamond	177	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
32348874	32348874	PRJNA1188114_P_NODE_18059_length_162_cov_0.902655_g18007_i0	PRJNA1188114	18059	162	0.902655	1.4623011	Gemmata sp.	1914242	Bacteria	Bacteria	67.4	2.43e-11	NR	HEY1186586.1	1914242	g18007	i0	67.9	1.96296296296296	53	17	98.1	0	3	161	638	690	HEY1186586.1 hypothetical protein [Gemmata sp.]	diamond	318	67.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp.
32412025	32412025	PRJNA1188114_P_NODE_13499_length_166_cov_0.871795_g13447_i0	PRJNA1188114	13499	166	0.871795	1.4471797	Gemmataceae bacterium	2052164	Bacteria	Bacteria	92	2.5300000000000003e-21	NR	HEX4590977.1	2052164	g13447	i0	86.5	4.75301204819277	52	7	94	0	7	162	42	93	HEX4590977.1 adenosine kinase [Gemmataceae bacterium]	diamond	789	92	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32884848	32884848	PRJNA1188114_P_NODE_8700_length_181_cov_1.219697_g8648_i0	PRJNA1188114	8700	181	1.219697	2.20765157	Pirellulales bacterium	2715253	Bacteria	Bacteria	102	1.58e-24	NR	MCC7476623.1	2715253	g8648	i0	74.6	1.95580110497238	59	15	97.8	0	1	177	87	145	MCC7476623.1 hypothetical protein [Pirellulales bacterium]	diamond	354	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales 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);;