RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA672101 · 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
21567603 21567603 PRJNA672101_S_NODE_34637_length_227_cov_4.500000_g34606_i0 PRJNA672101 34637 227 4.5 10.215 root 1 Root_unresolved Root_unresolved 101 6.64e-24   NR XP_063846616.1 85552 g34606 i0 64.9 27.4625550660793 74 26 97.8 0 222 1 216 289 XP_063846616.1 persulfide dioxygenase ETHE1, mitochondrial-like [Scylla paramamosain] diamond 6234 102 0.990196078431373 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
27081735 27081735 PRJNA672101_S_NODE_16222_length_304_cov_5.722944_g16191_i0 PRJNA672101 16222 304 5.722944 17.39774976 Anopheles moucheti 186751 Arthropoda Arthropoda 49.7 2.82e-4   NR XP_052888899.1 186751 g16191 i0 43.3 3.96710526315789 67 33 66.1 3 3 203 469 530 XP_052888899.1 LIM domain kinase 1 [Anopheles moucheti] diamond 1206 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles moucheti
27113183 27113183 PRJNA672101_S_NODE_11062_length_339_cov_3.744361_g11031_i0 PRJNA672101 11062 339 3.744361 12.69338379 Trinorchestia longiramus 1923959 Arthropoda Arthropoda 46.6 0.00492   NR KAF2360991.1 1923959 g11031 i0 60 0.592920353982301 35 14 31 0 17 121 686 720 KAF2360991.1 Heat shock protein Hsp90 family [Trinorchestia longiramus] diamond 201 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Talitridae Trinorchestia Trinorchestia longiramus
27397968 27397968 PRJNA672101_S_NODE_32703_length_242_cov_1.822485_g32672_i0 PRJNA672101 32703 242 1.822485 4.4104137 Anoplophora glabripennis 217634 Arthropoda Arthropoda 43.5 0.0195   NR XP_018577773.1 217634 g32672 i0 47.8 0.570247933884298 46 24 57 0 236 99 291 336 XP_018577773.1 leucine-rich repeats and immunoglobulin-like domains protein 1 [Anoplophora glabripennis] diamond 138 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Anoplophora Anoplophora glabripennis
27788723 27788723 PRJNA672101_S_NODE_17084_length_299_cov_5.159292_g17053_i0 PRJNA672101 17084 299 5.159292 15.42628308 Metazoa 33208 Arthropoda Arthropoda 70.9 9.5e-12   NR GIY84995.1 172846 g17053 i0 38.3 3.79264214046823 94 45 89.3 3 22 288 20 105 GIY84995.1 ubiquitin carboxyl-terminal hydrolase 15 [Caerostris extrusa] diamond 1134 70.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Caerostris Caerostris extrusa
28186937 28186937 PRJNA672101_S_NODE_34106_length_234_cov_4.304348_g34075_i0 PRJNA672101 34106 234 4.304348 10.07217432 Tropilaelaps mercedesae 418985 Arthropoda Arthropoda 43.1 0.0173   NR OQR76709.1 418985 g34075 i0 61.8 1.37179487179487 34 13 43.6 0 226 125 143 176 OQR76709.1 protein Mpv17-like [Tropilaelaps mercedesae] diamond 321 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Laelapidae Tropilaelaps Tropilaelaps mercedesae
28660849 28660849 PRJNA672101_S_NODE_14307_length_316_cov_5.333333_g14276_i0 PRJNA672101 14307 316 5.333333 16.85333228 Schistocerca gregaria 7010 Arthropoda Arthropoda 74.7 2.53e-14   NR XP_049851313.1 7010 g14276 i0 37.8 0.854430379746835 90 56 85.4 0 316 47 60 149 XP_049851313.1 myosin regulatory light chain-like [Schistocerca gregaria] diamond 270 74.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
28660850 28660850 PRJNA672101_S_NODE_21307_length_279_cov_3.699029_g21276_i0 PRJNA672101 21307 279 3.699029 10.32029091 Schistocerca gregaria 7010 Arthropoda Arthropoda 107 6.34e-27   NR XP_049850888.1 7010 g21276 i0 66.2 1.63440860215054 77 26 82.8 0 278 48 94 170 XP_049850888.1 ras-like protein rasG [Schistocerca gregaria] diamond 456 107 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
28925161 28925161 PRJNA672101_S_NODE_8648_length_360_cov_10.045296_g8617_i0 PRJNA672101 8648 360 10.045296 36.1630656 root 1 Root_unresolved Root_unresolved 48.1 0.00166   NR GBN01749.1 182803 g8617 i0 51.4 2.64166666666667 35 17 29.2 0 108 4 93 127 GBN01749.1 hypothetical protein AVEN_64609-1 [Araneus ventricosus] diamond 951 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
28945215 28945215 PRJNA672101_S_NODE_24248_length_267_cov_1.587629_g24217_i0 PRJNA672101 24248 267 1.587629 4.23896943 Schistocerca gregaria 7010 Arthropoda Arthropoda 112 1.54e-28   NR XP_049849936.1 7010 g24217 i0 65.8 0.853932584269663 76 26 85.4 0 38 265 118 193 XP_049849936.1 eukaryotic translation initiation factor 2 subunit 2-like [Schistocerca gregaria] diamond 228 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
29178017 29178017 PRJNA672101_S_NODE_18729_length_291_cov_3.160550_g18698_i0 PRJNA672101 18729 291 3.16055 9.1972005 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 73.9 6.93e-13   NR XP_013783828.1 6850 g18698 i0 42.2 2.72164948453608 90 48 92.8 1 287 18 418 503 XP_013783828.1 THO complex subunit 2-like [Limulus polyphemus] diamond 792 73.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
30303381 30303381 PRJNA672101_S_NODE_15452_length_309_cov_2.682203_g15421_i0 PRJNA672101 15452 309 2.682203 8.28800727 Carabus blaptoides fortunei 49296 Arthropoda Arthropoda 78.6 2.2e-14   NR GLV39996.1 49296 g15421 i0 47.4 6.64077669902913 76 38 73.8 1 300 73 757 830 GLV39996.1 Argonaute 3 [Carabus blaptoides fortunei] diamond 2052 78.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Carabidae Carabus Carabus blaptoides
30681813 30681813 PRJNA672101_S_NODE_34993_length_218_cov_8.834483_g34962_i0 PRJNA672101 34993 218 8.834483 19.25917294 Toxorhynchites rutilus septentrionalis 329112 Arthropoda Arthropoda 52.8 7.65e-6   NR XP_055629131.1 329112 g34962 i0 44.4 0.743119266055046 54 29 72.9 1 217 59 193 246 XP_055629131.1 SEC14-like protein 2 [Toxorhynchites rutilus septentrionalis] diamond 162 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Toxorhynchites Toxorhynchites rutilus
30915300 30915300 PRJNA672101_S_NODE_25174_length_263_cov_3.647368_g25143_i0 PRJNA672101 25174 263 3.647368 9.59257784 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 70.1 1.04e-11   NR KXJ80044.1 7160 g25143 i0 46 4.27756653992395 63 33 70.7 1 241 56 332 394 KXJ80044.1 hypothetical protein RP20_CCG027054 [Aedes albopictus] diamond 1125 70.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
31883322 31883322 PRJNA672101_S_NODE_17497_length_297_cov_5.334821_g17466_i0 PRJNA672101 17497 297 5.334821 15.84441837 Schistocerca gregaria 7010 Arthropoda Arthropoda 43.1 0.0484   NR XP_049831294.1 7010 g17466 i0 40.6 0.646464646464647 64 34 60.6 1 20 199 319 382 XP_049831294.1 la protein homolog isoform X1 [Schistocerca gregaria] diamond 192 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
31958566 31958566 PRJNA672101_S_NODE_3857_length_432_cov_4.270195_g3826_i0 PRJNA672101 3857 432 4.270195 18.4472424 root 1 Root_unresolved Root_unresolved 53.1 6.88e-5   NR GBN61280.1 182803 g3826 i0 50.9 3.38888888888889 53 26 36.8 0 315 157 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
32199889 32199889 PRJNA672101_S_NODE_20198_length_284_cov_4.014218_g20167_i0 PRJNA672101 20198 284 4.014218 11.40037912 Drosophila melanogaster 7227 Arthropoda Arthropoda 50.8 8.22e-5   NR NP_573291.1 7227 g20167 i0 48.1 0.549295774647887 52 26 54.9 1 275 120 126 176 NP_573291.1 uncharacterized protein Dmel_CG15056 [Drosophila melanogaster] diamond 156 50.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
32421360 32421360 PRJNA672101_S_NODE_14619_length_314_cov_6.614108_g14588_i0 PRJNA672101 14619 314 6.614108 20.768299119999998 Penaeus vannamei 6689 Arthropoda Arthropoda 43.9 0.0312   NR ROT81649.1 6689 g14588 i0 55.3 0.726114649681529 76 28 66.9 4 53 262 170 245 ROT81649.1 hypothetical protein C7M84_025201 [Penaeus vannamei] diamond 228 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
32673739 32673739 PRJNA672101_S_NODE_15100_length_311_cov_3.899160_g15069_i0 PRJNA672101 15100 311 3.89916 12.1263876 Schistocerca gregaria 7010 Arthropoda Arthropoda 107 2.17e-25   NR XP_049851169.1 7010 g15069 i0 47.6 0.993569131832797 103 54 99.4 0 311 3 215 317 XP_049851169.1 uncharacterized protein LOC126325505 [Schistocerca gregaria] diamond 309 107 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);;