RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1240805" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1240805 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
5452899 5452899 PRJNA1240805_P_NODE_1045_length_488_cov_8.473804_g998_i0 PRJNA1240805 1045 488 8.473804 41.35216352 Arthropoda 6656 Arthropoda Arthropoda 188 3.04e-58   NR XP_032793488.1 35525 g998 i0 79.7 12.3504098360656 123 24 75.6 1 67 435 1 122 XP_032793488.1 40S ribosomal protein S17 [Daphnia magna] diamond 6027 188 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
19475478 19475478 PRJNA1240805_P_NODE_336_length_816_cov_8.614081_g304_i0 PRJNA1240805 336 816 8.614081 70.29090096 Larinioides sclopetarius 280406 Arthropoda Arthropoda 166 6.78e-48   NR CAL1290256.1 280406 g304 i0 67.7 2.60661764705882 133 36 47.1 3 126 509 3 133 CAL1290256.1 unnamed protein product [Larinioides sclopetarius] diamond 2127 166 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Larinioides Larinioides sclopetarius
26598436 26598436 PRJNA1240805_P_NODE_5761_length_190_cov_8.992908_g5712_i0 PRJNA1240805 5761 190 8.992908 17.0865252 Daphnia pulex 6669 Arthropoda Arthropoda 91.7 2.67e-20   NR EFX60189.1 6669 g5712 i0 71.7 0.947368421052632 60 17 94.7 0 9 188 87 146 EFX60189.1 hypothetical protein DAPPUDRAFT_344845, partial [Daphnia pulex] diamond 180 91.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
26870501 26870501 PRJNA1240805_P_NODE_7981_length_164_cov_1.773913_g7932_i0 PRJNA1240805 7981 164 1.773913 2.90921732 Daphnia 6668 Arthropoda Arthropoda 43.1 0.0093   NR XP_046458123.1 6669 g7932 i0 100 0.731707317073171 20 0 36.6 0 2 61 331 350 XP_046458123.1 protein limb expression 1 homolog isoform X1 [Daphnia pulex] diamond 120 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
27263303 27263303 PRJNA1240805_P_NODE_5503_length_194_cov_17.179310_g5454_i0 PRJNA1240805 5503 194 17.17931 33.3278614 Idotea baltica 82763 Arthropoda Arthropoda 51.6 6.82e-7   NR MCL4120614.1 82763 g5454 i0 60.5 0.587628865979381 38 15 58.8 0 57 170 22 59 MCL4120614.1 hypothetical protein [Idotea baltica] diamond 114 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
27421447 27421447 PRJNA1240805_P_NODE_3263_length_258_cov_3.813397_g3214_i0 PRJNA1240805 3263 258 3.813397 9.83856426 Meganyctiphanes norvegica 48144 Arthropoda Arthropoda 48.1 1.99e-4   NR CAL4105074.1 48144 g3214 i0 51.3 1.34883720930233 39 19 45.3 0 96 212 104 142 CAL4105074.1 unnamed protein product [Meganyctiphanes norvegica] diamond 348 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
27673986 27673986 PRJNA1240805_P_NODE_5244_length_199_cov_6.686667_g5195_i0 PRJNA1240805 5244 199 6.686667 13.30646733 Idotea baltica 82763 Arthropoda Arthropoda 70.9 2.55e-12   NR MCL4114215.1 82763 g5195 i0 77.5 0.603015075376884 40 9 60.3 0 23 142 608 647 MCL4114215.1 hypothetical protein [Idotea baltica] diamond 120 70.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
28102218 28102218 PRJNA1240805_P_NODE_2505_length_300_cov_4.613546_g2456_i0 PRJNA1240805 2505 300 4.613546 13.840638 Daphnia 6668 Arthropoda Arthropoda 165 8.43e-45   NR EFX76974.1 6669 g2456 i0 97.5 2.37 79 2 79 0 294 58 767 845 EFX76974.1 hypothetical protein DAPPUDRAFT_321858 [Daphnia pulex] diamond 711 165 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
28165562 28165562 PRJNA1240805_P_NODE_5885_length_188_cov_7.647482_g5836_i0 PRJNA1240805 5885 188 7.647482 14.37726616 Metazoa 33208 Arthropoda Arthropoda 45.4 0.00197   NR QGN00885.1 7229 g5836 i0 81 22.4840425531915 21 4 33.5 0 64 126 359 379 QGN00885.1 ActL2 [Drosophila miranda] diamond 4227 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila miranda
29649109 29649109 PRJNA1240805_P_NODE_610_length_632_cov_8.849057_g567_i0 PRJNA1240805 610 632 8.849057 55.92604024 Araneae 6893 Arthropoda Arthropoda 172 3.62e-51   NR XP_054709503.1 327109 g567 i0 62.9 1.42879746835443 151 39 70.7 3 92 538 1 136 XP_054709503.1 cuticle protein 10.9-like [Uloborus diversus] diamond 903 172 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Uloboridae Uloborus Uloborus diversus
29884181 29884181 PRJNA1240805_P_NODE_2811_length_281_cov_14.327586_g2762_i0 PRJNA1240805 2811 281 14.327586 40.26051666 Idotea baltica 82763 Arthropoda Arthropoda 64.3 1.48e-10   NR MCL4126295.1 82763 g2762 i0 51.7 0.640569395017794 60 29 64.1 0 39 218 58 117 MCL4126295.1 hypothetical protein [Idotea baltica] diamond 180 64.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
29915763 29915763 PRJNA1240805_P_NODE_7611_length_167_cov_3.118644_g7562_i0 PRJNA1240805 7611 167 3.118644 5.20813548 Hetaerina americana 62018 Arthropoda Arthropoda 45.1 0.00203   NR XP_071440009.1 62018 g7562 i0 63.3 0.538922155688623 30 11 53.9 0 28 117 384 413 XP_071440009.1 MFS-type transporter SLC18B1-like [Hetaerina americana] diamond 90 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Calopterygidae Hetaerina Hetaerina americana
30358400 30358400 PRJNA1240805_P_NODE_6232_length_183_cov_4.723881_g6183_i0 PRJNA1240805 6232 183 4.723881 8.64470223 Idotea baltica 82763 Arthropoda Arthropoda 58.5 2.06e-9   NR MCL4129585.1 82763 g6183 i0 97 1.08196721311475 33 1 54.1 0 31 129 1 33 MCL4129585.1 hypothetical protein [Idotea baltica] diamond 198 58.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
30515889 30515889 PRJNA1240805_P_NODE_7073_length_173_cov_2.346774_g7024_i0 PRJNA1240805 7073 173 2.346774 4.05991902 Zootermopsis nevadensis 136037 Arthropoda Arthropoda 75.1 6.56e-16   NR XP_021931188.1 136037 g7024 i0 97.3 3.9364161849711 37 1 64.2 0 63 173 45 81 XP_021931188.1 60S ribosomal protein L39 [Zootermopsis nevadensis] diamond 681 75.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Termopsidae Zootermopsis Zootermopsis nevadensis
30610533 30610533 PRJNA1240805_P_NODE_2373_length_308_cov_10.471042_g2324_i0 PRJNA1240805 2373 308 10.471042 32.25080936 Tenebrio molitor 7067 Arthropoda Arthropoda 120 5.76e-29   NR KAH0814484.1 7067 g2324 i0 59.2 3.57467532467532 98 36 95.5 1 15 308 20 113 KAH0814484.1 hypothetical protein GEV33_008308 [Tenebrio molitor] diamond 1101 120 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
31147390 31147390 PRJNA1240805_P_NODE_2995_length_271_cov_11.788288_g2946_i0 PRJNA1240805 2995 271 11.788288 31.94626048 Idotea baltica 82763 Arthropoda Arthropoda 105 1.48e-26   NR MCL4130911.1 82763 g2946 i0 69.2 0.719557195571956 65 20 72 0 49 243 96 160 MCL4130911.1 hypothetical protein [Idotea baltica] diamond 195 105 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
32255272 32255272 PRJNA1240805_P_NODE_4018_length_230_cov_3.353591_g3969_i0 PRJNA1240805 4018 230 3.353591 7.7132593 Neocloeon triangulifer 2078957 Arthropoda Arthropoda 63.9 1.07e-10   NR XP_059476095.1 2078957 g3969 i0 76.3 3.96521739130435 38 8 48.3 1 2 112 105 142 XP_059476095.1 small ribosomal subunit protein uS12-like [Neocloeon triangulifer] diamond 912 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Baetidae Neocloeon Neocloeon triangulifer
32476581 32476581 PRJNA1240805_P_NODE_6359_length_181_cov_9.734848_g6310_i0 PRJNA1240805 6359 181 9.734848 17.62007488 Idotea baltica 82763 Arthropoda Arthropoda 82.4 3.05e-19   NR MCL4113149.1 82763 g6310 i0 82.9 0.679558011049724 41 7 68 0 34 156 11 51 MCL4113149.1 hypothetical protein [Idotea baltica] diamond 123 82.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
32602809 32602809 PRJNA1240805_P_NODE_3780_length_238_cov_2.343915_g3731_i0 PRJNA1240805 3780 238 2.343915 5.5785177 Idotea baltica 82763 Arthropoda Arthropoda 116 7.56e-32   NR MCL4113736.1 82763 g3731 i0 73.3 0.945378151260504 75 20 94.5 0 14 238 30 104 MCL4113736.1 hypothetical protein [Idotea baltica] diamond 225 116 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
32904124 32904124 PRJNA1240805_P_NODE_2460_length_303_cov_1.503937_g2411_i0 PRJNA1240805 2460 303 1.503937 4.55692911 Daphnia 6668 Arthropoda Arthropoda 100 5.87e-25   NR EFX88885.1 6669 g2411 i0 100 0.891089108910891 45 0 44.6 0 160 26 1 45 EFX88885.1 hypothetical protein DAPPUDRAFT_27756, partial [Daphnia pulex] diamond 270 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex

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