RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA857143" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA857143 · 20 ✖
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
3394336 3394336 PRJNA857143_S_NODE_181343_length_248_cov_0.891429_g180250_i0 PRJNA857143 181343 248 0.891429 2.21074392 Anneissia japonica 1529436 Echinodermata other_Eukaryota 138 7.55e-40   NR XP_033110415.1 1529436 g180250 i0 78 1.98387096774194 82 18 99.2 0 2 247 40 121 XP_033110415.1 40S ribosomal protein S18 [Anneissia japonica] diamond 492 138 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
5947263 5947263 PRJNA857143_S_NODE_36525_length_437_cov_1.670330_g35433_i0 PRJNA857143 36525 437 1.67033 7.2993421 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 65.8 5.42e-6   NTclustered gi|1752336946|ref|XM_030983561.1| 7668 g35433 i0 100 2.64073226544622 35 0 8 0 402 436 7769 7735 PREDICTED: Strongylocentrotus purpuratus E3 ubiquitin-protein ligase HUWE1 (LOC575742), mRNA blastn 1154 65.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
8495759 8495759 PRJNA857143_S_NODE_103587_length_309_cov_1.703390_g102494_i0 PRJNA857143 103587 309 1.70339 5.2634751 Diadema antillarum 105358 Echinodermata other_Eukaryota 54.7 0.008   NTclustered gi|2919412131|ref|XM_071633709.1| 105358 g102494 i0 94.286 0.226537216828479 35 2 11 0 1 35 1580 1614 PREDICTED: Diadema antillarum T-complex protein 1 subunit theta-like (LOC139722418), mRNA blastn 70 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
18695788 18695788 PRJNA857143_S_NODE_82435_length_335_cov_2.381679_g81342_i0 PRJNA857143 82435 335 2.381679 7.97862465 Anneissia japonica 1529436 Echinodermata other_Eukaryota 151 3.389999999999999e-43   NR XP_033118288.1 1529436 g81342 i0 60 6.9134328358209 110 44 98.5 0 5 334 127 236 XP_033118288.1 60S ribosomal protein L7-like isoform X2 [Anneissia japonica] diamond 2316 151 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
26968249 26968249 PRJNA857143_S_NODE_188002_length_245_cov_0.906977_g186909_i0 PRJNA857143 188002 245 0.906977 2.22209365 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 43.1 0.0272   NR XP_033633037.1 7604 g186909 i0 51.5 2.49795918367347 33 16 40.4 0 143 241 411 443 XP_033633037.1 serine/threonine-protein phosphatase 2A 55 kDa regulatory subunit B delta isoform-like isoform X2 [Asterias rubens] diamond 612 43.1 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
27149439 27149439 PRJNA857143_S_NODE_104182_length_308_cov_2.931915_g103089_i0 PRJNA857143 104182 308 2.931915 9.0302982 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 116 1.17e-27   NR KAJ8040946.1 206669 g103089 i0 56.3 0.935064935064935 96 41 92.5 1 2 286 591 686 KAJ8040946.1 Polypyrimidine tract-binding protein 2 [Holothuria leucospilota] diamond 288 116 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
27623952 27623952 PRJNA857143_S_NODE_75044_length_346_cov_2.227106_g73951_i0 PRJNA857143 75044 346 2.227106 7.70578676 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 67.4 2.82e-10   NR KAJ8028063.1 206669 g73951 i0 43.2 1.38728323699422 81 46 70.2 0 245 3 861 941 KAJ8028063.1 THO complex subunit 2 [Holothuria leucospilota] diamond 480 67.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
28602648 28602648 PRJNA857143_S_NODE_193227_length_242_cov_3.201183_g192134_i0 PRJNA857143 193227 242 3.201183 7.74686286 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 47 2.08e-4   NR KAJ8043773.1 206669 g192134 i0 51.1 1.20247933884298 47 23 58.3 0 17 157 53 99 KAJ8043773.1 hypothetical protein HOLleu_11030 [Holothuria leucospilota] diamond 291 47 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
28737029 28737029 PRJNA857143_S_NODE_123867_length_289_cov_1.083333_g122774_i0 PRJNA857143 123867 289 1.083333 3.13083237 Opisthokonta 33154 Echinodermata other_Eukaryota 60.5 3.91e-8   NR XP_041455967.1 7654 g122774 i0 57.8 7.71280276816609 45 19 46.7 0 289 155 436 480 XP_041455967.1 uncharacterized protein LOC121408541 isoform X1 [Lytechinus variegatus] diamond 2229 60.8 0.995065789473684 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
29210795 29210795 PRJNA857143_S_NODE_88469_length_327_cov_1.909449_g87376_i0 PRJNA857143 88469 327 1.909449 6.24389823 Metazoa 33208 Echinodermata other_Eukaryota 73.6 7.72e-13   NR XP_071511396.1 105358 g87376 i0 49.3 2.53211009174312 69 35 63.3 0 61 267 227 295 XP_071511396.1 coatomer subunit epsilon-like [Diadema antillarum] diamond 828 74.3 0.990578734858681 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
29360378 29360378 PRJNA857143_S_NODE_69129_length_356_cov_2.123675_g68036_i0 PRJNA857143 69129 356 2.123675 7.560283 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 152 1.7299999999999994e-42   NR XP_030831828.1 7668 g68036 i0 64 3.74157303370787 111 40 93.5 0 15 347 37 147 XP_030831828.1 tartrate-resistant acid phosphatase type 5 [Strongylocentrotus purpuratus] diamond 1332 152 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
29833920 29833920 PRJNA857143_S_NODE_175471_length_250_cov_1.322034_g174378_i0 PRJNA857143 175471 250 1.322034 3.305085 Diadema antillarum 105358 Echinodermata other_Eukaryota 49.7 1.43e-4   NR XP_071477387.1 105358 g174378 i0 33.7 0.996 83 49 99.6 1 250 2 338 414 XP_071477387.1 uncharacterized protein [Diadema antillarum] diamond 249 49.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
29928885 29928885 PRJNA857143_S_NODE_58531_length_376_cov_4.092409_g57438_i0 PRJNA857143 58531 376 4.092409 15.38745784 Patiria miniata 46514 Echinodermata other_Eukaryota 50.1 4.11e-4   NR XP_038069666.1 46514 g57438 i0 58.8 0.271276595744681 34 12 27.1 1 24 125 409 440 XP_038069666.1 uncharacterized protein MT2135-like [Patiria miniata] diamond 102 50.1 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
30411124 30411124 PRJNA857143_S_NODE_79553_length_339_cov_2.327068_g78460_i0 PRJNA857143 79553 339 2.327068 7.88876052 Opisthokonta 33154 Echinodermata other_Eukaryota 154 8.489999999999997e-43   NR XP_033637737.1 7604 g78460 i0 74 18.929203539823 100 26 88.5 0 3 302 283 382 XP_033637737.1 actin-related protein 2-B isoform X2 [Asterias rubens] diamond 6417 154 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
30560352 30560352 PRJNA857143_S_NODE_62893_length_367_cov_6.255102_g61800_i0 PRJNA857143 62893 367 6.255102 22.95622434 Diadema antillarum 105358 Echinodermata other_Eukaryota 82 1.46e-15   NR XP_071479548.1 105358 g61800 i0 46.2 3.04904632152589 93 47 73.6 1 337 68 261 353 XP_071479548.1 gelsolin-like protein 2 [Diadema antillarum] diamond 1119 82 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
30718495 30718495 PRJNA857143_S_NODE_81194_length_337_cov_1.643939_g80101_i0 PRJNA857143 81194 337 1.643939 5.54007443 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 65.1 1.29e-9   NR KAJ8042247.1 206669 g80101 i0 51.9 0.462908011869436 52 25 46.3 0 83 238 276 327 KAJ8042247.1 E3 ubiquitin-protein ligase MYLIP [Holothuria leucospilota] diamond 156 65.1 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
30813325 30813325 PRJNA857143_S_NODE_72334_length_351_cov_1.122302_g71241_i0 PRJNA857143 72334 351 1.122302 3.93928002 Anneissia japonica 1529436 Echinodermata other_Eukaryota 87.8 1.25e-19   NR XP_033116045.1 1529436 g71241 i0 60.9 0.547008547008547 64 25 54.7 0 349 158 55 118 XP_033116045.1 biogenesis of lysosome-related organelles complex 1 subunit 1-like [Anneissia japonica] diamond 192 87.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
31730090 31730090 PRJNA857143_S_NODE_108937_length_303_cov_2.713043_g107844_i0 PRJNA857143 108937 303 2.713043 8.22052029 Patiria miniata 46514 Echinodermata other_Eukaryota 49.3 3.51e-4   NR XP_038047137.1 46514 g107844 i0 46.3 1.32673267326733 67 34 64.4 2 286 92 330 396 XP_038047137.1 ubiquitin-like modifier-activating enzyme 5 [Patiria miniata] diamond 402 49.3 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
31833091 31833091 PRJNA857143_S_NODE_180297_length_248_cov_1.337143_g179204_i0 PRJNA857143 180297 248 1.337143 3.31611464 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 66.2 2.08e-10   NR XP_022081885.1 133434 g179204 i0 41.8 5.00806451612903 91 42 98 2 243 1 264 353 XP_022081885.1 cAMP and cAMP-inhibited cGMP 3',5'-cyclic phosphodiesterase 10A-like isoform X2 [Acanthaster planci] diamond 1242 66.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
32363200 32363200 PRJNA857143_S_NODE_17339_length_557_cov_20.392562_g16270_i0 PRJNA857143 17339 557 20.392562 113.58657034 Apostichopus japonicus 307972 Echinodermata other_Eukaryota 82 2.17e-16   NR AFU36096.1 307972 g16270 i0 35.7 1.4165170556553 126 77 66.2 3 488 120 1 125 AFU36096.1 profilin [Apostichopus japonicus] diamond 789 82 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Stichopodidae Apostichopus Apostichopus japonicus

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;