metadata: contig_metadata: 16 rows where bioproject = "PRJNA640143" and tax

16 rows where bioproject = "PRJNA640143" 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
1886105	1886105	PRJNA640143_S_NODE_23802_length_181_cov_1.208333_g23592_i0	PRJNA640143	23802	181	1.208333	2.18708273	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	95.5	4e-21	NR	MCB9073696.1	2026715	g23592	i0	82.8	5.76795580110497	58	10	96.1	0	181	8	306	363	MCB9073696.1 chaperonin GroEL [Pseudobdellovibrionaceae bacterium]	diamond	1044	95.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
17733220	17733220	PRJNA640143_S_NODE_13394_length_237_cov_6.580000_g13184_i0	PRJNA640143	13394	237	6.58	15.5946	Pseudobdellovibrio	2862745	Bacteria	Bacteria	106	1.61e-18	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g13184	i0	82.54	298.57805907173	126	17	52	5	75	198	125	3	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	70763	106	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
22287368	22287368	PRJNA640143_S_NODE_9158_length_282_cov_5.297959_g8948_i0	PRJNA640143	9158	282	5.297959	14.94024438	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	422	1.72e-113	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g8948	i0	95.131	106.287234042553	267	13	95	0	4	270	1292755	1292489	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	29973	422	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
22832885	22832885	PRJNA640143_S_NODE_30858_length_155_cov_2.186441_g30648_i0	PRJNA640143	30858	155	2.186441	3.38898355	Bdellovibrio	958	Bacteria	Bacteria	80.5	5.85e-11	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g30648	i0	100	75.3677419354839	43	0	28	0	1	43	1676578	1676620	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	11682	80.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
22832941	22832941	PRJNA640143_S_NODE_9218_length_281_cov_14.614754_g9008_i0	PRJNA640143	9218	281	14.614754	41.06745874	Bdellovibrio	958	Bacteria	Bacteria	222	1.87e-53	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g9008	i0	83.071	2.12811387900356	254	33	88	7	8	254	1071610	1071360	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	598	222	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24835956	24835956	PRJNA640143_S_NODE_11780_length_252_cov_3.860465_g11570_i0	PRJNA640143	11780	252	3.860465	9.7283718	Peredibacter starrii	28202	Bacteria	Bacteria	342	1.21e-89	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g11570	i0	94.196	96.5555555555556	224	13	89	0	1	224	510915	510692	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	24332	342	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
26954274	26954274	PRJNA640143_S_NODE_21342_length_190_cov_6.189542_g21132_i0	PRJNA640143	21342	190	6.189542	11.7601298	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	67	2.97e-11	NR	MCB9072930.1	2026715	g21132	i0	56.3	2.27368421052632	48	21	75.8	0	158	15	67	114	MCB9072930.1 NAD(+)/NADH kinase [Pseudobdellovibrionaceae bacterium]	diamond	432	67	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
27017720	27017720	PRJNA640143_S_NODE_30302_length_157_cov_1.900000_g30092_i0	PRJNA640143	30302	157	1.9	2.983	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	72.4	2.26e-13	NR	MCC6137677.1	2026715	g30092	i0	70.8	0.917197452229299	48	14	91.7	0	1	144	50	97	MCC6137677.1 TIGR02147 family protein [Pseudobdellovibrionaceae bacterium]	diamond	144	72.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
27156318	27156318	PRJNA640143_S_NODE_15782_length_220_cov_1.475410_g15572_i0	PRJNA640143	15782	220	1.47541	3.245902	Pseudobdellovibrio	2862745	Bacteria	Bacteria	88.2	2.31e-18	NR	MFN8845911.1	2053517	g15572	i0	71.7	4.09090909090909	60	17	81.8	0	218	39	316	375	MFN8845911.1 MBL fold metallo-hydrolase [Bdellovibrionales bacterium]	diamond	900	88.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27838959	27838959	PRJNA640143_S_NODE_31584_length_153_cov_2.189655_g31374_i0	PRJNA640143	31584	153	2.189655	3.35017215	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	57	2.88e-8	NR	MCB0370085.1	2053517	g31374	i0	68.8	0.627450980392157	32	10	62.7	0	153	58	64	95	MCB0370085.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	96	57	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28798598	28798598	PRJNA640143_S_NODE_9587_length_277_cov_5.920833_g9377_i0	PRJNA640143	9587	277	5.920833	16.40070741	Bacteria	2	Bacteria	Bacteria	80.5	2.03e-15	NR	MBT4760334.1	2026715	g9377	i0	54.3	6.1841155234657	70	32	75.8	0	215	6	7	76	MBT4760334.1 alanine--glyoxylate aminotransferase family protein [Pseudobdellovibrionaceae bacterium]	diamond	1713	81.3	0.990159901599016	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
29954678	29954678	PRJNA640143_S_NODE_27771_length_166_cov_1.410853_g27561_i0	PRJNA640143	27771	166	1.410853	2.34201598	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	44.7	0.00277	NR	WP_061835927.1	959	g27561	i0	35.7	1.01204819277108	56	27	84.9	1	154	14	24	79	WP_061835927.1 hypothetical protein [Bdellovibrio bacteriovorus]	diamond	168	44.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
30030382	30030382	PRJNA640143_S_NODE_12231_length_248_cov_2.213270_g12021_i0	PRJNA640143	12231	248	2.21327	5.4889096	Bacteria	2	Bacteria	Bacteria	52.8	3.72e-6	NR	MBL7544945.1	2026715	g12021	i0	39.7	2.70967741935484	78	41	88.3	2	219	1	40	116	MBL7544945.1 hypothetical protein [Pseudobdellovibrionaceae bacterium]	diamond	672	53.1	0.994350282485876	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
30030384	30030384	PRJNA640143_S_NODE_24331_length_179_cov_1.373239_g24121_i0	PRJNA640143	24331	179	1.373239	2.45809781	Pseudomonadati	3379134	Bacteria	Bacteria	47	4.99e-4	NR	MAZ50014.1	2026745	g24121	i0	47.2	2.64804469273743	53	28	88.8	0	179	21	168	220	MAZ50014.1 hypothetical protein [Halobacteriovoraceae bacterium]	diamond	474	47	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae		Halobacteriovoraceae bacterium
30978304	30978304	PRJNA640143_S_NODE_15054_length_225_cov_1.579787_g14844_i0	PRJNA640143	15054	225	1.579787	3.55452075	Bacteria	2	Bacteria	Bacteria	79.7	8.24e-16	NR	MCM2350626.1	2081706	g14844	i0	62.1	1.76	66	24	88	1	27	224	13	77	MCM2350626.1 tetratricopeptide repeat protein [Bacteriovoracaceae bacterium]	diamond	396	79.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
32528207	32528207	PRJNA640143_S_NODE_7519_length_307_cov_211.100000_g7309_i0	PRJNA640143	7519	307	211.1	648.077	Bdellovibrio	958	Bacteria	Bacteria	79.3	6.15e-15	NR	WP_374078301.1	958	g7309	i0	62.1	1.41693811074919	66	25	64.5	0	68	265	1	66	WP_374078301.1 MULTISPECIES: hypothetical protein [Bdellovibrio]	diamond	435	79.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio

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