metadata: contig_metadata: 13 rows where bioproject = "PRJNA857857" and tax

13 rows where bioproject = "PRJNA857857" 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
6339494	6339494	PRJNA857857_P_NODE_20005_length_350_cov_1.364621_g19556_i0	PRJNA857857	20005	350	1.364621	4.7761735	Halococcus	2249	Archaea	Archaea	641	1.5399999999999996e-179	NTclustered	gi\|288192\|emb\|X72588.1\|	2250	g19556	i0	99.714	133.8	350	1	100	0	1	350	4230	4579	H.morrhuae ribosomal RNA operon and flanking regions	blastn	46830	641	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus morrhuae
8497943	8497943	PRJNA857857_P_NODE_33167_length_266_cov_1.595855_g32718_i0	PRJNA857857	33167	266	1.595855	4.2449743	Methanobacteriati	3366610	Archaea	Archaea	123	1.74e-30	NR	HDY74227.1	2026739	g32718	i0	69	6.84586466165414	87	27	98.1	0	1	261	483	569	HDY74227.1 calcium-transporting P-type ATPase, PMR1-type [Methanobacteriota archaeon]	diamond	1821	123	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
8498235	8498235	PRJNA857857_P_NODE_45827_length_245_cov_0.895349_g45378_i0	PRJNA857857	45827	245	0.895349	2.19360505	Methanobrevibacter woesei	190976	Archaea	Archaea	146	1.42e-38	NR	WP_116669349.1	190976	g45378	i0	92.6	0.991836734693878	81	6	99.2	0	243	1	523	603	WP_116669349.1 heavy metal translocating P-type ATPase [Methanobrevibacter woesei]	diamond	243	146	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter woesei
18696668	18696668	PRJNA857857_P_NODE_43855_length_246_cov_0.890173_g43406_i0	PRJNA857857	43855	246	0.890173	2.18982558	Methanobrevibacter smithii	2173	Archaea	Archaea	390	4.15e-104	NTclustered	gi\|1294447101\|gb\|CP017803.1\|	2173	g43406	i0	95.51	2.98373983739837	245	10	99	1	3	246	1271602	1271358	Methanobrevibacter smithii strain KB11 chromosome, complete genome	blastn	734	390	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
27023427	27023427	PRJNA857857_P_NODE_34822_length_258_cov_1.610811_g34373_i0	PRJNA857857	34822	258	1.610811	4.15589238	Methanobrevibacter woesei	190976	Archaea	Archaea	128	4.19e-32	NR	WP_116669569.1	190976	g34373	i0	92.3	0.906976744186046	78	6	90.7	0	25	258	1	78	WP_116669569.1 calcium-translocating P-type ATPase, PMCA-type [Methanobrevibacter woesei]	diamond	234	128	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter woesei
27623973	27623973	PRJNA857857_P_NODE_8044_length_548_cov_1.600000_g7615_i0	PRJNA857857	8044	548	1.6	8.768	Candidatus Alkanophagales archaeon	2971454	Archaea	Archaea	89.4	1.12e-18	NR	RLG36346.1	2971454	g7615	i0	38.3	1.17153284671533	107	64	58.6	2	323	3	23	127	RLG36346.1 MAG: protein phosphatase [Candidatus Alkanophagales archaeon]	diamond	642	89.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Candidatus Alkanophagales			Candidatus Alkanophagales archaeon
27813450	27813450	PRJNA857857_P_NODE_28824_length_288_cov_1.074419_g28375_i0	PRJNA857857	28824	288	1.074419	3.09432672	Candidatus Methanoperedens sp.	2032688	Archaea	Archaea	68.9	3.96e-11	NR	MDP2767729.1	2032688	g28375	i0	45.1	0.947916666666667	91	46	94.8	2	11	283	575	661	MDP2767729.1 DUF4062 domain-containing protein [Candidatus Methanoperedens sp.]	diamond	273	68.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Candidatus Methanoperedentaceae	Candidatus Methanoperedens	Candidatus Methanoperedens sp.
28168710	28168710	PRJNA857857_P_NODE_28425_length_290_cov_1.064516_g27976_i0	PRJNA857857	28425	290	1.064516	3.0870964	Methanobacteriati	3366610	Archaea	Archaea	104	1.0899999999999999e-23	NR	HLQ42713.1	1906666	g27976	i0	66.7	3.68275862068965	72	24	74.5	0	218	3	414	485	HLQ42713.1 alkaline phosphatase family protein [Thermoplasmata archaeon]	diamond	1068	104	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
30434582	30434582	PRJNA857857_P_NODE_42993_length_247_cov_0.885057_g42544_i0	PRJNA857857	42993	247	0.885057	2.18609079	Methanobrevibacter woesei	190976	Archaea	Archaea	161	2.91e-44	NR	WP_116669046.1	190976	g42544	i0	100	0.995951417004049	82	0	99.6	0	246	1	461	542	WP_116669046.1 heavy metal translocating P-type ATPase [Methanobrevibacter woesei]	diamond	246	161	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter woesei
30845053	30845053	PRJNA857857_P_NODE_45714_length_245_cov_0.895349_g45265_i0	PRJNA857857	45714	245	0.895349	2.19360505	Methanobrevibacter woesei	190976	Archaea	Archaea	148	1.16e-40	NR	WP_116670124.1	190976	g45265	i0	97.4	0.955102040816327	78	2	95.5	0	244	11	356	433	WP_116670124.1 prephenate dehydrogenase [Methanobrevibacter woesei]	diamond	234	148	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter woesei
31066401	31066401	PRJNA857857_P_NODE_45915_length_245_cov_0.895349_g45466_i0	PRJNA857857	45915	245	0.895349	2.19360505	Methanobrevibacter woesei	190976	Archaea	Archaea	153	5.089999999999998e-43	NR	WP_116669561.1	190976	g45466	i0	100	0.991836734693878	81	0	99.2	0	3	245	139	219	WP_116669561.1 DNA-directed RNA polymerase subunit A'' [Methanobrevibacter woesei]	diamond	243	153	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter woesei
31666869	31666869	PRJNA857857_P_NODE_43737_length_246_cov_0.890173_g43288_i0	PRJNA857857	43737	246	0.890173	2.18982558	Methanobrevibacter woesei	190976	Archaea	Archaea	140	1.0599999999999998e-37	NR	WP_116669984.1	190976	g43288	i0	93.9	1	82	5	100	0	1	246	273	354	WP_116669984.1 MATE family efflux transporter [Methanobrevibacter woesei]	diamond	246	140	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter woesei
32867703	32867703	PRJNA857857_P_NODE_2960_length_875_cov_2.164589_g2617_i0	PRJNA857857	2960	875	2.164589	18.94015375	Euryarchaeota archaeon RBG_19FT_COMBO_69_17	1797984	Archaea	Archaea	82.4	4.25e-14	NR	OGS62806.1	1797984	g2617	i0	27.1	1.81714285714286	266	153	79.5	10	744	49	18	276	OGS62806.1 MAG: hypothetical protein A3K59_01270 [Euryarchaeota archaeon RBG_19FT_COMBO_69_17]	diamond	1590	82.4	1	Archaea		Methanobacteriati	Methanobacteriota					Euryarchaeota archaeon RBG_19FT_COMBO_69_17

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