metadata: contig_metadata: 17 rows where analysis = "diamond", bioproject = "PRJNA980585" and tax

17 rows where analysis = "diamond", bioproject = "PRJNA980585" 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
1269318	1269318	PRJNA980585_P_NODE_24761_length_297_cov_1.375000_g24507_i0	PRJNA980585	24761	297	1.375	4.08375	Methanothrix sp.	90426	Archaea	Archaea	72.8	1.87e-12	NR	TFH48914.1	90426	g24507	i0	42.1	10.8686868686869	95	48	92.9	2	280	5	7	97	TFH48914.1 MAG: carboxylesterase family protein [Methanothrix sp.]	diamond	3228	72.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
9882605	9882605	PRJNA980585_P_NODE_18908_length_330_cov_1.583658_g18654_i0	PRJNA980585	18908	330	1.583658	5.2260714	Thermoplasmatota archaeon	2806419	Archaea	Archaea	149	1.4099999999999999e-40	NR	MDD5501850.1	2806419	g18654	i0	67.9	1.98181818181818	109	33	97.3	1	8	328	40	148	MDD5501850.1 phosphoglycerate kinase [Thermoplasmatota archaeon]	diamond	654	149	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
26677708	26677708	PRJNA980585_P_NODE_8081_length_461_cov_1.283505_g7827_i0	PRJNA980585	8081	461	1.283505	5.91695805	Haloarculaceae archaeon	2497615	Archaea	Archaea	46.2	0.0195	NR	MFT4922621.1	2497615	g7827	i0	43.8	1.24945770065076	48	27	31.2	0	178	35	386	433	MFT4922621.1 aldehyde dehydrogenase (NAD+) [Haloarculaceae archaeon]	diamond	576	46.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae		Haloarculaceae archaeon
26683974	26683974	PRJNA980585_P_NODE_51441_length_246_cov_0.890173_g51187_i0	PRJNA980585	51441	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	69.7	2.58e-12	NR	WP_089816310.1	767519	g51187	i0	56.5	4.52439024390244	62	27	75.6	0	60	245	115	176	WP_089816310.1 class I SAM-dependent methyltransferase [Halomicrobium zhouii]	diamond	1113	70.1	0.994293865905849	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halomicrobium	Halomicrobium zhouii
26937222	26937222	PRJNA980585_P_NODE_10262_length_419_cov_0.890173_g10008_i0	PRJNA980585	10262	419	0.890173	3.72982487	root	1	Root_unresolved	Root_unresolved	48.5	0.00209	NR	WP_297523431.1	35749	g10008	i0	34.5	6.6945107398568	87	53	60.9	2	103	357	322	406	WP_297523431.1 flippase [Thermococcus sp.]	diamond	2805	48.5	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus sp.
27089505	27089505	PRJNA980585_P_NODE_55762_length_243_cov_1.664706_g55508_i0	PRJNA980585	55762	243	1.664706	4.04523558	Marine Group III euryarchaeote CG-Epi1	1888995	Archaea	Archaea	75.9	6.67e-14	NR	OIR16537.1	1888995	g55508	i0	50	4.75308641975309	80	38	98.8	1	241	2	13	90	OIR16537.1 MAG: aspartate aminotransferase [Marine Group III euryarchaeote CG-Epi1]	diamond	1155	75.9	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Candidatus Thermoprofundales			Marine Group III euryarchaeote CG-Epi1
27184053	27184053	PRJNA980585_P_NODE_37202_length_259_cov_3.274194_g36948_i0	PRJNA980585	37202	259	3.274194	8.48016246	Candidatus Methanoperedens sp.	2032688	Archaea	Archaea	55.5	8.32e-8	NR	HWR98714.1	2032688	g36948	i0	77.4	1.1003861003861	31	7	35.9	0	257	165	52	82	HWR98714.1 hypothetical protein [Candidatus Methanoperedens sp.]	diamond	285	55.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Candidatus Methanoperedentaceae	Candidatus Methanoperedens	Candidatus Methanoperedens sp.
27948349	27948349	PRJNA980585_P_NODE_53825_length_244_cov_1.801170_g53571_i0	PRJNA980585	53825	244	1.80117	4.3948548	root	1	Root_unresolved	Root_unresolved	44.3	0.01	NR	MDP8011883.1	1906666	g53571	i0	32.3	1.64754098360656	62	42	76.2	0	243	58	36	97	MDP8011883.1 bifunctional 5,10-methylenetetrahydrofolate dehydrogenase/5,10-methenyltetrahydrofolate cyclohydrolase [Thermoplasmata archaeon]	diamond	402	44.3	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
28163289	28163289	PRJNA980585_P_NODE_10845_length_409_cov_1.827381_g10591_i0	PRJNA980585	10845	409	1.827381	7.47398829	Thermoplasmatota archaeon	2806419	Archaea	Archaea	79.3	2.03e-15	NR	HLE48058.1	2806419	g10591	i0	43.5	0.623471882640587	85	48	62.3	0	255	1	1	85	HLE48058.1 aquaporin [Thermoplasmatota archaeon]	diamond	255	79.3	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
29142261	29142261	PRJNA980585_P_NODE_50669_length_246_cov_0.890173_g50415_i0	PRJNA980585	50669	246	0.890173	2.18982558	Thermoplasmatota archaeon	2806419	Archaea	Archaea	91.7	2.01e-20	NR	MBU0496405.1	2806419	g50415	i0	53.9	0.926829268292683	76	35	92.7	0	246	19	159	234	MBU0496405.1 SOS response-associated peptidase [Thermoplasmatota archaeon]	diamond	228	91.7	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
29211446	29211446	PRJNA980585_P_NODE_45369_length_249_cov_0.875000_g45115_i0	PRJNA980585	45369	249	0.875	2.17875	root	1	Root_unresolved	Root_unresolved	48.5	3.81e-4	NR	MED5271849.1	2806419	g45115	i0	38.2	6.79518072289157	55	33	66.3	1	246	82	141	194	MED5271849.1 hypothetical protein [Thermoplasmatota archaeon]	diamond	1692	48.5	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
30468789	30468789	PRJNA980585_P_NODE_48833_length_247_cov_0.885057_g48579_i0	PRJNA980585	48833	247	0.885057	2.18609079	Halorhabdus sp. CBA11	1961697	Archaea	Archaea	65.5	3.91e-10	NR	WP_154551566.1	1380432	g48579	i0	41.9	3.49797570850202	74	43	89.9	0	234	13	100	173	WP_154551566.1 PAS domain-containing protein [Halorhabdus sp. CBA1104]	diamond	864	65.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halorhabdus	Halorhabdus sp. CBA1104
31194799	31194799	PRJNA980585_P_NODE_24215_length_300_cov_1.017621_g23961_i0	PRJNA980585	24215	300	1.017621	3.052863	Methanoregulaceae archaeon	2485498	Archaea	Archaea	57	7.02e-7	NR	HNJ81026.1	2485498	g23961	i0	41.7	0.6	60	33	60	1	75	254	603	660	HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon]	diamond	180	57	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		Methanoregulaceae archaeon
31385143	31385143	PRJNA980585_P_NODE_62056_length_227_cov_2.701299_g61802_i0	PRJNA980585	62056	227	2.701299	6.13194873	Methanosarcinales archaeon	2250255	Archaea	Archaea	61.6	3.61e-10	NR	TRZ87066.1	2250255	g61802	i0	39.7	1.77092511013216	68	41	89.9	0	24	227	3	70	TRZ87066.1 MAG: hypothetical protein D4R88_09915 [Methanosarcinales archaeon]	diamond	402	61.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
31738833	31738833	PRJNA980585_P_NODE_56757_length_243_cov_0.905882_g56503_i0	PRJNA980585	56757	243	0.905882	2.20129326	root	1	Root_unresolved	Root_unresolved	120	3.85e-30	NR	HLF06029.1	1906666	g56503	i0	65.8	2.92592592592593	79	27	97.5	0	5	241	290	368	HLF06029.1 nicotinate phosphoribosyltransferase [Thermoplasmata archaeon]	diamond	711	120	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
32144212	32144212	PRJNA980585_P_NODE_32998_length_271_cov_1.555556_g32744_i0	PRJNA980585	32998	271	1.555556	4.21555676	Methanoregula sp.	2052170	Archaea	Archaea	56.2	9.41e-7	NR	MCX6682390.1	2052170	g32744	i0	51.2	0.476014760147601	43	21	47.6	0	94	222	393	435	MCX6682390.1 hypothetical protein [Methanoregula sp.]	diamond	129	56.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp.
32618511	32618511	PRJNA980585_P_NODE_33400_length_270_cov_1.538071_g33146_i0	PRJNA980585	33400	270	1.538071	4.1527917	Methanobacteriota archaeon	2026739	Archaea	Archaea	63.5	6.93e-10	NR	MBT4920624.1	2026739	g33146	i0	37.1	0.988888888888889	89	52	98.9	1	2	268	2	86	MBT4920624.1 hypothetical protein [Methanobacteriota archaeon]	diamond	267	63.5	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);;