metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA694770" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA694770" 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
8328799	8328799	PRJNA694770_P_NODE_85687_length_248_cov_0.880000_g85393_i0	PRJNA694770	85687	248	0.88	2.1824	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	425	1.15e-114	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g85393	i0	97.581	1	248	6	100	0	1	248	562374	562127	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	248	425	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
9603020	9603020	PRJNA694770_P_NODE_45708_length_309_cov_1.305085_g45414_i0	PRJNA694770	45708	309	1.305085	4.03271265	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	106	2.18e-18	NTclustered	gi\|2621706115\|emb\|OY764332.1\|	2053589	g45414	i0	91.026	0.618122977346278	78	7	25	0	10	87	657351	657274	MAG: Candidatus Paceibacterota bacterium isolate afe48dc8-71d9-430e-8630-11ffabd708cb genome assembly, chromosome: 1	blastn	191	106	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
15978604	15978604	PRJNA694770_P_NODE_93473_length_244_cov_0.900585_g93179_i0	PRJNA694770	93473	244	0.900585	2.1974274	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g93179	i0	99.18	1	244	2	100	0	1	244	74180	74423	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	244	440	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
22352306	22352306	PRJNA694770_P_NODE_62078_length_276_cov_2.034483_g61784_i0	PRJNA694770	62078	276	2.034483	5.61517308	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	477	3.529999999999999e-130	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g61784	i0	97.826	1	276	6	100	0	1	276	125348	125623	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	276	477	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
23626437	23626437	PRJNA694770_P_NODE_14019_length_499_cov_1.807512_g13725_i0	PRJNA694770	14019	499	1.807512	9.01948488	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	355	3.32e-93	NTclustered	gi\|2874253817\|emb\|OY969801.1\|	2212470	g13725	i0	79.802	200.817635270541	505	89	99	13	2	499	739940	740438	MAG: Candidatus Eisenbacteria bacterium isolate MFD10007.bin.c.4 genome assembly, chromosome: 1	blastn	100208	355	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota					Candidatus Eiseniibacteriota bacterium
23628400	23628400	PRJNA694770_P_NODE_87299_length_247_cov_0.885057_g87005_i0	PRJNA694770	87299	247	0.885057	2.18609079	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	324	4.2799999999999995e-84	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g87005	i0	90.283	16.5951417004049	247	24	100	0	1	247	607232	607478	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	4099	324	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488

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