RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1087264 · 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
4020654 4020654 PRJNA1087264_P_NODE_21164_length_161_cov_0.910714_g21082_i0 PRJNA1087264 21164 161 0.910714 1.46624954 Pecten maximus 6579 Mollusca Mollusca 54.7 0.004   NTclustered gi|1835527097|ref|XM_033896522.1| 6579 g21082 i0 100 0.180124223602484 29 0 18 0 112 140 4786 4814 PREDICTED: Pecten maximus zinc transporter 1-like (LOC117336138), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Pecten Pecten maximus
5296866 5296866 PRJNA1087264_P_NODE_4765_length_296_cov_1.327935_g4683_i0 PRJNA1087264 4765 296 1.327935 3.9306876 Aplysia californica 6500 Mollusca Mollusca 239 1.97e-58   NTclustered gi|1897938828|ref|XM_013087923.2| 6500 g4683 i0 82.593 62.6047297297297 270 47 91 0 1 270 1653 1384 PREDICTED: Aplysia californica ATP-dependent RNA helicase cgh-1 (LOC101857439), mRNA blastn 18531 239 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
10397338 10397338 PRJNA1087264_P_NODE_13529_length_171_cov_1.254098_g13447_i0 PRJNA1087264 13529 171 1.254098 2.14450758 Haliotis asinina 109174 Mollusca Mollusca 56.5 0.001   NTclustered gi|2793425074|ref|XM_067825802.1| 109174 g13447 i0 94.444 1.98245614035088 36 2 21 0 128 163 5110 5075 PREDICTED: Haliotis asinina transcriptional-regulating factor 1-like (LOC137294721), transcript variant X2, mRNA blastn 339 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis asinina
14222754 14222754 PRJNA1087264_P_NODE_19592_length_163_cov_0.894737_g19510_i0 PRJNA1087264 19592 163 0.894737 1.45842131 Haliotis asinina 109174 Mollusca Mollusca 76.8 8.06e-10   NTclustered gi|2793396553|ref|XM_067810220.1| 109174 g19510 i0 86.765 0.846625766871166 68 9 42 0 5 72 733 666 PREDICTED: Haliotis asinina eukaryotic translation elongation factor 2-like (LOC137278102), mRNA blastn 138 76.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis asinina
16770981 16770981 PRJNA1087264_P_NODE_16514_length_165_cov_1.413793_g16432_i0 PRJNA1087264 16514 165 1.413793 2.33275845 Biomphalaria glabrata 6526 Mollusca Mollusca 60.2 8.25e-5   NTclustered gi|2502134919|ref|XM_056013775.1| 6526 g16432 i0 100 1.11515151515152 32 0 19 0 78 109 233 264 PREDICTED: Biomphalaria glabrata guanine nucleotide-binding protein-like 3 homolog (LOC106077405), transcript variant X5, mRNA blastn 184 60.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Biomphalaria Biomphalaria glabrata
23146226 23146226 PRJNA1087264_P_NODE_18079_length_164_cov_0.886957_g17997_i0 PRJNA1087264 18079 164 0.886957 1.45460948 Bradybaena similaris 145626 Mollusca Mollusca 71.3 3.78e-8   NTclustered gi|2912999747|dbj|AP039606.1| 145626 g17997 i0 86.364 28.6524390243902 66 7 39 2 91 154 5621272 5621207 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence blastn 4699 71.3 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
24419836 24419836 PRJNA1087264_P_NODE_13020_length_175_cov_1.047619_g12938_i0 PRJNA1087264 13020 175 1.047619 1.83333325 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.015   NTclustered gi|2912986657|dbj|AP039591.1| 145626 g12938 i0 100 0.48 28 0 16 0 135 162 7803863 7803890 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris

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