metadata: contig_metadata: 27 rows where bioproject = "PRJNA605033" and tax

27 rows where bioproject = "PRJNA605033" 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
1857669	1857669	PRJNA605033_P_NODE_165622_length_183_cov_1.229730_g164053_i0	PRJNA605033	165622	183	1.22973	2.2504059	Methanobacteriota archaeon	2026739	Archaea	Archaea	67.6	5.57e-7	NTclustered	gi\|2108123351\|gb\|CP070732.1\|	2026739	g164053	i0	100	4.11475409836066	36	0	20	0	6	41	1649628	1649593	MAG: Methanobacteriota archaeon isolate bin41 chromosome	blastn	753	67.6	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
3697509	3697509	PRJNA605033_P_NODE_88623_length_222_cov_2.219251_g87054_i0	PRJNA605033	88623	222	2.219251	4.92673722	Halobacteriales	2235	Archaea	Archaea	111	3.2e-20	NTclustered	gi\|299123054\|gb\|CP002062.1\|	795797	g87054	i0	95.652	1.52702702702703	69	3	31	0	1	69	1318414	1318482	Halalkalicoccus jeotgali B3, complete genome	blastn	339	111	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus jeotgali
5685980	5685980	PRJNA605033_P_NODE_210365_length_162_cov_1.259843_g208796_i0	PRJNA605033	210365	162	1.259843	2.04094566	Candidatus Nitrosotenuis aquarius	1846278	Archaea	Archaea	291	2.62e-74	NTclustered	gi\|1279207014\|gb\|CP024808.1\|	1846278	g208796	i0	99.375	74.9012345679012	160	1	99	0	1	160	293826	293667	Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome	blastn	12134	291	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis aquarius
6248501	6248501	PRJNA605033_P_NODE_143525_length_200_cov_2.896970_g141956_i0	PRJNA605033	143525	200	2.89697	5.79394	Thermoproteati	1783275	Archaea	Archaea	364	1.96e-96	NTclustered	gi\|22797874\|emb\|AJ496176.1\|	29281	g141956	i0	99.5	34.305	200	1	100	0	1	200	7350	7151	Uncultured crenarchaeote 34 kb genomic fragment	blastn	6861	364	1	Archaea		Thermoproteati	Thermoproteota					uncultured crenarchaeote
10073213	10073213	PRJNA605033_P_NODE_11388_length_412_cov_2.628647_g9857_i0	PRJNA605033	11388	412	2.628647	10.83002564	Thermococcus	2263	Archaea	Archaea	256	1.69e-78	NR	MEO2152736.1	35749	g9857	i0	98.5	17.8252427184466	136	2	99	0	3	410	511	646	MEO2152736.1 DNA polymerase domain-containing protein [Thermococcus sp.]	diamond	7344	256	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus sp.
10074371	10074371	PRJNA605033_P_NODE_66048_length_222_cov_3.737968_g64479_i0	PRJNA605033	66048	222	3.737968	8.29828896	Halorubrum	56688	Archaea	Archaea	52.8	0.02	NTclustered	gi\|1540603140\|gb\|CP030064.1\|	634157	g64479	i0	100	0.252252252252252	28	0	13	0	160	187	2695383	2695356	Halorubrum sp. PV6 chromosome, complete genome	blastn	56	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. PV6
14611210	14611210	PRJNA605033_P_NODE_216112_length_160_cov_1.136000_g214543_i0	PRJNA605033	216112	160	1.136	1.8176	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	228	2.0499999999999995e-55	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g214543	i0	92.073	49.65	164	9	100	2	1	160	1789672	1789509	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	7944	228	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
14611394	14611394	PRJNA605033_P_NODE_234792_length_154_cov_1.000000_g233223_i0	PRJNA605033	234792	154	1	1.54	uncultured archaeon	115547	Archaea	Archaea	224	2.5299999999999994e-54	NTclustered	gi\|388254672\|gb\|JQ768092.1\|	115547	g233223	i0	92.857	52.0779220779221	154	11	100	0	1	154	27982	27829	Uncultured archaeon clone 02j05, complete sequence	blastn	8020	224	1	Archaea								uncultured archaeon
19708237	19708237	PRJNA605033_P_NODE_1576_length_1291_cov_2.747611_g758_i0	PRJNA605033	1576	1291	2.747611	35.47165801	Thermococcus	2263	Archaea	Archaea	807	1.87e-276	NR	WP_014121997.1	246969	g758	i0	88	2.16576297443842	466	20	99.9	3	2	1291	1	466	WP_014121997.1 DNA polymerase domain-containing protein [Thermococcus sp. AM4]	diamond	2796	807	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus sp. AM4
20983543	20983543	PRJNA605033_P_NODE_113997_length_222_cov_1.727273_g112428_i0	PRJNA605033	113997	222	1.727273	3.83454606	Halorubrum ezzemoulense	337243	Archaea	Archaea	56.5	0.002	NTclustered	gi\|1565814486\|gb\|CP034940.1\|	337243	g112428	i0	96.97	0.148648648648649	33	1	15	0	188	220	2855919	2855951	Halorubrum ezzemoulense strain Fb21 chromosome, complete genome	blastn	33	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum ezzemoulense
22260332	22260332	PRJNA605033_P_NODE_93758_length_222_cov_2.096257_g92189_i0	PRJNA605033	93758	222	2.096257	4.65369054	Haloplanus aerogenes	660522	Archaea	Archaea	102	1.93e-17	NTclustered	gi\|1526250537\|gb\|CP034145.1\|	660522	g92189	i0	91.781	0.657657657657658	73	6	33	0	3	75	1832118	1832046	Haloplanus aerogenes strain JCM 16430 chromosome, complete genome	blastn	146	102	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloplanus	Haloplanus aerogenes
22823179	22823179	PRJNA605033_P_NODE_718_length_2342_cov_8.273082_g151_i0	PRJNA605033	718	2342	8.273082	193.75558044	root	1	Root_unresolved	Root_unresolved	451	4.2599999999999984e-148	NR	MCI0556924.1	1971748	g151	i0	54.6	7.47181895815542	441	192	56	4	325	1635	17	453	MCI0556924.1 IS110 family transposase [Nitrososphaera sp.]	diamond	17499	454	0.993392070484581	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.
24809335	24809335	PRJNA605033_P_NODE_64140_length_222_cov_4.679144_g62571_i0	PRJNA605033	64140	222	4.679144	10.38769968	Halovenus aranensis	890420	Archaea	Archaea	67.8	3.8e-11	NR	SDJ86709.1	890420	g62571	i0	46.6	0.986486486486487	73	30	98.6	1	220	2	271	334	SDJ86709.1 Transposase DDE domain-containing protein [Halovenus aranensis]	diamond	219	67.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halovenus	Halovenus aranensis
24809379	24809379	PRJNA605033_P_NODE_72540_length_222_cov_2.914439_g70971_i0	PRJNA605033	72540	222	2.914439	6.47005458	Halalkalicoccus salilacus	3117459	Archaea	Archaea	110	1.15e-19	NTclustered	gi\|2674869203\|gb\|CP144461.1\|	3117459	g70971	i0	93.243	5.26576576576577	74	5	33	0	1	74	620372	620445	Halalkalicoccus salilacus strain FCH27 chromosome, complete genome	blastn	1169	110	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus salilacus
26636772	26636772	PRJNA605033_P_NODE_117241_length_222_cov_1.652406_g115672_i0	PRJNA605033	117241	222	1.652406	3.66834132	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	55.1	1.23e-6	NR	MDW3611325.1	2169593	g115672	i0	100	0.648648648648649	24	0	32.4	0	149	220	282	305	MDW3611325.1 type I glutamate--ammonia ligase [Nitrososphaeraceae archaeon]	diamond	144	55.1	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
26858905	26858905	PRJNA605033_P_NODE_189821_length_170_cov_2.066667_g188252_i0	PRJNA605033	189821	170	2.066667	3.5133339	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	42	0.00447	NR	MBS3072054.1	2026773	g188252	i0	44.4	0.794117647058823	45	22	79.4	1	150	16	33	74	MBS3072054.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	135	42	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon
26935006	26935006	PRJNA605033_P_NODE_153282_length_191_cov_3.147436_g151713_i0	PRJNA605033	153282	191	3.147436	6.01160276	Thermococcus	2263	Archaea	Archaea	133	2.07e-34	NR	WP_167728776.1	163002	g151713	i0	100	4.94764397905759	63	0	99	0	2	190	1761	1823	WP_167728776.1 DNA polymerase domain-containing protein [Thermococcus sp. 9N3]	diamond	945	133	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus sp. 9N3
27396342	27396342	PRJNA605033_P_NODE_77843_length_222_cov_2.604278_g76274_i0	PRJNA605033	77843	222	2.604278	5.78149716	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	50.1	8.79e-6	NR	HEX5977788.1	2169593	g76274	i0	100	0.648648648648649	24	0	32.4	0	220	149	69	92	HEX5977788.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	144	50.1	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
27869582	27869582	PRJNA605033_P_NODE_158365_length_187_cov_4.151316_g156796_i0	PRJNA605033	158365	187	4.151316	7.76296092	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	63.5	1.83e-11	NR	HZA64091.1	2169593	g156796	i0	82.9	0.561497326203209	35	6	56.1	0	45	149	42	76	HZA64091.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	105	63.5	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
28596069	28596069	PRJNA605033_P_NODE_109247_length_222_cov_1.807487_g107678_i0	PRJNA605033	109247	222	1.807487	4.01262114	Methanospirillum sp.	45200	Archaea	Archaea	50.1	7.37e-5	NR	MBP9009538.1	45200	g107678	i0	41.1	1.97297297297297	73	20	98.6	1	219	1	199	248	MBP9009538.1 DNA cytosine methyltransferase [Methanospirillum sp.]	diamond	438	50.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanospirillaceae	Methanospirillum	Methanospirillum sp.
28924711	28924711	PRJNA605033_P_NODE_141988_length_202_cov_1.802395_g140419_i0	PRJNA605033	141988	202	1.802395	3.6408379	root	1	Root_unresolved	Root_unresolved	94	4.569999999999999e-23	NR	MCI0562201.1	1971748	g140419	i0	84.9	1.57425742574257	53	8	78.7	0	4	162	53	105	MCI0562201.1 fluoride efflux transporter CrcB [Nitrososphaera sp.]	diamond	318	94	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.
30079911	30079911	PRJNA605033_P_NODE_72492_length_222_cov_2.919786_g70923_i0	PRJNA605033	72492	222	2.919786	6.48192492	Candidatus Nanoarchaeia archaeon	2910166	Archaea	Archaea	47.8	4.65e-4	NR	HLD15491.1	2910166	g70923	i0	91.7	0.324324324324324	24	2	32.4	0	221	150	312	335	HLD15491.1 signal recognition particle-docking protein FtsY [Candidatus Nanoarchaeia archaeon]	diamond	72	47.8	1	Archaea		Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia				Candidatus Nanoarchaeia archaeon
30585416	30585416	PRJNA605033_P_NODE_180613_length_174_cov_6.985612_g179044_i0	PRJNA605033	180613	174	6.985612	12.15496488	Pyrococcus furiosus	2261	Archaea	Archaea	110	1.47e-26	NR	4AHC_A	2261	g179044	i0	96.5	0.982758620689655	57	2	98.3	0	172	2	131	187	4AHC_A Chain A, DNA POLYMERASE [Pyrococcus furiosus]	diamond	171	110	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus furiosus
30996390	30996390	PRJNA605033_P_NODE_36874_length_261_cov_1.654867_g35307_i0	PRJNA605033	36874	261	1.654867	4.31920287	Candidatus Altiarchaeales archaeon	2250256	Archaea	Archaea	60.8	1.54e-8	NR	MBD3260715.1	2250256	g35307	i0	44.8	0.770114942528736	67	31	77	1	202	2	54	114	MBD3260715.1 IS200/IS605 family element transposase accessory protein TnpB [Candidatus Altiarchaeales archaeon]	diamond	201	60.8	1	Archaea		Nanobdellati	Candidatus Altarchaeota	Candidatus Altiarchaeia	Candidatus Altarchaeales			Candidatus Altiarchaeales archaeon
31547191	31547191	PRJNA605033_P_NODE_26656_length_290_cov_1.635294_g25094_i0	PRJNA605033	26656	290	1.635294	4.7423526	root	1	Root_unresolved	Root_unresolved	55.8	1.61e-6	NR	TRO47018.1	2026714	g25094	i0	55.8	2.23448275862069	43	19	44.5	0	4	132	423	465	TRO47018.1 HAD family hydrolase, partial [Candidatus Bathyarchaeota archaeon]	diamond	648	55.8	1	Archaea		Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
32229986	32229986	PRJNA605033_P_NODE_170558_length_180_cov_1.379310_g168989_i0	PRJNA605033	170558	180	1.37931	2.482758	Halobaculum sp.	1891221	Archaea	Archaea	40	0.0495	NR	MFB6177911.1	1891221	g168989	i0	35.8	0.883333333333333	53	28	78.3	1	177	37	49	101	MFB6177911.1 AAA family ATPase [Halobaculum sp.]	diamond	159	40	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobaculum	Halobaculum sp.
32892524	32892524	PRJNA605033_P_NODE_228780_length_155_cov_4.200000_g227211_i0	PRJNA605033	228780	155	4.2	6.51	Nitrosopumilus ureiphilus	1470067	Archaea	Archaea	44.3	0.00321	NR	WP_179372584.1	1470067	g227211	i0	53.6	2.12903225806452	28	13	54.2	0	1	84	439	466	WP_179372584.1 serpin family protein [Nitrosopumilus ureiphilus]	diamond	330	44.3	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus ureiphilus

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