RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA1159911" 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

  • PRJNA1159911 · 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
2858738 2858738 PRJNA1159911_P_NODE_48743_length_353_cov_1.100000_g48201_i0 PRJNA1159911 48743 353 1.1 3.883 Oppiella nova 334625 Arthropoda Arthropoda 105 1.7799999999999995e-23   NR CAD7636591.1 334625 g48201 i0 53.2 0.943342776203966 111 31 94.3 1 3 335 311 400 CAD7636591.1 unnamed protein product [Oppiella nova] diamond 333 105 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
15610828 15610828 PRJNA1159911_P_NODE_55353_length_326_cov_1.521739_g54811_i0 PRJNA1159911 55353 326 1.521739 4.96086914 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 162 2.4799999999999996e-47   NR RXG69454.1 13347 g54811 i0 72.4 79.5092024539877 105 29 96.6 0 325 11 92 196 RXG69454.1 40S ribosomal protein S2 [Armadillidium vulgare] diamond 25920 163 0.993865030674847 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Armadillidiidae Armadillidium Armadillidium vulgare
17615591 17615591 PRJNA1159911_P_NODE_101234_length_241_cov_0.916667_g100692_i0 PRJNA1159911 101234 241 0.916667 2.20916747 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 100 1.05e-24   NR XP_055321163.1 263140 g100692 i0 87.1 0.771784232365145 62 8 77.2 0 207 22 100 161 XP_055321163.1 60S ribosomal protein L14 isoform X1 [Sitodiplosis mosellana] diamond 186 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
18159071 18159071 PRJNA1159911_P_NODE_20575_length_639_cov_2.014134_g20054_i0 PRJNA1159911 20575 639 2.014134 12.87031626 Drosophila busckii 30019 Arthropoda Arthropoda 190 1.01e-57   NR XP_017847377.1 30019 g20054 i0 61.1 5.94366197183099 162 60 75.6 3 15 497 21 180 XP_017847377.1 peroxiredoxin-5, mitochondrial [Drosophila busckii] diamond 3798 190 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila busckii
19433833 19433833 PRJNA1159911_P_NODE_44996_length_371_cov_2.197987_g44454_i0 PRJNA1159911 44996 371 2.197987 8.15453177 Opisthokonta 33154 Arthropoda Arthropoda 227 4.99e-73   NR XP_039962485.1 59916 g44454 i0 86.2 22.8355795148248 123 17 99.5 0 371 3 83 205 XP_039962485.1 peptidyl-prolyl cis-trans isomerase-like isoform X3 [Bactrocera tryoni] diamond 8472 227 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera tryoni
19434047 19434047 PRJNA1159911_P_NODE_55316_length_326_cov_1.810277_g54774_i0 PRJNA1159911 55316 326 1.810277 5.90150302 Ephemera danica 1049336 Arthropoda Arthropoda 117 2.8499999999999993e-28   NR KAF4516978.1 1049336 g54774 i0 72.2 4.28834355828221 79 20 70.9 1 325 95 385 463 KAF4516978.1 hypothetical protein B566_EDAN005580 [Ephemera danica] diamond 1398 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Ephemeridae Ephemera Ephemera danica
26977041 26977041 PRJNA1159911_P_NODE_85722_length_252_cov_6.184358_g85180_i0 PRJNA1159911 85722 252 6.184358 15.58458216 Anthophora plagiata 597819 Arthropoda Arthropoda 57.8 1.9e-7   NR CAK9813121.1 597819 g85180 i0 50.9 2.83333333333333 57 27 66.7 1 187 20 222 278 CAK9813121.1 Transposable element Tc1 transposase [Anthophora plagiata] diamond 714 58.2 0.993127147766323 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Anthophora Anthophora plagiata
27091359 27091359 PRJNA1159911_P_NODE_57442_length_319_cov_1.252033_g56900_i0 PRJNA1159911 57442 319 1.252033 3.99398527 Insecta 50557 Arthropoda Arthropoda 43.5 0.04   NR XP_023012208.1 7539 g56900 i0 30.7 1.7115987460815 88 54 82.8 2 270 7 99 179 XP_023012208.1 cysteine proteinase 3-like [Leptinotarsa decemlineata] diamond 546 43.9 0.990888382687927 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Leptinotarsa Leptinotarsa decemlineata
27154092 27154092 PRJNA1159911_P_NODE_85242_length_253_cov_2.333333_g84700_i0 PRJNA1159911 85242 253 2.333333 5.90333249 Tenebrionidae 7065 Arthropoda Arthropoda 46.2 0.00244   NR KAJ3631994.1 7067 g84700 i0 55.3 3.15415019762846 38 17 45.1 0 248 135 106 143 KAJ3631994.1 hypothetical protein MTP99_013093 [Tenebrio molitor] diamond 798 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
28354541 28354541 PRJNA1159911_P_NODE_36026_length_433_cov_2.488889_g35484_i0 PRJNA1159911 36026 433 2.488889 10.77688937 Arthropoda 6656 Arthropoda Arthropoda 121 3.5200000000000003e-29   NR XP_055707653.1 29031 g35484 i0 67 4.82909930715935 88 29 61 0 432 169 427 514 XP_055707653.1 succinyl-CoA:3-ketoacid-coenzyme A transferase, mitochondrial [Phlebotomus papatasi] diamond 2091 122 0.991803278688525 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Phlebotomus Phlebotomus papatasi
28745755 28745755 PRJNA1159911_P_NODE_55547_length_325_cov_2.007937_g55005_i0 PRJNA1159911 55547 325 2.007937 6.52579525 Idotea baltica 82763 Arthropoda Arthropoda 82.8 2.28e-18   NR MCL4165455.1 82763 g55005 i0 68.3 0.581538461538462 63 20 58.2 0 321 133 5 67 MCL4165455.1 hypothetical protein [Idotea baltica] diamond 189 82.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
29314087 29314087 PRJNA1159911_P_NODE_74349_length_274_cov_1.398010_g73807_i0 PRJNA1159911 74349 274 1.39801 3.8305474 Orchesella dallaii 48710 Arthropoda Arthropoda 73.6 7.23e-13   NR CAL8101517.1 48710 g73807 i0 45.7 0.886861313868613 81 42 87.6 2 2 241 293 372 CAL8101517.1 unnamed protein product [Orchesella dallaii] diamond 243 73.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii
29660973 29660973 PRJNA1159911_P_NODE_80190_length_262_cov_2.037037_g79648_i0 PRJNA1159911 80190 262 2.037037 5.33703694 Schistocerca gregaria 7010 Arthropoda Arthropoda 43.1 0.0334   NR XP_049855442.1 7010 g79648 i0 31.5 1.01908396946565 89 41 79 3 19 225 166 254 XP_049855442.1 translation initiation factor IF-2-like [Schistocerca gregaria] diamond 267 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
29755935 29755935 PRJNA1159911_P_NODE_101311_length_241_cov_0.916667_g100769_i0 PRJNA1159911 101311 241 0.916667 2.20916747 Dermacentor albipictus 60249 Arthropoda Arthropoda 48.1 4.26e-4   NR XP_070387400.1 60249 g100769 i0 55.9 0.423236514522822 34 15 42.3 0 4 105 57 90 XP_070387400.1 uncharacterized protein [Dermacentor albipictus] diamond 102 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Dermacentor Dermacentor albipictus
29755954 29755954 PRJNA1159911_P_NODE_87351_length_251_cov_0.865169_g86809_i0 PRJNA1159911 87351 251 0.865169 2.17157419 Orussus abietinus 222816 Arthropoda Arthropoda 46.2 0.00242   NR XP_012271711.1 222816 g86809 i0 36.9 0.776892430278884 65 33 68.1 2 245 75 15 79 XP_012271711.1 Meckel syndrome type 1 protein [Orussus abietinus] diamond 195 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Orussidae Orussus Orussus abietinus
29965008 29965008 PRJNA1159911_P_NODE_72211_length_278_cov_2.492683_g71669_i0 PRJNA1159911 72211 278 2.492683 6.92965874 Arthropoda 6656 Arthropoda Arthropoda 156 7.89e-46   NR RVE51549.1 168631 g71669 i0 89.4 43.6510791366906 85 9 91.7 0 256 2 28 112 RVE51549.1 hypothetical protein evm_003819 [Chilo suppressalis] diamond 12135 157 0.993630573248408 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Crambidae Chilo Chilo suppressalis
29977192 29977192 PRJNA1159911_P_NODE_94991_length_245_cov_1.151163_g94449_i0 PRJNA1159911 94991 245 1.151163 2.82034935 Anthonomus grandis grandis 2921223 Arthropoda Arthropoda 43.5 0.021   NR XP_050298339.1 2921223 g94449 i0 33.8 1.59183673469388 65 41 77.1 1 39 227 116 180 XP_050298339.1 uncharacterized protein LOC126737471 isoform X2 [Anthonomus grandis grandis] diamond 390 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Anthonomus Anthonomus grandis
29996691 29996691 PRJNA1159911_P_NODE_29331_length_499_cov_1.995305_g28791_i0 PRJNA1159911 29331 499 1.995305 9.95657195 Metazoa 33208 Arthropoda Arthropoda 161 7.909999999999999e-48   NR XP_065571790.1 6661 g28791 i0 66.4 4.63527054108216 110 37 66.1 0 9 338 22 131 XP_065571790.1 small ribosomal subunit protein eS12-like [Artemia franciscana] diamond 2313 161 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
30008997 30008997 PRJNA1159911_P_NODE_91071_length_248_cov_0.880000_g90529_i0 PRJNA1159911 91071 248 0.88 2.1824 Pollicipes pollicipes 41117 Arthropoda Arthropoda 58.9 1.69e-8   NR XP_037074987.1 41117 g90529 i0 61.9 1.51209677419355 42 16 50.8 0 247 122 96 137 XP_037074987.1 zinc finger protein 135-like [Pollicipes pollicipes] diamond 375 58.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Pollicipedomorpha Pollicipedidae Pollicipes Pollicipes pollicipes
30040373 30040373 PRJNA1159911_P_NODE_68051_length_288_cov_2.097674_g67509_i0 PRJNA1159911 68051 288 2.097674 6.04130112 Pseudolycoriella hygida 35572 Arthropoda Arthropoda 86.7 2.4e-17   NR KAJ6645188.1 35572 g67509 i0 52.5 1.03125 99 35 94.8 4 288 16 444 538 KAJ6645188.1 50S ribosomal protein L2 [Pseudolycoriella hygida] diamond 297 86.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
30356859 30356859 PRJNA1159911_P_NODE_91492_length_248_cov_0.880000_g90950_i0 PRJNA1159911 91492 248 0.88 2.1824 Ceratosolen solmsi marchali 326594 Arthropoda Arthropoda 180 9.35e-54   NR XP_011495742.1 326594 g90950 i0 100 0.967741935483871 80 0 96.8 0 241 2 265 344 XP_011495742.1 PREDICTED: transcriptional repressor protein YY1-like isoform X3 [Ceratosolen solmsi marchali] diamond 240 180 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Agaonidae Ceratosolen Ceratosolen solmsi
30388345 30388345 PRJNA1159911_P_NODE_102513_length_236_cov_2.042945_g101971_i0 PRJNA1159911 102513 236 2.042945 4.8213502 Bradysia odoriphaga 1564500 Arthropoda Arthropoda 73.2 2.11e-13   NR KAG4067902.1 1564500 g101971 i0 59.3 0.75 59 24 75 0 234 58 185 243 KAG4067902.1 hypothetical protein HA402_010588 [Bradysia odoriphaga] diamond 177 73.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia odoriphaga
31240927 31240927 PRJNA1159911_P_NODE_96635_length_244_cov_0.900585_g96093_i0 PRJNA1159911 96635 244 0.900585 2.1974274 Cyamophila willieti 2604842 Arthropoda Arthropoda 76.6 4.33e-14   NR KAL1461066.1 2604842 g96093 i0 48.6 0.885245901639344 72 36 87.3 1 27 239 387 458 KAL1461066.1 hypothetical protein WDU94_012997 [Cyamophila willieti] diamond 216 76.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Cyamophila Cyamophila willieti
31387050 31387050 PRJNA1159911_P_NODE_95816_length_244_cov_3.327485_g95274_i0 PRJNA1159911 95816 244 3.327485 8.1190634 Metazoa 33208 Arthropoda Arthropoda 44.3 0.00958   NR XP_037282431.1 6941 g95274 i0 87 1.97950819672131 23 3 28.3 0 242 174 250 272 XP_037282431.1 protein l(2)37Cc-like [Rhipicephalus microplus] diamond 483 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
31778688 31778688 PRJNA1159911_P_NODE_68657_length_287_cov_1.186916_g68115_i0 PRJNA1159911 68657 287 1.186916 3.40644892 Manduca sexta 7130 Arthropoda Arthropoda 56.6 6.74e-7   NR XP_037303361.1 7130 g68115 i0 44.9 0.721254355400697 69 36 72.1 1 239 33 73 139 XP_037303361.1 small glutamine-rich tetratricopeptide repeat-containing protein alpha-like [Manduca sexta] diamond 207 56.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Sphingidae Manduca Manduca sexta
31905227 31905227 PRJNA1159911_P_NODE_60857_length_308_cov_1.310638_g60315_i0 PRJNA1159911 60857 308 1.310638 4.03676504 Daktulosphaira vitifoliae 58002 Arthropoda Arthropoda 51.6 5.57e-5   NR XP_050524953.1 58002 g60315 i0 35.9 1.00324675324675 103 61 97.4 2 305 6 41 141 XP_050524953.1 partner of Y14 and mago [Daktulosphaira vitifoliae] diamond 309 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phylloxeridae Daktulosphaira Daktulosphaira vitifoliae
32031951 32031951 PRJNA1159911_P_NODE_91418_length_248_cov_0.880000_g90876_i0 PRJNA1159911 91418 248 0.88 2.1824 Exocentrus adspersus 1586481 Arthropoda Arthropoda 72.8 1.03e-12   NR KAJ8925076.1 1586481 g90876 i0 73.3 3.42338709677419 45 12 54.4 0 235 101 221 265 KAJ8925076.1 hypothetical protein NQ315_001248 [Exocentrus adspersus] diamond 849 72.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Exocentrus Exocentrus adspersus
32746462 32746462 PRJNA1159911_P_NODE_22360_length_602_cov_2.145558_g21834_i0 PRJNA1159911 22360 602 2.145558 12.91625916 Metazoa 33208 Arthropoda Arthropoda 333 3.04e-113   NR XP_027220166.1 6689 g21834 i0 89.4 140.621262458472 180 19 89.7 0 560 21 68 247 XP_027220166.1 ADP-ribosylation factor 1 isoform X1 [Penaeus vannamei] diamond 84654 335 0.994029850746269 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei

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