metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA492280" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA492280" 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
3002689	3002689	PRJNA492280_P_NODE_24623_length_164_cov_2.637795_g24516_i0	PRJNA492280	24623	164	2.637795	4.3259838	Ignisphaera sp.	2268142	Archaea	Archaea	55.5	4.08e-7	NR	MCI4437658.1	2268142	g24516	i0	100	0.439024390243902	24	0	43.9	0	162	91	212	235	MCI4437658.1 hypothetical protein [Ignisphaera sp.]	diamond	72	55.5	1	Archaea		Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales	Desulfurococcaceae	Ignisphaera	Ignisphaera sp.
26791660	26791660	PRJNA492280_P_NODE_22501_length_164_cov_2.929134_g22394_i0	PRJNA492280	22501	164	2.929134	4.80377976	Natronomonas sp.	2184060	Archaea	Archaea	51.2	1.19e-5	NR	MFT4946158.1	2184060	g22394	i0	87.5	0.439024390243902	24	3	43.9	0	5	76	129	152	MFT4946158.1 putative membrane protein [Natronomonas sp.]	diamond	72	51.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas sp.
27013069	27013069	PRJNA492280_P_NODE_15882_length_164_cov_4.275591_g15775_i0	PRJNA492280	15882	164	4.275591	7.01196924	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	43.9	0.00502	NR	MBT7787159.1	2026803	g15775	i0	46.2	0.713414634146341	39	21	71.3	0	7	123	6	44	MBT7787159.1 PDZ domain-containing protein [Candidatus Woesearchaeota archaeon]	diamond	117	43.9	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
28844699	28844699	PRJNA492280_P_NODE_31428_length_151_cov_3.140351_g31321_i0	PRJNA492280	31428	151	3.140351	4.74193001	Haloarcula amylovorans	2562280	Archaea	Archaea	59.7	1.91e-9	NR	WP_135306088.1	2562280	g31321	i0	92.9	0.556291390728477	28	2	55.6	0	87	4	84	111	WP_135306088.1 DUF6141 family protein [Haloarcula amylovorans]	diamond	84	59.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Haloarcula	Haloarcula amylovorans
30644927	30644927	PRJNA492280_P_NODE_33453_length_150_cov_3.973451_g33346_i0	PRJNA492280	33453	150	3.973451	5.9601765	archaeon	1906665	Archaea	Archaea	72	1.13e-13	NR	RYH29009.1	1906665	g33346	i0	70.4	1.08	54	7	90	1	6	140	101	154	RYH29009.1 MAG: hypothetical protein EON65_10100 [archaeon]	diamond	162	72	1	Archaea								archaeon
30961172	30961172	PRJNA492280_P_NODE_21214_length_164_cov_3.125984_g21107_i0	PRJNA492280	21214	164	3.125984	5.12661376	archaeon	1906665	Archaea	Archaea	41.6	0.0333	NR	RYH22982.1	1906665	g21107	i0	72.7	0.402439024390244	22	6	40.2	0	156	91	628	649	RYH22982.1 MAG: DUF4395 family protein [archaeon]	diamond	66	41.6	1	Archaea								archaeon
31024309	31024309	PRJNA492280_P_NODE_21355_length_164_cov_3.094488_g21248_i0	PRJNA492280	21355	164	3.094488	5.07496032	Nitrosopumilus sp.	2024843	Archaea	Archaea	43.1	0.00926	NR	MDA7495390.1	2024843	g21248	i0	44.2	0.951219512195122	52	26	89.6	2	8	154	241	292	MDA7495390.1 hypothetical protein [Nitrosopumilus sp.]	diamond	156	43.1	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
31751426	31751426	PRJNA492280_P_NODE_14437_length_164_cov_4.818898_g14330_i0	PRJNA492280	14437	164	4.818898	7.90299272	Haloarcula nitratireducens	2487749	Archaea	Archaea	52.8	7.28e-7	NR	WP_220581994.1	2487749	g14330	i0	82.4	0.621951219512195	34	1	62.2	1	164	63	21	49	WP_220581994.1 hypothetical protein [Haloarcula nitratireducens]	diamond	102	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Haloarcula	Haloarcula nitratireducens
32384303	32384303	PRJNA492280_P_NODE_31739_length_151_cov_2.815789_g31632_i0	PRJNA492280	31739	151	2.815789	4.25184139	Candidatus Micrarchaeia archaeon	3018267	Archaea	Archaea	58.5	1.11e-8	NR	MFA6531196.1	3018267	g31632	i0	54.2	1.17218543046358	59	14	91.4	1	144	7	56	114	MFA6531196.1 RNA ligase partner protein [Candidatus Micrarchaeia archaeon]	diamond	177	58.5	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia				Candidatus Micrarchaeia archaeon
32605597	32605597	PRJNA492280_P_NODE_20340_length_164_cov_3.283465_g20233_i0	PRJNA492280	20340	164	3.283465	5.3848826	Haloarcula nitratireducens	2487749	Archaea	Archaea	67.8	1.86e-11	NR	WP_220581842.1	2487749	g20233	i0	62.5	1.17073170731707	64	8	87.8	1	161	18	25	88	WP_220581842.1 PAS domain S-box protein [Haloarcula nitratireducens]	diamond	192	67.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Haloarcula	Haloarcula nitratireducens

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);;