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

8 rows where analysis = "blastn", bioproject = "PRJNA1098727" and tax_clade = "Bacteria candidate phyla"

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
2295289	2295289	PRJNA1098727_P_NODE_8262_length_214_cov_1.563636_g8021_i0	PRJNA1098727	8262	214	1.563636	3.34618104	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	279	7.940000000000001e-71	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g8021	i0	90.61	101.46261682243	213	17	99	3	2	213	150389	150179	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	21713	279	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
4847902	4847902	PRJNA1098727_P_NODE_2984_length_391_cov_2.201754_g2743_i0	PRJNA1098727	2984	391	2.201754	8.60885814	Candidatus Saccharimonadaceae	2171986	Bacteria	Bacteria	601	2.9599999999999992e-167	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g2743	i0	94.615	129.447570332481	390	18	99	3	2	390	906517	906904	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	50614	601	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
6122899	6122899	PRJNA1098727_P_NODE_14245_length_165_cov_1.456897_g14004_i0	PRJNA1098727	14245	165	1.456897	2.40388005	Candidatus Saccharimonadaceae	2171986	Bacteria	Bacteria	257	2.72e-64	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g14004	i0	96.178	127.406060606061	157	6	95	0	8	164	905000	905156	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	21022	257	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
9138726	9138726	PRJNA1098727_P_NODE_6908_length_237_cov_1.101064_g6667_i0	PRJNA1098727	6908	237	1.101064	2.60952168	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	285	1.93e-72	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g6667	i0	88.608	60.7805907172996	237	24	99	3	2	237	451897	451663	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	14405	285	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
11689842	11689842	PRJNA1098727_P_NODE_7450_length_226_cov_3.180791_g7209_i0	PRJNA1098727	7450	226	3.180791	7.18858766	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	339	1.3799999999999998e-88	NTclustered	gi\|1958122490\|gb\|CP065015.1\|	2026720	g7209	i0	93.805	108.986725663717	226	12	99	2	2	226	511688	511464	Candidatus Saccharibacteria bacterium isolate Skiv_18-Q3-R9-52_BAT3C.188_fly chromosome, complete genome	blastn	24631	339	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
12964964	12964964	PRJNA1098727_P_NODE_8751_length_207_cov_1.898734_g8510_i0	PRJNA1098727	8751	207	1.898734	3.93037938	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	342	9.599999999999999e-90	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g8510	i0	97.073	298.371980676329	205	3	99	2	2	206	115976	115775	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	61763	342	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
20612316	20612316	PRJNA1098727_P_NODE_6497_length_245_cov_3.739796_g6256_i0	PRJNA1098727	6497	245	3.739796	9.1625002	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	353	5.41e-93	NTclustered	gi\|1958070929\|gb\|CP064991.1\|	2026720	g6256	i0	92.975	331.044897959184	242	17	99	0	2	243	86580	86339	Candidatus Saccharibacteria bacterium isolate Hirt_18-Q3-R61-65_BAT3C.362_fly chromosome, complete genome	blastn	81106	353	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
21421872	21421872	PRJNA1098727_P_NODE_8537_length_210_cov_3.130435_g8296_i0	PRJNA1098727	8537	210	3.130435	6.5739135	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	331	2.11e-86	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g8296	i0	95.631	134.971428571429	206	9	98	0	5	210	79614	79819	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	28344	331	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);;