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

5 rows where bioproject = "PRJNA1150539", tax_kingdom = "Methanobacteriati" and tax_phylum = "Methanobacteriota"

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
7954010	7954010	PRJNA1150539_S_NODE_106587_length_233_cov_2.506250_g105991_i0	PRJNA1150539	106587	233	2.50625	5.8395625	Methanococcus maripaludis	39152	Archaea	Archaea	54.7	0.006	NTclustered	gi\|1342459100\|gb\|CP026606.1\|	39152	g105991	i0	94.286	0.150214592274678	35	2	15	0	107	141	1423590	1423556	Methanococcus maripaludis strain DSM 2067 chromosome, complete genome	blastn	35	54.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanococcaceae	Methanococcus	Methanococcus maripaludis
11779531	11779531	PRJNA1150539_S_NODE_107950_length_230_cov_2.343949_g107354_i0	PRJNA1150539	107950	230	2.343949	5.3910827	Halorussus gelatinilyticus	2937524	Archaea	Archaea	52.8	0.021	NTclustered	gi\|2234308622\|gb\|CP096658.1\|	2937524	g107354	i0	100	0.121739130434783	28	0	12	0	24	51	3593268	3593295	Halorussus gelatinilyticus strain XZYJT40 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Halorussus	Halorussus gelatinilyticus
27293163	27293163	PRJNA1150539_S_NODE_86363_length_258_cov_1.270270_g85767_i0	PRJNA1150539	86363	258	1.27027	3.2772966	Salinirubellus salinus	1364945	Archaea	Archaea	43.5	0.0236	NR	WP_260593692.1	1364945	g85767	i0	45.6	0.662790697674419	57	27	61.6	1	67	225	66	122	WP_260593692.1 poly-gamma-glutamate biosynthesis protein PgsC/CapC [Salinirubellus salinus]	diamond	171	43.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Salinirubellus	Salinirubellus salinus
27924748	27924748	PRJNA1150539_S_NODE_97805_length_245_cov_3.726744_g97209_i0	PRJNA1150539	97805	245	3.726744	9.1305228	Halobacterium sp. CBA1126	2668074	Archaea	Archaea	42	0.0327	NR	WP_157502138.1	2668074	g97209	i0	41.9	0.52653061224489806	43	24	52.7	1	165	37	77	118	WP_157502138.1 PrsW family glutamic-type intramembrane protease, partial [Halobacterium sp. CBA1126]	diamond	129	42	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halobacterium	Halobacterium sp. CBA1126
31272613	31272613	PRJNA1150539_S_NODE_93995_length_249_cov_1.818182_g93399_i0	PRJNA1150539	93995	249	1.818182	4.52727318	Theionarchaea archaeon	2747605	Archaea	Archaea	43.1	0.0245	NR	MBU7045767.1	2747605	g93399	i0	30.2	0.759036144578313	63	37	75.9	1	35	223	56	111	MBU7045767.1 hypothetical protein [Theionarchaea archaeon]	diamond	189	43.1	1	Archaea		Methanobacteriati	Methanobacteriota	Theionarchaea				Theionarchaea 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);;