metadata: contig_metadata: 5 rows where bioproject = "PRJNA893346", tax_phylum = "Bdellovibrionota" and tax

5 rows where bioproject = "PRJNA893346", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
5971190	5971190	PRJNA893346_P_NODE_1705_length_1240_cov_4.343616_g1448_i0	PRJNA893346	1705	1240	4.343616	53.8608384	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	207	5.019999999999999e-60	NR	MCB0370750.1	2053517	g1448	i0	54.9	0.498387096774194	206	90	49.6	2	617	3	10	213	MCB0370750.1 inositol-3-phosphate synthase [Bdellovibrionales bacterium]	diamond	618	207	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27055738	27055738	PRJNA893346_P_NODE_34842_length_249_cov_0.875000_g34352_i0	PRJNA893346	34842	249	0.875	2.17875	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	73.9	1.46e-13	NR	MSP18409.1	2053517	g34352	i0	46.2	1.87951807228916	78	41	94	1	15	248	2	78	MSP18409.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	468	73.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29179344	29179344	PRJNA893346_P_NODE_12829_length_436_cov_1.484848_g12343_i0	PRJNA893346	12829	436	1.484848	6.47393728	Pseudomonadati	3379134	Bacteria	Bacteria	86.7	1.01e-16	NR	OUR93503.1	97084	g12343	i0	36.8	2.97935779816514	144	85	99.1	2	1	432	182	319	OUR93503.1 hypothetical protein A9Q84_18700 [Halobacteriovorax marinus]	diamond	1299	87	0.996551724137931	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae	Halobacteriovorax	Halobacteriovorax marinus
29486933	29486933	PRJNA893346_P_NODE_20510_length_340_cov_1.711610_g20021_i0	PRJNA893346	20510	340	1.71161	5.819474	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	180	1.8e-52	NR	MCB0368368.1	2053517	g20021	i0	78.4	0.979411764705882	111	24	97.9	0	335	3	130	240	MCB0368368.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	333	180	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30592635	30592635	PRJNA893346_P_NODE_38193_length_243_cov_1.358824_g37703_i0	PRJNA893346	38193	243	1.358824	3.30194232	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	102	3.57e-25	NR	MCB0369154.1	2053517	g37703	i0	65	0.987654320987654	80	28	98.8	0	3	242	35	114	MCB0369154.1 C39 family peptidase [Bdellovibrionales bacterium]	diamond	240	102	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales 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);;