RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "blastn", bioproject = "PRJNA1196384" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 33 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1196384 · 33 ✖

analysis 1

  • blastn · 33 ✖
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
1597284 1597284 PRJNA1196384_S_NODE_3542_length_209_cov_1.360465_g3478_i0 PRJNA1196384 3542 209 1.360465 2.84337185 Cydia strobilella 1100964 Arthropoda Arthropoda 156 1.36e-33   NTclustered gi|2694290680|ref|XM_063674203.1| 1100964 g3478 i0 81.72 60.9569377990431 186 34 89 0 1 186 426 241 PREDICTED: Cydia strobilella large ribosomal subunit protein uL15 (LOC134741429), transcript variant X2, mRNA blastn 12740 156 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia strobilella
3593577 3593577 PRJNA1196384_S_NODE_1763_length_295_cov_3.519380_g1699_i0 PRJNA1196384 1763 295 3.51938 10.382171 Drosophila 7215 Arthropoda Arthropoda 156 2.03e-33   NTclustered gi|1829475869|ref|XM_033311861.1| 7226 g1699 i0 81 42.1050847457627 200 35 68 1 38 237 179 375 PREDICTED: Drosophila mauritiana 60S acidic ribosomal protein P1 (LOC117145961), mRNA blastn 12421 156 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila mauritiana
4149601 4149601 PRJNA1196384_S_NODE_2764_length_233_cov_4.051020_g2700_i0 PRJNA1196384 2764 233 4.05102 9.4388766 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.021   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g2700 i0 100 0.120171673819742 28 0 12 0 15 42 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
4149653 4149653 PRJNA1196384_S_NODE_6024_length_169_cov_1.704545_g5960_i0 PRJNA1196384 6024 169 1.704545 2.88068105 Cydia pomonella 82600 Arthropoda Arthropoda 106 1.07e-18   NTclustered gi|2639410752|ref|XM_061855401.1| 82600 g5960 i0 84.259 2.56213017751479 108 17 64 0 1 108 353 246 PREDICTED: Cydia pomonella small ribosomal subunit protein uS11 (LOC133520764), mRNA blastn 433 106 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia pomonella
5425857 5425857 PRJNA1196384_S_NODE_3585_length_208_cov_1.140351_g3521_i0 PRJNA1196384 3585 208 1.140351 2.37193008 Drosophila serrata 7274 Arthropoda Arthropoda 89.8 1.39e-13   NTclustered gi|1189095141|ref|XM_020957441.1| 7274 g3521 i0 93.333 2.36538461538462 60 4 29 0 82 141 1188 1129 PREDICTED: Drosophila serrata calreticulin (LOC110187930), mRNA blastn 492 89.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila serrata
5425860 5425860 PRJNA1196384_S_NODE_365_length_605_cov_9.105634_g308_i0 PRJNA1196384 365 605 9.105634 55.0890857 Ixodes ricinus 34613 Arthropoda Arthropoda 1118 0   NTclustered gi|2315884134|gb|ON800839.1| 34613 g308 i0 100 94.7834710743802 605 0 100 0 1 605 2886 3490 Ixodes ricinus isolate 3 mitochondrion, complete genome blastn 57344 1118 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes ricinus
5425901 5425901 PRJNA1196384_S_NODE_5765_length_172_cov_1.696296_g5701_i0 PRJNA1196384 5765 172 1.696296 2.91762912 Dendroctonus ponderosae 77166 Arthropoda Arthropoda 147 6.429999999999999e-31   NTclustered gi|2252254095|ref|XM_019899245.2| 77166 g5701 i0 82.738 10.1046511627907 168 26 97 3 3 169 696 531 PREDICTED: Dendroctonus ponderosae ras-related protein Rap1 (LOC109533808), mRNA blastn 1738 147 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Dendroctonus Dendroctonus ponderosae
7976018 7976018 PRJNA1196384_S_NODE_2967_length_225_cov_6.765957_g2903_i0 PRJNA1196384 2967 225 6.765957 15.22340325 Eriocheir sinensis 95602 Arthropoda Arthropoda 117 7e-22   NTclustered gi|2311903009|ref|XM_050861302.1| 95602 g2903 i0 82.946 3.59555555555556 129 22 57 0 97 225 462 334 PREDICTED: Eriocheir sinensis ubiquitin-40S ribosomal protein S27a (LOC126998991), transcript variant X2, mRNA blastn 809 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Varunidae Eriocheir Eriocheir sinensis
7976044 7976044 PRJNA1196384_S_NODE_4407_length_190_cov_8.843137_g4343_i0 PRJNA1196384 4407 190 8.843137 16.8019603 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|2919553660|emb|OZ238364.1| 1002887 g4343 i0 96.875 0.336842105263158 32 1 17 0 120 151 24059155 24059124 Glaucopsyche melanops genome assembly, chromosome: W blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
8696138 8696138 PRJNA1196384_S_NODE_547_length_504_cov_4.177730_g485_i0 PRJNA1196384 547 504 4.17773 21.0557592 root 1 Root_unresolved Root_unresolved 259 2.71e-64   NTclustered gi|2384753|gb|AF016835.1|AF016835 7227 g485 i0 80.938 74.1527777777778 341 53 66 10 164 498 1082 748 Drosophila melanogaster ribosomal protein L3 (RpL3) mRNA, complete cds blastn 37373 259 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
9250586 9250586 PRJNA1196384_S_NODE_3368_length_213_cov_3.954545_g3304_i0 PRJNA1196384 3368 213 3.954545 8.42318085 Drosophila busckii 30019 Arthropoda Arthropoda 150 6.459999999999998e-32   NTclustered gi|1829296265|ref|XM_017999386.2| 30019 g3304 i0 79.621 32.849765258216 211 41 99 2 4 213 425 216 PREDICTED: Drosophila busckii 60S ribosomal protein L5 (LOC108608143), mRNA blastn 6997 150 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila busckii
9971259 9971259 PRJNA1196384_S_NODE_1808_length_291_cov_2.531496_g1744_i0 PRJNA1196384 1808 291 2.531496 7.36665336 Culex 7174 Arthropoda Arthropoda 161 4.29e-35   NTclustered gi|1949580423|ref|XM_001865100.2| 7176 g1744 i0 81.313 14.9656357388316 198 37 68 0 55 252 378 575 Culex quinquefasciatus 40S ribosomal protein S13 (LOC6048183), mRNA blastn 4355 161 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
10526436 10526436 PRJNA1196384_S_NODE_4369_length_191_cov_2.500000_g4305_i0 PRJNA1196384 4369 191 2.5 4.775 Ostrinia furnacalis 93504 Arthropoda Arthropoda 106 1.24e-18   NTclustered gi|1590279031|ref|XM_028307355.1| 93504 g4305 i0 86.458 1.00523560209424 96 13 50 0 95 190 476 381 PREDICTED: Ostrinia furnacalis histone H2A.V (LOC114354794), transcript variant X1, mRNA blastn 192 106 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Crambidae Ostrinia Ostrinia furnacalis
11801213 11801213 PRJNA1196384_S_NODE_3670_length_206_cov_1.562130_g3606_i0 PRJNA1196384 3670 206 1.56213 3.2179878 Drosophila elegans 30023 Arthropoda Arthropoda 150 6.21e-32   NTclustered gi|2042703958|ref|XM_017258577.2| 30023 g3606 i0 83.234 10.6067961165049 167 24 80 4 42 206 448 284 PREDICTED: Drosophila elegans RING-box protein 1A (LOC108137071), mRNA blastn 2185 150 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila elegans
11801223 11801223 PRJNA1196384_S_NODE_4110_length_196_cov_1.471698_g4046_i0 PRJNA1196384 4110 196 1.471698 2.88452808 Anopheles aquasalis 42839 Arthropoda Arthropoda 121 4.579999999999999e-23   NTclustered gi|2289116657|ref|XM_050232031.1| 42839 g4046 i0 78.836 2.61224489795918 189 32 94 8 3 187 670 486 PREDICTED: Anopheles aquasalis 40S ribosomal protein S3 (LOC126572605), mRNA blastn 512 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles aquasalis
12521811 12521811 PRJNA1196384_S_NODE_4330_length_192_cov_1.703226_g4266_i0 PRJNA1196384 4330 192 1.703226 3.27019392 Pieridae 7114 Arthropoda Arthropoda 154 4.41e-33   NTclustered gi|2566481429|gb|OK730972.1| 72259 g4266 i0 83.333 54.5885416666667 168 26 87 2 1 167 241 407 Eurema nicippe voucher CCNY:EB-19-X001 GTP-binding nuclear protein gene, partial cds blastn 10481 154 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pieridae Abaeis Abaeis nicippe
12521845 12521845 PRJNA1196384_S_NODE_850_length_415_cov_4.124339_g786_i0 PRJNA1196384 850 415 4.124339 17.11600685 Drosophila 7215 Arthropoda Arthropoda 324 7.66e-84   NTclustered gi|1829472574|ref|XM_033317027.1| 7226 g786 i0 81.01 98.5301204819277 416 71 99 7 2 413 705 294 PREDICTED: Drosophila mauritiana 40S ribosomal protein S2 (LOC117150228), mRNA blastn 40890 324 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila mauritiana
13076253 13076253 PRJNA1196384_S_NODE_1331_length_335_cov_3.348993_g1267_i0 PRJNA1196384 1331 335 3.348993 11.21912655 Drosophila takahashii 29030 Arthropoda Arthropoda 198 3.83e-46   NTclustered gi|2866477303|ref|XM_017139171.3| 29030 g1267 i0 83.784 21.0597014925373 222 22 64 12 1 215 359 573 PREDICTED: Drosophila takahashii ribosomal protein L18A (RpL18A), mRNA blastn 7055 198 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila takahashii
13076272 13076272 PRJNA1196384_S_NODE_2771_length_233_cov_2.147959_g2707_i0 PRJNA1196384 2771 233 2.147959 5.00474447 Chironomus tepperi 113505 Arthropoda Arthropoda 121 5.64e-23   NTclustered gi|2874193204|ref|XM_070649519.1| 113505 g2707 i0 76.293 1.59227467811159 232 51 99 4 3 232 877 1106 PREDICTED: Chironomus tepperi calreticulin (Calr), mRNA blastn 371 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tepperi
13076367 13076367 PRJNA1196384_S_NODE_8251_length_151_cov_4.578947_g8187_i0 PRJNA1196384 8251 151 4.578947 6.91420997 Drosophila kikkawai 30033 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2868164424|ref|XM_070286094.1| 30033 g8187 i0 100 4.74172185430464 30 0 20 0 6 35 450 479 PREDICTED: Drosophila kikkawai Polyubiquitin-63E (Ubi-p63E), transcript variant X5, mRNA blastn 716 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila kikkawai
14351717 14351717 PRJNA1196384_S_NODE_5112_length_180_cov_4.524476_g5048_i0 PRJNA1196384 5112 180 4.524476 8.1440568 Daktulosphaira vitifoliae 58002 Arthropoda Arthropoda 84.2 5.41e-12   NTclustered gi|2304380257|ref|XM_050670069.1| 58002 g5048 i0 82 5.04444444444444 100 16 55 2 8 106 448 546 PREDICTED: Daktulosphaira vitifoliae 40S ribosomal protein S24 (LOC126896901), mRNA blastn 908 84.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phylloxeridae Daktulosphaira Daktulosphaira vitifoliae
14351746 14351746 PRJNA1196384_S_NODE_6652_length_163_cov_1.515873_g6588_i0 PRJNA1196384 6652 163 1.515873 2.47087299 Drosophila bipectinata 42026 Arthropoda Arthropoda 230 5.8499999999999985e-56   NTclustered gi|2867890296|ref|XM_017245457.3| 42026 g6588 i0 93.038 98.5337423312883 158 10 96 1 2 158 1477 1320 PREDICTED: Drosophila bipectinata V-type proton ATPase subunit Vha55 (Vha55), mRNA blastn 16061 230 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila bipectinata
15625466 15625466 PRJNA1196384_S_NODE_3453_length_211_cov_4.178161_g3389_i0 PRJNA1196384 3453 211 4.178161 8.81591971 Pectinophora gossypiella 13191 Arthropoda Arthropoda 76.8 1.1e-9   NTclustered gi|2285920508|ref|XM_050021476.1| 13191 g3389 i0 89.831 2.49763033175355 59 6 28 0 153 211 569 511 PREDICTED: Pectinophora gossypiella 40S ribosomal protein S9 (LOC126374735), mRNA blastn 527 76.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Gelechiidae Pectinophora Pectinophora gossypiella
16899779 16899779 PRJNA1196384_S_NODE_314_length_638_cov_5.713810_g259_i0 PRJNA1196384 314 638 5.71381 36.4541078 Ixodes ricinus 34613 Arthropoda Arthropoda 1173 0   NTclustered gi|544190584|gb|KF197125.1| 34613 g259 i0 99.843 87.3369905956113 638 1 100 0 1 638 9870 10507 Ixodes ricinus isolate IR_28 mitochondrion, complete genome blastn 55721 1173 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes ricinus
16899798 16899798 PRJNA1196384_S_NODE_4114_length_196_cov_1.421384_g4050_i0 PRJNA1196384 4114 196 1.421384 2.78591264 Pararge aegeria 116150 Arthropoda Arthropoda 91.6 3.59e-14   NTclustered gi|1998044279|ref|XM_039903030.1| 116150 g4050 i0 88.158 2.86734693877551 76 9 39 0 33 108 2379 2454 PREDICTED: Pararge aegeria transitional endoplasmic reticulum ATPase TER94 (LOC120633006), transcript variant X1, mRNA blastn 562 91.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Pararge Pararge aegeria
16899849 16899849 PRJNA1196384_S_NODE_6494_length_164_cov_3.889764_g6430_i0 PRJNA1196384 6494 164 3.889764 6.37921296 Rhipicephalus microplus 6941 Arthropoda Arthropoda 150 4.72e-32   NTclustered gi|1930422008|ref|XM_037425577.1| 6941 g6430 i0 83.333 19.3841463414634 162 27 99 0 2 163 618 457 PREDICTED: Rhipicephalus microplus peptidyl-prolyl cis-trans isomerase-like (LOC119174592), mRNA blastn 3179 150 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
17620927 17620927 PRJNA1196384_S_NODE_4854_length_184_cov_1.278912_g4790_i0 PRJNA1196384 4854 184 1.278912 2.35319808 Cydia 82599 Arthropoda Arthropoda 71.3 4.33e-8   NTclustered gi|2695901554|ref|XM_063771098.1| 1100963 g4790 i0 93.617 0.510869565217391 47 3 26 0 24 70 979 1025 PREDICTED: Cydia splendana eukaryotic translation initiation factor 2 subunit 2 (LOC134798714), mRNA blastn 94 71.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia splendana
18174393 18174393 PRJNA1196384_S_NODE_975_length_387_cov_8.177143_g911_i0 PRJNA1196384 975 387 8.177143 31.64554341 Ixodes ricinus 34613 Arthropoda Arthropoda 715 0   NTclustered gi|2315884134|gb|ON800839.1| 34613 g911 i0 100 72.3488372093023 387 0 100 0 1 387 10837 10451 Ixodes ricinus isolate 3 mitochondrion, complete genome blastn 27999 715 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes ricinus
21445096 21445096 PRJNA1196384_S_NODE_6517_length_164_cov_2.102362_g6453_i0 PRJNA1196384 6517 164 2.102362 3.44787368 Opisthokonta 33154 Arthropoda Arthropoda 97.1 6.24e-16   NTclustered gi|1829495318|ref|XM_033303705.1| 7226 g6453 i0 91.429 26.9390243902439 70 6 43 0 1 70 588 657 PREDICTED: Drosophila mauritiana 60S ribosomal protein L18 (LOC117140661), mRNA blastn 4418 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila mauritiana
21999407 21999407 PRJNA1196384_S_NODE_1098_length_366_cov_14.838906_g1034_i0 PRJNA1196384 1098 366 14.838906 54.31039596 Chelidurella thaleri 2546182 Arthropoda Arthropoda 52.8 0.035   NTclustered gi|2919610158|emb|OZ238415.1| 2546182 g1034 i0 100 0.0765027322404372 28 0 8 0 37 64 2961675 2961648 Chelidura thaleri genome assembly, chromosome: 16 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
21999543 21999543 PRJNA1196384_S_NODE_8538_length_150_cov_0.982301_g8474_i0 PRJNA1196384 8538 150 0.982301 1.4734515 Drosophila busckii 30019 Arthropoda Arthropoda 161 1.95e-35   NTclustered gi|1060183832|ref|XM_017999501.1| 30019 g8474 i0 86.395 24.4266666666667 147 20 98 0 1 147 1540 1394 PREDICTED: Drosophila busckii elongation factor 2 (LOC108608224), transcript variant X1, mRNA blastn 3664 161 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila busckii
22720021 22720021 PRJNA1196384_S_NODE_8078_length_152_cov_3.939130_g8014_i0 PRJNA1196384 8078 152 3.93913 5.9874776 Opisthokonta 33154 Arthropoda Arthropoda 222 8.95e-54   NTclustered gi|2897329798|ref|XM_065867967.2| 28584 g8014 i0 93.333 97.9013157894737 150 10 99 0 3 152 213 362 PREDICTED: Drosophila suzukii Actin 5C (Act5C), mRNA blastn 14881 222 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila suzukii
24548806 24548806 PRJNA1196384_S_NODE_4980_length_182_cov_1.600000_g4916_i0 PRJNA1196384 4980 182 1.6 2.912 Chironomus tepperi 113505 Arthropoda Arthropoda 121 4.179999999999999e-23   NTclustered gi|2874227525|ref|XM_070648404.1| 113505 g4916 i0 82.836 3.62087912087912 134 23 74 0 47 180 436 303 PREDICTED: Chironomus tepperi Regulator of cullins 1a (Roc1a), mRNA blastn 659 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tepperi

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