metadata: contig_metadata: 9 rows where bioproject = "PRJEB64798" and tax

9 rows where 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
129616	129616	PRJEB64798_P_NODE_81101_length_214_cov_4.666667_g79335_i0	PRJEB64798	81101	214	4.666667	9.98666738	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	167	6.449999999999999e-37	NTclustered	gi\|2874253967\|emb\|OY970292.1\|	2052151	g79335	i0	88.571	82.4485981308411	140	13	64	2	50	186	717449	717588	MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1	blastn	17644	167	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levyibacteriota bacterium
12880231	12880231	PRJEB64798_P_NODE_119631_length_206_cov_12.025478_g117865_i0	PRJEB64798	119631	206	12.025478	24.77248468	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	185	1.7e-42	NTclustered	gi\|2874253967\|emb\|OY970292.1\|	2052151	g117865	i0	83.251	68.6990291262136	203	32	98	2	1	202	718581	718782	MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1	blastn	14152	185	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levyibacteriota bacterium
17980018	17980018	PRJEB64798_P_NODE_244235_length_153_cov_18.326923_g242469_i0	PRJEB64798	244235	153	18.326923	28.04019219	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	167	4.2899999999999995e-37	NTclustered	gi\|2874253967\|emb\|OY970292.1\|	2052151	g242469	i0	87.943	84.6732026143791	141	17	92	0	1	141	719455	719595	MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1	blastn	12955	167	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levyibacteriota bacterium
23079592	23079592	PRJEB64798_P_NODE_183199_length_173_cov_2.717742_g181433_i0	PRJEB64798	183199	173	2.717742	4.70169366	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	231	1.7399999999999998e-56	NTclustered	gi\|2874253967\|emb\|OY970292.1\|	2052151	g181433	i0	90.805	1.00578034682081	174	15	100	1	1	173	718671	718498	MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1	blastn	174	231	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levyibacteriota bacterium
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);;