metadata: contig_metadata: 10 rows where bioproject = "PRJNA1067370" and tax

10 rows where bioproject = "PRJNA1067370" 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
26814125	26814125	PRJNA1067370_P_NODE_38621_length_323_cov_1.924000_g38073_i0	PRJNA1067370	38621	323	1.924	6.21452	Promethearchaeota archaeon	2053489	Archaea	Archaea	50.8	1.2e-4	NR	MBD3193731.1	2053489	g38073	i0	40.7	0.547987616099071	59	29	49.2	1	120	278	131	189	MBD3193731.1 GTP-binding protein [Promethearchaeota archaeon]	diamond	177	50.8	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
28456929	28456929	PRJNA1067370_P_NODE_36226_length_331_cov_1.519380_g35678_i0	PRJNA1067370	36226	331	1.51938	5.0291478	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	44.7	0.00931	NR	MCG3258108.1	2026747	g35678	i0	31.3	1.79456193353474	99	65	88.8	2	21	314	60	156	MCG3258108.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon]	diamond	594	44.7	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota					Candidatus Heimdallarchaeota archaeon
28614718	28614718	PRJNA1067370_P_NODE_4687_length_811_cov_2.487805_g4203_i0	PRJNA1067370	4687	811	2.487805	20.17609855	Candidatus Odinarchaeota archaeon	2053490	Archaea	Archaea	56.6	3.88e-5	NR	MCD6483764.1	2053490	g4203	i0	26.5	0.75462392108508	204	132	71.4	7	62	640	64	260	MCD6483764.1 hypothetical protein [Candidatus Odinarchaeota archaeon]	diamond	612	56.6	1	Archaea	Promethearchaeati	Candidatus Odinarchaeota					Candidatus Odinarchaeota archaeon
28858846	28858846	PRJNA1067370_P_NODE_87808_length_249_cov_0.875000_g87259_i0	PRJNA1067370	87808	249	0.875	2.17875	Candidatus Lokiarchaeum	1655637	Archaea	Archaea	82.4	2.82e-16	NR	KKK42630.1	1538547	g87259	i0	46.9	1.96385542168675	81	43	97.6	0	248	6	233	313	KKK42630.1 MAG: hypothetical protein Lokiarch_33560, partial [Candidatus Lokiarchaeum sp. GC14_75]	diamond	489	82.4	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeales	Promethearchaeaceae	Candidatus Lokiarchaeum	Candidatus Lokiarchaeum sp. GC14_75
29404039	29404039	PRJNA1067370_P_NODE_34289_length_338_cov_1.373585_g33741_i0	PRJNA1067370	34289	338	1.373585	4.6427173	Promethearchaeota archaeon	2053489	Archaea	Archaea	44.7	0.0125	NR	UCC21304.1	2053489	g33741	i0	44.2	0.461538461538462	52	29	46.2	0	24	179	123	174	UCC21304.1 MAG: GTP-binding protein [Promethearchaeota archaeon]	diamond	156	44.7	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
30098709	30098709	PRJNA1067370_P_NODE_71132_length_263_cov_1.210526_g70583_i0	PRJNA1067370	71132	263	1.210526	3.18368338	Candidatus Thorarchaeota archaeon	2053491	Archaea	Archaea	45.8	0.00351	NR	NHJ14199.1	2053491	g70583	i0	35.6	0.832699619771863	73	42	83.3	2	34	252	212	279	NHJ14199.1 hypothetical protein [Candidatus Thorarchaeota archaeon]	diamond	219	45.8	1	Archaea	Promethearchaeati	Candidatus Thorarchaeota					Candidatus Thorarchaeota archaeon
30920486	30920486	PRJNA1067370_P_NODE_29254_length_359_cov_1.412587_g28706_i0	PRJNA1067370	29254	359	1.412587	5.07118733	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	75.5	3.35e-13	NR	MDH5404732.1	2026747	g28706	i0	37.3	0.986072423398329	118	66	92.8	2	23	355	196	312	MDH5404732.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon]	diamond	354	75.5	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota					Candidatus Heimdallarchaeota archaeon
31015093	31015093	PRJNA1067370_P_NODE_69095_length_266_cov_1.259067_g68546_i0	PRJNA1067370	69095	266	1.259067	3.34911822	Promethearchaeia archaeon	3067280	Archaea	Archaea	62	7.78e-9	NR	MFO8018952.1	3067280	g68546	i0	38.2	0.857142857142857	76	34	85.7	3	38	265	331	393	MFO8018952.1 trehalase family glycosidase [Promethearchaeia archaeon]	diamond	228	62	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia				Promethearchaeia archaeon
31267942	31267942	PRJNA1067370_P_NODE_47615_length_302_cov_1.388646_g47067_i0	PRJNA1067370	47615	302	1.388646	4.19371092	Promethearchaeota archaeon	2053489	Archaea	Archaea	43.5	0.0364	NR	MBY8981975.1	2053489	g47067	i0	29.5	0.874172185430464	88	52	77.5	2	245	12	154	241	MBY8981975.1 SDR family oxidoreductase [Promethearchaeota archaeon]	diamond	264	43.5	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
31932011	31932011	PRJNA1067370_P_NODE_34157_length_339_cov_0.755639_g33609_i0	PRJNA1067370	34157	339	0.755639	2.56161621	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	64.7	1.96e-9	NR	MDH5404732.1	2026747	g33609	i0	33.9	2.88495575221239	115	68	95.6	2	333	10	219	332	MDH5404732.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon]	diamond	978	64.7	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);;