RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJEB58983", tax_clade = "Opisthokonta" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 16 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 16 ✖

bioproject 1

  • PRJEB58983 · 16 ✖
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
1399438 1399438 PRJEB58983_P_NODE_28322_length_252_cov_0.871508_g27907_i0 PRJEB58983 28322 252 0.871508 2.19620016 Littorina saxatilis 31220 Mollusca Mollusca 95.5 3.179999999999999e-23   NR XP_070200040.1 31220 g27907 i0 60.8 1.88095238095238 79 31 94 0 251 15 40 118 XP_070200040.1 myotrophin-like [Littorina saxatilis] diamond 474 95.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
2674934 2674934 PRJEB58983_P_NODE_22943_length_274_cov_7.189055_g22528_i0 PRJEB58983 22943 274 7.189055 19.6980107 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.007   NTclustered gi|2913000417|dbj|AP039607.1| 145626 g22528 i0 96.875 0.233576642335766 32 1 12 0 16 47 8068736 8068705 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
2675202 2675202 PRJEB58983_P_NODE_5183_length_539_cov_2.221030_g4770_i0 PRJEB58983 5183 539 2.22103 11.9713517 Patella vulgata 6465 Mollusca Mollusca 121 1.43e-22   NTclustered gi|2506343378|ref|XR_007684797.2| 6465 g4770 i0 92.771 0.619666048237477 83 6 21 0 436 518 162 244 PREDICTED: Patella vulgata uncharacterized LOC126832675 (LOC126832675), ncRNA blastn 334 121 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
10328095 10328095 PRJEB58983_P_NODE_31149_length_245_cov_0.906977_g30734_i0 PRJEB58983 31149 245 0.906977 2.22209365 Bradybaena similaris 145626 Mollusca Mollusca 381 2.4799999999999995e-101   NTclustered gi|2913002568|dbj|AP039611.1| 145626 g30734 i0 94.694 1 245 13 100 0 1 245 545639 545395 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored2, sequence blastn 245 381 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
11603033 11603033 PRJEB58983_P_NODE_10290_length_390_cov_2.025237_g9875_i0 PRJEB58983 10290 390 2.025237 7.8984243 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 199 1.09e-60   NR XP_033735994.1 6579 g9875 i0 71.5 22.9692307692308 130 37 100 0 390 1 46 175 XP_033735994.1 40S ribosomal protein SA-like [Pecten maximus] diamond 8958 201 0.990049751243781 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Pecten Pecten maximus
11603043 11603043 PRJEB58983_P_NODE_10630_length_384_cov_3.803859_g10215_i0 PRJEB58983 10630 384 3.803859 14.60681856 Myida 278205 Mollusca Mollusca 171 5.9e-50   NR XP_052790655.1 6604 g10215 i0 66.7 8.90625 126 42 98.4 0 384 7 2 127 XP_052790655.1 60S ribosomal protein L5-like [Mya arenaria] diamond 3420 172 0.994186046511628 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
15427449 15427449 PRJEB58983_P_NODE_31173_length_245_cov_0.906977_g30758_i0 PRJEB58983 31173 245 0.906977 2.22209365 Bradybaena similaris 145626 Mollusca Mollusca 202 2.08e-47   NTclustered gi|2913002568|dbj|AP039611.1| 145626 g30758 i0 85.938 0.783673469387755 192 24 78 1 54 245 541630 541818 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored2, sequence blastn 192 202 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
16701489 16701489 PRJEB58983_P_NODE_18934_length_296_cov_4.269058_g18519_i0 PRJEB58983 18934 296 4.269058 12.63641168 Pomacea canaliculata 400727 Mollusca Mollusca 141 1.3699999999999996e-40   NR XP_025086345.1 400727 g18519 i0 67 1.96621621621622 97 32 98.3 0 291 1 1 97 XP_025086345.1 LOW QUALITY PROTEIN: 40S ribosomal protein S11-like [Pomacea canaliculata] diamond 582 141 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Architaenioglossa Ampullariidae Pomacea Pomacea canaliculata
19250503 19250503 PRJEB58983_P_NODE_25976_length_260_cov_3.834225_g25561_i0 PRJEB58983 25976 260 3.834225 9.968985 Physella acuta 109671 Mollusca Mollusca 481 2.55e-131   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g25561 i0 100 3.19615384615385 260 0 100 0 1 260 3489 3748 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 831 481 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
28044311 28044311 PRJEB58983_P_NODE_26025_length_260_cov_2.449198_g25610_i0 PRJEB58983 26025 260 2.449198 6.3679148 Patella vulgata 6465 Mollusca Mollusca 53.9 5.38e-6   NR XP_050414052.1 6465 g25610 i0 33.7 1.98461538461538 86 52 99.2 1 2 259 170 250 XP_050414052.1 26S proteasome non-ATPase regulatory subunit 1 isoform X2 [Patella vulgata] diamond 516 53.9 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
28233523 28233523 PRJEB58983_P_NODE_31046_length_245_cov_1.337209_g30631_i0 PRJEB58983 31046 245 1.337209 3.27616205 Acanthosepion pharaonis 158019 Mollusca Mollusca 71.6 2.61e-12   NR CAE1280052.1 158019 g30631 i0 42.5 0.893877551020408 73 42 89.4 0 230 12 2207 2279 CAE1280052.1 unnamed protein product [Acanthosepion pharaonis] diamond 219 71.6 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Sepiida Sepiidae Acanthosepion Acanthosepion pharaonis
28826685 28826685 PRJEB58983_P_NODE_6148_length_496_cov_1.940898_g5734_i0 PRJEB58983 6148 496 1.940898 9.62685408 Opisthokonta 33154 Mollusca Mollusca 135 4.01e-37   NR XP_062592983.1 36930 g5734 i0 58.1 8.86693548387097 129 52 78 1 464 78 8 134 XP_062592983.1 large ribosomal subunit protein eL14-like [Saccostrea cuccullata] diamond 4398 135 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Saccostrea Saccostrea cuccullata
29647439 29647439 PRJEB58983_P_NODE_8170_length_433_cov_5.075000_g7756_i0 PRJEB58983 8170 433 5.075 21.97475 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 185 2.41e-57   NR XP_012936217.2 6500 g7756 i0 62.6 11.0300230946882 131 49 90.8 0 395 3 7 137 XP_012936217.2 40S ribosomal protein S18 [Aplysia californica] diamond 4776 186 0.99462365591397806 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
30089890 30089890 PRJEB58983_P_NODE_22852_length_275_cov_1.569307_g22437_i0 PRJEB58983 22852 275 1.569307 4.31559425 Stylommatophora 6527 Mollusca Mollusca 116 3.19e-28   NR CAG5131274.1 100452 g22437 i0 62.4 9.27272727272727 85 32 92.7 0 263 9 252 336 CAG5131274.1 unnamed protein product [Candidula unifasciata] diamond 2550 117 0.991452991452991 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Geomitridae Candidula Candidula unifasciata
30879844 30879844 PRJEB58983_P_NODE_19554_length_292_cov_2.995434_g19139_i0 PRJEB58983 19554 292 2.995434 8.74666728 Opisthokonta 33154 Mollusca Mollusca 101 1.42e-22   NR CAG2243665.1 6550 g19139 i0 49.5 4.92123287671233 97 47 98.6 2 2 289 409 504 CAG2243665.1 EEF2 [Mytilus edulis] diamond 1437 101 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
31132354 31132354 PRJEB58983_P_NODE_15935_length_321_cov_1.258065_g15520_i0 PRJEB58983 15935 321 1.258065 4.03838865 Mollusca 6447 Mollusca Mollusca 144 3.88e-39   NR CAL1535663.1 6523 g15520 i0 68.3 12.5700934579439 104 33 97.2 0 313 2 61 164 CAL1535663.1 unnamed protein product [Lymnaea stagnalis] diamond 4035 144 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis

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