RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA557895" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA557895 · 20 ✖

analysis 1

  • diamond · 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
9464923 9464923 PRJNA557895_P_NODE_36448_length_162_cov_1.805310_g36093_i0 PRJNA557895 36448 162 1.80531 2.9246022 Metazoa 33208 Echinodermata other_Eukaryota 73.2 2.25e-13   NR XP_033630111.1 7604 g36093 i0 64.2 6.87037037037037 53 19 98.1 0 160 2 258 310 XP_033630111.1 3-phosphoinositide-dependent protein kinase 1-like isoform X1 [Asterias rubens] diamond 1113 73.9 0.990527740189445 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
13289883 13289883 PRJNA557895_P_NODE_16691_length_225_cov_1.159091_g16336_i0 PRJNA557895 16691 225 1.159091 2.60795475 Metazoa 33208 Echinodermata other_Eukaryota 128 2.76e-33   NR XP_038072492.1 46514 g16336 i0 87.8 147.906666666667 74 9 98.7 0 223 2 123 196 XP_038072492.1 actin-related protein 3 [Patiria miniata] diamond 33279 129 0.992248062015504 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
20938272 20938272 PRJNA557895_P_NODE_32257_length_165_cov_1.758621_g31902_i0 PRJNA557895 32257 165 1.758621 2.90172465 Metazoa 33208 Echinodermata other_Eukaryota 87.8 1.07e-18   NR XP_033637737.1 7604 g31902 i0 75.5 5.52727272727273 53 13 96.4 0 2 160 342 394 XP_033637737.1 actin-related protein 2-B isoform X2 [Asterias rubens] diamond 912 88.6 0.99097065462754 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
27047278 27047278 PRJNA557895_P_NODE_33102_length_165_cov_0.879310_g32747_i0 PRJNA557895 33102 165 0.87931 1.4508615 Asterias rubens 7604 Echinodermata other_Eukaryota 45.4 0.00151   NR XP_033636750.1 7604 g32747 i0 55.3 0.690909090909091 38 17 69.1 0 22 135 713 750 XP_033636750.1 uncharacterized protein LOC117297709 [Asterias rubens] diamond 114 45.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
27205042 27205042 PRJNA557895_P_NODE_15942_length_230_cov_1.408840_g15587_i0 PRJNA557895 15942 230 1.40884 3.240332 Anneissia japonica 1529436 Echinodermata other_Eukaryota 87.4 5.86e-18   NR XP_033115395.1 1529436 g15587 i0 64.1 6.95217391304348 64 23 83.5 0 228 37 470 533 XP_033115395.1 protein FAN-like [Anneissia japonica] diamond 1599 87.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
27268475 27268475 PRJNA557895_P_NODE_7823_length_320_cov_1.125461_g7468_i0 PRJNA557895 7823 320 1.125461 3.6014752 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 44.7 0.0171   NR KAJ8022556.1 206669 g7468 i0 34.3 1.3125 70 45 65.6 1 320 111 191 259 KAJ8022556.1 hypothetical protein HOLleu_37488 [Holothuria leucospilota] diamond 420 44.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
27647699 27647699 PRJNA557895_P_NODE_6624_length_347_cov_2.362416_g6269_i0 PRJNA557895 6624 347 2.362416 8.19758352 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 52 3.23e-5   NR NP_001229596.1 7668 g6269 i0 64.3 4.86743515850144 42 11 32.9 1 3 116 153 194 NP_001229596.1 ras-related C3 botulinum toxin substrate 1 (rho family, small GTP binding protein Rac1)-like [Strongylocentrotus purpuratus] diamond 1689 52 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
28500157 28500157 PRJNA557895_P_NODE_29787_length_167_cov_1.059322_g29432_i0 PRJNA557895 29787 167 1.059322 1.7690677400000001 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 79 2.28e-15   NR KAJ8032563.1 206669 g29432 i0 58.2 3.93413173652695 55 23 98.8 0 2 166 875 929 KAJ8032563.1 Pre-mRNA-processing factor 6 [Holothuria leucospilota] diamond 657 79 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
28847139 28847139 PRJNA557895_P_NODE_11068_length_276_cov_1.348018_g10713_i0 PRJNA557895 11068 276 1.348018 3.72052968 Anneissia japonica 1529436 Echinodermata other_Eukaryota 99.4 7.27e-22   NR XP_033115330.1 1529436 g10713 i0 52.2 1 92 44 100 0 276 1 626 717 XP_033115330.1 alanine--tRNA ligase, cytoplasmic-like isoform X1 [Anneissia japonica] diamond 276 99.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
29114105 29114105 PRJNA557895_P_NODE_23708_length_190_cov_1.446809_g23353_i0 PRJNA557895 23708 190 1.446809 2.7489371 Opisthokonta 33154 Echinodermata other_Eukaryota 92.8 1.86e-21   NR XP_038057560.1 46514 g23353 i0 63.5 5.79473684210526 63 23 99.5 0 2 190 100 162 XP_038057560.1 GTP:AMP phosphotransferase AK3, mitochondrial-like [Patiria miniata] diamond 1101 93.6 0.991452991452991 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
29713532 29713532 PRJNA557895_P_NODE_38710_length_161_cov_0.910714_g38355_i0 PRJNA557895 38710 161 0.910714 1.46624954 Metazoa 33208 Echinodermata other_Eukaryota 64.3 2.93e-10   NR XP_041464455.1 7654 g38355 i0 54.7 4.93788819875776 53 24 98.8 0 1 159 124 176 XP_041464455.1 m7GpppN-mRNA hydrolase-like [Lytechinus variegatus] diamond 795 64.3 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
29808515 29808515 PRJNA557895_P_NODE_18111_length_217_cov_0.910714_g17756_i0 PRJNA557895 18111 217 0.910714 1.97624938 Metazoa 33208 Echinodermata other_Eukaryota 49.3 1.26e-4   NR XP_071486057.1 105358 g17756 i0 63.6 1.31336405529954 33 12 45.6 0 107 9 1 33 XP_071486057.1 uncharacterized protein [Diadema antillarum] diamond 285 49.7 0.991951710261569 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
30061144 30061144 PRJNA557895_P_NODE_31_length_6196_cov_13.466406_g20_i0 PRJNA557895 31 6196 13.466406 834.37851576 Metazoa 33208 Echinodermata other_Eukaryota 166 2.97e-41   NR XP_022088067.1 133434 g20 i0 34.5 0.922369270497095 313 156 15.2 4 6163 5225 17 280 XP_022088067.1 uncharacterized protein LOC110977866 [Acanthaster planci] diamond 5715 167 0.994011976047904 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
30314613 30314613 PRJNA557895_P_NODE_32_length_6146_cov_13.474168_g20_i1 PRJNA557895 32 6146 13.474168 828.12236528 Metazoa 33208 Echinodermata other_Eukaryota 166 2.95e-41   NR XP_022088067.1 133434 g20 i1 34.5 0.929873088187439 313 156 15.3 4 6113 5175 17 280 XP_022088067.1 uncharacterized protein LOC110977866 [Acanthaster planci] diamond 5715 167 0.994011976047904 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
30710708 30710708 PRJNA557895_P_NODE_18854_length_213_cov_1.243902_g18499_i0 PRJNA557895 18854 213 1.243902 2.64951126 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 52.8 7.43e-6   NR XP_787337.4 7668 g18499 i0 41.3 1.73239436619718 63 37 88.7 0 13 201 381 443 XP_787337.4 solute carrier family 2, facilitated glucose transporter member 8 [Strongylocentrotus purpuratus] diamond 369 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
31009184 31009184 PRJNA557895_P_NODE_14954_length_238_cov_1.211640_g14599_i0 PRJNA557895 14954 238 1.21164 2.8837032 Lytechinus 7652 Echinodermata other_Eukaryota 56.2 6.27e-7   NR XP_063954017.1 7653 g14599 i0 48.1 2.04201680672269 54 28 68.1 0 162 1 751 804 XP_063954017.1 uncharacterized protein LOC135153799 [Lytechinus pictus] diamond 486 56.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
31342860 31342860 PRJNA557895_P_NODE_11516_length_271_cov_1.373874_g11161_i0 PRJNA557895 11516 271 1.373874 3.72319854 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 54.3 4.37e-6   NR XP_030843761.1 7668 g11161 i0 48.7 0.431734317343173 39 20 43.2 0 170 54 270 308 XP_030843761.1 protein kinase C-binding protein NELL2 [Strongylocentrotus purpuratus] diamond 117 54.3 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
32101991 32101991 PRJNA557895_P_NODE_26338_length_180_cov_0.977099_g25983_i0 PRJNA557895 26338 180 0.977099 1.7587782 Anneissia japonica 1529436 Echinodermata other_Eukaryota 65.5 1.01e-10   NR XP_033110274.1 1529436 g25983 i0 55.9 1.95 59 26 98.3 0 2 178 113 171 XP_033110274.1 uncharacterized protein LOC117111460 [Anneissia japonica] diamond 351 65.5 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
32622068 32622068 PRJNA557895_P_NODE_20340_length_206_cov_0.974522_g19985_i0 PRJNA557895 20340 206 0.974522 2.00751532 Lytechinus 7652 Echinodermata other_Eukaryota 45.8 0.00192   NR XP_063968368.1 7653 g19985 i0 47.6 4.01941747572816 42 22 61.2 0 164 39 190 231 XP_063968368.1 uncharacterized protein LOC129265564 [Lytechinus pictus] diamond 828 45.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
32734151 32734151 PRJNA557895_P_NODE_18320_length_216_cov_0.916168_g17965_i0 PRJNA557895 18320 216 0.916168 1.97892288 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 44.7 0.0012   NR KAJ8043661.1 206669 g17965 i0 33.3 0.958333333333333 69 43 94.4 2 5 208 29 95 KAJ8043661.1 hypothetical protein HOLleu_10857 [Holothuria leucospilota] diamond 207 44.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota

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