contig_metadata
27 rows where bioproject = "PRJNA971593", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4772603 | 4772603 | PRJNA971593_P_NODE_23644_length_249_cov_0.875000_g23495_i0 | PRJNA971593 | 23644 | 249 | 0.875 | 2.17875 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 75 | 4.81e-9 | NTclustered | gi|1752388613|ref|XM_030997039.1| | 7668 | g23495 | i0 | 79.464 | 0.979919678714859 | 112 | 18 | 43 | 4 | 85 | 192 | 3772 | 3882 | PREDICTED: Strongylocentrotus purpuratus ATP-citrate synthase (LOC594785), mRNA | blastn | 244 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 7322152 | 7322152 | PRJNA971593_P_NODE_10126_length_381_cov_1.155844_g9977_i0 | PRJNA971593 | 10126 | 381 | 1.155844 | 4.40376564 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 313 | 1.51e-80 | NTclustered | gi|1752354307|ref|XM_030982482.1| | 7668 | g9977 | i0 | 91.593 | 60.1259842519685 | 226 | 19 | 59 | 0 | 11 | 236 | 6629 | 6404 | PREDICTED: Strongylocentrotus purpuratus serine/threonine-protein kinase 25 (LOC591674), transcript variant X1, mRNA | blastn | 22908 | 313 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 7322198 | 7322198 | PRJNA971593_P_NODE_13606_length_326_cov_1.762846_g13457_i0 | PRJNA971593 | 13606 | 326 | 1.762846 | 5.74687796 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 138 | 1.7199999999999998e-35 | NR | KAJ8022903.1 | 206669 | g13457 | i0 | 56.5 | 14.558282208589 | 108 | 47 | 99.4 | 0 | 325 | 2 | 520 | 627 | KAJ8022903.1 Long-chain-fatty-acid--CoA ligase 1 [Holothuria leucospilota] | diamond | 4746 | 139 | 0.992805755395683 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 8597297 | 8597297 | PRJNA971593_P_NODE_27727_length_243_cov_0.905882_g27578_i0 | PRJNA971593 | 27727 | 243 | 0.905882 | 2.20129326 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 250 | 7.2399999999999995e-62 | NTclustered | gi|1752373985|ref|XM_030990816.1| | 7668 | g27578 | i0 | 89.5 | 79.5061728395062 | 200 | 17 | 81 | 4 | 41 | 238 | 1812 | 2009 | PREDICTED: Strongylocentrotus purpuratus lanC-like protein 2 (LOC593095), transcript variant X1, mRNA | blastn | 19320 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 9872505 | 9872505 | PRJNA971593_P_NODE_25868_length_246_cov_0.890173_g25719_i0 | PRJNA971593 | 25868 | 246 | 0.890173 | 2.18982558 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 298 | 2.5799999999999998e-76 | NTclustered | gi|164457974|gb|AC204779.10| | 7668 | g25719 | i0 | 88.71 | 14.3943089430894 | 248 | 22 | 100 | 5 | 1 | 246 | 94614 | 94371 | Strongylocentrotus purpuratus BAC CS-181662 (L. Courtney Smith, George Washington University) complete sequence | blastn | 3541 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 12423397 | 12423397 | PRJNA971593_P_NODE_18310_length_279_cov_0.975728_g18161_i0 | PRJNA971593 | 18310 | 279 | 0.975728 | 2.72228112 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 320 | 6.38e-83 | NTclustered | gi|985701817|gb|KU668453.1| | 7668 | g18161 | i0 | 96.875 | 64.4336917562724 | 192 | 5 | 69 | 1 | 88 | 279 | 97069 | 97259 | Strongylocentrotus purpuratus clone 10K9 sequence, complete sequence | blastn | 17977 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 16247102 | 16247102 | PRJNA971593_P_NODE_22373_length_251_cov_0.865169_g22224_i0 | PRJNA971593 | 22373 | 251 | 0.865169 | 2.17157419 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 348 | 2.5900000000000005e-91 | NTclustered | gi|1752357563|ref|XM_030983870.1| | 7668 | g22224 | i0 | 91.633 | 11.9362549800797 | 251 | 21 | 100 | 0 | 1 | 251 | 1784 | 2034 | PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC100890809 (LOC100890809), mRNA | blastn | 2996 | 348 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 24217926 | 24217926 | PRJNA971593_P_NODE_27559_length_243_cov_0.905882_g27410_i0 | PRJNA971593 | 27559 | 243 | 0.905882 | 2.20129326 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 270 | 5.5499999999999986e-68 | NTclustered | gi|2645092062|gb|PP082968.1| | 7668 | g27410 | i0 | 91.457 | 28.1604938271605 | 199 | 14 | 81 | 2 | 46 | 243 | 9833 | 9637 | Strongylocentrotus purpuratus clone BAC10B1_15, complete sequence | blastn | 6843 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 25170262 | 25170262 | PRJNA971593_P_NODE_11740_length_353_cov_0.785714_g11591_i0 | PRJNA971593 | 11740 | 353 | 0.785714 | 2.77357042 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 148 | 4.14e-31 | NTclustered | gi|1752398323|ref|XM_787882.5| | 7668 | g11591 | i0 | 88.095 | 4.35694050991501 | 126 | 13 | 36 | 2 | 121 | 246 | 2137 | 2014 | PREDICTED: Strongylocentrotus purpuratus transcription factor CP2 (LOC588186), mRNA | blastn | 1538 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 25170576 | 25170576 | PRJNA971593_P_NODE_7760_length_437_cov_1.013736_g7611_i0 | PRJNA971593 | 7760 | 437 | 1.013736 | 4.43002632 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 383 | 1.3199999999999995e-101 | NTclustered | gi|1752378597|ref|XM_030992663.1| | 7668 | g7611 | i0 | 87.842 | 34.4050343249428 | 329 | 36 | 75 | 3 | 101 | 426 | 2596 | 2923 | PREDICTED: Strongylocentrotus purpuratus myb-related transcription factor (LOC592751), mRNA | blastn | 15035 | 383 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 25170589 | 25170589 | PRJNA971593_P_NODE_8780_length_409_cov_5.059524_g8631_i0 | PRJNA971593 | 8780 | 409 | 5.059524 | 20.69345316 | root | 1 | Root_unresolved | Root_unresolved | 144 | 1.22e-41 | NR | XP_038057180.1 | 46514 | g8631 | i0 | 65.1 | 2.31051344743276 | 106 | 37 | 77.8 | 0 | 90 | 407 | 8 | 113 | XP_038057180.1 40S ribosomal protein S20-like [Patiria miniata] | diamond | 945 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 26683918 | 26683918 | PRJNA971593_P_NODE_9221_length_400_cov_0.941896_g9072_i0 | PRJNA971593 | 9221 | 400 | 0.941896 | 3.767584 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 116 | 7.88e-30 | NR | XP_038055488.1 | 46514 | g9072 | i0 | 45.2 | 8.475 | 124 | 63 | 90.8 | 2 | 25 | 387 | 1 | 122 | XP_038055488.1 malignant T-cell-amplified sequence 1-like [Patiria miniata] | diamond | 3390 | 117 | 0.991452991452991 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 28453600 | 28453600 | PRJNA971593_P_NODE_25626_length_246_cov_0.890173_g25477_i0 | PRJNA971593 | 25626 | 246 | 0.890173 | 2.18982558 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 108 | 2.11e-25 | NR | XP_030839882.1 | 7668 | g25477 | i0 | 75.4 | 13.1829268292683 | 61 | 15 | 74.4 | 0 | 244 | 62 | 495 | 555 | XP_030839882.1 intraflagellar transport protein 56 [Strongylocentrotus purpuratus] | diamond | 3243 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 29022129 | 29022129 | PRJNA971593_P_NODE_18788_length_275_cov_1.183168_g18639_i0 | PRJNA971593 | 18788 | 275 | 1.183168 | 3.253712 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 75.5 | 1.66e-13 | NR | XP_033647644.1 | 7604 | g18639 | i0 | 51.3 | 3.87272727272727 | 76 | 35 | 80.7 | 1 | 49 | 270 | 243 | 318 | XP_033647644.1 protein SHQ1 homolog [Asterias rubens] | diamond | 1065 | 75.9 | 0.994729907773386 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 29463403 | 29463403 | PRJNA971593_P_NODE_13790_length_324_cov_1.386454_g13641_i0 | PRJNA971593 | 13790 | 324 | 1.386454 | 4.49211096 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 112 | 3.55e-26 | NR | XP_063960238.1 | 7653 | g13641 | i0 | 72.5 | 2.55555555555556 | 69 | 19 | 63.9 | 0 | 2 | 208 | 2115 | 2183 | XP_063960238.1 uncharacterized protein LOC129266975 [Lytechinus pictus] | diamond | 828 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 29615068 | 29615068 | PRJNA971593_P_NODE_22030_length_251_cov_0.865169_g21881_i0 | PRJNA971593 | 22030 | 251 | 0.865169 | 2.17157419 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 108 | 1.53e-25 | NR | XP_041477977.1 | 7654 | g21881 | i0 | 69.5 | 0.9800796812749 | 82 | 22 | 96.8 | 2 | 3 | 245 | 179 | 258 | XP_041477977.1 muscarinic acetylcholine receptor M2-like [Lytechinus variegatus] | diamond | 246 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 29836356 | 29836356 | PRJNA971593_P_NODE_24431_length_248_cov_0.880000_g24282_i0 | PRJNA971593 | 24431 | 248 | 0.88 | 2.1824 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 51.6 | 2.96e-5 | NR | XP_003725559.1 | 7668 | g24282 | i0 | 61 | 0.495967741935484 | 41 | 14 | 47.2 | 1 | 131 | 247 | 3 | 43 | XP_003725559.1 zinc finger protein 37 [Strongylocentrotus purpuratus] | diamond | 123 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 30468593 | 30468593 | PRJNA971593_P_NODE_28633_length_242_cov_0.911243_g28484_i0 | PRJNA971593 | 28633 | 242 | 0.911243 | 2.20520806 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 64.3 | 9.3e-10 | NR | XP_030832179.1 | 7668 | g28484 | i0 | 43 | 2.04545454545455 | 79 | 42 | 95.5 | 2 | 236 | 6 | 30 | 107 | XP_030832179.1 sushi, von Willebrand factor type A, EGF and pentraxin domain-containing protein 1 isoform X2 [Strongylocentrotus purpuratus] | diamond | 495 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31194587 | 31194587 | PRJNA971593_P_NODE_20215_length_264_cov_1.015707_g20066_i0 | PRJNA971593 | 20215 | 264 | 1.015707 | 2.68146648 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 119 | 1.88e-30 | NR | XP_041460869.1 | 7654 | g20066 | i0 | 70.5 | 1.80681818181818 | 78 | 23 | 88.6 | 0 | 242 | 9 | 51 | 128 | XP_041460869.1 uncharacterized protein LOC121412022 [Lytechinus variegatus] | diamond | 477 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31200840 | 31200840 | PRJNA971593_P_NODE_8495_length_416_cov_2.002915_g8346_i0 | PRJNA971593 | 8495 | 416 | 2.002915 | 8.3321264 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 135 | 1.14e-36 | NR | XP_030830317.1 | 7668 | g8346 | i0 | 56.3 | 7.5 | 128 | 56 | 92.3 | 0 | 33 | 416 | 13 | 140 | XP_030830317.1 60S ribosomal protein L7 [Strongylocentrotus purpuratus] | diamond | 3120 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31479876 | 31479876 | PRJNA971593_P_NODE_10776_length_369_cov_0.885135_g10627_i0 | PRJNA971593 | 10776 | 369 | 0.885135 | 3.26614815 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 158 | 5.559999999999998e-42 | NR | XP_041477327.1 | 7654 | g10627 | i0 | 63.9 | 1.97560975609756 | 122 | 42 | 98.4 | 2 | 5 | 367 | 475 | 595 | XP_041477327.1 uncharacterized protein LOC121425366 [Lytechinus variegatus] | diamond | 729 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31479878 | 31479878 | PRJNA971593_P_NODE_11256_length_360_cov_1.383275_g11107_i0 | PRJNA971593 | 11256 | 360 | 1.383275 | 4.97979 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 155 | 5.94e-41 | NR | XP_041463449.1 | 7654 | g11107 | i0 | 66.7 | 4.75833333333333 | 111 | 37 | 92.5 | 0 | 358 | 26 | 435 | 545 | XP_041463449.1 leucine--tRNA ligase, cytoplasmic-like isoform X2 [Lytechinus variegatus] | diamond | 1713 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31606178 | 31606178 | PRJNA971593_P_NODE_10396_length_375_cov_2.910596_g10247_i0 | PRJNA971593 | 10396 | 375 | 2.910596 | 10.914735 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 107 | 5.0799999999999996e-24 | NR | XP_022084207.1 | 133434 | g10247 | i0 | 55.8 | 0.76 | 95 | 42 | 76 | 0 | 328 | 44 | 649 | 743 | XP_022084207.1 adenylate kinase isoenzyme 5-like isoform X2 [Acanthaster planci] | diamond | 285 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 31764300 | 31764300 | PRJNA971593_P_NODE_22957_length_250_cov_0.870056_g22808_i0 | PRJNA971593 | 22957 | 250 | 0.870056 | 2.17514 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 77.4 | 2.56e-14 | NR | XP_030847751.1 | 7668 | g22808 | i0 | 51.9 | 1.944 | 81 | 39 | 97.2 | 0 | 4 | 246 | 502 | 582 | XP_030847751.1 uncharacterized protein LOC115926717 [Strongylocentrotus purpuratus] | diamond | 486 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31827387 | 31827387 | PRJNA971593_P_NODE_22117_length_251_cov_0.865169_g21968_i0 | PRJNA971593 | 22117 | 251 | 0.865169 | 2.17157419 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 57.8 | 2.01e-7 | NR | XP_794413.2 | 7668 | g21968 | i0 | 57.4 | 0.561752988047809 | 47 | 20 | 56.2 | 0 | 75 | 215 | 17 | 63 | XP_794413.2 F-box only protein 22 [Strongylocentrotus purpuratus] | diamond | 141 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 32270685 | 32270685 | PRJNA971593_P_NODE_22318_length_251_cov_0.865169_g22169_i0 | PRJNA971593 | 22318 | 251 | 0.865169 | 2.17157419 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 75.5 | 1.21e-13 | NR | XP_071489383.1 | 105358 | g22169 | i0 | 72.9 | 0.573705179282869 | 48 | 13 | 57.4 | 0 | 145 | 2 | 224 | 271 | XP_071489383.1 solute carrier organic anion transporter family member 4A1-like [Diadema antillarum] | diamond | 144 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 32340312 | 32340312 | PRJNA971593_P_NODE_27119_length_244_cov_0.900585_g26970_i0 | PRJNA971593 | 27119 | 244 | 0.900585 | 2.1974274 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 111 | 7.55e-27 | NR | XP_041464734.1 | 7654 | g26970 | i0 | 61.5 | 1.91803278688525 | 78 | 30 | 95.9 | 0 | 10 | 243 | 88 | 165 | XP_041464734.1 uncharacterized protein LOC121415553 [Lytechinus variegatus] | diamond | 468 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus |
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);;