metadata: contig_metadata: 10 rows where bioproject = "PRJNA382357", tax_clade = "Bacteria candidate phyla" and tax

10 rows where bioproject = "PRJNA382357", 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
403056	403056	PRJNA382357_P_NODE_154241_length_202_cov_5.368794_g153502_i0	PRJNA382357	154241	202	5.368794	10.84496388	Bacteria	2	Bacteria	Bacteria	83.6	3.33e-17	NR	HTZ33457.1	2072417	g153502	i0	88.6	5.22772277227723	44	5	65.3	0	188	57	120	163	HTZ33457.1 MoxR family ATPase [Candidatus Methylomirabilota bacterium]	diamond	1056	83.6	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
14433483	14433483	PRJNA382357_P_NODE_97852_length_244_cov_4.737705_g97113_i0	PRJNA382357	97852	244	4.737705	11.5600002	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	122	1.3099999999999998e-31	NR	HEX6210258.1	2072417	g97113	i0	82.7	5.84016393442623	75	10	92.2	1	244	20	202	273	HEX6210258.1 inorganic phosphate transporter [Candidatus Methylomirabilota bacterium]	diamond	1425	122	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
26807296	26807296	PRJNA382357_P_NODE_68641_length_285_cov_4.125000_g67902_i0	PRJNA382357	68641	285	4.125	11.75625	Pseudomonadati	3379134	Bacteria	Bacteria	71.2	5.7e-12	NR	HXA83316.1	2072417	g67902	i0	68.8	2.37894736842105	48	15	50.5	0	2	145	362	409	HXA83316.1 FAD/NAD(P)-binding protein [Candidatus Methylomirabilota bacterium]	diamond	678	71.2	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
26948408	26948408	PRJNA382357_P_NODE_171262_length_168_cov_15.448598_g170523_i0	PRJNA382357	171262	168	15.448598	25.95364464	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	65.1	1.43e-10	NR	HXA81940.1	2072417	g170523	i0	78	0.732142857142857	41	9	73.2	0	24	146	182	222	HXA81940.1 DMT family transporter [Candidatus Methylomirabilota bacterium]	diamond	123	65.1	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
29050080	29050080	PRJNA382357_P_NODE_57968_length_307_cov_5.495935_g57229_i0	PRJNA382357	57968	307	5.495935	16.87252045	Pseudomonadati	3379134	Bacteria	Bacteria	163	3.39e-48	NR	HYA98035.1	2072417	g57229	i0	95.1	4.71986970684039	81	4	79.2	0	39	281	153	233	HYA98035.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	1449	164	0.99390243902439	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
29428633	29428633	PRJNA382357_P_NODE_96729_length_246_cov_0.837838_g95990_i0	PRJNA382357	96729	246	0.837838	2.06108148	Pseudomonadati	3379134	Bacteria	Bacteria	99.8	1.5e-23	NR	HTZ31423.1	2072417	g95990	i0	86.5	1.90243902439024	52	7	63.4	0	158	3	86	137	HTZ31423.1 prolipoprotein diacylglyceryl transferase family protein [Candidatus Methylomirabilota bacterium]	diamond	468	100	0.998	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
29601054	29601054	PRJNA382357_P_NODE_167550_length_178_cov_47.888889_g166811_i0	PRJNA382357	167550	178	47.888889	85.24222242	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	68.9	8.73e-12	NR	HTZ31266.1	2072417	g166811	i0	75.7	0.623595505617977	37	9	62.4	0	8	118	268	304	HTZ31266.1 radical SAM protein [Candidatus Methylomirabilota bacterium]	diamond	111	68.9	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
31623617	31623617	PRJNA382357_P_NODE_131476_length_213_cov_1.710526_g130737_i0	PRJNA382357	131476	213	1.710526	3.64342038	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	86.7	1.11e-19	NR	HTZ31017.1	2072417	g130737	i0	73.2	0.788732394366197	56	15	78.9	0	13	180	84	139	HTZ31017.1 CoA-binding protein [Candidatus Methylomirabilota bacterium]	diamond	168	86.7	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
32478149	32478149	PRJNA382357_P_NODE_64479_length_293_cov_4.969828_g63740_i0	PRJNA382357	64479	293	4.969828	14.56159604	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	45.1	0.0101	NR	HYE32127.1	2072417	g63740	i0	36.4	0.675767918088737	66	33	58.4	2	201	31	240	305	HYE32127.1 phage terminase large subunit [Candidatus Methylomirabilota bacterium]	diamond	198	45.1	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
32652406	32652406	PRJNA382357_P_NODE_90000_length_253_cov_52.531250_g89261_i0	PRJNA382357	90000	253	52.53125	132.9040625	Bacteria candidate phyla	1783234	Bacteria	Bacteria	103	2.2299999999999998e-23	NR	HWS95129.1	2032687	g89261	i0	91.9	17.1106719367589	62	5	73.5	0	3	188	744	805	HWS95129.1 CusA/CzcA family heavy metal efflux RND transporter [Candidatus Methylomirabilis sp.]	diamond	4329	104	0.990384615384615	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.

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);;