metadata: contig_metadata: 12 rows where bioproject = "PRJNA859990", tax_phylum = "Bdellovibrionota" and tax

12 rows where bioproject = "PRJNA859990", 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
5949224	5949224	PRJNA859990_S_NODE_19865_length_246_cov_0.890173_g19604_i0	PRJNA859990	19865	246	0.890173	2.18982558	Peredibacter starrii	28202	Bacteria	Bacteria	353	5.44e-93	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g19604	i0	92.653	3.99186991869919	245	18	99	0	2	246	512231	512475	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	982	353	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
9774077	9774077	PRJNA859990_S_NODE_9128_length_334_cov_1.394636_g8867_i0	PRJNA859990	9128	334	1.394636	4.65808424	Peredibacter starrii	28202	Bacteria	Bacteria	595	1.1599999999999998e-165	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g8867	i0	98.802	204.245508982036	334	4	100	0	1	334	513055	512722	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	68218	595	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
12325154	12325154	PRJNA859990_S_NODE_5750_length_410_cov_1.317507_g5489_i0	PRJNA859990	5750	410	1.317507	5.4017787	Peredibacter starrii	28202	Bacteria	Bacteria	721	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g5489	i0	98.301	115.956097560976	412	5	100	1	1	410	511821	512232	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	47542	721	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
14873842	14873842	PRJNA859990_S_NODE_16752_length_257_cov_1.434783_g16491_i0	PRJNA859990	16752	257	1.434783	3.68739231	Peredibacter starrii	28202	Bacteria	Bacteria	414	2.59e-111	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g16491	i0	96.063	91.9455252918288	254	10	99	0	4	257	511302	511049	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	23630	414	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
14873893	14873893	PRJNA859990_S_NODE_21492_length_242_cov_1.621302_g21231_i0	PRJNA859990	21492	242	1.621302	3.92355084	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	243	1.2100000000000004e-59	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g21231	i0	88.5	2.73140495867769	200	23	83	0	3	202	2579000	2579199	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	661	243	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
20362586	20362586	PRJNA859990_S_NODE_6016_length_401_cov_1.945122_g5755_i0	PRJNA859990	6016	401	1.945122	7.79993922	Peredibacter	263370	Bacteria	Bacteria	667	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g5755	i0	96.758	219.476309226933	401	12	100	1	1	401	511581	511980	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	88010	667	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
27149495	27149495	PRJNA859990_S_NODE_18242_length_250_cov_0.870056_g17981_i0	PRJNA859990	18242	250	0.870056	2.17514	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	145	4.55e-39	NR	MCM2350652.1	2081706	g17981	i0	79.5	0.996	83	17	99.6	0	2	250	457	539	MCM2350652.1 hypothetical protein [Bacteriovoracaceae bacterium]	diamond	249	145	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
27907656	27907656	PRJNA859990_S_NODE_19525_length_247_cov_0.879310_g19264_i0	PRJNA859990	19525	247	0.87931	2.1718957	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	62	6.18e-9	NR	MBY0515591.1	2081706	g19264	i0	37.3	1.0080971659919	83	50	98.4	2	3	245	546	628	MBY0515591.1 hypothetical protein [Bacteriovoracaceae bacterium]	diamond	249	62	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
28034387	28034387	PRJNA859990_S_NODE_20525_length_244_cov_1.543860_g20264_i0	PRJNA859990	20525	244	1.54386	3.7670184	Bdellovibrio sp. KM	28201	Bacteria	Bacteria	74.7	2.11e-13	NR	WP_181604689.1	2748865	g20264	i0	97.1	0.418032786885246	34	1	41.8	0	244	143	950	983	WP_181604689.1 L-glutamate gamma-semialdehyde dehydrogenase [Bdellovibrio sp. KM01]	diamond	102	74.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. KM01
30244819	30244819	PRJNA859990_S_NODE_21692_length_242_cov_0.911243_g21431_i0	PRJNA859990	21692	242	0.911243	2.20520806	Pseudobdellovibrio sp.	2862747	Bacteria	Bacteria	62.8	3.15e-9	NR	MFN3453399.1	2862747	g21431	i0	42.3	0.966942148760331	78	45	96.7	0	242	9	444	521	MFN3453399.1 aromatic amino acid hydroxylase [Pseudobdellovibrio sp.]	diamond	234	62.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp.
30434590	30434590	PRJNA859990_S_NODE_18213_length_250_cov_0.915254_g17952_i0	PRJNA859990	18213	250	0.915254	2.288135	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	87	3e-18	NR	HVK60334.1	2053517	g17952	i0	64.2	0.804	67	24	80.4	0	1	201	56	122	HVK60334.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	201	87	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31445566	31445566	PRJNA859990_S_NODE_18276_length_250_cov_0.870056_g18015_i0	PRJNA859990	18276	250	0.870056	2.17514	Silvanigrellaceae bacterium	2654442	Bacteria	Bacteria	64.7	7.05e-10	NR	MBX9837929.1	2654442	g18015	i0	50.8	0.732	61	29	73.2	1	248	66	96	155	MBX9837929.1 hypothetical protein [Silvanigrellaceae bacterium]	diamond	183	64.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae		Silvanigrellaceae 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);;