metadata: contig_metadata: 10 rows where bioproject = "PRJNA1010780", tax_phylum = "Promethearchaeota" and tax

10 rows where bioproject = "PRJNA1010780", tax_phylum = "Promethearchaeota" 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_class	tax_order	tax_family	tax_genus	tax_species
26654449	26654449	PRJNA1010780_S_NODE_35741_length_227_cov_1.140625_g34452_i0	PRJNA1010780	35741	227	1.140625	2.58921875	Promethearchaeota archaeon CR_4	1849166	Archaea	Archaea	75.1	5.57e-14	NR	OLS16401.1	1849166	g34452	i0	58.2	0.726872246696035	55	23	72.7	0	196	32	217	271	OLS16401.1 MAG: hypothetical protein RBG13Loki_0029 [Promethearchaeota archaeon CR_4]	diamond	165	75.1	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon CR_4
26876726	26876726	PRJNA1010780_S_NODE_54101_length_166_cov_1.290076_g52812_i0	PRJNA1010780	54101	166	1.290076	2.14152616	Promethearchaeia archaeon	3067280	Archaea	Archaea	55.5	4.18e-7	NR	MFO8017366.1	3067280	g52812	i0	49	1.82530120481928	51	25	92.2	1	1	153	295	344	MFO8017366.1 Rab family GTPase [Promethearchaeia archaeon]	diamond	303	55.5	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia				Promethearchaeia archaeon
27311763	27311763	PRJNA1010780_S_NODE_39443_length_209_cov_2.155172_g38154_i0	PRJNA1010780	39443	209	2.155172	4.50430948	Archaea	2157	Archaea	Archaea	63.5	8.35e-10	NR	MBD3228839.1	2053489	g38154	i0	48.5	3.84688995215311	68	33	94.7	1	4	201	206	273	MBD3228839.1 actin, cytoplasmic 2 [Promethearchaeota archaeon]	diamond	804	63.5	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
29024519	29024519	PRJNA1010780_S_NODE_25688_length_309_cov_1.781022_g24399_i0	PRJNA1010780	25688	309	1.781022	5.50335798	Promethearchaeota archaeon	2053489	Archaea	Archaea	87.4	3.09e-18	NR	NHJ21135.1	2053489	g24399	i0	42	0.854368932038835	88	50	85.4	1	276	13	30	116	NHJ21135.1 hypothetical protein [Promethearchaeota archaeon]	diamond	264	87.4	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
29623593	29623593	PRJNA1010780_S_NODE_5850_length_1108_cov_7.875116_g5271_i0	PRJNA1010780	5850	1108	7.875116	87.25628528	Promethearchaeota archaeon	2053489	Archaea	Archaea	103	1.73e-21	NR	UCC20989.1	2053489	g5271	i0	26	0.728339350180505	269	174	72	7	801	4	30	276	UCC20989.1 MAG: alpha/beta hydrolase [Promethearchaeota archaeon]	diamond	807	103	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
31362011	31362011	PRJNA1010780_S_NODE_56436_length_161_cov_1.968254_g55147_i0	PRJNA1010780	56436	161	1.968254	3.16888894	Promethearchaeota archaeon	2053489	Archaea	Archaea	50.4	2.21e-5	NR	MBD3196182.1	2053489	g55147	i0	45.8	1.75155279503106	48	26	89.4	0	153	10	227	274	MBD3196182.1 tetratricopeptide repeat protein [Promethearchaeota archaeon]	diamond	282	50.4	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
31425052	31425052	PRJNA1010780_S_NODE_55856_length_162_cov_2.307087_g54567_i0	PRJNA1010780	55856	162	2.307087	3.73748094	Candidatus Harpocratesius repetitus	3049170	Archaea	Archaea	43.5	0.00126	NR	MCF2140270.1	3049170	g54567	i0	46.2	1.98148148148148	39	21	72.2	0	43	159	4	42	MCF2140270.1 cold-shock protein [Candidatus Harpocratesius repetitus]	diamond	321	43.5	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeales	Promethearchaeaceae	Candidatus Harpocratesius	Candidatus Harpocratesius repetitus
31741253	31741253	PRJNA1010780_S_NODE_63737_length_150_cov_0.956522_g62448_i0	PRJNA1010780	63737	150	0.956522	1.434783	Promethearchaeota archaeon	2053489	Archaea	Archaea	50.1	2.64e-5	NR	MBD3212008.1	2053489	g62448	i0	52.2	0.92	46	22	92	0	143	6	261	306	MBD3212008.1 hypothetical protein [Promethearchaeota archaeon]	diamond	138	50.1	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
32089369	32089369	PRJNA1010780_S_NODE_42238_length_198_cov_2.251534_g40949_i0	PRJNA1010780	42238	198	2.251534	4.45803732	Promethearchaeota archaeon	2053489	Archaea	Archaea	43.5	0.011	NR	MBY8985620.1	2053489	g40949	i0	41.3	1.53030303030303	46	27	69.7	0	169	32	370	415	MBY8985620.1 right-handed parallel beta-helix repeat-containing protein [Promethearchaeota archaeon]	diamond	303	43.5	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
32564193	32564193	PRJNA1010780_S_NODE_22459_length_355_cov_2.406250_g21170_i0	PRJNA1010780	22459	355	2.40625	8.5421875	Promethearchaeota archaeon	2053489	Archaea	Archaea	46.6	0.00573	NR	MBY9005368.1	2053489	g21170	i0	35.7	0.591549295774648	70	41	55.8	1	326	129	97	166	MBY9005368.1 GTP-binding protein [Promethearchaeota archaeon]	diamond	210	46.6	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota 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);;