metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA493828" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA493828" 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
474478	474478	PRJNA493828_P_NODE_11821_length_337_cov_1.026515_g11402_i0	PRJNA493828	11821	337	1.026515	3.45935555	Bacteriovorax stolpii	960	Bacteria	Bacteria	590	5.449999999999998e-164	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g11402	i0	98.22	187.320474777448	337	6	100	0	1	337	1661418	1661082	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	63127	590	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
475016	475016	PRJNA493828_P_NODE_46541_length_207_cov_5.731343_g46122_i0	PRJNA493828	46541	207	5.731343	11.86388001	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	320	4.5e-83	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g46122	i0	94.66	222.222222222222	206	11	99	0	1	206	778035	777830	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	46000	320	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
1106662	1106662	PRJNA493828_P_NODE_7861_length_400_cov_4.137615_g7446_i0	PRJNA493828	7861	400	4.137615	16.55046	Peredibacter	263370	Bacteria	Bacteria	708	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g7446	i0	98.507	239.0975	402	4	100	1	1	400	511926	511525	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	95639	713	0.992987377279102	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
1749624	1749624	PRJNA493828_P_NODE_27282_length_263_cov_3.863158_g26863_i0	PRJNA493828	27282	263	3.863158	10.16010554	Peredibacter starrii	28202	Bacteria	Bacteria	479	9.29e-131	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g26863	i0	99.618	101.456273764259	262	1	99	0	2	263	512164	511903	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	26683	479	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
3657585	3657585	PRJNA493828_P_NODE_19323_length_290_cov_1.423963_g18904_i0	PRJNA493828	19323	290	1.423963	4.1294927	Pseudobdellovibrio	2862745	Bacteria	Bacteria	379	1.08e-100	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g18904	i0	90.345	130	290	26	99	2	1	289	309	21	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	37700	379	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
3657702	3657702	PRJNA493828_P_NODE_29603_length_257_cov_1.804348_g29184_i0	PRJNA493828	29603	257	1.804348	4.63717436	Bdellovibrio	958	Bacteria	Bacteria	246	9.99e-61	NTclustered	gi\|2800917394\|gb\|CP168972.1\|	959	g29184	i0	86.087	124.241245136187	230	30	89	2	28	256	747864	748092	Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome	blastn	31930	246	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
5578548	5578548	PRJNA493828_P_NODE_48625_length_196_cov_7.682927_g48206_i0	PRJNA493828	48625	196	7.682927	15.05853692	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	237	4.36e-58	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g48206	i0	90.503	181.102040816327	179	17	91	0	15	193	1677456	1677278	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	35496	237	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
6852717	6852717	PRJNA493828_P_NODE_9146_length_374_cov_3.810631_g8729_i0	PRJNA493828	9146	374	3.810631	14.25175994	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	274	6.98e-69	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g8729	i0	80.495	244.379679144385	364	66	96	4	2	361	3448038	3448400	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	91398	274	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
8759269	8759269	PRJNA493828_P_NODE_10647_length_351_cov_3.309353_g10228_i0	PRJNA493828	10647	351	3.309353	11.61582903	Pseudobdellovibrio	2862745	Bacteria	Bacteria	503	7.619999999999998e-138	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g10228	i0	92.571	84.8062678062678	350	26	99	0	2	351	1440	1789	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	29767	503	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
8759306	8759306	PRJNA493828_P_NODE_12787_length_326_cov_1.177866_g12368_i0	PRJNA493828	12787	326	1.177866	3.83984316	Pseudobdellovibrio	2862745	Bacteria	Bacteria	243	1.69e-59	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g12368	i0	81.013	161.033742331288	316	51	95	8	10	320	462	151	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	52497	243	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
9402700	9402700	PRJNA493828_P_NODE_30208_length_255_cov_3.362637_g29789_i0	PRJNA493828	30208	255	3.362637	8.57472435	Peredibacter starrii	28202	Bacteria	Bacteria	433	7.08e-117	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g29789	i0	97.255	32.7333333333333	255	7	100	0	1	255	512492	512238	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	8347	433	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
10035077	10035077	PRJNA493828_P_NODE_34628_length_247_cov_3.229885_g34209_i0	PRJNA493828	34628	247	3.229885	7.97781595	Bacteriovorax	146784	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g34209	i0	100	197.121457489879	247	0	100	0	1	247	1660824	1660578	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	48689	457	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
10678462	10678462	PRJNA493828_P_NODE_40569_length_238_cov_4.260606_g40150_i0	PRJNA493828	40569	238	4.260606	10.14024228	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	318	1.91e-82	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g40150	i0	92.76	181.924369747899	221	15	93	1	16	236	3250971	3250752	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	43298	318	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
11309570	11309570	PRJNA493828_P_NODE_19169_length_290_cov_4.663594_g18750_i0	PRJNA493828	19169	290	4.663594	13.5244226	Peredibacter	263370	Bacteria	Bacteria	512	1.02e-140	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g18750	i0	98.951	170.089655172414	286	3	99	0	4	289	511221	511506	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	49326	512	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
13228259	13228259	PRJNA493828_P_NODE_12711_length_326_cov_5.422925_g12292_i0	PRJNA493828	12711	326	5.422925	17.6787355	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	246	1.31e-60	NTclustered	gi\|2893356065\|emb\|OZ220488.1\|	2053517	g12292	i0	86.607	30.5276073619632	224	28	68	2	32	254	730260	730038	MAG: Bdellovibrionales bacterium isolate 0d1acec5-ee6a-42a0-9e8e-8bc2840f726d genome assembly, chromosome: 1	blastn	9952	246	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
13860167	13860167	PRJNA493828_P_NODE_29631_length_257_cov_1.668478_g29212_i0	PRJNA493828	29631	257	1.668478	4.28798846	Bacteriovorax	146784	Bacteria	Bacteria	464	2.5299999999999998e-126	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g29212	i0	99.222	234.517509727626	257	2	100	0	1	257	1660363	1660619	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	60271	464	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
14503450	14503450	PRJNA493828_P_NODE_29752_length_256_cov_8.240437_g29333_i0	PRJNA493828	29752	256	8.240437	21.09551872	Peredibacter starrii	28202	Bacteria	Bacteria	451	1.96e-122	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g29333	i0	98.814	128.23046875	253	3	99	0	1	253	511238	510986	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	32827	451	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
14503685	14503685	PRJNA493828_P_NODE_46292_length_209_cov_4.352941_g45873_i0	PRJNA493828	46292	209	4.352941	9.09764669	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	267	6.01e-67	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g45873	i0	89.904	87.0909090909091	208	20	99	1	1	208	3447226	3447020	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	18202	267	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
15134665	15134665	PRJNA493828_P_NODE_36172_length_245_cov_2.726744_g35753_i0	PRJNA493828	36172	245	2.726744	6.6805228	Bacteriovorax	146784	Bacteria	Bacteria	420	5.26e-113	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g35753	i0	100	309.342857142857	227	0	93	0	16	242	1663251	1663025	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	75789	420	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
15134740	15134740	PRJNA493828_P_NODE_44472_length_223_cov_11.493333_g44053_i0	PRJNA493828	44472	223	11.493333	25.63013259	Peredibacter	263370	Bacteria	Bacteria	353	4.849999999999999e-93	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g44053	i0	97.129	58.6008968609865	209	6	94	0	1	209	513390	513598	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	13068	353	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
15777157	15777157	PRJNA493828_P_NODE_17753_length_298_cov_2.106667_g17334_i0	PRJNA493828	17753	298	2.106667	6.27786766	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	327	4.11e-85	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g17334	i0	86.601	112.744966442953	306	30	99	9	3	298	3447104	3447408	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	33598	327	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
16409079	16409079	PRJNA493828_P_NODE_20933_length_284_cov_1.872038_g20514_i0	PRJNA493828	20933	284	1.872038	5.31658792	Bdellovibrio	958	Bacteria	Bacteria	418	2.2399999999999995e-112	NTclustered	gi\|2328635023\|gb\|CP106855.1\|	1732569	g20514	i0	93.333	216.035211267606	285	16	99	3	2	284	2945046	2945329	Bdellovibrio sp. SKB1291214 chromosome, complete genome	blastn	61354	418	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. SKB1291214
16409271	16409271	PRJNA493828_P_NODE_37873_length_243_cov_1.447059_g37454_i0	PRJNA493828	37873	243	1.447059	3.51635337	Peredibacter	263370	Bacteria	Bacteria	370	5.32e-98	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g37454	i0	94.215	286.497942386831	242	14	99	0	2	243	513541	513300	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	69619	370	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
23426928	23426928	PRJNA493828_P_NODE_16419_length_308_cov_3.889362_g16000_i0	PRJNA493828	16419	308	3.889362	11.97923496	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	453	6.75e-123	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g16000	i0	95.423	91.6720779220779	284	13	92	0	25	308	779032	779315	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	28235	453	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);;