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

5 rows where bioproject = "PRJNA340009", 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_species
27359359	27359359	PRJNA340009_P_NODE_53223_length_178_cov_4.953488_g52916_i0	PRJNA340009	53223	178	4.953488	8.81720864	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	59.3	2.11e-8	NR	MBN1682760.1	2026714	g52916	i0	66.7	1.31460674157303	39	13	65.7	0	48	164	205	243	MBN1682760.1 3-isopropylmalate dehydratase large subunit [Candidatus Bathyarchaeota archaeon]	diamond	234	59.3	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota		Candidatus Bathyarchaeota archaeon
27485531	27485531	PRJNA340009_P_NODE_44863_length_191_cov_5.394366_g44556_i0	PRJNA340009	44863	191	5.394366	10.30323906	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	55.8	4.16e-7	NR	TMI19911.1	2026714	g44556	i0	59.6	0.816753926701571	52	15	72.3	1	189	52	26	77	TMI19911.1 MAG: hypothetical protein E6H32_00410, partial [Candidatus Bathyarchaeota archaeon]	diamond	156	55.8	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota		Candidatus Bathyarchaeota archaeon
27517087	27517087	PRJNA340009_P_NODE_38023_length_205_cov_25.012821_g37716_i0	PRJNA340009	38023	205	25.012821	51.27628305	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	80.9	7.52e-16	NR	HYB69124.1	3045160	g37716	i0	55.6	3.68780487804878	63	24	92.2	1	195	7	105	163	HYB69124.1 Rieske 2Fe-2S domain-containing protein [Candidatus Bathyarchaeia archaeon]	diamond	756	80.9	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia	Candidatus Bathyarchaeia archaeon
27927591	27927591	PRJNA340009_P_NODE_68785_length_164_cov_0.886957_g68478_i0	PRJNA340009	68785	164	0.886957	1.45460948	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	49.3	1.08e-5	NR	HEX9239206.1	3045160	g68478	i0	67.6	0.621951219512195	34	11	62.2	0	62	163	1	34	HEX9239206.1 hypothetical protein [Candidatus Bathyarchaeia archaeon]	diamond	102	49.3	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia	Candidatus Bathyarchaeia archaeon
30832996	30832996	PRJNA340009_P_NODE_42354_length_196_cov_3.741497_g42047_i0	PRJNA340009	42354	196	3.741497	7.33333412	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	51.2	2.09e-5	NR	MBT7913863.1	2026714	g42047	i0	52.3	0.673469387755102	44	21	67.3	0	132	1	142	185	MBT7913863.1 hypothetical protein [Candidatus Bathyarchaeota archaeon]	diamond	132	51.2	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);;