metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA520845" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA520845" 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
490377	490377	PRJNA520845_P_NODE_221781_length_250_cov_0.870056_g220282_i0	PRJNA520845	221781	250	0.870056	2.17514	Bdellovibrio sp. HCB209	3394354	Bacteria	Bacteria	230	9.75e-56	NTclustered	gi\|2895998570\|gb\|CP178618.1\|	3394354	g220282	i0	83.267	12.112	251	40	100	2	1	250	2779304	2779553	Bdellovibrio sp. HCB209 chromosome, complete genome	blastn	3028	230	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB209
1766710	1766710	PRJNA520845_P_NODE_262222_length_242_cov_0.911243_g260723_i0	PRJNA520845	262222	242	0.911243	2.20520806	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|635300599\|gb\|CP007656.1\|	959	g260723	i0	100	29.4710743801653	242	0	100	0	1	242	2751598	2751357	Bdellovibrio bacteriovorus strain 109J, complete genome	blastn	7132	448	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
5595229	5595229	PRJNA520845_P_NODE_257305_length_243_cov_0.905882_g255806_i0	PRJNA520845	257305	243	0.905882	2.20129326	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|635300599\|gb\|CP007656.1\|	959	g255806	i0	99.588	20.5390946502058	243	1	100	0	1	243	3266345	3266587	Bdellovibrio bacteriovorus strain 109J, complete genome	blastn	4991	444	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
6214849	6214849	PRJNA520845_P_NODE_165985_length_289_cov_1.097222_g164486_i0	PRJNA520845	165985	289	1.097222	3.17097158	Bdellovibrio	958	Bacteria	Bacteria	459	1.3499999999999999e-124	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g164486	i0	95.47	169.377162629758	287	13	99	0	2	288	783653	783939	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	48950	459	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
6867778	6867778	PRJNA520845_P_NODE_206646_length_256_cov_1.497268_g205147_i0	PRJNA520845	206646	256	1.497268	3.83300608	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	346	9.53e-91	NTclustered	gi\|1210342126\|gb\|CP020946.1\|	959	g205147	i0	91.016	3.984375	256	23	100	0	1	256	1347264	1347519	Bdellovibrio bacteriovorus strain SSB218315, complete genome	blastn	1020	346	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
7489743	7489743	PRJNA520845_P_NODE_234746_length_247_cov_0.885057_g233247_i0	PRJNA520845	234746	247	0.885057	2.18609079	Bdellovibrio	958	Bacteria	Bacteria	381	2.5099999999999995e-101	NTclustered	gi\|2771112236\|gb\|CP160486.1\|	959	g233247	i0	94.694	13.8947368421053	245	13	99	0	1	245	3432184	3432428	Bdellovibrio bacteriovorus strain MHI39 chromosome	blastn	3432	381	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
7489885	7489885	PRJNA520845_P_NODE_267746_length_241_cov_0.916667_g266247_i0	PRJNA520845	267746	241	0.916667	2.20916747	Bdellovibrio	958	Bacteria	Bacteria	368	1.9e-97	NTclustered	gi\|2800927921\|gb\|CP168969.1\|	959	g266247	i0	94.191	16.954356846473	241	14	100	0	1	241	774398	774158	Bdellovibrio bacteriovorus strain Bd10 chromosome, complete genome	blastn	4086	370	0.994594594594595	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
13243427	13243427	PRJNA520845_P_NODE_187851_length_271_cov_2.085859_g186352_i0	PRJNA520845	187851	271	2.085859	5.65267789	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	335	2.2e-87	NTclustered	gi\|635300599\|gb\|CP007656.1\|	959	g186352	i0	88.93	15.0073800738007	271	30	100	0	1	271	2871020	2870750	Bdellovibrio bacteriovorus strain 109J, complete genome	blastn	4067	335	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
14519219	14519219	PRJNA520845_P_NODE_215812_length_251_cov_0.865169_g214313_i0	PRJNA520845	215812	251	0.865169	2.17157419	Silvanigrella aquatica	1915309	Bacteria	Bacteria	62.1	3.78e-5	NTclustered	gi\|1114626566\|gb\|CP017834.1\|	1915309	g214313	i0	90	1.50597609561753	50	2	20	2	156	205	2253328	2253374	Silvanigrella aquatica strain MWH-Nonnen-W8red chromosome	blastn	378	62.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Silvanigrella	Silvanigrella aquatica
16414024	16414024	PRJNA520845_P_NODE_154173_length_300_cov_1.938326_g152674_i0	PRJNA520845	154173	300	1.938326	5.814978	Bacteriovorax	146784	Bacteria	Bacteria	555	1.7399999999999995e-153	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g152674	i0	100	470.536666666667	300	0	100	0	1	300	1662222	1661923	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	141161	555	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
18963428	18963428	PRJNA520845_P_NODE_268375_length_238_cov_2.254545_g266876_i0	PRJNA520845	268375	238	2.254545	5.3658171	Pseudobdellovibrio	2862745	Bacteria	Bacteria	346	8.76e-91	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g266876	i0	92.857	79.5546218487395	238	17	100	0	1	238	1433	1670	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	18934	346	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
22167411	22167411	PRJNA520845_P_NODE_229818_length_248_cov_0.880000_g228319_i0	PRJNA520845	229818	248	0.88	2.1824	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	392	1.1599999999999999e-104	NTclustered	gi\|425858678\|gb\|CP002930.1\|	1069642	g228319	i0	95.161	17.0120967741935	248	12	100	0	1	248	3692541	3692294	Bdellovibrio bacteriovorus str. Tiberius, complete genome	blastn	4219	392	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);;