contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA674048" and tax_clade = "Discoba"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 643014 | 643014 | PRJNA674048_P_NODE_22881_length_184_cov_1.155556_g22678_i0 | PRJNA674048 | 22881 | 184 | 1.155556 | 2.12622304 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 126 | 9.12e-25 | NTclustered | gi|290975281|ref|XM_002670326.1| | 5762 | g22678 | i0 | 83.582 | 6.43478260869565 | 134 | 22 | 73 | 0 | 49 | 182 | 224 | 91 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_82817), mRNA | blastn | 1184 | 126 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 3193941 | 3193941 | PRJNA674048_P_NODE_17003_length_215_cov_5.843373_g16800_i0 | PRJNA674048 | 17003 | 215 | 5.843373 | 12.56325195 | Trypanosoma theileri | 67003 | Euglenozoa | other_Eukaryota | 248 | 2.25e-61 | NTclustered | gi|2026667531|dbj|LC618031.1| | 67003 | g16800 | i0 | 88.038 | 116.967441860465 | 209 | 25 | 97 | 0 | 7 | 215 | 4900 | 5108 | Trypanosoma theileri OSK-16 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, partial and complete sequence | blastn | 25148 | 248 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 4470991 | 4470991 | PRJNA674048_P_NODE_15424_length_227_cov_4.140449_g15221_i0 | PRJNA674048 | 15424 | 227 | 4.140449 | 9.39881923 | Sphenomonas teres | 2704098 | Euglenozoa | other_Eukaryota | 337 | 4.9799999999999995e-88 | NTclustered | gi|1803019522|gb|MT007908.1| | 2704098 | g15221 | i0 | 93.421 | 5.54185022026432 | 228 | 13 | 99 | 2 | 2 | 227 | 345 | 118 | Sphenomonas teres isolate UJL10 small subunit ribosomal RNA gene, partial sequence | blastn | 1258 | 337 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Petalomonadida | Sphenomonadidae | Sphenomonas | Sphenomonas teres | ||
| 4994362 | 4994362 | PRJNA674048_P_NODE_3044_length_648_cov_10.110184_g2871_i0 | PRJNA674048 | 3044 | 648 | 10.110184 | 65.51399232 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 1120 | 0 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g2871 | i0 | 97.84 | 30.9614197530864 | 648 | 14 | 100 | 0 | 1 | 648 | 2999 | 2352 | 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 | 20063 | 1120 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 7021753 | 7021753 | PRJNA674048_P_NODE_27966_length_168_cov_0.873950_g27763_i0 | PRJNA674048 | 27966 | 168 | 0.87395 | 1.468236 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|290986245|ref|XM_002675789.1| | 5762 | g27763 | i0 | 100 | 0.345238095238095 | 30 | 0 | 18 | 0 | 89 | 118 | 873 | 844 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_68813), partial mRNA | blastn | 58 | 56.5 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 7021795 | 7021795 | PRJNA674048_P_NODE_32066_length_163_cov_0.912281_g31863_i0 | PRJNA674048 | 32066 | 163 | 0.912281 | 1.48701803 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 159 | 7.779999999999998e-35 | NTclustered | gi|290995629|ref|XM_002680340.1| | 5762 | g31863 | i0 | 89.6 | 0.766871165644172 | 125 | 13 | 77 | 0 | 1 | 125 | 2692 | 2816 | Naegleria gruberi serine/threonine protein kinase (NAEGRDRAFT_78828), partial mRNA | blastn | 125 | 159 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 7544149 | 7544149 | PRJNA674048_P_NODE_8906_length_320_cov_8.501845_g8703_i0 | PRJNA674048 | 8906 | 320 | 8.501845 | 27.205904 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 592 | 1.4299999999999996e-164 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g8703 | i0 | 100 | 94.325 | 320 | 0 | 100 | 0 | 1 | 320 | 74 | 393 | 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 | 30184 | 592 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 8296504 | 8296504 | PRJNA674048_P_NODE_7187_length_369_cov_2.984375_g6984_i0 | PRJNA674048 | 7187 | 369 | 2.984375 | 11.01234375 | Trypanosoma theileri | 67003 | Euglenozoa | other_Eukaryota | 488 | 2.26e-133 | NTclustered | gi|2026667530|dbj|LC618030.1| | 67003 | g6984 | i0 | 90.451 | 141.482384823848 | 377 | 27 | 100 | 7 | 1 | 369 | 4772 | 4397 | Trypanosoma theileri YMG-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, ITS5, partial and complete sequence | blastn | 52207 | 488 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 8818973 | 8818973 | PRJNA674048_P_NODE_16187_length_221_cov_2.261628_g15984_i0 | PRJNA674048 | 16187 | 221 | 2.261628 | 4.99819788 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 409 | 1.0100000000000001e-109 | NTclustered | gi|2801876964|gb|PQ308414.1| | 37103 | g15984 | i0 | 100 | 99.9683257918552 | 221 | 0 | 100 | 0 | 1 | 221 | 266 | 46 | Naegleria sp. isolate N1 small subunit ribosomal RNA gene, partial sequence | blastn | 22093 | 409 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria sp. | ||||
| 11369454 | 11369454 | PRJNA674048_P_NODE_17709_length_210_cov_6.347826_g17506_i0 | PRJNA674048 | 17709 | 210 | 6.347826 | 13.3304346 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 388 | 1.24e-103 | NTclustered | gi|32966202|gb|AY266314.1| | 5762 | g17506 | i0 | 100 | 99.9952380952381 | 210 | 0 | 100 | 0 | 1 | 210 | 264 | 473 | Naegleria gruberi 18S ribosomal RNA gene, partial sequence | blastn | 20999 | 388 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 12645117 | 12645117 | PRJNA674048_P_NODE_10970_length_281_cov_3.168103_g10767_i0 | PRJNA674048 | 10970 | 281 | 3.168103 | 8.90236943 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 228 | 4.0099999999999984e-55 | NTclustered | gi|2119430704|ref|XM_044702190.1| | 5763 | g10767 | i0 | 85.455 | 137.110320284698 | 220 | 30 | 78 | 2 | 1 | 219 | 4 | 222 | Naegleria fowleri uncharacterized protein (FDP41_011747), partial mRNA | blastn | 38528 | 228 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 13397245 | 13397245 | PRJNA674048_P_NODE_27591_length_168_cov_1.470588_g27388_i0 | PRJNA674048 | 27591 | 168 | 1.470588 | 2.47058784 | Scytomonas saepesedens | 1732443 | Euglenozoa | other_Eukaryota | 291 | 2.75e-74 | NTclustered | gi|937541989|gb|KP306755.1| | 1732443 | g27388 | i0 | 97.647 | 44.0119047619048 | 170 | 2 | 100 | 1 | 1 | 168 | 1436 | 1267 | Scytomonas saepesedens 18S ribosomal RNA gene, partial sequence | blastn | 7394 | 291 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Petalomonadida | Scytomonadidae | Scytomonas | Scytomonas saepesedens | ||
| 15194470 | 15194470 | PRJNA674048_P_NODE_16292_length_220_cov_11.491228_g16089_i0 | PRJNA674048 | 16292 | 220 | 11.491228 | 25.2807016 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 407 | 3.61e-109 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g16089 | i0 | 100 | 10.1181818181818 | 220 | 0 | 100 | 0 | 1 | 220 | 5548 | 5767 | 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 | 2226 | 407 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 19769985 | 19769985 | PRJNA674048_P_NODE_25996_length_172_cov_1.577236_g25793_i0 | PRJNA674048 | 25996 | 172 | 1.577236 | 2.71284592 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 172 | 1.06e-38 | NTclustered | gi|302026180|gb|GQ377699.1| | 75058 | g25793 | i0 | 91.27 | 72.7616279069767 | 126 | 11 | 73 | 0 | 1 | 126 | 174 | 49 | Bodo saltans elongation factor 1 alpha mRNA, complete cds | blastn | 12515 | 172 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 19770070 | 19770070 | PRJNA674048_P_NODE_5496_length_442_cov_6.829517_g5293_i0 | PRJNA674048 | 5496 | 442 | 6.829517 | 30.18646514 | Sphenomonas teres | 2704098 | Euglenozoa | other_Eukaryota | 516 | 1.26e-141 | NTclustered | gi|1803019522|gb|MT007908.1| | 2704098 | g5293 | i0 | 91.071 | 8.53846153846154 | 392 | 19 | 85 | 9 | 66 | 441 | 802 | 1193 | Sphenomonas teres isolate UJL10 small subunit ribosomal RNA gene, partial sequence | blastn | 3774 | 516 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Petalomonadida | Sphenomonadidae | Sphenomonas | Sphenomonas teres | ||
| 23595910 | 23595910 | PRJNA674048_P_NODE_18639_length_205_cov_1.346154_g18436_i0 | PRJNA674048 | 18639 | 205 | 1.346154 | 2.7596157 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 351 | 1.58e-92 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g18436 | i0 | 97.561 | 12.2487804878049 | 205 | 5 | 100 | 0 | 1 | 205 | 2283 | 2079 | Allovahlkampfia sp. isolate P10 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 2511 | 351 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 24869247 | 24869247 | PRJNA674048_P_NODE_17860_length_210_cov_1.080745_g17657_i0 | PRJNA674048 | 17860 | 210 | 1.080745 | 2.2695645 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 342 | 9.769999999999999e-90 | NTclustered | gi|11466174|ref|NC_002573.1| | 5762 | g17657 | i0 | 95.814 | 1.02380952380952 | 215 | 4 | 100 | 2 | 1 | 210 | 272 | 486 | Naegleria gruberi mitochondrion, complete genome | blastn | 215 | 342 | 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);;