metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJEB14175" and tax

31 rows where analysis = "blastn", bioproject = "PRJEB14175" 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
25608953	25608953	PRJEB14175_P_NODE_207313_length_222_cov_11.391304_g205046_i0	PRJEB14175	207313	222	11.391304	25.28869488	root	1	Root_unresolved	Root_unresolved	135	1.9e-27	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g205046	i0	90.291	104.427927927928	103	10	46	0	77	179	1676473	1676371	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	23183	135	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
25638057	25638057	PRJEB14175_P_NODE_126258_length_309_cov_7.608871_g123991_i0	PRJEB14175	126258	309	7.608871	23.51141139	Bdellovibrio sp. HCB288	3394355	Bacteria	Bacteria	165	3.55e-36	NTclustered	gi\|2895994964\|gb\|CP178619.1\|	3394355	g123991	i0	77.66	139.003236245955	282	55	90	8	11	287	574467	574745	Bdellovibrio sp. HCB288 chromosome, complete genome	blastn	42952	165	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB288
25641302	25641302	PRJEB14175_P_NODE_196146_length_231_cov_2.752941_g193879_i0	PRJEB14175	196146	231	2.752941	6.35929371	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	165	2.54e-36	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g193879	i0	80.952	14.2597402597403	210	38	90	2	3	211	469416	469624	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	3294	165	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
25645432	25645432	PRJEB14175_P_NODE_40658_length_585_cov_5.097328_g38463_i0	PRJEB14175	40658	585	5.097328	29.8193688	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	364	6.539999999999998e-96	NTclustered	gi\|2800927921\|gb\|CP168969.1\|	959	g38463	i0	79.129	2.78803418803419	551	97	92	12	26	566	1786532	1787074	Bdellovibrio bacteriovorus strain Bd10 chromosome, complete genome	blastn	1631	364	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
25744557	25744557	PRJEB14175_P_NODE_16890_length_880_cov_12.255189_g15186_i0	PRJEB14175	16890	880	12.255189	107.8456632	Bdellovibrio	958	Bacteria	Bacteria	857	0	NTclustered	gi\|2800927921\|gb\|CP168969.1\|	959	g15186	i0	85.219	207.903409090909	866	92	97	28	1	850	829819	828974	Bdellovibrio bacteriovorus strain Bd10 chromosome, complete genome	blastn	182955	857	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
25773006	25773006	PRJEB14175_P_NODE_101923_length_353_cov_10.061644_g99657_i0	PRJEB14175	101923	353	10.061644	35.51760332	Fluviispira sanaruensis	2493639	Bacteria	Bacteria	154	8.890000000000001e-33	NTclustered	gi\|1566193515\|dbj\|AP019368.1\|	2493639	g99657	i0	75.988	145.008498583569	329	62	91	15	30	350	398768	399087	Silvanigrellales bacterium RF1110005 DNA, complete genome	blastn	51188	154	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Fluviispira	Fluviispira sanaruensis
25781181	25781181	PRJEB14175_P_NODE_35019_length_630_cov_11.868190_g32869_i0	PRJEB14175	35019	630	11.86819	74.769597	Bacteriovorax stolpii	960	Bacteria	Bacteria	931	0	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g32869	i0	94.399	456.931746031746	607	33	96	1	1	606	1661491	1660885	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	287867	931	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
25880481	25880481	PRJEB14175_P_NODE_182619_length_242_cov_4.486188_g180352_i0	PRJEB14175	182619	242	4.486188	10.85657496	Peredibacter	263370	Bacteria	Bacteria	329	8.99e-86	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g180352	i0	96.04	40.3471074380165	202	8	83	0	22	223	510752	510953	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	9764	329	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
25881928	25881928	PRJEB14175_P_NODE_266395_length_194_cov_3.706767_g264127_i0	PRJEB14175	266395	194	3.706767	7.19112798	Bdellovibrio	958	Bacteria	Bacteria	243	9.26e-60	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g264127	i0	96.575	61.2628865979381	146	5	75	0	1	146	784537	784682	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	11885	243	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
25910361	25910361	PRJEB14175_P_NODE_12612_length_1002_cov_49.142402_g11076_i0	PRJEB14175	12612	1002	49.142402	492.40686804	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	846	0	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g11076	i0	82.454	156.405189620758	986	156	97	12	3	976	468595	469575	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	156718	846	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
25911122	25911122	PRJEB14175_P_NODE_141620_length_287_cov_4.752212_g139353_i0	PRJEB14175	141620	287	4.752212	13.63884844	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	359	1.4e-94	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g139353	i0	89.273	193.08362369338	289	27	100	4	1	287	3446543	3446257	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	55415	359	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
25920621	25920621	PRJEB14175_P_NODE_93476_length_372_cov_108.800643_g91210_i0	PRJEB14175	93476	372	108.800643	404.73839196	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	621	2.1499999999999998e-173	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g91210	i0	96.774	119.709677419355	372	12	100	0	1	372	1292770	1292399	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	44532	621	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
26016786	26016786	PRJEB14175_P_NODE_179436_length_245_cov_4.141304_g177169_i0	PRJEB14175	179436	245	4.141304	10.1461948	Pseudobdellovibrio	2862745	Bacteria	Bacteria	106	1.67e-18	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g177169	i0	84.906	8.2734693877551	106	15	43	1	140	245	387	491	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	2027	106	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
26017453	26017453	PRJEB14175_P_NODE_214748_length_217_cov_2.461538_g212481_i0	PRJEB14175	214748	217	2.461538	5.34153746	Pseudobdellovibrio	2862745	Bacteria	Bacteria	165	2.3600000000000002e-36	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g212481	i0	83.799	112.410138248848	179	23	81	6	1	176	495	320	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	24393	165	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
26153936	26153936	PRJEB14175_P_NODE_241109_length_205_cov_22.875000_g238841_i0	PRJEB14175	241109	205	22.875	46.89375	Bdellovibrio	958	Bacteria	Bacteria	207	3.61e-49	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g238841	i0	91.447	24.4487804878049	152	11	74	2	30	180	968166	968016	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	5012	207	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
26154025	26154025	PRJEB14175_P_NODE_246469_length_204_cov_1.139860_g244201_i0	PRJEB14175	246469	204	1.13986	2.3253144	Bacteriovorax	146784	Bacteria	Bacteria	124	3.72e-24	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g244201	i0	78.431	2.91176470588235	204	34	100	4	1	204	3486572	3486379	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	594	124	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
26186943	26186943	PRJEB14175_P_NODE_220558_length_213_cov_2.177632_g218290_i0	PRJEB14175	220558	213	2.177632	4.63835616	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	241	3.7300000000000004e-59	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g218290	i0	88.177	151.441314553991	203	22	95	2	12	213	3250972	3251173	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	32257	241	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
26188826	26188826	PRJEB14175_P_NODE_269374_length_190_cov_72.821705_g267106_i0	PRJEB14175	269374	190	72.821705	138.3612395	Peredibacter starrii	28202	Bacteria	Bacteria	243	9.02e-60	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g267106	i0	92.857	87.0052631578947	168	11	88	1	2	168	512145	511978	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	16531	243	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
26190316	26190316	PRJEB14175_P_NODE_47662_length_540_cov_40.920668_g45435_i0	PRJEB14175	47662	540	40.920668	220.9716072	Bdellovibrio sp. HCB29	28201	Bacteria	Bacteria	189	3.88e-43	NTclustered	gi\|2895991164\|gb\|CP178620.1\|	3394356	g45435	i0	80.784	88.2777777777778	255	38	47	8	242	493	1790244	1789998	Bdellovibrio sp. HCB290 chromosome, complete genome	blastn	47670	189	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB290
26290266	26290266	PRJEB14175_P_NODE_265414_length_195_cov_5.940299_g263146_i0	PRJEB14175	265414	195	5.940299	11.58358305	Bacteriovorax	146784	Bacteria	Bacteria	302	1.5200000000000001e-77	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g263146	i0	98.266	16.8102564102564	173	2	88	1	24	195	1661602	1661774	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	3278	302	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
26291476	26291476	PRJEB14175_P_NODE_66846_length_452_cov_5.104859_g64588_i0	PRJEB14175	66846	452	5.104859	23.07396268	Halobacteriovorax	1652133	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1249980216\|gb\|CP017414.1\|	97084	g64588	i0	100	0.132743362831858	30	0	7	0	104	133	2411593	2411622	Halobacteriovorax marinus strain BE01 chromosome, complete genome	blastn	60	56.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae	Halobacteriovorax	Halobacteriovorax marinus
26291697	26291697	PRJEB14175_P_NODE_77958_length_414_cov_19.623229_g75697_i0	PRJEB14175	77958	414	19.623229	81.24016806	Bdellovibrio	958	Bacteria	Bacteria	294	5.99e-75	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g75697	i0	80.818	7.90821256038647	391	62	93	12	22	405	4080729	4080345	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	3274	294	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
26321991	26321991	PRJEB14175_P_NODE_204927_length_224_cov_4.417178_g202660_i0	PRJEB14175	204927	224	4.417178	9.89447872	Bdellovibrio sp. NC	28201	Bacteria	Bacteria	67.6	7.11e-7	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g202660	i0	87.719	0.491071428571429	57	7	25	0	69	125	1765836	1765892	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	110	67.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
26321999	26321999	PRJEB14175_P_NODE_205223_length_224_cov_2.355828_g202956_i0	PRJEB14175	205223	224	2.355828	5.27705472	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	154	5.3e-33	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g202956	i0	81.481	22.6830357142857	189	33	84	2	27	214	864146	864333	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	5081	154	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
26323998	26323998	PRJEB14175_P_NODE_253687_length_202_cov_2.226950_g251419_i0	PRJEB14175	253687	202	2.22695	4.498439	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	172	1.2899999999999999e-38	NTclustered	gi\|2621706492\|emb\|OY764265.1\|	3034175	g251419	i0	83	265.925742574257	200	25	97	6	8	202	1695521	1695326	MAG: Bdellovibrionota bacterium isolate efddfb02-ff0c-4ac5-ae96-c61d995422a3 genome assembly, chromosome: 1	blastn	53717	172	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
26426021	26426021	PRJEB14175_P_NODE_253039_length_202_cov_22.624113_g250771_i0	PRJEB14175	253039	202	22.624113	45.70070826	Bdellovibrio	958	Bacteria	Bacteria	231	2.0999999999999996e-56	NTclustered	gi\|2771112236\|gb\|CP160486.1\|	959	g250771	i0	89.56	14.3861386138614	182	19	90	0	21	202	3435158	3435339	Bdellovibrio bacteriovorus strain MHI39 chromosome	blastn	2906	231	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
26427600	26427600	PRJEB14175_P_NODE_77039_length_417_cov_13.109551_g74778_i0	PRJEB14175	77039	417	13.109551	54.666827670000004	Pseudomonadati	3379134	Bacteria	Bacteria	416	1.23e-111	NTclustered	gi\|1950812799\|gb\|CP066681.1\|	349221	g74778	i0	85.608	137.079136690647	403	51	96	7	3	402	659900	659502	Micavibrio aeruginosavorus isolate NC_groundwater_70_Ag_B-0.1um_54_66 chromosome	blastn	57162	418	0.995215311004785	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
26453694	26453694	PRJEB14175_P_NODE_106336_length_344_cov_15.780919_g104070_i0	PRJEB14175	106336	344	15.780919	54.28636136	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	366	1.0199999999999999e-96	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g104070	i0	87.195	188.921511627907	328	34	94	6	23	344	3250581	3250906	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	64989	366	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
26560937	26560937	PRJEB14175_P_NODE_190040_length_236_cov_2.674286_g187773_i0	PRJEB14175	190040	236	2.674286	6.31131496	Bacteriovorax	146784	Bacteria	Bacteria	387	5.11e-103	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g187773	i0	98.19	214.800847457627	221	4	94	0	1	221	1662621	1662401	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	50693	387	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
26562446	26562446	PRJEB14175_P_NODE_274336_length_182_cov_4.454545_g272068_i0	PRJEB14175	274336	182	4.454545	8.1072719	Bdellovibrio	958	Bacteria	Bacteria	147	6.899999999999999e-31	NTclustered	gi\|1210342126\|gb\|CP020946.1\|	959	g272068	i0	84.076	178.379120879121	157	19	85	6	1	155	2950250	2950402	Bdellovibrio bacteriovorus strain SSB218315, complete genome	blastn	32465	147	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
26563627	26563627	PRJEB14175_P_NODE_75592_length_422_cov_4.457064_g73333_i0	PRJEB14175	75592	422	4.457064	18.80881008	Peredibacter	263370	Bacteria	Bacteria	641	1.9e-179	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g73333	i0	94.104	93.063981042654	424	21	100	3	1	422	509245	508824	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	39273	641	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii

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