metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA436017" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA436017" 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
431010	431010	PRJNA436017_P_NODE_7881_length_315_cov_2.233813_g7584_i0	PRJNA436017	7881	315	2.233813	7.03651095	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	433	9.01e-117	NTclustered	gi\|560190589\|gb\|KF633467.1\|	91374	g7584	i0	91.304	24.8507936507937	322	20	100	5	1	315	1849	1529	Diplonema papillatum strain ATCC 50162 28S ribosomal RNA gene, complete sequence	blastn	7828	433	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
1705666	1705666	PRJNA436017_P_NODE_23282_length_169_cov_1.431818_g22984_i0	PRJNA436017	23282	169	1.431818	2.41977242	Rhynchomonas nasuta	127150	Euglenozoa	other_Eukaryota	283	4.6e-72	NTclustered	gi\|1996609220\|gb\|MW694339.1\|	127150	g22984	i0	97.041	95.3136094674556	169	4	100	1	1	169	801	634	Rhynchomonas nasuta isolate G431 small subunit ribosomal RNA gene, partial sequence	blastn	16108	283	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida	Rhynchomonadidae	Rhynchomonas	Rhynchomonas nasuta
1705869	1705869	PRJNA436017_P_NODE_7162_length_333_cov_2.104730_g6865_i0	PRJNA436017	7162	333	2.10473	7.0087509	Lacrimia lanifica	2016125	Euglenozoa	other_Eukaryota	104	8.54e-18	NTclustered	gi\|1802568038\|gb\|MN109014.1\|	2016125	g6865	i0	80	0.870870870870871	145	26	43	3	127	269	720	863	Lacrimia lanifica clone U02 U02 array genomic sequence; and rnl gene, partial sequence; mitochondrial	blastn	290	104	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Lacrimia	Lacrimia lanifica
2981677	2981677	PRJNA436017_P_NODE_6383_length_354_cov_1.962145_g6087_i0	PRJNA436017	6383	354	1.962145	6.9459933	Diplonemida sp.	2015511	Euglenozoa	other_Eukaryota	416	1.03e-111	NTclustered	gi\|1214280013\|gb\|MF422198.1\|	2015511	g6087	i0	88.022	74.5169491525424	359	34	100	9	1	354	1078	724	Diplonemida sp. isolate YPF1523 small subunit ribosomal RNA gene, partial sequence	blastn	26379	416	1	Eukaryota	Discoba	Euglenozoa	Diplonemea				Diplonemida sp.
3640035	3640035	PRJNA436017_P_NODE_13743_length_225_cov_5.638298_g13445_i0	PRJNA436017	13743	225	5.638298	12.6861705	Trypanosoma	5690	Euglenozoa	other_Eukaryota	248	2.38e-61	NTclustered	gi\|556442\|gb\|L22334.1\|TRBS3RRBN	5693	g13445	i0	95.513	79.4088888888889	156	5	69	2	70	225	5329	5176	Trypanosoma cruzi 5.8S ribosomal RNA, internal transcribed spacers 1-7 (ITS1-ITS7), and 28S ribosomal RNA	blastn	17867	248	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
3640054	3640054	PRJNA436017_P_NODE_16523_length_202_cov_12.539394_g16225_i0	PRJNA436017	16523	202	12.539394	25.32957588	Trypanosoma	5690	Euglenozoa	other_Eukaryota	261	2.68e-65	NTclustered	gi\|162233\|gb\|M63699.1\|TRBRGS1	5693	g16225	i0	90.099	89.950495049505	202	19	99	1	2	202	262	61	T.cruzi S3 ribosomal RNA gene	blastn	18170	261	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
5534750	5534750	PRJNA436017_P_NODE_7865_length_315_cov_3.701439_g7568_i0	PRJNA436017	7865	315	3.701439	11.65953285	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	427	4.1899999999999985e-115	NTclustered	gi\|560190589\|gb\|KF633467.1\|	91374	g7568	i0	91.139	40.615873015873	316	26	100	2	1	315	3132	3446	Diplonema papillatum strain ATCC 50162 28S ribosomal RNA gene, complete sequence	blastn	12794	427	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
7467062	7467062	PRJNA436017_P_NODE_12186_length_242_cov_60.229268_g11888_i0	PRJNA436017	12186	242	60.229268	145.75482856	Trypanosoma	5690	Euglenozoa	other_Eukaryota	350	6.9e-92	NTclustered	gi\|162233\|gb\|M63699.1\|TRBRGS1	5693	g11888	i0	95.455	114.194214876033	220	8	90	2	22	240	44	262	T.cruzi S3 ribosomal RNA gene	blastn	27635	350	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
8741867	8741867	PRJNA436017_P_NODE_12187_length_242_cov_26.170732_g11889_i0	PRJNA436017	12187	242	26.170732	63.33317144	Trypanosoma	5690	Euglenozoa	other_Eukaryota	300	7.05e-77	NTclustered	gi\|162233\|gb\|M63699.1\|TRBRGS1	5693	g11889	i0	91.364	105.359504132231	220	18	91	1	22	241	44	262	T.cruzi S3 ribosomal RNA gene	blastn	25497	300	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
13184482	13184482	PRJNA436017_P_NODE_23631_length_168_cov_1.160305_g23333_i0	PRJNA436017	23631	168	1.160305	1.9493124	Leishmania sp. Ghana 2012 LV757	2803181	Euglenozoa	other_Eukaryota	171	3.73e-38	NTclustered	gi\|2795000421\|ref\|XM_067846461.1\|	2803181	g23333	i0	93.103	28.5297619047619	116	8	69	0	1	116	278	393	Leishmania sp. Ghana 2012 LV757 uncharacterized protein (GH5_06680), partial mRNA	blastn	4793	171	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania sp. Ghana 2012 LV757
17666669	17666669	PRJNA436017_P_NODE_22934_length_170_cov_2.067669_g22636_i0	PRJNA436017	22934	170	2.067669	3.5150373	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	76.8	8.44e-10	NTclustered	gi\|169656123\|gb\|EU429363.1\|	5659	g22636	i0	95.745	25.6352941176471	47	2	28	0	124	170	435	389	Leishmania amazonensis clone AR249 28S ribosomal RNA (LSU-beta)-like gene, partial sequence	blastn	4358	76.8	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania amazonensis
18282306	18282306	PRJNA436017_P_NODE_16815_length_201_cov_0.926829_g16517_i0	PRJNA436017	16815	201	0.926829	1.86292629	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	82.4	2.23e-11	NTclustered	gi\|1002446348\|ref\|XM_015803961.1\|	157538	g16517	i0	92.982	3.54726368159204	57	2	28	2	118	173	60	5	Leptomonas pyrrhocoris hypothetical protein mRNA	blastn	713	82.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
18282662	18282662	PRJNA436017_P_NODE_9455_length_282_cov_2.706122_g9157_i0	PRJNA436017	9455	282	2.706122	7.63126404	Lacrimia vacuolata	3051248	Euglenozoa	other_Eukaryota	420	6.19e-113	NTclustered	gi\|2514496195\|gb\|OR094903.1\|	3051248	g9157	i0	93.617	72.3758865248227	282	17	100	1	1	282	120	400	Lacrimia vacuolata isolate YPF1808 small subunit ribosomal RNA gene, partial sequence	blastn	20410	420	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Lacrimia	Lacrimia vacuolata
21490905	21490905	PRJNA436017_P_NODE_5017_length_407_cov_2.994595_g4721_i0	PRJNA436017	5017	407	2.994595	12.18800165	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	348	4.45e-91	NTclustered	gi\|2414483\|emb\|Y00055.1\|	5656	g4721	i0	82.299	97.7346437346437	435	45	100	21	1	407	7503	7073	Crithidia fasciculata ribosomal DNA repeat (complete)	blastn	39778	348	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Crithidia	Crithidia fasciculata

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