metadata: contig_metadata: 5 rows where bioproject = "PRJNA565584", tax_phylum = "Candidatus Heimdallarchaeota" and tax

5 rows where bioproject = "PRJNA565584", tax_phylum = "Candidatus Heimdallarchaeota" 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_species
27110823	27110823	PRJNA565584_P_NODE_18862_length_736_cov_1.933635_g17769_i0	PRJNA565584	18862	736	1.933635	14.2315536	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	149	1.09e-40	NR	MDH5401859.1	2026747	g17769	i0	36.6	0.925271739130435	227	139	92.5	2	728	48	5	226	MDH5401859.1 aquaporin [Candidatus Heimdallarchaeota archaeon]	diamond	681	149	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon
28816069	28816069	PRJNA565584_P_NODE_47668_length_432_cov_1.005571_g46517_i0	PRJNA565584	47668	432	1.005571	4.34406672	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	79	1.04e-14	NR	TET81129.1	2026747	g46517	i0	38.5	8.82638888888889	122	67	84.7	3	392	27	65	178	TET81129.1 MAG: Kae1-associated serine/threonine protein kinase [Candidatus Heimdallarchaeota archaeon]	diamond	3813	79	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon
29037528	29037528	PRJNA565584_P_NODE_15908_length_814_cov_1.585695_g14841_i0	PRJNA565584	15908	814	1.585695	12.9075573	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	162	1.82e-42	NR	MCH8907703.1	2026747	g14841	i0	39.8	1.67690417690418	226	119	82.6	6	679	8	270	480	MCH8907703.1 CD36 family protein [Candidatus Heimdallarchaeota archaeon]	diamond	1365	162	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon
29069095	29069095	PRJNA565584_P_NODE_42128_length_461_cov_2.747423_g40977_i0	PRJNA565584	42128	461	2.747423	12.66562003	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	70.5	8.59e-11	NR	MCY3415128.1	2026747	g40977	i0	36.5	0.676789587852495	104	60	67.7	2	318	7	10	107	MCY3415128.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon]	diamond	312	70.5	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon
31279948	31279948	PRJNA565584_P_NODE_110315_length_288_cov_1.279070_g109163_i0	PRJNA565584	110315	288	1.27907	3.6837216	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	126	2.29e-31	NR	MCY3414927.1	2026747	g109163	i0	66	0.979166666666667	94	30	95.8	1	279	4	170	263	MCY3414927.1 BspA family leucine-rich repeat surface protein [Candidatus Heimdallarchaeota archaeon]	diamond	282	126	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota 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);;