metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA744060" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA744060" 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_species
723347	723347	PRJNA744060_P_NODE_36221_length_275_cov_1.341584_g35892_i0	PRJNA744060	36221	275	1.341584	3.689356	Promethearchaeota archaeon CR_4	1849166	Archaea	Archaea	128	3.98e-33	NR	OLS14603.1	1849166	g35892	i0	68.5	0.970909090909091	89	28	97.1	0	9	275	10	98	OLS14603.1 MAG: acetyl-CoA acetyltransferase [Promethearchaeota archaeon CR_4]	diamond	267	128	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeota archaeon CR_4
26894686	26894686	PRJNA744060_P_NODE_10301_length_499_cov_1.960094_g9973_i0	PRJNA744060	10301	499	1.960094	9.78086906	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	68.6	5.68e-10	NR	UCE12300.1	2026747	g9973	i0	34.5	0.715430861723447	119	74	70.3	3	441	91	763	879	UCE12300.1 MAG: VWA domain-containing protein [Candidatus Heimdallarchaeota archaeon]	diamond	357	68.6	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon
28316047	28316047	PRJNA744060_P_NODE_21006_length_353_cov_1.607143_g20677_i0	PRJNA744060	21006	353	1.607143	5.67321479	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	65.9	1.08e-9	NR	MCY3415128.1	2026747	g20677	i0	34.9	1.81869688385269	109	64	92.6	2	23	349	1092	1193	MCY3415128.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon]	diamond	642	65.9	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota	Candidatus Heimdallarchaeota archaeon
28600277	28600277	PRJNA744060_P_NODE_25127_length_324_cov_1.844622_g24798_i0	PRJNA744060	25127	324	1.844622	5.97657528	Promethearchaeota archaeon	2053489	Archaea	Archaea	107	1.86e-24	NR	TFG30480.1	2053489	g24798	i0	49.1	0.981481481481482	106	51	98.1	1	2	319	556	658	TFG30480.1 MAG: hypothetical protein EU532_00820 [Promethearchaeota archaeon]	diamond	318	107	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeota archaeon
29020970	29020970	PRJNA744060_P_NODE_49688_length_244_cov_1.368421_g49359_i0	PRJNA744060	49688	244	1.368421	3.33894724	Promethearchaeati	1935183	Archaea	Archaea	108	8.56e-26	NR	MEX2701911.1	2799005	g49359	i0	62.8	3.83606557377049	78	29	95.9	0	235	2	123	200	MEX2701911.1 actin, cytoplasmic 2 [Candidatus Baldrarchaeota archaeon]	diamond	936	109	0.990825688073395	Archaea	Promethearchaeati	Candidatus Baldrarchaeota	Candidatus Baldrarchaeota archaeon
31949129	31949129	PRJNA744060_P_NODE_33877_length_283_cov_1.647619_g33548_i0	PRJNA744060	33877	283	1.647619	4.66276177	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	99	1.04e-21	NR	MCE7735648.1	2026747	g33548	i0	51.6	1.00706713780919	95	44	98.6	1	282	4	479	573	MCE7735648.1 CocE/NonD family hydrolase [Candidatus Heimdallarchaeota archaeon]	diamond	285	99	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);;