RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA473641" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA473641 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
1719970 1719970 PRJNA473641_P_NODE_24762_length_242_cov_0.911243_g24679_i0 PRJNA473641 24762 242 0.911243 2.20520806 Haliotis asinina 109174 Mollusca Mollusca 52.8 0.022   NTclustered gi|2793372167|ref|XM_067797417.1| 109174 g24679 i0 100 0.115702479338843 28 0 12 0 14 41 1194 1221 PREDICTED: Haliotis asinina thioredoxin domain-containing protein-like (LOC137259801), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis asinina
8097925 8097925 PRJNA473641_P_NODE_13767_length_279_cov_1.014563_g13684_i0 PRJNA473641 13767 279 1.014563 2.83063077 Mya arenaria 6604 Mollusca Mollusca 54.7 0.007   NTclustered gi|2427486998|ref|XM_052947381.1| 6604 g13684 i0 100 0.405017921146953 29 0 10 0 109 137 711 739 PREDICTED: Mya arenaria calponin homolog OV9M-like (LOC128233620), mRNA blastn 113 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
8097966 8097966 PRJNA473641_P_NODE_15227_length_266_cov_1.056995_g15144_i0 PRJNA473641 15227 266 1.056995 2.8116067 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.024   NTclustered gi|2912992646|dbj|AP039597.1| 145626 g15144 i0 100 0.105263157894737 28 0 11 0 209 236 48676555 48676582 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
9372877 9372877 PRJNA473641_P_NODE_24168_length_243_cov_0.905882_g24085_i0 PRJNA473641 24168 243 0.905882 2.20129326 Patella caerulea 87958 Mollusca Mollusca 255 1.5600000000000001e-63   NTclustered gi|669205829|gb|KF494230.1| 87958 g24085 i0 85.833 81.2098765432099 240 34 99 0 1 240 558 797 Patella caerulea beta-tubulin mRNA, partial cds blastn 19734 255 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella caerulea
14473740 14473740 PRJNA473641_P_NODE_24412_length_243_cov_0.905882_g24329_i0 PRJNA473641 24412 243 0.905882 2.20129326 Gigantopelta aegis 1735272 Mollusca Mollusca 54.7 0.006   NTclustered gi|2034330529|ref|XM_041507349.1| 1735272 g24329 i0 96.875 0.263374485596708 32 1 13 0 60 91 2741 2710 PREDICTED: Gigantopelta aegis acyl-coenzyme A synthetase ACSM3, mitochondrial-like (LOC121378952), transcript variant X1, mRNA blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Neomphalida Peltospiridae Gigantopelta Gigantopelta aegis
20846722 20846722 PRJNA473641_P_NODE_23777_length_243_cov_0.905882_g23694_i0 PRJNA473641 23777 243 0.905882 2.20129326 Bradybaena similaris 145626 Mollusca Mollusca 62.1 3.64e-5   NTclustered gi|2912990805|dbj|AP039595.1| 145626 g23694 i0 89.583 0.197530864197531 48 5 20 0 149 196 5670876 5670829 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence blastn 48 62.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
23397048 23397048 PRJNA473641_P_NODE_13919_length_277_cov_1.509804_g13836_i0 PRJNA473641 13919 277 1.509804 4.18215708 Physella acuta 109671 Mollusca Mollusca 239 1.82e-58   NTclustered gi|2572417298|ref|XM_059322395.1| 109671 g13836 i0 85.59 33.4837545126354 229 32 82 1 1 228 842 1070 PREDICTED: Physella acuta serine/threonine-protein phosphatase alpha-2 isoform (LOC131957656), transcript variant X2, mRNA blastn 9275 239 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta

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