metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA893346" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA893346" 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
9795921	9795921	PRJNA893346_P_NODE_19768_length_347_cov_0.992701_g19279_i0	PRJNA893346	19768	347	0.99270099999999994	3.44467247	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	163	1.4499999999999998e-35	NTclustered	gi\|290995181\|ref\|XM_002680150.1\|	5762	g19279	i0	83.815	2.23054755043228	173	26	50	2	139	310	636	807	Naegleria gruberi 60S ribosomal protein L2 (NAEGRDRAFT_35785), mRNA	blastn	774	163	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
11071376	11071376	PRJNA893346_P_NODE_12849_length_436_cov_1.187328_g12363_i0	PRJNA893346	12849	436	1.187328	5.17675008	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	135	4.0700000000000005e-27	NTclustered	gi\|1002460993\|ref\|XM_015796549.1\|	157538	g12363	i0	83.803	21.1834862385321	142	23	33	0	288	429	575	434	Leptomonas pyrrhocoris putative ribosomal protein L15 mRNA	blastn	9236	135	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
12346828	12346828	PRJNA893346_P_NODE_1170_length_1454_cov_2.102100_g978_i0	PRJNA893346	1170	1454	2.1021	30.564534	Petalomonas cantuscygni	56452	Euglenozoa	other_Eukaryota	924	0	NTclustered	gi\|227908931\|gb\|FJ807263.2\|	56452	g978	i0	82.745	59.0082530949106	1049	169	72	11	234	1276	1043	1	Petalomonas cantuscygni strain AMOP1 elongation factor-like gene, partial cds	blastn	85798	924	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Petalomonadida	Scytomonadidae	Petalomonas	Petalomonas cantuscygni
12347025	12347025	PRJNA893346_P_NODE_19470_length_349_cov_1.586957_g18981_i0	PRJNA893346	19470	349	1.586957	5.53847993	Trypanosoma grayi	71804	Euglenozoa	other_Eukaryota	285	2.9799999999999996e-72	NTclustered	gi\|686648116\|ref\|XM_009318228.1\|	71804	g18981	i0	85.401	15.2607449856734	274	40	79	0	65	338	279	6	Trypanosoma grayi kinetoplastid membrane protein KMP-11 partial mRNA	blastn	5326	285	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma grayi
12722763	12722763	PRJNA893346_P_NODE_33770_length_250_cov_1.672316_g33280_i0	PRJNA893346	33770	250	1.672316	4.18079	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	204	5.909999999999999e-48	NTclustered	gi\|2593249075\|emb\|OY748415.1\|	5660	g33280	i0	82.479	7.552	234	39	93	2	10	242	401252	401484	Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 21	blastn	1888	206	0.990291262135922	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
16170772	16170772	PRJNA893346_P_NODE_21493_length_332_cov_1.077220_g21004_i0	PRJNA893346	21493	332	1.07722	3.5763704	Bodo saltans	75058	Euglenozoa	other_Eukaryota	425	1.5999999999999999e-114	NTclustered	gi\|206598103\|gb\|FJ168548.1\|	75058	g21004	i0	90.625	98.0090361445783	320	30	96	0	1	320	20093	19774	Bodo saltans clone fosmid 14L17, complete sequence	blastn	32539	425	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
19994654	19994654	PRJNA893346_P_NODE_19276_length_351_cov_1.633094_g18787_i0	PRJNA893346	19276	351	1.633094	5.73215994	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	333	1.06e-86	NTclustered	gi\|1002459085\|ref\|XM_015798083.1\|	157538	g18787	i0	86.799	46.5156695156695	303	34	85	6	52	351	1378	1079	Leptomonas pyrrhocoris putative Vacuolar ATP synthase subunit B mRNA	blastn	16327	333	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
19995011	19995011	PRJNA893346_P_NODE_31896_length_259_cov_1.317204_g31406_i0	PRJNA893346	31896	259	1.317204	3.41155836	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	156	1.75e-33	NTclustered	gi\|2108229086\|ref\|XM_002678359.2\|	5762	g31406	i0	82.32	5.4980694980695	181	30	69	2	79	258	52	231	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_5552), partial mRNA	blastn	1424	156	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi

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