metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA674048" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA674048" 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
2441320	2441320	PRJNA674048_P_NODE_23382_length_182_cov_1.496241_g23179_i0	PRJNA674048	23382	182	1.496241	2.72315862	Micavibrio	213485	Bacteria	Bacteria	209	8.68e-50	NTclustered	gi\|469926873\|gb\|CP003538.1\|	349215	g23179	i0	87.634	319.291208791209	186	16	100	6	1	182	463006	462824	Micavibrio aeruginosavorus EPB, complete genome	blastn	58111	209	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
3193978	3193978	PRJNA674048_P_NODE_23083_length_183_cov_1.552239_g22880_i0	PRJNA674048	23083	183	1.552239	2.84059737	Bdellovibrio reynosensis	2835041	Bacteria	Bacteria	150	5.37e-32	NTclustered	gi\|2216477995\|gb\|CP093442.1\|	2835041	g22880	i0	81.667	0.983606557377049	180	33	98	0	2	181	375524	375703	Bdellovibrio reynosensis strain LBG001 chromosome, complete genome	blastn	180	150	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio reynosensis
7021746	7021746	PRJNA674048_P_NODE_27006_length_169_cov_0.866667_g26803_i0	PRJNA674048	27006	169	0.866667	1.46466723	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	87.9	3.87e-13	NTclustered	gi\|2893356065\|emb\|OZ220488.1\|	2053517	g26803	i0	94.737	1.06508875739645	57	2	34	1	113	169	730199	730144	MAG: Bdellovibrionales bacterium isolate 0d1acec5-ee6a-42a0-9e8e-8bc2840f726d genome assembly, chromosome: 1	blastn	180	87.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
13920062	13920062	PRJNA674048_P_NODE_32051_length_163_cov_0.912281_g31848_i0	PRJNA674048	32051	163	0.912281	1.48701803	Bdellovibrio	958	Bacteria	Bacteria	196	5.93e-46	NTclustered	gi\|2898207634\|gb\|CP178861.1\|	3394234	g31848	i0	88.75	8.29447852760736	160	18	98	0	1	160	2699265	2699424	Bdellovibrio sp. HCB-162 chromosome, complete genome	blastn	1352	196	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB-162
20292495	20292495	PRJNA674048_P_NODE_26976_length_169_cov_0.866667_g26773_i0	PRJNA674048	26976	169	0.866667	1.46466723	Bdellovibrio	958	Bacteria	Bacteria	169	1.34e-37	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g26773	i0	86.755	8.10650887573964	151	20	89	0	19	169	4059767	4059617	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	1370	169	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
21045651	21045651	PRJNA674048_P_NODE_22997_length_183_cov_2.201493_g22794_i0	PRJNA674048	22997	183	2.201493	4.02873219	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	307	3.0100000000000005e-79	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g22794	i0	97.753	282.497267759563	178	4	97	0	1	178	780737	780560	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	51697	307	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24869229	24869229	PRJNA674048_P_NODE_14200_length_239_cov_1.336842_g13997_i0	PRJNA674048	14200	239	1.336842	3.19505238	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	401	1.8499999999999992e-107	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g13997	i0	98.673	236.790794979079	226	3	95	0	14	239	778697	778922	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	56593	401	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus

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