metadata: contig_metadata: 5 rows where bioproject = "PRJNA1136505" and tax

5 rows where bioproject = "PRJNA1136505" 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
15059665	15059665	PRJNA1136505_P_NODE_135932_length_249_cov_0.875000_g129072_i0	PRJNA1136505	135932	249	0.875	2.17875	Candidatus Micrarchaeota archaeon	2250274	Archaea	Archaea	127	1.42e-32	NR	MDO8554187.1	2250274	g129072	i0	83.3	3.63855421686747	72	12	86.7	0	247	32	256	327	MDO8554187.1 ATP citrate lyase citrate-binding domain-containing protein [Candidatus Micrarchaeota archaeon]	diamond	906	127	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeota archaeon
27797076	27797076	PRJNA1136505_P_NODE_108544_length_277_cov_1.436275_g101684_i0	PRJNA1136505	108544	277	1.436275	3.97848175	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	60.1	4.55e-8	NR	MBS3142235.1	2026803	g101684	i0	40.5	1.64620938628159	79	43	85.6	3	1	237	820	894	MBS3142235.1 methionine--tRNA ligase [Candidatus Woesearchaeota archaeon]	diamond	456	60.1	1	Archaea		Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
28775628	28775628	PRJNA1136505_P_NODE_59127_length_393_cov_1.275000_g52267_i0	PRJNA1136505	59127	393	1.275	5.01075	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	87.8	5.97e-18	NR	MBS3113391.1	2026803	g52267	i0	40.2	1.80916030534351	122	62	92.4	2	364	2	2	113	MBS3113391.1 vitamin K epoxide reductase family protein [Candidatus Woesearchaeota archaeon]	diamond	711	87.8	1	Archaea		Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
31334191	31334191	PRJNA1136505_P_NODE_79996_length_327_cov_0.909449_g73136_i0	PRJNA1136505	79996	327	0.909449	2.97389823	Candidatus Micrarchaeota archaeon	2250274	Archaea	Archaea	50.8	1.9e-5	NR	MFH1520474.1	2250274	g73136	i0	43.1	0.660550458715596	72	35	60.6	2	199	2	4	75	MFH1520474.1 ankyrin repeat domain-containing protein [Candidatus Micrarchaeota archaeon]	diamond	216	50.8	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeota archaeon
32093468	32093468	PRJNA1136505_P_NODE_153758_length_241_cov_2.119048_g146898_i0	PRJNA1136505	153758	241	2.119048	5.10690568	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	68.9	3.81e-12	NR	MCK5624922.1	2026773	g146898	i0	47.9	2.58921161825726	71	32	88.4	1	21	233	125	190	MCK5624922.1 2'-5' RNA ligase family protein [Candidatus Pacearchaeota archaeon]	diamond	624	68.9	1	Archaea	Candidatus Pacearchaeota	Nanobdellati		Candidatus Pacearchaeota 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);;