metadata: contig_metadata: 6 rows where bioproject = "PRJNA591127", tax_clade = "Bacteria candidate phyla" and tax

6 rows where bioproject = "PRJNA591127", tax_clade = "Bacteria candidate phyla" 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
6943172	6943172	PRJNA591127_P_NODE_1506_length_553_cov_2.416667_g1356_i0	PRJNA591127	1506	553	2.416667	13.36416851	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	773	0	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g1356	i0	92.21	103.101265822785	552	34	99	7	5	552	906727	906181	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	57015	773	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
9493474	9493474	PRJNA591127_P_NODE_23668_length_177_cov_1.064286_g23499_i0	PRJNA591127	23668	177	1.064286	1.88378622	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	195	2.35e-45	NTclustered	gi\|1958123529\|gb\|CP065016.1\|	2026720	g23499	i0	87.574	522.988700564972	169	19	94	2	6	172	637822	637990	Candidatus Saccharibacteria bacterium isolate Vibo_18-Q3-R45-57_BAT3C.117_fly chromosome, complete genome	blastn	92569	195	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
17716775	17716775	PRJNA591127_P_NODE_4214_length_353_cov_42.791139_g4046_i0	PRJNA591127	4214	353	42.791139	151.05272067	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	542	1.6199999999999999e-149	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g4046	i0	94.366	253.28045325779	355	16	100	4	1	353	907040	907392	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	89408	542	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
18417033	18417033	PRJNA591127_P_NODE_5795_length_304_cov_4.033708_g5627_i0	PRJNA591127	5795	304	4.033708	12.26247232	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	507	5.03e-139	NTclustered	gi\|1958122490\|gb\|CP065015.1\|	2026720	g5627	i0	96.721	145.717105263158	305	9	100	1	1	304	511365	511669	Candidatus Saccharibacteria bacterium isolate Skiv_18-Q3-R9-52_BAT3C.188_fly chromosome, complete genome	blastn	44298	507	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22242298	22242298	PRJNA591127_P_NODE_7218_length_273_cov_27.292373_g7050_i0	PRJNA591127	7218	273	27.292373	74.50817829	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	435	2.13e-117	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g7050	i0	96.226	292.886446886447	265	10	97	0	4	268	451317	451053	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	79958	435	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
32134603	32134603	PRJNA591127_P_NODE_17458_length_197_cov_2.481250_g17289_i0	PRJNA591127	17458	197	2.48125	4.8880625	Candidatus Microsaccharimonas sossegonensis	2506948	Bacteria	Bacteria	52.4	7.96e-6	NR	RWZ78033.1	2506948	g17289	i0	100	0.380710659898477	25	0	38.1	0	76	2	119	143	RWZ78033.1 MAG: ISL3 family transposase [Candidatus Microsaccharimonas sossegonensis]	diamond	75	52.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Microsaccharimonas	Candidatus Microsaccharimonas sossegonensis

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