RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA939415" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA939415 · 14 ✖

analysis 1

  • blastn · 14 ✖
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
915640 915640 PRJNA939415_P_NODE_50801_length_283_cov_1.461905_g50379_i0 PRJNA939415 50801 283 1.461905 4.13719115 Haliotis rubra 36100 Mollusca Mollusca 154 6.96e-33   NTclustered gi|2194133745|ref|XM_046722902.1| 36100 g50379 i0 80.093 67.6325088339223 216 35 75 8 12 223 1230 1441 PREDICTED: Haliotis rubra phenylalanine--tRNA ligase alpha subunit-like (LOC124286536), mRNA blastn 19140 154 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rubra
915696 915696 PRJNA939415_P_NODE_54621_length_279_cov_2.019417_g54199_i0 PRJNA939415 54621 279 2.019417 5.63417343 Bradybaena similaris 145626 Mollusca Mollusca 200 8.67e-47   NTclustered gi|2913002568|dbj|AP039611.1| 145626 g54199 i0 80.303 18.7598566308244 264 52 95 0 16 279 774609 774346 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored2, sequence blastn 5234 200 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
2191579 2191579 PRJNA939415_P_NODE_79302_length_254_cov_4.801105_g78880_i0 PRJNA939415 79302 254 4.801105 12.194806700000001 Bradybaena similaris 145626 Mollusca Mollusca 219 2.1499999999999998e-52   NTclustered gi|2912981848|dbj|AP039587.1| 145626 g78880 i0 93.289 19.3346456692913 149 9 91 1 21 168 37320424 37320572 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence blastn 4911 219 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
8569336 8569336 PRJNA939415_P_NODE_90947_length_244_cov_16.853801_g90525_i0 PRJNA939415 90947 244 16.853801 41.12327444 Magallana angulata 2784310 Mollusca Mollusca 449 6.68e-122   NTclustered gi|2416874841|ref|XR_008241671.1| 2784310 g90525 i0 100 71.3893442622951 243 0 99 0 1 243 3534 3776 PREDICTED: Crassostrea angulata large subunit ribosomal RNA (LOC128170120), rRNA blastn 17419 449 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana angulata
9843974 9843974 PRJNA939415_P_NODE_68248_length_265_cov_3.729167_g67826_i0 PRJNA939415 68248 265 3.729167 9.88229255 Haliotis rufescens 6454 Mollusca Mollusca 355 1.6499999999999996e-93   NTclustered gi|2245733845|ref|XM_046501044.2| 6454 g67826 i0 91.288 0.99622641509434 264 18 99 2 2 265 4639 4897 PREDICTED: Haliotis rufescens extensin-1-like (LOC124135626), mRNA blastn 264 355 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rufescens
12735596 12735596 PRJNA939415_P_NODE_103510_length_229_cov_4.070513_g103088_i0 PRJNA939415 103510 229 4.070513 9.32147477 Magallana 147004 Mollusca Mollusca 424 3.76e-114   NTclustered gi|28375710|dbj|AB102757.1| 29159 g103088 i0 100 100.008733624454 229 0 100 0 1 229 2802 3030 Crassostrea gigas genes for ITS2, 28S rRNA, partial sequence, country: Japan: Okinawa (Haneji inland sea) blastn 22902 424 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana gigas
14010200 14010200 PRJNA939415_P_NODE_106571_length_222_cov_4.570470_g106149_i0 PRJNA939415 106571 222 4.57047 10.1464434 Ostreidae 6563 Mollusca Mollusca 411 2.8199999999999996e-110   NTclustered gi|1843197836|ref|XR_004597991.1| 29159 g106149 i0 100 99.9954954954955 222 0 100 0 1 222 369 148 PREDICTED: Magallana gigas small subunit ribosomal RNA (LOC117684133), rRNA blastn 22199 411 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana gigas
17494574 17494574 PRJNA939415_P_NODE_84654_length_250_cov_0.870056_g84232_i0 PRJNA939415 84654 250 0.870056 2.17514 Biomphalaria glabrata 6526 Mollusca Mollusca 235 2.09e-57   NTclustered gi|257286307|gb|AC236507.3| 6526 g84232 i0 84.706 26.284 255 17 98 13 7 250 2404 2161 Biomphalaria glabrata BAC clone BG_BBa-11G10 from chromosome unknown, complete sequence blastn 6571 235 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Biomphalaria Biomphalaria glabrata
17833934 17833934 PRJNA939415_P_NODE_34634_length_309_cov_3.516949_g34212_i0 PRJNA939415 34634 309 3.516949 10.86737241 Magallana 147004 Mollusca Mollusca 571 1.7899999999999995e-158   NTclustered gi|2087356261|dbj|LC648604.1| 29159 g34212 i0 100 100.142394822006 309 0 100 0 1 309 221 529 Crassostrea gigas IDEA_Shell201 gene for 28S rRNA, partial sequence blastn 30944 571 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana gigas
20042189 20042189 PRJNA939415_P_NODE_44636_length_289_cov_1.750000_g44214_i0 PRJNA939415 44636 289 1.75 5.0575 Mizuhopecten yessoensis 6573 Mollusca Mollusca 60.2 1.6e-4   NTclustered gi|1207921812|ref|XM_021494198.1| 6573 g44214 i0 85.965 0.197231833910035 57 6 19 2 211 266 4872 4927 PREDICTED: Mizuhopecten yessoensis histone-lysine N-methyltransferase SETD1B-A-like (LOC110448131), mRNA blastn 57 60.2 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
22593384 22593384 PRJNA939415_P_NODE_90238_length_245_cov_2.651163_g89816_i0 PRJNA939415 90238 245 2.651163 6.49534935 Bradybaena similaris 145626 Mollusca Mollusca 189 1.62e-43   NTclustered gi|2912992646|dbj|AP039597.1| 145626 g89816 i0 86.441 25.8448979591837 177 18 70 5 1 171 1781869 1781693 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence blastn 6332 189 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
22934453 22934453 PRJNA939415_P_NODE_65658_length_268_cov_2.271795_g65236_i0 PRJNA939415 65658 268 2.271795 6.0884106 Magallana 147004 Mollusca Mollusca 496 9.429999999999999e-136   NTclustered gi|1832334954|gb|MT353676.1| 29159 g65236 i0 100 94.9328358208955 268 0 100 0 1 268 914 647 Crassostrea gigas isolate 3155 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 25442 496 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana gigas
23868601 23868601 PRJNA939415_P_NODE_77739_length_256_cov_2.814208_g77317_i0 PRJNA939415 77739 256 2.814208 7.20437248 Dreissena polymorpha 45954 Mollusca Mollusca 63.9 1.08e-5   NTclustered gi|2364358319|ref|XM_052394270.1| 45954 g77317 i0 97.297 10.875 37 1 14 0 220 256 1948 1912 PREDICTED: Dreissena polymorpha zinc finger protein ZFP2-like (LOC127857679), transcript variant X2, mRNA blastn 2784 63.9 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Dreissenidae Dreissena Dreissena polymorpha
25483304 25483304 PRJNA939415_P_NODE_80380_length_253_cov_3.950000_g79958_i0 PRJNA939415 80380 253 3.95 9.9935 Magallana 147004 Mollusca Mollusca 457 4.16e-124   NTclustered gi|28375710|dbj|AB102757.1| 29159 g79958 i0 99.209 100.114624505929 253 2 100 0 1 253 840 1092 Crassostrea gigas genes for ITS2, 28S rRNA, partial sequence, country: Japan: Okinawa (Haneji inland sea) blastn 25329 457 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana gigas

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