metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA493828" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA493828" and tax_superkingdom = "Archaea"

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
26792143	26792143	PRJNA493828_P_NODE_39921_length_241_cov_0.916667_g39502_i0	PRJNA493828	39921	241	0.916667	2.20916747	archaeon	1906665	Archaea	Archaea	94.7	1.8e-20	NR	RYG70388.1	1906665	g39502	i0	49.4	0.983402489626556	79	40	98.3	0	3	239	833	911	RYG70388.1 MAG: hypothetical protein EON64_00275 [archaeon]	diamond	237	94.7	1	Archaea								archaeon
27740602	27740602	PRJNA493828_P_NODE_38124_length_243_cov_0.905882_g37705_i0	PRJNA493828	38124	243	0.905882	2.20129326	Candidatus Asgardarchaeum californiense	3067292	Archaea	Archaea	42.7	0.0346	NR	RLI64177.1	3067292	g37705	i0	32.5	0.950617283950617	77	42	87.7	2	241	29	35	107	RLI64177.1 MAG: RimK family alpha-L-glutamate ligase [Candidatus Asgardarchaeum californiense]	diamond	231	42.7	1	Archaea		Promethearchaeati		Candidatus Asgardarchaeia (ex Tamarit et al. 2024)	Candidatus Asgardarchaeales (ex Tamarit et al. 2024)	Candidatus Asgardarchaeaceae	Candidatus Asgardarchaeum (ex Tamarit et al. 2024)	Candidatus Asgardarchaeum californiense
28513667	28513667	PRJNA493828_P_NODE_18127_length_296_cov_0.995516_g17708_i0	PRJNA493828	18127	296	0.995516	2.94672736	Methanobacteriati	3366610	Archaea	Archaea	43.5	0.0366	NR	MAI09409.1	2026739	g17708	i0	40	0.810810810810811	40	24	40.5	0	292	173	81	120	MAI09409.1 hypothetical protein [Methanobacteriota archaeon]	diamond	240	43.5	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
28687784	28687784	PRJNA493828_P_NODE_42767_length_230_cov_4.407643_g42348_i0	PRJNA493828	42767	230	4.407643	10.1375789	Nitrososphaerota archaeon	2026795	Archaea	Archaea	50.4	5.48e-5	NR	RZD32614.1	2026795	g42348	i0	45.1	0.665217391304348	51	25	66.5	1	228	76	82	129	RZD32614.1 MAG: hypothetical protein CXT79_05995 [Nitrososphaerota archaeon]	diamond	153	50.4	1	Archaea		Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
28813508	28813508	PRJNA493828_P_NODE_30228_length_255_cov_3.060440_g29809_i0	PRJNA493828	30228	255	3.06044	7.804122	Nitrososphaeria archaeon	2268198	Archaea	Archaea	55.1	5.35e-8	NR	MEM3385410.1	2268198	g29809	i0	46.8	2.68235294117647	47	25	55.3	0	251	111	5	51	MEM3385410.1 DUF2283 domain-containing protein [Nitrososphaeria archaeon]	diamond	684	55.1	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria				Nitrososphaeria archaeon
28940276	28940276	PRJNA493828_P_NODE_24228_length_273_cov_1.965000_g23809_i0	PRJNA493828	24228	273	1.965	5.36445	archaeon	1906665	Archaea	Archaea	74.7	2.61e-14	NR	MDP2437280.1	1906665	g23809	i0	44.2	0.846153846153846	77	40	81.3	1	23	244	96	172	MDP2437280.1 hypothetical protein [archaeon]	diamond	231	74.7	1	Archaea								archaeon
29287282	29287282	PRJNA493828_P_NODE_25749_length_268_cov_2.220513_g25330_i0	PRJNA493828	25749	268	2.220513	5.95097484	Candidatus Thorarchaeota archaeon	2053491	Archaea	Archaea	176	4.35e-50	NR	MBN2228639.1	2053491	g25330	i0	95.5	0.996268656716418	89	4	99.6	0	268	2	164	252	MBN2228639.1 DDE-type integrase/transposase/recombinase [Candidatus Thorarchaeota archaeon]	diamond	267	176	1	Archaea		Promethearchaeati	Candidatus Thorarchaeota					Candidatus Thorarchaeota archaeon
29445062	29445062	PRJNA493828_P_NODE_40470_length_239_cov_2.319277_g40051_i0	PRJNA493828	40470	239	2.319277	5.54307203	Promethearchaeia archaeon	3067280	Archaea	Archaea	160	1.0699999999999999e-43	NR	MFO7795213.1	3067280	g40051	i0	98.7	0.99163179916318	79	1	99.2	0	3	239	703	781	MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon]	diamond	237	160	1	Archaea		Promethearchaeati	Promethearchaeota	Promethearchaeia				Promethearchaeia archaeon
30393294	30393294	PRJNA493828_P_NODE_25793_length_268_cov_1.897436_g25374_i0	PRJNA493828	25793	268	1.897436	5.08512848	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	127	5.65e-32	NR	HKI07328.1	2169593	g25374	i0	65.6	1.00746268656716	90	30	99.6	1	268	2	81	170	HKI07328.1 HYR domain-containing protein [Nitrososphaeraceae archaeon]	diamond	270	127	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
30645393	30645393	PRJNA493828_P_NODE_20733_length_285_cov_1.283019_g20314_i0	PRJNA493828	20733	285	1.283019	3.65660415	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	103	7.3099999999999995e-25	NR	WP_148685841.1	1826872	g20314	i0	61.7	0.989473684210526	94	34	98.9	1	3	284	64	155	WP_148685841.1 hypothetical protein [Candidatus Nitrosocosmicus hydrocola]	diamond	282	103	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
31277504	31277504	PRJNA493828_P_NODE_40995_length_237_cov_2.640244_g40576_i0	PRJNA493828	40995	237	2.640244	6.25737828	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	150	2.8299999999999998e-43	NR	HEX7257879.1	2169593	g40576	i0	89.9	1	79	8	100	0	1	237	64	142	HEX7257879.1 LamG domain-containing protein [Nitrososphaeraceae archaeon]	diamond	237	150	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
32432191	32432191	PRJNA493828_P_NODE_36879_length_244_cov_3.122807_g36460_i0	PRJNA493828	36879	244	3.122807	7.61964908	Candidatus Methanofastidiosum	2666130	Archaea	Archaea	154	4.8899999999999986e-43	NR	NMC77251.1	2099674	g36460	i0	97.5	1.9672131147541	80	2	98.4	0	3	242	174	253	NMC77251.1 aspartate--tRNA(Asn) ligase [Candidatus Methanofastidiosia archaeon]	diamond	480	154	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Candidatus Methanofastidiosia				Candidatus Methanofastidiosia 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);;