metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJEB66218" and tax

5 rows where analysis = "diamond", bioproject = "PRJEB66218" and tax_phylum = "Candidatus Melainabacteria"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_genus	tax_species
15436134	15436134	PRJEB66218_P_NODE_50493_length_476_cov_2.033735_g48076_i0	PRJEB66218	50493	476	2.033735	9.6805786	Vampirovibrio sp.	2717857	Bacteria	Bacteria	142	2.38e-36	NR	MBX2859775.1	2717857	g48076	i0	57.1	0.838235294117647	133	47	83.8	1	409	11	167	289	MBX2859775.1 amino acid permease [Vampirovibrio sp.]	diamond	399	142	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales	Vampirovibrio	Vampirovibrio sp.
27697785	27697785	PRJEB66218_P_NODE_117644_length_278_cov_1.589862_g115215_i0	PRJEB66218	117644	278	1.589862	4.4198163600000004	Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11	1801609	Bacteria	Bacteria	50.4	9.95e-5	NR	OGI09100.1	1801609	g115215	i0	52.4	0.453237410071942	42	20	45.3	0	56	181	122	163	OGI09100.1 MAG: hypothetical protein A3F80_00030 [Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11]	diamond	126	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11
28076172	28076172	PRJEB66218_P_NODE_117025_length_279_cov_1.192661_g114596_i0	PRJEB66218	117025	279	1.192661	3.32752419	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	56.2	1.06e-6	NR	MBX3137205.1	2364082	g114596	i0	35.4	1.6989247311828	79	50	83.9	1	24	257	2128	2206	MBX3137205.1 zeta toxin family protein [Candidatus Obscuribacterales bacterium]	diamond	474	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales		Candidatus Obscuribacterales bacterium
29339382	29339382	PRJEB66218_P_NODE_173529_length_225_cov_1.554878_g171099_i0	PRJEB66218	173529	225	1.554878	3.4984755	Vampirovibrionales bacterium	2692181	Bacteria	Bacteria	99	1.19e-23	NR	MBK8190284.1	2692181	g171099	i0	67.6	2.93333333333333	71	22	94.7	1	214	2	119	188	MBK8190284.1 MBL fold metallo-hydrolase [Vampirovibrionales bacterium]	diamond	660	99	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales		Vampirovibrionales bacterium
32752311	32752311	PRJEB66218_P_NODE_168520_length_228_cov_1.856287_g166090_i0	PRJEB66218	168520	228	1.856287	4.23233436	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	147	1.0899999999999999e-43	NR	MBX9722669.1	2364082	g166090	i0	86.8	2	76	10	100	0	1	228	5	80	MBX9722669.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	456	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales		Candidatus Obscuribacterales 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);;