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

5 rows where analysis = "diamond", bioproject = "PRJNA752278" and tax_phylum = "Ignavibacteriota"

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_family	tax_species
28284329	28284329	PRJNA752278_P_NODE_17046_length_376_cov_1.762376_g16843_i0	PRJNA752278	17046	376	1.762376	6.62653376	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	81.6	1.61e-15	NR	MCF6270679.1	2614255	g16843	i0	68.4	2.3218085106383	57	18	45.5	0	173	3	3	59	MCF6270679.1 cysteine synthase family protein [Melioribacteraceae bacterium]	diamond	873	81.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
28505548	28505548	PRJNA752278_P_NODE_53127_length_274_cov_1.671642_g52924_i0	PRJNA752278	53127	274	1.671642	4.58029908	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	65.1	1.22e-10	NR	HEX2869324.1	2049428	g52924	i0	54	2.81386861313869	63	27	69	1	200	12	116	176	HEX2869324.1 NADP-dependent oxidoreductase [Ignavibacteriales bacterium]	diamond	771	65.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
29021001	29021001	PRJNA752278_P_NODE_688_length_1231_cov_2.089810_g563_i0	PRJNA752278	688	1231	2.08981	25.7255611	Bacteria	2	Bacteria	Bacteria	184	8.55e-51	NR	MAT57736.1	2026749	g563	i0	35	1.55483346872461	317	171	76.3	5	983	45	17	302	MAT57736.1 fatty acid desaturase [Ignavibacteriota bacterium]	diamond	1914	184	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
31664521	31664521	PRJNA752278_P_NODE_106217_length_239_cov_2.295181_g106014_i0	PRJNA752278	106217	239	2.295181	5.48548259	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	108	8.280000000000001e-26	NR	MCK5456842.1	2614255	g106014	i0	59.5	0.99163179916318	79	32	99.2	0	238	2	294	372	MCK5456842.1 Glu/Leu/Phe/Val dehydrogenase [Melioribacteraceae bacterium]	diamond	237	108	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
32044288	32044288	PRJNA752278_P_NODE_106078_length_239_cov_2.638554_g105875_i0	PRJNA752278	106078	239	2.638554	6.30614406	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	87	9.12e-18	NR	MCX6168873.1	2049428	g105875	i0	78	3.76569037656904	50	11	62.8	0	239	90	1178	1227	MCX6168873.1 methionine synthase [Ignavibacteriales bacterium]	diamond	900	87	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales 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);;