RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA1192965" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1192965 · 14 ✖

analysis 1

  • diamond · 14 ✖
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
4147431 4147431 PRJNA1192965_P_NODE_5084_length_241_cov_0.916667_g5065_i0 PRJNA1192965 5084 241 0.916667 2.20916747 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 116 3.97e-29   NR KAH9514130.1 55810 g5065 i0 64.1 11.7634854771784 78 28 97.1 0 234 1 240 317 KAH9514130.1 hypothetical protein Btru_030358 [Bulinus truncatus] diamond 2835 116 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Bulinus Bulinus truncatus
26660556 26660556 PRJNA1192965_P_NODE_3901_length_248_cov_0.880000_g3882_i0 PRJNA1192965 3901 248 0.88 2.1824 Mercenaria mercenaria 6596 Mollusca Mollusca 59.3 5.36e-8   NR XP_053391666.1 6596 g3882 i0 43.3 0.810483870967742 67 36 78.6 2 202 8 9 75 XP_053391666.1 lipase ZK262.3-like [Mercenaria mercenaria] diamond 201 59.3 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Mercenaria Mercenaria mercenaria
26692461 26692461 PRJNA1192965_P_NODE_2981_length_260_cov_1.385027_g2962_i0 PRJNA1192965 2981 260 1.385027 3.6010702 Pecten maximus 6579 Mollusca Mollusca 117 3.5e-28   NR XP_033734872.1 6579 g2962 i0 68.2 6.86538461538461 85 27 98.1 0 1 255 1096 1180 XP_033734872.1 pyruvate carboxylase, mitochondrial-like isoform X2 [Pecten maximus] diamond 1785 117 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Pecten Pecten maximus
27230358 27230358 PRJNA1192965_P_NODE_1423_length_341_cov_1.205224_g1404_i0 PRJNA1192965 1423 341 1.205224 4.10981384 Lymnaea stagnalis 6523 Mollusca Mollusca 53.1 1.97e-5   NR CAL1539987.1 6523 g1404 i0 32.4 2.92961876832845 111 66 96.8 3 8 337 24 126 CAL1539987.1 unnamed protein product [Lymnaea stagnalis] diamond 999 53.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis
28070478 28070478 PRJNA1192965_P_NODE_3245_length_251_cov_1.730337_g3226_i0 PRJNA1192965 3245 251 1.730337 4.34314587 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 53.1 8.76e-6   NR VDI48492.1 29158 g3226 i0 32.2 5.199203187251 87 52 95.6 2 12 251 478 564 VDI48492.1 Hypothetical predicted protein [Mytilus galloprovincialis] diamond 1305 53.5 0.992523364485981 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus galloprovincialis
28272326 28272326 PRJNA1192965_P_NODE_4686_length_243_cov_1.811765_g4667_i0 PRJNA1192965 4686 243 1.811765 4.40258895 Solemya velum 13268 Mollusca Mollusca 45.4 0.00415   NR KAL5010570.1 13268 g4667 i0 48.6 0.432098765432099 35 18 43.2 0 134 238 738 772 KAL5010570.1 hypothetical protein ScPMuIL_012875 [Solemya velum] diamond 105 45.4 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Solemyida Solemyidae Solemya Solemya velum
28525275 28525275 PRJNA1192965_P_NODE_3627_length_249_cov_1.613636_g3608_i0 PRJNA1192965 3627 249 1.613636 4.01795364 Pecten maximus 6579 Mollusca Mollusca 121 1.43e-30   NR XP_033730557.1 6579 g3608 i0 61 2.96385542168675 82 32 98.8 0 3 248 56 137 XP_033730557.1 long-chain specific acyl-CoA dehydrogenase, mitochondrial-like [Pecten maximus] diamond 738 121 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Pecten Pecten maximus
28967296 28967296 PRJNA1192965_P_NODE_3188_length_253_cov_1.422222_g3169_i0 PRJNA1192965 3188 253 1.422222 3.59822166 Saccostrea cuccullata 36930 Mollusca Mollusca 65.9 3e-10   NR XP_062567131.1 36930 g3169 i0 45.2 3 84 44 98.4 2 252 4 9 91 XP_062567131.1 phenylalanine--tRNA ligase alpha subunit-like [Saccostrea cuccullata] diamond 759 65.9 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Saccostrea Saccostrea cuccullata
29585769 29585769 PRJNA1192965_P_NODE_5270_length_235_cov_2.129630_g5251_i0 PRJNA1192965 5270 235 2.12963 5.0046305 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 44.7 0.00689   NR WAQ96290.1 6604 g5251 i0 30.3 3.62553191489362 66 46 84.3 0 211 14 12 77 WAQ96290.1 CBPA2-like protein [Mya arenaria] diamond 852 44.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
30091205 30091205 PRJNA1192965_P_NODE_2432_length_281_cov_1.259615_g2413_i0 PRJNA1192965 2432 281 1.259615 3.53951815 Bivalvia 6544 Mollusca Mollusca 55.5 1.95e-6   NR KAL3865706.1 1069815 g2413 i0 41.9 3.06405693950178 86 49 91.8 1 6 263 125 209 KAL3865706.1 hypothetical protein ACJMK2_043068 [Sinanodonta woodiana] diamond 861 55.5 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Unionida Unionidae Sinanodonta Sinanodonta woodiana
30609341 30609341 PRJNA1192965_P_NODE_3213_length_252_cov_1.720670_g3194_i0 PRJNA1192965 3213 252 1.72067 4.3360884 Pinctada imbricata 66713 Mollusca Mollusca 61.6 4.07e-9   NR KAK3101195.1 66713 g3194 i0 48.5 2.98809523809524 66 34 78.6 0 1 198 155 220 KAK3101195.1 hypothetical protein FSP39_001661 [Pinctada imbricata] diamond 753 61.6 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pterioida Pteriidae Pinctada Pinctada imbricata
30957236 30957236 PRJNA1192965_P_NODE_554_length_495_cov_3.142180_g535_i0 PRJNA1192965 554 495 3.14218 15.553791 Pomacea canaliculata 400727 Mollusca Mollusca 63.5 2.66e-8   NR XP_025105735.1 400727 g535 i0 47.6 1.14545454545455 63 33 38.2 0 475 287 222 284 XP_025105735.1 calcium-binding protein LPS1-alpha-like [Pomacea canaliculata] diamond 567 63.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Architaenioglossa Ampullariidae Pomacea Pomacea canaliculata
31007684 31007684 PRJNA1192965_P_NODE_5074_length_241_cov_0.916667_g5055_i0 PRJNA1192965 5074 241 0.916667 2.20916747 Octopus 6643 Mollusca Mollusca 78.6 4.81e-15   NR CAI9737587.1 6645 g5055 i0 50 9 80 39 98.3 1 5 241 142 221 CAI9737587.1 ammonium transporter Rh type A-like [Octopus vulgaris] diamond 2169 78.6 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus vulgaris
32443858 32443858 PRJNA1192965_P_NODE_4379_length_245_cov_0.895349_g4360_i0 PRJNA1192965 4379 245 0.895349 2.19360505 Bulinus truncatus 55810 Mollusca Mollusca 93.6 5.02e-20   NR KAH9515710.1 55810 g4360 i0 64.2 0.820408163265306 67 24 82 0 201 1 910 976 KAH9515710.1 NFX1-type zinc finger-containing protein 1 [Bulinus truncatus] diamond 201 93.6 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Bulinus Bulinus truncatus

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