metadata: contig_metadata: 7 rows where bioproject = "PRJNA1002570", tax_clade = "Bacteria candidate phyla" and tax

7 rows where bioproject = "PRJNA1002570", tax_clade = "Bacteria candidate phyla" 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
26590915	26590915	PRJNA1002570_P_NODE_17981_length_299_cov_2.539823_g17786_i0	PRJNA1002570	17981	299	2.539823	7.59407077	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	77	3.93e-14	NR	HTO83663.1	2072417	g17786	i0	75.5	0.491638795986622	49	12	49.2	0	151	297	84	132	HTO83663.1 lysylphosphatidylglycerol synthase transmembrane domain-containing protein [Candidatus Methylomirabilota bacterium]	diamond	147	77	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
26773839	26773839	PRJNA1002570_P_NODE_16421_length_309_cov_3.067797_g16226_i0	PRJNA1002570	16421	309	3.067797	9.47949273	Bacteria	2	Bacteria	Bacteria	142	7.03e-38	NR	HYE33644.1	2072417	g16226	i0	73.3	9.8252427184466	101	27	98.1	0	307	5	242	342	HYE33644.1 MFS transporter [Candidatus Methylomirabilota bacterium]	diamond	3036	142	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
26907850	26907850	PRJNA1002570_P_NODE_42422_length_243_cov_0.905882_g42227_i0	PRJNA1002570	42422	243	0.905882	2.20129326	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	132	1.3799999999999998e-35	NR	HXG18729.1	2072417	g42227	i0	75	0.987654320987654	80	20	98.8	0	241	2	12	91	HXG18729.1 VOC family protein [Candidatus Methylomirabilota bacterium]	diamond	240	132	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
27097568	27097568	PRJNA1002570_P_NODE_32322_length_261_cov_1.510638_g32127_i0	PRJNA1002570	32322	261	1.510638	3.94276518	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	127	3.5999999999999997e-33	NR	HMB35670.1	2072417	g32127	i0	64.4	2.98850574712644	87	29	97.7	1	4	258	149	235	HMB35670.1 DUF6607 family protein [Candidatus Methylomirabilota bacterium]	diamond	780	127	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
30666286	30666286	PRJNA1002570_P_NODE_44753_length_237_cov_2.707317_g44558_i0	PRJNA1002570	44753	237	2.707317	6.41634129	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	153	1.76e-42	NR	HEX5814410.1	2072417	g44558	i0	94.7	6.70886075949367	76	4	96.2	0	1	228	127	202	HEX5814410.1 amidase [Candidatus Methylomirabilota bacterium]	diamond	1590	153	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
32469091	32469091	PRJNA1002570_P_NODE_36879_length_250_cov_0.870056_g36684_i0	PRJNA1002570	36879	250	0.870056	2.17514	Candidatus Methylomirabilis sp.	2032687	Bacteria	Bacteria	109	2.86e-27	NR	HWS16173.1	2032687	g36684	i0	62.2	0.984	82	31	98.4	0	249	4	43	124	HWS16173.1 class I SAM-dependent methyltransferase [Candidatus Methylomirabilis sp.]	diamond	246	109	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.
32847072	32847072	PRJNA1002570_P_NODE_11160_length_353_cov_5.253571_g10965_i0	PRJNA1002570	11160	353	5.253571	18.54510563	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	62.4	1.06e-8	NR	MEE9538740.1	2072417	g10965	i0	39.8	2.24362606232295	88	48	70.5	2	2	250	181	268	MEE9538740.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	792	62.4	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);;