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

13 rows where analysis = "blastn", bioproject = "PRJNA927284" 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
2177238	2177238	PRJNA927284_P_NODE_8382_length_167_cov_2.115942_g8175_i0	PRJNA927284	8382	167	2.115942	3.53362314	Naegleria australiensis	51634	Heterolobosea	other_Eukaryota	309	7.53e-80	NTclustered	gi\|2476253407\|gb\|OQ627480.1\|	51634	g8175	i0	100	64.1796407185629	167	0	100	0	1	167	2343	2509	Naegleria australiensis strain PP397 rDNA-containing extrachromosomal element genomic sequence; small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence; and non-ribosomal sequence	blastn	10718	309	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria australiensis
6005047	6005047	PRJNA927284_P_NODE_6225_length_215_cov_1.575269_g6018_i0	PRJNA927284	6225	215	1.575269	3.38682835	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	337	4.67e-88	NTclustered	gi\|290988433\|ref\|XM_002676880.1\|	5762	g6018	i0	94.884	25.0186046511628	215	11	100	0	1	215	1140	1354	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_82621), mRNA	blastn	5379	337	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
6356610	6356610	PRJNA927284_P_NODE_6805_length_198_cov_5.349112_g6598_i0	PRJNA927284	6805	198	5.349112	10.59124176	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	259	9.42e-65	NTclustered	gi\|2414483\|emb\|Y00055.1\|	5656	g6598	i0	91.146	118.166666666667	192	16	97	1	1	192	7025	6835	Crithidia fasciculata ribosomal DNA repeat (complete)	blastn	23397	261	0.992337164750958	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Crithidia	Crithidia fasciculata
7279951	7279951	PRJNA927284_P_NODE_8966_length_157_cov_1.609375_g8759_i0	PRJNA927284	8966	157	1.609375	2.52671875	Trypanosoma melophagium	715481	Euglenozoa	other_Eukaryota	152	1.24e-32	NTclustered	gi\|2787690114\|ref\|XM_067335207.1\|	715481	g8759	i0	84.076	45.8917197452229	157	25	100	0	1	157	322	166	Trypanosoma melophagium Ribosomal protein L11 (LSM04_005035), partial mRNA	blastn	7205	152	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma melophagium
7630686	7630686	PRJNA927284_P_NODE_6226_length_215_cov_1.456989_g6019_i0	PRJNA927284	6226	215	1.456989	3.13252635	Naegleria	5761	Heterolobosea	other_Eukaryota	398	2.1099999999999997e-106	NTclustered	gi\|2618963742\|gb\|OR769034.1\|	5762	g6019	i0	100	37.0139534883721	215	0	100	0	1	215	5315	5101	Naegleria gruberi strain NEG-M rDNA-containing extrachromosomal element genomic sequence; and 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence	blastn	7958	398	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
8554692	8554692	PRJNA927284_P_NODE_2287_length_457_cov_17.885514_g2095_i0	PRJNA927284	2287	457	17.885514	81.73679898	Trypanosoma theileri	67003	Euglenozoa	other_Eukaryota	645	1.5999999999999996e-180	NTclustered	gi\|2026667530\|dbj\|LC618030.1\|	67003	g2095	i0	92.043	143.763676148796	465	28	100	7	1	457	4802	4339	Trypanosoma theileri YMG-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, ITS5, partial and complete sequence	blastn	65700	645	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
11105476	11105476	PRJNA927284_P_NODE_8629_length_163_cov_1.582090_g8422_i0	PRJNA927284	8629	163	1.58209	2.5788067	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	154	3.62e-33	NTclustered	gi\|290981449\|ref\|XM_002673397.1\|	5762	g8422	i0	86.957	33.638036809816	138	16	84	2	2	138	357	493	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_55855), mRNA	blastn	5483	154	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
14006603	14006603	PRJNA927284_P_NODE_8131_length_171_cov_4.338028_g7924_i0	PRJNA927284	8131	171	4.338028	7.41802788	Leishmania	5658	Euglenozoa	other_Eukaryota	257	2.83e-64	NTclustered	gi\|440222388\|gb\|JX030056.1\|	5659	g7924	i0	94.083	88.672514619883	169	10	99	0	2	170	181	13	Leishmania amazonensis isolate LaPH8.rRNA.32 28S ribosomal RNA (LSU-delta M2), partial sequence	blastn	15163	257	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania amazonensis
16555054	16555054	PRJNA927284_P_NODE_2253_length_462_cov_11.736721_g2061_i0	PRJNA927284	2253	462	11.736721	54.22365102	Leishmania	5658	Euglenozoa	other_Eukaryota	436	1.06e-117	NTclustered	gi\|2593250474\|emb\|OY748421.1\|	5660	g2061	i0	83.91	114.290043290043	491	44	100	21	1	462	991046	990562	Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 27	blastn	52802	436	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
20028475	20028475	PRJNA927284_P_NODE_396_length_1289_cov_15.494444_g320_i0	PRJNA927284	396	1289	15.494444	199.72338316	Neobodo designis	312471	Euglenozoa	other_Eukaryota	1919	0	NTclustered	gi\|197723537\|gb\|EF681922.2\|	312471	g320	i0	94.569	133.11249030256	1252	50	97	13	1	1244	1242	1	Neobodo designis strain HFCC97 28S ribosomal RNA gene, partial sequence	blastn	171582	1919	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
20028501	20028501	PRJNA927284_P_NODE_776_length_896_cov_4.152249_g661_i0	PRJNA927284	776	896	4.152249	37.20415104	Naegleria australiensis	51634	Heterolobosea	other_Eukaryota	1650	0	NTclustered	gi\|32479131\|gb\|AY321362.1\|	51634	g661	i0	99.888	94.2488839285714	896	1	100	0	1	896	435	1330	Naegleria australiensis isolate TT 18S ribosomal RNA gene, partial sequence	blastn	84447	1650	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria australiensis
22579035	22579035	PRJNA927284_P_NODE_8618_length_163_cov_1.768657_g8411_i0	PRJNA927284	8618	163	1.768657	2.88291091	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	265	1.6e-66	NTclustered	gi\|290975864\|ref\|XM_002670616.1\|	5762	g8411	i0	96.296	15.9877300613497	162	4	99	2	1	161	522	362	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_55913), mRNA	blastn	2606	265	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
22930329	22930329	PRJNA927284_P_NODE_2258_length_462_cov_3.191686_g2066_i0	PRJNA927284	2258	462	3.191686	14.74558932	Naegleria	5761	Heterolobosea	other_Eukaryota	852	0	NTclustered	gi\|32479131\|gb\|AY321362.1\|	51634	g2066	i0	100	97.8484848484848	461	0	99	0	1	461	1353	1813	Naegleria australiensis isolate TT 18S ribosomal RNA gene, partial sequence	blastn	45206	852	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria australiensis

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