RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA807347" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 25 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA807347 · 25 ✖

analysis 1

  • diamond · 25 ✖
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
806305 806305 PRJNA807347_P_NODE_161_length_1505_cov_8.993715_g129_i0 PRJNA807347 161 1505 8.993715 135.35541075 Diaphorina citri 121845 Arthropoda Arthropoda 600 4.73e-203   NR KAI5737947.1 121845 g129 i0 59.4 1.92757475083056 483 196 96.3 0 56 1504 488 970 KAI5737947.1 hypothetical protein M8J77_001036 [Diaphorina citri] diamond 2901 600 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
3357205 3357205 PRJNA807347_P_NODE_1283_length_726_cov_2.580398_g1188_i0 PRJNA807347 1283 726 2.580398 18.73368948 root 1 Root_unresolved Root_unresolved 352 3.039999999999999e-115   NR CAD7254415.1 69355 g1188 i0 73.1 2 242 40 100 2 726 1 314 530 CAD7254415.1 unnamed protein product, partial [Darwinula stevensoni] diamond 1452 353 0.997167138810198 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Darwinulidae Darwinula Darwinula stevensoni
23758887 23758887 PRJNA807347_P_NODE_12259_length_251_cov_1.730337_g12156_i0 PRJNA807347 12259 251 1.730337 4.34314587 Leptotrombidium deliense 299467 Arthropoda Arthropoda 126 1.23e-31   NR RWS31988.1 299467 g12156 i0 93.8 1.54183266932271 65 4 77.7 0 56 250 169 233 RWS31988.1 ankyrin-2-like isoform X8 [Leptotrombidium deliense] diamond 387 126 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense
26642523 26642523 PRJNA807347_P_NODE_17821_length_227_cov_2.188312_g17718_i0 PRJNA807347 17821 227 2.188312 4.96746824 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 76.6 3.48e-15   NR ADD38186.1 72036 g17718 i0 49.3 0.9383259911894268 71 33 89.9 1 223 20 74 144 ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] diamond 213 76.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
26800907 26800907 PRJNA807347_P_NODE_14601_length_246_cov_4.005780_g14498_i0 PRJNA807347 14601 246 4.00578 9.8542188 Stegodyphus mimosarum 407821 Arthropoda Arthropoda 124 5.679999999999999e-31   NR KFM72496.1 407821 g14498 i0 74.1 0.98780487804878 81 21 98.8 0 3 245 1175 1255 KFM72496.1 Retrovirus-related Pol polyprotein from transposon 17.6, partial [Stegodyphus mimosarum] diamond 243 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus mimosarum
26968044 26968044 PRJNA807347_P_NODE_11582_length_253_cov_1.733333_g11479_i0 PRJNA807347 11582 253 1.733333 4.38533249 Arachnida 6854 Arthropoda Arthropoda 127 6.47e-33   NR KAG0412570.1 34615 g11479 i0 73.5 11.8102766798419 83 22 98.4 0 251 3 237 319 KAG0412570.1 hypothetical protein HPB47_010292 [Ixodes persulcatus] diamond 2988 128 0.9921875 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes persulcatus
27433627 27433627 PRJNA807347_P_NODE_15203_length_245_cov_1.406977_g15100_i0 PRJNA807347 15203 245 1.406977 3.44709365 Cordylochernes scorpioides 51811 Arthropoda Arthropoda 43.9 0.0147   NR UYV70907.1 51811 g15100 i0 32.8 0.746938775510204 61 41 74.7 0 42 224 226 286 UYV70907.1 hypothetical protein LAZ67_8001073, partial [Cordylochernes scorpioides] diamond 183 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Pseudoscorpiones Chernetidae Cordylochernes Cordylochernes scorpioides
27654593 27654593 PRJNA807347_P_NODE_16164_length_243_cov_3.600000_g16061_i0 PRJNA807347 16164 243 3.6 8.748 Stegodyphus mimosarum 407821 Arthropoda Arthropoda 122 5e-30   NR KFM75301.1 407821 g16061 i0 70.4 5.92592592592593 81 24 100 0 1 243 168 248 KFM75301.1 Stress response protein nst1, partial [Stegodyphus mimosarum] diamond 1440 122 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus mimosarum
28673711 28673711 PRJNA807347_P_NODE_6127_length_331_cov_2.558140_g6024_i0 PRJNA807347 6127 331 2.55814 8.4674434 Metazoa 33208 Arthropoda Arthropoda 47.8 3.02e-4   NR XP_027193941.1 6956 g6024 i0 33.3 1.31419939577039 81 52 72.5 2 45 284 2 81 XP_027193941.1 60S acidic ribosomal protein P1-like [Dermatophagoides pteronyssinus] diamond 435 48.1 0.993762993762994 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
28980732 28980732 PRJNA807347_P_NODE_17968_length_211_cov_4.333333_g17865_i0 PRJNA807347 17968 211 4.333333 9.14333263 Carabus blaptoides fortunei 49296 Arthropoda Arthropoda 70.5 3.38e-12   NR GLV40058.1 49296 g17865 i0 58.2 0.781990521327014 55 23 78.2 0 42 206 162 216 GLV40058.1 hypothetical protein CBL_02943 [Carabus blaptoides fortunei] diamond 165 70.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Carabidae Carabus Carabus blaptoides
29043850 29043850 PRJNA807347_P_NODE_4848_length_374_cov_7.269103_g4745_i0 PRJNA807347 4848 374 7.269103 27.18644522 Centruroides sculpturatus 218467 Arthropoda Arthropoda 82.4 1.65e-15   NR XP_023231883.1 218467 g4745 i0 55.4 0.593582887700535 74 33 59.4 0 152 373 24 97 XP_023231883.1 uncharacterized protein LOC111631804 [Centruroides sculpturatus] diamond 222 82.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides sculpturatus
29170122 29170122 PRJNA807347_P_NODE_7789_length_293_cov_2.536364_g7686_i0 PRJNA807347 7789 293 2.536364 7.43154652 Trichonephila clavipes 2585209 Arthropoda Arthropoda 48.5 5.84e-4   NR GFX21880.1 2585209 g7686 i0 50.8 0.931740614334471 59 27 60.4 1 178 2 2 58 GFX21880.1 uncharacterized protein TNCV_2311581 [Trichonephila clavipes] diamond 273 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
29368332 29368332 PRJNA807347_P_NODE_17749_length_228_cov_2.503226_g17646_i0 PRJNA807347 17749 228 2.503226 5.70735528 Orchesella 48705 Arthropoda Arthropoda 57 2.95e-7   NR ODN00819.1 48709 g17646 i0 55.6 1.77631578947368 45 20 59.2 0 135 1 359 403 ODN00819.1 Anaphase-promoting complex subunit 2 [Orchesella cincta] diamond 405 57 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
29991042 29991042 PRJNA807347_P_NODE_4211_length_403_cov_5.851515_g4108_i0 PRJNA807347 4211 403 5.851515 23.58160545 Centruroides vittatus 120091 Arthropoda Arthropoda 187 3.11e-54   NR XP_067127708.1 120091 g4108 i0 65.2 2.96277915632754 132 46 98.3 0 397 2 26 157 XP_067127708.1 craniofacial development protein 2-like [Centruroides vittatus] diamond 1194 187 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides vittatus
30338986 30338986 PRJNA807347_P_NODE_10872_length_259_cov_2.913978_g10769_i0 PRJNA807347 10872 259 2.913978 7.54720302 Caerostris darwini 1538125 Arthropoda Arthropoda 68.9 6.31e-13   NR GIY12083.1 1538125 g10769 i0 76.7 1.21621621621622 43 10 49.8 0 11 139 57 99 GIY12083.1 hypothetical protein CDAR_449931 [Caerostris darwini] diamond 315 68.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Caerostris Caerostris darwini
30591233 30591233 PRJNA807347_P_NODE_17933_length_216_cov_8.958042_g17830_i0 PRJNA807347 17933 216 8.958042 19.34937072 Centruroides vittatus 120091 Arthropoda Arthropoda 83.2 1.36e-16   NR XP_067127708.1 120091 g17830 i0 62.3 0.958333333333333 69 26 95.8 0 212 6 351 419 XP_067127708.1 craniofacial development protein 2-like [Centruroides vittatus] diamond 207 83.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides vittatus
31571334 31571334 PRJNA807347_P_NODE_18056_length_200_cov_5.157480_g17953_i0 PRJNA807347 18056 200 5.15748 10.31496 Centruroides sculpturatus 218467 Arthropoda Arthropoda 90.1 3.03e-19   NR XP_023231883.1 218467 g17953 i0 63.6 1.965 66 24 99 0 3 200 71 136 XP_023231883.1 uncharacterized protein LOC111631804 [Centruroides sculpturatus] diamond 393 90.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides sculpturatus
31665918 31665918 PRJNA807347_P_NODE_13977_length_248_cov_0.885714_g13874_i0 PRJNA807347 13977 248 0.885714 2.19657072 Tetranychus urticae 32264 Arthropoda Arthropoda 132 1.18e-33   NR XP_015785059.1 32264 g13874 i0 82.9 0.991935483870968 82 14 99.2 0 2 247 853 934 XP_015785059.1 1-phosphatidylinositol 4,5-bisphosphate phosphodiesterase [Tetranychus urticae] diamond 246 132 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
31760873 31760873 PRJNA807347_P_NODE_18077_length_198_cov_5.504000_g17974_i0 PRJNA807347 18077 198 5.504 10.89792 Centruroides vittatus 120091 Arthropoda Arthropoda 93.6 2.07e-20   NR XP_067127708.1 120091 g17974 i0 65.6 1.93939393939394 64 22 97 0 196 5 191 254 XP_067127708.1 craniofacial development protein 2-like [Centruroides vittatus] diamond 384 93.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides vittatus
31855744 31855744 PRJNA807347_P_NODE_12457_length_251_cov_0.876404_g12354_i0 PRJNA807347 12457 251 0.876404 2.19977404 Chelonus insularis 460826 Arthropoda Arthropoda 48.9 1.65e-4   NR XP_034944976.1 460826 g12354 i0 50 2.46215139442231 54 20 64.5 1 196 35 110 156 XP_034944976.1 protein OPI10 homolog [Chelonus insularis] diamond 618 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Chelonus Chelonus insularis
32299130 32299130 PRJNA807347_P_NODE_12039_length_252_cov_0.871508_g11936_i0 PRJNA807347 12039 252 0.871508 2.19620016 Uloborus diversus 327109 Arthropoda Arthropoda 45.1 0.00622   NR XP_054720505.1 327109 g11936 i0 47.6 7.83333333333333 63 20 73.8 3 21 206 500 550 XP_054720505.1 LOW QUALITY PROTEIN: uncharacterized protein LOC129230126, partial [Uloborus diversus] diamond 1974 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Uloboridae Uloborus Uloborus diversus
32425386 32425386 PRJNA807347_P_NODE_10639_length_262_cov_0.746032_g10536_i0 PRJNA807347 10639 262 0.746032 1.95460384 Trichonephila clavipes 2585209 Arthropoda Arthropoda 54.3 8.07e-7   NR GFX37588.1 2585209 g10536 i0 88 0.286259541984733 25 3 28.6 0 187 261 38 62 GFX37588.1 transposable element Tcb1 transposase [Trichonephila clavipes] diamond 75 54.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
32425390 32425390 PRJNA807347_P_NODE_18079_length_198_cov_4.640000_g17976_i0 PRJNA807347 18079 198 4.64 9.1872 Araneus ventricosus 182803 Arthropoda Arthropoda 72.8 5.05e-13   NR GBN19663.1 182803 g17976 i0 51.6 3.83333333333333 64 31 97 0 194 3 36 99 GBN19663.1 Transposon Ty3-I Gag-Pol polyprotein [Araneus ventricosus] diamond 759 72.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
32457146 32457146 PRJNA807347_P_NODE_1239_length_737_cov_6.753012_g1144_i0 PRJNA807347 1239 737 6.753012 49.76969844 Centruroides vittatus 120091 Arthropoda Arthropoda 275 1.97e-86   NR XP_067127708.1 120091 g1144 i0 60.8 0.944369063772049 232 88 94 2 735 43 120 349 XP_067127708.1 craniofacial development protein 2-like [Centruroides vittatus] diamond 696 275 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides vittatus
32866778 32866778 PRJNA807347_P_NODE_17860_length_226_cov_7.483660_g17757_i0 PRJNA807347 17860 226 7.48366 16.9130716 Centruroides vittatus 120091 Arthropoda Arthropoda 73.9 2.97e-13   NR XP_067127708.1 120091 g17757 i0 55.8 1.02212389380531 77 32 99.6 1 226 2 372 448 XP_067127708.1 craniofacial development protein 2-like [Centruroides vittatus] diamond 231 73.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides vittatus

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