metadata: contig_metadata: 25 rows where bioproject = "PRJNA1000943", tax_clade = "PVC group" and tax

25 rows where bioproject = "PRJNA1000943", 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
2695312	2695312	PRJNA1000943_P_NODE_143_length_1549_cov_2.367209_g116_i0	PRJNA1000943	143	1549	2.367209	36.66806741	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	2540	0	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g116	i0	96.26	103.848934796643	1551	54	100	4	1	1549	737142	735594	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	160862	2540	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
3971486	3971486	PRJNA1000943_P_NODE_7264_length_304_cov_1.350649_g7126_i0	PRJNA1000943	7264	304	1.350649	4.10597296	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	289	1.9799999999999996e-73	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g7126	i0	89.823	443.861842105263	226	22	74	1	35	259	2749638	2749863	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	134934	289	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9072538	9072538	PRJNA1000943_P_NODE_12088_length_250_cov_1.418079_g11950_i0	PRJNA1000943	12088	250	1.418079	3.5451975	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	281	2.65e-71	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g11950	i0	91.346	70.06	208	15	83	3	1	207	1315122	1314917	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	17515	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9072592	9072592	PRJNA1000943_P_NODE_1568_length_608_cov_3.871028_g1433_i0	PRJNA1000943	1568	608	3.871028	23.53585024	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	193	2.1999999999999993e-53	NR	PYL68015.1	2026799	g1433	i0	49	3.04440789473684	204	90	93.8	5	17	586	316	519	PYL68015.1 MAG: hypothetical protein DMF20_01945 [Verrucomicrobiota bacterium]	diamond	1851	193	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
13752695	13752695	PRJNA1000943_P_NODE_131_length_1603_cov_6.793464_g106_i0	PRJNA1000943	131	1603	6.793464	108.89922792	Chthoniobacter sp.	2510640	Bacteria	Bacteria	845	1.23e-305	NR	MDR3405335.1	2510640	g106	i0	88.6	0.868371802869619	464	53	86.8	0	45	1436	1	464	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	1392	845	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
14173816	14173816	PRJNA1000943_P_NODE_7292_length_304_cov_0.874459_g7154_i0	PRJNA1000943	7292	304	0.874459	2.65835536	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	374	5.319999999999998e-99	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g7154	i0	89.333	76.6842105263158	300	29	98	3	1	298	1315203	1315501	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	23312	374	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15447914	15447914	PRJNA1000943_P_NODE_7973_length_292_cov_1.552511_g7835_i0	PRJNA1000943	7973	292	1.552511	4.53333212	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	359	1.42e-94	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g7835	i0	89.68	200.332191780822	281	29	96	0	12	292	3894740	3894460	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	58497	359	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
17996823	17996823	PRJNA1000943_P_NODE_15115_length_243_cov_0.917647_g14977_i0	PRJNA1000943	15115	243	0.917647	2.22988221	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	165	2.6999999999999997e-36	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g14977	i0	79.184	26.1646090534979	245	45	99	6	1	242	6569312	6569071	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	6358	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
17996834	17996834	PRJNA1000943_P_NODE_15735_length_237_cov_2.817073_g15597_i0	PRJNA1000943	15735	237	2.817073	6.67646301	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	366	6.69e-97	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g15597	i0	94.561	154.725738396624	239	9	100	4	1	237	737308	737544	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	36670	366	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20546322	20546322	PRJNA1000943_P_NODE_4817_length_362_cov_1.079585_g4680_i0	PRJNA1000943	4817	362	1.079585	3.9080977	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	89.7	4.99e-18	NR	HZS17562.1	2665650	g4680	i0	44.2	1.98895027624309	120	50	99.4	3	2	361	491	593	HZS17562.1 thioredoxin domain-containing protein [Candidatus Udaeobacter sp.]	diamond	720	89.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
25225387	25225387	PRJNA1000943_P_NODE_9620_length_269_cov_1.260204_g9482_i0	PRJNA1000943	9620	269	1.260204	3.38994876	Pseudomonadati	3379134	Bacteria	Bacteria	359	1.3e-94	NTclustered	gi\|2874254040\|emb\|OY970364.1\|	412056	g9482	i0	90.741	118.234200743494	270	24	100	1	1	269	2168321	2168590	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1	blastn	31805	359	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
27382145	27382145	PRJNA1000943_P_NODE_11083_length_253_cov_0.866667_g10945_i0	PRJNA1000943	11083	253	0.866667	2.19266751	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	55.5	1.45e-6	NR	MEI7935671.1	2026799	g10945	i0	57.1	1.99209486166008	42	18	49.8	0	207	82	228	269	MEI7935671.1 DUF6531 domain-containing protein [Verrucomicrobiota bacterium]	diamond	504	55.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27382157	27382157	PRJNA1000943_P_NODE_7503_length_300_cov_1.374449_g7365_i0	PRJNA1000943	7503	300	1.374449	4.123347	Puniceicoccaceae bacterium	2026784	Bacteria	Bacteria	64.7	7.09e-10	NR	MEQ9823762.1	2026784	g7365	i0	63.6	1.79	44	16	44	0	25	156	58	101	MEQ9823762.1 putative 4-mercaptohistidine N1-methyltransferase [Puniceicoccaceae bacterium]	diamond	537	64.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Puniceicoccaceae		Puniceicoccaceae bacterium
27413893	27413893	PRJNA1000943_P_NODE_9343_length_272_cov_1.819095_g9205_i0	PRJNA1000943	9343	272	1.819095	4.9479384	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	47.4	7.89e-4	NR	MBL9172466.1	2026801	g9205	i0	48.9	0.518382352941177	47	22	51.8	1	2	142	154	198	MBL9172466.1 DUF3506 domain-containing protein [Verrucomicrobiales bacterium]	diamond	141	47.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28739755	28739755	PRJNA1000943_P_NODE_3087_length_439_cov_12.612022_g2950_i0	PRJNA1000943	3087	439	12.612022	55.36677658	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	107	7.980000000000001e-27	NR	MEM9444818.1	2026799	g2950	i0	41.9	2.79498861047836	136	69	92.9	4	11	418	7	132	MEM9444818.1 globin family protein [Verrucomicrobiota bacterium]	diamond	1227	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29055620	29055620	PRJNA1000943_P_NODE_8628_length_282_cov_1.492823_g8490_i0	PRJNA1000943	8628	282	1.492823	4.20976086	Cerasicoccus fimbriatus	3014554	Bacteria	Bacteria	45.8	0.00467	NR	WP_269542665.1	3014554	g8490	i0	37.7	0.819148936170213	77	48	81.9	0	282	52	270	346	WP_269542665.1 polyprenyl synthetase family protein [Cerasicoccus fimbriatus]	diamond	231	45.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Cerasicoccus	Cerasicoccus fimbriatus
29434041	29434041	PRJNA1000943_P_NODE_230_length_1331_cov_4.159777_g183_i0	PRJNA1000943	230	1331	4.159777	55.36663187	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	89	2.96e-16	NR	MEO5753320.1	2201154	g183	i0	30.3	0.439519158527423	195	108	40.3	6	1290	754	34	216	MEO5753320.1 CAP domain-containing protein [Chthoniobacterales bacterium]	diamond	585	89	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29623304	29623304	PRJNA1000943_P_NODE_12670_length_249_cov_0.886364_g12532_i0	PRJNA1000943	12670	249	0.886364	2.20704636	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	45.1	0.00589	NR	WP_133793902.1	48464	g12532	i0	40.3	2.56626506024096	67	36	79.5	2	248	51	360	423	WP_133793902.1 MFS transporter [Prosthecobacter fusiformis]	diamond	639	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
29939773	29939773	PRJNA1000943_P_NODE_9111_length_276_cov_1.177340_g8973_i0	PRJNA1000943	9111	276	1.17734	3.2494584	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	132	2.26e-35	NR	RYD65414.1	2026800	g8973	i0	73.9	1	92	23	98.9	1	275	3	196	287	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	276	132	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30666219	30666219	PRJNA1000943_P_NODE_7813_length_295_cov_1.382883_g7675_i0	PRJNA1000943	7813	295	1.382883	4.07950485	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	107	1.32e-24	NR	MBV8899192.1	2026799	g7675	i0	54.1	0.996610169491525	98	41	99.7	1	295	2	308	401	MBV8899192.1 thioredoxin domain-containing protein [Verrucomicrobiota bacterium]	diamond	294	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31266723	31266723	PRJNA1000943_P_NODE_8095_length_290_cov_1.723502_g7957_i0	PRJNA1000943	8095	290	1.723502	4.9981558	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	79.7	6.52e-15	NR	HMJ05698.1	2201154	g7957	i0	48	6.13448275862069	98	49	99.3	2	290	3	352	449	HMJ05698.1 S8 family serine peptidase [Chthoniobacterales bacterium]	diamond	1779	79.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31456558	31456558	PRJNA1000943_P_NODE_9596_length_269_cov_1.591837_g9458_i0	PRJNA1000943	9596	269	1.591837	4.28204153	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	44.7	0.00856	NR	MBA3272837.1	2201154	g9458	i0	49	0.546468401486989	49	23	52.4	1	110	250	170	218	MBA3272837.1 arylesterase [Chthoniobacterales bacterium]	diamond	147	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31835783	31835783	PRJNA1000943_P_NODE_15697_length_238_cov_2.836364_g15559_i0	PRJNA1000943	15697	238	2.836364	6.75054632	Puniceicoccaceae bacterium	2026784	Bacteria	Bacteria	76.3	5.42e-14	NR	TVR53920.1	2026784	g15559	i0	44.2	4.91596638655462	77	37	97.1	1	235	5	393	463	TVR53920.1 MAG: metallophosphoesterase family protein [Puniceicoccaceae bacterium]	diamond	1170	76.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Puniceicoccaceae		Puniceicoccaceae bacterium
32500651	32500651	PRJNA1000943_P_NODE_12159_length_250_cov_0.881356_g12021_i0	PRJNA1000943	12159	250	0.881356	2.20339	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	151	1.57e-41	NR	MBK7999304.1	2026799	g12021	i0	88	0.996	83	10	99.6	0	2	250	348	430	MBK7999304.1 tetratricopeptide repeat protein [Verrucomicrobiota bacterium]	diamond	249	151	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32783999	32783999	PRJNA1000943_P_NODE_11980_length_251_cov_0.876404_g11842_i0	PRJNA1000943	11980	251	0.876404	2.19977404	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	152	1.83e-44	NR	MBK8000203.1	2026799	g11842	i0	83.1	0.99203187250996006	83	14	99.2	0	1	249	90	172	MBK8000203.1 cyclase family protein [Verrucomicrobiota bacterium]	diamond	249	152	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);;