metadata: contig_metadata: 26 rows where bioproject = "PRJEB75017" and tax

26 rows where bioproject = "PRJEB75017" 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
1410003	1410003	PRJEB75017_P_NODE_9222_length_298_cov_1.720000_g9093_i0	PRJEB75017	9222	298	1.72	5.1256	Methanomicrobium mobile	2205	Archaea	Archaea	167	1.57e-49	NR	WP_042706143.1	2205	g9093	i0	78.5	44.8489932885906	93	20	93.6	0	19	297	2	94	WP_042706143.1 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Methanomicrobium mobile]	diamond	13365	167	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanomicrobium	Methanomicrobium mobile
3961439	3961439	PRJEB75017_P_NODE_14804_length_251_cov_0.876404_g14675_i0	PRJEB75017	14804	251	0.876404	2.19977404	Halodesulfurarchaeum formicicum	1873524	Archaea	Archaea	213	9.86e-51	NTclustered	gi\|1082264851\|gb\|CP016070.1\|	1873524	g14675	i0	83.406	1.82470119521912	229	38	91	0	1	229	1808771	1808543	Halodesulfurarchaeum formicicum strain HTSR1 chromosome, complete genome	blastn	458	213	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halodesulfurarchaeum	Halodesulfurarchaeum formicicum
7373109	7373109	PRJEB75017_P_NODE_16226_length_247_cov_0.896552_g16097_i0	PRJEB75017	16226	247	0.896552	2.21448344	Haloarculaceae	1963268	Archaea	Archaea	95.3	3.66e-15	NTclustered	gi\|256689853\|gb\|CP001687.1\|	519442	g16097	i0	95	0.48582995951417	60	3	24	0	3	62	76142	76201	Halorhabdus utahensis DSM 12940, complete genome	blastn	120	95.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halorhabdus	Halorhabdus utahensis
10338451	10338451	PRJEB75017_P_NODE_4849_length_399_cov_1.196319_g4720_i0	PRJEB75017	4849	399	1.196319	4.77331281	uncultured marine group II/III euryarchaeote KM3_83_G03	1456522	Archaea	Archaea	65.8	4.9099999999999996e-06	NTclustered	gi\|663528601\|gb\|KF901116.1\|	1456522	g4720	i0	91.489	0.228070175438596	47	4	13	0	173	219	29837	29883	Uncultured marine group II/III euryarchaeote KM3_83_G03 genomic sequence	blastn	91	65.8	1	Archaea		Methanobacteriati	Methanobacteriota					uncultured marine group II/III euryarchaeote KM3_83_G03
16712037	16712037	PRJEB75017_P_NODE_16934_length_245_cov_1.691860_g16805_i0	PRJEB75017	16934	245	1.69186	4.145057	Halorientalis litorea	2931977	Archaea	Archaea	448	2.41e-121	NTclustered	gi\|2225350820\|gb\|CP095484.1\|	2931977	g16805	i0	99.592	4.58367346938776	245	1	100	0	1	245	103780	103536	Halorientalis litorea strain ZY14 plasmid unnamed2, complete sequence	blastn	1123	448	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halorientalis	Halorientalis litorea
16712041	16712041	PRJEB75017_P_NODE_17454_length_244_cov_0.912281_g17325_i0	PRJEB75017	17454	244	0.912281	2.22596564	Halococcus dombrowskii	179637	Archaea	Archaea	357	4.16e-94	NTclustered	gi\|2221492587\|gb\|CP095006.1\|	179637	g17325	i0	93.033	18.75	244	17	100	0	1	244	87209	87452	Halococcus dombrowskii strain H4 plasmid unnamed1, complete sequence	blastn	4575	357	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus dombrowskii
17573462	17573462	PRJEB75017_P_NODE_10794_length_281_cov_1.418269_g10665_i0	PRJEB75017	10794	281	1.418269	3.98533589	Haladaptatus	367188	Archaea	Archaea	86.1	2.55e-12	NTclustered	gi\|2471356508\|gb\|CP120470.1\|	3032580	g10665	i0	82.353	2.97864768683274	102	15	36	3	55	155	483812	483911	Haladaptatus sp. DYSN1 chromosome, complete genome	blastn	837	86.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Haladaptatus	Haladaptatus sp. DYSN1
17986898	17986898	PRJEB75017_P_NODE_12995_length_260_cov_1.160428_g12866_i0	PRJEB75017	12995	260	1.160428	3.0171128	Haladaptatus salinisoli	2884876	Archaea	Archaea	52.8	0.024	NTclustered	gi\|2124061132\|gb\|CP085327.1\|	2884876	g12866	i0	100	0.107692307692308	28	0	11	0	166	193	669348	669375	Haladaptatus salinisoli strain PSR8 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Haladaptatus	Haladaptatus salinisoli
17986908	17986908	PRJEB75017_P_NODE_13855_length_253_cov_0.866667_g13726_i0	PRJEB75017	13855	253	0.866667	2.19266751	Natronomonas moolapensis	416273	Archaea	Archaea	318	2.05e-82	NTclustered	gi\|452081962\|emb\|HF582854.1\|	268739	g13726	i0	89.328	4.96837944664032	253	27	100	0	1	253	2901233	2900981	Natronomonas moolapensis 8.8.11 complete genome	blastn	1257	318	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas moolapensis
21812120	21812120	PRJEB75017_P_NODE_17178_length_245_cov_0.906977_g17049_i0	PRJEB75017	17178	245	0.906977	2.22209365	Natronomonas marina	2961939	Archaea	Archaea	309	1.19e-79	NTclustered	gi\|2273574514\|gb\|CP101154.1\|	2961939	g17049	i0	89.388	62.0285714285714	245	26	100	0	1	245	2087217	2087461	Natronomonas marina strain ZY43 chromosome, complete genome	blastn	15197	309	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas marina
26868915	26868915	PRJEB75017_P_NODE_9261_length_298_cov_1.040000_g9132_i0	PRJEB75017	9261	298	1.04	3.0992	root	1	Root_unresolved	Root_unresolved	45.8	0.00436	NR	MCK4948533.1	1906666	g9132	i0	38.7	1.28859060402685	62	38	62.4	0	194	9	63	124	MCK4948533.1 heme ABC exporter ATP-binding protein CcmA [Thermoplasmata archaeon]	diamond	384	45.8	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
26876210	26876210	PRJEB75017_P_NODE_11641_length_273_cov_1.170000_g11512_i0	PRJEB75017	11641	273	1.17	3.1941	Halorubrum sp. AJ67	1173487	Archaea	Archaea	51.2	7.16e-6	NR	WP_048075940.1	1173487	g11512	i0	50	0.417582417582418	38	19	41.8	0	206	93	59	96	WP_048075940.1 hypothetical protein [Halorubrum sp. AJ67]	diamond	114	51.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. AJ67
27002302	27002302	PRJEB75017_P_NODE_14522_length_251_cov_1.522472_g14393_i0	PRJEB75017	14522	251	1.522472	3.82140472	Haloferacaceae archaeon	2080321	Archaea	Archaea	90.9	4.75e-19	NR	MDR9411911.1	2080321	g14393	i0	54.1	1.01593625498008	85	37	99.2	1	2	250	721	805	MDR9411911.1 hypothetical protein [Haloferacaceae archaeon]	diamond	255	90.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae		Haloferacaceae archaeon
27128539	27128539	PRJEB75017_P_NODE_16462_length_247_cov_0.867816_g16333_i0	PRJEB75017	16462	247	0.867816	2.14350552	Halodesulfurarchaeum sp.	1980530	Archaea	Archaea	128	1.3e-35	NR	MFP4530828.1	1980530	g16333	i0	76.8	1.9919028340081	82	18	98.4	1	245	3	30	111	MFP4530828.1 cob(I)yrinic acid a,c-diamide adenosyltransferase [Halodesulfurarchaeum sp.]	diamond	492	128	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halodesulfurarchaeum	Halodesulfurarchaeum sp.
27508316	27508316	PRJEB75017_P_NODE_13323_length_256_cov_1.989071_g13194_i0	PRJEB75017	13323	256	1.989071	5.09202176	Thermoplasmatota archaeon	2806419	Archaea	Archaea	94.7	1.88e-20	NR	HET6405799.1	2806419	g13194	i0	55.4	0.97265625	83	37	97.3	0	251	3	1	83	HET6405799.1 malate synthase A [Thermoplasmatota archaeon]	diamond	249	94.7	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
27918510	27918510	PRJEB75017_P_NODE_16625_length_246_cov_0.901734_g16496_i0	PRJEB75017	16625	246	0.901734	2.21826564	Halanaeroarchaeum sp.	1963275	Archaea	Archaea	120	2.21e-29	NR	MFB6132002.1	1963275	g16496	i0	73.8	1.96341463414634	80	21	97.6	0	6	245	155	234	MFB6132002.1 secretion system protein [Halanaeroarchaeum sp.]	diamond	483	120	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halanaeroarchaeum	Halanaeroarchaeum sp.
28234066	28234066	PRJEB75017_P_NODE_14826_length_251_cov_0.876404_g14697_i0	PRJEB75017	14826	251	0.876404	2.19977404	Halobacteriaceae archaeon GCM10025711	3252693	Archaea	Archaea	111	5.67e-27	NR	MFC7046887.1	3252693	g14697	i0	63.9	0.99203187250996006	83	30	99.2	0	2	250	220	302	MFC7046887.1 ABC transporter substrate-binding protein [Halobacteriaceae archaeon GCM10025711]	diamond	249	111	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae		Halobacteriaceae archaeon GCM10025711
28581816	28581816	PRJEB75017_P_NODE_16747_length_246_cov_0.901734_g16618_i0	PRJEB75017	16747	246	0.901734	2.21826564	Halanaeroarchaeum sp.	1963275	Archaea	Archaea	82.4	4.11e-16	NR	MFB6070285.1	1963275	g16618	i0	87	0.560975609756098	46	6	56.1	0	139	2	1	46	MFB6070285.1 helix-turn-helix domain-containing protein [Halanaeroarchaeum sp.]	diamond	138	82.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halanaeroarchaeum	Halanaeroarchaeum sp.
28834221	28834221	PRJEB75017_P_NODE_16388_length_247_cov_0.896552_g16259_i0	PRJEB75017	16388	247	0.896552	2.21448344	Halorubrum sp. ASP1	2518114	Archaea	Archaea	97.4	3.03e-22	NR	WP_137711550.1	2518114	g16259	i0	55.7	0.959514170040486	79	35	96	0	10	246	64	142	WP_137711550.1 class I SAM-dependent methyltransferase [Halorubrum sp. ASP1]	diamond	237	97.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. ASP1
28992426	28992426	PRJEB75017_P_NODE_14328_length_252_cov_0.871508_g14199_i0	PRJEB75017	14328	252	0.871508	2.19620016	Haloarculaceae archaeon H-GB1-1	3037652	Archaea	Archaea	99.8	3.65e-22	NR	MDG5778880.1	3037652	g14199	i0	61.4	4.92857142857143	83	32	98.8	0	3	251	511	593	MDG5778880.1 PAS domain S-box protein [Haloarculaceae archaeon H-GB1-1]	diamond	1242	99.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae		Haloarculaceae archaeon H-GB1-1
29465339	29465339	PRJEB75017_P_NODE_15630_length_249_cov_0.886364_g15501_i0	PRJEB75017	15630	249	0.886364	2.20704636	Halegenticoccus tardaugens	2071624	Archaea	Archaea	115	2.08e-28	NR	WP_129115518.1	2071624	g15501	i0	88.3	0.72289156626506	60	7	72.3	0	69	248	1	60	WP_129115518.1 sulfatase-like hydrolase/transferase [Halegenticoccus tardaugens]	diamond	180	115	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halegenticoccus	Halegenticoccus tardaugens
29876317	29876317	PRJEB75017_P_NODE_6211_length_355_cov_1.120567_g6082_i0	PRJEB75017	6211	355	1.120567	3.97801285	Methanobacteriota archaeon	2026739	Archaea	Archaea	45.1	0.0212	NR	MAE79210.1	2026739	g6082	i0	34.9	0.726760563380282	86	50	71	3	255	4	873	954	MAE79210.1 hypothetical protein [Methanobacteriota archaeon]	diamond	258	45.1	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
30824047	30824047	PRJEB75017_P_NODE_17594_length_244_cov_0.912281_g17465_i0	PRJEB75017	17594	244	0.912281	2.22596564	Halomicrococcus gelatinilyticus	1702103	Archaea	Archaea	149	1.08e-41	NR	WP_327053555.1	1702103	g17465	i0	82.7	0.995901639344262	81	14	99.6	0	243	1	184	264	WP_327053555.1 ABC transporter substrate-binding protein [Halomicrococcus gelatinilyticus]	diamond	243	149	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Halomicrococcus	Halomicrococcus gelatinilyticus
31519640	31519640	PRJEB75017_P_NODE_15776_length_248_cov_0.891429_g15647_i0	PRJEB75017	15776	248	0.891429	2.21074392	Halococcus sp. PRR34	3020830	Archaea	Archaea	105	3.24e-24	NR	WP_273837821.1	3020830	g15647	i0	62.5	1.06451612903226	88	25	96.8	3	2	241	582	669	WP_273837821.1 HNH endonuclease [Halococcus sp. PRR34]	diamond	264	105	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus sp. PRR34
31607158	31607158	PRJEB75017_P_NODE_12116_length_268_cov_1.558974_g11987_i0	PRJEB75017	12116	268	1.558974	4.17805032	root	1	Root_unresolved	Root_unresolved	75.1	1.06e-13	NR	WP_010867902.1	29292	g11987	i0	42.2	9.03358208955224	90	50	98.5	1	267	4	155	244	WP_010867902.1 ABC transporter ATP-binding protein [Pyrococcus abyssi]	diamond	2421	75.1	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus abyssi
32595122	32595122	PRJEB75017_P_NODE_12040_length_269_cov_1.255102_g11911_i0	PRJEB75017	12040	269	1.255102	3.37622438	Halobacterium	2239	Archaea	Archaea	42.7	0.0205	NR	WP_059056727.1	2239	g11911	i0	44.4	0.50185873605948	45	22	46.8	1	142	267	3	47	WP_059056727.1 MULTISPECIES: hypothetical protein [Halobacterium]	diamond	135	42.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halobacterium

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