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

15 rows where bioproject = "PRJNA1073712" 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
12941298	12941298	PRJNA1073712_P_NODE_11231_length_251_cov_0.865169_g11148_i0	PRJNA1073712	11231	251	0.865169	2.17157419	Bodo saltans	75058	Euglenozoa	other_Eukaryota	106	8.41e-25	NR	CUE64030.1	75058	g11148	i0	65	2.91633466135458	80	28	95.6	0	243	4	143	222	CUE64030.1 alanine aminotransferase, putative [Bodo saltans]	diamond	732	106	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
16764507	16764507	PRJNA1073712_P_NODE_15594_length_243_cov_0.905882_g15511_i0	PRJNA1073712	15594	243	0.905882	2.20129326	Parabodo caudatus	351713	Euglenozoa	other_Eukaryota	420	5.21e-113	NTclustered	gi\|20331092\|gb\|AY028450.1\|	351713	g15511	i0	97.942	100.004115226337	243	4	100	1	1	243	2882	2641	Bodo caudatus 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	24301	420	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Parabodonida		Parabodo	Parabodo caudatus
24413529	24413529	PRJNA1073712_P_NODE_16980_length_241_cov_0.916667_g16897_i0	PRJNA1073712	16980	241	0.916667	2.20916747	Angomonas desouzai	59800	Euglenozoa	other_Eukaryota	255	1.54e-63	NTclustered	gi\|529498127\|gb\|KC584063.1\|	59800	g16897	i0	86.58	18.9211618257261	231	31	96	0	1	231	17	247	Angomonas desouzai clone CDS_2.5.1.6 methionine adenosyltransferase gene, complete cds	blastn	4560	255	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Angomonas	Angomonas desouzai
27098977	27098977	PRJNA1073712_P_NODE_17082_length_240_cov_3.347305_g16999_i0	PRJNA1073712	17082	240	3.347305	8.033532	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	93.6	1.62e-22	NR	QLA09590.1	3039	g16999	i0	69.9	2.7125	73	22	91.3	0	13	231	21	93	QLA09590.1 40S small subunit ribosomal protein eS25 [Euglena gracilis]	diamond	651	93.6	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
27161965	27161965	PRJNA1073712_P_NODE_13422_length_247_cov_0.885057_g13339_i0	PRJNA1073712	13422	247	0.885057	2.18609079	Bodo saltans	75058	Euglenozoa	other_Eukaryota	106	1.16e-25	NR	CUI14316.1	75058	g13339	i0	55.6	0.983805668016194	81	36	98.4	0	246	4	189	269	CUI14316.1 eukaryotic initiation factor-like protein, putative [Bodo saltans]	diamond	243	106	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
27794088	27794088	PRJNA1073712_P_NODE_11264_length_251_cov_0.865169_g11181_i0	PRJNA1073712	11264	251	0.865169	2.17157419	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	68.2	2.19e-11	NR	KAJ9450056.1	91374	g11181	i0	50.7	0.824701195219124	69	32	82.5	1	209	3	2	68	KAJ9450056.1 Ubiquitin-conjugating enzyme E2 2 [Diplonema papillatum]	diamond	207	68.2	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
29719694	29719694	PRJNA1073712_P_NODE_14410_length_245_cov_0.895349_g14327_i0	PRJNA1073712	14410	245	0.895349	2.19360505	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	133	2.7799999999999997e-37	NR	KAJ9463182.1	91374	g14327	i0	81.3	0.979591836734694	80	14	98	1	242	3	18	96	KAJ9463182.1 Calcium-binding protein NCSA [Diplonema papillatum]	diamond	240	133	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
29877975	29877975	PRJNA1073712_P_NODE_15851_length_243_cov_0.905882_g15768_i0	PRJNA1073712	15851	243	0.905882	2.20129326	Bodo saltans	75058	Euglenozoa	other_Eukaryota	99	1.27e-22	NR	CUG86076.1	75058	g15768	i0	66.2	0.950617283950617	77	25	95.1	1	3	233	262	337	CUG86076.1 glyceraldehyde-3-phosphate, putative [Bodo saltans]	diamond	231	99	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
30058756	30058756	PRJNA1073712_P_NODE_8931_length_272_cov_1.547739_g8848_i0	PRJNA1073712	8931	272	1.547739	4.20985008	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	155	1.52e-44	NR	KNH08151.1	1314962	g8848	i0	78.9	1.96323529411765	90	19	99.3	0	1	270	138	227	KNH08151.1 mitochondrial ADP/ATP translocase [Perkinsela sp. CCAP 1560/4]	diamond	534	155	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea		Ichthyobodonidae	Perkinsela	Perkinsela sp. CCAP 1560/4
30090357	30090357	PRJNA1073712_P_NODE_13612_length_247_cov_0.885057_g13529_i0	PRJNA1073712	13612	247	0.885057	2.18609079	Trypanosoma	5690	Euglenozoa	other_Eukaryota	120	1.6699999999999999e-31	NR	KAG8338940.1	5699	g13529	i0	69.5	2.97570850202429	82	25	99.6	0	247	2	13	94	KAG8338940.1 40S ribosomal protein SA [Trypanosoma vivax]	diamond	735	120	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma vivax
30153434	30153434	PRJNA1073712_P_NODE_10772_length_254_cov_1.646409_g10689_i0	PRJNA1073712	10772	254	1.646409	4.18187886	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	89.4	1.59e-18	NR	CUG07493.1	75058	g10689	i0	56	2.97637795275591	84	37	99.2	0	252	1	327	410	CUG07493.1 Hypothetical protein, putative [Bodo saltans]	diamond	756	90.1	0.992230854605993	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
30667698	30667698	PRJNA1073712_P_NODE_14973_length_244_cov_0.900585_g14890_i0	PRJNA1073712	14973	244	0.900585	2.1974274	Bodo saltans	75058	Euglenozoa	other_Eukaryota	95.9	4.4e-21	NR	CUG91657.1	75058	g14890	i0	46.8	2.31147540983607	94	35	97.1	1	8	244	287	380	CUG91657.1 Hypothetical protein, putative, partial [Bodo saltans]	diamond	564	95.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
31616014	31616014	PRJNA1073712_P_NODE_9236_length_269_cov_1.535714_g9153_i0	PRJNA1073712	9236	269	1.535714	4.13107066	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	51.2	3.6e-5	NR	KAJ9462774.1	91374	g9153	i0	39.8	0.925650557620818	83	47	91.4	2	3	248	19	99	KAJ9462774.1 putative serine/threonine-protein kinase roco5 [Diplonema papillatum]	diamond	249	51.2	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
32525381	32525381	PRJNA1073712_P_NODE_16979_length_241_cov_0.916667_g16896_i0	PRJNA1073712	16979	241	0.916667	2.20916747	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	67.8	1.98e-11	NR	XP_001686175.1	347515	g16896	i0	58.9	2.11618257261411	56	23	69.7	0	238	71	10	65	XP_001686175.1 elongation factor 1-beta [Leishmania major strain Friedlin]	diamond	510	67.8	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania major
32659358	32659358	PRJNA1073712_P_NODE_12460_length_249_cov_0.875000_g12377_i0	PRJNA1073712	12460	249	0.875	2.17875	Bodo saltans	75058	Euglenozoa	other_Eukaryota	85.5	3.56e-17	NR	CUG88230.1	75058	g12377	i0	58.8	0.819277108433735	68	28	81.9	0	2	205	815	882	CUG88230.1 WD40 repeat-containing protein, putative [Bodo saltans]	diamond	204	85.5	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);;