RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA436017 · 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
430989 430989 PRJNA436017_P_NODE_6681_length_345_cov_29.405844_g6384_i0 PRJNA436017 6681 345 29.405844 101.4501618 Physella acuta 109671 Mollusca Mollusca 632 9.17e-177   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g6384 i0 99.71 4.27246376811594 345 1 100 0 1 345 3749 3405 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 1474 632 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
8083994 8083994 PRJNA436017_P_NODE_18027_length_193_cov_1.480769_g17729_i0 PRJNA436017 18027 193 1.480769 2.85788417 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.005   NTclustered gi|2912999747|dbj|AP039606.1| 145626 g17729 i0 100 0.150259067357513 29 0 15 0 97 125 19922455 19922483 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
11292246 11292246 PRJNA436017_P_NODE_25929_length_160_cov_1.268293_g25631_i0 PRJNA436017 25929 160 1.268293 2.0292688 Metazoa 33208 Mollusca Mollusca 296 5.55e-76   NTclustered gi|1928112764|gb|MT947788.1| 6523 g25631 i0 100 99.975 160 0 100 0 1 160 618 777 Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds blastn 15996 296 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis
12567974 12567974 PRJNA436017_P_NODE_9550_length_281_cov_1.356557_g9252_i0 PRJNA436017 9550 281 1.356557 3.81192517 Metazoa 33208 Mollusca Mollusca 520 5.909999999999999e-143   NTclustered gi|1928112764|gb|MT947788.1| 6523 g9252 i0 100 99.7224199288256 281 0 100 0 1 281 36 316 Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds blastn 28022 520 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis
13184682 13184682 PRJNA436017_P_NODE_7471_length_325_cov_1.652778_g7174_i0 PRJNA436017 7471 325 1.652778 5.3715285 Octopus sinensis 2607531 Mollusca Mollusca 187 8.02e-43   NTclustered gi|1697450084|ref|XM_029784716.1| 2607531 g7174 i0 84.946 52.5384615384615 186 26 57 2 1 185 143 327 PREDICTED: Octopus sinensis histone H3.3-like (LOC115215535), mRNA blastn 17075 187 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus sinensis
13842664 13842664 PRJNA436017_P_NODE_851_length_997_cov_12.428125_g713_i0 PRJNA436017 851 997 12.428125 123.90840625 Metazoa 33208 Mollusca Mollusca 206 7.33e-48   NTclustered gi|2022611928|dbj|LC597644.1| 6613 g713 i0 86.885 18.3309929789368 183 24 18 0 112 294 1975 1793 Euprymna scolopes 2020GS-euscolo gene for 28S rRNA, partial sequence blastn 18276 206 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Sepiida Sepiolidae Euprymna Euprymna scolopes
25315224 25315224 PRJNA436017_P_NODE_24820_length_164_cov_1.141732_g24522_i0 PRJNA436017 24820 164 1.141732 1.87244048 Octopoda 6638 Mollusca Mollusca 255 9.72e-64   NTclustered gi|2217048103|gb|ON156549.1| 61709 g24522 i0 100 84.9512195121951 138 0 84 0 27 164 35 172 Bolitaena pygmaea isolate A200083 small subunit ribosomal RNA gene, partial sequence blastn 13932 255 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Bolitaenidae Bolitaena Bolitaena pygmaea

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