metadata: contig_metadata: 12 rows where bioproject = "PRJNA798905" and tax

12 rows where bioproject = "PRJNA798905" 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
26927408	26927408	PRJNA798905_S_NODE_38402_length_244_cov_4.157895_g37953_i0	PRJNA798905	38402	244	4.157895	10.1452638	Candidatus Thorarchaeota archaeon	2053491	Archaea	Archaea	57.8	4.93e-9	NR	TFG97008.1	2053491	g37953	i0	41.9	0.762295081967213	62	36	76.2	0	48	233	1	62	TFG97008.1 MAG: hypothetical protein E4H12_09715 [Candidatus Thorarchaeota archaeon]	diamond	186	57.8	1	Archaea		Promethearchaeati	Candidatus Thorarchaeota					Candidatus Thorarchaeota archaeon
26999556	26999556	PRJNA798905_S_NODE_20642_length_328_cov_4.121569_g20193_i0	PRJNA798905	20642	328	4.121569	13.51874632	root	1	Root_unresolved	Root_unresolved	57.8	1.6e-7	NR	MFA5071309.1	2026773	g20193	i0	47.7	1.6280487804878	88	41	78.7	3	9	266	78	162	MFA5071309.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	534	58.2	0.993127147766323	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon
27496448	27496448	PRJNA798905_S_NODE_26323_length_294_cov_5.108597_g25874_i0	PRJNA798905	26323	294	5.108597	15.01927518	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	52.4	2.61e-6	NR	MDX1371233.1	2169593	g25874	i0	42	0.510204081632653	50	29	51	0	150	1	33	82	MDX1371233.1 DUF1937 family protein [Nitrososphaeraceae archaeon]	diamond	150	52.4	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
28064682	28064682	PRJNA798905_S_NODE_26045_length_296_cov_2.035874_g25596_i0	PRJNA798905	26045	296	2.035874	6.02618704	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	56.6	9.07e-7	NR	MFA5071262.1	2026773	g25596	i0	40	0.608108108108108	60	36	60.8	0	182	3	7	66	MFA5071262.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	180	56.6	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon
28137030	28137030	PRJNA798905_S_NODE_16045_length_364_cov_2.752577_g15596_i0	PRJNA798905	16045	364	2.752577	10.01938028	root	1	Root_unresolved	Root_unresolved	81.3	2.2e-15	NR	MCA9495814.1	2026764	g15596	i0	50.7	1.21153846153846	73	33	60.2	1	250	32	13	82	MCA9495814.1 FAD-dependent thymidylate synthase [Nanoarchaeota archaeon]	diamond	441	82	0.991463414634146	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
28948992	28948992	PRJNA798905_S_NODE_10148_length_434_cov_3.246537_g9699_i0	PRJNA798905	10148	434	3.246537	14.08997058	Candidatus Altiarchaeales archaeon WOR_SM1_SCG	1849261	Archaea	Archaea	69.3	1.03e-10	NR	ODS35195.1	1849261	g9699	i0	46.3	3.84331797235023	80	31	53.2	2	45	275	71	141	ODS35195.1 hypothetical protein BEH94_01935 [Candidatus Altiarchaeales archaeon WOR_SM1_SCG]	diamond	1668	69.3	1	Archaea		Nanobdellati	Candidatus Altarchaeota	Candidatus Altiarchaeia	Candidatus Altarchaeales			Candidatus Altiarchaeales archaeon WOR_SM1_SCG
30053811	30053811	PRJNA798905_S_NODE_40891_length_236_cov_3.306748_g40442_i0	PRJNA798905	40891	236	3.306748	7.80392528	Methanobrevibacter sp.	66852	Archaea	Archaea	162	1.6899999999999999e-47	NR	MBP3225391.1	66852	g40442	i0	100	0.991525423728814	78	0	99.2	0	3	236	181	258	MBP3225391.1 hypothetical protein [Methanobrevibacter sp.]	diamond	234	162	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30243665	30243665	PRJNA798905_S_NODE_29872_length_276_cov_5.325123_g29423_i0	PRJNA798905	29872	276	5.325123	14.69733948	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	76.3	1.07e-14	NR	MBI2004439.1	2026773	g29423	i0	79.6	0.532608695652174	49	10	53.3	0	194	48	20	68	MBI2004439.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	147	76.3	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon
30473898	30473898	PRJNA798905_S_NODE_23813_length_308_cov_3.063830_g23364_i0	PRJNA798905	23813	308	3.06383	9.4365964	root	1	Root_unresolved	Root_unresolved	52.8	2.45e-5	NR	MBI2655886.1	2026803	g23364	i0	58	5.8538961038961	50	18	45.8	2	180	40	463	512	MBI2655886.1 ribonucleoside reductase class II [Candidatus Woesearchaeota archaeon]	diamond	1803	53.1	0.994350282485876	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
31792155	31792155	PRJNA798905_S_NODE_43557_length_219_cov_4.150685_g43108_i0	PRJNA798905	43557	219	4.150685	9.09000015	Candidatus Thorarchaeota archaeon	2053491	Archaea	Archaea	46.2	0.00164	NR	TFG99955.1	2053491	g43108	i0	42.9	1.28767123287671	63	30	86.3	2	13	201	374	430	TFG99955.1 MAG: hypothetical protein E4H12_00765 [Candidatus Thorarchaeota archaeon]	diamond	282	46.2	1	Archaea		Promethearchaeati	Candidatus Thorarchaeota					Candidatus Thorarchaeota archaeon
31855570	31855570	PRJNA798905_S_NODE_24517_length_304_cov_4.090909_g24068_i0	PRJNA798905	24517	304	4.090909	12.43636336	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	84.7	3.96e-18	NR	MFA5071271.1	2026773	g24068	i0	36.7	2.91118421052632	98	61	96.7	1	296	3	20	116	MFA5071271.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	885	84.7	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon
32803605	32803605	PRJNA798905_S_NODE_8580_length_463_cov_32.453846_g8131_i0	PRJNA798905	8580	463	32.453846	150.26130698	Methanofastidiosum sp.	2666341	Archaea	Archaea	83.2	1.56e-15	NR	HII95174.1	2666341	g8131	i0	44.5	0.712742980561555	110	61	71.3	0	56	385	125	234	HII95174.1 hypothetical protein [Methanofastidiosum sp.]	diamond	330	83.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Candidatus Methanofastidiosia	Candidatus Methanofastidiosales	Candidatus Methanofastidiosaceae	Candidatus Methanofastidiosum	Methanofastidiosum sp.

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);;