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

10 rows where bioproject = "PRJNA340009" and tax_phylum = "Candidatus Aenigmatarchaeota"

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
26726165	26726165	PRJNA340009_P_NODE_8401_length_388_cov_8.575221_g8094_i0	PRJNA340009	8401	388	8.575221	33.27185748	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	132	9.589999999999999e-34	NR	MFH0832408.1	3121606	g8094	i0	50.8	0.989690721649485	128	61	99	1	4	387	193	318	MFH0832408.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon]	diamond	384	132	1	Archaea	Nanobdellati	Candidatus Aenigmatarchaeota	Candidatus Aenigmatarchaeota archaeon
27296002	27296002	PRJNA340009_P_NODE_73943_length_162_cov_0.902655_g73636_i0	PRJNA340009	73943	162	0.902655	1.4623011	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	41.6	0.0331	NR	MEM7818990.1	3121606	g73636	i0	29.4	1.88888888888889	51	36	94.4	0	10	162	435	485	MEM7818990.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon]	diamond	306	41.6	1	Archaea	Nanobdellati	Candidatus Aenigmatarchaeota	Candidatus Aenigmatarchaeota archaeon
27580165	27580165	PRJNA340009_P_NODE_41084_length_199_cov_1.360000_g40777_i0	PRJNA340009	41084	199	1.36	2.7064	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	58.2	7.46e-8	NR	MBS3056618.1	3121606	g40777	i0	55.4	1.65829145728643	56	20	76.9	2	164	12	279	334	MBS3056618.1 laminin G domain-containing protein [Candidatus Aenigmatarchaeota archaeon]	diamond	330	58.2	1	Archaea	Nanobdellati	Candidatus Aenigmatarchaeota	Candidatus Aenigmatarchaeota archaeon
28243101	28243101	PRJNA340009_P_NODE_37666_length_206_cov_3.891720_g37359_i0	PRJNA340009	37666	206	3.89172	8.0169432	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	52	1.24e-5	NR	MFH1229274.1	3121606	g37359	i0	63.6	1.38349514563107	33	12	48.1	0	38	136	555	587	MFH1229274.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Candidatus Aenigmatarchaeota archaeon]	diamond	285	52	1	Archaea	Nanobdellati	Candidatus Aenigmatarchaeota	Candidatus Aenigmatarchaeota archaeon
28590775	28590775	PRJNA340009_P_NODE_76247_length_161_cov_0.910714_g75940_i0	PRJNA340009	76247	161	0.910714	1.46624954	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	96.7	1.21e-21	NR	HIG97694.1	3121606	g75940	i0	94.3	2.96273291925466	53	3	98.8	0	1	159	41	93	HIG97694.1 Flp pilus assembly complex ATPase component TadA [Candidatus Aenigmatarchaeota archaeon]	diamond	477	96.7	1	Archaea	Nanobdellati	Candidatus Aenigmatarchaeota	Candidatus Aenigmatarchaeota archaeon
29095902	29095902	PRJNA340009_P_NODE_52848_length_179_cov_1.569231_g52541_i0	PRJNA340009	52848	179	1.569231	2.80892349	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	53.5	2.44e-6	NR	MEM5806981.1	3121606	g52541	i0	45.6	0.955307262569832	57	31	95.5	0	1	171	173	229	MEM5806981.1 DNA polymerase [Candidatus Aenigmatarchaeota archaeon]	diamond	171	53.5	1	Archaea	Nanobdellati	Candidatus Aenigmatarchaeota	Candidatus Aenigmatarchaeota archaeon
29316799	29316799	PRJNA340009_P_NODE_62289_length_167_cov_0.864407_g61982_i0	PRJNA340009	62289	167	0.864407	1.44355969	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	105	9.93e-28	NR	MBS3051317.1	3121606	g61982	i0	85.5	1.97604790419162	55	8	98.8	0	165	1	15	69	MBS3051317.1 ribonuclease P protein component 2 [Candidatus Aenigmatarchaeota archaeon]	diamond	330	105	1	Archaea	Nanobdellati	Candidatus Aenigmatarchaeota	Candidatus Aenigmatarchaeota archaeon
29474372	29474372	PRJNA340009_P_NODE_26310_length_240_cov_3.659686_g26003_i0	PRJNA340009	26310	240	3.659686	8.7832464	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	112	2.63e-29	NR	MBI2578863.1	3121606	g26003	i0	73.9	0.8625	69	18	86.3	0	1	207	92	160	MBI2578863.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon]	diamond	207	112	1	Archaea	Nanobdellati	Candidatus Aenigmatarchaeota	Candidatus Aenigmatarchaeota archaeon
32256438	32256438	PRJNA340009_P_NODE_36718_length_208_cov_6.220126_g36411_i0	PRJNA340009	36718	208	6.220126	12.93786208	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	106	1.03e-24	NR	MBI2076609.1	3121606	g36411	i0	71.6	0.966346153846154	67	19	96.6	0	1	201	113	179	MBI2076609.1 calcium-transporting P-type ATPase, PMR1-type [Candidatus Aenigmatarchaeota archaeon]	diamond	201	106	1	Archaea	Nanobdellati	Candidatus Aenigmatarchaeota	Candidatus Aenigmatarchaeota archaeon
32792626	32792626	PRJNA340009_P_NODE_68760_length_164_cov_0.886957_g68453_i0	PRJNA340009	68760	164	0.886957	1.45460948	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	52.8	3.69e-6	NR	MEM5806981.1	3121606	g68453	i0	58	2.54268292682927	50	19	87.8	1	154	11	211	260	MEM5806981.1 DNA polymerase [Candidatus Aenigmatarchaeota archaeon]	diamond	417	52.8	1	Archaea	Nanobdellati	Candidatus Aenigmatarchaeota	Candidatus Aenigmatarchaeota 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);;