metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax_phylum = "Thermoplasmatota"

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
28011489	28011489	PRJNA946307_P_NODE_13685_length_352_cov_3.115512_g12815_i0	PRJNA946307	13685	352	3.115512	10.96660224	Archaea	2157	Archaea	Archaea	45.4	0.013	NR	WP_236993901.1	1080712	g12815	i0	52.4	0.724431818181818	42	20	35.8	0	226	351	258	299	WP_236993901.1 RNA-guided endonuclease InsQ/TnpB family protein [Methanomassiliicoccus luminyensis]	diamond	255	45.4	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomassiliicoccaceae	Methanomassiliicoccus	Methanomassiliicoccus luminyensis
28541548	28541548	PRJNA946307_P_NODE_136627_length_168_cov_2.201681_g135753_i0	PRJNA946307	136627	168	2.2016810000000002	3.69882408	Candidatus Methanomethylophilaceae archaeon	2517205	Archaea	Archaea	57.4	5.78e-8	NR	MFA7161944.1	2517205	g135753	i0	47.1	0.910714285714286	51	26	89.3	1	14	163	176	226	MFA7161944.1 hypothetical protein [Candidatus Methanomethylophilaceae archaeon]	diamond	153	57.4	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomethylophilaceae		Candidatus Methanomethylophilaceae archaeon
28604591	28604591	PRJNA946307_P_NODE_95067_length_186_cov_2.708029_g94193_i0	PRJNA946307	95067	186	2.708029	5.03693394	Thermoplasmatales archaeon	2268204	Archaea	Archaea	43.1	0.0127	NR	MBP1661917.1	2268204	g94193	i0	41.2	0.82258064516129	51	29	80.6	1	2	151	58	108	MBP1661917.1 peptidase and subtilisin kexin sedolisin [Thermoplasmatales archaeon]	diamond	153	43.1	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales			Thermoplasmatales archaeon
28983579	28983579	PRJNA946307_P_NODE_108088_length_180_cov_3.366412_g107214_i0	PRJNA946307	108088	180	3.366412	6.0595416	Thermoplasmata archaeon	1906666	Archaea	Archaea	41.6	0.0408	NR	HUJ77987.1	1906666	g107214	i0	43.1	0.85	51	28	83.3	1	175	26	259	309	HUJ77987.1 type I 3-dehydroquinate dehydratase [Thermoplasmata archaeon]	diamond	153	41.6	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
29015302	29015302	PRJNA946307_P_NODE_45728_length_210_cov_4.888199_g44854_i0	PRJNA946307	45728	210	4.888199	10.2652179	Thermoplasmatota archaeon	2806419	Archaea	Archaea	55.8	5.64e-7	NR	HLE48401.1	2806419	g44854	i0	30.2	1.84285714285714	129	23	88.6	1	14	199	172	300	HLE48401.1 CocE/NonD family hydrolase [Thermoplasmatota archaeon]	diamond	387	55.8	1	Archaea	Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
30056930	30056930	PRJNA946307_P_NODE_70831_length_199_cov_3.060000_g69957_i0	PRJNA946307	70831	199	3.06	6.0894	Candidatus Methanomethylophilaceae archaeon	2517205	Archaea	Archaea	42.4	0.0278	NR	MBR6911019.1	2517205	g69957	i0	36.5	0.949748743718593	63	34	85.9	2	16	186	164	226	MBR6911019.1 glycosyltransferase family 2 protein [Candidatus Methanomethylophilaceae archaeon]	diamond	189	42.4	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomethylophilaceae		Candidatus Methanomethylophilaceae archaeon
31542456	31542456	PRJNA946307_P_NODE_151456_length_164_cov_2.495652_g150582_i0	PRJNA946307	151456	164	2.495652	4.09286928	Methanomassiliicoccus sp.	2528041	Archaea	Archaea	86.3	5.81e-19	NR	NLT37801.1	2528041	g150582	i0	87.8	0.896341463414634	49	6	89.6	0	163	17	109	157	NLT37801.1 energy-coupling factor ABC transporter permease [Methanomassiliicoccus sp.]	diamond	147	86.3	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomassiliicoccaceae	Methanomassiliicoccus	Methanomassiliicoccus sp.
32555056	32555056	PRJNA946307_P_NODE_117979_length_176_cov_1.535433_g117105_i0	PRJNA946307	117979	176	1.535433	2.70236208	Thermoplasmata archaeon	1906666	Archaea	Archaea	48.1	1.53e-4	NR	UCG69083.1	1906666	g117105	i0	38.5	0.886363636363636	52	32	88.6	0	16	171	92	143	UCG69083.1 MAG: hypothetical protein JSV09_15065 [Thermoplasmata archaeon]	diamond	156	48.1	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata 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);;