metadata: contig_metadata: 5 rows where bioproject = "PRJNA533623" and tax

5 rows where bioproject = "PRJNA533623" 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
9435245	9435245	PRJNA533623_P_NODE_59688_length_255_cov_2.041237_g57908_i0	PRJNA533623	59688	255	2.041237	5.20515435	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	102	3.22e-23	NR	HZS33543.1	2072417	g57908	i0	73.5	1.64705882352941	68	18	80	0	30	233	79	146	HZS33543.1 LamG-like jellyroll fold domain-containing protein [Candidatus Methylomirabilota bacterium]	diamond	420	102	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
29713313	29713313	PRJNA533623_P_NODE_70410_length_219_cov_1.050633_g68629_i0	PRJNA533623	70410	219	1.050633	2.30088627	Pseudomonadati	3379134	Bacteria	Bacteria	111	1.66e-28	NR	HWS97061.1	2032687	g68629	i0	72.6	5	73	20	100	0	219	1	145	217	HWS97061.1 SDR family NAD(P)-dependent oxidoreductase [Candidatus Methylomirabilis sp.]	diamond	1095	112	0.991071428571429	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.
29713314	29713314	PRJNA533623_P_NODE_73410_length_210_cov_1.744966_g71629_i0	PRJNA533623	73410	210	1.744966	3.6644286	Pseudomonadati	3379134	Bacteria	Bacteria	62.4	1.45e-10	NR	HXJ79817.1	2032687	g71629	i0	63	1.25714285714286	46	16	65.7	1	204	67	1	45	HXJ79817.1 VCBS repeat-containing protein [Candidatus Methylomirabilis sp.]	diamond	264	62.4	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.
30535014	30535014	PRJNA533623_P_NODE_76553_length_203_cov_6.140845_g74772_i0	PRJNA533623	76553	203	6.140845	12.46591535	Bacillati	1783272	Bacteria	Bacteria	119	2.43e-29	NR	HEY3100339.1	2072417	g74772	i0	86.2	1.92118226600985	65	9	96.1	0	200	6	323	387	HEY3100339.1 xanthine dehydrogenase family protein molybdopterin-binding subunit [Candidatus Methylomirabilota bacterium]	diamond	390	119	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
31911073	31911073	PRJNA533623_P_NODE_11857_length_683_cov_17.774920_g10236_i0	PRJNA533623	11857	683	17.77492	121.4027036	Candidatus Methylomirabilales bacterium	3159508	Bacteria	Bacteria	223	3.4999999999999996e-69	NR	MFQ5990765.1	3159508	g10236	i0	53.5	3.44363103953148	198	81	85.7	4	24	608	92	281	MFQ5990765.1 pirin family protein [Candidatus Methylomirabilales bacterium]	diamond	2352	223	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales			Candidatus Methylomirabilales 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);;