metadata: contig_metadata: 16 rows where bioproject = "PRJNA575566", tax_phylum = "Bdellovibrionota" and tax

16 rows where bioproject = "PRJNA575566", 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
4964869	4964869	PRJNA575566_P_NODE_28224_length_203_cov_0.901408_g28027_i0	PRJNA575566	28224	203	0.901408	1.82985824	Bdellovibrio	958	Bacteria	Bacteria	239	1.27e-58	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g28027	i0	88.776	7.63054187192118	196	20	96	2	1	195	4045413	4045607	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	1549	239	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
9488398	9488398	PRJNA575566_P_NODE_20748_length_230_cov_1.136095_g20551_i0	PRJNA575566	20748	230	1.136095	2.6130185	Bdellovibrio sp. HCB2-146	3394362	Bacteria	Bacteria	150	3.6e-45	NR	WP_413939772.1	3394362	g20551	i0	100	0.991304347826087	76	0	99.1	0	229	2	5	80	WP_413939772.1 RNA recognition motif domain-containing protein [Bdellovibrio sp. HCB2-146]	diamond	228	150	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB2-146
10764440	10764440	PRJNA575566_P_NODE_29869_length_201_cov_0.914286_g29672_i0	PRJNA575566	29869	201	0.914286	1.83771486	Bdellovibrio sp. KM01	2748865	Bacteria	Bacteria	195	2.74e-45	NTclustered	gi\|1880307726\|gb\|CP058348.1\|	2748865	g29672	i0	84.158	2.00995024875622	202	30	100	2	1	201	341709	341909	Bdellovibrio sp. KM01 chromosome, complete genome	blastn	404	195	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. KM01
12039213	12039213	PRJNA575566_P_NODE_25970_length_207_cov_0.876712_g25773_i0	PRJNA575566	25970	207	0.876712	1.81479384	Bdellovibrio sp. HCB2-146	3394362	Bacteria	Bacteria	131	4.85e-34	NR	WP_413938877.1	3394362	g25773	i0	100	0.985507246376812	68	0	98.6	0	206	3	3	70	WP_413938877.1 microtubule-binding protein [Bdellovibrio sp. HCB2-146]	diamond	204	131	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB2-146
12615648	12615648	PRJNA575566_P_NODE_15590_length_267_cov_1.242718_g15393_i0	PRJNA575566	15590	267	1.242718	3.31805706	Bdellovibrio	958	Bacteria	Bacteria	287	6.15e-73	NTclustered	gi\|1700693790\|gb\|CP030082.1\|	2231053	g15393	i0	87.251	35.8801498127341	251	32	94	0	16	266	806388	806638	Bdellovibrio sp. ZAP7 chromosome, complete genome	blastn	9580	289	0.993079584775087	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. ZAP7
13890665	13890665	PRJNA575566_P_NODE_12651_length_295_cov_1.581197_g12454_i0	PRJNA575566	12651	295	1.581197	4.66453115	Bdellovibrio	958	Bacteria	Bacteria	479	1.0599999999999996e-130	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g12454	i0	95.946	44.0203389830508	296	11	100	1	1	295	3504713	3504418	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	12986	479	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
19686640	19686640	PRJNA575566_P_NODE_26496_length_206_cov_0.882759_g26299_i0	PRJNA575566	26496	206	0.882759	1.81848354	Bdellovibrio sp. HCB185ZH	3394235	Bacteria	Bacteria	298	2.09e-76	NTclustered	gi\|2895513970\|gb\|CP178624.1\|	3394235	g26299	i0	92.718	14.2766990291262	206	15	100	0	1	206	1199597	1199802	Bdellovibrio sp. HCB185ZH chromosome, complete genome	blastn	2941	298	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB185ZH
20263235	20263235	PRJNA575566_P_NODE_24696_length_208_cov_1.292517_g24499_i0	PRJNA575566	24696	208	1.292517	2.68843536	Bdellovibrio sp. HCB2-146	3394362	Bacteria	Bacteria	124	1.22e-33	NR	WP_413941498.1	3394362	g24499	i0	95.5	0.951923076923077	66	3	95.2	0	198	1	1	66	WP_413941498.1 MotA/TolQ/ExbB proton channel family protein [Bdellovibrio sp. HCB2-146]	diamond	198	124	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB2-146
23512284	23512284	PRJNA575566_P_NODE_14539_length_276_cov_1.190698_g14342_i0	PRJNA575566	14539	276	1.190698	3.28632648	Bdellovibrio sp. HCB185ZH	3394235	Bacteria	Bacteria	377	3.69e-100	NTclustered	gi\|2895513970\|gb\|CP178624.1\|	3394235	g14342	i0	91.636	43.6775362318841	275	20	99	2	4	276	2779033	2779306	Bdellovibrio sp. HCB185ZH chromosome, complete genome	blastn	12055	377	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB185ZH
25363121	25363121	PRJNA575566_P_NODE_27860_length_204_cov_0.895105_g27663_i0	PRJNA575566	27860	204	0.895105	1.8260142	Bdellovibrio	958	Bacteria	Bacteria	241	3.54e-59	NTclustered	gi\|1880307726\|gb\|CP058348.1\|	2748865	g27663	i0	89.894	10.2549019607843	188	17	92	2	1	187	799524	799710	Bdellovibrio sp. KM01 chromosome, complete genome	blastn	2092	241	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. KM01
26889934	26889934	PRJNA575566_P_NODE_24281_length_209_cov_0.864865_g24084_i0	PRJNA575566	24281	209	0.864865	1.80756785	Bdellovibrio sp. HCB2-146	3394362	Bacteria	Bacteria	118	3.32e-29	NR	WP_413939334.1	3394362	g24084	i0	95.7	0.990430622009569	69	3	99	0	207	1	432	500	WP_413939334.1 methyl-accepting chemotaxis protein [Bdellovibrio sp. HCB2-146]	diamond	207	118	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB2-146
27205712	27205712	PRJNA575566_P_NODE_27762_length_204_cov_0.895105_g27565_i0	PRJNA575566	27762	204	0.895105	1.8260142	Bdellovibrio sp. HCB2-146	3394362	Bacteria	Bacteria	127	1.2e-34	NR	WP_413941452.1	3394362	g27565	i0	85.1	0.985294117647059	67	10	98.5	0	2	202	33	99	WP_413941452.1 3D domain-containing protein [Bdellovibrio sp. HCB2-146]	diamond	201	127	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB2-146
28279477	28279477	PRJNA575566_P_NODE_28386_length_203_cov_0.901408_g28189_i0	PRJNA575566	28386	203	0.901408	1.82985824	Bdellovibrio sp. HCB2-146	3394362	Bacteria	Bacteria	131	3.76e-34	NR	WP_413939910.1	3394362	g28189	i0	98.4	0.916256157635468	62	1	91.6	0	201	16	464	525	WP_413939910.1 hypothetical protein [Bdellovibrio sp. HCB2-146]	diamond	186	131	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB2-146
29164021	29164021	PRJNA575566_P_NODE_27949_length_204_cov_0.895105_g27752_i0	PRJNA575566	27949	204	0.895105	1.8260142	Bdellovibrio sp. HCB2-146	3394362	Bacteria	Bacteria	132	3.59e-35	NR	WP_413939332.1	3394362	g27752	i0	100	0.985294117647059	67	0	98.5	0	202	2	305	371	WP_413939332.1 cell division protein FtsA [Bdellovibrio sp. HCB2-146]	diamond	201	132	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB2-146
32387454	32387454	PRJNA575566_P_NODE_25959_length_207_cov_0.876712_g25762_i0	PRJNA575566	25959	207	0.876712	1.81479384	Bdellovibrio sp. HCB2-146	3394362	Bacteria	Bacteria	129	1.14e-33	NR	WP_413941783.1	3394362	g25762	i0	87	1	69	9	100	0	207	1	249	317	WP_413941783.1 NAD(P)/FAD-dependent oxidoreductase [Bdellovibrio sp. HCB2-146]	diamond	207	129	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB2-146
32482529	32482529	PRJNA575566_P_NODE_29159_length_202_cov_0.907801_g28962_i0	PRJNA575566	29159	202	0.907801	1.83375802	Bdellovibrio sp. HCB2-146	3394362	Bacteria	Bacteria	141	3.29e-39	NR	WP_413940981.1	3394362	g28962	i0	100	0.98019801980198	66	0	98	0	200	3	67	132	WP_413940981.1 tryptophan--tRNA ligase [Bdellovibrio sp. HCB2-146]	diamond	198	141	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB2-146

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