RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA1196384" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 32 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1196384 · 32 ✖

analysis 1

  • diamond · 32 ✖
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
5425865 5425865 PRJNA1196384_S_NODE_385_length_592_cov_4.282883_g328_i0 PRJNA1196384 385 592 4.282883 25.35466736 Dinothrombium tinctorium 1965070 Arthropoda Arthropoda 211 5.129999999999999e-66   NR RWS10011.1 1965070 g328 i0 61.8 0.902027027027027 178 67 90.2 1 592 59 9 185 RWS10011.1 hypothetical protein B4U79_10334 [Dinothrombium tinctorium] diamond 534 211 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium
9250558 9250558 PRJNA1196384_S_NODE_188_length_776_cov_5.635995_g144_i0 PRJNA1196384 188 776 5.635995 43.7353212 Metazoa 33208 Arthropoda Arthropoda 379 1.5799999999999993e-130   NR XP_002402767.2 6945 g144 i0 73.9 44.9845360824742 245 60 93.2 1 3 725 14 258 XP_002402767.2 60S ribosomal protein L8 [Ixodes scapularis] diamond 34908 380 0.997368421052632 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
9250661 9250661 PRJNA1196384_S_NODE_7268_length_158_cov_1.545455_g7204_i0 PRJNA1196384 7268 158 1.545455 2.4418189 Parnassius apollo 110799 Arthropoda Arthropoda 77.4 3.69e-15   NR CAG4985250.1 110799 g7204 i0 75 16.7848101265823 52 13 98.7 0 156 1 97 148 CAG4985250.1 unnamed protein product [Parnassius apollo] diamond 2652 77.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Parnassius Parnassius apollo
11801253 11801253 PRJNA1196384_S_NODE_5950_length_170_cov_1.676692_g5886_i0 PRJNA1196384 5950 170 1.676692 2.8503764 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 114 2.69e-28   NR CAL6180791.1 34612 g5886 i0 87.5 82.9764705882353 56 7 98.8 0 170 3 355 410 CAL6180791.1 unnamed protein product [Ixodes hexagonus] diamond 14106 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes hexagonus
14351748 14351748 PRJNA1196384_S_NODE_672_length_460_cov_4.326241_g609_i0 PRJNA1196384 672 460 4.326241 19.9007086 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 228 7.059999999999998e-74   NR GIY36064.1 1538125 g609 i0 78.4 5.2304347826087 134 29 87.4 0 459 58 22 155 GIY36064.1 40S ribosomal protein S18 [Caerostris darwini] diamond 2406 229 0.995633187772926 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Caerostris Caerostris darwini
16899842 16899842 PRJNA1196384_S_NODE_594_length_488_cov_4.104213_g532_i0 PRJNA1196384 594 488 4.104213 20.02855944 Metazoa 33208 Arthropoda Arthropoda 201 1.74e-63   NR AHB12474.1 185825 g532 i0 68.5 5.21311475409836 143 45 87.9 0 486 58 5 147 AHB12474.1 60S Ribosomal Protein L27A [Pantala flavescens] diamond 2544 201 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Libellulidae Pantala Pantala flavescens
23274925 23274925 PRJNA1196384_S_NODE_359_length_609_cov_3.800699_g302_i0 PRJNA1196384 359 609 3.800699 23.14625691 Opisthokonta 33154 Arthropoda Arthropoda 203 2.56e-63   NR KFM78563.1 407821 g302 i0 62.6 26.1083743842365 163 61 80.3 0 12 500 2 164 KFM78563.1 60S ribosomal protein L17, partial [Stegodyphus mimosarum] diamond 15900 204 0.995098039215686 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus mimosarum
27217625 27217625 PRJNA1196384_S_NODE_4762_length_185_cov_1.804054_g4698_i0 PRJNA1196384 4762 185 1.804054 3.3374999 Opisthokonta 33154 Arthropoda Arthropoda 57 3.87e-8   NR ACF72877.1 329105 g4698 i0 54.3 1.68648648648649 46 21 74.6 0 177 40 69 114 ACF72877.1 ribosomal protein S10 [Ochlerotatus taeniorhynchus] diamond 312 57 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Ochlerotatus Ochlerotatus taeniorhynchus
27293691 27293691 PRJNA1196384_S_NODE_3243_length_216_cov_4.128492_g3179_i0 PRJNA1196384 3243 216 4.128492 8.91754272 Panonychus citri 50023 Arthropoda Arthropoda 56.6 4.46e-8   NR XP_053213121.1 50023 g3179 i0 83.3 1.23611111111111 30 5 41.7 0 5 94 98 127 XP_053213121.1 FAU ubiquitin-like and ribosomal protein S30 [Panonychus citri] diamond 267 56.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri
27325350 27325350 PRJNA1196384_S_NODE_243_length_706_cov_4.627803_g193_i0 PRJNA1196384 243 706 4.627803 32.67228918 Bemisia tabaci 7038 Arthropoda Arthropoda 218 7.93e-68   NR XP_018909113.1 7038 g193 i0 59.3 3.46317280453258 204 78 85.4 3 671 69 3 204 XP_018909113.1 PREDICTED: 60S ribosomal protein L13 [Bemisia tabaci] diamond 2445 218 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
27325352 27325352 PRJNA1196384_S_NODE_4203_length_194_cov_1.955414_g4139_i0 PRJNA1196384 4203 194 1.955414 3.79350316 Diaphorina citri 121845 Arthropoda Arthropoda 96.7 1.4e-21   NR KAI5699564.1 121845 g4139 i0 67.2 0.989690721649485 64 21 99 0 2 193 83 146 KAI5699564.1 hypothetical protein M8J75_005107 [Diaphorina citri] diamond 192 96.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
27420384 27420384 PRJNA1196384_S_NODE_7023_length_160_cov_1.487805_g6959_i0 PRJNA1196384 7023 160 1.487805 2.380488 Megalurothrips usitatus 439358 Arthropoda Arthropoda 52.8 3.54e-6   NR KAJ1523508.1 439358 g6959 i0 51.9 0.975 52 25 97.5 0 160 5 420 471 KAJ1523508.1 hypothetical protein ONE63_001360 [Megalurothrips usitatus] diamond 156 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Megalurothrips Megalurothrips usitatus
27451906 27451906 PRJNA1196384_S_NODE_7583_length_156_cov_1.268908_g7519_i0 PRJNA1196384 7583 156 1.268908 1.97949648 Lasius niger 67767 Arthropoda Arthropoda 79.7 9.11e-16   NR KMQ91225.1 67767 g7519 i0 77.1 2.88461538461538 48 11 92.3 0 144 1 242 289 KMQ91225.1 tyrosine-protein phosphatase non-receptor type 14 [Lasius niger] diamond 450 79.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Lasius Lasius niger
27470782 27470782 PRJNA1196384_S_NODE_663_length_464_cov_1.775176_g600_i0 PRJNA1196384 663 464 1.775176 8.23681664 Maniola 111919 Arthropoda Arthropoda 136 5.669999999999999e-34   NR XP_045778132.1 191418 g600 i0 45.8 3.00646551724138 155 77 99.6 5 462 1 360 508 XP_045778132.1 uncharacterized protein LOC123876048 [Maniola jurtina] diamond 1395 137 0.992700729927007 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Maniola Maniola jurtina
28196701 28196701 PRJNA1196384_S_NODE_7046_length_160_cov_1.252033_g6982_i0 PRJNA1196384 7046 160 1.252033 2.0032528 Arthropoda 6656 Arthropoda Arthropoda 64.3 4.61e-12   NR AAP68668.1 6687 g6982 i0 68.9 9.375 45 14 84.4 0 157 23 20 64 AAP68668.1 proteasome subunit alpha 1, partial [Penaeus monodon] diamond 1500 64.7 0.993817619783617 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon
28462272 28462272 PRJNA1196384_S_NODE_4706_length_186_cov_1.771812_g4642_i0 PRJNA1196384 4706 186 1.771812 3.29557032 Oedothorax gibbosus 931172 Arthropoda Arthropoda 75.1 3.1e-15   NR KAG8181787.1 931172 g4642 i0 59.3 4.54838709677419 59 24 95.2 0 184 8 92 150 KAG8181787.1 hypothetical protein JTE90_000079 [Oedothorax gibbosus] diamond 846 75.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Linyphiidae Oedothorax Oedothorax gibbosus
28481030 28481030 PRJNA1196384_S_NODE_7026_length_160_cov_1.422764_g6962_i0 PRJNA1196384 7026 160 1.422764 2.2764224 Diplostraca 84337 Arthropoda Arthropoda 73.6 9.57e-14   NR CAG4634982.1 381656 g6962 i0 67.3 16.14375 49 16 91.9 0 13 159 147 195 CAG4634982.1 EOG090X0AVX [Alona affinis] diamond 2583 73.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Chydoridae Alona Alona affinis
28702131 28702131 PRJNA1196384_S_NODE_5607_length_174_cov_1.394161_g5543_i0 PRJNA1196384 5607 174 1.394161 2.42584014 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 55.8 2.34e-7   NR QBH72806.1 32400 g5543 i0 67.6 5.10344827586207 37 12 63.8 0 174 64 199 235 QBH72806.1 proteasome subunit beta type [Encarsia formosa] diamond 888 55.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Aphelinidae Encarsia Encarsia formosa
28777673 28777673 PRJNA1196384_S_NODE_5947_length_170_cov_1.736842_g5883_i0 PRJNA1196384 5947 170 1.736842 2.9526314 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 90.9 8.02e-20   NR KAH9406166.1 59818 g5883 i0 66.1 3.95294117647059 56 19 98.8 0 2 169 315 370 KAH9406166.1 Translation elongation factor [Tyrophagus putrescentiae] diamond 672 90.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
29219983 29219983 PRJNA1196384_S_NODE_7309_length_158_cov_0.950413_g7245_i0 PRJNA1196384 7309 158 0.950413 1.50165254 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 47.8 2e-4   NR XP_040578903.1 72036 g7245 i0 57.6 0.626582278481013 33 14 62.7 0 154 56 514 546 XP_040578903.1 FYVE, RhoGEF and PH domain-containing protein 6-like [Lepeophtheirus salmonis] diamond 99 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
29333509 29333509 PRJNA1196384_S_NODE_3149_length_219_cov_2.071429_g3085_i0 PRJNA1196384 3149 219 2.071429 4.53642951 Insecta 50557 Arthropoda Arthropoda 53.1 1.87e-6   NR XP_015834104.1 7070 g3085 i0 65.5 4.76712328767123 29 10 39.7 0 218 132 133 161 XP_015834104.1 nucleoside diphosphate kinase isoform X2 [Tribolium castaneum] diamond 1044 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum
29585797 29585797 PRJNA1196384_S_NODE_3410_length_212_cov_3.074286_g3346_i0 PRJNA1196384 3410 212 3.074286 6.51748632 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 103 1.39e-25   NR ACO10404.1 217165 g3346 i0 65.7 11.8867924528302 70 24 99.1 0 2 211 28 97 ACO10404.1 40S ribosomal protein S5 [Caligus rogercresseyi] diamond 2520 103 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Caligus Caligus rogercresseyi
29756443 29756443 PRJNA1196384_S_NODE_5311_length_178_cov_1.042553_g5247_i0 PRJNA1196384 5311 178 1.042553 1.85574434 Rhipicephalus microplus 6941 Arthropoda Arthropoda 70.5 3.52e-13   NR KAH8022129.1 6941 g5247 i0 75 14.7134831460674 40 9 65.7 1 42 158 84 123 KAH8022129.1 hypothetical protein HPB51_022011 [Rhipicephalus microplus] diamond 2619 70.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
30723251 30723251 PRJNA1196384_S_NODE_4374_length_191_cov_1.753247_g4310_i0 PRJNA1196384 4374 191 1.753247 3.34870177 Opisthokonta 33154 Arthropoda Arthropoda 46.6 7.36e-4   NR XP_001607539.1 7425 g4310 i0 50.8 8.04188481675393 61 29 94.2 1 180 1 10 70 XP_001607539.1 60S ribosomal protein L7 isoform X2 [Nasonia vitripennis] diamond 1536 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Nasonia Nasonia vitripennis
30881245 30881245 PRJNA1196384_S_NODE_6354_length_166_cov_0.906977_g6290_i0 PRJNA1196384 6354 166 0.906977 1.50558182 Metazoa 33208 Arthropoda Arthropoda 112 3.4400000000000003e-29   NR XP_059081437.1 6832 g6290 i0 100 314.096385542169 55 0 99.4 0 2 166 26 80 XP_059081437.1 ras-related protein Rab-5C-like [Tigriopus californicus] diamond 52140 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
31260537 31260537 PRJNA1196384_S_NODE_1015_length_380_cov_3.049563_g951_i0 PRJNA1196384 1015 380 3.049563 11.5883394 Culex 7174 Arthropoda Arthropoda 158 2.99e-46   NR XP_001844844.1 7176 g951 i0 74 3.93947368421053 100 26 78.9 0 6 305 97 196 XP_001844844.1 peroxiredoxin 1 [Culex quinquefasciatus] diamond 1497 158 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
31273178 31273178 PRJNA1196384_S_NODE_1295_length_339_cov_4.920530_g1231_i0 PRJNA1196384 1295 339 4.92053 16.6805967 Euwallacea fornicatus 995702 Arthropoda Arthropoda 76.6 5.91e-15   NR XP_066139175.1 995702 g1231 i0 53.2 0.831858407079646 94 41 83.2 2 331 50 65 155 XP_066139175.1 large ribosomal subunit protein eL24 [Euwallacea fornicatus] diamond 282 76.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Euwallacea Euwallacea fornicatus
31336274 31336274 PRJNA1196384_S_NODE_5996_length_169_cov_3.803030_g5932_i0 PRJNA1196384 5996 169 3.80303 6.4271207 Limulus polyphemus 6850 Arthropoda Arthropoda 67.8 1.36e-11   NR XP_022248706.1 6850 g5932 i0 49.1 1.95266272189349 55 28 97.6 0 167 3 188 242 XP_022248706.1 LIM domain and actin-binding protein 1-like isoform X1 [Limulus polyphemus] diamond 330 67.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
31368265 31368265 PRJNA1196384_S_NODE_8276_length_151_cov_2.324561_g8212_i0 PRJNA1196384 8276 151 2.324561 3.51008711 Tetranychus urticae 32264 Arthropoda Arthropoda 53.9 1.17e-6   NR XP_015791309.1 32264 g8212 i0 53.3 4.49006622516556 45 20 87.4 1 145 14 173 217 XP_015791309.1 cathepsin L1 [Tetranychus urticae] diamond 678 53.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
31905713 31905713 PRJNA1196384_S_NODE_3797_length_203_cov_2.343373_g3733_i0 PRJNA1196384 3797 203 2.343373 4.75704719 Artemia franciscana 6661 Arthropoda Arthropoda 105 2.51e-25   NR XP_065566647.1 6661 g3733 i0 74.6 1.98029556650246 67 17 99 0 202 2 17 83 XP_065566647.1 large ribosomal subunit protein uL10-like [Artemia franciscana] diamond 402 105 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
32475492 32475492 PRJNA1196384_S_NODE_1939_length_281_cov_5.258197_g1875_i0 PRJNA1196384 1939 281 5.258197 14.77553357 Ixodes persulcatus 34615 Arthropoda Arthropoda 180 1.0799999999999998e-55   NR CAL6262610.1 34615 g1875 i0 94.6 5.95729537366548 93 5 99.3 0 3 281 38 130 CAL6262610.1 unnamed protein product [Ixodes persulcatus] diamond 1674 180 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes persulcatus
32664475 32664475 PRJNA1196384_S_NODE_1340_length_334_cov_3.643098_g1276_i0 PRJNA1196384 1340 334 3.643098 12.16794732 Euroglyphus maynei 6958 Arthropoda Arthropoda 113 1.16e-27   NR OTF73674.1 6958 g1276 i0 63.6 3.90718562874252 88 32 79 0 334 71 194 281 OTF73674.1 60S acidic ribosomal protein P0-like protein [Euroglyphus maynei] diamond 1305 113 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Euroglyphus Euroglyphus maynei

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