metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA721440" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA721440" 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
1986158	1986158	PRJNA721440_S_NODE_11002_length_198_cov_1.711409_g10876_i0	PRJNA721440	11002	198	1.711409	3.38858982	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	202	1.61e-47	NTclustered	gi\|1002453727\|ref\|XM_015799466.1\|	157538	g10876	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
3745378	3745378	PRJNA721440_S_NODE_16143_length_172_cov_0.869919_g16017_i0	PRJNA721440	16143	172	0.869919	1.49626068	Leishmania	5658	Euglenozoa	other_Eukaryota	189	1.0499999999999996e-43	NTclustered	gi\|2593250474\|emb\|OY748421.1\|	5660	g16017	i0	97.297	81.6860465116279	111	3	65	0	1	111	991001	990891	Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 27	blastn	14050	189	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
3745385	3745385	PRJNA721440_S_NODE_3523_length_305_cov_2.160156_g3397_i0	PRJNA721440	3523	305	2.160156	6.5884758	Trypanosoma	5690	Euglenozoa	other_Eukaryota	444	4.01e-120	NTclustered	gi\|2026667530\|dbj\|LC618030.1\|	67003	g3397	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
12189445	12189445	PRJNA721440_S_NODE_15050_length_176_cov_1.795276_g14924_i0	PRJNA721440	15050	176	1.795276	3.15968576	Phytomonas serpens	5707	Euglenozoa	other_Eukaryota	145	2.38e-30	NTclustered	gi\|1370450307\|gb\|MF687108.1\|	5707	g14924	i0	82.927	3.04545454545455	164	24	92	4	13	174	1201	1040	Phytomonas serpens heat shock protein 70 (HSP70) gene, partial cds	blastn	536	145	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Phytomonas	Phytomonas serpens
12189473	12189473	PRJNA721440_S_NODE_5610_length_254_cov_3.068293_g5484_i0	PRJNA721440	5610	254	3.068293	7.79346422	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	167	7.889999999999999e-37	NTclustered	gi\|2031924613\|emb\|OD955805.1\|	5763	g5484	i0	84.211	11.5984251968504	171	27	67	0	25	195	19647	19477	Naegleria fowleri Karachi_NF001 strain	blastn	2946	167	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri
15222184	15222184	PRJNA721440_S_NODE_12252_length_190_cov_1.106383_g12126_i0	PRJNA721440	12252	190	1.106383	2.1021277	Leishmania	5658	Euglenozoa	other_Eukaryota	244	2.5099999999999997e-60	NTclustered	gi\|157872867\|ref\|XM_001684908.1\|	347515	g12126	i0	90	102.321052631579	190	17	99	2	2	190	754	942	Leishmania major strain Friedlin S-adenosylmethionine synthetase (METK1), partial mRNA	blastn	19441	246	0.991869918699187	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania major
17288171	17288171	PRJNA721440_S_NODE_10934_length_198_cov_5.657718_g10808_i0	PRJNA721440	10934	198	5.657718	11.20228164	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	73.1	1.32e-8	NTclustered	gi\|290977199\|ref\|XM_002671280.1\|	5762	g10808	i0	85.714	0.353535353535354	70	8	35	2	99	167	1422	1354	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_83297), mRNA	blastn	70	73.1	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
17288186	17288186	PRJNA721440_S_NODE_17674_length_167_cov_1.483051_g17548_i0	PRJNA721440	17674	167	1.483051	2.47669517	Neobodo designis	312471	Euglenozoa	other_Eukaryota	285	1.27e-72	NTclustered	gi\|197723537\|gb\|EF681922.2\|	312471	g17548	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
18561984	18561984	PRJNA721440_S_NODE_2515_length_353_cov_1.427632_g2389_i0	PRJNA721440	2515	353	1.427632	5.03954096	Leishmania sp. Ghana 2012 LV757	2803181	Euglenozoa	other_Eukaryota	270	8.46e-68	NTclustered	gi\|2795012999\|ref\|XM_067840170.1\|	2803181	g2389	i0	85.992	26.7223796033994	257	31	73	5	5	260	1369	1621	Leishmania sp. Ghana 2012 LV757 uncharacterized protein (GH5_00021), partial mRNA	blastn	9433	270	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania sp. Ghana 2012 LV757
22871142	22871142	PRJNA721440_S_NODE_14698_length_178_cov_1.186047_g14572_i0	PRJNA721440	14698	178	1.186047	2.11116366	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	250	4.9799999999999995e-62	NTclustered	gi\|2026667531\|dbj\|LC618031.1\|	67003	g14572	i0	100	100.522471910112	135	0	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	252	0.992063492063492	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
23663187	23663187	PRJNA721440_S_NODE_17399_length_168_cov_0.873950_g17273_i0	PRJNA721440	17399	168	0.87395	1.468236	Allovahlkampfia sp.	1874883	Heterolobosea	other_Eukaryota	174	2.89e-39	NTclustered	gi\|2651357784\|gb\|PP174299.1\|	1874883	g17273	i0	92.562	18.8333333333333	121	9	72	0	47	167	3332	3452	Allovahlkampfia sp. isolate S28D2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	3164	174	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Allovahlkampfia	Allovahlkampfia sp.
23663189	23663189	PRJNA721440_S_NODE_17459_length_168_cov_0.781513_g17333_i0	PRJNA721440	17459	168	0.781513	1.31294184	Trypanosoma vivax	5699	Euglenozoa	other_Eukaryota	187	3.71e-43	NTclustered	gi\|340054361\|emb\|HE573023.1\|	1055687	g17333	i0	86.905	2.01190476190476	168	20	99	2	1	167	415140	415306	Trypanosoma vivax Y486 annotated genomic contig, chromosome 7	blastn	338	187	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma vivax
24145175	24145175	PRJNA721440_S_NODE_19779_length_162_cov_1.380531_g19653_i0	PRJNA721440	19779	162	1.380531	2.23646022	Leishmania	5658	Euglenozoa	other_Eukaryota	161	2.15e-35	NTclustered	gi\|2593249679\|emb\|OY748418.1\|	5660	g19653	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

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