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

14 rows where analysis = "blastn", bioproject = "PRJNA1164198" 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
4138769	4138769	PRJNA1164198_P_NODE_11124_length_373_cov_1.040000_g10856_i0	PRJNA1164198	11124	373	1.04	3.8792	Trypanosoma grayi	71804	Euglenozoa	other_Eukaryota	377	5.15e-100	NTclustered	gi\|686630350\|ref\|XM_009309346.1\|	71804	g10856	i0	87.273	4.42359249329759	330	42	88	0	43	372	441	770	Trypanosoma grayi ribosomal protein L13 partial mRNA	blastn	1650	377	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma grayi
6142336	6142336	PRJNA1164198_P_NODE_13285_length_340_cov_1.078652_g13016_i0	PRJNA1164198	13285	340	1.078652	3.6674168	Leishmania	5658	Euglenozoa	other_Eukaryota	172	2.36e-38	NTclustered	gi\|2593249075\|emb\|OY748415.1\|	5660	g13016	i0	82.587	14.1941176470588	201	29	58	5	143	340	625286	625089	Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 21	blastn	4826	172	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
6689893	6689893	PRJNA1164198_P_NODE_21806_length_266_cov_1.616580_g21537_i0	PRJNA1164198	21806	266	1.61658	4.3001028	Crithidia fasciculata	5656	Euglenozoa	other_Eukaryota	296	1.02e-75	NTclustered	gi\|2414483\|emb\|Y00055.1\|	5656	g21537	i0	86.813	124.593984962406	273	27	100	7	1	266	6694	6424	Crithidia fasciculata ribosomal DNA repeat (complete)	blastn	33142	296	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Crithidia	Crithidia fasciculata
6689948	6689948	PRJNA1164198_P_NODE_31606_length_230_cov_2.853503_g31337_i0	PRJNA1164198	31606	230	2.853503	6.5630569	Trypanosoma brucei	5691	Euglenozoa	other_Eukaryota	86.1	2.02e-12	NTclustered	gi\|1376159113\|ref\|XR_002989671.1\|	185431	g31337	i0	77.551	0.639130434782609	147	29	63	4	80	225	405	548	Trypanosoma brucei brucei TREU927 ribosomal RNA (Tb09_rRNA_3), rRNA	blastn	147	86.1	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma brucei
7965225	7965225	PRJNA1164198_P_NODE_26047_length_250_cov_0.881356_g25778_i0	PRJNA1164198	26047	250	0.881356	2.20339	Crithidia fasciculata	5656	Euglenozoa	other_Eukaryota	231	2.7099999999999996e-56	NTclustered	gi\|2414483\|emb\|Y00055.1\|	5656	g25778	i0	85.965	77.516	228	18	86	11	1	215	7527	7301	Crithidia fasciculata ribosomal DNA repeat (complete)	blastn	19379	231	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Crithidia	Crithidia fasciculata
9239847	9239847	PRJNA1164198_P_NODE_13588_length_336_cov_1.186312_g13319_i0	PRJNA1164198	13588	336	1.186312	3.98600832	Trypanosoma grayi	71804	Euglenozoa	other_Eukaryota	414	3.51e-111	NTclustered	gi\|686639836\|ref\|XM_009314089.1\|	71804	g13319	i0	89.362	84.9315476190476	329	35	98	0	1	329	746	418	Trypanosoma grayi putative ATPase beta subunit partial mRNA	blastn	28537	414	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma grayi
11790578	11790578	PRJNA1164198_P_NODE_26390_length_249_cov_0.886364_g26121_i0	PRJNA1164198	26390	249	0.886364	2.20704636	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	339	1.5399999999999998e-88	NTclustered	gi\|1002462249\|ref\|XM_015797076.1\|	157538	g26121	i0	94.144	19.5020080321285	222	13	89	0	25	246	27	248	Leptomonas pyrrhocoris 60s ribosomal protein L37 mRNA	blastn	4856	339	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
13065547	13065547	PRJNA1164198_P_NODE_20111_length_276_cov_2.438424_g19842_i0	PRJNA1164198	20111	276	2.438424	6.73005024	Angomonas deanei	59799	Euglenozoa	other_Eukaryota	372	1.72e-98	NTclustered	gi\|242133530\|gb\|GQ153664.1\|	59799	g19842	i0	91.513	38.6050724637681	271	21	98	2	1	270	2963	3232	Crithidia sp. ATCC 30255 clone fosmid 6b12 genomic sequence	blastn	10655	372	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Angomonas	Angomonas deanei
18163539	18163539	PRJNA1164198_P_NODE_16975_length_300_cov_1.030837_g16706_i0	PRJNA1164198	16975	300	1.030837	3.092511	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	191	5.67e-44	NTclustered	gi\|1002444669\|ref\|XM_015804407.1\|	157538	g16706	i0	78.618	65.22	304	53	99	8	1	298	642	345	Leptomonas pyrrhocoris 60S ribosomal protein L10a putative (RPL10a) mRNA	blastn	19566	191	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
19437941	19437941	PRJNA1164198_P_NODE_26536_length_249_cov_0.886364_g26267_i0	PRJNA1164198	26536	249	0.886364	2.20704636	Trypanosoma rangeli	5698	Euglenozoa	other_Eukaryota	150	7.77e-32	NTclustered	gi\|1673170143\|ref\|XM_029385251.1\|	5698	g26267	i0	82.558	0.690763052208835	172	28	69	2	79	249	331	161	Trypanosoma rangeli 60S ribosomal protein L7a (TraAM80_08501), partial mRNA	blastn	172	150	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma rangeli
19437945	19437945	PRJNA1164198_P_NODE_26956_length_248_cov_1.337143_g26687_i0	PRJNA1164198	26956	248	1.337143	3.31611464	Trypanosoma theileri	67003	Euglenozoa	other_Eukaryota	154	5.98e-33	NTclustered	gi\|1624748521\|ref\|XM_029025189.1\|	67003	g26687	i0	82.584	4.48387096774194	178	27	71	3	74	248	54	230	Trypanosoma theileri ribosomal protein L36 (TM35_000122140), partial mRNA	blastn	1112	154	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
20713366	20713366	PRJNA1164198_P_NODE_31297_length_237_cov_2.243902_g31028_i0	PRJNA1164198	31297	237	2.243902	5.31804774	Bodo saltans	75058	Euglenozoa	other_Eukaryota	427	3.03e-115	NTclustered	gi\|197723519\|gb\|EF681898.2\|	75058	g31028	i0	99.156	146.388185654008	237	2	100	0	1	237	142	378	Bodo saltans strain HFCC13 28S ribosomal RNA gene, partial sequence	blastn	34694	427	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
22716401	22716401	PRJNA1164198_P_NODE_25758_length_250_cov_1.322034_g25489_i0	PRJNA1164198	25758	250	1.322034	3.305085	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	215	2.73e-51	NTclustered	gi\|2593262068\|emb\|OY748521.1\|	5660	g25489	i0	85.238	14.832	210	29	84	2	40	248	61294	61502	Leishmania braziliensis isolate MHOM/BR/75/M2903 genome assembly, chromosome: 35	blastn	3708	215	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
23264158	23264158	PRJNA1164198_P_NODE_12459_length_352_cov_0.806452_g12191_i0	PRJNA1164198	12459	352	0.806452	2.83871104	Bodo saltans	75058	Euglenozoa	other_Eukaryota	250	1.1e-61	NTclustered	gi\|206598117\|gb\|FJ168549.1\|	75058	g12191	i0	80.747	11.8607954545455	348	44	96	13	13	350	2631	2297	Bodo saltans clone fosmid 16K02, complete sequence	blastn	4175	250	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);;