RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA657343 · 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
1899234 1899234 PRJNA657343_P_NODE_35482_length_169_cov_0.866667_g35458_i0 PRJNA657343 35482 169 0.866667 1.46466723 Bradybaena similaris 145626 Mollusca Mollusca 152 1.35e-32   NTclustered gi|2912981848|dbj|AP039587.1| 145626 g35458 i0 86.331 5.61538461538461 139 19 82 0 27 165 43396590 43396728 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence blastn 949 152 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
1899264 1899264 PRJNA657343_P_NODE_3762_length_386_cov_1.439169_g3739_i0 PRJNA657343 3762 386 1.439169 5.55519234 Lottia austrodigitalis 244422 Mollusca Mollusca 339 2.5299999999999996e-88   NTclustered gi|34484254|gb|AY303385.1| 244422 g3739 i0 83.243 81.0569948186529 370 60 96 2 14 382 1181 813 Lottia austrodigitalis sodium/potassium ATPase alpha subunit mRNA, partial cds blastn 31288 339 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia austrodigitalis
3173710 3173710 PRJNA657343_P_NODE_16583_length_222_cov_2.300578_g16559_i0 PRJNA657343 16583 222 2.300578 5.10728316 Bradybaena similaris 145626 Mollusca Mollusca 56.5 0.002   NTclustered gi|2912999222|dbj|AP039605.1| 145626 g16559 i0 100 6.54954954954955 30 0 14 0 118 147 23580654 23580683 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence blastn 1454 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
3173982 3173982 PRJNA657343_P_NODE_38743_length_166_cov_1.333333_g38719_i0 PRJNA657343 38743 166 1.333333 2.21333278 Gigantopelta aegis 1735272 Mollusca Mollusca 139 1.04e-28   NTclustered gi|2034270288|ref|XM_041523278.1| 1735272 g38719 i0 82.692 3.6566265060241 156 27 94 0 5 160 121 276 PREDICTED: Gigantopelta aegis NADH-quinone oxidoreductase subunit B-like (LOC121391767), mRNA blastn 607 139 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Neomphalida Peltospiridae Gigantopelta Gigantopelta aegis
5726379 5726379 PRJNA657343_P_NODE_23065_length_196_cov_3.312925_g23041_i0 PRJNA657343 23065 196 3.312925 6.493333 Lottia gigantea 225164 Mollusca Mollusca 195 2.66e-45   NTclustered gi|676473711|ref|XM_009061660.1| 225164 g23041 i0 87.5 51.6887755102041 168 21 86 0 4 171 1208 1375 Lottia gigantea hypothetical protein mRNA blastn 10131 195 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
8276035 8276035 PRJNA657343_P_NODE_10267_length_265_cov_4.032407_g10243_i0 PRJNA657343 10267 265 4.032407 10.68587855 Patella vulgata 6465 Mollusca Mollusca 303 6.06e-78   NTclustered gi|2506342739|ref|XM_050562691.2| 6465 g10243 i0 88.189 91.3433962264151 254 30 96 0 10 263 429 176 PREDICTED: Patella vulgata tubulin alpha-3 chain (LOC126832007), mRNA blastn 24206 303 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
9551442 9551442 PRJNA657343_P_NODE_17288_length_219_cov_1.300000_g17264_i0 PRJNA657343 17288 219 1.3 2.847 Patella vulgata 6465 Mollusca Mollusca 198 2.35e-46   NTclustered gi|2506345316|ref|XM_050562402.2| 6465 g17264 i0 84.5 38.5433789954338 200 31 91 0 2 201 428 627 PREDICTED: Patella vulgata 26S proteasome regulatory subunit 8 (LOC126831748), mRNA blastn 8441 198 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
15925870 15925870 PRJNA657343_P_NODE_24133_length_193_cov_1.993056_g24109_i0 PRJNA657343 24133 193 1.993056 3.84659808 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.017   NTclustered gi|2912999747|dbj|AP039606.1| 145626 g24109 i0 100 0.145077720207254 28 0 15 0 83 110 3765940 3765913 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
15926975 15926975 PRJNA657343_S_NODE_27873_length_169_cov_0.866667_g27848_i0 PRJNA657343 27873 169 0.866667 1.46466723 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.004   NTclustered gi|2913000417|dbj|AP039607.1| 145626 g27848 i0 96.875 0.378698224852071 32 1 19 0 21 52 8068736 8068705 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
17201259 17201259 PRJNA657343_P_NODE_7834_length_293_cov_3.475410_g7810_i0 PRJNA657343 7834 293 3.47541 10.1829513 Lottia gigantea 225164 Mollusca Mollusca 340 5.1799999999999996e-89   NTclustered gi|676453046|ref|XM_009054981.1| 225164 g7810 i0 87.671 92.1365187713311 292 36 99 0 1 292 136 427 Lottia gigantea hypothetical protein mRNA blastn 26996 340 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
19749980 19749980 PRJNA657343_P_NODE_34356_length_170_cov_1.363636_g34332_i0 PRJNA657343 34356 170 1.363636 2.3181812 Lottia gigantea 225164 Mollusca Mollusca 180 6.25e-41   NTclustered gi|676441220|ref|XM_009051178.1| 225164 g34332 i0 89.928 80.6588235294118 139 14 82 0 7 145 1320 1458 Lottia gigantea hypothetical protein mRNA blastn 13712 180 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
19750196 19750196 PRJNA657343_P_NODE_9496_length_273_cov_2.727679_g9472_i0 PRJNA657343 9496 273 2.727679 7.44656367 Lottia gigantea 225164 Mollusca Mollusca 150 8.639999999999998e-32   NTclustered gi|676441211|ref|XM_009051175.1| 225164 g9472 i0 86.765 44.7472527472527 136 17 49 1 15 149 1332 1467 Lottia gigantea hypothetical protein mRNA blastn 12216 150 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);;