metadata: contig_metadata: 14 rows where bioproject = "PRJNA1098727" and tax

14 rows where bioproject = "PRJNA1098727" 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_order	tax_family	tax_genus	tax_species
211102	211102	PRJNA1098727_P_NODE_14821_length_164_cov_0.904348_g14580_i0	PRJNA1098727	14821	164	0.904348	1.48313072	Bacillati	1783272	Bacteria	Bacteria	84.7	1.55e-17	NR	MFA5460301.1	2053589	g14580	i0	77.4	1.95731707317073	53	12	97	0	162	4	263	315	MFA5460301.1 RNA-guided endonuclease TnpB family protein [Candidatus Paceibacterota bacterium]	diamond	321	85.1	0.995299647473561	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
2295289	2295289	PRJNA1098727_P_NODE_8262_length_214_cov_1.563636_g8021_i0	PRJNA1098727	8262	214	1.563636	3.34618104	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	279	7.940000000000001e-71	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g8021	i0	90.61	101.46261682243	213	17	99	3	2	213	150389	150179	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	21713	279	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
4847902	4847902	PRJNA1098727_P_NODE_2984_length_391_cov_2.201754_g2743_i0	PRJNA1098727	2984	391	2.201754	8.60885814	Candidatus Saccharimonadaceae	2171986	Bacteria	Bacteria	601	2.9599999999999992e-167	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g2743	i0	94.615	129.447570332481	390	18	99	3	2	390	906517	906904	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	50614	601	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
6122899	6122899	PRJNA1098727_P_NODE_14245_length_165_cov_1.456897_g14004_i0	PRJNA1098727	14245	165	1.456897	2.40388005	Candidatus Saccharimonadaceae	2171986	Bacteria	Bacteria	257	2.72e-64	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g14004	i0	96.178	127.406060606061	157	6	95	0	8	164	905000	905156	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	21022	257	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
9138726	9138726	PRJNA1098727_P_NODE_6908_length_237_cov_1.101064_g6667_i0	PRJNA1098727	6908	237	1.101064	2.60952168	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	285	1.93e-72	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g6667	i0	88.608	60.7805907172996	237	24	99	3	2	237	451897	451663	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	14405	285	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
11689842	11689842	PRJNA1098727_P_NODE_7450_length_226_cov_3.180791_g7209_i0	PRJNA1098727	7450	226	3.180791	7.18858766	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	339	1.3799999999999998e-88	NTclustered	gi\|1958122490\|gb\|CP065015.1\|	2026720	g7209	i0	93.805	108.986725663717	226	12	99	2	2	226	511688	511464	Candidatus Saccharibacteria bacterium isolate Skiv_18-Q3-R9-52_BAT3C.188_fly chromosome, complete genome	blastn	24631	339	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
12964964	12964964	PRJNA1098727_P_NODE_8751_length_207_cov_1.898734_g8510_i0	PRJNA1098727	8751	207	1.898734	3.93037938	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	342	9.599999999999999e-90	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g8510	i0	97.073	298.371980676329	205	3	99	2	2	206	115976	115775	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	61763	342	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
20612316	20612316	PRJNA1098727_P_NODE_6497_length_245_cov_3.739796_g6256_i0	PRJNA1098727	6497	245	3.739796	9.1625002	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	353	5.41e-93	NTclustered	gi\|1958070929\|gb\|CP064991.1\|	2026720	g6256	i0	92.975	331.044897959184	242	17	99	0	2	243	86580	86339	Candidatus Saccharibacteria bacterium isolate Hirt_18-Q3-R61-65_BAT3C.362_fly chromosome, complete genome	blastn	81106	353	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
21421872	21421872	PRJNA1098727_P_NODE_8537_length_210_cov_3.130435_g8296_i0	PRJNA1098727	8537	210	3.130435	6.5739135	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	331	2.11e-86	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g8296	i0	95.631	134.971428571429	206	9	98	0	5	210	79614	79819	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	28344	331	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27920401	27920401	PRJNA1098727_P_NODE_14805_length_164_cov_0.904348_g14564_i0	PRJNA1098727	14805	164	0.904348	1.48313072	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	41.6	0.00585	NR	MCK5016727.1	2735830	g14564	i0	44.2	1.68292682926829	43	22	78.7	1	135	7	31	71	MCK5016727.1 hypothetical protein [Candidatus Peribacteraceae bacterium]	diamond	276	41.6	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales			Candidatus Peribacteraceae bacterium
28741420	28741420	PRJNA1098727_P_NODE_9947_length_192_cov_1.811189_g9706_i0	PRJNA1098727	9947	192	1.811189	3.47748288	Candidatus Elulimicrobium humile	2802965	Bacteria	Bacteria	94	1.49e-23	NR	NBP58003.1	2802965	g9706	i0	95.7	0.71875	46	2	71.9	0	55	192	1	46	NBP58003.1 hypothetical protein [Candidatus Elulimicrobium humile]	diamond	138	94	1	Bacteria	Bacteria candidate phyla	Candidatus Elulimicrobiota	Candidatus Elulimicrobia	Candidatus Elulimicrobiales	Candidatus Elulimicrobiaceae	Candidatus Elulimicrobium	Candidatus Elulimicrobium humile
29372931	29372931	PRJNA1098727_P_NODE_15569_length_162_cov_1.380531_g15328_i0	PRJNA1098727	15569	162	1.380531	2.23646022	Candidatus Elulimicrobium humile	2802965	Bacteria	Bacteria	60.5	5.03e-9	NR	NBP58002.1	2802965	g15328	i0	65.9	0.759259259259259	41	14	75.9	0	39	161	237	277	NBP58002.1 hypothetical protein [Candidatus Elulimicrobium humile]	diamond	123	60.5	1	Bacteria	Bacteria candidate phyla	Candidatus Elulimicrobiota	Candidatus Elulimicrobia	Candidatus Elulimicrobiales	Candidatus Elulimicrobiaceae	Candidatus Elulimicrobium	Candidatus Elulimicrobium humile
32272113	32272113	PRJNA1098727_P_NODE_14078_length_166_cov_0.888889_g13837_i0	PRJNA1098727	14078	166	0.888889	1.47555574	Bacteria	2	Bacteria	Bacteria	63.2	6.26e-10	NR	MCA9332305.1	2026720	g13837	i0	81.8	2.3855421686747	33	6	59.6	0	3	101	272	304	MCA9332305.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	396	63.5	0.995275590551181	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32880236	32880236	PRJNA1098727_P_NODE_15420_length_163_cov_0.912281_g15179_i0	PRJNA1098727	15420	163	0.912281	1.48701803	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	42	0.0243	NR	MCK4546319.1	2212470	g15179	i0	37.7	0.975460122699387	53	32	95.7	1	5	160	85	137	MCK4546319.1 PD40 domain-containing protein [Candidatus Eiseniibacteriota bacterium]	diamond	159	42	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota					Candidatus Eiseniibacteriota 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);;