metadata: contig_metadata: 15 rows where bioproject = "PRJNA849822" and tax

15 rows where bioproject = "PRJNA849822" 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
3389298	3389298	PRJNA849822_P_NODE_24603_length_292_cov_1.415525_g24429_i0	PRJNA849822	24603	292	1.415525	4.133333	Nitrosopumilus sp.	2024843	Archaea	Archaea	52.8	0.027	NTclustered	gi\|2805380108\|emb\|OY763927.2\|	2024843	g24429	i0	92.105	0.13013698630137	38	2	13	1	179	216	927685	927721	MAG: Nitrosopumilus sp. isolate e501d42f-d10b-4094-a589-3c4c61670bda genome assembly, chromosome: 1	blastn	38	52.8	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
4666965	4666965	PRJNA849822_P_NODE_12704_length_412_cov_2.976401_g12530_i0	PRJNA849822	12704	412	2.976401	12.26277212	Acidianus sulfidivorans	312539	Archaea	Archaea	56.5	0.003	NTclustered	gi\|1820310478\|gb\|CP029288.2\|	619593	g12530	i0	96.97	0.0800970873786408	33	1	8	0	266	298	707439	707471	Acidianus sulfidivorans JP7 chromosome, complete genome	blastn	33	56.5	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Acidianus	Acidianus sulfidivorans
19964929	19964929	PRJNA849822_P_NODE_11816_length_429_cov_1.685393_g11642_i0	PRJNA849822	11816	429	1.685393	7.23033597	root	1	Root_unresolved	Root_unresolved	104	5.219999999999999e-23	NR	MDH3677794.1	2024843	g11642	i0	44.8	2.70629370629371	134	67	93	4	17	415	350	477	MDH3677794.1 peroxidase family protein [Nitrosopumilus sp.]	diamond	1161	105	0.990476190476191	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
26651464	26651464	PRJNA849822_P_NODE_37401_length_248_cov_2.240000_g37227_i0	PRJNA849822	37401	248	2.24	5.5552	root	1	Root_unresolved	Root_unresolved	53.9	4.7e-6	NR	WP_179363299.1	1959104	g37227	i0	39.4	9.16935483870968	71	37	85.9	1	2	214	1484	1548	WP_179363299.1 Ig-like domain-containing protein [Nitrosopumilus oxyclinae]	diamond	2274	54.3	0.992633517495396	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus oxyclinae
27371282	27371282	PRJNA849822_P_NODE_17663_length_345_cov_1.147059_g17489_i0	PRJNA849822	17663	345	1.147059	3.95735355	Thermoproteota archaeon	2056631	Archaea	Archaea	85.5	6.24e-17	NR	NPA99786.1	2056631	g17489	i0	48.1	1.84347826086957	106	48	92.2	1	3	320	16	114	NPA99786.1 RNA 3'-terminal phosphate cyclase [Thermoproteota archaeon]	diamond	636	85.5	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
27915885	27915885	PRJNA849822_P_NODE_15125_length_374_cov_1.368771_g14951_i0	PRJNA849822	15125	374	1.368771	5.11920354	root	1	Root_unresolved	Root_unresolved	48.5	0.00158	NR	MDG6921989.1	2026795	g14951	i0	28.3	1.85294117647059	152	58	81	4	304	2	1049	1200	MDG6921989.1 hypothetical protein [Nitrososphaerota archaeon]	diamond	693	48.5	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
28697336	28697336	PRJNA849822_P_NODE_42307_length_243_cov_0.917647_g42133_i0	PRJNA849822	42307	243	0.917647	2.22988221	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	73.6	3.64e-13	NR	MBS7652186.1	2026714	g42133	i0	47.5	1.97530864197531	80	41	98.8	1	241	2	163	241	MBS7652186.1 methyltransferase [Candidatus Bathyarchaeota archaeon]	diamond	480	73.6	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
29526396	29526396	PRJNA849822_P_NODE_19890_length_325_cov_0.968254_g19716_i0	PRJNA849822	19890	325	0.968254	3.1468255	root	1	Root_unresolved	Root_unresolved	100	2.13e-22	NR	MDI9643857.1	2250257	g19716	i0	72.3	7.55076923076923	65	18	60	0	84	278	3	67	MDI9643857.1 molecular chaperone DnaJ [Candidatus Methanomethylicota archaeon]	diamond	2454	101	0.99009900990099	Archaea	Thermoproteati	Candidatus Methanomethylicota					Candidatus Methanomethylicota archaeon
29683852	29683852	PRJNA849822_P_NODE_15750_length_366_cov_1.368601_g15576_i0	PRJNA849822	15750	366	1.368601	5.00907966	Thermoproteati	1783275	Archaea	Archaea	110	5.4300000000000006e-27	NR	MEM3166191.1	2268187	g15576	i0	53.3	6.30327868852459	107	49	87.7	1	3	323	160	265	MEM3166191.1 RuvB-like domain-containing protein [Candidatus Methanomethylicia archaeon]	diamond	2307	111	0.990990990990991	Archaea	Thermoproteati	Thermoproteota	Methanosuratincolia				Candidatus Methanomethylicia archaeon
29865369	29865369	PRJNA849822_P_NODE_32191_length_258_cov_1.248649_g32017_i0	PRJNA849822	32191	258	1.248649	3.22151442	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	89.7	1.29e-18	NR	MCJ7713084.1	2026714	g32017	i0	56.5	0.988372093023256	85	34	95.3	1	247	2	454	538	MCJ7713084.1 AAA family ATPase [Candidatus Bathyarchaeota archaeon]	diamond	255	89.7	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
30781623	30781623	PRJNA849822_P_NODE_41394_length_244_cov_0.912281_g41220_i0	PRJNA849822	41394	244	0.912281	2.22596564	Nitrososphaera sp.	1971748	Archaea	Archaea	126	9.8e-32	NR	NOJ27505.1	1971748	g41220	i0	84	0.995901639344262	81	13	99.6	0	1	243	64	144	NOJ27505.1 hypothetical protein [Nitrososphaera sp.]	diamond	243	126	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.
30813191	30813191	PRJNA849822_P_NODE_32234_length_258_cov_0.918919_g32060_i0	PRJNA849822	32234	258	0.918919	2.37081102	Desulfurococcales archaeon ex4484_217_2	2012519	Archaea	Archaea	43.5	0.0246	NR	OYT53707.1	2012519	g32060	i0	36.4	1.02325581395349	88	42	91.9	4	255	19	414	496	OYT53707.1 MAG: hypothetical protein B6U76_08215, partial [Desulfurococcales archaeon ex4484_217_2]	diamond	264	43.5	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales			Desulfurococcales archaeon ex4484_217_2
30908134	30908134	PRJNA849822_P_NODE_17774_length_344_cov_1.151292_g17600_i0	PRJNA849822	17774	344	1.151292	3.96044448	Thermofilum	2268	Archaea	Archaea	107	3.61e-26	NR	WP_020962048.1	2268	g17600	i0	54.3	1.64825581395349	92	41	79.4	1	70	342	1	92	WP_020962048.1 MULTISPECIES: adenylate kinase [Thermofilum]	diamond	567	107	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermofilales	Thermofilaceae	Thermofilum
32046491	32046491	PRJNA849822_P_NODE_32558_length_256_cov_1.617486_g32384_i0	PRJNA849822	32558	256	1.617486	4.14076416	Metallosphaera yellowstonensis	1111107	Archaea	Archaea	45.1	0.00629	NR	WP_009069900.1	1111107	g32384	i0	53.3	0.52734375	45	17	52.7	1	221	87	66	106	WP_009069900.1 NAD(P)/FAD-dependent oxidoreductase [Metallosphaera yellowstonensis]	diamond	135	45.1	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Metallosphaera	Metallosphaera yellowstonensis
32236672	32236672	PRJNA849822_P_NODE_6818_length_591_cov_1.691120_g6649_i0	PRJNA849822	6818	591	1.69112	9.9945192	Thermoprotei archaeon	2250277	Archaea	Archaea	65.5	4.89e-9	NR	RLG82655.1	2250277	g6649	i0	38.5	1.14720812182741	91	53	44.7	1	296	33	138	228	RLG82655.1 MAG: hypothetical protein DRO40_07150 [Thermoprotei archaeon]	diamond	678	65.5	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei				Thermoprotei 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);;