metadata: contig_metadata: 31 rows where bioproject = "PRJNA982106" and tax

31 rows where bioproject = "PRJNA982106" 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
2238994	2238994	PRJNA982106_P_NODE_15802_length_279_cov_1.495146_g15562_i0	PRJNA982106	15802	279	1.495146	4.17145734	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	483	7.689999999999998e-132	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g15562	i0	97.849	1	279	6	100	0	1	279	1307724	1308002	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	279	483	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
7341747	7341747	PRJNA982106_P_NODE_29766_length_243_cov_0.905882_g29526_i0	PRJNA982106	29766	243	0.905882	2.20129326	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	322	1.51e-83	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g29526	i0	91.489	0.967078189300412	235	18	96	1	1	233	968468	968702	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	235	322	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
8616650	8616650	PRJNA982106_P_NODE_14447_length_288_cov_1.297674_g14207_i0	PRJNA982106	14447	288	1.297674	3.73730112	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	177	1.3e-49	NR	WP_048188212.1	1603555	g14207	i0	86.3	0.989583333333333	95	13	99	0	2	286	604	698	WP_048188212.1 ABC transporter substrate-binding protein [Candidatus Nitrosotenuis cloacae]	diamond	285	177	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
8616872	8616872	PRJNA982106_P_NODE_25647_length_247_cov_0.885057_g25407_i0	PRJNA982106	25647	247	0.885057	2.18609079	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	339	1.5299999999999998e-88	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g25407	i0	91.463	2.18218623481781	246	21	99	0	1	246	1361847	1362092	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	539	339	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
11167048	11167048	PRJNA982106_P_NODE_14889_length_285_cov_1.452830_g14649_i0	PRJNA982106	14889	285	1.45283	4.1405655	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	370	6.4e-98	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g14649	i0	90.175	1	285	27	100	1	1	285	615882	615599	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	285	370	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
11167335	11167335	PRJNA982106_P_NODE_29929_length_243_cov_0.905882_g29689_i0	PRJNA982106	29929	243	0.905882	2.20129326	Methanimicrococcus hongohii	3028295	Archaea	Archaea	119	2.13e-22	NTclustered	gi\|2591774574\|gb\|CP131059.1\|	3028295	g29689	i0	82.143	57.522633744856	140	24	57	1	12	150	946106	946245	Methanimicrococcus hongohii strain Hf6 chromosome, complete genome	blastn	13978	119	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanimicrococcus	Methanimicrococcus hongohii
12442824	12442824	PRJNA982106_P_NODE_15410_length_282_cov_1.148325_g15170_i0	PRJNA982106	15410	282	1.148325	3.2382765	Halostagnicola larsenii	353800	Archaea	Archaea	327	3.86e-85	NTclustered	gi\|573479867\|gb\|CP007055.1\|	797299	g15170	i0	87.589	25.2695035460993	282	35	100	0	1	282	1061690	1061971	Halostagnicola larsenii XH-48, complete genome	blastn	7126	327	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Halostagnicola	Halostagnicola larsenii
14991856	14991856	PRJNA982106_P_NODE_28712_length_244_cov_0.900585_g28472_i0	PRJNA982106	28712	244	0.900585	2.1974274	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	291	4.28e-74	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g28472	i0	88.115	1	244	29	100	0	1	244	44115	43872	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	244	291	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
16266914	16266914	PRJNA982106_P_NODE_31593_length_242_cov_0.911243_g31353_i0	PRJNA982106	31593	242	0.911243	2.20520806	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	409	1.12e-109	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g31353	i0	97.107	2.59090909090909	242	7	100	0	1	242	377523	377764	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	627	409	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
16573812	16573812	PRJNA982106_P_NODE_9453_length_332_cov_2.154440_g9213_i0	PRJNA982106	9453	332	2.15444	7.1527408	Thermoproteati	1783275	Archaea	Archaea	601	2.4799999999999996e-167	NTclustered	gi\|428675553\|gb\|JX889077.1\|	29281	g9213	i0	99.396	99.0903614457831	331	2	99	0	1	331	331	1	Uncultured crenarchaeote clone J4 ammonia monooxygenase subunit A (amoA) gene, partial cds	blastn	32898	601	1	Archaea		Thermoproteati	Thermoproteota					uncultured crenarchaeote
17541624	17541624	PRJNA982106_P_NODE_16434_length_275_cov_1.311881_g16194_i0	PRJNA982106	16434	275	1.311881	3.60767275	Natronococcus occultus	29288	Archaea	Archaea	252	2.32e-62	NTclustered	gi\|433671692\|gb\|CP003929.1\|	694430	g16194	i0	85.141	2.04727272727273	249	33	90	4	14	260	3872567	3872813	Natronococcus occultus SP4, complete genome	blastn	563	252	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronococcus	Natronococcus occultus
20090300	20090300	PRJNA982106_P_NODE_22076_length_250_cov_0.870056_g21836_i0	PRJNA982106	22076	250	0.870056	2.17514	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	287	5.7e-73	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g21836	i0	87.402	1.016	254	27	100	3	1	250	527753	527501	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	254	287	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
20090387	20090387	PRJNA982106_P_NODE_26456_length_246_cov_0.890173_g26216_i0	PRJNA982106	26456	246	0.890173	2.18982558	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	405	1.48e-108	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g26216	i0	96.341	1	246	9	100	0	1	246	736492	736737	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	246	405	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
21365852	21365852	PRJNA982106_P_NODE_19817_length_254_cov_1.497238_g19577_i0	PRJNA982106	19817	254	1.497238	3.80298452	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	335	2.0399999999999993e-87	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g19577	i0	90.8	1.8740157480315	250	23	100	0	1	250	6767	7016	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	476	335	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
22641040	22641040	PRJNA982106_P_NODE_29798_length_243_cov_0.905882_g29558_i0	PRJNA982106	29798	243	0.905882	2.20129326	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	355	1.49e-93	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g29558	i0	93.004	1	243	17	100	0	1	243	349208	349450	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	243	355	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
23916268	23916268	PRJNA982106_P_NODE_11259_length_314_cov_0.958506_g11019_i0	PRJNA982106	11259	314	0.958506	3.00970884	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	399	9.109999999999998e-107	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g11019	i0	90.196	0.974522292993631	306	30	97	0	1	306	1529495	1529190	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	306	399	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
23916526	23916526	PRJNA982106_P_NODE_26119_length_246_cov_0.890173_g25879_i0	PRJNA982106	26119	246	0.890173	2.18982558	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	427	3.16e-115	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g25879	i0	97.967	1.98780487804878	246	5	100	0	1	246	454964	455209	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	489	427	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
26709419	26709419	PRJNA982106_P_NODE_19361_length_257_cov_1.255435_g19121_i0	PRJNA982106	19361	257	1.255435	3.22646795	Candidatus Iainarchaeum archaeon	3101447	Archaea	Archaea	43.5	0.0232	NR	MCX8158111.1	2026736	g19121	i0	39.3	0.910505836575875	56	30	60.7	1	15	170	42	97	MCX8158111.1 hypothetical protein [Candidatus Iainarchaeum archaeon]	diamond	234	43.5	1	Archaea		Nanobdellati	Candidatus Iainarchaeota				Candidatus Iainarchaeum	Candidatus Iainarchaeum archaeon
27437412	27437412	PRJNA982106_P_NODE_23203_length_249_cov_0.875000_g22963_i0	PRJNA982106	23203	249	0.875	2.17875	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	44.7	0.00509	NR	WP_148550720.1	1603555	g22963	i0	37	0.975903614457831	81	49	95.2	1	9	245	6	86	WP_148550720.1 hypothetical protein [Candidatus Nitrosotenuis cloacae]	diamond	243	44.7	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
27721789	27721789	PRJNA982106_P_NODE_29764_length_243_cov_0.905882_g29524_i0	PRJNA982106	29764	243	0.905882	2.20129326	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	120	7.22e-30	NR	WP_048188750.1	1603555	g29524	i0	78.5	1.97530864197531	79	16	97.5	1	240	4	383	460	WP_048188750.1 hypothetical protein [Candidatus Nitrosotenuis cloacae]	diamond	480	120	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
27822266	27822266	PRJNA982106_P_NODE_22984_length_249_cov_0.875000_g22744_i0	PRJNA982106	22984	249	0.875	2.17875	root	1	Root_unresolved	Root_unresolved	142	3.499999999999999e-38	NR	WP_048165412.1	971279	g22744	i0	75.9	39.0602409638554	83	20	100	0	1	249	161	243	WP_048165412.1 cyclic 2,3-diphosphoglycerate synthase [Palaeococcus pacificus]	diamond	9726	143	0.993006993006993	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Palaeococcus	Palaeococcus pacificus
27942461	27942461	PRJNA982106_P_NODE_30505_length_243_cov_0.882353_g30265_i0	PRJNA982106	30505	243	0.882353	2.14411779	Nitrososphaera sp.	1971748	Archaea	Archaea	132	1.24e-35	NR	HEU0047943.1	1971748	g30265	i0	75.3	1	81	20	100	0	243	1	1	81	HEU0047943.1 glycosyltransferase family 2 protein [Nitrososphaera sp.]	diamond	243	132	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.
28384332	28384332	PRJNA982106_P_NODE_28846_length_244_cov_0.900585_g28606_i0	PRJNA982106	28846	244	0.900585	2.1974274	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	68.2	4.14e-11	NR	MBW2990903.1	2026803	g28606	i0	41.8	0.971311475409836	79	46	97.1	0	3	239	110	188	MBW2990903.1 DUF2341 domain-containing protein [Candidatus Woesearchaeota archaeon]	diamond	237	68.2	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
28889501	28889501	PRJNA982106_P_NODE_14108_length_290_cov_1.391705_g13868_i0	PRJNA982106	14108	290	1.391705	4.0359445	Nitrososphaerota archaeon	2026795	Archaea	Archaea	196	4.95e-60	NR	MBI5377520.1	2026795	g13868	i0	100	0.993103448275862	96	0	99.3	0	288	1	177	272	MBI5377520.1 fused MFS/spermidine synthase [Nitrososphaerota archaeon]	diamond	288	196	1	Archaea		Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
29047551	29047551	PRJNA982106_P_NODE_9108_length_337_cov_1.079545_g8868_i0	PRJNA982106	9108	337	1.079545	3.63806665	Methanomassiliicoccales archaeon	1906667	Archaea	Archaea	210	1.51e-61	NR	MBC7109221.1	1906667	g8868	i0	95.5	0.997032640949555	112	5	99.7	0	336	1	26	137	MBC7109221.1 bifunctional DNA primase/polymerase [Methanomassiliicoccales archaeon]	diamond	336	210	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales			Methanomassiliicoccales archaeon
29268266	29268266	PRJNA982106_P_NODE_31129_length_242_cov_0.911243_g30889_i0	PRJNA982106	31129	242	0.911243	2.20520806	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	159	9.93e-49	NR	MDW0210172.1	2169593	g30889	i0	96.3	0.991735537190083	80	3	99.2	0	1	240	26	105	MDW0210172.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	240	159	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
30721292	30721292	PRJNA982106_P_NODE_16794_length_273_cov_1.070000_g16554_i0	PRJNA982106	16794	273	1.07	2.9211	Thermoplasmata archaeon	1906666	Archaea	Archaea	42.7	0.0497	NR	HEV2429800.1	1906666	g16554	i0	45.9	0.406593406593407	37	20	40.7	0	263	153	43	79	HEV2429800.1 DNA methyltransferase [Thermoplasmata archaeon]	diamond	111	42.7	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
31543356	31543356	PRJNA982106_P_NODE_23176_length_249_cov_0.875000_g22936_i0	PRJNA982106	23176	249	0.875	2.17875	Methanothrix soehngenii	2223	Archaea	Archaea	71.2	4.89e-13	NR	WP_334140542.1	2223	g22936	i0	45	2.90361445783133	80	41	92.8	2	231	1	2	81	WP_334140542.1 bifunctional DNA primase/polymerase, partial [Methanothrix soehngenii]	diamond	723	71.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix soehngenii
31606527	31606527	PRJNA982106_P_NODE_21616_length_250_cov_0.870056_g21376_i0	PRJNA982106	21616	250	0.870056	2.17514	Thermoproteota archaeon	2056631	Archaea	Archaea	65.5	6.12e-12	NR	MDQ6668694.1	2056631	g21376	i0	82.1	0.936	39	7	46.8	0	133	249	4	42	MDQ6668694.1 hypothetical protein [Thermoproteota archaeon]	diamond	234	65.5	1	Archaea		Thermoproteati	Thermoproteota					Thermoproteota archaeon
32561991	32561991	PRJNA982106_P_NODE_31259_length_242_cov_0.911243_g31019_i0	PRJNA982106	31259	242	0.911243	2.20520806	Thermoproteati	1783275	Archaea	Archaea	147	4.729999999999999e-42	NR	MRN41899.1	2026768	g31019	i0	92.4	2.93801652892562	79	6	97.9	0	239	3	129	207	MRN41899.1 SDR family NAD(P)-dependent oxidoreductase [Nitrosopumilales archaeon]	diamond	711	147	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales			Nitrosopumilales archaeon
32876523	32876523	PRJNA982106_P_NODE_16560_length_274_cov_1.532338_g16320_i0	PRJNA982106	16560	274	1.532338	4.19860612	Nitrososphaera	497726	Archaea	Archaea	144	1.4999999999999998e-39	NR	MEO9276698.1	1971748	g16320	i0	75.8	1.99270072992701	91	22	99.6	0	1	273	101	191	MEO9276698.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Nitrososphaera sp.]	diamond	546	144	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.

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