metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA703759" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA703759" 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
5787418	5787418	PRJNA703759_P_NODE_11225_length_402_cov_2.176292_g10749_i0	PRJNA703759	11225	402	2.176292	8.74869384	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	129	1.02e-31	NR	MCX5734496.1	2072417	g10749	i0	81.9	1.07462686567164	72	13	53.7	0	185	400	1	72	MCX5734496.1 catalase/peroxidase HPI [Candidatus Methylomirabilota bacterium]	diamond	432	129	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
17262765	17262765	PRJNA703759_P_NODE_47394_length_244_cov_0.912281_g46918_i0	PRJNA703759	47394	244	0.912281	2.22596564	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	134	6.159999999999998e-35	NR	HWN97548.1	2072417	g46918	i0	74.4	1.95491803278689	78	20	95.9	0	10	243	376	453	HWN97548.1 NapC/NirT family cytochrome c [Candidatus Methylomirabilota bacterium]	diamond	477	134	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
29462014	29462014	PRJNA703759_P_NODE_32450_length_258_cov_2.151351_g31974_i0	PRJNA703759	32450	258	2.151351	5.55048558	Bacteria	2	Bacteria	Bacteria	124	6.119999999999999e-32	NR	HWT78709.1	2032687	g31974	i0	71.4	1.96511627906977	84	24	97.7	0	5	256	159	242	HWT78709.1 IS110 family transposase [Candidatus Methylomirabilis sp.]	diamond	507	125	0.992	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.
30536270	30536270	PRJNA703759_P_NODE_36793_length_252_cov_0.865922_g36317_i0	PRJNA703759	36793	252	0.865922	2.18212344	Bacteria	2	Bacteria	Bacteria	51.6	2.87e-5	NR	HXS82037.1	2072417	g36317	i0	50	2.14285714285714	60	28	71.4	1	184	5	1	58	HXS82037.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	540	52	0.992307692307692	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
31042162	31042162	PRJNA703759_P_NODE_46635_length_245_cov_0.906977_g46159_i0	PRJNA703759	46635	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	77.4	5.96e-15	NR	HXS82810.1	2072417	g46159	i0	94.4	4.84897959183674	36	2	44.1	0	138	245	1	36	HXS82810.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	1188	77.8	0.994858611825193	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
31631368	31631368	PRJNA703759_P_NODE_28176_length_273_cov_1.400000_g27700_i0	PRJNA703759	28176	273	1.4	3.822	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	89.4	2.16e-18	NR	HXS81769.1	2072417	g27700	i0	61.5	3.95604395604396	91	34	98.9	1	272	3	133	223	HXS81769.1 cation:proton antiporter [Candidatus Methylomirabilota bacterium]	diamond	1080	89.4	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
31947600	31947600	PRJNA703759_P_NODE_30817_length_264_cov_1.308901_g30341_i0	PRJNA703759	30817	264	1.308901	3.45549864	Candidatus Methylomirabilis sp.	2032687	Bacteria	Bacteria	109	7.999999999999999e-26	NR	HWT79240.1	2032687	g30341	i0	60.2	2	88	34	98.9	1	263	3	270	357	HWT79240.1 zinc-dependent metalloprotease [Candidatus Methylomirabilis sp.]	diamond	528	109	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.
32895239	32895239	PRJNA703759_P_NODE_35360_length_253_cov_0.866667_g34884_i0	PRJNA703759	35360	253	0.866667	2.19266751	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	142	9.25e-40	NR	HMH30993.1	2072417	g34884	i0	80.7	0.984189723320158	83	16	98.4	0	3	251	120	202	HMH30993.1 exodeoxyribonuclease VII large subunit [Candidatus Methylomirabilota bacterium]	diamond	249	142	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);;