RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA1115053" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 32 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1115053 · 32 ✖

analysis 1

  • diamond · 32 ✖
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
26624798 26624798 PRJNA1115053_S_NODE_311341_length_158_cov_2.086957_g309524_i0 PRJNA1115053 311341 158 2.086957 3.29739206 Caligus rogercresseyi 217165 Arthropoda Arthropoda 87.8 1.54e-18   NR QQP50210.1 217165 g309524 i0 78.8 8.88607594936709 52 11 98.7 0 157 2 317 368 QQP50210.1 Uncharacterized protein FKW44_011137 [Caligus rogercresseyi] diamond 1404 88.2 0.99546485260771 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Caligus Caligus rogercresseyi
26751140 26751140 PRJNA1115053_S_NODE_90321_length_270_cov_1.480176_g88504_i0 PRJNA1115053 90321 270 1.480176 3.9964752 Meganyctiphanes norvegica 48144 Arthropoda Arthropoda 43.5 0.0282   NR CAL4069830.1 48144 g88504 i0 32.8 0.677777777777778 61 31 67.8 1 186 4 176 226 CAL4069830.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 183 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
26900994 26900994 PRJNA1115053_S_NODE_143081_length_224_cov_1.325967_g141264_i0 PRJNA1115053 143081 224 1.325967 2.97016608 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 90.1 4.2e-21   NR XP_013110759.1 35570 g141264 i0 83.3 115.794642857143 54 9 72.3 0 224 63 78 131 XP_013110759.1 ubiquitin-like FUBI-ribosomal protein eS30 fusion protein [Stomoxys calcitrans] diamond 25938 90.5 0.995580110497237 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Stomoxys Stomoxys calcitrans
26932509 26932509 PRJNA1115053_S_NODE_126282_length_236_cov_1.243523_g124465_i0 PRJNA1115053 126282 236 1.243523 2.93471428 Palaemonidae 6695 Arthropoda Arthropoda 46.2 0.00199   NR XP_066969100.1 79674 g124465 i0 53.3 1.80508474576271 45 19 54.7 1 179 51 378 422 XP_066969100.1 uncharacterized protein [Macrobrachium rosenbergii] diamond 426 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium rosenbergii
27067919 27067919 PRJNA1115053_S_NODE_124882_length_237_cov_1.469072_g123065_i0 PRJNA1115053 124882 237 1.469072 3.48170064 Spodoptera littoralis 7109 Arthropoda Arthropoda 40 0.0477   NR CAB3517760.1 7109 g123065 i0 41.3 0.582278481012658 46 24 57 2 89 223 18 61 CAB3517760.1 unnamed protein product [Spodoptera littoralis] diamond 138 40 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera littoralis
27225876 27225876 PRJNA1115053_S_NODE_137203_length_228_cov_1.297297_g135386_i0 PRJNA1115053 137203 228 1.297297 2.95783716 Penaeus vannamei 6689 Arthropoda Arthropoda 43.1 0.0223   NR ROT84963.1 6689 g135386 i0 50 0.552631578947368 42 20 53.9 1 133 11 581 622 ROT84963.1 hypothetical protein C7M84_021703 [Penaeus vannamei] diamond 126 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
27478816 27478816 PRJNA1115053_S_NODE_284623_length_165_cov_1.967213_g282806_i0 PRJNA1115053 284623 165 1.967213 3.24590145 Musca vetustissima 27455 Arthropoda Arthropoda 42 0.0256   NR XP_061388404.1 27455 g282806 i0 36 0.909090909090909 50 31 90.9 1 16 165 2085 2133 XP_061388404.1 serine protease nudel [Musca vetustissima] diamond 150 42 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Musca Musca vetustissima
27605271 27605271 PRJNA1115053_S_NODE_138704_length_227_cov_1.304348_g136887_i0 PRJNA1115053 138704 227 1.304348 2.96086996 Diaphorina citri 121845 Arthropoda Arthropoda 42.4 0.0418   NR KAI5716805.1 121845 g136887 i0 64.9 0.488986784140969 37 9 46.3 2 59 163 391 425 KAI5716805.1 hypothetical protein M8J76_012671 [Diaphorina citri] diamond 111 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
27636837 27636837 PRJNA1115053_S_NODE_190064_length_198_cov_1.787097_g188247_i0 PRJNA1115053 190064 198 1.787097 3.53845206 Trinorchestia longiramus 1923959 Arthropoda Arthropoda 92.8 4.38e-20   NR KAF2347932.1 1923959 g188247 i0 81.6 0.742424242424242 49 9 74.2 0 51 197 151 199 KAF2347932.1 hypothetical protein FHG87_021314 [Trinorchestia longiramus] diamond 147 92.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Talitridae Trinorchestia Trinorchestia longiramus
27731690 27731690 PRJNA1115053_S_NODE_110544_length_249_cov_1.631068_g108727_i0 PRJNA1115053 110544 249 1.631068 4.06135932 Timema douglasi 61478 Arthropoda Arthropoda 43.1 0.0298   NR CAD7197585.1 61478 g108727 i0 37.3 0.807228915662651 67 39 80.7 1 3 203 281 344 CAD7197585.1 unnamed protein product [Timema douglasi] diamond 201 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
27857632 27857632 PRJNA1115053_S_NODE_73585_length_292_cov_1.783133_g71768_i0 PRJNA1115053 73585 292 1.783133 5.20674836 Coptotermes formosanus 36987 Arthropoda Arthropoda 43.1 0.0489   NR GFG30553.1 36987 g71768 i0 35.5 0.636986301369863 62 35 63.7 2 191 6 79 135 GFG30553.1 hypothetical protein Cfor_10836 [Coptotermes formosanus] diamond 186 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
28426167 28426167 PRJNA1115053_S_NODE_94206_length_265_cov_3.220721_g92389_i0 PRJNA1115053 94206 265 3.220721 8.53491065 Trichogramma pretiosum 7493 Arthropoda Arthropoda 59.3 3.09e-8   NR XP_014235764.1 7493 g92389 i0 42.4 1.04150943396226 92 43 92.8 2 263 18 107 198 XP_014235764.1 60S ribosomal protein L13-like [Trichogramma pretiosum] diamond 276 59.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma pretiosum
28890573 28890573 PRJNA1115053_S_NODE_275748_length_168_cov_1.152000_g273931_i0 PRJNA1115053 275748 168 1.152 1.93536 Araneidae 6913 Arthropoda Arthropoda 42.7 0.0106   NR XP_055924574.1 94029 g273931 i0 43.4 22.3928571428571 53 28 91.1 1 14 166 90 142 XP_055924574.1 uncharacterized protein LOC129956667 [Argiope bruennichi] diamond 3762 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Argiope Argiope bruennichi
29057612 29057612 PRJNA1115053_S_NODE_339248_length_152_cov_3.633028_g337431_i0 PRJNA1115053 339248 152 3.633028 5.52220256 Trichonephila clavipes 2585209 Arthropoda Arthropoda 73.6 6.14e-14   NR GFV19184.1 2585209 g337431 i0 66 2.72368421052632 47 10 80.9 1 8 130 154 200 GFV19184.1 transposable element Tcb1 transposase [Trichonephila clavipes] diamond 414 73.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
29553526 29553526 PRJNA1115053_S_NODE_253850_length_174_cov_2.160305_g252033_i0 PRJNA1115053 253850 174 2.160305 3.7589307 Metazoa 33208 Arthropoda Arthropoda 78.6 3.41e-15   NR PSN37765.1 6973 g252033 i0 90.5 4.39655172413793 42 4 72.4 0 3 128 1124 1165 PSN37765.1 Chromodomain-helicase-DNA-binding protein Mi-2 [Blattella germanica] diamond 765 78.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
29806213 29806213 PRJNA1115053_S_NODE_177191_length_204_cov_2.186335_g175374_i0 PRJNA1115053 177191 204 2.186335 4.4601234 Ixodidae 6939 Arthropoda Arthropoda 42.4 0.0294   NR XP_037272257.1 6941 g175374 i0 44.7 4.14705882352941 47 21 64.7 2 152 21 31 75 XP_037272257.1 uncharacterized protein LOC119164220 isoform X2 [Rhipicephalus microplus] diamond 846 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
29815172 29815172 PRJNA1115053_S_NODE_269611_length_170_cov_0.803150_g267794_i0 PRJNA1115053 269611 170 0.80315 1.365355 Cardiocondyla obscurior 286306 Arthropoda Arthropoda 40 0.025   NR KAL0111751.1 286306 g267794 i0 48.5 0.582352941176471 33 17 58.2 0 2 100 36 68 KAL0111751.1 hypothetical protein PUN28_013144 [Cardiocondyla obscurior] diamond 99 40 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Cardiocondyla Cardiocondyla obscurior
29846940 29846940 PRJNA1115053_S_NODE_341811_length_152_cov_1.321101_g339994_i0 PRJNA1115053 341811 152 1.321101 2.00807352 Uroleucon formosanum 796250 Arthropoda Arthropoda 43.9 0.00403   NR KAL4154483.1 796250 g339994 i0 47.8 3.57236842105263 46 23 88.8 1 147 13 187 232 KAL4154483.1 hypothetical protein QTP88_000346 [Uroleucon formosanum] diamond 543 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Uroleucon Uroleucon formosanum
29869526 29869526 PRJNA1115053_S_NODE_108951_length_250_cov_3.463768_g107134_i0 PRJNA1115053 108951 250 3.463768 8.65942 Insecta 50557 Arthropoda Arthropoda 47.4 9.4e-4   NR PSN43193.1 6973 g107134 i0 80.6 0.744 31 6 37.2 0 249 157 441 471 PSN43193.1 T-complex protein 1 subunit beta [Blattella germanica] diamond 186 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
29878594 29878594 PRJNA1115053_S_NODE_136191_length_228_cov_4.091892_g134374_i0 PRJNA1115053 136191 228 4.091892 9.32951376 Allacma fusca 39272 Arthropoda Arthropoda 43.1 0.0182   NR CAG7825199.1 39272 g134374 i0 36 0.657894736842105 50 28 60.5 1 69 206 79 128 CAG7825199.1 unnamed protein product [Allacma fusca] diamond 150 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
29996040 29996040 PRJNA1115053_S_NODE_211771_length_189_cov_1.493151_g209954_i0 PRJNA1115053 211771 189 1.493151 2.82205539 Insecta 50557 Arthropoda Arthropoda 69.3 7.41e-12   NR XP_037808071.1 13632 g209954 i0 50 3.25396825396825 54 27 85.7 0 2 163 237 290 XP_037808071.1 zinc finger protein 182-like isoform X2 [Lucilia sericata] diamond 615 69.7 0.994261119081779 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia sericata
30004911 30004911 PRJNA1115053_S_NODE_160211_length_213_cov_2.258824_g158394_i0 PRJNA1115053 160211 213 2.258824 4.81129512 Drosophila rubida 30044 Arthropoda Arthropoda 42 0.0471   NR KAH8365782.1 30044 g158394 i0 43.1 0.71830985915493 51 23 70.4 2 51 200 460 505 KAH8365782.1 hypothetical protein KR093_004365 [Drosophila rubida] diamond 153 42 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila rubida
30036462 30036462 PRJNA1115053_S_NODE_175211_length_205_cov_2.135802_g173394_i0 PRJNA1115053 175211 205 2.135802 4.3783941 Incisitermes schwarzi 765390 Arthropoda Arthropoda 42 0.0381   NR UQJ75083.1 765390 g173394 i0 41.1 0.819512195121951 56 29 82 1 193 26 61 112 UQJ75083.1 ATP synthase F0 subunit 6 [Incisitermes schwarzi] diamond 168 42 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Kalotermitidae Incisitermes Incisitermes schwarzi
30289544 30289544 PRJNA1115053_S_NODE_171592_length_207_cov_1.756098_g169775_i0 PRJNA1115053 171592 207 1.756098 3.63512286 Larinioides sclopetarius 280406 Arthropoda Arthropoda 52.8 6.9e-6   NR CAL1279908.1 280406 g169775 i0 58.1 1.23188405797101 43 18 62.3 0 180 52 29 71 CAL1279908.1 unnamed protein product, partial [Larinioides sclopetarius] diamond 255 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Larinioides Larinioides sclopetarius
30384388 30384388 PRJNA1115053_S_NODE_247633_length_176_cov_2.052632_g245816_i0 PRJNA1115053 247633 176 2.052632 3.61263232 Trichonephila clavipes 2585209 Arthropoda Arthropoda 42.7 0.00954   NR GFU38347.1 2585209 g245816 i0 46.8 11.5056818181818 47 15 69.9 2 174 52 119 161 GFU38347.1 transposable element Tcb1 transposase [Trichonephila clavipes] diamond 2025 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
30510304 30510304 PRJNA1115053_S_NODE_132693_length_231_cov_1.680851_g130876_i0 PRJNA1115053 132693 231 1.680851 3.88276581 Araneus ventricosus 182803 Arthropoda Arthropoda 46.6 8.13e-4   NR GBM81557.1 182803 g130876 i0 87 1.19480519480519 23 3 29.9 0 163 231 43 65 GBM81557.1 Transposable element Tc1 transposase [Araneus ventricosus] diamond 276 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
30541921 30541921 PRJNA1115053_S_NODE_351613_length_151_cov_0.888889_g349796_i0 PRJNA1115053 351613 151 0.888889 1.34222239 Scirpophaga incertulas 72366 Arthropoda Arthropoda 40.8 0.0498   NR KAL4704037.1 72366 g349796 i0 53.7 0.814569536423841 41 16 75.5 2 119 6 282 322 KAL4704037.1 hypothetical protein ACJJTC_015193 [Scirpophaga incertulas] diamond 123 40.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Crambidae Scirpophaga Scirpophaga incertulas
30984456 30984456 PRJNA1115053_S_NODE_228994_length_182_cov_5.086331_g227177_i0 PRJNA1115053 228994 182 5.086331 9.25712242 Nymphon striatum 424472 Arthropoda Arthropoda 92 1.36e-21   NR KAG1673498.1 424472 g227177 i0 76.7 0.989010989010989 60 14 98.9 0 181 2 119 178 KAG1673498.1 60S ribosomal protein L23a [Nymphon striatum] diamond 180 92 1 Eukaryota Opisthokonta Metazoa Arthropoda Pycnogonida Pantopoda Nymphonidae Nymphon Nymphon striatum
31110475 31110475 PRJNA1115053_S_NODE_144315_length_223_cov_1.600000_g142498_i0 PRJNA1115053 144315 223 1.6 3.568 Caerostris darwini 1538125 Arthropoda Arthropoda 40.8 0.0414   NR GIY02934.1 1538125 g142498 i0 38.6 0.94170403587444 70 31 78 3 210 37 24 93 GIY02934.1 hypothetical protein CDAR_407311 [Caerostris darwini] diamond 210 40.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Caerostris Caerostris darwini
31300337 31300337 PRJNA1115053_S_NODE_263275_length_171_cov_2.820312_g261458_i0 PRJNA1115053 263275 171 2.820312 4.82273352 Panonychus citri 50023 Arthropoda Arthropoda 59.3 2.63e-9   NR XP_053211566.1 50023 g261458 i0 63.4 0.719298245614035 41 15 71.9 0 160 38 96 136 XP_053211566.1 60S ribosomal protein L27-like [Panonychus citri] diamond 123 59.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri
31458645 31458645 PRJNA1115053_S_NODE_282536_length_166_cov_1.170732_g280719_i0 PRJNA1115053 282536 166 1.170732 1.94341512 Ceratitis capitata 7213 Arthropoda Arthropoda 40.8 0.0467   NR CAD6994634.1 7213 g280719 i0 46.2 0.704819277108434 39 21 70.5 0 30 146 19 57 CAD6994634.1 unnamed protein product [Ceratitis capitata] diamond 117 40.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Ceratitis Ceratitis capitata
31774663 31774663 PRJNA1115053_S_NODE_133897_length_230_cov_2.005348_g132080_i0 PRJNA1115053 133897 230 2.005348 4.6123004 Henosepilachna vigintioctopunctata 420089 Arthropoda Arthropoda 42.7 0.0313   NR KAK9885449.1 420089 g132080 i0 33.8 0.965217391304348 74 44 92.6 2 16 228 45 116 KAK9885449.1 hypothetical protein WA026_010945 [Henosepilachna vigintioctopunctata] diamond 222 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Henosepilachna Henosepilachna vigintioctopunctata

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