metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA432257" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA432257" 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
1704673	1704673	PRJNA432257_S_NODE_51462_length_228_cov_108.209424_g51081_i0	PRJNA432257	51462	228	108.209424	246.71748672	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	353	4.98e-93	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g51081	i0	99.485	22.1228070175439	194	1	85	0	34	227	96491	96298	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	5044	353	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
2364193	2364193	PRJNA432257_S_NODE_50982_length_229_cov_30.265625_g50601_i0	PRJNA432257	50982	229	30.265625	69.30828125	Bdellovibrio	958	Bacteria	Bacteria	183	6.939999999999998e-42	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g50601	i0	84.293	2.50218340611354	191	27	83	3	1	190	1700343	1700531	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	573	183	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
4256826	4256826	PRJNA432257_S_NODE_55664_length_222_cov_2.335135_g55283_i0	PRJNA432257	55664	222	2.335135	5.1839997	Bdellovibrio sp. HM001	3113894	Bacteria	Bacteria	198	2.39e-46	NTclustered	gi\|2663428595\|dbj\|AP029174.1\|	3113894	g55283	i0	88.024	3.74324324324324	167	20	75	0	5	171	3043442	3043608	Bdellovibrio sp. HM001 DNA, complete genome	blastn	831	198	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HM001
6191724	6191724	PRJNA432257_S_NODE_29905_length_279_cov_78.962810_g29524_i0	PRJNA432257	29905	279	78.96281	220.3062399	Bdellovibrio	958	Bacteria	Bacteria	95.3	4.21e-15	NTclustered	gi\|2800917394\|gb\|CP168972.1\|	959	g29524	i0	84.694	0.702508960573477	98	11	34	4	184	279	2821332	2821427	Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome	blastn	196	95.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
8082586	8082586	PRJNA432257_S_NODE_17807_length_335_cov_2.238255_g17426_i0	PRJNA432257	17807	335	2.238255	7.49815425	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	425	1.62e-114	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g17426	i0	92.308	0.892537313432836	299	23	89	0	34	332	500814	501112	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	299	425	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
8083068	8083068	PRJNA432257_S_NODE_49167_length_232_cov_137.923077_g48786_i0	PRJNA432257	49167	232	137.923077	319.98153864	Bacteriovorax stolpii	960	Bacteria	Bacteria	132	2.59e-26	NTclustered	gi\|1326041851\|gb\|CP025704.1\|	960	g48786	i0	90.099	0.435344827586207	101	10	44	0	37	137	1166680	1166780	Bacteriovorax stolpii strain DSM 12778 chromosome, complete genome	blastn	101	132	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
8741507	8741507	PRJNA432257_S_NODE_16547_length_343_cov_6.450980_g16166_i0	PRJNA432257	16547	343	6.45098	22.1268614	Bdellovibrio	958	Bacteria	Bacteria	219	3.02e-52	NTclustered	gi\|2800917394\|gb\|CP168972.1\|	959	g16166	i0	81.343	1.56268221574344	268	50	78	0	44	311	1190291	1190024	Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome	blastn	536	219	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
9357400	9357400	PRJNA432257_S_NODE_14768_length_357_cov_1.950000_g14387_i0	PRJNA432257	14768	357	1.95	6.9615	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	309	1.8200000000000003e-79	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g14387	i0	82.353	1	357	61	99	2	2	357	2743640	2743995	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	357	309	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
9357859	9357859	PRJNA432257_S_NODE_48628_length_233_cov_72.030612_g48247_i0	PRJNA432257	48628	233	72.030612	167.83132596	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	183	7.089999999999998e-42	NTclustered	gi\|635300599\|gb\|CP007656.1\|	959	g48247	i0	87.195	5.60515021459227	164	18	69	3	39	199	118022	117859	Bdellovibrio bacteriovorus strain 109J, complete genome	blastn	1306	183	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
9358287	9358287	PRJNA432257_S_NODE_79168_length_193_cov_449.000000_g78787_i0	PRJNA432257	79168	193	449	866.57	Peredibacter starrii	28202	Bacteria	Bacteria	219	1.55e-52	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g78787	i0	90.964	89.9948186528497	166	9	85	6	1	164	133775	133614	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	17369	219	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
10633315	10633315	PRJNA432257_S_NODE_25649_length_295_cov_9.879845_g25268_i0	PRJNA432257	25649	295	9.879845	29.14554275	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	172	2.0099999999999999e-38	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g25268	i0	78.846	1.30847457627119	260	51	87	4	6	263	1160014	1159757	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	386	172	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
10633498	10633498	PRJNA432257_S_NODE_37789_length_256_cov_265.301370_g37408_i0	PRJNA432257	37789	256	265.30137	679.1715072	Peredibacter starrii	28202	Bacteria	Bacteria	270	5.899999999999999e-68	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g37408	i0	89.286	1.8671875	224	13	86	7	37	256	4017919	4018135	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	478	270	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
11291851	11291851	PRJNA432257_S_NODE_24189_length_301_cov_251.371212_g23808_i0	PRJNA432257	24189	301	251.371212	756.62734812	Peredibacter	263370	Bacteria	Bacteria	230	1.2099999999999995e-55	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g23808	i0	82.264	1.76079734219269	265	47	88	0	2	266	3434099	3433835	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	530	230	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
11909110	11909110	PRJNA432257_S_NODE_93750_length_181_cov_3.416667_g93369_i0	PRJNA432257	93750	181	3.416667	6.18416727	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	132	1.92e-26	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g93369	i0	82.993	0.812154696132597	147	23	81	2	36	181	2206312	2206167	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	147	132	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
12567699	12567699	PRJNA432257_S_NODE_81690_length_191_cov_18.409091_g81309_i0	PRJNA432257	81690	191	18.409091	35.16136381	Bdellovibrio	958	Bacteria	Bacteria	93.5	9.68e-15	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g81309	i0	87.059	0.890052356020942	85	8	45	1	60	144	2479244	2479325	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	170	93.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
14458871	14458871	PRJNA432257_S_NODE_68532_length_205_cov_2.845238_g68151_i0	PRJNA432257	68532	205	2.845238	5.8327379	Peredibacter starrii	28202	Bacteria	Bacteria	198	2.17e-46	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g68151	i0	84.577	0.980487804878049	201	30	98	1	5	204	2341749	2341949	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	201	198	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
14458933	14458933	PRJNA432257_S_NODE_73672_length_199_cov_21.203704_g73291_i0	PRJNA432257	73672	199	21.203704	42.19537096	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	134	6e-27	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g73291	i0	88.496	44.3768844221105	113	10	56	3	58	168	613223	613112	Bdellovibrio bacteriovorus W, complete genome	blastn	8831	134	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
17006458	17006458	PRJNA432257_S_NODE_121134_length_156_cov_1.184874_g120753_i0	PRJNA432257	121134	156	1.184874	1.84840344	Bdellovibrio sp. HCB-162	3394234	Bacteria	Bacteria	100	4.52e-17	NTclustered	gi\|2898207634\|gb\|CP178861.1\|	3394234	g120753	i0	90.909	15.4102564102564	77	4	49	3	72	148	393214	393141	Bdellovibrio sp. HCB-162 chromosome, complete genome	blastn	2404	100	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB-162
17006935	17006935	PRJNA432257_S_NODE_41294_length_248_cov_4.687204_g40913_i0	PRJNA432257	41294	248	4.687204	11.62426592	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	200	7.569999999999999e-47	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g40913	i0	83.81	0.846774193548387	210	34	85	0	16	225	360258	360467	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	210	200	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
17666279	17666279	PRJNA432257_S_NODE_28014_length_286_cov_2.273092_g27633_i0	PRJNA432257	28014	286	2.273092	6.50104312	Bdellovibrio	958	Bacteria	Bacteria	213	1.15e-50	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g27633	i0	82.258	7.16433566433566	248	43	86	1	1	247	2466038	2466285	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	2049	213	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
18281107	18281107	PRJNA432257_S_NODE_31955_length_273_cov_2.000000_g31574_i0	PRJNA432257	31955	273	2	5.46	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	398	2.7899999999999995e-106	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g31574	i0	95.238	1.98901098901099	252	10	92	1	9	260	881361	881112	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	543	398	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
18281959	18281959	PRJNA432257_S_NODE_94975_length_180_cov_6.699301_g94594_i0	PRJNA432257	94975	180	6.699301	12.0587418	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	202	1.4299999999999999e-47	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g94594	i0	100	14.8944444444444	109	0	62	0	13	121	94472	94364	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	2681	202	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
19555838	19555838	PRJNA432257_S_NODE_62616_length_212_cov_52.485714_g62235_i0	PRJNA432257	62616	212	52.485714	111.26971368	Bdellovibrio sp. HCB274	3394361	Bacteria	Bacteria	239	1.33e-58	NTclustered	gi\|2895984058\|gb\|CP178623.1\|	3394361	g62235	i0	91.813	29.127358490566	171	14	81	0	34	204	868480	868650	Bdellovibrio sp. HCB274 chromosome, complete genome	blastn	6175	239	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB274
19556099	19556099	PRJNA432257_S_NODE_8156_length_439_cov_2.437811_g7828_i0	PRJNA432257	8156	439	2.437811	10.70199029	Bdellovibrio sp. HM001	3113894	Bacteria	Bacteria	278	6.43e-70	NTclustered	gi\|2663428595\|dbj\|AP029174.1\|	3113894	g7828	i0	80.376	4.51708428246014	372	67	84	5	42	410	1981453	1981821	Bdellovibrio sp. HM001 DNA, complete genome	blastn	1983	278	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HM001
22105528	22105528	PRJNA432257_S_NODE_10298_length_404_cov_3.776567_g9939_i0	PRJNA432257	10298	404	3.776567	15.25733068	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	233	1.29e-56	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g9939	i0	78.917	1.74009900990099	351	68	86	6	5	352	299239	299586	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	703	233	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
22106129	22106129	PRJNA432257_S_NODE_33438_length_268_cov_184.350649_g33057_i0	PRJNA432257	33438	268	184.350649	494.05973932	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g33057	i0	96.774	0.115671641791045	31	1	12	0	116	146	2861438	2861408	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	31	52.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
22765613	22765613	PRJNA432257_S_NODE_32358_length_271_cov_284.961538_g31977_i0	PRJNA432257	32358	271	284.961538	772.24576798	Bdellovibrio	958	Bacteria	Bacteria	93.5	1.46e-14	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g31977	i0	77.193	1.2619926199262	171	31	62	6	69	235	186413	186247	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	342	93.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
23381534	23381534	PRJNA432257_S_NODE_20619_length_318_cov_1856.665480_g20238_i0	PRJNA432257	20619	318	1856.66548	5904.1962264	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	185	2.8199999999999994e-42	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g20238	i0	85.475	242.424528301887	179	24	56	2	40	217	3071358	3071535	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	77091	185	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
23381577	23381577	PRJNA432257_S_NODE_23199_length_306_cov_2.631970_g22818_i0	PRJNA432257	23199	306	2.63197	8.0538282	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	267	9.36e-67	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g22818	i0	84.043	0.92156862745098	282	39	91	4	28	306	1020597	1020319	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	282	267	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
23381895	23381895	PRJNA432257_S_NODE_4619_length_539_cov_19.278884_g4369_i0	PRJNA432257	4619	539	19.278884	103.91318476	Peredibacter starrii	28202	Bacteria	Bacteria	375	2.7699999999999995e-99	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g4369	i0	81.579	1.69202226345083	456	82	84	2	69	523	864882	865336	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	912	375	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);;