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

22 rows where bioproject = "PRJNA533623" 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
4333204	4333204	PRJNA533623_P_NODE_29744_length_416_cov_9.859155_g27974_i0	PRJNA533623	29744	416	9.859155	41.0140848	Halococcus qingdaonensis	224402	Archaea	Archaea	691	0	NTclustered	gi\|2281256326\|gb\|CP101943.1\|	224402	g27974	i0	98.966	1.90384615384615	387	2	93	2	8	394	2477290	2477674	Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome	blastn	792	691	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus qingdaonensis
5609693	5609693	PRJNA533623_P_NODE_15605_length_597_cov_9.809701_g13894_i0	PRJNA533623	15605	597	9.809701	58.56391497	Salinirubellus litoreus	3131999	Archaea	Archaea	54.7	0.016	NTclustered	gi\|2700494409\|gb\|CP147841.1\|	3131999	g13894	i0	100	0.0485762144053601	29	0	5	0	483	511	2445208	2445236	Salinirubellus litoreus strain SYNS196 chromosome, complete genome	blastn	29	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Salinirubellus	Salinirubellus litoreus
7496058	7496058	PRJNA533623_P_NODE_45586_length_315_cov_3.913386_g43810_i0	PRJNA533623	45586	315	3.913386	12.3271659	Methanothrix	2222	Archaea	Archaea	505	1.8799999999999995e-138	NTclustered	gi\|2133328945\|gb\|CP086219.1\|	90426	g43810	i0	99.283	1.77142857142857	279	2	89	0	14	292	1633763	1633485	MAG: Methanothrix sp. isolate MAG 281 chromosome	blastn	558	505	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
8158758	8158758	PRJNA533623_P_NODE_15707_length_595_cov_8.595506_g13996_i0	PRJNA533623	15707	595	8.595506	51.1432607	Haloferax sp. S1W	3377110	Archaea	Archaea	84.2	2.09e-11	NTclustered	gi\|2845109985\|gb\|CP172595.1\|	3377110	g13996	i0	90.476	0.105882352941176	63	6	11	0	481	543	648036	648098	Haloferax sp. S1W chromosome, complete genome	blastn	63	84.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax sp. S1W
20908970	20908970	PRJNA533623_P_NODE_60997_length_250_cov_4.238095_g59217_i0	PRJNA533623	60997	250	4.238095	10.5952375	Halobaculum halobium	3032281	Archaea	Archaea	176	1.2899999999999999e-39	NTclustered	gi\|2511738011\|gb\|CP126159.1\|	3032281	g59217	i0	83	11.928	200	28	79	4	13	209	286422	286618	Halobaculum halobium strain SYNS20 plasmid unnamed1, complete sequence	blastn	2982	176	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobaculum	Halobaculum halobium
23458534	23458534	PRJNA533623_P_NODE_32619_length_393_cov_6.228916_g30848_i0	PRJNA533623	32619	393	6.228916	24.47963988	Methanobacterium sp. ACI-7	3240853	Archaea	Archaea	66.2	1.28e-11	NR	WP_414469398.1	3240853	g30848	i0	51.7	0.458015267175573	60	28	45.8	1	114	293	4	62	WP_414469398.1 YwbE family protein [Methanobacterium sp. ACI-7]	diamond	180	66.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp. ACI-7
27520112	27520112	PRJNA533623_P_NODE_15183_length_605_cov_4.143382_g13480_i0	PRJNA533623	15183	605	4.143382	25.0674611	Methanosarcina sp.	2213	Archaea	Archaea	90.9	8.09e-20	NR	HET8689612.1	2213	g13480	i0	43.7	0.510743801652893	103	55	51.1	1	360	52	9	108	HET8689612.1 hypothetical protein [Methanosarcina sp.]	diamond	309	90.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
28246113	28246113	PRJNA533623_P_NODE_21646_length_499_cov_12.646119_g19896_i0	PRJNA533623	21646	499	12.646119	63.10413381	Methanobacteriota archaeon	2026739	Archaea	Archaea	108	7.7e-24	NR	MAI40379.1	2026739	g19896	i0	55.8	1.81563126252505	77	34	46.3	0	484	254	524	600	MAI40379.1 ribonucleoside-triphosphate reductase [Methanobacteriota archaeon]	diamond	906	108	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
28814377	28814377	PRJNA533623_P_NODE_21268_length_504_cov_18.040632_g19520_i0	PRJNA533623	21268	504	18.040632	90.92478528	Natrinema amylolyticum	2878679	Archaea	Archaea	171	1.16e-50	NR	WP_226482782.1	2878679	g19520	i0	81.1	1.32142857142857	111	21	66.1	0	165	497	1	111	WP_226482782.1 bifunctional 4-hydroxy-2-oxoglutarate aldolase/2-dehydro-3-deoxy-phosphogluconate aldolase [Natrinema amylolyticum]	diamond	666	171	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema amylolyticum
28846063	28846063	PRJNA533623_P_NODE_39268_length_349_cov_4.375000_g37494_i0	PRJNA533623	39268	349	4.375	15.26875	Methanobacteriaceae archaeon	2099680	Archaea	Archaea	166	4.69e-45	NR	NYB27335.1	2099680	g37494	i0	97.6	0.722063037249284	84	2	72.2	0	2	253	970	1053	NYB27335.1 isoleucine--tRNA ligase [Methanobacteriaceae archaeon]	diamond	252	166	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		Methanobacteriaceae archaeon
28846075	28846075	PRJNA533623_P_NODE_64228_length_239_cov_1.460674_g62447_i0	PRJNA533623	64228	239	1.460674	3.49101086	Methanobacteriaceae archaeon	2099680	Archaea	Archaea	155	4.0599999999999986e-43	NR	NYB27229.1	2099680	g62447	i0	96.2	0.99163179916318	79	3	99.2	0	239	3	308	386	NYB27229.1 2-isopropylmalate synthase [Methanobacteriaceae archaeon]	diamond	237	155	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		Methanobacteriaceae archaeon
29098905	29098905	PRJNA533623_P_NODE_78228_length_197_cov_5.764706_g76447_i0	PRJNA533623	78228	197	5.764706	11.35647082	Methanobacteriota archaeon	2026739	Archaea	Archaea	103	5.63e-24	NR	MAV44562.1	2026739	g76447	i0	79.3	3.47208121827411	58	12	88.3	0	193	20	494	551	MAV44562.1 hypothetical protein [Methanobacteriota archaeon]	diamond	684	103	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
29162214	29162214	PRJNA533623_P_NODE_54769_length_274_cov_3.305164_g52990_i0	PRJNA533623	54769	274	3.305164	9.05614936	Methanobacterium sp. PtaU1.Bin	2164	Archaea	Archaea	181	1.3e-55	NR	OPY19747.1	1811675	g52990	i0	100	0.91970802919708	84	0	92	0	273	22	56	139	OPY19747.1 MAG: Sortase family protein [Methanobacterium sp. PtaU1.Bin097]	diamond	252	181	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp. PtaU1.Bin097
29414500	29414500	PRJNA533623_P_NODE_73249_length_210_cov_5.114094_g71468_i0	PRJNA533623	73249	210	5.114094	10.7395974	Methanomassiliicoccus sp.	2528041	Archaea	Archaea	79.7	2.24e-15	NR	NLT37724.1	2528041	g71468	i0	69.8	0.9	63	16	85.7	1	188	9	485	547	NLT37724.1 hypothetical protein [Methanomassiliicoccus sp.]	diamond	189	79.7	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomassiliicoccaceae	Methanomassiliicoccus	Methanomassiliicoccus sp.
29951435	29951435	PRJNA533623_P_NODE_72411_length_212_cov_10.933775_g70630_i0	PRJNA533623	72411	212	10.933775	23.179603	Methanosarcinales archaeon	2250255	Archaea	Archaea	43.1	0.00386	NR	MCK5216355.1	2250255	g70630	i0	54.1	0.523584905660377	37	17	52.4	0	164	54	56	92	MCK5216355.1 hypothetical protein [Methanosarcinales archaeon]	diamond	111	43.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
30140546	30140546	PRJNA533623_P_NODE_22912_length_484_cov_7.938534_g21156_i0	PRJNA533623	22912	484	7.938534	38.42250456	Methanogenium sp.	2196	Archaea	Archaea	91.7	2.7e-18	NR	MFA5396188.1	2196	g21156	i0	47.5	1.86570247933884	101	52	62	1	431	132	267	367	MFA5396188.1 RNA ligase family protein [Methanogenium sp.]	diamond	903	91.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanogenium	Methanogenium sp.
30930900	30930900	PRJNA533623_P_NODE_50334_length_292_cov_43.567100_g48555_i0	PRJNA533623	50334	292	43.5671	127.215932	Methanobacteriota archaeon	2026739	Archaea	Archaea	165	6.02e-45	NR	MFH1322683.1	2026739	g48555	i0	89.2	0.955479452054795	93	10	95.5	0	292	14	469	561	MFH1322683.1 phage/plasmid primase, P4 family [Methanobacteriota archaeon]	diamond	279	165	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
30962513	30962513	PRJNA533623_P_NODE_39754_length_346_cov_3.143860_g37980_i0	PRJNA533623	39754	346	3.14386	10.8777556	Theionarchaea archaeon	2747605	Archaea	Archaea	44.3	0.0335	NR	MBU7013736.1	2747605	g37980	i0	29.2	0.979768786127168	113	66	93.6	4	329	6	193	296	MBU7013736.1 PAS domain-containing protein [Theionarchaea archaeon]	diamond	339	44.3	1	Archaea		Methanobacteriati	Methanobacteriota	Theionarchaea				Theionarchaea archaeon
32037666	32037666	PRJNA533623_P_NODE_3418_length_1184_cov_59.008014_g2421_i0	PRJNA533623	3418	1184	59.008014	698.65488576	Methanolobus sp.	1874737	Archaea	Archaea	159	1.0699999999999998e-41	NR	WP_305310995.1	1874737	g2421	i0	73.5	0.248310810810811	98	24	24.8	1	558	851	199	294	WP_305310995.1 NUMOD3 domain-containing DNA-binding protein [Methanolobus sp.]	diamond	294	159	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanolobus	Methanolobus sp.
32116002	32116002	PRJNA533623_P_NODE_66258_length_232_cov_1.900585_g64477_i0	PRJNA533623	66258	232	1.900585	4.4093572	root	1	Root_unresolved	Root_unresolved	155	8.15e-45	NR	MEN4029920.1	2164	g64477	i0	96.1	1.99137931034483	77	3	99.6	0	232	2	90	166	MEN4029920.1 AMP-binding protein [Methanobacterium sp.]	diamond	462	155	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp.
32354340	32354340	PRJNA533623_P_NODE_35019_length_375_cov_16.796178_g33247_i0	PRJNA533623	35019	375	16.796178	62.9856675	Methanosarcina sp.	2213	Archaea	Archaea	169	1.16e-50	NR	HET8686855.1	2213	g33247	i0	71.9	0.968	121	33	96	1	372	13	88	208	HET8686855.1 SDR family oxidoreductase [Methanosarcina sp.]	diamond	363	169	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
32890225	32890225	PRJNA533623_P_NODE_5860_length_947_cov_10.857788_g4583_i0	PRJNA533623	5860	947	10.857788	102.82325236	Methanomicrobiales archaeon	2184052	Archaea	Archaea	47	0.0336	NR	NLL09360.1	2184052	g4583	i0	28.1	0.28194297782471	89	59	26.9	2	429	683	87	174	NLL09360.1 hypothetical protein [Methanomicrobiales archaeon]	diamond	267	47	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales			Methanomicrobiales archaeon

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