metadata: contig_metadata: 4 rows where bioproject = "PRJNA867519", tax_kingdom = "Methanobacteriati" and tax

4 rows where bioproject = "PRJNA867519", 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
27339777	27339777	PRJNA867519_P_NODE_3103_length_586_cov_2.239766_g2952_i0	PRJNA867519	3103	586	2.239766	13.12502876	Candidatus Thalassarchaeum sp.	3134679	Archaea	Archaea	80.9	7.1e-14	NR	MCH2637131.1	3134679	g2952	i0	52.6	0.783276450511945	76	35	38.4	1	559	335	39	114	MCH2637131.1 alpha-amylase family glycosyl hydrolase [Candidatus Thalassarchaeum sp.]	diamond	459	80.9	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Thalassarchaeaceae	Candidatus Thalassarchaeum	Candidatus Thalassarchaeum sp.
28791901	28791901	PRJNA867519_P_NODE_8387_length_384_cov_1.745981_g8233_i0	PRJNA867519	8387	384	1.745981	6.70456704	Thermoplasmatota archaeon	2806419	Archaea	Archaea	84.7	3.72e-16	NR	MEW5936266.1	2806419	g8233	i0	50.6	2.0703125	89	44	69.5	0	2	268	605	693	MEW5936266.1 putative Ig domain-containing protein [Thermoplasmatota archaeon]	diamond	795	84.7	1	Archaea	Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
29612641	29612641	PRJNA867519_P_NODE_31050_length_244_cov_0.900585_g30896_i0	PRJNA867519	31050	244	0.900585	2.1974274	Candidatus Poseidoniaceae archaeon	2666346	Archaea	Archaea	53.5	1.34e-6	NR	HJL96603.1	2666346	g30896	i0	60	1.94262295081967	40	16	49.2	0	243	124	99	138	HJL96603.1 TM2 domain-containing protein [Candidatus Poseidoniaceae archaeon]	diamond	474	53.5	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniaceae		Candidatus Poseidoniaceae archaeon
31350793	31350793	PRJNA867519_P_NODE_12656_length_327_cov_1.007874_g12502_i0	PRJNA867519	12656	327	1.007874	3.29574798	Thermoplasmata archaeon	1906666	Archaea	Archaea	43.9	0.0344	NR	MCK5253513.1	1906666	g12502	i0	35.6	0.541284403669725	59	35	54.1	1	101	277	219	274	MCK5253513.1 hypothetical protein [Thermoplasmata archaeon]	diamond	177	43.9	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata 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);;