metadata: contig_metadata: 5 rows where bioproject = "PRJNA615351" and tax

5 rows where bioproject = "PRJNA615351" and tax_phylum = "Candidatus Bipolaricaulota"

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
12074807	12074807	PRJNA615351_P_NODE_118270_length_255_cov_1.454545_g104171_i0	PRJNA615351	118270	255	1.454545	3.70908975	Candidatus Bipolaricaulota bacterium	2306012	Bacteria	Bacteria	106	3.27e-28	NR	MBN1857846.1	2306012	g104171	i0	74.2	1.55294117647059	66	17	77.6	0	252	55	4	69	MBN1857846.1 cold-shock protein [Candidatus Bipolaricaulota bacterium]	diamond	396	106	1	Bacteria	Bacteria candidate phyla	Candidatus Bipolaricaulota					Candidatus Bipolaricaulota bacterium
28122815	28122815	PRJNA615351_P_NODE_77525_length_442_cov_5.660934_g63505_i0	PRJNA615351	77525	442	5.660934	25.02132828	Candidatus Bipolaricaulota bacterium	2306012	Bacteria	Bacteria	53.1	4.09e-6	NR	MEA3356540.1	2306012	g63505	i0	36.1	0.929864253393665	83	52	55.7	1	254	9	4	86	MEA3356540.1 acyl carrier protein [Candidatus Bipolaricaulota bacterium]	diamond	411	53.1	1	Bacteria	Bacteria candidate phyla	Candidatus Bipolaricaulota					Candidatus Bipolaricaulota bacterium
30143337	30143337	PRJNA615351_P_NODE_75212_length_459_cov_4.160377_g61215_i0	PRJNA615351	75212	459	4.160377	19.09613043	Candidatus Bipolaricaulis sibiricus	2501609	Bacteria	Bacteria	45.1	0.0498	NR	QAA76965.1	2501609	g61215	i0	36.2	0.450980392156863	69	44	45.1	0	223	17	287	355	QAA76965.1 MAG: Translation elongation factor G [Candidatus Bipolaricaulis sibiricus]	diamond	207	45.1	1	Bacteria	Bacteria candidate phyla	Candidatus Bipolaricaulota	Candidatus Bipolaricaulia	Candidatus Bipolaricaulales	Candidatus Bipolaricaulaceae	Candidatus Bipolaricaulis	Candidatus Bipolaricaulis sibiricus
30680433	30680433	PRJNA615351_P_NODE_103013_length_305_cov_2.529630_g88914_i0	PRJNA615351	103013	305	2.52963	7.7153715	Candidatus Bipolaricaulota bacterium	2306012	Bacteria	Bacteria	48.5	7.34e-4	NR	MBS3812805.1	2306012	g88914	i0	46.3	0.659016393442623	67	33	63.9	2	239	45	651	716	MBS3812805.1 DEAD/DEAH box helicase [Candidatus Bipolaricaulota bacterium]	diamond	201	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Bipolaricaulota					Candidatus Bipolaricaulota bacterium
32135326	32135326	PRJNA615351_P_NODE_155558_length_182_cov_1.925170_g141458_i0	PRJNA615351	155558	182	1.92517	3.5038094	Candidatus Bipolaricaulota bacterium	2306012	Bacteria	Bacteria	41.6	0.0244	NR	MCK5827976.1	2306012	g141458	i0	42.3	0.857142857142857	52	29	84.1	1	182	30	48	99	MCK5827976.1 hypothetical protein [Candidatus Bipolaricaulota bacterium]	diamond	156	41.6	1	Bacteria	Bacteria candidate phyla	Candidatus Bipolaricaulota					Candidatus Bipolaricaulota 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);;