RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJEB17675" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB17675 · 15 ✖

analysis 1

  • blastn · 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
1295878 1295878 PRJEB17675_P_NODE_3762_length_505_cov_2.553191_g3477_i0 PRJEB17675 3762 505 2.553191 12.89361455 Mercenaria mercenaria 6596 Mollusca Mollusca 52.8 0.049   NTclustered gi|2442057096|ref|XM_053542242.1| 6596 g3477 i0 100 0.110891089108911 28 0 6 0 141 168 1581 1608 PREDICTED: Mercenaria mercenaria nucleolar protein dao-5-like (LOC123551956), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Mercenaria Mercenaria mercenaria
3847836 3847836 PRJEB17675_P_NODE_13964_length_220_cov_2.313514_g13660_i0 PRJEB17675 13964 220 2.313514 5.0897308 Haliotis rufescens 6454 Mollusca Mollusca 117 6.81e-22   NTclustered gi|2245690426|ref|XM_046520578.2| 6454 g13660 i0 77.404 0.945454545454545 208 39 93 6 16 219 629 426 PREDICTED: Haliotis rufescens cilia- and flagella-associated protein 58-like (LOC124149172), mRNA blastn 208 117 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rufescens
7673928 7673928 PRJEB17675_P_NODE_2547_length_618_cov_4.648370_g2302_i0 PRJEB17675 2547 618 4.64837 28.7269266 Haliotis rubra 36100 Mollusca Mollusca 265 7.229999999999999e-66   NTclustered gi|2194123062|ref|XM_046717536.1| 36100 g2302 i0 80 65.462783171521 360 70 58 2 57 415 14 372 PREDICTED: Haliotis rubra histone H2A (LOC124281598), mRNA blastn 40456 265 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rubra
10224423 10224423 PRJEB17675_P_NODE_23749_length_156_cov_1.652893_g23445_i0 PRJEB17675 23749 156 1.652893 2.57851308 Argopecten irradians 31199 Mollusca Mollusca 108 2.7e-19   NTclustered gi|2835338981|ref|XM_069283339.1| 31199 g23445 i0 85.577 3.96153846153846 104 14 66 1 52 154 307 204 PREDICTED: Argopecten irradians succinate--CoA ligase [ADP/GDP-forming] subunit alpha, mitochondrial-like (LOC138334677), transcript variant X2, mRNA blastn 618 108 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Argopecten Argopecten irradians
10224428 10224428 PRJEB17675_P_NODE_25229_length_151_cov_1.034483_g24925_i0 PRJEB17675 25229 151 1.034483 1.56206933 Patella vulgata 6465 Mollusca Mollusca 161 1.96e-35   NTclustered gi|2506344480|ref|XM_050563061.2| 6465 g24925 i0 87.234 24.2317880794702 141 18 93 0 1 141 237 377 PREDICTED: Patella vulgata ADP-ribosylation factor 1 (LOC126832313), mRNA blastn 3659 161 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
12775219 12775219 PRJEB17675_P_NODE_15091_length_209_cov_1.149425_g14787_i0 PRJEB17675 15091 209 1.149425 2.40229825 Ostrea edulis 37623 Mollusca Mollusca 106 1.39e-18   NTclustered gi|2507391512|ref|XM_048880142.2| 37623 g14787 i0 78.882 3.23923444976077 161 30 76 3 46 203 875 716 PREDICTED: Ostrea edulis ribosome biogenesis protein NSA2 homolog (LOC125651511), mRNA blastn 677 106 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Ostrea Ostrea edulis
12775240 12775240 PRJEB17675_P_NODE_21211_length_167_cov_1.818182_g20907_i0 PRJEB17675 21211 167 1.818182 3.03636394 Littorina saxatilis 31220 Mollusca Mollusca 99 1.77e-16   NTclustered gi|2868620583|ref|XM_070341250.1| 31220 g20907 i0 83.178 1.2814371257485 107 18 64 0 1 107 208 102 PREDICTED: Littorina saxatilis small ribosomal subunit protein uS3 (LOC138968656), transcript variant X2, mRNA blastn 214 99 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
16598471 16598471 PRJEB17675_P_NODE_19874_length_174_cov_2.273381_g19570_i0 PRJEB17675 19874 174 2.273381 3.95568294 Bradybaena similaris 145626 Mollusca Mollusca 56.5 0.001   NTclustered gi|2912987826|dbj|AP039592.1| 145626 g19570 i0 97.059 0.195402298850575 34 0 19 1 26 58 10695165 10695198 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence blastn 34 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
16598490 16598490 PRJEB17675_P_NODE_24434_length_154_cov_0.957983_g24130_i0 PRJEB17675 24434 154 0.957983 1.47529382 Lottia gigantea 225164 Mollusca Mollusca 145 2.03e-30   NTclustered gi|676495766|ref|XM_009068745.1| 225164 g24130 i0 86.364 8.74025974025974 132 18 86 0 6 137 312 181 Lottia gigantea hypothetical protein mRNA blastn 1346 145 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
16598495 16598495 PRJEB17675_P_NODE_25514_length_150_cov_1.347826_g25210_i0 PRJEB17675 25514 150 1.347826 2.021739 Haliotis rubra 36100 Mollusca Mollusca 148 1.51e-31   NTclustered gi|2194109215|ref|XM_046710664.1| 36100 g25210 i0 85.417 31.1333333333333 144 19 95 2 6 148 1612 1470 PREDICTED: Haliotis rubra endoplasmic reticulum chaperone BiP-like (LOC124275165), mRNA blastn 4670 148 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rubra
19147188 19147188 PRJEB17675_P_NODE_8116_length_318_cov_3.091873_g7812_i0 PRJEB17675 8116 318 3.091873 9.83215614 Bradybaena similaris 145626 Mollusca Mollusca 60.2 1.78e-4   NTclustered gi|2912993551|dbj|AP039598.1| 145626 g7812 i0 100 9.82075471698113 32 0 10 0 41 72 27551157 27551188 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence blastn 3123 60.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
20422323 20422323 PRJEB17675_P_NODE_10237_length_272_cov_2.012658_g9933_i0 PRJEB17675 10237 272 2.012658 5.47442976 Physella acuta 109671 Mollusca Mollusca 209 1.4e-49   NTclustered gi|2572399431|ref|XM_059316954.1| 109671 g9933 i0 83.117 42.0294117647059 231 37 85 2 1 230 1040 1269 PREDICTED: Physella acuta V-type proton ATPase catalytic subunit A-like (LOC131953656), mRNA blastn 11432 209 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
20422416 20422416 PRJEB17675_P_NODE_697_length_1091_cov_2.805871_g571_i0 PRJEB17675 697 1091 2.805871 30.61205261 Mizuhopecten yessoensis 6573 Mollusca Mollusca 60.2 6.63e-4   NTclustered gi|1207921551|ref|XM_021494057.1| 6573 g571 i0 100 0.288725939505041 32 0 3 0 898 929 949 980 PREDICTED: Mizuhopecten yessoensis mucin-4-like (LOC110448026), partial mRNA blastn 315 60.2 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
22973606 22973606 PRJEB17675_P_NODE_11319_length_253_cov_3.486239_g11015_i0 PRJEB17675 11319 253 3.486239 8.82018467 Mya arenaria 6604 Mollusca Mollusca 198 2.7899999999999998e-46   NTclustered gi|2427441888|ref|XM_052905672.1| 6604 g11015 i0 91.667 51.6916996047431 144 11 57 1 111 253 1514 1371 PREDICTED: Mya arenaria tubulin alpha-1A chain-like (LOC128204264), mRNA blastn 13078 198 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
22973627 22973627 PRJEB17675_P_NODE_18219_length_185_cov_1.220000_g17915_i0 PRJEB17675 18219 185 1.22 2.257 Tropidomya abbreviata 102404 Mollusca Mollusca 69.4 1.57e-7   NTclustered gi|1181491976|ref|NC_034304.1| 102404 g17915 i0 95.349 1.05945945945946 43 2 23 0 76 118 14673 14715 Tropidomya abbreviata voucher T_abbreviata_29Jun15 mitochondrion, complete genome blastn 196 69.4 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia   Poromyidae Tropidomya Tropidomya abbreviata

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