metadata: contig_metadata: 5 rows where bioproject = "PRJNA591000" and tax

5 rows where bioproject = "PRJNA591000" and tax_kingdom = "Methanobacteriati"

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
27711949	27711949	PRJNA591000_P_NODE_7964_length_493_cov_5.577586_g6459_i0	PRJNA591000	7964	493	5.577586	27.49749898	Halopenitus persicus	1048396	Archaea	Archaea	46.2	0.0212	NR	WP_096390784.1	1048396	g6459	i0	33.9	0.663286004056795	109	66	65.7	3	117	440	21	124	WP_096390784.1 sugar kinase [Halopenitus persicus]	diamond	327	46.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halopenitus	Halopenitus persicus
29321705	29321705	PRJNA591000_P_NODE_12829_length_408_cov_3.308707_g11241_i0	PRJNA591000	12829	408	3.308707	13.49952456	Thermoplasmata archaeon	1906666	Archaea	Archaea	76.6	2.04e-13	NR	MBE3137513.1	1906666	g11241	i0	58.7	0.463235294117647	63	26	46.3	0	156	344	23	85	MBE3137513.1 methyltransferase domain-containing protein [Thermoplasmata archaeon]	diamond	189	76.6	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
29479337	29479337	PRJNA591000_P_NODE_7970_length_493_cov_3.478448_g6465_i0	PRJNA591000	7970	493	3.478448	17.14874864	Euryarchaeota archaeon RBG_13_31_8	1797976	Archaea	Archaea	160	9.969999999999999e-47	NR	OGS41372.1	1797976	g6465	i0	49.7	0.931034482758621	153	77	93.1	0	1	459	29	181	OGS41372.1 MAG: hypothetical protein A3K77_06355 [Euryarchaeota archaeon RBG_13_31_8]	diamond	459	160	1	Archaea		Methanobacteriati	Methanobacteriota					Euryarchaeota archaeon RBG_13_31_8
29668707	29668707	PRJNA591000_P_NODE_6070_length_581_cov_3.628623_g4793_i0	PRJNA591000	6070	581	3.628623	21.08229963	Methanosarcina sp.	2213	Archaea	Archaea	213	9.72e-67	NR	HET8685478.1	2213	g4793	i0	68.8	0.743545611015491	144	39	71.3	1	579	166	60	203	HET8685478.1 hypothetical protein [Methanosarcina sp.]	diamond	432	213	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
30047894	30047894	PRJNA591000_P_NODE_4171_length_712_cov_3.587116_g3291_i0	PRJNA591000	4171	712	3.587116	25.54026592	Methanofastidiosum sp.	2666341	Archaea	Archaea	81.6	1.71e-14	NR	HQF90298.1	2666341	g3291	i0	42.7	0.463483146067416	110	51	46.3	2	342	13	2	99	HQF90298.1 hypothetical protein [Methanofastidiosum sp.]	diamond	330	81.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Candidatus Methanofastidiosia	Candidatus Methanofastidiosales	Candidatus Methanofastidiosaceae	Candidatus Methanofastidiosum	Methanofastidiosum 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);;