RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "blastn", bioproject = "PRJNA741997" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA741997 · 19 ✖

analysis 1

  • blastn · 19 ✖
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
4549955 4549955 PRJNA741997_P_NODE_39724_length_344_cov_1.516605_g38604_i0 PRJNA741997 39724 344 1.516605 5.2171212 Perna viridis 73031 Mollusca Mollusca 298 3.79e-76   NTclustered gi|56967588|gb|AY850128.1| 73031 g38604 i0 96.667 0.627906976744186 180 5 63 1 65 243 19 198 Perna viridis clone GM8 microsatellite sequence blastn 216 298 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Perna Perna viridis
4549999 4549999 PRJNA741997_P_NODE_47524_length_314_cov_1.269710_g46404_i0 PRJNA741997 47524 314 1.26971 3.9868894 Patella vulgata 6465 Mollusca Mollusca 204 7.66e-48   NTclustered gi|2506312098|ref|XM_050537420.2| 6465 g46404 i0 79.195 40.5382165605096 298 58 94 4 6 301 765 470 PREDICTED: Patella vulgata calmodulin-like protein 3 (LOC126811635), mRNA blastn 12729 204 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
5825202 5825202 PRJNA741997_P_NODE_64285_length_268_cov_1.307692_g63165_i0 PRJNA741997 64285 268 1.307692 3.50461456 Bradybaena similaris 145626 Mollusca Mollusca 63.9 1.13e-5   NTclustered gi|2912998575|dbj|AP039604.1| 145626 g63165 i0 97.297 0.511194029850746 37 1 14 0 2 38 36472210 36472246 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence blastn 137 63.9 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
7100362 7100362 PRJNA741997_P_NODE_75406_length_249_cov_0.875000_g74286_i0 PRJNA741997 75406 249 0.875 2.17875 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.023   NTclustered gi|2912993551|dbj|AP039598.1| 145626 g74286 i0 100 0.112449799196787 28 0 11 0 48 75 32979090 32979117 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
7576024 7576024 PRJNA741997_P_NODE_19386_length_524_cov_1.549889_g18271_i0 PRJNA741997 19386 524 1.549889 8.12141836 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 58.4 0.001   NTclustered gi|2334745070|ref|XM_052205312.1| 6549 g18271 i0 97.143 2.76526717557252 35 0 6 1 286 319 1576 1542 PREDICTED: Mytilus californianus uncharacterized LOC127701449 (LOC127701449), mRNA blastn 1449 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus californianus
8374872 8374872 PRJNA741997_P_NODE_58787_length_281_cov_0.711538_g57667_i0 PRJNA741997 58787 281 0.711538 1.99942178 Aplysia californica 6500 Mollusca Mollusca 111 4.21e-20   NTclustered gi|1897931265|ref|XM_013085028.2| 6500 g57667 i0 85.321 1.87188612099644 109 15 38 1 29 136 390 282 PREDICTED: Aplysia californica heat shock protein 83 (LOC101859343), mRNA blastn 526 111 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
9649896 9649896 PRJNA741997_P_NODE_36368_length_360_cov_1.369338_g35248_i0 PRJNA741997 36368 360 1.369338 4.9296168 Bradybaena similaris 145626 Mollusca Mollusca 65.8 4.38e-6   NTclustered gi|2912987826|dbj|AP039592.1| 145626 g35248 i0 97.368 6.875 38 1 11 0 231 268 48349204 48349167 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence blastn 2475 65.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
12200691 12200691 PRJNA741997_P_NODE_15710_length_601_cov_1.285985_g14606_i0 PRJNA741997 15710 601 1.285985 7.72876985 Patella vulgata 6465 Mollusca Mollusca 497 6.36e-136   NTclustered gi|2506343157|ref|XM_050561934.2| 6465 g14606 i0 81.742 98.6289517470882 597 107 99 2 6 601 568 1163 PREDICTED: Patella vulgata ATP synthase subunit beta, mitochondrial (LOC126831451), mRNA blastn 59276 497 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
12200891 12200891 PRJNA741997_P_NODE_47270_length_315_cov_1.111570_g46150_i0 PRJNA741997 47270 315 1.11157 3.5014455 Bradybaena similaris 145626 Mollusca Mollusca 58.4 6.34e-4   NTclustered gi|2913001816|dbj|AP039609.1| 145626 g46150 i0 80.519 0.244444444444444 77 14 24 1 68 144 32069203 32069278 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence blastn 77 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
12201093 12201093 PRJNA741997_P_NODE_82910_length_245_cov_0.895349_g81790_i0 PRJNA741997 82910 245 0.895349 2.19360505 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.022   NTclustered gi|2912991694|dbj|AP039596.1| 145626 g81790 i0 100 0.114285714285714 28 0 11 0 2 29 19199327 19199300 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
14750488 14750488 PRJNA741997_P_NODE_57612_length_283_cov_1.457143_g56492_i0 PRJNA741997 57612 283 1.457143 4.12371469 Mytilus californianus 6549 Mollusca Mollusca 71.3 7.21e-8   NTclustered gi|2334818648|ref|XM_052222415.1| 6549 g56492 i0 85.915 1.89752650176678 71 4 24 2 34 101 1077 1010 PREDICTED: Mytilus californianus hsc70-interacting protein-like (LOC127716256), transcript variant X10, mRNA blastn 537 71.3 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus californianus
15226689 15226689 PRJNA741997_P_NODE_39732_length_344_cov_1.420664_g38612_i0 PRJNA741997 39732 344 1.420664 4.88708416 Opisthokonta 33154 Mollusca Mollusca 93.5 1.92e-14   NTclustered gi|2427458655|ref|XM_052937391.1| 6604 g38612 i0 98.113 16.1308139534884 53 1 15 0 292 344 1386 1334 PREDICTED: Mya arenaria tubulin beta chain-like (LOC128227143), mRNA blastn 5549 93.5 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
16024149 16024149 PRJNA741997_P_NODE_5953_length_1116_cov_1.845638_g5238_i0 PRJNA741997 5953 1116 1.845638 20.59732008 Haliotis discus 36094 Mollusca Mollusca 56.5 0.009   NTclustered gi|1403874856|gb|MG011711.1| 42344 g5238 i0 96.97 0.0295698924731183 33 1 3 0 984 1016 1140 1108 Haliotis discus hannai sex-determining region Y-box 9 (Sox9) mRNA, complete cds blastn 33 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis discus
16024248 16024248 PRJNA741997_P_NODE_76893_length_248_cov_1.320000_g75773_i0 PRJNA741997 76893 248 1.32 3.2736 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.022   NTclustered gi|2912994531|dbj|AP039599.1| 145626 g75773 i0 100 0.112903225806452 28 0 11 0 101 128 58802921 58802894 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
18573453 18573453 PRJNA741997_P_NODE_86655_length_243_cov_0.905882_g85535_i0 PRJNA741997 86655 243 0.905882 2.20129326 Haliotis rubra 36100 Mollusca Mollusca 63.9 1.01e-5   NTclustered gi|2194137516|ref|XM_046724765.1| 36100 g85535 i0 100 21.1358024691358 34 0 14 0 69 102 3 36 PREDICTED: Haliotis rubra protein PIF-like (LOC124288179), mRNA blastn 5136 63.9 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rubra
21124164 21124164 PRJNA741997_P_NODE_66657_length_262_cov_1.629630_g65537_i0 PRJNA741997 66657 262 1.62963 4.2696306 Crassostrea virginica 6565 Mollusca Mollusca 63.9 1.1e-5   NTclustered gi|1242819309|ref|XM_022434688.1| 6565 g65537 i0 100 1.12595419847328 34 0 13 0 123 156 183 216 PREDICTED: Crassostrea virginica putative uncharacterized protein DDB_G0277057 (LOC111102032), mRNA blastn 295 63.9 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Crassostrea Crassostrea virginica
23674442 23674442 PRJNA741997_P_NODE_33079_length_378_cov_3.790164_g31959_i0 PRJNA741997 33079 378 3.790164 14.32681992 Mercenaria mercenaria 6596 Mollusca Mollusca 267 1.18e-66   NTclustered gi|2441991191|ref|XM_053519753.1| 6596 g31959 i0 84.906 46.9867724867725 265 38 70 2 56 319 443 180 PREDICTED: Mercenaria mercenaria dynein light chain 1, cytoplasmic-like (LOC123533746), transcript variant X1, mRNA blastn 17761 267 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Mercenaria Mercenaria mercenaria
23674685 23674685 PRJNA741997_P_NODE_78919_length_247_cov_0.885057_g77799_i0 PRJNA741997 78919 247 0.885057 2.18609079 Mya arenaria 6604 Mollusca Mollusca 54.7 0.006   NTclustered gi|2427531956|ref|XM_052963346.1| 6604 g77799 i0 100 0.234817813765182 29 0 12 0 64 92 758 786 PREDICTED: Mya arenaria cytoplasmic dynein 1 light intermediate chain 2-like (LOC128245109), mRNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
24947805 24947805 PRJNA741997_P_NODE_23380_length_465_cov_1.821429_g22261_i0 PRJNA741997 23380 465 1.821429 8.46964485 Octopus bimaculoides 37653 Mollusca Mollusca 54.7 0.013   NTclustered gi|2427260936|ref|XM_052972188.1| 37653 g22261 i0 96.875 0.36989247311828 32 1 7 0 281 312 864 895 PREDICTED: Octopus bimaculoides hybrid signal transduction histidine kinase E-like (LOC106870123), mRNA blastn 172 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus bimaculoides

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