metadata: contig_metadata: 6 rows where bioproject = "PRJNA453567" and tax

6 rows where bioproject = "PRJNA453567" and tax_kingdom = "Nanobdellati"

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_clade	tax_kingdom	tax_phylum	tax_species
1716753	1716753	PRJNA453567_P_NODE_32622_length_153_cov_2.155172_g32385_i0	PRJNA453567	32622	153	2.155172	3.29741316	Archaea	2157	Archaea	Archaea	87.8	1.41e-18	NR	MBI2079316.1	2250274	g32385	i0	74	5.88235294117647	50	13	98	0	151	2	320	369	MBI2079316.1 methionine--tRNA ligase [Candidatus Micrarchaeota archaeon]	diamond	900	87.8	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeota archaeon
26791377	26791377	PRJNA453567_P_NODE_20481_length_195_cov_1.727848_g20244_i0	PRJNA453567	20481	195	1.727848	3.3693036	Nanobdellota archaeon	2026764	Archaea	Archaea	85.5	1.68e-17	NR	MCA9485224.1	2026764	g20244	i0	67.7	0.953846153846154	62	19	95.4	1	2	187	722	782	MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon]	diamond	186	85.5	1	Archaea		Nanobdellati	Nanobdellota	Nanobdellota archaeon
27155138	27155138	PRJNA453567_P_NODE_32562_length_154_cov_0.982906_g32325_i0	PRJNA453567	32562	154	0.982906	1.51367524	root	1	Root_unresolved	Root_unresolved	66.6	4.17e-11	NR	MEX0932923.1	2026773	g32325	i0	64.4	6.50649350649351	45	16	87.7	0	8	142	274	318	MEX0932923.1 isoleucine--tRNA ligase [Candidatus Pacearchaeota archaeon]	diamond	1002	66.6	1	Archaea	Candidatus Pacearchaeota	Nanobdellati		Candidatus Pacearchaeota archaeon
29160594	29160594	PRJNA453567_P_NODE_13169_length_253_cov_1.986111_g12932_i0	PRJNA453567	13169	253	1.986111	5.02486083	Nanobdellota archaeon	2026764	Archaea	Archaea	99	7.110000000000001e-22	NR	MCA9485224.1	2026764	g12932	i0	52.4	0.99604743083004	84	40	99.6	0	2	253	237	320	MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon]	diamond	252	99	1	Archaea		Nanobdellati	Nanobdellota	Nanobdellota archaeon
29886731	29886731	PRJNA453567_P_NODE_571_length_1469_cov_2.251397_g524_i0	PRJNA453567	571	1469	2.251397	33.07302193	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	50.4	0.0229	NR	MBN2042865.1	3121606	g524	i0	30.4	0.569775357385977	168	106	34.3	5	997	494	392	548	MBN2042865.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon]	diamond	837	50.4	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota	Candidatus Aenigmatarchaeota archaeon
30329413	30329413	PRJNA453567_P_NODE_16532_length_220_cov_2.912568_g16295_i0	PRJNA453567	16532	220	2.912568	6.4076496	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	58.9	2.69e-8	NR	MBI2659394.1	2026803	g16295	i0	45.6	0.927272727272727	68	34	91.4	2	19	219	93	158	MBI2659394.1 carbamoyl phosphate synthase large subunit [Candidatus Woesearchaeota archaeon]	diamond	204	58.9	1	Archaea		Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota 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);;