RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA801875" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 28 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA801875 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
9729164 9729164 PRJNA801875_P_NODE_3508_length_175_cov_1.328571_g3405_i0 PRJNA801875 3508 175 1.328571 2.32499925 Lucilia sericata 13632 Arthropoda Arthropoda 65.5 1.43e-10   NR XP_037806544.1 13632 g3405 i0 51.9 4.45714285714286 52 25 89.1 0 14 169 254 305 XP_037806544.1 ovarian-specific serine/threonine-protein kinase Lok [Lucilia sericata] diamond 780 65.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia sericata
12280569 12280569 PRJNA801875_P_NODE_4550_length_153_cov_1.644068_g4447_i0 PRJNA801875 4550 153 1.644068 2.51542404 Arthropoda 6656 Arthropoda Arthropoda 95.1 2.38e-22   NR RZF43028.1 195883 g4447 i0 92 12.7450980392157 50 4 98 0 4 153 138 187 RZF43028.1 hypothetical protein LSTR_LSTR001206 [Laodelphax striatellus] diamond 1950 95.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Laodelphax Laodelphax striatellus
16103606 16103606 PRJNA801875_P_NODE_3653_length_171_cov_2.220588_g3550_i0 PRJNA801875 3653 171 2.220588 3.79720548 Degeeriella rufa 236531 Arthropoda Arthropoda 80.1 1.35e-16   NR UTN43047.1 236531 g3550 i0 65.5 1.89473684210526 55 19 96.5 0 3 167 144 198 UTN43047.1 cytochrome c oxidase subunit 2 [Degeeriella rufa] diamond 324 80.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Philopteridae Degeeriella Degeeriella rufa
26642509 26642509 PRJNA801875_P_NODE_2321_length_229_cov_3.860825_g2218_i0 PRJNA801875 2321 229 3.860825 8.84128925 Lispe orientalis 520026 Arthropoda Arthropoda 68.2 9.58e-12   NR ACD50027.1 520026 g2218 i0 49.2 3.95633187772926 63 32 82.5 0 3 191 48 110 ACD50027.1 cytochrome oxidase subunit II, partial [Lispe orientalis] diamond 906 68.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Lispe Lispe orientalis
26800895 26800895 PRJNA801875_P_NODE_4341_length_157_cov_1.262295_g4238_i0 PRJNA801875 4341 157 1.262295 1.98180315 Daphnia carinata 120202 Arthropoda Arthropoda 46.6 4.91e-4   NR XP_059352378.1 120202 g4238 i0 48.9 0.859872611464968 45 23 86 0 143 9 799 843 XP_059352378.1 CCAAT/enhancer-binding protein zeta-like isoform X2 [Daphnia carinata] diamond 135 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia carinata
26896178 26896178 PRJNA801875_P_NODE_1761_length_282_cov_2.611336_g1658_i0 PRJNA801875 1761 282 2.611336 7.36396752 Drosophila kikkawai 30033 Arthropoda Arthropoda 44.3 0.0172   NR XP_017022451.2 30033 g1658 i0 54.8 0.329787234042553 31 14 33 0 278 186 359 389 XP_017022451.2 probable multidrug resistance-associated protein lethal(2)03659 [Drosophila kikkawai] diamond 93 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila kikkawai
26990630 26990630 PRJNA801875_P_NODE_2082_length_248_cov_3.342723_g1979_i0 PRJNA801875 2082 248 3.342723 8.28995304 Neocloeon triangulifer 2078957 Arthropoda Arthropoda 62.8 3.44e-9   NR XP_059475622.1 2078957 g1979 i0 48.6 0.895161290322581 74 36 87.1 1 224 9 62 135 XP_059475622.1 protein scarlet isoform X1 [Neocloeon triangulifer] diamond 222 62.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Baetidae Neocloeon Neocloeon triangulifer
26999588 26999588 PRJNA801875_P_NODE_1602_length_301_cov_1.631579_g1499_i0 PRJNA801875 1602 301 1.631579 4.91105279 Lepidoptera 7088 Arthropoda Arthropoda 77.4 4.11e-14   NR XP_039763282.1 116150 g1499 i0 41.7 2.0531561461794 103 52 98.7 3 2 298 310 408 XP_039763282.1 dnaJ homolog subfamily A member 2-like [Pararge aegeria] diamond 618 77.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Pararge Pararge aegeria
27054214 27054214 PRJNA801875_P_NODE_3202_length_185_cov_1.033333_g3099_i0 PRJNA801875 3202 185 1.033333 1.91166605 Xylocopa violacea 135666 Arthropoda Arthropoda 42 0.0317   NR CAL7946027.1 135666 g3099 i0 39.3 0.989189189189189 61 35 95.7 1 178 2 179 239 CAL7946027.1 unnamed protein product [Xylocopa violacea] diamond 183 42 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Xylocopa Xylocopa violacea
27148523 27148523 PRJNA801875_P_NODE_3482_length_176_cov_1.113475_g3379_i0 PRJNA801875 3482 176 1.113475 1.959716 Schistocerca piceifrons 274613 Arthropoda Arthropoda 49.7 5.38e-5   NR XP_047119985.1 274613 g3379 i0 49.1 0.9375 55 28 93.8 0 5 169 438 492 XP_047119985.1 ATP-binding cassette sub-family G member 4 [Schistocerca piceifrons] diamond 165 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca piceifrons
27686341 27686341 PRJNA801875_P_NODE_1844_length_274_cov_2.121339_g1741_i0 PRJNA801875 1844 274 2.121339 5.81246886 Planococcus citri 170843 Arthropoda Arthropoda 49.7 2.03e-4   NR XP_065203541.1 170843 g1741 i0 32.3 1.01824817518248 93 44 81 4 270 49 788 880 XP_065203541.1 neurogenic locus notch homolog protein 2-like [Planococcus citri] diamond 279 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pseudococcidae Planococcus Planococcus citri
28263007 28263007 PRJNA801875_P_NODE_4266_length_158_cov_2.430894_g4163_i0 PRJNA801875 4266 158 2.430894 3.84081252 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 44.7 0.00244   NR XP_023233844.1 218467 g4163 i0 45.2 2.62025316455696 42 23 79.7 0 17 142 86 127 XP_023233844.1 MAP kinase-activated protein kinase 2-like [Centruroides sculpturatus] diamond 414 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides sculpturatus
29084232 29084232 PRJNA801875_P_NODE_728_length_500_cov_2.075269_g626_i0 PRJNA801875 728 500 2.075269 10.376345 Psychodidae 7197 Arthropoda Arthropoda 122 1.9799999999999996e-31   NR XP_055693994.1 7200 g626 i0 40.7 4.056 167 94 97.8 3 9 497 11 176 XP_055693994.1 probable elongation factor 1-beta [Lutzomyia longipalpis] diamond 2028 122 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Lutzomyia Lutzomyia longipalpis
29327741 29327741 PRJNA801875_P_NODE_3829_length_168_cov_0.879699_g3726_i0 PRJNA801875 3829 168 0.879699 1.47789432 Halotydeus destructor 2874060 Arthropoda Arthropoda 44.3 0.00385   NR KAI1295372.1 2874060 g3726 i0 36.2 0.839285714285714 47 30 83.9 0 11 151 313 359 KAI1295372.1 Transient receptor potential cation channel subfamily A member 1 [Halotydeus destructor] diamond 141 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
29336743 29336743 PRJNA801875_P_NODE_4529_length_154_cov_0.983193_g4426_i0 PRJNA801875 4529 154 0.983193 1.51411722 Opisthokonta 33154 Arthropoda Arthropoda 73.6 1.51e-13   NR CAD7276159.1 399045 g4426 i0 54.9 5.9025974025974 51 23 99.4 0 153 1 108 158 CAD7276159.1 unnamed protein product [Notodromas monacha] diamond 909 73.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
29778705 29778705 PRJNA801875_P_NODE_2971_length_194_cov_1.540881_g2868_i0 PRJNA801875 2971 194 1.540881 2.98930914 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 95.1 3.04e-21   NR XP_029845771.2 6945 g2868 i0 73.4 3.95876288659794 64 17 99 0 2 193 97 160 XP_029845771.2 hydroxyacid oxidase 1 [Ixodes scapularis] diamond 768 95.9 0.991657977059437 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
29905233 29905233 PRJNA801875_P_NODE_3571_length_173_cov_2.630435_g3468_i0 PRJNA801875 3571 173 2.630435 4.55065255 Arthropoda 6656 Arthropoda Arthropoda 78.6 1.27e-16   NR XP_017494938.1 28612 g3468 i0 67.9 9.71098265895954 56 18 97.1 0 6 173 64 119 XP_017494938.1 PREDICTED: LOW QUALITY PROTEIN: 40S ribosomal protein S12-like [Rhagoletis zephyria] diamond 1680 78.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
29936742 29936742 PRJNA801875_P_NODE_4011_length_164_cov_0.906977_g3908_i0 PRJNA801875 4011 164 0.906977 1.48744228 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 81.3 3.01e-16   NR XP_063851112.1 85552 g3908 i0 62.3 4.8109756097561 53 20 97 0 159 1 306 358 XP_063851112.1 vacuolar protein sorting-associated protein 4-like [Scylla paramamosain] diamond 789 82 0.991463414634146 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
30379364 30379364 PRJNA801875_P_NODE_1232_length_362_cov_2.779817_g1129_i0 PRJNA801875 1232 362 2.779817 10.06293754 Insecta 50557 Arthropoda Arthropoda 62.8 1.41e-8   NR XP_055715451.1 29031 g1129 i0 36.7 2.23756906077348 98 61 81.2 1 63 356 59 155 XP_055715451.1 importin-11 [Phlebotomus papatasi] diamond 810 63.2 0.993670886075949 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Phlebotomus Phlebotomus papatasi
30410935 30410935 PRJNA801875_P_NODE_4593_length_153_cov_0.957627_g4490_i0 PRJNA801875 4593 153 0.957627 1.46516931 Metazoa 33208 Arthropoda Arthropoda 68.6 2.43e-12   NR TRY62750.1 6832 g4490 i0 75.6 16.0588235294118 41 10 80.4 0 153 31 178 218 TRY62750.1 hypothetical protein TCAL_04938, partial [Tigriopus californicus] diamond 2457 68.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
30505428 30505428 PRJNA801875_P_NODE_2613_length_210_cov_2.005714_g2510_i0 PRJNA801875 2613 210 2.005714 4.2119994 Insecta 50557 Arthropoda Arthropoda 45.4 0.00261   NR KAJ9580445.1 6984 g2510 i0 38 2.64285714285714 71 40 95.7 2 209 9 306 376 KAJ9580445.1 hypothetical protein L9F63_024381 [Diploptera punctata] diamond 555 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blaberidae Diploptera Diploptera punctata
31128038 31128038 PRJNA801875_P_NODE_2255_length_234_cov_3.321608_g2152_i0 PRJNA801875 2255 234 3.321608 7.77256272 Anoplophora glabripennis 217634 Arthropoda Arthropoda 102 7.010000000000001e-26   NR XP_018578213.1 217634 g2152 i0 84.1 7.14102564102564 63 10 80.8 0 218 30 71 133 XP_018578213.1 ubiquitin-like protein FUBI [Anoplophora glabripennis] diamond 1671 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Anoplophora Anoplophora glabripennis
31381498 31381498 PRJNA801875_P_NODE_2876_length_198_cov_1.184049_g2773_i0 PRJNA801875 2876 198 1.184049 2.34441702 Photinus pyralis 7054 Arthropoda Arthropoda 68.2 2.17e-11   NR XP_031352257.1 7054 g2773 i0 53.1 1.93939393939394 64 28 97 1 5 196 291 352 XP_031352257.1 GTP-binding protein 1-like [Photinus pyralis] diamond 384 68.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Photinus Photinus pyralis
32614967 32614967 PRJNA801875_P_NODE_3200_length_185_cov_1.260000_g3097_i0 PRJNA801875 3200 185 1.26 2.331 Contarinia nasturtii 265458 Arthropoda Arthropoda 62 1.06e-9   NR XP_031628877.1 265458 g3097 i0 53.4 0.940540540540541 58 27 94.1 0 1 174 136 193 XP_031628877.1 60S ribosomal protein L13 [Contarinia nasturtii] diamond 174 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Contarinia Contarinia nasturtii
32686623 32686623 PRJNA801875_P_NODE_3020_length_192_cov_1.503185_g2917_i0 PRJNA801875 3020 192 1.503185 2.8861152 Insecta 50557 Arthropoda Arthropoda 62 2.58e-9   NR XP_001960085.1 7217 g2917 i0 47.6 7.765625 63 33 98.4 0 191 3 82 144 XP_001960085.1 retinol dehydrogenase 11 isoform X2 [Drosophila ananassae] diamond 1491 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila ananassae
32709305 32709305 PRJNA801875_P_NODE_1920_length_266_cov_3.138528_g1817_i0 PRJNA801875 1920 266 3.138528 8.34848448 Armadillidium nasatum 96803 Arthropoda Arthropoda 64.7 8.91e-10   NR KAB7495024.1 96803 g1817 i0 62.1 8.25563909774436 58 19 62 1 171 7 6 63 KAB7495024.1 putative methylmalonate-semialdehyde dehydrogenase [acylating], mitochondrial [Armadillidium nasatum] diamond 2196 64.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Armadillidiidae Armadillidium Armadillidium nasatum
32718296 32718296 PRJNA801875_P_NODE_1460_length_321_cov_1.482517_g1357_i0 PRJNA801875 1460 321 1.482517 4.75887957 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 119 4.28e-29   NR XP_013105658.2 35570 g1357 i0 52.6 7.89719626168224 97 46 90.7 0 292 2 33 129 XP_013105658.2 succinyl-CoA:3-ketoacid-coenzyme A transferase, mitochondrial [Stomoxys calcitrans] diamond 2535 119 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Stomoxys Stomoxys calcitrans
32835261 32835261 PRJNA801875_P_NODE_4760_length_150_cov_1.991304_g4657_i0 PRJNA801875 4760 150 1.991304 2.986956 Orchesella dallaii 48710 Arthropoda Arthropoda 44.3 0.00269   NR CAL8141275.1 48710 g4657 i0 57.1 2.08 35 15 70 0 105 1 182 216 CAL8141275.1 unnamed protein product [Orchesella dallaii] diamond 312 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii

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