RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "blastn", bioproject = "PRJNA1088503" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 31 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1088503 · 31 ✖

analysis 1

  • blastn · 31 ✖
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
1469137 1469137 PRJNA1088503_P_NODE_9362_length_207_cov_34250.735955_g8990_i0 PRJNA1088503 9362 207 34250.735955 70899.02342685 Agapeta hamana 1100904 Arthropoda Arthropoda 52.8 0.018   NTclustered gi|2918370035|emb|OZ237963.1| 1100904 g8990 i0 100 0.270531400966184 28 0 14 0 138 165 4513396 4513369 Agapeta hamana genome assembly, chromosome: 3 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Agapeta Agapeta hamana
3568134 3568134 PRJNA1088503_P_NODE_3383_length_486_cov_19675.713348_g3058_i0 PRJNA1088503 3383 486 19675.713348 95623.96687128 Aphididae 27482 Arthropoda Arthropoda 161 7.549999999999998e-35   NTclustered gi|1229876427|ref|XM_022318834.1| 13164 g3058 i0 94.34 0.674897119341564 106 5 34 1 15 119 315 420 PREDICTED: Myzus persicae piggyBac transposable element-derived protein 4-like (LOC111036705), partial mRNA blastn 328 161 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Myzus Myzus persicae
4021128 4021128 PRJNA1088503_P_NODE_1904_length_668_cov_2.456964_g1032_i1 PRJNA1088503 1904 668 2.456964 16.41251952 Eurytemora carolleeae 1294199 Arthropoda Arthropoda 420 1.5799999999999996e-112   NTclustered gi|1325306509|ref|XM_023479101.1| 1294199 g1032 i1 79.798 85.747005988024 594 106 88 14 1 587 729 143 PREDICTED: Eurytemora carolleeae eukaryotic initiation factor 4A-I (LOC111706269), mRNA blastn 57279 420 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Temoridae Eurytemora Eurytemora carolleeae
4021138 4021138 PRJNA1088503_P_NODE_2564_length_570_cov_22829.940850_g2294_i0 PRJNA1088503 2564 570 22829.94085 130130.662845 Neocloeon triangulifer 2078957 Arthropoda Arthropoda 335 4.989999999999998e-87   NTclustered gi|2579110896|ref|XM_059634456.1| 2078957 g2294 i0 81.043 65.3368421052632 422 78 74 2 128 548 141 561 PREDICTED: Neocloeon triangulifer small ribosomal subunit protein uS19 (LOC132205416), mRNA blastn 37242 335 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Baetidae Neocloeon Neocloeon triangulifer
5297314 5297314 PRJNA1088503_P_NODE_4345_length_411_cov_25180.034031_g3985_i0 PRJNA1088503 4345 411 25180.034031 103489.93986741 Speleorchestes sp. AD1314 2051768 Arthropoda Arthropoda 346 1.6199999999999996e-90   NTclustered gi|1282190926|gb|KY922357.1| 2051768 g3985 i0 87.625 51.3844282238443 299 36 73 1 80 378 1 298 Speleorchestes sp. AD1314 voucher UMMZ BMOC 08-0901-011 AD1314 cytochrome oxidase subunit I (COXI) gene, partial cds; mitochondrial blastn 21119 346 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Nanorchestidae Speleorchestes Speleorchestes sp. AD1314
6572361 6572361 PRJNA1088503_P_NODE_10626_length_175_cov_1.678082_g10254_i0 PRJNA1088503 10626 175 1.678082 2.9366435 Nicrophorus vespilloides 110193 Arthropoda Arthropoda 187 3.8699999999999985e-43   NTclustered gi|1059415595|ref|XM_017925179.1| 110193 g10254 i0 87.975 62.1257142857143 158 19 90 0 16 173 365 522 PREDICTED: Nicrophorus vespilloides ADP-ribosylation factor 1 (LOC108565625), transcript variant X2, mRNA blastn 10872 187 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Silphidae Nicrophorus Nicrophorus vespilloides
6572375 6572375 PRJNA1088503_P_NODE_2126_length_633_cov_430.302980_g1888_i0 PRJNA1088503 2126 633 430.30298 2723.8178634 Colocasiomyia kinabaluana 2880669 Arthropoda Arthropoda 196 2.74e-45   NTclustered gi|2228983853|gb|OK377085.1| 2880669 g1888 i0 91.549 23.0774091627172 142 12 22 0 465 606 382 241 Colocasiomyia kinabaluana ATP synthase sub-unit alpha (ATPsyn-alpha) gene, partial cds blastn 14608 196 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Colocasiomyia Colocasiomyia kinabaluana
7847179 7847179 PRJNA1088503_P_NODE_2727_length_551_cov_2.913793_g2446_i0 PRJNA1088503 2727 551 2.913793 16.05499943 Portunus trituberculatus 210409 Arthropoda Arthropoda 174 1.11e-38   NTclustered gi|2159658493|ref|XM_045259179.1| 210409 g2446 i0 79.675 9.76406533575318 246 46 44 4 307 551 461 219 PREDICTED: Portunus trituberculatus cytochrome c (LOC123506836), mRNA blastn 5380 174 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
9122106 9122106 PRJNA1088503_P_NODE_1168_length_837_cov_2.404703_g1032_i0 PRJNA1088503 1168 837 2.404703 20.12736411 Ixodes scapularis 6945 Arthropoda Arthropoda 501 6.96e-137   NTclustered gi|2015524481|ref|XM_040223602.1| 6945 g1032 i0 77.699 78.547192353644 843 172 99 14 3 837 157 991 PREDICTED: Ixodes scapularis eukaryotic initiation factor 4A-I (LOC120851027), mRNA blastn 65744 501 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
9122149 9122149 PRJNA1088503_P_NODE_7088_length_276_cov_1.939271_g6716_i0 PRJNA1088503 7088 276 1.939271 5.35238796 Cylas formicarius 197179 Arthropoda Arthropoda 117 8.87e-22   NTclustered gi|2615456032|ref|XM_060669909.1| 197179 g6716 i0 91.667 6.35507246376812 84 7 30 0 192 275 1313 1230 PREDICTED: Cylas formicarius eukaryotic initiation factor 4A-III (LOC132701745), mRNA blastn 1754 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Brentidae Cylas Cylas formicarius
9945692 9945692 PRJNA1088503_P_NODE_8828_length_221_cov_2.473958_g8456_i0 PRJNA1088503 8828 221 2.473958 5.46744718 Drosophila 7215 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|2897283881|ref|XM_017068252.4| 28584 g8456 i0 90.244 1.08597285067873 41 4 19 0 181 221 462 422 PREDICTED: Drosophila suzukii dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit (Dad1), mRNA blastn 240 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila suzukii
11673156 11673156 PRJNA1088503_P_NODE_10130_length_187_cov_2.424051_g9758_i0 PRJNA1088503 10130 187 2.424051 4.53297537 Leptodora kindtii 77707 Arthropoda Arthropoda 235 1.4799999999999998e-57   NTclustered gi|2488183864|emb|OC988002.1| 77707 g9758 i0 89.305 99.4973262032086 187 20 100 0 1 187 1017 1203 Leptodora kindtii EOG090X03DA gene for EOG090X03DA blastn 18606 235 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Leptodoridae Leptodora Leptodora kindtii
12948218 12948218 PRJNA1088503_P_NODE_8731_length_223_cov_55078.603093_g8359_i0 PRJNA1088503 8731 223 55078.603093 122825.28489739 Diprion similis 362088 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2198845333|ref|XM_046882771.1| 362088 g8359 i0 96.97 2.52017937219731 33 1 15 0 136 168 1781 1749 PREDICTED: Diprion similis uncharacterized LOC124407005 (LOC124407005), mRNA blastn 562 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Diprionidae Diprion Diprion similis
14223257 14223257 PRJNA1088503_P_NODE_4232_length_419_cov_22578.494872_g3873_i0 PRJNA1088503 4232 419 22578.494872 94603.89351368 Calliphora vicina 7373 Arthropoda Arthropoda 684 0   NTclustered gi|2736839961|ref|XM_065510661.1| 7373 g3873 i0 98.465 1.86634844868735 391 0 92 3 34 419 3143 3532 PREDICTED: Calliphora vicina Acyl-CoA synthetase long-chain (Acsl), transcript variant X2, mRNA blastn 782 684 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Calliphora Calliphora vicina
14223265 14223265 PRJNA1088503_P_NODE_5292_length_352_cov_31342.058824_g4920_i0 PRJNA1088503 5292 352 31342.058824 110324.04706048 Calliphora vicina 7373 Arthropoda Arthropoda 564 3.4599999999999995e-156   NTclustered gi|2736846543|ref|XM_065514300.1| 7373 g4920 i0 98.447 0.914772727272727 322 1 90 1 1 318 1659 1338 PREDICTED: Calliphora vicina CAAX prenyl protease 1 homolog (LOC135962391), mRNA blastn 322 564 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Calliphora Calliphora vicina
14223288 14223288 PRJNA1088503_P_NODE_8172_length_240_cov_51800.497630_g7800_i0 PRJNA1088503 8172 240 51800.49763 124321.194312 Cavariella theobaldi 527598 Arthropoda Arthropoda 350 6.839999999999999e-92   NTclustered gi|2739944308|emb|OZ060905.1| 527598 g7800 i0 98.01 84.6583333333333 201 4 84 0 36 236 14330 14130 Cavariella theobaldi genome assembly, organelle: mitochondrion blastn 20318 350 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cavariella Cavariella theobaldi
14223290 14223290 PRJNA1088503_P_NODE_8532_length_229_cov_46164.995000_g8160_i0 PRJNA1088503 8532 229 46164.995 105717.83855 Calliphora vicina 7373 Arthropoda Arthropoda 361 2.9899999999999998e-95   NTclustered gi|2736832970|ref|XM_065506837.1| 7373 g8160 i0 100 1.70305676855895 195 0 85 0 2 196 3521 3327 PREDICTED: Calliphora vicina Tis11 zinc finger protein (Tis11), transcript variant X2, mRNA blastn 390 361 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Calliphora Calliphora vicina
15497174 15497174 PRJNA1088503_P_NODE_8613_length_226_cov_59782.324873_g8241_i0 PRJNA1088503 8613 226 59782.324873 135108.05421298 Anopheles nili 185578 Arthropoda Arthropoda 76.8 1.19e-9   NTclustered gi|2449495736|ref|XM_053816737.1| 185578 g8241 i0 100 17.5840707964602 41 0 18 0 3 43 1182 1142 PREDICTED: Anopheles nili heat shock protein 83 (LOC128723033), mRNA blastn 3974 76.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles nili
16771519 16771519 PRJNA1088503_P_NODE_4374_length_409_cov_24469.550000_g4013_i0 PRJNA1088503 4374 409 24469.55 100080.4595 Calliphora vicina 7373 Arthropoda Arthropoda 695 0   NTclustered gi|2736839920|ref|XM_065510639.1| 7373 g4013 i0 100 2.36674816625917 376 0 92 0 34 409 1486 1861 PREDICTED: Calliphora vicina fatty-acid amide hydrolase 2-A (LOC135959645), mRNA blastn 968 695 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Calliphora Calliphora vicina
17595290 17595290 PRJNA1088503_P_NODE_1614_length_721_cov_6.936416_g1432_i0 PRJNA1088503 1614 721 6.936416 50.01155936 Insecta 50557 Arthropoda Arthropoda 141 1.5e-28   NTclustered gi|1509803114|ref|XM_001973675.3| 7220 g1432 i0 97.561 11.7337031900139 82 2 11 0 640 721 1202 1121 PREDICTED: Drosophila erecta actin, larval muscle (LOC6544283), mRNA blastn 8460 141 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila erecta
18046240 18046240 PRJNA1088503_P_NODE_5155_length_360_cov_1.858006_g4783_i0 PRJNA1088503 5155 360 1.858006 6.6888216 Nilaparvata lugens 108931 Arthropoda Arthropoda 274 6.689999999999998e-69   NTclustered gi|1983885609|ref|XM_039440011.1| 108931 g4783 i0 85.496 66.0027777777778 262 38 73 0 99 360 67 328 PREDICTED: Nilaparvata lugens 60S ribosomal protein L30 (LOC111050702), transcript variant X1, mRNA blastn 23761 274 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
19320259 19320259 PRJNA1088503_P_NODE_5016_length_367_cov_307.372781_g4646_i0 PRJNA1088503 5016 367 307.372781 1128.05810627 Adelges cooleyi 133065 Arthropoda Arthropoda 191 7.08e-44   NTclustered gi|2296687056|ref|XM_050572588.1| 133065 g4646 i0 81.545 8.79291553133515 233 41 63 2 136 367 199 430 PREDICTED: Adelges cooleyi ubiquitin-conjugating enzyme E2-17 kDa (LOC126838282), mRNA blastn 3227 191 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Adelgidae Adelges Adelges cooleyi
19320280 19320280 PRJNA1088503_P_NODE_8516_length_230_cov_2.482587_g8144_i0 PRJNA1088503 8516 230 2.482587 5.7099501 Pollicipes pollicipes 41117 Arthropoda Arthropoda 159 1.18e-34   NTclustered gi|172072957|gb|EU370441.1| 41117 g8144 i0 92.793 72.0260869565217 111 7 48 1 6 115 3338 3448 Pollicipes pollicipes strain C17 28S ribosomal RNA gene, partial sequence blastn 16566 159 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Pollicipedomorpha Pollicipedidae Pollicipes Pollicipes pollicipes
20595570 20595570 PRJNA1088503_P_NODE_237_length_1387_cov_7982.826215_g201_i0 PRJNA1088503 237 1387 7982.826215 110721.79960205 Homalodisca vitripennis 197043 Arthropoda Arthropoda 111 2.31e-19   NTclustered gi|2196651789|ref|XR_006922670.1| 197043 g201 i0 91.358 1.05984138428262 81 7 6 0 67 147 94 174 PREDICTED: Homalodisca vitripennis uncharacterized LOC124364837 (LOC124364837), ncRNA blastn 1470 111 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
20595575 20595575 PRJNA1088503_P_NODE_2837_length_538_cov_21281.210216_g2549_i0 PRJNA1088503 2837 538 21281.210216 114492.91096208 Timema douglasi 61478 Arthropoda Arthropoda 425 2.7e-114   NTclustered gi|1936766486|emb|OA594500.1| 61478 g2549 i0 98.347 0.901486988847584 242 4 90 0 278 519 1651 1892 1_Tdi_b3v08 blastn 485 425 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
20595601 20595601 PRJNA1088503_P_NODE_6077_length_316_cov_19738.480836_g5705_i0 PRJNA1088503 6077 316 19738.480836 62373.59944176 Calliphora vicina 7373 Arthropoda Arthropoda 462 1.15e-125   NTclustered gi|2736819844|ref|XM_065499838.1| 7373 g5705 i0 96.154 2.85443037974684 286 6 90 4 1 285 1466 1185 PREDICTED: Calliphora vicina prohibitin l(2)37Cc (l(2)37Cc), mRNA blastn 902 462 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Calliphora Calliphora vicina
23146691 23146691 PRJNA1088503_P_NODE_7059_length_277_cov_2.588710_g6687_i0 PRJNA1088503 7059 277 2.58871 7.1707267 Drosophila novamexicana 47314 Arthropoda Arthropoda 259 1.4e-64   NTclustered gi|1732844357|ref|XM_030712282.1| 47314 g6687 i0 85.772 46.057761732852 246 33 88 2 32 276 491 247 PREDICTED: Drosophila novamexicana 40S ribosomal protein S16 (LOC115767889), mRNA blastn 12758 259 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila novamexicana
23146705 23146705 PRJNA1088503_P_NODE_9319_length_208_cov_51611.262570_g8947_i0 PRJNA1088503 9319 208 51611.26257 107351.4261456 Timema cristinae 61476 Arthropoda Arthropoda 58.4 3.92e-4   NTclustered gi|1947061955|emb|OC320287.1| 61476 g8947 i0 94.737 1.01442307692308 38 0 17 1 57 92 55514 55551 3_Tce_b3v08 blastn 211 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae
24420345 24420345 PRJNA1088503_P_NODE_2060_length_643_cov_14646.820847_g1834_i0 PRJNA1088503 2060 643 14646.820847 94179.05804621 Acyrthosiphon pisum 7029 Arthropoda Arthropoda 69.4 6.35e-7   NTclustered gi|239790251|dbj|AK341267.1| 7029 g1834 i0 97.5 0.180404354587869 40 1 6 0 571 610 1444 1405 Acyrthosiphon pisum ACYPI000185 mRNA, clone: 92O23, complete cds, full-insert cDNA sequence based on the ESTs (5'-EST:EX628214, 3'-EST:EX628346) blastn 116 69.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
24420348 24420348 PRJNA1088503_P_NODE_2360_length_595_cov_19467.148410_g2106_i0 PRJNA1088503 2360 595 19467.14841 115829.5330395 Timema douglasi 61478 Arthropoda Arthropoda 905 0   NTclustered gi|1936766486|emb|OA594500.1| 61478 g2106 i0 97.043 0.909243697478992 541 10 91 2 36 576 1358 1892 1_Tdi_b3v08 blastn 541 905 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
24420394 24420394 PRJNA1088503_P_NODE_7320_length_268_cov_2.280335_g6948_i0 PRJNA1088503 7320 268 2.280335 6.1112978 Cylas formicarius 197179 Arthropoda Arthropoda 121 6.63e-23   NTclustered gi|2615456032|ref|XM_060669909.1| 197179 g6948 i0 91.86 7.0634328358209 86 7 32 0 2 87 1230 1315 PREDICTED: Cylas formicarius eukaryotic initiation factor 4A-III (LOC132701745), mRNA blastn 1893 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Brentidae Cylas Cylas formicarius

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