metadata: contig_metadata: 5 rows where bioproject = "PRJNA1180292", tax_phylum = "Candidatus Bathyarchaeota" and tax

5 rows where bioproject = "PRJNA1180292", tax_phylum = "Candidatus Bathyarchaeota" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1592491	1592491	PRJNA1180292_P_NODE_11542_length_245_cov_0.906977_g11410_i0	PRJNA1180292	11542	245	0.906977	2.22209365	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	148	2.74e-31	NTclustered	gi\|2874253764\|emb\|OY969706.1\|	2026714	g11410	i0	78.112	1.40816326530612	233	51	95	0	1	233	2605063	2604831	MAG: Candidatus Bathyarchaeota archaeon isolate MFD02416.bin.c.15 genome assembly, chromosome: 1	blastn	345	148	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
26945542	26945542	PRJNA1180292_P_NODE_10722_length_247_cov_0.896552_g10590_i0	PRJNA1180292	10722	247	0.896552	2.21448344	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	135	2.32e-39	NR	MCX6641919.1	2026714	g10590	i0	76.3	0.97165991902834	80	19	97.2	0	244	5	19	98	MCX6641919.1 phosphate ABC transporter substrate-binding protein [Candidatus Bathyarchaeota archaeon]	diamond	240	135	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
29408975	29408975	PRJNA1180292_P_NODE_8369_length_252_cov_0.871508_g8237_i0	PRJNA1180292	8369	252	0.871508	2.19620016	Candidatus Bathycorpusculum termitum	3139631	Archaea	Archaea	143	1.5e-37	NR	MDR0373734.1	3139631	g8237	i0	85.5	3.95238095238095	83	12	98.8	0	3	251	262	344	MDR0373734.1 ATP-dependent helicase [Candidatus Bathycorpusculum termitum]	diamond	996	143	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia	Candidatus Bathyarchaeales	Candidatus Bathycorpusculaceae	Candidatus Bathycorpusculum	Candidatus Bathycorpusculum termitum
31494450	31494450	PRJNA1180292_P_NODE_10796_length_247_cov_0.896552_g10664_i0	PRJNA1180292	10796	247	0.896552	2.21448344	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	146	1.77e-40	NR	MCX6642911.1	2026714	g10664	i0	93.7	0.959514170040486	79	5	96	0	246	10	68	146	MCX6642911.1 sodium/proton-translocating pyrophosphatase [Candidatus Bathyarchaeota archaeon]	diamond	237	146	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
31652268	31652268	PRJNA1180292_P_NODE_12117_length_244_cov_0.912281_g11985_i0	PRJNA1180292	12117	244	0.912281	2.22596564	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	52.8	7.75e-6	NR	MCJ7760751.1	2026714	g11985	i0	25.9	1.04508196721311	85	55	99.6	2	1	243	43	123	MCJ7760751.1 hypothetical protein [Candidatus Bathyarchaeota archaeon]	diamond	255	52.8	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota 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);;