metadata: contig_metadata: 8 rows where bioproject = "PRJNA724039" and tax

8 rows where bioproject = "PRJNA724039" and tax_clade = "Bacteria candidate phyla"

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_species
9639676	9639676	PRJNA724039_S_NODE_3328_length_399_cov_35.190608_g3121_i0	PRJNA724039	3328	399	35.190608	140.41052592	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	516	1.13e-141	NTclustered	gi\|2814788338\|emb\|OY761159.2\|	2838779	g3121	i0	90.025	231.022556390977	401	36	100	4	1	399	3737401	3737799	MAG: Candidatus Binatia bacterium isolate a3054953-5fa8-48fb-90a5-e173aac96f7a genome assembly, chromosome: 1	blastn	92178	516	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
10122659	10122659	PRJNA724039_S_NODE_16448_length_157_cov_1.891667_g16241_i0	PRJNA724039	16448	157	1.891667	2.96991719	Bacteria	2	Bacteria	Bacteria	158	2.67e-34	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g16241	i0	85	123.872611464968	160	19	100	4	1	157	427713	427870	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	19448	158	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
10122662	10122662	PRJNA724039_S_NODE_17068_length_154_cov_2.888889_g16861_i0	PRJNA724039	17068	154	2.888889	4.44888906	Pseudomonadati	3379134	Bacteria	Bacteria	121	3.4199999999999996e-23	NTclustered	gi\|2518551991\|emb\|OX638351.1\|	265321	g16861	i0	94.805	135.876623376623	77	4	50	0	1	77	592208	592284	MAG: uncultured Poribacteria bacterium isolate d4690918-7cf6-4b6d-bcb0-07eb3c50a363 genome assembly, chromosome: 1	blastn	20925	121	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria		uncultured Poribacteria bacterium
18562836	18562836	PRJNA724039_S_NODE_14115_length_170_cov_1.744361_g13908_i0	PRJNA724039	14115	170	1.744361	2.9654137	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	171	3.7599999999999997e-38	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g13908	i0	89.051	423.005882352941	137	15	81	0	1	137	813989	814125	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	71911	171	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium
24937808	24937808	PRJNA724039_S_NODE_9780_length_208_cov_4.397661_g9573_i0	PRJNA724039	9780	208	4.397661	9.14713488	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	313	7.569999999999998e-81	NTclustered	gi\|2531949172\|emb\|OY282457.1\|	3036252	g9573	i0	94.146	47.7451923076923	205	12	99	0	2	206	988585	988381	MAG: uncultured Candidatus Binatia bacterium genome assembly, chromosome: 1	blastn	9931	313	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	uncultured Candidatus Binatia bacterium
26830803	26830803	PRJNA724039_S_NODE_17001_length_155_cov_0.983051_g16794_i0	PRJNA724039	17001	155	0.983051	1.52372905	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	79.7	5.23e-17	NR	MFT7452046.1	2052139	g16794	i0	68.6	1.9741935483871	51	16	98.7	0	154	2	19	69	MFT7452046.1 RimJ/RimL family protein N-acetyltransferase [Patescibacteria group bacterium]	diamond	306	79.7	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
29894400	29894400	PRJNA724039_S_NODE_13691_length_173_cov_1.426471_g13484_i0	PRJNA724039	13691	173	1.426471	2.46779483	Candidatus Azambacteria bacterium	2053511	Bacteria	Bacteria	72.4	1.41e-13	NR	HAW91354.1	2053511	g13484	i0	67.9	0.971098265895954	56	18	97.1	0	2	169	163	218	HAW91354.1 AAA family ATPase [Candidatus Azambacteria bacterium]	diamond	168	72.4	1	Bacteria	Bacteria candidate phyla	Candidatus Azamiibacteriota		Candidatus Azambacteria bacterium
30052073	30052073	PRJNA724039_S_NODE_9391_length_213_cov_1.744318_g9184_i0	PRJNA724039	9391	213	1.744318	3.71539734	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	70.9	2.05e-13	NR	HEY2774878.1	2838779	g9184	i0	43	1.11267605633803	79	35	97.2	1	209	3	40	118	HEY2774878.1 DUF2147 domain-containing protein [Candidatus Binatia bacterium]	diamond	237	70.9	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia 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);;