metadata: contig_metadata: 7 rows where bioproject = "PRJNA784979" and tax

7 rows where bioproject = "PRJNA784979" 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
5041648	5041648	PRJNA784979_S_NODE_10604_length_166_cov_1.641026_g10562_i0	PRJNA784979	10604	166	1.641026	2.72410316	Methanosarcina	2207	Archaea	Archaea	278	2.11e-70	NTclustered	gi\|805329805\|gb\|CP009501.1\|	523844	g10562	i0	99.346	145.614457831325	153	1	97	0	9	161	1523034	1522882	Methanosarcina thermophila TM-1, complete genome	blastn	24172	278	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina thermophila
27780355	27780355	PRJNA784979_S_NODE_9504_length_171_cov_1.360656_g9462_i0	PRJNA784979	9504	171	1.360656	2.32672176	Candidatus Iainarchaeum archaeon	3101447	Archaea	Archaea	82.4	1.44e-16	NR	HRT03623.1	2026736	g9462	i0	76.4	0.964912280701754	55	13	96.5	0	6	170	303	357	HRT03623.1 hypothetical protein [Candidatus Iainarchaeum archaeon]	diamond	165	82.4	1	Archaea		Nanobdellati	Candidatus Iainarchaeota				Candidatus Iainarchaeum	Candidatus Iainarchaeum archaeon
28601245	28601245	PRJNA784979_S_NODE_10187_length_167_cov_1.296610_g10145_i0	PRJNA784979	10187	167	1.29661	2.1653387	Candidatus Methanofastidiosia archaeon	2099674	Archaea	Archaea	84.3	7.73e-18	NR	NMC57893.1	2099674	g10145	i0	69.2	2.80239520958084	52	16	93.4	0	158	3	214	265	NMC57893.1 UDP-glucose/GDP-mannose dehydrogenase family protein [Candidatus Methanofastidiosia archaeon]	diamond	468	84.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Candidatus Methanofastidiosia				Candidatus Methanofastidiosia archaeon
30401676	30401676	PRJNA784979_S_NODE_7413_length_187_cov_1.072464_g7371_i0	PRJNA784979	7413	187	1.072464	2.00550768	Halococcoides cellulosivorans	1679096	Archaea	Archaea	42	0.0294	NR	WP_108383978.1	1679096	g7371	i0	44.7	0.754010695187166	47	26	75.4	0	164	24	27	73	WP_108383978.1 nucleotidyltransferase domain-containing protein [Halococcoides cellulosivorans]	diamond	141	42	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halococcoides	Halococcoides cellulosivorans
32266854	32266854	PRJNA784979_S_NODE_11918_length_164_cov_0.886957_g11876_i0	PRJNA784979	11918	164	0.886957	1.45460948	Nanobdellota archaeon	2026764	Archaea	Archaea	52.8	2.8e-7	NR	MEK6844422.1	2026764	g11876	i0	75	0.585365853658537	32	8	58.5	0	2	97	52	83	MEK6844422.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	96	52.8	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
32266855	32266855	PRJNA784979_S_NODE_12738_length_162_cov_1.106195_g12696_i0	PRJNA784979	12738	162	1.106195	1.7920359	Nitrosopumilaceae archaeon	2202732	Archaea	Archaea	63.5	5.18e-10	NR	HWY33643.1	2202732	g12696	i0	59.3	1	54	18	96.3	2	157	2	210	261	HWY33643.1 hypothetical protein [Nitrosopumilaceae archaeon]	diamond	162	63.5	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae		Nitrosopumilaceae archaeon
32330240	32330240	PRJNA784979_S_NODE_9719_length_170_cov_0.958678_g9677_i0	PRJNA784979	9719	170	0.958678	1.6297526	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	68.2	1.48e-11	NR	MFA5724505.1	2026773	g9677	i0	60.4	0.935294117647059	53	21	93.5	0	168	10	332	384	MFA5724505.1 Hint domain-containing homing endonuclease [Candidatus Pacearchaeota archaeon]	diamond	159	68.2	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota 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);;