metadata: contig_metadata: 18 rows where bioproject = "PRJNA756891" and tax

18 rows where bioproject = "PRJNA756891" 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
7110678	7110678	PRJNA756891_P_NODE_12466_length_250_cov_0.870056_g12397_i0	PRJNA756891	12466	250	0.870056	2.17514	Halalkalicoccus jeotgali	413810	Archaea	Archaea	307	4.3800000000000005e-79	NTclustered	gi\|299126090\|gb\|CP002063.1\|	795797	g12397	i0	89.669	2.84	242	23	96	2	1	241	310566	310326	Halalkalicoccus jeotgali B3 plasmid 1, complete sequence	blastn	710	307	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus jeotgali
27779618	27779618	PRJNA756891_P_NODE_2404_length_537_cov_1.816810_g2336_i0	PRJNA756891	2404	537	1.81681	9.7562697	Candidatus Sysuiplasma superficiale	2823368	Archaea	Archaea	61.2	2.36e-7	NR	MBX8644801.1	2823368	g2336	i0	31	0.558659217877095	100	68	55.3	1	240	536	247	346	MBX8644801.1 hypothetical protein [Candidatus Sysuiplasma superficiale]	diamond	300	61.2	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Candidatus Sysuiplasmatales	Candidatus Sysuiplasmataceae	Candidatus Sysuiplasma	Candidatus Sysuiplasma superficiale
27915479	27915479	PRJNA756891_P_NODE_16425_length_241_cov_0.916667_g16356_i0	PRJNA756891	16425	241	0.916667	2.20916747	Methanolobus	2220	Archaea	Archaea	42.7	0.0208	NR	WP_209616198.1	38023	g16356	i0	48.8	0.933609958506224	41	19	48.5	1	219	103	61	101	WP_209616198.1 META domain-containing protein [Methanolobus bombayensis]	diamond	225	42.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanolobus	Methanolobus bombayensis
28000723	28000723	PRJNA756891_P_NODE_5945_length_349_cov_2.032609_g5876_i0	PRJNA756891	5945	349	2.032609	7.09380541	uncultured Methanoregula sp.	1005933	Archaea	Archaea	43.9	0.0234	NR	WP_320160266.1	1005933	g5876	i0	34	0.833810888252149	97	58	82.5	3	293	6	61	152	WP_320160266.1 hypothetical protein [uncultured Methanoregula sp.]	diamond	291	43.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	uncultured Methanoregula sp.
28474177	28474177	PRJNA756891_P_NODE_5486_length_362_cov_2.128028_g5417_i0	PRJNA756891	5486	362	2.128028	7.70346136	Thermoplasmata archaeon	1906666	Archaea	Archaea	45.1	0.0166	NR	HYB78508.1	1906666	g5417	i0	30.9	0.803867403314917	97	61	75.4	3	89	361	119	215	HYB78508.1 hypothetical protein [Thermoplasmata archaeon]	diamond	291	45.1	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
29074213	29074213	PRJNA756891_P_NODE_15528_length_243_cov_0.905882_g15459_i0	PRJNA756891	15528	243	0.905882	2.20129326	Methanobacteriota archaeon	2026739	Archaea	Archaea	64.3	9e-10	NR	RMG33649.1	2026739	g15459	i0	43.5	2.39506172839506	69	36	81.5	1	8	205	354	422	RMG33649.1 MAG: hypothetical protein D6732_11770 [Methanobacteriota archaeon]	diamond	582	64.3	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
29147366	29147366	PRJNA756891_P_NODE_3429_length_452_cov_1.218997_g3361_i0	PRJNA756891	3429	452	1.218997	5.50986644	root	1	Root_unresolved	Root_unresolved	140	6.58e-36	NR	MDP6640595.1	2666346	g3361	i0	45.8	6.25884955752212	153	75	99.6	3	451	2	210	357	MDP6640595.1 CTP synthase (glutamine hydrolyzing) [Candidatus Poseidoniaceae archaeon]	diamond	2829	141	0.99290780141844	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniaceae		Candidatus Poseidoniaceae archaeon
30442047	30442047	PRJNA756891_P_NODE_5913_length_350_cov_1.581227_g5844_i0	PRJNA756891	5913	350	1.581227	5.5342945	root	1	Root_unresolved	Root_unresolved	68.2	3.15e-11	NR	WP_114450628.1	1126245	g5844	i0	36.3	3.47142857142857	102	59	87.4	2	340	35	56	151	WP_114450628.1 DUF4397 domain-containing protein [Haloplanus salinus]	diamond	1215	68.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloplanus	Haloplanus salinus
30558247	30558247	PRJNA756891_P_NODE_2073_length_577_cov_1.240079_g2006_i0	PRJNA756891	2073	577	1.240079	7.15525583	Methanobacteriota archaeon	2026739	Archaea	Archaea	68.6	1.02e-9	NR	RMG33649.1	2026739	g2006	i0	25.7	0.790294627383016	152	103	77.5	3	119	565	202	346	RMG33649.1 MAG: hypothetical protein D6732_11770 [Methanobacteriota archaeon]	diamond	456	68.6	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
30621514	30621514	PRJNA756891_P_NODE_12213_length_251_cov_0.865169_g12144_i0	PRJNA756891	12213	251	0.865169	2.17157419	Methanoregulaceae archaeon	2485498	Archaea	Archaea	44.7	0.00336	NR	HTY15773.1	2485498	g12144	i0	33.8	0.920318725099602	77	50	90.8	1	19	246	47	123	HTY15773.1 hypothetical protein [Methanoregulaceae archaeon]	diamond	231	44.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		Methanoregulaceae archaeon
30748068	30748068	PRJNA756891_P_NODE_13574_length_248_cov_0.880000_g13505_i0	PRJNA756891	13574	248	0.88	2.1824	Halobacteriales archaeon	1904752	Archaea	Archaea	42.7	0.0384	NR	HKJ58101.1	1904752	g13505	i0	32.9	0.846774193548387	70	42	82.3	2	36	239	89	155	HKJ58101.1 NUDIX domain-containing protein [Halobacteriales archaeon]	diamond	210	42.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			Halobacteriales archaeon
31042581	31042581	PRJNA756891_P_NODE_12195_length_251_cov_0.865169_g12126_i0	PRJNA756891	12195	251	0.865169	2.17157419	Methanolobus	2220	Archaea	Archaea	50.1	7.87e-5	NR	WP_169729092.1	2221	g12126	i0	37.5	3.68127490039841	80	49	95.6	1	241	2	22	100	WP_169729092.1 tetratricopeptide repeat protein [Methanolobus tindarius]	diamond	924	50.4	0.994047619047619	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanolobus	Methanolobus tindarius
31073888	31073888	PRJNA756891_P_NODE_1175_length_743_cov_2.343284_g1112_i0	PRJNA756891	1175	743	2.343284	17.41060012	root	1	Root_unresolved	Root_unresolved	47.8	0.00635	NR	OYT28433.1	2012525	g1112	i0	27.9	1.70390309555855	104	71	41.2	3	380	685	45	146	OYT28433.1 MAG: hypothetical protein B6U98_05060 [Thermoplasmatales archaeon ex4572_165]	diamond	1266	47.8	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales			Thermoplasmatales archaeon ex4572_165
31506880	31506880	PRJNA756891_P_NODE_6456_length_337_cov_0.875000_g6387_i0	PRJNA756891	6456	337	0.875	2.94875	Methanobacteriota archaeon	2026739	Archaea	Archaea	55.1	5.09e-6	NR	RMG33649.1	2026739	g6387	i0	32.5	1.01483679525223	114	72	97.9	3	1	330	288	400	RMG33649.1 MAG: hypothetical protein D6732_11770 [Methanobacteriota archaeon]	diamond	342	55.1	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
31800973	31800973	PRJNA756891_P_NODE_6477_length_336_cov_1.171103_g6408_i0	PRJNA756891	6477	336	1.171103	3.93490608	Archaea	2157	Archaea	Archaea	55.5	1.57e-6	NR	WP_052358743.1	2234	g6408	i0	27.7	3.375	94	67	83	1	323	45	102	195	WP_052358743.1 PD-(D/E)XK nuclease family protein [Archaeoglobus fulgidus]	diamond	1134	55.5	1	Archaea		Methanobacteriati	Methanobacteriota	Archaeoglobi	Archaeoglobales	Archaeoglobaceae	Archaeoglobus	Archaeoglobus fulgidus
31854510	31854510	PRJNA756891_P_NODE_1617_length_646_cov_2.926702_g1552_i0	PRJNA756891	1617	646	2.926702	18.90649492	Methanobrevibacter millerae	230361	Archaea	Archaea	57.4	1.35e-5	NR	WP_303737944.1	230361	g1552	i0	32	0.784829721362229	169	93	74.8	7	516	34	884	1038	WP_303737944.1 hypothetical protein, partial [Methanobrevibacter millerae]	diamond	507	57.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter millerae
32708142	32708142	PRJNA756891_P_NODE_20_length_3023_cov_3.889492_g18_i0	PRJNA756891	20	3023	3.889492	117.57934316	Methanobacteriota archaeon	2026739	Archaea	Archaea	151	2.22e-34	NR	RMG33649.1	2026739	g18	i0	31.5	0.384055573933179	387	241	37.2	10	2322	1198	109	483	RMG33649.1 MAG: hypothetical protein D6732_11770 [Methanobacteriota archaeon]	diamond	1161	151	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
32802549	32802549	PRJNA756891_P_NODE_11520_length_257_cov_2.510870_g11451_i0	PRJNA756891	11520	257	2.51087	6.4529359	Halorubellus salinus	755309	Archaea	Archaea	43.9	0.00792	NR	WP_227133082.1	755309	g11451	i0	45	0.466926070038911	40	22	46.7	0	7	126	1	40	WP_227133082.1 universal stress protein [Halorubellus salinus]	diamond	120	43.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halorubellaceae	Halorubellus	Halorubellus salinus

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