RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA560029" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA560029 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
544178 544178 PRJNA560029_S_NODE_4501_length_449_cov_4.574468_g4277_i0 PRJNA560029 4501 449 4.574468 20.53936132 root 1 Root_unresolved Root_unresolved 152 4.55e-42   NR XP_049838357.1 7010 g4277 i0 61.8 17.3986636971047 123 46 82.2 1 70 438 1 122 XP_049838357.1 aldo-keto reductase family 1 member B1-like isoform X1 [Schistocerca gregaria] diamond 7812 152 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
4371071 4371071 PRJNA560029_S_NODE_11344_length_356_cov_1.632509_g11120_i0 PRJNA560029 11344 356 1.632509 5.81173204 Opisthokonta 33154 Arthropoda Arthropoda 105 5.98e-24   NR UYV65547.1 51811 g11120 i0 65.8 17.9494382022472 79 27 66.6 0 1 237 324 402 UYV65547.1 RPL23A [Cordylochernes scorpioides] diamond 6390 105 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Pseudoscorpiones Chernetidae Cordylochernes Cordylochernes scorpioides
23496645 23496645 PRJNA560029_S_NODE_7079_length_399_cov_5.184049_g6855_i0 PRJNA560029 7079 399 5.184049 20.68435551 Arthropoda 6656 Arthropoda Arthropoda 176 5.83e-53   NR KAK7043288.1 373956 g6855 i0 77.9 12.5563909774436 104 23 78.2 0 317 6 1 104 KAK7043288.1 40S ribosomal protein S4, partial [Halocaridina rubra] diamond 5010 176 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Atyidae Halocaridina Halocaridina rubra
26857826 26857826 PRJNA560029_S_NODE_15901_length_325_cov_1.638889_g15677_i0 PRJNA560029 15901 325 1.638889 5.32638925 Holotrichia oblita 644536 Arthropoda Arthropoda 50.4 1.76e-4   NR KAI4461381.1 644536 g15677 i0 56.1 0.378461538461538 41 18 37.8 0 323 201 401 441 KAI4461381.1 ruvb-related reptin and pontin [Holotrichia oblita] diamond 123 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Scarabaeidae Holotrichia Holotrichia oblita
26903288 26903288 PRJNA560029_S_NODE_37381_length_221_cov_4.337838_g37157_i0 PRJNA560029 37381 221 4.337838 9.58662198 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 47.8 4.67e-4   NR XP_049849546.1 7010 g37157 i0 58.3 2.91855203619909 36 15 48.9 0 221 114 373 408 XP_049849546.1 uncharacterized protein LOC126319887 [Schistocerca gregaria] diamond 645 48.1 0.993762993762994 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
26997888 26997888 PRJNA560029_S_NODE_17922_length_313_cov_3.908333_g17698_i0 PRJNA560029 17922 313 3.908333 12.23308229 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 88.6 1.79e-18   NR XP_055388650.1 2530218 g17698 i0 46.8 3.57507987220447 94 50 90.1 0 313 32 211 304 XP_055388650.1 60S ribosomal protein L7a-like [Condylostylus longicornis] diamond 1119 89.4 0.991051454138702 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
27977324 27977324 PRJNA560029_S_NODE_2965_length_513_cov_31.890909_g2743_i0 PRJNA560029 2965 513 31.890909 163.60036317 root 1 Root_unresolved Root_unresolved 53.1 1.39e-4   NR GBN61280.1 182803 g2743 i0 50.9 2.85380116959064 53 26 31 0 124 282 1136 1188 GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] diamond 1464 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
28215746 28215746 PRJNA560029_S_NODE_9206_length_374_cov_5.318937_g8982_i0 PRJNA560029 9206 374 5.318937 19.89282438 Araneus ventricosus 182803 Arthropoda Arthropoda 49.7 5.4e-4   NR GBN01749.1 182803 g8982 i0 48.6 1.48395721925134 37 19 29.7 0 113 3 93 129 GBN01749.1 hypothetical protein AVEN_64609-1 [Araneus ventricosus] diamond 555 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
28310789 28310789 PRJNA560029_S_NODE_25606_length_277_cov_1.171569_g25382_i0 PRJNA560029 25606 277 1.171569 3.24524613 Pediculus humanus corporis 121224 Arthropoda Arthropoda 55.8 4.71e-8   NR XP_002432412.1 121224 g25382 i0 72.7 0.357400722021661 33 9 35.7 0 275 177 20 52 XP_002432412.1 ATP synthase epsilon chain, putative [Pediculus humanus corporis] diamond 99 55.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Pediculidae Pediculus Pediculus humanus
29335099 29335099 PRJNA560029_S_NODE_18509_length_310_cov_3.050633_g18285_i0 PRJNA560029 18509 310 3.050633 9.4569623 Araneidae 6913 Arthropoda Arthropoda 50.8 1.14e-4   NR KAF8785944.1 94029 g18285 i0 37.9 1.27741935483871 66 41 63.9 0 95 292 64 129 KAF8785944.1 Sodium-dependent glucose transporter 1 like protein [Argiope bruennichi] diamond 396 50.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Argiope Argiope bruennichi
29650373 29650373 PRJNA560029_S_NODE_36010_length_237_cov_3.280488_g35786_i0 PRJNA560029 36010 237 3.280488 7.77475656 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 49.7 1.21e-4   NR XP_015790989.1 32264 g35786 i0 34.2 3.68354430379747 76 47 94.9 2 2 226 459 532 XP_015790989.1 myotubularin-related protein 2 [Tetranychus urticae] diamond 873 50.1 0.992015968063872 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
30078842 30078842 PRJNA560029_S_NODE_8252_length_384_cov_26.983923_g8028_i0 PRJNA560029 8252 384 26.983923 103.61826432 Musca domestica 7370 Arthropoda Arthropoda 54.7 1.25e-5   NR XP_058975114.1 7370 g8028 i0 37.5 0.875 56 35 43.8 0 19 186 1269 1324 XP_058975114.1 uncharacterized protein LOC131801083 [Musca domestica] diamond 336 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Musca Musca domestica
30155901 30155901 PRJNA560029_S_NODE_36632_length_231_cov_3.329114_g36408_i0 PRJNA560029 36632 231 3.329114 7.69025334 root 1 Root_unresolved Root_unresolved 65.5 2.84e-10   NR XP_018497077.1 34638 g36408 i0 62 3.16883116883117 50 19 64.9 0 229 80 337 386 XP_018497077.1 aminomethyltransferase, mitochondrial [Galendromus occidentalis] diamond 732 65.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
30282937 30282937 PRJNA560029_S_NODE_7712_length_391_cov_4.125786_g7488_i0 PRJNA560029 7712 391 4.125786 16.13182326 Insecta 50557 Arthropoda Arthropoda 207 1.72e-64   NR XP_023718569.1 105785 g7488 i0 83.6 4.45012787723785 116 19 89 0 2 349 153 268 XP_023718569.1 60S ribosomal protein L7a [Cryptotermes secundus] diamond 1740 207 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Kalotermitidae Cryptotermes Cryptotermes secundus
31184519 31184519 PRJNA560029_S_NODE_29935_length_259_cov_1.967742_g29711_i0 PRJNA560029 29935 259 1.967742 5.09645178 Daphnia barbata 414587 Arthropoda Arthropoda 54.3 4e-6   NR SVE74005.1 414587 g29711 i0 44.4 0.938223938223938 81 40 91.5 3 13 249 1700 1777 SVE74005.1 EOG090X00E0 [Daphnia barbata] diamond 243 54.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia barbata
31342980 31342980 PRJNA560029_S_NODE_10756_length_360_cov_7.226481_g10532_i0 PRJNA560029 10756 360 7.226481 26.0153316 Aromia moschata 1265417 Arthropoda Arthropoda 94.4 2.48e-20   NR KAJ8943318.1 1265417 g10532 i0 59.3 4.14166666666667 59 24 49.2 0 5 181 252 310 KAJ8943318.1 hypothetical protein NQ318_004759 [Aromia moschata] diamond 1491 94.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Aromia Aromia moschata
31564595 31564595 PRJNA560029_S_NODE_11036_length_358_cov_4.361404_g10812_i0 PRJNA560029 11036 358 4.361404 15.61382632 Palaemon carinicauda 392227 Arthropoda Arthropoda 125 5.97e-31   NR XP_068233243.1 392227 g10812 i0 56.9 4.53351955307263 109 45 89.7 1 350 30 427 535 XP_068233243.1 phosphopentomutase isoform X2 [Palaemon carinicauda] diamond 1623 125 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Palaemon Palaemon carinicauda
31659053 31659053 PRJNA560029_S_NODE_5397_length_427_cov_3.759887_g5173_i0 PRJNA560029 5397 427 3.759887 16.05471749 Daphnia pulex 6669 Arthropoda Arthropoda 90.9 1.6e-18   NR EFX63653.1 6669 g5173 i0 39 2.86651053864169 136 71 89.9 3 421 38 38 169 EFX63653.1 hypothetical protein DAPPUDRAFT_268051 [Daphnia pulex] diamond 1224 90.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
31943751 31943751 PRJNA560029_S_NODE_29357_length_261_cov_3.893617_g29133_i0 PRJNA560029 29357 261 3.893617 10.16234037 Thrips palmi 161013 Arthropoda Arthropoda 49.3 2.2e-4   NR XP_034238337.1 161013 g29133 i0 46.7 0.689655172413793 60 28 64.4 1 193 26 391 450 XP_034238337.1 ammonium transporter Rh type A [Thrips palmi] diamond 180 49.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi

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