metadata: contig_metadata: 22 rows where bioproject = "PRJNA896973" and tax

22 rows where bioproject = "PRJNA896973" and tax_clade = "Stenosarchaea group"

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
873151	873151	PRJNA896973_P_NODE_19421_length_263_cov_1.336842_g19327_i0	PRJNA896973	19421	263	1.336842	3.51589446	Natronomonas moolapensis	416273	Archaea	Archaea	132	3e-26	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g19327	i0	84.058	0.524714828897338	138	21	52	1	126	263	2322930	2322794	Natronomonas moolapensis 8.8.11 complete genome	blastn	138	132	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
3423962	3423962	PRJNA896973_P_NODE_21863_length_251_cov_0.865169_g21769_i0	PRJNA896973	21863	251	0.865169	2.17157419	Natronomonas moolapensis	416273	Archaea	Archaea	315	2.6299999999999998e-81	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g21769	i0	89.516	5.82868525896414	248	26	99	0	1	248	543474	543721	Natronomonas moolapensis 8.8.11 complete genome	blastn	1463	315	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
3424086	3424086	PRJNA896973_P_NODE_26983_length_243_cov_0.882353_g26889_i0	PRJNA896973	26983	243	0.882353	2.14411779	Halobacterium noricense	223182	Archaea	Archaea	449	6.65e-122	NTclustered	gi\|2168248316\|gb\|CP089469.1\|	223182	g26889	i0	100	68.6502057613169	243	0	100	0	1	243	95113	95355	Halobacterium noricense strain JCM 15102 plasmid unnamed1, complete sequence	blastn	16682	449	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halobacterium	Halobacterium noricense
4701656	4701656	PRJNA896973_P_NODE_17424_length_275_cov_1.514851_g17330_i0	PRJNA896973	17424	275	1.514851	4.16584025	Haloplanus sp. GX21	3127120	Archaea	Archaea	270	6.41e-68	NTclustered	gi\|2700851762\|gb\|CP147874.1\|	3127120	g17330	i0	84.783	1.00363636363636	276	34	99	6	1	272	1553340	1553611	Haloplanus sp. GX21 chromosome, complete genome	blastn	276	270	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloplanus	Haloplanus sp. GX21
4701858	4701858	PRJNA896973_P_NODE_26784_length_243_cov_0.905882_g26690_i0	PRJNA896973	26784	243	0.905882	2.20129326	Halobellus marinus	3075123	Archaea	Archaea	372	1.48e-98	NTclustered	gi\|2582078524\|gb\|CP134948.1\|	3075123	g26690	i0	94.937	4.92592592592593	237	12	98	0	7	243	122564	122328	Halobellus sp. DFY28 plasmid unnamed2, complete sequence	blastn	1197	372	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobellus	Halobellus marinus
5976511	5976511	PRJNA896973_P_NODE_22885_length_249_cov_0.875000_g22791_i0	PRJNA896973	22885	249	0.875	2.17875	Haloterrigena turkmenica	62320	Archaea	Archaea	248	2.68e-61	NTclustered	gi\|284012950\|gb\|CP001860.1\|	543526	g22791	i0	87.273	1.79919678714859	220	24	88	4	1	218	2558303	2558520	Haloterrigena turkmenica DSM 5511, complete genome	blastn	448	248	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Haloterrigena	Haloterrigena turkmenica
5976548	5976548	PRJNA896973_P_NODE_24565_length_246_cov_1.728324_g24471_i0	PRJNA896973	24565	246	1.728324	4.25167704	Halobaculum halobium	3032281	Archaea	Archaea	99	2.81e-16	NTclustered	gi\|2511738010\|gb\|CP126158.1\|	3032281	g24471	i0	82.727	1.59756097560976	110	19	45	0	135	244	1133624	1133515	Halobaculum halobium strain SYNS20 chromosome, complete genome	blastn	393	99	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobaculum	Halobaculum halobium
8526001	8526001	PRJNA896973_P_NODE_23487_length_248_cov_0.880000_g23393_i0	PRJNA896973	23487	248	0.88	2.1824	Halorubrum sp. CBA1229	1853699	Archaea	Archaea	315	2.59e-81	NTclustered	gi\|1861358827\|gb\|CP054585.1\|	1853699	g23393	i0	89.494	6.96774193548387	257	16	99	2	1	246	674240	674496	Halorubrum sp. CBA1229 chromosome, complete genome	blastn	1728	315	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. CBA1229
8896889	8896889	PRJNA896973_P_NODE_23047_length_249_cov_0.875000_g22953_i0	PRJNA896973	23047	249	0.875	2.17875	Natronomonas sp. LN261	2750669	Archaea	Archaea	165	2.89e-48	NR	WP_181692690.1	2750669	g22953	i0	97.6	1	83	2	100	0	249	1	149	231	WP_181692690.1 AAA family ATPase [Natronomonas sp. LN261]	diamond	249	165	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas sp. LN261
9801035	9801035	PRJNA896973_P_NODE_22768_length_249_cov_1.375000_g22674_i0	PRJNA896973	22768	249	1.375	3.42375	Natronomonas sp. LN261	2750669	Archaea	Archaea	165	2.2099999999999997e-47	NR	WP_181692260.1	2750669	g22674	i0	95.1	0.987951807228916	82	4	98.8	0	247	2	6	87	WP_181692260.1 tRNA pseudouridine(54/55) synthase Pus10 [Natronomonas sp. LN261]	diamond	246	165	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas sp. LN261
11076799	11076799	PRJNA896973_P_NODE_26089_length_244_cov_0.900585_g25995_i0	PRJNA896973	26089	244	0.900585	2.1974274	Natronomonas moolapensis	416273	Archaea	Archaea	228	3.409999999999999e-55	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g25995	i0	86.473	61.2213114754098	207	28	85	0	1	207	1745747	1745953	Natronomonas moolapensis 8.8.11 complete genome	blastn	14938	228	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
14901146	14901146	PRJNA896973_P_NODE_21712_length_251_cov_0.865169_g21618_i0	PRJNA896973	21712	251	0.865169	2.17157419	Natronomonas moolapensis	416273	Archaea	Archaea	453	5.34e-123	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g21618	i0	99.203	3.33466135458167	251	2	100	0	1	251	676277	676527	Natronomonas moolapensis 8.8.11 complete genome	blastn	837	453	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
16175813	16175813	PRJNA896973_P_NODE_16413_length_282_cov_1.000000_g16319_i0	PRJNA896973	16413	282	1	2.82	Halorubrum ezzemoulense	337243	Archaea	Archaea	276	1.4199999999999999e-69	NTclustered	gi\|1565814486\|gb\|CP034940.1\|	337243	g16319	i0	84.561	42.4751773049645	285	37	100	4	1	282	1171939	1172219	Halorubrum ezzemoulense strain Fb21 chromosome, complete genome	blastn	11978	276	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum ezzemoulense
16176044	16176044	PRJNA896973_P_NODE_27913_length_241_cov_0.916667_g27819_i0	PRJNA896973	27913	241	0.916667	2.20916747	Halorubrum sp. CBA1229	1853699	Archaea	Archaea	326	1.16e-84	NTclustered	gi\|1861358827\|gb\|CP054585.1\|	1853699	g27819	i0	91.213	0.991701244813278	239	21	99	0	3	241	2376489	2376251	Halorubrum sp. CBA1229 chromosome, complete genome	blastn	239	326	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. CBA1229
18724756	18724756	PRJNA896973_P_NODE_27275_length_242_cov_0.911243_g27181_i0	PRJNA896973	27275	242	0.911243	2.20520806	Halonotius aquaticus	2216978	Archaea	Archaea	155	6.5799999999999985e-43	NR	WP_120103427.1	2216978	g27181	i0	88.8	1.98347107438017	80	9	99.2	0	240	1	381	460	WP_120103427.1 lipase maturation factor family protein [Halonotius aquaticus]	diamond	480	155	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halonotius	Halonotius aquaticus
19999688	19999688	PRJNA896973_P_NODE_18256_length_270_cov_1.157360_g18162_i0	PRJNA896973	18256	270	1.15736	3.124872	Natronomonas moolapensis	416273	Archaea	Archaea	403	5.93e-108	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g18162	i0	93.68	92.6703703703704	269	17	99	0	2	270	424769	424501	Natronomonas moolapensis 8.8.11 complete genome	blastn	25021	403	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
21275145	21275145	PRJNA896973_P_NODE_23017_length_249_cov_0.875000_g22923_i0	PRJNA896973	23017	249	0.875	2.17875	Halorubrum sp. CBA1229	1853699	Archaea	Archaea	392	1.1699999999999999e-104	NTclustered	gi\|1861358827\|gb\|CP054585.1\|	1853699	g22923	i0	95.161	0.995983935742972	248	12	99	0	2	249	1707129	1706882	Halorubrum sp. CBA1229 chromosome, complete genome	blastn	248	392	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. CBA1229
23825350	23825350	PRJNA896973_P_NODE_22439_length_250_cov_0.870056_g22345_i0	PRJNA896973	22439	250	0.870056	2.17514	Halorubrum sp. CBA1229	1853699	Archaea	Archaea	209	1.27e-49	NTclustered	gi\|1861358827\|gb\|CP054585.1\|	1853699	g22345	i0	83.122	1.62	237	33	94	7	16	250	1244439	1244670	Halorubrum sp. CBA1229 chromosome, complete genome	blastn	405	209	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. CBA1229
25470762	25470762	PRJNA896973_P_NODE_4700_length_479_cov_2.458128_g4606_i0	PRJNA896973	4700	479	2.458128	11.77443312	root	1	Root_unresolved	Root_unresolved	874	0	NTclustered	gi\|2515741548\|gb\|CP117271.1\|	2209	g4606	i0	99.582	100.480167014614	479	2	100	0	1	479	3941880	3941402	Mutant Methanosarcina mazei strain Mm Mut 208, complete genome	blastn	48130	880	0.993181818181818	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina mazei
29116205	29116205	PRJNA896973_P_NODE_22548_length_250_cov_0.870056_g22454_i0	PRJNA896973	22548	250	0.870056	2.17514	Halobacteriales	2235	Archaea	Archaea	148	4.59e-40	NR	WP_256401039.1	755306	g22454	i0	90.4	7.968	83	8	99.6	0	250	2	16	98	WP_256401039.1 ATP-binding protein [Haloarchaeobius litoreus]	diamond	1992	148	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halorubellaceae	Haloarchaeobius	Haloarchaeobius litoreus
29550219	29550219	PRJNA896973_P_NODE_25650_length_245_cov_0.895349_g25556_i0	PRJNA896973	25650	245	0.895349	2.19360505	Halovenus carboxidivorans	2692199	Archaea	Archaea	110	4.04e-26	NR	WP_159763028.1	2692199	g25556	i0	69.1	0.991836734693878	81	25	99.2	0	243	1	230	310	WP_159763028.1 PAS domain-containing protein [Halovenus carboxidivorans]	diamond	243	110	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halovenus	Halovenus carboxidivorans
29676360	29676360	PRJNA896973_P_NODE_25450_length_245_cov_0.895349_g25356_i0	PRJNA896973	25450	245	0.895349	2.19360505	Natronomonas sp. LN261	2750669	Archaea	Archaea	140	3.4699999999999995e-37	NR	WP_181691709.1	2750669	g25356	i0	95.6	0.83265306122449	68	3	83.3	0	205	2	1	68	WP_181691709.1 acyl-CoA mutase large subunit family protein [Natronomonas sp. LN261]	diamond	204	140	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas sp. LN261

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