metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA682078" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA682078" 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
3210566	3210566	PRJNA682078_P_NODE_187943_length_270_cov_1.385787_g186166_i0	PRJNA682078	187943	270	1.385787	3.7416249	Bacteriovorax stolpii	960	Bacteria	Bacteria	241	4.92e-59	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g186166	i0	83.588	2.91481481481481	262	37	96	4	11	269	1360028	1360286	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	787	241	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
4489297	4489297	PRJNA682078_P_NODE_254524_length_246_cov_1.300578_g252747_i0	PRJNA682078	254524	246	1.300578	3.19942188	Bacteriovorax stolpii	960	Bacteria	Bacteria	302	2e-77	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g252747	i0	89.256	1.97967479674797	242	24	98	2	6	246	3794109	3793869	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	487	302	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
5761664	5761664	PRJNA682078_P_NODE_121465_length_323_cov_4.076000_g119688_i0	PRJNA682078	121465	323	4.076	13.16548	uncultured Bdellovibrio sp.	239744	Bacteria	Bacteria	584	2.419999999999999e-162	NTclustered	gi\|354780212\|gb\|JN412381.1\|	239744	g119688	i0	99.381	114.835913312693	323	1	100	1	1	323	20	341	Uncultured Bdellovibrio sp. clone PM62 16S ribosomal RNA gene, partial sequence	blastn	37092	584	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	uncultured Bdellovibrio sp.
5765417	5765417	PRJNA682078_P_NODE_271265_length_244_cov_0.900585_g269488_i0	PRJNA682078	271265	244	0.900585	2.1974274	Bacteriovorax sp. HI3	2984118	Bacteria	Bacteria	322	1.52e-83	NTclustered	gi\|2321225508\|dbj\|AP026946.1\|	2984118	g269488	i0	91.139	2.91803278688525	237	21	97	0	8	244	3055887	3055651	Bacteriovorax sp. HI3 DNA, complete genome	blastn	712	322	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp. HI3
6277405	6277405	PRJNA682078_P_NODE_282025_length_242_cov_0.911243_g280248_i0	PRJNA682078	282025	242	0.911243	2.20520806	Bacteriovorax	146784	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g280248	i0	100	10.5537190082645	242	0	100	0	1	242	1661712	1661953	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	2554	448	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
7038950	7038950	PRJNA682078_P_NODE_213086_length_255_cov_2.510989_g211309_i0	PRJNA682078	213086	255	2.510989	6.40302195	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	211	3.61e-50	NTclustered	gi\|347589306\|gb\|CP002382.1\|	856793	g211309	i0	82.305	15.2078431372549	243	43	95	0	1	243	1584346	1584104	Micavibrio aeruginosavorus ARL-13, complete genome	blastn	3878	211	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
7550753	7550753	PRJNA682078_P_NODE_214166_length_255_cov_1.291209_g212389_i0	PRJNA682078	214166	255	1.291209	3.29258295	Bdellovibrio	958	Bacteria	Bacteria	451	1.95e-122	NTclustered	gi\|2663425168\|dbj\|AP029173.1\|	3113893	g212389	i0	98.814	16.1803921568627	253	3	99	0	3	255	2943861	2943609	Bdellovibrio sp. CKG001 DNA, complete genome	blastn	4126	455	0.991208791208791	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CKG001
7552071	7552071	PRJNA682078_P_NODE_71666_length_408_cov_1.847761_g69891_i0	PRJNA682078	71666	408	1.847761	7.53886488	Bdellovibrio	958	Bacteria	Bacteria	726	0	NTclustered	gi\|1210342126\|gb\|CP020946.1\|	959	g69891	i0	98.775	205.561274509804	408	5	100	0	1	408	2948434	2948027	Bdellovibrio bacteriovorus strain SSB218315, complete genome	blastn	83869	726	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
8313995	8313995	PRJNA682078_P_NODE_231587_length_250_cov_0.870056_g229810_i0	PRJNA682078	231587	250	0.870056	2.17514	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	213	9.81e-51	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g229810	i0	82.8	2.008	250	31	99	7	4	250	3691891	3691651	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	502	213	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
8315065	8315065	PRJNA682078_P_NODE_274447_length_243_cov_1.270588_g272670_i0	PRJNA682078	274447	243	1.270588	3.08752884	Bacteriovorax stolpii	960	Bacteria	Bacteria	287	5.52e-73	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g272670	i0	88.285	35.40329218107	239	28	98	0	4	242	1854516	1854278	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	8603	287	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
10863440	10863440	PRJNA682078_P_NODE_175909_length_277_cov_1.441176_g174132_i0	PRJNA682078	175909	277	1.441176	3.99205752	Bacteriovorax stolpii	960	Bacteria	Bacteria	303	6.37e-78	NTclustered	gi\|1326041851\|gb\|CP025704.1\|	960	g174132	i0	87.266	1.92779783393502	267	33	96	1	12	277	2715853	2715587	Bacteriovorax stolpii strain DSM 12778 chromosome, complete genome	blastn	534	303	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
12140363	12140363	PRJNA682078_P_NODE_238070_length_249_cov_0.875000_g236293_i0	PRJNA682078	238070	249	0.875	2.17875	Bacteriovorax sp. HI3	2984118	Bacteria	Bacteria	267	7.39e-67	NTclustered	gi\|2321225508\|dbj\|AP026946.1\|	2984118	g236293	i0	86.179	1.88755020080321	246	34	99	0	3	248	598477	598722	Bacteriovorax sp. HI3 DNA, complete genome	blastn	470	267	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp. HI3
13415331	13415331	PRJNA682078_P_NODE_25391_length_677_cov_2.269868_g23680_i0	PRJNA682078	25391	677	2.269868	15.36700636	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	531	7.109999999999999e-146	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g23680	i0	81.791	301.096011816839	659	97	96	20	31	677	3251792	3251145	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	203842	531	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
15961831	15961831	PRJNA682078_P_NODE_160553_length_287_cov_0.995327_g158776_i0	PRJNA682078	160553	287	0.995327	2.85658849	Peredibacter starrii	28202	Bacteria	Bacteria	503	6.1e-138	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g158776	i0	98.258	134.177700348432	287	5	100	0	1	287	512689	512975	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	38509	503	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
15963642	15963642	PRJNA682078_P_NODE_233593_length_249_cov_1.818182_g231816_i0	PRJNA682078	233593	249	1.818182	4.52727318	Bacteriovorax stolpii	960	Bacteria	Bacteria	309	1.21e-79	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g231816	i0	89.669	2.93975903614458	242	25	97	0	8	249	1168414	1168655	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	732	309	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
18513516	18513516	PRJNA682078_P_NODE_257035_length_246_cov_0.890173_g255258_i0	PRJNA682078	257035	246	0.890173	2.18982558	Bacteriovorax stolpii	960	Bacteria	Bacteria	195	3.49e-45	NTclustered	gi\|1326041851\|gb\|CP025704.1\|	960	g255258	i0	94.444	0.51219512195122	126	7	51	0	8	133	1544939	1545064	Bacteriovorax stolpii strain DSM 12778 chromosome, complete genome	blastn	126	195	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
23613188	23613188	PRJNA682078_P_NODE_211419_length_256_cov_2.153005_g209642_i0	PRJNA682078	211419	256	2.153005	5.5116928	Bdellovibrio sp. HCB288	3394355	Bacteria	Bacteria	226	1.3e-54	NTclustered	gi\|2895994964\|gb\|CP178619.1\|	3394355	g209642	i0	82.677	4.8203125	254	44	99	0	3	256	2916740	2916487	Bdellovibrio sp. HCB288 chromosome, complete genome	blastn	1234	226	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB288
24886690	24886690	PRJNA682078_P_NODE_221280_length_251_cov_1.460674_g219503_i0	PRJNA682078	221280	251	1.460674	3.66629174	Bdellovibrio sp. HCB-162	3394234	Bacteria	Bacteria	222	1.64e-53	NTclustered	gi\|2898207634\|gb\|CP178861.1\|	3394234	g219503	i0	83.613	0.948207171314741	238	37	94	2	15	251	936232	936468	Bdellovibrio sp. HCB-162 chromosome, complete genome	blastn	238	222	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB-162
24887386	24887386	PRJNA682078_P_NODE_249420_length_247_cov_0.885057_g247643_i0	PRJNA682078	249420	247	0.885057	2.18609079	Bacteriovorax stolpii	960	Bacteria	Bacteria	230	9.61e-56	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g247643	i0	83.401	2	247	41	100	0	1	247	2749909	2750155	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	494	230	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii

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