metadata: contig_metadata: 22 rows where bioproject = "PRJNA293022", tax_kingdom = "Pseudomonadati" and tax

22 rows where bioproject = "PRJNA293022", 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
2335012	2335012	PRJNA293022_P_NODE_73382_length_165_cov_1.750000_g72645_i0	PRJNA293022	73382	165	1.75	2.8875	Bdellovibrio	958	Bacteria	Bacteria	195	2.17e-45	NTclustered	gi\|1210342126\|gb\|CP020946.1\|	959	g72645	i0	88.623	512.721212121212	167	10	99	7	1	163	2950187	2950348	Bdellovibrio bacteriovorus strain SSB218315, complete genome	blastn	84599	195	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
2923971	2923971	PRJNA293022_P_NODE_44623_length_209_cov_1.287500_g43886_i0	PRJNA293022	44623	209	1.2875	2.690875	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	235	1.6999999999999998e-57	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g43886	i0	89.362	702.574162679426	188	18	89	2	1	187	3448031	3448217	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	146838	235	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
2924031	2924031	PRJNA293022_P_NODE_57763_length_183_cov_1.537313_g57026_i0	PRJNA293022	57763	183	1.537313	2.81328279	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	246	6.659999999999999e-61	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g57026	i0	90.957	88.9289617486339	188	10	99	4	3	183	611439	611626	Bdellovibrio bacteriovorus W, complete genome	blastn	16274	246	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
2924169	2924169	PRJNA293022_P_NODE_79963_length_161_cov_3.428571_g79226_i0	PRJNA293022	79963	161	3.428571	5.51999931	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	287	3.37e-73	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g79226	i0	99.367	85.8819875776397	158	1	98	0	2	159	666658	666815	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	13827	287	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
4200335	4200335	PRJNA293022_P_NODE_19944_length_319_cov_1.637037_g19207_i0	PRJNA293022	19944	319	1.637037	5.22214803	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	497	3.2e-136	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g19207	i0	94.969	27.576802507837	318	15	99	1	2	319	1293747	1294063	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	8797	497	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
4887698	4887698	PRJNA293022_P_NODE_65424_length_171_cov_2.221311_g64687_i0	PRJNA293022	65424	171	2.221311	3.79844181	Bacteriovorax	146784	Bacteria	Bacteria	289	1e-73	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g64687	i0	97.619	222.286549707602	168	4	98	0	3	170	1662493	1662326	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	38011	289	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
6750874	6750874	PRJNA293022_P_NODE_20166_length_317_cov_2.410448_g19429_i0	PRJNA293022	20166	317	2.410448	7.64112016	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	276	1.62e-69	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g19429	i0	82.5	112.296529968454	320	50	99	4	3	317	3448357	3448039	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	35598	276	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
9301386	9301386	PRJNA293022_P_NODE_50368_length_196_cov_2.278912_g49631_i0	PRJNA293022	50368	196	2.278912	4.46666752	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	335	1.5e-87	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g49631	i0	97.927	175.040816326531	193	4	98	0	3	195	699733	699925	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	34308	335	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
9301586	9301586	PRJNA293022_P_NODE_8288_length_497_cov_3.821429_g7563_i0	PRJNA293022	8288	497	3.821429	18.99250213	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	446	1.91e-120	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g7563	i0	86.019	435.233400402414	422	52	84	6	2	420	699883	700300	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	216311	446	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
11262894	11262894	PRJNA293022_P_NODE_56789_length_185_cov_0.882353_g56052_i0	PRJNA293022	56789	185	0.882353	1.63235305	Bacteriovorax	146784	Bacteria	Bacteria	339	1.08e-88	NTclustered	gi\|459219260\|gb\|KC480587.1\|	960	g56052	i0	100	102.027027027027	183	0	99	0	1	183	188	6	Bacteriovorax stolpii strain CWDS-2 16S ribosomal RNA gene, partial sequence	blastn	18875	339	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
12538176	12538176	PRJNA293022_P_NODE_27830_length_267_cov_1.211009_g27093_i0	PRJNA293022	27830	267	1.211009	3.23339403	Bdellovibrio	958	Bacteria	Bacteria	250	8.07e-62	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g27093	i0	87.33	74.6966292134831	221	25	83	3	2	222	779039	779256	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	19944	250	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
13127068	13127068	PRJNA293022_P_NODE_33691_length_241_cov_1.520833_g32954_i0	PRJNA293022	33691	241	1.520833	3.66520753	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	385	1.88e-102	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g32954	i0	95.816	85.9668049792531	239	9	99	1	1	239	816802	816565	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	20718	385	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
13813098	13813098	PRJNA293022_P_NODE_45511_length_207_cov_1.088608_g44774_i0	PRJNA293022	45511	207	1.088608	2.25341856	root	1	Root_unresolved	Root_unresolved	172	1.33e-38	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g44774	i0	83.246	64.1980676328502	191	28	91	4	1	189	815739	815551	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	13289	172	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
14402144	14402144	PRJNA293022_P_NODE_24412_length_286_cov_1.683544_g23675_i0	PRJNA293022	24412	286	1.683544	4.81493584	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	327	3.919999999999999e-85	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g23675	i0	87.676	85.972027972028	284	32	99	2	3	285	861302	861583	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	24588	327	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
14402400	14402400	PRJNA293022_P_NODE_75132_length_164_cov_1.417391_g74395_i0	PRJNA293022	75132	164	1.417391	2.32452124	Peredibacter starrii	28202	Bacteria	Bacteria	257	2.7e-64	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g74395	i0	95.122	137.085365853659	164	6	99	1	1	162	512033	511870	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	22482	257	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
15087311	15087311	PRJNA293022_P_NODE_43332_length_212_cov_1.398773_g42595_i0	PRJNA293022	43332	212	1.398773	2.96539876	Pseudomonadati	3379134	Bacteria	Bacteria	128	3.0099999999999997e-25	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g42595	i0	78.744	32.3018867924528	207	32	95	10	5	205	610576	610376	Bdellovibrio bacteriovorus W, complete genome	blastn	6848	128	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
15676110	15676110	PRJNA293022_P_NODE_59093_length_181_cov_1.151515_g58356_i0	PRJNA293022	59093	181	1.151515	2.08424215	uncultured Pseudobdellovibrionaceae bacterium	269677	Bacteria	Bacteria	287	3.87e-73	NTclustered	gi\|1409356697\|gb\|MH537953.1\|	269677	g58356	i0	95.531	98.7569060773481	179	8	99	0	3	181	56	234	Uncultured Pseudobdellovibrionaceae bacterium clone Bde2A 16S ribosomal RNA gene, partial sequence	blastn	17875	287	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		uncultured Pseudobdellovibrionaceae bacterium
19499179	19499179	PRJNA293022_P_NODE_37016_length_229_cov_4.527778_g36279_i0	PRJNA293022	37016	229	4.527778	10.36861162	Peredibacter starrii	28202	Bacteria	Bacteria	411	2.9299999999999996e-110	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g36279	i0	99.556	88.6593886462882	225	1	98	0	3	227	512199	511975	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	20303	411	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
22049635	22049635	PRJNA293022_P_NODE_21358_length_307_cov_158.596899_g20621_i0	PRJNA293022	21358	307	158.596899	486.89247993	uncultured Bdellovibrio sp.	239744	Bacteria	Bacteria	449	8.69e-122	NTclustered	gi\|380837387\|gb\|JN866303.1\|	239744	g20621	i0	97.701	121.514657980456	261	6	85	0	45	305	3	263	Uncultured Bdellovibrio sp. clone B3_30_117 16S ribosomal RNA gene, partial sequence	blastn	37305	449	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	uncultured Bdellovibrio sp.
26631049	26631049	PRJNA293022_P_NODE_74541_length_165_cov_0.896552_g73804_i0	PRJNA293022	74541	165	0.896552	1.4793108	Bdellovibrio sp.	28201	Bacteria	Bacteria	95.1	6.22e-22	NR	MEN0059642.1	28201	g73804	i0	81.8	4.87272727272727	55	10	100	0	1	165	59	113	MEN0059642.1 MBL fold metallo-hydrolase [Bdellovibrio sp.]	diamond	804	95.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
30611195	30611195	PRJNA293022_P_NODE_44493_length_209_cov_1.893750_g43756_i0	PRJNA293022	44493	209	1.89375	3.9579375	Micavibrio sp.	2024841	Bacteria	Bacteria	40	0.0213	NR	MAE52118.1	2024841	g43756	i0	43.9	0.588516746411483	41	23	58.9	0	190	68	1	41	MAE52118.1 entericidin [Micavibrio sp.]	diamond	123	40	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio sp.
31528028	31528028	PRJNA293022_P_NODE_32156_length_247_cov_1.040404_g31419_i0	PRJNA293022	32156	247	1.040404	2.56979788	Bdellovibrio sp. 22V	3044166	Bacteria	Bacteria	55.8	8.24e-7	NR	WP_284605945.1	3044166	g31419	i0	39.7	0.88663967611336	73	42	86.2	1	247	35	78	150	WP_284605945.1 hypothetical protein [Bdellovibrio sp. 22V]	diamond	219	55.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. 22V

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