metadata: contig_metadata: 11 rows where bioproject = "PRJNA591127", tax_kingdom = "Pseudomonadati" and tax

11 rows where bioproject = "PRJNA591127", 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
6943137	6943137	PRJNA591127_P_NODE_11446_length_218_cov_1.314917_g11277_i0	PRJNA591127	11446	218	1.314917	2.86651906	Peredibacter starrii	28202	Bacteria	Bacteria	353	4.72e-93	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g11277	i0	95.872	35.7018348623853	218	9	100	0	1	218	512486	512269	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	7783	353	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
6943216	6943216	PRJNA591127_P_NODE_19626_length_197_cov_1.956250_g19457_i0	PRJNA591127	19626	197	1.95625	3.8538125	Bdellovibrio sp. HM001	3113894	Bacteria	Bacteria	141	3.5400000000000003e-29	NTclustered	gi\|2663428595\|dbj\|AP029174.1\|	3113894	g19457	i0	100	2.31472081218274	76	0	77	0	122	197	3211239	3211164	Bdellovibrio sp. HM001 DNA, complete genome	blastn	456	141	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HM001
14593868	14593868	PRJNA591127_P_NODE_18292_length_197_cov_2.250000_g18123_i0	PRJNA591127	18292	197	2.25	4.4325	Pseudobdellovibrio exovorus	453816	Bacteria	Bacteria	141	3.5400000000000003e-29	NTclustered	gi\|469929247\|gb\|CP003537.1\|	1184267	g18123	i0	100	0.771573604060914	76	0	77	0	1	76	108868	108943	Bdellovibrio exovorus JSS, complete genome	blastn	152	141	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
17142775	17142775	PRJNA591127_P_NODE_30014_length_151_cov_3.228070_g29845_i0	PRJNA591127	30014	151	3.22807	4.8743857	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	279	5.19e-71	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g29845	i0	100	94.7483443708609	151	0	100	0	1	151	1293352	1293202	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	14307	279	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
24090709	24090709	PRJNA591127_P_NODE_23919_length_175_cov_1.724638_g23750_i0	PRJNA591127	23919	175	1.724638	3.0181165	Peredibacter	263370	Bacteria	Bacteria	235	1.36e-57	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g23750	i0	91.279	102.754285714286	172	15	98	0	1	172	513380	513551	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	17982	235	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
27774841	27774841	PRJNA591127_P_NODE_28604_length_151_cov_7.026316_g28435_i0	PRJNA591127	28604	151	7.026316	10.60973716	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	52.8	5.72e-7	NR	WP_015468462.1	349221	g28435	i0	96	0.993377483443709	25	1	49.7	0	2	76	15	39	WP_015468462.1 head decoration protein [Micavibrio aeruginosavorus]	diamond	150	52.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
28816334	28816334	PRJNA591127_P_NODE_28828_length_151_cov_5.412281_g28659_i0	PRJNA591127	28828	151	5.412281	8.17254431	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	70.9	1.23e-12	NR	WP_374076374.1	959	g28659	i0	65.3	0.973509933774834	49	17	97.4	0	3	149	410	458	WP_374076374.1 hypothetical protein [Bdellovibrio bacteriovorus]	diamond	147	70.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
29416368	29416368	PRJNA591127_P_NODE_19169_length_197_cov_2.056250_g19000_i0	PRJNA591127	19169	197	2.05625	4.0508125	Micavibrio sp.	2024841	Bacteria	Bacteria	61.2	2.44e-9	NR	HEY0900874.1	2024841	g19000	i0	32.7	2.23857868020305	147	17	99	1	2	196	16	162	HEY0900874.1 helix-turn-helix transcriptional regulator [Micavibrio sp.]	diamond	441	61.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio sp.
31090756	31090756	PRJNA591127_P_NODE_28875_length_151_cov_5.210526_g28706_i0	PRJNA591127	28875	151	5.210526	7.86789426	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	49.3	4.84e-5	NR	WP_063243448.1	959	g28706	i0	100	2.3841059602649	24	0	47.7	0	74	3	261	284	WP_063243448.1 hypothetical protein [Bdellovibrio bacteriovorus]	diamond	360	49.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
31262277	31262277	PRJNA591127_P_NODE_19195_length_197_cov_2.050000_g19026_i0	PRJNA591127	19195	197	2.05	4.0385	Bdellovibrio	958	Bacteria	Bacteria	52	1.1e-5	NR	WP_262555486.1	959	g19026	i0	100	3.03045685279188	25	0	38.1	0	1	75	468	492	WP_262555486.1 DNA topoisomerase VI subunit B [Bdellovibrio bacteriovorus]	diamond	597	52	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
32703252	32703252	PRJNA591127_P_NODE_18500_length_197_cov_2.200000_g18331_i0	PRJNA591127	18500	197	2.2	4.334	uncultured Bdellovibrio sp.	239744	Bacteria	Bacteria	94.4	6.5e-21	NR	WP_295905413.1	239744	g18331	i0	75.4	0.989847715736041	65	5	99	1	1	195	190	243	WP_295905413.1 Fe-S cluster assembly protein SufB, partial [uncultured Bdellovibrio sp.]	diamond	195	94.4	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);;