metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA796753" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA796753" 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
2056645	2056645	PRJNA796753_P_NODE_38462_length_252_cov_1.083799_g38150_i0	PRJNA796753	38462	252	1.083799	2.73117348	Peredibacter starrii	28202	Bacteria	Bacteria	427	3.2499999999999993e-115	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g38150	i0	97.222	69.3690476190476	252	7	100	0	1	252	512036	512287	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	17481	427	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
7159202	7159202	PRJNA796753_P_NODE_49366_length_244_cov_0.900585_g49054_i0	PRJNA796753	49366	244	0.900585	2.1974274	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	307	4.25e-79	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g49054	i0	89.344	1.11475409836066	244	26	100	0	1	244	3299035	3299278	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	272	307	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
9709021	9709021	PRJNA796753_P_NODE_4768_length_616_cov_1.521179_g4464_i0	PRJNA796753	4768	616	1.521179	9.37046264	Bacteriovorax stolpii	960	Bacteria	Bacteria	939	0	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g4464	i0	94.165	213.512987012987	617	35	100	1	1	616	1660903	1661519	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	131524	939	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
10984738	10984738	PRJNA796753_P_NODE_42109_length_249_cov_0.875000_g41797_i0	PRJNA796753	42109	249	0.875	2.17875	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	178	3.56e-40	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g41797	i0	81.364	0.883534136546185	220	39	88	2	12	230	2652381	2652599	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	220	178	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
15245125	15245125	PRJNA796753_P_NODE_3492_length_711_cov_3.236677_g3204_i0	PRJNA796753	3492	711	3.236677	23.01277347	Bacteriovorax	146784	Bacteria	Bacteria	848	0	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g3204	i0	88.252	119	715	77	100	7	1	711	1660364	1661075	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	84609	848	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
16083101	16083101	PRJNA796753_P_NODE_10773_length_423_cov_1.980000_g10461_i0	PRJNA796753	10773	423	1.98	8.3754	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	472	2.64e-128	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g10461	i0	86.854	185.787234042553	426	50	100	6	1	423	3447876	3448298	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	78588	472	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
21183163	21183163	PRJNA796753_P_NODE_30417_length_278_cov_2.517073_g30105_i0	PRJNA796753	30417	278	2.517073	6.99746294	Bdellovibrio sp. HCB117	3394359	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2895987660\|gb\|CP178622.1\|	3394359	g30105	i0	92.308	0.140287769784173	39	3	14	0	117	155	1078659	1078697	Bdellovibrio sp. HCB117 chromosome, complete genome	blastn	39	56.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB117
24168280	24168280	PRJNA796753_P_NODE_26499_length_292_cov_1.406393_g26187_i0	PRJNA796753	26499	292	1.406393	4.10666756	Bacteriovorax	146784	Bacteria	Bacteria	451	2.28e-122	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g26187	i0	94.828	97.7979452054795	290	14	99	1	3	292	1661859	1661571	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	28557	451	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);;