metadata: contig_metadata: 9 rows where bioproject = "PRJNA752572" and tax

9 rows where bioproject = "PRJNA752572" 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
9657157	9657157	PRJNA752572_P_NODE_9188_length_844_cov_3.318912_g8868_i0	PRJNA752572	9188	844	3.318912	28.01161728	Methanosarcinales archaeon	2250255	Archaea	Archaea	338	9.959999999999999e-112	NR	RYE83110.1	2250255	g8868	i0	62	0.945497630331754	266	92	94.5	3	844	47	160	416	RYE83110.1 MAG: translation elongation factor EF-1 subunit alpha, partial [Methanosarcinales archaeon]	diamond	798	338	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
27663159	27663159	PRJNA752572_P_NODE_283044_length_155_cov_4.058333_g282537_i0	PRJNA752572	283044	155	4.058333	6.29041615	root	1	Root_unresolved	Root_unresolved	62.4	1.29e-9	NR	WP_013194585.1	2322	g282537	i0	63.6	4.12258064516129	44	16	85.2	0	132	1	2	45	WP_013194585.1 cryptochrome/photolyase family protein [Methanohalobium evestigatum]	diamond	639	62.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanohalobium	Methanohalobium evestigatum
28789625	28789625	PRJNA752572_P_NODE_212187_length_182_cov_1.959184_g211680_i0	PRJNA752572	212187	182	1.959184	3.56571488	Methanoregulaceae archaeon	2485498	Archaea	Archaea	47.4	3.85e-4	NR	HNJ81026.1	2485498	g211680	i0	41.5	0.873626373626374	53	29	87.4	1	159	1	603	653	HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon]	diamond	159	47.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		Methanoregulaceae archaeon
29074141	29074141	PRJNA752572_P_NODE_207988_length_184_cov_1.973154_g207481_i0	PRJNA752572	207988	184	1.973154	3.63060336	Candidatus Methanoperedens sp.	2032688	Archaea	Archaea	55.1	6.94e-7	NR	HEY9245765.1	2032688	g207481	i0	76.5	2.23369565217391	34	8	55.4	0	105	4	2	35	HEY9245765.1 serine hydroxymethyltransferase [Candidatus Methanoperedens sp.]	diamond	411	55.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Candidatus Methanoperedentaceae	Candidatus Methanoperedens	Candidatus Methanoperedens sp.
29800039	29800039	PRJNA752572_P_NODE_130391_length_235_cov_1.400000_g129884_i0	PRJNA752572	130391	235	1.4	3.29	Methanobacteriota archaeon	2026739	Archaea	Archaea	70.5	1.49e-12	NR	RMG30150.1	2026739	g129884	i0	47.8	0.85531914893617	67	32	85.5	1	231	31	160	223	RMG30150.1 MAG: aquaporin [Methanobacteriota archaeon]	diamond	201	70.5	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
29800050	29800050	PRJNA752572_P_NODE_243151_length_170_cov_3.125926_g242644_i0	PRJNA752572	243151	170	3.125926	5.3140742	Thermoplasmatales archaeon B_DKE	1961136	Archaea	Archaea	65.5	1.3099999999999999e-10	NR	OWP57015.1	1961136	g242644	i0	48.2	0.988235294117647	56	29	98.8	0	3	170	343	398	OWP57015.1 MAG: hypothetical protein B2I17_02260 [Thermoplasmatales archaeon B_DKE]	diamond	168	65.5	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales			Thermoplasmatales archaeon B_DKE
30052724	30052724	PRJNA752572_P_NODE_194451_length_191_cov_1.467949_g193944_i0	PRJNA752572	194451	191	1.467949	2.80378259	Thermoplasmatales archaeon	2268204	Archaea	Archaea	43.1	0.0126	NR	HEC76766.1	2268204	g193944	i0	48.1	0.848167539267016	27	14	42.4	0	144	64	35	61	HEC76766.1 alanyl-tRNA editing protein [Thermoplasmatales archaeon]	diamond	162	43.1	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales			Thermoplasmatales archaeon
30115947	30115947	PRJNA752572_P_NODE_262192_length_165_cov_2.569231_g261685_i0	PRJNA752572	262192	165	2.569231	4.23923115	Methanomassiliicoccales archaeon	1906667	Archaea	Archaea	59.7	8.93e-9	NR	MCG7843943.1	1906667	g261685	i0	44.4	1.96363636363636	54	29	98.2	1	163	2	191	243	MCG7843943.1 hypothetical protein [Methanomassiliicoccales archaeon]	diamond	324	59.7	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales			Methanomassiliicoccales archaeon
31737724	31737724	PRJNA752572_P_NODE_224297_length_177_cov_1.373239_g223790_i0	PRJNA752572	224297	177	1.373239	2.43063303	Methanomethylophilus	1291539	Archaea	Archaea	62.8	2.24e-11	NR	MCK5291341.1	1906666	g223790	i0	62.5	8.30508474576271	40	15	67.8	0	177	58	21	60	MCK5291341.1 30S ribosomal protein S27ae [Thermoplasmata archaeon]	diamond	1470	63.2	0.993670886075949	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);;