RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA577580" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA577580 · 12 ✖

analysis 1

  • blastn · 12 ✖
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
3115006 3115006 PRJNA577580_P_NODE_7523_length_328_cov_3.796078_g7445_i0 PRJNA577580 7523 328 3.796078 12.45113584 Mercenaria mercenaria 6596 Mollusca Mollusca 191 6.27e-44   NTclustered gi|2442017659|ref|XM_053527748.1| 6596 g7445 i0 90.845 34.8993902439024 142 13 43 0 187 328 266 125 PREDICTED: Mercenaria mercenaria 60S ribosomal protein L27a-like (LOC128549953), mRNA blastn 11447 191 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Mercenaria Mercenaria mercenaria
4391481 4391481 PRJNA577580_P_NODE_15184_length_246_cov_1.838150_g15106_i0 PRJNA577580 15184 246 1.83815 4.521849 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.006   NTclustered gi|2913001038|dbj|AP039608.1| 145626 g15106 i0 100 0.117886178861789 29 0 12 0 65 93 9147465 9147493 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
6942183 6942183 PRJNA577580_P_NODE_14026_length_251_cov_0.876404_g13948_i0 PRJNA577580 14026 251 0.876404 2.19977404 Sinonovacula constricta 98310 Mollusca Mollusca 52.8 0.023   NTclustered gi|937961735|gb|KR534869.1| 98310 g13948 i0 100 0.111553784860558 28 0 11 0 1 28 5 32 Sinonovacula constricta insulin-like peptide 1 mRNA, complete cds blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Cardiida Solecurtidae Sinonovacula Sinonovacula constricta
6942233 6942233 PRJNA577580_P_NODE_3686_length_469_cov_2.449495_g3608_i0 PRJNA577580 3686 469 2.449495 11.48813155 Patella vulgata 6465 Mollusca Mollusca 278 6.91e-70   NTclustered gi|2506338579|ref|XM_050556681.2| 6465 g3608 i0 83.117 63.2643923240938 308 48 65 4 13 318 1123 1428 PREDICTED: Patella vulgata tubulin beta chain (LOC126827387), mRNA blastn 29671 278 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
10768306 10768306 PRJNA577580_P_NODE_1809_length_676_cov_7.402985_g1734_i0 PRJNA577580 1809 676 7.402985 50.0441786 Crepidula atrasolea 136598 Mollusca Mollusca 63.9 3.11e-5   NTclustered gi|2717312343|gb|PP639288.1| 136598 g1734 i0 80.46 0.128698224852071 87 13 13 4 226 310 867 951 Crepidula atrasolea hypothetical protein (Ca202986) mRNA, complete cds blastn 87 63.9 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Calyptraeidae Crepidula Crepidula atrasolea
12043092 12043092 PRJNA577580_P_NODE_14290_length_250_cov_0.881356_g14212_i0 PRJNA577580 14290 250 0.881356 2.20339 Bradybaena similaris 145626 Mollusca Mollusca 56.5 0.002   NTclustered gi|2912987826|dbj|AP039592.1| 145626 g14212 i0 96.97 0.36 33 1 13 0 33 65 18180274 18180306 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence blastn 90 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
12043141 12043141 PRJNA577580_P_NODE_4070_length_446_cov_2.882038_g3992_i0 PRJNA577580 4070 446 2.882038 12.85388948 Magallana angulata 2784310 Mollusca Mollusca 52.8 0.043   NTclustered gi|2416963886|ref|XM_052821160.1| 2784310 g3992 i0 100 0.062780269058296 28 0 6 0 264 291 314 341 PREDICTED: Crassostrea angulata selenoprotein K-like (LOC128158368), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana angulata
12617162 12617162 PRJNA577580_P_NODE_2990_length_520_cov_4.689038_g2912_i0 PRJNA577580 2990 520 4.689038 24.3829976 Metazoa 33208 Mollusca Mollusca 200 1.72e-46   NTclustered gi|2572299341|ref|XM_059292545.1| 109671 g2912 i0 76.289 27.6615384615385 388 84 74 8 104 487 145 528 PREDICTED: Physella acuta large ribosomal subunit protein uL15-like (LOC131935845), mRNA blastn 14384 202 0.99009900990099 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
12617174 12617174 PRJNA577580_P_NODE_7230_length_335_cov_1.156489_g7152_i0 PRJNA577580 7230 335 1.156489 3.87423815 Opisthokonta 33154 Mollusca Mollusca 268 2.8799999999999994e-67   NTclustered gi|2502189327|ref|XM_013241676.2| 6526 g7152 i0 82.781 84.5313432835821 302 51 90 1 34 335 1421 1121 PREDICTED: Biomphalaria glabrata tubulin beta-4B chain (LOC106080335), mRNA blastn 28318 268 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Biomphalaria Biomphalaria glabrata
13318070 13318070 PRJNA577580_P_NODE_8271_length_315_cov_1.289256_g8193_i0 PRJNA577580 8271 315 1.289256 4.0611564 Ceratophallus sp. cea 2664637 Mollusca Mollusca 158 6.069999999999999e-34   NTclustered gi|1772640093|gb|MN644829.1| 2664637 g8193 i0 91.379 36.9333333333333 116 8 37 2 142 257 2725 2838 Ceratophallus sp. cea 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 11634 158 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Ceratophallus Ceratophallus sp. cea
18415929 18415929 PRJNA577580_P_NODE_1915_length_656_cov_9.248714_g1839_i0 PRJNA577580 1915 656 9.248714 60.67156384 Gigantopelta aegis 1735272 Mollusca Mollusca 311 9.75e-80   NTclustered gi|2034270288|ref|XM_041523278.1| 1735272 g1839 i0 79.907 27.0457317073171 428 82 65 4 175 600 59 484 PREDICTED: Gigantopelta aegis NADH-quinone oxidoreductase subunit B-like (LOC121391767), mRNA blastn 17742 311 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Neomphalida Peltospiridae Gigantopelta Gigantopelta aegis
22241197 22241197 PRJNA577580_P_NODE_9898_length_291_cov_1.431193_g9820_i0 PRJNA577580 9898 291 1.431193 4.16477163 Lottia gigantea 225164 Mollusca Mollusca 246 1.1499999999999999e-60   NTclustered gi|676435893|ref|XM_009049457.1| 225164 g9820 i0 82.5 9.85223367697595 280 49 96 0 11 290 1213 934 Lottia gigantea hypothetical protein mRNA blastn 2867 246 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea

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