RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA688736 · 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
5771950 5771950 PRJNA688736_P_NODE_9085_length_493_cov_3.092857_g8801_i0 PRJNA688736 9085 493 3.092857 15.24778501 Dreissena polymorpha 45954 Mollusca Mollusca 268 4.39e-67   NTclustered gi|2364448524|ref|XM_052423941.1| 45954 g8801 i0 79.73 3.71602434077079 370 75 75 0 1 370 412 781 PREDICTED: Dreissena polymorpha 40S ribosomal protein S3 (LOC127877747), mRNA blastn 1832 268 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Dreissenidae Dreissena Dreissena polymorpha
10106470 10106470 PRJNA688736_P_NODE_47728_length_245_cov_0.906977_g47443_i0 PRJNA688736 47728 245 0.906977 2.22209365 Octopus 6643 Mollusca Mollusca 121 5.98e-23   NTclustered gi|2427292506|ref|XM_014928752.2| 37653 g47443 i0 80.745 5.99591836734694 161 25 64 4 1 158 439 282 PREDICTED: Octopus bimaculoides ubiquitin-conjugating enzyme E2 2 (LOC106879255), partial mRNA blastn 1469 121 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus bimaculoides
14696397 14696397 PRJNA688736_P_NODE_19512_length_352_cov_1.802867_g19227_i0 PRJNA688736 19512 352 1.802867 6.34609184 Aplysia californica 6500 Mollusca Mollusca 220 8.62e-53   NTclustered gi|1897920247|ref|XM_013080928.2| 6500 g19227 i0 78.448 9.34943181818182 348 67 98 8 1 344 360 17 PREDICTED: Aplysia californica 40S ribosomal protein S24 (LOC101858016), transcript variant X1, mRNA blastn 3291 220 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
15971034 15971034 PRJNA688736_P_NODE_8153_length_518_cov_4.689888_g7870_i0 PRJNA688736 8153 518 4.689888 24.29361984 Littorina saxatilis 31220 Mollusca Mollusca 342 2.69e-89   NTclustered gi|2868613863|ref|XM_070321082.1| 31220 g7870 i0 81.265 58.3899613899614 427 76 82 4 65 489 82 506 PREDICTED: Littorina saxatilis small ribosomal subunit protein uS19-like (LOC138949293), mRNA blastn 30246 342 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
18519517 18519517 PRJNA688736_P_NODE_18475_length_361_cov_1.041667_g18190_i0 PRJNA688736 18475 361 1.041667 3.76041787 Pomacea canaliculata 400727 Mollusca Mollusca 84.2 1.21e-11   NTclustered gi|1397662513|ref|XM_025227528.1| 400727 g18190 i0 90.476 0.349030470914127 63 6 17 0 9 71 481 543 PREDICTED: Pomacea canaliculata ATP synthase lipid-binding protein, mitochondrial-like (LOC112557579), transcript variant X2, mRNA blastn 126 84.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Architaenioglossa Ampullariidae Pomacea Pomacea canaliculata
19029525 19029525 PRJNA688736_P_NODE_47755_length_245_cov_0.906977_g47470_i0 PRJNA688736 47755 245 0.906977 2.22209365 Mytilus 6548 Mollusca Mollusca 150 7.62e-32   NTclustered gi|2334685673|ref|XM_052239314.1| 6549 g47470 i0 82.123 39.3183673469388 179 28 71 2 8 182 813 635 PREDICTED: Mytilus californianus endoplasmic reticulum chaperone BiP-like (LOC127730768), mRNA blastn 9633 150 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus californianus
22854627 22854627 PRJNA688736_P_NODE_21378_length_339_cov_1.857143_g21093_i0 PRJNA688736 21378 339 1.857143 6.29571477 Ostreidae 6563 Mollusca Mollusca 183 1.0899999999999998e-41   NTclustered gi|2751294070|ref|XM_020068887.3| 29159 g21093 i0 78.116 76.737463126843707 329 44 95 16 17 337 26 334 PREDICTED: Magallana gigas small ribosomal subunit protein uS5 (LOC105332191), mRNA blastn 26014 183 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);;