metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA976345" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA976345" 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
3499020	3499020	PRJNA976345_P_NODE_34363_length_290_cov_2.458824_g32756_i0	PRJNA976345	34363	290	2.458824	7.1305896	Trypanosoma brucei	5691	Euglenozoa	other_Eukaryota	473	4.8399999999999986e-129	NTclustered	gi\|62175954\|gb\|AC159430.1\|	5691	g32756	i0	96.246	1.01034482758621	293	4	100	4	1	290	45869	46157	Trypanosoma brucei chromosome 3 clone RPCI93-28C22, complete sequence	blastn	293	473	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma brucei
4776042	4776042	PRJNA976345_P_NODE_124824_length_178_cov_1.531469_g123216_i0	PRJNA976345	124824	178	1.531469	2.72601482	Cryptoglena skujai	161229	Euglenozoa	other_Eukaryota	52.8	0.015	NTclustered	gi\|836614630\|ref\|NC_027286.1\|	161229	g123216	i0	100	0.157303370786517	28	0	16	0	120	147	65319	65292	Cryptoglena skujai strain SAG 10.88 chloroplast, complete genome	blastn	28	52.8	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Cryptoglena	Cryptoglena skujai
7326739	7326739	PRJNA976345_P_NODE_84806_length_201_cov_2.939759_g83198_i0	PRJNA976345	84806	201	2.939759	5.90891559	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	56.5	0.001	NTclustered	gi\|1002445267\|ref\|XM_015804135.1\|	157538	g83198	i0	100	0.43283582089552203	30	0	15	0	138	167	1531	1560	Leptomonas pyrrhocoris hypothetical protein mRNA	blastn	87	56.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
7645239	7645239	PRJNA976345_P_NODE_198106_length_150_cov_1.973913_g196498_i0	PRJNA976345	198106	150	1.973913	2.9608695	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	62.1	2.03e-5	NTclustered	gi\|2794783799\|ref\|XM_067832329.1\|	5663	g196498	i0	100	20.5266666666667	33	0	22	0	118	150	775	807	Leishmania enriettii uncharacterized protein (CUR178_00547), partial mRNA	blastn	3079	62.1	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania enriettii
11151968	11151968	PRJNA976345_P_NODE_35589_length_286_cov_2.143426_g33982_i0	PRJNA976345	35589	286	2.143426	6.13019836	Trypanosoma rangeli	5698	Euglenozoa	other_Eukaryota	147	1.18e-30	NTclustered	gi\|1673156724\|ref\|XM_029381175.1\|	5698	g33982	i0	81.868	29.6013986013986	182	26	62	6	109	286	359	181	Trypanosoma rangeli small subunit ribosomal protein S17e (TraAM80_04240), partial mRNA	blastn	8466	147	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma rangeli
12427771	12427771	PRJNA976345_P_NODE_46050_length_256_cov_1.986425_g44442_i0	PRJNA976345	46050	256	1.986425	5.085248	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	405	1.55e-108	NTclustered	gi\|2031939661\|emb\|OD957602.1\|	5763	g44442	i0	95.019	61.59375	261	8	100	1	1	256	231	491	Naegleria fowleri Karachi_NF001 strain	blastn	15768	405	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri
13702128	13702128	PRJNA976345_P_NODE_38171_length_277_cov_3.351240_g36564_i0	PRJNA976345	38171	277	3.35124	9.2829348	Naegleria lovaniensis	51637	Heterolobosea	other_Eukaryota	52.8	0.025	NTclustered	gi\|2119417205\|ref\|XM_044687182.1\|	51637	g36564	i0	100	0.101083032490975	28	0	10	0	145	172	1253	1280	Naegleria lovaniensis uncharacterized protein (C9374_011518), partial mRNA	blastn	28	52.8	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria lovaniensis
21350140	21350140	PRJNA976345_P_NODE_180897_length_155_cov_1.933333_g179289_i0	PRJNA976345	180897	155	1.933333	2.99666615	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	172	9.38e-39	NTclustered	gi\|226347398\|gb\|FJ807238.1\|	3039	g179289	i0	87.755	10.6645161290323	147	18	95	0	8	154	1149	1295	Euglena gracilis elongation factor 1 alpha mRNA, complete cds	blastn	1653	172	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
21350298	21350298	PRJNA976345_P_NODE_22937_length_351_cov_3.018987_g21336_i0	PRJNA976345	22937	351	3.018987	10.59664437	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	189	2.4199999999999992e-43	NTclustered	gi\|2031941191\|emb\|OD957845.1\|	5763	g21336	i0	83.41	0.618233618233618	217	22	59	5	1	207	122	334	Naegleria fowleri Karachi_NF001 strain	blastn	217	189	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri
25174318	25174318	PRJNA976345_P_NODE_23280_length_348_cov_4.530351_g21679_i0	PRJNA976345	23280	348	4.530351	15.76562148	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	219	3.07e-52	NTclustered	gi\|2031941502\|emb\|OD957913.1\|	5763	g21679	i0	95	4.41666666666667	140	5	84	2	1	140	138	1	Naegleria fowleri Karachi_NF001 strain	blastn	1537	219	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri

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