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

5 rows where analysis = "blastn", bioproject = "PRJEB56699" 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
1399036	1399036	PRJEB56699_P_NODE_6122_length_174_cov_2.303448_g5892_i0	PRJEB56699	6122	174	2.303448	4.00799952	Halobacteriovorax sp. BALOs_7	2109558	Bacteria	Bacteria	110	8.56e-20	NTclustered	gi\|1486380477\|gb\|CP027772.1\|	2109558	g5892	i0	78.286	129.66091954023	175	35	100	3	1	174	248864	249036	Halobacteriovorax sp. BALOs_7 chromosome, complete genome	blastn	22561	110	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae	Halobacteriovorax	Halobacteriovorax sp. BALOs_7
16294705	16294705	PRJEB56699_P_NODE_5473_length_197_cov_1.886905_g5243_i0	PRJEB56699	5473	197	1.886905	3.71720285	Bacteriovorax	146784	Bacteria	Bacteria	287	4.3e-73	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g5243	i0	96.552	258.258883248731	174	5	97	1	20	193	1661062	1660890	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	50877	287	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
17976191	17976191	PRJEB56699_P_NODE_2215_length_379_cov_3.748571_g1988_i0	PRJEB56699	2215	379	3.748571	14.20708409	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	195	5.67e-45	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g1988	i0	77.62	37.3298153034301	353	58	91	17	34	379	3556793	3556455	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	14148	195	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
19250166	19250166	PRJEB56699_P_NODE_576_length_766_cov_5.759837_g448_i0	PRJEB56699	576	766	5.759837	44.12035142	Bacteriovorax stolpii	960	Bacteria	Bacteria	961	0	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g448	i0	95.946	308.097911227154	592	24	100	0	175	766	1661823	1661232	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	236003	961	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
24350448	24350448	PRJEB56699_P_NODE_1740_length_435_cov_65.763547_g1521_i0	PRJEB56699	1740	435	65.763547	286.07142945	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	516	1.24e-141	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g1521	i0	88.155	286.04367816092	439	44	100	7	1	435	815306	815740	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	124429	516	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);;