RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

35 rows where analysis = "diamond", bioproject = "PRJEB2925" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 35 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB2925 · 35 ✖

analysis 1

  • diamond · 35 ✖
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
2575996 2575996 PRJEB2925_P_NODE_4623_length_639_cov_2.501656_g3665_i0 PRJEB2925 4623 639 2.501656 15.98558184 Cyprideis torosa 163714 Arthropoda Arthropoda 179 5.63e-54   NR CAD7239287.1 163714 g3665 i0 59.9 0.737089201877934 157 49 73.7 1 12 482 1 143 CAD7239287.1 unnamed protein product, partial [Cyprideis torosa] diamond 471 179 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cytherideidae Cyprideis Cyprideis torosa
3852201 3852201 PRJEB2925_P_NODE_11524_length_324_cov_1.906574_g10249_i0 PRJEB2925 11524 324 1.906574 6.17729976 Cyprideis torosa 163714 Arthropoda Arthropoda 121 2.13e-29   NR CAD7229512.1 163714 g10249 i0 89.1 2.37037037037037 64 7 59.3 0 131 322 35 98 CAD7229512.1 unnamed protein product [Cyprideis torosa] diamond 768 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cytherideidae Cyprideis Cyprideis torosa
3852337 3852337 PRJEB2925_P_NODE_9644_length_378_cov_2.807580_g8373_i0 PRJEB2925 9644 378 2.80758 10.6126524 Insecta 50557 Arthropoda Arthropoda 211 7.57e-65   NR KAG8230017.1 123851 g8373 i0 78.4 25.7857142857143 125 26 99.2 1 377 3 225 348 KAG8230017.1 hypothetical protein J437_LFUL008458 [Ladona fulva] diamond 9747 212 0.995283018867924 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Libellulidae Ladona Ladona fulva
5128478 5128478 PRJEB2925_P_NODE_16505_length_241_cov_1.553398_g15227_i0 PRJEB2925 16505 241 1.553398 3.74368918 Schistocerca gregaria 7010 Arthropoda Arthropoda 96.3 3.8099999999999996e-23   NR XP_049851188.1 7010 g15227 i0 50.6 11.7883817427386 79 39 98.3 0 1 237 38 116 XP_049851188.1 ubiquitin conjugating enzyme E2 B-like [Schistocerca gregaria] diamond 2841 96.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
6404381 6404381 PRJEB2925_P_NODE_8486_length_421_cov_7.139896_g7244_i0 PRJEB2925 8486 421 7.139896 30.05896216 Metazoa 33208 Arthropoda Arthropoda 104 1.32e-25   NR KAH9399477.1 59818 g7244 i0 43.8 14.2589073634204 121 64 83.4 2 383 33 12 132 KAH9399477.1 60S ribosomal protein L22 [Tyrophagus putrescentiae] diamond 6003 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
8953144 8953144 PRJEB2925_P_NODE_6008_length_539_cov_2.450397_g4922_i0 PRJEB2925 6008 539 2.450397 13.20763983 Metazoa 33208 Arthropoda Arthropoda 244 1.1e-79   NR NP_524819.1 7227 g4922 i0 72.6 19.1187384044527 164 42 89.6 1 29 511 1 164 NP_524819.1 ribosomal protein L12, isoform A [Drosophila melanogaster] diamond 10305 245 0.995918367346939 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
10228913 10228913 PRJEB2925_P_NODE_4209_length_677_cov_3.264798_g3292_i0 PRJEB2925 4209 677 3.264798 22.10268246 Amphibalanus amphitrite 1232801 Arthropoda Arthropoda 176 1.03e-50   NR KAF0304196.1 1232801 g3292 i0 53 4.60413589364845 185 78 82 2 2 556 114 289 KAF0304196.1 60S acidic ribosomal protein P0 [Amphibalanus amphitrite] diamond 3117 176 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Balanomorpha Balanidae Amphibalanus Amphibalanus amphitrite
14054199 14054199 PRJEB2925_P_NODE_11232_length_331_cov_2.037162_g9958_i0 PRJEB2925 11232 331 2.037162 6.74300622 Aphidius gifuensis 684658 Arthropoda Arthropoda 128 1.08e-31   NR XP_044020927.1 684658 g9958 i0 85.1 11.5377643504532 67 10 60.7 0 1 201 547 613 XP_044020927.1 probable aconitate hydratase, mitochondrial [Aphidius gifuensis] diamond 3819 128 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Aphidius Aphidius gifuensis
15328270 15328270 PRJEB2925_P_NODE_2853_length_893_cov_5.123543_g2160_i0 PRJEB2925 2853 893 5.123543 45.75323899 Diaphorina citri 121845 Arthropoda Arthropoda 265 1.48e-84   NR KAI5700884.1 121845 g2160 i0 49.6 4.42777155655095 264 124 88.4 3 873 85 1 256 KAI5700884.1 hypothetical protein M8J75_003817 [Diaphorina citri] diamond 3954 265 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
16602876 16602876 PRJEB2925_P_NODE_13754_length_279_cov_1.778689_g12476_i0 PRJEB2925 13754 279 1.778689 4.96254231 Dinothrombium tinctorium 1965070 Arthropoda Arthropoda 168 2.58e-46   NR RWS13494.1 1965070 g12476 i0 85.9 2.96774193548387 92 13 98.9 0 3 278 656 747 RWS13494.1 aconitate hydratase-like protein [Dinothrombium tinctorium] diamond 828 168 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium
17877681 17877681 PRJEB2925_P_NODE_10455_length_353_cov_1.820755_g9183_i0 PRJEB2925 10455 353 1.820755 6.42726515 Metazoa 33208 Arthropoda Arthropoda 164 1.62e-49   NR XP_001656734.1 7159 g9183 i0 68.1 22.6827195467422 113 36 96 0 14 352 2 114 XP_001656734.1 60S ribosomal protein L32 [Aedes aegypti] diamond 8007 164 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes aegypti
17877753 17877753 PRJEB2925_P_NODE_2855_length_893_cov_3.662005_g2162_i0 PRJEB2925 2855 893 3.662005 32.70170465 Galendromus occidentalis 34638 Arthropoda Arthropoda 306 3.32e-100   NR XP_003748187.1 34638 g2162 i0 62.1 10.0783874580067 243 87 81 2 800 78 58 297 XP_003748187.1 ADP,ATP carrier protein 1 [Galendromus occidentalis] diamond 9000 306 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
21702883 21702883 PRJEB2925_P_NODE_6458_length_512_cov_5.215933_g5327_i0 PRJEB2925 6458 512 5.215933 26.70557696 Culicoides brevitarsis 469753 Arthropoda Arthropoda 77 2.69e-13   NR XP_063702915.1 469753 g5327 i0 47.4 3.94921875 76 40 44.5 0 501 274 215 290 XP_063702915.1 large ribosomal subunit protein uL18 [Culicoides brevitarsis] diamond 2022 77 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides brevitarsis
21702896 21702896 PRJEB2925_P_NODE_7278_length_471_cov_3.167431_g6105_i0 PRJEB2925 7278 471 3.167431 14.91860001 Arthropoda 6656 Arthropoda Arthropoda 169 3.08e-50   NR KAG1671722.1 424472 g6105 i0 60.4 6.73885350318471 154 56 96.2 2 2 454 36 187 KAG1671722.1 60S ribosomal protein L17 [Nymphon striatum] diamond 3174 170 0.994117647058824 Eukaryota Opisthokonta Metazoa Arthropoda Pycnogonida Pantopoda Nymphonidae Nymphon Nymphon striatum
22665006 22665006 PRJEB2925_P_NODE_7938_length_442_cov_4.142506_g6724_i0 PRJEB2925 7938 442 4.142506 18.30987652 Arthropoda 6656 Arthropoda Arthropoda 159 5.219999999999998e-47   NR KAK4887832.1 1421715 g6724 i0 62.5 9.40045248868778 136 50 92.3 1 33 440 6 140 KAK4887832.1 hypothetical protein RN001_004103 [Aquatica leii] diamond 4155 160 0.99375 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Aquatica Aquatica leii
22978129 22978129 PRJEB2925_P_NODE_5079_length_602_cov_2.313933_g4069_i0 PRJEB2925 5079 602 2.313933 13.92987666 Hyalella azteca 294128 Arthropoda Arthropoda 213 9.76e-67   NR XP_018027602.1 294128 g4069 i0 59.6 2.79568106312292 188 75 93.2 1 25 585 4 191 XP_018027602.1 60S ribosomal protein L9 [Hyalella azteca] diamond 1683 213 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Hyalellidae Hyalella Hyalella azteca
24251964 24251964 PRJEB2925_P_NODE_8240_length_431_cov_1.994949_g7007_i0 PRJEB2925 8240 431 1.994949 8.59823019 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 153 7.47e-40   NR XP_011062974.1 103372 g7007 i0 67.9 16.6287703016241 109 34 75.9 1 426 100 734 841 XP_011062974.1 PREDICTED: golgin subfamily A member 4-like [Acromyrmex echinatior] diamond 7167 154 0.993506493506494 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Acromyrmex Acromyrmex echinatior
26747925 26747925 PRJEB2925_P_NODE_14281_length_271_cov_1.427966_g13003_i0 PRJEB2925 14281 271 1.427966 3.86978786 Formica exsecta 72781 Arthropoda Arthropoda 132 5.1e-37   NR XP_029679916.1 72781 g13003 i0 70.8 1.98154981549816 89 26 98.5 0 267 1 78 166 XP_029679916.1 fumarate hydratase, mitochondrial-like, partial [Formica exsecta] diamond 537 132 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Formica Formica exsecta
26906691 26906691 PRJEB2925_P_NODE_4582_length_642_cov_2.116969_g3625_i0 PRJEB2925 4582 642 2.116969 13.59094098 Culicoides brevitarsis 469753 Arthropoda Arthropoda 210 1.32e-64   NR XP_063705348.1 469753 g3625 i0 56.4 1.69158878504673 181 79 84.6 0 543 1 48 228 XP_063705348.1 trypsin-3-like [Culicoides brevitarsis] diamond 1086 210 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides brevitarsis
27697036 27697036 PRJEB2925_P_NODE_15584_length_253_cov_2.610092_g14306_i0 PRJEB2925 15584 253 2.610092 6.60353276 Anopheles darlingi 43151 Arthropoda Arthropoda 130 2.6999999999999997e-36   NR ETN67208.1 43151 g14306 i0 74.7 1.96837944664032 83 21 98.4 0 250 2 69 151 ETN67208.1 abnormal wing disc [Anopheles darlingi] diamond 498 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles darlingi
28580864 28580864 PRJEB2925_P_NODE_8787_length_408_cov_4.828418_g7528_i0 PRJEB2925 8787 408 4.828418 19.69994544 Culicoides brevitarsis 469753 Arthropoda Arthropoda 103 1.2099999999999999e-24   NR XP_063703570.1 469753 g7528 i0 52.8 0.919117647058823 125 55 91.9 2 408 34 91 211 XP_063703570.1 large ribosomal subunit protein eL13 [Culicoides brevitarsis] diamond 375 103 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides brevitarsis
29426563 29426563 PRJEB2925_P_NODE_8409_length_424_cov_2.030848_g7171_i0 PRJEB2925 8409 424 2.030848 8.61079552 Arthropoda 6656 Arthropoda Arthropoda 116 3.78e-29   NR MCL4137248.1 82763 g7171 i0 56.6 2.88679245283019 99 32 62.3 1 424 161 144 242 MCL4137248.1 hypothetical protein [Idotea baltica] diamond 1224 116 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
29717141 29717141 PRJEB2925_P_NODE_9310_length_389_cov_2.163842_g8042_i0 PRJEB2925 9310 389 2.163842 8.41734538 Bradysia odoriphaga 1564500 Arthropoda Arthropoda 98.2 3.5299999999999995e-23   NR KAG4071384.1 1564500 g8042 i0 41 0.940874035989717 122 70 93.3 2 382 20 28 148 KAG4071384.1 hypothetical protein HA402_004088 [Bradysia odoriphaga] diamond 366 98.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia odoriphaga
29875388 29875388 PRJEB2925_P_NODE_4551_length_644_cov_4.154351_g3598_i0 PRJEB2925 4551 644 4.154351 26.75402044 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 125 3.11e-32   NR ADD38186.1 72036 g3598 i0 34.4 2.7111801242236 192 121 89.4 1 636 61 1 187 ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] diamond 1746 125 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
30406288 30406288 PRJEB2925_P_NODE_9253_length_391_cov_2.654494_g7985_i0 PRJEB2925 9253 391 2.654494 10.37907154 Opisthokonta 33154 Arthropoda Arthropoda 95.1 2.2700000000000003e-22   NR XP_017492214.1 28612 g7985 i0 66.2 19.0281329923274 68 23 52.2 0 8 211 1 68 XP_017492214.1 PREDICTED: 60S acidic ribosomal protein P2 [Rhagoletis zephyria] diamond 7440 95.5 0.995811518324607 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
30412709 30412709 PRJEB2925_P_NODE_13333_length_286_cov_1.884462_g12056_i0 PRJEB2925 13333 286 1.884462 5.38956132 Aphidius gifuensis 684658 Arthropoda Arthropoda 65.1 8.7e-10   NR XP_044008501.1 684658 g12056 i0 44.7 1.85664335664336 85 43 85 1 4 246 578 662 XP_044008501.1 heat shock 70 kDa protein cognate 5-like [Aphidius gifuensis] diamond 531 65.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Aphidius Aphidius gifuensis
30816634 30816634 PRJEB2925_P_NODE_14774_length_264_cov_2.288210_g13496_i0 PRJEB2925 14774 264 2.28821 6.0408744 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 90.1 5.77e-19   NR KAF7492856.1 52283 g13496 i0 60.6 15.2159090909091 71 28 80.7 0 215 3 17 87 KAF7492856.1 Hydroxyacylglutathione hydrolase [Sarcoptes scabiei] diamond 4017 90.5 0.995580110497237 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Sarcoptidae Sarcoptes Sarcoptes scabiei
31518707 31518707 PRJEB2925_P_NODE_14856_length_263_cov_2.644737_g13578_i0 PRJEB2925 14856 263 2.644737 6.95565831 Uranotaenia lowii 190385 Arthropoda Arthropoda 69.7 1.96e-12   NR XP_055595150.1 190385 g13578 i0 61.4 0.501901140684411 44 17 50.2 0 260 129 79 122 XP_055595150.1 galectin-4-like [Uranotaenia lowii] diamond 132 69.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Uranotaenia Uranotaenia lowii
32018203 32018203 PRJEB2925_P_NODE_6138_length_531_cov_2.137097_g5037_i0 PRJEB2925 6138 531 2.137097 11.34798507 Orchesella 48705 Arthropoda Arthropoda 143 3.989999999999999e-37   NR ODN02581.1 48709 g5037 i0 56.3 2.53672316384181 151 59 85.3 2 530 78 310 453 ODN02581.1 Bacillopeptidase F [Orchesella cincta] diamond 1347 143 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
32144819 32144819 PRJEB2925_P_NODE_16458_length_242_cov_0.966184_g15180_i0 PRJEB2925 16458 242 0.966184 2.33816528 Ixodidae 6939 Arthropoda Arthropoda 69.3 6.25e-13   NR XP_037268857.1 6941 g15180 i0 52.7 2.76446280991736 74 33 91.7 1 242 21 51 122 XP_037268857.1 60S ribosomal protein L35-like [Rhipicephalus microplus] diamond 669 69.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
32398031 32398031 PRJEB2925_P_NODE_6219_length_526_cov_2.128310_g5112_i0 PRJEB2925 6219 526 2.12831 11.1949106 Metazoa 33208 Arthropoda Arthropoda 127 7.719999999999998e-32   NR UYV70826.1 51811 g5112 i0 43 15.712927756654 172 81 97.5 6 513 1 91 246 UYV70826.1 CTSL [Cordylochernes scorpioides] diamond 8265 128 0.9921875 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Pseudoscorpiones Chernetidae Cordylochernes Cordylochernes scorpioides
32429625 32429625 PRJEB2925_P_NODE_8139_length_435_cov_2.402500_g6912_i0 PRJEB2925 8139 435 2.4025 10.450875 Metazoa 33208 Arthropoda Arthropoda 67 9.95e-10   NR XP_037025151.1 38358 g6912 i0 32.5 3.72413793103448 126 73 85.5 6 61 432 473 588 XP_037025151.1 uncharacterized protein LOC119066670 [Bradysia coprophila] diamond 1620 67 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
32619089 32619089 PRJEB2925_P_NODE_9060_length_398_cov_2.652893_g7794_i0 PRJEB2925 9060 398 2.652893 10.55851414 Metazoa 33208 Arthropoda Arthropoda 196 4.97e-61   NR QDE54943.1 6728 g7794 i0 82 2.78140703517588 128 22 95.7 1 383 3 65 192 QDE54943.1 60S ribosomal protein L22-like protein, partial [Procambarus clarkii] diamond 1107 197 0.99492385786802 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
32625487 32625487 PRJEB2925_P_NODE_16300_length_244_cov_1.444976_g15022_i0 PRJEB2925 16300 244 1.444976 3.52574144 Daphnia magna 35525 Arthropoda Arthropoda 63.2 2.1e-9   NR KZS10819.1 35525 g15022 i0 59.6 0.639344262295082 52 21 63.9 0 244 89 80 131 KZS10819.1 Uncharacterized protein APZ42_024615 [Daphnia magna] diamond 156 63.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
32650305 32650305 PRJEB2925_P_NODE_8400_length_424_cov_4.616967_g7162_i0 PRJEB2925 8400 424 4.616967 19.57594008 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 85.1 8.18e-19   NR XP_017484166.1 28612 g7162 i0 62 4.13915094339623 71 26 50.2 1 30 242 1 70 XP_017484166.1 PREDICTED: 60S ribosomal protein L38 [Rhagoletis zephyria] diamond 1755 85.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria

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