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

5 rows where analysis = "blastn", bioproject = "PRJNA1020854" 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
6538898	6538898	PRJNA1020854_S_NODE_13646_length_324_cov_16.847458_g10882_i0	PRJNA1020854	13646	324	16.847458	54.58576392	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	427	4.33e-115	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g10882	i0	90.432	211.296296296296	324	31	100	0	1	324	1292764	1292441	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	68460	427	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
7381091	7381091	PRJNA1020854_S_NODE_42386_length_152_cov_3.300813_g39622_i0	PRJNA1020854	42386	152	3.300813	5.01723576	Bacteriovorax	146784	Bacteria	Bacteria	220	3.22e-53	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g39622	i0	92.81	11.4210526315789	153	10	100	1	1	152	1661722	1661874	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	1736	220	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
11206432	11206432	PRJNA1020854_S_NODE_17409_length_271_cov_10.400826_g14645_i0	PRJNA1020854	17409	271	10.400826	28.18623846	Bacteriovorax	146784	Bacteria	Bacteria	320	6.17e-83	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g14645	i0	88.192	268.317343173432	271	29	99	3	3	271	1660852	1660583	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	72714	320	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
15463466	15463466	PRJNA1020854_S_NODE_16173_length_287_cov_3.697674_g13409_i0	PRJNA1020854	16173	287	3.697674	10.61232438	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	470	6.18e-128	NTclustered	gi\|469926873\|gb\|CP003538.1\|	349215	g13409	i0	96.167	2	287	11	100	0	1	287	537635	537921	Micavibrio aeruginosavorus EPB, complete genome	blastn	574	470	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
25229306	25229306	PRJNA1020854_S_NODE_13940_length_319_cov_1075.093103_g11176_i0	PRJNA1020854	13940	319	1075.093103	3429.54699857	Bacteriovorax	146784	Bacteria	Bacteria	399	9.269999999999998e-107	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g11176	i0	93.939	251.736677115987	264	16	83	0	56	319	1660347	1660610	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	80304	399	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii

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