RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA1010662" 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

  • PRJNA1010662 · 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
1001431 1001431 PRJNA1010662_P_NODE_15941_length_163_cov_0.912281_g15882_i0 PRJNA1010662 15941 163 0.912281 1.48701803 Opisthokonta 33154 Echinodermata other_Eukaryota 72.8 3.2e-13   NR XP_022082031.1 133434 g15882 i0 69.8 1.95092024539877 53 15 97.5 1 159 1 244 295 XP_022082031.1 bifunctional purine biosynthesis protein PURH-like [Acanthaster planci] diamond 318 72.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
6533123 6533123 PRJNA1010662_P_NODE_7646_length_204_cov_1.329032_g7587_i0 PRJNA1010662 7646 204 1.329032 2.71122528 Apostichopus japonicus 307972 Echinodermata other_Eukaryota 85.5 8.17e-18   NR PIK51386.1 307972 g7587 i0 55.7 1.02941176470588 70 28 98.5 2 3 203 104 173 PIK51386.1 hypothetical protein BSL78_11708 [Apostichopus japonicus] diamond 210 85.5 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Stichopodidae Apostichopus Apostichopus japonicus
20556034 20556034 PRJNA1010662_P_NODE_15257_length_164_cov_0.904348_g15198_i0 PRJNA1010662 15257 164 0.904348 1.48313072 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 86.3 5.5e-18   NR KAJ8020257.1 206669 g15198 i0 70.4 0.98780487804878 54 16 98.8 0 163 2 104 157 KAJ8020257.1 Polyadenylate-binding protein 1 [Holothuria leucospilota] diamond 162 86.3 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
24380883 24380883 PRJNA1010662_P_NODE_12960_length_168_cov_0.873950_g12901_i0 PRJNA1010662 12960 168 0.87395 1.468236 Opisthokonta 33154 Echinodermata other_Eukaryota 95.5 9.1e-22   NR XP_033637768.1 7604 g12901 i0 83.6 31.4285714285714 55 9 98.2 0 2 166 231 285 XP_033637768.1 calcium-binding protein 39-like [Asterias rubens] diamond 5280 96.3 0.991692627206646 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
27034507 27034507 PRJNA1010662_P_NODE_7622_length_204_cov_1.832258_g7563_i0 PRJNA1010662 7622 204 1.832258 3.73780632 Acanthaster planci 133434 Echinodermata other_Eukaryota 45.1 0.00286   NR XP_022091842.1 133434 g7563 i0 45.5 0.808823529411765 55 28 77.9 1 177 19 5 59 XP_022091842.1 transmembrane emp24 domain-containing protein 4-like [Acanthaster planci] diamond 165 45.1 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
27192404 27192404 PRJNA1010662_P_NODE_11662_length_173_cov_1.927419_g11603_i0 PRJNA1010662 11662 173 1.927419 3.33443487 Anneissia japonica 1529436 Echinodermata other_Eukaryota 60.8 5.95e-9   NR XP_033105774.1 1529436 g11603 i0 49.2 1.05780346820809 61 25 97.1 2 5 172 4232 4291 XP_033105774.1 uncharacterized protein LOC117108037 [Anneissia japonica] diamond 183 60.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
27943168 27943168 PRJNA1010662_P_NODE_10145_length_183_cov_2.216418_g10086_i0 PRJNA1010662 10145 183 2.216418 4.05604494 Metazoa 33208 Echinodermata other_Eukaryota 87.8 2.18e-18   NR XP_033096903.1 1529436 g10086 i0 65 4.9016393442623 60 21 98.4 0 3 182 9 68 XP_033096903.1 lysosomal alpha-mannosidase-like [Anneissia japonica] diamond 897 87.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
28297771 28297771 PRJNA1010662_P_NODE_2326_length_334_cov_1.428070_g2267_i0 PRJNA1010662 2326 334 1.42807 4.7697538 Patiria miniata 46514 Echinodermata other_Eukaryota 133 9.9e-35   NR XP_038074570.1 46514 g2267 i0 57 3.08083832335329 114 46 99.7 2 334 2 127 240 XP_038074570.1 uncharacterized protein LOC119742563 [Patiria miniata] diamond 1029 133 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
28771424 28771424 PRJNA1010662_P_NODE_15587_length_164_cov_0.895652_g15528_i0 PRJNA1010662 15587 164 0.895652 1.46886928 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 41.6 0.0336   NR KAJ8026136.1 206669 g15528 i0 38.9 0.98780487804878 54 33 98.8 0 164 3 1730 1783 KAJ8026136.1 Fibrocystin-L [Holothuria leucospilota] diamond 162 41.6 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
29182129 29182129 PRJNA1010662_P_NODE_7709_length_203_cov_1.675325_g7650_i0 PRJNA1010662 7709 203 1.675325 3.40090975 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 62 3.58e-9   NR KAJ8022464.1 206669 g7650 i0 57.4 0.798029556650246 54 22 79.8 1 198 37 2395 2447 KAJ8022464.1 Prosaposin [Holothuria leucospilota] diamond 162 62 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
29308134 29308134 PRJNA1010662_P_NODE_10249_length_183_cov_1.044776_g10190_i0 PRJNA1010662 10249 183 1.044776 1.91194008 Anneissia japonica 1529436 Echinodermata other_Eukaryota 85.5 4.78e-18   NR XP_033102886.1 1529436 g10190 i0 69.1 1.80327868852459 55 17 90.2 0 182 18 215 269 XP_033102886.1 LOW QUALITY PROTEIN: NAD-dependent protein deacetylase sirtuin-2-like [Anneissia japonica] diamond 330 85.5 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
29749974 29749974 PRJNA1010662_P_NODE_13731_length_167_cov_0.872881_g13672_i0 PRJNA1010662 13731 167 0.872881 1.45771127 Patiria miniata 46514 Echinodermata other_Eukaryota 68.9 7.59e-12   NR XP_038075350.1 46514 g13672 i0 50 3.64670658682635 54 27 97 0 166 5 366 419 XP_038075350.1 putative phospholipase B-like 2 [Patiria miniata] diamond 609 68.9 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
31227538 31227538 PRJNA1010662_P_NODE_11775_length_173_cov_1.250000_g11716_i0 PRJNA1010662 11775 173 1.25 2.1625 Metazoa 33208 Echinodermata other_Eukaryota 61.6 1.96e-9   NR XP_033628931.1 7604 g11716 i0 75.9 1.50867052023121 29 7 50.3 0 2 88 230 258 XP_033628931.1 uncharacterized protein LOC117291388 [Asterias rubens] diamond 261 61.6 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
32525084 32525084 PRJNA1010662_P_NODE_10179_length_183_cov_1.552239_g10120_i0 PRJNA1010662 10179 183 1.552239 2.84059737 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 88.6 1.63e-19   NR XP_030850438.1 7668 g10120 i0 64.4 18.3770491803279 59 21 96.7 0 183 7 152 210 XP_030850438.1 40S ribosomal protein S4 [Strongylocentrotus purpuratus] diamond 3363 88.6 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
32878694 32878694 PRJNA1010662_P_NODE_12740_length_168_cov_1.731092_g12681_i0 PRJNA1010662 12740 168 1.731092 2.90823456 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 49.3 6.85e-5   NR XP_030845741.1 7668 g12681 i0 49.2 1.05357142857143 59 24 94.6 3 168 10 3450 3508 XP_030845741.1 sushi, von Willebrand factor type A, EGF and pentraxin domain-containing protein 1 [Strongylocentrotus purpuratus] diamond 177 49.3 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus

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