RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA682370" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA682370 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
14693247 14693247 PRJNA682370_S_NODE_18512_length_167_cov_1.545455_g17900_i0 PRJNA682370 18512 167 1.545455 2.58090985 Idotea baltica 82763 Arthropoda Arthropoda 108 2.24e-29   NR MCL4147966.1 82763 g17900 i0 87.3 1.97604790419162 55 7 98.8 0 1 165 37 91 MCL4147966.1 hypothetical protein [Idotea baltica] diamond 330 108 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
21066726 21066726 PRJNA682370_S_NODE_17597_length_171_cov_1.367647_g16985_i0 PRJNA682370 17597 171 1.367647 2.33867637 Hemiptera 7524 Arthropoda Arthropoda 73.2 5.01e-14   NR XP_050531816.1 58002 g16985 i0 71.7 1.6140350877193 46 13 80.7 0 32 169 120 165 XP_050531816.1 elongation factor 1-beta [Daktulosphaira vitifoliae] diamond 276 73.6 0.994565217391304 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phylloxeridae Daktulosphaira Daktulosphaira vitifoliae
27018852 27018852 PRJNA682370_S_NODE_24682_length_150_cov_1.034783_g24070_i0 PRJNA682370 24682 150 1.034783 1.5521745 Tigriopus californicus 6832 Arthropoda Arthropoda 80.5 3.34e-16   NR XP_059096468.1 6832 g24070 i0 81.3 0.96 48 9 96 0 3 146 266 313 XP_059096468.1 fructose-bisphosphate aldolase-like [Tigriopus californicus] diamond 144 80.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
27555833 27555833 PRJNA682370_S_NODE_16684_length_175_cov_1.878571_g16072_i0 PRJNA682370 16684 175 1.878571 3.28749925 Tigriopus japonicus 158387 Arthropoda Arthropoda 61.2 4.46e-9   NR AKO90278.1 158387 g16072 i0 43.9 1.13142857142857 66 27 96 2 7 174 391 456 AKO90278.1 cathepsin F [Tigriopus japonicus] diamond 198 61.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus japonicus
27840021 27840021 PRJNA682370_S_NODE_7904_length_269_cov_2.367521_g7292_i0 PRJNA682370 7904 269 2.367521 6.36863149 Polypedilum vanderplanki 319348 Arthropoda Arthropoda 117 9.32e-31   NR KAG5678728.1 319348 g7292 i0 67.4 1.97397769516729 89 29 99.3 0 269 3 39 127 KAG5678728.1 hypothetical protein PVAND_008376 [Polypedilum vanderplanki] diamond 531 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
27966457 27966457 PRJNA682370_S_NODE_16565_length_176_cov_1.397163_g15953_i0 PRJNA682370 16565 176 1.397163 2.45900688 Halotydeus destructor 2874060 Arthropoda Arthropoda 51.2 1.54e-5   NR KAI1299243.1 2874060 g15953 i0 52.8 0.613636363636364 36 17 61.4 0 172 65 199 234 KAI1299243.1 Leucine-zipper-like transcriptional regulator 1 [Halotydeus destructor] diamond 108 51.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
27978122 27978122 PRJNA682370_S_NODE_8645_length_254_cov_2.703196_g8033_i0 PRJNA682370 8645 254 2.703196 6.86611784 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 52 2.21e-5   NR KAI5745976.1 121845 g8033 i0 38.1 2.92913385826772 63 39 74.4 0 254 66 17 79 KAI5745976.1 hypothetical protein M8J76_015973 [Diaphorina citri] diamond 744 52 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
28325368 28325368 PRJNA682370_S_NODE_16506_length_176_cov_1.964539_g15894_i0 PRJNA682370 16506 176 1.964539 3.45758864 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 50.4 2.78e-5   NR XP_040577325.1 72036 g15894 i0 74.2 2.11363636363636 31 7 52.8 1 163 71 154 183 XP_040577325.1 procathepsin L-like [Lepeophtheirus salmonis] diamond 372 50.8 0.992125984251969 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
28535062 28535062 PRJNA682370_S_NODE_20607_length_160_cov_1.272000_g19995_i0 PRJNA682370 20607 160 1.272 2.0352 Formica exsecta 72781 Arthropoda Arthropoda 73.9 3.28e-14   NR XP_029668056.1 72781 g19995 i0 67.3 14.68125 52 16 97.5 1 157 2 136 186 XP_029668056.1 TATA-box-binding protein-like [Formica exsecta] diamond 2349 73.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Formica Formica exsecta
28641407 28641407 PRJNA682370_S_NODE_8767_length_252_cov_1.783410_g8155_i0 PRJNA682370 8767 252 1.78341 4.4941932 Opisthokonta 33154 Arthropoda Arthropoda 91.7 3.64e-21   NR XP_026462134.1 7515 g8155 i0 62.7 9.13095238095238 67 25 79.8 0 225 25 50 116 XP_026462134.1 60S ribosomal protein L12 [Ctenocephalides felis] diamond 2301 91.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Siphonaptera Pulicidae Ctenocephalides Ctenocephalides felis
29702694 29702694 PRJNA682370_S_NODE_6710_length_299_cov_1.806818_g6098_i0 PRJNA682370 6710 299 1.806818 5.40238582 Idotea baltica 82763 Arthropoda Arthropoda 72.8 1.5e-14   NR MCL4117871.1 82763 g6098 i0 59.4 0.642140468227425 64 26 64.2 0 1 192 7 70 MCL4117871.1 hypothetical protein [Idotea baltica] diamond 192 72.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
29999128 29999128 PRJNA682370_S_NODE_10951_length_220_cov_1.356757_g10339_i0 PRJNA682370 10951 220 1.356757 2.9848654 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 94.4 1.1e-21   NR AEC33277.1 6687 g10339 i0 60.3 6.96818181818182 73 29 99.5 0 1 219 64 136 AEC33277.1 14-3-3 protein, partial [Penaeus monodon] diamond 1533 94.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon
30188456 30188456 PRJNA682370_S_NODE_15712_length_180_cov_2.365517_g15100_i0 PRJNA682370 15712 180 2.365517 4.2579306 Opisthokonta 33154 Arthropoda Arthropoda 90.9 1.81e-19   NR KAG5889532.1 63699 g15100 i0 72.2 93.6166666666667 54 15 90 0 1 162 1207 1260 KAG5889532.1 hypothetical protein JTB14_036623 [Gonioctena quinquepunctata] diamond 16851 91.7 0.991275899672846 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Gonioctena Gonioctena quinquepunctata
30430042 30430042 PRJNA682370_S_NODE_15333_length_183_cov_1.054054_g14721_i0 PRJNA682370 15333 183 1.054054 1.92891882 Ornithodoros turicata 34597 Arthropoda Arthropoda 65.1 2.16e-10   NR XP_064486765.1 34597 g14721 i0 58.3 3.31147540983607 48 20 78.7 0 3 146 711 758 XP_064486765.1 alpha-aminoadipic semialdehyde synthase, mitochondrial-like isoform X2 [Ornithodoros turicata] diamond 606 65.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Argasidae Ornithodoros Ornithodoros turicata
31314457 31314457 PRJNA682370_S_NODE_18735_length_166_cov_1.824427_g18123_i0 PRJNA682370 18735 166 1.824427 3.02854882 Aethina tumida 116153 Arthropoda Arthropoda 82.4 1.38e-16   NR XP_019868287.2 116153 g18123 i0 65.5 3.9578313253012 55 19 99.4 0 2 166 947 1001 XP_019868287.2 uncharacterized protein LOC109597099 [Aethina tumida] diamond 657 82.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Nitidulidae Aethina Aethina tumida
31377849 31377849 PRJNA682370_S_NODE_2536_length_526_cov_1.967413_g1950_i0 PRJNA682370 2536 526 1.967413 10.34859238 Idotea baltica 82763 Arthropoda Arthropoda 132 8.49e-36   NR MCL4119131.1 82763 g1950 i0 52.9 0.798479087452472 140 65 79.3 1 498 82 8 147 MCL4119131.1 hypothetical protein [Idotea baltica] diamond 420 132 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
31883696 31883696 PRJNA682370_S_NODE_15537_length_181_cov_2.547945_g14925_i0 PRJNA682370 15537 181 2.547945 4.61178045 Rhynocoris fuscipes 488301 Arthropoda Arthropoda 92 2.02e-20   NR KAK9498923.1 488301 g14925 i0 70 3.91160220994475 60 17 97.8 1 1 177 151 210 KAK9498923.1 hypothetical protein O3M35_003464 [Rhynocoris fuscipes] diamond 708 92 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Reduviidae Rhynocoris Rhynocoris fuscipes
32137044 32137044 PRJNA682370_S_NODE_8158_length_264_cov_1.257642_g7546_i0 PRJNA682370 8158 264 1.257642 3.32017488 Spodoptera exigua 7107 Arthropoda Arthropoda 53.5 7.43e-6   NR KAH9640402.1 7107 g7546 i0 48 1.76136363636364 50 26 56.8 0 215 66 65 114 KAH9640402.1 hypothetical protein HF086_018068 [Spodoptera exigua] diamond 465 53.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera exigua
32307111 32307111 PRJNA682370_S_NODE_12979_length_199_cov_2.079268_g12367_i0 PRJNA682370 12979 199 2.079268 4.13774332 Opisthokonta 33154 Arthropoda Arthropoda 113 3.5800000000000003e-29   NR ACB70396.1 92741 g12367 i0 69.7 20.6683417085427 66 20 99.5 0 199 2 17 82 ACB70396.1 60S ribosomal protein L2/L8, partial [Ornithodoros coriaceus] diamond 4113 114 0.991228070175439 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Argasidae Ornithodoros Ornithodoros coriaceus
32674111 32674111 PRJNA682370_S_NODE_8360_length_260_cov_1.755556_g7748_i0 PRJNA682370 8360 260 1.755556 4.5644456 Bemisia tabaci 7038 Arthropoda Arthropoda 73.2 6.86e-13   NR XP_018896481.1 7038 g7748 i0 46.2 4.2 91 44 99.2 2 260 3 72 162 XP_018896481.1 PREDICTED: cathepsin L1-like [Bemisia tabaci] diamond 1092 73.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
32705660 32705660 PRJNA682370_S_NODE_5000_length_357_cov_2.304348_g4388_i0 PRJNA682370 5000 357 2.304348 8.22652236 Diprion similis 362088 Arthropoda Arthropoda 80.9 4.65e-16   NR XP_046745590.1 362088 g4388 i0 41.2 3.53781512605042 114 64 95.8 1 3 344 42 152 XP_046745590.1 glutathione S-transferase-like [Diprion similis] diamond 1263 80.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Diprionidae Diprion Diprion similis

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