RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA485080" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA485080 · 13 ✖

analysis 1

  • blastn · 13 ✖
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
9377230 9377230 PRJNA485080_P_NODE_4788_length_436_cov_1.834711_g4694_i0 PRJNA485080 4788 436 1.834711 7.99933996 Bradybaena similaris 145626 Mollusca Mollusca 124 8.799999999999999e-24   NTclustered gi|2912983111|dbj|AP039588.1| 145626 g4694 i0 84.091 9.26834862385321 132 18 30 2 72 203 93633755 93633627 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence blastn 4041 124 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
10652642 10652642 PRJNA485080_P_NODE_11409_length_322_cov_0.923695_g11315_i0 PRJNA485080 11409 322 0.923695 2.9742979 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.008   NTclustered gi|2912987826|dbj|AP039592.1| 145626 g11315 i0 100 0.0900621118012422 29 0 9 0 114 142 10981154 10981182 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
10652983 10652983 PRJNA485080_P_NODE_3709_length_486_cov_1.728814_g3615_i0 PRJNA485080 3709 486 1.728814 8.40203604 Aplysia californica 6500 Mollusca Mollusca 287 1.1899999999999998e-72   NTclustered gi|1897919841|ref|XM_013080763.2| 6500 g3615 i0 78.889 88.4650205761317 450 76 91 18 31 470 62 502 PREDICTED: Aplysia californica 40S ribosomal protein S18 (LOC101863011), mRNA blastn 42994 287 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
12576392 12576392 PRJNA485080_P_NODE_33210_length_246_cov_0.890173_g33116_i0 PRJNA485080 33210 246 0.890173 2.18982558 Metazoa 33208 Mollusca Mollusca 60.2 1.33e-4   NTclustered gi|2868637591|ref|XM_070350399.1| 31220 g33116 i0 97.143 7.27235772357724 35 1 14 0 113 147 1241 1275 PREDICTED: Littorina saxatilis ribosome-binding protein 1-like (LOC138977794), mRNA blastn 1789 60.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
12576398 12576398 PRJNA485080_P_NODE_38550_length_243_cov_0.905882_g38456_i0 PRJNA485080 38550 243 0.905882 2.20129326 Metazoa 33208 Mollusca Mollusca 52.8 0.022   NTclustered gi|2912987826|dbj|AP039592.1| 145626 g38456 i0 100 0.230452674897119 28 0 12 0 195 222 3911245 3911272 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
13202567 13202567 PRJNA485080_P_NODE_12071_length_316_cov_1.267490_g11977_i0 PRJNA485080 12071 316 1.26749 4.0052684 Octopus bimaculoides 37653 Mollusca Mollusca 54.7 0.008   NTclustered gi|2427268934|ref|XM_052973677.1| 37653 g11977 i0 100 0.0917721518987342 29 0 9 0 7 35 17583 17611 PREDICTED: Octopus bimaculoides uncharacterized LOC106871427 (LOC106871427), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus bimaculoides
13202916 13202916 PRJNA485080_P_NODE_37511_length_244_cov_0.900585_g37417_i0 PRJNA485080 37511 244 0.900585 2.1974274 Bradybaena similaris 145626 Mollusca Mollusca 56.5 0.002   NTclustered gi|2912992646|dbj|AP039597.1| 145626 g37417 i0 96.97 1.81147540983607 33 1 14 0 70 102 2390550 2390582 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence blastn 442 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
13851010 13851010 PRJNA485080_P_NODE_13231_length_307_cov_0.897436_g13137_i0 PRJNA485080 13231 307 0.897436 2.75512852 Metazoa 33208 Mollusca Mollusca 52.8 0.029   NTclustered gi|2912989933|dbj|AP039594.1| 145626 g13137 i0 100 0.182410423452769 28 0 9 0 142 169 61042719 61042746 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
15751938 15751938 PRJNA485080_P_NODE_35813_length_245_cov_0.895349_g35719_i0 PRJNA485080 35813 245 0.895349 2.19360505 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.006   NTclustered gi|2912999222|dbj|AP039605.1| 145626 g35719 i0 96.875 0.130612244897959 32 1 13 0 22 53 51812015 51811984 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
17675006 17675006 PRJNA485080_P_NODE_11854_length_318_cov_1.126531_g11760_i0 PRJNA485080 11854 318 1.126531 3.58236858 Metazoa 33208 Mollusca Mollusca 52.8 0.03   NTclustered gi|2912996298|dbj|AP039601.1| 145626 g11760 i0 100 0.176100628930818 28 0 9 0 102 129 42874123 42874150 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 20, sequence blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
18300646 18300646 PRJNA485080_P_NODE_20735_length_255_cov_1.269231_g20641_i0 PRJNA485080 20735 255 1.269231 3.23653905 Ruditapes philippinarum 129788 Mollusca Mollusca 52.8 0.023   NTclustered gi|2616654892|ref|XR_009629123.1| 129788 g20641 i0 100 0.109803921568627 28 0 11 0 208 235 4725 4752 PREDICTED: Ruditapes philippinarum uncharacterized LOC132754766 (LOC132754766), ncRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Ruditapes Ruditapes philippinarum
19574772 19574772 PRJNA485080_P_NODE_15736_length_288_cov_0.981395_g15642_i0 PRJNA485080 15736 288 0.981395 2.8264176 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.027   NTclustered gi|2912984370|dbj|AP039589.1| 145626 g15642 i0 91.892 0.128472222222222 37 3 13 0 237 273 40157248 40157284 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence blastn 37 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
20850929 20850929 PRJNA485080_P_NODE_37997_length_243_cov_1.358824_g37903_i0 PRJNA485080 37997 243 1.358824 3.30194232 Ruditapes philippinarum 129788 Mollusca Mollusca 267 7.19e-67   NTclustered gi|2616637443|ref|XM_060737498.1| 129788 g37903 i0 86.722 102.012345679012 241 30 99 2 1 240 836 1075 PREDICTED: Ruditapes philippinarum tubulin alpha-1A chain (LOC132747962), mRNA blastn 24789 267 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Ruditapes Ruditapes philippinarum

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