contig_metadata
26 rows where bioproject = "PRJEB17675", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3847830 | 3847830 | PRJEB17675_P_NODE_12464_length_238_cov_1.157635_g12160_i0 | PRJEB17675 | 12464 | 238 | 1.157635 | 2.7551713 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 182 | 2.61e-41 | NTclustered | gi|2707408381|ref|XM_054893204.2| | 7653 | g12160 | i0 | 90.58 | 16.1302521008403 | 138 | 12 | 58 | 1 | 102 | 238 | 605 | 468 | PREDICTED: Lytechinus pictus dynein light chain 2, cytoplasmic-like (LOC129254696), mRNA | blastn | 3839 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 5124102 | 5124102 | PRJEB17675_P_NODE_5665_length_400_cov_2.049315_g5366_i0 | PRJEB17675 | 5665 | 400 | 2.049315 | 8.19726 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52.8 | 0.038 | NTclustered | gi|1826614684|ref|XM_033244415.1| | 1529436 | g5366 | i0 | 100 | 0.14 | 28 | 0 | 7 | 0 | 114 | 141 | 700 | 727 | PREDICTED: Anneissia japonica uncharacterized LOC117103791 (LOC117103791), transcript variant X1, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 8948726 | 8948726 | PRJEB17675_P_NODE_7588_length_334_cov_1.605351_g7284_i0 | PRJEB17675 | 7588 | 334 | 1.605351 | 5.36187234 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 150 | 1.09e-31 | NTclustered | gi|2037982232|ref|XM_041603685.1| | 7654 | g7284 | i0 | 80.612 | 3.53892215568862 | 196 | 36 | 58 | 2 | 140 | 334 | 180 | 374 | PREDICTED: Lytechinus variegatus rho-related GTP-binding protein RhoA-B-like (LOC121411150), transcript variant X1, mRNA | blastn | 1182 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 12775218 | 12775218 | PRJEB17675_P_NODE_14771_length_212_cov_1.124294_g14467_i0 | PRJEB17675 | 14771 | 212 | 1.124294 | 2.38350328 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 90.5 | 1.49e-19 | NR | XP_033639519.1 | 7604 | g14467 | i0 | 58.8 | 1.92452830188679 | 68 | 28 | 96.2 | 0 | 6 | 209 | 234 | 301 | XP_033639519.1 Bardet-Biedl syndrome 5 protein homolog [Asterias rubens] | diamond | 408 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 14049797 | 14049797 | PRJEB17675_P_NODE_21232_length_167_cov_1.515152_g20928_i0 | PRJEB17675 | 21232 | 167 | 1.515152 | 2.53030384 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 63.9 | 6.47e-6 | NTclustered | gi|1752373891|ref|XM_030990776.1| | 7668 | g20928 | i0 | 97.297 | 2.38922155688623 | 37 | 1 | 22 | 0 | 131 | 167 | 1847 | 1883 | PREDICTED: Strongylocentrotus purpuratus 60 kDa heat shock protein, mitochondrial (LOC590510), mRNA | blastn | 399 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 17873241 | 17873241 | PRJEB17675_P_NODE_12235_length_240_cov_3.039024_g11931_i0 | PRJEB17675 | 12235 | 240 | 3.039024 | 7.2936576 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 104 | 5.88e-18 | NTclustered | gi|1752399769|ref|XM_030972759.1| | 7668 | g11931 | i0 | 87.097 | 3.44583333333333 | 93 | 10 | 38 | 2 | 1 | 92 | 340 | 431 | PREDICTED: Strongylocentrotus purpuratus 40S ribosomal protein S23 (LOC590530), mRNA | blastn | 827 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 22662792 | 22662792 | PRJEB17675_P_NODE_22218_length_163_cov_0.859375_g21914_i0 | PRJEB17675 | 22218 | 163 | 0.859375 | 1.40078125 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.001 | NTclustered | gi|1752349763|ref|XM_011681162.2| | 7668 | g21914 | i0 | 100 | 1.09815950920245 | 30 | 0 | 18 | 0 | 25 | 54 | 114 | 143 | PREDICTED: Strongylocentrotus purpuratus glycoprotein 3-alpha-L-fucosyltransferase A-like (LOC589688), mRNA | blastn | 179 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 25211916 | 25211916 | PRJEB17675_P_NODE_2260_length_653_cov_2.199029_g2020_i0 | PRJEB17675 | 2260 | 653 | 2.199029 | 14.35965937 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 128 | 5.06e-30 | NR | KAJ8025971.1 | 206669 | g2020 | i0 | 37.9 | 4.91117917304747 | 214 | 133 | 98.3 | 0 | 652 | 11 | 641 | 854 | KAJ8025971.1 Major vault protein [Holothuria leucospilota] | diamond | 3207 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 27096311 | 27096311 | PRJEB17675_P_NODE_23882_length_156_cov_1.132231_g23578_i0 | PRJEB17675 | 23882 | 156 | 1.132231 | 1.76628036 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 47.8 | 1.9e-4 | NR | XP_033104149.1 | 1529436 | g23578 | i0 | 63.9 | 1.25 | 36 | 13 | 69.2 | 0 | 47 | 154 | 1 | 36 | XP_033104149.1 beta-arrestin-1-like isoform X1 [Anneissia japonica] | diamond | 195 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27222588 | 27222588 | PRJEB17675_P_NODE_22783_length_160_cov_1.504000_g22479_i0 | PRJEB17675 | 22783 | 160 | 1.504 | 2.4064 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 52.8 | 3.4e-6 | NR | KAJ8029172.1 | 206669 | g22479 | i0 | 39.1 | 0.8625 | 46 | 27 | 86.3 | 1 | 140 | 3 | 920 | 964 | KAJ8029172.1 Fibropellin-1 [Holothuria leucospilota] | diamond | 138 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 27317808 | 27317808 | PRJEB17675_P_NODE_7663_length_332_cov_1.592593_g7359_i0 | PRJEB17675 | 7663 | 332 | 1.592593 | 5.28740876 | Pseudocnus echinatus | 2592315 | Echinodermata | other_Eukaryota | 56.6 | 1.35e-6 | NR | BAK19472.1 | 2592315 | g7359 | i0 | 46.2 | 0.587349397590361 | 65 | 35 | 58.7 | 0 | 9 | 203 | 336 | 400 | BAK19472.1 hemolytic lectin-S1 [Pseudocnus echinatus] | diamond | 195 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Dendrochirotida | Cucumariidae | Pseudocnus | Pseudocnus echinatus | |
| 27444304 | 27444304 | PRJEB17675_P_NODE_11643_length_249_cov_1.635514_g11339_i0 | PRJEB17675 | 11643 | 249 | 1.635514 | 4.07242986 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 84.3 | 5.67e-17 | NR | XP_071476725.1 | 105358 | g11339 | i0 | 50.6 | 1 | 83 | 41 | 100 | 0 | 1 | 249 | 92 | 174 | XP_071476725.1 ferroptosis suppressor protein 1-like [Diadema antillarum] | diamond | 249 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27602069 | 27602069 | PRJEB17675_P_NODE_6424_length_371_cov_1.904762_g6121_i0 | PRJEB17675 | 6424 | 371 | 1.904762 | 7.06666702 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 119 | 2.35e-30 | NR | XP_033118288.1 | 1529436 | g6121 | i0 | 58.4 | 21.177897574124 | 113 | 47 | 91.4 | 0 | 28 | 366 | 9 | 121 | XP_033118288.1 60S ribosomal protein L7-like isoform X2 [Anneissia japonica] | diamond | 7857 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27696933 | 27696933 | PRJEB17675_P_NODE_21004_length_168_cov_1.804511_g20700_i0 | PRJEB17675 | 21004 | 168 | 1.804511 | 3.03157848 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 68.6 | 4.1e-12 | NR | XP_030842684.1 | 7668 | g20700 | i0 | 58.2 | 0.982142857142857 | 55 | 23 | 98.2 | 0 | 3 | 167 | 98 | 152 | XP_030842684.1 proteasome subunit beta type-6 [Strongylocentrotus purpuratus] | diamond | 165 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 27917468 | 27917468 | PRJEB17675_P_NODE_10285_length_271_cov_2.021186_g9981_i0 | PRJEB17675 | 10285 | 271 | 2.021186 | 5.47741406 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 95.5 | 8.64e-21 | NR | XP_033107834.1 | 1529436 | g9981 | i0 | 57.7 | 4.36162361623616 | 71 | 30 | 78.6 | 0 | 271 | 59 | 291 | 361 | XP_033107834.1 gastric triacylglycerol lipase-like [Anneissia japonica] | diamond | 1182 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 28037574 | 28037574 | PRJEB17675_P_NODE_14865_length_211_cov_1.363636_g14561_i0 | PRJEB17675 | 14865 | 211 | 1.363636 | 2.87727196 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 73.2 | 5.64e-14 | NR | XP_038069264.1 | 46514 | g14561 | i0 | 51.5 | 2.68720379146919 | 68 | 31 | 95.3 | 2 | 5 | 205 | 70 | 136 | XP_038069264.1 uncharacterized protein LOC119738440 [Patiria miniata] | diamond | 567 | 73.6 | 0.994565217391304 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 28795020 | 28795020 | PRJEB17675_P_NODE_19767_length_175_cov_1.542857_g19463_i0 | PRJEB17675 | 19767 | 175 | 1.542857 | 2.69999975 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 59.7 | 1.03e-8 | NR | XP_063951657.1 | 7653 | g19463 | i0 | 65.7 | 1.2 | 35 | 12 | 60 | 0 | 164 | 60 | 119 | 153 | XP_063951657.1 fibropellin-3-like [Lytechinus pictus] | diamond | 210 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 28889874 | 28889874 | PRJEB17675_P_NODE_20168_length_173_cov_1.159420_g19864_i0 | PRJEB17675 | 20168 | 173 | 1.15942 | 2.0057966 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 107 | 2.99e-26 | NR | XP_041458658.1 | 7654 | g19864 | i0 | 82.5 | 11.8612716763006 | 57 | 10 | 98.8 | 0 | 1 | 171 | 269 | 325 | XP_041458658.1 procathepsin L-like [Lytechinus variegatus] | diamond | 2052 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 29401585 | 29401585 | PRJEB17675_P_NODE_23289_length_158_cov_1.300813_g22985_i0 | PRJEB17675 | 23289 | 158 | 1.300813 | 2.05528454 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52.4 | 4.61e-6 | NR | XP_033097306.1 | 1529436 | g22985 | i0 | 51.2 | 0.816455696202532 | 43 | 21 | 81.6 | 0 | 153 | 25 | 151 | 193 | XP_033097306.1 insulin-like growth factor-binding protein complex acid labile subunit [Anneissia japonica] | diamond | 129 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 29432852 | 29432852 | PRJEB17675_P_NODE_7650_length_332_cov_2.670034_g7346_i0 | PRJEB17675 | 7650 | 332 | 2.670034 | 8.86451288 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 54.7 | 4.94e-6 | NR | KAJ8045453.1 | 206669 | g7346 | i0 | 30.9 | 2.60240963855422 | 81 | 55 | 73.2 | 1 | 328 | 86 | 176 | 255 | KAJ8045453.1 Ribonuclease Oy [Holothuria leucospilota] | diamond | 864 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30001721 | 30001721 | PRJEB17675_P_NODE_24251_length_154_cov_1.680672_g23947_i0 | PRJEB17675 | 24251 | 154 | 1.680672 | 2.58823488 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 48.9 | 7.17e-5 | NR | KAJ8020411.1 | 206669 | g23947 | i0 | 48.6 | 0.681818181818182 | 35 | 18 | 68.2 | 0 | 6 | 110 | 824 | 858 | KAJ8020411.1 Neurogenic locus notch-like protein 1 [Holothuria leucospilota] | diamond | 105 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31961298 | 31961298 | PRJEB17675_P_NODE_7078_length_349_cov_2.149682_g6774_i0 | PRJEB17675 | 7078 | 349 | 2.149682 | 7.50239018 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 48.1 | 0.00162 | NR | XP_063956759.1 | 7653 | g6774 | i0 | 63.6 | 0.567335243553009 | 33 | 12 | 28.4 | 0 | 29 | 127 | 402 | 434 | XP_063956759.1 uncharacterized protein LOC135154486 [Lytechinus pictus] | diamond | 198 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 32151246 | 32151246 | PRJEB17675_P_NODE_15798_length_202_cov_2.431138_g15494_i0 | PRJEB17675 | 15798 | 202 | 2.431138 | 4.91089876 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 76.6 | 1.99e-15 | NR | PIK59143.1 | 307972 | g15494 | i0 | 72.7 | 6.38613861386139 | 44 | 12 | 65.3 | 0 | 142 | 11 | 17 | 60 | PIK59143.1 putative tubulin alpha-1C chain-like [Apostichopus japonicus] | diamond | 1290 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 32239928 | 32239928 | PRJEB17675_P_NODE_6878_length_356_cov_1.619938_g6575_i0 | PRJEB17675 | 6878 | 356 | 1.619938 | 5.76697928 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 120 | 7.58e-29 | NR | NP_001116989.1 | 7668 | g6575 | i0 | 59.2 | 7.78651685393258 | 98 | 40 | 82.6 | 0 | 356 | 63 | 760 | 857 | NP_001116989.1 major vault protein [Strongylocentrotus purpuratus] | diamond | 2772 | 121 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 32556400 | 32556400 | PRJEB17675_P_NODE_13999_length_220_cov_1.513514_g13695_i0 | PRJEB17675 | 13999 | 220 | 1.513514 | 3.3297308 | root | 1 | Root_unresolved | Root_unresolved | 97.1 | 1.0699999999999997e-23 | NR | KAJ8033962.1 | 206669 | g13695 | i0 | 58.9 | 8.95909090909091 | 73 | 30 | 99.5 | 0 | 1 | 219 | 55 | 127 | KAJ8033962.1 40S ribosomal protein S12 [Holothuria leucospilota] | diamond | 1971 | 97.4 | 0.996919917864476 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32562786 | 32562786 | PRJEB17675_P_NODE_7079_length_349_cov_2.038217_g6775_i0 | PRJEB17675 | 7079 | 349 | 2.038217 | 7.11337733 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 139 | 6.28e-38 | NR | KAJ8042358.1 | 206669 | g6775 | i0 | 51.7 | 0.997134670487106 | 116 | 54 | 99.7 | 1 | 349 | 2 | 21 | 134 | KAJ8042358.1 Carbonic anhydrase 2 [Holothuria leucospilota] | diamond | 348 | 139 | 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);;