RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where bioproject = "PRJEB9859" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 30 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB9859 · 30 ✖
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
145015 145015 PRJEB9859_S_NODE_541_length_179_cov_6.611111_g536_i0 PRJEB9859 541 179 6.611111 11.83388869 Liposcelis bostrychophila 185214 Arthropoda Arthropoda 331 1.74e-86   NTclustered gi|2210637305|gb|MT106115.1| 185214 g536 i0 100 72.3240223463687 179 0 100 0 1 179 7678 7856 Liposcelis bostrychophila strain Berlin chromosome 1 mitochondrion, complete sequence blastn 12946 331 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Liposcelididae Liposcelis Liposcelis bostrychophila
2695144 2695144 PRJEB9859_P_NODE_3983_length_255_cov_2.424779_g3948_i0 PRJEB9859 3983 255 2.424779 6.18318645 Stomoxys calcitrans 35570 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2573078818|ref|XM_013253840.2| 35570 g3948 i0 100 0.109803921568627 28 0 11 0 134 161 2712 2739 PREDICTED: Stomoxys calcitrans daxx-like protein (LOC106088360), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Stomoxys Stomoxys calcitrans
2695199 2695199 PRJEB9859_S_NODE_563_length_175_cov_2.628571_g558_i0 PRJEB9859 563 175 2.628571 4.59999925 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 313 6.13e-81   NTclustered gi|1535914814|ref|XR_003474832.1| 6956 g558 i0 98.857 100.422857142857 175 2 100 0 1 175 320 146 PREDICTED: Dermatophagoides pteronyssinus large subunit ribosomal RNA (LOC113793595), rRNA blastn 17574 313 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
6102155 6102155 PRJEB9859_P_NODE_2065_length_316_cov_759.282230_g2030_i0 PRJEB9859 2065 316 759.28223 2399.3318468 Staphylinidae 29026 Arthropoda Arthropoda 302 2.66e-77   NTclustered gi|693464834|gb|KJ844884.1| 1541375 g2030 i0 92.453 59.2151898734177 212 14 67 2 24 234 108 318 Pselaptrichus sp. DDM1181 28S ribosomal RNA gene, partial sequence blastn 18712 302 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Pselaptrichus Pselaptrichus sp. DDM1181
6523316 6523316 PRJEB9859_P_NODE_8206_length_197_cov_21.184524_g8171_i0 PRJEB9859 8206 197 21.184524 41.73351228 Cephus cinctus 211228 Arthropoda Arthropoda 85.9 1.21e-17   NR XP_024939559.1 211228 g8171 i0 66.7 5.93908629441624 54 18 82.2 0 170 9 213 266 XP_024939559.1 glutathione hydrolase 1 proenzyme isoform X2 [Cephus cinctus] diamond 1170 85.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Cephidae Cephus Cephus cinctus
9072424 9072424 PRJEB9859_P_NODE_608_length_452_cov_371.297872_g578_i0 PRJEB9859 608 452 371.297872 1678.26638144 Liposcelis bostrychophila 185214 Arthropoda Arthropoda 619 9.57e-173   NTclustered gi|194718416|gb|EU863798.1| 185214 g578 i0 100 25.7920353982301 335 0 74 0 22 356 11 345 Liposcelis bostrychophila isolate CZ 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 11658 619 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Liposcelididae Liposcelis Liposcelis bostrychophila
9072429 9072429 PRJEB9859_P_NODE_6348_length_227_cov_2.111111_g6313_i0 PRJEB9859 6348 227 2.111111 4.79222197 Vanessa cardui 171605 Arthropoda Arthropoda 119 1.97e-22   NTclustered gi|2207062080|ref|XM_047117954.1| 171605 g6313 i0 87.619 13.7929515418502 105 9 45 4 124 226 1555 1453 PREDICTED: Vanessa cardui tubulin alpha chain (LOC124540420), mRNA blastn 3131 119 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Vanessa Vanessa cardui
10347984 10347984 PRJEB9859_P_NODE_2069_length_316_cov_7.156794_g2034_i0 PRJEB9859 2069 316 7.156794 22.61546904 Daphnia pulex 6669 Arthropoda Arthropoda 139 7.73e-40   NR EFX60013.1 6669 g2034 i0 82.3 1.57594936708861 79 14 75 0 25 261 67 145 EFX60013.1 hypothetical protein DAPPUDRAFT_73053 [Daphnia pulex] diamond 498 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
11202272 11202272 PRJEB9859_P_NODE_1729_length_334_cov_710.619672_g1694_i0 PRJEB9859 1729 334 710.619672 2373.46970448 Staphylinidae 29026 Arthropoda Arthropoda 302 2.8300000000000002e-77   NTclustered gi|693464834|gb|KJ844884.1| 1541375 g1694 i0 92.453 56.0239520958084 212 14 63 2 101 311 318 108 Pselaptrichus sp. DDM1181 28S ribosomal RNA gene, partial sequence blastn 18712 302 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Pselaptrichus Pselaptrichus sp. DDM1181
11202274 11202274 PRJEB9859_P_NODE_1809_length_329_cov_28.733333_g1774_i0 PRJEB9859 1809 329 28.733333 94.53266557 Entomobryomorpha 730330 Arthropoda Arthropoda 139 2.31e-28   NTclustered gi|472455922|gb|KC236276.1| 247613 g1774 i0 100 22.7963525835866 75 0 23 0 255 329 202 128 Entomobrya multifasciata 28S ribosomal RNA gene, partial sequence blastn 7500 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Entomobryidae Entomobrya Entomobrya multifasciata
11202311 11202311 PRJEB9859_P_NODE_7129_length_216_cov_63.780749_g7094_i0 PRJEB9859 7129 216 63.780749 137.76641784 Aphelocheirus 280208 Arthropoda Arthropoda 91.6 4.04e-14   NTclustered gi|741985854|gb|KJ461297.1| 575831 g7094 i0 91.045 32.087962962963 67 6 31 0 146 212 2209 2143 Aphelocheirus ellipsoideus 28S ribosomal RNA gene, partial sequence blastn 6931 91.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphelocheiridae Aphelocheirus Aphelocheirus ellipsoideus
11623560 11623560 PRJEB9859_P_NODE_750_length_425_cov_57.535354_g716_i0 PRJEB9859 750 425 57.535354 244.5252545 Derocheilocaris typica 84307 Arthropoda Arthropoda 154 1.09e-32   NTclustered gi|172072974|gb|EU370429.1| 84307 g716 i0 96.739 30.6470588235294 92 3 39 0 334 425 1221 1130 Derocheilocaris typicus strain C9 18S ribosomal RNA gene, partial sequence blastn 13025 154 1 Eukaryota Opisthokonta Metazoa Arthropoda Mystacocarida Mystacocaridida Derocheilocarididae Derocheilocaris Derocheilocaris typica
12477904 12477904 PRJEB9859_P_NODE_1530_length_348_cov_682.304075_g1495_i0 PRJEB9859 1530 348 682.304075 2374.418181 Staphylinidae 29026 Arthropoda Arthropoda 302 2.96e-77   NTclustered gi|693464834|gb|KJ844884.1| 1541375 g1495 i0 92.453 53.7701149425287 212 14 61 2 115 325 318 108 Pselaptrichus sp. DDM1181 28S ribosomal RNA gene, partial sequence blastn 18712 302 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Pselaptrichus Pselaptrichus sp. DDM1181
12898564 12898564 PRJEB9859_P_NODE_1511_length_349_cov_62.578125_g1476_i0 PRJEB9859 1511 349 62.578125 218.39765625 Derocheilocaris typica 84307 Arthropoda Arthropoda 154 8.78e-33   NTclustered gi|172072974|gb|EU370429.1| 84307 g1476 i0 96.739 30.1805157593123 92 3 26 0 142 233 1221 1130 Derocheilocaris typicus strain C9 18S ribosomal RNA gene, partial sequence blastn 10533 154 1 Eukaryota Opisthokonta Metazoa Arthropoda Mystacocarida Mystacocaridida Derocheilocarididae Derocheilocaris Derocheilocaris typica
14173497 14173497 PRJEB9859_P_NODE_1032_length_390_cov_3.210526_g998_i0 PRJEB9859 1032 390 3.210526 12.5210514 Metazoa 33208 Arthropoda Arthropoda 149 3.27e-43   NR OTF70000.1 6958 g998 i0 71.6 11.9 95 27 73.1 0 387 103 74 168 OTF70000.1 60S ribosomal protein L11-like protein [Euroglyphus maynei] diamond 4641 150 0.993333333333333 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Euroglyphus Euroglyphus maynei
15447699 15447699 PRJEB9859_P_NODE_7773_length_207_cov_135.325843_g7738_i0 PRJEB9859 7773 207 135.325843 280.12449501 Speleonectes gironensis 172521 Arthropoda Arthropoda 97.1 8.25e-16   NTclustered gi|15986551|gb|AF370810.1| 172521 g7738 i0 95.082 14.6038647342995 61 3 29 0 133 193 224 164 Speleonectes gironensis 28S ribosomal RNA gene, partial sequence blastn 3023 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Remipedia Nectiopoda Speleonectidae Speleonectes Speleonectes gironensis
15447704 15447704 PRJEB9859_S_NODE_293_length_337_cov_27.884106_g288_i0 PRJEB9859 293 337 27.884106 93.96943722 Liposcelis bostrychophila 185214 Arthropoda Arthropoda 614 3.229999999999999e-171   NTclustered gi|194718416|gb|EU863798.1| 185214 g288 i0 99.701 34.6112759643917 335 1 99 0 3 337 11 345 Liposcelis bostrychophila isolate CZ 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 11664 614 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Liposcelididae Liposcelis Liposcelis bostrychophila
17996636 17996636 PRJEB9859_P_NODE_2835_length_287_cov_3.189922_g2800_i0 PRJEB9859 2835 287 3.189922 9.15507614 Labidocera rotunda 207950 Arthropoda Arthropoda 117 9.28e-22   NTclustered gi|961376781|gb|KT755301.1| 207950 g2800 i0 80.769 31.6898954703833 156 24 53 6 125 277 417 265 Labidocera rotunda clone LabbicDNA51(Lbi51) 60S ribosomal protein L22 mRNA, complete cds blastn 9095 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Pontellidae Labidocera Labidocera rotunda
18850678 18850678 PRJEB9859_P_NODE_1495_length_350_cov_674.105919_g1460_i0 PRJEB9859 1495 350 674.105919 2359.3707165 Staphylinidae 29026 Arthropoda Arthropoda 302 2.9700000000000006e-77   NTclustered gi|693464834|gb|KJ844884.1| 1541375 g1460 i0 92.453 53.462857142857096 212 14 60 2 24 234 108 318 Pselaptrichus sp. DDM1181 28S ribosomal RNA gene, partial sequence blastn 18712 302 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Pselaptrichus Pselaptrichus sp. DDM1181
20546043 20546043 PRJEB9859_P_NODE_2057_length_317_cov_1.750000_g2022_i0 PRJEB9859 2057 317 1.75 5.5475 Zerynthia rumina 132710 Arthropoda Arthropoda 52.8 0.03   NTclustered gi|2918381530|emb|OZ238054.1| 132710 g2022 i0 100 0.0883280757097792 28 0 9 0 241 268 6323989 6323962 Zerynthia rumina genome assembly, chromosome: 19 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Zerynthia Zerynthia rumina
20546117 20546117 PRJEB9859_P_NODE_6917_length_217_cov_39.335106_g6882_i0 PRJEB9859 6917 217 39.335106 85.35718002 Delia radicum 30064 Arthropoda Arthropoda 139 1.43e-28   NTclustered gi|425869920|gb|KC177819.1| 30064 g6882 i0 100 34.1013824884793 75 0 35 0 143 217 2454 2380 Delia radicum 28S ribosomal RNA gene, partial sequence blastn 7400 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Anthomyiidae Delia Delia radicum
21821830 21821830 PRJEB9859_P_NODE_7558_length_211_cov_339.252747_g7523_i0 PRJEB9859 7558 211 339.252747 715.82329617 Liposcelis bostrychophila 185214 Arthropoda Arthropoda 255 1.32e-63   NTclustered gi|537107101|gb|KF419262.1| 185214 g7523 i0 99.291 16.9099526066351 141 1 93 0 71 211 227 367 Liposcelis bostrychophila 12S ribosomal RNA gene, partial sequence; mitochondrial blastn 3568 255 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Liposcelididae Liposcelis Liposcelis bostrychophila
25225153 25225153 PRJEB9859_P_NODE_6800_length_217_cov_158.031915_g6765_i0 PRJEB9859 6800 217 158.031915 342.92925555 Diptera 7147 Arthropoda Arthropoda 215 2.31e-51   NTclustered gi|2568282091|ref|XR_009344279.1| 7370 g6765 i0 99.16 56.6451612903226 119 1 55 0 99 217 3637 3519 PREDICTED: Musca domestica large subunit ribosomal RNA (LOC131807038), rRNA blastn 12292 215 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Musca Musca domestica
26646870 26646870 PRJEB9859_P_NODE_3481_length_267_cov_7.344538_g3446_i0 PRJEB9859 3481 267 7.344538 19.60991646 Metazoa 33208 Arthropoda Arthropoda 67 9.96e-12   NR XP_055701935.1 29031 g3446 i0 48.6 9.33707865168539 72 36 80.9 1 2 217 70 140 XP_055701935.1 40S ribosomal protein S12 [Phlebotomus papatasi] diamond 2493 67.4 0.99406528189911 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Phlebotomus Phlebotomus papatasi
28108079 28108079 PRJEB9859_P_NODE_1385_length_359_cov_2.093939_g1350_i0 PRJEB9859 1385 359 2.093939 7.51724101 Idotea baltica 82763 Arthropoda Arthropoda 89.7 1.11e-20   NR MCL4170146.1 82763 g1350 i0 57.5 0.668523676880223 80 34 66.9 0 6 245 12 91 MCL4170146.1 hypothetical protein [Idotea baltica] diamond 240 89.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
29718254 29718254 PRJEB9859_P_NODE_210_length_639_cov_7.260656_g199_i0 PRJEB9859 210 639 7.260656 46.39559184 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 115 3.1699999999999998e-28   NR ADD38186.1 72036 g199 i0 37.6 0.849765258215962 181 104 84 2 637 101 16 189 ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] diamond 543 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
29971152 29971152 PRJEB9859_P_NODE_4771_length_247_cov_1.018349_g4736_i0 PRJEB9859 4771 247 1.018349 2.51532203 Limnephilus lunatus 1218281 Arthropoda Arthropoda 48.9 2.52e-4   NR WIM01487.1 1218281 g4736 i0 60.5 0.461538461538462 38 15 46.2 0 3 116 504 541 WIM01487.1 T-complex protein 1 subunit eta [Limnephilus lunatus] diamond 114 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Trichoptera Limnephilidae Limnephilus Limnephilus lunatus
30785263 30785263 PRJEB9859_P_NODE_1314_length_364_cov_1.907463_g1279_i0 PRJEB9859 1314 364 1.907463 6.94316532 Opisthokonta 33154 Arthropoda Arthropoda 122 1.35e-32   NR NP_476778.1 7227 g1279 i0 67 21.7087912087912 94 26 77.5 1 348 67 64 152 NP_476778.1 ribosomal protein S27A [Drosophila melanogaster] diamond 7902 122 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
31449128 31449128 PRJEB9859_P_NODE_2676_length_292_cov_3.399240_g2641_i0 PRJEB9859 2676 292 3.39924 9.9257808 Insecta 50557 Arthropoda Arthropoda 88.2 2.87e-19   NR XP_068905359.1 7067 g2641 i0 51.9 5.49657534246575 79 38 81.2 0 257 21 63 141 XP_068905359.1 large ribosomal subunit protein eL13-like [Tenebrio molitor] diamond 1605 89 0.991011235955056 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
32588088 32588088 PRJEB9859_P_NODE_3139_length_277_cov_3.318548_g3104_i0 PRJEB9859 3139 277 3.318548 9.19237796 Arthropoda 6656 Arthropoda Arthropoda 76.6 2e-15   NR XP_037794350.1 6687 g3104 i0 70.7 24.4440433212996 58 17 62.8 0 257 84 82 139 XP_037794350.1 uncharacterized protein LOC119589836 isoform X1 [Penaeus monodon] diamond 6771 76.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon

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