metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA940501" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA940501" 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
10187303	10187303	PRJNA940501_S_NODE_98208_length_239_cov_1.724490_g97390_i0	PRJNA940501	98208	239	1.72449	4.1215311	root	1	Root_unresolved	Root_unresolved	99.4	4.16e-22	NR	WP_015300700.1	387341	g97390	i0	79	7.07949790794979	62	13	77.8	0	50	235	574	635	WP_015300700.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Halovivax ruber]	diamond	1692	100	0.994	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Halovivax	Halovivax ruber
28604277	28604277	PRJNA940501_S_NODE_23227_length_348_cov_2.049180_g22409_i0	PRJNA940501	23227	348	2.04918	7.1311464	Haloferax sp. Atlit-12N	2077203	Archaea	Archaea	62	1.68e-8	NR	WP_115883272.1	2077203	g22409	i0	38.8	1.35344827586207	85	46	69.8	3	14	256	228	310	WP_115883272.1 oxidoreductase [Haloferax sp. Atlit-12N]	diamond	471	62	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax sp. Atlit-12N
30909982	30909982	PRJNA940501_S_NODE_100734_length_237_cov_2.592784_g99916_i0	PRJNA940501	100734	237	2.592784	6.14489808	Methanofollis sp.	2052835	Archaea	Archaea	42.7	0.0359	NR	MDK2974911.1	2052835	g99916	i0	30.6	0.784810126582278	62	36	69.6	2	40	204	483	544	MDK2974911.1 hypothetical protein [Methanofollis sp.]	diamond	186	42.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanofollis	Methanofollis sp.
31068057	31068057	PRJNA940501_S_NODE_5635_length_634_cov_4.622673_g4995_i0	PRJNA940501	5635	634	4.622673	29.30774682	Methanosarcinales archaeon	2250255	Archaea	Archaea	122	6.57e-29	NR	RYE84491.1	2250255	g4995	i0	55.4	2.69242902208202	112	47	51.6	1	27	353	124	235	RYE84491.1 MAG: hypothetical protein EOO65_02170 [Methanosarcinales archaeon]	diamond	1707	122	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
31858355	31858355	PRJNA940501_S_NODE_322217_length_163_cov_1.175000_g321399_i0	PRJNA940501	322217	163	1.175	1.91525	Methanosarcinales archaeon	2250255	Archaea	Archaea	100	6.839999999999999e-23	NR	RYE85578.1	2250255	g321399	i0	75.9	0.993865030674847	54	13	99.4	0	162	1	46	99	RYE85578.1 MAG: hypothetical protein EOO65_00010 [Methanosarcinales archaeon]	diamond	162	100	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
32428047	32428047	PRJNA940501_S_NODE_129499_length_221_cov_1.584270_g128681_i0	PRJNA940501	129499	221	1.58427	3.5012367	Methanoregula sp.	2052170	Archaea	Archaea	42	0.0331	NR	MDD1680356.1	2052170	g128681	i0	37.2	1.05882352941176	78	30	82.8	3	208	26	56	131	MDD1680356.1 hypothetical protein [Methanoregula sp.]	diamond	234	42	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula 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);;