metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1020854" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1020854" and tax_kingdom = "Methanobacteriati"

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
15464022	15464022	PRJNA1020854_S_NODE_5613_length_804_cov_402.772903_g3255_i0	PRJNA1020854	5613	804	402.772903	3238.29414012	Methanobrevibacter sp.	66852	Archaea	Archaea	463	1.0599999999999998e-162	NR	MEE3444449.1	66852	g3255	i0	97.2	1.88059701492537	252	7	94	0	3	758	46	297	MEE3444449.1 HAD-IC family P-type ATPase [Methanobrevibacter sp.]	diamond	1512	463	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
28171889	28171889	PRJNA1020854_S_NODE_33186_length_177_cov_2.554054_g30422_i0	PRJNA1020854	33186	177	2.554054	4.52067558	Thermoplasmata archaeon	1906666	Archaea	Archaea	42.4	0.0148	NR	HEY4704964.1	1906666	g30422	i0	55.2	0.491525423728814	29	13	49.2	0	50	136	128	156	HEY4704964.1 DUF3795 domain-containing protein [Thermoplasmata archaeon]	diamond	87	42.4	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
30603511	30603511	PRJNA1020854_S_NODE_6533_length_653_cov_4.607372_g4009_i0	PRJNA1020854	6533	653	4.607372	30.08613916	Methanosphaera sp. rholeuAM27	2666342	Archaea	Archaea	93.6	3.02e-18	NR	RAP51160.1	1945577	g4009	i0	37.1	0.767228177641654	167	97	73.5	3	634	155	257	422	RAP51160.1 MAG: hypothetical protein BZ138_05820 [Methanosphaera sp. rholeuAM270]	diamond	501	93.6	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp. rholeuAM270
30666781	30666781	PRJNA1020854_S_NODE_16313_length_285_cov_3.613281_g13549_i0	PRJNA1020854	16313	285	3.613281	10.29785085	Methanothrix sp.	90426	Archaea	Archaea	92.4	2.06e-20	NR	MDH7597985.1	90426	g13549	i0	50.5	0.978947368421053	93	46	97.9	0	281	3	1	93	MDH7597985.1 serine protease [Methanothrix sp.]	diamond	279	92.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
31646568	31646568	PRJNA1020854_S_NODE_8117_length_504_cov_3.993684_g5457_i0	PRJNA1020854	8117	504	3.993684	20.12816736	Archaeoglobaceae archaeon	2511821	Archaea	Archaea	93.2	9.69e-19	NR	MEM1673093.1	2511821	g5457	i0	48.5	1.29761904761905	103	47	58.3	2	79	372	1	102	MEM1673093.1 hypothetical protein [Archaeoglobaceae archaeon]	diamond	654	93.2	1	Archaea		Methanobacteriati	Methanobacteriota	Archaeoglobi	Archaeoglobales	Archaeoglobaceae		Archaeoglobaceae 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);;