metadata: contig_metadata: 5 rows where bioproject = "PRJNA888821" and tax

5 rows where bioproject = "PRJNA888821" 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
4691514	4691514	PRJNA888821_P_NODE_46724_length_215_cov_11.591549_g46641_i0	PRJNA888821	46724	215	11.591549	24.92183035	Saccharolobus islandicus	43080	Archaea	Archaea	300	6.13e-77	NTclustered	gi\|323473489\|gb\|CP002425.1\|	930945	g46641	i0	91.102	78.646511627907	236	0	100	1	1	215	890958	890723	Sulfolobus islandicus REY15A, complete genome	blastn	16909	300	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Saccharolobus	Saccharolobus islandicus
28918492	28918492	PRJNA888821_P_NODE_44308_length_223_cov_26.386667_g44225_i0	PRJNA888821	44308	223	26.386667	58.84226741	Thermoproteota archaeon	2056631	Archaea	Archaea	154	1.77e-46	NR	MDQ3727269.1	2056631	g44225	i0	98.6	2.94618834080717	74	1	99.6	0	222	1	15	88	MDQ3727269.1 hypothetical protein [Thermoproteota archaeon]	diamond	657	154	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
31192530	31192530	PRJNA888821_P_NODE_14675_length_310_cov_6.793249_g14593_i0	PRJNA888821	14675	310	6.793249	21.0590719	Nitrososphaerales archaeon	2268197	Archaea	Archaea	60.5	1e-8	NR	MFI5407391.1	2268197	g14593	i0	63.6	0.851612903225806	44	16	42.6	0	149	18	124	167	MFI5407391.1 endonuclease/exonuclease/phosphatase family protein [Nitrososphaerales archaeon]	diamond	264	60.5	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales			Nitrososphaerales archaeon
31667253	31667253	PRJNA888821_P_NODE_29457_length_272_cov_6.788945_g29375_i0	PRJNA888821	29457	272	6.788945	18.4659304	Candidatus Nitrosocosmicus sp.	2109671	Archaea	Archaea	53.5	1.97e-6	NR	MDR4489495.1	2109671	g29375	i0	57.4	0.518382352941177	47	19	51.8	1	149	9	1	46	MDR4489495.1 hypothetical protein [Candidatus Nitrosocosmicus sp.]	diamond	141	53.5	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus sp.
32300464	32300464	PRJNA888821_P_NODE_31379_length_264_cov_3.952880_g31296_i0	PRJNA888821	31379	264	3.95288	10.4356032	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	139	9.74e-39	NR	HEX6646956.1	2169593	g31296	i0	83.5	0.897727272727273	79	13	89.8	0	237	1	1	79	HEX6646956.1 phosphate ABC transporter ATP-binding protein PstB [Nitrososphaeraceae archaeon]	diamond	237	139	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae 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);;