metadata: contig_metadata: 5 rows where bioproject = "PRJNA854078" and tax

5 rows where bioproject = "PRJNA854078" 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
5944819	5944819	PRJNA854078_P_NODE_10985_length_284_cov_1.786730_g10773_i0	PRJNA854078	10985	284	1.78673	5.0743132	archaeon	1906665	Archaea	Archaea	78.6	1.56e-14	NR	MCQ2818481.1	1906665	g10773	i0	56.1	6.13732394366197	66	29	69.7	0	199	2	706	771	MCQ2818481.1 cyclic nucleotide-binding serine/threonine-protein kinase [archaeon]	diamond	1743	78.6	1	Archaea								archaeon
7219798	7219798	PRJNA854078_P_NODE_1066_length_926_cov_3.042204_g899_i0	PRJNA854078	1066	926	3.042204	28.17080904	Candidatus Heimdallarchaeum aukensis	2876573	Archaea	Archaea	54.7	0.026	NTclustered	gi\|2180467162\|gb\|CP084166.1\|	2876573	g899	i0	96.875	0.0345572354211663	32	1	3	0	870	901	504622	504653	MAG: Candidatus Heimdallarchaeum aukensis isolate PM71 chromosome, complete genome	blastn	32	54.7	1	Archaea		Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeia (ex Rinke et al. 2021) (nom. nud.)	Candidatus Heimdallarchaeales	Candidatus Heimdallarchaeaceae	Candidatus Heimdallarchaeum	Candidatus Heimdallarchaeum aukensis
28255077	28255077	PRJNA854078_P_NODE_14066_length_251_cov_0.865169_g13854_i0	PRJNA854078	14066	251	0.865169	2.17157419	archaeon	1906665	Archaea	Archaea	44.7	0.00853	NR	MCQ2818660.1	1906665	g13854	i0	33.8	1.91235059760956	77	49	92	1	19	249	144	218	MCQ2818660.1 protein kinase [archaeon]	diamond	480	44.7	1	Archaea								archaeon
28452999	28452999	PRJNA854078_P_NODE_8766_length_317_cov_3.786885_g8554_i0	PRJNA854078	8766	317	3.786885	12.00442545	root	1	Root_unresolved	Root_unresolved	50.4	1.71e-4	NR	HKQ20896.1	2169593	g8554	i0	36.8	2.49842271293375	76	44	71.9	1	228	1	67	138	HKQ20896.1 reverse transcriptase family protein [Nitrososphaeraceae archaeon]	diamond	792	50.8	0.992125984251969	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
31951557	31951557	PRJNA854078_P_NODE_8197_length_329_cov_0.902344_g7985_i0	PRJNA854078	8197	329	0.902344	2.96871176	Halorubrum sp. SD626R	1419722	Archaea	Archaea	42.4	0.0244	NR	TKX76719.1	1419722	g7985	i0	34.4	0.556231003039514	61	32	55.6	1	92	274	34	86	TKX76719.1 methionine synthase, partial [Halorubrum sp. SD626R]	diamond	183	42.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. SD626R

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