metadata: contig_metadata: 8 rows where bioproject = "PRJNA222400", tax_phylum = "Bdellovibrionota" and tax

8 rows where bioproject = "PRJNA222400", 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
1056587	1056587	PRJNA222400_P_NODE_6921_length_171_cov_1.311475_g6888_i0	PRJNA222400	6921	171	1.311475	2.24262225	Bdellovibrio	958	Bacteria	Bacteria	272	1.01e-68	NTclustered	gi\|1210342126\|gb\|CP020946.1\|	959	g6888	i0	95.322	123.397660818713	171	8	100	0	1	171	2952219	2952049	Bdellovibrio bacteriovorus strain SSB218315, complete genome	blastn	21101	272	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
8020617	8020617	PRJNA222400_P_NODE_5467_length_191_cov_2.035211_g5434_i0	PRJNA222400	5467	191	2.035211	3.88725301	Bacteria	2	Bacteria	Bacteria	104	2.77e-24	NR	MCB0326570.1	2053517	g5434	i0	74.2	1.94764397905759	62	16	97.4	0	188	3	668	729	MCB0326570.1 ribonucleoside-diphosphate reductase subunit alpha [Bdellovibrionales bacterium]	diamond	372	104	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
18218885	18218885	PRJNA222400_P_NODE_5855_length_186_cov_0.912409_g5822_i0	PRJNA222400	5855	186	0.912409	1.69708074	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	267	5.22e-67	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g5822	i0	92.473	295.467741935484	186	14	100	0	1	186	668330	668145	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	54957	267	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
19493162	19493162	PRJNA222400_P_NODE_3436_length_247_cov_1.196970_g3403_i0	PRJNA222400	3436	247	1.19697	2.9565159	Bdellovibrio sp. NC	28201	Bacteria	Bacteria	99.8	1.36e-22	NR	WP_142694956.1	2220073	g3403	i0	61	7.87044534412955	82	32	99.6	0	2	247	256	337	WP_142694956.1 acetyl-CoA C-acetyltransferase [Bdellovibrio sp. NC01]	diamond	1944	99.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
27881389	27881389	PRJNA222400_P_NODE_7525_length_168_cov_0.873950_g7492_i0	PRJNA222400	7525	168	0.87395	1.468236	Bdellovibrio	958	Bacteria	Bacteria	73.6	1.41e-13	NR	OYZ13486.1	1970323	g7492	i0	69.1	2.05357142857143	55	16	98.2	1	167	3	300	353	OYZ13486.1 MAG: hypothetical protein B7Y39_17575 [Bdellovibrio sp. 28-41-41]	diamond	345	73.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. 28-41-41
28228488	28228488	PRJNA222400_P_NODE_4846_length_202_cov_1.359477_g4813_i0	PRJNA222400	4846	202	1.359477	2.74614354	Pseudomonadati	3379134	Bacteria	Bacteria	49.7	6.7e-5	NR	MBC7421275.1	28201	g4813	i0	48	3.47524752475248	50	26	74.3	0	194	45	140	189	MBC7421275.1 MOSC domain-containing protein [Bdellovibrio sp.]	diamond	702	49.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
29916210	29916210	PRJNA222400_P_NODE_531_length_700_cov_3.482335_g501_i0	PRJNA222400	531	700	3.482335	24.376345	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	105	7.509999999999999e-24	NR	MBT6325281.1	2053517	g501	i0	32.5	2.58857142857143	200	128	82.7	4	656	78	10	209	MBT6325281.1 glutathione S-transferase [Bdellovibrionales bacterium]	diamond	1812	105	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32318927	32318927	PRJNA222400_P_NODE_1719_length_388_cov_1.392330_g1686_i0	PRJNA222400	1719	388	1.39233	5.4022404	Bdellovibrionales bacterium RIFOXYD1_FULL_44_7	1797402	Bacteria	Bacteria	47.8	0.0021	NR	OFZ79669.1	1797402	g1686	i0	36	1.35309278350515	89	45	68.8	3	18	284	151	227	OFZ79669.1 MAG: hypothetical protein A3K03_06035 [Bdellovibrionales bacterium RIFOXYD1_FULL_44_7]	diamond	525	47.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium RIFOXYD1_FULL_44_7

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