metadata: contig_metadata: 5 rows where bioproject = "PRJNA594101", tax_phylum = "Candidatus Micrarchaeota" and tax

5 rows where bioproject = "PRJNA594101", tax_phylum = "Candidatus Micrarchaeota" 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_species
28122032	28122032	PRJNA594101_S_NODE_21265_length_364_cov_1.955326_g20963_i0	PRJNA594101	21265	364	1.955326	7.11738664	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	67.4	2.86e-10	NR	MEM3227512.1	2953041	g20963	i0	37.9	0.717032967032967	87	53	71.7	1	307	47	215	300	MEM3227512.1 molecular chaperone DnaJ [Candidatus Micrarchaeaceae archaeon]	diamond	261	67.4	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae	Candidatus Micrarchaeaceae archaeon
29100890	29100890	PRJNA594101_S_NODE_2888_length_931_cov_12.335664_g2660_i0	PRJNA594101	2888	931	12.335664	114.84503184	Candidatus Micrarchaeia archaeon	3018267	Archaea	Archaea	62	9.1e-7	NR	MEM3400025.1	3018267	g2660	i0	41.6	1.51772287862513	89	39	24.5	1	239	466	7	95	MEM3400025.1 molecular chaperone DnaJ [Candidatus Micrarchaeia archaeon]	diamond	1413	62	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia			Candidatus Micrarchaeia archaeon
29732114	29732114	PRJNA594101_S_NODE_5890_length_671_cov_2.103679_g5601_i0	PRJNA594101	5890	671	2.103679	14.11568609	Candidatus Micrarchaeota archaeon	2250274	Archaea	Archaea	101	2.34e-22	NR	MBI5223301.1	2250274	g5601	i0	42.2	0.742175856929955	166	86	73.8	4	670	176	57	213	MBI5223301.1 aquaporin [Candidatus Micrarchaeota archaeon]	diamond	498	101	1	Archaea	Nanobdellati	Candidatus Micrarchaeota				Candidatus Micrarchaeota archaeon
30364546	30364546	PRJNA594101_S_NODE_38592_length_280_cov_0.893720_g38290_i0	PRJNA594101	38592	280	0.89372	2.502416	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	116	1.71e-30	NR	MEM0150156.1	2953041	g38290	i0	59.6	2.14285714285714	94	36	98.6	1	279	4	90	183	MEM0150156.1 prolyl oligopeptidase family serine peptidase [Candidatus Micrarchaeaceae archaeon]	diamond	600	116	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae	Candidatus Micrarchaeaceae archaeon
30396136	30396136	PRJNA594101_S_NODE_26473_length_330_cov_1.182879_g26171_i0	PRJNA594101	26473	330	1.182879	3.9035007	Candidatus Micrarchaeota archaeon	2250274	Archaea	Archaea	43.9	0.0156	NR	NYZ60618.1	2250274	g26171	i0	35.7	0.509090909090909	56	34	49.1	1	150	311	70	125	NYZ60618.1 ferritin-like domain-containing protein [Candidatus Micrarchaeota archaeon]	diamond	168	43.9	1	Archaea	Nanobdellati	Candidatus Micrarchaeota				Candidatus Micrarchaeota 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);;