RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

34 rows where bioproject = "PRJEB11523" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 34 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB11523 · 34 ✖
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
13722 13722 PRJEB11523_P_NODE_2541_length_327_cov_7.787770_g2463_i0 PRJEB11523 2541 327 7.78777 25.4660079 Hyalella azteca 294128 Arthropoda Arthropoda 568 2.47e-157   NTclustered gi|2232419545|ref|XR_007157289.1| 294128 g2463 i0 99.054 52.6238532110092 317 2 97 1 1 317 2234 2549 PREDICTED: Hyalella azteca large subunit ribosomal RNA (LOC125179508), rRNA blastn 17208 568 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Hyalellidae Hyalella Hyalella azteca
13732 13732 PRJEB11523_P_NODE_4201_length_233_cov_1.793478_g4123_i0 PRJEB11523 4201 233 1.793478 4.17880374 Ceratitis capitata 7213 Arthropoda Arthropoda 137 5.6000000000000005e-28   NTclustered gi|1184342863|ref|XM_004522766.3| 7213 g4123 i0 88.496 9.52789699570815 113 13 48 0 121 233 560 448 PREDICTED: Ceratitis capitata 40S ribosomal protein S18 (LOC101450709), mRNA blastn 2220 137 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Ceratitis Ceratitis capitata
13746 13746 PRJEB11523_P_NODE_621_length_768_cov_3.336579_g558_i0 PRJEB11523 621 768 3.336579 25.62492672 Nylanderia fulva 613905 Arthropoda Arthropoda 627 1.0099999999999997e-174   NTclustered gi|1663740367|ref|XM_029313408.1| 613905 g558 i0 82.353 3.96484375 748 107 94 10 10 732 796 49 PREDICTED: Nylanderia fulva uncharacterized LOC114939175 (LOC114939175), mRNA blastn 3045 627 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Nylanderia Nylanderia fulva
1288001 1288001 PRJEB11523_P_NODE_3502_length_262_cov_2.272300_g3424_i0 PRJEB11523 3502 262 2.2723 5.953426 Drosophila melanogaster 7227 Arthropoda Arthropoda 433 7.31e-117   NTclustered gi|113204896|gb|BT028801.1| 7227 g3424 i0 99.578 90.4580152671756 237 1 90 0 1 237 438 674 Drosophila melanogaster LP21747 full insert cDNA blastn 23700 433 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
2563617 2563617 PRJEB11523_P_NODE_2563_length_325_cov_25.246377_g2485_i0 PRJEB11523 2563 325 25.246377 82.05072525 Timema californicum 61474 Arthropoda Arthropoda 52.8 0.031   NTclustered gi|1964641010|emb|OE180894.1| 61474 g2485 i0 100 0.0861538461538462 28 0 9 0 3 30 63288 63261 2_Tcm_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
2563671 2563671 PRJEB11523_P_NODE_8983_length_155_cov_3.424528_g8905_i0 PRJEB11523 8983 155 3.424528 5.3080184 Condylostylus longicornis 2530218 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2496071103|ref|XM_055516902.1| 2530218 g8905 i0 100 0.748387096774194 29 0 19 0 14 42 6350 6322 PREDICTED: Condylostylus longicornis putative uncharacterized protein DDB_G0282133 (LOC129606536), transcript variant X2, mRNA blastn 116 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
5116167 5116167 PRJEB11523_P_NODE_8285_length_163_cov_0.894737_g8207_i0 PRJEB11523 8285 163 0.894737 1.45842131 Artemia franciscana 6661 Arthropoda Arthropoda 276 7.41e-70   NTclustered gi|2743031592|ref|XM_065711973.1| 6661 g8207 i0 98.718 3.25766871165644 156 0 94 1 10 163 460 615 PREDICTED: Artemia franciscana large ribosomal subunit protein uL15-like (LOC136031960), mRNA blastn 531 276 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
7665987 7665987 PRJEB11523_P_NODE_5947_length_189_cov_4.157143_g5869_i0 PRJEB11523 5947 189 4.157143 7.85700027 Bemisia tabaci 7038 Arthropoda Arthropoda 52.8 0.016   NTclustered gi|1101370597|ref|XM_019061133.1| 7038 g5869 i0 100 0.148148148148148 28 0 15 0 2 29 937 964 PREDICTED: Bemisia tabaci uncharacterized LOC109043815 (LOC109043815), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
7666017 7666017 PRJEB11523_P_NODE_947_length_613_cov_2.549645_g874_i0 PRJEB11523 947 613 2.549645 15.62932385 Artemia franciscana 6661 Arthropoda Arthropoda 540 1.0599999999999999e-148   NTclustered gi|2743057791|ref|XM_065728991.1| 6661 g874 i0 84.31 17.0848287112561 580 61 94 14 36 610 2332 2886 PREDICTED: Artemia franciscana glycoprotein endo-alpha-1,2-mannosidase-like (LOC136043931), transcript variant X2, mRNA blastn 10473 540 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
8635646 8635646 PRJEB11523_P_NODE_727_length_708_cov_13.247344_g663_i0 PRJEB11523 727 708 13.247344 93.79119552 Artemia 6660 Arthropoda Arthropoda 1229 0   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g663 i0 99.556 74.4590395480226 675 2 95 1 26 700 1799 2472 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 52717 1229 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
8940721 8940721 PRJEB11523_P_NODE_3268_length_275_cov_2.030973_g3190_i0 PRJEB11523 3268 275 2.030973 5.58517575 Calliphora vicina 7373 Arthropoda Arthropoda 82.4 3.22e-11   NTclustered gi|2736833332|ref|XM_065507036.1| 7373 g3190 i0 97.872 1.13818181818182 47 1 17 0 1 47 2530 2484 PREDICTED: Calliphora vicina septin 4 (Sep4), transcript variant X1, mRNA blastn 313 82.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Calliphora Calliphora vicina
9910705 9910705 PRJEB11523_P_NODE_9188_length_151_cov_3.000000_g9110_i0 PRJEB11523 9188 151 3 4.53 Acaridae 41442 Arthropoda Arthropoda 276 6.72e-70   NTclustered gi|66390978|gb|DQ025510.1| 59818 g9110 i0 100 98.6688741721854 149 0 99 0 3 151 880 1028 Tyrophagus putrescentiae 18S ribosomal RNA gene, partial sequence blastn 14899 276 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
12767259 12767259 PRJEB11523_P_NODE_1351_length_496_cov_10.145414_g1273_i0 PRJEB11523 1351 496 10.145414 50.32125344 Coptotermes formosanus 36987 Arthropoda Arthropoda 54.7 0.013   NTclustered gi|506965362|gb|KC632258.1| 36987 g1273 i0 100 0.11491935483871 29 0 6 0 468 496 33 5 Coptotermes formosanus clone CFSNI2475 hypothetical protein mRNA, complete cds blastn 57 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
12767276 12767276 PRJEB11523_P_NODE_2871_length_299_cov_21.360000_g2793_i0 PRJEB11523 2871 299 21.36 63.8664 Penaeus monodon 6687 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|1832334880|gb|MK599468.1| 6687 g2793 i0 100 0.377926421404682 29 0 10 0 1 29 87 115 Penaeus monodon C-type lectin mRNA, complete cds blastn 113 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon
14041806 14041806 PRJEB11523_P_NODE_392_length_961_cov_37.446272_g336_i0 PRJEB11523 392 961 37.446272 359.85867392 Camponotus floridanus 104421 Arthropoda Arthropoda 1101 0   NTclustered gi|1418054895|ref|XM_011260219.3| 104421 g336 i0 88.466 43.426638917794 945 65 97 24 27 959 158 1070 PREDICTED: Camponotus floridanus uncharacterized LOC105252698 (LOC105252698), mRNA blastn 41733 1101 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Camponotus Camponotus floridanus
15315960 15315960 PRJEB11523_P_NODE_2973_length_292_cov_13.547325_g2895_i0 PRJEB11523 2973 292 13.547325 39.558189 Bombyx mori 7091 Arthropoda Arthropoda 60.2 1.62e-4   NTclustered gi|1237088976|dbj|LC316987.1| 7091 g2895 i0 97.143 0.311643835616438 35 1 12 0 258 292 62 28 Bombyx mori BmSfp53 mRNA for seminal fluid protein 53, complete cds blastn 91 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
15315975 15315975 PRJEB11523_P_NODE_4613_length_219_cov_4.388235_g4535_i0 PRJEB11523 4613 219 4.388235 9.61023465 Darwinula stevensoni 69355 Arthropoda Arthropoda 171 5.13e-38   NTclustered gi|1936727265|emb|LR914586.1| 69355 g4535 i0 82.812 2.6027397260274 192 31 87 2 23 213 1033 1223 Darwinula stevensoni blastn 570 171 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Darwinulidae Darwinula Darwinula stevensoni
16285130 16285130 PRJEB11523_P_NODE_1753_length_420_cov_3.708895_g1675_i0 PRJEB11523 1753 420 3.708895 15.577359 Metazoa 33208 Arthropoda Arthropoda 58.4 8.69e-4   NTclustered gi|2492455899|ref|XM_055444678.1| 263140 g1675 i0 97.059 6.4952380952381 34 1 8 0 311 344 894 927 PREDICTED: Sitodiplosis mosellana achaete-scute complex protein T8 (LOC129567599), transcript variant X1, mRNA blastn 2728 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
16590632 16590632 PRJEB11523_P_NODE_6334_length_183_cov_3.649254_g6256_i0 PRJEB11523 6334 183 3.649254 6.67813482 Galendromus occidentalis 34638 Arthropoda Arthropoda 147 6.949999999999999e-31   NTclustered gi|1078805367|ref|XM_003743429.2| 34638 g6256 i0 81.667 21.4098360655738 180 30 98 3 2 181 152 328 PREDICTED: Metaseiulus occidentalis endoplasmic reticulum chaperone BiP (LOC100901400), mRNA blastn 3918 147 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
17560400 17560400 PRJEB11523_P_NODE_4294_length_230_cov_1.690608_g4216_i0 PRJEB11523 4294 230 1.6906080000000001 3.8883984 Arthropoda 6656 Arthropoda Arthropoda 405 1.37e-108   NTclustered gi|1912461452|gb|MN857506.1| 59818 g4216 i0 99.55 91.9695652173913 222 1 97 0 1 222 3932 4153 Tyrophagus putrescentiae voucher UMMZ BMOC 17-0108-002 PMR 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 21153 405 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
17865478 17865478 PRJEB11523_P_NODE_1195_length_538_cov_27.173824_g1118_i0 PRJEB11523 1195 538 27.173824 146.19517312 Scylla paramamosain 85552 Arthropoda Arthropoda 63.9 2.44e-5   NTclustered gi|1184387702|emb|LT835105.1| 85552 g1118 i0 100 0.0631970260223048 34 0 6 0 1 34 6 39 Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) blastn 34 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
17865508 17865508 PRJEB11523_P_NODE_5235_length_204_cov_2.006452_g5157_i0 PRJEB11523 5235 204 2.006452 4.09316208 Lasius niger 67767 Arthropoda Arthropoda 372 1.2e-98   NTclustered gi|1907755039|gb|MT862424.1| 67767 g5157 i0 99.51 80.9950980392157 204 1 100 0 1 204 14442 14645 Lasius niger isolate DM415 mitochondrion blastn 16523 372 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Lasius Lasius niger
20414366 20414366 PRJEB11523_P_NODE_3897_length_244_cov_3.153846_g3819_i0 PRJEB11523 3897 244 3.153846 7.69538424 Artemia franciscana 6661 Arthropoda Arthropoda 246 9.409999999999999e-61   NTclustered gi|2743025959|ref|XM_065728334.1| 6661 g3819 i0 87.273 85.327868852459 220 23 89 5 1 217 8210 7993 PREDICTED: Artemia franciscana VWFA and cache domain-containing protein 1-like (LOC136043424), transcript variant X1, mRNA blastn 20820 246 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
20414370 20414370 PRJEB11523_P_NODE_4477_length_224_cov_1.165714_g4399_i0 PRJEB11523 4477 224 1.165714 2.61119936 Pseudophacopteron tuberculatum 2591580 Arthropoda Arthropoda 346 8.15e-91   NTclustered gi|1694459262|gb|MH758029.1| 2591580 g4399 i0 95.434 0.977678571428571 219 6 98 2 6 224 300 514 Pseudophacopteron tuberculatum isolate 112 28S ribosomal RNA gene, partial sequence blastn 219 346 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phacopteronidae Pseudophacopteron Pseudophacopteron tuberculatum
20414409 20414409 PRJEB11523_P_NODE_8297_length_163_cov_0.894737_g8219_i0 PRJEB11523 8297 163 0.894737 1.45842131 Culex quinquefasciatus 7176 Arthropoda Arthropoda 145 2.18e-30   NTclustered gi|78097483|gb|AC167561.3| 7176 g8219 i0 87.402 66.2331288343558 127 14 77 2 38 163 24065 23940 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940117D9, complete sequence blastn 10796 145 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
21690363 21690363 PRJEB11523_P_NODE_3678_length_253_cov_5.049020_g3600_i0 PRJEB11523 3678 253 5.04902 12.7740206 Tribolium castaneum 7070 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2733082144|emb|OX466062.1| 7070 g3600 i0 100 0.110671936758893 28 0 11 0 110 137 885558 885531 Tribolium castaneum genome assembly, chromosome: LG2 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum
21690400 21690400 PRJEB11523_P_NODE_718_length_712_cov_7.009050_g654_i0 PRJEB11523 718 712 7.00905 49.904436 Bombyx mori 7091 Arthropoda Arthropoda 54.7 0.02   NTclustered gi|1237088976|dbj|LC316987.1| 7091 g654 i0 94.444 0.050561797752809 36 1 5 1 1 36 28 62 Bombyx mori BmSfp53 mRNA for seminal fluid protein 53, complete cds blastn 36 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
21690411 21690411 PRJEB11523_P_NODE_818_length_667_cov_3.556634_g748_i0 PRJEB11523 818 667 3.556634 23.72274878 Amblyseius sp. ARP-2015 1712292 Arthropoda Arthropoda 1144 0   NTclustered gi|938018641|gb|KP276389.1| 1712292 g748 i0 98.607 43.1184407796102 646 9 97 0 17 662 1663 2308 Amblyseius sp. ARP-2015 isolate AC16 large subunit ribosomal RNA gene, partial sequence blastn 28760 1144 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Amblyseius Amblyseius sp. ARP-2015
22965631 22965631 PRJEB11523_P_NODE_559_length_809_cov_4.275000_g498_i0 PRJEB11523 559 809 4.275 34.58475 Formica exsecta 72781 Arthropoda Arthropoda 920 0   NTclustered gi|1697944446|ref|XM_029813367.1| 72781 g498 i0 91.945 42.2707045735476 658 51 81 1 2 657 772 115 PREDICTED: Formica exsecta protein D2-like (LOC115239046), transcript variant X4, mRNA blastn 34197 920 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Formica Formica exsecta
26994730 26994730 PRJEB11523_P_NODE_3082_length_286_cov_2.000000_g3004_i0 PRJEB11523 3082 286 2 5.72 root 1 Root_unresolved Root_unresolved 57 5.17e-7   NR XP_050460981.1 1086592 g3004 i0 68.6 3.88111888111888 35 11 36.7 0 180 284 41 75 XP_050460981.1 dehydrogenase/reductase SDR family member 7 isoform X2 [Cataglyphis hispanica] diamond 1110 57.4 0.993031358885017 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Cataglyphis Cataglyphis hispanica
27728132 27728132 PRJEB11523_P_NODE_2944_length_295_cov_1.796748_g2866_i0 PRJEB11523 2944 295 1.796748 5.3004066 Idotea baltica 82763 Arthropoda Arthropoda 98.2 3.64e-24   NR MCL4162242.1 82763 g2866 i0 86.8 0.538983050847458 53 7 53.9 0 16 174 24 76 MCL4162242.1 hypothetical protein [Idotea baltica] diamond 159 98.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
28769643 28769643 PRJEB11523_P_NODE_3067_length_287_cov_1.789916_g2989_i0 PRJEB11523 3067 287 1.789916 5.13705892 Penaeus vannamei 6689 Arthropoda Arthropoda 44.7 0.0125   NR ROT79663.1 6689 g2989 i0 55.6 0.752613240418119 72 24 75.3 3 61 276 81 144 ROT79663.1 hypothetical protein C7M84_001611 [Penaeus vannamei] diamond 216 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
29205838 29205838 PRJEB11523_P_NODE_389_length_968_cov_32.267682_g333_i0 PRJEB11523 389 968 32.267682 312.35116176 Arachnida 6854 Arthropoda Arthropoda 54.7 2.69e-4   NR XP_053206642.1 50023 g333 i0 51.4 0.963842975206612 35 17 10.8 0 265 369 110 144 XP_053206642.1 LOW QUALITY PROTEIN: uncharacterized protein LOC128390894 [Panonychus citri] diamond 933 55.1 0.992740471869329 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri
31543675 31543675 PRJEB11523_P_NODE_5016_length_209_cov_6.037500_g4938_i0 PRJEB11523 5016 209 6.0375 12.618375 Metazoa 33208 Arthropoda Arthropoda 96.3 3.13e-21   NR XP_053214876.1 50023 g4938 i0 85.5 15.1291866028708 62 9 89 0 208 23 408 469 XP_053214876.1 excitatory amino acid transporter-like isoform X2 [Panonychus citri] diamond 3162 97.1 0.991761071060762 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri

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