metadata: contig_metadata: 15 rows where bioproject = "PRJNA658591" and tax

15 rows where bioproject = "PRJNA658591" 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
3713155	3713155	PRJNA658591_S_NODE_9023_length_168_cov_0.873950_g8960_i0	PRJNA658591	9023	168	0.87395	1.468236	Leishmania	5658	Euglenozoa	other_Eukaryota	215	1.7e-51	NTclustered	gi\|157872867\|ref\|XM_001684908.1\|	347515	g8960	i0	92.617	94.625	149	11	89	0	2	150	754	902	Leishmania major strain Friedlin S-adenosylmethionine synthetase (METK1), partial mRNA	blastn	15897	217	0.990783410138249	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania major
4453400	4453400	PRJNA658591_S_NODE_8464_length_171_cov_2.311475_g8401_i0	PRJNA658591	8464	171	2.311475	3.95262225	Paratrypanosoma confusum	1470209	Euglenozoa	other_Eukaryota	95.5	1.19e-22	NR	AGG11562.1	1470209	g8401	i0	80.7	2	57	11	100	0	171	1	88	144	AGG11562.1 hypothetical protein, partial [Paratrypanosoma confusum]	diamond	342	95.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Paratrypanosoma	Paratrypanosoma confusum
5728931	5728931	PRJNA658591_S_NODE_5325_length_203_cov_1.292208_g5262_i0	PRJNA658591	5325	203	1.292208	2.62318224	Leishmania sp. Ghana 2012 LV757	2803181	Euglenozoa	other_Eukaryota	128	2.86e-25	NTclustered	gi\|2795012999\|ref\|XM_067840170.1\|	2803181	g5262	i0	88.073	13.0295566502463	109	12	53	1	94	201	1621	1513	Leishmania sp. Ghana 2012 LV757 uncharacterized protein (GH5_00021), partial mRNA	blastn	2645	128	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania sp. Ghana 2012 LV757
7004104	7004104	PRJNA658591_S_NODE_9186_length_167_cov_1.474576_g9123_i0	PRJNA658591	9186	167	1.474576	2.46254192	Neobodo designis	312471	Euglenozoa	other_Eukaryota	285	1.27e-72	NTclustered	gi\|197723537\|gb\|EF681922.2\|	312471	g9123	i0	97.605	144.532934131737	167	3	100	1	1	167	1214	1049	Neobodo designis strain HFCC97 28S ribosomal RNA gene, partial sequence	blastn	24137	285	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
8814374	8814374	PRJNA658591_S_NODE_1887_length_305_cov_2.160156_g1824_i0	PRJNA658591	1887	305	2.160156	6.5884758	Trypanosoma	5690	Euglenozoa	other_Eukaryota	444	4.01e-120	NTclustered	gi\|2026667530\|dbj\|LC618030.1\|	67003	g1824	i0	94.178	152.127868852459	292	15	95	2	15	305	4700	4410	Trypanosoma theileri YMG-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, ITS5, partial and complete sequence	blastn	46399	444	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
11364846	11364846	PRJNA658591_S_NODE_7589_length_178_cov_2.015504_g7526_i0	PRJNA658591	7589	178	2.015504	3.58759712	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	233	5.01e-57	NTclustered	gi\|2026667531\|dbj\|LC618031.1\|	67003	g7526	i0	97.778	100.522471910112	135	3	76	0	44	178	5283	5149	Trypanosoma theileri OSK-16 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, partial and complete sequence	blastn	17893	235	0.991489361702128	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
12104841	12104841	PRJNA658591_S_NODE_3610_length_235_cov_1.473118_g3547_i0	PRJNA658591	3610	235	1.473118	3.4618273	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	72.8	7.47e-13	NR	KAJ9460353.1	91374	g3547	i0	45.7	0.893617021276596	70	33	89.4	2	3	212	171	235	KAJ9460353.1 hypothetical protein DIPPA_02802 [Diplonema papillatum]	diamond	210	72.8	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
13379596	13379596	PRJNA658591_S_NODE_5671_length_198_cov_1.711409_g5608_i0	PRJNA658591	5671	198	1.711409	3.38858982	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	202	1.61e-47	NTclustered	gi\|1002453727\|ref\|XM_015799466.1\|	157538	g5608	i0	85.294	26.8737373737374	204	21	100	7	1	198	327	527	Leptomonas pyrrhocoris putative mitochondrial putative ADP/ATP translocase 1 mRNA	blastn	5321	202	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
15189936	15189936	PRJNA658591_S_NODE_10292_length_162_cov_1.380531_g10229_i0	PRJNA658591	10292	162	1.380531	2.23646022	Leishmania	5658	Euglenozoa	other_Eukaryota	161	2.15e-35	NTclustered	gi\|2593249679\|emb\|OY748418.1\|	5660	g10229	i0	89.231	63.9197530864198	130	12	80	2	6	134	830626	830498	Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 24	blastn	10355	161	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
28356755	28356755	PRJNA658591_S_NODE_8966_length_168_cov_1.663866_g8903_i0	PRJNA658591	8966	168	1.663866	2.79529488	Trypanosoma	5690	Euglenozoa	other_Eukaryota	61.2	1.39e-10	NR	KAF8277798.1	5693	g8903	i0	74.4	9.98214285714286	43	10	76.8	1	38	166	1	42	KAF8277798.1 putative histone H4 [Trypanosoma cruzi]	diamond	1677	61.6	0.993506493506494	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
28755138	28755138	PRJNA658591_S_NODE_8047_length_174_cov_3.544000_g7984_i0	PRJNA658591	8047	174	3.544	6.16656	Phytomonas sp. Hart1	223615	Euglenozoa	other_Eukaryota	86.3	1.11e-19	NR	CCW71534.1	223615	g7984	i0	64.9	0.982758620689655	57	20	98.3	0	3	173	10	66	CCW71534.1 unnamed protein product [Phytomonas sp. Hart1]	diamond	171	86.3	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Phytomonas	Phytomonas sp. Hart1
29146590	29146590	PRJNA658591_S_NODE_3009_length_251_cov_1.772277_g2946_i0	PRJNA658591	3009	251	1.772277	4.44841527	Trypanosoma	5690	Euglenozoa	other_Eukaryota	107	1.34e-26	NR	KAG8344751.1	5699	g2946	i0	63.9	10.9123505976096	83	30	99.2	0	249	1	76	158	KAG8344751.1 60S ribosomal protein L13a [Trypanosoma vivax]	diamond	2739	107	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma vivax
29525224	29525224	PRJNA658591_S_NODE_9250_length_167_cov_0.881356_g9187_i0	PRJNA658591	9250	167	0.881356	1.47186452	Kinetoplastea	5653	Euglenozoa	other_Eukaryota	85.9	6.3e-19	NR	GET93160.1	5689	g9187	i0	65.5	18.6826347305389	55	19	98.8	0	167	3	71	125	GET93160.1 40S ribosomal protein S18, putative [Leishmania tarentolae]	diamond	3120	86.7	0.990772779700115	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania tarentolae
32641781	32641781	PRJNA658591_S_NODE_7360_length_180_cov_1.572519_g7297_i0	PRJNA658591	7360	180	1.572519	2.8305341999999998	Trypanosoma rangeli	5698	Euglenozoa	other_Eukaryota	102	3.51e-24	NR	XP_029236609.1	5698	g7297	i0	84.2	5.7	57	9	95	0	173	3	20	76	XP_029236609.1 large subunit ribosomal protein L18Ae [Trypanosoma rangeli]	diamond	1026	102	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma rangeli
32767926	32767926	PRJNA658591_S_NODE_10120_length_163_cov_0.912281_g10057_i0	PRJNA658591	10120	163	0.912281	1.48701803	Bodo saltans	75058	Euglenozoa	other_Eukaryota	82	1.68e-16	NR	CUG93847.1	75058	g10057	i0	73.6	0.975460122699387	53	13	95.7	1	6	161	191	243	CUG93847.1 ABC transporter, putative [Bodo saltans]	diamond	159	82	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans

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