RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA833575" 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

  • PRJNA833575 · 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
3375460 3375460 PRJNA833575_P_NODE_8443_length_491_cov_4.464455_g8306_i0 PRJNA833575 8443 491 4.464455 21.92047405 Portunus trituberculatus 210409 Arthropoda Arthropoda 327 7.11e-85   NTclustered gi|2159654136|ref|XM_045257944.1| 210409 g8306 i0 80 88.2016293279022 450 84 91 5 45 491 525 79 PREDICTED: Portunus trituberculatus ubiquitin-40S ribosomal protein S27a (LOC123506082), mRNA blastn 43307 327 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
4652606 4652606 PRJNA833575_P_NODE_23184_length_308_cov_2.451883_g23047_i0 PRJNA833575 23184 308 2.451883 7.55179964 Drosophila gunungcola 103775 Arthropoda Arthropoda 89.8 2.19e-13   NTclustered gi|2427851622|ref|XM_052986541.1| 103775 g23047 i0 87.342 8.43831168831169 79 8 25 2 201 278 205 128 PREDICTED: Drosophila gunungcola 60S ribosomal protein L29 (LOC128256259), transcript variant X1, mRNA blastn 2599 89.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila gunungcola
7202384 7202384 PRJNA833575_P_NODE_18946_length_338_cov_2.096654_g18809_i0 PRJNA833575 18946 338 2.096654 7.08669052 Galendromus occidentalis 34638 Arthropoda Arthropoda 159 1.83e-34   NTclustered gi|391333711|ref|XM_003741206.1| 34638 g18809 i0 77.049 2.45266272189349 305 52 89 12 39 338 121 412 PREDICTED: Metaseiulus occidentalis 60S acidic ribosomal protein P1 (LOC100897241), mRNA blastn 829 159 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
7202739 7202739 PRJNA833575_P_NODE_40866_length_232_cov_1.110429_g40729_i0 PRJNA833575 40866 232 1.110429 2.57619528 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.021   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g40729 i0 100 0.120689655172414 28 0 12 0 87 114 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
7606772 7606772 PRJNA833575_P_NODE_18066_length_346_cov_1.335740_g17929_i0 PRJNA833575 18066 346 1.33574 4.6216604 Opisthokonta 33154 Arthropoda Arthropoda 204 8.539999999999999e-48   NTclustered gi|2273959266|ref|XM_011210182.4| 27457 g17929 i0 82.008 57.6849710982659 239 43 69 0 9 247 434 196 PREDICTED: Bactrocera dorsalis 40S ribosomal protein S14a (LOC105229748), mRNA blastn 19959 204 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera dorsalis
8477165 8477165 PRJNA833575_P_NODE_29887_length_272_cov_1.123153_g29750_i0 PRJNA833575 29887 272 1.123153 3.05497616 Drosophila montana 40370 Arthropoda Arthropoda 126 1.45e-24   NTclustered gi|2721924556|ref|XM_064686397.1| 40370 g29750 i0 80.702 10.8639705882353 171 26 61 5 98 263 531 699 PREDICTED: Drosophila montana peptidyl-prolyl cis-trans isomerase Fkb14 (Fkbp14), transcript variant X2, mRNA blastn 2955 126 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila montana
8882153 8882153 PRJNA833575_P_NODE_39767_length_234_cov_0.872727_g39630_i0 PRJNA833575 39767 234 0.872727 2.04218118 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 207 4.23e-49   NTclustered gi|2154306794|ref|XM_032925012.2| 35525 g39630 i0 90.909 66.7692307692308 154 14 66 0 3 156 1178 1331 PREDICTED: Daphnia magna actin, muscle (LOC116919128), mRNA blastn 15624 209 0.990430622009569 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
11028159 11028159 PRJNA833575_P_NODE_34769_length_250_cov_1.480663_g34632_i0 PRJNA833575 34769 250 1.480663 3.7016575 Mylabris cichorii 580878 Arthropoda Arthropoda 183 7.7e-42   NTclustered gi|379771651|gb|JQ180217.1| 580878 g34632 i0 86.667 127.436 165 22 66 0 86 250 180 16 Mylabris cichorii ubiquitin C mRNA, partial cds blastn 31859 183 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Meloidae Mylabris Mylabris cichorii
13982707 13982707 PRJNA833575_P_NODE_25011_length_297_cov_2.951754_g24874_i0 PRJNA833575 25011 297 2.951754 8.76670938 Stegana 188292 Arthropoda Arthropoda 243 1.53e-59   NTclustered gi|1706954857|gb|MH426053.1| 1127308 g24874 i0 82.784 82.340067340067307 273 45 92 2 26 297 1049 778 Stegana aotsukai isolate 1945 ATP synthase subunit alpha (atpA) gene, partial cds blastn 24455 243 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Stegana Stegana aotsukai
14852591 14852591 PRJNA833575_P_NODE_45772_length_227_cov_0.911392_g45635_i0 PRJNA833575 45772 227 0.911392 2.06885984 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g45635 i0 100 0.13215859030837 30 0 13 0 140 169 14100601 14100630 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
16126941 16126941 PRJNA833575_P_NODE_31533_length_265_cov_0.882653_g31396_i0 PRJNA833575 31533 265 0.882653 2.33903045 Drosophila obscura 7282 Arthropoda Arthropoda 235 2.24e-57   NTclustered gi|2038059695|ref|XM_022364367.2| 7282 g31396 i0 83.268 35.7358490566038 257 41 97 2 1 256 378 123 PREDICTED: Drosophila obscura cdc42 homolog (LOC111072466), mRNA blastn 9470 235 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila obscura
17402583 17402583 PRJNA833575_P_NODE_27194_length_285_cov_2.722222_g27057_i0 PRJNA833575 27194 285 2.722222 7.7583327 Rhipicephalus sanguineus 34632 Arthropoda Arthropoda 172 1.94e-38   NTclustered gi|2272995034|ref|XM_037652366.2| 34632 g27057 i0 81.69 30.8456140350877 213 33 74 5 46 255 145 354 PREDICTED: Rhipicephalus sanguineus 60S ribosomal protein L27a (LOC119384082), mRNA blastn 8791 172 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus sanguineus
17806560 17806560 PRJNA833575_P_NODE_42174_length_231_cov_0.888889_g42037_i0 PRJNA833575 42174 231 0.888889 2.05333359 Timema 61471 Arthropoda Arthropoda 52.8 0.021   NTclustered gi|1936909922|emb|OA565991.1| 61478 g42037 i0 100 0.242424242424242 28 0 12 0 187 214 128453 128480 1_Tdi_b3v08 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
18675660 18675660 PRJNA833575_P_NODE_30555_length_269_cov_1.080000_g30418_i0 PRJNA833575 30555 269 1.08 2.9052 Turesis theste 355190 Arthropoda Arthropoda 193 1.39e-44   NTclustered gi|2567322312|gb|OK804982.1| 355190 g30418 i0 79.775 33.1226765799257 267 52 99 2 2 267 706 971 Turesis theste voucher UMD:05-SRNP-23567 heat shock cognate protein gene, partial cds blastn 8910 193 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Hesperiidae Turesis Turesis theste
18675715 18675715 PRJNA833575_P_NODE_34135_length_253_cov_1.173913_g33998_i0 PRJNA833575 34135 253 1.173913 2.96999989 Pseudonascus paulliniae 355007 Arthropoda Arthropoda 193 1.3e-44   NTclustered gi|2569056269|gb|OL118925.1| 355007 g33998 i0 84 56.2608695652174 200 32 79 0 52 251 244 443 Pseudonascus paulliniae voucher MGCL:639 delta-aminolevulinic acid dehydratase gene, partial cds blastn 14234 193 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Hesperiidae Pseudonascus Pseudonascus paulliniae
19950576 19950576 PRJNA833575_P_NODE_17296_length_353_cov_1.549296_g17159_i0 PRJNA833575 17296 353 1.549296 5.46901488 Drosophila subpulchrella 1486046 Arthropoda Arthropoda 196 1.4599999999999998e-45   NTclustered gi|1934935444|ref|XM_037859966.1| 1486046 g17159 i0 77.576 29.4022662889518 330 70 93 4 2 329 483 156 PREDICTED: Drosophila subpulchrella 60S ribosomal protein L18a (LOC119550941), mRNA blastn 10379 196 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila subpulchrella
21226649 21226649 PRJNA833575_P_NODE_5377_length_608_cov_3.285714_g5241_i0 PRJNA833575 5377 608 3.285714 19.97714112 Tetranychus urticae 32264 Arthropoda Arthropoda 93.5 3.55e-14   NTclustered gi|1005939175|ref|XM_015926337.1| 32264 g5241 i0 73.913 0.529605263157895 253 56 41 9 251 498 310 557 PREDICTED: Tetranychus urticae 40S ribosomal protein S16 (LOC107359766), mRNA blastn 322 93.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
21631049 21631049 PRJNA833575_P_NODE_41097_length_232_cov_0.883436_g40960_i0 PRJNA833575 41097 232 0.883436 2.04957152 Timema 61471 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1936893637|emb|OA565187.1| 61478 g40960 i0 96.97 0.28448275862069 33 0 14 1 169 200 111732 111764 1_Tdi_b3v08 blastn 66 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
22500862 22500862 PRJNA833575_P_NODE_15398_length_373_cov_1.447368_g15261_i0 PRJNA833575 15398 373 1.447368 5.39868264 Chelonus insularis 460826 Arthropoda Arthropoda 259 1.95e-64   NTclustered gi|1860466846|ref|XM_035077687.1| 460826 g15261 i0 80.523 102.302949061662 344 62 92 4 1 342 949 609 PREDICTED: Chelonus insularis polyubiquitin-like (LOC118063608), mRNA blastn 38159 259 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Chelonus Chelonus insularis
25050501 25050501 PRJNA833575_P_NODE_25180_length_296_cov_4.837004_g25043_i0 PRJNA833575 25180 296 4.837004 14.31753184 Panonychus citri 50023 Arthropoda Arthropoda 307 5.31e-79   NTclustered gi|2437591841|ref|XM_053346993.1| 50023 g25043 i0 86.063 181.415540540541 287 39 97 1 2 288 404 119 PREDICTED: Panonychus citri polyubiquitin-B (LOC128387730), mRNA blastn 53699 307 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri

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