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

8 rows where bioproject = "PRJNA642647" 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_species
17736483	17736483	PRJNA642647_P_NODE_5994_length_156_cov_1.151261_g5944_i0	PRJNA642647	5994	156	1.151261	1.79596716	Bacteria	2	Bacteria	Bacteria	176	7.31e-40	NTclustered	gi\|2874253993\|emb\|OY970318.1\|	179883	g5944	i0	92.683	46.2628205128205	123	8	79	1	31	153	472528	472649	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04716.bin.c.3 genome assembly, chromosome: 1	blastn	7217	176	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			uncultured Candidatus Saccharibacteria bacterium
28849551	28849551	PRJNA642647_P_NODE_5208_length_166_cov_2.426357_g5158_i0	PRJNA642647	5208	166	2.426357	4.02775262	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	61.6	9.4e-10	NR	MBA3678603.1	2026720	g5158	i0	47.9	1.31927710843373	73	19	97.6	2	162	1	53	125	MBA3678603.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	219	61.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
29070953	29070953	PRJNA642647_P_NODE_6288_length_152_cov_3.426087_g6238_i0	PRJNA642647	6288	152	3.426087	5.20765224	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	57	8.56e-8	NR	HUD10272.1	2973664	g6238	i0	46	0.986842105263158	50	27	98.7	0	2	151	190	239	HUD10272.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	150	57	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadales bacterium
29259998	29259998	PRJNA642647_P_NODE_1729_length_264_cov_1.713656_g1679_i0	PRJNA642647	1729	264	1.713656	4.52405184	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	67.8	7.79e-11	NR	QQS65395.1	2026720	g1679	i0	49.4	0.897727272727273	79	37	89.8	3	264	28	1878	1953	QQS65395.1 MAG: collagen-like protein [Candidatus Saccharibacteria bacterium]	diamond	237	67.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
30378304	30378304	PRJNA642647_P_NODE_652_length_444_cov_2.945946_g603_i0	PRJNA642647	652	444	2.945946	13.08000024	Bacteria	2	Bacteria	Bacteria	115	1.1300000000000002e-27	NR	MDB5184375.1	2026720	g603	i0	51.5	1.41216216216216	103	47	68.2	2	320	18	113	214	MDB5184375.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	627	115	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
32053389	32053389	PRJNA642647_P_NODE_1098_length_338_cov_2.564784_g1048_i0	PRJNA642647	1098	338	2.564784	8.66896992	Bacteria	2	Bacteria	Bacteria	116	1.58e-28	NR	MDB5184375.1	2026720	g1048	i0	52.4	1.85502958579882	103	46	89.6	2	320	18	113	214	MDB5184375.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	627	116	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
32072807	32072807	PRJNA642647_P_NODE_3858_length_182_cov_4.413793_g3808_i0	PRJNA642647	3858	182	4.413793	8.03310326	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	42	0.0306	NR	HEU5187356.1	2973664	g3808	i0	48.5	0.543956043956044	33	17	54.4	0	1	99	73	105	HEU5187356.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	99	42	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadales bacterium
32136167	32136167	PRJNA642647_P_NODE_5658_length_160_cov_1.747967_g5608_i0	PRJNA642647	5658	160	1.747967	2.7967472	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	40	0.0173	NR	MCA9312891.1	2026720	g5608	i0	46.7	0.84375	45	24	84.4	0	140	6	5	49	MCA9312891.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	135	40	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);;