metadata: contig_metadata: 5 rows where bioproject = "PRJNA760904", tax_clade = "Bacteria candidate phyla" and tax

5 rows where bioproject = "PRJNA760904", 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
4570638	4570638	PRJNA760904_P_NODE_6984_length_333_cov_0.869231_g6927_i0	PRJNA760904	6984	333	0.869231	2.89453923	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	161	2.37e-44	NR	HEY7647972.1	2072417	g6927	i0	69.1	18.8198198198198	110	34	99.1	0	331	2	64	173	HEY7647972.1 L-glutamate gamma-semialdehyde dehydrogenase [Candidatus Methylomirabilota bacterium]	diamond	6267	161	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
5845790	5845790	PRJNA760904_P_NODE_13145_length_262_cov_1.629630_g13088_i0	PRJNA760904	13145	262	1.62963	4.2696306	Bacteria	2	Bacteria	Bacteria	125	2.84e-32	NR	WP_107561991.1	2033718	g13088	i0	63.9	8.63358778625954	83	29	95	1	8	256	179	260	WP_107561991.1 multicopper oxidase domain-containing protein [Candidatus Methylomirabilis limnetica]	diamond	2262	126	0.992063492063492	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis limnetica
27527026	27527026	PRJNA760904_P_NODE_15243_length_250_cov_0.870056_g15186_i0	PRJNA760904	15243	250	0.870056	2.17514	Candidatus Methylomirabilis sp.	2032687	Bacteria	Bacteria	76.3	6.5e-14	NR	HSB73716.1	2032687	g15186	i0	57.4	1.692	68	28	80.4	1	237	37	159	226	HSB73716.1 VIT domain-containing protein [Candidatus Methylomirabilis sp.]	diamond	423	76.3	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.
27653545	27653545	PRJNA760904_P_NODE_4544_length_395_cov_1.521739_g4487_i0	PRJNA760904	4544	395	1.521739	6.01086905	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	121	6.579999999999999e-31	NR	MEE8242988.1	2072417	g4487	i0	46.2	2.66582278481013	117	62	88.1	1	349	2	137	253	MEE8242988.1 metallophosphoesterase [Candidatus Methylomirabilota bacterium]	diamond	1053	121	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
30811386	30811386	PRJNA760904_P_NODE_19874_length_242_cov_0.911243_g19817_i0	PRJNA760904	19874	242	0.911243	2.20520806	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	70.9	3.84e-12	NR	HTO84209.1	2072417	g19817	i0	53.8	2.98760330578512	80	26	99.2	3	2	241	129	197	HTO84209.1 glycine cleavage system aminomethyltransferase GcvT [Candidatus Methylomirabilota bacterium]	diamond	723	70.9	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);;