metadata: contig_metadata: 5 rows where bioproject = "PRJNA352610" and tax

5 rows where bioproject = "PRJNA352610" 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
27106220	27106220	PRJNA352610_P_NODE_21122_length_274_cov_1.069652_g21061_i0	PRJNA352610	21122	274	1.069652	2.93084648	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	55.1	2.25e-6	NR	MBC62650.1	2026715	g21061	i0	45.3	0.58029197080292	53	29	58	0	274	116	273	325	MBC62650.1 malate dehydrogenase [Pseudobdellovibrionaceae bacterium]	diamond	159	55.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
28432859	28432859	PRJNA352610_P_NODE_23346_length_260_cov_1.614973_g23285_i0	PRJNA352610	23346	260	1.614973	4.1989298	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	45.1	0.00685	NR	MDQ3231995.1	2026715	g23285	i0	38.4	0.992307692307692	86	41	99.2	2	2	259	9	82	MDQ3231995.1 response regulator [Pseudobdellovibrionaceae bacterium]	diamond	258	45.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
30376734	30376734	PRJNA352610_P_NODE_8432_length_393_cov_0.962500_g8371_i0	PRJNA352610	8432	393	0.9625	3.782625	Pseudomonadati	3379134	Bacteria	Bacteria	63.5	1.06e-8	NR	MBQ48580.1	2026715	g8371	i0	31.4	3.15267175572519	140	77	96.9	4	383	3	23	156	MBQ48580.1 hypothetical protein [Pseudobdellovibrionaceae bacterium]	diamond	1239	63.9	0.993740219092332	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
30580068	30580068	PRJNA352610_P_NODE_30373_length_243_cov_0.905882_g30312_i0	PRJNA352610	30373	243	0.905882	2.20129326	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	44.7	0.00254	NR	MEE2744353.1	3034175	g30312	i0	36.4	0.679012345679012	55	34	66.7	1	6	167	72	126	MEE2744353.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	165	44.7	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
31844700	31844700	PRJNA352610_P_NODE_15957_length_309_cov_0.978814_g15896_i0	PRJNA352610	15957	309	0.978814	3.02453526	Silvanigrella paludirubra	2499159	Bacteria	Bacteria	71.6	5.77e-12	NR	WP_153420773.1	2499159	g15896	i0	48.5	0.660194174757282	68	35	66	0	103	306	57	124	WP_153420773.1 insecticidal delta-endotoxin Cry8Ea1 family protein [Silvanigrella paludirubra]	diamond	204	71.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Silvanigrella	Silvanigrella paludirubra

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