metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA565584" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA565584" 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
554695	554695	PRJNA565584_P_NODE_126601_length_277_cov_2.764706_g125449_i0	PRJNA565584	126601	277	2.764706	7.65823562	Bacteriovorax stolpii	960	Bacteria	Bacteria	259	1.4e-64	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g125449	i0	84.701	0.967509025270758	268	31	96	5	4	268	2648010	2648270	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	268	259	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
1133929	1133929	PRJNA565584_P_NODE_129661_length_275_cov_3.029703_g128509_i0	PRJNA565584	129661	275	3.029703	8.33168325	Bacteriovorax	146784	Bacteria	Bacteria	449	7.670000000000001e-122	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g128509	i0	96.337	232.447272727273	273	10	99	0	3	275	1660726	1660454	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	63923	449	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
2410377	2410377	PRJNA565584_P_NODE_39182_length_480_cov_1.113022_g38031_i0	PRJNA565584	39182	480	1.113022	5.3425056	Peredibacter	263370	Bacteria	Bacteria	765	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g38031	i0	95.417	162.0125	480	22	100	0	1	480	511695	511216	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	77766	771	0.992217898832685	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
3685206	3685206	PRJNA565584_P_NODE_120383_length_281_cov_2.307692_g119231_i0	PRJNA565584	120383	281	2.307692	6.48461452	Bdellovibrio	958	Bacteria	Bacteria	257	5.11e-64	NTclustered	gi\|1210342126\|gb\|CP020946.1\|	959	g119231	i0	87.665	232.701067615658	227	20	79	6	2	224	2950116	2950338	Bdellovibrio bacteriovorus strain SSB218315, complete genome	blastn	65389	257	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
3685393	3685393	PRJNA565584_P_NODE_137863_length_270_cov_1.563452_g136711_i0	PRJNA565584	137863	270	1.563452	4.2213204	Bdellovibrio	958	Bacteria	Bacteria	237	6.37e-58	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g136711	i0	85.043	2.50740740740741	234	33	86	2	5	237	591999	591767	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	677	237	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
5661679	5661679	PRJNA565584_P_NODE_92885_length_310_cov_2.497890_g91733_i0	PRJNA565584	92885	310	2.49789	7.743459	Bdellovibrio sp. HCB-162	3394234	Bacteria	Bacteria	152	2.7799999999999996e-32	NTclustered	gi\|2898207634\|gb\|CP178861.1\|	3394234	g91733	i0	86.429	4.39354838709677	140	17	45	2	169	307	2312022	2312160	Bdellovibrio sp. HCB-162 chromosome, complete genome	blastn	1362	152	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB-162
7512208	7512208	PRJNA565584_P_NODE_173586_length_250_cov_0.870056_g172434_i0	PRJNA565584	173586	250	0.870056	2.17514	Bdellovibrio	958	Bacteria	Bacteria	202	2.12e-47	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g172434	i0	83.645	8.044	214	35	86	0	1	214	2186416	2186629	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	2011	204	0.990196078431373	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
9484420	9484420	PRJNA565584_P_NODE_198248_length_244_cov_2.181287_g197096_i0	PRJNA565584	198248	244	2.181287	5.32234028	Bdellovibrio sp. 22V	3044166	Bacteria	Bacteria	172	1.62e-38	NTclustered	gi\|2514198184\|gb\|CP125854.1\|	3044166	g197096	i0	84.181	18.7049180327869	177	28	73	0	1	177	3354235	3354059	Bdellovibrio sp. 22V chromosome, complete genome	blastn	4564	172	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. 22V
14584460	14584460	PRJNA565584_P_NODE_171192_length_250_cov_1.728814_g170040_i0	PRJNA565584	171192	250	1.728814	4.322035	Bacteriovorax sp. HI3	2984118	Bacteria	Bacteria	294	3.41e-75	NTclustered	gi\|2321225508\|dbj\|AP026946.1\|	2984118	g170040	i0	88.889	1.476	243	22	95	3	9	246	95534	95776	Bacteriovorax sp. HI3 DNA, complete genome	blastn	369	294	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp. HI3
15163681	15163681	PRJNA565584_P_NODE_85812_length_321_cov_1.008065_g84660_i0	PRJNA565584	85812	321	1.008065	3.23588865	Bdellovibrio	958	Bacteria	Bacteria	237	7.750000000000001e-58	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g84660	i0	82.657	6.07476635514019	271	43	84	4	1	269	236433	236701	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	1950	237	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
15858757	15858757	PRJNA565584_P_NODE_200513_length_244_cov_0.900585_g199361_i0	PRJNA565584	200513	244	0.900585	2.1974274	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	158	4.53e-34	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g199361	i0	81.579	18.094262295082	190	35	78	0	11	200	4186394	4186583	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	4415	158	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
16436328	16436328	PRJNA565584_P_NODE_104453_length_292_cov_2.100457_g103301_i0	PRJNA565584	104453	292	2.100457	6.13333444	Pigmentibacter	2838409	Bacteria	Bacteria	255	1.92e-63	NTclustered	gi\|2651759839\|dbj\|AP029159.1\|	2683196	g103301	i0	82.712	195.27397260274	295	44	99	6	1	291	507192	507483	Pigmentibacter ruber GTC16762 DNA, complete genome	blastn	57020	255	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Pigmentibacter	Pigmentibacter ruber
18406431	18406431	PRJNA565584_P_NODE_109455_length_288_cov_2.051163_g108303_i0	PRJNA565584	109455	288	2.051163	5.90734944	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	75	5.69e-9	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g108303	i0	78.814	6.40972222222222	118	19	40	4	2	116	1460545	1460431	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	1846	75	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
18408148	18408148	PRJNA565584_P_NODE_205775_length_243_cov_0.905882_g204623_i0	PRJNA565584	205775	243	0.905882	2.20129326	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g204623	i0	100	1	243	0	100	0	1	243	2541558	2541800	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	243	449	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
24780796	24780796	PRJNA565584_P_NODE_117300_length_283_cov_2.133333_g116148_i0	PRJNA565584	117300	283	2.133333	6.03733239	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	296	1.09e-75	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g116148	i0	86.496	68.3003533568905	274	31	96	6	11	283	861457	861189	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	19329	296	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01

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