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

5 rows where analysis = "blastn", bioproject = "PRJNA758088" 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
4565663	4565663	PRJNA758088_P_NODE_314564_length_247_cov_0.885057_g307593_i0	PRJNA758088	314564	247	0.885057	2.18609079	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	412	8.89e-111	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g307593	i0	96.761	97.7813765182186	247	8	100	0	1	247	798196	798442	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	24152	412	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
4566061	4566061	PRJNA758088_P_NODE_340724_length_244_cov_0.900585_g333753_i0	PRJNA758088	340724	244	0.900585	2.1974274	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	424	4.05e-114	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g333753	i0	97.951	2	244	5	100	0	1	244	119105	119348	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	488	424	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
8391154	8391154	PRJNA758088_P_NODE_355247_length_242_cov_0.911243_g348276_i0	PRJNA758088	355247	242	0.911243	2.20520806	Candidatus Bipolaricaulis anaerobius	2026885	Bacteria	Bacteria	67.6	7.78e-7	NTclustered	gi\|1403730514\|emb\|LS483254.1\|	2026885	g348276	i0	91.837	2.70247933884298	49	2	20	2	60	108	30041	29995	Candidatus Acetothermia bacterium Ran1 isolate BARAN1 MAG genome assembly, chromosome: BARAN1	blastn	654	67.6	1	Bacteria	Bacteria candidate phyla	Candidatus Bipolaricaulota	Candidatus Bipolaricaulia	Candidatus Bipolaricaulales	Candidatus Bipolaricaulaceae	Candidatus Bipolaricaulis	Candidatus Bipolaricaulis anaerobius
13491184	13491184	PRJNA758088_P_NODE_321571_length_246_cov_0.890173_g314600_i0	PRJNA758088	321571	246	0.890173	2.18982558	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	62.1	3.69e-5	NTclustered	gi\|2814788387\|emb\|OY762897.2\|	2838779	g314600	i0	87.5	0.227642276422764	56	4	23	2	62	117	1077566	1077618	MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1	blastn	56	62.1	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
23687117	23687117	PRJNA758088_P_NODE_104979_length_409_cov_1.660714_g98009_i0	PRJNA758088	104979	409	1.660714	6.79232026	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	756	0	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g98009	i0	100	228.936430317848	409	0	100	0	1	409	502266	501858	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	93635	756	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis

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