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

5 rows where bioproject = "PRJNA312899", 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
11267555	11267555	PRJNA312899_P_NODE_1769_length_1184_cov_22.917181_g183_i2	PRJNA312899	1769	1184	22.917181	271.33942304	Bacteria	2	Bacteria	Bacteria	939	0	NTclustered	gi\|507148395\|ref\|NR_103198.1\|	671143	g183	i2	82.214	888.858108108108	1102	184	92	9	1	1094	2983	1886	Candidatus Methylomirabilis oxyfera 23S ribosomal RNA gene, complete sequence	blastn	1052408	948	0.990506329113924	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis oxygeniifera
27863883	27863883	PRJNA312899_P_NODE_86145_length_167_cov_0.864407_g85703_i0	PRJNA312899	86145	167	0.864407	1.44355969	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	75.9	3.6e-15	NR	HTG41628.1	2072417	g85703	i0	69.8	1.92215568862275	53	16	95.2	0	9	167	1	53	HTG41628.1 HD domain-containing protein [Candidatus Methylomirabilota bacterium]	diamond	321	75.9	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
27927158	27927158	PRJNA312899_P_NODE_7665_length_675_cov_2.678914_g7295_i0	PRJNA312899	7665	675	2.678914	18.0826695	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	293	2.8300000000000003e-97	NR	HTO81012.1	2072417	g7295	i0	65.9	2.92444444444444	217	73	96	1	651	4	1	217	HTO81012.1 methyltransferase [Candidatus Methylomirabilota bacterium]	diamond	1974	293	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
28621894	28621894	PRJNA312899_P_NODE_41947_length_274_cov_7.137778_g41505_i0	PRJNA312899	41947	274	7.137778	19.55751172	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	89	1.64e-18	NR	MCI0372801.1	2072417	g41505	i0	73.3	1.31386861313869	60	16	65.7	0	95	274	3	62	MCI0372801.1 amino acid permease [Candidatus Methylomirabilota bacterium]	diamond	360	89	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
32002548	32002548	PRJNA312899_P_NODE_38318_length_290_cov_2.402490_g37876_i0	PRJNA312899	38318	290	2.40249	6.967221	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	67.4	1.37e-10	NR	HZF00614.1	2072417	g37876	i0	77.8	0.372413793103448	36	8	37.2	0	181	288	14	49	HZF00614.1 AarF/UbiB family protein [Candidatus Methylomirabilota bacterium]	diamond	108	67.4	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);;