RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA597223" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA597223 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
4397077 4397077 PRJNA597223_P_NODE_74224_length_165_cov_1.130769_g72378_i0 PRJNA597223 74224 165 1.130769 1.86576885 Metazoa 33208 Mollusca Mollusca 79.7 3.26e-16   NR XP_052219903.1 45954 g72378 i0 77.4 3.92727272727273 53 12 96.4 0 159 1 86 138 XP_052219903.1 60S ribosomal protein L7a-like [Dreissena polymorpha] diamond 648 80.1 0.995006242197254 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Dreissenidae Dreissena Dreissena polymorpha
17147223 17147223 PRJNA597223_P_NODE_81494_length_156_cov_1.677686_g79648_i0 PRJNA597223 81494 156 1.677686 2.61719016 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 84 3.32e-17   NR BFZ05575.1 145626 g79648 i0 86.4 18.9807692307692 44 6 84.6 0 133 2 37 80 BFZ05575.1 hypothetical protein BsWGS_08614 [Bradybaena similaris] diamond 2961 84.3 0.99644128113879 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
26731282 26731282 PRJNA597223_P_NODE_9981_length_548_cov_18.514620_g8333_i0 PRJNA597223 9981 548 18.51462 101.4601176 Mytilus coruscus 42192 Mollusca Mollusca 97.8 8.650000000000001e-21   NR CAC5411093.1 42192 g8333 i0 42.7 7.56569343065693 124 70 67.3 1 377 9 89 212 CAC5411093.1 unnamed protein product [Mytilus coruscus] diamond 4146 97.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus coruscus
26795048 26795048 PRJNA597223_P_NODE_37701_length_235_cov_2.305000_g35855_i0 PRJNA597223 37701 235 2.305 5.41675 Pomacea canaliculata 400727 Mollusca Mollusca 69.3 1.42e-11   NR XP_025084054.1 400727 g35855 i0 45.5 0.842553191489362 66 36 84.3 0 221 24 640 705 XP_025084054.1 uncharacterized protein LOC112558046 [Pomacea canaliculata] diamond 198 69.3 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Architaenioglossa Ampullariidae Pomacea Pomacea canaliculata
27029914 27029914 PRJNA597223_P_NODE_43402_length_215_cov_1.427778_g41556_i0 PRJNA597223 43402 215 1.427778 3.0697227 Mytilus 6548 Mollusca Mollusca 45.1 7.09e-4   NR VDI16770.1 29158 g41556 i0 33.9 3.46046511627907 62 39 83.7 1 208 29 3 64 VDI16770.1 Hypothetical predicted protein, partial [Mytilus galloprovincialis] diamond 744 45.1 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus galloprovincialis
27124460 27124460 PRJNA597223_P_NODE_48762_length_200_cov_2.303030_g46916_i0 PRJNA597223 48762 200 2.30303 4.60606 Mytilus 6548 Mollusca Mollusca 44.7 0.00412   NR VDI63694.1 29158 g46916 i0 39.3 3.645 56 34 84 0 3 170 97 152 VDI63694.1 Hypothetical predicted protein [Mytilus galloprovincialis] diamond 729 45.1 0.991130820399113 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus galloprovincialis
27977539 27977539 PRJNA597223_P_NODE_31685_length_265_cov_1.595652_g29839_i0 PRJNA597223 31685 265 1.595652 4.2284778 Pectinidae 6566 Mollusca Mollusca 67 1.44e-10   NR XP_069120780.1 31199 g29839 i0 38.8 3.84905660377358 85 52 96.2 0 265 11 756 840 XP_069120780.1 uncharacterized protein [Argopecten irradians] diamond 1020 67 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Argopecten Argopecten irradians
29258501 29258501 PRJNA597223_P_NODE_24549_length_316_cov_2.957295_g22705_i0 PRJNA597223 24549 316 2.957295 9.3450522 Patella caerulea 87958 Mollusca Mollusca 57.4 6.56e-7   NR KAK6165076.1 87958 g22705 i0 38.8 0.806962025316456 85 50 78.8 1 53 301 50 134 KAK6165076.1 hypothetical protein SNE40_023679 [Patella caerulea] diamond 255 57.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella caerulea
29385181 29385181 PRJNA597223_P_NODE_11769_length_499_cov_7.543103_g10044_i0 PRJNA597223 11769 499 7.543103 37.64008397 Mytilus coruscus 42192 Mollusca Mollusca 96.7 1.43e-20   NR CAC5411093.1 42192 g10044 i0 43.6 0.703406813627255 117 65 69.7 1 128 475 89 205 CAC5411093.1 unnamed protein product [Mytilus coruscus] diamond 351 96.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus coruscus
29763756 29763756 PRJNA597223_P_NODE_20911_length_352_cov_2.078864_g19074_i0 PRJNA597223 20911 352 2.078864 7.31760128 Mytilus galloprovincialis 29158 Mollusca Mollusca 127 1.24e-34   NR VDI33759.1 29158 g19074 i0 51.7 0.988636363636364 116 56 98.9 0 2 349 20 135 VDI33759.1 Hypothetical predicted protein [Mytilus galloprovincialis] diamond 348 127 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus galloprovincialis
29763763 29763763 PRJNA597223_P_NODE_48191_length_201_cov_6.710843_g46345_i0 PRJNA597223 48191 201 6.710843 13.48879443 Elysia marginata 1093978 Mollusca Mollusca 48.9 1.09e-4   NR GFS23271.1 1093978 g46345 i0 50 0.716417910447761 48 22 68.7 1 140 3 117 164 GFS23271.1 Gypsy retrotransposon integrase-like protein 1, partial [Elysia marginata] diamond 144 48.9 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Plakobranchidae Elysia Elysia marginata
30016757 30016757 PRJNA597223_P_NODE_23651_length_324_cov_2.792388_g21807_i0 PRJNA597223 23651 324 2.792388 9.04733712 Argopecten irradians 31199 Mollusca Mollusca 73.2 2.04e-12   NR XP_069120780.1 31199 g21807 i0 40.4 5.77777777777778 94 56 87 0 311 30 747 840 XP_069120780.1 uncharacterized protein [Argopecten irradians] diamond 1872 73.2 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Argopecten Argopecten irradians
30630176 30630176 PRJNA597223_P_NODE_46613_length_205_cov_18.211765_g44767_i0 PRJNA597223 46613 205 18.211765 37.33411825 Metazoa 33208 Mollusca Mollusca 58.5 4.03e-8   NR CAC5379272.1 42192 g44767 i0 50.9 1.66829268292683 57 28 83.4 0 200 30 203 259 CAC5379272.1 unnamed protein product [Mytilus coruscus] diamond 342 58.5 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus coruscus
30679933 30679933 PRJNA597223_P_NODE_51973_length_193_cov_2.189873_g50127_i0 PRJNA597223 51973 193 2.189873 4.22645489 Acanthosepion pharaonis 158019 Mollusca Mollusca 41.6 0.0491   NR CAE1230948.1 158019 g50127 i0 69 1.80310880829016 29 9 45.1 0 103 189 145 173 CAE1230948.1 unnamed protein product [Acanthosepion pharaonis] diamond 348 41.6 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Sepiida Sepiidae Acanthosepion Acanthosepion pharaonis
30901387 30901387 PRJNA597223_P_NODE_21094_length_349_cov_14.222930_g19256_i0 PRJNA597223 21094 349 14.22293 49.6380257 Plakobranchus ocellatus 259542 Mollusca Mollusca 75.5 4.15e-13   NR GFO41531.1 259542 g19256 i0 39.4 1.70200573065903 99 60 85.1 0 347 51 581 679 GFO41531.1 gypsy retrotransposon integrase-like protein 1 [Plakobranchus ocellatus] diamond 594 75.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Plakobranchidae Plakobranchus Plakobranchus ocellatus
31357280 31357280 PRJNA597223_P_NODE_76536_length_162_cov_1.259843_g74690_i0 PRJNA597223 76536 162 1.259843 2.04094566 root 1 Root_unresolved Root_unresolved 67.8 1.79e-11   NR KAK3087210.1 66713 g74690 i0 54.7 14.2777777777778 53 23 98.1 1 2 160 464 515 KAK3087210.1 hypothetical protein FSP39_003149 [Pinctada imbricata] diamond 2313 67.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pterioida Pteriidae Pinctada Pinctada imbricata
32369703 32369703 PRJNA597223_P_NODE_62019_length_184_cov_3.120805_g60173_i0 PRJNA597223 62019 184 3.120805 5.7422812 Opisthokonta 33154 Mollusca Mollusca 64.7 2.92e-10   NR XP_046581664.1 36100 g60173 i0 50 16.7282608695652 60 27 97.8 1 182 3 49 105 XP_046581664.1 uncharacterized protein K02A2.6-like [Haliotis rubra] diamond 3078 65.1 0.993855606758833 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rubra
32640286 32640286 PRJNA597223_P_NODE_72360_length_167_cov_2.000000_g70514_i0 PRJNA597223 72360 167 2 3.34 Gigantopelta aegis 1735272 Mollusca Mollusca 107 1.26e-28   NR XP_041358868.1 1735272 g70514 i0 85.5 1.97604790419162 55 8 98.8 0 166 2 11 65 XP_041358868.1 NADH dehydrogenase [ubiquinone] 1 alpha subcomplex subunit 2-like [Gigantopelta aegis] diamond 330 107 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Neomphalida Peltospiridae Gigantopelta Gigantopelta aegis
32779661 32779661 PRJNA597223_P_NODE_83820_length_154_cov_0.991597_g81974_i0 PRJNA597223 83820 154 0.991597 1.52705938 Metazoa 33208 Mollusca Mollusca 62 1.77e-9   NR XP_033735924.1 6579 g81974 i0 56.5 16.1103896103896 46 20 89.6 0 13 150 446 491 XP_033735924.1 GTP-binding protein 1-like [Pecten maximus] diamond 2481 62.4 0.993589743589744 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Pecten Pecten maximus

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