metadata: contig_metadata: 5 rows where bioproject = "PRJNA1122875", tax_kingdom = "Methanobacteriati" and tax

5 rows where bioproject = "PRJNA1122875", tax_kingdom = "Methanobacteriati" and tax_phylum = "Thermoplasmatota"

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
6655277	6655277	PRJNA1122875_P_NODE_13766_length_449_cov_1.840426_g13542_i0	PRJNA1122875	13766	449	1.840426	8.26351274	root	1	Root_unresolved	Root_unresolved	159	4.5599999999999987e-42	NR	WP_400233200.1	1291540	g13542	i0	78.4	17.9665924276169	102	22	68.2	0	1	306	611	712	WP_400233200.1 V-type H(+)-translocating pyrophosphatase, partial [Methanomethylophilus alvi]	diamond	8067	160	0.99375	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomethylophilaceae	Methanomethylophilus	Methanomethylophilus alvi
28238480	28238480	PRJNA1122875_P_NODE_19506_length_378_cov_0.996721_g19282_i0	PRJNA1122875	19506	378	0.996721	3.76760538	Thermoplasmatota archaeon	2806419	Archaea	Archaea	66.6	4.94e-11	NR	MFA5861769.1	2806419	g19282	i0	41.5	2.96825396825397	94	54	73.8	1	347	69	23	116	MFA5861769.1 aquaporin [Thermoplasmatota archaeon]	diamond	1122	66.6	1	Archaea	Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
28827683	28827683	PRJNA1122875_P_NODE_26568_length_321_cov_1.016129_g26344_i0	PRJNA1122875	26568	321	1.016129	3.26177409	Archaea	2157	Archaea	Archaea	57.4	6.36e-7	NR	MEA3144032.1	1906666	g26344	i0	37	2.73831775700935	100	51	84.1	3	6	275	315	412	MEA3144032.1 hypothetical protein [Thermoplasmata archaeon]	diamond	879	57.4	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
32346716	32346716	PRJNA1122875_P_NODE_8299_length_568_cov_1.149495_g8081_i0	PRJNA1122875	8299	568	1.149495	6.5291316	Thermoplasmata archaeon	1906666	Archaea	Archaea	58.5	1.36e-6	NR	MEM0129446.1	1906666	g8081	i0	33.1	1.24647887323944	118	54	58.1	4	403	74	119	219	MEM0129446.1 HNH endonuclease [Thermoplasmata archaeon]	diamond	708	58.5	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
32725349	32725349	PRJNA1122875_P_NODE_18560_length_387_cov_2.009554_g18336_i0	PRJNA1122875	18560	387	2.009554	7.77697398	Thermoplasmatota archaeon	2806419	Archaea	Archaea	78.2	9.48e-15	NR	HWG91149.1	2806419	g18336	i0	28.1	0.992248062015504	128	92	99.2	0	385	2	39	166	HWG91149.1 hypothetical protein [Thermoplasmatota archaeon]	diamond	384	78.2	1	Archaea	Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon

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