RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA575566" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 28 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA575566 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
2412069 2412069 PRJNA575566_P_NODE_12462_length_297_cov_1.627119_g12265_i0 PRJNA575566 12462 297 1.627119 4.83254343 Daphnia pulex 6669 Arthropoda Arthropoda 137 4.23e-37   NR EFX60005.1 6669 g12265 i0 67.3 0.98989898989899 98 32 99 0 2 295 170 267 EFX60005.1 hypothetical protein DAPPUDRAFT_29116, partial [Daphnia pulex] diamond 294 137 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
4387465 4387465 PRJNA575566_P_NODE_18804_length_242_cov_1.817680_g18607_i0 PRJNA575566 18804 242 1.81768 4.3987856 Arthropoda 6656 Arthropoda Arthropoda 115 7.169999999999999e-31   NR XP_037944909.1 139649 g18607 i0 66.7 8.78925619834711 78 26 96.7 0 1 234 52 129 XP_037944909.1 eukaryotic translation initiation factor 5A-like [Teleopsis dalmanni] diamond 2127 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Diopsidae Teleopsis Teleopsis dalmanni
8213372 8213372 PRJNA575566_P_NODE_8847_length_352_cov_1.130584_g8650_i0 PRJNA575566 8847 352 1.130584 3.97965568 Artemia franciscana 6661 Arthropoda Arthropoda 173 1.79e-51   NR XP_065585031.1 6661 g8650 i0 69.2 14.90625 117 36 99.7 0 351 1 126 242 XP_065585031.1 small ribosomal subunit protein eS4 [Artemia franciscana] diamond 5247 173 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
20962248 20962248 PRJNA575566_P_NODE_22057_length_221_cov_2.187500_g21860_i0 PRJNA575566 22057 221 2.1875 4.834375 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 115 1.19e-31   NR XP_015781178.1 32264 g21860 i0 78.5 10.9954751131222 65 14 88.2 0 25 219 1 65 XP_015781178.1 60S ribosomal protein L37a [Tetranychus urticae] diamond 2430 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
23512419 23512419 PRJNA575566_P_NODE_22659_length_217_cov_2.410256_g22462_i0 PRJNA575566 22659 217 2.410256 5.23025552 root 1 Root_unresolved Root_unresolved 125 1.99e-31   NR KAI4453964.1 644536 g22462 i0 80.3 7.85253456221198 71 14 98.2 0 215 3 102 172 KAI4453964.1 6-phosphogluconate dehydrogenase [Holotrichia oblita] diamond 1704 125 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Scarabaeidae Holotrichia Holotrichia oblita
27047958 27047958 PRJNA575566_P_NODE_25622_length_207_cov_0.876712_g25425_i0 PRJNA575566 25622 207 0.876712 1.81479384 Photinus pyralis 7054 Arthropoda Arthropoda 57.8 9.27e-8   NR XP_031357072.1 7054 g25425 i0 39.7 0.91304347826087 63 37 89.9 1 187 2 128 190 XP_031357072.1 suppressor of cytokine signaling 6-like [Photinus pyralis] diamond 189 57.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Photinus Photinus pyralis
27932382 27932382 PRJNA575566_P_NODE_25945_length_207_cov_0.876712_g25748_i0 PRJNA575566 25945 207 0.876712 1.81479384 Teleopsis dalmanni 139649 Arthropoda Arthropoda 74.7 1.23e-13   NR XP_037939007.1 139649 g25748 i0 56.7 1.94202898550725 67 29 97.1 0 3 203 64 130 XP_037939007.1 trifunctional enzyme subunit alpha, mitochondrial [Teleopsis dalmanni] diamond 402 74.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Diopsidae Teleopsis Teleopsis dalmanni
28121823 28121823 PRJNA575566_P_NODE_28465_length_203_cov_0.901408_g28268_i0 PRJNA575566 28465 203 0.901408 1.82985824 Cinara cedri 506608 Arthropoda Arthropoda 67.8 4.22e-12   NR VVC24879.1 506608 g28268 i0 43.9 1.95073891625616 66 37 97.5 0 200 3 105 170 VVC24879.1 Protein of unknown function DUF423 [Cinara cedri] diamond 396 67.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cinara Cinara cedri
28500797 28500797 PRJNA575566_P_NODE_26587_length_206_cov_0.882759_g26390_i0 PRJNA575566 26587 206 0.882759 1.81848354 Kerria lacca 473130 Arthropoda Arthropoda 95.9 4.420000000000001e-21   NR XKL68142.1 473130 g26390 i0 60.3 2.97087378640777 68 27 99 0 1 204 122 189 XKL68142.1 hypothetical protein PGB90_003633 [Kerria lacca] diamond 612 95.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Tachardiidae Kerria Kerria lacca
28514283 28514283 PRJNA575566_P_NODE_13827_length_283_cov_1.153153_g13630_i0 PRJNA575566 13827 283 1.153153 3.26342299 root 1 Root_unresolved Root_unresolved 111 3.74e-26   NR CAD7272853.1 399045 g13630 i0 53.2 2.98939929328622 94 44 99.6 0 2 283 261 354 CAD7272853.1 unnamed protein product [Notodromas monacha] diamond 846 111 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
28514285 28514285 PRJNA575566_P_NODE_25147_length_208_cov_0.870748_g24950_i0 PRJNA575566 25147 208 0.870748 1.81115584 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 78.6 5.47e-15   NR KAJ9574051.1 6984 g24950 i0 53.8 5.74038461538461 65 30 93.8 0 206 12 771 835 KAJ9574051.1 hypothetical protein L9F63_008577, partial [Diploptera punctata] diamond 1194 79 0.994936708860759 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blaberidae Diploptera Diploptera punctata
28879486 28879486 PRJNA575566_P_NODE_23088_length_215_cov_1.246753_g22891_i0 PRJNA575566 23088 215 1.246753 2.68051895 Schistocerca gregaria 7010 Arthropoda Arthropoda 108 2.37e-25   NR XP_049848480.1 7010 g22891 i0 70 8.90232558139535 70 21 97.7 0 2 211 365 434 XP_049848480.1 transitional endoplasmic reticulum ATPase-like [Schistocerca gregaria] diamond 1914 108 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
28910870 28910870 PRJNA575566_P_NODE_21668_length_224_cov_1.343558_g21471_i0 PRJNA575566 21668 224 1.343558 3.00956992 Amphibalanus amphitrite 1232801 Arthropoda Arthropoda 80.1 2.02e-15   NR KAF0312698.1 1232801 g21471 i0 50 4.44642857142857 82 31 96.4 1 9 224 134 215 KAF0312698.1 Coatomer subunit alpha [Amphibalanus amphitrite] diamond 996 80.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Balanomorpha Balanidae Amphibalanus Amphibalanus amphitrite
28943034 28943034 PRJNA575566_P_NODE_25628_length_207_cov_0.876712_g25431_i0 PRJNA575566 25628 207 0.876712 1.81479384 Agrilus planipennis 224129 Arthropoda Arthropoda 42.4 0.0312   NR XP_018331600.1 224129 g25431 i0 38.7 0.898550724637681 62 38 89.9 0 187 2 1 62 XP_018331600.1 FK506-binding protein 59 isoform X2 [Agrilus planipennis] diamond 186 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Buprestidae Agrilus Agrilus planipennis
29082707 29082707 PRJNA575566_P_NODE_6168_length_421_cov_1.719444_g5971_i0 PRJNA575566 6168 421 1.719444 7.23885924 Arthropoda 6656 Arthropoda Arthropoda 164 5.79e-48   NR KAK8780331.1 6943 g5971 i0 68.5 7.43230403800475 130 41 92.6 0 421 32 62 191 KAK8780331.1 hypothetical protein V5799_018327 [Amblyomma americanum] diamond 3129 164 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Amblyomma Amblyomma americanum
29195469 29195469 PRJNA575566_P_NODE_23669_length_211_cov_1.706667_g23472_i0 PRJNA575566 23669 211 1.706667 3.60106737 Nephila pilipes 299642 Arthropoda Arthropoda 48.9 1.66e-4   NR GFT57284.1 299642 g23472 i0 47.9 1.36492890995261 48 23 68.2 1 151 8 39 84 GFT57284.1 sushi, von Willebrand factor type A, EGF and pentraxin domain-containing protein 1, partial [Nephila pilipes] diamond 288 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Nephila Nephila pilipes
29872012 29872012 PRJNA575566_P_NODE_18291_length_246_cov_1.383784_g18094_i0 PRJNA575566 18291 246 1.383784 3.40410864 Metazoa 33208 Arthropoda Arthropoda 92.8 6.28e-20   NR GLH05455.1 6999 g18094 i0 56.8 3.95121951219512 81 25 98.8 1 3 245 149 219 GLH05455.1 Lissencephaly-1 homolog [Gryllus bimaculatus] diamond 972 92.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Gryllidae Gryllus Gryllus bimaculatus
29903654 29903654 PRJNA575566_P_NODE_22451_length_219_cov_1.474684_g22254_i0 PRJNA575566 22451 219 1.474684 3.22955796 Opisthokonta 33154 Arthropoda Arthropoda 52.4 8.21e-6   NR KAH9628870.1 7107 g22254 i0 41.4 5.58904109589041 70 40 94.5 1 8 214 7 76 KAH9628870.1 hypothetical protein HF086_001105 [Spodoptera exigua] diamond 1224 52.8 0.992424242424242 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera exigua
30030030 30030030 PRJNA575566_P_NODE_11391_length_310_cov_2.056225_g11194_i0 PRJNA575566 11391 310 2.056225 6.3742975 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 143 1.55e-41   NR KAH0819945.1 7067 g11194 i0 65.7 25.8483870967742 99 33 95.8 1 299 3 1 98 KAH0819945.1 hypothetical protein GEV33_002846 [Tenebrio molitor] diamond 8013 143 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
30346399 30346399 PRJNA575566_P_NODE_21392_length_226_cov_1.163636_g21195_i0 PRJNA575566 21392 226 1.163636 2.62981736 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 52 1.57e-5   NR XP_052868794.1 68878 g21195 i0 64.7 1.06194690265487 34 12 45.1 0 104 3 206 239 XP_052868794.1 alanine--glyoxylate aminotransferase 2-like [Anopheles cruzii] diamond 240 52.4 0.99236641221374 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles cruzii
30395911 30395911 PRJNA575566_P_NODE_13613_length_285_cov_1.142857_g13416_i0 PRJNA575566 13613 285 1.142857 3.25714245 Stenichnus sp. 3037936 Arthropoda Arthropoda 77.4 6.37e-16   NR WYN07432.1 3037936 g13416 i0 50.6 6.21052631578947 85 39 87.4 2 279 31 24 107 WYN07432.1 NADH dehydrogenase subunit 3 [Stenichnus sp.] diamond 1770 77.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Stenichnus Stenichnus sp.
30743003 30743003 PRJNA575566_P_NODE_18554_length_244_cov_1.398907_g18357_i0 PRJNA575566 18554 244 1.398907 3.41333308 Fragariocoptes setiger 1670756 Arthropoda Arthropoda 110 7.72e-26   NR KAG9509753.1 1670756 g18357 i0 65 6.88524590163934 80 28 98.4 0 1 240 163 242 KAG9509753.1 Clathrin heavy chain 1, partial [Fragariocoptes setiger] diamond 1680 110 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Phytoptidae Fragariocoptes Fragariocoptes setiger
31547036 31547036 PRJNA575566_P_NODE_19176_length_240_cov_1.212291_g18979_i0 PRJNA575566 19176 240 1.212291 2.9094984 Insecta 50557 Arthropoda Arthropoda 50.4 5.81e-5   NR XP_024083242.1 79782 g18979 i0 36.5 2.6375 63 38 76.3 2 214 32 184 246 XP_024083242.1 cytochrome b5-related protein-like isoform X2 [Cimex lectularius] diamond 633 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cimicidae Cimex Cimex lectularius
31722972 31722972 PRJNA575566_P_NODE_27217_length_205_cov_0.888889_g27020_i0 PRJNA575566 27217 205 0.888889 1.82222245 Dendrolimus kikuchii 765133 Arthropoda Arthropoda 49.7 8.26e-5   NR KAJ0170064.1 765133 g27020 i0 47.3 2.34146341463415 55 29 80.5 0 17 181 546 600 KAJ0170064.1 hypothetical protein K1T71_014670 [Dendrolimus kikuchii] diamond 480 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lasiocampidae Dendrolimus Dendrolimus kikuchii
31849496 31849496 PRJNA575566_P_NODE_11037_length_315_cov_1.267717_g10840_i0 PRJNA575566 11037 315 1.267717 3.99330855 Cyamophila willieti 2604842 Arthropoda Arthropoda 62.4 5.02e-10   NR KAL1461371.1 2604842 g10840 i0 44.1 0.885714285714286 93 45 82.9 2 309 49 6 97 KAL1461371.1 hypothetical protein WDU94_013273 [Cyamophila willieti] diamond 279 62.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Cyamophila Cyamophila willieti
32324515 32324515 PRJNA575566_P_NODE_26879_length_205_cov_0.888889_g26682_i0 PRJNA575566 26879 205 0.888889 1.82222245 Anoplophora glabripennis 217634 Arthropoda Arthropoda 52 1.21e-5   NR XP_018579451.1 217634 g26682 i0 45.5 0.804878048780488 55 30 80.5 0 204 40 154 208 XP_018579451.1 plancitoxin-1 isoform X2 [Anoplophora glabripennis] diamond 165 52 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Anoplophora Anoplophora glabripennis
32608750 32608750 PRJNA575566_P_NODE_27720_length_204_cov_0.895105_g27523_i0 PRJNA575566 27720 204 0.895105 1.8260142 Trichonephila clavipes 2585209 Arthropoda Arthropoda 53.5 3.03e-6   NR GFW22603.1 2585209 g27523 i0 46.5 6.17647058823529 43 21 60.3 1 70 192 195 237 GFW22603.1 transposable element Tc1 transposase [Trichonephila clavipes] diamond 1260 53.9 0.992578849721707 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
32639962 32639962 PRJNA575566_P_NODE_28460_length_203_cov_0.901408_g28263_i0 PRJNA575566 28460 203 0.901408 1.82985824 Panulirus ornatus 150431 Arthropoda Arthropoda 55.5 7.24e-7   NR XP_071521614.1 150431 g28263 i0 45.3 1.89162561576355 64 32 90.1 2 20 202 954 1017 XP_071521614.1 uncharacterized protein sud1 isoform X2 [Panulirus ornatus] diamond 384 55.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palinuridae Panulirus Panulirus ornatus

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