metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA493632" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA493632" 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
6846187	6846187	PRJNA493632_P_NODE_709606_length_220_cov_13.401361_g706164_i0	PRJNA493632	709606	220	13.401361	29.4829942	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	329	8.04e-86	NTclustered	gi\|1842053267\|gb\|CP039998.1\|	713059	g706164	i0	94.393	18.2727272727273	214	12	97	0	1	214	394135	393922	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM002 chromosome, complete genome	blastn	4020	329	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
9396220	9396220	PRJNA493632_P_NODE_685328_length_232_cov_8.503145_g681887_i0	PRJNA493632	685328	232	8.503145	19.7272964	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	351	1.8299999999999998e-92	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g681887	i0	95.111	14.5258620689655	225	8	96	2	2	223	275720	275944	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	3370	351	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
10672510	10672510	PRJNA493632_P_NODE_721989_length_208_cov_7.229630_g718547_i0	PRJNA493632	721989	208	7.22963	15.0376304	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	145	2.92e-30	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g718547	i0	86.364	3.80769230769231	132	18	63	0	38	169	1551	1682	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	792	145	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
13215370	13215370	PRJNA493632_P_NODE_319411_length_289_cov_5.250000_g315972_i0	PRJNA493632	319411	289	5.25	15.1725	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	534	2.18e-147	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g315972	i0	100	1.99653979238754	289	0	100	0	1	289	603809	604097	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	577	534	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
15769186	15769186	PRJNA493632_P_NODE_590333_length_245_cov_2.500000_g586892_i0	PRJNA493632	590333	245	2.5	6.125	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	425	1.1299999999999999e-114	NTclustered	gi\|2218410560\|gb\|CP089288.1\|	2899133	g586892	i0	97.959	8.01632653061225	245	5	100	0	1	245	122872	123116	Candidatus Nanosynbacter sp. HMT-352 strain TM7-037 chromosome	blastn	1964	425	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
15769774	15769774	PRJNA493632_P_NODE_625833_length_243_cov_0.905882_g622392_i0	PRJNA493632	625833	243	0.905882	2.20129326	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g622392	i0	99.177	1	243	2	100	0	1	243	611621	611379	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	243	438	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
19593695	19593695	PRJNA493632_P_NODE_665356_length_240_cov_2.095808_g661915_i0	PRJNA493632	665356	240	2.095808	5.0299392	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	411	3.089999999999999e-110	NTclustered	gi\|2218410560\|gb\|CP089288.1\|	2899133	g661915	i0	97.5	7.93333333333333	240	6	100	0	1	240	540494	540733	Candidatus Nanosynbacter sp. HMT-352 strain TM7-037 chromosome	blastn	1904	411	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
19594696	19594696	PRJNA493632_P_NODE_720696_length_209_cov_16.904412_g717254_i0	PRJNA493632	720696	209	16.904412	35.33022108	Candidatus Minimicrobia naudis	2841263	Bacteria	Bacteria	320	4.55e-83	NTclustered	gi\|2052595119\|gb\|CP076460.1\|	2841263	g717254	i0	94.258	8.00478468899522	209	12	100	0	1	209	271555	271763	Candidatus Minimicrobia naudis isolate IHU1 chromosome, complete genome	blastn	1673	320	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia naudis
23420136	23420136	PRJNA493632_P_NODE_662519_length_241_cov_0.857143_g659078_i0	PRJNA493632	662519	241	0.857143	2.06571463	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	292	1.17e-74	NTclustered	gi\|2874253993\|emb\|OY970318.1\|	179883	g659078	i0	88.843	564.410788381743	242	21	98	5	2	238	473360	473600	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04716.bin.c.3 genome assembly, chromosome: 1	blastn	136023	292	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria 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);;