metadata: contig_metadata: 15 rows where bioproject = "PRJNA1120060", tax_clade = "Bacteria candidate phyla" and tax

15 rows where bioproject = "PRJNA1120060", 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
4854329	4854329	PRJNA1120060_P_NODE_2721204_length_248_cov_0.891429_g2703121_i0	PRJNA1120060	2721204	248	0.891429	2.21074392	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	135	1.61e-39	NR	HVG82124.1	2072417	g2703121	i0	87.7	0.786290322580645	65	8	78.6	0	196	2	1	65	HVG82124.1 UBP-type zinc finger domain-containing protein [Candidatus Methylomirabilota bacterium]	diamond	195	135	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
14287067	14287067	PRJNA1120060_P_NODE_3002252_length_240_cov_14.047904_g2984154_i0	PRJNA1120060	3002252	240	14.047904	33.7149696	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	141	2.9199999999999996e-37	NR	HZN51904.1	2072417	g2984154	i0	83.3	3.9	78	13	97.5	0	2	235	378	455	HZN51904.1 phosphoketolase family protein [Candidatus Methylomirabilota bacterium]	diamond	936	141	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
23205434	23205434	PRJNA1120060_P_NODE_2553339_length_252_cov_1.966480_g2535264_i0	PRJNA1120060	2553339	252	1.96648	4.9555296	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	156	4.6699999999999985e-43	NR	HZO39986.1	2072417	g2535264	i0	94	0.988095238095238	83	5	98.8	0	3	251	240	322	HZO39986.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	249	156	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
27386077	27386077	PRJNA1120060_P_NODE_498603_length_367_cov_1.544218_g480988_i0	PRJNA1120060	498603	367	1.544218	5.66728006	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	45.1	0.0158	NR	MBP2670103.1	2072417	g480988	i0	35.6	0.596730245231608	73	45	58	1	34	246	54	126	MBP2670103.1 exported protein of unknown function [Candidatus Methylomirabilota bacterium]	diamond	219	45.1	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
27386276	27386276	PRJNA1120060_P_NODE_878423_length_312_cov_9.556485_g860495_i0	PRJNA1120060	878423	312	9.556485	29.8162332	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	112	2.83e-26	NR	HWN96983.1	2072417	g860495	i0	98	1.44230769230769	50	1	48.1	0	311	162	335	384	HWN96983.1 CehA/McbA family metallohydrolase [Candidatus Methylomirabilota bacterium]	diamond	450	112	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
27858354	27858354	PRJNA1120060_P_NODE_2073585_length_270_cov_1.192893_g2055548_i0	PRJNA1120060	2073585	270	1.192893	3.2208111	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	53.5	2.42e-6	NR	MBW8004627.1	2072417	g2055548	i0	36.2	4.58888888888889	69	44	76.7	0	51	257	71	139	MBW8004627.1 ribonuclease HI family protein [Candidatus Methylomirabilota bacterium]	diamond	1239	53.5	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
28774636	28774636	PRJNA1120060_P_NODE_3029227_length_239_cov_3.879518_g3011127_i0	PRJNA1120060	3029227	239	3.879518	9.27204802	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	42	0.0146	NR	HET7340088.1	2072417	g3011127	i0	37.9	0.828451882845188	66	30	69	2	191	27	24	89	HET7340088.1 DUF4115 domain-containing protein [Candidatus Methylomirabilota bacterium]	diamond	198	42	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
29216119	29216119	PRJNA1120060_P_NODE_1743609_length_283_cov_2.076190_g1725601_i0	PRJNA1120060	1743609	283	2.07619	5.8756177	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	43.1	0.038	NR	MBI2454798.1	2072417	g1725601	i0	34.6	0.826855123674912	78	35	65.7	3	61	246	2	79	MBI2454798.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	234	43.1	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
29499831	29499831	PRJNA1120060_P_NODE_1520710_length_292_cov_3.219178_g1502721_i0	PRJNA1120060	1520710	292	3.219178	9.39999976	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	43.9	0.0254	NR	HWC03535.1	2072417	g1502721	i0	38.6	0.585616438356164	57	25	48.3	1	269	129	30	86	HWC03535.1 2-oxoacid:acceptor oxidoreductase family protein [Candidatus Methylomirabilota bacterium]	diamond	171	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
29627364	29627364	PRJNA1120060_P_NODE_887850_length_312_cov_5.820084_g869922_i0	PRJNA1120060	887850	312	5.820084	18.15866208	Candidatus Methylomirabilis sp.	2032687	Bacteria	Bacteria	81.3	1.15e-15	NR	HET7854788.1	2032687	g869922	i0	80.9	0.451923076923077	47	9	45.2	0	311	171	8	54	HET7854788.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Methylomirabilis sp.]	diamond	141	81.3	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.
30448397	30448397	PRJNA1120060_P_NODE_2497373_length_254_cov_1.480663_g2479302_i0	PRJNA1120060	2497373	254	1.480663	3.76088402	Candidatus Methylomirabilis lanthanidiphila	2211376	Bacteria	Bacteria	130	7.64e-33	NR	MBZ0169624.1	2211376	g2479302	i0	72	0.968503937007874	82	23	96.9	0	252	7	452	533	MBZ0169624.1 hypothetical protein [Candidatus Methylomirabilis lanthanidiphila]	diamond	246	130	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis lanthanidiphila
30733447	30733447	PRJNA1120060_P_NODE_876074_length_313_cov_0.812500_g858150_i0	PRJNA1120060	876074	313	0.8125	2.543125	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	43.5	0.0417	NR	HXS83175.1	2072417	g858150	i0	31.1	0.70926517571885	74	41	63.3	2	107	304	84	155	HXS83175.1 glycosyltransferase [Candidatus Methylomirabilota bacterium]	diamond	222	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
31205456	31205456	PRJNA1120060_P_NODE_1625155_length_288_cov_1.823256_g1607158_i0	PRJNA1120060	1625155	288	1.823256	5.25097728	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	44.7	0.0127	NR	HET8578026.1	2072417	g1607158	i0	39.3	0.583333333333333	56	32	56.3	2	283	122	72	127	HET8578026.1 APC family permease [Candidatus Methylomirabilota bacterium]	diamond	168	44.7	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
31585739	31585739	PRJNA1120060_P_NODE_1703576_length_285_cov_1.240566_g1685572_i0	PRJNA1120060	1703576	285	1.240566	3.5356131	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	42.7	0.0492	NR	HET7876847.1	2072417	g1685572	i0	30.5	1	95	60	96.8	2	6	281	43	134	HET7876847.1 DNA polymerase Y family protein [Candidatus Methylomirabilota bacterium]	diamond	285	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
32692800	32692800	PRJNA1120060_P_NODE_2681940_length_249_cov_0.886364_g2663859_i0	PRJNA1120060	2681940	249	0.886364	2.20704636	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	155	4.06e-46	NR	HWC01876.1	2072417	g2663859	i0	96.3	0.987951807228916	82	3	98.8	0	3	248	2	83	HWC01876.1 XRE family transcriptional regulator [Candidatus Methylomirabilota bacterium]	diamond	246	155	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);;