metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA421571" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA421571" 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
18937514	18937514	PRJNA421571_P_NODE_67175_length_313_cov_1.283333_g64626_i0	PRJNA421571	67175	313	1.283333	4.01683229	Archaea	2157	Archaea	Archaea	94.7	1.6e-20	NR	HLE55307.1	1906666	g64626	i0	53.1	3.67092651757189	96	40	92	1	2	289	63	153	HLE55307.1 calcium/proton exchanger [Thermoplasmata archaeon]	diamond	1149	95.5	0.991623036649215	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
27503174	27503174	PRJNA421571_P_NODE_100863_length_245_cov_0.895349_g98314_i0	PRJNA421571	100863	245	0.895349	2.19360505	Methanobacteriati	3366610	Archaea	Archaea	43.1	0.0233	NR	MBR17678.1	2026739	g98314	i0	50	0.979591836734694	40	20	49	0	241	122	163	202	MBR17678.1 RNA-binding protein [Methanobacteriota archaeon]	diamond	240	43.5	0.990804597701149	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
27913285	27913285	PRJNA421571_P_NODE_108365_length_206_cov_2.609023_g105816_i0	PRJNA421571	108365	206	2.609023	5.37458738	Methanobacteriati	3366610	Archaea	Archaea	42.7	0.0234	NR	MDA8610574.1	2026739	g105816	i0	55.6	0.786407766990291	27	12	39.3	0	175	95	746	772	MDA8610574.1 helicase-related protein [Methanobacteriota archaeon]	diamond	162	42.7	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
29428785	29428785	PRJNA421571_P_NODE_103269_length_243_cov_0.905882_g100720_i0	PRJNA421571	103269	243	0.905882	2.20129326	root	1	Root_unresolved	Root_unresolved	89	2.11e-18	NR	WP_138007409.1	2563889	g100720	i0	58.9	3.61728395061728	73	28	90.1	1	1	219	1989	2059	WP_138007409.1 PKD domain-containing protein [Halalkalirubrum salinum]	diamond	879	89	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halalkalirubrum	Halalkalirubrum salinum
30170325	30170325	PRJNA421571_P_NODE_95272_length_249_cov_0.875000_g92723_i0	PRJNA421571	95272	249	0.875	2.17875	Candidatus Nanohaloarchaea archaeon	2594798	Archaea	Archaea	43.1	0.0274	NR	MFB6203942.1	2594798	g92723	i0	47.5	0.481927710843373	40	21	48.2	0	90	209	66	105	MFB6203942.1 hypothetical protein [Candidatus Nanohaloarchaea archaeon]	diamond	120	43.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Candidatus Nanohaloarchaea				Candidatus Nanohaloarchaea archaeon
30707516	30707516	PRJNA421571_P_NODE_67414_length_312_cov_1.569038_g64865_i0	PRJNA421571	67414	312	1.569038	4.89539856	Methanotrichaceae archaeon	2595067	Archaea	Archaea	99.4	7.91e-22	NR	MCJ7445913.1	2595067	g64865	i0	60.3	0.653846153846154	68	27	65.4	0	308	105	71	138	MCJ7445913.1 SPFH domain-containing protein [Methanotrichaceae archaeon]	diamond	204	99.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae		Methanotrichaceae archaeon
31023518	31023518	PRJNA421571_P_NODE_105295_length_242_cov_0.911243_g102746_i0	PRJNA421571	105295	242	0.911243	2.20520806	Halostella	1843185	Archaea	Archaea	43.9	0.0134	NR	WP_121816590.1	1843185	g102746	i0	38.5	0.805785123966942	65	40	80.6	0	12	206	226	290	WP_121816590.1 MULTISPECIES: transcription initiation factor IIB [Halostella]	diamond	195	43.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronoarchaeaceae	Halostella
31055383	31055383	PRJNA421571_P_NODE_100915_length_245_cov_0.895349_g98366_i0	PRJNA421571	100915	245	0.895349	2.19360505	Methanobacteriota archaeon	2026739	Archaea	Archaea	55.5	7.74e-8	NR	RZD50660.1	2026739	g98366	i0	59	0.955102040816327	78	32	95.5	0	234	1	5	82	RZD50660.1 MAG: hypothetical protein CXT67_09355 [Methanobacteriota archaeon]	diamond	234	55.5	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
32067081	32067081	PRJNA421571_P_NODE_94038_length_250_cov_0.870056_g91489_i0	PRJNA421571	94038	250	0.870056	2.17514	Candidatus Thalassarchaeaceae archaeon	2670411	Archaea	Archaea	47.8	4.85e-4	NR	MDP7328634.1	2670411	g91489	i0	65.1	1.56	43	15	51.6	0	250	122	4	46	MDP7328634.1 50S ribosomal protein L32e [Candidatus Thalassarchaeaceae archaeon]	diamond	390	47.8	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Thalassarchaeaceae		Candidatus Thalassarchaeaceae archaeon
32542028	32542028	PRJNA421571_P_NODE_73699_length_292_cov_2.456621_g71150_i0	PRJNA421571	73699	292	2.456621	7.17333332	Methanobacteriota archaeon	2026739	Archaea	Archaea	82.8	5.92e-16	NR	MBU38166.1	2026739	g71150	i0	42.3	0.996575342465753	97	51	97.6	4	8	292	1791	1884	MBU38166.1 hypothetical protein [Methanobacteriota archaeon]	diamond	291	82.8	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota 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);;