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

6 rows where analysis = "blastn", bioproject = "PRJNA492363" 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
25975688	25975688	PRJNA492363_S_NODE_93204_length_205_cov_1.333333_g92383_i0	PRJNA492363	93204	205	1.333333	2.73333265	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	257	3.53e-64	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g92383	i0	89.268	1.58536585365854	205	22	100	0	1	205	903115	902911	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	325	257	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
26111810	26111810	PRJNA492363_S_NODE_96941_length_203_cov_1.352113_g96120_i0	PRJNA492363	96941	203	1.352113	2.74478939	Bacteriovorax sp. HI3	2984118	Bacteria	Bacteria	134	6.14e-27	NTclustered	gi\|2321225508\|dbj\|AP026946.1\|	2984118	g96120	i0	80.702	11.6650246305419	171	33	84	0	1	171	2103636	2103466	Bacteriovorax sp. HI3 DNA, complete genome	blastn	2368	134	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp. HI3
26247723	26247723	PRJNA492363_S_NODE_85854_length_209_cov_1.729730_g85033_i0	PRJNA492363	85854	209	1.72973	3.6151357	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	154	4.88e-33	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g85033	i0	80.097	0.985645933014354	206	41	99	0	2	207	3261105	3261310	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	206	154	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
26383558	26383558	PRJNA492363_S_NODE_85855_length_209_cov_1.729730_g85034_i0	PRJNA492363	85855	209	1.72973	3.6151357	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	309	9.85e-80	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g85034	i0	93.301	2	209	14	100	0	1	209	1617443	1617235	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	418	309	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
26519903	26519903	PRJNA492363_S_NODE_91392_length_206_cov_1.324138_g90571_i0	PRJNA492363	91392	206	1.324138	2.72772428	Peredibacter starrii	28202	Bacteria	Bacteria	171	4.76e-38	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g90571	i0	82.09	1.98058252427184	201	35	97	1	1	200	2188093	2188293	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	408	171	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
26577521	26577521	PRJNA492363_S_NODE_89888_length_207_cov_0.876712_g89067_i0	PRJNA492363	89888	207	0.876712	1.81479384	Peredibacter	263370	Bacteria	Bacteria	206	1.3099999999999999e-48	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g89067	i0	84.541	2	207	32	100	0	1	207	426509	426715	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	414	206	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);;