metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA939415" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA939415" 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
6019387	6019387	PRJNA939415_P_NODE_80045_length_254_cov_1.629834_g79623_i0	PRJNA939415	80045	254	1.629834	4.13977836	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	387	5.569999999999998e-103	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g79623	i0	94.466	122.448818897638	253	10	99	4	4	254	150177	150427	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	31102	387	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
8569398	8569398	PRJNA939415_P_NODE_94347_length_242_cov_1.461538_g93925_i0	PRJNA939415	94347	242	1.461538	3.53692196	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	398	2.4299999999999994e-106	NTclustered	gi\|2166692445\|gb\|CP089520.1\|	2899133	g93925	i0	96.281	7.82231404958678	242	9	100	0	1	242	532665	532424	Candidatus Nanosynbacter sp. HMT-352 strain KC1 chromosome, complete genome	blastn	1893	398	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
13668909	13668909	PRJNA939415_P_NODE_32471_length_310_cov_2.772152_g32049_i0	PRJNA939415	32471	310	2.772152	8.5936712	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	278	4.39e-70	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g32049	i0	100	71.2258064516129	150	0	97	0	1	150	137585	137734	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	22080	278	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
18768081	18768081	PRJNA939415_P_NODE_87975_length_247_cov_2.229885_g87553_i0	PRJNA939415	87975	247	2.229885	5.50781595	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	435	1.9e-117	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g87553	i0	98.381	1	247	4	100	0	1	247	431476	431230	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	247	435	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
20042165	20042165	PRJNA939415_P_NODE_43436_length_290_cov_2.013825_g43014_i0	PRJNA939415	43436	290	2.013825	5.8400925	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	226	1.5e-54	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g43014	i0	85.581	9.8551724137931	215	31	74	0	76	290	339488	339274	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	2858	226	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22591781	22591781	PRJNA939415_P_NODE_10278_length_489_cov_2.521635_g9860_i0	PRJNA939415	10278	489	2.521635	12.33079515	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	898	0	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g9860	i0	99.796	109.114519427403	489	1	100	0	1	489	138594	138106	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	53357	898	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
22592196	22592196	PRJNA939415_P_NODE_26038_length_310_cov_4.864979_g25616_i0	PRJNA939415	26038	310	4.864979	15.0814349	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	459	1.46e-124	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g25616	i0	92.258	1	310	24	100	0	1	310	261743	261434	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	310	459	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB

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