metadata: contig_metadata: 27 rows where analysis = "diamond", bioproject = "PRJNA384462" and tax

27 rows where analysis = "diamond", bioproject = "PRJNA384462" and tax_phylum = "Euglenozoa"

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
1680186	1680186	PRJNA384462_S_NODE_4962_length_241_cov_1.109375_g4846_i0	PRJNA384462	4962	241	1.109375	2.67359375	Kinetoplastea	5653	Euglenozoa	other_Eukaryota	90.9	1.2600000000000002e-21	NR	CUG81215.1	75058	g4846	i0	74.5	1.36929460580913	55	14	68.5	0	212	48	52	106	CUG81215.1 60S ribosomal protein L44, putative [Bodo saltans]	diamond	330	91.3	0.995618838992333	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
4232475	4232475	PRJNA384462_S_NODE_8424_length_196_cov_1.040816_g8308_i0	PRJNA384462	8424	196	1.040816	2.03999936	Bodo saltans	75058	Euglenozoa	other_Eukaryota	105	1.08e-25	NR	CUG87640.1	75058	g8308	i0	76.6	1.95918367346939	64	15	98	0	194	3	48	111	CUG87640.1 40S ribosomal protein S4, putative [Bodo saltans]	diamond	384	105	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
8058598	8058598	PRJNA384462_S_NODE_11427_length_175_cov_0.968254_g11311_i0	PRJNA384462	11427	175	0.968254	1.6944445	Bodo saltans	75058	Euglenozoa	other_Eukaryota	103	6.66e-27	NR	CUG80347.1	75058	g11311	i0	82.5	1.95428571428571	57	10	97.7	0	173	3	24	80	CUG80347.1 60S ribosomal protein L30, putative [Bodo saltans]	diamond	342	103	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
11884006	11884006	PRJNA384462_S_NODE_3870_length_268_cov_1.050228_g3754_i0	PRJNA384462	3870	268	1.050228	2.81461104	Trypanosoma	5690	Euglenozoa	other_Eukaryota	144	6.829999999999999e-40	NR	RNF19761.1	5693	g3754	i0	80.7	6.83955223880597	88	17	98.5	0	264	1	22	109	RNF19761.1 60S ribosomal protein L2 [Trypanosoma cruzi]	diamond	1833	144	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
22752715	22752715	PRJNA384462_S_NODE_2078_length_361_cov_9.679487_g1962_i0	PRJNA384462	2078	361	9.679487	34.94294807	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	159	1.47e-47	NR	QLA09576.1	3039	g1962	i0	79.2	102.839335180055	96	20	79.8	0	1	288	56	151	QLA09576.1 40S small subunit ribosomal protein uS15 [Euglena gracilis]	diamond	37125	160	0.99375	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
23357422	23357422	PRJNA384462_S_NODE_9979_length_184_cov_0.851852_g9863_i0	PRJNA384462	9979	184	0.851852	1.56740768	Kinetoplastea	5653	Euglenozoa	other_Eukaryota	90.9	1.5300000000000002e-21	NR	EPY26024.1	28005	g9863	i0	75	4.85869565217391	60	15	97.8	0	3	182	66	125	EPY26024.1 large subunit ribosomal protein L38e [Strigomonas culicis]	diamond	894	90.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Strigomonas	Strigomonas culicis
24631735	24631735	PRJNA384462_S_NODE_6860_length_212_cov_1.134969_g6744_i0	PRJNA384462	6860	212	1.134969	2.40613428	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	118	1.01e-29	NR	KAI5686520.1	5660	g6744	i0	80.9	21.1698113207547	68	13	96.2	0	211	8	59	126	KAI5686520.1 Ribosomal protein L3 [Leishmania braziliensis]	diamond	4488	119	0.991596638655462	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
26839153	26839153	PRJNA384462_S_NODE_3521_length_279_cov_1.321739_g3405_i0	PRJNA384462	3521	279	1.321739	3.68765181	root	1	Root_unresolved	Root_unresolved	119	6.66e-32	NR	EPY34433.1	59799	g3405	i0	54.9	3.91397849462366	91	41	97.8	0	1	273	87	177	EPY34433.1 large subunit ribosomal protein L23e [Angomonas deanei]	diamond	1092	119	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Angomonas	Angomonas deanei
26870917	26870917	PRJNA384462_S_NODE_8761_length_193_cov_1.062500_g8645_i0	PRJNA384462	8761	193	1.0625	2.050625	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	43.1	0.0141	NR	EPY26529.1	59799	g8645	i0	38.6	3.29533678756477	44	27	68.4	0	189	58	75	118	EPY26529.1 conserved TPR domain protein [Angomonas deanei]	diamond	636	43.1	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Angomonas	Angomonas deanei
27169748	27169748	PRJNA384462_S_NODE_14482_length_163_cov_0.894737_g14366_i0	PRJNA384462	14482	163	0.894737	1.45842131	Bodo saltans	75058	Euglenozoa	other_Eukaryota	76.6	2.46e-16	NR	CUG89993.1	75058	g14366	i0	76.9	0.957055214723926	52	11	95.7	1	156	1	4	54	CUG89993.1 basic transcription factor 3a, putative [Bodo saltans]	diamond	156	76.6	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
27345142	27345142	PRJNA384462_S_NODE_1943_length_374_cov_1.181538_g1827_i0	PRJNA384462	1943	374	1.181538	4.41895212	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	169	1.91e-51	NR	QLA09576.1	3039	g1827	i0	79.6	63.5775401069519	103	21	82.6	0	372	64	49	151	QLA09576.1 40S small subunit ribosomal protein uS15 [Euglena gracilis]	diamond	23778	169	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
27440019	27440019	PRJNA384462_S_NODE_7503_length_205_cov_1.025641_g7387_i0	PRJNA384462	7503	205	1.025641	2.10256405	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	69.7	3.28e-12	NR	QLA09580.1	3039	g7387	i0	60.4	3.21951219512195	53	21	77.6	0	182	24	66	118	QLA09580.1 40S small subunit ribosomal protein eS4 [Euglena gracilis]	diamond	660	69.7	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
27549040	27549040	PRJNA384462_S_NODE_4584_length_249_cov_1.815000_g4468_i0	PRJNA384462	4584	249	1.815	4.51935	Trypanosoma theileri	67003	Euglenozoa	other_Eukaryota	118	5.68e-32	NR	XP_028881661.1	67003	g4468	i0	75.6	8.89156626506024	82	20	98.8	0	247	2	20	101	XP_028881661.1 40S ribosomal protein S16 [Trypanosoma theileri]	diamond	2214	118	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
27707413	27707413	PRJNA384462_S_NODE_12644_length_168_cov_0.823529_g12528_i0	PRJNA384462	12644	168	0.823529	1.38352872	Bodo saltans	75058	Euglenozoa	other_Eukaryota	63.2	4.66e-11	NR	CUG89185.1	75058	g12528	i0	60	3.92857142857143	55	22	98.2	0	2	166	20	74	CUG89185.1 60S ribosomal protein L36, putative [Bodo saltans]	diamond	660	63.2	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
28039669	28039669	PRJNA384462_S_NODE_11805_length_173_cov_0.798387_g11689_i0	PRJNA384462	11805	173	0.798387	1.38120951	Trypanosoma	5690	Euglenozoa	other_Eukaryota	63.9	4.81e-10	NR	XP_028884262.1	67003	g11689	i0	46.6	3.97109826589595	58	29	97.1	1	173	6	268	325	XP_028884262.1 putative carnitine/choline acetyltransferase [Trypanosoma theileri]	diamond	687	63.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
28085790	28085790	PRJNA384462_S_NODE_6785_length_213_cov_0.914634_g6669_i0	PRJNA384462	6785	213	0.914634	1.94817042	Trypanosoma brucei gambiense DAL972	679716	Euglenozoa	other_Eukaryota	102	4.13e-26	NR	XP_011772066.1	679716	g6669	i0	75	0.957746478873239	68	17	95.8	0	3	206	32	99	XP_011772066.1 ribosomal protein S25, putative [Trypanosoma brucei gambiense DAL972]	diamond	204	102	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma brucei
28559616	28559616	PRJNA384462_S_NODE_5867_length_225_cov_0.869318_g5751_i0	PRJNA384462	5867	225	0.869318	1.9559655	Bodo saltans	75058	Euglenozoa	other_Eukaryota	102	4.81e-25	NR	CUG92810.1	75058	g5751	i0	64.4	0.973333333333333	73	26	97.3	0	2	220	23	95	CUG92810.1 40S ribosomal protein S21, putative [Bodo saltans]	diamond	219	102	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
29317250	29317250	PRJNA384462_S_NODE_2989_length_301_cov_1.162698_g2873_i0	PRJNA384462	2989	301	1.162698	3.49972098	Trypanosoma congolense IL3	5692	Euglenozoa	other_Eukaryota	97.1	9.73e-22	NR	CCD14963.1	1068625	g2873	i0	59	2.33222591362126	78	32	77.7	0	301	68	227	304	CCD14963.1 unnamed protein product [Trypanosoma congolense IL3000]	diamond	702	97.1	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma congolense
29460138	29460138	PRJNA384462_S_NODE_6450_length_217_cov_0.875000_g6334_i0	PRJNA384462	6450	217	0.875	1.89875	Leishmania	5658	Euglenozoa	other_Eukaryota	79.3	1.45e-16	NR	KAL0518664.1	5678	g6334	i0	66.7	3.67741935483871	66	22	91.2	0	3	200	74	139	KAL0518664.1 putative Ribosomal protein L6e, partial [Leishmania naiffi]	diamond	798	79.3	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania naiffi
29491977	29491977	PRJNA384462_S_NODE_15430_length_161_cov_0.910714_g15314_i0	PRJNA384462	15430	161	0.910714	1.46624954	Trypanosoma	5690	Euglenozoa	other_Eukaryota	77.8	7.98e-16	NR	XP_805416.1	5693	g15314	i0	83.7	2.40372670807453	43	7	80.1	0	161	33	178	220	XP_805416.1 ribosomal protein L15, putative [Trypanosoma cruzi]	diamond	387	77.8	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
30154990	30154990	PRJNA384462_S_NODE_9932_length_184_cov_1.133333_g9816_i0	PRJNA384462	9932	184	1.133333	2.08533272	Kinetoplastea	5653	Euglenozoa	other_Eukaryota	102	7.09e-24	NR	AAF62506.1	5710	g9816	i0	73.3	1.97282608695652	60	16	97.8	0	181	2	267	326	AAF62506.1 ribosomal protein L3 [Trypanoplasma borreli]	diamond	363	102	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Parabodonida		Trypanoplasma	Trypanoplasma borreli
30818790	30818790	PRJNA384462_S_NODE_6874_length_212_cov_0.920245_g6758_i0	PRJNA384462	6874	212	0.920245	1.9509194	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	48.1	3.1e-4	NR	XP_028885211.1	67003	g6758	i0	42.4	1.68396226415094	66	37	93.4	1	198	1	21	85	XP_028885211.1 putative nucleolar RNA helicase II [Trypanosoma theileri]	diamond	357	48.1	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
31040202	31040202	PRJNA384462_S_NODE_10575_length_180_cov_1.145038_g10459_i0	PRJNA384462	10575	180	1.145038	2.0610684	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	47.8	2.86e-4	NR	KAJ9471278.1	91374	g10459	i0	69.2	2.23333333333333	26	8	43.3	0	180	103	2050	2075	KAJ9471278.1 putative pre-mRNA-splicing factor ATP-dependent RNA helicase DEAH5 [Diplonema papillatum]	diamond	402	47.8	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
31103006	31103006	PRJNA384462_S_NODE_11255_length_176_cov_1.125984_g11139_i0	PRJNA384462	11255	176	1.125984	1.98173184	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	44.3	0.00109	NR	XP_029234987.1	5698	g11139	i0	53.6	6.68181818181818	56	25	95.5	1	2	169	36	90	XP_029234987.1 60S ribosomal protein L13 [Trypanosoma rangeli]	diamond	1176	44.7	0.991051454138702	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma rangeli
31103009	31103009	PRJNA384462_S_NODE_7095_length_209_cov_1.506250_g6979_i0	PRJNA384462	7095	209	1.50625	3.1480625	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	102	3.71e-26	NR	EPY24538.1	28005	g6979	i0	69.7	4.73684210526316	66	20	94.7	0	209	12	11	76	EPY24538.1 large subunit ribosomal protein L24e [Strigomonas culicis]	diamond	990	102	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Strigomonas	Strigomonas culicis
31180669	31180669	PRJNA384462_S_NODE_11595_length_174_cov_1.216000_g11479_i0	PRJNA384462	11595	174	1.216	2.11584	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	56.6	1.81e-7	NR	KAJ9458863.1	91374	g11479	i0	80	1.13793103448276	35	7	60.3	0	173	69	376	410	KAJ9458863.1 Caffeyl-CoA reductase-Etf complex subunit CarC [Diplonema papillatum]	diamond	198	56.6	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
32793055	32793055	PRJNA384462_S_NODE_3180_length_292_cov_2.242798_g3064_i0	PRJNA384462	3180	292	2.242798	6.54897016	Trypanosoma congolense IL3	5692	Euglenozoa	other_Eukaryota	61.6	1.49e-8	NR	CCD12316.1	1068625	g3064	i0	64.1	0.801369863013699	39	14	40.1	0	173	289	312	350	CCD12316.1 unnamed protein product [Trypanosoma congolense IL3000]	diamond	234	61.6	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma congolense

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