contig_metadata
26 rows where bioproject = "PRJNA414036", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2969551 | 2969551 | PRJNA414036_P_NODE_67603_length_190_cov_1.916129_g65864_i0 | PRJNA414036 | 67603 | 190 | 1.916129 | 3.6406451 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|2707445222|ref|XM_064105914.1| | 7653 | g65864 | i0 | 90.698 | 0.226315789473684 | 43 | 0 | 21 | 4 | 127 | 166 | 704 | 745 | PREDICTED: Lytechinus pictus aspartate and glycine-rich protein-like (LOC129269662), mRNA | blastn | 43 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 6796468 | 6796468 | PRJNA414036_P_NODE_30306_length_272_cov_7.409283_g28570_i0 | PRJNA414036 | 30306 | 272 | 7.409283 | 20.15324976 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 126 | 1.45e-24 | NTclustered | gi|2707408381|ref|XM_054893204.2| | 7653 | g28570 | i0 | 80.233 | 3.48161764705882 | 172 | 30 | 63 | 4 | 94 | 263 | 394 | 563 | PREDICTED: Lytechinus pictus dynein light chain 2, cytoplasmic-like (LOC129254696), mRNA | blastn | 947 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 11897562 | 11897562 | PRJNA414036_P_NODE_29630_length_276_cov_3.016598_g27894_i0 | PRJNA414036 | 29630 | 276 | 3.016598 | 8.32581048 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2919397928|ref|XM_071631265.1| | 105358 | g27894 | i0 | 100 | 0.105072463768116 | 29 | 0 | 11 | 0 | 232 | 260 | 276 | 304 | PREDICTED: Diadema antillarum uncharacterized protein (LOC139719881), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 13172546 | 13172546 | PRJNA414036_P_NODE_63531_length_203_cov_2.809524_g61792_i0 | PRJNA414036 | 63531 | 203 | 2.809524 | 5.70333372 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 69.4 | 1.76e-7 | NTclustered | gi|1752357769|ref|XM_030983960.1| | 7668 | g61792 | i0 | 83.562 | 0.719211822660099 | 73 | 12 | 36 | 0 | 110 | 182 | 812 | 740 | PREDICTED: Strongylocentrotus purpuratus splicing factor U2AF 50 kDa subunit (LOC588126), transcript variant X2, mRNA | blastn | 146 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 24645244 | 24645244 | PRJNA414036_P_NODE_70980_length_181_cov_1.876712_g69241_i0 | PRJNA414036 | 70980 | 181 | 1.876712 | 3.39684872 | Paracentrotus lividus | 7656 | Echinodermata | other_Eukaryota | 63.9 | 7.1e-6 | NTclustered | gi|108735519|gb|DQ536194.1| | 7656 | g69241 | i0 | 79.121 | 0.502762430939227 | 91 | 19 | 50 | 0 | 85 | 175 | 1199 | 1289 | Paracentrotus lividus BMP2/4 mRNA, complete cds | blastn | 91 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Echinidae | Paracentrotus | Paracentrotus lividus | |
| 26726975 | 26726975 | PRJNA414036_P_NODE_20401_length_334_cov_5.595318_g18674_i0 | PRJNA414036 | 20401 | 334 | 5.595318 | 18.68836212 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 63.2 | 7.54e-9 | NR | XP_071499632.1 | 105358 | g18674 | i0 | 59.4 | 0.907185628742515 | 101 | 41 | 90.7 | 0 | 30 | 332 | 594 | 694 | XP_071499632.1 multifunctional protein CAD-like [Diadema antillarum] | diamond | 303 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27106956 | 27106956 | PRJNA414036_P_NODE_16742_length_365_cov_2.839394_g15039_i0 | PRJNA414036 | 16742 | 365 | 2.839394 | 10.3637881 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 117 | 6.16e-28 | NR | XP_033099774.1 | 1529436 | g15039 | i0 | 57.8 | 84.8712328767123 | 116 | 48 | 94.5 | 1 | 351 | 7 | 194 | 309 | XP_033099774.1 F-box-like/WD repeat-containing protein TBL1XR1 [Anneissia japonica] | diamond | 30978 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27170145 | 27170145 | PRJNA414036_P_NODE_60482_length_214_cov_9.134078_g58743_i0 | PRJNA414036 | 60482 | 214 | 9.134078 | 19.54692692 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 55.5 | 7.54e-8 | NR | XP_030844740.1 | 7668 | g58743 | i0 | 62 | 12.6168224299065 | 50 | 19 | 70.1 | 0 | 16 | 165 | 5 | 54 | XP_030844740.1 60S ribosomal protein L7a-like, partial [Strongylocentrotus purpuratus] | diamond | 2700 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 27345251 | 27345251 | PRJNA414036_P_NODE_11443_length_418_cov_4.031332_g9866_i0 | PRJNA414036 | 11443 | 418 | 4.031332 | 16.85096776 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 87.8 | 4.98e-17 | NR | XP_063965664.1 | 7653 | g9866 | i0 | 75.5 | 17.8636363636364 | 53 | 13 | 38 | 0 | 258 | 100 | 1466 | 1518 | XP_063965664.1 chromodomain-helicase-DNA-binding protein Mi-2 homolog isoform X10 [Lytechinus pictus] | diamond | 7467 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 27581001 | 27581001 | PRJNA414036_P_NODE_86864_length_153_cov_1.618644_g85125_i0 | PRJNA414036 | 86864 | 153 | 1.618644 | 2.47652532 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 41.6 | 0.0277 | NR | KAJ8025587.1 | 206669 | g85125 | i0 | 47.8 | 0.901960784313726 | 46 | 22 | 90.2 | 1 | 15 | 152 | 208 | 251 | KAJ8025587.1 Dual specificity protein phosphatase 4 [Holothuria leucospilota] | diamond | 138 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 28134631 | 28134631 | PRJNA414036_P_NODE_76305_length_169_cov_3.335821_g74566_i0 | PRJNA414036 | 76305 | 169 | 3.335821 | 5.63753749 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 89.7 | 2.92e-19 | NR | XP_011661670.2 | 7668 | g74566 | i0 | 84.9 | 107.201183431953 | 53 | 8 | 94.1 | 0 | 4 | 162 | 160 | 212 | XP_011661670.2 eukaryotic peptide chain release factor subunit 1 [Strongylocentrotus purpuratus] | diamond | 18117 | 90.1 | 0.995560488346282 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 28591534 | 28591534 | PRJNA414036_P_NODE_25007_length_303_cov_2.332090_g23273_i0 | PRJNA414036 | 25007 | 303 | 2.33209 | 7.0662327 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 63.5 | 2.81e-9 | NR | XP_071491041.1 | 105358 | g23273 | i0 | 70 | 5.94059405940594 | 40 | 12 | 39.6 | 0 | 93 | 212 | 270 | 309 | XP_071491041.1 ubiquitin-like-conjugating enzyme ATG3 [Diadema antillarum] | diamond | 1800 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 29254272 | 29254272 | PRJNA414036_P_NODE_72969_length_176_cov_2.815603_g71230_i0 | PRJNA414036 | 72969 | 176 | 2.815603 | 4.95546128 | Peniagone sp. YYH-2 | 3022205 | Echinodermata | other_Eukaryota | 42.4 | 0.0208 | NR | AHH93116.1 | 1430316 | g71230 | i0 | 80 | 1.77272727272727 | 25 | 5 | 42.6 | 0 | 77 | 3 | 212 | 236 | AHH93116.1 NADH dehydrogenase subunit 4 [Peniagone sp. YYH-2013] | diamond | 312 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Elasipodida | Elpidiidae | Peniagone | Peniagone sp. YYH-2013 | |
| 29270938 | 29270938 | PRJNA414036_P_NODE_23409_length_313_cov_8.086331_g21678_i0 | PRJNA414036 | 23409 | 313 | 8.086331 | 25.31021603 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.2 | 5.5e-9 | NR | XP_041463381.1 | 7654 | g21678 | i0 | 65.3 | 4.00638977635783 | 49 | 17 | 47 | 0 | 154 | 8 | 16 | 64 | XP_041463381.1 tubulin alpha-1 chain-like [Lytechinus variegatus] | diamond | 1254 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 29586529 | 29586529 | PRJNA414036_P_NODE_24850_length_304_cov_3.126394_g23118_i0 | PRJNA414036 | 24850 | 304 | 3.126394 | 9.50423776 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 44.7 | 0.016 | NR | XP_033118455.1 | 1529436 | g23118 | i0 | 86.4 | 21.9375 | 22 | 3 | 21.7 | 0 | 74 | 9 | 936 | 957 | XP_033118455.1 DNA ligase 1-like [Anneissia japonica] | diamond | 6669 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 30313879 | 30313879 | PRJNA414036_P_NODE_19112_length_344_cov_12.440129_g17389_i0 | PRJNA414036 | 19112 | 344 | 12.440129 | 42.79404376 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 75.1 | 1.39e-13 | NR | ACF74200.1 | 307972 | g17389 | i0 | 53.4 | 4.45639534883721 | 73 | 34 | 63.7 | 0 | 7 | 225 | 149 | 221 | ACF74200.1 beta-actin, partial [Apostichopus japonicus] | diamond | 1533 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 30328831 | 30328831 | PRJNA414036_P_NODE_36412_length_245_cov_3.876190_g34676_i0 | PRJNA414036 | 36412 | 245 | 3.87619 | 9.4966655 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 43.9 | 0.0155 | NR | XP_071499632.1 | 105358 | g34676 | i0 | 51.9 | 5.95102040816327 | 81 | 39 | 99.2 | 0 | 1 | 243 | 614 | 694 | XP_071499632.1 multifunctional protein CAD-like [Diadema antillarum] | diamond | 1458 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 30376968 | 30376968 | PRJNA414036_P_NODE_80752_length_162_cov_1.220472_g79013_i0 | PRJNA414036 | 80752 | 162 | 1.220472 | 1.97716464 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 55.1 | 5.4e-7 | NR | XP_033639504.1 | 7604 | g79013 | i0 | 75 | 16.2962962962963 | 44 | 11 | 81.5 | 0 | 27 | 158 | 231 | 274 | XP_033639504.1 NADH-ubiquinone oxidoreductase 75 kDa subunit, mitochondrial-like [Asterias rubens] | diamond | 2640 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 30408452 | 30408452 | PRJNA414036_P_NODE_37413_length_241_cov_7.781553_g35674_i0 | PRJNA414036 | 37413 | 241 | 7.781553 | 18.75354273 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 50.1 | 9.93e-5 | NR | XP_041468335.1 | 7654 | g35674 | i0 | 92 | 47.7261410788382 | 25 | 2 | 31.1 | 0 | 163 | 237 | 1711 | 1735 | XP_041468335.1 E3 ubiquitin-protein ligase HECTD1-like isoform X1 [Lytechinus variegatus] | diamond | 11502 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 30692436 | 30692436 | PRJNA414036_P_NODE_27953_length_285_cov_2.492000_g26218_i0 | PRJNA414036 | 27953 | 285 | 2.492 | 7.1022 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 105 | 6.399999999999999e-24 | NR | XP_041470208.1 | 7654 | g26218 | i0 | 62 | 38.7368421052632 | 92 | 35 | 96.8 | 0 | 3 | 278 | 72 | 163 | XP_041470208.1 coatomer subunit delta-like [Lytechinus variegatus] | diamond | 11040 | 106 | 0.990566037735849 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31134522 | 31134522 | PRJNA414036_P_NODE_13655_length_394_cov_4.061281_g12006_i0 | PRJNA414036 | 13655 | 394 | 4.061281 | 16.00144714 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 88.6 | 2.01e-17 | NR | XP_063965664.1 | 7653 | g12006 | i0 | 75.5 | 25.507614213198 | 53 | 13 | 40.4 | 0 | 234 | 76 | 1466 | 1518 | XP_063965664.1 chromodomain-helicase-DNA-binding protein Mi-2 homolog isoform X10 [Lytechinus pictus] | diamond | 10050 | 89 | 0.995505617977528 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 31434324 | 31434324 | PRJNA414036_P_NODE_62356_length_207_cov_3.633721_g60617_i0 | PRJNA414036 | 62356 | 207 | 3.633721 | 7.52180247 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 43.1 | 0.017 | NR | XP_033119145.1 | 1529436 | g60617 | i0 | 43.1 | 2.82608695652174 | 65 | 37 | 94.2 | 0 | 11 | 205 | 367 | 431 | XP_033119145.1 ATP-binding cassette sub-family F member 1-like [Anneissia japonica] | diamond | 585 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 31687370 | 31687370 | PRJNA414036_P_NODE_81037_length_161_cov_3.468254_g79298_i0 | PRJNA414036 | 81037 | 161 | 3.468254 | 5.58388894 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 49.3 | 5.97e-5 | NR | XP_033105685.1 | 1529436 | g79298 | i0 | 75.8 | 9.83850931677019 | 33 | 8 | 61.5 | 0 | 45 | 143 | 1017 | 1049 | XP_033105685.1 NAD(P) transhydrogenase, mitochondrial-like [Anneissia japonica] | diamond | 1584 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 31925448 | 31925448 | PRJNA414036_P_NODE_11717_length_415_cov_1.934211_g10129_i0 | PRJNA414036 | 11717 | 415 | 1.934211 | 8.02697565 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 49.7 | 8.16e-4 | NR | XP_041480017.1 | 7654 | g10129 | i0 | 55.6 | 0.780722891566265 | 54 | 24 | 39 | 0 | 154 | 315 | 343 | 396 | XP_041480017.1 26S proteasome regulatory subunit 7 [Lytechinus variegatus] | diamond | 324 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31940325 | 31940325 | PRJNA414036_P_NODE_77137_length_168_cov_1.466165_g75398_i0 | PRJNA414036 | 77137 | 168 | 1.466165 | 2.4631572 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 48.1 | 1.74e-4 | NR | KAJ8027382.1 | 206669 | g75398 | i0 | 60.5 | 1.32142857142857 | 38 | 15 | 67.9 | 0 | 4 | 117 | 607 | 644 | KAJ8027382.1 WD repeat-containing protein 3 [Holothuria leucospilota] | diamond | 222 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32841682 | 32841682 | PRJNA414036_P_NODE_73640_length_175_cov_1.314286_g71901_i0 | PRJNA414036 | 73640 | 175 | 1.314286 | 2.3000005 | Aspidochirotida | 7682 | Echinodermata | other_Eukaryota | 48.5 | 1.34e-4 | NR | KAJ8043881.1 | 206669 | g71901 | i0 | 63 | 3.15428571428571 | 46 | 17 | 78.9 | 0 | 6 | 143 | 1098 | 1143 | KAJ8043881.1 Protein strawberry notch-like 1 [Holothuria leucospilota] | diamond | 552 | 48.9 | 0.991820040899796 | 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);;