metadata: contig_metadata: 6 rows where bioproject = "PRJNA915212" and tax

6 rows where bioproject = "PRJNA915212" 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
26707706	26707706	PRJNA915212_P_NODE_1021_length_662_cov_2.569331_g990_i0	PRJNA915212	1021	662	2.569331	17.00897122	Pseudobacteriovorax antillogorgiicola	1513793	Bacteria	Bacteria	117	8.040000000000001e-29	NR	WP_132317945.1	1513793	g990	i0	37.3	0.874622356495468	193	115	85.2	4	564	1	1	192	WP_132317945.1 DUF2589 domain-containing protein [Pseudobacteriovorax antillogorgiicola]	diamond	579	117	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Pseudobacteriovoracaceae	Pseudobacteriovorax	Pseudobacteriovorax antillogorgiicola
27119113	27119113	PRJNA915212_P_NODE_10442_length_178_cov_1.581395_g10404_i0	PRJNA915212	10442	178	1.581395	2.8148831	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	68.6	2.62e-12	NR	MBX9767865.1	2053517	g10404	i0	91.4	0.589887640449438	35	3	59	0	109	5	114	148	MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	105	68.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28761413	28761413	PRJNA915212_P_NODE_2367_length_427_cov_1.828042_g2331_i0	PRJNA915212	2367	427	1.828042	7.80573934	Pseudobacteriovorax antillogorgiicola	1513793	Bacteria	Bacteria	68.2	6.63e-11	NR	WP_132317945.1	1513793	g2331	i0	45.5	0.540983606557377	77	41	53.4	1	427	200	28	104	WP_132317945.1 DUF2589 domain-containing protein [Pseudobacteriovorax antillogorgiicola]	diamond	231	68.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Pseudobacteriovoracaceae	Pseudobacteriovorax	Pseudobacteriovorax antillogorgiicola
30372523	30372523	PRJNA915212_P_NODE_13492_length_164_cov_0.886957_g13454_i0	PRJNA915212	13492	164	0.886957	1.45460948	Oligoflexia bacterium	2599941	Bacteria	Bacteria	49.3	2.13e-5	NR	MBX7138565.1	2599941	g13454	i0	52.2	1.8109756097561	46	22	84.1	0	14	151	42	87	MBX7138565.1 potassium channel family protein [Oligoflexia bacterium]	diamond	297	49.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
31857723	31857723	PRJNA915212_P_NODE_3277_length_349_cov_1.003333_g3240_i0	PRJNA915212	3277	349	1.003333	3.50163217	Pseudobacteriovorax antillogorgiicola	1513793	Bacteria	Bacteria	74.7	9.02e-14	NR	WP_132317945.1	1513793	g3240	i0	41.6	0.765042979942693	89	49	74.8	2	87	347	5	92	WP_132317945.1 DUF2589 domain-containing protein [Pseudobacteriovorax antillogorgiicola]	diamond	267	74.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Pseudobacteriovoracaceae	Pseudobacteriovorax	Pseudobacteriovorax antillogorgiicola
32174458	32174458	PRJNA915212_P_NODE_3158_length_357_cov_1.535714_g3121_i0	PRJNA915212	3158	357	1.535714	5.48249898	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	164	6.69e-49	NR	MBX9767865.1	2053517	g3121	i0	88	0.773109243697479	92	11	77.3	0	77	352	1	92	MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	276	164	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);;