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

5 rows where analysis = "diamond", bioproject = "PRJNA703759" 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
27304183	27304183	PRJNA703759_P_NODE_33943_length_254_cov_1.292818_g33467_i0	PRJNA703759	33943	254	1.292818	3.28375772	Natrinema pallidum	69527	Archaea	Archaea	40	0.0358	NR	WP_152422535.1	69527	g33467	i0	65.2	0.271653543307087	23	8	27.2	0	186	254	6	28	WP_152422535.1 hypothetical protein [Natrinema pallidum]	diamond	69	40	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema pallidum
27588426	27588426	PRJNA703759_P_NODE_32244_length_259_cov_1.645161_g31768_i0	PRJNA703759	32244	259	1.645161	4.26096699	Haladaptatus sp. DYF46	2886041	Archaea	Archaea	43.5	0.0225	NR	WP_303646666.1	2886041	g31768	i0	64.7	0.393822393822394	34	11	39.4	1	248	147	317	349	WP_303646666.1 non-hydrolyzing UDP-N-acetylglucosamine 2-epimerase [Haladaptatus sp. DYF46]	diamond	102	43.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Haladaptatus	Haladaptatus sp. DYF46
28693622	28693622	PRJNA703759_P_NODE_40527_length_249_cov_0.886364_g40051_i0	PRJNA703759	40527	249	0.886364	2.20704636	Halobacterium sp. KA-4	2896367	Archaea	Archaea	54.7	8.49e-8	NR	WP_230888317.1	2896367	g40051	i0	82.4	0.409638554216867	34	6	41	0	103	2	1	34	WP_230888317.1 hypothetical protein [Halobacterium sp. KA-4]	diamond	102	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halobacterium	Halobacterium sp. KA-4
29009530	29009530	PRJNA703759_P_NODE_20108_length_309_cov_1.593220_g19632_i0	PRJNA703759	20108	309	1.59322	4.9230498	Halorientalis marina	2931976	Archaea	Archaea	43.5	0.0409	NR	WP_246986624.1	2931976	g19632	i0	29.8	1.00970873786408	104	63	96.1	4	3	299	78	176	WP_246986624.1 cytochrome P450 [Halorientalis marina]	diamond	312	43.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halorientalis	Halorientalis marina
29399111	29399111	PRJNA703759_P_NODE_51229_length_242_cov_0.923077_g50753_i0	PRJNA703759	51229	242	0.923077	2.23384634	Halobacteriales	2235	Archaea	Archaea	84	1.14e-16	NR	WP_276410133.1	2237	g50753	i0	50.6	24.4710743801653	81	37	96.7	1	7	240	550	630	WP_276410133.1 MULTISPECIES: DUF2309 domain-containing protein [Haloarcula]	diamond	5922	84.7	0.991735537190083	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Haloarcula

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