metadata: contig_metadata: 26 rows where bioproject = "PRJNA255848" and tax

26 rows where bioproject = "PRJNA255848" 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
368698	368698	PRJNA255848_P_NODE_4141_length_553_cov_3.521825_g3837_i0	PRJNA255848	4141	553	3.521825	19.47569225	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	933	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g3837	i0	97.107	278.580470162749	553	16	100	0	1	553	2463	1911	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	154055	933	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
1643575	1643575	PRJNA255848_P_NODE_722_length_1244_cov_4.487029_g578_i0	PRJNA255848	722	1244	4.487029	55.81864076	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	1954	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g578	i0	95.016	225.733922829582	1244	62	100	0	1	1244	338	1581	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	280813	1954	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
6746355	6746355	PRJNA255848_P_NODE_2246_length_757_cov_8.899718_g1994_i0	PRJNA255848	2246	757	8.899718	67.37086526	Limnoglobus roseus	2598579	Bacteria	Bacteria	1168	0	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g1994	i0	94.591	197.095112285337	758	35	100	4	1	757	2956139	2956891	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	149201	1168	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
9296651	9296651	PRJNA255848_P_NODE_12608_length_285_cov_6.961864_g12290_i0	PRJNA255848	12608	285	6.961864	19.8413124	Limnoglobus roseus	2598579	Bacteria	Bacteria	505	1.6799999999999995e-138	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g12290	i0	98.596	108.761403508772	285	4	100	0	1	285	2958882	2958598	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	30997	505	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
9985098	9985098	PRJNA255848_P_NODE_42368_length_164_cov_0.886957_g42050_i0	PRJNA255848	42368	164	0.886957	1.45460948	Pedosphaera	1032526	Bacteria	Bacteria	102	6.25e-25	NR	PHX95918.1	2024890	g42050	i0	92.6	3.95121951219512	54	4	98.8	0	1	162	108	161	PHX95918.1 MAG: hypothetical protein CK546_00005 [Pedosphaera sp.]	diamond	648	102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.
13122435	13122435	PRJNA255848_P_NODE_18991_length_228_cov_1.703911_g18673_i0	PRJNA255848	18991	228	1.703911	3.88491708	Luteolibacter sp.	1962973	Bacteria	Bacteria	372	1.37e-98	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g18673	i0	96.053	273.565789473684	228	9	100	0	1	228	1008799	1009026	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	62373	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
13122578	13122578	PRJNA255848_P_NODE_7491_length_391_cov_7.368421_g7173_i0	PRJNA255848	7491	391	7.368421	28.81052611	Limnoglobus roseus	2598579	Bacteria	Bacteria	468	3.13e-127	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g7173	i0	88.601	142.797953964194	386	42	100	2	1	385	2956139	2956523	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	55834	468	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
18220445	18220445	PRJNA255848_P_NODE_7955_length_377_cov_2.268293_g7637_i0	PRJNA255848	7955	377	2.268293	8.55146461	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	577	4.789999999999999e-160	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g7637	i0	97.904	231.46949602122	334	5	88	1	46	377	1562	1895	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	87264	577	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
19494638	19494638	PRJNA255848_P_NODE_44436_length_162_cov_2.867257_g44118_i0	PRJNA255848	44436	162	2.867257	4.64495634	Urbifossiella limnaea	2528023	Bacteria	Bacteria	291	2.62e-74	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g44118	i0	99.375	125.981481481481	160	1	99	0	3	162	2018965	2019124	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	20409	291	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
20770177	20770177	PRJNA255848_P_NODE_19217_length_227_cov_1.196629_g18899_i0	PRJNA255848	19217	227	1.196629	2.71634783	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	329	8.34e-86	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g18899	i0	92.952	127.290748898678	227	15	100	1	1	227	4421234	4421009	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	28895	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
20770225	20770225	PRJNA255848_P_NODE_34877_length_167_cov_1.559322_g34559_i0	PRJNA255848	34877	167	1.559322	2.60406774	Urbifossiella limnaea	2528023	Bacteria	Bacteria	261	2.14e-65	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g34559	i0	94.675	76.2994011976048	169	7	100	1	1	167	2020065	2020233	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	12742	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
22045238	22045238	PRJNA255848_P_NODE_16818_length_243_cov_2.097938_g16500_i0	PRJNA255848	16818	243	2.097938	5.09798934	Urbifossiella limnaea	2528023	Bacteria	Bacteria	403	5.25e-108	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g16500	i0	96.694	223.699588477366	242	8	99	0	1	242	2018120	2017879	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	54359	403	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
22045259	22045259	PRJNA255848_P_NODE_24638_length_201_cov_1.039474_g24320_i0	PRJNA255848	24638	201	1.039474	2.08934274	Limnoglobus roseus	2598579	Bacteria	Bacteria	119	1.7000000000000002e-22	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g24320	i0	80.117	2.64179104477612	171	25	92	8	18	185	4089609	4089445	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	531	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
22045271	22045271	PRJNA255848_P_NODE_28178_length_187_cov_3.797101_g27860_i0	PRJNA255848	28178	187	3.797101	7.10057887	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	243	8.85e-60	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g27860	i0	92.398	3.01604278074866	171	11	91	2	4	173	316	147	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	564	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
22045373	22045373	PRJNA255848_P_NODE_8898_length_352_cov_3.006601_g8580_i0	PRJNA255848	8898	352	3.006601	10.58323552	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	579	1.2299999999999996e-160	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g8580	i0	96.307	142.068181818182	352	13	100	0	1	352	2002343	2002694	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	50008	579	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
27832078	27832078	PRJNA255848_P_NODE_47504_length_161_cov_0.910714_g47186_i0	PRJNA255848	47504	161	0.910714	1.46624954	Gemmataceae bacterium	2052164	Bacteria	Bacteria	61.6	1.31e-9	NR	MFO0878164.1	2052164	g47186	i0	52.8	0.987577639751553	53	25	98.8	0	160	2	163	215	MFO0878164.1 GntR family transcriptional regulator [Gemmataceae bacterium]	diamond	159	61.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28590066	28590066	PRJNA255848_P_NODE_38867_length_165_cov_1.318966_g38549_i0	PRJNA255848	38867	165	1.318966	2.1762939	Planctomycetota bacterium	2026780	Bacteria	Bacteria	40.8	0.0387	NR	MCG3134052.1	2026780	g38549	i0	54.8	0.563636363636364	31	14	56.4	0	165	73	104	134	MCG3134052.1 hypothetical protein [Planctomycetota bacterium]	diamond	93	40.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28590070	28590070	PRJNA255848_P_NODE_46147_length_162_cov_0.902655_g45829_i0	PRJNA255848	46147	162	0.902655	1.4623011	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	60.1	1.59e-9	NR	HMO25009.1	2876886	g45829	i0	65.2	2.7962962962963	46	16	85.2	0	160	23	91	136	HMO25009.1 glycosyltransferase [Tepidisphaeraceae bacterium]	diamond	453	60.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
28828503	28828503	PRJNA255848_P_NODE_47248_length_161_cov_0.910714_g46930_i0	PRJNA255848	47248	161	0.910714	1.46624954	Bacteria	2	Bacteria	Bacteria	74.3	8.4e-15	NR	MEA2011983.1	2026799	g46930	i0	60.4	3.93167701863354	53	21	98.8	0	159	1	35	87	MEA2011983.1 phosphohydrolase [Verrucomicrobiota bacterium]	diamond	633	74.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29032178	29032178	PRJNA255848_P_NODE_39108_length_165_cov_0.879310_g38790_i0	PRJNA255848	39108	165	0.87931	1.4508615	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	42.4	0.018	NR	MBQ7206390.1	2053569	g38790	i0	44.8	0.527272727272727	29	16	52.7	0	34	120	17	45	MBQ7206390.1 helix-turn-helix domain-containing protein [Lentisphaeria bacterium]	diamond	87	42.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
29726289	29726289	PRJNA255848_P_NODE_18250_length_233_cov_1.135870_g17932_i0	PRJNA255848	18250	233	1.13587	2.6465771	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	42.4	0.0414	NR	HEY3862872.1	2499141	g17932	i0	48.5	0.424892703862661	33	17	42.5	0	91	189	193	225	HEY3862872.1 3'(2'),5'-bisphosphate nucleotidase CysQ [Verrucomicrobiia bacterium]	diamond	99	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30263901	30263901	PRJNA255848_P_NODE_45952_length_162_cov_0.902655_g45634_i0	PRJNA255848	45952	162	0.902655	1.4623011	Luteolibacter yonseiensis	1144680	Bacteria	Bacteria	92.4	2.25e-21	NR	WP_200350219.1	1144680	g45634	i0	75.9	1	54	13	100	0	1	162	121	174	WP_200350219.1 GDSL-type esterase/lipase family protein [Luteolibacter yonseiensis]	diamond	162	92.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter yonseiensis
31780644	31780644	PRJNA255848_P_NODE_42157_length_164_cov_0.886957_g41839_i0	PRJNA255848	42157	164	0.886957	1.45460948	Chlamydiota bacterium	2081524	Bacteria	Bacteria	111	3.3799999999999993e-28	NR	MES2122925.1	2081524	g41839	i0	92.6	0.98780487804878	54	4	98.8	0	163	2	14	67	MES2122925.1 metallophosphoesterase [Chlamydiota bacterium]	diamond	162	111	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
31938823	31938823	PRJNA255848_P_NODE_35577_length_167_cov_0.864407_g35259_i0	PRJNA255848	35577	167	0.864407	1.44355969	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	64.3	3.17e-10	NR	HMO24746.1	2876886	g35259	i0	56.4	0.988023952095808	55	24	98.8	0	165	1	49	103	HMO24746.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	165	64.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
32540372	32540372	PRJNA255848_P_NODE_27879_length_188_cov_2.201439_g27561_i0	PRJNA255848	27879	188	2.201439	4.13870532	Isosphaera sp.	41672	Bacteria	Bacteria	42	0.006	NR	MBA4062752.1	41672	g27561	i0	44.4	0.574468085106383	36	20	57.4	0	10	117	36	71	MBA4062752.1 hypothetical protein [Isosphaera sp.]	diamond	108	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera sp.
32791952	32791952	PRJNA255848_P_NODE_34060_length_169_cov_1.700000_g33742_i0	PRJNA255848	34060	169	1.7	2.873	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	45.8	9.95e-4	NR	MDP2913672.1	2035772	g33742	i0	57.9	1.2603550295858	38	13	67.5	1	122	9	33	67	MDP2913672.1 dTMP kinase [Candidatus Omnitrophota bacterium]	diamond	213	45.8	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota 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);;