RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1073005 · 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
10390287 10390287 PRJNA1073005_P_NODE_9429_length_248_cov_0.880000_g9310_i0 PRJNA1073005 9429 248 0.88 2.1824 Euroglyphus maynei 6958 Arthropoda Arthropoda 127 1.31e-35   NR OTF82201.1 6958 g9310 i0 70.7 10.8991935483871 82 24 99.2 0 2 247 19 100 OTF82201.1 40S ribosomal protein S18-like protein [Euroglyphus maynei] diamond 2703 127 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Euroglyphus Euroglyphus maynei
21863835 21863835 PRJNA1073005_P_NODE_6518_length_345_cov_2.264706_g6399_i0 PRJNA1073005 6518 345 2.264706 7.8132357 Metazoa 33208 Arthropoda Arthropoda 199 3.7699999999999995e-57   NR XP_059082377.1 6832 g6399 i0 79.1 39.8260869565217 115 23 100 1 345 1 628 741 XP_059082377.1 translation elongation factor 2-like [Tigriopus californicus] diamond 13740 200 0.995 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
27532850 27532850 PRJNA1073005_P_NODE_9943_length_244_cov_0.900585_g9824_i0 PRJNA1073005 9943 244 0.900585 2.1974274 Metazoa 33208 Arthropoda Arthropoda 115 1.34e-27   NR KAJ6647572.1 35572 g9824 i0 70 40.5245901639344 80 17 98.4 1 1 240 489 561 KAJ6647572.1 RNA helicase aquarius, partial [Pseudolycoriella hygida] diamond 9888 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
27564196 27564196 PRJNA1073005_P_NODE_144_length_2259_cov_6.845837_g129_i0 PRJNA1073005 144 2259 6.845837 154.64745783 Insecta 50557 Arthropoda Arthropoda 103 1e-18   NR KAG6464791.1 7130 g129 i0 27.9 3.0066401062417 305 188 37.5 10 925 1770 2 297 KAG6464791.1 hypothetical protein O3G_MSEX014731 [Manduca sexta] diamond 6792 104 0.990384615384615 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Sphingidae Manduca Manduca sexta
27722728 27722728 PRJNA1073005_P_NODE_5204_length_415_cov_1.514620_g5085_i0 PRJNA1073005 5204 415 1.51462 6.285673 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 192 7.3e-59   NR CAH0775837.1 7038 g5085 i0 69.6 47.8048192771084 135 39 96.1 1 17 415 14 148 CAH0775837.1 unnamed protein product [Bemisia tabaci] diamond 19839 192 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
28015105 28015105 PRJNA1073005_P_NODE_9165_length_250_cov_0.870056_g9046_i0 PRJNA1073005 9165 250 0.870056 2.17514 Eurytemora carolleeae 1294199 Arthropoda Arthropoda 46.6 0.0018   NR XP_023344555.1 1294199 g9046 i0 35.3 0.612 51 33 61.2 0 30 182 447 497 XP_023344555.1 uncharacterized protein LOC111713829 [Eurytemora carolleeae] diamond 153 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Temoridae Eurytemora Eurytemora carolleeae
29237980 29237980 PRJNA1073005_P_NODE_9929_length_244_cov_0.900585_g9810_i0 PRJNA1073005 9929 244 0.900585 2.1974274 Metazoa 33208 Arthropoda Arthropoda 49.3 1.2e-4   NR XP_030751531.1 7048 g9810 i0 38.8 4.10655737704918 67 40 82.4 1 41 241 81 146 XP_030751531.1 regulator of G-protein signaling 7-like [Sitophilus oryzae] diamond 1002 49.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Sitophilus Sitophilus oryzae
29972585 29972585 PRJNA1073005_P_NODE_6811_length_332_cov_1.189189_g6692_i0 PRJNA1073005 6811 332 1.189189 3.94810748 Allacma fusca 39272 Arthropoda Arthropoda 111 8.03e-28   NR CAG7723843.1 39272 g6692 i0 51.4 0.984939759036145 109 52 98.5 1 327 1 9 116 CAG7723843.1 unnamed protein product [Allacma fusca] diamond 327 111 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
30352305 30352305 PRJNA1073005_P_NODE_6492_length_347_cov_1.164234_g6373_i0 PRJNA1073005 6492 347 1.164234 4.03989198 Idotea baltica 82763 Arthropoda Arthropoda 107 1.2e-26   NR MCL4113740.1 82763 g6373 i0 55.8 0.821325648414986 95 41 81.3 1 283 2 7 101 MCL4113740.1 hypothetical protein [Idotea baltica] diamond 285 107 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
30352306 30352306 PRJNA1073005_P_NODE_9292_length_249_cov_0.875000_g9173_i0 PRJNA1073005 9292 249 0.875 2.17875 Daphnia pulex 6669 Arthropoda Arthropoda 53.5 1.11e-6   NR EFX90100.1 6669 g9173 i0 35.4 1.95180722891566 79 44 86.7 2 240 25 35 113 EFX90100.1 hypothetical protein DAPPUDRAFT_40094 [Daphnia pulex] diamond 486 53.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
30730875 30730875 PRJNA1073005_P_NODE_9874_length_244_cov_1.801170_g9755_i0 PRJNA1073005 9874 244 1.80117 4.3948548 Procambarus clarkii 6728 Arthropoda Arthropoda 89.4 2.07e-19   NR AXR98485.1 6728 g9755 i0 61.3 1.52459016393443 62 24 76.2 0 59 244 114 175 AXR98485.1 papain family cysteine protease, partial [Procambarus clarkii] diamond 372 90.1 0.992230854605993 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
30785589 30785589 PRJNA1073005_P_NODE_10174_length_242_cov_1.124260_g10055_i0 PRJNA1073005 10174 242 1.12426 2.7207092 Opisthokonta 33154 Arthropoda Arthropoda 80.5 4.94e-17   NR XP_021952128.1 158441 g10055 i0 64.4 16.8223140495868 59 21 73.1 0 178 2 49 107 XP_021952128.1 40S ribosomal protein S12 [Folsomia candida] diamond 4071 80.9 0.995055624227441 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Isotomidae Folsomia Folsomia candida
31164451 31164451 PRJNA1073005_P_NODE_9035_length_251_cov_0.865169_g8916_i0 PRJNA1073005 9035 251 0.865169 2.17157419 Insecta 50557 Arthropoda Arthropoda 53.5 6.28e-6   NR XP_063229579.1 93214 g8916 i0 43.2 3.77689243027888 74 35 87.3 3 8 226 338 405 XP_063229579.1 uncharacterized protein LOC134534858 isoform X2 [Bacillus rossius redtenbacheri] diamond 948 53.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Bacillidae Bacillus Bacillus rossius
31521225 31521225 PRJNA1073005_P_NODE_8276_length_273_cov_1.540000_g8157_i0 PRJNA1073005 8276 273 1.54 4.2042 Oppia nitens 1686743 Arthropoda Arthropoda 48.5 4.91e-4   NR XP_054165495.1 1686743 g8157 i0 32.2 0.956043956043956 87 58 94.5 1 7 264 308 394 XP_054165495.1 peroxisomal N(1)-acetyl-spermine/spermidine oxidase-like isoform X2 [Oppia nitens] diamond 261 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppia Oppia nitens
31837230 31837230 PRJNA1073005_P_NODE_4197_length_487_cov_2.183575_g4078_i0 PRJNA1073005 4197 487 2.183575 10.63401025 Limulus polyphemus 6850 Arthropoda Arthropoda 84.3 1.33e-15   NR XP_013792674.1 6850 g4078 i0 40 1.61396303901437 125 65 73.9 4 126 485 16 135 XP_013792674.1 sequestosome-1-like [Limulus polyphemus] diamond 786 84.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
32018755 32018755 PRJNA1073005_P_NODE_8718_length_258_cov_1.291892_g8599_i0 PRJNA1073005 8718 258 1.291892 3.33308136 Vespula 7451 Arthropoda Arthropoda 100 2e-22   NR XP_050869787.1 7454 g8599 i0 54.8 11.7093023255814 84 38 97.7 0 256 5 439 522 XP_050869787.1 phenylalanine--tRNA ligase beta subunit [Vespula vulgaris] diamond 3021 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Vespula Vespula vulgaris
32690928 32690928 PRJNA1073005_P_NODE_6380_length_352_cov_1.666667_g6261_i0 PRJNA1073005 6380 352 1.666667 5.86666784 Schistocerca gregaria 7010 Arthropoda Arthropoda 109 6.75e-26   NR XP_049850989.1 7010 g6261 i0 52.6 0.988636363636364 116 54 98.9 1 3 350 12 126 XP_049850989.1 uncharacterized protein LOC126324525 [Schistocerca gregaria] diamond 348 109 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria

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