metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA493827" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA493827" 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_species
2380153	2380153	PRJNA493827_P_NODE_114822_length_319_cov_1.252033_g112624_i0	PRJNA493827	114822	319	1.252033	3.99398527	Promethearchaeia archaeon	3067280	Archaea	Archaea	152	3.95e-42	NR	HME54153.1	3067280	g112624	i0	70.5	1.98432601880878	105	31	98.7	0	4	318	116	220	HME54153.1 acetyl-CoA C-acyltransferase [Promethearchaeia archaeon]	diamond	633	152	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeia archaeon
27171451	27171451	PRJNA493827_P_NODE_232522_length_241_cov_0.916667_g230324_i0	PRJNA493827	232522	241	0.916667	2.20916747	Candidatus Thorarchaeota archaeon	2053491	Archaea	Archaea	42.4	0.0492	NR	UCE11833.1	2053491	g230324	i0	35.9	0.796680497925311	64	41	79.7	0	230	39	357	420	UCE11833.1 MAG: ABC transporter permease subunit [Candidatus Thorarchaeota archaeon]	diamond	192	42.4	1	Archaea	Promethearchaeati	Candidatus Thorarchaeota		Candidatus Thorarchaeota archaeon
28087371	28087371	PRJNA493827_P_NODE_195085_length_249_cov_0.875000_g192887_i0	PRJNA493827	195085	249	0.875	2.17875	Promethearchaeia archaeon	3067280	Archaea	Archaea	170	5.49e-51	NR	MFO7797710.1	3067280	g192887	i0	97.6	0.987951807228916	82	2	98.8	0	247	2	161	242	MFO7797710.1 hypothetical protein [Promethearchaeia archaeon]	diamond	246	170	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeia archaeon
28403216	28403216	PRJNA493827_P_NODE_156666_length_274_cov_1.084577_g154468_i0	PRJNA493827	156666	274	1.084577	2.97174098	Promethearchaeia archaeon	3067280	Archaea	Archaea	45.4	0.00508	NR	MFO7797710.1	3067280	g154468	i0	30	1.65328467153285	90	63	98.5	0	3	272	18	107	MFO7797710.1 hypothetical protein [Promethearchaeia archaeon]	diamond	453	45.4	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeia archaeon
29097913	29097913	PRJNA493827_P_NODE_114728_length_319_cov_1.361789_g112530_i0	PRJNA493827	114728	319	1.361789	4.34410691	Promethearchaeota archaeon	2053489	Archaea	Archaea	63.5	4.34e-9	NR	MBD3352732.1	2053489	g112530	i0	69.2	0.733542319749216	39	12	36.7	0	117	1	110	148	MBD3352732.1 protein kinase [Promethearchaeota archaeon]	diamond	234	63.5	1	Archaea	Promethearchaeati	Promethearchaeota		Promethearchaeota archaeon
29192660	29192660	PRJNA493827_P_NODE_100369_length_342_cov_1.144981_g98171_i0	PRJNA493827	100369	342	1.144981	3.91583502	Promethearchaeia archaeon	3067280	Archaea	Archaea	50.1	2.4e-4	NR	MFO7797710.1	3067280	g98171	i0	41.3	0.701754385964912	80	44	67.5	2	342	112	141	220	MFO7797710.1 hypothetical protein [Promethearchaeia archaeon]	diamond	240	50.1	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeia archaeon
29350457	29350457	PRJNA493827_P_NODE_100269_length_342_cov_1.349442_g98071_i0	PRJNA493827	100269	342	1.349442	4.61509164	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	87.8	1.43e-18	NR	MDH5401859.1	2026747	g98071	i0	45.3	0.754385964912281	86	47	75.4	0	9	266	136	221	MDH5401859.1 aquaporin [Candidatus Heimdallarchaeota archaeon]	diamond	258	87.8	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota		Candidatus Heimdallarchaeota archaeon
29571345	29571345	PRJNA493827_P_NODE_176270_length_257_cov_1.538043_g174072_i0	PRJNA493827	176270	257	1.538043	3.95277051	Promethearchaeia archaeon	3067280	Archaea	Archaea	162	2.8999999999999996e-44	NR	MFO7795213.1	3067280	g174072	i0	97.6	0.992217898832685	85	2	99.2	0	257	3	755	839	MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon]	diamond	255	162	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeia archaeon
30772038	30772038	PRJNA493827_P_NODE_172694_length_260_cov_1.566845_g170496_i0	PRJNA493827	172694	260	1.566845	4.073797	Promethearchaeota archaeon	2053489	Archaea	Archaea	47	0.00139	NR	MBY9004229.1	2053489	g170496	i0	36.1	0.830769230769231	72	40	78.5	2	206	3	224	293	MBY9004229.1 GTP-binding protein [Promethearchaeota archaeon]	diamond	216	47	1	Archaea	Promethearchaeati	Promethearchaeota		Promethearchaeota archaeon
30803507	30803507	PRJNA493827_P_NODE_235594_length_239_cov_5.650602_g233395_i0	PRJNA493827	235594	239	5.650602	13.50493878	Candidatus Baldrarchaeota archaeon	2799005	Archaea	Archaea	67.4	6.04e-13	NR	MEX2703090.1	2799005	g233395	i0	70.5	5.13389121338912	44	13	55.2	0	58	189	7	50	MEX2703090.1 30S ribosomal protein S14 [Candidatus Baldrarchaeota archaeon]	diamond	1227	67.4	1	Archaea	Promethearchaeati	Candidatus Baldrarchaeota		Candidatus Baldrarchaeota 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);;