RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "blastn", bioproject = "PRJNA1061474" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 26 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1061474 · 26 ✖

analysis 1

  • blastn · 26 ✖
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
177966 177966 PRJNA1061474_P_NODE_18261_length_464_cov_1.529412_g18015_i0 PRJNA1061474 18261 464 1.529412 7.09647168 Diaphorina citri 121845 Arthropoda Arthropoda 54.7 0.013   NTclustered gi|1494768721|ref|XM_026829868.1| 121845 g18015 i0 92.308 0.385775862068966 39 2 8 1 186 223 4533 4495 PREDICTED: Diaphorina citri protein Gawky (LOC103517948), mRNA blastn 179 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
179081 179081 PRJNA1061474_P_NODE_55621_length_243_cov_0.905882_g55375_i0 PRJNA1061474 55621 243 0.905882 2.20129326 Bemisia tabaci 7038 Arthropoda Arthropoda 449 6.65e-122   NTclustered gi|1101340044|ref|XM_019040022.1| 7038 g55375 i0 100 2 243 0 100 0 1 243 153 395 PREDICTED: Bemisia tabaci uncharacterized LOC109029538 (LOC109029538), transcript variant X2, mRNA blastn 486 449 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
2729258 2729258 PRJNA1061474_P_NODE_44263_length_256_cov_1.508197_g44017_i0 PRJNA1061474 44263 256 1.508197 3.86098432 Drosophila virilis 7244 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|2867919253|ref|XM_002059158.4| 7244 g44017 i0 96.97 0.12890625 33 0 13 1 38 69 587 555 PREDICTED: Drosophila virilis PDGF- and VEGF-related factor 2 (Pvf2), mRNA blastn 33 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila virilis
4005399 4005399 PRJNA1061474_P_NODE_51424_length_246_cov_0.890173_g51178_i0 PRJNA1061474 51424 246 0.890173 2.18982558 Chelidurella thaleri 2546182 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2919607494|emb|OZ238404.1| 2546182 g51178 i0 100 0.113821138211382 28 0 11 0 74 101 20397811 20397838 Chelidura thaleri genome assembly, chromosome: 5 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
5281666 5281666 PRJNA1061474_P_NODE_50105_length_247_cov_0.885057_g49859_i0 PRJNA1061474 50105 247 0.885057 2.18609079 Artemia sinica 112780 Arthropoda Arthropoda 331 2.5600000000000002e-86   NTclustered gi|765368597|gb|KP162166.1| 112780 g49859 i0 96.954 0.797570850202429 197 6 80 0 1 197 1777 1581 Artemia sinica cell division cycle 20 (cdc20) mRNA, complete cds blastn 197 331 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia sinica
6556605 6556605 PRJNA1061474_P_NODE_40786_length_275_cov_1.524752_g40540_i0 PRJNA1061474 40786 275 1.524752 4.193068 Oppiella nova 334625 Arthropoda Arthropoda 52.8 0.025   NTclustered gi|1962586414|emb|OC916738.1| 334625 g40540 i0 91.892 0.134545454545455 37 3 13 0 213 249 907 871 Oppiella nova blastn 37 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
6556790 6556790 PRJNA1061474_P_NODE_47446_length_249_cov_2.625000_g47200_i0 PRJNA1061474 47446 249 2.625 6.53625 Thrix scopula 2847741 Arthropoda Arthropoda 195 3.5399999999999996e-45   NTclustered gi|2566480291|gb|OK730403.1| 2847742 g47200 i0 82.727 34.5903614457831 220 37 88 1 29 247 374 155 Thrix scopula scopula voucher MCZ:NP-95-Z258 GTP-binding nuclear protein gene, partial cds blastn 8613 195 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Thrix Thrix scopula
6557036 6557036 PRJNA1061474_P_NODE_57526_length_241_cov_0.916667_g57280_i0 PRJNA1061474 57526 241 0.916667 2.20916747 Teleopsis dalmanni 139649 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1941851779|ref|XM_038078826.1| 139649 g57280 i0 96.875 0.265560165975104 32 1 13 0 173 204 3529 3560 PREDICTED: Teleopsis dalmanni serine/threonine-protein kinase minibrain-like (LOC119669066), transcript variant X2, mRNA blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Diopsidae Teleopsis Teleopsis dalmanni
7389438 7389438 PRJNA1061474_P_NODE_55306_length_243_cov_0.905882_g55060_i0 PRJNA1061474 55306 243 0.905882 2.20129326 Timema 61471 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|1964637642|emb|OE179793.1| 61474 g55060 i0 100 0.230452674897119 28 0 12 0 2 29 131413 131386 2_Tcm_b3v08 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
10382026 10382026 PRJNA1061474_P_NODE_44469_length_255_cov_1.500000_g44223_i0 PRJNA1061474 44469 255 1.5 3.825 Spodoptera frugiperda 7108 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|291201245|emb|FP340420.1| 7108 g44223 i0 100 0.109803921568627 28 0 11 0 96 123 79249 79222 70A06_SfBAC_fin, Spodoptera frugiperda BAC, egg DNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
12932805 12932805 PRJNA1061474_P_NODE_58051_length_241_cov_0.916667_g57805_i0 PRJNA1061474 58051 241 0.916667 2.20916747 Nicrophorus vespilloides 110193 Arthropoda Arthropoda 100 7.64e-17   NTclustered gi|1059406907|ref|XM_017920846.1| 110193 g57805 i0 81.6 3.0207468879668 125 19 51 4 95 217 1397 1519 PREDICTED: Nicrophorus vespilloides elongation factor 2 (LOC108562483), mRNA blastn 728 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Silphidae Nicrophorus Nicrophorus vespilloides
16755753 16755753 PRJNA1061474_P_NODE_45774_length_251_cov_0.865169_g45528_i0 PRJNA1061474 45774 251 0.865169 2.17157419 Anarta stigmosa 1869462 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2918376539|emb|OZ237978.1| 1869462 g45528 i0 100 0.111553784860558 28 0 11 0 177 204 14103779 14103752 Anarta stigmosa genome assembly, chromosome: 2 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Anarta Anarta stigmosa
18030552 18030552 PRJNA1061474_P_NODE_48095_length_249_cov_0.875000_g47849_i0 PRJNA1061474 48095 249 0.875 2.17875 Eupeodes corollae 290404 Arthropoda Arthropoda 150 7.77e-32   NTclustered gi|2503834946|ref|XM_056066391.1| 290404 g47849 i0 78.279 2.11646586345382 244 45 97 8 3 243 360 598 PREDICTED: Eupeodes corollae ADP-ribosylation factor 2 (LOC129953312), mRNA blastn 527 150 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Syrphidae Eupeodes Eupeodes corollae
18030767 18030767 PRJNA1061474_P_NODE_56675_length_242_cov_0.911243_g56429_i0 PRJNA1061474 56675 242 0.911243 2.20520806 Tetranychus evansi 178897 Arthropoda Arthropoda 239 1.56e-58   NTclustered gi|1514785883|gb|MH979717.1| 178897 g56429 i0 87.143 79.2438016528926 210 27 87 0 28 237 283 492 Tetranychus evansi actin isoform X1 mRNA, complete cds blastn 19177 239 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus evansi
18030795 18030795 PRJNA1061474_P_NODE_58035_length_241_cov_0.916667_g57789_i0 PRJNA1061474 58035 241 0.916667 2.20916747 Centruroides sculpturatus 218467 Arthropoda Arthropoda 132 2.7100000000000004e-26   NTclustered gi|1316131948|ref|XM_023378152.1| 218467 g57789 i0 87.288 5.31535269709544 118 12 49 3 9 125 352 237 PREDICTED: Centruroides sculpturatus RING-box protein 1 (LOC111633535), mRNA blastn 1281 132 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides sculpturatus
19304346 19304346 PRJNA1061474_P_NODE_40316_length_278_cov_1.126829_g40070_i0 PRJNA1061474 40316 278 1.126829 3.13258462 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.026   NTclustered gi|1963414999|emb|OE881564.1| 629358 g40070 i0 88.636 0.158273381294964 44 4 16 1 23 66 243 285 5_Tge_b3v08 blastn 44 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
19304742 19304742 PRJNA1061474_P_NODE_55336_length_243_cov_0.905882_g55090_i0 PRJNA1061474 55336 243 0.905882 2.20129326 Cyprideis torosa 163714 Arthropoda Arthropoda 65.8 2.81e-6   NTclustered gi|1936457459|emb|OB776731.1| 163714 g55090 i0 93.333 0.740740740740741 45 2 18 1 136 179 117 73 Cyprideis torosa blastn 180 65.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cytherideidae Cyprideis Cyprideis torosa
20579659 20579659 PRJNA1061474_P_NODE_39837_length_281_cov_0.985577_g39591_i0 PRJNA1061474 39837 281 0.985577 2.76947137 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 172 1.91e-38   NTclustered gi|1535903816|ref|XM_027337872.1| 6956 g39591 i0 88.276 1.38434163701068 145 15 51 2 118 261 1612 1469 PREDICTED: Dermatophagoides pteronyssinus endoplasmin-like (LOC113788421), mRNA blastn 389 172 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
20579968 20579968 PRJNA1061474_P_NODE_51097_length_246_cov_0.930636_g50851_i0 PRJNA1061474 51097 246 0.930636 2.28936456 Microplitis mediator 375433 Arthropoda Arthropoda 193 1.25e-44   NTclustered gi|2520964906|ref|XM_057477251.1| 375433 g50851 i0 82.143 9.34959349593496 224 40 91 0 18 241 467 244 PREDICTED: Microplitis mediator 40S ribosomal protein S11 (LOC130672612), mRNA blastn 2300 193 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Microplitis Microplitis mediator
21854866 21854866 PRJNA1061474_P_NODE_22138_length_412_cov_1.221239_g21892_i0 PRJNA1061474 22138 412 1.221239 5.03150468 Daphnia carinata 120202 Arthropoda Arthropoda 58.4 8.51e-4   NTclustered gi|2577064070|ref|XM_057516072.2| 120202 g21892 i0 92.5 0.0970873786407767 40 3 10 0 45 84 2599 2638 PREDICTED: Daphnia carinata DNA topoisomerase 3-beta-1-like (LOC130692980), mRNA blastn 40 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia carinata
21855509 21855509 PRJNA1061474_P_NODE_41198_length_273_cov_1.250000_g40952_i0 PRJNA1061474 41198 273 1.25 3.4125 Procambarus clarkii 6728 Arthropoda Arthropoda 346 1.03e-90   NTclustered gi|1465231299|gb|MG910479.1| 6728 g40952 i0 89.668 100.007326007326 271 28 99 0 1 271 325 55 Procambarus clarkii cytoplasmic actin 1 (Actb) mRNA, partial cds blastn 27302 346 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
21855656 21855656 PRJNA1061474_P_NODE_45718_length_251_cov_0.865169_g45472_i0 PRJNA1061474 45718 251 0.865169 2.17157419 Diachasmimorpha longicaudata 58733 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2706564944|ref|XM_064134235.1| 58733 g45472 i0 88.889 1.43426294820717 45 2 18 3 66 109 4305 4263 PREDICTED: Diachasmimorpha longicaudata autism susceptibility gene 2 protein homolog (LOC135169331), transcript variant X6, mRNA blastn 360 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Diachasmimorpha Diachasmimorpha longicaudata
21855777 21855777 PRJNA1061474_P_NODE_50698_length_247_cov_0.885057_g50452_i0 PRJNA1061474 50698 247 0.885057 2.18609079 Bombus pascuorum 65598 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|2620563859|ref|XM_060974284.1| 65598 g50452 i0 100 3.71255060728745 29 0 12 0 115 143 1778 1806 PREDICTED: Bombus pascuorum plasma membrane calcium-transporting ATPase 3 (LOC132914843), transcript variant X4, mRNA blastn 917 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus pascuorum
21856019 21856019 PRJNA1061474_P_NODE_7098_length_821_cov_4.915775_g6891_i0 PRJNA1061474 7098 821 4.915775 40.35851275 Papilio polytes 76194 Arthropoda Arthropoda 1354 0   NTclustered gi|389615034|dbj|AK405121.1| 76194 g6891 i0 99.729 19.8745432399513 738 2 90 0 84 821 1 738 Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis blastn 16317 1354 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
23131401 23131401 PRJNA1061474_P_NODE_57699_length_241_cov_0.916667_g57453_i0 PRJNA1061474 57699 241 0.916667 2.20916747 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2024315559|ref|XM_040712855.1| 72036 g57453 i0 100 0.232365145228216 28 0 12 0 134 161 1142 1169 PREDICTED: Lepeophtheirus salmonis ras-responsive element-binding protein 1-like (LOC121118287), transcript variant X1, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
24404444 24404444 PRJNA1061474_P_NODE_35200_length_306_cov_2.034335_g34954_i0 PRJNA1061474 35200 306 2.034335 6.2250651 Frankliniella occidentalis 133901 Arthropoda Arthropoda 200 9.63e-47   NTclustered gi|2347703373|ref|XR_003303738.2| 133901 g34954 i0 85.641 73.9313725490196 195 22 63 5 112 304 1502 1312 PREDICTED: Frankliniella occidentalis large subunit ribosomal RNA (LOC113212716), rRNA blastn 22623 200 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Frankliniella Frankliniella occidentalis

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