metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1105232" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1105232" and tax_phylum = "Bdellovibrionota"

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
3570943	3570943	PRJNA1105232_S_NODE_17663_length_160_cov_2.342342_g17447_i0	PRJNA1105232	17663	160	2.342342	3.7477472	Bdellovibrio	958	Bacteria	Bacteria	209	7.44e-50	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g17447	i0	90.506	36.24375	158	15	99	0	2	159	2936804	2936647	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	5799	209	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
10416050	10416050	PRJNA1105232_S_NODE_7509_length_226_cov_1.175141_g7293_i0	PRJNA1105232	7509	226	1.175141	2.65581866	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	219	1.8699999999999998e-52	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g7293	i0	85.577	3.7212389380531	208	30	92	0	8	215	4874	4667	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	841	219	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
10416057	10416057	PRJNA1105232_S_NODE_8369_length_216_cov_2.491018_g8153_i0	PRJNA1105232	8369	216	2.491018	5.38059888	Bdellovibrio sp. HCB209	3394354	Bacteria	Bacteria	211	2.97e-50	NTclustered	gi\|2895998570\|gb\|CP178618.1\|	3394354	g8153	i0	86.154	1.875	195	27	90	0	22	216	2503253	2503059	Bdellovibrio sp. HCB209 chromosome, complete genome	blastn	405	211	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB209
12966441	12966441	PRJNA1105232_S_NODE_3911_length_292_cov_1.135802_g3695_i0	PRJNA1105232	3911	292	1.135802	3.31654184	Bdellovibrio sp. HCB209	3394354	Bacteria	Bacteria	289	1.8899999999999996e-73	NTclustered	gi\|2895998570\|gb\|CP178618.1\|	3394354	g3695	i0	84.536	39.4143835616438	291	45	99	0	1	291	770104	770394	Bdellovibrio sp. HCB209 chromosome, complete genome	blastn	11509	289	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB209
15048096	15048096	PRJNA1105232_S_NODE_1352_length_435_cov_5.168394_g1138_i0	PRJNA1105232	1352	435	5.168394	22.4825139	Bdellovibrio	958	Bacteria	Bacteria	532	1.2299999999999999e-146	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g1138	i0	88.813	124.528735632184	438	44	100	4	1	435	777847	778282	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	54170	532	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
18064237	18064237	PRJNA1105232_S_NODE_12295_length_185_cov_1.147059_g12079_i0	PRJNA1105232	12295	185	1.147059	2.12205915	Pseudobdellovibrio exovorus	453816	Bacteria	Bacteria	156	1.17e-33	NTclustered	gi\|469929247\|gb\|CP003537.1\|	1184267	g12079	i0	82.32	2.95675675675676	181	30	97	2	6	185	1869493	1869672	Bdellovibrio exovorus JSS, complete genome	blastn	547	156	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
19338393	19338393	PRJNA1105232_S_NODE_11116_length_193_cov_1.437500_g10900_i0	PRJNA1105232	11116	193	1.4375	2.774375	Bdellovibrio sp. HCB-162	3394234	Bacteria	Bacteria	147	7.419999999999999e-31	NTclustered	gi\|2898207634\|gb\|CP178861.1\|	3394234	g10900	i0	84.314	0.792746113989637	153	20	78	4	1	151	2880840	2880990	Bdellovibrio sp. HCB-162 chromosome, complete genome	blastn	153	147	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB-162
23164833	23164833	PRJNA1105232_S_NODE_11359_length_191_cov_2.563380_g11143_i0	PRJNA1105232	11359	191	2.56338	4.8960558	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	156	1.22e-33	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g11143	i0	82.486	1.85340314136126	177	31	93	0	6	182	2540831	2541007	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	354	156	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
23972737	23972737	PRJNA1105232_S_NODE_4859_length_268_cov_3.232877_g4643_i0	PRJNA1105232	4859	268	3.232877	8.66411036	Bdellovibrio	958	Bacteria	Bacteria	390	4.579999999999999e-104	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g4643	i0	92.937	218.522388059701	269	17	100	2	1	268	817508	817241	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	58564	390	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus

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