RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA407886 · 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
418160 418160 PRJNA407886_P_NODE_80801_length_242_cov_0.911243_g79107_i0 PRJNA407886 80801 242 0.911243 2.20520806 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.022   NTclustered gi|2912992646|dbj|AP039597.1| 145626 g79107 i0 100 0.115702479338843 28 0 12 0 215 242 51873181 51873208 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
1082420 1082420 PRJNA407886_P_NODE_59161_length_276_cov_2.458128_g57467_i0 PRJNA407886 59161 276 2.458128 6.78443328 Opisthokonta 33154 Mollusca Mollusca 54.7 0.007   NTclustered gi|2912404344|ref|XM_071315010.1| 6550 g57467 i0 96.875 0.463768115942029 32 1 12 0 10 41 554 523 PREDICTED: Mytilus edulis uncharacterized protein (LOC139521535), mRNA blastn 128 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
2358060 2358060 PRJNA407886_P_NODE_78322_length_244_cov_0.900585_g76628_i0 PRJNA407886 78322 244 0.900585 2.1974274 Opisthokonta 33154 Mollusca Mollusca 239 1.57e-58   NTclustered gi|2245697241|ref|XM_046515848.2| 6454 g76628 i0 84.426 97.0081967213115 244 36 99 2 2 244 422 180 PREDICTED: Haliotis rufescens 40S ribosomal protein S23 (LOC124145891), mRNA blastn 23670 239 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rufescens
2967738 2967738 PRJNA407886_P_NODE_22283_length_523_cov_3.086667_g20595_i0 PRJNA407886 22283 523 3.086667 16.14326841 Bradybaena similaris 145626 Mollusca Mollusca 58.4 0.001   NTclustered gi|2912984370|dbj|AP039589.1| 145626 g20595 i0 97.059 0.131931166347992 34 1 7 0 287 320 34231816 34231849 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence blastn 69 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
4245164 4245164 PRJNA407886_P_NODE_76564_length_245_cov_1.069767_g74870_i0 PRJNA407886 76564 245 1.069767 2.62092915 Lottia goshimai 1824450 Mollusca Mollusca 172 1.63e-38   NTclustered gi|2159309633|gb|MZ822426.1| 1824450 g74870 i0 85.207 69.6408163265306 169 23 69 2 5 172 792 625 Lottia goshimai Hsp90a mRNA, partial cds blastn 17062 172 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia goshimai
8070415 8070415 PRJNA407886_P_NODE_28527_length_432_cov_3.311978_g26834_i0 PRJNA407886 28527 432 3.311978 14.30774496 Bradybaena similaris 145626 Mollusca Mollusca 58.4 8.96e-4   NTclustered gi|2912991694|dbj|AP039596.1| 145626 g26834 i0 94.737 1.65046296296296 38 1 9 1 297 334 52222900 52222936 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence blastn 713 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
8070769 8070769 PRJNA407886_P_NODE_45867_length_320_cov_1.246964_g44173_i0 PRJNA407886 45867 320 1.246964 3.9902848 Bradybaena similaris 145626 Mollusca Mollusca 67.6 1.07e-6   NTclustered gi|2912999747|dbj|AP039606.1| 145626 g44173 i0 76.224 6.63125 143 24 43 9 180 317 23374826 23374689 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence blastn 2122 67.6 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
9345190 9345190 PRJNA407886_P_NODE_23228_length_507_cov_2.433180_g21537_i0 PRJNA407886 23228 507 2.43318 12.3362226 Mya arenaria 6604 Mollusca Mollusca 54.7 0.014   NTclustered gi|2427413949|ref|XM_052925871.1| 6604 g21537 i0 100 0.0571992110453649 29 0 6 0 332 360 7704 7732 PREDICTED: Mya arenaria uncharacterized LOC128218256 (LOC128218256), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
9345584 9345584 PRJNA407886_P_NODE_43148_length_331_cov_1.790698_g41454_i0 PRJNA407886 43148 331 1.790698 5.92721038 Patella vulgata 6465 Mollusca Mollusca 298 3.63e-76   NTclustered gi|2506338579|ref|XM_050556681.2| 6465 g41454 i0 85.971 81.0151057401813 278 39 84 0 54 331 1423 1146 PREDICTED: Patella vulgata tubulin beta chain (LOC126827387), mRNA blastn 26816 298 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
11896447 11896447 PRJNA407886_P_NODE_51190_length_300_cov_1.356828_g49496_i0 PRJNA407886 51190 300 1.356828 4.070484 Physella acuta 109671 Mollusca Mollusca 172 2.05e-38   NTclustered gi|2572374663|ref|XM_059310370.1| 109671 g49496 i0 79.508 6.66666666666667 244 48 81 2 9 251 160 402 PREDICTED: Physella acuta dynein light chain 2, cytoplasmic (LOC131948703), mRNA blastn 2000 172 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
14446237 14446237 PRJNA407886_P_NODE_37672_length_359_cov_3.139860_g35978_i0 PRJNA407886 37672 359 3.13986 11.2720974 Bradybaena similaris 145626 Mollusca Mollusca 62.1 5.65e-5   NTclustered gi|2912981848|dbj|AP039587.1| 145626 g35978 i0 91.304 0.596100278551532 46 2 13 2 195 239 10117922 10117966 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence blastn 214 62.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
15720306 15720306 PRJNA407886_P_NODE_52713_length_295_cov_1.630631_g51019_i0 PRJNA407886 52713 295 1.630631 4.81036145 Patella vulgata 6465 Mollusca Mollusca 318 2.439999999999999e-82   NTclustered gi|2506343157|ref|XM_050561934.2| 6465 g51019 i0 86.102 81.0338983050847 295 41 100 0 1 295 868 1162 PREDICTED: Patella vulgata ATP synthase subunit beta, mitochondrial (LOC126831451), mRNA blastn 23905 318 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
15720698 15720698 PRJNA407886_P_NODE_71773_length_249_cov_1.568182_g70079_i0 PRJNA407886 71773 249 1.568182 3.90477318 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.006   NTclustered gi|2912999222|dbj|AP039605.1| 145626 g70079 i0 90.476 0.168674698795181 42 3 16 1 59 99 7267635 7267676 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence blastn 42 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
16994647 16994647 PRJNA407886_P_NODE_29274_length_425_cov_1.556818_g27581_i0 PRJNA407886 29274 425 1.556818 6.6164765 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.041   NTclustered gi|2912986657|dbj|AP039591.1| 145626 g27581 i0 100 0.0658823529411765 28 0 7 0 354 381 63846267 63846294 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
18269525 18269525 PRJNA407886_P_NODE_66995_length_257_cov_1.456522_g65301_i0 PRJNA407886 66995 257 1.456522 3.74326154 Aplysia californica 6500 Mollusca Mollusca 60.2 1.4e-4   NTclustered gi|1897945022|ref|XM_035973569.1| 6500 g65301 i0 100 2.8443579766537 32 0 12 0 190 221 1407 1376 PREDICTED: Aplysia californica uncharacterized LOC118479020 (LOC118479020), mRNA blastn 731 60.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
22758934 22758934 PRJNA407886_P_NODE_26558_length_456_cov_4.065274_g24866_i0 PRJNA407886 26558 456 4.065274 18.53764944 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 52.8 0.044   NTclustered gi|2912986657|dbj|AP039591.1| 145626 g24866 i0 100 0.736842105263158 28 0 6 0 67 94 54730112 54730139 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence blastn 336 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
23369879 23369879 PRJNA407886_P_NODE_61859_length_269_cov_2.147959_g60165_i0 PRJNA407886 61859 269 2.147959 5.77800971 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.025   NTclustered gi|2912994531|dbj|AP039599.1| 145626 g60165 i0 100 0.104089219330855 28 0 10 0 20 47 18797772 18797745 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
24644057 24644057 PRJNA407886_P_NODE_57000_length_282_cov_2.119617_g55306_i0 PRJNA407886 57000 282 2.119617 5.97731994 Ostrea edulis 37623 Mollusca Mollusca 52.8 0.026   NTclustered gi|2507397783|ref|XM_056166154.1| 37623 g55306 i0 96.875 0.113475177304965 32 0 11 1 136 166 853 822 PREDICTED: Ostrea edulis nucleoprotein TPR-like (LOC130055008), mRNA blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Ostrea Ostrea edulis

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