metadata: contig_metadata: 23 rows where bioproject = "PRJNA758770" and tax

23 rows where bioproject = "PRJNA758770" 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
2016824	2016824	PRJNA758770_S_NODE_33142_length_235_cov_2.098765_g33016_i0	PRJNA758770	33142	235	2.098765	4.93209775	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	363	8.569999999999998e-96	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g33016	i0	94.515	75.1829787234043	237	10	100	2	1	235	4317791	4318026	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	17668	363	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
5844247	5844247	PRJNA758770_S_NODE_28265_length_247_cov_0.896552_g28139_i0	PRJNA758770	28265	247	0.896552	2.21448344	Gemmata sp.	1914242	Bacteria	Bacteria	174	9.21e-51	NR	HEV3385726.1	1914242	g28139	i0	95.1	7.96761133603239	82	4	99.6	0	246	1	176	257	HEV3385726.1 nickel-dependent lactate racemase [Gemmata sp.]	diamond	1968	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp.
10944762	10944762	PRJNA758770_S_NODE_25969_length_250_cov_0.881356_g25843_i0	PRJNA758770	25969	250	0.881356	2.20339	Gemmataceae bacterium	2052164	Bacteria	Bacteria	85.5	1.57e-17	NR	MFO0842532.1	2052164	g25843	i0	97.8	0.54	45	1	54	0	248	114	296	340	MFO0842532.1 AAA family ATPase [Gemmataceae bacterium]	diamond	135	85.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
26609675	26609675	PRJNA758770_S_NODE_26561_length_249_cov_0.886364_g26435_i0	PRJNA758770	26561	249	0.886364	2.20704636	Prosthecobacter debontii	48467	Bacteria	Bacteria	157	1.5299999999999998e-42	NR	WP_217699031.1	48467	g26435	i0	100	1	83	0	100	0	1	249	560	642	WP_217699031.1 beta strand repeat-containing protein [Prosthecobacter debontii]	diamond	249	157	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
26863578	26863578	PRJNA758770_S_NODE_24181_length_252_cov_0.871508_g24055_i0	PRJNA758770	24181	252	0.871508	2.19620016	Prosthecobacter sp.	1965333	Bacteria	Bacteria	173	6.559999999999999e-48	NR	WP_395719944.1	1965333	g24055	i0	97.6	2	84	2	100	0	1	252	3173	3256	WP_395719944.1 putative Ig domain-containing protein, partial [Prosthecobacter sp.]	diamond	504	173	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
26863579	26863579	PRJNA758770_S_NODE_25341_length_251_cov_0.876404_g25215_i0	PRJNA758770	25341	251	0.876404	2.19977404	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	115	1.09e-27	NR	MBL9158133.1	2026801	g25215	i0	100	0.848605577689243	71	0	84.9	0	39	251	972	1042	MBL9158133.1 autotransporter-associated beta strand repeat-containing protein [Verrucomicrobiales bacterium]	diamond	213	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
26989591	26989591	PRJNA758770_S_NODE_30042_length_245_cov_0.906977_g29916_i0	PRJNA758770	30042	245	0.906977	2.22209365	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	131	1.71e-33	NR	HET6422534.1	2026779	g29916	i0	80	0.979591836734694	80	15	98	1	243	4	141	219	HET6422534.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	240	131	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27179327	27179327	PRJNA758770_S_NODE_31622_length_243_cov_0.917647_g31496_i0	PRJNA758770	31622	243	0.917647	2.22988221	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	47.8	6.61e-4	NR	MFO0826591.1	2052180	g31496	i0	51.2	1	43	21	53.1	0	243	115	594	636	MFO0826591.1 hypothetical protein [Phycisphaerales bacterium]	diamond	243	47.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27242698	27242698	PRJNA758770_S_NODE_24183_length_252_cov_0.871508_g24057_i0	PRJNA758770	24183	252	0.871508	2.19620016	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	169	1.38e-46	NR	MEZ6112510.1	2699754	g24057	i0	97.6	1.97619047619048	83	2	98.8	0	2	250	671	753	MEZ6112510.1 VWA domain-containing protein [Pirellulaceae bacterium]	diamond	498	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
27379111	27379111	PRJNA758770_S_NODE_32603_length_242_cov_0.923077_g32477_i0	PRJNA758770	32603	242	0.923077	2.23384634	Planctomycetota	203682	Bacteria	Bacteria	115	5.76e-28	NR	MCE2653567.1	2026779	g32477	i0	82.8	3.59504132231405	64	11	79.3	0	37	228	89	152	MCE2653567.1 metallophosphoesterase [Planctomycetaceae bacterium]	diamond	870	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27716905	27716905	PRJNA758770_S_NODE_26664_length_249_cov_0.886364_g26538_i0	PRJNA758770	26664	249	0.886364	2.20704636	Pirellulales bacterium	2715253	Bacteria	Bacteria	125	6.22e-33	NR	MBN2218107.1	2715253	g26538	i0	78	0.987951807228916	82	17	98.8	1	247	2	13	93	MBN2218107.1 RDD family protein [Pirellulales bacterium]	diamond	246	125	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27748298	27748298	PRJNA758770_S_NODE_31024_length_244_cov_0.912281_g30898_i0	PRJNA758770	31024	244	0.912281	2.22596564	Planctomycetota bacterium	2026780	Bacteria	Bacteria	76.3	5.76e-14	NR	HLF91923.1	2026780	g30898	i0	46.9	0.995901639344262	81	42	98.4	1	3	242	572	652	HLF91923.1 hypothetical protein [Planctomycetota bacterium]	diamond	243	76.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27937618	27937618	PRJNA758770_S_NODE_27885_length_248_cov_0.891429_g27759_i0	PRJNA758770	27885	248	0.891429	2.21074392	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	46.2	0.00181	NR	MBK7405132.1	2052180	g27759	i0	95.2	0.508064516129032	21	1	25.4	0	2	64	200	220	MBK7405132.1 MBL fold metallo-hydrolase [Phycisphaerales bacterium]	diamond	126	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28316456	28316456	PRJNA758770_S_NODE_28386_length_247_cov_0.896552_g28260_i0	PRJNA758770	28386	247	0.896552	2.21448344	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	158	1.32e-44	NR	HOC55733.1	2026799	g28260	i0	100	0.995951417004049	82	0	99.6	0	246	1	67	148	HOC55733.1 MFS transporter [Verrucomicrobiota bacterium]	diamond	246	158	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28347947	28347947	PRJNA758770_S_NODE_23526_length_253_cov_0.866667_g23400_i0	PRJNA758770	23526	253	0.866667	2.19266751	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	71.2	3.89e-12	NR	MDD4016636.1	2212473	g23400	i0	91.7	0.426877470355731	36	3	42.7	0	1	108	678	713	MDD4016636.1 right-handed parallel beta-helix repeat-containing protein [Kiritimatiellia bacterium]	diamond	108	71.2	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
28379530	28379530	PRJNA758770_S_NODE_25426_length_251_cov_0.876404_g25300_i0	PRJNA758770	25426	251	0.876404	2.19977404	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	70.5	7.07e-12	NR	NLX55886.1	2026779	g25300	i0	46.3	0.9800796812749	82	44	98	0	249	4	792	873	NLX55886.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	246	70.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29800280	29800280	PRJNA758770_S_NODE_26251_length_250_cov_0.881356_g26125_i0	PRJNA758770	26251	250	0.881356	2.20339	Planctomycetia bacterium	2052181	Bacteria	Bacteria	88.6	1.2e-18	NR	MCX7423111.1	2052181	g26125	i0	93.3	0.54	45	3	54	0	136	2	5	49	MCX7423111.1 Gfo/Idh/MocA family oxidoreductase [Planctomycetia bacterium]	diamond	135	88.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
29989950	29989950	PRJNA758770_S_NODE_25451_length_251_cov_0.876404_g25325_i0	PRJNA758770	25451	251	0.876404	2.19977404	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	182	4.36e-53	NR	HPU56588.1	2026799	g25325	i0	100	2.97609561752988	83	0	99.2	0	251	3	413	495	HPU56588.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	747	182	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30179354	30179354	PRJNA758770_S_NODE_28452_length_247_cov_0.896552_g28326_i0	PRJNA758770	28452	247	0.896552	2.21448344	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	72	1.51e-13	NR	MCA9098498.1	2026779	g28326	i0	94.1	0.412955465587045	34	2	41.3	0	142	243	1	34	MCA9098498.1 methylenetetrahydrofolate reductase [Planctomycetaceae bacterium]	diamond	102	72	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30779800	30779800	PRJNA758770_S_NODE_32774_length_242_cov_0.923077_g32648_i0	PRJNA758770	32774	242	0.923077	2.23384634	Opitutia bacterium	2026771	Bacteria	Bacteria	166	9.04e-48	NR	NCC93894.1	2026771	g32648	i0	100	1.98347107438017	80	0	99.2	0	240	1	310	389	NCC93894.1 hypothetical protein [Opitutia bacterium]	diamond	480	166	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
31126965	31126965	PRJNA758770_S_NODE_24255_length_252_cov_0.871508_g24129_i0	PRJNA758770	24255	252	0.871508	2.19620016	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	62.4	4.25e-9	NR	MCA9075291.1	2026779	g24129	i0	38.6	0.988095238095238	83	50	97.6	1	250	5	239	321	MCA9075291.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	249	62.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31801008	31801008	PRJNA758770_S_NODE_29957_length_245_cov_0.906977_g29831_i0	PRJNA758770	29957	245	0.906977	2.22209365	Planctomycetia	203683	Bacteria	Bacteria	124	1.03e-30	NR	MFM8253046.1	2026780	g29831	i0	67.9	11.8530612244898	81	26	99.2	0	244	2	273	353	MFM8253046.1 tetratricopeptide repeat protein [Planctomycetota bacterium]	diamond	2904	125	0.992	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32686369	32686369	PRJNA758770_S_NODE_25800_length_250_cov_0.881356_g25674_i0	PRJNA758770	25800	250	0.881356	2.20339	Pseudomonadati	3379134	Bacteria	Bacteria	113	3.0900000000000003e-27	NR	MBU4199398.1	2026799	g25674	i0	69.7	4.488	76	23	91.2	0	21	248	8	83	MBU4199398.1 integron integrase [Verrucomicrobiota bacterium]	diamond	1122	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;