metadata: contig_metadata: 21 rows where bioproject = "PRJNA326068", tax_phylum = "Bdellovibrionota" and tax

21 rows where bioproject = "PRJNA326068", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"

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
389449	389449	PRJNA326068_P_NODE_3141_length_621_cov_7.125000_g2480_i0	PRJNA326068	3141	621	7.125	44.24625	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	505	3.9299999999999983e-138	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g2480	i0	85.421	154.512077294686	487	69	78	1	1	485	468802	469288	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	95952	505	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
1069192	1069192	PRJNA326068_P_NODE_10021_length_316_cov_12.874564_g9062_i0	PRJNA326068	10021	316	12.874564	40.68362224	Bdellovibrio	958	Bacteria	Bacteria	344	4.36e-90	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g9062	i0	86.901	352.193037974684	313	33	99	7	4	316	784503	784199	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	111293	344	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
1664155	1664155	PRJNA326068_P_NODE_4062_length_549_cov_9.942308_g3311_i0	PRJNA326068	4062	549	9.942308	54.58327092	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	809	0	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g3311	i0	94.476	193.905282331512	525	29	96	0	1	525	699974	699450	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	106454	809	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
3619878	3619878	PRJNA326068_P_NODE_6983_length_406_cov_2.740053_g6056_i0	PRJNA326068	6983	406	2.740053	11.12461518	Bacteriovorax	146784	Bacteria	Bacteria	660	0	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g6056	i0	98.4	224.647783251232	375	6	92	0	32	406	1662082	1661708	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	91207	660	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
3619884	3619884	PRJNA326068_P_NODE_8843_length_346_cov_155.826498_g7889_i0	PRJNA326068	8843	346	155.826498	539.15968308	Peredibacter	263370	Bacteria	Bacteria	630	3.3099999999999985e-176	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g7889	i0	99.709	233.621387283237	344	1	99	0	3	346	511170	511513	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	80833	630	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
4216757	4216757	PRJNA326068_P_NODE_7544_length_385_cov_132.275281_g6603_i0	PRJNA326068	7544	385	132.275281	509.25983185	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	340	7e-89	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g6603	i0	82.785	111.711688311688	395	55	100	9	1	385	469233	469624	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	43009	340	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
4897053	4897053	PRJNA326068_P_NODE_19344_length_159_cov_124.853846_g18381_i0	PRJNA326068	19344	159	124.853846	198.51761514	Pseudobdellovibrio	2862745	Bacteria	Bacteria	226	7.329999999999998e-55	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g18381	i0	93.96	359.276729559748	149	9	94	0	10	158	2864	2716	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	57125	226	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
4897064	4897064	PRJNA326068_P_NODE_6464_length_428_cov_2.922306_g5556_i0	PRJNA326068	6464	428	2.922306	12.50746968	Bdellovibrio	958	Bacteria	Bacteria	311	6.17e-80	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g5556	i0	80.607	92.4556074766355	428	61	97	20	1	416	784746	784329	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	39571	311	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
6767027	6767027	PRJNA326068_P_NODE_16046_length_209_cov_1.694444_g15083_i0	PRJNA326068	16046	209	1.694444	3.54138796	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	135	1.7700000000000002e-27	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g15083	i0	93.478	85.4688995215311	92	5	44	1	118	208	469805	469896	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	17863	135	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
7447088	7447088	PRJNA326068_P_NODE_8106_length_368_cov_122.678466_g7158_i0	PRJNA326068	8106	368	122.678466	451.45675488	Bdellovibrio	958	Bacteria	Bacteria	379	1.41e-100	NTclustered	gi\|2328635023\|gb\|CP106855.1\|	1732569	g7158	i0	85.637	178.247282608696	369	43	100	9	1	368	2945026	2944667	Bdellovibrio sp. SKB1291214 chromosome, complete genome	blastn	65595	379	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. SKB1291214
10593126	10593126	PRJNA326068_P_NODE_18129_length_178_cov_8.362416_g17166_i0	PRJNA326068	18129	178	8.362416	14.88510048	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	289	1.05e-73	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g17166	i0	96.067	330.308988764045	178	6	100	1	1	178	860108	860284	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	58795	289	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
11868071	11868071	PRJNA326068_P_NODE_6830_length_412_cov_24.394256_g5908_i0	PRJNA326068	6830	412	24.394256	100.50433472	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	364	4.4799999999999986e-96	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g5908	i0	82.816	125.152912621359	419	60	99	8	3	412	469624	469209	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	51563	364	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
13142982	13142982	PRJNA326068_P_NODE_16971_length_198_cov_4.130178_g16008_i0	PRJNA326068	16971	198	4.130178	8.17775244	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	209	9.63e-50	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g16008	i0	86.139	133.550505050505	202	19	98	6	1	195	469408	469209	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	26443	209	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
16966773	16966773	PRJNA326068_P_NODE_15574_length_213_cov_376.978261_g14611_i0	PRJNA326068	15574	213	376.978261	802.96369593	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	261	2.86e-65	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g14611	i0	88.732	157.150234741784	213	24	100	0	1	213	468748	468960	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	33473	261	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
21470921	21470921	PRJNA326068_P_NODE_3877_length_562_cov_79.988743_g3142_i0	PRJNA326068	3877	562	79.988743	449.53673566	Pseudobdellovibrio	2862745	Bacteria	Bacteria	717	0	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g3142	i0	89.912	232.387900355872	565	46	99	10	3	562	1560	1002	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	130602	717	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
22065852	22065852	PRJNA326068_P_NODE_12778_length_255_cov_4.168142_g11815_i0	PRJNA326068	12778	255	4.168142	10.6287621	Peredibacter starrii	28202	Bacteria	Bacteria	71.3	6.4e-8	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g11815	i0	88.333	17.9803921568627	60	5	23	2	195	253	512279	512337	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	4585	71.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
22746087	22746087	PRJNA326068_P_NODE_4138_length_543_cov_11.782101_g3311_i1	PRJNA326068	4138	543	11.782101	63.97680843	Bdellovibrio	958	Bacteria	Bacteria	656	0	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g3311	i1	89.225	207.764272559853	529	51	97	6	1	525	666541	666015	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	112816	656	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
23341327	23341327	PRJNA326068_P_NODE_16279_length_206_cov_5.559322_g15316_i0	PRJNA326068	16279	206	5.559322	11.45220332	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	257	3.5600000000000004e-64	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g15316	i0	89.32	171.825242718447	206	21	100	1	1	206	469030	469234	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	35396	257	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
23341350	23341350	PRJNA326068_P_NODE_3139_length_621_cov_9.194257_g2478_i0	PRJNA326068	3139	621	9.194257	57.09633597	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	488	3.96e-133	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g2478	i0	84.836	140.367149758454	488	70	78	3	137	621	469288	468802	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	87168	488	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
24020972	24020972	PRJNA326068_P_NODE_14079_length_232_cov_210.280788_g13116_i0	PRJNA326068	14079	232	210.280788	487.85142816	Bdellovibrio	958	Bacteria	Bacteria	307	4.0100000000000005e-79	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g13116	i0	90.558	314.271551724138	233	20	100	2	1	232	1676876	1676645	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	72911	307	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24615541	24615541	PRJNA326068_P_NODE_3140_length_621_cov_7.704392_g2479_i0	PRJNA326068	3140	621	7.704392	47.84427432	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	505	3.9299999999999983e-138	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g2479	i0	85.421	126.605475040258	487	69	78	1	137	621	469288	468802	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	78622	505	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium

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