metadata: contig_metadata: 19 rows where bioproject = "PRJNA906294", tax_clade = "PVC group" and tax

19 rows where bioproject = "PRJNA906294", 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
2163462	2163462	PRJNA906294_P_NODE_221502_length_244_cov_1.029240_g217386_i0	PRJNA906294	221502	244	1.02924	2.5113456	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	346	9.019999999999999e-91	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g217386	i0	95.392	189.049180327869	217	10	89	0	1	217	2498040	2497824	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	46128	346	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
11089594	11089594	PRJNA906294_P_NODE_129349_length_345_cov_1.113971_g125233_i0	PRJNA906294	129349	345	1.113971	3.84319995	Opitutales bacterium	2026772	Bacteria	Bacteria	200	6.95e-60	NR	MDY6069808.1	2026772	g125233	i0	84.2	4.95652173913043	114	18	99.1	0	2	343	21	134	MDY6069808.1 adenosylhomocysteinase [Opitutales bacterium]	diamond	1710	200	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
13640810	13640810	PRJNA906294_P_NODE_179351_length_276_cov_1.339901_g175235_i0	PRJNA906294	179351	276	1.339901	3.69812676	Fontisphaera persica	2974023	Bacteria	Bacteria	324	4.87e-84	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g175235	i0	87.9	41.2898550724638	281	27	99	5	3	276	3861594	3861874	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	11396	324	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
14915720	14915720	PRJNA906294_P_NODE_205112_length_250_cov_4.124294_g200996_i0	PRJNA906294	205112	250	4.124294	10.310735	Candidatus Xiphinematobacter sp. Idaho Grape	1704307	Bacteria	Bacteria	329	9.34e-86	NTclustered	gi\|939198278\|gb\|CP012665.1\|	1704307	g200996	i0	90.476	163.316	252	20	99	3	1	249	15769	15519	Candidatus Xiphinematobacter sp. Idaho Grape, complete genome	blastn	40829	329	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp. Idaho Grape
18738574	18738574	PRJNA906294_P_NODE_17695_length_1397_cov_12.048338_g15387_i0	PRJNA906294	17695	1397	12.048338	168.31528186	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	422	2.12e-142	NR	MDH4476108.1	2026800	g15387	i0	61.8	6.92125984251969	359	131	77.1	4	1353	277	3	355	MDH4476108.1 alkene reductase [Verrucomicrobiaceae bacterium]	diamond	9669	422	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
22564356	22564356	PRJNA906294_P_NODE_18838_length_1350_cov_12.489428_g15387_i1	PRJNA906294	18838	1350	12.489428	168.607278	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	422	1.2e-142	NR	MDH4476108.1	2026800	g15387	i1	61.8	7.16222222222222	359	131	79.8	4	1306	230	3	355	MDH4476108.1 alkene reductase [Verrucomicrobiaceae bacterium]	diamond	9669	422	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
23838766	23838766	PRJNA906294_P_NODE_157359_length_301_cov_4.859649_g153243_i0	PRJNA906294	157359	301	4.859649	14.62754349	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	372	1.89e-98	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g153243	i0	89.037	222.129568106312	301	31	100	2	1	301	3894530	3894828	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	66861	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
27245546	27245546	PRJNA906294_P_NODE_133643_length_337_cov_1.340909_g129527_i0	PRJNA906294	133643	337	1.340909	4.51886333	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	96.3	6.2e-21	NR	MBE7496199.1	2026800	g129527	i0	46.1	1.02373887240356	115	54	98.8	3	3	335	168	278	MBE7496199.1 Gfo/Idh/MocA family oxidoreductase [Verrucomicrobiaceae bacterium]	diamond	345	96.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27403765	27403765	PRJNA906294_P_NODE_225663_length_243_cov_0.894118_g221547_i0	PRJNA906294	225663	243	0.894118	2.17270674	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.9	0.0143	NR	MEY4939534.1	2026799	g221547	i0	32.9	0.901234567901235	73	47	87.7	1	238	26	121	193	MEY4939534.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	219	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28414105	28414105	PRJNA906294_P_NODE_213326_length_247_cov_0.873563_g209210_i0	PRJNA906294	213326	247	0.873563	2.15770061	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	42	0.015	NR	HYJ03741.1	2201154	g209210	i0	41.3	0.765182186234818	63	25	61.9	3	6	158	28	90	HYJ03741.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	189	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
28887434	28887434	PRJNA906294_P_NODE_110048_length_387_cov_1.143312_g105933_i0	PRJNA906294	110048	387	1.143312	4.42461744	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	47.4	0.0038	NR	MFM2243029.1	2026799	g105933	i0	29.7	0.573643410852713	74	49	57.4	1	354	133	231	301	MFM2243029.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	222	47.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29676565	29676565	PRJNA906294_P_NODE_152350_length_308_cov_1.685106_g148234_i0	PRJNA906294	152350	308	1.685106	5.19012648	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	119	4.77e-29	NR	NBQ24453.1	2026799	g148234	i0	56.9	0.993506493506494	102	44	99.4	0	2	307	344	445	NBQ24453.1 UTP--glucose-1-phosphate uridylyltransferase [Verrucomicrobiota bacterium]	diamond	306	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29708061	29708061	PRJNA906294_P_NODE_102930_length_407_cov_0.769461_g98815_i0	PRJNA906294	102930	407	0.769461	3.13170627	Opitutaceae bacterium	2006848	Bacteria	Bacteria	72.4	3.25e-13	NR	HEX2854679.1	2006848	g98815	i0	46.8	3.36855036855037	94	47	68.6	3	126	404	1	92	HEX2854679.1 DUF423 domain-containing protein [Opitutaceae bacterium]	diamond	1371	72.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30182241	30182241	PRJNA906294_P_NODE_130112_length_343_cov_2.092593_g125996_i0	PRJNA906294	130112	343	2.092593	7.17759399	Opitutus sp. ER46	2161864	Bacteria	Bacteria	80.9	1.84e-15	NR	WP_107836914.1	2161864	g125996	i0	41.9	1.79300291545189	105	59	91	2	313	2	2	105	WP_107836914.1 glycosyltransferase family 32 protein [Opitutus sp. ER46]	diamond	615	80.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. ER46
30213738	30213738	PRJNA906294_P_NODE_152132_length_309_cov_0.822034_g148016_i0	PRJNA906294	152132	309	0.822034	2.54008506	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	48.9	5.54e-4	NR	HET6409373.1	2811408	g148016	i0	40	1.72815533980583	75	39	72.8	3	299	75	93	161	HET6409373.1 hypothetical protein [Chthoniobacteraceae bacterium]	diamond	534	48.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
30372302	30372302	PRJNA906294_P_NODE_210852_length_248_cov_0.868571_g206736_i0	PRJNA906294	210852	248	0.868571	2.15405608	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	42	0.0177	NR	HAB17453.1	2026801	g206736	i0	43.6	0.665322580645161	55	23	59.3	3	248	102	35	87	HAB17453.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	165	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31446443	31446443	PRJNA906294_P_NODE_214456_length_247_cov_0.873563_g210340_i0	PRJNA906294	214456	247	0.873563	2.15770061	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	70.5	4.61e-12	NR	HKP03264.1	2201154	g210340	i0	63.6	1.20242914979757	55	20	66.8	0	81	245	2	56	HKP03264.1 transaldolase [Chthoniobacterales bacterium]	diamond	297	70.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32774025	32774025	PRJNA906294_P_NODE_128760_length_346_cov_1.113553_g124644_i0	PRJNA906294	128760	346	1.113553	3.85289338	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	87	1.05e-17	NR	MBS0648513.1	2026799	g124644	i0	41.3	1.95953757225434	109	57	90.2	3	335	24	85	191	MBS0648513.1 DUF2431 domain-containing protein [Verrucomicrobiota bacterium]	diamond	678	87	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32805588	32805588	PRJNA906294_P_NODE_198740_length_256_cov_2.120219_g194624_i0	PRJNA906294	198740	256	2.120219	5.42776064	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	42.4	0.0498	NR	HCU86341.1	2026801	g194624	i0	36.4	0.90234375	77	49	90.2	0	240	10	13	89	HCU86341.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	231	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales 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);;