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

5 rows where analysis = "blastn", bioproject = "PRJNA1122875" 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
2304035	2304035	PRJNA1122875_P_NODE_29042_length_304_cov_2.103896_g28818_i0	PRJNA1122875	29042	304	2.103896	6.39584384	Bacteriovorax	146784	Bacteria	Bacteria	446	1.11e-120	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g28818	i0	93.16	55.0888157894737	307	15	100	6	1	304	1661912	1661609	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	16747	446	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
4856700	4856700	PRJNA1122875_P_NODE_21804_length_355_cov_2.393617_g21580_i0	PRJNA1122875	21804	355	2.393617	8.49734035	Micavibrio	213485	Bacteria	Bacteria	342	1.78e-89	NTclustered	gi\|469926873\|gb\|CP003538.1\|	349215	g21580	i0	84.167	280.588732394366	360	49	100	8	1	355	463176	462820	Micavibrio aeruginosavorus EPB, complete genome	blastn	99609	342	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
5380732	5380732	PRJNA1122875_P_NODE_27265_length_316_cov_1.555556_g27041_i0	PRJNA1122875	27265	316	1.555556	4.91555696	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	86.1	2.92e-12	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g27041	i0	89.706	7.7373417721519004	68	6	22	1	11	78	802897	802831	Bdellovibrio bacteriovorus W, complete genome	blastn	2445	86.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
11232075	11232075	PRJNA1122875_P_NODE_33989_length_283_cov_1.466667_g33765_i0	PRJNA1122875	33989	283	1.466667	4.15066761	Bacteriovorax	146784	Bacteria	Bacteria	448	2.8499999999999996e-121	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g33765	i0	95.39	185.388692579505	282	11	99	2	1	281	1662160	1661880	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	52465	448	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
23229855	23229855	PRJNA1122875_P_NODE_22599_length_349_cov_1.623188_g22375_i0	PRJNA1122875	22599	349	1.623188	5.66492612	Bdellovibrio sp. HCB-162	3394234	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2898207634\|gb\|CP178861.1\|	3394234	g22375	i0	100	0.0802292263610315	28	0	8	0	132	159	11082	11055	Bdellovibrio sp. HCB-162 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB-162

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