RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA385396" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA385396 · 20 ✖

analysis 1

  • blastn · 20 ✖
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
2351908 2351908 PRJNA385396_P_NODE_14582_length_250_cov_0.870056_g14490_i0 PRJNA385396 14582 250 0.870056 2.17514 Ostrinia 29056 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2703962384|ref|XM_063967680.1| 29057 g14490 i0 100 0.224 28 0 11 0 216 243 5626 5599 PREDICTED: Ostrinia nubilalis cytoplasmic dynein 2 heavy chain 1-like (LOC135073495), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Crambidae Ostrinia Ostrinia nubilalis
2957540 2957540 PRJNA385396_P_NODE_16183_length_248_cov_0.880000_g16091_i0 PRJNA385396 16183 248 0.88 2.1824 Haemaphysalis flava 181088 Arthropoda Arthropoda 459 1.13e-124   NTclustered gi|2314671839|gb|OL741741.1| 181088 g16091 i0 100 98.0040322580645 248 0 100 0 1 248 7224 7471 Haemaphysalis flava voucher 122 mitochondrion, complete genome blastn 24305 459 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Haemaphysalis Haemaphysalis flava
2957613 2957613 PRJNA385396_P_NODE_19143_length_244_cov_0.900585_g19051_i0 PRJNA385396 19143 244 0.900585 2.1974274 Venturia canescens 32260 Arthropoda Arthropoda 254 5.62e-63   NTclustered gi|2089821576|ref|XM_043422063.1| 32260 g19051 i0 86.784 121.967213114754 227 30 93 0 11 237 1985 1759 PREDICTED: Venturia canescens polyubiquitin-A-like (LOC122412500), mRNA blastn 29760 254 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Ichneumonidae Venturia Venturia canescens
3627256 3627256 PRJNA385396_P_NODE_12023_length_263_cov_1.278947_g11931_i0 PRJNA385396 12023 263 1.278947 3.36363061 Anopheles 7164 Arthropoda Arthropoda 171 6.35e-38   NTclustered gi|2637391125|ref|XM_061645922.1| 7165 g11931 i0 83.607 25.0076045627376 183 28 69 2 81 262 861 1042 PREDICTED: Anopheles gambiae ras-related protein Rac1 (LOC1276139), transcript variant X2, mRNA blastn 6577 171 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles gambiae
6784770 6784770 PRJNA385396_P_NODE_466_length_978_cov_3.813260_g399_i0 PRJNA385396 466 978 3.81326 37.2936828 Thrips palmi 161013 Arthropoda Arthropoda 60.2 5.92e-4   NTclustered gi|1841837932|ref|XM_034393062.1| 161013 g399 i0 82.353 0.137014314928425 68 12 7 0 191 258 635 702 PREDICTED: Thrips palmi anti-sigma-I factor RsgI2-like (LOC117649880), mRNA blastn 134 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi
7454541 7454541 PRJNA385396_P_NODE_14246_length_250_cov_0.870056_g14154_i0 PRJNA385396 14246 250 0.870056 2.17514 root 1 Root_unresolved Root_unresolved 56.5 0.002   NTclustered gi|2782982121|ref|XM_067109494.1| 79674 g14154 i0 94.595 3.624 37 1 15 1 212 248 492 527 PREDICTED: Macrobrachium rosenbergii keratin-associated protein 6-2-like (LOC136842133), mRNA blastn 906 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium rosenbergii
8060022 8060022 PRJNA385396_P_NODE_12547_length_258_cov_1.248649_g12455_i0 PRJNA385396 12547 258 1.248649 3.22151442 Drosophila miranda 7229 Arthropoda Arthropoda 220 6.08e-53   NTclustered gi|76880789|gb|DQ145270.1| 7229 g12455 i0 83.83 85.1124031007752 235 34 90 4 20 252 607 839 Drosophila miranda neo-X TER94 gene, partial sequence blastn 21959 220 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila miranda
8060063 8060063 PRJNA385396_P_NODE_14247_length_250_cov_0.870056_g14155_i0 PRJNA385396 14247 250 0.870056 2.17514 Dermacentor silvarum 543639 Arthropoda Arthropoda 213 9.81e-51   NTclustered gi|2278146495|ref|XM_049661606.1| 543639 g14155 i0 83.051 3.864 236 38 94 2 15 249 1773 1539 PREDICTED: Dermacentor silvarum probable ATP-dependent RNA helicase DDX27 (LOC119441773), mRNA blastn 966 213 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Dermacentor Dermacentor silvarum
8729253 8729253 PRJNA385396_P_NODE_20687_length_242_cov_0.911243_g20595_i0 PRJNA385396 20687 242 0.911243 2.20520806 root 1 Root_unresolved Root_unresolved 52.8 0.022   NTclustered gi|2282624035|ref|XM_049920191.1| 274614 g20595 i0 100 0.247933884297521 28 0 12 0 41 68 984 1011 PREDICTED: Schistocerca cancellata uncharacterized LOC126163843 (LOC126163843), mRNA blastn 60 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca cancellata
10610563 10610563 PRJNA385396_P_NODE_13629_length_251_cov_0.865169_g13537_i0 PRJNA385396 13629 251 0.865169 2.17157419 Helicoverpa armigera 29058 Arthropoda Arthropoda 464 2.47e-126   NTclustered gi|2705291527|ref|XM_021344028.3| 29058 g13537 i0 100 51.8127490039841 251 0 100 0 1 251 1291 1041 PREDICTED: Helicoverpa armigera poly(A) binding protein (Pabp), mRNA blastn 13005 464 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa armigera
11885490 11885490 PRJNA385396_P_NODE_13030_length_253_cov_1.711111_g12938_i0 PRJNA385396 13030 253 1.711111 4.32911083 Haemaphysalis longicornis 44386 Arthropoda Arthropoda 143 1.32e-29   NTclustered gi|117938919|dbj|AB259294.1| 44386 g12938 i0 85.401 0.541501976284585 137 20 54 0 117 253 218 354 Haemaphysalis longicornis hlim4 mRNA for cement-like antigen, partial cds blastn 137 143 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Haemaphysalis Haemaphysalis longicornis
11885637 11885637 PRJNA385396_P_NODE_19490_length_243_cov_0.905882_g19398_i0 PRJNA385396 19490 243 0.905882 2.20129326 Drosophila obscura 7282 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|2038090830|ref|XM_041594990.1| 7282 g19398 i0 100 0.238683127572016 29 0 12 0 26 54 382 410 PREDICTED: Drosophila obscura uncharacterized LOC121404754 (LOC121404754), transcript variant X1, mRNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila obscura
11885899 11885899 PRJNA385396_P_NODE_7530_length_317_cov_1.254098_g7438_i0 PRJNA385396 7530 317 1.254098 3.97549066 Amblyomma variegatum 34610 Arthropoda Arthropoda 113 1.34e-20   NTclustered gi|325304067|tpg|BK007788.1| 34610 g7438 i0 75.219 1.08201892744479 343 31 94 28 14 312 31 363 TPA_inf: Amblyomma variegatum hypothetical secreted protein 84 mRNA, complete cds blastn 343 113 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Amblyomma Amblyomma variegatum
13160702 13160702 PRJNA385396_P_NODE_20151_length_242_cov_2.035503_g20059_i0 PRJNA385396 20151 242 2.035503 4.92591726 Daphnia pulex 6669 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2192734159|ref|XM_046600325.1| 6669 g20059 i0 94.595 0.611570247933884 37 0 14 2 154 188 8462 8498 PREDICTED: Daphnia pulex serine/arginine repetitive matrix protein 2-like (LOC124203620), transcript variant X3, mRNA blastn 148 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
14435612 14435612 PRJNA385396_P_NODE_15132_length_249_cov_0.875000_g15040_i0 PRJNA385396 15132 249 0.875 2.17875 Drosophila takahashii 29030 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2866489959|ref|XM_044395575.2| 29030 g15040 i0 100 0.224899598393574 28 0 11 0 161 188 758 731 PREDICTED: Drosophila takahashii serpent (srp), transcript variant X1, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila takahashii
15709637 15709637 PRJNA385396_P_NODE_18033_length_245_cov_0.895349_g17941_i0 PRJNA385396 18033 245 0.895349 2.19360505 Paralithodes camtschaticus 6741 Arthropoda Arthropoda 124 4.62e-24   NTclustered gi|125995162|dbj|AB270632.1| 6741 g17941 i0 93.902 1.00408163265306 82 5 33 0 1 82 598 679 Paralithodes camtschaticus Tm-Parc-fast mRNA for tropomyosin fast isoform, complete cds blastn 246 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Lithodidae Paralithodes Paralithodes camtschaticus
18258589 18258589 PRJNA385396_P_NODE_4095_length_390_cov_1.940063_g4003_i0 PRJNA385396 4095 390 1.940063 7.5662457 Haemaphysalis flava 181088 Arthropoda Arthropoda 721 0   NTclustered gi|2210663526|gb|OM368276.1| 181088 g4003 i0 100 88.2358974358974 390 0 100 0 1 390 6830 7219 Haemaphysalis flava isolate A27 mitochondrion, complete genome blastn 34412 721 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Haemaphysalis Haemaphysalis flava
20808536 20808536 PRJNA385396_P_NODE_20057_length_243_cov_0.905882_g19965_i0 PRJNA385396 20057 243 0.905882 2.20129326 Rhipicephalus sanguineus 34632 Arthropoda Arthropoda 235 2.03e-57   NTclustered gi|2273021173|ref|XM_037672909.2| 34632 g19965 i0 84.647 6.94238683127572 241 31 99 3 3 243 819 585 PREDICTED: Rhipicephalus sanguineus dual specificity testis-specific protein kinase 1 (LOC119406061), mRNA blastn 1687 235 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus sanguineus
22083574 22083574 PRJNA385396_P_NODE_6018_length_341_cov_2.555970_g5926_i0 PRJNA385396 6018 341 2.55597 8.7158577 Dermacentor silvarum 543639 Arthropoda Arthropoda 121 8.709999999999999e-23   NTclustered gi|2278166749|ref|XM_037715603.2| 543639 g5926 i0 91.011 5.08797653958944 89 8 26 0 223 311 821 733 PREDICTED: Dermacentor silvarum ras-related protein Rac1 (LOC119453550), mRNA blastn 1735 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Dermacentor Dermacentor silvarum
25302748 25302748 PRJNA385396_P_NODE_9420_length_291_cov_1.412844_g9328_i0 PRJNA385396 9420 291 1.412844 4.11137604 Ixodidae 6939 Arthropoda Arthropoda 333 8.6e-87   NTclustered gi|2272994052|ref|XM_037651628.2| 34632 g9328 i0 87.285 3.99656357388316 291 37 100 0 1 291 559 849 PREDICTED: Rhipicephalus sanguineus 60S ribosomal protein L5-A (LOC119383477), mRNA blastn 1163 333 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus sanguineus

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