RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

34 rows where analysis = "blastn", bioproject = "PRJNA289590" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 34 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA289590 · 34 ✖

analysis 1

  • blastn · 34 ✖
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
1059432 1059432 PRJNA289590_P_NODE_23281_length_182_cov_1.533835_g23057_i0 PRJNA289590 23281 182 1.533835 2.7915797 root 1 Root_unresolved Root_unresolved 337 3.82e-88   NTclustered gi|76443734|gb|AC164954.3| 7176 g23057 i0 100 97.8846153846154 182 0 100 0 1 182 3181 3362 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940128D9, complete sequence blastn 17815 337 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
1647503 1647503 PRJNA289590_P_NODE_4382_length_485_cov_1.490826_g4162_i0 PRJNA289590 4382 485 1.490826 7.2305061 Scapholeberis mucronata 202097 Arthropoda Arthropoda 339 3.2399999999999997e-88   NTclustered gi|2488195007|emb|OC992536.1| 202097 g4162 i0 83.2 84.8618556701031 375 57 76 6 115 485 798 1170 Scapholeberis mucronata EOG090X03DA gene for EOG090X03DA blastn 41158 339 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Scapholeberis Scapholeberis mucronata
2922992 2922992 PRJNA289590_P_NODE_12943_length_253_cov_12.676471_g12719_i0 PRJNA289590 12943 253 12.676471 32.07147163 Charissa obscurata 204503 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2919570218|emb|OZ238379.1| 204503 g12719 i0 100 0.110671936758893 28 0 11 0 147 174 15215218 15215191 Charissa obscurata genome assembly, chromosome: 13 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Charissa Charissa obscurata
2923348 2923348 PRJNA289590_P_NODE_29043_length_165_cov_0.896552_g28819_i0 PRJNA289590 29043 165 0.896552 1.4793108 Eupeodes corollae 290404 Arthropoda Arthropoda 165 1.6999999999999998e-36   NTclustered gi|2503787527|ref|XM_056053365.1| 290404 g28819 i0 87.857 81.6727272727273 140 17 85 0 1 140 522 383 PREDICTED: Eupeodes corollae heat shock protein 83-like (LOC129944154), mRNA blastn 13476 165 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Syrphidae Eupeodes Eupeodes corollae
3609962 3609962 PRJNA289590_P_NODE_30483_length_163_cov_0.912281_g30259_i0 PRJNA289590 30483 163 0.912281 1.48701803 Artemia 6660 Arthropoda Arthropoda 296 5.68e-76   NTclustered gi|25251406|emb|AJ238061.1| 6661 g30259 i0 99.387 100.030674846626 163 1 100 0 1 163 692 854 Artemia franciscana 18S rRNA gene blastn 16305 296 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
4199461 4199461 PRJNA289590_P_NODE_13504_length_248_cov_1.040201_g13280_i0 PRJNA289590 13504 248 1.040201 2.57969848 Culex quinquefasciatus 7176 Arthropoda Arthropoda 453 5.2600000000000005e-123   NTclustered gi|76443734|gb|AC164954.3| 7176 g13280 i0 99.597 7 248 1 100 0 1 248 22376 22623 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940128D9, complete sequence blastn 1736 453 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
5475928 5475928 PRJNA289590_P_NODE_19945_length_200_cov_0.933775_g19721_i0 PRJNA289590 19945 200 0.933775 1.86755 Atrichopogon minutus 880166 Arthropoda Arthropoda 213 7.53e-51   NTclustered gi|308211018|gb|GU356726.1| 880166 g19721 i0 96.85 60.94 127 4 64 0 2 128 132 258 Atrichopogon minutus voucher CER02 18S ribosomal RNA gene, partial sequence blastn 12188 213 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Atrichopogon Atrichopogon minutus
6162282 6162282 PRJNA289590_P_NODE_8665_length_319_cov_1.592593_g8441_i0 PRJNA289590 8665 319 1.592593 5.08037167 root 1 Root_unresolved Root_unresolved 562 1.12e-155   NTclustered gi|76443734|gb|AC164954.3| 7176 g8441 i0 98.433 7.9153605015674 319 5 100 0 1 319 20086 20404 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940128D9, complete sequence blastn 2525 562 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
6750090 6750090 PRJNA289590_P_NODE_15226_length_231_cov_1.956044_g15002_i0 PRJNA289590 15226 231 1.956044 4.51846164 Papilio polytes 76194 Arthropoda Arthropoda 427 2.9399999999999998e-115   NTclustered gi|389615034|dbj|AK405121.1| 76194 g15002 i0 100 3.48484848484848 231 0 100 0 1 231 582 352 Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis blastn 805 427 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
6750179 6750179 PRJNA289590_P_NODE_18546_length_208_cov_1.201258_g18322_i0 PRJNA289590 18546 208 1.201258 2.49861664 Hyalella azteca 294128 Arthropoda Arthropoda 385 1.58e-102   NTclustered gi|2232419545|ref|XR_007157289.1| 294128 g18322 i0 100 70.8461538461538 208 0 100 0 1 208 3078 2871 PREDICTED: Hyalella azteca large subunit ribosomal RNA (LOC125179508), rRNA blastn 14736 385 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Hyalellidae Hyalella Hyalella azteca
6750316 6750316 PRJNA289590_P_NODE_25926_length_169_cov_0.866667_g25702_i0 PRJNA289590 25926 169 0.866667 1.46466723 Oppiella nova 334625 Arthropoda Arthropoda 307 2.73e-79   NTclustered gi|1964807332|emb|OC914829.1| 334625 g25702 i0 99.408 2 169 1 100 0 1 169 147813 147981 Oppiella nova blastn 338 307 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
8025725 8025725 PRJNA289590_P_NODE_17787_length_213_cov_1.140244_g17563_i0 PRJNA289590 17787 213 1.140244 2.42871972 Culex quinquefasciatus 7176 Arthropoda Arthropoda 394 2.7e-105   NTclustered gi|76443734|gb|AC164954.3| 7176 g17563 i0 100 90.5117370892019 213 0 100 0 1 213 9175 9387 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940128D9, complete sequence blastn 19279 394 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
9987591 9987591 PRJNA289590_P_NODE_4088_length_505_cov_3.228070_g3869_i0 PRJNA289590 4088 505 3.22807 16.3017535 root 1 Root_unresolved Root_unresolved 219 4.6e-52   NTclustered gi|78097480|gb|AC167666.4| 7176 g3869 i0 85.377 0.853465346534653 212 30 42 1 292 503 111946 111736 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940120D9, complete sequence blastn 431 220 0.995454545454545 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
11262564 11262564 PRJNA289590_P_NODE_18229_length_210_cov_1.254658_g18005_i0 PRJNA289590 18229 210 1.254658 2.6347818 root 1 Root_unresolved Root_unresolved 374 3.4599999999999995e-99   NTclustered gi|76443734|gb|AC164954.3| 7176 g18005 i0 99.038 7.90476190476191 208 2 99 0 1 208 51800 52007 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940128D9, complete sequence blastn 1660 374 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
11262576 11262576 PRJNA289590_P_NODE_21669_length_190_cov_1.439716_g21445_i0 PRJNA289590 21669 190 1.439716 2.7354604 root 1 Root_unresolved Root_unresolved 335 1.4499999999999993e-87   NTclustered gi|76443734|gb|AC164954.3| 7176 g21445 i0 98.93 6.90526315789474 187 2 98 0 1 187 16967 17153 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940128D9, complete sequence blastn 1312 335 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
11851090 11851090 PRJNA289590_P_NODE_18290_length_209_cov_2.937500_g18066_i0 PRJNA289590 18290 209 2.9375 6.139375 Ochlerotatus camptorhynchus 644619 Arthropoda Arthropoda 113 8.290000000000001e-21   NTclustered gi|2730521630|ref|XM_065237886.1| 644619 g18066 i0 90.588 23.9473684210526 85 8 41 0 123 207 435 351 PREDICTED: Ochlerotatus camptorhynchus ribosomal protein L12 (RpL12), mRNA blastn 5005 113 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Ochlerotatus Ochlerotatus camptorhynchus
11851280 11851280 PRJNA289590_P_NODE_26550_length_168_cov_1.310924_g26326_i0 PRJNA289590 26550 168 1.310924 2.20235232 Chironomidae sp. Cy2020 sp1 2766959 Arthropoda Arthropoda 100 4.97e-17   NTclustered gi|1896444337|gb|MT921238.1| 2766959 g26326 i0 96.667 7.75 60 2 36 0 109 168 3041 3100 Chironomidae sp. Cy2020 sp1 voucher Chironomidae_Cy2020_sp1 large subunit ribosomal RNA gene, partial sequence blastn 1302 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae   Chironomidae sp. Cy2020 sp1
13126297 13126297 PRJNA289590_P_NODE_19111_length_204_cov_2.348387_g18887_i0 PRJNA289590 19111 204 2.348387 4.79070948 Sipha flava 143950 Arthropoda Arthropoda 52.8 0.018   NTclustered gi|1418903997|ref|XM_025554749.1| 143950 g18887 i0 100 0.137254901960784 28 0 14 0 137 164 680 653 PREDICTED: Sipha flava uncharacterized LOC112683635 (LOC112683635), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Sipha Sipha flava
14401570 14401570 PRJNA289590_P_NODE_25532_length_170_cov_2.975207_g25308_i0 PRJNA289590 25532 170 2.975207 5.0578519 Satyrium ilicis 876074 Arthropoda Arthropoda 58.4 3.06e-4   NTclustered gi|2918386101|emb|OZ238115.1| 876074 g25308 i0 90.698 0.252941176470588 43 4 25 0 73 115 56559237 56559195 Satyrium ilicis genome assembly, chromosome: 6 blastn 43 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
15086946 15086946 PRJNA289590_P_NODE_10132_length_290_cov_2.286307_g9908_i0 PRJNA289590 10132 290 2.286307 6.6302903 root 1 Root_unresolved Root_unresolved 529 1.0199999999999996e-145   NTclustered gi|76443734|gb|AC164954.3| 7176 g9908 i0 99.654 7.70344827586207 289 1 99 0 2 290 7696 7984 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940128D9, complete sequence blastn 2234 534 0.99063670411985 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
15087034 15087034 PRJNA289590_P_NODE_29172_length_165_cov_0.896552_g28948_i0 PRJNA289590 29172 165 0.896552 1.4793108 root 1 Root_unresolved Root_unresolved 248 1.64e-61   NTclustered gi|76443734|gb|AC164954.3| 7176 g28948 i0 98.582 48.8909090909091 141 1 100 1 1 140 103671 103811 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940128D9, complete sequence blastn 8067 248 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
15675050 15675050 PRJNA289590_P_NODE_12173_length_262_cov_1.934272_g11949_i0 PRJNA289590 12173 262 1.934272 5.06779264 Chironomus tentans 7153 Arthropoda Arthropoda 438 1.5699999999999999e-118   NTclustered gi|1834412|emb|X99212.1| 7153 g11949 i0 96.947 98.763358778626 262 6 100 2 1 262 7222 6963 Chironomus tentans partial 18S rRNA gene, 5.8S rRNA gene, partial 28S rRNA gene, internal transcribed spacers 1 and 2 and intergenic spacer blastn 25876 438 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tentans
18223937 18223937 PRJNA289590_P_NODE_11195_length_274_cov_5.040000_g10971_i0 PRJNA289590 11195 274 5.04 13.8096 Culex quinquefasciatus 7176 Arthropoda Arthropoda 326 1.34e-84   NTclustered gi|78097480|gb|AC167666.4| 7176 g10971 i0 88.235 2.99270072992701 272 32 99 0 3 274 109277 109548 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940120D9, complete sequence blastn 820 326 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
18224370 18224370 PRJNA289590_P_NODE_31335_length_162_cov_0.920354_g31111_i0 PRJNA289590 31335 162 0.920354 1.49097348 Frankliniella occidentalis 133901 Arthropoda Arthropoda 294 2.03e-75   NTclustered gi|2347689893|ref|XM_026433998.2| 133901 g31111 i0 99.383 3.48148148148148 162 1 100 0 1 162 185 24 PREDICTED: Frankliniella occidentalis heat shock 70 kDa protein II-like (LOC113214575), mRNA blastn 564 294 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Frankliniella Frankliniella occidentalis
18910779 18910779 PRJNA289590_P_NODE_10555_length_284_cov_1.285106_g10331_i0 PRJNA289590 10555 284 1.285106 3.64970104 root 1 Root_unresolved Root_unresolved 503 6.02e-138   NTclustered gi|76443734|gb|AC164954.3| 7176 g10331 i0 98.592 7.09859154929577 284 4 100 0 1 284 18428 18145 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940128D9, complete sequence blastn 2016 503 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
18910928 18910928 PRJNA289590_P_NODE_9235_length_307_cov_1.538760_g9011_i0 PRJNA289590 9235 307 1.53876 4.7239932 Chironomus 7150 Arthropoda Arthropoda 385 2.49e-102   NTclustered gi|1834409|emb|X99546.1| 7151 g9011 i0 89.577 71.9381107491857 307 27 99 3 2 307 520 218 Chironomus pallidivittatus partial 28S rRNA gene, intergenic spacer and partial 18S rRNA gene blastn 22085 385 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus pallidivittatus
19498569 19498569 PRJNA289590_P_NODE_28316_length_166_cov_0.888889_g28092_i0 PRJNA289590 28316 166 0.888889 1.47555574 Hyalella azteca 294128 Arthropoda Arthropoda 298 1.62e-76   NTclustered gi|2232419545|ref|XR_007157289.1| 294128 g28092 i0 98.81 20.5963855421687 168 0 100 1 1 166 2285 2452 PREDICTED: Hyalella azteca large subunit ribosomal RNA (LOC125179508), rRNA blastn 3419 298 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Hyalellidae Hyalella Hyalella azteca
20773996 20773996 PRJNA289590_P_NODE_20517_length_196_cov_1.768707_g20293_i0 PRJNA289590 20517 196 1.768707 3.46666572 Culex quinquefasciatus 7176 Arthropoda Arthropoda 363 6.899999999999998e-96   NTclustered gi|76443734|gb|AC164954.3| 7176 g20293 i0 100 7 196 0 100 0 1 196 7271 7076 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940128D9, complete sequence blastn 1372 363 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
22049055 22049055 PRJNA289590_P_NODE_26398_length_168_cov_6.731092_g26174_i0 PRJNA289590 26398 168 6.731092 11.30823456 Culex quinquefasciatus 7176 Arthropoda Arthropoda 233 4.7e-57   NTclustered gi|78097480|gb|AC167666.4| 7176 g26174 i0 91.667 5.97619047619048 168 14 100 0 1 168 110145 109978 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940120D9, complete sequence blastn 1004 233 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
23324561 23324561 PRJNA289590_P_NODE_21659_length_190_cov_1.453901_g21435_i0 PRJNA289590 21659 190 1.453901 2.7624119 Frankliniella occidentalis 133901 Arthropoda Arthropoda 141 3.39e-29   NTclustered gi|2347647438|ref|XM_052264766.1| 133901 g21435 i0 97.59 0.436842105263158 83 1 43 1 9 90 1987 2069 PREDICTED: Frankliniella occidentalis uncharacterized LOC113204126 (LOC113204126), mRNA blastn 83 141 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Frankliniella Frankliniella occidentalis
23324711 23324711 PRJNA289590_P_NODE_29639_length_164_cov_0.904348_g29415_i0 PRJNA289590 29639 164 0.904348 1.48313072 Hyalella azteca 294128 Arthropoda Arthropoda 298 1.59e-76   NTclustered gi|2232419545|ref|XR_007157289.1| 294128 g29415 i0 99.39 80.7073170731707 164 1 100 0 1 164 241 78 PREDICTED: Hyalella azteca large subunit ribosomal RNA (LOC125179508), rRNA blastn 13236 298 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Hyalellidae Hyalella Hyalella azteca
24011368 24011368 PRJNA289590_P_NODE_5539_length_417_cov_1.317935_g5315_i0 PRJNA289590 5539 417 1.317935 5.49578895 root 1 Root_unresolved Root_unresolved 737 0   NTclustered gi|76443734|gb|AC164954.3| 7176 g5315 i0 98.561 10.9568345323741 417 6 100 0 1 417 21733 22149 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940128D9, complete sequence blastn 4569 743 0.991924629878869 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
24598392 24598392 PRJNA289590_P_NODE_10860_length_279_cov_1.886957_g10636_i0 PRJNA289590 10860 279 1.886957 5.26461003 Macrosteles quadrilineatus 74068 Arthropoda Arthropoda 226 1.43e-54   NTclustered gi|2463278192|ref|XM_054430194.1| 74068 g10636 i0 84.188 178.781362007168 234 35 84 2 44 276 2182 2414 PREDICTED: Macrosteles quadrilineatus polyubiquitin-C-like (LOC129002413), transcript variant X1, mRNA blastn 49880 226 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
25285557 25285557 PRJNA289590_P_NODE_6860_length_366_cov_1.280757_g6636_i0 PRJNA289590 6860 366 1.280757 4.68757062 Chironomidae 7149 Arthropoda Arthropoda 601 2.7499999999999998e-167   NTclustered gi|308211027|gb|GU356735.1| 880170 g6636 i0 96.216 101.554644808743 370 9 100 5 1 366 490 122 Polypedilum prasiogaster voucher V403 18S ribosomal RNA gene, partial sequence blastn 37169 601 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum prasiogaster

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