metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA358049" and tax

4 rows where analysis = "blastn", 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

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