metadata: contig_metadata: 17 rows where bioproject = "PRJNA929952", tax_kingdom = "Pseudomonadati" and tax

17 rows where bioproject = "PRJNA929952", tax_kingdom = "Pseudomonadati" 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
2184533	2184533	PRJNA929952_P_NODE_622_length_1317_cov_74.841615_g424_i0	PRJNA929952	622	1317	74.841615	985.66406955	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	1402	0	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g424	i0	85.86	193.273348519362	1372	133	100	28	1	1317	3446654	3448019	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	254541	1402	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
3460034	3460034	PRJNA929952_P_NODE_1763_length_883_cov_10.576112_g253_i2	PRJNA929952	1763	883	10.576112	93.38706896	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	135	8.6e-27	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g253	i2	78.341	10.2049830124575	217	41	24	6	49	262	609805	609592	Bdellovibrio bacteriovorus W, complete genome	blastn	9011	135	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
3806823	3806823	PRJNA929952_P_NODE_15103_length_265_cov_6.953390_g13809_i0	PRJNA929952	15103	265	6.95339	18.4264835	Bdellovibrio	958	Bacteria	Bacteria	412	9.64e-111	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g13809	i0	94.757	145.958490566038	267	11	100	2	1	265	945277	945012	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	38679	412	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
10183479	10183479	PRJNA929952_P_NODE_16988_length_244_cov_433.288372_g15694_i0	PRJNA929952	16988	244	433.288372	1057.22362768	Bdellovibrio	958	Bacteria	Bacteria	353	5.389999999999998e-93	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g15694	i0	93.333	262.180327868852	240	15	98	1	5	244	1606714	1606952	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	63972	353	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
10183481	10183481	PRJNA929952_P_NODE_17568_length_238_cov_8.650718_g16274_i0	PRJNA929952	17568	238	8.650718	20.58870884	Pseudobdellovibrio	2862745	Bacteria	Bacteria	270	5.42e-68	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g16274	i0	87.342	87.0210084033613	237	28	99	2	3	238	1512	1277	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	20711	270	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
11458523	11458523	PRJNA929952_P_NODE_10669_length_348_cov_7.501567_g9380_i0	PRJNA929952	10669	348	7.501567	26.10545316	Pseudobdellovibrio	2862745	Bacteria	Bacteria	503	7.57e-138	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g9380	i0	92.614	93.4080459770115	352	22	100	4	1	348	1163	1514	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	32506	503	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
12734223	12734223	PRJNA929952_P_NODE_190_length_1921_cov_54.182347_g122_i0	PRJNA929952	190	1921	54.182347	1040.84288587	Bdellovibrio	958	Bacteria	Bacteria	1435	0	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g122	i0	84.015	139.377407600208	1564	176	78	39	419	1921	1676689	1678239	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	267744	1448	0.991022099447514	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
12734237	12734237	PRJNA929952_P_NODE_5230_length_544_cov_14.592233_g4180_i0	PRJNA929952	5230	544	14.592233	79.38174752	Bdellovibrio	958	Bacteria	Bacteria	889	0	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g4180	i0	96.147	92.3345588235294	545	20	100	1	1	544	784366	784910	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	50230	889	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
13662787	13662787	PRJNA929952_P_NODE_191_length_1919_cov_52.726984_g123_i0	PRJNA929952	191	1919	52.726984	1011.83082296	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	1467	0	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g123	i0	84.19	139.108910891089	1575	182	79	34	403	1919	3448219	3446654	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	266950	1467	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
17487446	17487446	PRJNA929952_P_NODE_494_length_1420_cov_51.859813_g331_i0	PRJNA929952	494	1420	51.859813	736.4093446	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	894	0	NTclustered	gi\|2893356071\|emb\|OZ220494.1\|	2053517	g331	i0	78.854	229.026056338028	1466	206	97	67	40	1420	966956	965510	MAG: Bdellovibrionales bacterium isolate 95f108ca-4012-4f55-a596-77f5f94b2342 genome assembly, chromosome: 1	blastn	325217	894	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
18760802	18760802	PRJNA929952_P_NODE_7615_length_439_cov_6.836585_g1671_i1	PRJNA929952	7615	439	6.836585	30.01260815	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	381	4.759999999999999e-101	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g1671	i1	83.135	165.305239179954	421	67	95	3	1	418	3448494	3448075	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	72569	381	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
20035749	20035749	PRJNA929952_P_NODE_12056_length_317_cov_4.065972_g10763_i0	PRJNA929952	12056	317	4.065972	12.88913124	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	492	1.48e-134	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g10763	i0	94.637	44.7728706624606	317	17	100	0	1	317	1292356	1292672	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	14193	492	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
20381134	20381134	PRJNA929952_P_NODE_12356_length_311_cov_4.152482_g11063_i0	PRJNA929952	12356	311	4.152482	12.91421902	Peredibacter	263370	Bacteria	Bacteria	553	6.539999999999998e-153	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g11063	i0	98.714	252.781350482315	311	4	100	0	1	311	511507	511197	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	78615	553	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
22932647	22932647	PRJNA929952_P_NODE_7398_length_446_cov_37.014388_g6186_i0	PRJNA929952	7398	446	37.014388	165.08417048	Bdellovibrio	958	Bacteria	Bacteria	652	0	NTclustered	gi\|2800917394\|gb\|CP168972.1\|	959	g6186	i0	93.258	191.784753363229	445	27	99	3	2	445	747621	748063	Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome	blastn	85536	652	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
23861472	23861472	PRJNA929952_P_NODE_2939_length_717_cov_44.811047_g2193_i0	PRJNA929952	2939	717	44.811047	321.29520699	Peredibacter starrii	28202	Bacteria	Bacteria	1153	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g2193	i0	96.051	131.507670850767	709	26	99	1	11	717	512512	511804	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	94291	1153	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
24206406	24206406	PRJNA929952_P_NODE_6339_length_488_cov_62.607843_g5203_i0	PRJNA929952	6339	488	62.607843	305.52627384	Bdellovibrio	958	Bacteria	Bacteria	261	7.26e-65	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g5203	i0	77.273	101.762295081967	506	75	97	21	1	472	1676863	1676364	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	49660	261	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
25135326	25135326	PRJNA929952_P_NODE_6340_length_488_cov_48.662309_g5204_i0	PRJNA929952	6340	488	48.662309	237.47206792	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	261	7.26e-65	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g5204	i0	77.439	100.559426229508	492	75	95	17	27	488	665461	665946	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	49073	261	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius

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