contig_metadata
28 rows where bioproject = "PRJNA924320", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11102670 | 11102670 | PRJNA924320_S_NODE_23469_length_218_cov_1.337278_g23327_i0 | PRJNA924320 | 23469 | 218 | 1.337278 | 2.91526604 | root | 1 | Root_unresolved | Root_unresolved | 103 | 4.7499999999999994e-24 | NR | XP_784944.3 | 7668 | g23327 | i0 | 73.6 | 29.6834862385321 | 72 | 19 | 99.1 | 0 | 2 | 217 | 293 | 364 | XP_784944.3 uncharacterized protein LOC579754 [Strongylocentrotus purpuratus] | diamond | 6471 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 15280193 | 15280193 | PRJNA924320_S_NODE_46172_length_167_cov_0.864407_g46030_i0 | PRJNA924320 | 46172 | 167 | 0.864407 | 1.44355969 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 92.4 | 2.65e-20 | NR | XP_054756181.1 | 7653 | g46030 | i0 | 78.2 | 96.8263473053892 | 55 | 12 | 98.8 | 0 | 165 | 1 | 170 | 224 | XP_054756181.1 actin-related protein 3 [Lytechinus pictus] | diamond | 16170 | 93.2 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 18750741 | 18750741 | PRJNA924320_S_NODE_23995_length_216_cov_1.826347_g23853_i0 | PRJNA924320 | 23995 | 216 | 1.826347 | 3.94490952 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 92.4 | 1.52e-20 | NR | XP_033105668.1 | 1529436 | g23853 | i0 | 67.7 | 1.76388888888889 | 65 | 21 | 90.3 | 0 | 1 | 195 | 194 | 258 | XP_033105668.1 60S ribosomal protein L5-like [Anneissia japonica] | diamond | 381 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 26992789 | 26992789 | PRJNA924320_S_NODE_14242_length_266_cov_1.405530_g14100_i0 | PRJNA924320 | 14242 | 266 | 1.40553 | 3.7387098 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 87 | 1.11e-17 | NR | XP_038068421.1 | 46514 | g14100 | i0 | 45.3 | 4.84962406015038 | 86 | 47 | 97 | 0 | 258 | 1 | 307 | 392 | XP_038068421.1 COP9 signalosome complex subunit 1-like isoform X2 [Patiria miniata] | diamond | 1290 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27119223 | 27119223 | PRJNA924320_S_NODE_15442_length_257_cov_1.466346_g15300_i0 | PRJNA924320 | 15442 | 257 | 1.466346 | 3.76850922 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 75.9 | 9.27e-14 | NR | XP_071501112.1 | 105358 | g15300 | i0 | 46.8 | 3.57198443579767 | 77 | 38 | 86.4 | 1 | 2 | 223 | 83 | 159 | XP_071501112.1 lysosomal protective protein-like [Diadema antillarum] | diamond | 918 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27119228 | 27119228 | PRJNA924320_S_NODE_20522_length_229_cov_1.844444_g20380_i0 | PRJNA924320 | 20522 | 229 | 1.844444 | 4.22377676 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 52 | 1.68e-5 | NR | XP_041452728.1 | 7654 | g20380 | i0 | 38.8 | 2.05676855895197 | 80 | 44 | 98.3 | 2 | 3 | 227 | 980 | 1059 | XP_041452728.1 phospholipase D1-like [Lytechinus variegatus] | diamond | 471 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 27309350 | 27309350 | PRJNA924320_S_NODE_20763_length_228_cov_1.994413_g20621_i0 | PRJNA924320 | 20763 | 228 | 1.994413 | 4.54726164 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 69.7 | 9.85e-12 | NR | XP_785086.3 | 7668 | g20621 | i0 | 54.8 | 1.61842105263158 | 62 | 27 | 80.3 | 1 | 189 | 7 | 35 | 96 | XP_785086.3 choline transporter-like protein 4 [Strongylocentrotus purpuratus] | diamond | 369 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 27340920 | 27340920 | PRJNA924320_S_NODE_26143_length_210_cov_0.931677_g26001_i0 | PRJNA924320 | 26143 | 210 | 0.931677 | 1.9565217 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 48.9 | 1.6e-4 | NR | XP_038076039.1 | 46514 | g26001 | i0 | 47.1 | 0.728571428571429 | 51 | 27 | 72.9 | 0 | 154 | 2 | 73 | 123 | XP_038076039.1 dynein intermediate chain 2, ciliary-like isoform X6 [Patiria miniata] | diamond | 153 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27940814 | 27940814 | PRJNA924320_S_NODE_42925_length_172_cov_1.243902_g42783_i0 | PRJNA924320 | 42925 | 172 | 1.243902 | 2.13951144 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 45.4 | 0.00158 | NR | XP_071501328.1 | 105358 | g42783 | i0 | 37.5 | 2.72093023255814 | 56 | 35 | 97.7 | 0 | 3 | 170 | 938 | 993 | XP_071501328.1 ATP-binding cassette sub-family C member 5-like [Diadema antillarum] | diamond | 468 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 28161898 | 28161898 | PRJNA924320_S_NODE_30765_length_197_cov_1.033784_g30623_i0 | PRJNA924320 | 30765 | 197 | 1.033784 | 2.03655448 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 68.9 | 3.1e-12 | NR | XP_022081077.1 | 133434 | g30623 | i0 | 56.1 | 1.73604060913706 | 57 | 25 | 86.8 | 0 | 191 | 21 | 55 | 111 | XP_022081077.1 ras-related protein Rab-7L1-like isoform X2 [Acanthaster planci] | diamond | 342 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 28642748 | 28642748 | PRJNA924320_S_NODE_24267_length_215_cov_2.265060_g24125_i0 | PRJNA924320 | 24267 | 215 | 2.26506 | 4.869879 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 43.1 | 0.00558 | NR | XP_033627483.1 | 7604 | g24125 | i0 | 46.8 | 2.09302325581395 | 47 | 25 | 65.6 | 0 | 214 | 74 | 20 | 66 | XP_033627483.1 60S acidic ribosomal protein P2-like [Asterias rubens] | diamond | 450 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 28800230 | 28800230 | PRJNA924320_S_NODE_35327_length_187_cov_0.949275_g35185_i0 | PRJNA924320 | 35327 | 187 | 0.949275 | 1.77514425 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 63.5 | 7.83e-10 | NR | XP_038065785.1 | 46514 | g35185 | i0 | 49.2 | 6.81818181818182 | 61 | 31 | 97.9 | 0 | 3 | 185 | 492 | 552 | XP_038065785.1 uncharacterized protein LOC119735910 [Patiria miniata] | diamond | 1275 | 63.9 | 0.993740219092332 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 29077532 | 29077532 | PRJNA924320_S_NODE_46228_length_167_cov_0.864407_g46086_i0 | PRJNA924320 | 46228 | 167 | 0.864407 | 1.44355969 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 47 | 4.25e-4 | NR | XP_030842920.1 | 7668 | g46086 | i0 | 45.8 | 1.72455089820359 | 48 | 23 | 86.2 | 1 | 167 | 24 | 235 | 279 | XP_030842920.1 arachidonate 5-lipoxygenase isoform X2 [Strongylocentrotus purpuratus] | diamond | 288 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 29211103 | 29211103 | PRJNA924320_S_NODE_22649_length_221_cov_1.267442_g22507_i0 | PRJNA924320 | 22649 | 221 | 1.267442 | 2.80104682 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 63.9 | 9.29e-10 | NR | XP_033116296.1 | 1529436 | g22507 | i0 | 42.3 | 6.40723981900453 | 71 | 34 | 86.9 | 1 | 17 | 208 | 293 | 363 | XP_033116296.1 2-(3-amino-3-carboxypropyl)histidine synthase subunit 2-like [Anneissia japonica] | diamond | 1416 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 29211107 | 29211107 | PRJNA924320_S_NODE_35489_length_186_cov_1.759124_g35347_i0 | PRJNA924320 | 35489 | 186 | 1.759124 | 3.27197064 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 53.5 | 2.73e-6 | NR | PIK56104.1 | 307972 | g35347 | i0 | 42.4 | 5.80645161290323 | 59 | 34 | 95.2 | 0 | 186 | 10 | 69 | 127 | PIK56104.1 putative NADPH-dependent methylglyoxal reductase GRP2 [Apostichopus japonicus] | diamond | 1080 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 29361586 | 29361586 | PRJNA924320_S_NODE_19629_length_233_cov_1.940217_g19487_i0 | PRJNA924320 | 19629 | 233 | 1.940217 | 4.52070561 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 46.6 | 1.56e-4 | NR | XP_030851458.1 | 7668 | g19487 | i0 | 37.7 | 2.25321888412017 | 61 | 37 | 78.5 | 1 | 18 | 200 | 17 | 76 | XP_030851458.1 dynein light chain 1, cytoplasmic-like [Strongylocentrotus purpuratus] | diamond | 525 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 29771826 | 29771826 | PRJNA924320_S_NODE_31551_length_195_cov_1.116438_g31409_i0 | PRJNA924320 | 31551 | 195 | 1.116438 | 2.1770541 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 50.4 | 3.67e-5 | NR | XP_022099072.1 | 133434 | g31409 | i0 | 30.4 | 0.861538461538462 | 56 | 39 | 86.2 | 0 | 3 | 170 | 257 | 312 | XP_022099072.1 LOW QUALITY PROTEIN: E3 ubiquitin-protein ligase RNF14-like [Acanthaster planci] | diamond | 168 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 29771836 | 29771836 | PRJNA924320_S_NODE_49571_length_165_cov_0.922414_g49429_i0 | PRJNA924320 | 49571 | 165 | 0.922414 | 1.5219831 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 58.9 | 2.43e-8 | NR | XP_033629045.1 | 7604 | g49429 | i0 | 46.3 | 4.83636363636364 | 54 | 29 | 98.2 | 0 | 164 | 3 | 200 | 253 | XP_033629045.1 proliferation-associated protein 2G4-like [Asterias rubens] | diamond | 798 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 30568775 | 30568775 | PRJNA924320_S_NODE_29453_length_200_cov_1.350993_g29311_i0 | PRJNA924320 | 29453 | 200 | 1.350993 | 2.701986 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 84.7 | 3.39e-17 | NR | XP_071488020.1 | 105358 | g29311 | i0 | 57.6 | 5.895 | 66 | 28 | 99 | 0 | 199 | 2 | 519 | 584 | XP_071488020.1 long-chain-fatty-acid--CoA ligase 6-like [Diadema antillarum] | diamond | 1179 | 85.5 | 0.990643274853801 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 30632094 | 30632094 | PRJNA924320_S_NODE_8633_length_331_cov_1.510638_g8491_i0 | PRJNA924320 | 8633 | 331 | 1.510638 | 5.00021178 | Valvatida | 41166 | Echinodermata | other_Eukaryota | 50.4 | 1.91e-4 | NR | XP_038066723.1 | 46514 | g8491 | i0 | 48.8 | 0.788519637462236 | 43 | 21 | 38.1 | 1 | 331 | 206 | 347 | 389 | XP_038066723.1 uncharacterized protein LOC119736785 [Patiria miniata] | diamond | 261 | 50.8 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 30877732 | 30877732 | PRJNA924320_S_NODE_10494_length_303_cov_2.610236_g10352_i0 | PRJNA924320 | 10494 | 303 | 2.610236 | 7.90901508 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 53.9 | 7.45e-6 | NR | XP_041455413.1 | 7654 | g10352 | i0 | 48 | 1.04950495049505 | 50 | 26 | 49.5 | 0 | 259 | 110 | 93 | 142 | XP_041455413.1 aquaporin AQPAe.a-like [Lytechinus variegatus] | diamond | 318 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 30979999 | 30979999 | PRJNA924320_S_NODE_49254_length_165_cov_1.318966_g49112_i0 | PRJNA924320 | 49254 | 165 | 1.318966 | 2.1762939 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 47 | 4.06e-4 | NR | XP_033642831.1 | 7604 | g49112 | i0 | 39.1 | 1.58181818181818 | 46 | 28 | 83.6 | 0 | 24 | 161 | 417 | 462 | XP_033642831.1 uncharacterized protein LOC117302941, partial [Asterias rubens] | diamond | 261 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 31169159 | 31169159 | PRJNA924320_S_NODE_16815_length_248_cov_2.050251_g16673_i0 | PRJNA924320 | 16815 | 248 | 2.050251 | 5.08462248 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 55.8 | 9.64e-7 | NR | PIK34828.1 | 307972 | g16673 | i0 | 31.9 | 5.03225806451613 | 72 | 49 | 87.1 | 0 | 246 | 31 | 27 | 98 | PIK34828.1 Zonadhesin [Apostichopus japonicus] | diamond | 1248 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 31288490 | 31288490 | PRJNA924320_S_NODE_23915_length_217_cov_0.863095_g23773_i0 | PRJNA924320 | 23915 | 217 | 0.863095 | 1.87291615 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 58.5 | 6.91e-8 | NR | XP_022084254.1 | 133434 | g23773 | i0 | 40.9 | 4.56221198156682 | 66 | 39 | 91.2 | 0 | 215 | 18 | 549 | 614 | XP_022084254.1 choline transporter-like protein 2 isoform X2 [Acanthaster planci] | diamond | 990 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 31864999 | 31864999 | PRJNA924320_S_NODE_47837_length_166_cov_1.008547_g47695_i0 | PRJNA924320 | 47837 | 166 | 1.008547 | 1.67418802 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 79 | 2.27e-15 | NR | XP_033626758.1 | 7604 | g47695 | i0 | 66 | 11.0060240963855 | 50 | 17 | 90.4 | 0 | 165 | 16 | 397 | 446 | XP_033626758.1 glucose-6-phosphate isomerase-like [Asterias rubens] | diamond | 1827 | 79.7 | 0.991217063989962 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 31991685 | 31991685 | PRJNA924320_S_NODE_27858_length_205_cov_0.820513_g27716_i0 | PRJNA924320 | 27858 | 205 | 0.820513 | 1.68205165 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 102 | 1.1799999999999999e-23 | NR | XP_041460907.1 | 7654 | g27716 | i0 | 71.6 | 229.434146341463 | 67 | 19 | 98 | 0 | 203 | 3 | 69 | 135 | XP_041460907.1 tubulin beta chain-like [Lytechinus variegatus] | diamond | 47034 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 32079373 | 32079373 | PRJNA924320_S_NODE_13418_length_272_cov_2.515695_g13276_i0 | PRJNA924320 | 13418 | 272 | 2.515695 | 6.8426904 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 43.1 | 0.038 | NR | XP_038055681.1 | 46514 | g13276 | i0 | 28.6 | 0.926470588235294 | 84 | 52 | 83.8 | 2 | 245 | 18 | 436 | 519 | XP_038055681.1 spartin-like [Patiria miniata] | diamond | 252 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 32459286 | 32459286 | PRJNA924320_S_NODE_6699_length_370_cov_1.352025_g6557_i0 | PRJNA924320 | 6699 | 370 | 1.352025 | 5.0024925 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 75.5 | 2.84e-13 | NR | XP_033100570.1 | 1529436 | g6557 | i0 | 33.3 | 0.972972972972973 | 120 | 79 | 97.3 | 1 | 362 | 3 | 100 | 218 | XP_033100570.1 poly [ADP-ribose] polymerase tankyrase-like [Anneissia japonica] | diamond | 360 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica |
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);;