RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "blastn", bioproject = "PRJNA1113956" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 23 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1113956 · 23 ✖

analysis 1

  • blastn · 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
221905 221905 PRJNA1113956_P_NODE_20681_length_248_cov_0.880000_g20341_i0 PRJNA1113956 20681 248 0.88 2.1824 Harpegnathos saltator 610380 Arthropoda Arthropoda 313 9.32e-81   NTclustered gi|1409275171|ref|XM_025304082.1| 610380 g20341 i0 89.057 6.17741935483871 265 11 100 5 1 248 1322 1059 PREDICTED: Harpegnathos saltator piggyBac transposable element-derived protein 4-like (LOC112589706), mRNA blastn 1532 313 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Harpegnathos Harpegnathos saltator
221974 221974 PRJNA1113956_P_NODE_9201_length_473_cov_1.432500_g8862_i0 PRJNA1113956 9201 473 1.4325 6.775725 Helicoverpa assulta 52344 Arthropoda Arthropoda 52.8 0.046   NTclustered gi|2636206759|emb|OY979785.1| 52344 g8862 i0 100 0.0591966173361522 28 0 6 0 425 452 7068178 7068205 Helicoverpa assulta genome assembly, chromosome: 11 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa assulta
1023937 1023937 PRJNA1113956_P_NODE_7421_length_562_cov_2.390593_g7089_i0 PRJNA1113956 7421 562 2.390593 13.43513266 Metazoa 33208 Arthropoda Arthropoda 54.7 0.015   NTclustered gi|909561676|ref|XM_013280524.1| 76194 g7089 i0 94.286 0.311387900355872 35 2 6 0 528 562 269 303 PREDICTED: Papilio polytes sex-determining region Y protein-like (LOC106101342), mRNA blastn 175 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
4048833 4048833 PRJNA1113956_P_NODE_1564_length_1472_cov_7.476054_g1437_i0 PRJNA1113956 1564 1472 7.476054 110.04751488 Pachythone xanthe 2847632 Arthropoda Arthropoda 204 3.9399999999999996e-47   NTclustered gi|2568337708|gb|OK961082.1| 2847632 g1437 i0 75.51 2.63586956521739 441 94 29 12 350 783 163 596 Pachythone xanthe voucher UNCP:GD-18-R016 vacuolar protein sorting 4 gene, partial cds blastn 3880 204 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Riodinidae Pachythone Pachythone xanthe
5324923 5324923 PRJNA1113956_P_NODE_21885_length_244_cov_0.900585_g21545_i0 PRJNA1113956 21885 244 0.900585 2.1974274 Daktulosphaira vitifoliae 58002 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|2304402411|ref|XM_050681593.1| 58002 g21545 i0 100 0.237704918032787 29 0 12 0 5 33 2524 2496 PREDICTED: Daktulosphaira vitifoliae E3 ubiquitin-protein ligase AMFR-like (LOC126903455), transcript variant X2, mRNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phylloxeridae Daktulosphaira Daktulosphaira vitifoliae
5324950 5324950 PRJNA1113956_P_NODE_5105_length_755_cov_103.630499_g4801_i0 PRJNA1113956 5105 755 103.630499 782.41026745 Daktulosphaira vitifoliae 58002 Arthropoda Arthropoda 518 6.21e-142   NTclustered gi|2304377699|ref|XM_050668748.1| 58002 g4801 i0 82.19 228.733774834437 612 99 80 8 32 638 252 858 PREDICTED: Daktulosphaira vitifoliae polyubiquitin-B-like (LOC126896185), mRNA blastn 172694 518 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phylloxeridae Daktulosphaira Daktulosphaira vitifoliae
6126852 6126852 PRJNA1113956_P_NODE_4465_length_825_cov_2.742021_g4179_i0 PRJNA1113956 4465 825 2.742021 22.62167325 Timema 61471 Arthropoda Arthropoda 54.7 0.023   NTclustered gi|1962660608|emb|OE179527.1| 61474 g4179 i0 100 0.0703030303030303 29 0 4 0 236 264 45566 45538 2_Tcm_b3v08 blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
7874866 7874866 PRJNA1113956_P_NODE_22287_length_242_cov_2.662722_g21947_i0 PRJNA1113956 22287 242 2.662722 6.44378724 Macrobrachium rosenbergii 79674 Arthropoda Arthropoda 154 5.81e-33   NTclustered gi|2782907570|ref|XM_067090927.1| 79674 g21947 i0 79.904 1.57438016528926 209 42 86 0 7 215 3030 2822 PREDICTED: Macrobrachium rosenbergii pre-mRNA processing factor 8 (Prp8), mRNA blastn 381 154 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium rosenbergii
9149658 9149658 PRJNA1113956_P_NODE_1728_length_1408_cov_2.341573_g1585_i0 PRJNA1113956 1728 1408 2.341573 32.96934784 Satyrium ilicis 876074 Arthropoda Arthropoda 56.5 0.011   NTclustered gi|2918386049|emb|OZ238112.1| 876074 g1585 i0 96.97 0.0234375 33 1 2 0 466 498 55684372 55684404 Satyrium ilicis genome assembly, chromosome: 3 blastn 33 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
9149668 9149668 PRJNA1113956_P_NODE_1828_length_1369_cov_18.836420_g128_i2 PRJNA1113956 1828 1369 18.83642 257.8705898 Stegodyphus dumicola 202533 Arthropoda Arthropoda 316 4.5e-81   NTclustered gi|1866191206|ref|XM_035372278.1| 202533 g128 i2 92 5.19722425127831 225 18 16 0 1 225 390 166 PREDICTED: Stegodyphus dumicola uncharacterized LOC118200321 (LOC118200321), partial mRNA blastn 7115 316 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus dumicola
11700613 11700613 PRJNA1113956_P_NODE_10770_length_415_cov_3.298246_g10431_i0 PRJNA1113956 10770 415 3.298246 13.6877209 Drymonia dodonaea 988176 Arthropoda Arthropoda 54.7 0.011   NTclustered gi|2918369734|emb|OZ237800.1| 988176 g10431 i0 87.755 0.118072289156627 49 2 11 4 334 380 10958829 10958875 Drymonia dodonaea genome assembly, chromosome: 7 blastn 49 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Notodontidae Drymonia Drymonia dodonaea
12502672 12502672 PRJNA1113956_P_NODE_18990_length_260_cov_1.085561_g18650_i0 PRJNA1113956 18990 260 1.085561 2.8224586 root 1 Root_unresolved Root_unresolved 420 5.64e-113   NTclustered gi|83281396|gb|AC167967.6| 7176 g18650 i0 95.769 167.830769230769 260 11 100 0 1 260 1285 1544 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940144D9, complete sequence blastn 43636 420 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
14250978 14250978 PRJNA1113956_P_NODE_4112_length_872_cov_118.748436_g3835_i0 PRJNA1113956 4112 872 118.748436 1035.48636192 Calliphora vicina 7373 Arthropoda Arthropoda 640 1.4799999999999997e-178   NTclustered gi|2736832851|ref|XM_065506771.1| 7373 g3835 i0 80.565 290.762614678899 849 149 99 16 1 841 2949 2109 PREDICTED: Calliphora vicina polyubiquitin-C (LOC135956319), mRNA blastn 253545 640 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Calliphora Calliphora vicina
16799037 16799037 PRJNA1113956_P_NODE_14934_length_318_cov_4.661224_g14594_i0 PRJNA1113956 14934 318 4.661224 14.82269232 Coccinella septempunctata 41139 Arthropoda Arthropoda 126 1.73e-24   NTclustered gi|2125251188|ref|XM_044892703.1| 41139 g14594 i0 87.273 1.35849056603774 110 14 35 0 65 174 347 238 PREDICTED: Coccinella septempunctata protein transport protein Sec61 subunit gamma (LOC123309542), mRNA blastn 432 126 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Coccinella Coccinella septempunctata
16799146 16799146 PRJNA1113956_P_NODE_3234_length_1016_cov_14.249205_g2995_i0 PRJNA1113956 3234 1016 14.249205 144.7719228 Cylas formicarius 197179 Arthropoda Arthropoda 680 0   NTclustered gi|2615472541|ref|XM_060665883.1| 197179 g2995 i0 80.991 84.867125984252 868 155 85 9 65 927 1306 444 PREDICTED: Cylas formicarius actin-5C (LOC132699255), mRNA blastn 86225 680 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Brentidae Cylas Cylas formicarius
18073673 18073673 PRJNA1113956_P_NODE_8955_length_483_cov_111.704878_g8617_i0 PRJNA1113956 8955 483 111.704878 539.53456074 Aphidius gifuensis 684658 Arthropoda Arthropoda 233 1.57e-56   NTclustered gi|2106740718|ref|XM_044152953.1| 684658 g8617 i0 77.551 55.0248447204969 392 85 81 3 85 474 574 184 PREDICTED: Aphidius gifuensis histone H3.3A (LOC122852866), mRNA blastn 26577 233 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Aphidius Aphidius gifuensis
19347792 19347792 PRJNA1113956_P_NODE_10856_length_413_cov_0.888235_g10517_i0 PRJNA1113956 10856 413 0.888235 3.66841055 Zerynthia rumina 132710 Arthropoda Arthropoda 52.8 0.04   NTclustered gi|2918376681|emb|OZ238052.1| 132710 g10517 i0 96.774 0.0750605326876513 31 1 8 0 326 356 25447439 25447469 Zerynthia rumina genome assembly, chromosome: 17 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Zerynthia Zerynthia rumina
20150372 20150372 PRJNA1113956_P_NODE_5296_length_737_cov_13.513554_g4989_i0 PRJNA1113956 5296 737 13.513554 99.59489298 Formicidae 36668 Arthropoda Arthropoda 54.7 0.021   NTclustered gi|1070189394|ref|XM_018496221.1| 34720 g4989 i0 100 0.118046132971506 29 0 4 0 349 377 478 506 PREDICTED: Trachymyrmex septentrionalis ras-related protein Rab-14 (LOC108754130), mRNA blastn 87 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Trachymyrmex Trachymyrmex septentrionalis
22700813 22700813 PRJNA1113956_P_NODE_2578_length_1157_cov_88.743542_g2378_i0 PRJNA1113956 2578 1157 88.743542 1026.76278094 Insecta 50557 Arthropoda Arthropoda 658 0   NTclustered gi|2573101593|ref|XM_059370572.1| 35570 g2378 i0 79.739 312.740708729473 918 178 79 6 244 1157 2856 3769 PREDICTED: Stomoxys calcitrans polyubiquitin-C (LOC106086651), mRNA blastn 361841 658 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Stomoxys Stomoxys calcitrans
23174206 23174206 PRJNA1113956_P_NODE_14059_length_333_cov_9.615385_g13719_i0 PRJNA1113956 14059 333 9.615385 32.01923205 Anarta stigmosa 1869462 Arthropoda Arthropoda 52.8 0.031   NTclustered gi|2918376575|emb|OZ238003.1| 1869462 g13719 i0 100 0.0840840840840841 28 0 8 0 30 57 11038763 11038736 Anarta stigmosa genome assembly, chromosome: 27 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Anarta Anarta stigmosa
23174345 23174345 PRJNA1113956_P_NODE_9719_length_449_cov_34.486702_g9380_i0 PRJNA1113956 9719 449 34.486702 154.84529198 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.043   NTclustered gi|1963377326|emb|OE847817.1| 629358 g9380 i0 100 0.0623608017817372 28 0 6 0 28 55 7934 7907 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
23976111 23976111 PRJNA1113956_P_NODE_1579_length_1464_cov_12.242991_g1451_i0 PRJNA1113956 1579 1464 12.242991 179.23738824 Metazoa 33208 Arthropoda Arthropoda 58.4 0.003   NTclustered gi|1723829356|ref|XM_030390083.1| 7232 g1451 i0 94.737 1.18852459016393 38 0 2 1 508 543 1458 1495 PREDICTED: Drosophila navojoa homeobox protein vnd (LOC115565098), mRNA blastn 1740 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila navojoa
25250058 25250058 PRJNA1113956_P_NODE_12440_length_368_cov_1.044068_g12100_i0 PRJNA1113956 12440 368 1.044068 3.84217024 Arthropoda 6656 Arthropoda Arthropoda 556 6.08e-154   NTclustered gi|1866130841|ref|XM_035354739.1| 202533 g12100 i0 94.022 31.4891304347826 368 21 100 1 1 368 485 119 PREDICTED: Stegodyphus dumicola tigger transposable element-derived protein 1-like (LOC118184974), mRNA blastn 11588 556 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus dumicola

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