RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJEB28589" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 22 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB28589 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
3852156 3852156 PRJEB28589_S_NODE_6364_length_303_cov_1.597656_g6256_i0 PRJEB28589 6364 303 1.597656 4.84089768 Metazoa 33208 Mollusca Mollusca 137 1.07e-35   NR XP_062615032.1 36930 g6256 i0 69.3 13.0693069306931 88 27 87.1 0 2 265 472 559 XP_062615032.1 piwi-like protein 1, partial [Saccostrea cuccullata] diamond 3960 138 0.992753623188406 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Saccostrea Saccostrea cuccullata
11504014 11504014 PRJEB28589_S_NODE_13970_length_198_cov_1.350993_g13862_i0 PRJEB28589 13970 198 1.350993 2.67496614 Mya arenaria 6604 Mollusca Mollusca 59.7 2.12e-8   NR XP_052782434.1 6604 g13862 i0 50.9 3.45454545454545 57 26 86.4 1 173 3 851 905 XP_052782434.1 neutral alpha-glucosidase AB-like isoform X3 [Mya arenaria] diamond 684 59.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
12779535 12779535 PRJEB28589_S_NODE_4771_length_330_cov_1.897527_g4663_i0 PRJEB28589 4771 330 1.897527 6.2618391 Metazoa 33208 Mollusca Mollusca 129 7.430000000000001e-33   NR CAG2256445.1 6550 g4663 i0 93.7 15.4636363636364 63 4 57.3 0 283 95 398 460 CAG2256445.1 AP2M1 [Mytilus edulis] diamond 5103 129 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
12779564 12779564 PRJEB28589_S_NODE_8291_length_272_cov_7.448889_g8183_i0 PRJEB28589 8291 272 7.448889 20.26097808 Mytilus coruscus 42192 Mollusca Mollusca 80.1 3.08e-15   NR CAC5387589.1 42192 g8183 i0 50.6 1.78676470588235 81 39 88.2 1 241 2 280 360 CAC5387589.1 ACP2 [Mytilus coruscus] diamond 486 80.1 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus coruscus
14054164 14054164 PRJEB28589_S_NODE_4632_length_333_cov_3.087413_g4524_i0 PRJEB28589 4632 333 3.087413 10.28108529 Lymnaea stagnalis 6523 Mollusca Mollusca 84.3 7.29e-19   NR CAL1532155.1 6523 g4524 i0 60.7 1.67567567567568 61 24 55 0 42 224 1 61 CAL1532155.1 unnamed protein product [Lymnaea stagnalis] diamond 558 84.3 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis
16602778 16602778 PRJEB28589_S_NODE_2274_length_398_cov_4.527066_g2166_i0 PRJEB28589 2274 398 4.527066 18.01772268 Metazoa 33208 Mollusca Mollusca 133 9.51e-36   NR XP_005095283.1 6500 g2166 i0 73.1 5.94723618090452 78 21 58.8 0 395 162 166 243 XP_005095283.1 uncharacterized protein LOC101845679 [Aplysia californica] diamond 2367 133 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
16602825 16602825 PRJEB28589_S_NODE_8134_length_275_cov_1.789474_g8026_i0 PRJEB28589 8134 275 1.789474 4.9210535 Metazoa 33208 Mollusca Mollusca 66.2 2.95e-10   NR XP_052789762.1 6604 g8026 i0 42.2 22.7018181818182 83 47 89.5 1 5 250 159 241 XP_052789762.1 ATP-binding cassette sub-family F member 1-like [Mya arenaria] diamond 6243 66.2 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
27349567 27349567 PRJEB28589_S_NODE_9183_length_259_cov_5.825472_g9075_i0 PRJEB28589 9183 259 5.825472 15.08797248 Mytilus coruscus 42192 Mollusca Mollusca 99.4 2.5000000000000002e-22   NR CAC5387589.1 42192 g9075 i0 50 0.972972972972973 84 42 97.3 0 254 3 73 156 CAC5387589.1 ACP2 [Mytilus coruscus] diamond 252 99.4 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus coruscus
27500894 27500894 PRJEB28589_S_NODE_2403_length_391_cov_5.938953_g2295_i0 PRJEB28589 2403 391 5.938953 23.22130623 Ostreidae 6563 Mollusca Mollusca 63.5 9.84e-9   NR XP_022341764.1 6565 g2295 i0 61.1 1.65728900255754 54 21 41.4 0 391 230 24 77 XP_022341764.1 leucine-rich repeat-containing protein 47-like [Crassostrea virginica] diamond 648 63.9 0.993740219092332 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Crassostrea Crassostrea virginica
27942876 27942876 PRJEB28589_S_NODE_1705_length_436_cov_5.357326_g1597_i0 PRJEB28589 1705 436 5.357326 23.35794136 Metazoa 33208 Mollusca Mollusca 137 2.48e-36   NR XP_021354830.1 6573 g1597 i0 71.3 15.7706422018349 87 25 59.9 0 7 267 224 310 XP_021354830.1 hydroxyacyl-coenzyme A dehydrogenase, mitochondrial-like [Mizuhopecten yessoensis] diamond 6876 138 0.992753623188406 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
27980894 27980894 PRJEB28589_S_NODE_6585_length_299_cov_4.912698_g6477_i0 PRJEB28589 6585 299 4.912698 14.68896702 Haliotis asinina 109174 Mollusca Mollusca 70.5 1.28e-11   NR XP_067681142.1 109174 g6477 i0 41 1.00334448160535 100 49 99.3 3 1 297 349 439 XP_067681142.1 uncharacterized protein [Haliotis asinina] diamond 300 70.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis asinina
28416524 28416524 PRJEB28589_S_NODE_506_length_676_cov_38.861685_g311_i1 PRJEB28589 506 676 38.861685 262.7049906 Magallana 147004 Mollusca Mollusca 119 2.6e-27   NR XP_065943338.1 29159 g311 i1 37.4 1.60650887573965 182 94 79 7 598 65 350 515 XP_065943338.1 lysosomal acid glucosylceramidase [Magallana gigas] diamond 1086 120 0.991666666666667 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana gigas
29237433 29237433 PRJEB28589_S_NODE_9889_length_249_cov_4.108911_g9781_i0 PRJEB28589 9889 249 4.108911 10.23118839 Mytilus 6548 Mollusca Mollusca 46.2 0.0021   NR CAG2226468.1 6550 g9781 i0 25 6.42168674698795 76 57 91.6 0 239 12 86 161 CAG2226468.1 unnamed protein product [Mytilus edulis] diamond 1599 46.2 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
29401659 29401659 PRJEB28589_S_NODE_11329_length_230_cov_1.267760_g11221_i0 PRJEB28589 11329 230 1.26776 2.915848 Pinctada imbricata 66713 Mollusca Mollusca 59.7 3.38e-8   NR KAK3090663.1 66713 g11221 i0 87.1 5.50434782608696 31 4 40.4 0 1 93 1708 1738 KAK3090663.1 hypothetical protein FSP39_013506 [Pinctada imbricata] diamond 1266 59.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pterioida Pteriidae Pinctada Pinctada imbricata
30026870 30026870 PRJEB28589_S_NODE_6671_length_298_cov_2.924303_g6563_i0 PRJEB28589 6671 298 2.924303 8.71442294 Metazoa 33208 Mollusca Mollusca 47.8 8.02e-4   NR XP_046355785.1 6454 g6563 i0 95.5 22.1275167785235 22 1 22.1 0 2 67 185 206 XP_046355785.1 transmembrane emp24 domain-containing protein 10-like [Haliotis rufescens] diamond 6594 47.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rufescens
30121392 30121392 PRJEB28589_S_NODE_17492_length_166_cov_1.285714_g17384_i0 PRJEB28589 17492 166 1.285714 2.13428524 Metazoa 33208 Mollusca Mollusca 108 1.19e-25   NR CAL1535885.1 6523 g17384 i0 89.1 27.6325301204819 55 6 99.4 0 2 166 463 517 CAL1535885.1 unnamed protein product [Lymnaea stagnalis] diamond 4587 109 0.990825688073395 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis
30349741 30349741 PRJEB28589_S_NODE_14072_length_196_cov_37.093960_g13964_i0 PRJEB28589 14072 196 37.09396 72.7041616 Mytilus edulis 6550 Mollusca Mollusca 43.9 0.00736   NR CAG2187267.1 6550 g13964 i0 47.7 0.673469387755102 44 22 65.8 1 66 194 192 235 CAG2187267.1 unnamed protein product [Mytilus edulis] diamond 132 43.9 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
30595316 30595316 PRJEB28589_S_NODE_14013_length_197_cov_3.066667_g13905_i0 PRJEB28589 14013 197 3.066667 6.04133399 Metazoa 33208 Mollusca Mollusca 58.2 7.11e-8   NR XP_021373616.1 6573 g13905 i0 100 40.7817258883249 26 0 39.6 0 1 78 349 374 XP_021373616.1 transcriptional enhancer factor TEF-1-like isoform X3 [Mizuhopecten yessoensis] diamond 8034 58.2 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
31606978 31606978 PRJEB28589_S_NODE_4516_length_335_cov_4.642361_g4408_i0 PRJEB28589 4516 335 4.642361 15.55190935 Metazoa 33208 Mollusca Mollusca 48.5 0.00104   NR KAL5021713.1 13268 g4408 i0 76 1.71940298507463 25 6 22.4 0 333 259 1336 1360 KAL5021713.1 hypothetical protein ScPMuIL_000868 [Solemya velum] diamond 576 48.5 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Solemyida Solemyidae Solemya Solemya velum
31676599 31676599 PRJEB28589_S_NODE_1097_length_509_cov_9.645022_g994_i0 PRJEB28589 1097 509 9.645022 49.09316198 Littorina saxatilis 31220 Mollusca Mollusca 80.1 4.39e-14   NR XP_070199425.1 31220 g994 i0 84.8 0.807465618860511 46 7 27.1 0 2 139 364 409 XP_070199425.1 isocitrate dehydrogenase [NADP] cytoplasmic-like [Littorina saxatilis] diamond 411 80.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
31771581 31771581 PRJEB28589_S_NODE_3977_length_345_cov_5.043624_g3869_i0 PRJEB28589 3977 345 5.043624 17.4005028 Pinctada imbricata 66713 Mollusca Mollusca 60.5 6.93e-8   NR KAK3086582.1 66713 g3869 i0 41.4 0.608695652173913 70 41 60.9 0 125 334 358 427 KAK3086582.1 hypothetical protein FSP39_020597 [Pinctada imbricata] diamond 210 60.5 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pterioida Pteriidae Pinctada Pinctada imbricata
32871019 32871019 PRJEB28589_S_NODE_8620_length_267_cov_5.718182_g8512_i0 PRJEB28589 8620 267 5.718182 15.26754594 Metazoa 33208 Mollusca Mollusca 47.8 4.85e-4   NR XP_064611261.1 13599 g8512 i0 71 0.685393258426966 31 9 34.8 0 143 235 158 188 XP_064611261.1 tetratricopeptide repeat protein 36-like [Liolophura japonica] diamond 183 48.1 0.993762993762994 Eukaryota Opisthokonta Metazoa Mollusca Polyplacophora Chitonida Chitonidae Liolophura Liolophura 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);;