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

4 rows where analysis = "diamond", bioproject = "PRJNA1073005" 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
30383758	30383758	PRJNA1073005_P_NODE_9673_length_246_cov_0.890173_g9554_i0	PRJNA1073005	9673	246	0.890173	2.18982558	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	90.1	1.89e-19	NR	KAL0480143.1	1008807	g9554	i0	50	0.951219512195122	78	39	95.1	0	13	246	181	258	KAL0480143.1 cathepsin [Acrasis kona]	diamond	234	90.1	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
31078589	31078589	PRJNA1073005_P_NODE_10315_length_241_cov_0.916667_g10196_i0	PRJNA1073005	10315	241	0.916667	2.20916747	Bodo saltans	75058	Euglenozoa	other_Eukaryota	42.4	0.0428	NR	CUI14446.1	75058	g10196	i0	29.5	0.759336099585062	61	43	75.9	0	45	227	28	88	CUI14446.1 transmembrane protein, putative [Bodo saltans]	diamond	183	42.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
31584557	31584557	PRJNA1073005_P_NODE_9376_length_248_cov_0.880000_g9257_i0	PRJNA1073005	9376	248	0.88	2.1824	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	124	5.549999999999999e-31	NR	XP_002677582.1	5762	g9257	i0	84.7	0.870967741935484	72	11	87.1	0	233	18	381	452	XP_002677582.1 uncharacterized protein NAEGRDRAFT_48838 [Naegleria gruberi]	diamond	216	124	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
31615999	31615999	PRJNA1073005_P_NODE_10256_length_242_cov_0.911243_g10137_i0	PRJNA1073005	10256	242	0.911243	2.20520806	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	69.7	1.08e-11	NR	KAJ9470941.1	91374	g10137	i0	54	0.78099173553719	63	26	76.9	2	39	224	108	168	KAJ9470941.1 putative endoglucanase type K [Diplonema papillatum]	diamond	189	69.7	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum

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