metadata: contig_metadata: 10 rows where bioproject = "PRJNA889065", tax_phylum = "Bdellovibrionota" and tax

10 rows where bioproject = "PRJNA889065", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"

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
26865946	26865946	PRJNA889065_S_NODE_29341_length_178_cov_1.703704_g29103_i0	PRJNA889065	29341	178	1.703704	3.03259312	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	47.4	2.91e-5	NR	MCB0370954.1	2053517	g29103	i0	65.6	0.539325842696629	32	11	53.9	0	176	81	33	64	MCB0370954.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	96	47.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27719364	27719364	PRJNA889065_S_NODE_30364_length_175_cov_1.045455_g30126_i0	PRJNA889065	30364	175	1.045455	1.82954625	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	42	0.0273	NR	MBY0413284.1	2053517	g30126	i0	86.4	0.377142857142857	22	3	37.7	0	66	1	1	22	MBY0413284.1 aminotransferase class IV [Bdellovibrionales bacterium]	diamond	66	42	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28887014	28887014	PRJNA889065_S_NODE_14428_length_255_cov_2.264151_g14190_i0	PRJNA889065	14428	255	2.264151	5.77358505	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	57.8	5.51e-9	NR	MCB0370164.1	2053517	g14190	i0	72.2	0.423529411764706	36	10	42.4	0	133	240	24	59	MCB0370164.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	108	57.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29392450	29392450	PRJNA889065_S_NODE_4869_length_424_cov_4.217848_g4631_i0	PRJNA889065	4869	424	4.217848	17.88367552	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	164	3.4499999999999995e-48	NR	MCB0369811.1	2053517	g4631	i0	68.5	0.877358490566038	124	35	87.7	1	2	373	95	214	MCB0369811.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	372	164	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29550002	29550002	PRJNA889065_S_NODE_16190_length_241_cov_3.297980_g15952_i0	PRJNA889065	16190	241	3.29798	7.9481318	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	43.5	0.00469	NR	MCB0370472.1	2053517	g15952	i0	64.3	0.348547717842324	28	10	34.9	0	199	116	30	57	MCB0370472.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	84	43.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29929315	29929315	PRJNA889065_S_NODE_3011_length_510_cov_12.012848_g2786_i0	PRJNA889065	3011	510	12.012848	61.2655248	Pseudobacteriovorax antillogorgiicola	1513793	Bacteria	Bacteria	98.2	2.94e-20	NR	WP_132314505.1	1513793	g2786	i0	39.4	0.835294117647059	142	79	83.5	2	508	83	575	709	WP_132314505.1 3-hydroxyacyl-CoA dehydrogenase NAD-binding domain-containing protein [Pseudobacteriovorax antillogorgiicola]	diamond	426	98.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Pseudobacteriovoracaceae	Pseudobacteriovorax	Pseudobacteriovorax antillogorgiicola
30403487	30403487	PRJNA889065_S_NODE_30313_length_175_cov_1.393939_g30075_i0	PRJNA889065	30313	175	1.393939	2.43939325	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	69.3	2.56e-13	NR	MCB0369637.1	2053517	g30075	i0	63.3	0.84	49	17	84	1	24	170	51	98	MCB0369637.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	147	69.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31667269	31667269	PRJNA889065_S_NODE_12717_length_270_cov_2.193833_g12479_i0	PRJNA889065	12717	270	2.193833	5.9233491	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	135	2.09e-39	NR	MCB0369390.1	2053517	g12479	i0	72.5	1.01111111111111	91	23	98.9	1	2	268	3	93	MCB0369390.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	273	135	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32616310	32616310	PRJNA889065_S_NODE_7120_length_354_cov_5.369775_g6882_i0	PRJNA889065	7120	354	5.369775	19.0090035	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	70.9	1.79e-11	NR	MCB0368268.1	2053517	g6882	i0	40.4	0.796610169491525	94	54	78.8	2	61	339	377	469	MCB0368268.1 DUF4215 domain-containing protein [Bdellovibrionales bacterium]	diamond	282	70.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32899531	32899531	PRJNA889065_S_NODE_4040_length_457_cov_4.234300_g3806_i0	PRJNA889065	4040	457	4.2343	19.350751	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	73.2	8.29e-12	NR	MCB0368268.1	2053517	g3806	i0	37.8	0.643326039387308	98	59	63.7	2	340	50	375	471	MCB0368268.1 DUF4215 domain-containing protein [Bdellovibrionales bacterium]	diamond	294	73.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium

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