RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA672101" 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

  • PRJNA672101 · 7 ✖

analysis 1

  • diamond · 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
26808946 26808946 PRJNA672101_S_NODE_9881_length_349_cov_4.032609_g9850_i0 PRJNA672101 9881 349 4.032609 14.07380541 Metazoa 33208 Mollusca Mollusca 123 1.0799999999999999e-32   NR NP_001298203.1 6526 g9850 i0 62.1 14.7507163323782 95 34 81.7 2 345 61 99 191 NP_001298203.1 ras-related C3 botulinum toxin substrate 1 [Biomphalaria glabrata] diamond 5148 123 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Biomphalaria Biomphalaria glabrata
27378408 27378408 PRJNA672101_S_NODE_13823_length_319_cov_5.308943_g13792_i0 PRJNA672101 13823 319 5.308943 16.93552817 Patella 6463 Mollusca Mollusca 61.2 2.95e-8   NR XP_050409853.1 6465 g13792 i0 46.3 2.51097178683386 80 36 74.3 2 80 316 376 449 XP_050409853.1 oxysterol-binding protein 1 isoform X2 [Patella vulgata] diamond 801 61.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
28818311 28818311 PRJNA672101_S_NODE_20608_length_282_cov_9.598086_g20577_i0 PRJNA672101 20608 282 9.598086 27.06660252 Haliotis asinina 109174 Mollusca Mollusca 43.5 0.0296   NR XP_067657806.1 109174 g20577 i0 35.4 1.36170212765957 65 36 68.1 2 217 26 144 203 XP_067657806.1 uncharacterized protein [Haliotis asinina] diamond 384 43.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis asinina
30081586 30081586 PRJNA672101_S_NODE_9312_length_354_cov_4.384342_g9281_i0 PRJNA672101 9312 354 4.384342 15.52057068 Ostrea edulis 37623 Mollusca Mollusca 104 2.4699999999999994e-23   NR XP_048766942.2 37623 g9281 i0 51.9 0.898305084745763 106 51 89.8 0 352 35 743 848 XP_048766942.2 major vault protein-like [Ostrea edulis] diamond 318 104 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Ostrea Ostrea edulis
31073227 31073227 PRJNA672101_S_NODE_7335_length_374_cov_5.116279_g7304_i0 PRJNA672101 7335 374 5.116279 19.13488346 root 1 Root_unresolved Root_unresolved 133 9.539999999999999e-34   NR XP_021361175.1 6573 g7304 i0 52.3 5.98395721925134 128 52 99.5 4 374 3 395 517 XP_021361175.1 putative aminopeptidase W07G4.4 isoform X1 [Mizuhopecten yessoensis] diamond 2238 133 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
31345781 31345781 PRJNA672101_S_NODE_23136_length_271_cov_3.358586_g23105_i0 PRJNA672101 23136 271 3.358586 9.10176806 Batillaria attramentaria 370345 Mollusca Mollusca 90.5 8.6e-21   NR KAK7450082.1 370345 g23105 i0 57.3 2.72324723247232 82 34 90.8 1 3 248 63 143 KAK7450082.1 hypothetical protein BaRGS_00039983 [Batillaria attramentaria] diamond 738 90.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Batillariidae Batillaria Batillaria attramentaria
31788291 31788291 PRJNA672101_S_NODE_25177_length_263_cov_3.352632_g25146_i0 PRJNA672101 25177 263 3.352632 8.81742216 Haliotis asinina 109174 Mollusca Mollusca 52 2.58e-5   NR XP_067663859.1 109174 g25146 i0 67.7 0.35361216730038 31 10 35.4 0 249 157 219 249 XP_067663859.1 uncharacterized protein NMB1327-like [Haliotis asinina] diamond 93 52 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis asinina

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