contig_metadata
27 rows where bioproject = "PRJNA630162" and tax_phylum = "Echinodermata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 601383 | 601383 | PRJNA630162_P_NODE_108281_length_180_cov_10.412214_g106758_i0 | PRJNA630162 | 108281 | 180 | 10.412214 | 18.7419852 | Myriotrochus sp. AKM-2016 | 1902928 | Echinodermata | other_Eukaryota | 180 | 6.71e-41 | NTclustered | gi|1160550711|gb|KX856867.1| | 1902928 | g106758 | i0 | 88.079 | 83.8777777777778 | 151 | 18 | 84 | 0 | 1 | 151 | 413 | 563 | Myriotrochus sp. AKM-2016 voucher NIWA:37812 28S ribosomal RNA gene, partial sequence | blastn | 15098 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Apodida | Myriotrochidae | Myriotrochus | Myriotrochus sp. AKM-2016 | |
| 10807046 | 10807046 | PRJNA630162_P_NODE_97409_length_187_cov_1.724638_g95886_i0 | PRJNA630162 | 97409 | 187 | 1.724638 | 3.22507306 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 128 | 2.59e-25 | NTclustered | gi|2919565827|ref|XM_071625415.1| | 105358 | g95886 | i0 | 91.489 | 46.4866310160428 | 94 | 6 | 49 | 1 | 96 | 187 | 1300 | 1207 | PREDICTED: Diadema antillarum actin, cytoskeletal (LOC139713710), mRNA | blastn | 8693 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 12081777 | 12081777 | PRJNA630162_P_NODE_50250_length_249_cov_1.015000_g48727_i0 | PRJNA630162 | 50250 | 249 | 1.015 | 2.52735 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 172 | 1.66e-38 | NTclustered | gi|2037931621|ref|XM_041597485.1| | 7654 | g48727 | i0 | 86.538 | 62.3253012048193 | 156 | 21 | 63 | 0 | 10 | 165 | 313 | 158 | PREDICTED: Lytechinus variegatus histone H3, embryonic (LOC121406474), mRNA | blastn | 15519 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 13356723 | 13356723 | PRJNA630162_P_NODE_65071_length_219_cov_2.147059_g63548_i0 | PRJNA630162 | 65071 | 219 | 2.147059 | 4.70205921 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 122 | 1.89e-32 | NR | XP_033640297.1 | 7604 | g63548 | i0 | 78.9 | 24.1095890410959 | 71 | 15 | 97.3 | 0 | 214 | 2 | 107 | 177 | XP_033640297.1 60S ribosomal protein L7-like [Asterias rubens] | diamond | 5280 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 16453909 | 16453909 | PRJNA630162_P_NODE_118913_length_175_cov_1.428571_g117390_i0 | PRJNA630162 | 118913 | 175 | 1.428571 | 2.49999925 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 92 | 6.53e-20 | NR | XP_030838316.1 | 7668 | g117390 | i0 | 76.4 | 17.0228571428571 | 55 | 13 | 94.3 | 0 | 4 | 168 | 2089 | 2143 | XP_030838316.1 LOW QUALITY PROTEIN: dynein heavy chain 1, axonemal [Strongylocentrotus purpuratus] | diamond | 2979 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 18454348 | 18454348 | PRJNA630162_P_NODE_44895_length_264_cov_2.260465_g43372_i0 | PRJNA630162 | 44895 | 264 | 2.260465 | 5.9676276 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 67.6 | 8.61e-7 | NTclustered | gi|1752380844|ref|XM_030993632.1| | 7668 | g43372 | i0 | 90.196 | 0.193181818181818 | 51 | 5 | 19 | 0 | 156 | 206 | 293 | 243 | PREDICTED: Strongylocentrotus purpuratus mucin-2-like (LOC115927571), mRNA | blastn | 51 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 21004017 | 21004017 | PRJNA630162_P_NODE_130957_length_169_cov_1.450000_g129434_i0 | PRJNA630162 | 130957 | 169 | 1.45 | 2.4505 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 80.5 | 6.47e-11 | NTclustered | gi|1752345938|ref|XR_004062932.1| | 7668 | g129434 | i0 | 94.34 | 37.7869822485207 | 53 | 2 | 31 | 1 | 102 | 154 | 58 | 7 | PREDICTED: Strongylocentrotus purpuratus U2 spliceosomal RNA (LOC115917722), ncRNA | blastn | 6386 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 22278585 | 22278585 | PRJNA630162_P_NODE_115038_length_177_cov_1.453125_g113515_i0 | PRJNA630162 | 115038 | 177 | 1.453125 | 2.57203125 | Leiaster glaber | 545793 | Echinodermata | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|525531079|gb|KC512791.1| | 545793 | g113515 | i0 | 100 | 0.163841807909605 | 29 | 0 | 16 | 0 | 92 | 120 | 663 | 635 | Leiaster glaber 18S ribosomal RNA gene, partial sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Ophidiasteridae | Leiaster | Leiaster glaber | |
| 22279389 | 22279389 | PRJNA630162_P_NODE_38678_length_286_cov_12.586498_g37155_i0 | PRJNA630162 | 38678 | 286 | 12.586498 | 35.99738428 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 174 | 5.41e-39 | NTclustered | gi|11494220|gb|AF212171.1|AF212171 | 7668 | g37155 | i0 | 91.935 | 46.8881118881119 | 124 | 10 | 43 | 0 | 158 | 281 | 2885 | 2762 | Strongylocentrotus purpuratus internal transcribed spacer 2, and 28S ribosomal RNA gene, partial sequence | blastn | 13410 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 24828872 | 24828872 | PRJNA630162_P_NODE_73920_length_209_cov_2.037500_g72397_i0 | PRJNA630162 | 73920 | 209 | 2.0375 | 4.258375 | Psychropotes longicauda | 55639 | Echinodermata | other_Eukaryota | 71.3 | 5.06e-8 | NTclustered | gi|2370359|emb|Z80946.1| | 55639 | g72397 | i0 | 93.617 | 15.3684210526316 | 47 | 3 | 22 | 0 | 7 | 53 | 26 | 72 | P.longicauda partial 28S rRNA gene | blastn | 3212 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Elasipodida | Psychropotidae | Psychropotes | Psychropotes longicauda | |
| 27251460 | 27251460 | PRJNA630162_P_NODE_159263_length_162_cov_1.699115_g157740_i0 | PRJNA630162 | 159263 | 162 | 1.699115 | 2.7525663 | Aspidochirotida | 7682 | Echinodermata | other_Eukaryota | 59.7 | 1.32e-8 | NR | KAJ8028819.1 | 206669 | g157740 | i0 | 57.7 | 1.92592592592593 | 52 | 22 | 96.3 | 0 | 159 | 4 | 452 | 503 | KAJ8028819.1 putative phospholipid-transporting ATPase IA [Holothuria leucospilota] | diamond | 312 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 27535862 | 27535862 | PRJNA630162_P_NODE_45643_length_262_cov_0.924883_g44120_i0 | PRJNA630162 | 45643 | 262 | 0.924883 | 2.42319346 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 68.9 | 2.87e-11 | NR | XP_038059643.1 | 46514 | g44120 | i0 | 42.5 | 5.56488549618321 | 80 | 45 | 90.5 | 1 | 258 | 22 | 240 | 319 | XP_038059643.1 X-linked retinitis pigmentosa GTPase regulator-like isoform X1 [Patiria miniata] | diamond | 1458 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27693935 | 27693935 | PRJNA630162_P_NODE_133864_length_168_cov_2.218487_g132341_i0 | PRJNA630162 | 133864 | 168 | 2.218487 | 3.72705816 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 48.5 | 1.23e-4 | NR | XP_038054079.1 | 46514 | g132341 | i0 | 55.3 | 3.23214285714286 | 38 | 17 | 67.9 | 0 | 161 | 48 | 1850 | 1887 | XP_038054079.1 uncharacterized protein LOC119726452 isoform X29 [Patiria miniata] | diamond | 543 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27788454 | 27788454 | PRJNA630162_P_NODE_153044_length_164_cov_0.904348_g151521_i0 | PRJNA630162 | 153044 | 164 | 0.904348 | 1.48313072 | root | 1 | Root_unresolved | Root_unresolved | 43.1 | 0.00952 | NR | XP_038046743.1 | 46514 | g151521 | i0 | 55.2 | 1.5 | 29 | 12 | 51.2 | 1 | 89 | 6 | 380 | 408 | XP_038046743.1 multiple epidermal growth factor-like domains protein 6 [Patiria miniata] | diamond | 246 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27965148 | 27965148 | PRJNA630162_P_NODE_8505_length_658_cov_35.702791_g7160_i0 | PRJNA630162 | 8505 | 658 | 35.702791 | 234.92436478 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 75.9 | 4.83e-12 | NR | XP_022093994.1 | 133434 | g7160 | i0 | 52.7 | 0.337386018237082 | 74 | 32 | 32.8 | 2 | 217 | 432 | 283 | 355 | XP_022093994.1 uncharacterized protein LOC110981078 [Acanthaster planci] | diamond | 222 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 30061639 | 30061639 | PRJNA630162_P_NODE_166691_length_157_cov_3.472222_g165168_i0 | PRJNA630162 | 166691 | 157 | 3.472222 | 5.45138854 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 79.7 | 1.03e-15 | NR | XP_038044305.1 | 46514 | g165168 | i0 | 77.6 | 35.484076433121 | 49 | 11 | 93.6 | 0 | 9 | 155 | 552 | 600 | XP_038044305.1 ATP-citrate synthase-like isoform X2 [Patiria miniata] | diamond | 5571 | 80.5 | 0.990062111801242 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 30428632 | 30428632 | PRJNA630162_P_NODE_162533_length_161_cov_3.607143_g161010_i0 | PRJNA630162 | 162533 | 161 | 3.607143 | 5.80750023 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 87.8 | 2.25e-19 | NR | XP_033125693.1 | 1529436 | g161010 | i0 | 71.2 | 1.93788819875776 | 52 | 15 | 96.9 | 0 | 5 | 160 | 92 | 143 | XP_033125693.1 40S ribosomal protein S4, X isoform-like [Anneissia japonica] | diamond | 312 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 30523130 | 30523130 | PRJNA630162_P_NODE_9433_length_625_cov_35.114583_g8052_i0 | PRJNA630162 | 9433 | 625 | 35.114583 | 219.46614375 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 74.7 | 9.25e-12 | NR | XP_022093994.1 | 133434 | g8052 | i0 | 75.6 | 0.216 | 45 | 11 | 21.6 | 0 | 467 | 333 | 283 | 327 | XP_022093994.1 uncharacterized protein LOC110981078 [Acanthaster planci] | diamond | 135 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 30554465 | 30554465 | PRJNA630162_P_NODE_156293_length_163_cov_0.912281_g154770_i0 | PRJNA630162 | 156293 | 163 | 0.912281 | 1.48701803 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 53.1 | 9.46e-7 | NR | PIK53382.1 | 307972 | g154770 | i0 | 47.2 | 2.9079754601227 | 53 | 26 | 93.9 | 1 | 155 | 3 | 16 | 68 | PIK53382.1 hypothetical protein BSL78_09744 [Apostichopus japonicus] | diamond | 474 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 30617706 | 30617706 | PRJNA630162_P_NODE_144973_length_166_cov_0.888889_g143450_i0 | PRJNA630162 | 144973 | 166 | 0.888889 | 1.47555574 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 49.7 | 4.76e-5 | NR | PIK45587.1 | 307972 | g143450 | i0 | 53.5 | 2.54819277108434 | 43 | 20 | 77.7 | 0 | 160 | 32 | 563 | 605 | PIK45587.1 putative sperm plasma membrane calcium transporting ATPase isoform X3 [Apostichopus japonicus] | diamond | 423 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 31123082 | 31123082 | PRJNA630162_P_NODE_83355_length_198_cov_1.328859_g81832_i0 | PRJNA630162 | 83355 | 198 | 1.328859 | 2.63114082 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 46.6 | 8.5e-4 | NR | XP_041472761.1 | 7654 | g81832 | i0 | 46.9 | 6.5 | 49 | 18 | 74.2 | 2 | 159 | 13 | 221 | 261 | XP_041472761.1 multiple epidermal growth factor-like domains protein 10 [Lytechinus variegatus] | diamond | 1287 | 47 | 0.991489361702128 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31503057 | 31503057 | PRJNA630162_P_NODE_36196_length_297_cov_2.891129_g34673_i0 | PRJNA630162 | 36196 | 297 | 2.891129 | 8.58665313 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 44.7 | 0.0143 | NR | XP_038059361.1 | 46514 | g34673 | i0 | 47.2 | 1.60606060606061 | 53 | 27 | 52.5 | 1 | 208 | 53 | 86 | 138 | XP_038059361.1 neurogenic locus protein delta-like isoform X9 [Patiria miniata] | diamond | 477 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 31660859 | 31660859 | PRJNA630162_P_NODE_52857_length_242_cov_2.818653_g51334_i0 | PRJNA630162 | 52857 | 242 | 2.818653 | 6.82114026 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 50.1 | 9.29e-5 | NR | XP_022093994.1 | 133434 | g51334 | i0 | 44.9 | 1.67355371900826 | 69 | 32 | 81.8 | 2 | 26 | 223 | 327 | 392 | XP_022093994.1 uncharacterized protein LOC110981078 [Acanthaster planci] | diamond | 405 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 31768510 | 31768510 | PRJNA630162_P_NODE_159317_length_162_cov_1.654867_g157794_i0 | PRJNA630162 | 159317 | 162 | 1.654867 | 2.68088454 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 63.9 | 4.04e-10 | NR | XP_071490193.1 | 105358 | g157794 | i0 | 56.8 | 5.81481481481481 | 44 | 19 | 81.5 | 0 | 143 | 12 | 490 | 533 | XP_071490193.1 parafibromin-like [Diadema antillarum] | diamond | 942 | 64.3 | 0.993779160186625 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 32053228 | 32053228 | PRJNA630162_P_NODE_104338_length_183_cov_1.477612_g102815_i0 | PRJNA630162 | 104338 | 183 | 1.477612 | 2.70402996 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 61.2 | 4.77e-9 | NR | XP_038051173.1 | 46514 | g102815 | i0 | 51.9 | 1.50819672131148 | 54 | 26 | 88.5 | 0 | 176 | 15 | 318 | 371 | XP_038051173.1 WD repeat and FYVE domain-containing protein 2-like isoform X2 [Patiria miniata] | diamond | 276 | 61.6 | 0.993506493506494 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 32180008 | 32180008 | PRJNA630162_P_NODE_131218_length_169_cov_1.325000_g129695_i0 | PRJNA630162 | 131218 | 169 | 1.325 | 2.23925 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 43.9 | 0.00556 | NR | XP_030849781.1 | 7668 | g129695 | i0 | 47.6 | 1.29585798816568 | 42 | 21 | 72.8 | 1 | 35 | 157 | 2807 | 2848 | XP_030849781.1 uncharacterized protein LOC105442097 [Strongylocentrotus purpuratus] | diamond | 219 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 32767390 | 32767390 | PRJNA630162_P_NODE_86840_length_194_cov_2.096552_g85317_i0 | PRJNA630162 | 86840 | 194 | 2.096552 | 4.06731088 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 49.7 | 7.03e-5 | NR | XP_030848586.1 | 7668 | g85317 | i0 | 51 | 1.51546391752577 | 49 | 21 | 71.1 | 1 | 146 | 9 | 114 | 162 | XP_030848586.1 nuclear pore complex protein Nup160 [Strongylocentrotus purpuratus] | diamond | 294 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus |
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);;