RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA1139127" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 31 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1139127 · 31 ✖

analysis 1

  • diamond · 31 ✖
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
285329 285329 PRJNA1139127_P_NODE_5381_length_981_cov_1.745595_g5045_i0 PRJNA1139127 5381 981 1.745595 17.12428695 Oppiidae 229795 Arthropoda Arthropoda 277 1.36e-81   NR XP_054154392.1 1686743 g5045 i0 46.4 3.09480122324159 336 112 98.2 7 963 1 16 298 XP_054154392.1 moesin/ezrin/radixin homolog 1-like [Oppia nitens] diamond 3036 277 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppia Oppia nitens
5388280 5388280 PRJNA1139127_P_NODE_2425_length_1456_cov_3.082430_g2223_i0 PRJNA1139127 2425 1456 3.08243 44.8801808 Leptotrombidium deliense 299467 Arthropoda Arthropoda 422 4.13e-140   NR RWS31863.1 299467 g2223 i0 61.2 0.838598901098901 407 135 83.9 9 31 1251 119 502 RWS31863.1 Transforming protein p54/c-ets-1-like protein [Leptotrombidium deliense] diamond 1221 422 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense
5388564 5388564 PRJNA1139127_P_NODE_6465_length_886_cov_1.971710_g6089_i0 PRJNA1139127 6465 886 1.97171 17.4693506 Tetranychus urticae 32264 Arthropoda Arthropoda 275 6.18e-89   NR XP_015784999.1 32264 g6089 i0 80.1 0.562076749435666 166 29 55.2 2 250 738 81 245 XP_015784999.1 E3 ubiquitin-protein ligase znrf2 isoform X1 [Tetranychus urticae] diamond 498 275 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
8685387 8685387 PRJNA1139127_P_NODE_43007_length_251_cov_0.870787_g42514_i0 PRJNA1139127 43007 251 0.870787 2.18567537 Diptera 7147 Arthropoda Arthropoda 161 1.6099999999999998e-45   NR XP_055679713.1 7200 g42514 i0 90.4 14.8804780876494 83 8 99.2 0 250 2 355 437 XP_055679713.1 mitochondrial-processing peptidase subunit beta, partial [Lutzomyia longipalpis] diamond 3735 161 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Lutzomyia Lutzomyia longipalpis
15059903 15059903 PRJNA1139127_P_NODE_11712_length_613_cov_1.716667_g11245_i0 PRJNA1139127 11712 613 1.716667 10.52316871 Polyplax serrata 468196 Arthropoda Arthropoda 247 1.5599999999999999e-74   NR KAK6631307.1 468196 g11245 i0 85.1 2.8531810766721 141 21 69 0 514 92 3 143 KAK6631307.1 hypothetical protein RUM44_005833 [Polyplax serrata] diamond 1749 247 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
18883782 18883782 PRJNA1139127_P_NODE_1235_length_1896_cov_3.013165_g1133_i0 PRJNA1139127 1235 1896 3.013165 57.1296084 Dinothrombium tinctorium 1965070 Arthropoda Arthropoda 301 3.0299999999999994e-89   NR RWS09466.1 1965070 g1133 i0 56.3 0.488924050632911 309 124 47.3 6 15 911 1 308 RWS09466.1 CREB-regulated transcription coactivator 1-like isoform X3, partial [Dinothrombium tinctorium] diamond 927 301 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium
21961698 21961698 PRJNA1139127_P_NODE_10318_length_667_cov_2.217172_g9861_i0 PRJNA1139127 10318 667 2.217172 14.78853724 Tetranychus 32263 Arthropoda Arthropoda 360 8.329999999999997e-119   NR AYV89053.1 93132 g9861 i0 86.7 24.647676161919 211 27 94.9 1 34 666 4 213 AYV89053.1 heat shock protein HSP 90-alpha, partial [Tetranychus truncatus] diamond 16440 360 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus truncatus
26595333 26595333 PRJNA1139127_P_NODE_24941_length_364_cov_1.979381_g24449_i0 PRJNA1139127 24941 364 1.979381 7.20494684 Ephemera danica 1049336 Arthropoda Arthropoda 76.6 1.92e-13   NR KAF4531338.1 1049336 g24449 i0 66.7 0.445054945054945 54 18 44.5 0 163 2 1 54 KAF4531338.1 hypothetical protein B566_EDAN019457, partial [Ephemera danica] diamond 162 76.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Ephemeridae Ephemera Ephemera danica
27006975 27006975 PRJNA1139127_P_NODE_42222_length_252_cov_1.301676_g41729_i0 PRJNA1139127 42222 252 1.301676 3.28022352 Bradysia coprophila 38358 Arthropoda Arthropoda 55.8 8.55e-7   NR XP_037030323.1 38358 g41729 i0 71.8 0.464285714285714 39 11 46.4 0 250 134 11 49 XP_037030323.1 cytochrome c1 [Bradysia coprophila] diamond 117 55.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
27564757 27564757 PRJNA1139127_P_NODE_45024_length_248_cov_0.885714_g44531_i0 PRJNA1139127 45024 248 0.885714 2.19657072 Diptera 7147 Arthropoda Arthropoda 135 1.55e-36   NR XP_061395609.1 27455 g44531 i0 73.4 2.86693548387097 79 21 95.6 0 10 246 238 316 XP_061395609.1 phosphotriesterase-related protein-like [Musca vetustissima] diamond 711 135 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Musca Musca vetustissima
27607622 27607622 PRJNA1139127_P_NODE_17664_length_464_cov_2.355499_g17175_i0 PRJNA1139127 17664 464 2.355499 10.92951536 Oppiella nova 334625 Arthropoda Arthropoda 65.1 6.49e-9   NR CAD7639356.1 334625 g17175 i0 41.5 0.872844827586207 135 36 86 5 1 399 331 424 CAD7639356.1 unnamed protein product [Oppiella nova] diamond 405 65.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
27765557 27765557 PRJNA1139127_P_NODE_39064_length_266_cov_1.606218_g38571_i0 PRJNA1139127 39064 266 1.606218 4.27253988 Dermatophagoides farinae 6954 Arthropoda Arthropoda 163 2.43e-44   NR KAH9527758.1 6954 g38571 i0 98.9 0.992481203007519 88 1 99.2 0 2 265 592 679 KAH9527758.1 hypothetical protein DERF_001763 [Dermatophagoides farinae] diamond 264 163 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
27797118 27797118 PRJNA1139127_P_NODE_33804_length_294_cov_1.407240_g33311_i0 PRJNA1139127 33804 294 1.40724 4.1372856 Dermatophagoides farinae 6954 Arthropoda Arthropoda 85.9 8.24e-19   NR KAH9527810.1 6954 g33311 i0 91.1 0.459183673469388 45 4 45.9 0 291 157 72 116 KAH9527810.1 hypothetical protein DERF_001805 [Dermatophagoides farinae] diamond 135 85.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
28302091 28302091 PRJNA1139127_P_NODE_26986_length_344_cov_1.992620_g26494_i0 PRJNA1139127 26986 344 1.99262 6.8546128 Dinothrombium tinctorium 1965070 Arthropoda Arthropoda 115 2.6900000000000003e-27   NR RWS12765.1 1965070 g26494 i0 52.8 0.941860465116279 108 51 94.2 0 335 12 154 261 RWS12765.1 uncharacterized protein B4U79_01184 [Dinothrombium tinctorium] diamond 324 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium
28365088 28365088 PRJNA1139127_P_NODE_10266_length_669_cov_2.501678_g9811_i0 PRJNA1139127 10266 669 2.501678 16.73622582 Tetranychus urticae 32264 Arthropoda Arthropoda 120 1.45e-28   NR XP_015787799.1 32264 g9811 i0 64.6 1.28251121076233 96 34 43 0 528 241 249 344 XP_015787799.1 transcription factor AP-1 [Tetranychus urticae] diamond 858 120 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
28449243 28449243 PRJNA1139127_P_NODE_37446_length_274_cov_1.547264_g36953_i0 PRJNA1139127 37446 274 1.547264 4.23950336 Trombidiformes 83136 Arthropoda Arthropoda 149 2.56e-39   NR RWS23730.1 299467 g36953 i0 70.1 1.90510948905109 87 26 95.3 0 13 273 716 802 RWS23730.1 protein slit-like protein [Leptotrombidium deliense] diamond 522 149 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense
28838779 28838779 PRJNA1139127_P_NODE_48808_length_242_cov_1.355030_g48315_i0 PRJNA1139127 48808 242 1.35503 3.2791726 Tetranychus urticae 32264 Arthropoda Arthropoda 42.4 0.0368   NR XP_015785735.1 32264 g48315 i0 65.8 0.471074380165289 38 10 45.9 2 131 241 126 161 XP_015785735.1 uncharacterized protein LOC107363076 [Tetranychus urticae] diamond 114 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
28870375 28870375 PRJNA1139127_P_NODE_3368_length_1245_cov_2.345563_g3115_i0 PRJNA1139127 3368 1245 2.345563 29.20225935 Medioppia subpectinata 1979941 Arthropoda Arthropoda 52.8 0.00303   NR CAD7624057.1 1979941 g3115 i0 42.1 0.257831325301205 107 45 23.4 5 707 417 601 700 CAD7624057.1 unnamed protein product [Medioppia subpectinata] diamond 321 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
29060000 29060000 PRJNA1139127_P_NODE_8808_length_735_cov_2.004532_g8371_i0 PRJNA1139127 8808 735 2.004532 14.7333102 Medioppia subpectinata 1979941 Arthropoda Arthropoda 84.3 1.66e-14   NR CAD7624057.1 1979941 g8371 i0 33.6 0.910204081632653 223 98 82.9 10 37 645 831 1023 CAD7624057.1 unnamed protein product [Medioppia subpectinata] diamond 669 84.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
29901591 29901591 PRJNA1139127_P_NODE_44471_length_249_cov_0.875000_g43978_i0 PRJNA1139127 44471 249 0.875 2.17875 Lepidoptera 7088 Arthropoda Arthropoda 58.5 1.09e-7   NR KAG6465364.1 7130 g43978 i0 45.8 3.8433734939759 72 34 80.7 2 206 6 443 514 KAG6465364.1 hypothetical protein O3G_MSEX015105 [Manduca sexta] diamond 957 58.9 0.99320882852292 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Sphingidae Manduca Manduca sexta
29975616 29975616 PRJNA1139127_P_NODE_17831_length_461_cov_2.399485_g17342_i0 PRJNA1139127 17831 461 2.399485 11.06162585 Panonychus citri 50023 Arthropoda Arthropoda 197 2.8e-56   NR XP_053203855.1 50023 g17342 i0 55.2 1.88720173535792 145 65 94.4 0 435 1 44 188 XP_053203855.1 neprilysin-4-like [Panonychus citri] diamond 870 197 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri
30070300 30070300 PRJNA1139127_P_NODE_27832_length_337_cov_1.416667_g27340_i0 PRJNA1139127 27832 337 1.416667 4.77416779 Dinothrombium tinctorium 1965070 Arthropoda Arthropoda 93.6 1.63e-19   NR RWS18005.1 1965070 g27340 i0 58.5 2.29673590504451 65 27 57.9 0 335 141 995 1059 RWS18005.1 protein slit-like protein [Dinothrombium tinctorium] diamond 774 93.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium
30228295 30228295 PRJNA1139127_P_NODE_4972_length_1025_cov_2.154412_g4652_i0 PRJNA1139127 4972 1025 2.154412 22.082723 Dinothrombium tinctorium 1965070 Arthropoda Arthropoda 227 6.81e-68   NR RWS13080.1 1965070 g4652 i0 46 2.23024390243902 372 144 99.5 6 4 1023 6 352 RWS13080.1 ELL-associated factor 1-like protein [Dinothrombium tinctorium] diamond 2286 227 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium
30386743 30386743 PRJNA1139127_P_NODE_13253_length_565_cov_1.735772_g12774_i0 PRJNA1139127 13253 565 1.735772 9.8071118 Halotydeus destructor 2874060 Arthropoda Arthropoda 137 5.41e-36   NR KAI1285776.1 2874060 g12774 i0 49.7 0.907964601769911 171 65 80.7 5 110 565 89 257 KAI1285776.1 hypothetical protein HDE_11617 [Halotydeus destructor] diamond 513 137 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
31207374 31207374 PRJNA1139127_P_NODE_795_length_2202_cov_2.160169_g726_i0 PRJNA1139127 795 2202 2.160169 47.56692138 Tetranychus urticae 32264 Arthropoda Arthropoda 420 6.46e-131   NR XP_015786344.1 32264 g726 i0 41.3 0.880108991825613 646 240 71.5 16 67 1641 274 901 XP_015786344.1 uncharacterized protein LOC107363611 isoform X1 [Tetranychus urticae] diamond 1938 420 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
31524253 31524253 PRJNA1139127_P_NODE_36156_length_281_cov_1.125000_g35663_i0 PRJNA1139127 36156 281 1.125 3.16125 Dinothrombium tinctorium 1965070 Arthropoda Arthropoda 132 2.54e-33   NR RWS18005.1 1965070 g35663 i0 67.4 1.9644128113879 92 29 98.2 1 3 278 808 898 RWS18005.1 protein slit-like protein [Dinothrombium tinctorium] diamond 552 132 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium
31650451 31650451 PRJNA1139127_P_NODE_7657_length_802_cov_1.341564_g7255_i0 PRJNA1139127 7657 802 1.341564 10.75934328 Panonychus citri 50023 Arthropoda Arthropoda 306 6.5e-98   NR XP_053208572.1 50023 g7255 i0 57 0.983790523690773 263 113 98.4 0 797 9 47 309 XP_053208572.1 N-fatty-acyl-amino acid synthase/hydrolase PM20D1.2-like [Panonychus citri] diamond 789 306 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri
31682049 31682049 PRJNA1139127_P_NODE_3497_length_1222_cov_2.773716_g3239_i0 PRJNA1139127 3497 1222 2.773716 33.89480952 Panonychus citri 50023 Arthropoda Arthropoda 141 8.3e-34   NR XP_053204190.1 50023 g3239 i0 36 0.613747954173486 250 119 52.8 6 529 1173 151 394 XP_053204190.1 atrophin-1-like, partial [Panonychus citri] diamond 750 141 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri
32662398 32662398 PRJNA1139127_P_NODE_20280_length_420_cov_1.386167_g19789_i0 PRJNA1139127 20280 420 1.386167 5.8219014 Uroleucon formosanum 796250 Arthropoda Arthropoda 127 7.91e-34   NR KAL4148292.1 796250 g19789 i0 60.2 0.878571428571429 123 20 87.9 2 398 30 1 94 KAL4148292.1 hypothetical protein QTP88_002568 [Uroleucon formosanum] diamond 369 127 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Uroleucon Uroleucon formosanum
32683002 32683002 PRJNA1139127_P_NODE_3240_length_1270_cov_2.389307_g2997_i0 PRJNA1139127 3240 1270 2.389307 30.3441989 Tetranychidae 32262 Arthropoda Arthropoda 487 1.5399999999999995e-163   NR XP_015784813.1 32264 g2997 i0 58.2 1.78346456692913 376 156 88.8 1 1261 134 351 725 XP_015784813.1 neprilysin-4-like [Tetranychus urticae] diamond 2265 487 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
32693982 32693982 PRJNA1139127_P_NODE_36080_length_281_cov_1.822115_g35587_i0 PRJNA1139127 36080 281 1.822115 5.12014315 Cordylochernes scorpioides 51811 Arthropoda Arthropoda 59.3 8.66e-8   NR UYV62167.1 51811 g35587 i0 37.4 1.43060498220641 91 33 71.5 1 211 11 18 108 UYV62167.1 hypothetical protein LAZ67_1008101 [Cordylochernes scorpioides] diamond 402 59.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Pseudoscorpiones Chernetidae Cordylochernes Cordylochernes scorpioides

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