metadata: contig_metadata: 14 rows where bioproject = "PRJNA1233465", tax_clade = "Bacteria candidate phyla" and tax

14 rows where bioproject = "PRJNA1233465", 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
32931965	32931965	PRJNA1233465a_S_NODE_96809_length_232_cov_1.393443_g95535_i0	PRJNA1233465	96809	232	1.393443	3.23278776	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	43.5	0.0179	NR	HTZ32492.1	2072417	g95535	i0	41.2	0.879310344827586	68	38	86.6	2	232	32	518	584	HTZ32492.1 CusA/CzcA family heavy metal efflux RND transporter [Candidatus Methylomirabilota bacterium]	diamond	204	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
32968091	32968091	PRJNA1233465e_S_NODE_90130_length_201_cov_1.342105_g88820_i0	PRJNA1233465	90130	201	1.342105	2.69763105	Candidatus Methylomirabilis sp.	2032687	Bacteria	Bacteria	67.4	3.41e-11	NR	HXJ80615.1	2032687	g88820	i0	74.4	1.28358208955224	43	11	64.2	0	72	200	268	310	HXJ80615.1 IS110 family transposase [Candidatus Methylomirabilis sp.]	diamond	258	67.4	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.
32968830	32968830	PRJNA1233465f_S_NODE_66146_length_284_cov_3.800000_g63866_i0	PRJNA1233465	66146	284	3.8	10.792	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	112	1.55e-28	NR	HWP77306.1	2072417	g63866	i0	65.9	2.69366197183099	85	29	89.8	0	30	284	7	91	HWP77306.1 AzlC family ABC transporter permease [Candidatus Methylomirabilota bacterium]	diamond	765	112	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33036049	33036049	PRJNA1233465e_S_NODE_7412_length_567_cov_2.847490_g6237_i0	PRJNA1233465	7412	567	2.84749	16.1452683	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	108	1.86e-25	NR	HEU5192990.1	2072417	g6237	i0	67.5	1.22751322751323	77	25	40.7	0	563	333	155	231	HEU5192990.1 AzlC family ABC transporter permease [Candidatus Methylomirabilota bacterium]	diamond	696	108	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33043496	33043496	PRJNA1233465f_S_NODE_190612_length_181_cov_2.166667_g188332_i0	PRJNA1233465	190612	181	2.166667	3.92166727	Pseudomonadati	3379134	Bacteria	Bacteria	117	5.96e-29	NR	HTO85609.1	2072417	g188332	i0	98.3	6.84530386740331	59	1	97.8	0	3	179	682	740	HTO85609.1 sarcosine oxidase subunit alpha family protein [Candidatus Methylomirabilota bacterium]	diamond	1239	117	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33060355	33060355	PRJNA1233465e_S_NODE_164317_length_161_cov_1.366071_g163007_i0	PRJNA1233465	164317	161	1.366071	2.19937431	Pseudomonadati	3379134	Bacteria	Bacteria	103	6.2499999999999996e-24	NR	HTO85609.1	2072417	g163007	i0	94.3	2.96273291925466	53	3	98.8	0	2	160	696	748	HTO85609.1 sarcosine oxidase subunit alpha family protein [Candidatus Methylomirabilota bacterium]	diamond	477	104	0.990384615384615	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33068750	33068750	PRJNA1233465b_S_NODE_235501_length_195_cov_1.582192_g233816_i0	PRJNA1233465	235501	195	1.582192	3.0852744	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	67.8	2.27e-11	NR	HEY3066351.1	2072417	g233816	i0	51.6	4.81538461538462	64	31	98.5	0	193	2	247	310	HEY3066351.1 trypsin-like peptidase domain-containing protein [Candidatus Methylomirabilota bacterium]	diamond	939	67.8	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33120531	33120531	PRJNA1233465d_S_NODE_21055_length_353_cov_1.319079_g19944_i0	PRJNA1233465	21055	353	1.319079	4.65634887	Candidatus Methylomirabilales bacterium	3159508	Bacteria	Bacteria	52.4	1.74e-5	NR	MFQ5846382.1	3159508	g19944	i0	40.5	1.36827195467422	79	41	66.3	3	2	235	91	164	MFQ5846382.1 hypothetical protein [Candidatus Methylomirabilales bacterium]	diamond	483	52.4	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales			Candidatus Methylomirabilales bacterium
33122098	33122098	PRJNA1233465f_S_NODE_67039_length_283_cov_1.405983_g64759_i0	PRJNA1233465	67039	283	1.405983	3.97893189	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	122	4.009999999999999e-34	NR	HTZ31624.1	2072417	g64759	i0	87	0.731448763250883	69	9	73.1	0	56	262	1	69	HTZ31624.1 alkene reductase [Candidatus Methylomirabilota bacterium]	diamond	207	122	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33136739	33136739	PRJNA1233465a_S_NODE_74375_length_256_cov_1.314010_g73101_i0	PRJNA1233465	74375	256	1.31401	3.3638656	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	55.1	2.06e-6	NR	MDE2179886.1	2072417	g73101	i0	39.3	1.04296875	89	49	99.6	4	1	255	60	147	MDE2179886.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	267	55.1	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33145704	33145704	PRJNA1233465d_S_NODE_5631_length_593_cov_2.237132_g4646_i0	PRJNA1233465	5631	593	2.237132	13.26619276	Bacteria	2	Bacteria	Bacteria	116	1.87e-28	NR	HEU5192990.1	2072417	g4646	i0	66.3	1.68465430016863	83	28	42	0	591	343	149	231	HEU5192990.1 AzlC family ABC transporter permease [Candidatus Methylomirabilota bacterium]	diamond	999	116	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33153993	33153993	PRJNA1233465b_S_NODE_175664_length_221_cov_1.482558_g173979_i0	PRJNA1233465	175664	221	1.482558	3.27645318	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	85.1	2.23e-17	NR	HZP36136.1	2072417	g173979	i0	66.7	1.68325791855204	63	21	85.5	0	221	33	316	378	HZP36136.1 5-(carboxyamino)imidazole ribonucleotide synthase [Candidatus Methylomirabilota bacterium]	diamond	372	85.1	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
33156223	33156223	PRJNA1233465f_S_NODE_80296_length_262_cov_2.314554_g78016_i0	PRJNA1233465	80296	262	2.3145539999999998	6.06413148	Candidatus Methylomirabilis sp.	2032687	Bacteria	Bacteria	60.8	1.74e-8	NR	HXJ80615.1	2032687	g78016	i0	73.7	0.858778625954199	38	10	43.5	0	114	1	268	305	HXJ80615.1 IS110 family transposase [Candidatus Methylomirabilis sp.]	diamond	225	60.8	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.
33172309	33172309	PRJNA1233465e_S_NODE_135512_length_170_cov_2.107438_g134202_i0	PRJNA1233465	135512	170	2.107438	3.5826446	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	86.3	1.07e-18	NR	MEE8242988.1	2072417	g134202	i0	63.6	3.91764705882353	55	20	97.1	0	1	165	141	195	MEE8242988.1 metallophosphoesterase [Candidatus Methylomirabilota bacterium]	diamond	666	86.3	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);;