metadata: contig_metadata: 18 rows where bioproject = "PRJNA1174234", tax_clade = "PVC group" and tax

18 rows where bioproject = "PRJNA1174234", 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
7418769	7418769	PRJNA1174234_P_NODE_11706_length_403_cov_1.154545_g11510_i0	PRJNA1174234	11706	403	1.154545	4.65281635	Verrucomicrobiaceae	203557	Bacteria	Bacteria	372	2.61e-98	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g11510	i0	89.796	232.90570719603	294	25	73	4	1	294	1772	1484	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	93861	374	0.994652406417112	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
11794652	11794652	PRJNA1174234_P_NODE_13810_length_370_cov_2.003367_g13614_i0	PRJNA1174234	13810	370	2.003367	7.4124579	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	364	3.98e-96	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g13614	i0	84.553	265.651351351351	369	55	99	2	1	369	1023	1389	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	98291	364	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
20717486	20717486	PRJNA1174234_P_NODE_25277_length_273_cov_1.415000_g25081_i0	PRJNA1174234	25277	273	1.415	3.86295	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	494	3.46e-135	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g25081	i0	99.267	277.021978021978	273	2	100	0	1	273	3893531	3893803	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	75627	494	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
26977237	26977237	PRJNA1174234_P_NODE_4562_length_628_cov_1.684685_g4369_i0	PRJNA1174234	4562	628	1.684685	10.5798218	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	79.3	1.86e-13	NR	RYD71398.1	2026800	g4369	i0	42.4	0.439490445859873	92	48	43.9	2	1	276	275	361	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	276	79.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27166797	27166797	PRJNA1174234_P_NODE_17722_length_327_cov_1.507874_g17526_i0	PRJNA1174234	17722	327	1.507874	4.93074798	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	62	1.81e-8	NR	HEX2748500.1	2026801	g17526	i0	44.3	2.6697247706422	97	47	84.4	4	52	327	1166	1260	HEX2748500.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	873	62	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27198393	27198393	PRJNA1174234_P_NODE_30342_length_249_cov_0.875000_g30146_i0	PRJNA1174234	30342	249	0.875	2.17875	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	53.5	6.33e-6	NR	MBL9151590.1	2026801	g30146	i0	39.7	0.939759036144578	78	26	94	2	236	3	962	1018	MBL9151590.1 DEAD/DEAH box helicase [Verrucomicrobiales bacterium]	diamond	234	53.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27723539	27723539	PRJNA1174234_P_NODE_26764_length_264_cov_1.518325_g26568_i0	PRJNA1174234	26764	264	1.518325	4.008378	Bacteria	2	Bacteria	Bacteria	120	6.3000000000000005e-30	NR	MEZ7956900.1	2109375	g26568	i0	78.9	2.51136363636364	71	15	80.7	0	51	263	6	76	MEZ7956900.1 UDP-glucose 6-dehydrogenase [Rubritalea sp.]	diamond	663	120	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Rubritaleaceae	Rubritalea	Rubritalea sp.
27735879	27735879	PRJNA1174234_P_NODE_22324_length_292_cov_1.242009_g22128_i0	PRJNA1174234	22324	292	1.242009	3.62666628	Opitutaceae bacterium	2006848	Bacteria	Bacteria	43.1	0.0478	NR	HXC01461.1	2006848	g22128	i0	33.7	0.883561643835616	86	44	75	3	264	46	371	456	HXC01461.1 methyltransferase domain-containing protein [Opitutaceae bacterium]	diamond	258	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28114316	28114316	PRJNA1174234_P_NODE_4665_length_622_cov_2.546448_g4472_i0	PRJNA1174234	4665	622	2.546448	15.83890656	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	167	5.17e-49	NR	RYD70704.1	2026800	g4472	i0	44.9	0.901929260450161	187	82	90.2	1	14	574	9	174	RYD70704.1 MAG: hypothetical protein EOP84_26230 [Verrucomicrobiaceae bacterium]	diamond	561	167	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28303895	28303895	PRJNA1174234_P_NODE_3646_length_693_cov_1.567742_g3466_i0	PRJNA1174234	3646	693	1.567742	10.86445206	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	58.2	2.93e-6	NR	HEX3818319.1	2201154	g3466	i0	37.3	0.476190476190476	110	59	46.3	5	21	341	120	222	HEX3818319.1 CAP domain-containing protein [Chthoniobacterales bacterium]	diamond	330	58.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
28493412	28493412	PRJNA1174234_P_NODE_23767_length_282_cov_3.157895_g23571_i0	PRJNA1174234	23767	282	3.157895	8.9052639	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	65.1	5.62e-11	NR	MEY3530030.1	2026799	g23571	i0	46.8	1.63829787234043	77	39	79.8	1	280	56	55	131	MEY3530030.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	462	65.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29125093	29125093	PRJNA1174234_P_NODE_1829_length_910_cov_8.277180_g1687_i0	PRJNA1174234	1829	910	8.27718	75.322338	Luteolibacter sp.	1962973	Bacteria	Bacteria	59.3	9.59e-6	NR	WP_348214599.1	1962973	g1687	i0	27.2	0.679120879120879	206	126	65.3	10	648	55	318	507	WP_348214599.1 RICIN domain-containing protein [Luteolibacter sp.]	diamond	618	59.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
29661106	29661106	PRJNA1174234_P_NODE_1690_length_936_cov_2.105446_g1552_i0	PRJNA1174234	1690	936	2.105446	19.70697456	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	324	9.459999999999998e-107	NR	RYD65414.1	2026800	g1552	i0	64	0.791666666666667	247	83	78.5	3	1	735	94	336	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	741	324	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30735600	30735600	PRJNA1174234_P_NODE_2314_length_837_cov_2.328534_g2151_i0	PRJNA1174234	2314	837	2.328534	19.48982958	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	167	8.399999999999998e-44	NR	MDZ4742534.1	2026799	g2151	i0	50	1.21863799283154	170	81	60.9	3	2	511	395	560	MDZ4742534.1 thiamine pyrophosphate-binding protein [Verrucomicrobiota bacterium]	diamond	1020	167	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31051878	31051878	PRJNA1174234_P_NODE_18675_length_319_cov_1.609756_g18479_i0	PRJNA1174234	18675	319	1.609756	5.13512164	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	94.4	2.86e-20	NR	MEO6755482.1	2811408	g18479	i0	42.3	0.912225705329154	97	54	89.3	1	285	1	148	244	MEO6755482.1 hypothetical protein [Chthoniobacteraceae bacterium]	diamond	291	94.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
31304442	31304442	PRJNA1174234_P_NODE_27255_length_261_cov_1.409574_g27059_i0	PRJNA1174234	27255	261	1.409574	3.67898814	Rubritalea spongiae	430797	Bacteria	Bacteria	73.2	7.85e-13	NR	WP_377092613.1	430797	g27059	i0	49.4	0.885057471264368	77	36	88.5	2	257	27	329	402	WP_377092613.1 glycoside hydrolase family 75 protein [Rubritalea spongiae]	diamond	231	73.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Rubritaleaceae	Rubritalea	Rubritalea spongiae
32032103	32032103	PRJNA1174234_P_NODE_29598_length_250_cov_1.305085_g29402_i0	PRJNA1174234	29598	250	1.305085	3.2627125	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	99.8	1.85e-22	NR	MES1166043.1	2026799	g29402	i0	65	3.768	80	26	96	1	250	11	216	293	MES1166043.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	942	99.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32695739	32695739	PRJNA1174234_P_NODE_16220_length_343_cov_1.118519_g16024_i0	PRJNA1174234	16220	343	1.118519	3.83652017	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	89.4	8.860000000000001e-21	NR	MCX6971451.1	2026799	g16024	i0	70.6	0.446064139941691	51	15	44.6	0	215	63	3	53	MCX6971451.1 CDGSH iron-sulfur domain-containing protein [Verrucomicrobiota bacterium]	diamond	153	89.4	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);;