RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1089179" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1089179 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
11220987 11220987 PRJNA1089179_P_NODE_869_length_700_cov_126.526316_g853_i0 PRJNA1089179 869 700 126.526316 885.684212 Insecta 50557 Arthropoda Arthropoda 354 1.7999999999999994e-120   NR GLG98626.1 6999 g853 i0 90.6 32.1128571428571 191 18 81.9 0 625 53 62 252 GLG98626.1 Cdc42-like protein [Gryllus bimaculatus] diamond 22479 357 0.991596638655462 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Gryllidae Gryllus Gryllus bimaculatus
16771811 16771811 PRJNA1089179_P_NODE_1754_length_559_cov_78.298354_g1737_i0 PRJNA1089179 1754 559 78.298354 437.68779886 Metazoa 33208 Arthropoda Arthropoda 131 6.02e-32   NR XP_055941404.1 94029 g1737 i0 42.3 10.6475849731664 168 94 88.6 1 556 62 378 545 XP_055941404.1 phosphoacetylglucosamine mutase-like [Argiope bruennichi] diamond 5952 131 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Argiope Argiope bruennichi
26718962 26718962 PRJNA1089179_P_NODE_11941_length_272_cov_2.854271_g11923_i0 PRJNA1089179 11941 272 2.854271 7.76361712 Halotydeus destructor 2874060 Arthropoda Arthropoda 43.1 0.0376   NR KAI1303014.1 2874060 g11923 i0 38.1 0.463235294117647 42 23 43 1 132 248 174 215 KAI1303014.1 hypothetical protein HDE_02276 [Halotydeus destructor] diamond 126 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
26972554 26972554 PRJNA1089179_P_NODE_5402_length_370_cov_605.292929_g5384_i0 PRJNA1089179 5402 370 605.292929 2239.5838373 Penaeus monodon 6687 Arthropoda Arthropoda 61.6 1.43e-9   NR XP_037784063.1 6687 g5384 i0 44.6 0.527027027027027 65 36 52.7 0 74 268 13 77 XP_037784063.1 selenoprotein W-like isoform X1 [Penaeus monodon] diamond 195 61.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon
29562091 29562091 PRJNA1089179_P_NODE_12910_length_263_cov_42.836842_g12892_i0 PRJNA1089179 12910 263 42.836842 112.66089446 Eriocheir sinensis 95602 Arthropoda Arthropoda 58.5 1.28e-7   NR XP_050721788.1 95602 g12892 i0 49.1 5.96577946768061 53 27 60.5 0 105 263 140 192 XP_050721788.1 serine/threonine-protein kinase RIO1-like [Eriocheir sinensis] diamond 1569 58.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Varunidae Eriocheir Eriocheir sinensis
29562097 29562097 PRJNA1089179_P_NODE_17470_length_239_cov_2.975904_g17452_i0 PRJNA1089179 17470 239 2.975904 7.11241056 Henosepilachna vigintioctopunctata 420089 Arthropoda Arthropoda 71.2 1.38e-13   NR KAK9874347.1 420089 g17452 i0 83.3 0.527196652719665 42 7 52.7 0 12 137 91 132 KAK9874347.1 hypothetical protein WA026_002697 [Henosepilachna vigintioctopunctata] diamond 126 71.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Henosepilachna Henosepilachna vigintioctopunctata
29846421 29846421 PRJNA1089179_P_NODE_611_length_788_cov_146.650350_g597_i0 PRJNA1089179 611 788 146.65035 1155.604758 Centruroides sculpturatus 218467 Arthropoda Arthropoda 56.6 1.94e-5   NR XP_023231450.1 218467 g597 i0 35.5 0.289340101522843 76 48 28.9 1 596 369 6 80 XP_023231450.1 myb/SANT-like DNA-binding domain-containing protein 3 [Centruroides sculpturatus] diamond 228 56.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides sculpturatus
29941357 29941357 PRJNA1089179_P_NODE_711_length_745_cov_838.666667_g695_i0 PRJNA1089179 711 745 838.666667 6248.06666915 Euwallacea similis 1736056 Arthropoda Arthropoda 123 9.289999999999998e-31   NR XP_066254759.1 1736056 g695 i0 42.9 2.10201342281879 168 92 67.7 4 80 583 4 167 XP_066254759.1 glutathione S-transferase-like [Euwallacea similis] diamond 1566 123 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Euwallacea Euwallacea similis
30027485 30027485 PRJNA1089179_P_NODE_1831_length_551_cov_171.196653_g1814_i0 PRJNA1089179 1831 551 171.196653 943.29355803 Metazoa 33208 Arthropoda Arthropoda 82.4 1.09e-16   NR XP_022236583.1 6850 g1814 i0 35.7 1.24682395644283 112 71 61 1 417 82 3 113 XP_022236583.1 epididymal secretory protein E1-like [Limulus polyphemus] diamond 687 82.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
30289081 30289081 PRJNA1089179_P_NODE_532_length_819_cov_150.892761_g518_i0 PRJNA1089179 532 819 150.892761 1235.81171259 Diaphorina citri 121845 Arthropoda Arthropoda 166 9.9e-47   NR KAI5717590.1 121845 g518 i0 40.8 5.50549450549451 211 123 76.9 2 721 92 6 215 KAI5717590.1 hypothetical protein M8J77_008229 [Diaphorina citri] diamond 4509 166 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
30794135 30794135 PRJNA1089179_P_NODE_1914_length_543_cov_122.978723_g1897_i0 PRJNA1089179 1914 543 122.978723 667.77446589 Meganyctiphanes norvegica 48144 Arthropoda Arthropoda 91.3 1.69e-19   NR CAL4083374.1 48144 g1897 i0 32.9 0.823204419889503 149 92 80.1 3 32 466 25 169 CAL4083374.1 unnamed protein product [Meganyctiphanes norvegica] diamond 447 91.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
31078748 31078748 PRJNA1089179_P_NODE_13855_length_255_cov_1.642857_g13837_i0 PRJNA1089179 13855 255 1.642857 4.18928535 Haemaphysalis longicornis 44386 Arthropoda Arthropoda 58.2 1.54e-7   NR KAH9363350.1 44386 g13837 i0 48.3 1.36470588235294 58 17 68.2 1 9 182 324 368 KAH9363350.1 hypothetical protein HPB48_006456 [Haemaphysalis longicornis] diamond 348 58.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Haemaphysalis Haemaphysalis longicornis
31132911 31132911 PRJNA1089179_P_NODE_195_length_1070_cov_52.598796_g184_i0 PRJNA1089179 195 1070 52.598796 562.8071172 Insecta 50557 Arthropoda Arthropoda 166 1.45e-44   NR XP_069685803.1 6978 g184 i0 47.4 8.41682242990654 215 89 55.8 8 21 617 6 212 XP_069685803.1 cathepsin L-like peptidase isoform X1 [Periplaneta americana] diamond 9006 166 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
31837376 31837376 PRJNA1089179_P_NODE_2697_length_481_cov_569.200980_g2679_i0 PRJNA1089179 2697 481 569.20098 2737.8567138 Uloborus diversus 327109 Arthropoda Arthropoda 47.8 0.00322   NR XP_054715796.1 327109 g2679 i0 40.3 0.48024948024948 77 40 47.4 5 141 368 51 122 XP_054715796.1 pituitary tumor-transforming gene 1 protein-interacting protein-like [Uloborus diversus] diamond 231 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Uloboridae Uloborus Uloborus diversus
32280757 32280757 PRJNA1089179_P_NODE_699_length_747_cov_131.589021_g683_i0 PRJNA1089179 699 747 131.589021 982.96998687 Nephila pilipes 299642 Arthropoda Arthropoda 152 4.05e-42   NR GFS29626.1 299642 g683 i0 42.1 0.734939759036145 183 105 73.1 1 663 118 2 184 GFS29626.1 hypothetical protein NPIL_414791 [Nephila pilipes] diamond 549 152 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Nephila Nephila pilipes
32745745 32745745 PRJNA1089179_P_NODE_15220_length_248_cov_0.880000_g15202_i0 PRJNA1089179 15220 248 0.88 2.1824 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 43.1 0.0192   NR KAL1483214.1 34631 g15202 i0 45 3.27822580645161 40 22 48.4 0 5 124 59 98 KAL1483214.1 hypothetical protein MTO96_033354 [Rhipicephalus appendiculatus] diamond 813 43.5 0.990804597701149 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus appendiculatus
32848638 32848638 PRJNA1089179_P_NODE_3640_length_430_cov_1.182073_g3622_i0 PRJNA1089179 3640 430 1.182073 5.0829139 Daphnia magna 35525 Arthropoda Arthropoda 117 3.58e-30   NR KZS00800.1 35525 g3622 i0 46.1 0.893023255813953 128 65 87.9 2 378 1 3 128 KZS00800.1 Uncharacterized protein APZ42_002753, partial [Daphnia magna] diamond 384 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna

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