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

19 rows where bioproject = "PRJNA1247234", 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
5455029	5455029	PRJNA1247234_P_NODE_3945_length_500_cov_1.501171_g3794_i0	PRJNA1247234	3945	500	1.501171	7.505855	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	627	6.38e-175	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g3794	i0	89.328	156.23	506	45	100	7	1	500	1316825	1316323	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	78115	627	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13105362	13105362	PRJNA1247234_P_NODE_23891_length_248_cov_0.891429_g23735_i0	PRJNA1247234	23891	248	0.891429	2.21074392	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	183	7.62e-42	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g23735	i0	86.391	1.12903225806452	169	21	68	2	2	169	279460	279293	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	280	183	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
15654524	15654524	PRJNA1247234_P_NODE_25793_length_245_cov_0.906977_g25637_i0	PRJNA1247234	25793	245	0.906977	2.22209365	Opitutaceae bacterium	2006848	Bacteria	Bacteria	95.5	1.1e-21	NR	MBC8040954.1	2006848	g25637	i0	81.1	4.56734693877551	53	10	64.9	0	160	2	4	56	MBC8040954.1 UDP-2,3-diacylglucosamine diphosphatase [Opitutaceae bacterium]	diamond	1119	95.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
22728634	22728634	PRJNA1247234_P_NODE_27838_length_242_cov_0.923077_g27682_i0	PRJNA1247234	27838	242	0.923077	2.23384634	Puniceicoccaceae bacterium	2026784	Bacteria	Bacteria	128	3.33e-32	NR	TVR49749.1	2026784	g27682	i0	76.3	1.97107438016529	80	19	99.2	0	3	242	557	636	TVR49749.1 MAG: RecQ family ATP-dependent DNA helicase [Puniceicoccaceae bacterium]	diamond	477	128	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Puniceicoccaceae		Puniceicoccaceae bacterium
23303846	23303846	PRJNA1247234_P_NODE_24199_length_247_cov_0.896552_g24043_i0	PRJNA1247234	24199	247	0.896552	2.21448344	Opitutia	414999	Bacteria	Bacteria	162	2.77e-45	NR	WP_189517161.1	424488	g24043	i0	89	5.97570850202429	82	9	99.6	0	246	1	174	255	WP_189517161.1 2Fe-2S iron-sulfur cluster-binding protein [Cerasicoccus arenae]	diamond	1476	163	0.993865030674847	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Cerasicoccus	Cerasicoccus arenae
26852327	26852327	PRJNA1247234_P_NODE_18821_length_262_cov_0.597884_g18665_i0	PRJNA1247234	18821	262	0.597884	1.56645608	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	44.3	0.0102	NR	HVV71216.1	2499141	g18665	i0	32.1	0.961832061068702	84	46	83.6	2	30	248	9	92	HVV71216.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	252	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27642457	27642457	PRJNA1247234_P_NODE_21484_length_251_cov_0.876404_g21328_i0	PRJNA1247234	21484	251	0.876404	2.19977404	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	101	9.37e-23	NR	HEX7859182.1	2499141	g21328	i0	63	1.93625498007968	81	29	96.8	1	7	249	329	408	HEX7859182.1 L-lactate permease [Verrucomicrobiia bacterium]	diamond	486	101	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27692201	27692201	PRJNA1247234_P_NODE_22164_length_250_cov_0.881356_g22008_i0	PRJNA1247234	22164	250	0.881356	2.20339	Cerasicoccus	468938	Bacteria	Bacteria	167	2.4699999999999998e-46	NR	MEO0795207.1	2026799	g22008	i0	90.4	18.924	83	8	99.6	0	2	250	316	398	MEO0795207.1 cytochrome c oxidase subunit I [Verrucomicrobiota bacterium]	diamond	4731	167	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27863196	27863196	PRJNA1247234_P_NODE_25885_length_245_cov_0.906977_g25729_i0	PRJNA1247234	25885	245	0.906977	2.22209365	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	166	2.67e-48	NR	MCC6884677.1	2026801	g25729	i0	97.5	0.991836734693878	81	2	99.2	0	1	243	241	321	MCC6884677.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	243	166	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28873573	28873573	PRJNA1247234_P_NODE_24108_length_247_cov_0.896552_g23952_i0	PRJNA1247234	24108	247	0.896552	2.21448344	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	126	4.26e-32	NR	MEQ1860771.1	2811408	g23952	i0	75.6	0.995951417004049	82	20	99.6	0	246	1	407	488	MEQ1860771.1 F0F1 ATP synthase subunit alpha [Chthoniobacteraceae bacterium]	diamond	246	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
29473265	29473265	PRJNA1247234_P_NODE_25630_length_245_cov_0.906977_g25474_i0	PRJNA1247234	25630	245	0.906977	2.22209365	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	107	4.8e-26	NR	HEV8542874.1	2499141	g25474	i0	79.7	5.80408163265306	59	12	72.2	0	181	5	1	59	HEV8542874.1 S-methyl-5'-thioadenosine phosphorylase [Verrucomicrobiia bacterium]	diamond	1422	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30691916	30691916	PRJNA1247234_P_NODE_21733_length_251_cov_0.876404_g21577_i0	PRJNA1247234	21733	251	0.876404	2.19977404	Bacteria	2	Bacteria	Bacteria	137	1.17e-37	NR	MDX1952245.1	2026799	g21577	i0	84.3	6.94422310756972	83	13	99.2	0	2	250	177	259	MDX1952245.1 ribose-phosphate pyrophosphokinase [Verrucomicrobiota bacterium]	diamond	1743	138	0.992753623188406	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30863398	30863398	PRJNA1247234_P_NODE_16414_length_279_cov_1.514563_g16258_i0	PRJNA1247234	16414	279	1.514563	4.22563077	Opitutia bacterium	2026771	Bacteria	Bacteria	57	5.63e-7	NR	HAE12017.1	2026771	g16258	i0	68.6	1.12903225806452	35	11	37.6	0	166	270	1	35	HAE12017.1 asparagine synthase (glutamine-hydrolyzing) [Opitutia bacterium]	diamond	315	57	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
31071272	31071272	PRJNA1247234_P_NODE_20915_length_252_cov_0.871508_g20759_i0	PRJNA1247234	20915	252	0.871508	2.19620016	Opitutia	414999	Bacteria	Bacteria	144	9.03e-39	NR	NQY32271.1	2024828	g20759	i0	81.9	13.75	83	15	98.8	0	250	2	248	330	NQY32271.1 YifB family Mg chelatase-like AAA ATPase [Coraliomargarita sp.]	diamond	3465	145	0.993103448275862	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita sp.
31228903	31228903	PRJNA1247234_P_NODE_22555_length_250_cov_0.881356_g22399_i0	PRJNA1247234	22555	250	0.881356	2.20339	Bacteria	2	Bacteria	Bacteria	53.9	4.65e-6	NR	MFO1513595.1	2026799	g22399	i0	36.7	1.896	79	50	94.8	0	12	248	348	426	MFO1513595.1 DUF3857 domain-containing protein [Verrucomicrobiota bacterium]	diamond	474	54.3	0.992633517495396	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31527410	31527410	PRJNA1247234_P_NODE_17656_length_270_cov_1.401015_g17500_i0	PRJNA1247234	17656	270	1.401015	3.7827405	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	57	4.83e-7	NR	MDQ6623254.1	2026799	g17500	i0	63.9	0.4	36	13	40	0	2	109	575	610	MDQ6623254.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	108	57	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31780240	31780240	PRJNA1247234_P_NODE_23117_length_249_cov_0.886364_g22961_i0	PRJNA1247234	23117	249	0.886364	2.20704636	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	94.4	1.7400000000000003e-21	NR	MFN5867803.1	2562705	g22961	i0	67.8	3.48192771084337	59	19	71.1	0	6	182	185	243	MFN5867803.1 DUF5131 family protein [Akkermansiaceae bacterium]	diamond	867	94.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
32223365	32223365	PRJNA1247234_P_NODE_23158_length_249_cov_0.886364_g23002_i0	PRJNA1247234	23158	249	0.886364	2.20704636	Ruficoccus sp. ZRK36	2866311	Bacteria	Bacteria	117	2.29e-32	NR	WP_220621413.1	2866311	g23002	i0	68.3	0.987951807228916	82	26	98.8	0	248	3	14	95	WP_220621413.1 helix-turn-helix domain-containing protein [Ruficoccus sp. ZRK36]	diamond	246	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Ruficoccus	Ruficoccus sp. ZRK36
32760235	32760235	PRJNA1247234_P_NODE_21100_length_252_cov_0.871508_g20944_i0	PRJNA1247234	21100	252	0.871508	2.19620016	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	56.6	5.32e-7	NR	MBU6182411.1	2026799	g20944	i0	39.4	1.39285714285714	71	42	84.5	1	38	250	31	100	MBU6182411.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	351	56.6	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);;