RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJNA1188114" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 26 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1188114 · 26 ✖

analysis 1

  • diamond · 26 ✖
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
2870806 2870806 PRJNA1188114_P_NODE_2863_length_256_cov_2.463768_g2811_i0 PRJNA1188114 2863 256 2.463768 6.30724608 Arthropoda 6656 Arthropoda Arthropoda 64.3 1.06e-9   NR XP_046463245.1 6669 g2811 i0 62.3 3.57421875 61 23 71.5 0 3 185 589 649 XP_046463245.1 heat shock 70 kDa protein cognate 4 [Daphnia pulex] diamond 915 64.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
10523731 10523731 PRJNA1188114_P_NODE_3709_length_228_cov_3.055866_g3657_i0 PRJNA1188114 3709 228 3.055866 6.96737448 Insecta 50557 Arthropoda Arthropoda 121 9.8e-33   NR XP_044741242.1 189513 g3657 i0 76.1 6.51315789473684 71 17 93.4 0 1 213 126 196 XP_044741242.1 peroxiredoxin 1-like isoform X2 [Chrysoperla carnea] diamond 1485 122 0.991803278688525 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Neuroptera Chrysopidae Chrysoperla Chrysoperla carnea
18171654 18171654 PRJNA1188114_P_NODE_7875_length_184_cov_1.459259_g7823_i0 PRJNA1188114 7875 184 1.459259 2.68503656 Macrobrachium nipponense 159736 Arthropoda Arthropoda 73.9 9.27e-14   NR XP_064103370.1 159736 g7823 i0 50.8 2.98369565217391 61 27 94.6 1 7 180 230 290 XP_064103370.1 trypsin-1-like, partial [Macrobrachium nipponense] diamond 549 73.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium nipponense
26787659 26787659 PRJNA1188114_P_NODE_15761_length_164_cov_0.886957_g15709_i0 PRJNA1188114 15761 164 0.886957 1.45460948 Dermatophagoides farinae 6954 Arthropoda Arthropoda 108 1.14e-25   NR KAH9527705.1 6954 g15709 i0 100 0.98780487804878 54 0 98.8 0 164 3 842 895 KAH9527705.1 hypothetical protein DERF_001714 [Dermatophagoides farinae] diamond 162 108 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
26851054 26851054 PRJNA1188114_P_NODE_2641_length_265_cov_1.652778_g2589_i0 PRJNA1188114 2641 265 1.652778 4.3798617 Chironomus riparius 315576 Arthropoda Arthropoda 63.9 1.53e-9   NR CAG9810316.1 315576 g2589 i0 43.2 3.26037735849057 74 42 83.8 0 258 37 44 117 CAG9810316.1 unnamed protein product [Chironomus riparius] diamond 864 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus riparius
27230345 27230345 PRJNA1188114_P_NODE_7923_length_184_cov_1.259259_g7871_i0 PRJNA1188114 7923 184 1.259259 2.31703656 Folsomia candida 158441 Arthropoda Arthropoda 72 4.47e-13   NR XP_021964447.1 158441 g7871 i0 81.6 3.09782608695652 38 7 62 0 182 69 264 301 XP_021964447.1 probable very-long-chain enoyl-CoA reductase art-1 [Folsomia candida] diamond 570 72 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Isotomidae Folsomia Folsomia candida
27451815 27451815 PRJNA1188114_P_NODE_7043_length_187_cov_1.521739_g6991_i0 PRJNA1188114 7043 187 1.521739 2.84565193 Homalodisca vitripennis 197043 Arthropoda Arthropoda 63.2 4.33e-11   NR KAG8320857.1 197043 g6991 i0 51.6 0.994652406417112 62 23 99.5 1 187 2 19 73 KAG8320857.1 G-protein-signaling modulator 2 [Homalodisca vitripennis] diamond 186 63.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
27755023 27755023 PRJNA1188114_P_NODE_3884_length_224_cov_2.251429_g3832_i0 PRJNA1188114 3884 224 2.251429 5.04320096 Metazoa 33208 Arthropoda Arthropoda 129 1.36e-32   NR XP_031334369.1 7054 g3832 i0 75.7 12.8839285714286 74 18 99.1 0 223 2 678 751 XP_031334369.1 mannosyl-oligosaccharide glucosidase GCS1 [Photinus pyralis] diamond 2886 130 0.992307692307692 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Photinus Photinus pyralis
27988383 27988383 PRJNA1188114_P_NODE_8905_length_180_cov_1.167939_g8853_i0 PRJNA1188114 8905 180 1.167939 2.1022902 Gryllus bimaculatus 6999 Arthropoda Arthropoda 43.1 0.0115   NR GLG95325.1 6999 g8853 i0 45.8 1.58333333333333 48 26 80 0 27 170 317 364 GLG95325.1 Putative low-specificity L-threonine aldolase 2 [Gryllus bimaculatus] diamond 285 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Gryllidae Gryllus Gryllus bimaculatus
28039043 28039043 PRJNA1188114_P_NODE_14465_length_165_cov_0.879310_g14413_i0 PRJNA1188114 14465 165 0.87931 1.4508615 Cerambycidae 34667 Arthropoda Arthropoda 58.9 2.47e-8   NR KAJ8941274.1 1265417 g14413 i0 51 9.34545454545455 51 25 92.7 0 164 12 634 684 KAJ8941274.1 hypothetical protein NQ318_016939, partial [Aromia moschata] diamond 1542 58.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Aromia Aromia moschata
28272318 28272318 PRJNA1188114_P_NODE_8446_length_182_cov_1.150376_g8394_i0 PRJNA1188114 8446 182 1.150376 2.09368432 Polyplax serrata 468196 Arthropoda Arthropoda 58.2 5.96e-8   NR KAK6623331.1 468196 g8394 i0 57.7 2.47252747252747 52 22 85.7 0 159 4 116 167 KAK6623331.1 hypothetical protein RUM43_009183 [Polyplax serrata] diamond 450 58.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
28556832 28556832 PRJNA1188114_P_NODE_18347_length_162_cov_0.902655_g18295_i0 PRJNA1188114 18347 162 0.902655 1.4623011 Cryptotermes secundus 105785 Arthropoda Arthropoda 50.1 3.16e-5   NR XP_023715187.1 105785 g18295 i0 83.3 2.66666666666667 24 4 44.4 0 73 2 378 401 XP_023715187.1 putative inorganic phosphate cotransporter isoform X2 [Cryptotermes secundus] diamond 432 50.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Kalotermitidae Cryptotermes Cryptotermes secundus
29093592 29093592 PRJNA1188114_P_NODE_5248_length_201_cov_1.473684_g5196_i0 PRJNA1188114 5248 201 1.473684 2.96210484 Bacillus rossius redtenbacheri 93214 Arthropoda Arthropoda 91.3 1.59e-19   NR XP_063234175.1 93214 g5196 i0 59.1 8.88059701492537 66 27 98.5 0 1 198 166 231 XP_063234175.1 UDP-N-acetylhexosamine pyrophosphorylase [Bacillus rossius redtenbacheri] diamond 1785 91.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Bacillidae Bacillus Bacillus rossius
30325659 30325659 PRJNA1188114_P_NODE_1132_length_407_cov_1.265363_g1080_i0 PRJNA1188114 1132 407 1.265363 5.15002741 Ixodes pacificus 29930 Arthropoda Arthropoda 94 2.06e-19   NR CAL6243403.1 29930 g1080 i0 39.7 2.00491400491401 136 77 99.5 4 405 1 314 445 CAL6243403.1 unnamed protein product, partial [Ixodes pacificus] diamond 816 94 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes pacificus
30344733 30344733 PRJNA1188114_P_NODE_17272_length_163_cov_0.894737_g17220_i0 PRJNA1188114 17272 163 0.894737 1.45842131 Coleoptera 7041 Arthropoda Arthropoda 51.6 9.02e-6   NR KAK9730858.1 7064 g17220 i0 64.1 5.74233128834356 39 13 71.8 1 3 119 416 453 KAK9730858.1 Reverse transcriptase (RNA-dependent DNA polymerase) [Popillia japonica] diamond 936 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Scarabaeidae Popillia Popillia japonica
30564980 30564980 PRJNA1188114_P_NODE_4113_length_219_cov_5.223529_g4061_i0 PRJNA1188114 4113 219 5.223529 11.43952851 Insecta 50557 Arthropoda Arthropoda 43.1 0.0194   NR KAF7389463.1 30213 g4061 i0 79.2 3.31506849315068 48 9 65.8 1 208 65 110 156 KAF7389463.1 hypothetical protein H0235_017947 [Vespula pensylvanica] diamond 726 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Vespula Vespula pensylvanica
30640918 30640918 PRJNA1188114_P_NODE_14493_length_165_cov_0.879310_g14441_i0 PRJNA1188114 14493 165 0.87931 1.4508615 Henosepilachna vigintioctopunctata 420089 Arthropoda Arthropoda 43.9 0.00508   NR KAK9875697.1 420089 g14441 i0 70.4 1.50909090909091 27 8 49.1 0 15 95 850 876 KAK9875697.1 hypothetical protein WA026_009494 [Henosepilachna vigintioctopunctata] diamond 249 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Henosepilachna Henosepilachna vigintioctopunctata
30640921 30640921 PRJNA1188114_P_NODE_7313_length_186_cov_1.489051_g7261_i0 PRJNA1188114 7313 186 1.489051 2.76963486 Clunio marinus 568069 Arthropoda Arthropoda 66.2 8.76e-11   NR CRK99702.1 568069 g7261 i0 90.9 0.532258064516129 33 3 53.2 0 100 2 304 336 CRK99702.1 CLUMA_CG012998, isoform B [Clunio marinus] diamond 99 66.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Clunio Clunio marinus
30976181 30976181 PRJNA1188114_P_NODE_3734_length_228_cov_1.139665_g3682_i0 PRJNA1188114 3734 228 1.139665 2.5984362 Phasmatodea 7020 Arthropoda Arthropoda 62 2.47e-9   NR CAD7201529.1 61478 g3682 i0 71.8 3.55263157894737 39 11 51.3 0 15 131 6 44 CAD7201529.1 unnamed protein product, partial [Timema douglasi] diamond 810 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
31146151 31146151 PRJNA1188114_P_NODE_15155_length_165_cov_0.879310_g15103_i0 PRJNA1188114 15155 165 0.87931 1.4508615 Pseudolycoriella hygida 35572 Arthropoda Arthropoda 59.7 1.15e-8   NR KAJ6640049.1 35572 g15103 i0 41.2 0.927272727272727 51 30 92.7 0 165 13 248 298 KAJ6640049.1 Failed axon connections like [Pseudolycoriella hygida] diamond 153 59.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
31165326 31165326 PRJNA1188114_P_NODE_14695_length_165_cov_0.879310_g14643_i0 PRJNA1188114 14695 165 0.87931 1.4508615 Arthropoda 6656 Arthropoda Arthropoda 85.1 1.27e-18   NR XP_017493383.1 28612 g14643 i0 88.4 2.29090909090909 43 5 78.2 0 130 2 75 117 XP_017493383.1 PREDICTED: sodium/potassium-transporting ATPase subunit alpha-1-like, partial [Rhagoletis zephyria] diamond 378 85.5 0.9953216374269 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
31273083 31273083 PRJNA1188114_P_NODE_7155_length_187_cov_1.210145_g7103_i0 PRJNA1188114 7155 187 1.210145 2.26297115 Dalotia coriaria 877792 Arthropoda Arthropoda 77 2.98e-15   NR XP_065161256.1 877792 g7103 i0 78.7 0.754010695187166 47 10 75.4 0 156 16 190 236 XP_065161256.1 proteasome subunit beta type-1 [Dalotia coriaria] diamond 141 77 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Dalotia Dalotia coriaria
31589530 31589530 PRJNA1188114_P_NODE_6396_length_190_cov_1.106383_g6344_i0 PRJNA1188114 6396 190 1.106383 2.1021277 Clunio marinus 568069 Arthropoda Arthropoda 68.9 9.74e-12   NR CRK89677.1 568069 g6344 i0 72.5 0.631578947368421 40 11 63.2 0 69 188 31 70 CRK89677.1 CLUMA_CG003431, isoform A [Clunio marinus] diamond 120 68.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Clunio Clunio marinus
32254029 32254029 PRJNA1188114_P_NODE_12858_length_167_cov_0.864407_g12806_i0 PRJNA1188114 12858 167 0.864407 1.44355969 Blattella germanica 6973 Arthropoda Arthropoda 113 1.53e-27   NR PSN43794.1 6973 g12806 i0 100 0.916167664670659 51 0 91.6 0 14 166 3 53 PSN43794.1 hypothetical protein C0J52_15509 [Blattella germanica] diamond 153 113 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
32695949 32695949 PRJNA1188114_P_NODE_2420_length_275_cov_1.951327_g2368_i0 PRJNA1188114 2420 275 1.951327 5.36614925 Molorchus minor 1323400 Arthropoda Arthropoda 67 1.57e-10   NR KAJ8981333.1 1323400 g2368 i0 49.4 1.86545454545455 81 29 88.4 4 31 273 26 94 KAJ8981333.1 hypothetical protein NQ317_015974 [Molorchus minor] diamond 513 67 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Molorchus Molorchus minor
32821983 32821983 PRJNA1188114_P_NODE_18540_length_162_cov_0.902655_g18488_i0 PRJNA1188114 18540 162 0.902655 1.4623011 Medioppia subpectinata 1979941 Arthropoda Arthropoda 42.7 0.0124   NR CAD7621401.1 1979941 g18488 i0 46.8 0.87037037037037 47 23 83.3 1 3 137 44 90 CAD7621401.1 unnamed protein product [Medioppia subpectinata] diamond 141 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata

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