metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1112809" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1112809" 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
1495522	1495522	PRJNA1112809_P_NODE_45682_length_581_cov_1.940945_g42440_i0	PRJNA1112809	45682	581	1.940945	11.27689045	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	122	4.309999999999999e-23	NTclustered	gi\|2258829869\|gb\|CP060224.1\|	2053688	g42440	i0	91.954	15.7986230636833	87	7	15	0	219	305	611558	611472	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-8 chromosome	blastn	9179	122	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
2770539	2770539	PRJNA1112809_P_NODE_175183_length_247_cov_0.965517_g171908_i0	PRJNA1112809	175183	247	0.965517	2.38482699	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	193	1.26e-44	NTclustered	gi\|2518556404\|emb\|OX638375.1\|	2838779	g171908	i0	82.648	2.81781376518219	219	37	88	1	1	218	3373059	3372841	MAG: Candidatus Binatia bacterium isolate 97b5e0c7-6798-4f16-949c-9b63468df6e4 genome assembly, chromosome: 1	blastn	696	193	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
6597618	6597618	PRJNA1112809_P_NODE_150086_length_263_cov_2.173684_g146811_i0	PRJNA1112809	150086	263	2.173684	5.71678892	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	226	1.3399999999999998e-54	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g146811	i0	94.558	8.10266159695817	147	7	89	1	117	263	40822	40967	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	2131	226	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
7401252	7401252	PRJNA1112809_P_NODE_199586_length_227_cov_2.629870_g196311_i0	PRJNA1112809	199586	227	2.62987	5.9698049	Candidatus Saccharimonadota	95818	Bacteria	Bacteria	420	4.81e-113	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g196311	i0	100	50.4229074889868	227	0	100	0	1	227	116748	116974	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	11446	420	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
14248541	14248541	PRJNA1112809_P_NODE_155992_length_258_cov_1.324324_g152717_i0	PRJNA1112809	155992	258	1.324324	3.41675592	uncultured Methylomirabilota bacterium	991135	Bacteria	Bacteria	167	8.04e-37	NTclustered	gi\|2874253892\|emb\|OY970067.1\|	991135	g152717	i0	78.74	41.0658914728682	254	50	98	4	7	258	5229411	5229662	MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1	blastn	10595	167	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					uncultured Methylomirabilota 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);;