metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA290839" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA290839" 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
1059516	1059516	PRJNA290839_P_NODE_1661_length_236_cov_2.226994_g1640_i0	PRJNA290839	1661	236	2.226994	5.25570584	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	431	2.33e-116	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g1640	i0	99.576	141.033898305085	236	1	100	0	1	236	150518	150283	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	33284	431	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
3610012	3610012	PRJNA290839_P_NODE_703_length_305_cov_2.112069_g682_i0	PRJNA290839	703	305	2.112069	6.44181045	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	558	1.37e-154	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g682	i0	99.672	192.340983606557	305	1	100	0	1	305	152015	151711	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	58664	558	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
4887438	4887438	PRJNA290839_P_NODE_224_length_572_cov_1.555110_g203_i0	PRJNA290839	224	572	1.55511	8.8952292	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	673	0	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g203	i0	89.299	353.45979020979	542	50	94	8	36	572	80043	80581	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	202179	678	0.992625368731563	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
4887439	4887439	PRJNA290839_P_NODE_444_length_388_cov_1.073016_g423_i0	PRJNA290839	444	388	1.073016	4.16330208	Bacteria	2	Bacteria	Bacteria	538	2.329999999999999e-148	NTclustered	gi\|1805658607\|gb\|CP047918.1\|	2572087	g423	i0	91.753	88.4664948453608	388	31	100	1	1	388	140483	140097	Candidatus Saccharibacteria bacterium oral taxon 955 strain FS14P chromosome, complete genome	blastn	34325	538	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
8712177	8712177	PRJNA290839_P_NODE_1007_length_253_cov_1.966667_g986_i0	PRJNA290839	1007	253	1.966667	4.97566751	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	462	8.95e-126	NTclustered	gi\|1842053267\|gb\|CP039998.1\|	713059	g986	i0	99.605	64.703557312253	253	1	100	0	1	253	146864	147116	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM002 chromosome, complete genome	blastn	16370	462	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
11262652	11262652	PRJNA290839_P_NODE_789_length_289_cov_1.421296_g768_i0	PRJNA290839	789	289	1.421296	4.10754544	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	339	1.83e-88	NTclustered	gi\|2874254031\|emb\|OY970356.1\|	179883	g768	i0	87.847	155.757785467128	288	35	99	0	1	288	596753	596466	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1	blastn	45014	340	0.997058823529412	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
11851580	11851580	PRJNA290839_P_NODE_550_length_346_cov_1.139194_g529_i0	PRJNA290839	550	346	1.139194	3.94161124	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	464	3.55e-126	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g529	i0	92.812	108.248554913295	320	23	92	0	27	346	112327	112008	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	37454	464	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
15675640	15675640	PRJNA290839_P_NODE_733_length_299_cov_1.327434_g712_i0	PRJNA290839	733	299	1.327434	3.96902766	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	553	6.25e-153	NTclustered	gi\|2166692445\|gb\|CP089520.1\|	2899133	g712	i0	100	344.501672240803	299	0	100	0	1	299	75939	75641	Candidatus Nanosynbacter sp. HMT-352 strain KC1 chromosome, complete genome	blastn	103006	553	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-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);;