metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA1137393" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA1137393" 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
284654	284654	PRJNA1137393_P_NODE_15241_length_221_cov_1.209302_g14725_i0	PRJNA1137393	15241	221	1.209302	2.67255742	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	211	3.05e-50	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g14725	i0	84.163	7.38914027149321	221	32	99	3	1	220	469335	469553	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	1633	211	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
2835369	2835369	PRJNA1137393_P_NODE_28943_length_183_cov_1.537313_g28427_i0	PRJNA1137393	28943	183	1.537313	2.81328279	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	274	3.06e-69	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g28427	i0	93.923	87.8524590163934	181	11	99	0	3	183	779074	779254	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	16077	274	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
7937693	7937693	PRJNA1137393_P_NODE_17387_length_211_cov_2.746914_g16871_i0	PRJNA1137393	17387	211	2.746914	5.79598854	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	148	2.3e-31	NTclustered	gi\|2907625691\|emb\|OZ223251.1\|	2081706	g16871	i0	80.193	248.881516587678	207	33	96	8	3	205	90798	91000	MAG: Bacteriovoracaceae bacterium isolate 56684ba0-df17-47c9-bcf5-ee076427a4fa genome assembly, chromosome: 1	blastn	52514	148	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
10488263	10488263	PRJNA1137393_P_NODE_38729_length_169_cov_6.075000_g38213_i0	PRJNA1137393	38729	169	6.075	10.26675	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	178	2.23e-40	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g38213	i0	86.145	118.934911242604	166	21	98	2	4	168	467075	467239	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	20100	178	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
10488326	10488326	PRJNA1137393_P_NODE_55849_length_165_cov_2.750000_g55333_i0	PRJNA1137393	55849	165	2.75	4.5375	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	182	1.6899999999999996e-41	NTclustered	gi\|2893356065\|emb\|OZ220488.1\|	2053517	g55333	i0	91.603	297.854545454545	131	11	79	0	18	148	728670	728800	MAG: Bdellovibrionales bacterium isolate 0d1acec5-ee6a-42a0-9e8e-8bc2840f726d genome assembly, chromosome: 1	blastn	49146	182	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
21961662	21961662	PRJNA1137393_P_NODE_9278_length_272_cov_2.443946_g8762_i0	PRJNA1137393	9278	272	2.443946	6.64753312	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	274	4.889999999999998e-69	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g8762	i0	85.036	213.805147058824	274	35	99	5	1	270	469435	469164	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	58155	274	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium

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