metadata: contig_metadata: 24 rows where bioproject = "PRJNA934472", tax_clade = "PVC group" and tax

24 rows where bioproject = "PRJNA934472", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"

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
2186074	2186074	PRJNA934472_P_NODE_12762_length_399_cov_3.567485_g12385_i0	PRJNA934472	12762	399	3.567485	14.23426515	Fontisphaera persica	2974023	Bacteria	Bacteria	510	5.249999999999998e-140	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g12385	i0	89.75	134.784461152882	400	40	100	1	1	399	3863076	3863475	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	53779	510	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
2186205	2186205	PRJNA934472_P_NODE_18822_length_335_cov_1.038168_g18445_i0	PRJNA934472	18822	335	1.038168	3.4778628	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	536	7.149999999999998e-148	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g18445	i0	96.061	286.414925373134	330	12	98	1	1	329	2034	2363	Luteolibacter sp. SL250 chromosome	blastn	95949	536	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
6014006	6014006	PRJNA934472_P_NODE_15505_length_364_cov_10.415808_g15128_i0	PRJNA934472	15505	364	10.415808	37.91354112	Fontisphaera persica	2974023	Bacteria	Bacteria	490	6.18e-134	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g15128	i0	91.341	244.131868131868	358	31	98	0	7	364	3861791	3862148	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	88864	490	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
6014047	6014047	PRJNA934472_P_NODE_17885_length_342_cov_3.249071_g17508_i0	PRJNA934472	17885	342	3.249071	11.11182282	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	337	7.969999999999997e-88	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g17508	i0	84.814	69.8567251461988	349	38	99	13	2	342	1316534	1316193	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	23891	337	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
7289214	7289214	PRJNA934472_P_NODE_3186_length_751_cov_2.977876_g2904_i0	PRJNA934472	3186	751	2.977876	22.36384876	Pedosphaera parvula	1032527	Bacteria	Bacteria	1007	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g2904	i0	91.452	169.908122503329	737	57	98	6	18	751	588	1321	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	127601	1007	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
7633709	7633709	PRJNA934472_P_NODE_32086_length_263_cov_1.136842_g31708_i0	PRJNA934472	32086	263	1.136842	2.98989446	Akkermansia	239934	Bacteria	Bacteria	250	7.93e-62	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g31708	i0	93.976	211.254752851711	166	9	63	1	98	263	2749886	2750050	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	55560	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8564024	8564024	PRJNA934472_P_NODE_29247_length_274_cov_1.373134_g28869_i0	PRJNA934472	29247	274	1.373134	3.76238716	Methylacidimicrobium sp. B4	2796139	Bacteria	Bacteria	165	3.1e-36	NTclustered	gi\|1999103383\|gb\|CP066203.1\|	2796139	g28869	i0	78.292	57.1934306569343	281	43	100	15	1	274	2069324	2069593	Methylacidimicrobium sp. B4 chromosome, complete genome	blastn	15671	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Methylacidimicrobium	Methylacidimicrobium sp. B4
8564082	8564082	PRJNA934472_P_NODE_32087_length_263_cov_1.126316_g31709_i0	PRJNA934472	32087	263	1.126316	2.96221108	Fontisphaera persica	2974023	Bacteria	Bacteria	187	6.309999999999998e-43	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g31709	i0	90.714	56.1026615969582	140	13	53	0	124	263	3862212	3862073	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	14755	187	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
8564287	8564287	PRJNA934472_P_NODE_6787_length_536_cov_5.386609_g6471_i0	PRJNA934472	6787	536	5.386609	28.87222424	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	736	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g6471	i0	90.909	96.1138059701493	539	41	99	2	6	536	5152287	5152825	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	51517	736	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9838692	9838692	PRJNA934472_P_NODE_1208_length_1181_cov_3.866426_g1025_i0	PRJNA934472	1208	1181	3.866426	45.66249106	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	1611	0	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g1025	i0	91.293	192.424216765453	1183	100	100	3	1	1181	15917	17098	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	227253	1611	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
9838881	9838881	PRJNA934472_P_NODE_22828_length_307_cov_0.756410_g22450_i0	PRJNA934472	22828	307	0.75641	2.3221787	Luteolibacter luteus	2728835	Bacteria	Bacteria	507	5.09e-139	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g22450	i0	96.417	121.517915309446	307	11	100	0	1	307	3803525	3803831	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	37306	507	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
9839308	9839308	PRJNA934472_P_NODE_7508_length_512_cov_2.660592_g7190_i0	PRJNA934472	7508	512	2.660592	13.62223104	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	627	6.55e-175	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g7190	i0	88.738	122.61328125	515	54	100	4	1	512	3833565	3833052	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	62778	627	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10184221	10184221	PRJNA934472_P_NODE_29188_length_274_cov_1.950249_g28810_i0	PRJNA934472	29188	274	1.950249	5.34368226	root	1	Root_unresolved	Root_unresolved	501	2.08e-137	NTclustered	gi\|2967737\|gb\|AF050561.1\|	74207	g28810	i0	99.635	100.018248175182	274	1	100	0	1	274	85	358	Uncultured eubacterium WCHD3-88 16S ribosomal RNA gene, partial sequence	blastn	27405	501	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria				uncultured eubacterium WCHD3-88
12390460	12390460	PRJNA934472_P_NODE_5990_length_566_cov_6.068966_g5678_i0	PRJNA934472	5990	566	6.068966	34.35034756	Pedosphaera parvula	1032527	Bacteria	Bacteria	455	3.64e-123	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g5678	i0	81.456	67.065371024735	577	88	100	19	1	566	1121	1689	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	37959	455	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
13664601	13664601	PRJNA934472_P_NODE_28351_length_278_cov_1.346341_g27973_i0	PRJNA934472	28351	278	1.346341	3.74282798	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	243	1.41e-59	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g27973	i0	82.437	155.931654676259	279	48	100	1	1	278	5637751	5638029	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	43349	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
14009621	14009621	PRJNA934472_P_NODE_40351_length_212_cov_6.151079_g39973_i0	PRJNA934472	40351	212	6.151079	13.04028748	Verrucomicrobiota	74201	Bacteria	Bacteria	239	1.33e-58	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g39973	i0	87.204	150.882075471698	211	25	99	2	4	212	2848	2638	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	31987	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
16213789	16213789	PRJNA934472_P_NODE_16033_length_359_cov_3.506993_g15656_i0	PRJNA934472	16033	359	3.506993	12.59010487	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	470	7.919999999999999e-128	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g15656	i0	90.305	153.621169916435	361	31	100	4	1	359	15746	15388	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	55150	470	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
17489597	17489597	PRJNA934472_P_NODE_5874_length_571_cov_3.381526_g5562_i0	PRJNA934472	5874	571	3.381526	19.30851346	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	935	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g5562	i0	96.309	127.495621716287	569	21	99	0	3	571	5152585	5153153	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	72800	935	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18762585	18762585	PRJNA934472_P_NODE_23355_length_303_cov_1.778261_g22977_i0	PRJNA934472	23355	303	1.778261	5.38813083	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	291	5.49e-74	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g22977	i0	84.262	247.075907590759	305	41	99	5	1	299	26258	26561	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	74864	291	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
20037703	20037703	PRJNA934472_P_NODE_29196_length_274_cov_1.756219_g28818_i0	PRJNA934472	29196	274	1.756219	4.81204006	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	375	1.3099999999999998e-99	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g28818	i0	91.367	90.7445255474452	278	18	100	6	1	274	3832459	3832734	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	24864	375	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22588179	22588179	PRJNA934472_P_NODE_36398_length_247_cov_5.206897_g36020_i0	PRJNA934472	36398	247	5.206897	12.86103559	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	191	4.53e-44	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g36020	i0	80.738	31.0890688259109	244	47	99	0	4	247	5638004	5637761	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	7679	191	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
27593825	27593825	PRJNA934472_P_NODE_35624_length_250_cov_0.870056_g35246_i0	PRJNA934472	35624	250	0.870056	2.17514	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	110	4.54e-26	NR	MCB1207841.1	2026801	g35246	i0	61.4	0.996	83	31	99.6	1	2	250	1198	1279	MCB1207841.1 DUF11 domain-containing protein [Verrucomicrobiales bacterium]	diamond	249	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30751762	30751762	PRJNA934472_P_NODE_37814_length_244_cov_0.900585_g37436_i0	PRJNA934472	37814	244	0.900585	2.1974274	Opitutaceae bacterium EW11	2161865	Bacteria	Bacteria	45.1	0.00564	NR	PTY06334.1	2161865	g37436	i0	47.9	0.590163934426229	48	25	59	0	228	85	39	86	PTY06334.1 hypothetical protein DB347_12955 [Opitutaceae bacterium EW11]	diamond	144	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium EW11
32238213	32238213	PRJNA934472_P_NODE_38198_length_243_cov_0.905882_g37820_i0	PRJNA934472	38198	243	0.905882	2.20129326	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	111	1.53e-26	NR	HUR40143.1	2499141	g37820	i0	68.8	0.987654320987654	80	25	98.8	0	3	242	105	184	HUR40143.1 polyphosphate:AMP phosphotransferase [Verrucomicrobiia bacterium]	diamond	240	111	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia 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);;