metadata: contig_metadata: 14 rows where bioproject = "PRJEB14175" and tax

14 rows where bioproject = "PRJEB14175" 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
25638729	25638729	PRJEB14175_P_NODE_139818_length_290_cov_1.117904_g137551_i0	PRJEB14175	139818	290	1.117904	3.2419216	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	185	6.45e-54	NR	HEY7142076.1	2072417	g137551	i0	91.5	0.972413793103448	94	8	97.2	0	289	8	284	377	HEY7142076.1 ABC transporter substrate-binding protein [Candidatus Methylomirabilota bacterium]	diamond	282	185	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
25638994	25638994	PRJEB14175_P_NODE_145178_length_283_cov_1.054054_g142911_i0	PRJEB14175	145178	283	1.054054	2.98297282	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	147	4.27e-41	NR	HEX6210668.1	2072417	g142911	i0	76.6	0.996466431095406	94	22	99.6	0	1	282	146	239	HEX6210668.1 thiamine pyrophosphate-binding protein [Candidatus Methylomirabilota bacterium]	diamond	282	147	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
25919211	25919211	PRJEB14175_P_NODE_67412_length_450_cov_4.313625_g65154_i0	PRJEB14175	67412	450	4.313625	19.4113125	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	208	2.33e-60	NR	HEX2480629.1	2072417	g65154	i0	89	0.786666666666667	118	13	78.7	0	435	82	215	332	HEX2480629.1 elongation factor G [Candidatus Methylomirabilota bacterium]	diamond	354	208	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
26049620	26049620	PRJEB14175_P_NODE_195533_length_232_cov_1.099415_g193266_i0	PRJEB14175	195533	232	1.099415	2.5506428	uncultured Methylomirabilota bacterium	991135	Bacteria	Bacteria	176	1.18e-39	NTclustered	gi\|2874253892\|emb\|OY970067.1\|	991135	g193266	i0	83.077	4.74137931034483	195	31	84	2	6	199	5092821	5093014	MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1	blastn	1100	176	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					uncultured Methylomirabilota bacterium
26188190	26188190	PRJEB14175_P_NODE_252054_length_203_cov_0.901408_g249786_i0	PRJEB14175	252054	203	0.901408	1.82985824	Bacteria	2	Bacteria	Bacteria	133	5.79e-36	NR	HXF74626.1	2072417	g249786	i0	97	15.8423645320197	67	2	99	0	1	201	82	148	HXF74626.1 MoxR family ATPase [Candidatus Methylomirabilota bacterium]	diamond	3216	133	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
26291376	26291376	PRJEB14175_P_NODE_62470_length_469_cov_1.377451_g60214_i0	PRJEB14175	62470	469	1.377451	6.46024519	Pseudomonadati	3379134	Bacteria	Bacteria	177	1.32e-53	NR	HVG82719.1	2072417	g60214	i0	95.9	1.25373134328358	98	4	62.7	0	467	174	52	149	HVG82719.1 ribosome recycling factor [Candidatus Methylomirabilota bacterium]	diamond	588	177	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
32978469	32978469	PRJEB14175_P_NODE_46875_length_545_cov_4.783058_g44649_i0	PRJEB14175	46875	545	4.783058	26.0676661	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	152	2.97e-41	NR	HEU5320258.1	2072417	g44649	i0	58.6	0.798165137614679	145	60	79.8	0	446	12	1	145	HEU5320258.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	435	152	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33028689	33028689	PRJEB14175_P_NODE_193708_length_233_cov_2.162791_g191441_i0	PRJEB14175	193708	233	2.162791	5.03930303	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	43.9	0.0127	NR	HME94093.1	2072417	g191441	i0	51.9	1.33905579399142	52	20	61.8	3	90	233	332	382	HME94093.1 phospholipase D-like domain-containing protein [Candidatus Methylomirabilota bacterium]	diamond	312	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33041890	33041890	PRJEB14175_P_NODE_103028_length_351_cov_4.272414_g100762_i0	PRJEB14175	103028	351	4.272414	14.99617314	Bacteria candidate phyla	1783234	Bacteria	Bacteria	92	1.84e-19	NR	HEY4719234.1	2032687	g100762	i0	92	5.73504273504274	50	4	42.7	0	331	182	167	216	HEY4719234.1 protease modulator HflC [Candidatus Methylomirabilis sp.]	diamond	2013	92.8	0.991379310344828	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.
33062792	33062792	PRJEB14175_P_NODE_199261_length_229_cov_1.142857_g196994_i0	PRJEB14175	199261	229	1.142857	2.61714253	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	43.5	0.0121	NR	HEX3178169.1	2072417	g196994	i0	37.9	2.21397379912664	66	41	86.5	0	24	221	2	67	HEX3178169.1 phosphatase PAP2 family protein [Candidatus Methylomirabilota bacterium]	diamond	507	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33079975	33079975	PRJEB14175_P_NODE_210974_length_220_cov_1.534591_g208707_i0	PRJEB14175	210974	220	1.534591	3.3761002	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	52	1.44e-5	NR	HET9490698.1	2072417	g208707	i0	49	0.695454545454545	51	26	69.5	0	154	2	2	52	HET9490698.1 tripartite tricarboxylate transporter substrate binding protein [Candidatus Methylomirabilota bacterium]	diamond	153	52	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33113472	33113472	PRJEB14175_P_NODE_150679_length_276_cov_1.776744_g148412_i0	PRJEB14175	150679	276	1.776744	4.90381344	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	119	4.51e-30	NR	HUG63459.1	2072417	g148412	i0	72.5	0.869565217391304	80	22	87	0	262	23	185	264	HUG63459.1 Gfo/Idh/MocA family oxidoreductase [Candidatus Methylomirabilota bacterium]	diamond	240	119	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33131336	33131336	PRJEB14175_P_NODE_227815_length_209_cov_0.864865_g225547_i0	PRJEB14175	227815	209	0.864865	1.80756785	Candidatus Methylomirabilales bacterium	3159508	Bacteria	Bacteria	81.3	1.55e-17	NR	MFQ5658478.1	3159508	g225547	i0	60.3	1.04784688995215	73	24	97.6	1	5	208	45	117	MFQ5658478.1 FG-GAP repeat domain-containing protein [Candidatus Methylomirabilales bacterium]	diamond	219	81.3	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales			Candidatus Methylomirabilales bacterium
33178828	33178828	PRJEB14175_P_NODE_262656_length_199_cov_2.253623_g260388_i0	PRJEB14175	262656	199	2.253623	4.48470977	Bacteria	2	Bacteria	Bacteria	45.4	8.54e-4	NR	HYB42500.1	2032687	g260388	i0	77.4	0.934673366834171	31	7	46.7	0	86	178	1	31	HYB42500.1 large conductance mechanosensitive channel protein MscL [Candidatus Methylomirabilis sp.]	diamond	186	45.8	0.991266375545852	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.

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