metadata: contig_metadata: 24 rows where bioproject = "PRJNA886442" and tax

24 rows where bioproject = "PRJNA886442" 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
862070	862070	PRJNA886442_P_NODE_9181_length_266_cov_1.616580_g9017_i0	PRJNA886442	9181	266	1.61658	4.3001028	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	377	3.53e-100	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g9017	i0	94.332	110.582706766917	247	12	92	2	11	255	1154990	1155236	Planctomyces sp. SH-PL62, complete genome	blastn	29415	377	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
2137417	2137417	PRJNA886442_P_NODE_6302_length_310_cov_2.075949_g6138_i0	PRJNA886442	6302	310	2.075949	6.4354419	Pedosphaera parvula	1032527	Bacteria	Bacteria	296	1.21e-75	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g6138	i0	87.795	136.912903225806	254	29	82	2	1	253	1806	1554	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	42443	296	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
3793439	3793439	PRJNA886442_P_NODE_9823_length_258_cov_1.264865_g9659_i0	PRJNA886442	9823	258	1.264865	3.2633517	Opitutaceae	134623	Bacteria	Bacteria	211	3.66e-50	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g9659	i0	81.928	55.7984496124031	249	45	97	0	1	249	6443875	6444123	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	14396	213	0.990610328638498	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
4690388	4690388	PRJNA886442_P_NODE_6524_length_307_cov_1.000000_g6360_i0	PRJNA886442	6524	307	1	3.07	Chthoniobacter flavus	191863	Bacteria	Bacteria	429	1.13e-115	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g6360	i0	93.151	143.543973941368	292	20	95	0	7	298	983	692	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	44068	429	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
10170047	10170047	PRJNA886442_P_NODE_3448_length_390_cov_1.230284_g3284_i0	PRJNA886442	3448	390	1.230284	4.7981076	Luteolibacter	518753	Bacteria	Bacteria	676	0	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g3284	i0	97.949	284.34358974359	390	8	100	0	1	390	3805749	3805360	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	110894	676	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
11065433	11065433	PRJNA886442_P_NODE_14589_length_243_cov_0.917647_g14425_i0	PRJNA886442	14589	243	0.917647	2.22988221	Planctomycetota bacterium	2026780	Bacteria	Bacteria	147	2.86e-40	NR	RIK83591.1	2026780	g14425	i0	86.3	3.95061728395062	80	10	98.8	1	2	241	223	301	RIK83591.1 MAG: gfo/Idh/MocA family oxidoreductase, partial [Planctomycetota bacterium]	diamond	960	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
11065507	11065507	PRJNA886442_P_NODE_6669_length_304_cov_1.012987_g6505_i0	PRJNA886442	6669	304	1.012987	3.07948048	Chthoniobacter flavus	191863	Bacteria	Bacteria	449	8.599999999999998e-122	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g6505	i0	93.96	225.585526315789	298	16	97	1	4	299	715	418	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	68578	449	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
13615550	13615550	PRJNA886442_P_NODE_4251_length_360_cov_1.170732_g4087_i0	PRJNA886442	4251	360	1.170732	4.2146352	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	346	1.4e-90	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g4087	i0	85.088	75.1694444444445	342	48	94	3	21	360	1315912	1316252	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	27061	346	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15269408	15269408	PRJNA886442_P_NODE_4792_length_344_cov_1.726937_g4628_i0	PRJNA886442	4792	344	1.726937	5.94066328	Verrucomicrobiota	74201	Bacteria	Bacteria	424	5.9899999999999996e-114	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g4628	i0	90.154	148.5	325	32	94	0	6	330	914735	915059	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	51084	427	0.992974238875878	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
17818956	17818956	PRJNA886442_P_NODE_10914_length_252_cov_0.871508_g10750_i0	PRJNA886442	10914	252	0.871508	2.19620016	Planctomycetia	203683	Bacteria	Bacteria	305	1.59e-78	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g10750	i0	91.818	193.384920634921	220	16	87	2	34	252	2623267	2623049	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	48733	305	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
17819019	17819019	PRJNA886442_P_NODE_4174_length_362_cov_2.930796_g4010_i0	PRJNA886442	4174	362	2.930796	10.60948152	Planctomycetia	203683	Bacteria	Bacteria	603	7.559999999999999e-168	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g4010	i0	96.694	309.229281767956	363	10	100	2	1	362	122641	122280	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	111941	603	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
18713348	18713348	PRJNA886442_P_NODE_5675_length_323_cov_1.248000_g5511_i0	PRJNA886442	5675	323	1.248	4.03104	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	414	3.36e-111	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g5511	i0	93.238	125.074303405573	281	19	87	0	43	323	7052359	7052639	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	40399	414	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
19988586	19988586	PRJNA886442_P_NODE_616_length_881_cov_3.146040_g466_i0	PRJNA886442	616	881	3.14604	27.7166124	Luteolibacter luteus	2728835	Bacteria	Bacteria	1343	0	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g466	i0	94.131	291.05788876277	886	47	100	3	1	881	3804241	3805126	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	256422	1343	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
21263869	21263869	PRJNA886442_P_NODE_1617_length_545_cov_1.889831_g1454_i0	PRJNA886442	1617	545	1.889831	10.29957895	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	784	0	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g1454	i0	92.687	120.133944954128	547	35	100	5	1	545	1155190	1155733	Planctomyces sp. SH-PL62, complete genome	blastn	65473	784	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
21263958	21263958	PRJNA886442_P_NODE_8157_length_280_cov_1.507246_g7993_i0	PRJNA886442	8157	280	1.507246	4.2202888	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	302	2.32e-77	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g7993	i0	88.235	185.45	255	26	90	4	1	251	26916	27170	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	51926	302	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
21263959	21263959	PRJNA886442_P_NODE_8177_length_280_cov_1.275362_g8013_i0	PRJNA886442	8177	280	1.275362	3.5710136	Candidatus Methylacidiphilales bacterium	2720631	Bacteria	Bacteria	181	4.209999999999999e-55	NR	HEY8965962.1	2720631	g8013	i0	91.4	0.996428571428571	93	8	99.6	0	280	2	38	130	HEY8965962.1 MBL fold metallo-hydrolase [Candidatus Methylacidiphilales bacterium]	diamond	279	181	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales			Candidatus Methylacidiphilales bacterium
22538698	22538698	PRJNA886442_P_NODE_2618_length_435_cov_1.370166_g2454_i0	PRJNA886442	2618	435	1.370166	5.9602221	Luteolibacter luteus	2728835	Bacteria	Bacteria	726	0	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g2454	i0	96.782	263.889655172414	435	14	100	0	1	435	3803957	3803523	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	114792	726	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
22538787	22538787	PRJNA886442_P_NODE_9338_length_264_cov_1.476440_g9174_i0	PRJNA886442	9338	264	1.47644	3.8978016	Chthoniobacter flavus	191863	Bacteria	Bacteria	411	3.4499999999999996e-110	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g9174	i0	94.737	31.4090909090909	266	10	100	4	1	264	1123	1386	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	8292	411	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
24192988	24192988	PRJNA886442_P_NODE_2479_length_445_cov_1.376344_g2315_i0	PRJNA886442	2479	445	1.376344	6.1247308	Chthoniobacter	295577	Bacteria	Bacteria	778	0	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g2315	i0	98.206	242.011235955056	446	6	100	2	1	445	17999	17555	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	107695	784	0.99234693877551	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
28003241	28003241	PRJNA886442_P_NODE_3585_length_385_cov_1.000000_g3421_i0	PRJNA886442	3585	385	1	3.85	Tautonia sociabilis	2080755	Bacteria	Bacteria	121	4.89e-31	NR	WP_126726219.1	2080755	g3421	i0	65.2	0.716883116883117	92	32	71.7	0	385	110	180	271	WP_126726219.1 class I SAM-dependent methyltransferase [Tautonia sociabilis]	diamond	276	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia sociabilis
30750649	30750649	PRJNA886442_P_NODE_2354_length_455_cov_1.225131_g2190_i0	PRJNA886442	2354	455	1.225131	5.57434605	Gemmataceae bacterium	2052164	Bacteria	Bacteria	120	1.63e-29	NR	HJZ92462.1	2052164	g2190	i0	45.7	1.99120879120879	151	66	99.6	5	1	453	105	239	HJZ92462.1 aldose epimerase family protein [Gemmataceae bacterium]	diamond	906	120	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
30971869	30971869	PRJNA886442_P_NODE_8794_length_272_cov_0.969849_g8630_i0	PRJNA886442	8794	272	0.969849	2.63798928	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	71.6	3.29e-12	NR	MBT8036538.1	2499141	g8630	i0	40.3	0.794117647058823	72	43	79.4	0	57	272	1	72	MBT8036538.1 CDP-glycerol glycerophosphotransferase family protein [Verrucomicrobiia bacterium]	diamond	216	71.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31509346	31509346	PRJNA886442_P_NODE_14096_length_244_cov_0.912281_g13932_i0	PRJNA886442	14096	244	0.912281	2.22596564	Candidatus Methylacidiphilales bacterium	2720631	Bacteria	Bacteria	154	8.929999999999999e-45	NR	HEY8966496.1	2720631	g13932	i0	96.2	1.95491803278689	79	3	97.1	0	242	6	61	139	HEY8966496.1 signal peptide peptidase SppA [Candidatus Methylacidiphilales bacterium]	diamond	477	154	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales			Candidatus Methylacidiphilales bacterium
32836558	32836558	PRJNA886442_P_NODE_7800_length_285_cov_1.839623_g7636_i0	PRJNA886442	7800	285	1.839623	5.24292555	Planctomycetia bacterium	2052181	Bacteria	Bacteria	82	4.49e-16	NR	NBO92887.1	2052181	g7636	i0	49.5	1.94736842105263	95	47	98.9	1	2	283	182	276	NBO92887.1 zinc-binding dehydrogenase [Planctomycetia bacterium]	diamond	555	82	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia 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);;