metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA983848" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA983848" 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
2241807	2241807	PRJNA983848_P_NODE_111382_length_285_cov_1.443396_g105499_i0	PRJNA983848	111382	285	1.443396	4.1136786	Natronomonas moolapensis	416273	Archaea	Archaea	244	4.05e-60	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g105499	i0	82.292	1.01052631578947	288	45	100	6	1	285	2739027	2738743	Natronomonas moolapensis 8.8.11 complete genome	blastn	288	244	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
3518303	3518303	PRJNA983848_P_NODE_145543_length_249_cov_0.886364_g139660_i0	PRJNA983848	145543	249	0.886364	2.20704636	Halorientalis sp. IM1011	1932360	Archaea	Archaea	172	1.66e-38	NTclustered	gi\|1142895524\|gb\|CP019067.1\|	1932360	g139660	i0	82.812	2.52610441767068	192	33	77	0	33	224	1978375	1978566	Halorientalis sp. IM1011 chromosome, complete genome	blastn	629	172	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halorientalis	Halorientalis sp. IM1011
4795505	4795505	PRJNA983848_P_NODE_140344_length_252_cov_0.871508_g134461_i0	PRJNA983848	140344	252	0.871508	2.19620016	Natronorarus salvus	3117733	Archaea	Archaea	93.5	1.35e-14	NTclustered	gi\|2670420129\|gb\|CP144125.1\|	3117733	g134461	i0	90.141	0.281746031746032	71	7	28	0	155	225	668053	668123	Natronorarus salvus strain CGA53 chromosome, complete genome	blastn	71	93.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halalkalicoccaceae	Natronorarus	Natronorarus salvus
4799191	4799191	PRJNA983848_P_NODE_94124_length_314_cov_1.004149_g88241_i0	PRJNA983848	94124	314	1.004149	3.15302786	Halobellus inordinatus	1126236	Archaea	Archaea	427	4.18e-115	NTclustered	gi\|2279714124\|gb\|CP101826.1\|	1126236	g88241	i0	95.833	30.359872611465	264	11	84	0	51	314	8887	9150	Halobellus inordinatus strain DSM 26177 plasmid unnamed1, complete sequence	blastn	9533	427	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobellus	Halobellus inordinatus
5099813	5099813	PRJNA983848_P_NODE_151304_length_246_cov_1.023121_g145421_i0	PRJNA983848	151304	246	1.023121	2.51687766	Halorubrum	56688	Archaea	Archaea	220	5.76e-53	NTclustered	gi\|1565814486\|gb\|CP034940.1\|	337243	g145421	i0	83.475	73.5487804878049	236	39	96	0	8	243	3017542	3017777	Halorubrum ezzemoulense strain Fb21 chromosome, complete genome	blastn	18093	220	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum ezzemoulense
6071071	6071071	PRJNA983848_P_NODE_148225_length_248_cov_0.891429_g142342_i0	PRJNA983848	148225	248	0.891429	2.21074392	Halobellus inordinatus	1126236	Archaea	Archaea	87.9	6.15e-13	NTclustered	gi\|2279714123\|gb\|CP101825.1\|	1126236	g142342	i0	90.769	0.758064516129032	65	6	26	0	184	248	1314529	1314593	Halobellus inordinatus strain DSM 26177 chromosome, complete genome	blastn	188	87.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobellus	Halobellus inordinatus
7649620	7649620	PRJNA983848_P_NODE_71666_length_372_cov_1.896321_g65783_i0	PRJNA983848	71666	372	1.896321	7.05431412	Haloferacaceae	1644056	Archaea	Archaea	403	8.48e-108	NTclustered	gi\|2176096791\|gb\|CP090373.1\|	2904243	g65783	i0	86.364	9.37365591397849	374	45	99	6	1	371	15282	15652	Halobaculum sp. CBA1158 plasmid pCBA1158-2, complete sequence	blastn	3487	403	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobaculum	Halobaculum sp. CBA1158
8620172	8620172	PRJNA983848_P_NODE_129607_length_262_cov_1.380952_g123724_i0	PRJNA983848	129607	262	1.380952	3.61809424	Halorarius halobius	2962671	Archaea	Archaea	111	3.89e-20	NTclustered	gi\|2273560674\|gb\|CP101161.1\|	2962671	g123724	i0	90.476	6.4618320610687	84	8	32	0	179	262	2695730	2695647	Halorarius halobius strain ZY10 chromosome, complete genome	blastn	1693	111	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Halorarius	Halorarius halobius
9899393	9899393	PRJNA983848_P_NODE_92088_length_318_cov_1.171429_g86205_i0	PRJNA983848	92088	318	1.171429	3.72514422	Natronomonas moolapensis	416273	Archaea	Archaea	372	2.0099999999999998e-98	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g86205	i0	87.736	4.49685534591195	318	39	100	0	1	318	1029496	1029179	Natronomonas moolapensis 8.8.11 complete genome	blastn	1430	372	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
14995652	14995652	PRJNA983848_P_NODE_145472_length_249_cov_0.886364_g139589_i0	PRJNA983848	145472	249	0.886364	2.20704636	haloarchaeon 3A1-DGR	1071085	Archaea	Archaea	231	2.7e-56	NTclustered	gi\|1804090075\|gb\|CP048032.1\|	1071085	g139589	i0	94.667	1.13654618473896	150	7	60	1	101	249	782455	782604	Haloarchaeon 3A1-DGR strain 3A1-DGR chromosome, complete genome	blastn	283	231	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			haloarchaeon 3A1-DGR
16270726	16270726	PRJNA983848_P_NODE_149353_length_247_cov_0.896552_g143470_i0	PRJNA983848	149353	247	0.896552	2.21448344	Natronomonas moolapensis	416273	Archaea	Archaea	209	1.25e-49	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g143470	i0	90.184	20.0607287449393	163	12	93	3	87	247	2537778	2537938	Natronomonas moolapensis 8.8.11 complete genome	blastn	4955	209	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
16270794	16270794	PRJNA983848_P_NODE_151433_length_246_cov_0.901734_g145550_i0	PRJNA983848	151433	246	0.901734	2.21826564	Halodesulfurarchaeum formicicum	1873524	Archaea	Archaea	211	3.46e-50	NTclustered	gi\|1082264851\|gb\|CP016070.1\|	1873524	g145550	i0	82.377	2.9349593495935	244	41	99	2	3	245	769263	769021	Halodesulfurarchaeum formicicum strain HTSR1 chromosome, complete genome	blastn	722	211	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halodesulfurarchaeum	Halodesulfurarchaeum formicicum
16274324	16274324	PRJNA983848_P_NODE_98673_length_305_cov_1.775862_g92790_i0	PRJNA983848	98673	305	1.775862	5.4163791	Natronomonas moolapensis	416273	Archaea	Archaea	313	1.18e-80	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g92790	i0	85.811	21.3377049180328	296	40	97	2	1	295	1268081	1268375	Natronomonas moolapensis 8.8.11 complete genome	blastn	6508	313	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
17545635	17545635	PRJNA983848_P_NODE_146274_length_249_cov_0.875000_g140391_i0	PRJNA983848	146274	249	0.875	2.17875	Natronomonas moolapensis	416273	Archaea	Archaea	165	2.77e-36	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g140391	i0	84.795	1.38955823293173	171	18	67	7	6	172	1388742	1388908	Natronomonas moolapensis 8.8.11 complete genome	blastn	346	165	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
18819526	18819526	PRJNA983848_P_NODE_147995_length_248_cov_0.891429_g142112_i0	PRJNA983848	147995	248	0.891429	2.21074392	Natronomonas marina	2961939	Archaea	Archaea	80.5	1.03e-10	NTclustered	gi\|2273574514\|gb\|CP101154.1\|	2961939	g142112	i0	94.231	1.77822580645161	52	3	21	0	1	52	148366	148315	Natronomonas marina strain ZY43 chromosome, complete genome	blastn	441	80.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas marina
19122863	19122863	PRJNA983848_P_NODE_154295_length_245_cov_0.906977_g148412_i0	PRJNA983848	154295	245	0.906977	2.22209365	Halorubrum	56688	Archaea	Archaea	154	5.89e-33	NTclustered	gi\|1041620700\|dbj\|AP017569.1\|	29284	g148412	i0	90.598	18.3265306122449	117	9	47	2	1	116	1872799	1872914	Halorubrum trapanicum DNA, complete genome, strain: CBA1232	blastn	4490	154	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum trapanicum
21673864	21673864	PRJNA983848_P_NODE_149837_length_247_cov_0.896552_g143954_i0	PRJNA983848	149837	247	0.896552	2.21448344	Haloarcula	2237	Archaea	Archaea	154	5.95e-33	NTclustered	gi\|343781660\|gb\|CP002921.1\|	634497	g143954	i0	96.739	4.85425101214575	92	3	37	0	156	247	1967975	1968066	Haloarcula hispanica ATCC 33960 chromosome I, complete sequence	blastn	1199	154	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Haloarcula	Haloarcula hispanica
22644775	22644775	PRJNA983848_P_NODE_143558_length_250_cov_0.881356_g137675_i0	PRJNA983848	143558	250	0.881356	2.20339	haloarchaeon 3A1-DGR	1071085	Archaea	Archaea	399	7.019999999999998e-107	NTclustered	gi\|1804090075\|gb\|CP048032.1\|	1071085	g137675	i0	95.935	5.088	246	10	98	0	5	250	2356733	2356488	Haloarchaeon 3A1-DGR strain 3A1-DGR chromosome, complete genome	blastn	1272	399	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			haloarchaeon 3A1-DGR
25194123	25194123	PRJNA983848_P_NODE_152220_length_246_cov_0.901734_g146337_i0	PRJNA983848	152220	246	0.901734	2.21826564	Natrononativus amylolyticus	2963434	Archaea	Archaea	204	5.799999999999998e-48	NTclustered	gi\|2274417431\|gb\|CP101458.1\|	2963434	g146337	i0	81.855	24.1788617886179	248	39	99	6	2	246	1826778	1826534	Natrononativus amylolyticus strain CGA73 chromosome, complete genome	blastn	5948	204	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrononativus	Natrononativus amylolyticus
25194308	25194308	PRJNA983848_P_NODE_157680_length_243_cov_0.917647_g151797_i0	PRJNA983848	157680	243	0.917647	2.22988221	Haloplanus salinarum	1912324	Archaea	Archaea	427	3.11e-115	NTclustered	gi\|2279709463\|gb\|CP101823.1\|	1912324	g151797	i0	98.354	3.87242798353909	243	4	100	0	1	243	2155116	2154874	Haloplanus salinarum strain JCM 31424 chromosome, complete genome	blastn	941	427	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloplanus	Haloplanus salinarum
25194408	25194408	PRJNA983848_P_NODE_160560_length_242_cov_0.923077_g154677_i0	PRJNA983848	160560	242	0.923077	2.23384634	Haloterrigena salinisoli	3132747	Archaea	Archaea	261	3.33e-65	NTclustered	gi\|2706837818\|gb\|CP149787.1\|	3132747	g154677	i0	86.307	6.8595041322314	241	31	99	2	3	242	3722700	3722461	Haloterrigena salinisoli strain KLK7 chromosome, complete genome	blastn	1660	261	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Haloterrigena	Haloterrigena salinisoli

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