metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA879221" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA879221" 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
4685521	4685521	PRJNA879221_P_NODE_48044_length_250_cov_0.870056_g47904_i0	PRJNA879221	48044	250	0.870056	2.17514	Bacteriovorax stolpii	960	Bacteria	Bacteria	283	7.379999999999999e-72	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g47904	i0	95.48	2.124	177	8	71	0	13	189	3492804	3492628	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	531	283	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
5960389	5960389	PRJNA879221_P_NODE_50185_length_249_cov_0.875000_g50045_i0	PRJNA879221	50185	249	0.875	2.17875	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	185	2.1299999999999994e-42	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g50045	i0	80.408	1.45381526104418	245	47	98	1	3	247	145353	145596	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	362	185	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
11060801	11060801	PRJNA879221_P_NODE_49649_length_249_cov_0.875000_g49509_i0	PRJNA879221	49649	249	0.875	2.17875	Bdellovibrio sp. HM001	3113894	Bacteria	Bacteria	355	1.53e-93	NTclustered	gi\|2663428595\|dbj\|AP029174.1\|	3113894	g49509	i0	92.369	1	249	19	100	0	1	249	3461639	3461391	Bdellovibrio sp. HM001 DNA, complete genome	blastn	249	355	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HM001
12336192	12336192	PRJNA879221_P_NODE_43710_length_259_cov_1.655914_g43570_i0	PRJNA879221	43710	259	1.655914	4.28881726	Bacteriovorax stolpii	960	Bacteria	Bacteria	202	2.2099999999999997e-47	NTclustered	gi\|1326041851\|gb\|CP025704.1\|	960	g43570	i0	81.25	1.97683397683398	256	43	98	5	5	257	2082040	2081787	Bacteriovorax stolpii strain DSM 12778 chromosome, complete genome	blastn	512	202	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
12336356	12336356	PRJNA879221_P_NODE_56350_length_245_cov_0.895349_g56210_i0	PRJNA879221	56350	245	0.895349	2.19360505	Bacteriovorax stolpii	960	Bacteria	Bacteria	202	2.08e-47	NTclustered	gi\|1326041851\|gb\|CP025704.1\|	960	g56210	i0	81.743	2.96326530612245	241	44	98	0	5	245	759356	759116	Bacteriovorax stolpii strain DSM 12778 chromosome, complete genome	blastn	726	202	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
16159732	16159732	PRJNA879221_P_NODE_41353_length_269_cov_1.540816_g41213_i0	PRJNA879221	41353	269	1.540816	4.14479504	Bacteriovorax stolpii	960	Bacteria	Bacteria	407	4.569999999999999e-109	NTclustered	gi\|1326041851\|gb\|CP025704.1\|	960	g41213	i0	94.34	0.985130111524164	265	15	99	0	5	269	1221416	1221152	Bacteriovorax stolpii strain DSM 12778 chromosome, complete genome	blastn	265	407	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
17435414	17435414	PRJNA879221_P_NODE_56334_length_245_cov_0.895349_g56194_i0	PRJNA879221	56334	245	0.895349	2.19360505	Bacteriovorax sp. HI3	2984118	Bacteria	Bacteria	255	1.57e-63	NTclustered	gi\|2321225508\|dbj\|AP026946.1\|	2984118	g56194	i0	86.235	41.9959183673469	247	20	100	9	1	245	3717805	3718039	Bacteriovorax sp. HI3 DNA, complete genome	blastn	10289	255	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp. HI3
22533904	22533904	PRJNA879221_P_NODE_53138_length_247_cov_0.885057_g52998_i0	PRJNA879221	53138	247	0.885057	2.18609079	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	291	4.35e-74	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g52998	i0	89.565	4.95141700404858	230	22	93	2	19	247	1308260	1308032	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	1223	291	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
22533916	22533916	PRJNA879221_P_NODE_53938_length_247_cov_0.885057_g53798_i0	PRJNA879221	53938	247	0.885057	2.18609079	Bacteriovorax stolpii	960	Bacteria	Bacteria	298	2.6e-76	NTclustered	gi\|1326041851\|gb\|CP025704.1\|	960	g53798	i0	90	0.931174089068826	230	23	93	0	18	247	1196631	1196402	Bacteriovorax stolpii strain DSM 12778 chromosome, complete genome	blastn	230	298	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);;