metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA1093008" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA1093008" and tax_clade = "Discoba"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
4025598	4025598	PRJNA1093008_S_NODE_89664_length_245_cov_1.645349_g89337_i0	PRJNA1093008	89664	245	1.645349	4.03110505	Naegleria	5761	Heterolobosea	other_Eukaryota	72	9.01e-13	NR	XP_002683047.1	5762	g89337	i0	43.8	2.70612244897959	73	41	89.4	0	220	2	201	273	XP_002683047.1 uncharacterized protein NAEGRDRAFT_29313 [Naegleria gruberi]	diamond	663	72.4	0.994475138121547	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
27185252	27185252	PRJNA1093008_S_NODE_49362_length_295_cov_1.734234_g49035_i0	PRJNA1093008	49362	295	1.734234	5.1159903	Leishmania	5658	Euglenozoa	other_Eukaryota	43.5	0.0352	NR	CAB46680.1	5664	g49035	i0	38.5	1.32203389830508	65	39	65.1	1	247	56	316	380	CAB46680.1 proteophosphoglycan, partial [Leishmania major]	diamond	390	43.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania major
27193906	27193906	PRJNA1093008_S_NODE_60302_length_278_cov_1.126829_g59975_i0	PRJNA1093008	60302	278	1.126829	3.13258462	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	98.6	2.09e-24	NR	KAL0480411.1	1008807	g59975	i0	66.7	0.971223021582734	90	25	91.7	1	263	9	12	101	KAL0480411.1 ribosomal protein L36 [Acrasis kona]	diamond	270	98.6	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
27794285	27794285	PRJNA1093008_S_NODE_50244_length_293_cov_3.822727_g49917_i0	PRJNA1093008	50244	293	3.822727	11.20059011	Leishmania martiniquensis	1580590	Euglenozoa	other_Eukaryota	43.5	0.0371	NR	XP_067176162.1	1580590	g49917	i0	31.7	0.839590443686007	82	51	84	1	268	23	319	395	XP_067176162.1 hypothetical protein LSCM1_02018 [Leishmania martiniquensis]	diamond	246	43.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania martiniquensis

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);;