RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA376117 · 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
399775 399775 PRJNA376117_P_NODE_20681_length_304_cov_1.129870_g20379_i0 PRJNA376117 20681 304 1.12987 3.4348048 Bradybaena similaris 145626 Mollusca Mollusca 128 4.58e-25   NTclustered gi|2912995509|dbj|AP039600.1| 145626 g20379 i0 77.83 9.2796052631579 212 44 70 2 91 302 63361482 63361690 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence blastn 2821 128 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
400167 400167 PRJNA376117_P_NODE_44721_length_241_cov_0.886905_g44419_i0 PRJNA376117 44721 241 0.886905 2.13744105 Lottia gigantea 225164 Mollusca Mollusca 228 3.3599999999999994e-55   NTclustered gi|676489107|ref|XM_009066582.1| 225164 g44419 i0 85.135 77.5892116182573 222 33 92 0 7 228 927 706 Lottia gigantea hypothetical protein partial mRNA blastn 18699 228 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
4227099 4227099 PRJNA376117_P_NODE_32764_length_254_cov_2.116022_g32462_i0 PRJNA376117 32764 254 2.116022 5.37469588 Mizuhopecten yessoensis 6573 Mollusca Mollusca 189 1.6799999999999996e-43   NTclustered gi|1207937899|ref|XM_021502813.1| 6573 g32462 i0 87.654 62.9251968503937 162 20 64 0 65 226 19 180 PREDICTED: Mizuhopecten yessoensis 60S ribosomal protein L27a-like (LOC110453724), mRNA blastn 15983 189 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
4901526 4901526 PRJNA376117_P_NODE_13264_length_374_cov_1.514950_g12962_i0 PRJNA376117 13264 374 1.51495 5.665913 Opisthokonta 33154 Mollusca Mollusca 58.4 7.65e-4   NTclustered gi|2507359615|ref|XM_056155776.1| 37623 g12962 i0 100 1.01871657754011 31 0 8 0 5 35 370 400 PREDICTED: Ostrea edulis zinc finger CCHC domain-containing protein 10-like (LOC125681632), mRNA blastn 381 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Ostrea Ostrea edulis
5503294 5503294 PRJNA376117_P_NODE_17425_length_330_cov_2.369650_g17123_i0 PRJNA376117 17425 330 2.36965 7.819845 Physella acuta 109671 Mollusca Mollusca 52.8 0.031   NTclustered gi|2572418058|ref|XM_059322633.1| 109671 g17123 i0 100 0.0848484848484849 28 0 8 0 60 87 3460 3433 PREDICTED: Physella acuta uncharacterized LOC131957830 (LOC131957830), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
8053421 8053421 PRJNA376117_P_NODE_9307_length_440_cov_66.953678_g9005_i0 PRJNA376117 9307 440 66.953678 294.5961832 Physella acuta 109671 Mollusca Mollusca 797 0   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g9005 i0 99.318 4.98636363636364 440 3 100 0 1 440 3759 3320 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 2194 797 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
13153746 13153746 PRJNA376117_P_NODE_35891_length_249_cov_1.017045_g35589_i0 PRJNA376117 35891 249 1.017045 2.5324420499999998 Bradybaena similaris 145626 Mollusca Mollusca 56.5 0.002   NTclustered gi|2912987826|dbj|AP039592.1| 145626 g35589 i0 96.97 3.79116465863454 33 1 13 0 76 108 42408878 42408846 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence blastn 944 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
14428660 14428660 PRJNA376117_P_NODE_3272_length_782_cov_1.878702_g2995_i0 PRJNA376117 3272 782 1.878702 14.69144964 Mytilus edulis 6550 Mollusca Mollusca 497 8.38e-136   NTclustered gi|2912325331|ref|XM_071288074.1| 6550 g2995 i0 78.389 91.2736572890026 782 157 99 10 1 776 861 1636 PREDICTED: Mytilus edulis tubulin alpha-1A chain-like (LOC139499393), mRNA blastn 71376 497 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
18251260 18251260 PRJNA376117_P_NODE_10495_length_415_cov_1.716374_g10193_i0 PRJNA376117 10495 415 1.716374 7.1229521 Mercenaria mercenaria 6596 Mollusca Mollusca 267 1.31e-66   NTclustered gi|2441991191|ref|XM_053519753.1| 6596 g10193 i0 84.906 42.7975903614458 265 38 64 2 84 347 443 180 PREDICTED: Mercenaria mercenaria dynein light chain 1, cytoplasmic-like (LOC123533746), transcript variant X1, mRNA blastn 17761 267 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Mercenaria Mercenaria mercenaria
18251429 18251429 PRJNA376117_P_NODE_23555_length_287_cov_2.088785_g23253_i0 PRJNA376117 23555 287 2.088785 5.99481295 Lottia gigantea 225164 Mollusca Mollusca 174 5.4299999999999997e-39   NTclustered gi|676428519|ref|XM_009047054.1| 225164 g23253 i0 88.435 48.1428571428571 147 14 50 3 1 144 1294 1440 Lottia gigantea hypothetical protein mRNA blastn 13817 174 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
20801118 20801118 PRJNA376117_P_NODE_11057_length_405_cov_2.554217_g10755_i0 PRJNA376117 11057 405 2.554217 10.34457885 Magallana angulata 2784310 Mollusca Mollusca 69.4 3.86e-7   NTclustered gi|2416977037|ref|XM_052828112.1| 2784310 g10755 i0 84.932 0.958024691358025 73 5 17 4 315 381 2186 2258 PREDICTED: Crassostrea angulata fibroin heavy chain-like (LOC128164320), mRNA blastn 388 69.4 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana angulata

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