metadata: contig_metadata: 18 rows where bioproject = "PRJNA662254" and tax

18 rows where bioproject = "PRJNA662254" and tax_kingdom = "Methanobacteriati"

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
2437158	2437158	PRJNA662254_P_NODE_63842_length_242_cov_0.911243_g63191_i0	PRJNA662254	63842	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	99	2.76e-16	NTclustered	gi\|2006064443\|gb\|CP071462.1\|	2816475	g63191	i0	86.022	5.49586776859504	93	11	38	2	19	110	1306577	1306486	Haloterrigena alkaliphila strain KZCA68 chromosome, complete genome	blastn	1330	99	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Haloterrigena	Haloterrigena alkaliphila
4456249	4456249	PRJNA662254_P_NODE_49424_length_249_cov_0.875000_g48773_i0	PRJNA662254	49424	249	0.875	2.17875	uncultured Methanobacteriaceae archaeon	176233	Archaea	Archaea	398	2.51e-106	NTclustered	gi\|2874253877\|emb\|OY969932.1\|	176233	g48773	i0	95.565	2.69879518072289	248	11	99	0	1	248	588165	588412	MAG: uncultured Methanobacteriaceae archaeon isolate MFD09286.bin.c.5 genome assembly, chromosome: 1	blastn	672	398	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		uncultured Methanobacteriaceae archaeon
4990241	4990241	PRJNA662254_P_NODE_53044_length_247_cov_0.885057_g52393_i0	PRJNA662254	53044	247	0.885057	2.18609079	Candidatus Lutacidiplasmatales archaeon	3345206	Archaea	Archaea	142	6.01e-41	NR	MFI5413637.1	3345206	g52393	i0	87.7	0.983805668016194	81	10	98.4	0	3	245	12	92	MFI5413637.1 UDP-glucose 6-dehydrogenase [Candidatus Lutacidiplasmatales archaeon]	diamond	243	142	1	Archaea		Methanobacteriati	Thermoplasmatota		Candidatus Lutacidiplasmatales			Candidatus Lutacidiplasmatales archaeon
14657180	14657180	PRJNA662254_P_NODE_20792_length_360_cov_1.073171_g20141_i0	PRJNA662254	20792	360	1.073171	3.8634156	uncultured Methanobacteriaceae archaeon	176233	Archaea	Archaea	555	2.1299999999999994e-153	NTclustered	gi\|2874253877\|emb\|OY969932.1\|	176233	g20141	i0	94.444	1	360	20	100	0	1	360	902531	902172	MAG: uncultured Methanobacteriaceae archaeon isolate MFD09286.bin.c.5 genome assembly, chromosome: 1	blastn	360	555	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		uncultured Methanobacteriaceae archaeon
15190509	15190509	PRJNA662254_P_NODE_53132_length_247_cov_0.885057_g52481_i0	PRJNA662254	53132	247	0.885057	2.18609079	Halorubrum	56688	Archaea	Archaea	54.7	0.006	NTclustered	gi\|1861358827\|gb\|CP054585.1\|	1853699	g52481	i0	100	0.700404858299595	29	0	12	0	141	169	1968068	1968040	Halorubrum sp. CBA1229 chromosome, complete genome	blastn	173	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. CBA1229
15931247	15931247	PRJNA662254_P_NODE_56073_length_246_cov_0.890173_g55422_i0	PRJNA662254	56073	246	0.890173	2.18982558	Methanoregula	395331	Archaea	Archaea	139	9.27e-40	NR	OPY37513.1	1811682	g55422	i0	81.5	3.95121951219512	81	15	98.8	0	245	3	92	172	OPY37513.1 MAG: Iron-sulfur flavoprotein [Methanoregula sp. PtaU1.Bin051]	diamond	972	140	0.992857142857143	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp. PtaU1.Bin051
23580997	23580997	PRJNA662254_P_NODE_49539_length_249_cov_0.875000_g48888_i0	PRJNA662254	49539	249	0.875	2.17875	Natrinema sp. 74	3384159	Archaea	Archaea	54.7	0.006	NTclustered	gi\|2869714891\|gb\|CP175698.1\|	3384159	g48888	i0	100	0.116465863453815	29	0	12	0	139	167	2650949	2650977	Natrinema sp. 74 chromosome, complete genome	blastn	29	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema sp. 74
28407946	28407946	PRJNA662254_P_NODE_65626_length_241_cov_0.916667_g64975_i0	PRJNA662254	65626	241	0.916667	2.20916747	Thermoplasmata archaeon	1906666	Archaea	Archaea	105	1.32e-25	NR	HLM70094.1	1906666	g64975	i0	58.2	3.93360995850622	79	33	98.3	0	2	238	10	88	HLM70094.1 hypothetical protein [Thermoplasmata archaeon]	diamond	948	105	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
28755203	28755203	PRJNA662254_P_NODE_57547_length_245_cov_0.895349_g56896_i0	PRJNA662254	57547	245	0.895349	2.19360505	Methanobacterium lacus	877455	Archaea	Archaea	59.7	6.63e-9	NR	WP_013644817.1	877455	g56896	i0	50.9	0.673469387755102	55	26	67.3	1	81	245	33	86	WP_013644817.1 hypothetical protein [Methanobacterium lacus]	diamond	165	59.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium lacus
29134307	29134307	PRJNA662254_P_NODE_64489_length_241_cov_0.916667_g63838_i0	PRJNA662254	64489	241	0.916667	2.20916747	Methanomassiliicoccales archaeon	1906667	Archaea	Archaea	157	2.12e-43	NR	HEY3419104.1	1906667	g63838	i0	95	0.995850622406639	80	4	99.6	0	241	2	314	393	HEY3419104.1 phenylalanine--tRNA ligase subunit beta [Methanomassiliicoccales archaeon]	diamond	240	157	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales			Methanomassiliicoccales archaeon
29682653	29682653	PRJNA662254_P_NODE_9770_length_533_cov_1.121739_g9123_i0	PRJNA662254	9770	533	1.121739	5.97886887	Geoglobus	190818	Archaea	Archaea	164	5.89e-46	NR	WP_193808075.1	565033	g9123	i0	48.1	3.61350844277674	160	83	90.1	0	485	6	72	231	WP_193808075.1 bis-aminopropyl spermidine synthase family protein [Geoglobus acetivorans]	diamond	1926	164	1	Archaea		Methanobacteriati	Methanobacteriota	Archaeoglobi	Archaeoglobales	Archaeoglobaceae	Geoglobus	Geoglobus acetivorans
29809199	29809199	PRJNA662254_P_NODE_63051_length_242_cov_0.911243_g62400_i0	PRJNA662254	63051	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	103	9.36e-24	NR	MCJ7445913.1	2595067	g62400	i0	70.9	1.95867768595041	79	23	97.9	0	240	4	197	275	MCJ7445913.1 SPFH domain-containing protein [Methanotrichaceae archaeon]	diamond	474	104	0.990384615384615	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae		Methanotrichaceae archaeon
30018401	30018401	PRJNA662254_P_NODE_53151_length_247_cov_0.885057_g52500_i0	PRJNA662254	53151	247	0.885057	2.18609079	Thermoplasmatota archaeon	2806419	Archaea	Archaea	43.1	0.0289	NR	MFO7677244.1	2806419	g52500	i0	35.8	0.643724696356275	53	34	64.4	0	240	82	85	137	MFO7677244.1 amylo-alpha-1,6-glucosidase [Thermoplasmatota archaeon]	diamond	159	43.1	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
31452616	31452616	PRJNA662254_P_NODE_65876_length_241_cov_0.910714_g65225_i0	PRJNA662254	65876	241	0.910714	2.19482074	root	1	Root_unresolved	Root_unresolved	55.5	1.18e-6	NR	WP_052721621.1	38027	g65225	i0	56.1	1.55601659751037	41	18	51	0	225	103	167	207	WP_052721621.1 Ig-like domain repeat protein [Methanosarcina siciliae]	diamond	375	55.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina siciliae
31724857	31724857	PRJNA662254_P_NODE_47517_length_250_cov_0.870056_g46866_i0	PRJNA662254	47517	250	0.870056	2.17514	uncultured Methanobacterium sp.	176306	Archaea	Archaea	78.6	1.01e-14	NR	WP_319374304.1	176306	g46866	i0	50	3.936	82	41	98.4	0	2	247	441	522	WP_319374304.1 PocR ligand-binding domain-containing protein [uncultured Methanobacterium sp.]	diamond	984	78.6	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	uncultured Methanobacterium sp.
32211807	32211807	PRJNA662254_P_NODE_9318_length_547_cov_0.915612_g8676_i0	PRJNA662254	9318	547	0.915612	5.00839764	root	1	Root_unresolved	Root_unresolved	100	8.14e-21	NR	OPX78749.1	1811685	g8676	i0	43.4	4.94698354661792	182	85	97.6	8	544	11	584	751	OPX78749.1 MAG: HYR domain protein [Methanosaeta sp. PtaB.Bin039]	diamond	2706	101	0.99009900990099	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanosaeta sp. PtaB.Bin039
32799338	32799338	PRJNA662254_P_NODE_47760_length_250_cov_0.870056_g47109_i0	PRJNA662254	47760	250	0.870056	2.17514	Methanococcoides sp. SA1	2735871	Archaea	Archaea	149	6.12e-41	NR	NPE27660.1	2735871	g47109	i0	82.9	9.828	82	14	98.4	0	3	248	254	335	NPE27660.1 AAA family ATPase [Methanococcoides sp. SA1]	diamond	2457	149	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanococcoides	Methanococcoides sp. SA1
32893844	32893844	PRJNA662254_P_NODE_35480_length_281_cov_1.110577_g34829_i0	PRJNA662254	35480	281	1.110577	3.12072137	Natrinema salifodinae	1202768	Archaea	Archaea	43.1	0.0418	NR	WP_049989907.1	1202768	g34829	i0	47.1	0.544483985765125	51	25	54.4	1	263	111	160	208	WP_049989907.1 sugar porter family MFS transporter [Natrinema salifodinae]	diamond	153	43.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema salifodinae

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