metadata: contig_metadata: 17 rows where bioproject = "PRJNA1245487" and tax

17 rows where bioproject = "PRJNA1245487" 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
2901844	2901844	PRJNA1245487_P_NODE_11483_length_346_cov_3.333333_g11145_i0	PRJNA1245487	11483	346	3.333333	11.53333218	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	374	6.149999999999998e-99	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g11145	i0	86.246	159.884393063584	349	43	100	4	1	346	777822	778168	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	55320	374	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
4879362	4879362	PRJNA1245487_P_NODE_14944_length_293_cov_1.309091_g14606_i0	PRJNA1245487	14944	293	1.309091	3.83563663	Pseudobdellovibrio	2862745	Bacteria	Bacteria	361	3.97e-95	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g14606	i0	89.236	156.645051194539	288	31	98	0	1	288	22	309	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	45897	361	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
6728955	6728955	PRJNA1245487_P_NODE_21606_length_243_cov_1.835294_g21268_i0	PRJNA1245487	21606	243	1.835294	4.45976442	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	318	1.96e-82	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g21268	i0	90.833	198.378600823045	240	19	98	3	5	243	3250924	3250687	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	48206	318	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
8004445	8004445	PRJNA1245487_P_NODE_22387_length_237_cov_2.847561_g22049_i0	PRJNA1245487	22387	237	2.847561	6.74871957	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	353	5.209999999999998e-93	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g22049	i0	93.671	100.459915611814	237	13	99	2	2	237	3447077	3447312	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	23809	353	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
9979375	9979375	PRJNA1245487_P_NODE_17048_length_270_cov_2.543147_g16710_i0	PRJNA1245487	17048	270	2.543147	6.8664969	Bdellovibrio	958	Bacteria	Bacteria	302	2.23e-77	NTclustered	gi\|2800914199\|gb\|CP168971.1\|	959	g16710	i0	86.94	321.17037037037	268	35	99	0	3	270	752902	753169	Bdellovibrio bacteriovorus strain Bd16 chromosome, complete genome	blastn	86716	302	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
11254848	11254848	PRJNA1245487_P_NODE_7249_length_458_cov_2.729870_g6913_i0	PRJNA1245487	7249	458	2.72987	12.5028046	Bacteriovorax	146784	Bacteria	Bacteria	466	1.3399999999999997e-126	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g6913	i0	85.217	173.294759825328	460	60	99	8	1	456	1660363	1660818	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	79369	466	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
12530018	12530018	PRJNA1245487_P_NODE_20990_length_246_cov_0.901734_g20652_i0	PRJNA1245487	20990	246	0.901734	2.21826564	Bdellovibrio	958	Bacteria	Bacteria	339	1.5199999999999998e-88	NTclustered	gi\|2800914199\|gb\|CP168971.1\|	959	g20652	i0	91.77	82.0934959349593	243	20	99	0	4	246	750724	750482	Bdellovibrio bacteriovorus strain Bd16 chromosome, complete genome	blastn	20195	339	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
15654153	15654153	PRJNA1245487_P_NODE_22533_length_235_cov_2.395062_g22195_i0	PRJNA1245487	22533	235	2.395062	5.6283957	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	435	1.79e-117	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g22195	i0	100	171.208510638298	235	0	100	0	1	235	1293208	1293442	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	40234	435	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
16353646	16353646	PRJNA1245487_P_NODE_11613_length_344_cov_1.918819_g11275_i0	PRJNA1245487	11613	344	1.918819	6.60073736	Bdellovibrio	958	Bacteria	Bacteria	231	3.89e-56	NTclustered	gi\|1700693790\|gb\|CP030082.1\|	2231053	g11275	i0	81.695	85.421511627907	295	38	95	16	59	344	1964146	1963859	Bdellovibrio sp. ZAP7 chromosome, complete genome	blastn	29385	231	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. ZAP7
16928292	16928292	PRJNA1245487_P_NODE_17234_length_268_cov_4.374359_g16896_i0	PRJNA1245487	17234	268	4.374359	11.72328212	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	418	2.1e-112	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g16896	i0	94.776	95.3134328358209	268	14	100	0	1	268	3446952	3446685	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	25544	418	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
17629143	17629143	PRJNA1245487_P_NODE_19994_length_249_cov_3.232955_g19656_i0	PRJNA1245487	19994	249	3.232955	8.05005795	Pseudobdellovibrio	2862745	Bacteria	Bacteria	422	1.49e-113	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g19656	i0	97.189	89.9397590361446	249	7	100	0	1	249	1724	1476	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	22395	422	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
21453158	21453158	PRJNA1245487_P_NODE_17897_length_263_cov_1.642105_g17559_i0	PRJNA1245487	17897	263	1.642105	4.31873615	Bdellovibrio	958	Bacteria	Bacteria	268	2.1899999999999998e-67	NTclustered	gi\|2663425168\|dbj\|AP029173.1\|	3113893	g17559	i0	85.547	277.984790874525	256	37	97	0	7	262	757309	757564	Bdellovibrio sp. CKG001 DNA, complete genome	blastn	73110	268	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CKG001
22728103	22728103	PRJNA1245487_P_NODE_12538_length_328_cov_1.568627_g12200_i0	PRJNA1245487	12538	328	1.568627	5.14509656	Bdellovibrio	958	Bacteria	Bacteria	331	3.54e-86	NTclustered	gi\|1210342126\|gb\|CP020946.1\|	959	g12200	i0	89.734	292.121951219512	263	21	79	5	69	328	2950172	2950431	Bdellovibrio bacteriovorus strain SSB218315, complete genome	blastn	95816	331	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
23303530	23303530	PRJNA1245487_P_NODE_22499_length_235_cov_3.425926_g22161_i0	PRJNA1245487	22499	235	3.425926	8.0509261	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	294	3.17e-75	NTclustered	gi\|2893356065\|emb\|OZ220488.1\|	2053517	g22161	i0	89.407	151.289361702128	236	21	99	4	3	235	729045	729279	MAG: Bdellovibrionales bacterium isolate 0d1acec5-ee6a-42a0-9e8e-8bc2840f726d genome assembly, chromosome: 1	blastn	35553	294	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
25277632	25277632	PRJNA1245487_P_NODE_6120_length_504_cov_2.394432_g5784_i0	PRJNA1245487	6120	504	2.394432	12.06793728	Peredibacter	263370	Bacteria	Bacteria	787	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g5784	i0	94.841	144.960317460317	504	26	100	0	1	504	510936	511439	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	73060	787	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
30073445	30073445	PRJNA1245487_P_NODE_17792_length_264_cov_1.460733_g17454_i0	PRJNA1245487	17792	264	1.460733	3.85633512	Bdellovibrio sp.	28201	Bacteria	Bacteria	88.6	8.15e-20	NR	HEY1079254.1	28201	g17454	i0	65	1.31818181818182	60	21	68.2	0	181	2	10	69	HEY1079254.1 lipocalin family protein [Bdellovibrio sp.]	diamond	348	88.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
32760229	32760229	PRJNA1245487_P_NODE_13340_length_315_cov_1.429752_g13002_i0	PRJNA1245487	13340	315	1.429752	4.5037188	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	51.2	8.51e-5	NR	MFN8790750.1	2053517	g13002	i0	34.2	0.723809523809524	76	47	69.5	2	225	7	182	257	MFN8790750.1 site-specific integrase [Bdellovibrionales bacterium]	diamond	228	51.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales 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);;