metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA1098727" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA1098727" 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
26719091	26719091	PRJNA1098727_P_NODE_15141_length_163_cov_1.271930_g14900_i0	PRJNA1098727	15141	163	1.27193	2.0732459	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	84	1.35e-17	NR	MEK9695007.1	2163009	g14900	i0	76	0.920245398773006	50	12	92	0	156	7	38	87	MEK9695007.1 GDP-L-fucose synthase [Candidatus Poseidoniales archaeon]	diamond	150	84	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
27004260	27004260	PRJNA1098727_P_NODE_13462_length_167_cov_1.313559_g13221_i0	PRJNA1098727	13462	167	1.313559	2.19364353	Methanobacteriota archaeon	2026739	Archaea	Archaea	50.8	1.86e-5	NR	MBU89553.1	2026739	g13221	i0	55.3	0.682634730538922	38	17	68.3	0	136	23	336	373	MBU89553.1 hypothetical protein [Methanobacteriota archaeon]	diamond	114	50.8	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
27099199	27099199	PRJNA1098727_P_NODE_13542_length_167_cov_0.881356_g13301_i0	PRJNA1098727	13542	167	0.881356	1.47186452	Halolamina sediminis	1480675	Archaea	Archaea	80.5	7.85e-17	NR	WP_053948864.1	1480675	g13301	i0	67.3	1.97604790419162	55	18	98.8	0	165	1	88	142	WP_053948864.1 DUF7504 family protein [Halolamina sediminis]	diamond	330	80.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halolamina	Halolamina sediminis
27596213	27596213	PRJNA1098727_P_NODE_12804_length_169_cov_0.866667_g12563_i0	PRJNA1098727	12804	169	0.866667	1.46466723	Haloferacaceae	1644056	Archaea	Archaea	53.5	2.08e-7	NR	WP_156587972.1	2668072	g12563	i0	68.6	2.16568047337278	35	11	62.1	0	106	2	5	39	WP_156587972.1 nucleotidyltransferase family protein [Halorubrum sp. CBA1125]	diamond	366	53.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. CBA1125
28448789	28448789	PRJNA1098727_P_NODE_15906_length_162_cov_0.920354_g15665_i0	PRJNA1098727	15906	162	0.920354	1.49097348	Halobacteriales	2235	Archaea	Archaea	48.1	1.59e-4	NR	WP_197570634.1	1407499	g15665	i0	42.3	1.92592592592593	52	30	96.3	0	4	159	244	295	WP_197570634.1 histidine kinase N-terminal 7TM domain-containing protein [Halobacterium hubeiense]	diamond	312	48.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halobacterium	Halobacterium hubeiense
28457381	28457381	PRJNA1098727_P_NODE_15926_length_162_cov_0.902655_g15685_i0	PRJNA1098727	15926	162	0.902655	1.4623011	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	90.5	7.52e-22	NR	MEK9699840.1	2163009	g15685	i0	88.9	0.833333333333333	45	5	83.3	0	135	1	1	45	MEK9699840.1 hypothetical protein [Candidatus Poseidoniales archaeon]	diamond	135	90.5	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
29332680	29332680	PRJNA1098727_P_NODE_5709_length_265_cov_1.430556_g5468_i0	PRJNA1098727	5709	265	1.430556	3.7909734	root	1	Root_unresolved	Root_unresolved	72	8.75e-15	NR	MBT5286141.1	2026739	g5468	i0	85.7	1.9811320754717	35	5	39.6	0	85	189	1	35	MBT5286141.1 high light inducible protein [Methanobacteriota archaeon]	diamond	525	72	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
29467279	29467279	PRJNA1098727_P_NODE_13590_length_167_cov_0.881356_g13349_i0	PRJNA1098727	13590	167	0.881356	1.47186452	Haloplanus sp.	1961696	Archaea	Archaea	82	1.13e-18	NR	MFB6256119.1	1961696	g13349	i0	95	0.718562874251497	40	2	71.9	0	165	46	57	96	MFB6256119.1 hypothetical protein [Haloplanus sp.]	diamond	120	82	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloplanus	Haloplanus sp.
29751513	29751513	PRJNA1098727_P_NODE_12891_length_169_cov_0.866667_g12650_i0	PRJNA1098727	12891	169	0.866667	1.46466723	Halanaeroarchaeum sulfurireducens	1604004	Archaea	Archaea	53.5	2.05e-6	NR	WP_050047402.1	1604004	g12650	i0	57.1	0.869822485207101	49	19	87	1	18	164	2	48	WP_050047402.1 methyl-accepting chemotaxis protein [Halanaeroarchaeum sulfurireducens]	diamond	147	53.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halanaeroarchaeum	Halanaeroarchaeum sulfurireducens
29783299	29783299	PRJNA1098727_P_NODE_15791_length_162_cov_0.920354_g15550_i0	PRJNA1098727	15791	162	0.920354	1.49097348	Halanaeroarchaeum sp. HSR-CO	2866382	Archaea	Archaea	93.6	8.290000000000001e-21	NR	WP_259518771.1	2866382	g15550	i0	88.5	0.962962962962963	52	6	96.3	0	159	4	228	279	WP_259518771.1 ABC transporter ATP-binding protein [Halanaeroarchaeum sp. HSR-CO]	diamond	156	93.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halanaeroarchaeum	Halanaeroarchaeum sp. HSR-CO
30920921	30920921	PRJNA1098727_P_NODE_14934_length_164_cov_0.904348_g14693_i0	PRJNA1098727	14934	164	0.904348	1.48313072	Methanobacteriota archaeon	2026739	Archaea	Archaea	61.6	2.41e-9	NR	NDF37290.1	2026739	g14693	i0	55.8	0.951219512195122	52	23	95.1	0	161	6	259	310	NDF37290.1 hypothetical protein [Methanobacteriota archaeon]	diamond	156	61.6	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
31806040	31806040	PRJNA1098727_P_NODE_11617_length_177_cov_1.460938_g11376_i0	PRJNA1098727	11617	177	1.460938	2.58586026	Natronomonas sp. LN261	2750669	Archaea	Archaea	80.9	2.51e-16	NR	WP_181691746.1	2750669	g11376	i0	100	0.677966101694915	40	0	67.8	0	3	122	280	319	WP_181691746.1 transcriptional regulator [Natronomonas sp. LN261]	diamond	120	80.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas sp. LN261
31995925	31995925	PRJNA1098727_P_NODE_14858_length_164_cov_0.904348_g14617_i0	PRJNA1098727	14858	164	0.904348	1.48313072	Halobacterium salinarum	2242	Archaea	Archaea	110	3.34e-29	NR	WP_285255381.1	2242	g14617	i0	98.1	0.98780487804878	54	1	98.8	0	162	1	42	95	WP_285255381.1 hypothetical protein [Halobacterium salinarum]	diamond	162	110	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halobacterium	Halobacterium salinarum
32430233	32430233	PRJNA1098727_P_NODE_3359_length_367_cov_1.248428_g3118_i0	PRJNA1098727	3359	367	1.248428	4.58173076	root	1	Root_unresolved	Root_unresolved	206	8.29e-63	NR	MCJ7489925.1	1906666	g3118	i0	86.7	3.94822888283379	120	16	98.1	0	362	3	276	395	MCJ7489925.1 hypothetical protein [Thermoplasmata archaeon]	diamond	1449	206	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);;