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

5 rows where analysis = "blastn", bioproject = "PRJNA1086823" 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
1468583	1468583	PRJNA1086823_P_NODE_8842_length_284_cov_1.374408_g8725_i0	PRJNA1086823	8842	284	1.374408	3.90331872	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	219	2.44e-52	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g8725	i0	88.764	1.5387323943662	178	20	63	0	1	178	2556357	2556180	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	437	219	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
4020334	4020334	PRJNA1086823_P_NODE_16504_length_246_cov_0.901734_g16387_i0	PRJNA1086823	16504	246	0.901734	2.21826564	Bdellovibrio sp. HM001	3113894	Bacteria	Bacteria	167	7.61e-37	NTclustered	gi\|2663428595\|dbj\|AP029174.1\|	3113894	g16387	i0	79.253	10.1869918699187	241	48	98	2	7	246	157347	157108	Bdellovibrio sp. HM001 DNA, complete genome	blastn	2506	167	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HM001
8670657	8670657	PRJNA1086823_P_NODE_3987_length_390_cov_1.422713_g3870_i0	PRJNA1086823	3987	390	1.422713	5.5485807	Pseudobdellovibrio	2862745	Bacteria	Bacteria	693	0	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g3870	i0	98.718	200.076923076923	390	5	100	0	1	390	1186	797	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	78030	693	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
9121546	9121546	PRJNA1086823_P_NODE_6788_length_314_cov_1.294606_g6671_i0	PRJNA1086823	6788	314	1.294606	4.06506284	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	564	3.05e-156	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g6671	i0	99.045	173.541401273885	314	3	100	0	1	314	1292670	1292983	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	54492	564	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
22694270	22694270	PRJNA1086823_P_NODE_16258_length_246_cov_1.375723_g16141_i0	PRJNA1086823	16258	246	1.375723	3.38427858	Bdellovibrio	958	Bacteria	Bacteria	318	1.98e-82	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g16141	i0	90.756	354.30487804878	238	22	97	0	9	246	613151	612914	Bdellovibrio bacteriovorus W, complete genome	blastn	87159	318	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);;