RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA421571" 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

  • PRJNA421571 · 14 ✖

analysis 1

  • blastn · 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
423268 423268 PRJNA421571_P_NODE_50241_length_388_cov_2.133333_g47693_i0 PRJNA421571 50241 388 2.133333 8.27733204 Littorina saxatilis 31220 Mollusca Mollusca 63.9 1.71e-5   NTclustered gi|2868647028|ref|XM_070353458.1| 31220 g47693 i0 83.333 0.371134020618557 72 8 18 4 8 77 496 565 PREDICTED: Littorina saxatilis uncharacterized protein (LOC138980570), transcript variant X1, mRNA blastn 144 63.9 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
1696659 1696659 PRJNA421571_P_NODE_101062_length_245_cov_0.895349_g98513_i0 PRJNA421571 101062 245 0.895349 2.19360505 Bradybaena similaris 145626 Mollusca Mollusca 69.4 2.2e-7   NTclustered gi|2912998575|dbj|AP039604.1| 145626 g98513 i0 83.784 7.45714285714286 74 11 30 1 104 177 45509731 45509803 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence blastn 1827 69.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
2973507 2973507 PRJNA421571_P_NODE_36223_length_506_cov_1.420323_g33680_i0 PRJNA421571 36223 506 1.420323 7.18683438 Bradybaena similaris 145626 Mollusca Mollusca 58.4 0.001   NTclustered gi|2912999747|dbj|AP039606.1| 145626 g33680 i0 100 0.120553359683794 31 0 6 0 275 305 12807113 12807083 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence blastn 61 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
5528033 5528033 PRJNA421571_P_NODE_91285_length_251_cov_4.707865_g88736_i0 PRJNA421571 91285 251 4.707865 11.81674115 Magallana angulata 2784310 Mollusca Mollusca 154 6.06e-33   NTclustered gi|2416975210|ref|XM_052827149.1| 2784310 g88736 i0 86.861 43.9641434262948 137 18 55 0 1 137 1384 1520 PREDICTED: Crassostrea angulata tubulin alpha-1A chain-like (LOC128163529), mRNA blastn 11035 154 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana angulata
6801623 6801623 PRJNA421571_P_NODE_73306_length_294_cov_0.855204_g70757_i0 PRJNA421571 73306 294 0.855204 2.51429976 Pomacea canaliculata 400727 Mollusca Mollusca 165 3.36e-36   NTclustered gi|1397671755|ref|XM_025231685.1| 400727 g70757 i0 81.373 27.0136054421769 204 36 69 2 45 247 613 411 PREDICTED: Pomacea canaliculata S-phase kinase-associated protein 1 (LOC112560103), mRNA blastn 7942 165 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Architaenioglossa Ampullariidae Pomacea Pomacea canaliculata
11901928 11901928 PRJNA421571_P_NODE_45610_length_419_cov_10.234104_g43062_i0 PRJNA421571 45610 419 10.234104 42.88089576 Physella acuta 109671 Mollusca Mollusca 750 0   NTclustered gi|2233989091|emb|OW484578.1| 109671 g43062 i0 99.515 82.0477326968974 412 2 98 0 8 419 11767 11356 Physella acuta genome assembly, organelle: mitochondrion blastn 34378 750 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
11902839 11902839 PRJNA421571_P_NODE_79130_length_279_cov_1.475728_g76581_i0 PRJNA421571 79130 279 1.475728 4.11728112 Bradybaena similaris 145626 Mollusca Mollusca 58.4 5.52e-4   NTclustered gi|2912996298|dbj|AP039601.1| 145626 g76581 i0 100 0.326164874551971 31 0 11 0 89 119 2037403 2037373 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 20, sequence blastn 91 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
15727087 15727087 PRJNA421571_P_NODE_94913_length_249_cov_0.875000_g92364_i0 PRJNA421571 94913 249 0.875 2.17875 Bradybaena similaris 145626 Mollusca Mollusca 62.1 3.74e-5   NTclustered gi|2912992646|dbj|AP039597.1| 145626 g92364 i0 91.304 6.30923694779116 46 3 18 1 118 162 14912458 14912413 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence blastn 1571 62.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
17001629 17001629 PRJNA421571_P_NODE_87834_length_259_cov_1.607527_g85285_i0 PRJNA421571 87834 259 1.607527 4.16349493 Octopus sinensis 2607531 Mollusca Mollusca 58.4 5.07e-4   NTclustered gi|1914653111|ref|XM_029797205.2| 2607531 g85285 i0 97.059 0.393822393822394 34 1 13 0 223 256 1674 1707 PREDICTED: Octopus sinensis uncharacterized LOC115226195 (LOC115226195), transcript variant X3, mRNA blastn 102 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus sinensis
18275653 18275653 PRJNA421571_P_NODE_77755_length_282_cov_1.842105_g75206_i0 PRJNA421571 77755 282 1.842105 5.1947361 Physella acuta 109671 Mollusca Mollusca 405 1.73e-108   NTclustered gi|2233973967|emb|OW483461.1| 109671 g75206 i0 92.553 43.968085106383 282 21 100 0 1 282 4360 4079 Physella acuta genome assembly, organelle: mitochondrion blastn 12399 405 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
19550201 19550201 PRJNA421571_P_NODE_91576_length_251_cov_1.595506_g89027_i0 PRJNA421571 91576 251 1.595506 4.00472006 Bradybaena similaris 145626 Mollusca Mollusca 63.9 1.05e-5   NTclustered gi|2912981848|dbj|AP039587.1| 145626 g89027 i0 93.023 0.171314741035857 43 3 17 0 100 142 91386534 91386576 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence blastn 43 63.9 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
20826102 20826102 PRJNA421571_P_NODE_92817_length_250_cov_2.435028_g90268_i0 PRJNA421571 92817 250 2.435028 6.08757 Pecten maximus 6579 Mollusca Mollusca 99 2.87e-16   NTclustered gi|1835489157|ref|XM_033882633.1| 6579 g90268 i0 82.727 2.056 110 19 44 0 141 250 1433 1324 PREDICTED: Pecten maximus AP-1 complex subunit mu-1 (LOC117326044), mRNA blastn 514 99 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Pecten Pecten maximus
22763219 22763219 PRJNA421571_P_NODE_88658_length_257_cov_1.673913_g86109_i0 PRJNA421571 88658 257 1.673913 4.30195641 Metazoa 33208 Mollusca Mollusca 84.2 8.29e-12   NTclustered gi|2868671985|ref|XM_070345200.1| 31220 g86109 i0 75.74 31.1400778210117 169 39 65 2 76 243 169 336 PREDICTED: Littorina saxatilis small ribosomal subunit protein eS25-like (LOC138972551), mRNA blastn 8003 84.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
25312378 25312378 PRJNA421571_P_NODE_89580_length_255_cov_1.692308_g87031_i0 PRJNA421571 89580 255 1.692308 4.3153854 Metazoa 33208 Mollusca Mollusca 472 1.5e-128   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g87031 i0 100 58.7921568627451 255 0 100 0 1 255 1561 1815 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 14992 472 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta

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