metadata: contig_metadata: 9 rows where bioproject = "PRJNA745553", tax_clade = "Bacteria candidate phyla" and tax

9 rows where bioproject = "PRJNA745553", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Saccharimonadota"

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
724032	724032	PRJNA745553_S_NODE_1341_length_721_cov_145.149691_g1213_i0	PRJNA745553	1341	721	145.149691	1046.52927211	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	894	0	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g1213	i0	92.742	230.037447988904	620	44	86	1	15	634	667181	667799	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	165857	894	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
2000356	2000356	PRJNA745553_S_NODE_27902_length_233_cov_4.431250_g27707_i0	PRJNA745553	27902	233	4.43125	10.3248125	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	331	2.39e-86	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g27707	i0	94.811	239.124463519313	212	11	91	0	1	212	220105	219894	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	55716	331	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
12203724	12203724	PRJNA745553_S_NODE_24890_length_248_cov_8.205714_g24695_i0	PRJNA745553	24890	248	8.205714	20.35017072	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	265	2.6499999999999997e-66	NTclustered	gi\|1958070929\|gb\|CP064991.1\|	2026720	g24695	i0	88.584	75.7661290322581	219	24	88	1	14	232	87121	87338	Candidatus Saccharibacteria bacterium isolate Hirt_18-Q3-R61-65_BAT3C.362_fly chromosome, complete genome	blastn	18790	265	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
12203749	12203749	PRJNA745553_S_NODE_26630_length_241_cov_5.934524_g26435_i0	PRJNA745553	26630	241	5.934524	14.30220284	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	313	9.01e-81	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g26435	i0	92.342	88.4647302904564	222	13	91	4	10	229	219894	220113	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	21320	313	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
12678276	12678276	PRJNA745553_S_NODE_20750_length_271_cov_6.797980_g20555_i0	PRJNA745553	20750	271	6.79798	18.4225258	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	311	3.71e-80	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g20555	i0	94.118	79.5055350553505	204	12	75	0	12	215	79597	79800	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	21546	311	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
13478175	13478175	PRJNA745553_S_NODE_3471_length_564_cov_6.733198_g3287_i0	PRJNA745553	3471	564	6.733198	37.97523672	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	854	0	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g3287	i0	93.993	1.15070921985816	566	31	99	1	2	564	232003	231438	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	649	854	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
14753225	14753225	PRJNA745553_S_NODE_29752_length_213_cov_12.478571_g29557_i0	PRJNA745553	29752	213	12.478571	26.57935623	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	263	7.95e-66	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g29557	i0	91.667	44.1079812206573	192	13	90	3	23	213	801421	801232	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	9395	263	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28610247	28610247	PRJNA745553_S_NODE_27427_length_236_cov_8.926380_g27232_i0	PRJNA745553	27427	236	8.92638	21.0662568	Bacteria	2	Bacteria	Bacteria	55.8	2.64e-8	NR	TWP16668.1	713054	g27232	i0	70.7	2.00847457627119	41	12	52.1	0	145	23	3	43	TWP16668.1 hypothetical protein EUA72_00305 [TM7 phylum sp. oral taxon 352]	diamond	474	56.2	0.99288256227758	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 352
32497360	32497360	PRJNA745553_S_NODE_5159_length_499_cov_3.124413_g4965_i0	PRJNA745553	5159	499	3.124413	15.59082087	Bacteria	2	Bacteria	Bacteria	46.6	0.0011	NR	TWP16668.1	713054	g4965	i0	59.5	0.961923847695391	42	17	25.3	0	374	499	2	43	TWP16668.1 hypothetical protein EUA72_00305 [TM7 phylum sp. oral taxon 352]	diamond	480	46.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 352

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