RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA685060" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA685060 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
1942104 1942104 PRJNA685060_P_NODE_12182_length_266_cov_1.575130_g12092_i0 PRJNA685060 12182 266 1.57513 4.1898458 Octopus bimaculoides 37653 Mollusca Mollusca 52.8 0.024   NTclustered gi|2427235429|ref|XM_052966718.1| 37653 g12092 i0 100 0.105263157894737 28 0 11 0 6 33 260 287 PREDICTED: Octopus bimaculoides putative protein TPRXL (LOC128247366), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus bimaculoides
13420151 13420151 PRJNA685060_P_NODE_4351_length_465_cov_45.752551_g4261_i0 PRJNA685060 4351 465 45.752551 212.74936215 Mollusca environmental sample 653389 Mollusca Mollusca 370 1.0999999999999998e-97   NTclustered gi|156254524|gb|EF528299.1| 653389 g4261 i0 82.227 73.1333333333333 467 48 100 20 1 465 1005 572 Uncultured mollusc isolate XenLSU7 28S ribosomal RNA gene, partial sequence blastn 34007 370 1 Eukaryota Opisthokonta Metazoa Mollusca         Mollusca environmental sample
15968909 15968909 PRJNA685060_P_NODE_6813_length_365_cov_1.215753_g6723_i0 PRJNA685060 6813 365 1.215753 4.43749845 Littorina saxatilis 31220 Mollusca Mollusca 71.3 9.56e-8   NTclustered gi|2868657957|ref|XM_070331727.1| 31220 g6723 i0 100 10.5616438356164 38 0 10 0 1 38 4218 4181 PREDICTED: Littorina saxatilis uncharacterized protein (LOC138960009), mRNA blastn 3855 71.3 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
16478869 16478869 PRJNA685060_P_NODE_3793_length_499_cov_2.053991_g3703_i0 PRJNA685060 3793 499 2.053991 10.24941509 Opisthokonta 33154 Mollusca Mollusca 52.8 0.049   NTclustered gi|2912994531|dbj|AP039599.1| 145626 g3703 i0 96.774 0.118236472945892 31 1 6 0 356 386 40117386 40117356 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence blastn 59 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
19793170 19793170 PRJNA685060_P_NODE_9676_length_305_cov_1.228448_g9586_i0 PRJNA685060 9676 305 1.228448 3.7467664 Bradybaena similaris 145626 Mollusca Mollusca 58.4 6.11e-4   NTclustered gi|2912988862|dbj|AP039593.1| 145626 g9586 i0 100 0.40655737704918 31 0 10 0 237 267 4320849 4320819 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence blastn 124 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
22853464 22853464 PRJNA685060_P_NODE_17818_length_237_cov_2.701220_g17728_i0 PRJNA685060 17818 237 2.70122 6.4018914 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 56.5 0.002   NTclustered gi|1897944213|ref|XM_005112234.3| 6500 g17728 i0 96.97 2.32911392405063 33 1 14 0 203 235 1058 1026 PREDICTED: Aplysia californica uncharacterized LOC101846108 (LOC101846108), partial mRNA blastn 552 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
24892303 24892303 PRJNA685060_P_NODE_2760_length_594_cov_3.416507_g2670_i0 PRJNA685060 2760 594 3.416507 20.29405158 Littorina saxatilis 31220 Mollusca Mollusca 272 4.14e-68   NTclustered gi|2868688207|ref|XM_070347684.1| 31220 g2670 i0 82.838 44.0942760942761 303 52 51 0 150 452 828 526 PREDICTED: Littorina saxatilis protein yippee-like 1 (LOC138975036), transcript variant X1, mRNA blastn 26192 272 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis

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