metadata: contig_metadata: 12 rows where bioproject = "PRJNA193544", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJNA193544", 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
365869	365869	PRJNA193544_S_NODE_1641_length_206_cov_5.367232_g1626_i0	PRJNA193544	1641	206	5.367232	11.05649792	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	219	1.68e-52	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g1626	i0	85.99	82	207	26	100	3	1	206	3446991	3447195	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	16892	219	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
4192973	4192973	PRJNA193544_S_NODE_1744_length_202_cov_5.699422_g1729_i0	PRJNA193544	1744	202	5.699422	11.51283244	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	248	2.09e-61	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g1729	i0	90.86	84.1683168316832	186	15	91	1	1	184	666907	667092	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	17002	248	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
10569947	10569947	PRJNA193544_S_NODE_1469_length_215_cov_8.069892_g1454_i0	PRJNA193544	1469	215	8.069892	17.3502678	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	185	1.79e-42	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g1454	i0	82.569	71.6558139534884	218	30	99	7	2	215	3448075	3448288	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	15406	185	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
11258436	11258436	PRJNA193544_S_NODE_1089_length_243_cov_18605.640187_g1074_i0	PRJNA193544	1089	243	18605.640187	45211.70565441	Bdellovibrio	958	Bacteria	Bacteria	320	5.44e-83	NTclustered	gi\|2771112236\|gb\|CP160486.1\|	959	g1074	i0	94.286	79.0041152263374	210	10	86	2	2	210	821710	821918	Bdellovibrio bacteriovorus strain MHI39 chromosome	blastn	19198	320	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
11844464	11844464	PRJNA193544_S_NODE_270_length_367_cov_1748.171598_g255_i0	PRJNA193544	270	367	1748.171598	6415.78976466	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	388	2.3399999999999996e-103	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g255	i0	92.62	175.983651226158	271	19	74	1	12	281	666229	666499	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	64586	388	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
15082771	15082771	PRJNA193544_S_NODE_1712_length_203_cov_10.327586_g1697_i0	PRJNA193544	1712	203	10.327586	20.96499958	Pseudobdellovibrio	2862745	Bacteria	Bacteria	248	2.1e-61	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g1697	i0	89.744	241.955665024631	195	18	96	2	10	203	2271	2078	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	49117	248	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
15668691	15668691	PRJNA193544_S_NODE_2473_length_175_cov_68.157534_g2458_i0	PRJNA193544	2473	175	68.157534	119.2756845	Fluviispira sanaruensis	2493639	Bacteria	Bacteria	263	6.26e-66	NTclustered	gi\|1566193515\|dbj\|AP019368.1\|	2493639	g2458	i0	93.75	240.708571428571	176	9	100	2	1	175	401052	400878	Silvanigrellales bacterium RF1110005 DNA, complete genome	blastn	42124	263	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Fluviispira	Fluviispira sanaruensis
16357669	16357669	PRJNA193544_S_NODE_313_length_357_cov_14.777439_g298_i0	PRJNA193544	313	357	14.777439	52.75545723	Pseudobdellovibrio	2862745	Bacteria	Bacteria	431	3.719999999999999e-116	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g298	i0	91.562	90.0364145658263	320	15	88	10	12	326	1864	1552	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	32143	431	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
16943128	16943128	PRJNA193544_S_NODE_1034_length_248_cov_21.100457_g1019_i0	PRJNA193544	1034	248	21.100457	52.32913336	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	344	3.299999999999999e-90	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g1019	i0	93.191	78.0161290322581	235	14	94	2	1	233	700052	700286	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	19348	344	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
16943158	16943158	PRJNA193544_S_NODE_2134_length_186_cov_18.649682_g2119_i0	PRJNA193544	2134	186	18.649682	34.68840852	Fluviispira sanaruensis	2493639	Bacteria	Bacteria	215	1.92e-51	NTclustered	gi\|1566193515\|dbj\|AP019368.1\|	2493639	g2119	i0	88.043	391.424731182796	184	18	98	4	5	186	2373209	2373028	Silvanigrellales bacterium RF1110005 DNA, complete genome	blastn	72805	215	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Fluviispira	Fluviispira sanaruensis
20767449	20767449	PRJNA193544_S_NODE_897_length_260_cov_2562.865801_g882_i0	PRJNA193544	897	260	2562.865801	6663.4510826	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	289	1.66e-73	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g882	i0	96.552	109.961538461538	174	6	67	0	1	174	666326	666499	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	28590	289	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
21457002	21457002	PRJNA193544_S_NODE_2017_length_191_cov_10.833333_g2002_i0	PRJNA193544	2017	191	10.833333	20.69166603	Pseudobdellovibrio	2862745	Bacteria	Bacteria	342	8.699999999999999e-90	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g2002	i0	98.958	150.219895287958	192	1	100	1	1	191	859	668	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	28692	342	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus

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