metadata: contig_metadata: 17 rows where bioproject = "PRJNA356682" and tax

17 rows where bioproject = "PRJNA356682" 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
397690	397690	PRJNA356682_P_NODE_31781_length_264_cov_2.691099_g31090_i0	PRJNA356682	31781	264	2.691099	7.10450136	Methanobrevibacter sp. YE315	1609968	Archaea	Archaea	483	7.219999999999998e-132	NTclustered	gi\|985614202\|gb\|CP010834.1\|	1609968	g31090	i0	99.621	149.625	264	1	100	0	1	264	496818	496555	Methanobrevibacter sp. YE315, complete genome	blastn	39501	483	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. YE315
398029	398029	PRJNA356682_P_NODE_47341_length_209_cov_6.338235_g46650_i0	PRJNA356682	47341	209	6.338235	13.24691115	Methanosalsum zhilinae	39669	Archaea	Archaea	56.5	0.001	NTclustered	gi\|335929340\|gb\|CP002101.1\|	679901	g46650	i0	100	0.143540669856459	30	0	14	0	59	88	1665167	1665138	Methanosalsum zhilinae DSM 4017, complete genome	blastn	30	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosalsum	Methanosalsum zhilinae
2948400	2948400	PRJNA356682_P_NODE_38383_length_248_cov_0.880000_g37692_i0	PRJNA356682	38383	248	0.88	2.1824	Halopenitus sp.	1979403	Archaea	Archaea	108	1.67e-25	NR	MFB6236002.1	1979403	g37692	i0	69.1	1.13709677419355	94	17	99.2	1	248	3	1	94	MFB6236002.1 helix-turn-helix transcriptional regulator [Halopenitus sp.]	diamond	282	108	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halopenitus	Halopenitus sp.
6775569	6775569	PRJNA356682_P_NODE_45046_length_241_cov_0.916667_g44355_i0	PRJNA356682	45046	241	0.916667	2.20916747	Haloferax gibbonsii	35746	Archaea	Archaea	174	4.4399999999999997e-39	NTclustered	gi\|1919476744\|gb\|CP063205.1\|	35746	g44355	i0	83.871	3.0746887966805	186	26	76	4	25	208	2789980	2789797	Haloferax gibbonsii strain LR2-5 chromosome, complete genome	blastn	741	174	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax gibbonsii
10601677	10601677	PRJNA356682_P_NODE_44829_length_241_cov_0.916667_g44138_i0	PRJNA356682	44829	241	0.916667	2.20916747	Natronomonas halophila	2747817	Archaea	Archaea	243	1.2e-59	NTclustered	gi\|1865516082\|gb\|CP058334.1\|	2747817	g44138	i0	89.529	1.26970954356846	191	20	79	0	1	191	2869383	2869193	Natronomonas halophila strain C90 chromosome, complete genome	blastn	306	243	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas halophila
16975139	16975139	PRJNA356682_P_NODE_36814_length_250_cov_0.870056_g36123_i0	PRJNA356682	36814	250	0.870056	2.17514	Methanobrevibacter ruminantium	83816	Archaea	Archaea	381	2.5399999999999996e-101	NTclustered	gi\|288541968\|gb\|CP001719.1\|	634498	g36123	i0	94.378	25.888	249	13	99	1	2	250	2040570	2040817	Methanobrevibacter ruminantium M1, complete genome	blastn	6472	381	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter ruminantium
18249523	18249523	PRJNA356682_P_NODE_43135_length_243_cov_0.905882_g42444_i0	PRJNA356682	43135	243	0.905882	2.20129326	Methanobrevibacter olleyae	294671	Archaea	Archaea	327	3.25e-85	NTclustered	gi\|998157363\|gb\|CP014265.1\|	294671	g42444	i0	91.25	7.32510288065844	240	21	99	0	1	240	302570	302809	Methanobrevibacter olleyae strain YLM1 chromosome, complete genome	blastn	1780	327	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter olleyae
18249571	18249571	PRJNA356682_P_NODE_44635_length_241_cov_0.916667_g43944_i0	PRJNA356682	44635	241	0.916667	2.20916747	Natronomonas halophila	2747817	Archaea	Archaea	368	1.9e-97	NTclustered	gi\|1865516082\|gb\|CP058334.1\|	2747817	g43944	i0	94.191	1.54771784232365	241	14	100	0	1	241	156285	156045	Natronomonas halophila strain C90 chromosome, complete genome	blastn	373	368	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas halophila
18923880	18923880	PRJNA356682_P_NODE_38855_length_248_cov_0.880000_g38164_i0	PRJNA356682	38855	248	0.88	2.1824	Halorubrum	56688	Archaea	Archaea	298	2.61e-76	NTclustered	gi\|1848526000\|gb\|CP053941.1\|	2739057	g38164	i0	88.4	60.9516129032258	250	25	100	4	1	248	622039	622286	Halorubrum salinarum strain RHB-C chromosome, complete genome	blastn	15116	298	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum salinarum
22074561	22074561	PRJNA356682_P_NODE_4758_length_650_cov_4.975737_g4085_i0	PRJNA356682	4758	650	4.975737	32.3422905	Methanobrevibacter sp. YE315	1609968	Archaea	Archaea	1134	0	NTclustered	gi\|985614202\|gb\|CP010834.1\|	1609968	g4085	i0	98.157	162.173846153846	651	11	100	1	1	650	495560	496210	Methanobrevibacter sp. YE315, complete genome	blastn	105413	1134	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. YE315
24624021	24624021	PRJNA356682_P_NODE_40140_length_246_cov_0.890173_g39449_i0	PRJNA356682	40140	246	0.890173	2.18982558	Natronorubrum bangense	61858	Archaea	Archaea	132	2.77e-26	NTclustered	gi\|1621081954\|gb\|CP031305.1\|	61858	g39449	i0	87.179	1.90650406504065	117	13	47	2	67	182	309078	309193	Natronorubrum bangense strain JCM 10635 chromosome, complete genome	blastn	469	132	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronorubrum	Natronorubrum bangense
27864397	27864397	PRJNA356682_P_NODE_26225_length_287_cov_1.962617_g25534_i0	PRJNA356682	26225	287	1.962617	5.63271079	Candidatus Thalassarchaeaceae archaeon	2670411	Archaea	Archaea	58.2	2.3e-7	NR	MFL2966465.1	2670411	g25534	i0	67.5	0.418118466898955	40	13	41.8	0	121	2	1	40	MFL2966465.1 HAD-IA family hydrolase [Candidatus Thalassarchaeaceae archaeon]	diamond	120	58.2	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Thalassarchaeaceae		Candidatus Thalassarchaeaceae archaeon
29744269	29744269	PRJNA356682_P_NODE_43870_length_242_cov_0.911243_g43179_i0	PRJNA356682	43870	242	0.911243	2.20520806	Methanobrevibacter	2172	Archaea	Archaea	156	2.7799999999999992e-43	NR	MEE1149620.1	66852	g43179	i0	97.5	3.96694214876033	80	2	99.2	0	3	242	118	197	MEE1149620.1 AAA family ATPase [Methanobrevibacter sp.]	diamond	960	156	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30454240	30454240	PRJNA356682_P_NODE_40253_length_246_cov_0.890173_g39562_i0	PRJNA356682	40253	246	0.890173	2.18982558	Methanosarcina sp.	2213	Archaea	Archaea	114	9.979999999999999e-30	NR	HET8688789.1	2213	g39562	i0	65.8	0.890243902439024	73	24	87.8	1	21	236	8	80	HET8688789.1 hypothetical protein [Methanosarcina sp.]	diamond	219	114	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
32051849	32051849	PRJNA356682_P_NODE_43738_length_242_cov_0.911243_g43047_i0	PRJNA356682	43738	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	106	8.43e-25	NR	MBX7076496.1	2099680	g43047	i0	82.3	1.53719008264463	62	11	76.9	0	1	186	452	513	MBX7076496.1 F0F1 ATP synthase subunit alpha [Methanobacteriaceae archaeon]	diamond	372	106	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		Methanobacteriaceae archaeon
32319841	32319841	PRJNA356682_P_NODE_36919_length_250_cov_0.870056_g36228_i0	PRJNA356682	36919	250	0.870056	2.17514	Methanobrevibacter sp.	66852	Archaea	Archaea	150	7.429999999999998e-42	NR	MCR5026642.1	66852	g36228	i0	91.6	0.996	83	7	99.6	0	249	1	44	126	MCR5026642.1 MFS transporter [Methanobrevibacter sp.]	diamond	249	150	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
32382765	32382765	PRJNA356682_P_NODE_32339_length_262_cov_2.370370_g31648_i0	PRJNA356682	32339	262	2.37037	6.2103694	Thermoplasmatota archaeon	2806419	Archaea	Archaea	46.2	0.00107	NR	MCL5681076.1	2806419	g31648	i0	38.9	0.824427480916031	72	39	76.7	2	240	40	46	117	MCL5681076.1 OB-fold nucleic acid binding domain-containing protein [Thermoplasmatota archaeon]	diamond	216	46.2	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota 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);;