RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA793147" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA793147 · 12 ✖

analysis 1

  • blastn · 12 ✖
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
3329350 3329350 PRJNA793147_P_NODE_57603_length_229_cov_2.187500_g57337_i0 PRJNA793147 57603 229 2.1875 5.009375 Mercenaria mercenaria 6596 Mollusca Mollusca 111 3.32e-20   NTclustered gi|2441985233|ref|XM_045314418.2| 6596 g57337 i0 85.714 0.458515283842795 105 15 46 0 65 169 413 309 PREDICTED: Mercenaria mercenaria 10 kDa heat shock protein, mitochondrial-like (LOC123532834), mRNA blastn 105 111 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Mercenaria Mercenaria mercenaria
8868930 8868930 PRJNA793147_P_NODE_14327_length_449_cov_4.221053_g14061_i0 PRJNA793147 14327 449 4.221053 18.95252797 Metazoa 33208 Mollusca Mollusca 824 0   NTclustered gi|1928112764|gb|MT947788.1| 6523 g14061 i0 99.777 100 449 1 100 0 1 449 648 200 Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds blastn 44900 830 0.992771084337349 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis
12257739 12257739 PRJNA793147_P_NODE_56390_length_230_cov_2.211180_g56124_i0 PRJNA793147 56390 230 2.21118 5.085714 Lottia gigantea 225164 Mollusca Mollusca 204 5.36e-48   NTclustered gi|676446650|ref|XM_009052902.1| 225164 g56124 i0 83.111 72.1521739130435 225 36 97 2 1 224 1098 1321 Lottia gigantea hypothetical protein mRNA blastn 16595 204 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
13969803 13969803 PRJNA793147_P_NODE_31451_length_298_cov_4.030568_g31185_i0 PRJNA793147 31451 298 4.030568 12.01109264 Metazoa 33208 Mollusca Mollusca 54.7 0.008   NTclustered gi|2669119147|ref|XM_062736641.1| 36930 g31185 i0 100 0.194630872483221 29 0 10 0 64 92 2353 2381 PREDICTED: Saccostrea cucullata uncharacterized LOC134254077 (LOC134254077), mRNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Saccostrea Saccostrea cuccullata
14806844 14806844 PRJNA793147_P_NODE_59552_length_228_cov_0.905660_g59286_i0 PRJNA793147 59552 228 0.90566 2.0649048 Physella acuta 109671 Mollusca Mollusca 121 5.49e-23   NTclustered gi|2572279296|ref|XM_059304615.1| 109671 g59286 i0 82.963 13.2675438596491 135 21 59 2 93 226 1034 1167 PREDICTED: Physella acuta serine/threonine-protein kinase PAK 1-like (LOC131944104), transcript variant X1, mRNA blastn 3025 121 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
14806929 14806929 PRJNA793147_P_NODE_63112_length_218_cov_3.322148_g62846_i0 PRJNA793147 63112 218 3.322148 7.24228264 Mytilus californianus 6549 Mollusca Mollusca 180 8.47e-41   NTclustered gi|2334776642|ref|XM_052212780.1| 6549 g62846 i0 84.324 26.7201834862385 185 27 84 1 24 206 220 36 PREDICTED: Mytilus californianus actin, cytoplasmic-like (LOC127707993), mRNA blastn 5825 180 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus californianus
16080530 16080530 PRJNA793147_P_NODE_48433_length_241_cov_1.674419_g48167_i0 PRJNA793147 48433 241 1.674419 4.03534979 Patella vulgata 6465 Mollusca Mollusca 182 2.65e-41   NTclustered gi|2296460196|ref|XM_050539233.1| 6465 g48167 i0 80.952 62.6058091286307 231 42 95 2 12 241 627 398 PREDICTED: Patella vulgata tubulin beta chain (LOC126814220), transcript variant X1, mRNA blastn 15088 182 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
17355739 17355739 PRJNA793147_P_NODE_16454_length_415_cov_59.387283_g16188_i0 PRJNA793147 16454 415 59.387283 246.45722445 Aplysia californica 6500 Mollusca Mollusca 156 2.96e-33   NTclustered gi|871245195|ref|XM_005102366.2| 6500 g16188 i0 83.432 1.42168674698795 169 27 41 1 201 369 686 853 PREDICTED: Aplysia californica helicase SRCAP-like (LOC101860347), mRNA blastn 590 156 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
17356686 17356686 PRJNA793147_P_NODE_6974_length_676_cov_3.186161_g6719_i0 PRJNA793147 6974 676 3.186161 21.53844836 Lottia gigantea 225164 Mollusca Mollusca 392 3.499999999999999e-104   NTclustered gi|676438731|ref|XM_009050379.1| 225164 g6719 i0 78.606 86.6686390532544 617 114 90 17 61 668 1299 692 Lottia gigantea hypothetical protein mRNA blastn 58588 392 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
22454713 22454713 PRJNA793147_P_NODE_1598_length_1509_cov_9.304167_g1500_i0 PRJNA793147 1598 1509 9.304167 140.39988003 Lottia gigantea 225164 Mollusca Mollusca 1083 0   NTclustered gi|676441193|ref|XM_009051169.1| 225164 g1500 i0 81.164 88.8482438701127 1375 236 90 20 140 1502 1549 186 Lottia gigantea hypothetical protein mRNA blastn 134072 1083 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
23730242 23730242 PRJNA793147_P_NODE_12659_length_482_cov_26.290557_g12393_i0 PRJNA793147 12659 482 26.290557 126.72048474 Haliotis asinina 109174 Mollusca Mollusca 215 5.66e-51   NTclustered gi|2793421121|ref|XM_067823659.1| 109174 g12393 i0 80.882 7.24273858921162 272 52 56 0 65 336 61 332 PREDICTED: Haliotis asinina histone H2A-like (LOC137292118), mRNA blastn 3491 215 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis asinina
23730855 23730855 PRJNA793147_P_NODE_48699_length_240_cov_2.526316_g48433_i0 PRJNA793147 48699 240 2.526316 6.0631584 Haliotis rubra 36100 Mollusca Mollusca 163 9.56e-36   NTclustered gi|2194150179|ref|XM_046687699.1| 36100 g48433 i0 79.574 7.99583333333333 235 42 96 6 8 238 3766 3534 PREDICTED: Haliotis rubra splicing factor 3B subunit 1-like (LOC124253848), mRNA blastn 1919 163 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rubra

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