RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA902848" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA902848 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
1247154 1247154 PRJNA902848_P_NODE_8821_length_300_cov_1.797357_g8771_i0 PRJNA902848 8821 300 1.797357 5.392071 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 324 5.36e-84   NTclustered gi|2427418402|ref|XM_052927352.1| 6604 g8771 i0 86.242 99.15 298 41 99 0 3 300 108 405 PREDICTED: Mya arenaria tubulin beta chain-like (LOC128219534), mRNA blastn 29745 327 0.990825688073395 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
3432888 3432888 PRJNA902848_P_NODE_923_length_688_cov_26.328455_g877_i0 PRJNA902848 923 688 26.328455 181.1397704 Physella acuta 109671 Mollusca Mollusca 1227 0   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g877 i0 98.837 42.8808139534884 688 8 100 0 1 688 1899 2586 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 29502 1227 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
5985256 5985256 PRJNA902848_P_NODE_165_length_1281_cov_5.458609_g144_i0 PRJNA902848 165 1281 5.458609 69.92478129 Mizuhopecten yessoensis 6573 Mollusca Mollusca 87.9 3.59e-12   NTclustered gi|1207941491|ref|XM_021504762.1| 6573 g144 i0 94.643 0.238875878220141 56 3 4 0 259 314 252 197 PREDICTED: Mizuhopecten yessoensis neuropeptide-like protein 29 (LOC110454942), mRNA blastn 306 87.9 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
7260275 7260275 PRJNA902848_P_NODE_7926_length_312_cov_7.347280_g7876_i0 PRJNA902848 7926 312 7.34728 22.9235136 Physella acuta 109671 Mollusca Mollusca 555 1.8199999999999994e-153   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g7876 i0 98.718 4.53846153846154 312 4 100 0 1 312 3405 3716 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 1416 555 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
10175673 10175673 PRJNA902848_P_NODE_5768_length_353_cov_0.960714_g5718_i0 PRJNA902848 5768 353 0.960714 3.39132042 Mytilus 6548 Mollusca Mollusca 174 6.83e-39   NTclustered gi|2334803060|ref|XM_052219055.1| 6549 g5718 i0 76.803 3.61473087818697 319 69 90 5 35 350 449 765 PREDICTED: Mytilus californianus fructose-bisphosphate aldolase-like (LOC127712554), transcript variant X1, mRNA blastn 1276 174 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus californianus
10175727 10175727 PRJNA902848_P_NODE_8808_length_300_cov_11.704846_g8758_i0 PRJNA902848 8808 300 11.704846 35.114538 Metazoa 33208 Mollusca Mollusca 555 1.7399999999999995e-153   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g8758 i0 100 54.0566666666667 300 0 100 0 1 300 1526 1825 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 16217 555 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
16184744 16184744 PRJNA902848_P_NODE_15633_length_249_cov_0.886364_g15583_i0 PRJNA902848 15633 249 0.886364 2.20704636 Littorina saxatilis 31220 Mollusca Mollusca 150 7.77e-32   NTclustered gi|2868614015|ref|XM_070321681.1| 31220 g15583 i0 79.524 8.09638554216867 210 43 84 0 3 212 326 117 PREDICTED: Littorina saxatilis eukaryotic translation elongation factor 2-like (LOC138949893), mRNA blastn 2016 150 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
20008740 20008740 PRJNA902848_P_NODE_4676_length_380_cov_2.530945_g4626_i0 PRJNA902848 4676 380 2.530945 9.6175909999999991 Magallana gigas 29159 Mollusca Mollusca 303 9.06e-78   NTclustered gi|2751229756|ref|XM_034453253.2| 29159 g4626 i0 81.167 37.4210526315789 377 71 99 0 3 379 706 330 PREDICTED: Magallana gigas tubulin alpha-1A chain (LOC105329348), mRNA blastn 14220 303 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana gigas
21284139 21284139 PRJNA902848_P_NODE_8097_length_310_cov_1.316456_g8047_i0 PRJNA902848 8097 310 1.316456 4.0810136 Lottia gigantea 225164 Mollusca Mollusca 346 1.19e-90   NTclustered gi|676476747|ref|XM_009062645.1| 225164 g8047 i0 89.963 64.5225806451613 269 26 87 1 38 306 344 77 Lottia gigantea hypothetical protein partial mRNA blastn 20002 346 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
22558799 22558799 PRJNA902848_P_NODE_14538_length_251_cov_0.876404_g14488_i0 PRJNA902848 14538 251 0.876404 2.19977404 Mytilus trossulus 6551 Mollusca Mollusca 248 2.7e-61   NTclustered gi|2694002732|ref|XM_063566204.1| 6551 g14488 i0 85.185 90.9641434262948 243 34 96 2 10 251 488 247 PREDICTED: Mytilus trossulus tubulin alpha-1A chain (LOC134706872), mRNA blastn 22832 248 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus trossulus
25108035 25108035 PRJNA902848_P_NODE_18680_length_244_cov_0.912281_g18630_i0 PRJNA902848 18680 244 0.912281 2.22596564 Patella vulgata 6465 Mollusca Mollusca 220 5.699999999999998e-53   NTclustered gi|2296482255|ref|XM_050548424.1| 6465 g18630 i0 84.444 4.04918032786885 225 34 92 1 16 240 1152 929 PREDICTED: Patella vulgata 26S proteasome regulatory subunit 4 (LOC126820441), mRNA blastn 988 220 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata

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