metadata: contig_metadata: 32 rows where bioproject = "PRJNA1186363" and tax

32 rows where bioproject = "PRJNA1186363" 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
2870433	2870433	PRJNA1186363_P_NODE_14923_length_513_cov_1.377273_g14038_i0	PRJNA1186363	14923	513	1.377273	7.06541049	archaeon	1906665	Archaea	Archaea	256	3.52e-81	NR	MDP2436715.1	1906665	g14038	i0	72.7	5.83625730994152	165	45	96.5	0	512	18	242	406	MDP2436715.1 hypothetical protein [archaeon]	diamond	2994	256	1	Archaea								archaeon
6697548	6697548	PRJNA1186363_P_NODE_16826_length_474_cov_3.007481_g15939_i0	PRJNA1186363	16826	474	3.007481	14.25545994	root	1	Root_unresolved	Root_unresolved	266	1.26e-88	NR	MDP2437911.1	1906665	g15939	i0	80.1	8.46835443037975	151	30	95.6	0	22	474	1	151	MDP2437911.1 peptidylprolyl isomerase [archaeon]	diamond	4014	266	1	Archaea								archaeon
6697620	6697620	PRJNA1186363_P_NODE_25246_length_361_cov_1.114583_g24358_i0	PRJNA1186363	25246	361	1.114583	4.02364463	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	56.5	0.003	NTclustered	gi\|2810060730\|gb\|CP170178.1\|	3045160	g24358	i0	100	0.0831024930747922	30	0	8	0	102	131	1013186	1013157	MAG: Candidatus Bathyarchaeia archaeon isolate Bathy6-F90_cMAG_MillC chromosome, complete genome	blastn	30	56.5	1	Archaea		Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
7973004	7973004	PRJNA1186363_P_NODE_2947_length_1189_cov_4.541219_g2485_i0	PRJNA1186363	2947	1189	4.541219	53.99509391	Halorussus limi	2938695	Archaea	Archaea	54.7	0.034	NTclustered	gi\|2234300126\|gb\|CP096659.1\|	2938695	g2485	i0	100	0.024390243902439	29	0	2	0	1044	1072	170444	170472	Halorussus limi strain XZYJT49 chromosome, complete genome	blastn	29	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haladaptataceae	Halorussus	Halorussus limi
7973079	7973079	PRJNA1186363_P_NODE_42307_length_245_cov_0.906977_g41419_i0	PRJNA1186363	42307	245	0.906977	2.22209365	archaeon	1906665	Archaea	Archaea	145	6.159999999999999e-43	NR	MDP2436093.1	1906665	g41419	i0	90.1	0.991836734693878	81	7	99.2	1	1	243	42	121	MDP2436093.1 2-oxo acid dehydrogenase subunit E2 [archaeon]	diamond	243	145	1	Archaea								archaeon
11798351	11798351	PRJNA1186363_P_NODE_25090_length_363_cov_1.020690_g24202_i0	PRJNA1186363	25090	363	1.02069	3.7051047	archaeon	1906665	Archaea	Archaea	223	1.61e-71	NR	MDP2435760.1	1906665	g24202	i0	95.8	0.991735537190083	120	5	99.2	0	362	3	40	159	MDP2435760.1 30S ribosomal protein S3 [archaeon]	diamond	360	223	1	Archaea								archaeon
18171472	18171472	PRJNA1186363_P_NODE_7515_length_770_cov_1.713056_g6708_i0	PRJNA1186363	7515	770	1.713056	13.1905312	Natronorubrum aibiense	348826	Archaea	Archaea	56.5	0.006	NTclustered	gi\|1770793304\|gb\|CP045488.1\|	348826	g6708	i0	94.595	0.0480519480519481	37	0	5	2	134	169	342667	342702	Natronorubrum aibiense strain 7-3 chromosome, complete genome	blastn	37	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronorubrum	Natronorubrum aibiense
19445746	19445746	PRJNA1186363_P_NODE_25076_length_363_cov_1.075862_g24188_i0	PRJNA1186363	25076	363	1.075862	3.90537906	archaeon	1906665	Archaea	Archaea	108	2.21e-27	NR	MDP2435761.1	1906665	g24188	i0	89.4	0.545454545454545	66	7	54.5	0	362	165	49	114	MDP2435761.1 ribosomal eL24 family protein [archaeon]	diamond	198	108	1	Archaea								archaeon
24545780	24545780	PRJNA1186363_P_NODE_34100_length_283_cov_2.028571_g33212_i0	PRJNA1186363	34100	283	2.028571	5.74085593	Methanomethylovorans hollandica	101192	Archaea	Archaea	52.8	0.026	NTclustered	gi\|433660872\|gb\|CP003362.1\|	867904	g33212	i0	100	0.0989399293286219	28	0	10	0	52	79	2196379	2196406	Methanomethylovorans hollandica DSM 15978, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanomethylovorans	Methanomethylovorans hollandica
26660523	26660523	PRJNA1186363_P_NODE_41181_length_247_cov_1.344828_g40293_i0	PRJNA1186363	41181	247	1.344828	3.32172516	archaeon	1906665	Archaea	Archaea	42.7	0.0396	NR	MDP2435053.1	1906665	g40293	i0	45.3	0.643724696356275	53	23	63.2	2	9	164	2051	2098	MDP2435053.1 hypothetical protein [archaeon]	diamond	159	42.7	1	Archaea								archaeon
26755571	26755571	PRJNA1186363_P_NODE_24381_length_370_cov_1.451178_g23493_i0	PRJNA1186363	24381	370	1.451178	5.3693586	Nitrososphaerales archaeon	2268197	Archaea	Archaea	61.6	3.72e-8	NR	MFI5405302.1	2268197	g23493	i0	36.1	0.875675675675676	108	63	84.3	4	57	368	87	192	MFI5405302.1 GTPase [Nitrososphaerales archaeon]	diamond	324	61.6	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales			Nitrososphaerales archaeon
27008919	27008919	PRJNA1186363_P_NODE_42462_length_245_cov_0.906977_g41574_i0	PRJNA1186363	42462	245	0.906977	2.22209365	archaeon	1906665	Archaea	Archaea	67	1.08e-10	NR	MDP2439212.1	1906665	g41574	i0	50.6	2.03265306122449	83	37	96.7	3	239	3	429	511	MDP2439212.1 hypothetical protein [archaeon]	diamond	498	67	1	Archaea								archaeon
27230259	27230259	PRJNA1186363_P_NODE_18523_length_446_cov_1.045576_g17635_i0	PRJNA1186363	18523	446	1.045576	4.66326896	archaeon	1906665	Archaea	Archaea	165	2.29e-49	NR	MDP2436403.1	1906665	g17635	i0	57.4	0.914798206278027	136	58	91.5	0	28	435	1	136	MDP2436403.1 hypothetical protein [archaeon]	diamond	408	165	1	Archaea								archaeon
27230267	27230267	PRJNA1186363_P_NODE_21783_length_400_cov_1.125382_g20895_i0	PRJNA1186363	21783	400	1.125382	4.501528	archaeon	1906665	Archaea	Archaea	227	1.2499999999999998e-73	NR	MDP2438473.1	1906665	g20895	i0	90.2	0.915	122	12	91.5	0	33	398	3	124	MDP2438473.1 GTP-binding protein [archaeon]	diamond	366	227	1	Archaea								archaeon
27262095	27262095	PRJNA1186363_P_NODE_41523_length_247_cov_0.896552_g40635_i0	PRJNA1186363	41523	247	0.896552	2.21448344	archaeon	1906665	Archaea	Archaea	139	2.36e-38	NR	MDP2439249.1	1906665	g40635	i0	82.7	0.983805668016194	81	14	98.4	0	1	243	27	107	MDP2439249.1 MC/SLC25 family protein [archaeon]	diamond	243	139	1	Archaea								archaeon
27325204	27325204	PRJNA1186363_P_NODE_32203_length_298_cov_1.280000_g31315_i0	PRJNA1186363	32203	298	1.28	3.8144	Candidatus Nitrosotenuis sp.	2507556	Archaea	Archaea	48.9	4.63e-4	NR	HEY8109573.1	2507556	g31315	i0	34.9	0.835570469798658	83	47	83.6	1	36	284	3	78	HEY8109573.1 spherulation-specific family 4 protein [Candidatus Nitrosotenuis sp.]	diamond	249	48.9	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis sp.
27451761	27451761	PRJNA1186363_P_NODE_27803_length_336_cov_1.186312_g26915_i0	PRJNA1186363	27803	336	1.186312	3.98600832	archaeon	1906665	Archaea	Archaea	135	4e-36	NR	MDP2438433.1	1906665	g26915	i0	62.2	0.991071428571429	111	41	99.1	1	2	334	2	111	MDP2438433.1 guanylate kinase [archaeon]	diamond	333	135	1	Archaea								archaeon
27514707	27514707	PRJNA1186363_P_NODE_35323_length_275_cov_0.772277_g34435_i0	PRJNA1186363	35323	275	0.772277	2.12376175	Nitrosarchaeum sp.	2026886	Archaea	Archaea	45.8	0.00331	NR	MCA9813149.1	2026886	g34435	i0	46.4	0.610909090909091	56	30	61.1	0	203	36	159	214	MCA9813149.1 helix-turn-helix domain-containing protein [Nitrosarchaeum sp.]	diamond	168	45.8	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp.
28133787	28133787	PRJNA1186363_P_NODE_27725_length_337_cov_1.071970_g26837_i0	PRJNA1186363	27725	337	1.07197	3.6125389	root	1	Root_unresolved	Root_unresolved	92.8	2.5200000000000004e-21	NR	PJB20935.1	1975559	g26837	i0	61.4	1.54896142433234	57	22	50.7	0	329	159	32	88	PJB20935.1 MAG: hypothetical protein CO114_08025 [Euryarchaeota archaeon CG_4_9_14_3_um_filter_38_12]	diamond	522	93.6	0.991452991452991	Archaea		Methanobacteriati	Methanobacteriota					Euryarchaeota archaeon CG_4_9_14_3_um_filter_38_12
28240679	28240679	PRJNA1186363_P_NODE_31286_length_306_cov_1.004292_g30398_i0	PRJNA1186363	31286	306	1.004292	3.07313352	archaeon	1906665	Archaea	Archaea	182	1.9499999999999994e-55	NR	MDP2438894.1	1906665	g30398	i0	95	0.990196078431373	101	5	99	0	2	304	56	156	MDP2438894.1 V-type ATP synthase subunit D [archaeon]	diamond	303	182	1	Archaea								archaeon
28462121	28462121	PRJNA1186363_P_NODE_36766_length_264_cov_0.811518_g35878_i0	PRJNA1186363	36766	264	0.811518	2.14240752	Thermoplasmata archaeon	1906666	Archaea	Archaea	42.7	0.0448	NR	HEV2429800.1	1906666	g35878	i0	45.9	0.420454545454545	37	20	42	0	6	116	43	79	HEV2429800.1 DNA methyltransferase [Thermoplasmata archaeon]	diamond	111	42.7	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
28702083	28702083	PRJNA1186363_P_NODE_39567_length_251_cov_0.876404_g38679_i0	PRJNA1186363	39567	251	0.876404	2.19977404	root	1	Root_unresolved	Root_unresolved	79	7.4e-15	NR	MDP2434228.1	1906665	g38679	i0	47.6	1.97211155378486	82	43	98	0	246	1	327	408	MDP2434228.1 hypothetical protein [archaeon]	diamond	495	79	1	Archaea								archaeon
28967258	28967258	PRJNA1186363_P_NODE_41968_length_246_cov_0.901734_g41080_i0	PRJNA1186363	41968	246	0.901734	2.21826564	archaeon	1906665	Archaea	Archaea	115	5.81e-28	NR	MDP2438299.1	1906665	g41080	i0	69.6	0.963414634146341	79	24	96.3	0	2	238	431	509	MDP2438299.1 hypothetical protein [archaeon]	diamond	237	115	1	Archaea								archaeon
29156750	29156750	PRJNA1186363_P_NODE_27469_length_339_cov_1.466165_g26581_i0	PRJNA1186363	27469	339	1.466165	4.97029935	archaeon	1906665	Archaea	Archaea	87.8	8.32e-19	NR	MDP2434397.1	1906665	g26581	i0	49.5	0.929203539823009	105	48	92	2	8	319	96	196	MDP2434397.1 hypothetical protein [archaeon]	diamond	315	87.8	1	Archaea								archaeon
29598269	29598269	PRJNA1186363_P_NODE_42970_length_244_cov_0.912281_g42082_i0	PRJNA1186363	42970	244	0.912281	2.22596564	archaeon	1906665	Archaea	Archaea	45.1	0.00316	NR	MDP2435168.1	1906665	g42082	i0	40.4	0.577868852459016	47	28	57.8	0	104	244	55	101	MDP2435168.1 hypothetical protein [archaeon]	diamond	141	45.1	1	Archaea								archaeon
29914547	29914547	PRJNA1186363_P_NODE_40551_length_249_cov_0.886364_g39663_i0	PRJNA1186363	40551	249	0.886364	2.20704636	archaeon	1906665	Archaea	Archaea	57.4	2.71e-7	NR	MDP2436913.1	1906665	g39663	i0	35	0.963855421686747	80	52	96.4	0	6	245	538	617	MDP2436913.1 hypothetical protein [archaeon]	diamond	240	57.4	1	Archaea								archaeon
30103780	30103780	PRJNA1186363_P_NODE_41812_length_246_cov_0.901734_g40924_i0	PRJNA1186363	41812	246	0.901734	2.21826564	archaeon	1906665	Archaea	Archaea	83.2	1.35e-17	NR	MDP2437848.1	1906665	g40924	i0	46.9	0.98780487804878	81	40	98.8	1	244	2	106	183	MDP2437848.1 SpoIIE family protein phosphatase [archaeon]	diamond	243	83.2	1	Archaea								archaeon
30514657	30514657	PRJNA1186363_P_NODE_42933_length_244_cov_0.912281_g42045_i0	PRJNA1186363	42933	244	0.912281	2.22596564	archaeon	1906665	Archaea	Archaea	159	2.329999999999999e-47	NR	MDP2436279.1	1906665	g42045	i0	94.9	0.971311475409836	79	4	97.1	0	6	242	59	137	MDP2436279.1 hypothetical protein [archaeon]	diamond	237	159	1	Archaea								archaeon
30988658	30988658	PRJNA1186363_P_NODE_22454_length_392_cov_0.978056_g21566_i0	PRJNA1186363	22454	392	0.978056	3.83397952	archaeon	1906665	Archaea	Archaea	97.1	2e-20	NR	MDP2435572.1	1906665	g21566	i0	42.6	0.987244897959184	129	62	98.7	3	389	3	30	146	MDP2435572.1 filamin/ABP280 repeat domain-containing protein [archaeon]	diamond	387	97.1	1	Archaea								archaeon
31146132	31146132	PRJNA1186363_P_NODE_41115_length_248_cov_0.862857_g40227_i0	PRJNA1186363	41115	248	0.862857	2.13988536	Candidatus Nitrosotenuis sp.	2507556	Archaea	Archaea	48.9	2.5e-4	NR	HXE72416.1	2507556	g40227	i0	40.7	0.653225806451613	54	32	65.3	0	56	217	176	229	HXE72416.1 FAD-binding protein [Candidatus Nitrosotenuis sp.]	diamond	162	48.9	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis sp.
31557889	31557889	PRJNA1186363_P_NODE_31036_length_308_cov_0.995745_g30148_i0	PRJNA1186363	31036	308	0.995745	3.0668946	archaeon	1906665	Archaea	Archaea	134	3.4299999999999995e-37	NR	MDP2436999.1	1906665	g30148	i0	64.9	1.88961038961039	97	34	94.5	0	291	1	1	97	MDP2436999.1 60S ribosomal protein L13 [archaeon]	diamond	582	134	1	Archaea								archaeon
32095453	32095453	PRJNA1186363_P_NODE_42458_length_245_cov_0.906977_g41570_i0	PRJNA1186363	42458	245	0.906977	2.22209365	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	43.9	0.0145	NR	MEM7828143.1	3121606	g41570	i0	35.5	5.3265306122449	62	39	75.9	1	59	244	280	340	MEM7828143.1 amino acid ABC transporter substrate-binding protein [Candidatus Aenigmatarchaeota archaeon]	diamond	1305	43.9	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota					Candidatus Aenigmatarchaeota 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);;