metadata: contig_metadata: 12 rows where bioproject = "PRJEB20058" and tax

12 rows where bioproject = "PRJEB20058" and tax_phylum = "Candidatus Methylomirabilota"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
25649762	25649762	PRJEB20058_P_NODE_124546_length_356_cov_1.111864_g121728_i0	PRJEB20058	124546	356	1.111864	3.95823584	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	181	1.6999999999999998e-53	NR	HEY7653010.1	2072417	g121728	i0	79.5	13.2808988764045	112	23	94.4	0	337	2	28	139	HEY7653010.1 TrpB-like pyridoxal phosphate-dependent enzyme [Candidatus Methylomirabilota bacterium]	diamond	4728	181	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
25654793	25654793	PRJEB20058_P_NODE_25050_length_833_cov_158.484456_g22797_i0	PRJEB20058	25050	833	158.484456	1320.17551848	Bacillati	1783272	Bacteria	Bacteria	221	5.42e-64	NR	HSB73342.1	2032687	g22797	i0	48.3	3.09723889555822	286	118	96.9	4	820	14	103	375	HSB73342.1 APC family permease [Candidatus Methylomirabilis sp.]	diamond	2580	223	0.991031390134529	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.
26473274	26473274	PRJEB20058_P_NODE_56032_length_561_cov_2.468000_g53283_i0	PRJEB20058	56032	561	2.468	13.84548	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	295	1.71e-98	NR	HXG49146.1	2072417	g53283	i0	85	0.855614973262032	160	24	85.6	0	482	3	2	161	HXG49146.1 NAD-dependent deacylase [Candidatus Methylomirabilota bacterium]	diamond	480	295	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
32910626	32910626	PRJEB20058_P_NODE_147681_length_317_cov_2.882812_g144860_i0	PRJEB20058	147681	317	2.882812	9.13851404	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	43.5	0.0476	NR	HKC09529.1	2072417	g144860	i0	32.3	0.936908517350158	99	59	86.1	3	317	45	573	671	HKC09529.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	297	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
32928112	32928112	PRJEB20058_P_NODE_204825_length_253_cov_0.927083_g202001_i0	PRJEB20058	204825	253	0.927083	2.34551999	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	68.6	7.73e-12	NR	HEY4909518.1	2072417	g202001	i0	73.5	0.58102766798419	49	13	58.1	0	148	2	1	49	HEY4909518.1 ORF6N domain-containing protein [Candidatus Methylomirabilota bacterium]	diamond	147	68.6	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
32939936	32939936	PRJEB20058_P_NODE_110889_length_383_cov_2.161491_g108077_i0	PRJEB20058	110889	383	2.161491	8.27851053	Bacteria candidate phyla	1783234	Bacteria	Bacteria	62.8	1.6e-8	NR	HKX03967.1	2072417	g108077	i0	55	2.3420365535248	60	27	47	0	187	366	1	60	HKX03967.1 ISNCY family transposase [Candidatus Methylomirabilota bacterium]	diamond	897	63.2	0.993670886075949	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
32945307	32945307	PRJEB20058_P_NODE_214682_length_246_cov_1.729730_g211858_i0	PRJEB20058	214682	246	1.72973	4.2551358	Candidatus Methylomirabilis sp.	2032687	Bacteria	Bacteria	68.9	8.66e-12	NR	HXJ78354.1	2032687	g211858	i0	43.3	0.817073170731707	67	38	81.7	0	237	37	124	190	HXJ78354.1 glycosyltransferase family A protein [Candidatus Methylomirabilis sp.]	diamond	201	68.9	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.
32945726	32945726	PRJEB20058_P_NODE_66490_length_512_cov_7.822616_g63722_i0	PRJEB20058	66490	512	7.822616	40.05179392	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	52.8	1.85e-4	NR	HEV8530067.1	2072417	g63722	i0	45.1	0.896484375	71	35	41	2	261	52	833	900	HEV8530067.1 DNA polymerase [Candidatus Methylomirabilota bacterium]	diamond	459	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33047257	33047257	PRJEB20058_P_NODE_143597_length_323_cov_3.996183_g140776_i0	PRJEB20058	143597	323	3.996183	12.90767109	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	192	4.49e-58	NR	HEX2500345.1	2072417	g140776	i0	88.1	0.938080495356037	101	12	93.8	0	19	321	116	216	HEX2500345.1 enolase C-terminal domain-like protein [Candidatus Methylomirabilota bacterium]	diamond	303	192	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33110674	33110674	PRJEB20058_P_NODE_181774_length_274_cov_1.718310_g178951_i0	PRJEB20058	181774	274	1.71831	4.7081694	Bacteria	2	Bacteria	Bacteria	158	2.95e-43	NR	HWN96369.1	2072417	g178951	i0	88.1	2.75912408759124	84	10	92	0	22	273	515	598	HWN96369.1 glycoside hydrolase family 2 TIM barrel-domain containing protein [Candidatus Methylomirabilota bacterium]	diamond	756	159	0.993710691823899	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33115897	33115897	PRJEB20058_P_NODE_213271_length_247_cov_1.564516_g210447_i0	PRJEB20058	213271	247	1.564516	3.86435452	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	70.9	4.36e-12	NR	HXS81187.1	2072417	g210447	i0	58.9	0.680161943319838	56	23	68	0	78	245	138	193	HXS81187.1 FAD-dependent oxidoreductase [Candidatus Methylomirabilota bacterium]	diamond	168	70.9	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33149511	33149511	PRJEB20058_P_NODE_122800_length_359_cov_3.734899_g119983_i0	PRJEB20058	122800	359	3.734899	13.40828741	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	141	1.94e-40	NR	HEX2483601.1	2072417	g119983	i0	95.7	0.584958217270195	70	3	58.5	0	28	237	70	139	HEX2483601.1 ABC transporter substrate-binding protein [Candidatus Methylomirabilota bacterium]	diamond	210	141	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota 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);;