metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1242190" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1242190" 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
350704	350704	PRJNA1242190_S_NODE_11401_length_257_cov_1.021739_g11394_i0	PRJNA1242190	11401	257	1.021739	2.62586923	Trypanosomatidae sp. G33	1134002	Euglenozoa	other_Eukaryota	56.5	0.002	NTclustered	gi\|440853732\|gb\|JQ890146.1\|	1134002	g11394	i0	97.059	1.43968871595331	34	0	13	1	222	254	11	44	Trypanosomatidae sp. G33 trans-spliced leader sequence SL gene, complete sequence	blastn	370	56.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae		Trypanosomatidae sp. G33
1625623	1625623	PRJNA1242190_S_NODE_5622_length_349_cov_1.554348_g5615_i0	PRJNA1242190	5622	349	1.554348	5.42467452	Trypanosoma conorhini	83891	Euglenozoa	other_Eukaryota	154	8.78e-33	NTclustered	gi\|1673138959\|ref\|XM_029372254.1\|	83891	g5615	i0	84.967	3.97994269340974	153	21	44	2	3	154	487	638	Trypanosoma conorhini 40S ribosomal protein SA (Tco025E_05355), partial mRNA	blastn	1389	154	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma conorhini
2901801	2901801	PRJNA1242190_S_NODE_9003_length_286_cov_1.478873_g8996_i0	PRJNA1242190	9003	286	1.478873	4.22957678	Strigomonas oncopelti	5657	Euglenozoa	other_Eukaryota	207	5.33e-49	NTclustered	gi\|529496469\|gb\|KC545085.1\|	5657	g8996	i0	80	0.996503496503496	285	53	99	4	2	284	1120	838	Strigomonas oncopelti clone CON_2.5.1.6 methionine adenosyltransferase gene, complete cds	blastn	285	207	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Strigomonas	Strigomonas oncopelti
3601590	3601590	PRJNA1242190_S_NODE_1903_length_513_cov_3.215909_g1896_i0	PRJNA1242190	1903	513	3.215909	16.49761317	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	261	7.67e-65	NTclustered	gi\|440222388\|gb\|JX030056.1\|	5659	g1896	i0	92.778	62.9317738791423	180	13	35	0	316	495	182	3	Leishmania amazonensis isolate LaPH8.rRNA.32 28S ribosomal RNA (LSU-delta M2), partial sequence	blastn	32284	261	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania amazonensis
4178198	4178198	PRJNA1242190_S_NODE_9644_length_277_cov_4.338235_g9637_i0	PRJNA1242190	9644	277	4.338235	12.01691095	Leishmania major	5664	Euglenozoa	other_Eukaryota	54.7	0.007	NTclustered	gi\|157874872\|ref\|XM_001685796.1\|	347515	g9637	i0	100	0.209386281588448	29	0	10	0	217	245	569	541	Leishmania major strain Friedlin putative 40S ribosomal protein S3 partial mRNA	blastn	58	54.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania major
4879116	4879116	PRJNA1242190_S_NODE_13924_length_234_cov_2.422360_g13917_i0	PRJNA1242190	13924	234	2.42236	5.6683224	Trypanosoma	5690	Euglenozoa	other_Eukaryota	93.5	1.23e-14	NTclustered	gi\|71661488\|ref\|XM_812672.1\|	5693	g13917	i0	83.838	2.95299145299145	99	14	42	2	1	98	329	426	Trypanosoma cruzi 40S ribosomal protein S23, putative (Tc00.1047053509695.180), partial mRNA	blastn	691	93.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
6153709	6153709	PRJNA1242190_S_NODE_12185_length_251_cov_0.876404_g12178_i0	PRJNA1242190	12185	251	0.876404	2.19977404	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	178	3.6e-40	NTclustered	gi\|2414483\|emb\|Y00055.1\|	5656	g12178	i0	95.536	48.6334661354582	112	4	45	1	1	112	7093	7203	Crithidia fasciculata ribosomal DNA repeat (complete)	blastn	12207	178	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Crithidia	Crithidia fasciculata
7428962	7428962	PRJNA1242190_S_NODE_6526_length_329_cov_0.929688_g6519_i0	PRJNA1242190	6526	329	0.929688	3.05867352	Leishmania	5658	Euglenozoa	other_Eukaryota	202	2.91e-47	NTclustered	gi\|159376\|gb\|L06120.1\|LEIMHOMC	5661	g6519	i0	80.859	13.9300911854103	256	49	78	0	1	256	264	519	Leishmania donovani ribosomal protein S11 mRNA, complete cds	blastn	4583	202	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania donovani
8703868	8703868	PRJNA1242190_S_NODE_2007_length_506_cov_2.709007_g2000_i0	PRJNA1242190	2007	506	2.709007	13.70757542	Trypanosoma	5690	Euglenozoa	other_Eukaryota	285	4.48e-72	NTclustered	gi\|686648116\|ref\|XM_009318228.1\|	71804	g2000	i0	92.462	15.6758893280632	199	15	39	0	308	506	279	81	Trypanosoma grayi kinetoplastid membrane protein KMP-11 partial mRNA	blastn	7932	285	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma grayi
9279100	9279100	PRJNA1242190_S_NODE_1368_length_557_cov_2.807851_g1361_i0	PRJNA1242190	1368	557	2.807851	15.63973007	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	407	1.02e-108	NTclustered	gi\|1002432462\|ref\|XM_015809846.1\|	157538	g1361	i0	86.921	74.0035906642729	367	42	65	4	194	557	1397	1034	Leptomonas pyrrhocoris elongation factor 1-alpha mRNA	blastn	41220	407	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
12529741	12529741	PRJNA1242190_S_NODE_6550_length_328_cov_1.788235_g6543_i0	PRJNA1242190	6550	328	1.788235	5.8654108	Leishmania	5658	Euglenozoa	other_Eukaryota	148	3.829999999999999e-31	NTclustered	gi\|2785799148\|ref\|XM_067208309.1\|	2249476	g6543	i0	78.603	12.1036585365854	229	45	69	4	102	328	728	502	Leishmania orientalis uncharacterized protein (LSCM4_06388), partial mRNA	blastn	3970	148	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania orientalis
15653878	15653878	PRJNA1242190_S_NODE_2013_length_506_cov_1.817552_g2006_i0	PRJNA1242190	2013	506	1.817552	9.19681312	Leishmania mexicana	5665	Euglenozoa	other_Eukaryota	331	5.68e-86	NTclustered	gi\|401429783\|ref\|XM_003879325.1\|	929439	g2006	i0	82.667	23.1640316205534	375	63	74	2	35	408	420	47	Leishmania mexicana MHOM/GT/2001/U1103 putative 60S ribosomal protein L23 partial mRNA	blastn	11721	331	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania mexicana
18202566	18202566	PRJNA1242190_S_NODE_12455_length_249_cov_1.289773_g12448_i0	PRJNA1242190	12455	249	1.289773	3.21153477	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	252	2.07e-62	NTclustered	gi\|1002460993\|ref\|XM_015796549.1\|	157538	g12448	i0	85.597	13.3534136546185	243	31	97	3	4	244	388	628	Leptomonas pyrrhocoris putative ribosomal protein L15 mRNA	blastn	3325	252	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
24003112	24003112	PRJNA1242190_S_NODE_6419_length_331_cov_1.290698_g6412_i0	PRJNA1242190	6419	331	1.290698	4.27221038	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	145	5e-30	NTclustered	gi\|1673133561\|ref\|XM_029369523.1\|	83891	g6412	i0	81.871	1.54984894259819	171	31	52	0	48	218	412	582	Trypanosoma conorhini translation elongation factor 1-beta (Tco025E_02598), partial mRNA	blastn	513	145	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma conorhini

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