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

31 rows where bioproject = "PRJNA851399" 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
4667596	4667596	PRJNA851399_P_NODE_14464_length_198_cov_1.369128_g14011_i0	PRJNA851399	14464	198	1.369128	2.71087344	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	259	9.42e-65	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g14011	i0	94.611	282.323232323232	167	9	84	0	1	167	17720	17554	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	55900	259	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
9767226	9767226	PRJNA851399_P_NODE_16148_length_188_cov_2.287770_g15695_i0	PRJNA851399	16148	188	2.28777	4.3010076	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	281	1.89e-71	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g15695	i0	93.617	130.218085106383	188	12	100	0	1	188	28335	28148	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	24481	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
11042882	11042882	PRJNA851399_P_NODE_17689_length_184_cov_1.125926_g17236_i0	PRJNA851399	17689	184	1.125926	2.07170384	Urbifossiella limnaea	2528023	Bacteria	Bacteria	121	4.24e-23	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g17236	i0	79.444	7.58695652173913	180	29	96	7	1	176	3839205	3839380	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	1396	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
11437878	11437878	PRJNA851399_P_NODE_9409_length_262_cov_1.098592_g8956_i0	PRJNA851399	9409	262	1.098592	2.87831104	Gemmata	113	Bacteria	Bacteria	364	2.7e-96	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g8956	i0	91.698	145.87786259542	265	19	100	2	1	262	559795	560059	Gemmata sp. SH-PL17, complete genome	blastn	38220	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
12713558	12713558	PRJNA851399_P_NODE_31970_length_164_cov_1.773913_g31517_i0	PRJNA851399	31970	164	1.773913	2.90921732	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	91.7	7.43e-20	NR	HVP10452.1	2026778	g31517	i0	83.3	1.97560975609756	54	9	98.8	0	162	1	361	414	HVP10452.1 Hsp70 family protein [Phycisphaerae bacterium]	diamond	324	91.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
14867349	14867349	PRJNA851399_P_NODE_28692_length_166_cov_0.871795_g28239_i0	PRJNA851399	28692	166	0.871795	1.4471797	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	171	3.68e-38	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g28239	i0	85.89	2.6144578313253	163	20	98	3	5	166	1317177	1317017	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	434	171	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15261917	15261917	PRJNA851399_P_NODE_22992_length_171_cov_1.254098_g22539_i0	PRJNA851399	22992	171	1.254098	2.14450758	Schlesneria	656899	Bacteria	Bacteria	187	3.76e-43	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g22539	i0	86.364	18.0116959064327	176	18	100	4	1	171	1264	1090	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	3080	187	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
16536421	16536421	PRJNA851399_P_NODE_12593_length_215_cov_0.921687_g12140_i0	PRJNA851399	12593	215	0.921687	1.98162705	Chthoniobacter	295577	Bacteria	Bacteria	303	4.74e-78	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g12140	i0	92.857	237.251162790698	210	14	98	1	1	210	16357	16565	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	51009	303	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
18690607	18690607	PRJNA851399_P_NODE_24055_length_169_cov_1.125000_g23602_i0	PRJNA851399	24055	169	1.125	1.90125	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	252	1.3e-62	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g23602	i0	93.491	112.011834319527	169	11	100	0	1	169	4421391	4421559	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	18930	252	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
21241535	21241535	PRJNA851399_P_NODE_36017_length_163_cov_0.894737_g35564_i0	PRJNA851399	36017	163	0.894737	1.45842131	Lacipirellula parvula	2650471	Bacteria	Bacteria	241	2.7000000000000008e-59	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g35564	i0	93.252	1	163	11	100	0	1	163	3416837	3416999	Lacipirellula parvula PX69 DNA, complete genome	blastn	163	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
23791479	23791479	PRJNA851399_P_NODE_21359_length_174_cov_1.648000_g20906_i0	PRJNA851399	21359	174	1.648	2.86752	Urbifossiella limnaea	2528023	Bacteria	Bacteria	244	2.25e-60	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g20906	i0	91.954	161.540229885057	174	14	100	0	1	174	2018239	2018412	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	28108	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
24185661	24185661	PRJNA851399_P_NODE_879_length_1198_cov_2.429939_g719_i0	PRJNA851399	879	1198	2.429939	29.11066922	Verrucomicrobiota	74201	Bacteria	Bacteria	1057	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g719	i0	88.623	131.860601001669	879	87	88	11	44	915	1452	580	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	157969	1057	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
25460491	25460491	PRJNA851399_P_NODE_12580_length_215_cov_1.228916_g12127_i0	PRJNA851399	12580	215	1.228916	2.6421694	Schlesneria	656899	Bacteria	Bacteria	359	9.969999999999999e-95	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g12127	i0	96.744	122.423255813953	215	7	100	0	1	215	2177	2391	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	26321	359	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
26833562	26833562	PRJNA851399_P_NODE_35221_length_163_cov_0.894737_g34768_i0	PRJNA851399	35221	163	0.894737	1.45842131	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	57	1.18e-7	NR	MBS0631760.1	2026799	g34768	i0	52.8	0.975460122699387	53	25	97.5	0	159	1	718	770	MBS0631760.1 M48 family metalloprotease [Verrucomicrobiota bacterium]	diamond	159	57	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27086670	27086670	PRJNA851399_P_NODE_17462_length_184_cov_1.511111_g17009_i0	PRJNA851399	17462	184	1.511111	2.78044424	Lacunisphaera sp.	1961806	Bacteria	Bacteria	117	5.22e-29	NR	MDI1334970.1	1961806	g17009	i0	93.3	0.978260869565217	60	4	97.8	0	182	3	408	467	MDI1334970.1 penicillin-binding protein 2 [Lacunisphaera sp.]	diamond	180	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
28002762	28002762	PRJNA851399_P_NODE_41365_length_161_cov_0.910714_g40912_i0	PRJNA851399	41365	161	0.910714	1.46624954	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	42	0.0229	NR	MDB6024811.1	2026801	g40912	i0	43.4	1.86335403726708	53	23	98.8	1	2	160	7	52	MDB6024811.1 Binding-protein-dependent transport system inner rane component [Verrucomicrobiales bacterium]	diamond	300	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28128977	28128977	PRJNA851399_P_NODE_35045_length_163_cov_0.894737_g34592_i0	PRJNA851399	35045	163	0.894737	1.45842131	Planctomycetia bacterium	2052181	Bacteria	Bacteria	98.2	5.069999999999999e-23	NR	MCI0700753.1	2052181	g34592	i0	82.7	2.88957055214724	52	9	95.7	0	162	7	25	76	MCI0700753.1 alpha/beta hydrolase [Planctomycetia bacterium]	diamond	471	98.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
28286494	28286494	PRJNA851399_P_NODE_18586_length_181_cov_1.545455_g18133_i0	PRJNA851399	18586	181	1.545455	2.79727355	Terrimicrobiaceae bacterium	2832348	Bacteria	Bacteria	88.2	1.38e-19	NR	HEY5704678.1	2832348	g18133	i0	86.4	0.729281767955801	44	6	72.9	0	178	47	190	233	HEY5704678.1 C4-type zinc ribbon domain-containing protein [Terrimicrobiaceae bacterium]	diamond	132	88.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae		Terrimicrobiaceae bacterium
29265315	29265315	PRJNA851399_P_NODE_30049_length_165_cov_0.879310_g29596_i0	PRJNA851399	30049	165	0.87931	1.4508615	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.00499	NR	MEM6755981.1	2026780	g29596	i0	60	0.636363636363636	35	14	63.6	0	59	163	20	54	MEM6755981.1 site-specific integrase [Planctomycetota bacterium]	diamond	105	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29580939	29580939	PRJNA851399_P_NODE_13890_length_202_cov_2.973856_g13437_i0	PRJNA851399	13890	202	2.973856	6.00718912	Singulisphaera sp.	1906241	Bacteria	Bacteria	42.7	0.0213	NR	MEJ7638550.1	1906241	g13437	i0	38.6	0.846534653465347	57	28	77.2	2	24	179	393	447	MEJ7638550.1 sodium:solute symporter family protein [Singulisphaera sp.]	diamond	171	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp.
29842080	29842080	PRJNA851399_P_NODE_28111_length_166_cov_0.871795_g27658_i0	PRJNA851399	28111	166	0.871795	1.4471797	Bacteria	2	Bacteria	Bacteria	70.1	1.38e-12	NR	HPD28582.1	2026778	g27658	i0	70.5	5.6566265060241	44	13	79.5	0	164	33	227	270	HPD28582.1 hypothetical protein [Phycisphaerae bacterium]	diamond	939	70.5	0.994326241134752	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29842081	29842081	PRJNA851399_P_NODE_41811_length_159_cov_2.736364_g41358_i0	PRJNA851399	41811	159	2.736364	4.35081876	Lacipirellulaceae	2691359	Bacteria	Bacteria	102	2.5299999999999998e-24	NR	WP_145061785.1	1930276	g41358	i0	92.3	5.88679245283019	52	4	98.1	0	158	3	194	245	WP_145061785.1 cupin-like domain-containing protein [Adhaeretor mobilis]	diamond	936	103	0.990291262135922	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Adhaeretor	Adhaeretor mobilis
30276471	30276471	PRJNA851399_P_NODE_10792_length_237_cov_0.744681_g10339_i0	PRJNA851399	10792	237	0.744681	1.76489397	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.5	0.0177	NR	PYI75966.1	2026799	g10339	i0	38.8	0.848101265822785	67	35	77.2	2	41	223	102	168	PYI75966.1 MAG: acyl-CoA dehydrogenase [Verrucomicrobiota bacterium]	diamond	201	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30339873	30339873	PRJNA851399_P_NODE_38792_length_162_cov_0.902655_g38339_i0	PRJNA851399	38792	162	0.902655	1.4623011	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	62	1.93e-9	NR	HXM29525.1	2201154	g38339	i0	51.9	0.962962962962963	52	25	96.3	0	161	6	169	220	HXM29525.1 Na/Pi cotransporter family protein [Chthoniobacterales bacterium]	diamond	156	62	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30466021	30466021	PRJNA851399_P_NODE_30313_length_165_cov_0.879310_g29860_i0	PRJNA851399	30313	165	0.87931	1.4508615	Prosthecobacter sp.	1965333	Bacteria	Bacteria	108	8.37e-26	NR	WP_300199569.1	1965333	g29860	i0	100	1.96363636363636	54	0	98.2	0	164	3	455	508	WP_300199569.1 excinuclease ABC subunit UvrA [Prosthecobacter sp.]	diamond	324	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
30686770	30686770	PRJNA851399_P_NODE_37413_length_162_cov_0.902655_g36960_i0	PRJNA851399	37413	162	0.902655	1.4623011	Gemmataceae bacterium	2052164	Bacteria	Bacteria	43.9	0.00479	NR	MCX7699587.1	2052164	g36960	i0	39.2	0.944444444444444	51	31	94.4	0	154	2	363	413	MCX7699587.1 glycoside hydrolase family 5 protein [Gemmataceae bacterium]	diamond	153	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31761719	31761719	PRJNA851399_P_NODE_31357_length_165_cov_0.879310_g30904_i0	PRJNA851399	31357	165	0.87931	1.4508615	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	84.3	1.38e-17	NR	HEX7569162.1	2499141	g30904	i0	82.6	1.67272727272727	46	8	83.6	0	165	28	294	339	HEX7569162.1 PIN domain-containing protein [Verrucomicrobiia bacterium]	diamond	276	84.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32014833	32014833	PRJNA851399_P_NODE_18338_length_182_cov_1.360902_g17885_i0	PRJNA851399	18338	182	1.360902	2.47684164	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	90.5	1.64e-19	NR	RFC48550.1	2026799	g17885	i0	74.6	1.96153846153846	59	15	97.3	0	2	178	289	347	RFC48550.1 MAG: MFS family permease [Verrucomicrobiota bacterium]	diamond	357	90.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32181420	32181420	PRJNA851399_P_NODE_30278_length_165_cov_0.879310_g29825_i0	PRJNA851399	30278	165	0.87931	1.4508615	Bacteria	2	Bacteria	Bacteria	93.6	1.11e-20	NR	MES2465762.1	2026799	g29825	i0	75.5	1.90909090909091	53	13	96.4	0	5	163	384	436	MES2465762.1 UDP-N-acetylmuramoyl-L-alanine--D-glutamate ligase [Verrucomicrobiota bacterium]	diamond	315	93.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32204732	32204732	PRJNA851399_P_NODE_19738_length_178_cov_1.581395_g19285_i0	PRJNA851399	19738	178	1.581395	2.8148831	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	105	8.61e-25	NR	MDR3455851.1	2499141	g19285	i0	86.4	1.98876404494382	59	8	99.4	0	177	1	222	280	MDR3455851.1 WecB/TagA/CpsF family glycosyltransferase [Verrucomicrobiia bacterium]	diamond	354	105	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32867592	32867592	PRJNA851399_P_NODE_10840_length_236_cov_1.080214_g10387_i0	PRJNA851399	10840	236	1.080214	2.54930504	Opitutaceae bacterium TAV1	278956	Bacteria	Bacteria	48.1	3.6e-4	NR	EIQ00196.1	278956	g10387	i0	83.3	0.635593220338983	24	4	30.5	0	73	2	3	26	EIQ00196.1 site-specific DNA methylase [Opitutaceae bacterium TAV1]	diamond	150	48.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV1

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);;