metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA1031674" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA1031674" 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
7819384	7819384	PRJNA1031674_P_NODE_22387_length_250_cov_2.265537_g22176_i0	PRJNA1031674	22387	250	2.265537	5.6638425	Bacteria	2	Bacteria	Bacteria	111	2.94e-28	NR	MBV8970391.1	2026799	g22176	i0	72	11.76	82	23	98.4	0	4	249	26	107	MBV8970391.1 zinc-binding dehydrogenase [Verrucomicrobiota bacterium]	diamond	2940	112	0.991071428571429	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
26845473	26845473	PRJNA1031674_P_NODE_19021_length_263_cov_1.094737_g18810_i0	PRJNA1031674	19021	263	1.094737	2.87915831	Opitutaceae bacterium	2006848	Bacteria	Bacteria	74.7	2.64e-13	NR	MBH54129.1	2006848	g18810	i0	50	2.78326996197719	82	36	93.5	1	8	253	448	524	MBH54129.1 hypothetical protein [Opitutaceae bacterium]	diamond	732	74.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28329912	28329912	PRJNA1031674_P_NODE_15646_length_275_cov_1.524752_g15435_i0	PRJNA1031674	15646	275	1.524752	4.193068	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	115	2.12e-28	NR	HAV65000.1	2026801	g15435	i0	62.6	2.96727272727273	91	34	99.3	0	273	1	66	156	HAV65000.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	816	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28361481	28361481	PRJNA1031674_P_NODE_15226_length_276_cov_2.014778_g15015_i0	PRJNA1031674	15226	276	2.014778	5.5607872800000004	Verrucomicrobia bacterium LW23	2161867	Bacteria	Bacteria	115	9.239999999999999e-30	NR	PTY01923.1	2161867	g15015	i0	83.1	0.771739130434783	71	12	77.2	0	213	1	1	71	PTY01923.1 branched-chain amino acid ABC transporter ATP-binding protein [Verrucomicrobia bacterium LW23]	diamond	213	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium LW23
28361484	28361484	PRJNA1031674_P_NODE_18966_length_263_cov_1.431579_g18755_i0	PRJNA1031674	18966	263	1.431579	3.76505277	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	87.8	4.17e-19	NR	MBA2272013.1	2201154	g18755	i0	60.7	0.958174904942966	84	30	94.7	2	251	3	62	143	MBA2272013.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	252	87.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
28424886	28424886	PRJNA1031674_P_NODE_4606_length_387_cov_1.942675_g4396_i0	PRJNA1031674	4606	387	1.942675	7.51815225	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	46.2	0.00591	NR	MEI6341235.1	2026799	g4396	i0	33.7	0.643410852713178	83	46	57.4	2	77	298	84	166	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	249	46.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28961745	28961745	PRJNA1031674_P_NODE_9568_length_299_cov_3.353982_g9357_i0	PRJNA1031674	9568	299	3.353982	10.02840618	Lacunisphaera sp.	1961806	Bacteria	Bacteria	98.2	1.3100000000000002e-21	NR	HEY0864151.1	1961806	g9357	i0	96	0.501672240802676	50	2	50.2	0	150	299	90	139	HEY0864151.1 FAD-dependent oxidoreductase [Lacunisphaera sp.]	diamond	150	98.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
30058585	30058585	PRJNA1031674_P_NODE_8651_length_310_cov_2.611814_g8440_i0	PRJNA1031674	8651	310	2.611814	8.0966234	Lacunisphaera	1961799	Bacteria	Bacteria	96.3	1.34e-20	NR	WP_069963418.1	1838286	g8440	i0	100	7.58709677419355	49	0	47.4	0	148	2	214	262	WP_069963418.1 bifunctional aspartate kinase/homoserine dehydrogenase I [Lacunisphaera limnophila]	diamond	2352	96.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
30193004	30193004	PRJNA1031674_P_NODE_25472_length_245_cov_1.459302_g25261_i0	PRJNA1031674	25472	245	1.459302	3.5752899	Opitutaceae bacterium	2006848	Bacteria	Bacteria	129	9.34e-33	NR	MBL9215566.1	2006848	g25261	i0	77.8	0.991836734693878	81	18	99.2	0	245	3	407	487	MBL9215566.1 GAF domain-containing protein [Opitutaceae bacterium]	diamond	243	129	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30667013	30667013	PRJNA1031674_P_NODE_15553_length_275_cov_1.915842_g15342_i0	PRJNA1031674	15553	275	1.915842	5.2685655	Lacunisphaera sp.	1961806	Bacteria	Bacteria	53.5	8.67e-6	NR	HEY0865052.1	1961806	g15342	i0	30.8	0.992727272727273	91	56	94.9	3	13	273	59	146	HEY0865052.1 prolyl oligopeptidase family serine peptidase [Lacunisphaera sp.]	diamond	273	53.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
31362463	31362463	PRJNA1031674_P_NODE_19236_length_262_cov_1.322751_g19025_i0	PRJNA1031674	19236	262	1.322751	3.46560762	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	90.9	5.53e-19	NR	MEY2879255.1	2026799	g19025	i0	54	0.99618320610687	87	40	99.6	0	2	262	284	370	MEY2879255.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	261	90.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31386111	31386111	PRJNA1031674_P_NODE_22416_length_250_cov_1.932203_g22205_i0	PRJNA1031674	22416	250	1.932203	4.8305075	Lacunisphaera	1961799	Bacteria	Bacteria	81.6	2.93e-17	NR	MEJ1971517.1	1961806	g22205	i0	48.8	7.728	82	42	98.4	0	1	246	9	90	MEJ1971517.1 hypothetical protein [Lacunisphaera sp.]	diamond	1932	81.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
32279932	32279932	PRJNA1031674_P_NODE_24879_length_246_cov_1.583815_g24668_i0	PRJNA1031674	24879	246	1.583815	3.8961849	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	44.7	0.00828	NR	HTJ73330.1	2499141	g24668	i0	55.6	1.24390243902439	36	15	43.9	1	1	108	628	662	HTJ73330.1 phage tail tip lysozyme [Verrucomicrobiia bacterium]	diamond	306	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32374775	32374775	PRJNA1031674_P_NODE_20419_length_257_cov_1.673913_g20208_i0	PRJNA1031674	20419	257	1.673913	4.30195641	Luteolibacter rhizosphaerae	2989719	Bacteria	Bacteria	127	1.04e-31	NR	WP_264513945.1	2989719	g20208	i0	81.1	0.863813229571984	74	13	86.4	1	257	36	1117	1189	WP_264513945.1 pilus assembly PilX family protein [Luteolibacter rhizosphaerae]	diamond	222	127	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter rhizosphaerae

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);;