metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJEB17675" and tax

7 rows where analysis = "diamond", bioproject = "PRJEB17675" 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
27886008	27886008	PRJEB17675_P_NODE_4525_length_458_cov_1.780142_g4228_i0	PRJEB17675	4525	458	1.780142	8.15305036	Methanobacteriota archaeon	2026739	Archaea	Archaea	162	9.059999999999999e-47	NR	RYE97637.1	2026739	g4228	i0	50.6	2.10262008733624	160	66	97.6	3	458	12	28	185	RYE97637.1 MAG: C1 family peptidase, partial [Methanobacteriota archaeon]	diamond	963	162	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
28012529	28012529	PRJEB17675_P_NODE_2985_length_570_cov_1.856075_g2718_i0	PRJEB17675	2985	570	1.856075	10.5796275	Thermoplasmata archaeon	1906666	Archaea	Archaea	283	8.57e-89	NR	RLF35995.1	1906666	g2718	i0	75.1	2.97894736842105	189	47	99.5	0	3	569	166	354	RLF35995.1 MAG: ATP citrate synthase [Thermoplasmata archaeon]	diamond	1698	283	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
28927937	28927937	PRJEB17675_P_NODE_10248_length_272_cov_1.518987_g9944_i0	PRJEB17675	10248	272	1.518987	4.13164464	Methanogenium organophilum	2199	Archaea	Archaea	44.7	0.00815	NR	WP_268186044.1	2199	g9944	i0	62.5	0.352941176470588	32	12	35.3	0	177	272	1	32	WP_268186044.1 SDR family oxidoreductase [Methanogenium organophilum]	diamond	96	44.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanogenium	Methanogenium organophilum
29527961	29527961	PRJEB17675_P_NODE_20650_length_170_cov_1.481481_g20346_i0	PRJEB17675	20650	170	1.481481	2.5185177	Methanosarcinales archaeon	2250255	Archaea	Archaea	48.1	1.72e-4	NR	MCD4840802.1	2250255	g20346	i0	43.5	1.09411764705882	62	29	98.8	2	168	1	192	253	MCD4840802.1 Cys-every-fifth RiPP peptide CefA [Methanosarcinales archaeon]	diamond	186	48.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
29559315	29559315	PRJEB17675_P_NODE_11250_length_255_cov_1.136364_g10946_i0	PRJEB17675	11250	255	1.136364	2.8977282	Haladaptatus caseinilyticus	2993314	Archaea	Archaea	51.6	3.25e-5	NR	WP_266077698.1	2993314	g10946	i0	32.4	0.870588235294118	74	49	87.1	1	4	225	145	217	WP_266077698.1 DUF4397 domain-containing protein [Haladaptatus caseinilyticus]	diamond	222	51.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Haladaptatus	Haladaptatus caseinilyticus
29773911	29773911	PRJEB17675_P_NODE_17471_length_190_cov_1.290323_g17167_i0	PRJEB17675	17471	190	1.290323	2.4516137	root	1	Root_unresolved	Root_unresolved	44.3	0.00481	NR	MAS62797.1	2026739	g17167	i0	51.4	1.12105263157895	35	17	55.3	0	153	49	104	138	MAS62797.1 hypothetical protein [Methanobacteriota archaeon]	diamond	213	44.3	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
30823038	30823038	PRJEB17675_P_NODE_12054_length_243_cov_1.538462_g11750_i0	PRJEB17675	12054	243	1.538462	3.73846266	Thermoplasmata archaeon	1906666	Archaea	Archaea	88.2	1.37e-18	NR	HUJ77646.1	1906666	g11750	i0	54.5	4.82716049382716	77	35	95.1	0	2	232	101	177	HUJ77646.1 cysteine synthase family protein [Thermoplasmata archaeon]	diamond	1173	88.2	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);;