metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA788929" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA788929" 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
13523130	13523130	PRJNA788929_P_NODE_31411_length_280_cov_7.995169_g30750_i0	PRJNA788929	31411	280	7.995169	22.3864732	Keelungia nitschei	2529305	Euglenozoa	other_Eukaryota	172	1.8999999999999995e-38	NTclustered	gi\|1581142783\|gb\|MK567808.1\|	2529305	g30750	i0	80.889	77.35	225	37	80	5	18	241	1568	1349	Keelungia nitschei strain HFCC166 large subunit ribosomal RNA gene, partial sequence	blastn	21658	172	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Heteronematales	Heteronematidae	Keelungia	Keelungia nitschei
13523522	13523522	PRJNA788929_P_NODE_9851_length_572_cov_30.667335_g9198_i0	PRJNA788929	9851	572	30.667335	175.4171562	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	56.5	0.004	NTclustered	gi\|1002433618\|ref\|XM_015809388.1\|	157538	g9198	i0	100	0.103146853146853	30	0	5	0	124	153	3564	3593	Leptomonas pyrrhocoris TLD domain protein conserved mRNA	blastn	59	56.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
14797828	14797828	PRJNA788929_P_NODE_20632_length_359_cov_22.339161_g19972_i0	PRJNA788929	20632	359	22.339161	80.19758799	Leishmania martiniquensis	1580590	Euglenozoa	other_Eukaryota	113	1.54e-20	NTclustered	gi\|2787683726\|ref\|XM_067321399.1\|	1580590	g19972	i0	82.677	1.56267409470752	127	22	35	0	210	336	495	369	Leishmania martiniquensis uncharacterized protein (LSCM1_03866), partial mRNA	blastn	561	113	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania martiniquensis
14797898	14797898	PRJNA788929_P_NODE_25712_length_315_cov_10.785124_g25051_i0	PRJNA788929	25712	315	10.785124	33.9731406	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	196	1.29e-45	NTclustered	gi\|1002455647\|ref\|XM_015800362.1\|	157538	g25051	i0	80.972	6.25079365079365	247	47	78	0	42	288	643	397	Leptomonas pyrrhocoris putative ribosomal protein L15 mRNA	blastn	1969	196	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
15242514	15242514	PRJNA788929_P_NODE_12532_length_488_cov_32.922892_g11875_i0	PRJNA788929	12532	488	32.922892	160.66371296	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	451	4.02e-122	NTclustered	gi\|2414483\|emb\|Y00055.1\|	5656	g11875	i0	84.242	111.362704918033	495	44	95	19	1	466	7552	7063	Crithidia fasciculata ribosomal DNA repeat (complete)	blastn	54345	451	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Crithidia	Crithidia fasciculata
16072257	16072257	PRJNA788929_P_NODE_8773_length_617_cov_21.077206_g8123_i0	PRJNA788929	8773	617	21.077206	130.04636102	Trypanosoma congolense	5692	Euglenozoa	other_Eukaryota	82.4	7.8e-11	NTclustered	gi\|342183127\|emb\|HE575322.1\|	1068625	g8123	i0	90.323	0.100486223662885	62	6	10	0	537	598	525255	525194	Trypanosoma congolense IL3000 annotated genomic contig, chromosome 9	blastn	62	82.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma congolense
22891839	22891839	PRJNA788929_P_NODE_17758_length_392_cov_29.376176_g17098_i0	PRJNA788929	17758	392	29.376176	115.15460992	Leishmania	5658	Euglenozoa	other_Eukaryota	141	7.78e-29	NTclustered	gi\|440222381\|gb\|JX030049.1\|	5659	g17098	i0	88.43	19.2040816326531	121	9	46	4	11	129	451	334	Leishmania amazonensis isolate LaPH8.rRNA.25 28S ribosomal RNA (LSU-beta), partial sequence	blastn	7528	141	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania amazonensis
22891845	22891845	PRJNA788929_P_NODE_18338_length_385_cov_31.288462_g17678_i0	PRJNA788929	18338	385	31.288462	120.4605787	Trypanosoma	5690	Euglenozoa	other_Eukaryota	267	1.21e-66	NTclustered	gi\|2026667531\|dbj\|LC618031.1\|	67003	g17678	i0	80.601	100.472727272727	366	54	92	15	23	375	5228	5589	Trypanosoma theileri OSK-16 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, partial and complete sequence	blastn	38682	267	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
24166037	24166037	PRJNA788929_P_NODE_47659_length_213_cov_5.557143_g46998_i0	PRJNA788929	47659	213	5.557143	11.83671459	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	206	1.36e-48	NTclustered	gi\|1658007\|gb\|U73613.1\|LBU73613	5660	g46998	i0	88.757	106.230046948357	169	17	78	2	25	191	182	14	Leishmania braziliensis 24S alpha ribosomal RNA gene, partial sequence	blastn	22627	206	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);;