RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

34 rows where bioproject = "PRJNA964500" 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

  • PRJNA964500 · 34 ✖

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
941798 941798 PRJNA964500_S_NODE_3441_length_286_cov_2.326848_g3349_i0 PRJNA964500 3441 286 2.326848 6.65478528 Loboquintus subsquamatus 1305852 Arthropoda Arthropoda 52.8 0.026   NTclustered gi|1282187787|gb|KY921992.1| 1305852 g3349 i0 100 0.0979020979020979 28 0 10 0 246 273 955 928 Loboquintus subsquamatus voucher UMMZ BMOC 15-0717-006 AD1918 28S ribosomal RNA gene, partial sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Phytoptidae Loboquintus Loboquintus subsquamatus
941825 941825 PRJNA964500_S_NODE_6841_length_218_cov_5.994709_g6749_i0 PRJNA964500 6841 218 5.994709 13.06846562 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.019   NTclustered gi|1964503389|emb|OE840646.1| 629358 g6749 i0 100 0.128440366972477 28 0 13 0 105 132 115171 115144 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
941830 941830 PRJNA964500_S_NODE_7421_length_211_cov_3.263736_g7329_i0 PRJNA964500 7421 211 3.263736 6.88648296 Cataglyphis hispanica 1086592 Arthropoda Arthropoda 52.8 0.019   NTclustered gi|2296762331|ref|XM_050605674.1| 1086592 g7329 i0 100 0.265402843601896 28 0 13 0 12 39 379 406 PREDICTED: Cataglyphis hispanica tyrosine-protein kinase transmembrane receptor Ror2 (LOC126856804), transcript variant X1, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Cataglyphis Cataglyphis hispanica
3492458 3492458 PRJNA964500_S_NODE_10983_length_180_cov_4.701987_g10891_i0 PRJNA964500 10983 180 4.701987 8.4635766 Medioppia subpectinata 1979941 Arthropoda Arthropoda 52.8 0.015   NTclustered gi|1964708817|emb|OC858617.1| 1979941 g10891 i0 100 0.155555555555556 28 0 16 0 93 120 5067 5040 Medioppia subpectinata blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
3817500 3817500 PRJNA964500_S_NODE_5363_length_240_cov_238.601896_g5271_i0 PRJNA964500 5363 240 238.601896 572.6445504 Eriophyidae 70320 Arthropoda Arthropoda 370 5.249999999999999e-98   NTclustered gi|673539918|gb|KJ841950.1| 1452679 g5271 i0 99.029 85.8666666666667 206 2 86 0 35 240 1194 1399 Heterotergum artemisiae 18S ribosomal RNA gene, complete sequence blastn 20608 370 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eriophyidae Heterotergum Heterotergum artemisiae
6045094 6045094 PRJNA964500_S_NODE_9165_length_194_cov_2.909091_g9073_i0 PRJNA964500 9165 194 2.909091 5.64363654 Aceria platanoidea 2883630 Arthropoda Arthropoda 279 7.06e-71   NTclustered gi|2119301953|gb|OK569898.1| 2883630 g9073 i0 94.054 19.9948453608247 185 10 95 1 10 194 2418 2601 Aceria platanoidea isolate 5230_5258_d239 large subunit ribosomal RNA gene, partial sequence blastn 3879 279 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eriophyidae Aceria Aceria platanoidea
6369588 6369588 PRJNA964500_S_NODE_2845_length_307_cov_4.550360_g2753_i0 PRJNA964500 2845 307 4.55036 13.9696052 Theridiidae 34643 Arthropoda Arthropoda 431 3.149999999999999e-116   NTclustered gi|1910768539|gb|MW045794.1| 2776011 g2753 i0 95.539 87.9511400651466 269 12 88 0 15 283 1262 994 Meotipa sp. The_758 large subunit ribosomal RNA gene, partial sequence blastn 27001 433 0.995381062355658 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Theridiidae Meotipa Meotipa sp. The_758
7319939 7319939 PRJNA964500_S_NODE_6346_length_225_cov_4.586735_g6254_i0 PRJNA964500 6346 225 4.586735 10.32015375 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1964668523|emb|OC856572.1| 1979941 g6254 i0 100 0.404444444444444 29 0 13 0 108 136 5783 5755 Medioppia subpectinata blastn 91 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
8594821 8594821 PRJNA964500_S_NODE_4407_length_259_cov_41964.939130_g4315_i0 PRJNA964500 4407 259 41964.93913 108689.1923467 Demodex folliculorum 481310 Arthropoda Arthropoda 375 1.2299999999999998e-99   NTclustered gi|360047396|gb|HQ728004.1| 481310 g4315 i0 100 39.046332046332 203 0 78 0 57 259 922 1124 Demodex folliculorum isolate 3-S6-Df2 28S ribosomal RNA gene, partial sequence blastn 10113 375 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Demodicidae Demodex Demodex folliculorum
9869979 9869979 PRJNA964500_S_NODE_1908_length_353_cov_29402.966049_g1816_i0 PRJNA964500 1908 353 29402.966049 103792.47015297 Anaspides tasmaniae 77687 Arthropoda Arthropoda 470 7.78e-128   NTclustered gi|16751927|gb|AF169720.2| 77687 g1816 i0 96.167 74.014164305949 287 11 81 0 1 287 634 348 Anaspides tasmaniae large subunit ribosomal RNA gene, partial sequence blastn 26127 470 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Anaspidacea Anaspididae Anaspides Anaspides tasmaniae
9870004 9870004 PRJNA964500_S_NODE_4328_length_261_cov_254.500000_g4236_i0 PRJNA964500 4328 261 254.5 664.245 Orthocladius sp. MAB-2008 560264 Arthropoda Arthropoda 261 3.63e-65   NTclustered gi|202070917|gb|FJ040556.1| 560264 g4236 i0 87.773 72.6513409961686 229 21 87 4 1 227 2492 2269 Orthocladius sp. MAB-2008 28S ribosomal RNA gene, partial sequence blastn 18962 261 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Orthocladius Orthocladius sp. MAB-2008
10194184 10194184 PRJNA964500_S_NODE_12768_length_170_cov_2.163121_g12676_i0 PRJNA964500 12768 170 2.163121 3.6773057 Diptera 7147 Arthropoda Arthropoda 315 1.64e-81   NTclustered gi|2087623291|ref|XR_006246843.1| 7222 g12676 i0 100 100 170 0 100 0 1 170 1631 1800 PREDICTED: Drosophila grimshawi small subunit ribosomal RNA (LOC122322777), rRNA blastn 17000 315 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila grimshawi
10194217 10194217 PRJNA964500_S_NODE_4948_length_248_cov_44020.931507_g4856_i0 PRJNA964500 4948 248 44020.931507 109171.91013736 Artemia 6660 Arthropoda Arthropoda 340 4.27e-89   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g4856 i0 100 78.633064516129 184 0 74 0 9 192 1635 1452 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 19501 340 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
11469332 11469332 PRJNA964500_S_NODE_3669_length_279_cov_4.556000_g3577_i0 PRJNA964500 3669 279 4.556 12.71124 Coleoptera 7041 Arthropoda Arthropoda 403 6.16e-108   NTclustered gi|2782661618|gb|PQ129718.1| 245108 g3577 i0 95.294 95.9426523297491 255 11 91 1 12 265 2286 2540 Limbodessus bigbellensis voucher R130 large subunit ribosomal RNA gene, partial sequence blastn 26768 403 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Dytiscidae Limbodessus Limbodessus bigbellensis
12420902 12420902 PRJNA964500_S_NODE_15750_length_156_cov_9.818898_g15658_i0 PRJNA964500 15750 156 9.818898 15.31748088 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|1964525302|emb|OC893647.1| 1979941 g15658 i0 96.875 0.205128205128205 32 1 21 0 97 128 909 940 Medioppia subpectinata blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
13695436 13695436 PRJNA964500_S_NODE_10431_length_184_cov_2.419355_g10339_i0 PRJNA964500 10431 184 2.419355 4.4516132 Gryllus bimaculatus 6999 Arthropoda Arthropoda 178 2.48e-40   NTclustered gi|153943193|dbj|AK284670.1| 6999 g10339 i0 86.667 295.836956521739 165 16 88 5 23 184 429 268 Gryllus bimaculatus mRNA, GBcontig31531 blastn 54434 178 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Gryllidae Gryllus Gryllus bimaculatus
14019267 14019267 PRJNA964500_S_NODE_17491_length_150_cov_4.950413_g17399_i0 PRJNA964500 17491 150 4.950413 7.4256195 Euwallacea 124011 Arthropoda Arthropoda 54.7 0.003   NTclustered gi|2753860062|ref|XM_066295923.1| 995702 g17399 i0 94.444 0.96 36 1 24 1 110 145 3298 3264 PREDICTED: Euwallacea fornicatus Mitochondrial assembly regulatory factor (Marf), transcript variant X1, mRNA blastn 144 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Euwallacea Euwallacea fornicatus
14019284 14019284 PRJNA964500_S_NODE_3571_length_282_cov_5.620553_g3479_i0 PRJNA964500 3571 282 5.620553 15.849959460000001 Chironomidae 7149 Arthropoda Arthropoda 440 4.7499999999999984e-119   NTclustered gi|2490581703|gb|OQ834327.1| 2675304 g3479 i0 97.308 91.8191489361702 260 6 92 1 22 280 3541 3800 Hydrobaenus distinctus isolate 44 HYD-GTS1D8-1 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 25893 440 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Hydrobaenus Hydrobaenus distinctus
16244626 16244626 PRJNA964500_S_NODE_10793_length_181_cov_11.065789_g10701_i0 PRJNA964500 10793 181 11.065789 20.02907809 Bombyx mori 7091 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|1493675518|gb|MK072709.1| 7091 g10701 i0 96.875 0.176795580110497 32 1 18 0 100 131 679 648 Bombyx mori isolate J-112 internal transcribed spacer 1, partial sequence blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
16244642 16244642 PRJNA964500_S_NODE_13273_length_167_cov_14.724638_g13181_i0 PRJNA964500 13273 167 14.724638 24.59014546 Limnephilus lunatus 1218281 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2752247092|tpg|BK062809.1| 1218281 g13181 i0 100 0.173652694610778 29 0 17 0 2 30 80208 80236 TPA_exp: Limnephilus lunatus Zonadhesin-like protein 3C (Zon3C) pseudogene, complete sequence; and zonadhesin-like protein 3B (Zon3B) gene, complete cds blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Trichoptera Limnephilidae Limnephilus Limnephilus lunatus
16244694 16244694 PRJNA964500_S_NODE_473_length_555_cov_30.384030_g409_i0 PRJNA964500 473 555 30.38403 168.6313665 Timema californicum 61474 Arthropoda Arthropoda 56.5 0.004   NTclustered gi|1965181363|emb|OE475415.1| 61474 g409 i0 90.909 0.0792792792792793 44 1 7 2 305 345 266 309 2_Tcm_b3v08 blastn 44 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
17519882 17519882 PRJNA964500_S_NODE_354_length_604_cov_4.707826_g301_i0 PRJNA964500 354 604 4.707826 28.43526904 Aceria thalgi 2837643 Arthropoda Arthropoda 582 1.7199999999999996e-161   NTclustered gi|2044619897|gb|MZ279727.1| 2837643 g301 i0 84.578 94.6076158940397 616 64 100 25 1 604 1012 416 Aceria thalgi small subunit ribosomal RNA gene, partial sequence blastn 57143 582 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eriophyidae Aceria Aceria thalgi
17519885 17519885 PRJNA964500_S_NODE_3814_length_275_cov_4.670732_g3722_i0 PRJNA964500 3814 275 4.670732 12.844513 Eriophyes sorbi 1670726 Arthropoda Arthropoda 228 3.9099999999999994e-55   NTclustered gi|2240866592|gb|ON555707.1| 1670726 g3722 i0 82.042 40.0072727272727 284 36 99 13 4 275 2983 2703 Eriophyes sorbi isolate MLW604 large subunit ribosomal RNA gene, partial sequence blastn 11002 228 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eriophyidae Eriophyes Eriophyes sorbi
17519898 17519898 PRJNA964500_S_NODE_6114_length_228_cov_347.477387_g6022_i0 PRJNA964500 6114 228 347.477387 792.24844236 Eosentomon megaglenum 533271 Arthropoda Arthropoda 329 8.38e-86   NTclustered gi|189171024|gb|EU557268.1| 533271 g6022 i0 97.423 88.5175438596491 194 4 85 1 35 228 2363 2555 Eosentomon megaglenum 28S ribosomal RNA gene, complete sequence blastn 20182 329 1 Eukaryota Opisthokonta Metazoa Arthropoda Protura   Eosentomidae Eosentomon Eosentomon megaglenum
19116885 19116885 PRJNA964500_S_NODE_4995_length_247_cov_52.426606_g4903_i0 PRJNA964500 4995 247 52.426606 129.49371682 Artemia 6660 Arthropoda Arthropoda 394 3.22e-105   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g4903 i0 100 21.0688259109312 213 0 86 0 26 238 2391 2179 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 5204 394 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
20068562 20068562 PRJNA964500_S_NODE_8436_length_200_cov_11.859649_g8344_i0 PRJNA964500 8436 200 11.859649 23.719298 Charissa obscurata 204503 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|2919604802|emb|OZ238384.1| 204503 g8344 i0 96.875 0.16 32 1 16 0 110 141 19659605 19659574 Charissa obscurata genome assembly, chromosome: 18 blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Charissa Charissa obscurata
21667766 21667766 PRJNA964500_S_NODE_11777_length_175_cov_6.431507_g11685_i0 PRJNA964500 11777 175 6.431507 11.25513725 Hemiptera 7524 Arthropoda Arthropoda 82.4 1.88e-11   NTclustered gi|741985872|gb|KJ461315.1| 280162 g11685 i0 96 10.5542857142857 50 2 29 0 6 55 2329 2280 Ochterus marginatus 28S ribosomal RNA gene, partial sequence blastn 1847 82.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Ochteridae Ochterus Ochterus marginatus
21667785 21667785 PRJNA964500_S_NODE_2877_length_305_cov_35602.315217_g2785_i0 PRJNA964500 2877 305 35602.315217 108587.06141185 Eriophyidae 70320 Arthropoda Arthropoda 316 9.129999999999999e-82   NTclustered gi|2044620515|gb|MZ279917.1| 2837689 g2785 i0 91.489 76.7639344262295 235 12 76 5 57 288 1778 2007 Tetra salixis voucher L17 small subunit ribosomal RNA gene, partial sequence blastn 23413 316 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eriophyidae Tetra Tetra salixis
22618927 22618927 PRJNA964500_S_NODE_2958_length_302_cov_5.578755_g2866_i0 PRJNA964500 2958 302 5.578755 16.8478401 Cydia splendana 1100963 Arthropoda Arthropoda 52.8 0.028   NTclustered gi|2695898591|ref|XM_063769561.1| 1100963 g2866 i0 100 0.0927152317880795 28 0 9 0 126 153 994 1021 PREDICTED: Cydia splendana uncharacterized LOC134797339 (LOC134797339), partial mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia splendana
22618965 22618965 PRJNA964500_S_NODE_858_length_465_cov_65.378440_g773_i0 PRJNA964500 858 465 65.37844 304.009746 Longitarsus dorsalis 346795 Arthropoda Arthropoda 52.8 0.045   NTclustered gi|2918386054|emb|OZ238097.1| 346795 g773 i0 96.774 0.0666666666666667 31 1 7 0 230 260 16006770 16006740 Longitarsus dorsalis genome assembly, chromosome: 4 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Longitarsus Longitarsus dorsalis
23894342 23894342 PRJNA964500_S_NODE_2879_length_305_cov_224.492754_g2787_i0 PRJNA964500 2879 305 224.492754 684.7028997 Epitrimerus libocedri 2837660 Arthropoda Arthropoda 265 3.3499999999999997e-66   NTclustered gi|2044620275|gb|MZ279801.1| 2837660 g2787 i0 84.397 90.5081967213115 282 30 89 12 35 305 1942 1664 Epitrimerus libocedri voucher FJ29 small subunit ribosomal RNA gene, partial sequence blastn 27605 265 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eriophyidae Epitrimerus Epitrimerus libocedri
24217129 24217129 PRJNA964500_S_NODE_5359_length_240_cov_327.004739_g5267_i0 PRJNA964500 5359 240 327.004739 784.8113736 root 1 Root_unresolved Root_unresolved 344 3.18e-90   NTclustered gi|2295022767|gb|OP365120.1| 6661 g5267 i0 98.958 79.875 192 2 80 0 35 226 1290 1481 Artemia franciscana isolate soni103 small subunit ribosomal RNA gene, partial sequence blastn 19170 344 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
24217154 24217154 PRJNA964500_S_NODE_959_length_447_cov_23594.014354_g870_i0 PRJNA964500 959 447 23594.014354 105465.24416238 Artemia 6660 Arthropoda Arthropoda 719 0   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g870 i0 99.745 83.7024608501119 392 1 88 0 53 444 1796 2187 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 37415 719 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
25491962 25491962 PRJNA964500_S_NODE_3160_length_294_cov_35453.177358_g3068_i0 PRJNA964500 3160 294 35453.177358 104232.34143252 Artemia 6660 Arthropoda Arthropoda 448 2.979999999999999e-121   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g3068 i0 100 153.520408163265 242 0 82 0 1 242 389 630 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 45135 448 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana

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