contig_metadata
27 rows where bioproject = "PRJNA1000943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1419847 | 1419847 | PRJNA1000943_P_NODE_1782_length_569_cov_2.356855_g1646_i0 | PRJNA1000943 | 1782 | 569 | 2.356855 | 13.41050495 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 54.7 | 0.016 | NTclustered | gi|1752368981|ref|XM_030988652.1| | 7668 | g1646 | i0 | 100 | 0.0509666080843585 | 29 | 0 | 5 | 0 | 162 | 190 | 2676 | 2648 | PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC100891279 (LOC100891279), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 2695306 | 2695306 | PRJNA1000943_P_NODE_13823_length_246_cov_0.901734_g13685_i0 | PRJNA1000943 | 13823 | 246 | 0.901734 | 2.21826564 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 99.8 | 2.12e-22 | NR | PIK57718.1 | 307972 | g13685 | i0 | 55.6 | 1.97560975609756 | 81 | 36 | 98.8 | 0 | 245 | 3 | 192 | 272 | PIK57718.1 putative glycerol kinase 5 [Apostichopus japonicus] | diamond | 486 | 100 | 0.998 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 3971433 | 3971433 | PRJNA1000943_P_NODE_1844_length_557_cov_2.927686_g1708_i0 | PRJNA1000943 | 1844 | 557 | 2.927686 | 16.30721102 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 126 | 2.78e-30 | NR | XP_030843483.1 | 7668 | g1708 | i0 | 41.2 | 1.83662477558348 | 170 | 94 | 89.9 | 2 | 521 | 21 | 101 | 267 | XP_030843483.1 transmembrane protease serine 9 [Strongylocentrotus purpuratus] | diamond | 1023 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 3971481 | 3971481 | PRJNA1000943_P_NODE_7084_length_307_cov_1.974359_g6946_i0 | PRJNA1000943 | 7084 | 307 | 1.974359 | 6.06128213 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 114 | 1.48e-27 | NR | XP_022101766.1 | 133434 | g6946 | i0 | 75.4 | 7.26058631921824 | 69 | 17 | 67.4 | 0 | 305 | 99 | 149 | 217 | XP_022101766.1 calreticulin-like [Acanthaster planci] | diamond | 2229 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 7797618 | 7797618 | PRJNA1000943_P_NODE_14187_length_245_cov_0.906977_g14049_i0 | PRJNA1000943 | 14187 | 245 | 0.906977 | 2.22209365 | Asteroidea | 7588 | Echinodermata | other_Eukaryota | 90.1 | 7.78e-19 | NR | XP_033632791.1 | 7604 | g14049 | i0 | 72.4 | 6.62448979591837 | 58 | 15 | 71 | 1 | 192 | 19 | 27 | 83 | XP_033632791.1 cytosolic purine 5'-nucleotidase-like isoform X2 [Asterias rubens] | diamond | 1623 | 90.5 | 0.995580110497237 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 11623706 | 11623706 | PRJNA1000943_P_NODE_15230_length_242_cov_1.846154_g15092_i0 | PRJNA1000943 | 15230 | 242 | 1.846154 | 4.46769268 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|1944935230|ref|XM_038223242.1| | 46514 | g15092 | i0 | 100 | 0.231404958677686 | 28 | 0 | 12 | 0 | 32 | 59 | 3062 | 3035 | PREDICTED: Patiria miniata uncharacterized LOC119746350 (LOC119746350), transcript variant X1, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 21821968 | 21821968 | PRJNA1000943_P_NODE_14698_length_244_cov_0.912281_g14560_i0 | PRJNA1000943 | 14698 | 244 | 0.912281 | 2.22596564 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|1826671125|ref|XM_033267324.1| | 1529436 | g14560 | i0 | 100 | 0.463114754098361 | 29 | 0 | 12 | 0 | 57 | 85 | 391 | 419 | PREDICTED: Anneissia japonica 60S acidic ribosomal protein P2-like (LOC117121922), mRNA | blastn | 113 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 26837255 | 26837255 | PRJNA1000943_P_NODE_8221_length_288_cov_1.451163_g8083_i0 | PRJNA1000943 | 8221 | 288 | 1.451163 | 4.17934944 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 124 | 1.59e-33 | NR | XP_030850469.1 | 7668 | g8083 | i0 | 70.1 | 19.9791666666667 | 87 | 26 | 90.6 | 0 | 27 | 287 | 4 | 90 | XP_030850469.1 60S ribosomal protein L13a-like [Strongylocentrotus purpuratus] | diamond | 5754 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 27438094 | 27438094 | PRJNA1000943_P_NODE_5203_length_350_cov_1.537906_g5066_i0 | PRJNA1000943 | 5203 | 350 | 1.537906 | 5.382671 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 62.8 | 1.61e-9 | NR | XP_041464052.1 | 7654 | g5066 | i0 | 34.7 | 3.36 | 118 | 68 | 94.3 | 7 | 5 | 334 | 40 | 156 | XP_041464052.1 myeloid-derived growth factor-like [Lytechinus variegatus] | diamond | 1176 | 63.2 | 0.993670886075949 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28013717 | 28013717 | PRJNA1000943_P_NODE_10045_length_264_cov_1.513089_g9907_i0 | PRJNA1000943 | 10045 | 264 | 1.513089 | 3.99455496 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 115 | 3.33e-29 | NR | NP_001229598.1 | 7668 | g9907 | i0 | 57.8 | 1.88636363636364 | 83 | 35 | 94.3 | 0 | 262 | 14 | 183 | 265 | NP_001229598.1 C-4 methylsterol oxidase-like [Strongylocentrotus purpuratus] | diamond | 498 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 28069310 | 28069310 | PRJNA1000943_P_NODE_3205_length_433_cov_1.080556_g3068_i0 | PRJNA1000943 | 3205 | 433 | 1.080556 | 4.67880748 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 154 | 2.98e-45 | NR | XP_033632396.1 | 7604 | g3068 | i0 | 64.2 | 62.0923787528868 | 120 | 43 | 83.1 | 0 | 379 | 20 | 3 | 122 | XP_033632396.1 60S ribosomal protein L31-like [Asterias rubens] | diamond | 26886 | 155 | 0.993548387096774 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 28329197 | 28329197 | PRJNA1000943_P_NODE_14146_length_245_cov_0.906977_g14008_i0 | PRJNA1000943 | 14146 | 245 | 0.906977 | 2.22209365 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 51.6 | 2.95e-5 | NR | XP_033643958.1 | 7604 | g14008 | i0 | 42.1 | 4.18775510204082 | 57 | 33 | 69.8 | 0 | 234 | 64 | 1107 | 1163 | XP_033643958.1 ankyrin repeat domain-containing protein 17-like isoform X2 [Asterias rubens] | diamond | 1026 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 28424133 | 28424133 | PRJNA1000943_P_NODE_8026_length_291_cov_1.844037_g7888_i0 | PRJNA1000943 | 8026 | 291 | 1.844037 | 5.36614767 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 83.2 | 2.05e-16 | NR | XP_041479530.1 | 7654 | g7888 | i0 | 40 | 3.94845360824742 | 95 | 55 | 97.9 | 1 | 2 | 286 | 129 | 221 | XP_041479530.1 uncharacterized oxidoreductase YrbE-like [Lytechinus variegatus] | diamond | 1149 | 83.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28550496 | 28550496 | PRJNA1000943_P_NODE_5387_length_345_cov_0.992647_g5249_i0 | PRJNA1000943 | 5387 | 345 | 0.992647 | 3.42463215 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 80.9 | 5.13e-15 | NR | XP_041485888.1 | 7654 | g5249 | i0 | 39.5 | 2.92173913043478 | 114 | 68 | 98.3 | 1 | 7 | 345 | 270 | 383 | XP_041485888.1 annexin A5-like isoform X1 [Lytechinus variegatus] | diamond | 1008 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 29402771 | 29402771 | PRJNA1000943_P_NODE_14209_length_245_cov_0.906977_g14071_i0 | PRJNA1000943 | 14209 | 245 | 0.906977 | 2.22209365 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 134 | 5.37e-36 | NR | XP_033630075.1 | 7604 | g14071 | i0 | 70.4 | 0.991836734693878 | 81 | 24 | 99.2 | 0 | 243 | 1 | 249 | 329 | XP_033630075.1 protein ADP-ribosylarginine hydrolase-like [Asterias rubens] | diamond | 243 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 29529174 | 29529174 | PRJNA1000943_P_NODE_6190_length_325_cov_1.500000_g6052_i0 | PRJNA1000943 | 6190 | 325 | 1.5 | 4.875 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 186 | 3.5e-52 | NR | KAJ8043531.1 | 206669 | g6052 | i0 | 80.6 | 4.98461538461538 | 108 | 21 | 99.7 | 0 | 1 | 324 | 101 | 208 | KAJ8043531.1 Major vault protein [Holothuria leucospilota] | diamond | 1620 | 186 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30090058 | 30090058 | PRJNA1000943_P_NODE_9432_length_271_cov_1.575758_g9294_i0 | PRJNA1000943 | 9432 | 271 | 1.575758 | 4.27030418 | root | 1 | Root_unresolved | Root_unresolved | 100 | 4.7199999999999996e-23 | NR | KAJ8029746.1 | 206669 | g9294 | i0 | 51.8 | 27.3431734317343 | 83 | 39 | 91.9 | 1 | 269 | 21 | 103 | 184 | KAJ8029746.1 Fructose-1,6-bisphosphatase 1 [Holothuria leucospilota] | diamond | 7410 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30216443 | 30216443 | PRJNA1000943_P_NODE_5972_length_330_cov_1.210117_g5834_i0 | PRJNA1000943 | 5972 | 330 | 1.210117 | 3.9933861 | root | 1 | Root_unresolved | Root_unresolved | 47 | 0.00319 | NR | KAJ8027768.1 | 206669 | g5834 | i0 | 48.8 | 3.71818181818182 | 43 | 22 | 39.1 | 0 | 329 | 201 | 300 | 342 | KAJ8027768.1 Acyl-CoA synthetase family member 2, mitochondrial [Holothuria leucospilota] | diamond | 1227 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30880030 | 30880030 | PRJNA1000943_P_NODE_6654_length_315_cov_1.611570_g6516_i0 | PRJNA1000943 | 6654 | 315 | 1.61157 | 5.0764455 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 46.6 | 0.0031 | NR | KAJ8025792.1 | 206669 | g6516 | i0 | 43.8 | 3.91428571428571 | 64 | 30 | 61 | 2 | 283 | 92 | 134 | 191 | KAJ8025792.1 Alpha-crystallin B chain [Holothuria leucospilota] | diamond | 1233 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31038346 | 31038346 | PRJNA1000943_P_NODE_895_length_786_cov_2.908836_g774_i0 | PRJNA1000943 | 895 | 786 | 2.908836 | 22.86345096 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 284 | 6.41e-93 | NR | XP_030830317.1 | 7668 | g774 | i0 | 60.4 | 21.9656488549618 | 240 | 94 | 91.2 | 1 | 738 | 22 | 7 | 246 | XP_030830317.1 60S ribosomal protein L7 [Strongylocentrotus purpuratus] | diamond | 17265 | 285 | 0.996491228070175 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31132532 | 31132532 | PRJNA1000943_P_NODE_14915_length_243_cov_0.917647_g14777_i0 | PRJNA1000943 | 14915 | 243 | 0.917647 | 2.22988221 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 64.3 | 1.5e-10 | NR | XP_063955432.1 | 7653 | g14777 | i0 | 70.6 | 2.83950617283951 | 51 | 13 | 63 | 1 | 171 | 19 | 17 | 65 | XP_063955432.1 methylmalonyl-CoA epimerase, mitochondrial-like [Lytechinus pictus] | diamond | 690 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 31424765 | 31424765 | PRJNA1000943_P_NODE_15696_length_238_cov_2.836364_g15558_i0 | PRJNA1000943 | 15696 | 238 | 2.836364 | 6.75054632 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 87.8 | 3.42e-20 | NR | KAJ8030924.1 | 206669 | g15558 | i0 | 54.5 | 0.970588235294118 | 77 | 35 | 97.1 | 0 | 6 | 236 | 20 | 96 | KAJ8030924.1 Profilin-1A [Holothuria leucospilota] | diamond | 231 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31424768 | 31424768 | PRJNA1000943_P_NODE_5036_length_355_cov_1.106383_g4899_i0 | PRJNA1000943 | 5036 | 355 | 1.106383 | 3.92765965 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 194 | 7.769999999999997e-55 | NR | XP_038077900.1 | 46514 | g4899 | i0 | 75 | 1.82535211267606 | 108 | 26 | 91.3 | 1 | 29 | 352 | 24 | 130 | XP_038077900.1 uncharacterized protein LOC119745555 isoform X22 [Patiria miniata] | diamond | 648 | 194 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 32089084 | 32089084 | PRJNA1000943_P_NODE_11878_length_251_cov_0.876404_g11740_i0 | PRJNA1000943 | 11878 | 251 | 0.876404 | 2.19977404 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 99 | 2.96e-22 | NR | XP_033119294.1 | 1529436 | g11740 | i0 | 65.4 | 5.67729083665339 | 78 | 25 | 93.2 | 1 | 238 | 5 | 300 | 375 | XP_033119294.1 60S ribosomal protein L3-like [Anneissia japonica] | diamond | 1425 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 32366680 | 32366680 | PRJNA1000943_P_NODE_2679_length_468_cov_2.022785_g2542_i0 | PRJNA1000943 | 2679 | 468 | 2.022785 | 9.4666338 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 141 | 2.01e-36 | NR | XP_022088629.1 | 133434 | g2542 | i0 | 57.9 | 8.28205128205128 | 107 | 45 | 68.6 | 0 | 147 | 467 | 38 | 144 | XP_022088629.1 ornithine decarboxylase-like [Acanthaster planci] | diamond | 3876 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 32405623 | 32405623 | PRJNA1000943_P_NODE_9359_length_272_cov_1.567839_g9221_i0 | PRJNA1000943 | 9359 | 272 | 1.567839 | 4.26452208 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 77.8 | 6.01e-16 | NR | XP_071482790.1 | 105358 | g9221 | i0 | 44.9 | 1.96323529411765 | 89 | 46 | 96 | 2 | 2 | 262 | 44 | 131 | XP_071482790.1 uncharacterized protein, partial [Diadema antillarum] | diamond | 534 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 32871248 | 32871248 | PRJNA1000943_P_NODE_15520_length_242_cov_0.923077_g15382_i0 | PRJNA1000943 | 15520 | 242 | 0.923077 | 2.23384634 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 50.8 | 5.26e-5 | NR | KAJ8039586.1 | 206669 | g15382 | i0 | 43.8 | 1.7603305785124 | 48 | 26 | 58.3 | 1 | 18 | 158 | 125 | 172 | KAJ8039586.1 Neurogenic locus Notch protein [Holothuria leucospilota] | diamond | 426 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota |
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);;