RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA193544" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 22 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA193544 · 22 ✖

analysis 1

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
1640685 1640685 PRJNA193544_S_NODE_3382_length_152_cov_120.756098_g3367_i0 PRJNA193544 3382 152 120.756098 183.54926896 Euderopus sp. G0098 2571570 Arthropoda Arthropoda 75 2.65e-9   NTclustered gi|1628772686|gb|MH984177.1| 2571570 g3367 i0 85.526 34.2697368421053 76 5 47 5 1 72 4 77 Euderopus sp. G0098 28S large subunit ribosomal RNA gene, partial sequence blastn 5209 75 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Biphyllidae Euderopus Euderopus sp. G0098
4883210 4883210 PRJNA193544_S_NODE_2104_length_187_cov_22895.537975_g2089_i0 PRJNA193544 2104 187 22895.537975 42814.65601325 Speleorchestes 386823 Arthropoda Arthropoda 117 5.600000000000001e-22   NTclustered gi|1282187772|gb|KY921977.1| 2051766 g2089 i0 88.66 51.5828877005348 97 9 52 2 35 131 1297 1203 Speleorchestes sp. AD937 voucher UMMZ BMOC 07-0814-002 AD937 28S ribosomal RNA gene, partial sequence blastn 9646 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Nanorchestidae Speleorchestes Speleorchestes sp. AD937
6157949 6157949 PRJNA193544_S_NODE_1265_length_226_cov_18049.406091_g1250_i0 PRJNA193544 1265 226 18049.406091 40791.65776566 Artemia 6660 Arthropoda Arthropoda 357 3.81e-94   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g1250 i0 100 90.1150442477876 193 0 85 0 34 226 1634 1442 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 20366 357 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
6743562 6743562 PRJNA193544_S_NODE_2066_length_189_cov_8.181250_g2051_i0 PRJNA193544 2066 189 8.18125 15.4625625 Neocloeon triangulifer 2078957 Arthropoda Arthropoda 141 3.3600000000000003e-29   NTclustered gi|2579119154|ref|XR_009441551.1| 2078957 g2051 i0 84.211 100.724867724868 152 16 78 8 1 147 1 149 PREDICTED: Neocloeon triangulifer U2 spliceosomal RNA (LOC132194522), ncRNA blastn 19037 141 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Baetidae Neocloeon Neocloeon triangulifer
8707959 8707959 PRJNA193544_S_NODE_1287_length_225_cov_426.469388_g1272_i0 PRJNA193544 1287 225 426.469388 959.556123 root 1 Root_unresolved Root_unresolved 416 6.159999999999998e-112   NTclustered gi|294661761|dbj|AB526262.1| 6669 g1272 i0 100 182.422222222222 225 0 100 0 1 225 998 774 Daphnia pulex ncRNA, kairomone-inducible transcript blastn 41045 416 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
9983303 9983303 PRJNA193544_S_NODE_848_length_266_cov_26.877637_g833_i0 PRJNA193544 848 266 26.877637 71.49451442 Chironomidae 7149 Arthropoda Arthropoda 477 3.3899999999999992e-130   NTclustered gi|2490581711|gb|OQ834335.1| 984904 g833 i0 99.617 98.1390977443609 261 1 98 0 1 261 1604 1864 Diamesa bohemani isolate EAM125 large subunit ribosomal RNA gene, partial sequence blastn 26105 477 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Diamesa Diamesa bohemani
10569956 10569956 PRJNA193544_S_NODE_1729_length_202_cov_894.901734_g1714_i0 PRJNA193544 1729 202 894.901734 1807.70150268 Corynoneura carriana 1278985 Arthropoda Arthropoda 272 1.24e-68   NTclustered gi|2490581767|gb|OQ834389.1| 2575444 g1714 i0 96.386 82.1831683168317 166 5 82 1 37 202 3170 3006 Corynoneura carriana kadalinka isolate COR-GUS4E8-8 510 large subunit ribosomal RNA gene, partial sequence blastn 16601 272 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Corynoneura Corynoneura carriana
11258437 11258437 PRJNA193544_S_NODE_1109_length_242_cov_12.948357_g1094_i0 PRJNA193544 1109 242 12.948357 31.33502394 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 97.1 9.93e-16   NTclustered gi|874529426|gb|KP271699.1| 1671746 g1094 i0 83.486 35.1570247933884 109 12 44 5 112 217 1048 943 Mimetus sp. GH1409 18S ribosomal RNA gene, partial sequence blastn 8508 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Mimetidae Mimetus Mimetus sp. GH1409
11258441 11258441 PRJNA193544_S_NODE_1269_length_226_cov_281.791878_g1254_i0 PRJNA193544 1269 226 281.791878 636.84964428 Artemia 6660 Arthropoda Arthropoda 366 6.32e-97   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g1254 i0 99.505 86.1017699115044 202 0 89 1 25 226 2188 1988 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 19459 366 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
13119664 13119664 PRJNA193544_S_NODE_1951_length_193_cov_22591.823171_g1936_i0 PRJNA193544 1951 193 22591.823171 43602.21872003 Orthocladius sp. 3002598 Arthropoda Arthropoda 298 1.94e-76   NTclustered gi|2486656231|gb|OQ819019.1| 3002598 g1936 i0 100 83.4093264248705 161 0 83 0 1 161 3102 3262 Orthocladius sp. isolate EAM591 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 16098 298 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Orthocladius Orthocladius sp.
13119691 13119691 PRJNA193544_S_NODE_351_length_347_cov_6.166667_g336_i0 PRJNA193544 351 347 6.166667 21.39833449 Porcellio scaber 64697 Arthropoda Arthropoda 130 1.48e-25   NTclustered gi|58610257|gb|AY744901.1| 64697 g336 i0 82.468 40.9452449567723 154 21 44 5 149 301 257 405 Porcellio scaber 28S ribosomal RNA gene, partial sequence blastn 14208 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Porcellionidae Porcellio Porcellio scaber
13808642 13808642 PRJNA193544_S_NODE_1711_length_203_cov_12.844828_g1696_i0 PRJNA193544 1711 203 12.844828 26.07500084 Artemia 6660 Arthropoda Arthropoda 372 1.2e-98   NTclustered gi|25251406|emb|AJ238061.1| 6661 g1696 i0 100 96.7536945812808 201 0 99 0 3 203 901 701 Artemia franciscana 18S rRNA gene blastn 19641 372 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
14394991 14394991 PRJNA193544_S_NODE_3192_length_156_cov_6.795276_g3177_i0 PRJNA193544 3192 156 6.795276 10.60063056 Hydrometra stagnorum 446445 Arthropoda Arthropoda 268 1.1699999999999997e-67   NTclustered gi|1131051030|gb|KX821841.1| 446445 g3177 i0 100 0.92948717948718 145 0 93 0 12 156 1433 1289 Hydrometra stagnorum 28S ribosomal RNA gene, partial sequence blastn 145 268 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Hydrometridae Hydrometra Hydrometra stagnorum
15082772 15082772 PRJNA193544_S_NODE_1752_length_201_cov_22242.319767_g1737_i0 PRJNA193544 1752 201 22242.319767 44707.06273167 Artemia 6660 Arthropoda Arthropoda 313 7.2599999999999985e-81   NTclustered gi|27461892|gb|AY137143.1| 6661 g1737 i0 100 5.40298507462687 169 0 84 0 33 201 521 353 Artemia franciscana 28S ribosomal RNA gene, partial sequence blastn 1086 313 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
15082791 15082791 PRJNA193544_S_NODE_792_length_273_cov_15044.315574_g777_i0 PRJNA193544 792 273 15044.315574 41070.98151702 Artemia 6660 Arthropoda Arthropoda 444 3.54e-120   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g777 i0 100 33.025641025641 240 0 88 0 34 273 329 90 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 9016 444 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
16943188 16943188 PRJNA193544_S_NODE_714_length_284_cov_15017.619608_g699_i0 PRJNA193544 714 284 15017.619608 42650.03968672 Baetis sp. Eph11 240915 Arthropoda Arthropoda 337 6.46e-88   NTclustered gi|34223577|gb|AY338695.1| 240915 g699 i0 90.909 84.1232394366197 253 19 88 4 1 251 35 285 Baetis sp. Eph11 18S ribosomal RNA gene, partial sequence blastn 23891 337 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Baetidae Baetis Baetis sp. Eph11
17632857 17632857 PRJNA193544_S_NODE_1474_length_214_cov_21265.697297_g1459_i0 PRJNA193544 1474 214 21265.697297 45508.59221558 Artemia 6660 Arthropoda Arthropoda 337 4.65e-88   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g1459 i0 100 3.4018691588785 182 0 85 0 33 214 688 507 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 728 337 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
19491883 19491883 PRJNA193544_S_NODE_2196_length_184_cov_3.290323_g2181_i0 PRJNA193544 2196 184 3.290323 6.05419432 Meloimorpha japonica 1109092 Arthropoda Arthropoda 104 4.27e-18   NTclustered gi|807014074|gb|KM853384.1| 1109092 g2181 i0 87.778 10.195652173913 90 10 49 1 4 93 1428 1340 Meloimorpha japonica 28S ribosomal RNA gene, partial sequence blastn 1876 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Phalangopsidae Meloimorpha Meloimorpha japonica
23318032 23318032 PRJNA193544_S_NODE_899_length_260_cov_356.943723_g884_i0 PRJNA193544 899 260 356.943723 928.0536798 Daphnia pulex 6669 Arthropoda Arthropoda 481 2.55e-131   NTclustered gi|294661761|dbj|AB526262.1| 6669 g884 i0 100 249.319230769231 260 0 100 0 1 260 171 430 Daphnia pulex ncRNA, kairomone-inducible transcript blastn 64823 481 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
24007233 24007233 PRJNA193544_S_NODE_779_length_275_cov_119.467480_g764_i0 PRJNA193544 779 275 119.46748 328.53557 Baculigerus 864009 Arthropoda Arthropoda 124 5.28e-24   NTclustered gi|375151043|gb|JF786573.1| 1006688 g764 i0 89.691 3.75636363636364 97 10 35 0 27 123 2411 2315 Baculigerus sp. DNA104054_3 voucher MCZ DNA104054_3 28S ribosomal RNA genes, partial sequence blastn 1033 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Opiliones Escadabiidae Baculigerus Baculigerus sp. DNA104054_3
24592151 24592151 PRJNA193544_S_NODE_480_length_319_cov_2258.403448_g465_i0 PRJNA193544 480 319 2258.403448 7204.30699912 Blackburnia fracta 155351 Arthropoda Arthropoda 178 4.73e-40   NTclustered gi|13487191|gb|AF337346.1|AF337346 155351 g465 i0 91.473 38.7617554858934 129 11 40 0 70 198 40 168 Blackburnia fracta 28S ribosomal RNA gene, partial sequence blastn 12365 178 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Carabidae Blackburnia Blackburnia fracta
25281334 25281334 PRJNA193544_S_NODE_700_length_286_cov_10.291829_g685_i0 PRJNA193544 700 286 10.291829 29.43463094 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 97.1 1.2e-15   NTclustered gi|874529426|gb|KP271699.1| 1671746 g685 i0 83.486 29.7482517482517 109 12 37 5 156 261 1048 943 Mimetus sp. GH1409 18S ribosomal RNA gene, partial sequence blastn 8508 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Mimetidae Mimetus Mimetus sp. GH1409

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