metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJEB20058" and tax

21 rows where analysis = "blastn", bioproject = "PRJEB20058" 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
25514340	25514340	PRJEB20058_P_NODE_135929_length_335_cov_12.065693_g133109_i0	PRJEB20058	135929	335	12.065693	40.42007155	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	163	1.4e-35	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g133109	i0	80.088	1.17313432835821	226	39	81	4	115	335	469623	469399	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	393	163	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
25514804	25514804	PRJEB20058_P_NODE_146017_length_319_cov_35.096899_g143196_i0	PRJEB20058	146017	319	35.096899	111.95910781	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	207	6.03e-49	NTclustered	gi\|2621706492\|emb\|OY764265.1\|	3034175	g143196	i0	82.52	227.689655172414	246	33	75	7	80	319	1695286	1695527	MAG: Bdellovibrionota bacterium isolate efddfb02-ff0c-4ac5-ae96-c61d995422a3 genome assembly, chromosome: 1	blastn	72633	207	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
25515229	25515229	PRJEB20058_P_NODE_155513_length_306_cov_1.644898_g152690_i0	PRJEB20058	155513	306	1.644898	5.03338788	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	195	4.48e-45	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g152690	i0	86.413	378.111111111111	184	17	58	7	114	290	467860	468042	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	115702	195	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
25611895	25611895	PRJEB20058_P_NODE_106601_length_392_cov_5.746224_g103793_i0	PRJEB20058	106601	392	5.746224	22.52519808	Bacteriovorax	146784	Bacteria	Bacteria	621	2.2799999999999997e-173	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g103793	i0	97.521	2.7780612244898	363	9	93	0	10	372	1705830	1706192	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	1089	627	0.990430622009569	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
25649117	25649117	PRJEB20058_P_NODE_109954_length_385_cov_2.425926_g107143_i0	PRJEB20058	109954	385	2.425926	9.3398151	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	113	1.66e-20	NTclustered	gi\|2907625691\|emb\|OZ223251.1\|	2081706	g107143	i0	79.545	15.5948051948052	176	23	44	12	130	297	958091	957921	MAG: Bacteriovoracaceae bacterium isolate 56684ba0-df17-47c9-bcf5-ee076427a4fa genome assembly, chromosome: 1	blastn	6004	113	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
25649483	25649483	PRJEB20058_P_NODE_118466_length_367_cov_11.787582_g115651_i0	PRJEB20058	118466	367	11.787582	43.26042594	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	219	3.2499999999999993e-52	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g115651	i0	78.932	128.929155313351	337	59	90	12	31	361	3250155	3250485	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	47317	219	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
25649488	25649488	PRJEB20058_P_NODE_118554_length_367_cov_5.441176_g115739_i0	PRJEB20058	118554	367	5.441176	19.96911592	Silvanigrella aquatica	1915309	Bacteria	Bacteria	544	4.72e-150	NTclustered	gi\|1114626566\|gb\|CP017834.1\|	1915309	g115739	i0	93.906	86.9482288828338	361	21	98	1	1	361	390594	390235	Silvanigrella aquatica strain MWH-Nonnen-W8red chromosome	blastn	31910	544	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Silvanigrella	Silvanigrella aquatica
25749124	25749124	PRJEB20058_P_NODE_165426_length_293_cov_2.206897_g162603_i0	PRJEB20058	165426	293	2.206897	6.46620821	Bdellovibrio	958	Bacteria	Bacteria	150	9.37e-32	NTclustered	gi\|1210342126\|gb\|CP020946.1\|	959	g162603	i0	76.948	292.095563139932	308	44	99	21	5	293	2950071	2950370	Bdellovibrio bacteriovorus strain SSB218315, complete genome	blastn	85584	150	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
25788226	25788226	PRJEB20058_P_NODE_177483_length_279_cov_1.178899_g174660_i0	PRJEB20058	177483	279	1.178899	3.28912821	uncultured Oligoflexales bacterium	2735263	Bacteria	Bacteria	226	1.43e-54	NTclustered	gi\|2531963191\|emb\|OY282434.1\|	2735263	g174660	i0	84.783	403.508960573477	230	30	82	4	5	233	955329	955554	MAG: uncultured Oligoflexales bacterium genome assembly, chromosome: 1	blastn	112579	226	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales			uncultured Oligoflexales bacterium
25886893	25886893	PRJEB20058_P_NODE_64299_length_521_cov_18.156522_g61534_i0	PRJEB20058	64299	521	18.156522	94.59547962	Peredibacter	263370	Bacteria	Bacteria	682	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g61534	i0	91.532	242.959692898273	496	40	95	2	5	499	511178	510684	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	126582	688	0.991279069767442	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
25921651	25921651	PRJEB20058_P_NODE_113980_length_376_cov_8.253968_g111166_i0	PRJEB20058	113980	376	8.253968	31.03491968	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	545	1.35e-150	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g111166	i0	93.681	126.031914893617	364	23	97	0	13	376	1292425	1292788	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	47388	545	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
25930268	25930268	PRJEB20058_P_NODE_82756_length_454_cov_7.106870_g79972_i0	PRJEB20058	82756	454	7.10687	32.2651898	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	558	2.1299999999999995e-154	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g79972	i0	90.398	183.015418502203	427	38	94	3	6	431	3251078	3250654	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	83089	558	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
26066736	26066736	PRJEB20058_P_NODE_92069_length_427_cov_21.863388_g89270_i0	PRJEB20058	92069	427	21.863388	93.35666676	uncultured Oligoflexales bacterium	2735263	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|2531963191\|emb\|OY282434.1\|	2735263	g89270	i0	100	0.199063231850117	29	0	7	0	43	71	74455	74427	MAG: uncultured Oligoflexales bacterium genome assembly, chromosome: 1	blastn	85	54.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales			uncultured Oligoflexales bacterium
26193465	26193465	PRJEB20058_P_NODE_105070_length_395_cov_16.994012_g102262_i0	PRJEB20058	105070	395	16.994012	67.1263474	Bacteriovorax sp. HI3	2984118	Bacteria	Bacteria	220	9.79e-53	NTclustered	gi\|2321225508\|dbj\|AP026946.1\|	2984118	g102262	i0	78.763	2.82784810126582	372	47	88	19	18	364	2309567	2309203	Bacteriovorax sp. HI3 DNA, complete genome	blastn	1117	220	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp. HI3
26195499	26195499	PRJEB20058_P_NODE_149070_length_315_cov_2.440945_g146248_i0	PRJEB20058	149070	315	2.440945	7.68897675	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	189	2.15e-43	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g146248	i0	78.571	6.16825396825397	308	50	95	16	10	309	33824	34123	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	1943	189	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
26198833	26198833	PRJEB20058_P_NODE_230342_length_231_cov_8.117647_g227517_i0	PRJEB20058	230342	231	8.117647	18.75176457	Peredibacter starrii	28202	Bacteria	Bacteria	351	1.8199999999999998e-92	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g227517	i0	97.115	85.5411255411255	208	6	90	0	1	208	510891	510684	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	19760	351	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
26201485	26201485	PRJEB20058_P_NODE_61638_length_533_cov_17.097458_g58876_i0	PRJEB20058	61638	533	17.097458	91.12945114	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	789	0	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g58876	i0	94.521	91.8724202626642	511	28	96	0	1	511	1292770	1292260	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	48968	789	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
26337284	26337284	PRJEB20058_P_NODE_60703_length_538_cov_1.073375_g57943_i0	PRJEB20058	60703	538	1.073375	5.7747575	Peredibacter starrii	28202	Bacteria	Bacteria	324	1.01e-83	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g57943	i0	80	0.8810408921933092	445	84	82	5	45	485	3912574	3912131	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	474	324	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
26337721	26337721	PRJEB20058_P_NODE_69263_length_501_cov_3.047727_g66492_i0	PRJEB20058	69263	501	3.047727	15.26911227	Bdellovibrio bacteriovorus W	765869	Bacteria	Bacteria	728	0	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g66492	i0	94.154	173.001996007984	479	27	95	1	1	478	610755	610277	Bdellovibrio bacteriovorus W, complete genome	blastn	86674	728	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
26428341	26428341	PRJEB20058_P_NODE_117559_length_369_cov_3.909091_g114744_i0	PRJEB20058	117559	369	3.909091	14.42454579	Bdellovibrio	958	Bacteria	Bacteria	612	1.2799999999999999e-170	NTclustered	gi\|2663425168\|dbj\|AP029173.1\|	3113893	g114744	i0	98.011	84.7994579945799	352	7	95	0	1	352	756222	755871	Bdellovibrio sp. CKG001 DNA, complete genome	blastn	31291	612	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CKG001
26467698	26467698	PRJEB20058_P_NODE_152368_length_310_cov_4.188755_g149545_i0	PRJEB20058	152368	310	4.188755	12.9851405	Peredibacter starrii	28202	Bacteria	Bacteria	350	9.17e-92	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g149545	i0	91.12	21.9677419354839	259	22	84	1	21	279	512077	512334	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	6810	350	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);;