metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1180292" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1180292" and tax_kingdom = "Promethearchaeati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27597031	27597031	PRJNA1180292_P_NODE_11344_length_246_cov_0.890173_g11212_i0	PRJNA1180292	11344	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	135	5.4600000000000004e-36	NR	TFF89429.1	2053489	g11212	i0	68.3	5.92682926829268	82	26	100	0	246	1	269	350	TFF89429.1 MAG: 4Fe-4S dicluster domain-containing protein [Promethearchaeota archaeon]	diamond	1458	135	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
27861785	27861785	PRJNA1180292_P_NODE_9885_length_249_cov_0.886364_g9753_i0	PRJNA1180292	9885	249	0.886364	2.20704636	Candidatus Sigynarchaeum calidifontis	3036983	Archaea	Archaea	128	3.71e-32	NR	MEX2726779.1	3036983	g9753	i0	78	0.987951807228916	82	18	98.8	0	246	1	560	641	MEX2726779.1 penicillin acylase family protein [Candidatus Sigynarchaeum springense]	diamond	246	128	1	Archaea	Promethearchaeati	Candidatus Sigynarchaeota	Candidatus Sigynarchaeia	Candidatus Sigynarchaeales	Candidatus Sigynarchaeaceae	Candidatus Sigynarchaeum	Candidatus Sigynarchaeum calidifontis
28840605	28840605	PRJNA1180292_P_NODE_8448_length_252_cov_0.871508_g8316_i0	PRJNA1180292	8448	252	0.871508	2.19620016	Promethearchaeati archaeon	2591838	Archaea	Archaea	125	1.47e-33	NR	NPD90716.1	2591838	g8316	i0	68.7	0.988095238095238	83	26	98.8	0	250	2	133	215	NPD90716.1 hypothetical protein [Promethearchaeati archaeon]	diamond	249	125	1	Archaea	Promethearchaeati						Promethearchaeati archaeon
29680421	29680421	PRJNA1180292_P_NODE_10630_length_247_cov_0.896552_g10498_i0	PRJNA1180292	10630	247	0.896552	2.21448344	root	1	Root_unresolved	Root_unresolved	57.8	1.98e-7	NR	MCK5304267.1	2026747	g10498	i0	44.3	2.59919028340081	70	38	85	1	35	244	195	263	MCK5304267.1 alpha/beta hydrolase [Candidatus Heimdallarchaeota archaeon]	diamond	642	57.8	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota					Candidatus Heimdallarchaeota archaeon
32000423	32000423	PRJNA1180292_P_NODE_11318_length_246_cov_0.901734_g11186_i0	PRJNA1180292	11318	246	0.901734	2.21826564	Promethearchaeota archaeon	2053489	Archaea	Archaea	92	1.69e-19	NR	MBN2157606.1	2053489	g11186	i0	57.5	0.975609756097561	80	34	97.6	0	5	244	331	410	MBN2157606.1 hypothetical protein [Promethearchaeota archaeon]	diamond	240	92	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
32063628	32063628	PRJNA1180292_P_NODE_12978_length_242_cov_0.923077_g12846_i0	PRJNA1180292	12978	242	0.923077	2.23384634	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	81.3	1e-15	NR	HUT87123.1	2026747	g12846	i0	50.6	0.979338842975207	79	39	97.9	0	2	238	109	187	HUT87123.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon]	diamond	237	81.3	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota					Candidatus Heimdallarchaeota 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);;