metadata: contig_metadata: 28 rows where bioproject = "PRJNA976345" and tax

28 rows where bioproject = "PRJNA976345" and tax_superkingdom = "Archaea"

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
2223118	2223118	PRJNA976345_P_NODE_124802_length_178_cov_1.559441_g123194_i0	PRJNA976345	124802	178	1.559441	2.77580498	Candidatus Nitrosocosmicus franklandianus	1798806	Archaea	Archaea	56.5	0.001	NTclustered	gi\|1599533355\|emb\|LR216287.1\|	1798806	g123194	i0	100	0.168539325842697	30	0	17	0	85	114	1183389	1183360	Candidatus Nitrosocosmicus franklandus isolate NFRAN1 genome assembly, chromosome: NFRAN	blastn	30	56.5	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus franklandianus
2224019	2224019	PRJNA976345_P_NODE_61802_length_227_cov_1.739583_g60194_i0	PRJNA976345	61802	227	1.739583	3.94885341	Methanolobus sp. ZRKC2	3125783	Archaea	Archaea	52.8	0.02	NTclustered	gi\|2708450131\|gb\|CP146980.1\|	3125783	g60194	i0	100	0.123348017621145	28	0	12	0	8	35	205498	205525	Methanolobus sp. ZRKC2 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanolobus	Methanolobus sp. ZRKC2
8601598	8601598	PRJNA976345_P_NODE_59347_length_230_cov_3.482051_g57739_i0	PRJNA976345	59347	230	3.482051	8.0087173	Candidatus Methanospirare jalkutatii	2977098	Archaea	Archaea	52.8	0.021	NTclustered	gi\|2324523409\|gb\|CP110382.1\|	2977098	g57739	i0	100	0.243478260869565	28	0	12	0	16	43	296054	296081	MAG: Candidatus Methanospirare jalkutatii isolate FWG175 chromosome	blastn	56	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Candidatus Methanophagales	Candidatus Methanospirareceae	Candidatus Methanospirare	Candidatus Methanospirare jalkutatii
12427119	12427119	PRJNA976345_P_NODE_149230_length_166_cov_4.015267_g147622_i0	PRJNA976345	149230	166	4.015267	6.66534322	uncultured Candidatus Nitrosopumilus sp.	517606	Archaea	Archaea	52.8	0.014	NTclustered	gi\|2518550870\|emb\|OX638319.1\|	517606	g147622	i0	100	0.168674698795181	28	0	17	0	71	98	249961	249988	MAG: uncultured Candidatus Nitrosopumilus sp. isolate a9bb1b8d-3405-4f78-8bb0-675615731146 genome assembly, chromosome: 1	blastn	28	52.8	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	uncultured Candidatus Nitrosopumilus sp.
14975729	14975729	PRJNA976345_P_NODE_138692_length_171_cov_2.080882_g137084_i0	PRJNA976345	138692	171	2.080882	3.55830822	uncultured Methanobacterium sp.	176306	Archaea	Archaea	54.7	0.004	NTclustered	gi\|2621703503\|emb\|OY762552.1\|	176306	g137084	i0	96.97	0.192982456140351	33	0	19	1	21	53	1272314	1272283	MAG: uncultured Methanobacterium sp. isolate 3f2017ab-9e69-417f-80a5-32741c1572f8 genome assembly, chromosome: 1	blastn	33	54.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	uncultured Methanobacterium sp.
15294887	15294887	PRJNA976345_P_NODE_119612_length_178_cov_2.895105_g118004_i0	PRJNA976345	119612	178	2.895105	5.1532869	root	1	Root_unresolved	Root_unresolved	52.8	0.015	NTclustered	gi\|2105355784\|gb\|CP084090.1\|	1586233	g118004	i0	100	0.353932584269663	28	0	16	0	22	49	706159	706186	Halomicrobium urmianum strain IBRC-M: 10911 chromosome, complete genome	blastn	63	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halomicrobium	Halomicrobium urmianum
16251043	16251043	PRJNA976345_P_NODE_191793_length_152_cov_1.547009_g190185_i0	PRJNA976345	191793	152	1.547009	2.35145368	Candidatus Heimdallarchaeum endolithica	2876572	Archaea	Archaea	60.2	7.43e-5	NTclustered	gi\|2180470024\|gb\|CP084167.1\|	2876572	g190185	i0	97.143	0.230263157894737	35	1	23	0	13	47	1699136	1699170	MAG: Candidatus Heimdallarchaeum endolithica isolate PR6 chromosome, complete genome	blastn	35	60.2	1	Archaea		Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeia (ex Rinke et al. 2021) (nom. nud.)	Candidatus Heimdallarchaeales	Candidatus Heimdallarchaeaceae	Candidatus Heimdallarchaeum	Candidatus Heimdallarchaeum endolithica
22624851	22624851	PRJNA976345_P_NODE_131238_length_175_cov_1.307143_g129630_i0	PRJNA976345	131238	175	1.307143	2.28750025	Methanochimaera problematica	2609417	Archaea	Archaea	52.8	0.015	NTclustered	gi\|2594454307\|gb\|CP043875.1\|	2609417	g129630	i0	100	0.16	28	0	16	0	119	146	491879	491906	Methanochimaera problematica strain FWC-SCC4 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanochimaera	Methanochimaera problematica
22625006	22625006	PRJNA976345_P_NODE_157098_length_163_cov_2.476562_g155490_i0	PRJNA976345	157098	163	2.476562	4.03679606	Candidatus Nanopusillus acidilobi	1577684	Archaea	Archaea	52.8	0.014	NTclustered	gi\|985630447\|gb\|CP010514.1\|	1577684	g155490	i0	100	0.171779141104294	28	0	17	0	71	98	265534	265561	Candidatus Nanopusillus acidilobi strain 7A chromosome, complete genome	blastn	28	52.8	1	Archaea		Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia	Nanoarchaeales	Nanopusillaceae	Candidatus Nanopusillus	Candidatus Nanopusillus acidilobi
23901457	23901457	PRJNA976345_P_NODE_84219_length_202_cov_1.670659_g82611_i0	PRJNA976345	84219	202	1.670659	3.37473118	Natrarchaeobaculum aegyptiacum	745377	Archaea	Archaea	62.1	2.92e-5	NTclustered	gi\|1196598842\|gb\|CP019893.1\|	745377	g82611	i0	92.857	0.207920792079208	42	3	21	0	67	108	2705856	2705815	Natrarchaeobaculum aegyptiacum strain JW/NM-HA 15 chromosome, complete genome	blastn	42	62.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrarchaeobaculum	Natrarchaeobaculum aegyptiacum
25174290	25174290	PRJNA976345_P_NODE_21620_length_362_cov_2.941896_g20020_i0	PRJNA976345	21620	362	2.941896	10.64966352	uncultured Methanobacteriaceae archaeon	176233	Archaea	Archaea	58.4	7.38e-4	NTclustered	gi\|2874253858\|emb\|OY969914.1\|	176233	g20020	i0	97.059	0.0939226519337017	34	1	9	0	252	285	2212723	2212690	MAG: uncultured Methanobacteriaceae archaeon isolate MFD02416.bin.1.248 genome assembly, chromosome: 1	blastn	34	58.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		uncultured Methanobacteriaceae archaeon
25174378	25174378	PRJNA976345_P_NODE_28300_length_317_cov_1.833333_g26696_i0	PRJNA976345	28300	317	1.833333	5.81166561	uncultured archaeon	115547	Archaea	Archaea	52.8	0.03	NTclustered	gi\|765560072\|gb\|KP308683.1\|	115547	g26696	i0	100	0.0883280757097792	28	0	9	0	28	55	1361	1334	Uncultured archaeon clone RBG_16_scaffold_12837 genomic sequence	blastn	28	52.8	1	Archaea								uncultured archaeon
27405531	27405531	PRJNA976345_P_NODE_96583_length_192_cov_2.031847_g94975_i0	PRJNA976345	96583	192	2.031847	3.90114624	Methanocorpusculum sp.	2058474	Archaea	Archaea	43.9	0.00708	NR	HJJ77687.1	2058474	g94975	i0	46.3	0.640625	41	22	64.1	0	126	4	4	44	HJJ77687.1 hypothetical protein [Methanocorpusculum sp.]	diamond	123	43.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanocorpusculaceae	Methanocorpusculum	Methanocorpusculum sp.
28131659	28131659	PRJNA976345_P_NODE_133245_length_174_cov_1.323741_g131637_i0	PRJNA976345	133245	174	1.323741	2.30330934	archaeon	1906665	Archaea	Archaea	42	0.0267	NR	NCN86483.1	1906665	g131637	i0	46.9	0.844827586206897	49	22	84.5	1	155	9	204	248	NCN86483.1 radical SAM protein [archaeon]	diamond	147	42	1	Archaea								archaeon
28194465	28194465	PRJNA976345_P_NODE_40526_length_270_cov_3.234043_g38918_i0	PRJNA976345	40526	270	3.234043	8.7319161	Nitrosopumilus sp.	2024843	Archaea	Archaea	60.5	2.89e-8	NR	MCH2406285.1	2024843	g38918	i0	40	1.78888888888889	85	49	93.3	2	15	266	445	528	MCH2406285.1 hypothetical protein [Nitrosopumilus sp.]	diamond	483	60.5	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
28542167	28542167	PRJNA976345_P_NODE_146927_length_167_cov_3.689394_g145319_i0	PRJNA976345	146927	167	3.689394	6.16128798	Methanocaldococcus sp.	2152917	Archaea	Archaea	46.2	7.88e-4	NR	WP_297317778.1	2152917	g145319	i0	44.9	0.880239520958084	49	27	88	0	6	152	50	98	WP_297317778.1 GTPase [Methanocaldococcus sp.]	diamond	147	46.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanocaldococcaceae	Methanocaldococcus	Methanocaldococcus sp.
29205166	29205166	PRJNA976345_P_NODE_100889_length_189_cov_1.961039_g99281_i0	PRJNA976345	100889	189	1.961039	3.70636371	Archaeoglobaceae archaeon	2511821	Archaea	Archaea	91.3	1.49e-19	NR	MCS7121671.1	2511821	g99281	i0	70.5	8.96825396825397	61	18	96.8	0	183	1	430	490	MCS7121671.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Archaeoglobaceae archaeon]	diamond	1695	91.3	1	Archaea		Methanobacteriati	Methanobacteriota	Archaeoglobi	Archaeoglobales	Archaeoglobaceae		Archaeoglobaceae archaeon
29299727	29299727	PRJNA976345_P_NODE_135269_length_173_cov_1.427536_g133661_i0	PRJNA976345	135269	173	1.427536	2.46963728	archaeon	1906665	Archaea	Archaea	55.1	2.36e-8	NR	RYY86752.1	1906665	g133661	i0	65.2	0.797687861271676	46	16	79.8	0	3	140	5	50	RYY86752.1 MAG: hypothetical protein EON63_05265 [archaeon]	diamond	138	55.1	1	Archaea								archaeon
29678298	29678298	PRJNA976345_P_NODE_146630_length_168_cov_1.187970_g145022_i0	PRJNA976345	146630	168	1.18797	1.9957896	archaeon	1906665	Archaea	Archaea	60.8	4.39e-9	NR	RYG53897.1	1906665	g145022	i0	62.5	0.857142857142857	48	18	85.7	0	23	166	1	48	RYG53897.1 MAG: hypothetical protein EON66_07885 [archaeon]	diamond	144	60.8	1	Archaea								archaeon
29962902	29962902	PRJNA976345_P_NODE_128111_length_176_cov_2.340426_g126503_i0	PRJNA976345	128111	176	2.340426	4.11914976	Candidatus Nitrosocosmicus sp.	2109671	Archaea	Archaea	45.4	0.00169	NR	HKU83278.1	2109671	g126503	i0	44.1	1.00568181818182	59	28	92	2	167	6	194	252	HKU83278.1 reverse transcriptase family protein [Candidatus Nitrosocosmicus sp.]	diamond	177	45.4	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus sp.
30562883	30562883	PRJNA976345_P_NODE_87713_length_199_cov_1.725610_g86105_i0	PRJNA976345	87713	199	1.72561	3.4339639	Candidatus Nitrosocosmicus oleophilus	1353260	Archaea	Archaea	40.8	0.0255	NR	WP_196817592.1	1353260	g86105	i0	42.2	0.678391959798995	45	26	67.8	0	187	53	3	47	WP_196817592.1 hypothetical protein [Candidatus Nitrosocosmicus oleophilus]	diamond	135	40.8	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
30562888	30562888	PRJNA976345_P_NODE_95193_length_193_cov_2.126582_g93585_i0	PRJNA976345	95193	193	2.126582	4.10430326	Nitrososphaerota archaeon	2026795	Archaea	Archaea	40	0.0439	NR	MBI1658427.1	2026795	g93585	i0	50	0.49740932642487	32	16	49.7	0	116	21	44	75	MBI1658427.1 hypothetical protein [Nitrososphaerota archaeon]	diamond	96	40	1	Archaea		Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
30847517	30847517	PRJNA976345_P_NODE_102994_length_188_cov_1.267974_g101386_i0	PRJNA976345	102994	188	1.267974	2.38379112	Candidatus Marsarchaeota archaeon	2823144	Archaea	Archaea	43.1	0.0132	NR	MCL5427951.1	2823144	g101386	i0	39.3	2.48936170212766	56	33	89.4	1	14	181	442	496	MCL5427951.1 TCP-1/cpn60 chaperonin family protein [Candidatus Marsarchaeota archaeon]	diamond	468	43.1	1	Archaea		Thermoproteati	Candidatus Marsarchaeota					Candidatus Marsarchaeota archaeon
31574805	31574805	PRJNA976345_P_NODE_34456_length_290_cov_1.839216_g32849_i0	PRJNA976345	34456	290	1.839216	5.3337264	Promethearchaeota archaeon	2053489	Archaea	Archaea	47.4	0.00141	NR	MBD3352878.1	2053489	g32849	i0	50	1.46896551724138	52	26	53.8	0	289	134	261	312	MBD3352878.1 GTP-binding protein [Promethearchaeota archaeon]	diamond	426	47.4	1	Archaea		Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
32175938	32175938	PRJNA976345_P_NODE_46598_length_255_cov_1.500000_g44990_i0	PRJNA976345	46598	255	1.5	3.825	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	42.7	0.00534	NR	RLE37447.1	2026803	g44990	i0	37	0.635294117647059	54	34	63.5	0	164	3	6	59	RLE37447.1 MAG: hypothetical protein DRJ17_06615 [Candidatus Woesearchaeota archaeon]	diamond	162	42.7	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
32492347	32492347	PRJNA976345_P_NODE_64199_length_223_cov_6.218085_g62591_i0	PRJNA976345	64199	223	6.218085	13.86632955	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	65.1	3.83e-10	NR	MDW3615052.1	2169593	g62591	i0	42.6	1.80269058295964	68	39	91.5	0	1	204	60	127	MDW3615052.1 ribonuclease H family protein [Nitrososphaeraceae archaeon]	diamond	402	65.1	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
32681095	32681095	PRJNA976345_P_NODE_112320_length_182_cov_1.619048_g110712_i0	PRJNA976345	112320	182	1.619048	2.94666736	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	45.8	0.0013	NR	WP_288267568.1	253161	g110712	i0	50	0.659340659340659	40	20	65.9	0	31	150	257	296	WP_288267568.1 RHS repeat-associated core domain-containing protein [uncultured Methanobrevibacter sp.]	diamond	120	45.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
32807293	32807293	PRJNA976345_P_NODE_131220_length_175_cov_1.328571_g129612_i0	PRJNA976345	131220	175	1.328571	2.32499925	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	77.4	9.09e-15	NR	MCK5611892.1	2026773	g129612	i0	62.1	0.994285714285714	58	22	99.4	0	175	2	701	758	MCK5611892.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	174	77.4	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota 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);;