metadata: contig_metadata: 29 rows where bioproject = "PRJNA909412" and tax

29 rows where bioproject = "PRJNA909412" 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
1249231	1249231	PRJNA909412_P_NODE_12981_length_161_cov_2.008197_g12840_i0	PRJNA909412	12981	161	2.008197	3.23319717	Rosistilla	2795779	Bacteria	Bacteria	167	4.5799999999999995e-37	NTclustered	gi\|1712438206\|gb\|CP036261.1\|	1930277	g12840	i0	85.976	115.062111801242	164	14	99	9	3	161	974730	974889	Rosistilla ulvae strain EC9 chromosome	blastn	18525	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla ulvae
3441497	3441497	PRJNA909412_P_NODE_1863_length_399_cov_2.166667_g1723_i0	PRJNA909412	1863	399	2.166667	8.64500133	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	636	8.299999999999999e-178	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g1723	i0	95.489	163.611528822055	399	16	100	1	1	399	1808	1412	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	65281	636	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
5077425	5077425	PRJNA909412_P_NODE_12184_length_163_cov_1.725806_g12043_i0	PRJNA909412	12184	163	1.725806	2.81306378	Gemmataceae	1914233	Bacteria	Bacteria	209	7.62e-50	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g12043	i0	90.244	356.398773006135	164	10	98	6	1	160	3633834	3633673	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	58093	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
5993871	5993871	PRJNA909412_P_NODE_1185_length_515_cov_2.941176_g1048_i0	PRJNA909412	1185	515	2.941176	15.1470564	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	523	8.889999999999997e-144	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g1048	i0	89.951	240.594174757282	408	37	79	3	2	408	1384	980	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	123906	523	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
5993947	5993947	PRJNA909412_P_NODE_3785_length_270_cov_1.909091_g3644_i0	PRJNA909412	3785	270	1.909091	5.1545457	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	455	1.6100000000000002e-123	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g3644	i0	97.037	84.9037037037037	270	8	100	0	1	270	5153588	5153319	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	22924	455	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
12728684	12728684	PRJNA909412_P_NODE_9410_length_175_cov_1.220588_g9269_i0	PRJNA909412	9410	175	1.220588	2.136029	Gimesia	1649453	Bacteria	Bacteria	95.3	2.42e-15	NTclustered	gi\|1712496122\|gb\|CP036269.1\|	2527973	g9269	i0	77.64	21.5085714285714	161	33	92	3	1	161	2394735	2394892	Gimesia alba strain Pan241w chromosome	blastn	3764	95.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia alba
16193475	16193475	PRJNA909412_P_NODE_1853_length_400_cov_2.445983_g1713_i0	PRJNA909412	1853	400	2.445983	9.783932	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	662	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g1713	i0	96.725	160.4025	397	13	99	0	4	400	653	257	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	64161	662	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
16551671	16551671	PRJNA909412_P_NODE_1353_length_474_cov_3.337931_g1214_i0	PRJNA909412	1353	474	3.337931	15.82179294	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	241	1.05e-74	NR	NUQ35036.1	2026779	g1214	i0	64.6	5.6075949367088596	178	41	98.7	1	2	469	97	274	NUQ35036.1 adenosylhomocysteinase [Planctomycetaceae bacterium]	diamond	2658	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
17468980	17468980	PRJNA909412_P_NODE_3274_length_291_cov_1.416667_g3133_i0	PRJNA909412	3274	291	1.416667	4.12250097	Lignipirellula cremea	2528010	Bacteria	Bacteria	315	3.11e-81	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g3133	i0	89.02	96.7457044673539	255	26	87	2	35	288	1144396	1144143	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	28153	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea
17468997	17468997	PRJNA909412_P_NODE_6194_length_211_cov_0.953488_g6053_i0	PRJNA909412	6194	211	0.953488	2.01185968	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	379	7.489999999999999e-101	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g6053	i0	99.052	119.284360189573	211	2	100	0	1	211	664	874	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	25169	379	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
19100684	19100684	PRJNA909412_P_NODE_11135_length_171_cov_3.272727_g10994_i0	PRJNA909412	11135	171	3.272727	5.59636317	Prosthecobacter	48463	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|219846433\|ref\|NR_026024.1\|	48464	g10994	i0	100	100.005847953216	171	0	100	0	1	171	1230	1060	Prosthecobacter fusiformis strain FC4 16S ribosomal RNA, partial sequence	blastn	17101	316	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
20375513	20375513	PRJNA909412_P_NODE_17536_length_150_cov_2.846847_g17395_i0	PRJNA909412	17536	150	2.846847	4.2702705	Bacteria	2	Bacteria	Bacteria	207	2.46e-49	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g17395	i0	91.946	10.04	149	10	99	2	2	150	2582829	2582975	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	1506	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
20375526	20375526	PRJNA909412_P_NODE_6776_length_202_cov_2.355828_g6635_i0	PRJNA909412	6776	202	2.355828	4.75877256	Bacteria	2	Bacteria	Bacteria	122	2.75e-30	NR	MBT8037638.1	2499141	g6635	i0	80.6	9.93564356435644	67	13	99.5	0	2	202	624	690	MBT8037638.1 aminomethyl-transferring glycine dehydrogenase [Verrucomicrobiia bacterium]	diamond	2007	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
23842953	23842953	PRJNA909412_P_NODE_7139_length_197_cov_4.392405_g6998_i0	PRJNA909412	7139	197	4.392405	8.65303785	Planctomycetota bacterium	2026780	Bacteria	Bacteria	63.9	7.88e-6	NTclustered	gi\|2907625648\|emb\|OZ223208.1\|	2026780	g6998	i0	95.122	1.11675126903553	41	1	20	1	104	143	1495077	1495117	MAG: Planctomycetota bacterium isolate 604ccff8-4b2f-4b13-82eb-4b7433267518 genome assembly, chromosome: 1	blastn	220	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26897966	26897966	PRJNA909412_P_NODE_13481_length_160_cov_2.851240_g13340_i0	PRJNA909412	13481	160	2.85124	4.561984	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	50.4	2.23e-5	NR	MCE5340208.1	2026779	g13340	i0	47.4	2.1375	57	25	97.5	1	3	158	828	884	MCE5340208.1 translation initiation factor IF-2 [Planctomycetaceae bacterium]	diamond	342	50.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27024371	27024371	PRJNA909412_P_NODE_15802_length_153_cov_2.052632_g15661_i0	PRJNA909412	15802	153	2.052632	3.14052696	Chlamydiota bacterium	2081524	Bacteria	Bacteria	63.5	4.87e-10	NR	NBO24982.1	2081524	g15661	i0	54.9	7	51	23	100	0	1	153	88	138	NBO24982.1 type III PLP-dependent enzyme [Chlamydiota bacterium]	diamond	1071	63.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
27118987	27118987	PRJNA909412_P_NODE_16222_length_152_cov_2.123894_g16081_i0	PRJNA909412	16222	152	2.123894	3.22831888	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	90.5	9.5e-20	NR	MCI0362746.1	2052180	g16081	i0	85.1	10.1052631578947	47	7	92.8	0	11	151	151	197	MCI0362746.1 MmgE/PrpD family protein [Phycisphaerales bacterium]	diamond	1536	90.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27972002	27972002	PRJNA909412_P_NODE_1765_length_412_cov_3.632708_g1625_i0	PRJNA909412	1765	412	3.632708	14.96675696	Waddliaceae bacterium	2026802	Bacteria	Bacteria	98.6	1.7700000000000003e-21	NR	HEY4831209.1	2026802	g1625	i0	62	0.575242718446602	79	30	57.5	0	407	171	242	320	HEY4831209.1 F0F1 ATP synthase subunit alpha [Waddliaceae bacterium]	diamond	237	98.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
28066723	28066723	PRJNA909412_P_NODE_8205_length_186_cov_1.088435_g8064_i0	PRJNA909412	8205	186	1.088435	2.0244891	Simkania sp.	34094	Bacteria	Bacteria	52.4	4.37e-7	NR	MCB1084365.1	34094	g8064	i0	43.3	0.967741935483871	60	34	96.8	0	182	3	2	61	MCB1084365.1 hypothetical protein [Simkania sp.]	diamond	180	52.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
28571882	28571882	PRJNA909412_P_NODE_16767_length_151_cov_2.482143_g16626_i0	PRJNA909412	16767	151	2.482143	3.74803593	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	67.8	1.12e-11	NR	MEP6809396.1	2201154	g16626	i0	61.7	0.933774834437086	47	18	93.4	0	142	2	119	165	MEP6809396.1 arginine deiminase-related protein [Chthoniobacterales bacterium]	diamond	141	67.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29203609	29203609	PRJNA909412_P_NODE_12169_length_163_cov_2.016129_g12028_i0	PRJNA909412	12169	163	2.016129	3.28629027	Planctomycetota bacterium	2026780	Bacteria	Bacteria	80.5	5.94e-16	NR	MBM3984144.1	2026780	g12028	i0	73.5	7.38036809815951	49	13	90.2	0	154	8	302	350	MBM3984144.1 M20/M25/M40 family metallo-hydrolase [Planctomycetota bacterium]	diamond	1203	80.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29298169	29298169	PRJNA909412_P_NODE_11949_length_165_cov_1.936508_g11808_i0	PRJNA909412	11949	165	1.936508	3.1952382	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	82.8	7.49e-17	NR	MCB1120004.1	2499141	g11808	i0	82	2.72727272727273	50	9	90.9	0	3	152	125	174	MCB1120004.1 bifunctional folylpolyglutamate synthase/dihydrofolate synthase [Verrucomicrobiia bacterium]	diamond	450	82.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30404044	30404044	PRJNA909412_P_NODE_1233_length_504_cov_6.516129_g1095_i0	PRJNA909412	1233	504	6.516129	32.84129016	PVC group bacterium	2056642	Bacteria	Bacteria	54.3	3.65e-6	NR	MCP4648866.1	2056642	g1095	i0	35.9	0.81547619047619	103	66	61.3	0	92	400	1	103	MCP4648866.1 hypothetical protein [PVC group bacterium]	diamond	411	54.3	1	Bacteria	PVC group	Pseudomonadati						PVC group bacterium
31478324	31478324	PRJNA909412_P_NODE_3816_length_269_cov_1.073913_g3675_i0	PRJNA909412	3816	269	1.073913	2.88882597	Planctomycetota bacterium	2026780	Bacteria	Bacteria	83.2	4.8e-17	NR	MCB9913063.1	2026780	g3675	i0	55.7	2.63197026022305	79	34	88.1	1	267	31	171	248	MCB9913063.1 SDR family oxidoreductase [Planctomycetota bacterium]	diamond	708	83.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31699578	31699578	PRJNA909412_P_NODE_11217_length_171_cov_1.727273_g11076_i0	PRJNA909412	11217	171	1.727273	2.95363683	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	41.2	0.0498	NR	HZW05812.1	2052180	g11076	i0	50	0.631578947368421	36	14	56.1	1	52	147	40	75	HZW05812.1 class I SAM-dependent methyltransferase [Phycisphaerales bacterium]	diamond	108	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32015861	32015861	PRJNA909412_P_NODE_4978_length_234_cov_1.487179_g4837_i0	PRJNA909412	4978	234	1.487179	3.47999886	Planctomycetota bacterium	2026780	Bacteria	Bacteria	71.2	3.05e-12	NR	PCH78894.1	2026780	g4837	i0	46.7	0.961538461538462	75	40	96.2	0	234	10	545	619	PCH78894.1 MAG: hypothetical protein COB96_04960 [Planctomycetota bacterium]	diamond	225	71.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32047602	32047602	PRJNA909412_P_NODE_158_length_1288_cov_8.624500_g127_i0	PRJNA909412	158	1288	8.6245	111.08356	PVC group bacterium	2056642	Bacteria	Bacteria	63.2	2.3e-8	NR	MCP4648866.1	2056642	g127	i0	44	0.232919254658385	100	56	23.3	0	477	178	1	100	MCP4648866.1 hypothetical protein [PVC group bacterium]	diamond	300	63.2	1	Bacteria	PVC group	Pseudomonadati						PVC group bacterium
32079118	32079118	PRJNA909412_P_NODE_9478_length_174_cov_2.681481_g9337_i0	PRJNA909412	9478	174	2.681481	4.66577694	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	49.3	7.01e-5	NR	MCH2162015.1	2052180	g9337	i0	40	1.86206896551724	55	31	91.4	1	8	166	359	413	MCH2162015.1 MmgE/PrpD family protein [Phycisphaerales bacterium]	diamond	324	49.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32427285	32427285	PRJNA909412_P_NODE_1239_length_502_cov_3.231102_g1100_i0	PRJNA909412	1239	502	3.231102	16.22013204	Planctomycetota bacterium	2026780	Bacteria	Bacteria	171	1.12e-48	NR	MCD6378656.1	2026780	g1100	i0	52.5	1.91235059760956	160	75	95	1	486	10	84	243	MCD6378656.1 Gfo/Idh/MocA family oxidoreductase [Planctomycetota bacterium]	diamond	960	171	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);;