metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax

5 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Candidatus Levyibacteriota"

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
29055058	29055058	PRJEB64798_P_NODE_243048_length_154_cov_3.666667_g241282_i0	PRJEB64798	243048	154	3.666667	5.64666718	Candidatus Levybacteria bacterium RIFOXYC1_FULL_4	2052151	Bacteria	Bacteria	55.5	2.24e-8	NR	OGH52707.1	1798641	g241282	i0	92.3	0.506493506493506	26	2	50.6	0	73	150	58	83	OGH52707.1 MAG: hypothetical protein A2423_03340 [Candidatus Levybacteria bacterium RIFOXYC1_FULL_40_10]	diamond	78	55.5	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levybacteria bacterium RIFOXYC1_FULL_40_10
31045100	31045100	PRJEB64798_P_NODE_140995_length_193_cov_2.402778_g139229_i0	PRJEB64798	140995	193	2.402778	4.63736154	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	45.8	2.47e-4	NR	MBI2195775.1	2052151	g139229	i0	80.8	0.404145077720207	26	5	40.4	0	147	70	1	26	MBI2195775.1 hypothetical protein [Candidatus Levyibacteriota bacterium]	diamond	78	45.8	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levyibacteriota bacterium
32144915	32144915	PRJEB64798_P_NODE_131758_length_197_cov_10.135135_g129992_i0	PRJEB64798	131758	197	10.135135	19.96621595	Bacteria	2	Bacteria	Bacteria	55.5	1.66e-7	NR	KKQ29725.1	1618452	g129992	i0	50	4.81218274111675	64	29	97.5	1	2	193	36	96	KKQ29725.1 MAG: hypothetical protein US43_C0003G0004 [Candidatus Levybacteria bacterium GW2011_GWA1_37_16]	diamond	948	55.5	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levybacteria bacterium GW2011_GWA1_37_16
32247177	32247177	PRJEB64798_P_NODE_83038_length_213_cov_7.689024_g81272_i0	PRJEB64798	83038	213	7.689024	16.37762112	Candidatus Levybacteria bacterium RIFCSPHIGHO2_12_FULL_37_9	1798609	Bacteria	Bacteria	106	2.6799999999999998e-25	NR	OGH30382.1	1798609	g81272	i0	78.3	0.971830985915493	69	14	97.2	1	209	3	69	136	OGH30382.1 MAG: hypothetical protein A3E40_01035 [Candidatus Levybacteria bacterium RIFCSPHIGHO2_12_FULL_37_9]	diamond	207	106	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levybacteria bacterium RIFCSPHIGHO2_12_FULL_37_9
32783350	32783350	PRJEB64798_P_NODE_171080_length_178_cov_4.379845_g169314_i0	PRJEB64798	171080	178	4.379845	7.7961241	Candidatus Levybacteria bacterium RIFOXYC1_FULL_4	2052151	Bacteria	Bacteria	58.5	1.82e-9	NR	OGH52707.1	1798641	g169314	i0	69	0.707865168539326	42	13	70.8	0	128	3	34	75	OGH52707.1 MAG: hypothetical protein A2423_03340 [Candidatus Levybacteria bacterium RIFOXYC1_FULL_40_10]	diamond	126	58.5	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levybacteria bacterium RIFOXYC1_FULL_40_10

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