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

5 rows where analysis = "blastn", bioproject = "PRJNA667863" 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
8816584	8816584	PRJNA667863_P_NODE_6987_length_278_cov_2.707317_g6953_i0	PRJNA667863	6987	278	2.707317	7.52634126	Bdellovibrio	958	Bacteria	Bacteria	268	2.3299999999999994e-67	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g6953	i0	88.688	57.2374100719424	221	23	79	2	26	246	816662	816444	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	15912	268	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
12642741	12642741	PRJNA667863_P_NODE_18650_length_226_cov_2.751634_g18616_i0	PRJNA667863	18650	226	2.751634	6.21869284	Pseudobdellovibrio	2862745	Bacteria	Bacteria	257	3.97e-64	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g18616	i0	87.5	171.685840707965	232	18	100	11	1	226	1173	947	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	38801	257	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
13388035	13388035	PRJNA667863_P_NODE_17991_length_232_cov_3.534591_g17957_i0	PRJNA667863	17991	232	3.534591	8.20025112	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	398	2.3099999999999995e-106	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g17957	i0	97.826	166.336206896552	230	5	99	0	3	232	1293204	1293433	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	38590	398	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
20289938	20289938	PRJNA667863_P_NODE_2776_length_358_cov_1.929825_g2742_i0	PRJNA667863	2776	358	1.929825	6.9087735	Peredibacter	263370	Bacteria	Bacteria	610	4.46e-170	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g2742	i0	97.486	27.7569832402235	358	8	100	1	1	358	512482	512126	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	9937	610	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
22311223	22311223	PRJNA667863_P_NODE_10778_length_253_cov_1.950000_g10744_i0	PRJNA667863	10778	253	1.95	4.9335	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	217	7.689999999999999e-52	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g10744	i0	82.52	0.972332015810277	246	43	97	0	4	249	357232	356987	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	246	217	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198

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