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

19 rows where bioproject = "PRJNA560932" and tax_kingdom = "Thermoproteati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
13298805	13298805	PRJNA560932_P_NODE_49271_length_259_cov_1.365591_g48915_i0	PRJNA560932	49271	259	1.365591	3.53688069	Nitrosarchaeum sp.	2026886	Archaea	Archaea	111	3.46e-26	NR	MFB5612793.1	2026886	g48915	i0	71.8	0.984555984555985	85	24	98.5	0	2	256	518	602	MFB5612793.1 molecular chaperone DnaK [Nitrosarchaeum sp.]	diamond	255	111	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp.
23496830	23496830	PRJNA560932_P_NODE_13999_length_468_cov_1.417722_g13644_i0	PRJNA560932	13999	468	1.417722	6.63493896	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	103	2.6e-22	NR	HUW61906.1	3045160	g13644	i0	36.8	1.04487179487179	163	89	96.2	4	14	463	248	409	HUW61906.1 C1 family peptidase [Candidatus Bathyarchaeia archaeon]	diamond	489	103	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
26681402	26681402	PRJNA560932_P_NODE_61201_length_245_cov_0.895349_g60845_i0	PRJNA560932	61201	245	0.895349	2.19360505	root	1	Root_unresolved	Root_unresolved	47	0.00114	NR	MDP2900478.1	2026714	g60845	i0	36.1	3.57551020408163	72	44	85.7	1	215	6	225	296	MDP2900478.1 TFIIB-type zinc ribbon-containing protein [Candidatus Bathyarchaeota archaeon]	diamond	876	47	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
26712919	26712919	PRJNA560932_P_NODE_38221_length_294_cov_1.389140_g37865_i0	PRJNA560932	38221	294	1.38914	4.0840716	Thermoproteati	1783275	Archaea	Archaea	45.1	0.00955	NR	MEM4316274.1	2026795	g37865	i0	28.9	2.54081632653061	83	56	84.7	2	43	291	200	279	MEM4316274.1 DUF3782 domain-containing protein [Nitrososphaerota archaeon]	diamond	747	45.4	0.993392070484582	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
26889446	26889446	PRJNA560932_P_NODE_58121_length_247_cov_0.885057_g57765_i0	PRJNA560932	58121	247	0.885057	2.18609079	Thermoprotei archaeon	2250277	Archaea	Archaea	112	9.95e-27	NR	RLF22639.1	2250277	g57765	i0	63.8	3.88663967611336	80	27	97.2	1	245	6	75	152	RLF22639.1 MAG: ribosome biogenesis/translation initiation ATPase RLI [Thermoprotei archaeon]	diamond	960	112	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei				Thermoprotei archaeon
26952340	26952340	PRJNA560932_P_NODE_61742_length_244_cov_9.000000_g61386_i0	PRJNA560932	61742	244	9	21.96	Candidatus Bathyarchaeota archaeon B26-1	1779370	Archaea	Archaea	68.6	2.3e-13	NR	KYH39817.1	1779370	g61386	i0	56.6	1.20491803278689	53	23	65.2	0	230	72	1	53	KYH39817.1 MAG: 30S ribosomal protein S14 [Candidatus Bathyarchaeota archaeon B26-1]	diamond	294	68.6	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon B26-1
27693526	27693526	PRJNA560932_P_NODE_48264_length_262_cov_1.629630_g47908_i0	PRJNA560932	48264	262	1.62963	4.2696306	root	1	Root_unresolved	Root_unresolved	43.1	0.0231	NR	WP_148703158.1	338191	g47908	i0	35.1	1.94656488549618	57	36	65.3	1	260	90	117	172	WP_148703158.1 MULTISPECIES: NADPH-dependent FMN reductase [Nitrosopumilus]	diamond	510	43.1	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus
27756633	27756633	PRJNA560932_P_NODE_28484_length_336_cov_3.148289_g28128_i0	PRJNA560932	28484	336	3.148289	10.57825104	Candidatus Nitrosotenuis	1825023	Archaea	Archaea	104	5.02e-25	NR	MBI5698011.1	2026795	g28128	i0	58	4.30357142857143	81	34	72.3	0	64	306	4	84	MBI5698011.1 ammonium transporter [Nitrososphaerota archaeon]	diamond	1446	104	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
28153120	28153120	PRJNA560932_P_NODE_65285_length_242_cov_0.911243_g64929_i0	PRJNA560932	65285	242	0.911243	2.20520806	Candidatus Bathycorpusculum soli	3139629	Archaea	Archaea	42.7	0.0369	NR	MDR2203897.1	3139629	g64929	i0	32.9	0.90495867768595	73	45	88	2	5	217	247	317	MDR2203897.1 GTP-binding protein [Candidatus Bathycorpusculum soli]	diamond	219	42.7	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia	Candidatus Bathyarchaeales	Candidatus Bathycorpusculaceae	Candidatus Bathycorpusculum	Candidatus Bathycorpusculum soli
28215761	28215761	PRJNA560932_P_NODE_17786_length_417_cov_1.343023_g17430_i0	PRJNA560932	17786	417	1.343023	5.60040591	Vulcanisaeta moutnovskia	985052	Archaea	Archaea	95.5	1.54e-20	NR	WP_013604536.1	985052	g17430	i0	36.6	1.02158273381295	142	85	98.6	3	3	413	134	275	WP_013604536.1 polyamine aminopropyltransferase [Vulcanisaeta moutnovskia]	diamond	426	95.5	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Vulcanisaeta	Vulcanisaeta moutnovskia
28324622	28324622	PRJNA560932_P_NODE_63646_length_243_cov_0.905882_g63290_i0	PRJNA560932	63646	243	0.905882	2.20129326	Thermoproteati	1783275	Archaea	Archaea	57	3.02e-7	NR	WP_172602162.1	1798806	g63290	i0	36.1	5.82716049382716	83	40	88.9	2	243	28	125	205	WP_172602162.1 ribose-phosphate diphosphokinase [Candidatus Nitrosocosmicus franklandus]	diamond	1416	57	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus franklandianus
29321007	29321007	PRJNA560932_P_NODE_10929_length_527_cov_1.017621_g10575_i0	PRJNA560932	10929	527	1.017621	5.36286267	Candidatus Marsarchaeota archaeon	2823144	Archaea	Archaea	56.6	8.01e-6	NR	MCL5412019.1	2823144	g10575	i0	45.1	2.25996204933586	51	27	29	1	289	441	261	310	MCL5412019.1 translation elongation factor EF-1 subunit alpha [Candidatus Marsarchaeota archaeon]	diamond	1191	56.6	1	Archaea	Thermoproteati	Candidatus Marsarchaeota					Candidatus Marsarchaeota archaeon
29966676	29966676	PRJNA560932_P_NODE_1591_length_1229_cov_3.747405_g1421_i0	PRJNA560932	1591	1229	3.747405	46.05560745	root	1	Root_unresolved	Root_unresolved	364	5.24e-120	NR	WP_101010768.1	1499975	g1421	i0	52	15.2172497965826	344	156	82.8	3	78	1094	54	393	WP_101010768.1 multicopper oxidase domain-containing protein [Nitrosotalea sinensis]	diamond	18702	364	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosotaleales	Nitrosotaleaceae	Nitrosotalea	Nitrosotalea sinensis
30710869	30710869	PRJNA560932_P_NODE_1554_length_1240_cov_3.139674_g1386_i0	PRJNA560932	1554	1240	3.139674	38.9319576	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	53.1	0.0013	NR	MCD6242836.1	2026714	g1386	i0	37.5	0.704032258064516	72	45	17.4	0	729	514	2	73	MCD6242836.1 glycosyltransferase family 2 protein [Candidatus Bathyarchaeota archaeon]	diamond	873	53.1	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
30914618	30914618	PRJNA560932_P_NODE_22914_length_370_cov_1.898990_g22558_i0	PRJNA560932	22914	370	1.89899	7.026263	root	1	Root_unresolved	Root_unresolved	43.9	0.0493	NR	HJS64354.1	2169593	g22558	i0	54.5	0.608108108108108	33	15	26.8	0	153	251	232	264	HJS64354.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	225	44.3	0.99097065462754	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
30932156	30932156	PRJNA560932_P_NODE_42894_length_279_cov_1.189320_g42538_i0	PRJNA560932	42894	279	1.18932	3.3182028	Acidilobus saccharovorans	242703	Archaea	Archaea	75.9	2.67e-15	NR	WP_238523592.1	242703	g42538	i0	46.8	1.62365591397849	77	41	82.8	0	239	9	4	80	WP_238523592.1 peptidyl-tRNA hydrolase Pth2 [Acidilobus saccharovorans]	diamond	453	75.9	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Acidilobales	Acidilobaceae	Acidilobus	Acidilobus saccharovorans
31216091	31216091	PRJNA560932_P_NODE_61555_length_245_cov_0.895349_g61199_i0	PRJNA560932	61555	245	0.895349	2.19360505	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	107	1.3500000000000002e-26	NR	MCJ7636954.1	2169593	g61199	i0	64.6	9.66122448979592	79	28	96.7	0	8	244	73	151	MCJ7636954.1 ammonia channel protein [Nitrososphaeraceae archaeon]	diamond	2367	107	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
31690894	31690894	PRJNA560932_P_NODE_62557_length_244_cov_0.900585_g62201_i0	PRJNA560932	62557	244	0.900585	2.1974274	Nitrososphaerota archaeon	2026795	Archaea	Archaea	90.9	1.3e-19	NR	MEM3062935.1	2026795	g62201	i0	50.7	1.74590163934426	71	34	87.3	1	1	213	205	274	MEM3062935.1 hypothetical protein [Nitrososphaerota archaeon]	diamond	426	90.9	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
31754153	31754153	PRJNA560932_P_NODE_49497_length_258_cov_1.664865_g49141_i0	PRJNA560932	49497	258	1.664865	4.2953517	Candidatus Nitrosocaldus islandicus	2045011	Archaea	Archaea	114	1.3100000000000002e-27	NR	WP_103288010.1	2045011	g49141	i0	64.7	3.95348837209302	85	30	98.8	0	257	3	13	97	WP_103288010.1 IMP dehydrogenase [Candidatus Nitrosocaldus islandicus]	diamond	1020	114	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Candidatus Nitrosocaldales	Candidatus Nitrosocaldaceae	Candidatus Nitrosocaldus	Candidatus Nitrosocaldus islandicus

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