metadata: contig_metadata: 16 rows where bioproject = "PRJNA527965", tax_phylum = "Bdellovibrionota" and tax

16 rows where bioproject = "PRJNA527965", 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
1772095	1772095	PRJNA527965_S_NODE_5182_length_164_cov_6.170543_g5099_i0	PRJNA527965	5182	164	6.170543	10.11969052	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	254	3.5e-63	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g5099	i0	94.512	116.426829268293	164	9	100	0	1	164	860522	860359	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	19094	254	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
2389861	2389861	PRJNA527965_S_NODE_6262_length_150_cov_2.182609_g6179_i0	PRJNA527965	6262	150	2.182609	3.2739135	Bdellovibrio	958	Bacteria	Bacteria	78.7	2.02e-10	NTclustered	gi\|1210342126\|gb\|CP020946.1\|	959	g6179	i0	87.143	37.3466666666667	70	7	45	2	1	68	2948778	2948847	Bdellovibrio bacteriovorus strain SSB218315, complete genome	blastn	5602	78.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
3665549	3665549	PRJNA527965_S_NODE_1123_length_352_cov_6.006309_g1040_i0	PRJNA527965	1123	352	6.006309	21.14220768	Peredibacter	263370	Bacteria	Bacteria	453	7.810000000000001e-123	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g1040	i0	90.085	120.204545454545	353	29	100	3	1	352	512675	512328	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	42312	453	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
3665562	3665562	PRJNA527965_S_NODE_2263_length_257_cov_5.265766_g2180_i0	PRJNA527965	2263	257	5.265766	13.53301862	Pseudobdellovibrio	2862745	Bacteria	Bacteria	315	2.7e-81	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g2180	i0	90.083	182.280155642023	242	24	94	0	2	243	10	251	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	46846	315	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
6874535	6874535	PRJNA527965_S_NODE_3066_length_217_cov_34.032967_g2983_i0	PRJNA527965	3066	217	34.032967	73.85153839	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	291	3.729999999999999e-74	NTclustered	gi\|1950812799\|gb\|CP066681.1\|	349221	g2983	i0	90.826	186.889400921659	218	19	100	1	1	217	659588	659805	Micavibrio aeruginosavorus isolate NC_groundwater_70_Ag_B-0.1um_54_66 chromosome	blastn	40555	291	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
10042810	10042810	PRJNA527965_S_NODE_1568_length_309_cov_10.777372_g1485_i0	PRJNA527965	1568	309	10.777372	33.30207948	Bdellovibrio	958	Bacteria	Bacteria	549	8.389999999999996e-152	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g1485	i0	98.706	121.724919093851	309	4	100	0	1	309	813646	813338	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	37613	549	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
13250699	13250699	PRJNA527965_S_NODE_1471_length_316_cov_6.014235_g1388_i0	PRJNA527965	1471	316	6.014235	19.0049826	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	436	6.9899999999999996e-118	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g1388	i0	93.793	278.642405063291	290	18	92	0	12	301	698887	699176	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	88051	436	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
13250787	13250787	PRJNA527965_S_NODE_6031_length_152_cov_230.059829_g5948_i0	PRJNA527965	6031	152	230.059829	349.69094008	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	202	1.1699999999999998e-47	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g5948	i0	90.789	195.348684210526	152	13	100	1	1	152	815424	815274	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	29693	202	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
13250800	13250800	PRJNA527965_S_NODE_891_length_383_cov_15.612069_g808_i0	PRJNA527965	891	383	15.612069	59.79422427	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	470	8.509999999999999e-128	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g808	i0	89.474	278.671018276762	380	28	98	12	8	383	815231	815602	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	106731	470	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
13868102	13868102	PRJNA527965_S_NODE_2131_length_265_cov_4.330435_g2048_i0	PRJNA527965	2131	265	4.330435	11.47565275	Pseudobdellovibrionaceae	213483	Bacteria	Bacteria	340	4.62e-89	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g2048	i0	89.85	137.483018867925	266	25	100	2	1	265	665996	665732	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	36433	340	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
15799481	15799481	PRJNA527965_S_NODE_153_length_739_cov_13.767045_g55_i1	PRJNA527965	153	739	13.767045	101.73846255	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	1188	0	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g55	i1	95.924	203.105548037889	736	25	99	3	4	739	666711	665981	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	150095	1188	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
16417081	16417081	PRJNA527965_S_NODE_533_length_468_cov_4.055427_g451_i0	PRJNA527965	533	468	4.055427	18.97939836	Bdellovibrio	958	Bacteria	Bacteria	774	0	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g451	i0	97.363	85.8782051282051	455	12	97	0	14	468	816443	816897	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	40191	774	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
19622853	19622853	PRJNA527965_S_NODE_1316_length_331_cov_7.668919_g1233_i0	PRJNA527965	1316	331	7.668919	25.38412189	Bacteriovorax stolpii	960	Bacteria	Bacteria	446	1.22e-120	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g1233	i0	91.667	3.35347432024169	324	24	98	3	9	331	2982634	2982955	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	1110	446	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
20240796	20240796	PRJNA527965_S_NODE_416_length_507_cov_58.010593_g335_i0	PRJNA527965	416	507	58.010593	294.11370651	Bacteriovorax	146784	Bacteria	Bacteria	556	8.62e-154	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g335	i0	86.64	150.264299802761	509	60	99	8	3	507	1660853	1660349	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	76184	556	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
21516315	21516315	PRJNA527965_S_NODE_637_length_440_cov_3.807407_g555_i0	PRJNA527965	637	440	3.807407	16.7525908	Bdellovibrio	958	Bacteria	Bacteria	710	0	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g555	i0	96.296	85.7431818181818	432	16	98	0	1	432	816897	816466	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	37727	710	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24066241	24066241	PRJNA527965_S_NODE_5099_length_166_cov_1.603053_g5016_i0	PRJNA527965	5099	166	1.603053	2.66106798	Pseudobdellovibrio	2862745	Bacteria	Bacteria	211	2.17e-50	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g5016	i0	89.759	55.1626506024096	166	15	99	2	1	165	335	499	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	9157	211	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus

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