metadata: contig_metadata: 5 rows where bioproject = "PRJNA884104" and tax

5 rows where bioproject = "PRJNA884104" 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
2137043	2137043	PRJNA884104_S_NODE_82722_length_243_cov_0.905882_g81979_i0	PRJNA884104	82722	243	0.905882	2.20129326	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g81979	i0	99.588	1	243	1	100	0	1	243	681487	681245	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	243	444	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
27340014	27340014	PRJNA884104_S_NODE_16483_length_495_cov_2.130332_g15745_i0	PRJNA884104	16483	495	2.130332	10.5451434	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	56.2	9.65e-6	NR	MBL8158855.1	2026720	g15745	i0	55	1.43030303030303	60	24	36.4	1	445	266	43	99	MBL8158855.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	708	56.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27971389	27971389	PRJNA884104_S_NODE_69605_length_251_cov_0.865169_g68862_i0	PRJNA884104	69605	251	0.865169	2.17157419	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	73.2	7.9e-13	NR	MDB5186597.1	2026720	g68862	i0	45.1	3.78884462151394	82	44	96.8	1	246	4	640	721	MDB5186597.1 domain containing protein [Candidatus Saccharibacteria bacterium]	diamond	951	73.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31509315	31509315	PRJNA884104_S_NODE_56536_length_278_cov_1.443902_g55793_i0	PRJNA884104	56536	278	1.443902	4.01404756	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	83.2	3.24e-16	NR	HEY4160733.1	2973664	g55793	i0	57.8	4.16546762589928	64	27	69.1	0	197	6	5	68	HEY4160733.1 bifunctional sulfate adenylyltransferase/adenylylsulfate kinase [Candidatus Saccharimonadales bacterium]	diamond	1158	83.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32805081	32805081	PRJNA884104_S_NODE_68840_length_251_cov_0.865169_g68097_i0	PRJNA884104	68840	251	0.865169	2.17157419	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	124	2.9499999999999993e-31	NR	MBN9397907.1	2026720	g68097	i0	73.1	0.932270916334661	78	21	93.2	0	16	249	1	78	MBN9397907.1 type II/IV secretion system protein [Candidatus Saccharibacteria bacterium]	diamond	234	124	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota 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);;