RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA1242190" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 23 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1242190 · 23 ✖
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
350696 350696 PRJNA1242190_S_NODE_10601_length_266_cov_1.093264_g10594_i0 PRJNA1242190 10601 266 1.093264 2.90808224 Orthetrum poecilops 1168658 Arthropoda Arthropoda 71.3 6.72e-8   NTclustered gi|2709255482|dbj|LC757448.1| 1168658 g10594 i0 100 16.3383458646617 38 0 14 0 27 64 14870 14833 Orthetrum poecilops RFr0884 mitochondrial DNA, nearly complete genome blastn 4346 71.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Libellulidae Orthetrum Orthetrum poecilops
1625597 1625597 PRJNA1242190_S_NODE_3162_length_438_cov_3.542466_g3155_i0 PRJNA1242190 3162 438 3.542466 15.51600108 Condylostylus longicornis 2530218 Arthropoda Arthropoda 233 1.4099999999999998e-56   NTclustered gi|2496082430|ref|XM_055523037.1| 2530218 g3155 i0 81.533 5.51826484018265 287 49 65 2 154 438 863 579 PREDICTED: Condylostylus longicornis heat shock protein 83 (LOC129610445), mRNA blastn 2417 233 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
3601601 3601601 PRJNA1242190_S_NODE_283_length_744_cov_2.268256_g278_i0 PRJNA1242190 283 744 2.268256 16.87582464 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 260 3.49e-83   NR XP_012174989.1 30195 g278 i0 60.8 101.310483870968 212 80 85.5 1 1 636 60 268 XP_012174989.1 40S ribosomal protein S2 isoform X1 [Bombus terrestris] diamond 75375 261 0.996168582375479 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus terrestris
11829550 11829550 PRJNA1242190_S_NODE_7090_length_317_cov_2.323770_g7083_i0 PRJNA1242190 7090 317 2.32377 7.3663509 Cloeon dipterum 197152 Arthropoda Arthropoda 139 1.24e-39   NR XP_065346663.1 197152 g7083 i0 74.2 15.0851735015773 89 23 84.2 0 317 51 61 149 XP_065346663.1 nucleoside diphosphate kinase-like [Cloeon dipterum] diamond 4782 140 0.992857142857143 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Baetidae Cloeon Cloeon dipterum
12529581 12529581 PRJNA1242190_S_NODE_10430_length_268_cov_0.994872_g10423_i0 PRJNA1242190 10430 268 0.994872 2.66625696 Timema 61471 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|1947018316|emb|OC319311.1| 61476 g10423 i0 100 0.21641791044776101 29 0 11 0 239 267 53616 53644 3_Tce_b3v08 blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae
13104812 13104812 PRJNA1242190_S_NODE_5871_length_342_cov_4.152416_g5864_i0 PRJNA1242190 5871 342 4.152416 14.20126272 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.009   NTclustered gi|1963617327|emb|OC873114.1| 1979941 g5864 i0 100 0.0847953216374269 29 0 8 0 69 97 1638 1610 Medioppia subpectinata blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
16928119 16928119 PRJNA1242190_S_NODE_4514_length_382_cov_1.967638_g4507_i0 PRJNA1242190 4514 382 1.967638 7.51637716 Papilio polytes 76194 Arthropoda Arthropoda 682 0   NTclustered gi|389615034|dbj|AK405121.1| 76194 g4507 i0 99.202 4.98167539267016 376 3 98 0 1 376 428 803 Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis blastn 1903 682 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
18902637 18902637 PRJNA1242190_S_NODE_7335_length_313_cov_1.700000_g7328_i0 PRJNA1242190 7335 313 1.7 5.321 Drosophila 7215 Arthropoda Arthropoda 80.5 1.34e-10   NTclustered gi|2119965241|ref|XM_001959683.4| 7217 g7328 i0 100 5.40894568690096 43 0 14 0 271 313 582 540 PREDICTED: Drosophila ananassae 40S ribosomal protein S16 (LOC6494764), mRNA blastn 1693 80.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila ananassae
22027581 22027581 PRJNA1242190_S_NODE_11038_length_260_cov_3.149733_g11031_i0 PRJNA1242190 11038 260 3.149733 8.1893058 Longitarsus dorsalis 346795 Arthropoda Arthropoda 52.8 0.024   NTclustered gi|2918386046|emb|OZ238108.1| 346795 g11031 i0 100 0.107692307692308 28 0 11 0 56 83 7820377 7820350 Longitarsus dorsalis genome assembly, chromosome: X blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Longitarsus Longitarsus dorsalis
22027646 22027646 PRJNA1242190_S_NODE_3458_length_424_cov_13.529915_g3451_i0 PRJNA1242190 3458 424 13.529915 57.3668396 Timema monikensis 170555 Arthropoda Arthropoda 58.4 8.78e-4   NTclustered gi|1946411097|emb|OB793204.1| 170555 g3451 i0 97.059 0.212264150943396 34 1 8 0 52 85 168510 168543 3_Tms_b3v08 blastn 90 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema monikensis
22027704 22027704 PRJNA1242190_S_NODE_8658_length_291_cov_2.059633_g8651_i0 PRJNA1242190 8658 291 2.059633 5.99353203 Hermetia illucens 343691 Arthropoda Arthropoda 65.8 3.46e-6   NTclustered gi|1941210850|ref|XM_038065130.1| 343691 g8651 i0 93.182 0.450171821305842 44 3 15 0 3 46 454 497 PREDICTED: Hermetia illucens 60S ribosomal protein L23 (LOC119657937), mRNA blastn 131 65.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Stratiomyidae Hermetia Hermetia illucens
27471037 27471037 PRJNA1242190_S_NODE_2543_length_471_cov_4.035176_g2536_i0 PRJNA1242190 2543 471 4.035176 19.00567896 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 99 2.1799999999999999e-23   NR XP_054710691.1 327109 g2536 i0 45.2 2.60509554140127 135 58 86 1 18 422 5 123 XP_054710691.1 60S ribosomal protein L35-like [Uloborus diversus] diamond 1227 100 0.99 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Uloboridae Uloborus Uloborus diversus
27894734 27894734 PRJNA1242190_S_NODE_9645_length_277_cov_3.681373_g9638_i0 PRJNA1242190 9645 277 3.681373 10.19740321 Artemia franciscana 6661 Arthropoda Arthropoda 97.4 3.47e-21   NR KAK2725708.1 6661 g9638 i0 48.9 2.85920577617329 94 46 99.6 1 2 277 848 941 KAK2725708.1 hypothetical protein QYM36_000264 [Artemia franciscana] diamond 792 97.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28134076 28134076 PRJNA1242190_S_NODE_10605_length_266_cov_1.056995_g10598_i0 PRJNA1242190 10605 266 1.056995 2.8116067 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 103 6.19e-25   NR PSN44958.1 6973 g10598 i0 55.6 11.0864661654135 90 38 99.2 1 2 265 83 172 PSN44958.1 ADP/ATP translocase 1 [Blattella germanica] diamond 2949 104 0.990384615384615 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
28923165 28923165 PRJNA1242190_S_NODE_2728_length_460_cov_4.782946_g2721_i0 PRJNA1242190 2728 460 4.782946 22.0015516 Metazoa 33208 Arthropoda Arthropoda 108 5.33e-27   NR XP_059090465.1 6832 g2721 i0 47.1 2.39347826086957 121 58 78.9 2 446 84 24 138 XP_059090465.1 small ribosomal subunit protein eS12-like [Tigriopus californicus] diamond 1101 109 0.990825688073395 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
29649115 29649115 PRJNA1242190_S_NODE_2650_length_464_cov_4.455243_g2643_i0 PRJNA1242190 2650 464 4.455243 20.67232752 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 139 1.0099999999999999e-38   NR EFX61290.1 6669 g2643 i0 62.5 8.74784482758621 120 45 77.6 0 1 360 57 176 EFX61290.1 hypothetical protein DAPPUDRAFT_69961 [Daphnia pulex] diamond 4059 140 0.992857142857143 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
30263425 30263425 PRJNA1242190_S_NODE_12252_length_250_cov_1.661017_g12245_i0 PRJNA1242190 12252 250 1.661017 4.1525425 Papilio polytes 76194 Arthropoda Arthropoda 47.4 2.92e-4   NR BAM20515.1 76194 g12245 i0 100 0.24 20 0 24 0 1 60 115 134 BAM20515.1 ribosomal protein L10Ab [Papilio polytes] diamond 60 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
30313388 30313388 PRJNA1242190_S_NODE_14232_length_200_cov_5.472441_g14225_i0 PRJNA1242190 14232 200 5.472441 10.944882 Arthropoda 6656 Arthropoda Arthropoda 65.9 1.5e-10   NR XP_026472217.1 7515 g14225 i0 56.5 11.16 62 22 90 3 11 190 271 329 XP_026472217.1 chromodomain-helicase-DNA-binding protein 1 isoform X2 [Ctenocephalides felis] diamond 2232 66.2 0.995468277945619 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Siphonaptera Pulicidae Ctenocephalides Ctenocephalides felis
30484408 30484408 PRJNA1242190_S_NODE_2113_length_498_cov_4.929412_g2106_i0 PRJNA1242190 2113 498 4.929412 24.54847176 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 114 2.91e-28   NR ADD38186.1 72036 g2106 i0 42.7 0.789156626506024 131 75 78.9 0 498 106 59 189 ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] diamond 393 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
30502432 30502432 PRJNA1242190_S_NODE_10373_length_268_cov_2.230769_g10366_i0 PRJNA1242190 10373 268 2.230769 5.97846092 root 1 Root_unresolved Root_unresolved 70.1 5.95e-13   NR XP_063708594.1 469753 g10366 i0 37.5 4.89179104477612 88 50 98.5 1 4 267 16 98 XP_063708594.1 small ribosomal subunit protein eS12 [Culicoides brevitarsis] diamond 1311 70.5 0.994326241134752 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides brevitarsis
31748598 31748598 PRJNA1242190_S_NODE_2557_length_470_cov_3.987406_g2550_i0 PRJNA1242190 2557 470 3.987406 18.7408082 Idotea baltica 82763 Arthropoda Arthropoda 100 3.87e-24   NR MCL4168740.1 82763 g2550 i0 48.6 1.31489361702128 105 54 67 0 467 153 5 109 MCL4168740.1 hypothetical protein [Idotea baltica] diamond 618 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
32286897 32286897 PRJNA1242190_S_NODE_9799_length_275_cov_3.217822_g9792_i0 PRJNA1242190 9799 275 3.217822 8.8490105 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 54.3 2.88e-6   NR ADD38577.1 72036 g9792 i0 39.1 0.752727272727273 69 41 74.2 1 8 211 160 228 ADD38577.1 Glutathione S-transferase Mu 2 [Lepeophtheirus salmonis] diamond 207 54.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
32589528 32589528 PRJNA1242190_S_NODE_14059_length_228_cov_2.290323_g14052_i0 PRJNA1242190 14059 228 2.290323 5.22193644 Insecta 50557 Arthropoda Arthropoda 124 5.17e-31   NR XP_031352115.1 7054 g14052 i0 69.3 22.5263157894737 75 23 98.7 0 226 2 386 460 XP_031352115.1 probable protein phosphatase 2C 60 [Photinus pyralis] diamond 5136 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Photinus Photinus pyralis

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