metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA753704" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA753704" 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
5834741	5834741	PRJNA753704_P_NODE_29985_length_229_cov_2.141026_g29624_i0	PRJNA753704	29985	229	2.141026	4.90294954	Peredibacter starrii	28202	Bacteria	Bacteria	254	5.22e-63	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g29624	i0	88.208	107.423580786026	212	25	93	0	18	229	512268	512479	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	24600	254	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
9659452	9659452	PRJNA753704_P_NODE_12828_length_332_cov_1.992278_g12467_i0	PRJNA753704	12828	332	1.992278	6.61436296	Peredibacter starrii	28202	Bacteria	Bacteria	326	1.67e-84	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g12467	i0	84.478	152.668674698795	335	46	99	6	1	331	510700	511032	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	50686	326	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
9659474	9659474	PRJNA753704_P_NODE_14188_length_317_cov_1.897541_g13827_i0	PRJNA753704	14188	317	1.897541	6.01520497	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	267	9.74e-67	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g13827	i0	83.391	9.85488958990536	289	47	91	1	20	307	2300060	2299772	Bdellovibrio bacteriovorus W, complete genome	blastn	3124	267	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
10130648	10130648	PRJNA753704_P_NODE_14228_length_316_cov_11.382716_g13867_i0	PRJNA753704	14228	316	11.382716	35.96938256	Bdellovibrio	958	Bacteria	Bacteria	435	2.5100000000000003e-117	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g13867	i0	91.772	44.7310126582278	316	21	99	5	3	316	3504404	3504716	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	14135	435	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
12681792	12681792	PRJNA753704_P_NODE_7450_length_426_cov_3.390935_g7089_i0	PRJNA753704	7450	426	3.390935	14.4453831	Bdellovibrio	958	Bacteria	Bacteria	259	2.25e-64	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g7089	i0	79.545	7.37793427230047	396	55	90	23	13	395	1189662	1189280	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	3143	259	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
15230551	15230551	PRJNA753704_P_NODE_17792_length_286_cov_2.164319_g17431_i0	PRJNA753704	17792	286	2.164319	6.18995234	Bdellovibrio	958	Bacteria	Bacteria	239	1.89e-58	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g17431	i0	89.84	20.0174825174825	187	18	65	1	84	269	3754561	3754747	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	5725	239	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
18583043	18583043	PRJNA753704_P_NODE_6235_length_460_cov_7.400517_g5874_i0	PRJNA753704	6235	460	7.400517	34.0423782	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	217	1.5e-51	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g5874	i0	75.862	138.845652173913	493	81	100	19	1	460	1676368	1676855	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	63869	217	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);;