RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA681822" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA681822 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
8304855 8304855 PRJNA681822_P_NODE_116927_length_371_cov_1.694631_g115441_i0 PRJNA681822 116927 371 1.694631 6.28708101 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 117 1.01e-27   NR XP_785293.2 7668 g115441 i0 59.8 1.72237196765499 107 40 84.9 2 317 3 413 518 XP_785293.2 protein DD3-3 [Strongylocentrotus purpuratus] diamond 639 117 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
13406027 13406027 PRJNA681822_P_NODE_144831_length_345_cov_3.051471_g143343_i0 PRJNA681822 144831 345 3.051471 10.52757495 Asteroidea 7588 Echinodermata other_Eukaryota 76.3 7.17e-15   NR XP_033647707.1 7604 g143343 i0 58.7 2.19130434782609 63 25 53.9 1 189 4 33 95 XP_033647707.1 peptidyl-prolyl cis-trans isomerase FKBP2-like [Asterias rubens] diamond 756 76.3 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
27018750 27018750 PRJNA681822_P_NODE_427262_length_247_cov_0.885057_g425773_i0 PRJNA681822 427262 247 0.885057 2.18609079 Diadema antillarum 105358 Echinodermata other_Eukaryota 63.2 1.81e-9   NR XP_071482942.1 105358 g425773 i0 67.4 0.558704453441296 46 14 54.7 1 9 143 256 301 XP_071482942.1 2-hydroxyacylsphingosine 1-beta-galactosyltransferase-like [Diadema antillarum] diamond 138 63.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
27271654 27271654 PRJNA681822_P_NODE_386223_length_251_cov_0.865169_g384734_i0 PRJNA681822 386223 251 0.865169 2.17157419 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 165 8.77e-49   NR XP_030840125.1 7668 g384734 i0 94 1.9840637450199201 83 5 99.2 0 249 1 156 238 XP_030840125.1 RNA pseudouridylate synthase domain-containing protein 1-like [Strongylocentrotus purpuratus] diamond 498 165 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
27473008 27473008 PRJNA681822_P_NODE_433883_length_246_cov_0.890173_g432394_i0 PRJNA681822 433883 246 0.890173 2.18982558 Opisthokonta 33154 Echinodermata other_Eukaryota 48.9 2.6e-4   NR XP_071493982.1 105358 g432394 i0 31.6 3.58536585365854 79 49 96.3 1 244 8 78 151 XP_071493982.1 transient receptor potential cation channel subfamily A member 1-like [Diadema antillarum] diamond 882 48.9 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
28345263 28345263 PRJNA681822_P_NODE_318746_length_269_cov_1.571429_g317257_i0 PRJNA681822 318746 269 1.571429 4.22714401 Apostichopus japonicus 307972 Echinodermata other_Eukaryota 76.3 4.21e-14   NR PIK40980.1 307972 g317257 i0 49.4 0.992565055762082 89 44 98.1 1 266 3 27 115 PIK40980.1 cell division cycle 2 [Apostichopus japonicus] diamond 267 76.3 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Stichopodidae Apostichopus Apostichopus japonicus
28356912 28356912 PRJNA681822_P_NODE_196426_length_310_cov_2.544304_g194938_i0 PRJNA681822 196426 310 2.544304 7.8873424 Opisthokonta 33154 Echinodermata other_Eukaryota 121 3.659999999999999e-32   NR XP_038064347.1 46514 g194938 i0 55.9 58.3548387096774 102 42 95.8 1 9 305 1 102 XP_038064347.1 ras-related C3 botulinum toxin substrate 1 [Patiria miniata] diamond 18090 121 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
29545001 29545001 PRJNA681822_P_NODE_489570_length_232_cov_2.811321_g488080_i0 PRJNA681822 489570 232 2.811321 6.52226472 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 81.6 6.48e-16   NR XP_030854825.1 7668 g488080 i0 51.9 1.99137931034483 77 37 99.6 0 231 1 334 410 XP_030854825.1 sodium-independent sulfate anion transporter-like isoform X1 [Strongylocentrotus purpuratus] diamond 462 81.6 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
30019007 30019007 PRJNA681822_P_NODE_445471_length_245_cov_0.895349_g443982_i0 PRJNA681822 445471 245 0.895349 2.19360505 Acanthaster planci 133434 Echinodermata other_Eukaryota 72.8 2.92e-14   NR XP_022107191.1 133434 g443982 i0 59 0.746938775510204 61 25 74.7 0 3 185 48 108 XP_022107191.1 ATP synthase subunit g, mitochondrial-like [Acanthaster planci] diamond 183 72.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
30682119 30682119 PRJNA681822_P_NODE_443873_length_245_cov_0.895349_g442384_i0 PRJNA681822 443873 245 0.895349 2.19360505 Asterias rubens 7604 Echinodermata other_Eukaryota 93.2 5.51e-20   NR XP_033642744.1 7604 g442384 i0 59.2 2.82857142857143 76 31 93.1 0 241 14 315 390 XP_033642744.1 adenylate kinase 8-like [Asterias rubens] diamond 693 93.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
31516144 31516144 PRJNA681822_P_NODE_306596_length_272_cov_1.934673_g305107_i0 PRJNA681822 306596 272 1.934673 5.26231056 Metazoa 33208 Echinodermata other_Eukaryota 72.4 7.58e-13   NR XP_033627124.1 7604 g305107 i0 65.6 1.62132352941176 61 20 67.3 1 2 184 199 258 XP_033627124.1 eukaryotic translation initiation factor 4H-like [Asterias rubens] diamond 441 72.8 0.994505494505495 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
31757161 31757161 PRJNA681822_P_NODE_437397_length_246_cov_0.867052_g435908_i0 PRJNA681822 437397 246 0.867052 2.13294792 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 96.7 3.35e-23   NR KAJ8032673.1 206669 g435908 i0 61.3 0.914634146341463 75 29 91.5 0 226 2 22 96 KAJ8032673.1 hypothetical protein HOLleu_26263 [Holothuria leucospilota] diamond 225 96.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
32010262 32010262 PRJNA681822_P_NODE_213038_length_300_cov_3.176211_g211550_i0 PRJNA681822 213038 300 3.176211 9.528633 Anneissia japonica 1529436 Echinodermata other_Eukaryota 89.7 2.31e-18   NR XP_033096755.1 1529436 g211550 i0 60.8 133.27 97 28 97 1 291 1 177 263 XP_033096755.1 dual specificity tyrosine-phosphorylation-regulated kinase 1A-like isoform X2 [Anneissia japonica] diamond 39981 89.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
32041940 32041940 PRJNA681822_P_NODE_453458_length_244_cov_0.900585_g451968_i0 PRJNA681822 453458 244 0.900585 2.1974274 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 91.7 2.32e-19   NR XP_011681859.2 7668 g451968 i0 64.3 1.0327868852459 84 27 99.6 1 1 243 489 572 XP_011681859.2 pollen-specific leucine-rich repeat extensin-like protein 1 isoform X2 [Strongylocentrotus purpuratus] diamond 252 91.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
32105149 32105149 PRJNA681822_P_NODE_443018_length_245_cov_0.895349_g441529_i0 PRJNA681822 443018 245 0.895349 2.19360505 Anneissia japonica 1529436 Echinodermata other_Eukaryota 70.1 1.84e-12   NR XP_033112195.1 1529436 g441529 i0 50.7 2.69387755102041 75 34 91.8 1 19 243 1 72 XP_033112195.1 glutathione S-transferase-like [Anneissia japonica] diamond 660 70.1 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica

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