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

5 rows where analysis = "diamond", bioproject = "PRJEB29441" and tax_clade = "Stenosarchaea group"

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_genus	tax_species
28201667	28201667	PRJEB29441_P_NODE_29466_length_193_cov_1.319444_g29025_i0	PRJEB29441	29466	193	1.319444	2.54652692	Halostella litorea	2528831	Archaea	Archaea	44.3	0.00167	NR	WP_135820513.1	2528831	g29025	i0	37.9	0.901554404145078	58	35	90.2	1	6	179	12	68	WP_135820513.1 DUF5518 domain-containing protein [Halostella litorea]	diamond	174	44.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronoarchaeaceae	Halostella	Halostella litorea
28612380	28612380	PRJEB29441_P_NODE_41427_length_165_cov_0.879310_g40986_i0	PRJEB29441	41427	165	0.87931	1.4508615	Methanosarcina sp.	2213	Archaea	Archaea	44.3	0.00276	NR	HET8685592.1	2213	g40986	i0	46.5	0.781818181818182	43	23	78.2	0	33	161	1	43	HET8685592.1 hypothetical protein [Methanosarcina sp.]	diamond	129	44.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
28826609	28826609	PRJEB29441_P_NODE_36848_length_172_cov_0.788618_g36407_i0	PRJEB29441	36848	172	0.788618	1.35642296	Salinibaculum	2732368	Archaea	Archaea	42.7	0.00247	NR	MEF8871985.1	2497615	g36407	i0	41.7	1.67441860465116	48	26	83.7	1	157	14	14	59	MEF8871985.1 hypothetical protein [Haloarculaceae archaeon]	diamond	288	43.1	0.990719257540603	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae		Haloarculaceae archaeon
31708351	31708351	PRJEB29441_P_NODE_43837_length_163_cov_1.394737_g43396_i0	PRJEB29441	43837	163	1.394737	2.27342131	Haladaptatus salinisoli	2884876	Archaea	Archaea	75.1	1.59e-14	NR	WP_227357203.1	2884876	g43396	i0	61.1	0.993865030674847	54	21	99.4	0	1	162	203	256	WP_227357203.1 CoA-transferase subunit beta [Haladaptatus salinisoli]	diamond	162	75.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Haladaptatus	Haladaptatus salinisoli
32688459	32688459	PRJEB29441_P_NODE_44660_length_163_cov_0.894737_g44219_i0	PRJEB29441	44660	163	0.894737	1.45842131	Halococcus sp.	29286	Archaea	Archaea	108	5.2600000000000005e-27	NR	HET7324970.1	29286	g44219	i0	92.6	1.98773006134969	54	4	99.4	0	1	162	231	284	HET7324970.1 DNA glycosylase [Halococcus sp.]	diamond	324	108	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus sp.

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