metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA640143" and tax

5 rows where analysis = "blastn", 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
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

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