metadata: contig_metadata: 29 rows where bioproject = "PRJNA949785" and tax

29 rows where bioproject = "PRJNA949785" 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
2208463	2208463	PRJNA949785_P_NODE_16782_length_247_cov_0.885057_g16585_i0	PRJNA949785	16782	247	0.885057	2.18609079	Halorubrum sp. CBA1229	1853699	Archaea	Archaea	255	1.59e-63	NTclustered	gi\|1861358827\|gb\|CP054585.1\|	1853699	g16585	i0	88.073	148.603238866397	218	22	87	4	3	217	1358646	1358430	Halorubrum sp. CBA1229 chromosome, complete genome	blastn	36705	255	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. CBA1229
8586152	8586152	PRJNA949785_P_NODE_16967_length_247_cov_0.885057_g16770_i0	PRJNA949785	16967	247	0.885057	2.18609079	Halobacterium litoreum	2039234	Archaea	Archaea	122	1.68e-23	NTclustered	gi\|2168234898\|gb\|CP089466.1\|	2039234	g16770	i0	92.045	22.1376518218623	88	5	35	2	9	95	1479722	1479636	Halobacterium litoreum strain ZS-54-S2 chromosome, complete genome	blastn	5468	122	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halobacterium	Halobacterium litoreum
8586172	8586172	PRJNA949785_P_NODE_18547_length_242_cov_0.911243_g18350_i0	PRJNA949785	18547	242	0.911243	2.20520806	Halopenitus persicus	1048396	Archaea	Archaea	156	1.6200000000000002e-33	NTclustered	gi\|1040460692\|dbj\|AP017558.1\|	1048396	g18350	i0	86.62	5.05371900826446	142	18	59	1	4	145	1050071	1050211	Halopenitus persicus DNA, complete genome, strain: CBA1233	blastn	1223	156	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halopenitus	Halopenitus persicus
9861193	9861193	PRJNA949785_P_NODE_16328_length_249_cov_0.875000_g16131_i0	PRJNA949785	16328	249	0.875	2.17875	Natronomonas moolapensis	416273	Archaea	Archaea	163	9.980000000000001e-36	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g16131	i0	93.578	11.140562248996	109	7	44	0	1	109	227207	227099	Natronomonas moolapensis 8.8.11 complete genome	blastn	2774	163	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
13686855	13686855	PRJNA949785_P_NODE_17871_length_244_cov_0.900585_g17674_i0	PRJNA949785	17871	244	0.900585	2.1974274	Haloarcula montana	3111776	Archaea	Archaea	368	1.92e-97	NTclustered	gi\|2648521790\|gb\|CP142027.1\|	3111776	g17674	i0	93.852	10.9016393442623	244	15	100	0	1	244	980773	980530	Haloarcula sp. GH36 chromosome, complete genome	blastn	2660	368	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Haloarcula	Haloarcula montana
13686864	13686864	PRJNA949785_P_NODE_18471_length_242_cov_1.378698_g18274_i0	PRJNA949785	18471	242	1.378698	3.33644916	Halodesulfurarchaeum sp.	1980530	Archaea	Archaea	149	2.5799999999999993e-42	NR	MFB6085499.1	1980530	g18274	i0	89.9	1.97107438016529	79	8	97.9	0	241	5	65	143	MFB6085499.1 lipoyl synthase [Halodesulfurarchaeum sp.]	diamond	477	149	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halodesulfurarchaeum	Halodesulfurarchaeum sp.
14960998	14960998	PRJNA949785_P_NODE_16152_length_249_cov_0.875000_g15955_i0	PRJNA949785	16152	249	0.875	2.17875	Halobellus inordinatus	1126236	Archaea	Archaea	411	3.2299999999999996e-110	NTclustered	gi\|2279714123\|gb\|CP101825.1\|	1126236	g15955	i0	96.386	4.28915662650602	249	9	100	0	1	249	1749796	1749548	Halobellus inordinatus strain DSM 26177 chromosome, complete genome	blastn	1068	411	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobellus	Halobellus inordinatus
17511307	17511307	PRJNA949785_P_NODE_13394_length_276_cov_1.384236_g13197_i0	PRJNA949785	13394	276	1.384236	3.82049136	Haloferax sp. S1W	3377110	Archaea	Archaea	182	3.1e-41	NTclustered	gi\|2845113133\|gb\|CP172596.1\|	3377110	g13197	i0	79.078	1.96739130434783	282	45	99	10	2	276	165833	166107	Haloferax sp. S1W plasmid pHFX1, complete sequence	blastn	543	182	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax sp. S1W
18784909	18784909	PRJNA949785_P_NODE_15155_length_254_cov_2.209945_g14958_i0	PRJNA949785	15155	254	2.209945	5.6132603	Natronomonas moolapensis	416273	Archaea	Archaea	259	1.27e-64	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g14958	i0	85.156	8.9251968503937	256	34	100	4	1	254	1548344	1548597	Natronomonas moolapensis 8.8.11 complete genome	blastn	2267	259	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
18784915	18784915	PRJNA949785_P_NODE_15675_length_251_cov_0.865169_g15478_i0	PRJNA949785	15675	251	0.865169	2.17157419	Halarchaeum sp. CBA1220	1853682	Archaea	Archaea	152	2.18e-32	NTclustered	gi\|1864269003\|gb\|CP054707.1\|	1853682	g15478	i0	79.717	0.844621513944223	212	41	84	2	1	211	1354870	1354660	Halarchaeum sp. CBA1220 chromosome, complete genome	blastn	212	152	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halarchaeum	Halarchaeum sp. CBA1220
18784924	18784924	PRJNA949785_P_NODE_16295_length_249_cov_0.875000_g16098_i0	PRJNA949785	16295	249	0.875	2.17875	Haloferax volcanii	2246	Archaea	Archaea	172	1.66e-38	NTclustered	gi\|291369412\|gb\|CP001955.1\|	309800	g16098	i0	94.595	1.22088353413655	111	6	45	0	134	244	452519	452629	Haloferax volcanii DS2 plasmid pHV4, complete sequence	blastn	304	172	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax volcanii
21335268	21335268	PRJNA949785_P_NODE_16837_length_247_cov_0.885057_g16640_i0	PRJNA949785	16837	247	0.885057	2.18609079	Natrinema thermotolerans	121872	Archaea	Archaea	322	1.54e-83	NTclustered	gi\|1621090060\|gb\|CP031304.1\|	121872	g16640	i0	90.871	28.7611336032389	241	21	97	1	8	247	7105	6865	Natrinema thermotolerans strain A29 plasmid unnamed6, complete sequence	blastn	7104	322	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema thermotolerans
26740212	26740212	PRJNA949785_P_NODE_15501_length_251_cov_0.865169_g15304_i0	PRJNA949785	15501	251	0.865169	2.17157419	Halanaeroarchaeum sp.	1963275	Archaea	Archaea	139	1.0499999999999998e-37	NR	MFB6094000.1	1963275	g15304	i0	86.7	0.99203187250996006	83	11	99.2	0	3	251	209	291	MFB6094000.1 tubulin/FtsZ family protein [Halanaeroarchaeum sp.]	diamond	249	139	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halanaeroarchaeum	Halanaeroarchaeum sp.
26962080	26962080	PRJNA949785_P_NODE_18962_length_241_cov_0.916667_g18765_i0	PRJNA949785	18962	241	0.916667	2.20916747	Natronomonas sp. LN261	2750669	Archaea	Archaea	66.6	1.37e-10	NR	WP_181691579.1	2750669	g18765	i0	93.8	0.398340248962656	32	2	39.8	0	96	1	1	32	WP_181691579.1 NCS2 family permease [Natronomonas sp. LN261]	diamond	96	66.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas sp. LN261
27246774	27246774	PRJNA949785_P_NODE_18403_length_243_cov_0.888235_g18206_i0	PRJNA949785	18403	243	0.888235	2.15841105	Natronomonas sp. LN261	2750669	Archaea	Archaea	155	4.08e-44	NR	WP_181692849.1	2750669	g18206	i0	92.5	0.987654320987654	80	6	98.8	0	3	242	246	325	WP_181692849.1 thiolase family protein [Natronomonas sp. LN261]	diamond	240	155	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas sp. LN261
27310212	27310212	PRJNA949785_P_NODE_17983_length_244_cov_0.900585_g17786_i0	PRJNA949785	17983	244	0.900585	2.1974274	Haloferax larsenii JCM 13917	1227460	Archaea	Archaea	62.4	2.18e-10	NR	ELZ79431.1	1227460	g17786	i0	50	0.688524590163934	56	28	68.9	0	227	60	51	106	ELZ79431.1 hypothetical protein C455_07602 [Haloferax larsenii JCM 13917]	diamond	168	62.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax larsenii
27373506	27373506	PRJNA949785_P_NODE_5483_length_478_cov_0.735802_g5286_i0	PRJNA949785	5483	478	0.735802	3.51713356	Haloferax sp. Q22	1526048	Archaea	Archaea	44.7	0.0257	NR	WP_157575373.1	1526048	g5286	i0	66.7	0.169456066945607	27	9	16.9	0	394	474	42	68	WP_157575373.1 HNH endonuclease signature motif containing protein [Haloferax sp. Q22]	diamond	81	44.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax sp. Q22
28099339	28099339	PRJNA949785_P_NODE_15545_length_251_cov_0.865169_g15348_i0	PRJNA949785	15545	251	0.865169	2.17157419	Halobellus limi	699433	Archaea	Archaea	44.7	0.00685	NR	WP_103989965.1	699433	g15348	i0	53.1	0.382470119521912	32	15	38.2	0	73	168	3	34	WP_103989965.1 hypothetical protein [Halobellus limi]	diamond	96	44.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobellus	Halobellus limi
28983752	28983752	PRJNA949785_P_NODE_16108_length_249_cov_1.312500_g15911_i0	PRJNA949785	16108	249	1.3125	3.268125	Natronomonas sp. LN261	2750669	Archaea	Archaea	161	4.81e-45	NR	WP_181691523.1	2750669	g15911	i0	96.3	0.987951807228916	82	3	98.8	0	2	247	378	459	WP_181691523.1 sensor histidine kinase [Natronomonas sp. LN261]	diamond	246	161	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas sp. LN261
28983755	28983755	PRJNA949785_P_NODE_17428_length_245_cov_1.534884_g17231_i0	PRJNA949785	17428	245	1.534884	3.7604658	Halodesulfurarchaeum sp.	1980530	Archaea	Archaea	130	1.64e-33	NR	MDZ7849954.1	1980530	g17231	i0	82.7	0.991836734693878	81	14	99.2	0	245	3	57	137	MDZ7849954.1 ABC transporter permease [Halodesulfurarchaeum sp.]	diamond	243	130	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halodesulfurarchaeum	Halodesulfurarchaeum sp.
29173121	29173121	PRJNA949785_P_NODE_15829_length_250_cov_0.870056_g15632_i0	PRJNA949785	15829	250	0.870056	2.17514	Halocalculus aciditolerans	1383812	Archaea	Archaea	74.3	2.87e-13	NR	WP_188977489.1	1383812	g15632	i0	51.3	1.872	78	32	92.4	2	248	18	6	78	WP_188977489.1 DNA (cytosine-5-)-methyltransferase [Halocalculus aciditolerans]	diamond	468	74.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halocalculus	Halocalculus aciditolerans
30183482	30183482	PRJNA949785_P_NODE_15872_length_250_cov_0.870056_g15675_i0	PRJNA949785	15872	250	0.870056	2.17514	Halomicroarcula sp. GCM1	44098	Archaea	Archaea	85.9	1e-17	NR	WP_379788386.1	3252667	g15675	i0	45.2	1.008	84	45	99.6	1	249	1	116	199	WP_379788386.1 homing endonuclease associated repeat-containing protein [Halomicroarcula sp. GCM10025324]	diamond	252	85.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Haloarcula	Halomicroarcula sp. GCM10025324
30342036	30342036	PRJNA949785_P_NODE_17992_length_244_cov_0.900585_g17795_i0	PRJNA949785	17992	244	0.900585	2.1974274	Haloprofundus sp. MHR1	2572921	Archaea	Archaea	55.5	1.26e-6	NR	WP_137046907.1	2572921	g17795	i0	51.1	2.36065573770492	45	22	55.3	0	2	136	706	750	WP_137046907.1 PAS domain S-box protein [Haloprofundus sp. MHR1]	diamond	576	55.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloprofundus	Haloprofundus sp. MHR1
30594145	30594145	PRJNA949785_P_NODE_19033_length_241_cov_0.916667_g18836_i0	PRJNA949785	19033	241	0.916667	2.20916747	Haloplanus sp.	1961696	Archaea	Archaea	71.2	6.2e-13	NR	WP_299335884.1	1961696	g18836	i0	55.6	1.81742738589212	72	32	89.6	0	226	11	102	173	WP_299335884.1 MinD/ParA family ATP-binding protein [Haloplanus sp.]	diamond	438	71.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloplanus	Haloplanus sp.
30910359	30910359	PRJNA949785_P_NODE_17534_length_245_cov_0.895349_g17337_i0	PRJNA949785	17534	245	0.895349	2.19360505	Halorubrum aidingense	368623	Archaea	Archaea	167	3.15e-48	NR	WP_007999408.1	368623	g17337	i0	96.3	0.991836734693878	81	3	99.2	0	243	1	217	297	WP_007999408.1 glycosyltransferase [Halorubrum aidingense]	diamond	243	167	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum aidingense
31415954	31415954	PRJNA949785_P_NODE_13796_length_271_cov_1.363636_g13599_i0	PRJNA949785	13796	271	1.363636	3.69545356	Methanofastidiosum sp.	2666341	Archaea	Archaea	101	2.03e-25	NR	HOG74200.1	2666341	g13599	i0	52.4	0.907749077490775	82	39	90.8	0	2	247	34	115	HOG74200.1 SLOG family protein [Methanofastidiosum sp.]	diamond	246	101	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Candidatus Methanofastidiosia	Candidatus Methanofastidiosales	Candidatus Methanofastidiosaceae	Candidatus Methanofastidiosum	Methanofastidiosum sp.
32340214	32340214	PRJNA949785_P_NODE_15019_length_256_cov_1.409836_g14822_i0	PRJNA949785	15019	256	1.409836	3.60918016	Halobacteriales	2235	Archaea	Archaea	70.1	7.53e-12	NR	WP_151114225.1	2251	g14822	i0	84.2	1.41796875	38	5	43.4	1	255	145	296	333	WP_151114225.1 MULTISPECIES: ABC transporter permease [Haloferax]	diamond	363	70.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax
32813357	32813357	PRJNA949785_P_NODE_18120_length_243_cov_1.782353_g17923_i0	PRJNA949785	18120	243	1.782353	4.33111779	Halanaeroarchaeum	1656823	Archaea	Archaea	90.5	5.49e-19	NR	MFB6070912.1	1963275	g17923	i0	74.2	1.62962962962963	66	17	81.5	0	1	198	457	522	MFB6070912.1 hydantoinase/oxoprolinase family protein [Halanaeroarchaeum sp.]	diamond	396	90.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halanaeroarchaeum	Halanaeroarchaeum sp.
32901171	32901171	PRJNA949785_P_NODE_18200_length_243_cov_0.905882_g18003_i0	PRJNA949785	18200	243	0.905882	2.20129326	Halanaeroarchaeum sulfurireducens	1604004	Archaea	Archaea	155	4.91e-45	NR	WP_050047917.1	1604004	g18003	i0	92.6	1	81	6	100	0	243	1	69	149	WP_050047917.1 tryptophan synthase subunit alpha [Halanaeroarchaeum sulfurireducens]	diamond	243	155	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halanaeroarchaeum	Halanaeroarchaeum sulfurireducens

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