RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "blastn", bioproject = "PRJNA950981" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 30 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA950981 · 30 ✖

analysis 1

  • blastn · 30 ✖
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
933889 933889 PRJNA950981_P_NODE_541_length_1199_cov_2.208703_g457_i0 PRJNA950981 541 1199 2.208703 26.48234897 Drosophila takahashii 29030 Arthropoda Arthropoda 911 0   NTclustered gi|2866490053|ref|XM_017144913.3| 29030 g457 i0 82.899 89.0100083402836 1035 155 85 19 168 1191 1501 478 PREDICTED: Drosophila takahashii V-type proton ATPase subunit Vha55 (Vha55), mRNA blastn 106723 911 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila takahashii
2209149 2209149 PRJNA950981_P_NODE_15462_length_262_cov_1.238095_g15286_i0 PRJNA950981 15462 262 1.238095 3.2438089 Drosophila melanogaster 7227 Arthropoda Arthropoda 52.8 0.024   NTclustered gi|55715380|gb|AY779917.1| 7227 g15286 i0 100 0.106870229007634 28 0 11 0 103 130 27817 27844 Drosophila melanogaster strain NVIII-m11 enhancer of split complex, complete sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
2209155 2209155 PRJNA950981_P_NODE_17482_length_251_cov_0.876404_g17306_i0 PRJNA950981 17482 251 0.876404 2.19977404 Eupeodes corollae 290404 Arthropoda Arthropoda 60.2 1.36e-4   NTclustered gi|2503798457|ref|XM_056056734.1| 290404 g17306 i0 90.909 4.08764940239044 44 4 18 0 155 198 351 308 PREDICTED: Eupeodes corollae uncharacterized LOC129946522 (LOC129946522), mRNA blastn 1026 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Syrphidae Eupeodes Eupeodes corollae
2209184 2209184 PRJNA950981_P_NODE_6702_length_379_cov_11.081699_g6526_i0 PRJNA950981 6702 379 11.081699 41.99963921 Speleorchestes sp. AD1084 2051767 Arthropoda Arthropoda 104 9.83e-18   NTclustered gi|1282187773|gb|KY921978.1| 2051767 g6526 i0 83.478 4.25857519788918 115 16 30 3 195 306 2454 2568 Speleorchestes sp. AD1084 voucher UMMZ BMOC 07-0615-007 AD1084 28S ribosomal RNA gene, partial sequence blastn 1614 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Nanorchestidae Speleorchestes Speleorchestes sp. AD1084
2538164 2538164 PRJNA950981_P_NODE_12582_length_290_cov_1.055300_g12406_i0 PRJNA950981 12582 290 1.0553 3.06037 Anopheles 7164 Arthropoda Arthropoda 52.8 0.027   NTclustered gi|2548915758|ref|XM_058272666.1| 139045 g12406 i0 100 0.193103448275862 28 0 10 0 229 256 1368 1341 PREDICTED: Anopheles coustani serrate RNA effector molecule homolog (LOC131271255), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles coustani
2538170 2538170 PRJNA950981_P_NODE_19402_length_247_cov_0.896552_g19226_i0 PRJNA950981 19402 247 0.896552 2.21448344 Culicidae 7157 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2669906868|ref|XM_062854529.1| 7160 g19226 i0 100 1.1336032388664 28 0 11 0 94 121 2526 2499 PREDICTED: Aedes albopictus transcription initiation factor TFIID subunit 4 (LOC109404750), transcript variant X1, mRNA blastn 280 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
3484499 3484499 PRJNA950981_P_NODE_11763_length_299_cov_1.380531_g11587_i0 PRJNA950981 11763 299 1.380531 4.12778769 Penaeus monodon 6687 Arthropoda Arthropoda 52.8 0.028   NTclustered gi|1936095781|ref|XM_037921990.1| 6687 g11587 i0 96.774 1.24414715719064 31 1 10 0 115 145 1174 1204 PREDICTED: Penaeus monodon chitin deacetylase 8-like (LOC119574624), transcript variant X6, mRNA blastn 372 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon
3484520 3484520 PRJNA950981_P_NODE_21983_length_234_cov_3.416149_g21807_i0 PRJNA950981 21983 234 3.416149 7.99378866 Maconellicoccus hirsutus 177089 Arthropoda Arthropoda 65.8 2.69e-6   NTclustered gi|121543864|gb|EF070531.1| 177089 g21807 i0 86.441 0.478632478632479 59 8 25 0 28 86 214 272 Maconellicoccus hirsutus clone WHMH4330 ubiquitin/ribosomal protein S30e fusion protein-like protein mRNA, complete cds blastn 112 65.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pseudococcidae Maconellicoccus Maconellicoccus hirsutus
3814551 3814551 PRJNA950981_P_NODE_21183_length_243_cov_0.917647_g21007_i0 PRJNA950981 21183 243 0.917647 2.22988221 Drosophila 7215 Arthropoda Arthropoda 62.1 3.64e-5   NTclustered gi|1060281669|ref|XM_017995916.1| 30019 g21007 i0 100 12.6460905349794 33 0 14 0 211 243 315 347 PREDICTED: Drosophila busckii mediator of RNA polymerase II transcription subunit 15 (LOC108606070), partial mRNA blastn 3073 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila busckii
4762269 4762269 PRJNA950981_P_NODE_4_length_4713_cov_6.849784_g3_i0 PRJNA950981 4 4713 6.849784 322.83031992 Malaya genurostris 325434 Arthropoda Arthropoda 67.6 1.76e-5   NTclustered gi|2557305120|ref|XM_058599925.1| 325434 g3 i0 97.5 0.00848716316571186 40 0 1 1 4473 4511 145 106 PREDICTED: Malaya genurostris dentin sialophosphoprotein-like (LOC131433109), partial mRNA blastn 40 67.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Malaya Malaya genurostris
7311890 7311890 PRJNA950981_P_NODE_21366_length_242_cov_2.905325_g21190_i0 PRJNA950981 21366 242 2.905325 7.0308865 Hydrometra stagnorum 446445 Arthropoda Arthropoda 348 2.48e-91   NTclustered gi|1131051030|gb|KX821841.1| 446445 g21190 i0 98.969 1.54545454545455 194 2 80 0 2 195 1433 1240 Hydrometra stagnorum 28S ribosomal RNA gene, partial sequence blastn 374 348 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Hydrometridae Hydrometra Hydrometra stagnorum
7640456 7640456 PRJNA950981_P_NODE_18906_length_248_cov_0.891429_g18730_i0 PRJNA950981 18906 248 0.891429 2.21074392 Daphnia 6668 Arthropoda Arthropoda 108 4.72e-19   NTclustered gi|2192762811|ref|XM_046584890.1| 6669 g18730 i0 79.747 31.116935483871 158 24 62 6 96 248 575 421 PREDICTED: Daphnia pulex GTPase HRas (LOC124191584), mRNA blastn 7717 108 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
8586809 8586809 PRJNA950981_P_NODE_14347_length_272_cov_1.537688_g14171_i0 PRJNA950981 14347 272 1.537688 4.18251136 Drosophila mojavensis 7230 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2104461840|ref|XM_032732858.2| 7230 g14171 i0 100 1.04044117647059 30 0 11 0 28 57 4267 4238 PREDICTED: Drosophila mojavensis regulatory-associated protein of mTOR (LOC6585491), transcript variant X1, mRNA blastn 283 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila mojavensis
8586811 8586811 PRJNA950981_P_NODE_16367_length_253_cov_2.166667_g16191_i0 PRJNA950981 16367 253 2.166667 5.48166751 Satyrium ilicis 876074 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2918386103|emb|OZ238124.1| 876074 g16191 i0 96.97 1.23715415019763 33 1 13 0 27 59 27495834 27495866 Satyrium ilicis genome assembly, chromosome: 15 blastn 313 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
8586823 8586823 PRJNA950981_P_NODE_19287_length_247_cov_0.896552_g19111_i0 PRJNA950981 19287 247 0.896552 2.21448344 Drosophila guanche 7266 Arthropoda Arthropoda 156 1.65e-33   NTclustered gi|1839724407|ref|XM_034274712.1| 7266 g19111 i0 78.571 5.08502024291498 238 49 96 2 6 242 1237 1001 PREDICTED: Drosophila guanche 26S proteasome regulatory subunit 6A-B (LOC117585285), mRNA blastn 1256 156 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila guanche
11137465 11137465 PRJNA950981_P_NODE_14769_length_268_cov_1.600000_g14593_i0 PRJNA950981 14769 268 1.6 4.288 Drosophila subobscura 7241 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|1847795425|ref|XM_034801081.1| 7241 g14593 i0 96.875 0.261194029850746 32 1 12 0 117 148 364 333 PREDICTED: Drosophila subobscura UPF0489 protein C5orf22 homolog (LOC117894176), mRNA blastn 70 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila subobscura
11137479 11137479 PRJNA950981_P_NODE_17789_length_250_cov_0.881356_g17613_i0 PRJNA950981 17789 250 0.881356 2.20339 Anopheles stephensi 30069 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1899753734|ref|XR_004906528.1| 30069 g17613 i0 100 0.232 29 0 12 0 185 213 715 687 PREDICTED: Anopheles stephensi protein odd-skipped (LOC118513889), transcript variant X2, misc_RNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles stephensi
13687511 13687511 PRJNA950981_P_NODE_2371_length_618_cov_1.766972_g2198_i0 PRJNA950981 2371 618 1.766972 10.91988696 Papilio polytes 76194 Arthropoda Arthropoda 411 8.78e-110   NTclustered gi|389615034|dbj|AK405121.1| 76194 g2198 i0 84.112 57.1974110032362 428 64 69 4 1 426 203 628 Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis blastn 35348 411 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
14961655 14961655 PRJNA950981_P_NODE_12532_length_290_cov_1.658986_g12356_i0 PRJNA950981 12532 290 1.658986 4.8110594 Timema poppense 170557 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1946896637|emb|OD014535.1| 170557 g12356 i0 96.97 0.113793103448276 33 1 11 0 183 215 7375 7407 1_Tps_b3v08 blastn 33 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema poppense
15290406 15290406 PRJNA950981_P_NODE_12792_length_287_cov_2.836449_g12616_i0 PRJNA950981 12792 287 2.836449 8.14060863 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 183 9.019999999999998e-42   NTclustered gi|2289132139|ref|XR_007608361.1| 42839 g12616 i0 81.013 34.8850174216028 237 39 82 5 53 286 513 746 PREDICTED: Anopheles aquasalis calmodulin (LOC126577881), transcript variant X2, misc_RNA blastn 10012 183 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles aquasalis
16236678 16236678 PRJNA950981_P_NODE_13513_length_280_cov_1.507246_g13337_i0 PRJNA950981 13513 280 1.507246 4.2202888 Nymphalis io 171585 Arthropoda Arthropoda 93.5 1.52e-14   NTclustered gi|2293920936|ref|XM_050486739.1| 171585 g13337 i0 84.211 0.553571428571429 95 15 34 0 183 277 768 674 PREDICTED: Nymphalis io 40S ribosomal protein S4 (LOC126768557), mRNA blastn 155 93.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Nymphalis Nymphalis io
16236703 16236703 PRJNA950981_P_NODE_4913_length_438_cov_1.641096_g4737_i0 PRJNA950981 4913 438 1.641096 7.18800048 Drosophila takahashii 29030 Arthropoda Arthropoda 272 2.9799999999999993e-68   NTclustered gi|2866478327|ref|XM_017154680.3| 29030 g4737 i0 80.508 13.9657534246575 354 69 81 0 13 366 494 141 PREDICTED: Drosophila takahashii RAS oncogene family member Rab2 (Rab2), mRNA blastn 6117 272 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila takahashii
18785642 18785642 PRJNA950981_P_NODE_8915_length_337_cov_1.772727_g8739_i0 PRJNA950981 8915 337 1.772727 5.97408999 Hyposmocoma kahamanoa 1477025 Arthropoda Arthropoda 97.1 1.45e-15   NTclustered gi|1483647546|ref|XM_026475158.1| 1477025 g8739 i0 90.541 30.3026706231454 74 5 22 2 108 180 399 471 PREDICTED: Hyposmocoma kahamanoa 40S ribosomal protein S16 (LOC113238317), mRNA blastn 10212 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Cosmopterigidae Hyposmocoma Hyposmocoma kahamanoa
19113860 19113860 PRJNA950981_P_NODE_21115_length_243_cov_0.917647_g20939_i0 PRJNA950981 21115 243 0.917647 2.22988221 Lepidoptera 7088 Arthropoda Arthropoda 224 4.3899999999999996e-54   NTclustered gi|2459164074|gb|ON959476.1| 51655 g20939 i0 83.673 98.0082304526749 245 33 100 5 1 243 361 122 Plutella xylostella voucher GR2589 V-type proton ATPase subunit B mRNA, partial cds blastn 23816 224 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
20060501 20060501 PRJNA950981_P_NODE_18776_length_248_cov_0.891429_g18600_i0 PRJNA950981 18776 248 0.891429 2.21074392 Cydia pomonella 82600 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2639360963|ref|XM_061858038.1| 82600 g18600 i0 100 0.112903225806452 28 0 11 0 189 216 6338 6311 PREDICTED: Cydia pomonella uncharacterized LOC133522651 (LOC133522651), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia pomonella
20060523 20060523 PRJNA950981_P_NODE_3276_length_530_cov_1.021882_g3102_i0 PRJNA950981 3276 530 1.021882 5.4159746 Anopheles stephensi 30069 Arthropoda Arthropoda 398 5.8e-106   NTclustered gi|1899743409|ref|XM_036054707.1| 30069 g3102 i0 80.407 97.6 541 90 99 13 4 530 1189 651 PREDICTED: Anopheles stephensi ATP synthase subunit alpha, mitochondrial (LOC118511519), mRNA blastn 51728 398 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles stephensi
20388783 20388783 PRJNA950981_P_NODE_18016_length_250_cov_0.881356_g17840_i0 PRJNA950981 18016 250 0.881356 2.20339 Helicoverpa 7112 Arthropoda Arthropoda 174 4.63e-39   NTclustered gi|2211680811|ref|XM_047174649.1| 7113 g17840 i0 79.365 85.332 252 48 100 4 1 250 1740 1989 PREDICTED: Helicoverpa zea translation elongation factor 2 (LOC124637920), mRNA blastn 21333 174 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa zea
20388791 20388791 PRJNA950981_P_NODE_7956_length_353_cov_2.850000_g7780_i0 PRJNA950981 7956 353 2.85 10.0605 Timema 61471 Arthropoda Arthropoda 52.8 0.033   NTclustered gi|1936955213|emb|OA567898.1| 61478 g7780 i0 100 0.237960339943343 28 0 8 0 261 288 49375 49402 1_Tdi_b3v08 blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
21335968 21335968 PRJNA950981_P_NODE_4857_length_440_cov_2.337875_g4681_i0 PRJNA950981 4857 440 2.337875 10.28665 Diuraphis noxia 143948 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|985399333|ref|XM_015511795.1| 143948 g4681 i0 100 3.14318181818182 30 0 7 0 245 274 839 868 PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA blastn 1383 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
24214125 24214125 PRJNA950981_P_NODE_6399_length_388_cov_1.196825_g6223_i0 PRJNA950981 6399 388 1.196825 4.643681 Insecta 50557 Arthropoda Arthropoda 244 5.7e-60   NTclustered gi|1028701960|ref|XM_003244000.3| 7029 g6223 i0 83.721 75.6443298969072 258 42 66 0 125 382 1002 745 PREDICTED: Acyrthosiphon pisum heat shock 70 kDa protein cognate 4 (LOC100163748), mRNA blastn 29350 244 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum

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