metadata: contig_metadata: 15 rows where bioproject = "PRJNA690124", tax_clade = "Discoba" and tax

15 rows where bioproject = "PRJNA690124", tax_clade = "Discoba" 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
1945216	1945216	PRJNA690124_P_NODE_29522_length_304_cov_1.943723_g29156_i0	PRJNA690124	29522	304	1.943723	5.90891792	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	155	4.86e-44	NR	PWV03856.1	5693	g29156	i0	76.2	41.8618421052632	101	24	99.7	0	1	303	6	106	PWV03856.1 putative heat shock protein 85 [Trypanosoma cruzi]	diamond	12726	155	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
5772722	5772722	PRJNA690124_P_NODE_27405_length_315_cov_0.966942_g27039_i0	PRJNA690124	27405	315	0.966942	3.0458673	Bodo saltans	75058	Euglenozoa	other_Eukaryota	388	1.98e-103	NTclustered	gi\|226347424\|gb\|FJ807252.1\|	75058	g27039	i0	88.924	138.495238095238	316	33	100	2	1	315	791	477	Bodo saltans strain CCAP 1907/2 elongation factor 1 alpha gene, partial cds	blastn	43626	388	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
7556353	7556353	PRJNA690124_P_NODE_30446_length_300_cov_1.321586_g30080_i0	PRJNA690124	30446	300	1.321586	3.964758	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	305	1.94e-78	NTclustered	gi\|15788963\|gb\|AF416379.1\|AF416379	5661	g30080	i0	91.441	104.506666666667	222	19	74	0	1	222	222	1	Leishmania donovani elongation factor 1-alpha mRNA, partial cds	blastn	31352	305	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania donovani
8831303	8831303	PRJNA690124_P_NODE_23607_length_337_cov_1.181818_g23241_i0	PRJNA690124	23607	337	1.181818	3.98272666	Trypanosoma	5690	Euglenozoa	other_Eukaryota	281	3.730000000000001e-71	NTclustered	gi\|2026667531\|dbj\|LC618031.1\|	67003	g23241	i0	86.873	103.682492581602	259	25	86	9	83	337	5413	5160	Trypanosoma theileri OSK-16 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, partial and complete sequence	blastn	34941	283	0.992932862190813	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
9598282	9598282	PRJNA690124_P_NODE_56308_length_242_cov_0.911243_g55942_i0	PRJNA690124	56308	242	0.911243	2.20520806	Trypanosoma grayi	71804	Euglenozoa	other_Eukaryota	161	3.47e-35	NTclustered	gi\|686648116\|ref\|XM_009318228.1\|	71804	g55942	i0	85.714	14.6694214876033	154	20	69	2	76	228	1	153	Trypanosoma grayi kinetoplastid membrane protein KMP-11 partial mRNA	blastn	3550	161	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma grayi
13423542	13423542	PRJNA690124_P_NODE_52251_length_245_cov_0.906977_g51885_i0	PRJNA690124	52251	245	0.906977	2.22209365	Trypanosoma brucei gambiense DAL972	679716	Euglenozoa	other_Eukaryota	91.3	4.7e-20	NR	XP_011780710.1	679716	g51885	i0	75	2.21632653061224	60	15	73.5	0	65	244	70	129	XP_011780710.1 NRBD2 [Trypanosoma brucei gambiense DAL972]	diamond	543	91.3	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma brucei
17246847	17246847	PRJNA690124_P_NODE_18754_length_374_cov_2.820598_g18388_i0	PRJNA690124	18754	374	2.820598	10.54903652	Bodo saltans	75058	Euglenozoa	other_Eukaryota	691	0	NTclustered	gi\|1509798611\|gb\|MH614643.1\|	75058	g18388	i0	100	98.4786096256685	374	0	100	0	1	374	993	620	Bodo saltans small subunit ribosomal RNA gene, partial sequence	blastn	36831	691	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
21580748	21580748	PRJNA690124_P_NODE_40417_length_261_cov_1.882979_g40051_i0	PRJNA690124	40417	261	1.882979	4.91457519	Bodo	5712	Euglenozoa	other_Eukaryota	460	3.3399999999999995e-125	NTclustered	gi\|45739076\|gb\|AY490234.1\|	75058	g40051	i0	98.467	86.9808429118774	261	4	100	0	1	261	1206	946	Bodo saltans 18S ribosomal RNA gene, partial sequence	blastn	22702	460	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
27619556	27619556	PRJNA690124_P_NODE_37144_length_273_cov_1.395000_g36778_i0	PRJNA690124	37144	273	1.395	3.80835	Bodo saltans	75058	Euglenozoa	other_Eukaryota	143	3.06e-39	NR	CUG94252.1	75058	g36778	i0	77.8	0.989010989010989	90	20	98.9	0	1	270	262	351	CUG94252.1 DNA-J chaperone, putative [Bodo saltans]	diamond	270	143	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
28030002	28030002	PRJNA690124_P_NODE_52245_length_245_cov_0.906977_g51879_i0	PRJNA690124	52245	245	0.906977	2.22209365	Trypanosoma equiperdum	5694	Euglenozoa	other_Eukaryota	87.8	1.78e-19	NR	XP_067082337.1	5694	g51879	i0	69.7	0.808163265306122	66	20	80.8	0	46	243	1	66	XP_067082337.1 Ribosomal protein L31e, putative [Trypanosoma equiperdum]	diamond	198	87.8	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma equiperdum
28377124	28377124	PRJNA690124_P_NODE_41406_length_258_cov_1.367568_g41040_i0	PRJNA690124	41406	258	1.367568	3.52832544	Bodo saltans	75058	Euglenozoa	other_Eukaryota	58.5	1.27e-7	NR	CUG84503.1	75058	g41040	i0	38.5	0.906976744186046	78	45	88.4	2	1	228	489	565	CUG84503.1 major surface protease, GP63, putative, partial [Bodo saltans]	diamond	234	58.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
29545350	29545350	PRJNA690124_P_NODE_55650_length_242_cov_0.923077_g55284_i0	PRJNA690124	55650	242	0.923077	2.23384634	Bodo saltans	75058	Euglenozoa	other_Eukaryota	106	1.2e-26	NR	CUF42197.1	75058	g55284	i0	79.7	0.793388429752066	64	13	79.3	0	51	242	32	95	CUF42197.1 cytochrome c oxidase VIII, putative [Bodo saltans]	diamond	192	106	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
30872223	30872223	PRJNA690124_P_NODE_49914_length_247_cov_0.896552_g49548_i0	PRJNA690124	49914	247	0.896552	2.21448344	Angomonas deanei	59799	Euglenozoa	other_Eukaryota	133	1.25e-38	NR	EPY43653.1	59799	g49548	i0	72.2	4.7246963562753	79	19	96	1	1	237	7	82	EPY43653.1 hypothetical protein AGDE_00268 [Angomonas deanei]	diamond	1167	133	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Angomonas	Angomonas deanei
32180436	32180436	PRJNA690124_P_NODE_51138_length_246_cov_0.901734_g50772_i0	PRJNA690124	51138	246	0.901734	2.21826564	root	1	Root_unresolved	Root_unresolved	43.1	0.0199	NR	ESL05026.1	429131	g50772	i0	72	1.29268292682927	25	7	30.5	0	66	140	43	67	ESL05026.1 hypothetical protein TRSC58_07379 [Trypanosoma rangeli SC58]	diamond	318	43.5	0.990804597701149	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma rangeli
32611603	32611603	PRJNA690124_P_NODE_56060_length_242_cov_0.923077_g55694_i0	PRJNA690124	56060	242	0.923077	2.23384634	Novymonas esmeraldas	1808958	Euglenozoa	other_Eukaryota	58.5	9.23e-8	NR	KAK7200615.1	1808958	g55694	i0	51.8	0.694214876033058	56	27	69.4	0	1	168	149	204	KAK7200615.1 leucine-rich repeat protein [Novymonas esmeraldas]	diamond	168	58.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Novymonas	Novymonas esmeraldas

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