metadata: contig_metadata: 10 rows where bioproject = "PRJNA867519" and tax

10 rows where bioproject = "PRJNA867519" 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
4676467	4676467	PRJNA867519_P_NODE_16124_length_295_cov_1.040541_g15970_i0	PRJNA867519	16124	295	1.040541	3.06959595	Acidianus hospitalis	563177	Archaea	Archaea	52.8	0.027	NTclustered	gi\|332693428\|gb\|CP002535.1\|	933801	g15970	i0	100	0.0949152542372881	28	0	9	0	247	274	1122679	1122652	Acidianus hospitalis W1, complete genome	blastn	28	52.8	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Acidianus	Acidianus hospitalis
27876347	27876347	PRJNA867519_P_NODE_18305_length_283_cov_1.466667_g18151_i0	PRJNA867519	18305	283	1.466667	4.15066761	Nitrososphaerota archaeon	2026795	Archaea	Archaea	59.3	9.34e-8	NR	MDG6921989.1	2026795	g18151	i0	35.2	0.964664310954064	91	56	94.3	2	8	274	697	786	MDG6921989.1 hypothetical protein [Nitrososphaerota archaeon]	diamond	273	59.3	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
28034425	28034425	PRJNA867519_P_NODE_23405_length_260_cov_2.042781_g23251_i0	PRJNA867519	23405	260	2.042781	5.3112306	Nitrosotalea devaniterrae	1078905	Archaea	Archaea	58.5	1.22e-7	NR	6VCF_A	1078905	g23251	i0	35.9	0.9	78	48	88.8	2	250	20	317	393	6VCF_A Chain A, carotenoid cleavage dioxygenase [Nitrosotalea devaniterrae]	diamond	234	58.5	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosotaleales	Nitrosotaleaceae	Nitrosotalea	Nitrosotalea devaniterrae
28855034	28855034	PRJNA867519_P_NODE_21428_length_269_cov_1.571429_g21274_i0	PRJNA867519	21428	269	1.571429	4.22714401	Nitrososphaerota archaeon	2026795	Archaea	Archaea	79	9.57e-15	NR	MDG6921989.1	2026795	g21274	i0	51.9	0.8810408921933092	79	38	88.1	0	250	14	1080	1158	MDG6921989.1 hypothetical protein [Nitrososphaerota archaeon]	diamond	237	79	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
29021559	29021559	PRJNA867519_P_NODE_6488_length_429_cov_1.705056_g6334_i0	PRJNA867519	6488	429	1.705056	7.31469024	Archaea	2157	Archaea	Archaea	138	3.07e-36	NR	MEM3449643.1	2026795	g6334	i0	46.1	9.86013986013986	141	74	98.6	1	427	5	39	177	MEM3449643.1 aminotransferase class V-fold PLP-dependent enzyme [Nitrososphaerota archaeon]	diamond	4230	139	0.992805755395683	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
29738988	29738988	PRJNA867519_P_NODE_1750_length_741_cov_3.561377_g1603_i0	PRJNA867519	1750	741	3.561377	26.38980357	Vulcanisaeta sp. JCM 14467	1295370	Archaea	Archaea	63.9	1.16e-7	NR	WP_054849042.1	1295370	g1603	i0	46.4	0.279352226720648	69	37	27.9	0	12	218	305	373	WP_054849042.1 ankyrin repeat domain-containing protein [Vulcanisaeta sp. JCM 14467]	diamond	207	63.9	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Vulcanisaeta	Vulcanisaeta sp. JCM 14467
30466191	30466191	PRJNA867519_P_NODE_28673_length_247_cov_0.885057_g28519_i0	PRJNA867519	28673	247	0.885057	2.18609079	Thermoprotei archaeon	2250277	Archaea	Archaea	115	1.1300000000000002e-27	NR	RLF22639.1	2250277	g28519	i0	61	3.98380566801619	82	30	99.6	1	2	247	69	148	RLF22639.1 MAG: ribosome biogenesis/translation initiation ATPase RLI [Thermoprotei archaeon]	diamond	984	115	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei				Thermoprotei archaeon
31223981	31223981	PRJNA867519_P_NODE_10875_length_347_cov_1.529197_g10721_i0	PRJNA867519	10875	347	1.529197	5.30631359	Desulfurococcales archaeon	2480821	Archaea	Archaea	58.9	1.82e-8	NR	MCE4621442.1	2480821	g10721	i0	38.3	2.74063400576369	115	50	88.2	2	312	7	2	108	MCE4621442.1 YbjQ family protein [Desulfurococcales archaeon]	diamond	951	58.9	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales			Desulfurococcales archaeon
31255803	31255803	PRJNA867519_P_NODE_16335_length_293_cov_1.109091_g16181_i0	PRJNA867519	16335	293	1.109091	3.24963663	Nitrososphaerota archaeon	2026795	Archaea	Archaea	43.9	0.024	NR	MBI2126805.1	2026795	g16181	i0	35.1	1.21843003412969	57	33	54.3	1	284	126	166	222	MBI2126805.1 CBS domain-containing protein [Nitrososphaerota archaeon]	diamond	357	43.9	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
31635318	31635318	PRJNA867519_P_NODE_33096_length_242_cov_0.911243_g32942_i0	PRJNA867519	33096	242	0.911243	2.20520806	Thermoprotei archaeon	2250277	Archaea	Archaea	49.3	9.24e-5	NR	RLG84825.1	2250277	g32942	i0	36.7	0.979338842975207	79	46	97.9	2	238	2	101	175	RLG84825.1 MAG: hypothetical protein DRO39_07105 [Thermoprotei archaeon]	diamond	237	49.3	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);;