metadata: contig_metadata: 31 rows where bioproject = "PRJNA596870" and tax

31 rows where bioproject = "PRJNA596870" 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
568364	568364	PRJNA596870_P_NODE_25001_length_271_cov_1.944444_g24868_i0	PRJNA596870	25001	271	1.944444	5.26944324	Seculamonas ecuadoriensis	221724	Root_unresolved	Root_unresolved	176	1.41e-39	NTclustered	gi\|2443276641\|gb\|OP760405.1\|	221724	g24868	i0	78.947	18.2619926199262	266	50	97	6	3	265	401	139	Seculamonas ecuadoriensis 40S ribosomal protein SA mRNA, complete cds	blastn	4949	176	1	Eukaryota	Discoba			Jakobida		Seculamonas	Seculamonas ecuadoriensis
3119697	3119697	PRJNA596870_P_NODE_5843_length_504_cov_0.770302_g5710_i0	PRJNA596870	5843	504	0.770302	3.88232208	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	278	2.19e-87	NR	WJH19499.1	3039	g5710	i0	81.4	0.994047619047619	167	31	99.4	0	502	2	428	594	WJH19499.1 Heat shock 70 kDa protein [Euglena gracilis]	diamond	501	278	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
6946841	6946841	PRJNA596870_P_NODE_36806_length_244_cov_0.900585_g36673_i0	PRJNA596870	36806	244	0.900585	2.1974274	Trypanosoma vivax	5699	Euglenozoa	other_Eukaryota	52.8	0.022	NTclustered	gi\|340058162\|emb\|HE573027.1\|	1055687	g36673	i0	100	0.114754098360656	28	0	11	0	212	239	771392	771419	Trypanosoma vivax Y486 annotated genomic contig, chromosome 11	blastn	28	52.8	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma vivax
6946854	6946854	PRJNA596870_P_NODE_37586_length_243_cov_0.905882_g37453_i0	PRJNA596870	37586	243	0.905882	2.20129326	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	129	9.22e-33	NR	RNC43563.1	5693	g37453	i0	80.8	16.4691358024691	78	15	96.3	0	4	237	441	518	RNC43563.1 putative glucose-regulated protein 78, partial [Trypanosoma cruzi]	diamond	4002	129	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
10772395	10772395	PRJNA596870_P_NODE_11449_length_377_cov_1.013158_g11316_i0	PRJNA596870	11449	377	1.013158	3.81960566	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	211	1.27e-65	NR	XP_044557880.1	5763	g11316	i0	80.8	2.9840848806366	125	24	99.5	0	2	376	17	141	XP_044557880.1 uncharacterized protein FDP41_008374 [Naegleria fowleri]	diamond	1125	211	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri
12047297	12047297	PRJNA596870_P_NODE_14690_length_340_cov_1.745318_g14557_i0	PRJNA596870	14690	340	1.745318	5.9340812	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	126	6.7999999999999995e-35	NR	KAJ9453561.1	91374	g14557	i0	52.9	92.4	119	50	99.7	1	339	1	7	125	KAJ9453561.1 Ubiquitin-60S ribosomal protein L40 [Diplonema papillatum]	diamond	31416	127	0.992125984251969	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
14597425	14597425	PRJNA596870_P_NODE_34332_length_246_cov_1.335260_g34199_i0	PRJNA596870	34332	246	1.33526	3.2847396	Peranema trichophorum	56466	Euglenozoa	other_Eukaryota	444	3.14e-120	NTclustered	gi\|427188201\|dbj\|AB757706.1\|	56466	g34199	i0	99.187	1	246	2	100	0	1	246	883	638	Peranema trichophorum rpl3 mRNA for 60S ribosomal protein L3, partial cds, strain: K-01	blastn	246	444	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Heteronematales	Peranemidae	Peranema	Peranema trichophorum
15870815	15870815	PRJNA596870_P_NODE_11373_length_378_cov_1.259016_g11240_i0	PRJNA596870	11373	378	1.259016	4.75908048	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	221	5.29e-65	NR	KAJ9442976.1	91374	g11240	i0	80	3.92063492063492	125	24	98.4	1	1	372	644	768	KAJ9442976.1 Elongation factor 2 [Diplonema papillatum]	diamond	1482	221	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
20970523	20970523	PRJNA596870_P_NODE_21897_length_287_cov_1.411215_g21764_i0	PRJNA596870	21897	287	1.411215	4.05018705	Peranema trichophorum	56466	Euglenozoa	other_Eukaryota	324	5.09e-84	NTclustered	gi\|110589646\|gb\|DQ683345.1\|	56466	g21764	i0	96.891	5.31358885017422	193	6	100	0	1	193	1478	1286	Peranema trichophorum Hsp90 gene, partial cds	blastn	1525	324	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Heteronematales	Peranemidae	Peranema	Peranema trichophorum
26776861	26776861	PRJNA596870_P_NODE_15801_length_330_cov_1.525292_g15668_i0	PRJNA596870	15801	330	1.525292	5.0334636	Trypanosoma	5690	Euglenozoa	other_Eukaryota	74.7	6.04e-13	NR	XP_067077465.1	5694	g15668	i0	34.3	2.62727272727273	105	67	95.5	1	317	3	536	638	XP_067077465.1 glucose-regulated protein 78, putative [Trypanosoma equiperdum]	diamond	867	74.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma equiperdum
26872029	26872029	PRJNA596870_P_NODE_13681_length_350_cov_1.469314_g13548_i0	PRJNA596870	13681	350	1.469314	5.142599	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	114	6.51e-29	NR	QLA09565.1	3039	g13548	i0	61.4	20.4171428571429	83	32	71.1	0	249	1	6	88	QLA09565.1 40S small subunit ribosomal protein uS3 [Euglena gracilis]	diamond	7146	115	0.991304347826087	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
26921623	26921623	PRJNA596870_P_NODE_29682_length_251_cov_0.865169_g29549_i0	PRJNA596870	29682	251	0.865169	2.17157419	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	107	7.71e-28	NR	KAL0479597.1	1008807	g29549	i0	59	1.9840637450199201	83	34	99.2	0	249	1	53	135	KAL0479597.1 NAD-dependent protein deacetylase Sirtuin [Acrasis kona]	diamond	498	107	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
27174413	27174413	PRJNA596870_P_NODE_27142_length_260_cov_1.475936_g27009_i0	PRJNA596870	27142	260	1.475936	3.8374335999999998	Trypanosoma vivax Y486	1055687	Euglenozoa	other_Eukaryota	134	3.82e-39	NR	CCC50566.1	1055687	g27009	i0	81.3	1.84615384615385	80	15	92.3	0	18	257	1	80	CCC50566.1 putative 60S ribosomal protein L37 [Trypanosoma vivax Y486]	diamond	480	134	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma vivax
27205992	27205992	PRJNA596870_P_NODE_5042_length_539_cov_0.982833_g4910_i0	PRJNA596870	5042	539	0.982833	5.29746987	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	61.2	2.59e-7	NR	WJH19525.1	3039	g4910	i0	38.2	0.567717996289425	102	61	55.7	1	475	176	343	444	WJH19525.1 Cell division cycle and apoptosis regulator protein 1, partial [Euglena gracilis]	diamond	306	61.2	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
27237799	27237799	PRJNA596870_P_NODE_9083_length_416_cov_2.198251_g8950_i0	PRJNA596870	9083	416	2.198251	9.14472416	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	192	1.55e-58	NR	QLA09564.1	3039	g8950	i0	70.9	1.01682692307692	141	35	99.5	3	2	415	123	260	QLA09564.1 40S small subunit ribosomal protein uS2 [Euglena gracilis]	diamond	423	192	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
27364608	27364608	PRJNA596870_P_NODE_35803_length_245_cov_0.895349_g35670_i0	PRJNA596870	35803	245	0.895349	2.19360505	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	57.4	2.66e-7	NR	XP_015663727.1	157538	g35670	i0	37.8	1.81224489795918	74	45	89.4	1	241	23	141	214	XP_015663727.1 putative proteasome regulatory non-ATP-ase subunit 2 [Leptomonas pyrrhocoris]	diamond	444	57.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
27409474	27409474	PRJNA596870_P_NODE_31083_length_249_cov_1.698864_g30950_i0	PRJNA596870	31083	249	1.698864	4.23017136	Naegleria	5761	Heterolobosea	other_Eukaryota	88.2	3.82e-18	NR	XP_044558917.1	5763	g30950	i0	46.3	3.96385542168675	82	44	98.8	0	248	3	275	356	XP_044558917.1 uncharacterized protein FDP41_006814 [Naegleria fowleri]	diamond	987	88.2	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri
27427696	27427696	PRJNA596870_P_NODE_14343_length_344_cov_1.132841_g14210_i0	PRJNA596870	14343	344	1.132841	3.8969730400000002	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	54.3	5.59e-6	NR	QLA09620.1	3039	g14210	i0	41.2	0.741279069767442	85	43	74.1	2	313	59	98	175	QLA09620.1 60S large subunit ribosomal protein eL14 [Euglena gracilis]	diamond	255	54.3	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
28406336	28406336	PRJNA596870_P_NODE_40126_length_241_cov_0.916667_g39993_i0	PRJNA596870	40126	241	0.916667	2.20916747	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	142	5.0099999999999996e-42	NR	AIN39994.1	3039	g39993	i0	86.1	0.983402489626556	79	11	98.3	0	3	239	5	83	AIN39994.1 putative Tctex-1 domain-containing protein 1 [Euglena gracilis]	diamond	237	142	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
29100946	29100946	PRJNA596870_P_NODE_24568_length_273_cov_1.810000_g24435_i0	PRJNA596870	24568	273	1.81	4.9413	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	163	4.599999999999999e-48	NR	QLA09567.1	3039	g24435	i0	86.8	1	91	12	100	0	1	273	149	239	QLA09567.1 40S small subunit ribosomal protein uS5 [Euglena gracilis]	diamond	273	163	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
29777212	29777212	PRJNA596870_P_NODE_39911_length_241_cov_0.916667_g39778_i0	PRJNA596870	39911	241	0.916667	2.20916747	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	107	8.799999999999999e-25	NR	EPY19354.1	28005	g39778	i0	58.8	9.85892116182573	80	33	99.6	0	241	2	269	348	EPY19354.1 leucine-rich repeat protein [Strigomonas culicis]	diamond	2376	107	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Strigomonas	Strigomonas culicis
29826982	29826982	PRJNA596870_P_NODE_28391_length_254_cov_1.226519_g28258_i0	PRJNA596870	28391	254	1.226519	3.11535826	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	98.2	1.22e-22	NR	XP_002679493.1	5762	g28258	i0	84.2	0.673228346456693	57	8	67.3	1	252	82	86	141	XP_002679493.1 VHP domain-containing protein [Naegleria gruberi]	diamond	171	98.2	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
29858601	29858601	PRJNA596870_P_NODE_34291_length_246_cov_1.601156_g34158_i0	PRJNA596870	34291	246	1.601156	3.93884376	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	53.1	8.25e-6	NR	WJH19495.1	3039	g34158	i0	46.8	0.963414634146341	79	42	96.3	0	242	6	701	779	WJH19495.1 Cell division cycle 5-like protein [Euglena gracilis]	diamond	237	53.1	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
29890445	29890445	PRJNA596870_P_NODE_40071_length_241_cov_0.916667_g39938_i0	PRJNA596870	40071	241	0.916667	2.20916747	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	94.4	5.62e-23	NR	QLA09636.1	3039	g39938	i0	66.7	0.933609958506224	75	25	93.4	0	237	13	26	100	QLA09636.1 60S large subunit ribosomal protein eL36 [Euglena gracilis]	diamond	225	94.4	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
30048030	30048030	PRJNA596870_P_NODE_23231_length_280_cov_1.956522_g23098_i0	PRJNA596870	23231	280	1.956522	5.4782616	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	69.7	1.69e-13	NR	QLA09594.1	3039	g23098	i0	56.7	0.717857142857143	67	29	71.8	0	18	218	1	67	QLA09594.1 40S small subunit ribosomal protein eS30 [Euglena gracilis]	diamond	201	69.7	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
30301461	30301461	PRJNA596870_P_NODE_32312_length_248_cov_1.308571_g32179_i0	PRJNA596870	32312	248	1.308571	3.24525608	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	122	5.2399999999999995e-30	NR	BAB12024.1	3039	g32179	i0	63.4	0.991935483870968	82	30	99.2	0	2	247	1703	1784	BAB12024.1 pyruvate: NADP+ oxidoreductase [Euglena gracilis]	diamond	246	122	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
30711696	30711696	PRJNA596870_P_NODE_20654_length_294_cov_1.389140_g20521_i0	PRJNA596870	20654	294	1.38914	4.0840716	Trypanosoma brucei gambiense DAL972	679716	Euglenozoa	other_Eukaryota	144	5.31e-40	NR	XP_011778960.1	679716	g20521	i0	73.6	5.54081632653061	91	24	92.9	0	273	1	4	94	XP_011778960.1 ADP/ATP translocase 1, putative [Trypanosoma brucei gambiense DAL972]	diamond	1629	144	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma brucei
31597060	31597060	PRJNA596870_P_NODE_25656_length_268_cov_1.369231_g25523_i0	PRJNA596870	25656	268	1.369231	3.66953908	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	61.6	2.88e-9	NR	KAJ9470567.1	91374	g25523	i0	36.9	0.940298507462687	84	48	91.8	2	12	257	5	85	KAJ9470567.1 SCF ubiquitin ligase complex protein SKP1a [Diplonema papillatum]	diamond	252	61.6	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
31881347	31881347	PRJNA596870_P_NODE_29077_length_251_cov_0.865169_g28944_i0	PRJNA596870	29077	251	0.865169	2.17157419	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	80.1	2.91e-15	NR	KAL0483870.1	1008807	g28944	i0	51.2	0.9800796812749	82	39	96.8	1	246	4	259	340	KAL0483870.1 Nlrc3 [Acrasis kona]	diamond	246	80.1	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
31913111	31913111	PRJNA596870_P_NODE_33537_length_247_cov_0.885057_g33404_i0	PRJNA596870	33537	247	0.885057	2.18609079	Bodo saltans	75058	Euglenozoa	other_Eukaryota	44.7	0.0084	NR	CUE69603.1	75058	g33404	i0	45.2	0.753036437246964	62	31	75.3	1	235	50	329	387	CUE69603.1 Hypothetical protein, putative [Bodo saltans]	diamond	186	44.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
32797703	32797703	PRJNA596870_P_NODE_27540_length_258_cov_1.329730_g27407_i0	PRJNA596870	27540	258	1.32973	3.4307034	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	69.3	2e-11	NR	WJH19525.1	3039	g27407	i0	49.3	0.779069767441861	67	29	74.4	2	195	4	548	612	WJH19525.1 Cell division cycle and apoptosis regulator protein 1, partial [Euglena gracilis]	diamond	201	69.3	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis

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