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

21 rows where analysis = "blastn", bioproject = "PRJNA1160211" 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
1585420	1585420	PRJNA1160211_S_NODE_81422_length_495_cov_6.272512_g80205_i0	PRJNA1160211	81422	495	6.272512	31.0489344	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	599	1.38e-166	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g80205	i0	88.485	6.26262626262626	495	57	100	0	1	495	858576	859070	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	3100	599	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
2860481	2860481	PRJNA1160211_S_NODE_189763_length_322_cov_16.369478_g188530_i0	PRJNA1160211	189763	322	16.369478	52.70971916	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	272	2.1299999999999993e-68	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g188530	i0	85.036	289.347826086957	274	34	84	7	30	299	3250325	3250055	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	93170	272	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
3589379	3589379	PRJNA1160211_S_NODE_4583_length_966_cov_43.512878_g4044_i0	PRJNA1160211	4583	966	43.512878	420.33440148	Peredibacter	263370	Bacteria	Bacteria	1598	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g4044	i0	97.346	235.626293995859	942	21	97	2	23	960	511249	512190	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	227615	1598	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
4866200	4866200	PRJNA1160211_S_NODE_126004_length_411_cov_6.325444_g124773_i0	PRJNA1160211	126004	411	6.325444	25.99757484	Bdellovibrio	958	Bacteria	Bacteria	682	0	NTclustered	gi\|1673538969\|gb\|MK159102.1\|	28201	g124773	i0	97.264	97.301703163017	402	11	98	0	10	411	254	655	Bdellovibrio sp. strain BDN-1 16S ribosomal RNA gene, partial sequence	blastn	39991	682	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
4866402	4866402	PRJNA1160211_S_NODE_177644_length_337_cov_5.731061_g176411_i0	PRJNA1160211	177644	337	5.731061	19.31367557	Bacteriovorax	146784	Bacteria	Bacteria	569	7.099999999999998e-158	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g176411	i0	99.363	224.056379821958	314	2	93	0	1	314	1661719	1661406	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	75507	569	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
5413985	5413985	PRJNA1160211_S_NODE_99045_length_459_cov_4.945596_g97820_i0	PRJNA1160211	99045	459	4.945596	22.70028564	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	108	9.37e-19	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g97820	i0	85.577	0.450980392156863	104	14	23	1	1	104	254441	254543	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	207	108	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
6687053	6687053	PRJNA1160211_S_NODE_126666_length_410_cov_4.946588_g125434_i0	PRJNA1160211	126666	410	4.946588	20.2810108	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	241	7.83e-59	NTclustered	gi\|2800941903\|gb\|CP168974.1\|	959	g125434	i0	78.133	96.8	407	70	98	15	8	407	783660	784054	Bdellovibrio bacteriovorus strain s4 chromosome, complete genome	blastn	39688	241	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
7416357	7416357	PRJNA1160211_S_NODE_196706_length_314_cov_6.813278_g195473_i0	PRJNA1160211	196706	314	6.813278	21.39369292	Bdellovibrio	958	Bacteria	Bacteria	494	4.06e-135	NTclustered	gi\|2800917394\|gb\|CP168972.1\|	959	g195473	i0	97.251	86.1592356687898	291	8	93	0	1	291	749455	749165	Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome	blastn	27054	494	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
7416961	7416961	PRJNA1160211_S_NODE_83586_length_490_cov_26.067146_g82367_i0	PRJNA1160211	83586	490	26.067146	127.7290154	Halobacteriovorax	1652133	Bacteria	Bacteria	627	6.24e-175	NTclustered	gi\|1249980216\|gb\|CP017414.1\|	97084	g82367	i0	90.832	177.916326530612	469	41	96	2	21	488	1867598	1867131	Halobacteriovorax marinus strain BE01 chromosome, complete genome	blastn	87179	627	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae	Halobacteriovorax	Halobacteriovorax marinus
9966983	9966983	PRJNA1160211_S_NODE_41348_length_604_cov_25.755179_g40205_i0	PRJNA1160211	41348	604	25.755179	155.56128116	Bacteriovorax	146784	Bacteria	Bacteria	1061	0	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g40205	i0	100	230.869205298013	574	0	95	0	22	595	1661602	1662175	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	139445	1061	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
12517789	12517789	PRJNA1160211_S_NODE_92850_length_471_cov_8.638191_g91627_i0	PRJNA1160211	92850	471	8.638191	40.68587961	Peredibacter	263370	Bacteria	Bacteria	531	4.8299999999999985e-146	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g91627	i0	88.053	180.288747346072	452	49	95	5	23	471	510684	511133	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	84916	531	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
13792236	13792236	PRJNA1160211_S_NODE_51471_length_571_cov_16.403614_g50304_i0	PRJNA1160211	51471	571	16.403614	93.66463594	Bacteriovorax	146784	Bacteria	Bacteria	163	2.4899999999999996e-35	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g50304	i0	88.971	19.8353765323993	136	10	24	3	312	446	3062722	3062591	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	11326	163	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
13792297	13792297	PRJNA1160211_S_NODE_6311_length_900_cov_13.126965_g5687_i0	PRJNA1160211	6311	900	13.126965	118.142685	Bdellovibrio	958	Bacteria	Bacteria	1153	0	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g5687	i0	90.909	189.163333333333	869	64	97	8	24	878	815799	816666	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	170247	1153	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
14339672	14339672	PRJNA1160211_S_NODE_70412_length_520_cov_45.434004_g69205_i0	PRJNA1160211	70412	520	45.434004	236.2568208	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	817	0	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g69205	i0	96.371	124.284615384615	496	18	95	0	2	497	1292755	1292260	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	64628	817	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
18890596	18890596	PRJNA1160211_S_NODE_75955_length_507_cov_14.693548_g74741_i0	PRJNA1160211	75955	507	14.693548	74.49628836	Bacteriovorax	146784	Bacteria	Bacteria	850	0	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g74741	i0	98.347	216.41617357002	484	8	95	0	1	484	1660830	1660347	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	109723	850	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
19436320	19436320	PRJNA1160211_S_NODE_293076_length_227_cov_2.980519_g291843_i0	PRJNA1160211	293076	227	2.980519	6.76577813	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	298	2.35e-76	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g291843	i0	92.344	164.651982378855	209	16	92	0	10	218	3446535	3446327	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	37376	298	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
20710650	20710650	PRJNA1160211_S_NODE_144577_length_382_cov_8.724919_g143344_i0	PRJNA1160211	144577	382	8.724919	33.32919058	Bacteriovorax stolpii	960	Bacteria	Bacteria	246	1.5599999999999999e-60	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g143344	i0	79.37	1.85078534031414	349	72	91	0	16	364	2723508	2723160	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	707	246	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
20712117	20712117	PRJNA1160211_S_NODE_7437_length_868_cov_41.074214_g6761_i0	PRJNA1160211	7437	868	41.074214	356.52417752	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	1050	0	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g6761	i0	89.511	183.373271889401	839	75	96	9	13	843	3251414	3250581	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	159168	1050	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
21986329	21986329	PRJNA1160211_S_NODE_188278_length_324_cov_4.944223_g187045_i0	PRJNA1160211	188278	324	4.944223	16.01928252	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	370	7.4e-98	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g187045	i0	88.925	168.311728395062	307	25	93	9	21	322	1292260	1292562	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	54533	370	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
21987452	21987452	PRJNA1160211_S_NODE_69998_length_521_cov_48.899554_g68792_i0	PRJNA1160211	69998	521	48.899554	254.76667634	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	414	5.6499999999999996e-111	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g68792	i0	81.909	183.264875239923	503	80	95	10	26	521	3448540	3448042	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	95481	414	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
23262226	23262226	PRJNA1160211_S_NODE_245179_length_266_cov_1.227979_g243946_i0	PRJNA1160211	245179	266	1.227979	3.26642414	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	427	3.4599999999999998e-115	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g243946	i0	98.354	79.4172932330827	243	4	91	0	1	243	779399	779157	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	21125	427	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);;