metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA436017" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA436017" 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
430921	430921	PRJNA436017_P_NODE_3421_length_505_cov_15.297009_g3141_i0	PRJNA436017	3421	505	15.297009	77.24989545	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	828	0	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g3141	i0	96.238	236.578217821782	505	19	100	0	1	505	666828	666324	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	119472	828	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
1089109	1089109	PRJNA436017_P_NODE_8381_length_304_cov_1.936330_g8084_i0	PRJNA436017	8381	304	1.93633	5.8864432	Pseudobdellovibrio	2862745	Bacteria	Bacteria	496	1.09e-135	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g8084	i0	96.053	95.6118421052632	304	12	100	0	1	304	1356	1659	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	29066	496	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
1705881	1705881	PRJNA436017_P_NODE_7582_length_322_cov_1.968421_g7285_i0	PRJNA436017	7582	322	1.968421	6.33831562	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	183	1.03e-41	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g7285	i0	77.961	5.03105590062112	304	59	93	7	23	322	611895	611596	Bdellovibrio bacteriovorus W, complete genome	blastn	1620	183	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
2981553	2981553	PRJNA436017_P_NODE_2643_length_578_cov_5.390018_g2381_i0	PRJNA436017	2643	578	5.390018	31.15430404	Peredibacter starrii	28202	Bacteria	Bacteria	752	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g2381	i0	93.064	48.3529411764706	519	29	89	7	2	516	512478	511963	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	27948	752	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
2981692	2981692	PRJNA436017_P_NODE_7023_length_336_cov_5.100334_g6726_i0	PRJNA436017	7023	336	5.100334	17.13712224	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	499	9.42e-137	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g6726	i0	93.491	179.485119047619	338	18	100	3	1	336	1292617	1292282	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	60307	499	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
4917117	4917117	PRJNA436017_P_NODE_13644_length_226_cov_4.746032_g13346_i0	PRJNA436017	13644	226	4.746032	10.72603232	Pseudobdellovibrionaceae	213483	Bacteria	Bacteria	180	8.84e-41	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g13346	i0	81.498	138.300884955752	227	34	98	8	5	226	665724	665947	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	31256	180	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
8084250	8084250	PRJNA436017_P_NODE_5127_length_402_cov_4.980822_g4831_i0	PRJNA436017	5127	402	4.980822	20.02290444	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	737	0	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g4831	i0	99.751	91.6169154228856	402	1	100	0	1	402	700273	700674	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	36830	737	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
11292182	11292182	PRJNA436017_P_NODE_16109_length_205_cov_4.345238_g15811_i0	PRJNA436017	16109	205	4.345238	8.9077379	Bdellovibrio	958	Bacteria	Bacteria	204	4.67e-48	NTclustered	gi\|1210342126\|gb\|CP020946.1\|	959	g15811	i0	86.772	119.409756097561	189	18	90	7	17	201	2952106	2952291	Bdellovibrio bacteriovorus strain SSB218315, complete genome	blastn	24479	204	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
14459415	14459415	PRJNA436017_P_NODE_11972_length_245_cov_5.947115_g11674_i0	PRJNA436017	11972	245	5.947115	14.57043175	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	206	1.6e-48	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g11674	i0	83.482	83.9510204081633	224	33	90	4	1	221	699366	699144	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	20568	206	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
14459517	14459517	PRJNA436017_P_NODE_16872_length_200_cov_1.865031_g16574_i0	PRJNA436017	16872	200	1.865031	3.730062	Pseudobdellovibrio exovorus	453816	Bacteria	Bacteria	193	9.81e-45	NTclustered	gi\|469929247\|gb\|CP003537.1\|	1184267	g16574	i0	86.034	1.81	179	25	90	0	1	179	2324122	2324300	Bdellovibrio exovorus JSS, complete genome	blastn	362	193	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
17008303	17008303	PRJNA436017_P_NODE_9214_length_286_cov_18.755020_g8916_i0	PRJNA436017	9214	286	18.75502	53.6393572	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	425	1.35e-114	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g8916	i0	93.426	223.643356643357	289	15	100	4	1	286	666828	666541	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	63962	425	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
19556546	19556546	PRJNA436017_P_NODE_15436_length_211_cov_1.287356_g15138_i0	PRJNA436017	15436	211	1.287356	2.71632116	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	244	2.85e-60	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g15138	i0	87.736	88.2227488151659	212	23	100	3	1	211	3447019	3447228	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	18615	244	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
19556578	19556578	PRJNA436017_P_NODE_1756_length_712_cov_6.397037_g1532_i0	PRJNA436017	1756	712	6.397037	45.54690344	Peredibacter starrii	28202	Bacteria	Bacteria	1171	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g1532	i0	96.484	142.442415730337	711	21	99	3	4	712	511414	510706	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	101419	1171	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
19556902	19556902	PRJNA436017_P_NODE_8356_length_304_cov_34.052434_g8059_i0	PRJNA436017	8356	304	34.052434	103.51939936	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	451	2.39e-122	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g8059	i0	93.421	167.351973684211	304	20	100	0	1	304	666577	666274	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	50875	451	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
20215276	20215276	PRJNA436017_P_NODE_2436_length_606_cov_104.595782_g2183_i0	PRJNA436017	2436	606	104.595782	633.85043892	Peredibacter	263370	Bacteria	Bacteria	1044	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g2183	i0	98.007	259.981848184818	602	10	99	1	5	604	512108	511507	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	157549	1050	0.994285714285714	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
20832307	20832307	PRJNA436017_P_NODE_14177_length_221_cov_2.684783_g13879_i0	PRJNA436017	14177	221	2.684783	5.93337043	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	126	1.1399999999999999e-24	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g13879	i0	88.571	1.66968325791855	105	10	47	2	1	104	180216	180113	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	369	126	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
22766056	22766056	PRJNA436017_P_NODE_5078_length_404_cov_6.261580_g4782_i0	PRJNA436017	5078	404	6.26158	25.2967832	Pseudobdellovibrio	2862745	Bacteria	Bacteria	520	8.84e-143	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g4782	i0	89.926	113.495049504951	407	35	99	6	1	403	499	95	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	45852	520	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
22766092	22766092	PRJNA436017_P_NODE_9798_length_276_cov_5.543933_g9500_i0	PRJNA436017	9798	276	5.543933	15.30125508	Pseudobdellovibrionaceae	213483	Bacteria	Bacteria	344	3.74e-90	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g9500	i0	89.17	173.800724637681	277	28	100	2	1	276	699976	699701	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	47969	344	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
23382875	23382875	PRJNA436017_P_NODE_15519_length_210_cov_1.676301_g15221_i0	PRJNA436017	15519	210	1.676301	3.5202321	uncultured Micavibrio sp.	362447	Bacteria	Bacteria	289	1.29e-73	NTclustered	gi\|2621703983\|emb\|OY762938.1\|	362447	g15221	i0	93.333	175.552380952381	195	13	93	0	16	210	961896	961702	MAG: uncultured Micavibrio sp. isolate 194a20bb-105a-45c9-9846-0688499aae06 genome assembly, chromosome: 1	blastn	36866	289	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	uncultured Micavibrio sp.
24040804	24040804	PRJNA436017_P_NODE_17939_length_193_cov_10.525641_g17641_i0	PRJNA436017	17939	193	10.525641	20.31448713	Pseudomonadati	3379134	Bacteria	Bacteria	220	4.31e-53	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g17641	i0	87.629	286.20725388601	194	19	100	5	1	193	815235	815424	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	55238	220	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24040819	24040819	PRJNA436017_P_NODE_20199_length_182_cov_1.075862_g19901_i0	PRJNA436017	20199	182	1.075862	1.95806884	Bdellovibrio	958	Bacteria	Bacteria	189	1.13e-43	NTclustered	gi\|2800914199\|gb\|CP168971.1\|	959	g19901	i0	86.286	4.17032967032967	175	23	96	1	8	181	2553594	2553420	Bdellovibrio bacteriovorus strain Bd16 chromosome, complete genome	blastn	759	189	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24656966	24656966	PRJNA436017_P_NODE_14260_length_220_cov_43.415301_g13962_i0	PRJNA436017	14260	220	43.415301	95.5136622	uncultured Bdellovibrio sp.	239744	Bacteria	Bacteria	357	3.69e-94	NTclustered	gi\|111607566\|gb\|DQ847445.1\|	239744	g13962	i0	96.313	96.8272727272727	217	8	99	0	1	217	21	237	Uncultured Bdellovibrio sp. clone GR2-101 16S ribosomal RNA gene, partial sequence	blastn	21302	357	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	uncultured Bdellovibrio sp.

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