metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA853203" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA853203" 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_species
30054857	30054857	PRJNA853203_P_NODE_22071_length_262_cov_1.201058_g21922_i0	PRJNA853203	22071	262	1.201058	3.14677196	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	98.2	1.85e-22	NR	HZC32200.1	3045160	g21922	i0	48.9	1.00763358778626	88	43	98.5	1	261	4	172	259	HZC32200.1 phage BR0599 family protein [Candidatus Bathyarchaeia archaeon]	diamond	264	98.2	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia			Candidatus Bathyarchaeia archaeon
31097536	31097536	PRJNA853203_P_NODE_42475_length_244_cov_2.538012_g42326_i0	PRJNA853203	42475	244	2.538012	6.19274928	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	123	6.63e-31	NR	MDH5201424.1	2026714	g42326	i0	67.1	2.91393442622951	79	26	97.1	0	242	6	201	279	MDH5201424.1 hypothetical protein [Candidatus Bathyarchaeota archaeon]	diamond	711	123	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota				Candidatus Bathyarchaeota archaeon
31160504	31160504	PRJNA853203_P_NODE_3755_length_359_cov_1.888112_g3607_i0	PRJNA853203	3755	359	1.888112	6.77832208	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	134	1.1699999999999999e-34	NR	HVQ35564.1	3045160	g3607	i0	61	5.33983286908078	105	41	87.7	0	359	45	303	407	HVQ35564.1 ATP-binding protein [Candidatus Bathyarchaeia archaeon]	diamond	1917	134	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia			Candidatus Bathyarchaeia archaeon
31413895	31413895	PRJNA853203_P_NODE_28196_length_252_cov_1.385475_g28047_i0	PRJNA853203	28196	252	1.385475	3.491397	Thermoproteota archaeon	2056631	Archaea	Archaea	71.6	4.4e-13	NR	NLE03261.1	2056631	g28047	i0	48.1	2.79761904761905	77	33	91.7	1	233	3	5	74	NLE03261.1 DNA (cytosine-5-)-methyltransferase [Thermoproteota archaeon]	diamond	705	71.6	1	Archaea	Thermoproteati	Thermoproteota				Thermoproteota archaeon
32236731	32236731	PRJNA853203_P_NODE_24378_length_257_cov_1.336957_g24229_i0	PRJNA853203	24378	257	1.336957	3.43597949	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	67.8	6.47e-11	NR	MDW0238181.1	2169593	g24229	i0	49.4	0.898832684824903	77	37	88.7	2	3	230	121	196	MDW0238181.1 phage portal protein [Nitrososphaeraceae archaeon]	diamond	231	67.8	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);;