metadata: contig_metadata: 31 rows where bioproject = "PRJNA657343" and tax

31 rows where bioproject = "PRJNA657343" 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
1899892	1899892	PRJNA657343_S_NODE_20122_length_201_cov_3.368421_g20097_i0	PRJNA657343	20122	201	3.368421	6.77052621	Phycisphaera sp.	2030824	Bacteria	Bacteria	237	4.4999999999999996e-58	NTclustered	gi\|2323351239\|gb\|CP098402.1\|	2030824	g20097	i0	88.06	8.48258706467662	201	23	100	1	1	201	3047330	3047131	MAG: Phycisphaera sp. isolate MAG12 chromosome	blastn	1705	237	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
1900206	1900206	PRJNA657343_S_NODE_27662_length_169_cov_5.383333_g27637_i0	PRJNA657343	27662	169	5.383333	9.09783277	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	235	1.31e-57	NTclustered	gi\|1938775668\|gb\|CP054178.1\|	2026777	g27637	i0	92.169	204.668639053254	166	13	98	0	1	166	192629	192464	MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome	blastn	34589	235	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
4450721	4450721	PRJNA657343_P_NODE_15824_length_226_cov_3.333333_g15800_i0	PRJNA657343	15824	226	3.333333	7.53333258	Simkania sp.	34094	Bacteria	Bacteria	127	1.99e-35	NR	MCB1084350.1	34094	g15800	i0	80	1.85840707964602	70	14	92.9	0	2	211	27	96	MCB1084350.1 MC/SLC25 family protein [Simkania sp.]	diamond	420	127	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
4452108	4452108	PRJNA657343_S_NODE_32884_length_151_cov_5.607843_g32859_i0	PRJNA657343	32884	151	5.607843	8.46784293	Horticoccus luteus	2862869	Bacteria	Bacteria	244	1.89e-60	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g32859	i0	98.561	33.4437086092715	139	1	92	1	1	139	540019	540156	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	5050	244	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
7001653	7001653	PRJNA657343_P_NODE_3126_length_414_cov_3.106849_g3103_i0	PRJNA657343	3126	414	3.106849	12.86235486	Simkania sp.	34094	Bacteria	Bacteria	209	1.42e-65	NR	MCB1084310.1	34094	g3103	i0	75.4	0.971014492753623	134	33	97.1	0	6	407	51	184	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	402	209	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
9551445	9551445	PRJNA657343_P_NODE_17488_length_218_cov_1.763314_g17464_i0	PRJNA657343	17488	218	1.763314	3.84402452	Pirellulales bacterium	2715253	Bacteria	Bacteria	101	2.58e-23	NR	MBN2295153.1	2715253	g17464	i0	78.9	0.784403669724771	57	12	78.4	0	5	175	382	438	MBN2295153.1 adenosylhomocysteinase [Pirellulales bacterium]	diamond	171	101	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
9552485	9552485	PRJNA657343_S_NODE_25028_length_179_cov_1.823077_g25003_i0	PRJNA657343	25028	179	1.823077	3.26330783	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	211	2.36e-50	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g25003	i0	88.268	120.441340782123	179	17	99	4	2	178	655212	655388	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	21559	211	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
13914369	13914369	PRJNA657343_P_NODE_22331_length_199_cov_1.346667_g22307_i0	PRJNA657343	22331	199	1.346667	2.67986733	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	99.8	1.35e-22	NR	PHY00844.1	2026779	g22307	i0	66.2	4.89949748743719	65	22	98	0	197	3	342	406	PHY00844.1 MAG: betaine-aldehyde dehydrogenase [Planctomycetaceae bacterium]	diamond	975	99.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
14652424	14652424	PRJNA657343_S_NODE_13792_length_244_cov_5.692308_g13767_i0	PRJNA657343	13792	244	5.692308	13.88923152	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	219	2.05e-52	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g13767	i0	84.052	14.827868852459	232	32	94	5	1	230	2190373	2190145	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	3618	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
14653141	14653141	PRJNA657343_S_NODE_31612_length_156_cov_2.457944_g31587_i0	PRJNA657343	31612	156	2.457944	3.83439264	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	206	9.32e-49	NTclustered	gi\|2916415364\|gb\|CP170459.1\|	2026799	g31587	i0	90.446	94.974358974359	157	14	100	1	1	156	2577657	2577813	MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome	blastn	14816	206	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
15189027	15189027	PRJNA657343_S_NODE_28732_length_166_cov_2.350427_g28707_i0	PRJNA657343	28732	166	2.350427	3.90170882	Verrucomicrobiota	74201	Bacteria	Bacteria	182	1.7e-41	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g28707	i0	89.041	31.7710843373494	146	16	88	0	1	146	5152316	5152461	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	5274	182	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18475791	18475791	PRJNA657343_S_NODE_15155_length_233_cov_3.320652_g15130_i0	PRJNA657343	15155	233	3.320652	7.73711916	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	335	1.8499999999999992e-87	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g15130	i0	94.47	110.609442060086	217	12	93	0	2	218	2556208	2556424	Lacunisphaera limnophila strain IG16b, complete genome	blastn	25772	335	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
24849770	24849770	PRJNA657343_S_NODE_13160_length_249_cov_30.555000_g13135_i0	PRJNA657343	13160	249	30.555	76.08195	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	307	4.3600000000000006e-79	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g13135	i0	89.243	3.78313253012048	251	20	100	6	1	249	2190130	2190375	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	942	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
26745106	26745106	PRJNA657343_P_NODE_41021_length_164_cov_2.243478_g40997_i0	PRJNA657343	41021	164	2.243478	3.67930392	Pseudomonadati	3379134	Bacteria	Bacteria	79	2.18e-15	NR	HWA87775.1	1913982	g40997	i0	70	3.58536585365854	50	15	91.5	0	151	2	11	60	HWA87775.1 phosphoenolpyruvate carboxykinase (GTP) [Opitutus sp.]	diamond	588	79	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
26891742	26891742	PRJNA657343_P_NODE_4521_length_359_cov_3.725806_g4498_i0	PRJNA657343	4521	359	3.725806	13.37564354	Planctomycetota bacterium	2026780	Bacteria	Bacteria	45.4	0.0145	NR	MCB9879835.1	2026780	g4498	i0	27.5	0.852367688022284	102	61	85.2	2	311	6	306	394	MCB9879835.1 hypothetical protein [Planctomycetota bacterium]	diamond	306	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27018043	27018043	PRJNA657343_P_NODE_17322_length_219_cov_1.152941_g17298_i0	PRJNA657343	17322	219	1.152941	2.52494079	Planctomycetia bacterium	2052181	Bacteria	Bacteria	54.7	1.95e-7	NR	MBL8864092.1	2052181	g17298	i0	54.3	0.63013698630137	46	21	63	0	2	139	29	74	MBL8864092.1 hypothetical protein [Planctomycetia bacterium]	diamond	138	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
27175966	27175966	PRJNA657343_P_NODE_40282_length_165_cov_0.896552_g40258_i0	PRJNA657343	40282	165	0.896552	1.4793108	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	47.4	1.62e-4	NR	MEZ6235105.1	2052180	g40258	i0	59.4	0.581818181818182	32	13	58.2	0	105	10	13	44	MEZ6235105.1 thiol-disulfide oxidoreductase DCC family protein [Phycisphaerales bacterium]	diamond	96	47.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27523711	27523711	PRJNA657343_P_NODE_4663_length_355_cov_2.810458_g4640_i0	PRJNA657343	4663	355	2.810458	9.9771259	Opitutaceae bacterium	2006848	Bacteria	Bacteria	48.9	9.82e-4	NR	MFA6288203.1	2006848	g4640	i0	35.2	0.912676056338028	108	67	90.4	3	34	354	1090	1195	MFA6288203.1 Ig-like domain-containing protein [Opitutaceae bacterium]	diamond	324	48.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
27744998	27744998	PRJNA657343_P_NODE_22264_length_199_cov_1.986667_g22240_i0	PRJNA657343	22264	199	1.986667	3.95346733	Pirellula sp.	117	Bacteria	Bacteria	41.6	0.0489	NR	MCF7963611.1	117	g22240	i0	36.1	0.919597989949749	61	29	76.9	2	6	158	59	119	MCF7963611.1 lysophospholipid acyltransferase family protein [Pirellula sp.]	diamond	183	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
27997468	27997468	PRJNA657343_P_NODE_24605_length_192_cov_1.321678_g24581_i0	PRJNA657343	24605	192	1.321678	2.53762176	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	42.4	0.0272	NR	HEV7300754.1	2876886	g24581	i0	42.9	0.65625	42	24	65.6	0	46	171	577	618	HEV7300754.1 ankyrin repeat domain-containing protein [Tepidisphaeraceae bacterium]	diamond	126	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
28029037	28029037	PRJNA657343_P_NODE_44965_length_161_cov_3.125000_g44941_i0	PRJNA657343	44965	161	3.125	5.03125	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	48.5	1.1e-4	NR	HEV8604544.1	2876886	g44941	i0	43.1	1.90062111801242	51	25	95	1	3	155	124	170	HEV8604544.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	306	48.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
28092001	28092001	PRJNA657343_P_NODE_32745_length_173_cov_1.645161_g32721_i0	PRJNA657343	32745	173	1.645161	2.84612853	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	47.8	2.46e-4	NR	MBM4165303.1	1932692	g32721	i0	46.8	1.5606936416185	47	25	81.5	0	146	6	97	143	MBM4165303.1 RCC1 repeat-containing protein [Lentisphaerota bacterium]	diamond	270	47.8	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
28198805	28198805	PRJNA657343_P_NODE_28026_length_183_cov_3.208955_g28002_i0	PRJNA657343	28026	183	3.208955	5.87238765	root	1	Root_unresolved	Root_unresolved	71.2	9.88e-13	NR	MEW6160975.1	2026799	g28002	i0	65.3	2.37704918032787	49	17	80.3	0	181	35	273	321	MEW6160975.1 transaldolase [Verrucomicrobiota bacterium]	diamond	435	71.6	0.994413407821229	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28641209	28641209	PRJNA657343_P_NODE_13087_length_243_cov_0.773196_g13063_i0	PRJNA657343	13087	243	0.773196	1.87886628	Verrucomicrobiota	74201	Bacteria	Bacteria	122	1.07e-30	NR	HEY5894404.1	2201154	g13063	i0	74.4	6.74074074074074	78	20	96.3	0	239	6	369	446	HEY5894404.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Chthoniobacterales bacterium]	diamond	1638	123	0.991869918699187	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29165777	29165777	PRJNA657343_P_NODE_16869_length_221_cov_1.180233_g16845_i0	PRJNA657343	16869	221	1.180233	2.60831493	Candidatus Brocadiia bacterium	2517210	Bacteria	Bacteria	77	2.26e-14	NR	NUM34221.1	2517210	g16845	i0	54.9	0.963800904977376	71	26	91	2	19	219	396	464	NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium]	diamond	213	77	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia bacterium
29240980	29240980	PRJNA657343_P_NODE_34169_length_170_cov_2.049587_g34145_i0	PRJNA657343	34169	170	2.049587	3.4842979	Bacteria	2	Bacteria	Bacteria	88.2	1.48e-19	NR	GJM22915.1	2026780	g34145	i0	66.1	5.85882352941176	56	19	98.8	0	3	170	119	174	GJM22915.1 MAG: 2,3-bisphosphoglycerate-dependent phosphoglycerate mutase [Planctomycetota bacterium]	diamond	996	89	0.991011235955056	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30966192	30966192	PRJNA657343_P_NODE_12574_length_246_cov_3.106599_g12550_i0	PRJNA657343	12574	246	3.106599	7.64223354	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	104	4.42e-24	NR	MCB9847620.1	2026777	g12550	i0	66.7	0.804878048780488	66	22	80.5	0	198	1	3	68	MCB9847620.1 aspartate aminotransferase family protein [Phycisphaeraceae bacterium]	diamond	198	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
31377075	31377075	PRJNA657343_P_NODE_12976_length_243_cov_5.500000_g12952_i0	PRJNA657343	12976	243	5.5	13.365	Chlamydiales bacterium	2047757	Bacteria	Bacteria	102	1.05e-25	NR	MCP5470420.1	2047757	g12952	i0	80	0.740740740740741	60	12	74.1	0	241	62	20	79	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	180	102	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31598540	31598540	PRJNA657343_P_NODE_17296_length_219_cov_1.200000_g17272_i0	PRJNA657343	17296	219	1.2	2.628	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	44.3	0.00787	NR	MBX3744974.1	2499141	g17272	i0	45.9	0.835616438356164	61	32	82.2	1	23	202	83	143	MBX3744974.1 protein kinase [Verrucomicrobiia bacterium]	diamond	183	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31819650	31819650	PRJNA657343_P_NODE_13217_length_242_cov_1.113990_g13193_i0	PRJNA657343	13217	242	1.11399	2.6958558	Simkania sp.	34094	Bacteria	Bacteria	44.7	0.00667	NR	MCB1084310.1	34094	g13193	i0	55.6	0.446280991735537	36	16	44.6	0	2	109	161	196	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	108	44.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
32294723	32294723	PRJNA657343_P_NODE_18679_length_213_cov_0.871951_g18655_i0	PRJNA657343	18679	213	0.871951	1.85725563	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	107	5.17e-26	NR	RYD65414.1	2026800	g18655	i0	79.7	0.971830985915493	69	12	97.2	1	211	5	121	187	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	207	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae 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);;