metadata: contig_metadata: 13 rows where bioproject = "PRJNA382558", tax_clade = "PVC group" and tax

13 rows where bioproject = "PRJNA382558", 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
8058232	8058232	PRJNA382558_S_NODE_487_length_377_cov_8.647059_g483_i0	PRJNA382558	487	377	8.647059	32.59941243	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	243	1.9900000000000002e-59	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g483	i0	79.101	2.04509283819629	378	59	98	16	10	377	3216806	3216439	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	771	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
9332953	9332953	PRJNA382558_S_NODE_1908_length_273_cov_4.792373_g1904_i0	PRJNA382558	1908	273	4.792373	13.08317829	Opitutales bacterium ASA1	3081749	Bacteria	Bacteria	125	4.38e-31	NR	BET68388.1	3081749	g1904	i0	69.3	0.967032967032967	88	27	96.7	0	8	271	127	214	BET68388.1 hypothetical protein ASA1KI_33060 [Opitutales bacterium ASA1]	diamond	264	125	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
9333069	9333069	PRJNA382558_S_NODE_7188_length_190_cov_9.124183_g7184_i0	PRJNA382558	7188	190	9.124183	17.3359477	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	122	1.2299999999999997e-23	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g7184	i0	82.27	2.06842105263158	141	25	74	0	50	190	4559686	4559546	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	393	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
11883437	11883437	PRJNA382558_S_NODE_10990_length_168_cov_5.160305_g10986_i0	PRJNA382558	10990	168	5.160305	8.6693124	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	102	1.38e-17	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g10986	i0	90.909	7.20238095238095	77	6	46	1	27	103	4278741	4278816	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	1210	102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
13158636	13158636	PRJNA382558_S_NODE_3591_length_231_cov_6.432990_g3587_i0	PRJNA382558	3591	231	6.43299	14.8602069	Haloferula helveola	490095	Bacteria	Bacteria	100	7.27e-17	NTclustered	gi\|2647781590\|dbj\|AP024702.1\|	490095	g3587	i0	93.939	24.9264069264069	66	4	29	0	155	220	2865168	2865103	Haloferula helveola CN-1 DNA, complete genome	blastn	5758	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola
20806381	20806381	PRJNA382558_S_NODE_12317_length_162_cov_6.552000_g12313_i0	PRJNA382558	12317	162	6.552	10.61424	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	176	7.67e-40	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g12313	i0	89.286	2.74691358024691	140	15	86	0	1	140	1538869	1538730	Lacunisphaera limnophila strain IG16b, complete genome	blastn	445	176	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
26758529	26758529	PRJNA382558_S_NODE_2901_length_244_cov_16.135266_g2897_i0	PRJNA382558	2901	244	16.135266	39.37004904	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	41.6	0.0133	NR	MDE0837282.1	2562705	g2897	i0	100	0.233606557377049	19	0	23.4	0	59	3	1	19	MDE0837282.1 ribbon-helix-helix protein, CopG family [Akkermansiaceae bacterium]	diamond	57	41.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
28496472	28496472	PRJNA382558_S_NODE_9487_length_175_cov_9.478261_g9483_i0	PRJNA382558	9487	175	9.478261	16.58695675	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	115	4.81e-28	NR	MCX6972604.1	2026799	g9483	i0	91.2	0.977142857142857	57	5	97.7	0	3	173	441	497	MCX6972604.1 DEAD/DEAH box helicase family protein [Verrucomicrobiota bacterium]	diamond	171	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28780332	28780332	PRJNA382558_S_NODE_2747_length_248_cov_7.691943_g2743_i0	PRJNA382558	2747	248	7.691943	19.07601864	Opitutaceae bacterium	2006848	Bacteria	Bacteria	124	2.98e-32	NR	HRE08112.1	2006848	g2743	i0	73.1	2.92741935483871	78	21	94.4	0	236	3	27	104	HRE08112.1 MBL fold metallo-hydrolase [Opitutaceae bacterium]	diamond	726	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30012109	30012109	PRJNA382558_S_NODE_2191_length_263_cov_7.194690_g2187_i0	PRJNA382558	2191	263	7.19469	18.9220347	Geminisphaera colitermitum	1148786	Bacteria	Bacteria	44.7	0.01	NR	WP_043584250.1	1148786	g2187	i0	32.8	0.730038022813688	64	42	73	1	220	29	534	596	WP_043584250.1 glycosyl hydrolase family 65 protein [Geminisphaera colitermitum]	diamond	192	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Geminisphaera	Geminisphaera colitermitum
30265046	30265046	PRJNA382558_S_NODE_5712_length_204_cov_4.958084_g5708_i0	PRJNA382558	5712	204	4.958084	10.11449136	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	54.3	1.94e-6	NR	HEX8313057.1	2811408	g5708	i0	46.3	0.985294117647059	67	35	98.5	1	4	204	317	382	HEX8313057.1 hypothetical protein [Chthoniobacteraceae bacterium]	diamond	201	54.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
31261179	31261179	PRJNA382558_S_NODE_11895_length_164_cov_5.110236_g11891_i0	PRJNA382558	11895	164	5.1102359999999996	8.38078704	Pseudomonadati	3379134	Bacteria	Bacteria	42.7	0.0116	NR	MBL9159496.1	2026801	g11891	i0	48	3.8780487804878	50	25	89.6	1	162	16	85	134	MBL9159496.1 response regulator transcription factor [Verrucomicrobiales bacterium]	diamond	636	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31971680	31971680	PRJNA382558_S_NODE_6118_length_199_cov_11.092593_g6114_i0	PRJNA382558	6118	199	11.092593	22.07426007	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42	0.0374	NR	MBV8481670.1	2026799	g6114	i0	44.2	1.5678391959799	52	29	78.4	0	198	43	6	57	MBV8481670.1 ChaN family lipoprotein [Verrucomicrobiota bacterium]	diamond	312	42	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);;