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

8 rows where bioproject = "PRJNA358049" 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	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
3623831	3623831	PRJNA358049_S_NODE_6443_length_243_cov_13.056701_g6395_i0	PRJNA358049	6443	243	13.056701	31.72778343	Candidatus Saccharimonadota	95818	Bacteria	Bacteria	300	7.08e-77	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g6395	i0	92.754	195.267489711934	207	15	85	14	220	115461	115255	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	47450	300	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
10602274	10602274	PRJNA358049_S_NODE_14809_length_174_cov_1.984000_g14761_i0	PRJNA358049	14809	174	1.984	3.45216	Candidatus Minimicrobia naudis	2841263	Bacteria	Bacteria	224	2.93e-54	NTclustered	gi\|2052595119\|gb\|CP076460.1\|	2841263	g14761	i0	91.411	90.4540229885057	163	14	94	12	174	122984	123146	Candidatus Minimicrobia naudis isolate IHU1 chromosome, complete genome	blastn	15739	224	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia naudis
20800279	20800279	PRJNA358049_S_NODE_6737_length_239_cov_1.105263_g6689_i0	PRJNA358049	6737	239	1.105263	2.64157857	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	436	5.0799999999999985e-118	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g6689	i0	99.582	211.008368200837	239	1	100	1	239	111002	111240	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	50431	436	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
23350763	23350763	PRJNA358049_S_NODE_6279_length_246_cov_3.096447_g6231_i0	PRJNA358049	6279	246	3.096447	7.61725962	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g6231	i0	100	72.9674796747967	246	0	100	1	246	111645	111400	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	17950	455	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
26599740	26599740	PRJNA358049_S_NODE_8981_length_212_cov_1.564417_g8933_i0	PRJNA358049	8981	212	1.564417	3.31656404	Candidatus Nanosynbacter sp.	2725945	Bacteria	Bacteria	127	4.46e-35	NR	MBF1037529.1	2725945	g8933	i0	97.1	0.976415094339623	69	2	97.6	4	210	43	111	MBF1037529.1 hypothetical protein [Candidatus Nanosynbacter sp.]	diamond	207	127	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp.
26694894	26694894	PRJNA358049_S_NODE_11301_length_194_cov_1.379310_g11253_i0	PRJNA358049	11301	194	1.37931	2.6758614	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	72.8	3.71e-14	NR	MEJ0072657.1	2026720	g11253	i0	59.3	3.64948453608247	59	24	91.2	16	192	4	62	MEJ0072657.1 HNH endonuclease [Candidatus Saccharibacteria bacterium]	diamond	708	72.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28085464	28085464	PRJNA358049_S_NODE_11545_length_193_cov_1.055556_g11497_i0	PRJNA358049	11545	193	1.055556	2.03722308	Candidatus Nanogingivalis gingivitcus	2171992	Bacteria	Bacteria	123	8.669999999999998e-31	NR	WP_129718745.1	2171992	g11497	i0	100	0.994818652849741	64	0	99.5	192	1	36	99	WP_129718745.1 hypothetical protein [Candidatus Nanogingivalis gingivitcus]	diamond	192	123	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae	Candidatus Nanogingivalis	Candidatus Nanogingivalis gingivitcus
30675045	30675045	PRJNA358049_S_NODE_9293_length_209_cov_1.512500_g9245_i0	PRJNA358049	9293	209	1.5125	3.161125	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	125	1.45e-32	NR	MBF1015493.1	2725942	g9245	i0	95.7	1.98086124401914	69	3	99	3	209	250	318	MBF1015493.1 DNA recombination protein RmuC [Candidatus Nanogingivalaceae bacterium]	diamond	414	125	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae 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);;