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

5 rows where bioproject = "PRJNA560932", 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
23496830	23496830	PRJNA560932_P_NODE_13999_length_468_cov_1.417722_g13644_i0	PRJNA560932	13999	468	1.417722	6.63493896	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	103	2.6e-22	NR	HUW61906.1	3045160	g13644	i0	36.8	1.04487179487179	163	89	96.2	4	14	463	248	409	HUW61906.1 C1 family peptidase [Candidatus Bathyarchaeia archaeon]	diamond	489	103	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
26681402	26681402	PRJNA560932_P_NODE_61201_length_245_cov_0.895349_g60845_i0	PRJNA560932	61201	245	0.895349	2.19360505	root	1	Root_unresolved	Root_unresolved	47	0.00114	NR	MDP2900478.1	2026714	g60845	i0	36.1	3.57551020408163	72	44	85.7	1	215	6	225	296	MDP2900478.1 TFIIB-type zinc ribbon-containing protein [Candidatus Bathyarchaeota archaeon]	diamond	876	47	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
26952340	26952340	PRJNA560932_P_NODE_61742_length_244_cov_9.000000_g61386_i0	PRJNA560932	61742	244	9	21.96	Candidatus Bathyarchaeota archaeon B26-1	1779370	Archaea	Archaea	68.6	2.3e-13	NR	KYH39817.1	1779370	g61386	i0	56.6	1.20491803278689	53	23	65.2	0	230	72	1	53	KYH39817.1 MAG: 30S ribosomal protein S14 [Candidatus Bathyarchaeota archaeon B26-1]	diamond	294	68.6	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon B26-1
28153120	28153120	PRJNA560932_P_NODE_65285_length_242_cov_0.911243_g64929_i0	PRJNA560932	65285	242	0.911243	2.20520806	Candidatus Bathycorpusculum soli	3139629	Archaea	Archaea	42.7	0.0369	NR	MDR2203897.1	3139629	g64929	i0	32.9	0.90495867768595	73	45	88	2	5	217	247	317	MDR2203897.1 GTP-binding protein [Candidatus Bathycorpusculum soli]	diamond	219	42.7	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia	Candidatus Bathyarchaeales	Candidatus Bathycorpusculaceae	Candidatus Bathycorpusculum	Candidatus Bathycorpusculum soli
30710869	30710869	PRJNA560932_P_NODE_1554_length_1240_cov_3.139674_g1386_i0	PRJNA560932	1554	1240	3.139674	38.9319576	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	53.1	0.0013	NR	MCD6242836.1	2026714	g1386	i0	37.5	0.704032258064516	72	45	17.4	0	729	514	2	73	MCD6242836.1 glycosyltransferase family 2 protein [Candidatus Bathyarchaeota archaeon]	diamond	873	53.1	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);;