RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "blastn", bioproject = "PRJNA431371" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA431371 · 17 ✖

analysis 1

  • blastn · 17 ✖
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
427941 427941 PRJNA431371_P_NODE_1161_length_891_cov_7.413203_g1099_i0 PRJNA431371 1161 891 7.413203 66.05163873 Biomphalaria glabrata 6526 Mollusca Mollusca 62.1 1.49e-4   NTclustered gi|2502142903|ref|XM_056017277.1| 6526 g1099 i0 81.013 0.162738496071829 79 13 9 2 409 486 621 698 PREDICTED: Biomphalaria glabrata procathepsin L-like (LOC106058997), mRNA blastn 145 62.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Biomphalaria Biomphalaria glabrata
1703006 1703006 PRJNA431371_P_NODE_19962_length_286_cov_1.446009_g19889_i0 PRJNA431371 19962 286 1.446009 4.13558574 Bradybaena similaris 145626 Mollusca Mollusca 62.1 4.39e-5   NTclustered gi|2913001816|dbj|AP039609.1| 145626 g19889 i0 88.462 0.395104895104895 52 4 17 2 99 148 16206513 16206564 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence blastn 113 62.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
2978641 2978641 PRJNA431371_P_NODE_11823_length_366_cov_1.518771_g11750_i0 PRJNA431371 11823 366 1.518771 5.55870186 Haliotis cracherodii 6455 Mollusca Mollusca 150 1.2e-31   NTclustered gi|2911810121|ref|XM_071238133.1| 6455 g11750 i0 78.423 7.02185792349727 241 44 65 6 102 338 560 324 PREDICTED: Haliotis cracherodii large ribosomal subunit protein uL23-like (LOC139456427), mRNA blastn 2570 150 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis cracherodii
2978795 2978795 PRJNA431371_P_NODE_19343_length_290_cov_2.534562_g19270_i0 PRJNA431371 19343 290 2.534562 7.3502298 Perna viridis 73031 Mollusca Mollusca 139 1.9999999999999997e-28   NTclustered gi|56967588|gb|AY850128.1| 73031 g19270 i0 91.262 0.355172413793103 103 8 36 1 1 103 66 167 Perna viridis clone GM8 microsatellite sequence blastn 103 139 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Perna Perna viridis
3639151 3639151 PRJNA431371_P_NODE_5103_length_528_cov_1.854945_g5030_i0 PRJNA431371 5103 528 1.854945 9.7941096 Metazoa 33208 Mollusca Mollusca 54.7 0.014   NTclustered gi|2334705242|ref|XM_052243844.1| 6549 g5030 i0 100 0.109848484848485 29 0 5 0 179 207 1060 1032 PREDICTED: Mytilus californianus uncharacterized LOC127734145 (LOC127734145), transcript variant X1, mRNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus californianus
4255399 4255399 PRJNA431371_P_NODE_3864_length_588_cov_2.376699_g3791_i0 PRJNA431371 3864 588 2.376699 13.97499012 Mytilus californianus 6549 Mollusca Mollusca 56.5 0.004   NTclustered gi|2334725129|ref|XM_052248596.1| 6549 g3791 i0 94.595 0.188775510204082 37 0 6 1 505 541 2696 2662 PREDICTED: Mytilus californianus glycogenin-1-like (LOC127737731), transcript variant X2, mRNA blastn 111 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus californianus
6805713 6805713 PRJNA431371_P_NODE_11886_length_365_cov_1.667808_g11813_i0 PRJNA431371 11886 365 1.667808 6.0874992 Mya arenaria 6604 Mollusca Mollusca 248 4.12e-61   NTclustered gi|2427367260|ref|XM_052910667.1| 6604 g11813 i0 79.32 13.7835616438356 353 73 97 0 1 353 322 674 PREDICTED: Mya arenaria ras-related protein Rab-1A (LOC128207630), mRNA blastn 5031 248 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
6805753 6805753 PRJNA431371_P_NODE_13606_length_344_cov_1.136531_g13533_i0 PRJNA431371 13606 344 1.136531 3.90966664 Mizuhopecten yessoensis 6573 Mollusca Mollusca 65.8 4.18e-6   NTclustered gi|1207930714|ref|XM_021498955.1| 6573 g13533 i0 97.368 0.302325581395349 38 1 11 0 5 42 910 947 PREDICTED: Mizuhopecten yessoensis uncharacterized LOC110451096 (LOC110451096), mRNA blastn 104 65.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
8081192 8081192 PRJNA431371_P_NODE_10427_length_387_cov_1.808917_g10354_i0 PRJNA431371 10427 387 1.808917 7.00050879 Bradybaena similaris 145626 Mollusca Mollusca 58.4 7.94e-4   NTclustered gi|2913001816|dbj|AP039609.1| 145626 g10354 i0 100 0.162790697674419 31 0 8 0 318 348 14577221 14577251 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence blastn 63 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
13181630 13181630 PRJNA431371_P_NODE_10731_length_382_cov_1.488673_g10658_i0 PRJNA431371 10731 382 1.488673 5.68673086 Bradybaena similaris 145626 Mollusca Mollusca 63.9 1.68e-5   NTclustered gi|2912999222|dbj|AP039605.1| 145626 g10658 i0 95.122 1.7303664921466 41 1 11 1 110 150 53597726 53597687 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence blastn 661 63.9 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
14456934 14456934 PRJNA431371_P_NODE_17092_length_310_cov_3.531646_g17019_i0 PRJNA431371 17092 310 3.531646 10.9481026 Mizuhopecten yessoensis 6573 Mollusca Mollusca 52.8 0.029   NTclustered gi|1207953555|ref|XM_021511204.1| 6573 g17019 i0 100 0.0903225806451613 28 0 9 0 17 44 3261 3288 PREDICTED: Mizuhopecten yessoensis uncharacterized LOC110459108 (LOC110459108), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
15730730 15730730 PRJNA431371_P_NODE_19393_length_290_cov_1.419355_g19320_i0 PRJNA431371 19393 290 1.419355 4.1161295 Perna viridis 73031 Mollusca Mollusca 106 2.03e-18   NTclustered gi|56967588|gb|AY850128.1| 73031 g19320 i0 98.361 0.210344827586207 61 0 21 1 231 290 198 138 Perna viridis clone GM8 microsatellite sequence blastn 61 106 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Perna Perna viridis
15731203 15731203 PRJNA431371_P_NODE_8753_length_419_cov_2.095376_g8680_i0 PRJNA431371 8753 419 2.095376 8.77962544 Mytilus edulis 6550 Mollusca Mollusca 52.8 0.04   NTclustered gi|2912333832|ref|XM_071280133.1| 6550 g8680 i0 100 1.67064439140811 28 0 7 0 69 96 8074 8101 PREDICTED: Mytilus edulis neuron navigator 2-like (LOC139492042), transcript variant X21, mRNA blastn 700 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
19554309 19554309 PRJNA431371_P_NODE_33956_length_243_cov_0.905882_g33883_i0 PRJNA431371 33956 243 0.905882 2.20129326 Mercenaria mercenaria 6596 Mollusca Mollusca 52.8 0.022   NTclustered gi|2442064162|ref|XM_053544458.1| 6596 g33883 i0 100 0.11522633744856 28 0 12 0 112 139 1557 1530 PREDICTED: Mercenaria mercenaria uncharacterized LOC123558144 (LOC123558144), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Mercenaria Mercenaria mercenaria
23380275 23380275 PRJNA431371_P_NODE_19979_length_286_cov_1.446009_g19906_i0 PRJNA431371 19979 286 1.446009 4.13558574 Haliotis rubra 36100 Mollusca Mollusca 56.5 0.002   NTclustered gi|2194123242|ref|XM_046717629.1| 36100 g19906 i0 96.97 7.57342657342657 33 1 12 0 203 235 1824 1856 PREDICTED: Haliotis rubra uncharacterized LOC124281679 (LOC124281679), transcript variant X1, mRNA blastn 2166 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rubra
23380670 23380670 PRJNA431371_P_NODE_5819_length_501_cov_1.259346_g5746_i0 PRJNA431371 5819 501 1.259346 6.30932346 Lottia gigantea 225164 Mollusca Mollusca 60.2 2.93e-4   NTclustered gi|676490373|ref|XM_009067000.1| 225164 g5746 i0 92.857 0.0838323353293413 42 1 8 2 169 209 74 34 Lottia gigantea hypothetical protein partial mRNA blastn 42 60.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
24654322 24654322 PRJNA431371_P_NODE_15360_length_326_cov_2.434783_g15287_i0 PRJNA431371 15360 326 2.434783 7.93739258 Bradybaena similaris 145626 Mollusca Mollusca 65.8 3.94e-6   NTclustered gi|2912983111|dbj|AP039588.1| 145626 g15287 i0 97.368 131.276073619632 38 1 14 0 66 103 69864009 69863972 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence blastn 42796 65.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris

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