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

5 rows where bioproject = "PRJNA1204310" and tax_kingdom = "Promethearchaeati"

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
7982555	7982555	PRJNA1204310_P_NODE_30567_length_337_cov_1.155303_g30270_i0	PRJNA1204310	30567	337	1.155303	3.89337111	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	115	2.38e-28	NR	MCE7748482.1	2026747	g30270	i0	50	1.90504451038576	112	54	99.7	1	2	337	170	279	MCE7748482.1 NAD(P)-dependent alcohol dehydrogenase [Candidatus Heimdallarchaeota archaeon]	diamond	642	115	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota					Candidatus Heimdallarchaeota archaeon
27578113	27578113	PRJNA1204310_P_NODE_46804_length_268_cov_2.400000_g46507_i0	PRJNA1204310	46804	268	2.4	6.432	Candidatus Harpocratesius repetitus	3049170	Archaea	Archaea	133	6.019999999999998e-35	NR	MCF2139674.1	3049170	g46507	i0	74.2	0.996268656716418	89	23	99.6	0	267	1	1	89	MCF2139674.1 thiolase family protein [Candidatus Harpocratesius repetitus]	diamond	267	133	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeales	Promethearchaeaceae	Candidatus Harpocratesius	Candidatus Harpocratesius repetitus
28114726	28114726	PRJNA1204310_P_NODE_2205_length_1063_cov_9.311111_g2014_i0	PRJNA1204310	2205	1063	9.311111	98.97710993	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	58.9	1.16e-5	NR	MBS85984.1	2026747	g2014	i0	22.3	0.846660395108184	300	203	83.3	9	1034	150	1	275	MBS85984.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon]	diamond	900	58.9	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota					Candidatus Heimdallarchaeota archaeon
29062252	29062252	PRJNA1204310_P_NODE_4228_length_815_cov_3.756065_g3977_i0	PRJNA1204310	4228	815	3.756065	30.61192975	Promethearchaeota archaeon	2053489	Archaea	Archaea	71.2	2.75e-11	NR	MBD3254165.1	2053489	g3977	i0	31.9	1.17055214723926	160	95	58.9	4	648	169	3	148	MBD3254165.1 hypothetical protein [Promethearchaeota archaeon]	diamond	954	71.2	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
31937407	31937407	PRJNA1204310_P_NODE_48157_length_263_cov_1.242105_g47860_i0	PRJNA1204310	48157	263	1.242105	3.26673615	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	64.3	6.97e-10	NR	MCG3215690.1	2026747	g47860	i0	46.6	1.61977186311787	73	34	83.3	2	17	235	124	191	MCG3215690.1 SDR family oxidoreductase [Candidatus Heimdallarchaeota archaeon]	diamond	426	64.3	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);;