RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "blastn", bioproject = "PRJNA724039" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA724039 · 21 ✖

analysis 1

  • blastn · 21 ✖
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
1987170 1987170 PRJNA724039_S_NODE_18202_length_150_cov_1.044248_g17995_i0 PRJNA724039 18202 150 1.044248 1.566372 Culicoides sonorensis 179676 Arthropoda Arthropoda 159 7e-35   NTclustered gi|56199551|gb|AY752852.1| 179676 g17995 i0 92.035 106.6 113 9 75 0 12 124 543 431 Culicoides sonorensis clone CsUB1 ubiquitin mRNA, complete cds blastn 15990 159 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides sonorensis
1987244 1987244 PRJNA724039_S_NODE_5602_length_292_cov_19.282353_g5395_i0 PRJNA724039 5602 292 19.282353 56.30447076 Boletoglyphus extremiorientalis 1111179 Arthropoda Arthropoda 71.3 7.47e-8   NTclustered gi|386696246|gb|JQ000419.1| 1111179 g5395 i0 79.646 19.4246575342466 113 12 37 8 21 129 1788 1683 Boletoglyphus extremiorientalis voucher UMMZ BMOC 01-0922-001 AD321 28S ribosomal RNA gene, partial sequence blastn 5672 71.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Boletoglyphus Boletoglyphus extremiorientalis
2469470 2469470 PRJNA724039_S_NODE_16342_length_157_cov_10.166667_g16135_i0 PRJNA724039 16342 157 10.166667 15.96166719 Bombyx 7090 Arthropoda Arthropoda 291 2.52e-74   NTclustered gi|2895205027|dbj|AP039410.1| 7091 g16135 i0 100 185.528662420382 157 0 100 0 1 157 8652519 8652675 Bombyx mori DNA, chromosome 22, sequence blastn 29128 291 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
3262435 3262435 PRJNA724039_S_NODE_17203_length_154_cov_1.239316_g16996_i0 PRJNA724039 17203 154 1.239316 1.90854664 Drosophila novamexicana 47314 Arthropoda Arthropoda 104 3.44e-18   NTclustered gi|1732857244|ref|XM_030700911.1| 47314 g16996 i0 89.286 1.27272727272727 84 7 54 2 59 141 202 284 PREDICTED: Drosophila novamexicana 40S ribosomal protein S2 (LOC115759819), mRNA blastn 196 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila novamexicana
6298161 6298161 PRJNA724039_S_NODE_10745_length_197_cov_2.118750_g10538_i0 PRJNA724039 10745 197 2.11875 4.1739375 root 1 Root_unresolved Root_unresolved 364 1.929999999999999e-96   NTclustered gi|442619164|ref|NM_001275657.1| 7227 g10538 i0 100 98.3756345177665 197 0 100 0 1 197 1616 1812 Drosophila melanogaster heat shock protein 70 cognate 4, transcript variant G (Hsc70-4), mRNA blastn 19380 364 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
7090025 7090025 PRJNA724039_S_NODE_7826_length_238_cov_1.343284_g7619_i0 PRJNA724039 7826 238 1.343284 3.19701592 Scaptodrosophila lebanonensis 7225 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1729025016|ref|XM_030514821.1| 7225 g7619 i0 96.97 0.415966386554622 33 1 14 0 35 67 946 978 PREDICTED: Scaptodrosophila lebanonensis broad-complex core protein (LOC115621231), transcript variant X2, mRNA blastn 99 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Scaptodrosophila Scaptodrosophila lebanonensis
7572063 7572063 PRJNA724039_S_NODE_8886_length_220_cov_2.338798_g8679_i0 PRJNA724039 8886 220 2.338798 5.1453556 Trombidiformes 83136 Arthropoda Arthropoda 154 5.19e-33   NTclustered gi|2240866599|gb|ON555714.1| 109366 g8679 i0 90 52.5318181818182 120 10 54 2 85 202 2588 2707 Aceria tulipae isolate AS197 large subunit ribosomal RNA gene, partial sequence blastn 11557 154 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eriophyidae Aceria Aceria tulipae
8364519 8364519 PRJNA724039_S_NODE_5047_length_312_cov_1.912727_g4840_i0 PRJNA724039 5047 312 1.912727 5.96770824 Hermetia illucens 343691 Arthropoda Arthropoda 300 9.44e-77   NTclustered gi|1941250953|ref|XM_038066025.1| 343691 g4840 i0 84.026 177.560897435897 313 48 100 2 1 312 1938 1627 PREDICTED: Hermetia illucens polyubiquitin-C (LOC119658576), transcript variant X2, mRNA blastn 55399 300 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Stratiomyidae Hermetia Hermetia illucens
8847147 8847147 PRJNA724039_S_NODE_14847_length_165_cov_4.632812_g14640_i0 PRJNA724039 14847 165 4.632812 7.6441398 Aphididae 27482 Arthropoda Arthropoda 305 9.59e-79   NTclustered gi|2720500858|gb|PP706360.1| 38111 g14640 i0 100 99.8666666666667 165 0 100 0 1 165 12216 12380 Schlechtendalia chinensis isolate A4613-47 mitochondrion, complete genome blastn 16478 305 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Schlechtendalia Schlechtendalia chinensis
10915188 10915188 PRJNA724039_S_NODE_16389_length_157_cov_2.825000_g16182_i0 PRJNA724039 16389 157 2.825 4.43525 Notodromas monacha 399045 Arthropoda Arthropoda 161 2.06e-35   NTclustered gi|1938163022|emb|OA938627.1| 399045 g16182 i0 86 8.13375796178344 150 21 96 0 5 154 157 306 Notodromas monacha blastn 1277 161 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
12190392 12190392 PRJNA724039_S_NODE_13730_length_172_cov_8.392593_g13523_i0 PRJNA724039 13730 172 8.392593 14.43525996 Platynothrus peltifer 128015 Arthropoda Arthropoda 119 1.4000000000000002e-22   NTclustered gi|2579718317|gb|CP133306.1| 128015 g13523 i0 82.734 5.06976744186047 139 19 80 4 36 172 6931196 6931331 Platynothrus peltifer isolate 155_3 chromosome 1 blastn 872 119 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Camisiidae Platynothrus Platynothrus peltifer
13464852 13464852 PRJNA724039_S_NODE_13111_length_177_cov_1.371429_g12904_i0 PRJNA724039 13111 177 1.371429 2.42742933 Centruroides vittatus 120091 Arthropoda Arthropoda 119 1.45e-22   NTclustered gi|2786507285|ref|XM_067271922.1| 120091 g12904 i0 84.298 7.09604519774011 121 19 68 0 57 177 411 291 PREDICTED: Centruroides vittatus histone H3 (LOC136976593), mRNA blastn 1256 119 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides vittatus
15222765 15222765 PRJNA724039_S_NODE_5952_length_282_cov_3.518367_g5745_i0 PRJNA724039 5952 282 3.518367 9.92179494 root 1 Root_unresolved Root_unresolved 521 1.6499999999999996e-143   NTclustered gi|442619164|ref|NM_001275657.1| 7227 g5745 i0 100 99.7198581560284 282 0 100 0 1 282 949 1230 Drosophila melanogaster heat shock protein 70 cognate 4, transcript variant G (Hsc70-4), mRNA blastn 28121 521 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
17289228 17289228 PRJNA724039_S_NODE_4294_length_342_cov_2.849180_g4087_i0 PRJNA724039 4294 342 2.84918 9.7441956 Shevtchenkella serrata 2883626 Arthropoda Arthropoda 91.6 6.85e-14   NTclustered gi|2112782721|gb|OK491613.1| 2883626 g4087 i0 84.211 20.6929824561403 95 13 27 2 91 184 1875 1968 Shevtchenkella serrata isolate d241proto large subunit ribosomal RNA gene, partial sequence blastn 7077 91.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eriophyidae Shevtchenkella Shevtchenkella serrata
17771851 17771851 PRJNA724039_S_NODE_12054_length_185_cov_2.547297_g11847_i0 PRJNA724039 12054 185 2.547297 4.71249945 root 1 Root_unresolved Root_unresolved 287 3.98e-73   NTclustered gi|1829500288|ref|XM_033306395.1| 7226 g11847 i0 96.023 91.0054054054054 176 7 95 0 2 177 363 188 PREDICTED: Drosophila mauritiana heat shock 70 kDa protein cognate 4 (LOC117142434), mRNA blastn 16836 287 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila mauritiana
18562852 18562852 PRJNA724039_S_NODE_15295_length_163_cov_1.928571_g15088_i0 PRJNA724039 15295 163 1.928571 3.14357073 Culicoides brevitarsis 469753 Arthropoda Arthropoda 121 3.669999999999999e-23   NTclustered gi|2701314687|ref|XM_063847108.1| 469753 g15088 i0 80.892 15.3558282208589 157 26 95 4 4 158 1518 1672 PREDICTED: Culicoides brevitarsis eukaryotic translation elongation factor 2 (LOC134832902), mRNA blastn 2503 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides brevitarsis
21113684 21113684 PRJNA724039_S_NODE_15657_length_161_cov_2.024194_g15450_i0 PRJNA724039 15657 161 2.024194 3.25895234 Hydrometra stagnorum 446445 Arthropoda Arthropoda 220 3.46e-53   NTclustered gi|1131051030|gb|KX821841.1| 446445 g15450 i0 98.4 1.46583850931677 125 2 78 0 1 125 1364 1240 Hydrometra stagnorum 28S ribosomal RNA gene, partial sequence blastn 236 220 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Hydrometridae Hydrometra Hydrometra stagnorum
21596410 21596410 PRJNA724039_S_NODE_4837_length_319_cov_7.755319_g4630_i0 PRJNA724039 4837 319 7.755319 24.73946761 Aphididae 27482 Arthropoda Arthropoda 584 2.38e-162   NTclustered gi|2720500858|gb|PP706360.1| 38111 g4630 i0 99.687 100.391849529781 319 1 100 0 1 319 12133 11815 Schlechtendalia chinensis isolate A4613-47 mitochondrion, complete genome blastn 32025 584 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Schlechtendalia Schlechtendalia chinensis
22388548 22388548 PRJNA724039_S_NODE_17758_length_151_cov_4.596491_g17551_i0 PRJNA724039 17758 151 4.596491 6.94070141 Hyalella azteca 294128 Arthropoda Arthropoda 274 2.42e-69   NTclustered gi|2232419545|ref|XR_007157289.1| 294128 g17551 i0 99.338 86.6556291390728 151 1 100 0 1 151 353 203 PREDICTED: Hyalella azteca large subunit ribosomal RNA (LOC125179508), rRNA blastn 13085 274 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Hyalellidae Hyalella Hyalella azteca
23664144 23664144 PRJNA724039_S_NODE_14459_length_168_cov_1.190840_g14252_i0 PRJNA724039 14459 168 1.19084 2.0006112 Penaeus japonicus 27405 Arthropoda Arthropoda 126 8.2e-25   NTclustered gi|2080935983|ref|XM_043014244.1| 27405 g14252 i0 84.8 17.2380952380952 125 19 74 0 43 167 745 621 PREDICTED: Penaeus japonicus 40S ribosomal protein S5 (LOC122251976), transcript variant X1, mRNA blastn 2896 126 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus japonicus
25420681 25420681 PRJNA724039_S_NODE_13620_length_173_cov_3.323529_g13413_i0 PRJNA724039 13620 173 3.323529 5.74970517 Bombyx 7090 Arthropoda Arthropoda 316 4.67e-82   NTclustered gi|2919985562|emb|OZ208535.1| 7091 g13413 i0 100 7.90751445086705 171 0 99 0 3 173 3455457 3455287 Bombyx mori genome assembly, chromosome: 15 blastn 1368 316 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori

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