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

4 rows where bioproject = "PRJNA699078", tax_kingdom = "Methanobacteriati" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
28598767	28598767	PRJNA699078_S_NODE_56167_length_227_cov_1.460674_g55218_i0	PRJNA699078	56167	227	1.460674	3.31572998	Candidatus Methanomassiliicoccus intestinalis	1406512	Archaea	Archaea	76.6	3.35e-14	NR	WP_020449127.1	1406512	g55218	i0	52.1	2.86784140969163	73	35	96.5	0	225	7	412	484	WP_020449127.1 catalase [Candidatus Methanomassiliicoccus intestinalis]	diamond	651	76.6	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomassiliicoccaceae	Methanomassiliicoccus	Candidatus Methanomassiliicoccus intestinalis
28914108	28914108	PRJNA699078_S_NODE_83208_length_184_cov_1.155556_g82259_i0	PRJNA699078	83208	184	1.155556	2.12622304	Candidatus Methanomethylophilaceae archaeon	2517205	Archaea	Archaea	46.2	7.5e-5	NR	MBR2255585.1	2517205	g82259	i0	40.8	1.38586956521739	49	28	79.9	1	11	157	5	52	MBR2255585.1 4Fe-4S dicluster domain-containing protein [Candidatus Methanomethylophilaceae archaeon]	diamond	255	46.2	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomethylophilaceae		Candidatus Methanomethylophilaceae archaeon
31124992	31124992	PRJNA699078_S_NODE_56935_length_225_cov_2.068182_g55986_i0	PRJNA699078	56935	225	2.068182	4.6534095	Halalkalicoccus	332246	Archaea	Archaea	63.2	1.13e-9	NR	WP_332101262.1	332246	g55986	i0	43.9	0.88	66	34	88	2	203	6	189	251	WP_332101262.1 MULTISPECIES: aldo/keto reductase [Halalkalicoccus]	diamond	198	63.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus
32843366	32843366	PRJNA699078_S_NODE_29760_length_316_cov_1.116105_g28811_i0	PRJNA699078	29760	316	1.116105	3.5268918	Archaea	2157	Archaea	Archaea	115	4.46e-28	NR	HML05280.1	2164	g28811	i0	53.8	2.91455696202532	104	46	97.8	2	315	7	77	179	HML05280.1 glycine--tRNA ligase [Methanobacterium sp.]	diamond	921	115	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium 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);;