metadata: contig_metadata: 6 rows where bioproject = "PRJDB4941", tax_clade = "Bacteria candidate phyla" and tax

6 rows where bioproject = "PRJDB4941", 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_species
3532151	3532151	PRJDB4941_P_NODE_10543_length_346_cov_1.993266_g9775_i0	PRJDB4941	10543	346	1.993266	6.89670036	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	82.8	9.37e-16	NR	HEY2994920.1	2072417	g9775	i0	59.2	0.615606936416185	71	29	61.6	0	344	132	108	178	HEY2994920.1 HlyD family secretion protein [Candidatus Methylomirabilota bacterium]	diamond	213	82.8	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilota bacterium
16587173	16587173	PRJDB4941_P_NODE_24514_length_203_cov_2.740260_g23746_i0	PRJDB4941	24514	203	2.74026	5.5627278	Pseudomonadati	3379134	Bacteria	Bacteria	78.2	4.66e-15	NR	HEV8438168.1	2072417	g23746	i0	65.7	2.88177339901478	67	23	99	0	201	1	55	121	HEV8438168.1 Gfo/Idh/MocA family oxidoreductase [Candidatus Methylomirabilota bacterium]	diamond	585	78.6	0.994910941475827	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilota bacterium
31770839	31770839	PRJDB4941_P_NODE_7217_length_455_cov_2.283251_g6449_i0	PRJDB4941	7217	455	2.283251	10.38879205	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	97.8	1.8899999999999998e-20	NR	HEV8141275.1	2072417	g6449	i0	44.4	0.949450549450549	144	74	94.9	2	1	432	195	332	HEV8141275.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	432	97.8	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilota bacterium
31802326	31802326	PRJDB4941_P_NODE_41937_length_154_cov_2.323810_g41169_i0	PRJDB4941	41937	154	2.32381	3.5786674	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	51.2	1.14e-5	NR	HEV8676577.1	2072417	g41169	i0	56.3	2.88311688311688	48	21	93.5	0	8	151	117	164	HEV8676577.1 iron ABC transporter permease [Candidatus Methylomirabilota bacterium]	diamond	444	51.2	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilota bacterium
32813728	32813728	PRJDB4941_P_NODE_26680_length_194_cov_1.462069_g25912_i0	PRJDB4941	26680	194	1.462069	2.83641386	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	73.9	2.19e-14	NR	MBI4841773.1	2072417	g25912	i0	54.7	0.989690721649485	64	29	99	0	2	193	61	124	MBI4841773.1 VWA domain-containing protein [Candidatus Methylomirabilota bacterium]	diamond	192	73.9	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilota bacterium
32876707	32876707	PRJDB4941_P_NODE_5580_length_552_cov_4.196819_g4817_i0	PRJDB4941	5580	552	4.196819	23.16644088	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	67.4	1.16e-10	NR	HTT33722.1	2072417	g4817	i0	37.4	0.53804347826087	99	59	52.7	2	549	259	32	129	HTT33722.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	297	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);;