metadata: contig_metadata: 20 rows where bioproject = "PRJNA560932" and tax

20 rows where bioproject = "PRJNA560932" 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
5648709	5648709	PRJNA560932_P_NODE_6725_length_666_cov_1.974705_g6374_i0	PRJNA560932	6725	666	1.974705	13.1515353	Halorussus vallis	2953749	Archaea	Archaea	56.5	0.005	NTclustered	gi\|2263966384\|gb\|CP100000.1\|	2953749	g6374	i0	100	0.045045045045045	30	0	5	0	100	129	2043996	2044025	Halorussus vallis strain XZYJT10 chromosome, complete genome	blastn	30	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Halorussus	Halorussus vallis
6922461	6922461	PRJNA560932_P_NODE_16466_length_433_cov_1.188889_g16110_i0	PRJNA560932	16466	433	1.188889	5.14788937	Halobaculum sp. CBA1158	2904243	Archaea	Archaea	54.7	0.012	NTclustered	gi\|2176093559\|gb\|CP090371.1\|	2904243	g16110	i0	92.308	0.0900692840646651	39	1	9	2	163	201	2507481	2507445	Halobaculum sp. CBA1158 chromosome, complete genome	blastn	39	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobaculum	Halobaculum sp. CBA1158
6922801	6922801	PRJNA560932_P_NODE_54846_length_249_cov_1.295455_g54490_i0	PRJNA560932	54846	249	1.295455	3.22568295	Natronorarus salvus	3117733	Archaea	Archaea	56.5	0.002	NTclustered	gi\|2670420129\|gb\|CP144125.1\|	3117733	g54490	i0	100	0.120481927710843	30	0	12	0	41	70	1818078	1818107	Natronorarus salvus strain CGA53 chromosome, complete genome	blastn	30	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halalkalicoccaceae	Natronorarus	Natronorarus salvus
10749163	10749163	PRJNA560932_P_NODE_61429_length_245_cov_0.895349_g61073_i0	PRJNA560932	61429	245	0.895349	2.19360505	Halobacterium wangiae	2902623	Archaea	Archaea	52.8	0.022	NTclustered	gi\|2168769890\|gb\|CP089588.1\|	2902623	g61073	i0	100	0.114285714285714	28	0	11	0	96	123	2598188	2598161	Halobacterium wangiae strain Gai3-17 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halobacterium	Halobacterium wangiae
13298656	13298656	PRJNA560932_P_NODE_29531_length_331_cov_1.399225_g29175_i0	PRJNA560932	29531	331	1.399225	4.63143475	Natronosalvus caseinilyticus	2953747	Archaea	Archaea	52.8	0.031	NTclustered	gi\|2006550273\|gb\|CP071596.1\|	2953747	g29175	i0	100	0.0845921450151057	28	0	8	0	120	147	1765254	1765227	Natronosalvus caseinilyticus strain KZCA101 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronosalvus	Natronosalvus caseinilyticus
23497051	23497051	PRJNA560932_P_NODE_38559_length_293_cov_0.986364_g38203_i0	PRJNA560932	38559	293	0.986364	2.89004652	Natrialba magadii	13769	Archaea	Archaea	52.8	0.027	NTclustered	gi\|289532809\|gb\|CP001933.1\|	547559	g38203	i0	100	0.0955631399317406	28	0	10	0	215	242	272225	272252	Natrialba magadii ATCC 43099 plasmid pNMAG01, complete sequence	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrialba	Natrialba magadii
24771121	24771121	PRJNA560932_P_NODE_61580_length_245_cov_0.895349_g61224_i0	PRJNA560932	61580	245	0.895349	2.19360505	uncultured Methanoregulaceae archaeon	1392423	Archaea	Archaea	62.1	3.67e-5	NTclustered	gi\|2874254037\|emb\|OY970361.1\|	1392423	g61224	i0	100	0.371428571428571	33	0	13	0	39	71	946034	946066	MAG: uncultured Methanoregulaceae archaeon isolate MFD01476.bin.2.40 genome assembly, chromosome: 1	blastn	91	62.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		uncultured Methanoregulaceae archaeon
27426892	27426892	PRJNA560932_P_NODE_52643_length_251_cov_0.865169_g52287_i0	PRJNA560932	52643	251	0.865169	2.17157419	Methanocorpusculum sp.	2058474	Archaea	Archaea	61.2	5.41e-9	NR	MDO5844305.1	2058474	g52287	i0	39.2	4.51792828685259	79	48	94.4	0	249	13	111	189	MDO5844305.1 MIP/aquaporin family protein [Methanocorpusculum sp.]	diamond	1134	61.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanocorpusculaceae	Methanocorpusculum	Methanocorpusculum sp.
27805773	27805773	PRJNA560932_P_NODE_61384_length_245_cov_0.895349_g61028_i0	PRJNA560932	61384	245	0.895349	2.19360505	Methanosarcinales archaeon	2250255	Archaea	Archaea	91.3	2.71e-20	NR	RYE82592.1	2250255	g61028	i0	48.8	1.02857142857143	84	40	99.2	1	245	3	150	233	RYE82592.1 MAG: hypothetical protein EOO65_05280 [Methanosarcinales archaeon]	diamond	252	91.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
28356209	28356209	PRJNA560932_P_NODE_64366_length_243_cov_0.905882_g64010_i0	PRJNA560932	64366	243	0.905882	2.20129326	Haloferacaceae	1644056	Archaea	Archaea	45.4	0.00405	NR	WP_310928220.1	2950537	g64010	i0	51.1	3.39506172839506	45	22	55.6	0	214	80	305	349	WP_310928220.1 amidohydrolase [Halogeometricum luteum]	diamond	825	45.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halogeometricum	Halogeometricum luteum
28563413	28563413	PRJNA560932_P_NODE_2547_length_1028_cov_1.783246_g2304_i0	PRJNA560932	2547	1028	1.783246	18.33176888	Methanoregulaceae archaeon	2485498	Archaea	Archaea	66.2	8.09e-8	NR	HNJ81026.1	2485498	g2304	i0	48.3	0.175097276264591	60	29	17.5	1	553	374	603	660	HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon]	diamond	180	66.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		Methanoregulaceae archaeon
29208955	29208955	PRJNA560932_P_NODE_49889_length_257_cov_1.385870_g49533_i0	PRJNA560932	49889	257	1.38587	3.5616859	root	1	Root_unresolved	Root_unresolved	43.5	0.0235	NR	MDD2340538.1	2213	g49533	i0	50	0.957198443579767	36	18	42	0	27	134	435	470	MDD2340538.1 tetratricopeptide repeat protein [Methanosarcina sp.]	diamond	246	43.9	0.990888382687927	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
29731331	29731331	PRJNA560932_P_NODE_47370_length_265_cov_1.541667_g47014_i0	PRJNA560932	47370	265	1.541667	4.08541755	Methanoregula sp.	2052170	Archaea	Archaea	65.9	1.83e-10	NR	MDD1680459.1	2052170	g47014	i0	50	2.11698113207547	70	31	78.1	3	36	242	76	142	MDD1680459.1 hypothetical protein [Methanoregula sp.]	diamond	561	65.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp.
30029928	30029928	PRJNA560932_P_NODE_5531_length_729_cov_2.693598_g5199_i0	PRJNA560932	5531	729	2.693598	19.63632942	root	1	Root_unresolved	Root_unresolved	48.5	0.0162	NR	MDD1676221.1	2184052	g5199	i0	32	1.17695473251029	128	64	52.7	5	233	616	119	223	MDD1676221.1 multicopper oxidase domain-containing protein [Methanomicrobiales archaeon]	diamond	858	48.9	0.991820040899796	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales			Methanomicrobiales archaeon
30141824	30141824	PRJNA560932_P_NODE_58772_length_247_cov_0.885057_g58416_i0	PRJNA560932	58772	247	0.885057	2.18609079	Methanosaeta sp. PtaU1.Bin112	1811689	Archaea	Archaea	61.6	7.85e-9	NR	OPY50585.1	1811689	g58416	i0	44.9	3.19433198380567	69	34	83.8	1	207	1	261	325	OPY50585.1 MAG: ADP-ribosylglycohydrolase [Methanosaeta sp. PtaU1.Bin112]	diamond	789	61.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanosaeta sp. PtaU1.Bin112
30409304	30409304	PRJNA560932_P_NODE_5793_length_713_cov_12.085938_g5456_i0	PRJNA560932	5793	713	12.085938	86.17273794	Haladaptatus	367188	Archaea	Archaea	107	1.2e-23	NR	WP_244895571.1	367189	g5456	i0	35.7	3.29032258064516	196	120	80.4	4	66	638	20	214	WP_244895571.1 DUF4397 domain-containing protein [Haladaptatus paucihalophilus]	diamond	2346	107	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Haladaptatus	Haladaptatus paucihalophilus
30900671	30900671	PRJNA560932_P_NODE_58194_length_247_cov_0.885057_g57838_i0	PRJNA560932	58194	247	0.885057	2.18609079	Halobacterium bonnevillei	2692200	Archaea	Archaea	43.1	0.0216	NR	WP_159526713.1	2692200	g57838	i0	51.1	0.57085020242915	47	22	57.1	1	203	63	100	145	WP_159526713.1 response regulator [Halobacterium bonnevillei]	diamond	141	43.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halobacterium	Halobacterium bonnevillei
31880521	31880521	PRJNA560932_P_NODE_45377_length_271_cov_1.555556_g45021_i0	PRJNA560932	45377	271	1.555556	4.21555676	Methanoregulaceae archaeon	2485498	Archaea	Archaea	44.7	0.0107	NR	HNJ81026.1	2485498	g45021	i0	42.2	0.498154981549816	45	24	49.8	1	269	135	618	660	HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon]	diamond	135	44.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae		Methanoregulaceae archaeon
32386887	32386887	PRJNA560932_P_NODE_17199_length_424_cov_1.028490_g16843_i0	PRJNA560932	17199	424	1.02849	4.3607976	Methanocella sp.	2052833	Archaea	Archaea	72	1.58e-11	NR	HTX44403.1	2052833	g16843	i0	36.4	0.700471698113208	99	61	69.3	2	38	331	490	587	HTX44403.1 hypothetical protein [Methanocella sp.]	diamond	297	72	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanocellales	Methanocellaceae	Methanocella	Methanocella sp.
32905444	32905444	PRJNA560932_P_NODE_4980_length_765_cov_19.784682_g4652_i0	PRJNA560932	4980	765	19.784682	151.3528173	Halobacteriales	2235	Archaea	Archaea	92	3.7e-17	NR	PSP63795.1	1919162	g4652	i0	28	5.61960784313725	211	141	79.2	5	63	668	296	504	PSP63795.1 MAG: hypothetical protein BRC77_05875 [Halobacteriales archaeon QH_8_64_26]	diamond	4299	92.8	0.991379310344828	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			Halobacteriales archaeon QH_8_64_26

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