metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA753112" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA753112" 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
2004870	2004870	PRJNA753112_P_NODE_15782_length_341_cov_11.231343_g15440_i0	PRJNA753112	15782	341	11.231343	38.29887963	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	586	7.14e-163	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g15440	i0	97.654	7.03519061583578	341	8	100	0	1	341	204171	203831	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	2399	586	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
2005124	2005124	PRJNA753112_P_NODE_29622_length_251_cov_0.876404_g29280_i0	PRJNA753112	29622	251	0.876404	2.19977404	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	442	1.1599999999999995e-119	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g29280	i0	98.406	5.56573705179283	251	4	100	0	1	251	3294507	3294757	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	1397	442	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
3280154	3280154	PRJNA753112_P_NODE_16123_length_338_cov_1.388679_g15781_i0	PRJNA753112	16123	338	1.388679	4.69373502	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	331	3.66e-86	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g15781	i0	84.615	1	338	46	99	6	4	338	592329	591995	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	338	331	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
5832403	5832403	PRJNA753112_P_NODE_15245_length_348_cov_1.134545_g14903_i0	PRJNA753112	15245	348	1.134545	3.9482166	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	368	2.88e-97	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g14903	i0	86.087	4.19540229885058	345	44	99	4	6	348	2793545	2793887	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	1460	368	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
5832792	5832792	PRJNA753112_P_NODE_33605_length_242_cov_0.923077_g33263_i0	PRJNA753112	33605	242	0.923077	2.23384634	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	305	1.52e-78	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g33263	i0	89.583	0.991735537190083	240	25	99	0	1	240	969717	969956	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	240	305	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
9657241	9657241	PRJNA753112_P_NODE_10688_length_415_cov_1.649123_g10346_i0	PRJNA753112	10688	415	1.649123	6.84386045	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	512	1.52e-140	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g10346	i0	93.586	1.71807228915663	343	22	83	0	1	343	723291	722949	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	713	512	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
9657642	9657642	PRJNA753112_P_NODE_32008_length_245_cov_2.720930_g31666_i0	PRJNA753112	32008	245	2.72093	6.6662785	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	207	4.46e-49	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g31666	i0	83.468	1.01224489795918	248	16	100	15	1	245	2470451	2470226	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	248	207	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
10932925	10932925	PRJNA753112_P_NODE_21549_length_293_cov_1.063636_g21207_i0	PRJNA753112	21549	293	1.063636	3.11645348	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	350	8.6e-92	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g21207	i0	88.699	0.996587030716723	292	26	99	5	1	291	1317876	1317591	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	292	350	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
10932971	10932971	PRJNA753112_P_NODE_24169_length_277_cov_1.514706_g23827_i0	PRJNA753112	24169	277	1.514706	4.19573562	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	429	1.0099999999999999e-115	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g23827	i0	94.585	6.46931407942238	277	15	100	0	1	277	2445686	2445962	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	1792	429	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
12208403	12208403	PRJNA753112_P_NODE_22330_length_288_cov_1.344186_g21988_i0	PRJNA753112	22330	288	1.344186	3.87125568	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	204	6.95e-48	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g21988	i0	79.667	1.04166666666667	300	48	100	9	1	288	1765490	1765788	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	300	204	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
12208577	12208577	PRJNA753112_P_NODE_31350_length_247_cov_0.896552_g31008_i0	PRJNA753112	31350	247	0.896552	2.21448344	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	291	4.35e-74	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g31008	i0	87.854	1	247	30	100	0	1	247	725649	725895	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	247	291	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
12208622	12208622	PRJNA753112_P_NODE_33570_length_242_cov_0.923077_g33228_i0	PRJNA753112	33570	242	0.923077	2.23384634	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	398	2.4299999999999994e-106	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g33228	i0	96.281	2	242	9	100	0	1	242	2541572	2541331	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	484	398	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
13482591	13482591	PRJNA753112_P_NODE_10171_length_425_cov_10.477273_g9829_i0	PRJNA753112	10171	425	10.477273	44.52841025	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	640	6.87e-179	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g9829	i0	97.34	5.20235294117647	376	10	88	0	50	425	3157120	3156745	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	2211	640	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
13482921	13482921	PRJNA753112_P_NODE_28311_length_255_cov_1.461538_g27969_i0	PRJNA753112	28311	255	1.461538	3.7269219	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	399	7.179999999999999e-107	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g27969	i0	94.902	5.51764705882353	255	13	100	0	1	255	3314953	3315207	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	1407	399	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
14757897	14757897	PRJNA753112_P_NODE_24652_length_274_cov_2.328358_g24310_i0	PRJNA753112	24652	274	2.328358	6.37970092	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	462	9.81e-126	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g24310	i0	97.08	1.98540145985401	274	8	100	0	1	274	1846775	1846502	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	544	462	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
16031734	16031734	PRJNA753112_P_NODE_30113_length_250_cov_0.881356_g29771_i0	PRJNA753112	30113	250	0.881356	2.20339	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	104	6.16e-18	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g29771	i0	94.118	0.272	68	4	27	0	52	119	2908739	2908672	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	68	104	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
18580972	18580972	PRJNA753112_P_NODE_33635_length_242_cov_0.923077_g33293_i0	PRJNA753112	33635	242	0.923077	2.23384634	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	409	1.12e-109	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g33293	i0	97.107	2.00413223140496	242	7	100	0	1	242	1750836	1750595	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	485	409	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
19856117	19856117	PRJNA753112_P_NODE_29296_length_252_cov_0.871508_g28954_i0	PRJNA753112	29296	252	0.871508	2.19620016	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	355	1.56e-93	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g28954	i0	93.004	3.36904761904762	243	17	96	0	1	243	1120459	1120701	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	849	355	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
20328161	20328161	PRJNA753112_P_NODE_31196_length_247_cov_1.505747_g30854_i0	PRJNA753112	31196	247	1.505747	3.71919509	Pseudobdellovibrionaceae	213483	Bacteria	Bacteria	394	3.22e-105	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g30854	i0	95.885	1.96761133603239	243	10	98	0	2	244	2544034	2544276	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	486	394	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
22406337	22406337	PRJNA753112_P_NODE_20498_length_300_cov_1.162996_g20156_i0	PRJNA753112	20498	300	1.162996	3.488988	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	278	4.2300000000000005e-70	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g20156	i0	83.333	1	300	50	100	0	1	300	1229422	1229123	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	300	278	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
22406529	22406529	PRJNA753112_P_NODE_30538_length_249_cov_0.886364_g30196_i0	PRJNA753112	30538	249	0.886364	2.20704636	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	198	2.74e-46	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g30196	i0	81.423	1.01606425702811	253	38	100	9	1	249	3316767	3316520	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	253	198	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
22406565	22406565	PRJNA753112_P_NODE_32698_length_244_cov_0.912281_g32356_i0	PRJNA753112	32698	244	0.912281	2.22596564	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	313	9.139999999999999e-81	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g32356	i0	89.837	2.01639344262295	246	22	100	3	1	244	498002	497758	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	492	313	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
22406582	22406582	PRJNA753112_P_NODE_33398_length_242_cov_2.059172_g33056_i0	PRJNA753112	33398	242	2.059172	4.98319624	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	292	1.18e-74	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g33056	i0	88.43	3.10330578512397	242	28	100	0	1	242	3136220	3136461	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	751	292	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
24955517	24955517	PRJNA753112_P_NODE_22960_length_284_cov_1.630332_g22618_i0	PRJNA753112	22960	284	1.630332	4.63014288	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	289	1.84e-73	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g22618	i0	85.211	1.74647887323944	284	38	99	3	1	282	1739115	1738834	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	496	289	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
24955635	24955635	PRJNA753112_P_NODE_29460_length_251_cov_1.752809_g29118_i0	PRJNA753112	29460	251	1.752809	4.39955059	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	420	5.41e-113	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g29118	i0	96.813	5.94820717131474	251	8	100	0	1	251	3353758	3353508	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	1493	420	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
24955731	24955731	PRJNA753112_P_NODE_33520_length_242_cov_1.325444_g33178_i0	PRJNA753112	33520	242	1.325444	3.20757448	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	174	4.46e-39	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g33178	i0	80.15	1.10330578512397	267	26	99	16	1	241	330034	329769	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	267	174	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154

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