metadata: contig_metadata: 13 rows where bioproject = "PRJNA939369", tax_kingdom = "Methanobacteriati" and tax

13 rows where bioproject = "PRJNA939369", tax_kingdom = "Methanobacteriati" 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
7292626	7292626	PRJNA939369_S_NODE_5906_length_511_cov_1.000000_g5489_i0	PRJNA939369	5906	511	1	5.11	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	299	2.7e-96	NR	MEK9699487.1	2163009	g5489	i0	87.7	1.00391389432485	171	20	99.8	1	510	1	325	495	MEK9699487.1 hypothetical protein [Candidatus Poseidoniales archaeon]	diamond	513	299	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
8908871	8908871	PRJNA939369_S_NODE_18847_length_344_cov_1.335793_g18430_i0	PRJNA939369	18847	344	1.335793	4.59512792	Candidatus Methanomethylophilaceae archaeon	2517205	Archaea	Archaea	172	2.3999999999999997e-48	NR	MBR6911394.1	2517205	g18430	i0	67.5	0.994186046511628	114	37	99.4	0	343	2	293	406	MBR6911394.1 hypothetical protein [Candidatus Methanomethylophilaceae archaeon]	diamond	342	172	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomethylophilaceae		Candidatus Methanomethylophilaceae archaeon
27150976	27150976	PRJNA939369_S_NODE_10562_length_416_cov_1.953353_g10145_i0	PRJNA939369	10562	416	1.953353	8.12594848	Thermoplasmatota archaeon	2806419	Archaea	Archaea	45.4	0.0282	NR	HEX2021115.1	2806419	g10145	i0	38.1	0.605769230769231	84	45	58.4	2	252	10	942	1021	HEX2021115.1 hypothetical protein [Thermoplasmatota archaeon]	diamond	252	45.4	1	Archaea	Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
27561900	27561900	PRJNA939369_S_NODE_34164_length_290_cov_0.866359_g33747_i0	PRJNA939369	34164	290	0.866359	2.5124411	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	171	6.669999999999998e-47	NR	MEK9697217.1	2163009	g33747	i0	87.4	0.982758620689655	95	12	98.3	0	289	5	519	613	MEK9697217.1 hypothetical protein [Candidatus Poseidoniales archaeon]	diamond	285	171	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
27625436	27625436	PRJNA939369_S_NODE_46144_length_265_cov_0.822917_g45727_i0	PRJNA939369	46144	265	0.822917	2.18073005	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	63.5	2.36e-9	NR	MEK9697467.1	2163009	g45727	i0	50.6	1.00754716981132	89	42	99.6	2	265	2	277	364	MEK9697467.1 hypothetical protein [Candidatus Poseidoniales archaeon]	diamond	267	63.5	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
28351459	28351459	PRJNA939369_S_NODE_73286_length_242_cov_1.183432_g72869_i0	PRJNA939369	73286	242	1.183432	2.86390544	Methanomethylophilus sp.	2774294	Archaea	Archaea	51.2	1.64e-6	NR	MBO5600175.1	2774294	g72869	i0	56.3	0.396694214876033	32	14	39.7	0	97	2	4	35	MBO5600175.1 hypothetical protein [Methanomethylophilus sp.]	diamond	96	51.2	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomethylophilaceae	Methanomethylophilus	Methanomethylophilus sp.
28509376	28509376	PRJNA939369_S_NODE_13447_length_384_cov_1.733119_g13030_i0	PRJNA939369	13447	384	1.733119	6.65517696	Candidatus Methanomethylophilaceae archaeon	2517205	Archaea	Archaea	62	2.83e-9	NR	MBQ7620813.1	2517205	g13030	i0	44.9	0.609375	78	33	54.7	3	213	4	1	76	MBQ7620813.1 hypothetical protein [Candidatus Methanomethylophilaceae archaeon]	diamond	234	62	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomethylophilaceae		Candidatus Methanomethylophilaceae archaeon
28572459	28572459	PRJNA939369_S_NODE_54527_length_251_cov_1.168539_g54110_i0	PRJNA939369	54527	251	1.168539	2.93303289	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	171	1.2399999999999998e-47	NR	MEK9698119.1	2163009	g54110	i0	97.6	0.99203187250996006	83	2	99.2	0	250	2	445	527	MEK9698119.1 hypothetical protein [Candidatus Poseidoniales archaeon]	diamond	249	171	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
30088141	30088141	PRJNA939369_S_NODE_65592_length_246_cov_0.890173_g65175_i0	PRJNA939369	65592	246	0.890173	2.18982558	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	135	6.55e-35	NR	MEK9698119.1	2163009	g65175	i0	87.7	0.98780487804878	81	10	98.8	0	245	3	550	630	MEK9698119.1 hypothetical protein [Candidatus Poseidoniales archaeon]	diamond	243	135	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
30878059	30878059	PRJNA939369_S_NODE_37774_length_281_cov_1.504808_g37357_i0	PRJNA939369	37774	281	1.504808	4.22851048	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	117	1.71e-28	NR	MEK9699487.1	2163009	g37357	i0	66.7	0.99288256227758	93	25	99.3	1	280	2	482	568	MEK9699487.1 hypothetical protein [Candidatus Poseidoniales archaeon]	diamond	279	117	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
31004497	31004497	PRJNA939369_S_NODE_11694_length_403_cov_0.903030_g11277_i0	PRJNA939369	11694	403	0.90303	3.6392109	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	124	8.65e-30	NR	MEK9697467.1	2163009	g11277	i0	54.9	0.990074441687345	133	49	97.5	3	399	7	254	377	MEK9697467.1 hypothetical protein [Candidatus Poseidoniales archaeon]	diamond	399	124	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
31130575	31130575	PRJNA939369_S_NODE_64575_length_246_cov_1.375723_g64158_i0	PRJNA939369	64575	246	1.375723	3.38427858	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	70.5	6.52e-12	NR	MEK9697467.1	2163009	g64158	i0	53	0.804878048780488	66	30	79.3	1	51	245	636	701	MEK9697467.1 hypothetical protein [Candidatus Poseidoniales archaeon]	diamond	198	70.5	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
31415443	31415443	PRJNA939369_S_NODE_49536_length_259_cov_0.865591_g49119_i0	PRJNA939369	49536	259	0.865591	2.24188069	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	155	1.51e-42	NR	MEK9699471.1	2163009	g49119	i0	94.2	0.996138996138996	86	4	99.6	1	2	259	479	563	MEK9699471.1 hypothetical protein [Candidatus Poseidoniales archaeon]	diamond	258	155	1	Archaea	Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales 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);;