metadata: contig_metadata: 5 rows where bioproject = "PRJNA432257", tax_phylum = "Thermoplasmatota" and tax

5 rows where bioproject = "PRJNA432257", tax_phylum = "Thermoplasmatota" and tax_superkingdom = "Archaea"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27170372	27170372	PRJNA432257_S_NODE_22502_length_309_cov_18.356618_g22121_i0	PRJNA432257	22502	309	18.356618	56.72194962	Thermoplasmata archaeon	1906666	Archaea	Archaea	146	1.32e-41	NR	MEM3335869.1	1906666	g22121	i0	70.7	3.61165048543689	99	26	93.2	2	1	288	41	139	MEM3335869.1 hypothetical protein [Thermoplasmata archaeon]	diamond	1116	146	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
27676259	27676259	PRJNA432257_S_NODE_110324_length_166_cov_1.596899_g109943_i0	PRJNA432257	110324	166	1.596899	2.65085234	Candidatus Methanomethylophilaceae archaeon	2517205	Archaea	Archaea	45.8	9.93e-4	NR	HKM09496.1	2517205	g109943	i0	86.4	0.397590361445783	22	3	39.8	0	143	78	251	272	HKM09496.1 EFR1 family ferrodoxin [Candidatus Methanomethylophilaceae archaeon]	diamond	66	45.8	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomethylophilaceae		Candidatus Methanomethylophilaceae archaeon
28402225	28402225	PRJNA432257_S_NODE_120006_length_157_cov_0.975000_g119625_i0	PRJNA432257	120006	157	0.975	1.53075	Thermoplasmata archaeon	1906666	Archaea	Archaea	40	0.0241	NR	MEM4730109.1	1906666	g119625	i0	41.5	0.78343949044586	41	24	78.3	0	124	2	23	63	MEM4730109.1 hypothetical protein [Thermoplasmata archaeon]	diamond	123	40	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
30170434	30170434	PRJNA432257_S_NODE_115752_length_160_cov_5.691057_g115371_i0	PRJNA432257	115752	160	5.691057	9.1056912	Thermoplasmata archaeon	1906666	Archaea	Archaea	71.2	3.45e-13	NR	MEM3335618.1	1906666	g115371	i0	56.9	0.95625	51	22	95.6	0	156	4	160	210	MEM3335618.1 nuclease-related domain-containing protein [Thermoplasmata archaeon]	diamond	153	71.2	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
32731090	32731090	PRJNA432257_S_NODE_9980_length_409_cov_3.096774_g9626_i0	PRJNA432257	9980	409	3.096774	12.66580566	Candidatus Sysuiplasma superficiale	2823368	Archaea	Archaea	45.8	0.0144	NR	MBX8644802.1	2823368	g9626	i0	36.8	0.696821515892421	95	42	63.8	4	148	408	172	256	MBX8644802.1 hypothetical protein [Candidatus Sysuiplasma superficiale]	diamond	285	45.8	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Candidatus Sysuiplasmatales	Candidatus Sysuiplasmataceae	Candidatus Sysuiplasma	Candidatus Sysuiplasma superficiale

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