metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJEB29441" and tax

15 rows where analysis = "diamond", bioproject = "PRJEB29441" 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
12780183	12780183	PRJEB29441_P_NODE_35551_length_175_cov_1.579365_g35110_i0	PRJEB29441	35551	175	1.579365	2.76388875	Jakobida	556282	Root_unresolved	Root_unresolved	103	7.71e-24	NR	ABC54655.1	48483	g35110	i0	84.5	4.97142857142857	58	9	99.4	0	1	174	290	347	ABC54655.1 translation elongation factor 2, partial [Reclinomonas americana]	diamond	870	103	1	Eukaryota	Discoba			Jakobida	Histionidae	Reclinomonas	Reclinomonas americana
26931843	26931843	PRJEB29441_P_NODE_16762_length_264_cov_1.632558_g16321_i0	PRJEB29441	16762	264	1.632558	4.30995312	root	1	Root_unresolved	Root_unresolved	69.3	2.04e-11	NR	KAF8297022.1	5693	g16321	i0	41.5	8.25	82	43	88.6	3	239	6	80	160	KAF8297022.1 hypothetical protein TcYC6_0081580 [Trypanosoma cruzi]	diamond	2178	69.3	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
28201668	28201668	PRJEB29441_P_NODE_38726_length_167_cov_1.296610_g38285_i0	PRJEB29441	38726	167	1.29661	2.1653387	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	102	9.93e-25	NR	XP_002676405.1	5762	g38285	i0	92.9	1.0059880239521	56	3	98.8	1	166	2	75	130	XP_002676405.1 uncharacterized protein NAEGRDRAFT_49668 [Naegleria gruberi]	diamond	168	102	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
28928051	28928051	PRJEB29441_P_NODE_47308_length_161_cov_0.910714_g46867_i0	PRJEB29441	47308	161	0.910714	1.46624954	Bodo saltans	75058	Euglenozoa	other_Eukaryota	79.3	1.49e-16	NR	CUG91220.1	75058	g46867	i0	69.2	0.968944099378882	52	16	96.9	0	159	4	30	81	CUG91220.1 guanylate kinase, putative [Bodo saltans]	diamond	156	79.3	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
29086106	29086106	PRJEB29441_P_NODE_39828_length_166_cov_1.743590_g39387_i0	PRJEB29441	39828	166	1.74359	2.8943594	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	63.2	8.25e-10	NR	KAJ9470062.1	91374	g39387	i0	52	3.65060240963855	50	24	90.4	0	2	151	560	609	KAJ9470062.1 Cysteine proteinase [Diplonema papillatum]	diamond	606	63.2	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
29401679	29401679	PRJEB29441_P_NODE_41489_length_165_cov_0.879310_g41048_i0	PRJEB29441	41489	165	0.87931	1.4508615	Perkinsela sp. CCAP 156	1935466	Euglenozoa	other_Eukaryota	90.5	2.16e-21	NR	KNH09260.1	1314962	g41048	i0	76.4	1	55	13	100	0	165	1	54	108	KNH09260.1 60S ribosomal protein L21 [Perkinsela sp. CCAP 1560/4]	diamond	165	90.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea		Ichthyobodonidae	Perkinsela	Perkinsela sp. CCAP 1560/4
29426566	29426566	PRJEB29441_P_NODE_42709_length_164_cov_0.886957_g42268_i0	PRJEB29441	42709	164	0.886957	1.45460948	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	99.8	1.38e-25	NR	XP_002681511.1	5762	g42268	i0	68.5	6.91463414634146	54	17	98.8	0	3	164	7	60	XP_002681511.1 uncharacterized protein NAEGRDRAFT_4809, partial [Naegleria gruberi]	diamond	1134	99.8	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
29622244	29622244	PRJEB29441_P_NODE_42970_length_164_cov_0.886957_g42529_i0	PRJEB29441	42970	164	0.886957	1.45460948	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	101	2.2699999999999994e-23	NR	XP_002672418.1	5762	g42529	i0	88.9	0.98780487804878	54	6	98.8	0	164	3	1623	1676	XP_002672418.1 dedicator of cytokinesis 4 [Naegleria gruberi]	diamond	162	101	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
29907032	29907032	PRJEB29441_P_NODE_41491_length_165_cov_0.879310_g41050_i0	PRJEB29441	41491	165	0.87931	1.4508615	Strigomonas culicis	28005	Euglenozoa	other_Eukaryota	72	6.91e-15	NR	EPY33267.1	28005	g41050	i0	61.1	1.96363636363636	54	21	98.2	0	162	1	24	77	EPY33267.1 large subunit ribosomal protein L23e [Strigomonas culicis]	diamond	324	72	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Strigomonas	Strigomonas culicis
29970039	29970039	PRJEB29441_P_NODE_40891_length_166_cov_0.871795_g40450_i0	PRJEB29441	40891	166	0.871795	1.4471797	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	67.4	2.66e-11	NR	KAJ9466404.1	91374	g40450	i0	68.6	1.86144578313253	51	16	92.2	0	160	8	262	312	KAJ9466404.1 Armadillo repeat-containing kinesin-like protein 3 [Diplonema papillatum]	diamond	309	67.4	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
29970040	29970040	PRJEB29441_P_NODE_41531_length_165_cov_0.879310_g41090_i0	PRJEB29441	41531	165	0.87931	1.4508615	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	61.2	3.8e-9	NR	KAL0490473.1	1008807	g41090	i0	64.9	1.34545454545455	37	13	67.3	0	39	149	1202	1238	KAL0490473.1 hypothetical protein AKO1_009512 [Acrasis kona]	diamond	222	61.2	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
30222758	30222758	PRJEB29441_P_NODE_42932_length_164_cov_0.886957_g42491_i0	PRJEB29441	42932	164	0.886957	1.45460948	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	101	1.5099999999999998e-23	NR	XP_002672777.1	5762	g42491	i0	90.7	0.98780487804878	54	5	98.8	0	164	3	208	261	XP_002672777.1 uncharacterized protein NAEGRDRAFT_52059 [Naegleria gruberi]	diamond	162	101	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
30286437	30286437	PRJEB29441_P_NODE_31912_length_185_cov_1.867647_g31471_i0	PRJEB29441	31912	185	1.867647	3.45514695	Tsukubamonas globosa	875863	Root_unresolved	Root_unresolved	77.8	6.62e-15	NR	YP_009004132.1	875863	g31471	i0	55.7	3.90810810810811	61	27	98.9	0	184	2	290	350	YP_009004132.1 NADH dehydrogenase subunit 7 [Tsukubamonas globosa]	diamond	723	77.8	1	Eukaryota	Discoba			Tsukubamonadida	Tsukubamonadidae	Tsukubamonas	Tsukubamonas globosa
31107374	31107374	PRJEB29441_P_NODE_44135_length_163_cov_0.894737_g43694_i0	PRJEB29441	44135	163	0.894737	1.45842131	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	103	3.35e-24	NR	XP_002674266.1	5762	g43694	i0	86.8	0.975460122699387	53	7	97.5	0	3	161	174	226	XP_002674266.1 iron hydrogenase [Naegleria gruberi]	diamond	159	103	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
32625493	32625493	PRJEB29441_P_NODE_39420_length_167_cov_0.864407_g38979_i0	PRJEB29441	39420	167	0.864407	1.44355969	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	58.9	2.58e-8	NR	XP_002673389.1	5762	g38979	i0	61.5	0.934131736526946	52	20	93.4	0	5	160	773	824	XP_002673389.1 kinesin-3 [Naegleria gruberi]	diamond	156	58.9	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi

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