RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA195897" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA195897 · 15 ✖

analysis 1

  • blastn · 15 ✖
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
366003 366003 PRJNA195897_P_NODE_5601_length_205_cov_1.333333_g5568_i0 PRJNA195897 5601 205 1.333333 2.73333265 Ostrea edulis 37623 Mollusca Mollusca 121 4.839999999999999e-23   NTclustered gi|2507440729|ref|XM_056150217.1| 37623 g5568 i0 84.874 28.9365853658537 119 18 58 0 85 203 673 791 PREDICTED: Ostrea edulis 60S ribosomal protein L8-like (LOC130050350), transcript variant X2, mRNA blastn 5932 121 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Ostrea Ostrea edulis
366016 366016 PRJNA195897_P_NODE_6881_length_189_cov_1.428571_g6848_i0 PRJNA195897 6881 189 1.428571 2.69999919 Pomacea canaliculata 400727 Mollusca Mollusca 139 1.21e-28   NTclustered gi|1397725324|ref|XM_025254038.1| 400727 g6848 i0 90.476 46.3492063492063 105 10 56 0 1 105 119 15 PREDICTED: Pomacea canaliculata tubulin alpha chain, testis-specific-like (LOC112573557), mRNA blastn 8760 139 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Architaenioglossa Ampullariidae Pomacea Pomacea canaliculata
4883281 4883281 PRJNA195897_P_NODE_6904_length_189_cov_1.114286_g6871_i0 PRJNA195897 6904 189 1.114286 2.10600054 root 1 Root_unresolved Root_unresolved 63.9 7.49e-6   NTclustered gi|2911890848|ref|XM_071225420.1| 6455 g6871 i0 100 10.8201058201058 34 0 18 0 5 38 23 56 PREDICTED: Haliotis cracherodii period circadian protein-like (LOC139444456), mRNA blastn 2045 63.9 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis cracherodii
9294080 9294080 PRJNA195897_P_NODE_5528_length_206_cov_1.547771_g5495_i0 PRJNA195897 5528 206 1.547771 3.18840826 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.005   NTclustered gi|2912989933|dbj|AP039594.1| 145626 g5495 i0 100 0.140776699029126 29 0 14 0 165 193 35002073 35002101 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
10570037 10570037 PRJNA195897_P_NODE_1809_length_384_cov_1.420896_g1776_i0 PRJNA195897 1809 384 1.420896 5.45624064 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.01   NTclustered gi|2912981848|dbj|AP039587.1| 145626 g1776 i0 100 0.0755208333333333 29 0 8 0 53 81 8815440 8815468 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
13808712 13808712 PRJNA195897_P_NODE_3371_length_265_cov_1.569444_g3338_i0 PRJNA195897 3371 265 1.569444 4.1590266 Magallana 147004 Mollusca Mollusca 178 3.83e-40   NTclustered gi|2751295848|ref|XM_011436623.4| 29159 g3338 i0 78.947 72.2566037735849 266 52 99 4 2 265 562 825 PREDICTED: Magallana gigas large ribosomal subunit protein uL3 (LOC105333577), mRNA blastn 19148 178 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana gigas
14395099 14395099 PRJNA195897_P_NODE_8852_length_169_cov_1.766667_g8819_i0 PRJNA195897 8852 169 1.766667 2.98566723 Corbicula japonica 141464 Mollusca Mollusca 91.6 2.99e-14   NTclustered gi|1863074142|dbj|LC564862.1| 141464 g8819 i0 84.615 0.538461538461538 91 14 54 0 25 115 728 638 Corbicula japonica mRNA for tropomyosin, complete cds blastn 91 91.6 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Cyrenidae Corbicula Corbicula japonica
16357702 16357702 PRJNA195897_P_NODE_1013_length_530_cov_2.671518_g982_i0 PRJNA195897 1013 530 2.671518 14.1590454 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 65.8 6.68e-6   NTclustered gi|2868657535|ref|XM_070331518.1| 31220 g982 i0 81.818 1.68867924528302 77 14 15 0 46 122 3635 3711 PREDICTED: Littorina saxatilis solute carrier family 15 member 1-like (LOC138959870), transcript variant X1, mRNA blastn 895 65.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
16943289 16943289 PRJNA195897_P_NODE_6354_length_195_cov_1.424658_g6321_i0 PRJNA195897 6354 195 1.424658 2.7780831 Haliotis rubra 36100 Mollusca Mollusca 84.2 5.97e-12   NTclustered gi|2194143813|ref|XM_046727912.1| 36100 g6321 i0 80.18 2.84615384615385 111 22 57 0 85 195 232 342 PREDICTED: Haliotis rubra dynein intermediate chain 2, ciliary-like (LOC124291010), mRNA blastn 555 84.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rubra
16943290 16943290 PRJNA195897_P_NODE_6374_length_195_cov_1.068493_g6341_i0 PRJNA195897 6374 195 1.068493 2.08356135 Dreissena polymorpha 45954 Mollusca Mollusca 141 3.5e-29   NTclustered gi|2364388755|ref|XM_052406072.1| 45954 g6341 i0 81.503 19.4153846153846 173 30 88 2 3 174 752 581 PREDICTED: Dreissena polymorpha glutamate dehydrogenase, mitochondrial-like (LOC127865927), mRNA blastn 3786 141 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Dreissenidae Dreissena Dreissena polymorpha
19491943 19491943 PRJNA195897_P_NODE_12236_length_162_cov_2.159292_g12203_i0 PRJNA195897 12236 162 2.159292 3.49805304 Physella acuta 109671 Mollusca Mollusca 76.8 8e-10   NTclustered gi|2572399984|ref|XM_059317112.1| 109671 g12203 i0 82.759 1.23456790123457 87 13 53 2 29 114 85 170 PREDICTED: Physella acuta large ribosomal subunit protein uL22-like (LOC131953758), mRNA blastn 200 76.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
19491989 19491989 PRJNA195897_P_NODE_4276_length_231_cov_1.686813_g4243_i0 PRJNA195897 4276 231 1.686813 3.89653803 Argopecten irradians 31199 Mollusca Mollusca 60.2 1.23e-4   NTclustered gi|2835328455|ref|XM_069269542.1| 31199 g4243 i0 81.69 0.432900432900433 71 13 31 0 160 230 1733 1663 PREDICTED: Argopecten irradians T-complex protein 1 subunit theta-like (LOC138324475), mRNA blastn 100 60.2 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Argopecten Argopecten irradians
20767489 20767489 PRJNA195897_P_NODE_17_length_2361_cov_6.082612_g16_i0 PRJNA195897 17 2361 6.082612 143.61046932 Littorina saxatilis 31220 Mollusca Mollusca 1206 0   NTclustered gi|2868619577|ref|XM_070340773.1| 31220 g16 i0 77.645 85.573485811097 2098 393 88 61 214 2279 2255 202 PREDICTED: Littorina saxatilis heat shock protein 83-like (LOC138968223), mRNA blastn 202039 1206 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
22042588 22042588 PRJNA195897_P_NODE_1718_length_394_cov_2.657971_g1685_i0 PRJNA195897 1718 394 2.657971 10.47240574 Littorina saxatilis 31220 Mollusca Mollusca 54.7 0.01   NTclustered gi|2868616210|ref|XM_070343508.1| 31220 g1685 i0 96.97 0.083756345177665 33 0 8 1 53 85 1559 1590 PREDICTED: Littorina saxatilis microfibrillar-associated protein 1-like (LOC138970926), mRNA blastn 33 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
22042634 22042634 PRJNA195897_P_NODE_6258_length_196_cov_2.455782_g6225_i0 PRJNA195897 6258 196 2.455782 4.81333272 Littorina saxatilis 31220 Mollusca Mollusca 121 4.579999999999999e-23   NTclustered gi|2868696718|ref|XM_070339283.1| 31220 g6225 i0 78.788 13.75 198 28 99 9 1 194 860 673 PREDICTED: Littorina saxatilis calreticulin-like (LOC138966892), mRNA blastn 2695 121 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis

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