metadata: contig_metadata: 23 rows where bioproject = "PRJNA488043", tax_kingdom = "Pseudomonadati" and tax

23 rows where bioproject = "PRJNA488043", 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
1098079	1098079	PRJNA488043_S_NODE_661_length_227_cov_8.823232_g650_i0	PRJNA488043	661	227	8.823232	20.02873664	Bacteriovorax	146784	Bacteria	Bacteria	340	3.8499999999999996e-89	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g650	i0	93.506	334.092511013216	231	11	100	3	1	227	1661465	1661695	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	75839	340	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
1724763	1724763	PRJNA488043_S_NODE_862_length_203_cov_5.517241_g851_i0	PRJNA488043	862	203	5.517241	11.19999923	Peredibacter starrii	28202	Bacteria	Bacteria	342	9.369999999999999e-90	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g851	i0	97.044	147.325123152709	203	6	100	0	1	203	512231	512433	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	29907	342	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
4277093	4277093	PRJNA488043_S_NODE_704_length_221_cov_22.520833_g693_i0	PRJNA488043	704	221	22.520833	49.77104093	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	163	8.67e-36	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g693	i0	83.077	126.009049773756	195	18	86	13	7	195	3447971	3448156	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	27848	163	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
5553606	5553606	PRJNA488043_S_NODE_85_length_482_cov_27.474614_g74_i0	PRJNA488043	85	482	27.474614	132.42763948	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	298	5.46e-76	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g74	i0	89.407	296.794605809129	236	25	49	0	3	238	3446972	3447207	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	143055	298	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
6201023	6201023	PRJNA488043_P_NODE_16265_length_210_cov_52.116022_g14023_i0	PRJNA488043	16265	210	52.116022	109.4436462	Peredibacter	263370	Bacteria	Bacteria	222	1.33e-53	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g14023	i0	99.187	2.34285714285714	123	1	59	0	88	210	513727	513849	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	492	222	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
6201195	6201195	PRJNA488043_S_NODE_1365_length_165_cov_3.330882_g1354_i0	PRJNA488043	1365	165	3.330882	5.4959553	Peredibacter	263370	Bacteria	Bacteria	267	4.53e-67	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g1354	i0	98.039	42.2181818181818	153	3	93	0	13	165	513594	513442	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	6966	267	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
6201203	6201203	PRJNA488043_S_NODE_405_length_290_cov_9.429119_g394_i0	PRJNA488043	405	290	9.429119	27.3444451	Peredibacter	263370	Bacteria	Bacteria	508	1.33e-139	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g394	i0	98.276	224.089655172414	290	5	100	0	1	290	511176	511465	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	64986	508	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
8102884	8102884	PRJNA488043_P_NODE_13707_length_248_cov_3.264840_g11465_i0	PRJNA488043	13707	248	3.26484	8.0968032	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	364	2.539999999999999e-96	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g11465	i0	93.802	197.995967741935	242	15	98	0	6	247	666243	666484	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	49103	364	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
10026357	10026357	PRJNA488043_S_NODE_728_length_217_cov_4.063830_g717_i0	PRJNA488043	728	217	4.06383	8.8185111	Bacteriovorax	146784	Bacteria	Bacteria	274	3.76e-69	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g717	i0	91.5	243.3133640553	200	16	92	1	18	216	1662082	1661883	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	52799	274	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
10653712	10653712	PRJNA488043_S_NODE_1489_length_159_cov_5.784615_g1478_i0	PRJNA488043	1489	159	5.784615	9.19753785	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	289	9.22e-74	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g1478	i0	99.371	19.3962264150943	159	1	100	0	1	159	1292617	1292459	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	3084	289	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
11928470	11928470	PRJNA488043_P_NODE_14290_length_238_cov_3.559809_g12048_i0	PRJNA488043	14290	238	3.559809	8.47234542	Peredibacter starrii	28202	Bacteria	Bacteria	418	1.8299999999999998e-112	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g12048	i0	99.138	146.96218487395	232	2	97	0	1	232	512686	512917	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	34977	418	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
14478320	14478320	PRJNA488043_P_NODE_11492_length_295_cov_36.244361_g9251_i0	PRJNA488043	11492	295	36.244361	106.92086495	Peredibacter starrii	28202	Bacteria	Bacteria	542	1.33e-149	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g9251	i0	100	523.918644067797	293	0	99	0	1	293	512090	511798	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	154556	542	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
15126012	15126012	PRJNA488043_P_NODE_7632_length_433_cov_3.183168_g5468_i0	PRJNA488043	7632	433	3.183168	13.78311744	Bdellovibrio	958	Bacteria	Bacteria	278	6.34e-70	NTclustered	gi\|2663425168\|dbj\|AP029173.1\|	3113893	g5468	i0	79.475	160.004618937644	419	65	94	15	29	433	756177	755766	Bdellovibrio sp. CKG001 DNA, complete genome	blastn	69282	278	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CKG001
17675640	17675640	PRJNA488043_P_NODE_4154_length_683_cov_9.527523_g2408_i0	PRJNA488043	4154	683	9.527523	65.07298209	Peredibacter	263370	Bacteria	Bacteria	1171	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g2408	i0	97.654	129.294289897511	682	16	99	0	2	683	511371	510690	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	88308	1171	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
18949407	18949407	PRJNA488043_P_NODE_18335_length_188_cov_3.509434_g16093_i0	PRJNA488043	18335	188	3.509434	6.59773592	Pseudobdellovibrionaceae	213483	Bacteria	Bacteria	259	8.84e-65	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g16093	i0	93.22	166.345744680851	177	10	94	2	6	181	805	980	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	31273	261	0.992337164750958	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
18949567	18949567	PRJNA488043_S_NODE_455_length_275_cov_9.593496_g444_i0	PRJNA488043	455	275	9.593496	26.382114	Bdellovibrio	958	Bacteria	Bacteria	387	6.1e-103	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g444	i0	91.844	113.072727272727	282	16	100	4	1	275	816342	816623	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	31095	387	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
20851416	20851416	PRJNA488043_P_NODE_13097_length_259_cov_3.556522_g10856_i0	PRJNA488043	13097	259	3.556522	9.21139198	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	381	2.6499999999999995e-101	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g10856	i0	93.411	88.5868725868726	258	15	99	2	2	258	3446692	3446948	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	22944	381	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
20851620	20851620	PRJNA488043_P_NODE_6877_length_473_cov_6.777027_g4775_i0	PRJNA488043	6877	473	6.777027	32.05533771	Peredibacter starrii	28202	Bacteria	Bacteria	822	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g4775	i0	98.097	115.875264270613	473	8	100	1	1	473	512074	512545	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	54809	822	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
22126432	22126432	PRJNA488043_P_NODE_6878_length_473_cov_6.623874_g4775_i1	PRJNA488043	6878	473	6.623874	31.33092402	Peredibacter starrii	28202	Bacteria	Bacteria	800	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g4775	i1	97.252	114.526427061311	473	12	100	1	1	473	512074	512545	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	54171	800	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
22126490	22126490	PRJNA488043_S_NODE_438_length_278_cov_170.248996_g427_i0	PRJNA488043	438	278	170.248996	473.29220888	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	403	6.13e-108	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g427	i0	92.832	163.41726618705	279	18	100	2	1	278	816402	816125	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	45430	403	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
22126494	22126494	PRJNA488043_S_NODE_738_length_216_cov_7.695187_g727_i0	PRJNA488043	738	216	7.695187	16.62160392	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	311	2.85e-80	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g727	i0	92.627	92.3564814814815	217	15	100	1	1	216	3446995	3446779	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	19949	311	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
23402332	23402332	PRJNA488043_S_NODE_919_length_197_cov_9.351190_g908_i0	PRJNA488043	919	197	9.35119	18.4218443	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	309	9.17e-80	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g908	i0	94.924	198.939086294416	197	10	100	0	1	197	611196	611000	Bdellovibrio bacteriovorus W, complete genome	blastn	39191	309	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24049802	24049802	PRJNA488043_P_NODE_19359_length_178_cov_63.046980_g17117_i0	PRJNA488043	19359	178	63.04698	112.2236244	Peredibacter	263370	Bacteria	Bacteria	222	1.08e-53	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g17117	i0	99.187	2.76404494382022	123	1	69	0	1	123	513849	513727	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	492	222	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii

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