metadata: contig_metadata: 20 rows where bioproject = "PRJNA285816" and tax

20 rows where bioproject = "PRJNA285816" 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
1646737	1646737	PRJNA285816_S_NODE_1742_length_500_cov_5.465632_g1640_i0	PRJNA285816	1742	500	5.465632	27.32816	Methanosarcinales archaeon	2250255	Archaea	Archaea	225	2.78e-69	NR	RYE83110.1	2250255	g1640	i0	70	0.9	150	45	90	0	8	457	267	416	RYE83110.1 MAG: translation elongation factor EF-1 subunit alpha, partial [Methanosarcinales archaeon]	diamond	450	225	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
9300040	9300040	PRJNA285816_S_NODE_1948_length_477_cov_4.633178_g1846_i0	PRJNA285816	1948	477	4.633178	22.10025906	Methanobacteriota archaeon	2026739	Archaea	Archaea	133	1.58e-35	NR	RYE97637.1	2026739	g1846	i0	60	0.72327044025157206	115	46	72.3	0	346	2	18	132	RYE97637.1 MAG: C1 family peptidase, partial [Methanobacteriota archaeon]	diamond	345	133	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
11850528	11850528	PRJNA285816_S_NODE_12370_length_214_cov_0.987879_g12268_i0	PRJNA285816	12370	214	0.987879	2.11406106	root	1	Root_unresolved	Root_unresolved	79.7	1.53e-15	NR	MFP3945957.1	2511821	g12268	i0	75	5.17289719626168	52	13	72.9	0	157	2	2	53	MFP3945957.1 molecular chaperone DnaJ [Archaeoglobaceae archaeon]	diamond	1107	79.7	1	Archaea		Methanobacteriati	Methanobacteriota	Archaeoglobi	Archaeoglobales	Archaeoglobaceae		Archaeoglobaceae archaeon
13125944	13125944	PRJNA285816_S_NODE_3531_length_360_cov_1.501608_g3429_i0	PRJNA285816	3531	360	1.501608	5.4057888	Halorussus aquaticus	2953748	Archaea	Archaea	52.8	0.034	NTclustered	gi\|2269702782\|gb\|CP100400.1\|	2953748	g3429	i0	100	0.0777777777777778	28	0	8	0	295	322	1465255	1465228	Halorussus aquaticus strain XZYJ18 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Halorussus	Halorussus aquaticus
26915935	26915935	PRJNA285816_S_NODE_5002_length_307_cov_2.186047_g4900_i0	PRJNA285816	5002	307	2.186047	6.71116429	Methanocellales archaeon	2666334	Archaea	Archaea	47.4	0.0018600000000000001	NR	MDI6889065.1	2666334	g4900	i0	43.3	0.586319218241042	60	34	58.6	0	87	266	592	651	MDI6889065.1 DNRLRE domain-containing protein [Methanocellales archaeon]	diamond	180	47.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanocellales			Methanocellales archaeon
26979195	26979195	PRJNA285816_S_NODE_9022_length_240_cov_1.465969_g8920_i0	PRJNA285816	9022	240	1.465969	3.5183256	Thermoplasmatota archaeon	2806419	Archaea	Archaea	44.7	0.0076	NR	MEK6987388.1	2806419	g8920	i0	44.2	0.65	52	29	65	0	210	55	205	256	MEK6987388.1 Ig-like domain-containing protein [Thermoplasmatota archaeon]	diamond	156	44.7	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
27706330	27706330	PRJNA285816_S_NODE_12124_length_215_cov_2.186747_g12022_i0	PRJNA285816	12124	215	2.186747	4.70150605	Thermoplasmata archaeon	1906666	Archaea	Archaea	42.7	0.0264	NR	HYS99079.1	1906666	g12022	i0	42	0.697674418604651	50	29	69.8	0	193	44	908	957	HYS99079.1 leucine--tRNA ligase [Thermoplasmata archaeon]	diamond	150	42.7	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
27769342	27769342	PRJNA285816_S_NODE_12984_length_210_cov_1.937888_g12882_i0	PRJNA285816	12984	210	1.937888	4.0695648	Methanosarcinales archaeon	2250255	Archaea	Archaea	42.7	0.0244	NR	RYE85335.1	2250255	g12882	i0	40	0.785714285714286	55	19	78.6	1	46	210	307	347	RYE85335.1 MAG: hypothetical protein EOO65_00610 [Methanosarcinales archaeon]	diamond	165	42.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
27832189	27832189	PRJNA285816_S_NODE_28664_length_163_cov_0.912281_g28562_i0	PRJNA285816	28664	163	0.912281	1.48701803	Methanosarcinales archaeon	2250255	Archaea	Archaea	43.1	0.00719	NR	RYE84401.1	2250255	g28562	i0	45.1	0.938650306748466	51	27	92	1	14	163	19	69	RYE84401.1 MAG: hypothetical protein EOO65_02325, partial [Methanosarcinales archaeon]	diamond	153	43.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
29095351	29095351	PRJNA285816_S_NODE_26048_length_166_cov_1.324786_g25946_i0	PRJNA285816	26048	166	1.324786	2.19914476	Thermoplasmatota archaeon	2806419	Archaea	Archaea	61.2	2.76e-9	NR	MEF8879996.1	2806419	g25946	i0	58.8	0.921686746987952	51	21	92.2	0	164	12	142	192	MEF8879996.1 class I SAM-dependent methyltransferase family protein [Thermoplasmatota archaeon]	diamond	153	61.2	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
29144771	29144771	PRJNA285816_S_NODE_789_length_702_cov_2.430322_g723_i0	PRJNA285816	789	702	2.430322	17.06086044	root	1	Root_unresolved	Root_unresolved	67	1.04e-8	NR	WP_116591430.1	190975	g723	i0	35.1	1.56837606837607	134	75	53.8	5	453	76	167	296	WP_116591430.1 Ig-like domain-containing protein [Methanobrevibacter thaueri]	diamond	1101	67	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter thaueri
29884749	29884749	PRJNA285816_S_NODE_21031_length_177_cov_1.218750_g20929_i0	PRJNA285816	21031	177	1.21875	2.1571875	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	51.6	1.11e-5	NR	MFL2940038.1	2163009	g20929	i0	42.9	0.711864406779661	42	24	71.2	0	148	23	372	413	MFL2940038.1 purple acid phosphatase family protein [Candidatus Poseidoniales archaeon]	diamond	126	51.6	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
30250002	30250002	PRJNA285816_S_NODE_17952_length_187_cov_2.978261_g17850_i0	PRJNA285816	17952	187	2.978261	5.56934807	root	1	Root_unresolved	Root_unresolved	58.2	6.39e-8	NR	OPY44313.1	1811687	g17850	i0	50.8	5.85561497326203	61	29	97.9	1	183	1	11	70	OPY44313.1 MAG: succinyl-CoA synthetase subunit beta [Methanosaeta sp. PtaU1.Bin028]	diamond	1095	58.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanosaeta sp. PtaU1.Bin028
31450757	31450757	PRJNA285816_S_NODE_22076_length_174_cov_1.248000_g21974_i0	PRJNA285816	22076	174	1.248	2.17152	Stenosarchaea group	2290931	Archaea	Archaea	83.2	7.58e-17	NR	HEX7444945.1	90426	g21974	i0	65.5	14.948275862069	58	20	100	0	1	174	396	453	HEX7444945.1 ATP citrate lyase citrate-binding domain-containing protein [Methanothrix sp.]	diamond	2601	83.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
31780765	31780765	PRJNA285816_S_NODE_17817_length_188_cov_1.122302_g17715_i0	PRJNA285816	17817	188	1.122302	2.10992776	Methanolinea sp.	2268143	Archaea	Archaea	50.4	2.37e-5	NR	MBP7120145.1	2268143	g17715	i0	47.1	0.813829787234043	51	27	81.4	0	181	29	38	88	MBP7120145.1 hypothetical protein [Methanolinea sp.]	diamond	153	50.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanolinea	Methanolinea sp.
31907432	31907432	PRJNA285816_S_NODE_8717_length_243_cov_3.706186_g8615_i0	PRJNA285816	8717	243	3.706186	9.00603198	Methanobrevibacter sp.	66852	Archaea	Archaea	55.8	8.89e-7	NR	WP_407421068.1	66852	g8615	i0	35.9	0.962962962962963	78	49	96.3	1	241	8	311	387	WP_407421068.1 C1 family peptidase [Methanobrevibacter sp.]	diamond	234	55.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
32065574	32065574	PRJNA285816_S_NODE_5318_length_299_cov_1.744000_g5216_i0	PRJNA285816	5318	299	1.744	5.21456	Methanocaldococcus villosus	667126	Archaea	Archaea	57	1.39e-7	NR	WP_004592618.1	667126	g5216	i0	43	0.792642140468227	79	27	79.3	2	294	58	80	140	WP_004592618.1 30S ribosomal protein S19e [Methanocaldococcus villosus]	diamond	237	57	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanocaldococcaceae	Methanocaldococcus	Methanocaldococcus villosus
32223964	32223964	PRJNA285816_S_NODE_7478_length_259_cov_2.090476_g7376_i0	PRJNA285816	7478	259	2.090476	5.41433284	Methanobacteriota archaeon	2026739	Archaea	Archaea	68.9	9.47e-12	NR	RYE97637.1	2026739	g7376	i0	58.8	0.590733590733591	51	21	59.1	0	154	2	20	70	RYE97637.1 MAG: C1 family peptidase, partial [Methanobacteriota archaeon]	diamond	153	68.9	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
32508906	32508906	PRJNA285816_S_NODE_6919_length_267_cov_1.655963_g6817_i0	PRJNA285816	6919	267	1.655963	4.42142121	Thermoplasmatota archaeon	2806419	Archaea	Archaea	77.4	1.73e-15	NR	HWH08748.1	2806419	g6817	i0	58.1	0.831460674157303	74	26	83.1	2	244	23	96	164	HWH08748.1 AMP-dependent synthetase [Thermoplasmatota archaeon]	diamond	222	77.4	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
32792069	32792069	PRJNA285816_S_NODE_28780_length_163_cov_0.912281_g28678_i0	PRJNA285816	28780	163	0.912281	1.48701803	Thermoplasmataceae archaeon	2953047	Archaea	Archaea	41.6	0.0313	NR	MFG1460913.1	2953047	g28678	i0	40	0.920245398773006	50	29	92	1	161	12	159	207	MFG1460913.1 BadF/BadG/BcrA/BcrD ATPase family protein [Thermoplasmataceae archaeon]	diamond	150	41.6	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales	Thermoplasmataceae		Thermoplasmataceae 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);;