RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJNA508758" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA508758 · 18 ✖

analysis 1

  • blastn · 18 ✖
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
484746 484746 PRJNA508758_P_NODE_6281_length_945_cov_1.521789_g3820_i1 PRJNA508758 6281 945 1.521789 14.38090605 Mya arenaria 6604 Mollusca Mollusca 54.7 0.027   NTclustered gi|2427467042|ref|XM_052939866.1| 6604 g3820 i1 100 0.0613756613756614 29 0 3 0 387 415 938 966 PREDICTED: Mya arenaria cell division control protein 42 homolog (LOC128228518), transcript variant X1, mRNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
6862119 6862119 PRJNA508758_P_NODE_11506_length_623_cov_13.492727_g458_i2 PRJNA508758 11506 623 13.492727 84.05968921 Littorina saxatilis 31220 Mollusca Mollusca 132 7.72e-26   NTclustered gi|2868688207|ref|XM_070347684.1| 31220 g458 i2 94.186 9.24719101123596 86 5 14 0 133 218 743 828 PREDICTED: Littorina saxatilis protein yippee-like 1 (LOC138975036), transcript variant X1, mRNA blastn 5761 132 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
6862656 6862656 PRJNA508758_P_NODE_76026_length_250_cov_0.870056_g74978_i0 PRJNA508758 76026 250 0.870056 2.17514 Mytilus californianus 6549 Mollusca Mollusca 244 3.48e-60   NTclustered gi|2334673389|ref|XM_052235946.1| 6549 g74978 i0 84.677 96.028 248 35 99 3 4 250 692 447 PREDICTED: Mytilus californianus tubulin alpha-1A chain-like (LOC127728525), mRNA blastn 24007 244 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus californianus
8137522 8137522 PRJNA508758_P_NODE_21367_length_434_cov_84.121884_g20320_i0 PRJNA508758 21367 434 84.121884 365.08897656 Physella acuta 109671 Mollusca Mollusca 682 0   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g20320 i0 94.977 4.62672811059908 438 16 100 6 1 434 3763 3328 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 2008 682 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
8137848 8137848 PRJNA508758_P_NODE_61847_length_274_cov_1.293532_g60799_i0 PRJNA508758 61847 274 1.293532 3.54427768 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.025   NTclustered gi|2912991694|dbj|AP039596.1| 145626 g60799 i0 100 0.102189781021898 28 0 10 0 91 118 49631240 49631267 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
9412850 9412850 PRJNA508758_P_NODE_56268_length_285_cov_2.160377_g55220_i0 PRJNA508758 56268 285 2.160377 6.15707445 Littorina saxatilis 31220 Mollusca Mollusca 56.5 0.002   NTclustered gi|2868662896|ref|XM_070355586.1| 31220 g55220 i0 96.97 4.74736842105263 33 1 12 0 107 139 2749 2781 PREDICTED: Littorina saxatilis uncharacterized protein (LOC138982332), transcript variant X2, mRNA blastn 1353 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
11963468 11963468 PRJNA508758_P_NODE_5890_length_985_cov_3.410088_g5131_i0 PRJNA508758 5890 985 3.410088 33.5893668 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.028   NTclustered gi|2912994531|dbj|AP039599.1| 145626 g5131 i0 100 0.0294416243654822 29 0 3 0 41 69 43221999 43221971 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
13238637 13238637 PRJNA508758_P_NODE_57171_length_284_cov_1.023697_g56123_i0 PRJNA508758 57171 284 1.023697 2.90729948 Patella vulgata 6465 Mollusca Mollusca 60.2 1.57e-4   NTclustered gi|2506321935|ref|XM_050543738.2| 6465 g56123 i0 97.143 0.225352112676056 35 1 12 0 236 270 2065 2031 PREDICTED: Patella vulgata zinc finger protein 836 (LOC126816945), mRNA blastn 64 60.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
14513776 14513776 PRJNA508758_P_NODE_74332_length_251_cov_0.865169_g73284_i0 PRJNA508758 74332 251 0.865169 2.17157419 Bradybaena similaris 145626 Mollusca Mollusca 58.4 4.89e-4   NTclustered gi|2912998015|dbj|AP039603.1| 145626 g73284 i0 100 0.239043824701195 31 0 12 0 187 217 21250860 21250890 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence blastn 60 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
15787109 15787109 PRJNA508758_P_NODE_17473_length_484_cov_1.987835_g16426_i0 PRJNA508758 17473 484 1.987835 9.6211214 Bradybaena similaris 145626 Mollusca Mollusca 63.9 2.18e-5   NTclustered gi|2912993551|dbj|AP039598.1| 145626 g16426 i0 97.297 13.0206611570248 37 1 8 0 151 187 27551149 27551113 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence blastn 6302 63.9 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
16413367 16413367 PRJNA508758_P_NODE_71413_length_255_cov_1.686813_g70365_i0 PRJNA508758 71413 255 1.686813 4.30137315 Metazoa 33208 Mollusca Mollusca 60.2 1.38e-4   NTclustered gi|1207924698|ref|XM_021495736.1| 6573 g70365 i0 92.683 1.05098039215686 41 3 16 0 23 63 2023 1983 PREDICTED: Mizuhopecten yessoensis zinc finger protein 728-like (LOC110449106), mRNA blastn 268 60.2 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
18336306 18336306 PRJNA508758_P_NODE_4375_length_1180_cov_2.161698_g3820_i0 PRJNA508758 4375 1180 2.161698 25.5080364 Mya arenaria 6604 Mollusca Mollusca 54.7 0.033   NTclustered gi|2427467042|ref|XM_052939866.1| 6604 g3820 i0 100 0.0491525423728814 29 0 2 0 622 650 938 966 PREDICTED: Mya arenaria cell division control protein 42 homolog (LOC128228518), transcript variant X1, mRNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
19610647 19610647 PRJNA508758_P_NODE_48856_length_303_cov_1.339130_g47808_i0 PRJNA508758 48856 303 1.33913 4.0575639 Bradybaena similaris 145626 Mollusca Mollusca 62.1 4.69e-5   NTclustered gi|2912984370|dbj|AP039589.1| 145626 g47808 i0 100 7.27062706270627 33 0 11 0 187 219 55269442 55269474 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence blastn 2203 62.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
22161268 22161268 PRJNA508758_P_NODE_3158_length_1437_cov_3.947947_g2749_i0 PRJNA508758 3158 1437 3.947947 56.73199839 Patella vulgata 6465 Mollusca Mollusca 71.3 4.07e-7   NTclustered gi|2506321935|ref|XM_050543738.2| 6465 g2749 i0 88.525 0.41892832289492 61 4 4 3 1001 1060 2089 2031 PREDICTED: Patella vulgata zinc finger protein 836 (LOC126816945), mRNA blastn 602 71.3 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
22161439 22161439 PRJNA508758_P_NODE_538_length_2972_cov_27.995171_g458_i0 PRJNA508758 538 2972 27.995171 832.01648212 Littorina saxatilis 31220 Mollusca Mollusca 272 2.1799999999999998e-67   NTclustered gi|2868688207|ref|XM_070347684.1| 31220 g458 i0 82.838 8.90915208613728 303 52 10 0 2265 2567 526 828 PREDICTED: Littorina saxatilis protein yippee-like 1 (LOC138975036), transcript variant X1, mRNA blastn 26478 272 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
23436914 23436914 PRJNA508758_P_NODE_25439_length_398_cov_3.033846_g24391_i0 PRJNA508758 25439 398 3.033846 12.07470708 Bradybaena similaris 145626 Mollusca Mollusca 58.4 8.19e-4   NTclustered gi|2912994531|dbj|AP039599.1| 145626 g24391 i0 100 0.150753768844221 31 0 8 0 316 346 12868526 12868556 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence blastn 60 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
24710556 24710556 PRJNA508758_P_NODE_39560_length_331_cov_0.895349_g38512_i0 PRJNA508758 39560 331 0.895349 2.96360519 Bradybaena similaris 145626 Mollusca Mollusca 60.2 1.86e-4   NTclustered gi|2912991694|dbj|AP039596.1| 145626 g38512 i0 92.857 0.126888217522659 42 2 13 1 286 327 49631227 49631267 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence blastn 42 60.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
24710703 24710703 PRJNA508758_P_NODE_58960_length_280_cov_1.130435_g57912_i0 PRJNA508758 58960 280 1.130435 3.165218 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.026   NTclustered gi|2912981848|dbj|AP039587.1| 145626 g57912 i0 100 0.1 28 0 10 0 184 211 51847101 51847074 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence blastn 28 52.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);;