metadata: contig_metadata: 5 rows where bioproject = "PRJNA867519", tax_phylum = "Thermoproteota" and tax

5 rows where bioproject = "PRJNA867519", tax_phylum = "Thermoproteota" 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_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
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
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);;