metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax

15 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Elusimicrobiota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27160015	27160015	PRJEB64798_P_NODE_58282_length_255_cov_6.485437_g56517_i0	PRJEB64798	58282	255	6.485437	16.53786435	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	114	1.88e-27	NR	MCG3206287.1	2030800	g56517	i0	62.7	0.976470588235294	83	31	97.6	0	1	249	216	298	MCG3206287.1 hypothetical protein [Elusimicrobiota bacterium]	diamond	249	114	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
27374846	27374846	PRJEB64798_P_NODE_109023_length_210_cov_8.285714_g107257_i0	PRJEB64798	109023	210	8.285714	17.3999994	Pseudomonadati	3379134	Bacteria	Bacteria	65.1	1.86e-10	NR	OGS22920.1	1797957	g107257	i0	75	1.37142857142857	32	8	45.7	0	4	99	169	200	OGS22920.1 MAG: hypothetical protein A2252_07525 [Elusimicrobia bacterium RIFOXYA2_FULL_39_19]	diamond	288	65.5	0.993893129770992	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobia bacterium RIFOXYA2_FULL_39_19
27697614	27697614	PRJEB64798_P_NODE_223444_length_161_cov_4.419643_g221678_i0	PRJEB64798	223444	161	4.419643	7.11562523	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	70.1	4.28e-14	NR	MDE2426759.1	2030800	g221678	i0	61.2	1.82608695652174	49	19	91.3	0	160	14	39	87	MDE2426759.1 hypothetical protein [Elusimicrobiota bacterium]	diamond	294	70.1	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
28044496	28044496	PRJEB64798_P_NODE_220605_length_162_cov_1.734513_g218839_i0	PRJEB64798	220605	162	1.734513	2.80991106	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	60.5	6.67e-9	NR	HVE12696.1	2030800	g218839	i0	58	1.85185185185185	50	21	92.6	0	157	8	27	76	HVE12696.1 hypothetical protein [Elusimicrobiota bacterium]	diamond	300	60.5	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
28574284	28574284	PRJEB64798_P_NODE_180627_length_174_cov_2.920000_g178861_i0	PRJEB64798	180627	174	2.92	5.0808	Bacteria	2	Bacteria	Bacteria	49.7	5.36e-5	NR	MBD3271215.1	2030800	g178861	i0	52.4	3.48275862068966	42	20	72.4	0	37	162	417	458	MBD3271215.1 S8 family serine peptidase [Elusimicrobiota bacterium]	diamond	606	50.1	0.992015968063872	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
30444610	30444610	PRJEB64798_P_NODE_171193_length_178_cov_3.945736_g169427_i0	PRJEB64798	171193	178	3.945736	7.02341008	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	73.6	1.65e-14	NR	MCG3206274.1	2030800	g169427	i0	68.4	0.960674157303371	57	18	96.1	0	171	1	69	125	MCG3206274.1 hypothetical protein [Elusimicrobiota bacterium]	diamond	171	73.6	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
30886815	30886815	PRJEB64798_P_NODE_168254_length_179_cov_8.430769_g166488_i0	PRJEB64798	168254	179	8.430769	15.09107651	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	58.9	3.04e-8	NR	MCG2724991.1	2030800	g166488	i0	52.8	0.888268156424581	53	24	87.2	1	172	17	369	421	MCG2724991.1 YifB family Mg chelatase-like AAA ATPase [Elusimicrobiota bacterium]	diamond	159	58.9	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
30943250	30943250	PRJEB64798_P_NODE_177594_length_175_cov_5.801587_g175828_i0	PRJEB64798	177594	175	5.801587	10.15277725	Pseudomonadati	3379134	Bacteria	Bacteria	46.6	6.22e-4	NR	WP_413906516.1	1408204	g175828	i0	100	3.24	21	0	36	0	111	173	5	25	WP_413906516.1 type I glyceraldehyde-3-phosphate dehydrogenase [Candidatus Endomicrobiellum trichonymphae]	diamond	567	46.6	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Candidatus Endomicrobiellum	Candidatus Endomicrobiellum trichonymphae
31290659	31290659	PRJEB64798_P_NODE_214515_length_163_cov_9.324561_g212749_i0	PRJEB64798	214515	163	9.324561	15.19903443	Bacteria	2	Bacteria	Bacteria	60.1	9.61e-9	NR	OGR95924.1	1797939	g212749	i0	65.2	2.79754601226994	46	16	84.7	0	144	7	14	59	OGR95924.1 MAG: hypothetical protein A2016_07930 [Elusimicrobia bacterium GWF2_62_30]	diamond	456	60.1	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobia bacterium GWF2_62_30
31487593	31487593	PRJEB64798_P_NODE_124036_length_203_cov_3.642857_g122270_i0	PRJEB64798	124036	203	3.642857	7.39499971	Elusimicrobiales bacterium	2478488	Bacteria	Bacteria	68.6	2.61e-12	NR	MBP5287097.1	2478488	g122270	i0	60.7	0.827586206896552	56	22	82.8	0	12	179	127	182	MBP5287097.1 NAD(P)H-dependent oxidoreductase [Elusimicrobiales bacterium]	diamond	168	68.6	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales			Elusimicrobiales bacterium
31677029	31677029	PRJEB64798_P_NODE_101217_length_212_cov_2.871166_g99451_i0	PRJEB64798	101217	212	2.871166	6.08687192	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	47.4	4.93e-4	NR	MFN0118032.1	2030800	g99451	i0	47.6	0.594339622641509	42	22	59.4	0	131	6	198	239	MFN0118032.1 hypothetical protein [Elusimicrobiota bacterium]	diamond	126	47.4	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
31772099	31772099	PRJEB64798_P_NODE_222237_length_161_cov_16.696429_g220471_i0	PRJEB64798	222237	161	16.696429	26.88125069	Endomicrobium sp.	2027285	Bacteria	Bacteria	50.8	4.2e-6	NR	MDR2192415.1	2027285	g220471	i0	78.6	0.782608695652174	42	9	78.3	0	159	34	73	114	MDR2192415.1 peptide chain release factor-like protein [Endomicrobium sp.]	diamond	126	50.8	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales	Endomicrobiaceae	Endomicrobium	Endomicrobium sp.
32493077	32493077	PRJEB64798_P_NODE_252699_length_150_cov_11.376238_g250933_i0	PRJEB64798	252699	150	11.376238	17.064357	Pseudomonadati	3379134	Bacteria	Bacteria	45.4	0.00115	NR	MFH1725188.1	2030800	g250933	i0	82.6	0.92	23	4	46	0	9	77	745	767	MFH1725188.1 LamG-like jellyroll fold domain-containing protein [Elusimicrobiota bacterium]	diamond	138	45.8	0.991266375545852	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobiota bacterium
32524913	32524913	PRJEB64798_P_NODE_225159_length_160_cov_9.720721_g223393_i0	PRJEB64798	225159	160	9.720721	15.5531536	Bacteria	2	Bacteria	Bacteria	50.4	2.21e-5	NR	OGR96077.1	1797939	g223393	i0	50	2.025	36	18	67.5	0	155	48	401	436	OGR96077.1 MAG: hypothetical protein A2016_09210 [Elusimicrobia bacterium GWF2_62_30]	diamond	324	50.4	1	Bacteria	Pseudomonadati	Elusimicrobiota					Elusimicrobia bacterium GWF2_62_30
32531672	32531672	PRJEB64798_P_NODE_191419_length_170_cov_1.446281_g189653_i0	PRJEB64798	191419	170	1.446281	2.4586777	Elusimicrobiaceae bacterium	2735568	Bacteria	Bacteria	44.7	0.00286	NR	MBO4674808.1	2735568	g189653	i0	62.5	0.564705882352941	32	12	56.5	0	6	101	25	56	MBO4674808.1 glycosyltransferase family 2 protein [Elusimicrobiaceae bacterium]	diamond	96	44.7	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae		Elusimicrobiaceae 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);;