RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where bioproject = "PRJNA513467", tax_kingdom = "Metazoa" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 30 ✖

tax_kingdom 1

  • Metazoa · 30 ✖

tax_clade 1

bioproject 1

  • PRJNA513467 · 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
3037742 3037742 PRJNA513467_S_NODE_503_length_436_cov_2.523810_g480_i0 PRJNA513467 503 436 2.52381 11.0038116 Aedes albopictus 7160 Arthropoda Arthropoda 182 5.15e-41   NTclustered gi|2669926270|ref|XR_009999487.1| 7160 g480 i0 87.421 7.12385321100917 159 19 36 1 276 433 60 218 PREDICTED: Aedes albopictus uncharacterized LOC134292129 (LOC134292129), ncRNA blastn 3106 182 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
4313580 4313580 PRJNA513467_S_NODE_1784_length_263_cov_3.106195_g1761_i0 PRJNA513467 1784 263 3.106195 8.16929285 Artemia franciscana 6661 Arthropoda Arthropoda 364 2.719999999999999e-96   NTclustered gi|2743025959|ref|XM_065728334.1| 6661 g1761 i0 91.698 63.212927756654 265 19 100 3 1 263 7297 7560 PREDICTED: Artemia franciscana VWFA and cache domain-containing protein 1-like (LOC136043424), transcript variant X1, mRNA blastn 16625 364 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
4313605 4313605 PRJNA513467_S_NODE_3464_length_205_cov_5.226190_g3441_i0 PRJNA513467 3464 205 5.22619 10.7136895 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|2919553660|emb|OZ238364.1| 1002887 g3441 i0 96.875 0.31219512195122 32 1 16 0 61 92 24059124 24059155 Glaucopsyche melanops genome assembly, chromosome: W blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
5590466 5590466 PRJNA513467_S_NODE_1445_length_286_cov_3.522088_g1422_i0 PRJNA513467 1445 286 3.522088 10.07317168 Aedes albopictus 7160 Arthropoda Arthropoda 254 6.75e-63   NTclustered gi|2669903567|ref|XR_009997975.1| 7160 g1422 i0 99.286 51.5594405594406 140 1 49 0 147 286 13036 12897 PREDICTED: Aedes albopictus uncharacterized LOC109417952 (LOC109417952), misc_RNA blastn 14746 254 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
6864465 6864465 PRJNA513467_S_NODE_6666_length_163_cov_1.547619_g6643_i0 PRJNA513467 6666 163 1.547619 2.52261897 Callophrys avis 700180 Arthropoda Arthropoda 58.4 2.92e-4   NTclustered gi|2918383405|emb|OZ238069.1| 700180 g6643 i0 97.143 0.214723926380368 35 0 21 1 8 42 44204386 44204353 Callophrys avis genome assembly, chromosome: 2 blastn 35 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Callophrys Callophrys avis
8139739 8139739 PRJNA513467_S_NODE_3527_length_205_cov_1.136905_g3504_i0 PRJNA513467 3527 205 1.136905 2.33065525 Plodia interpunctella 58824 Arthropoda Arthropoda 379 7.229999999999999e-101   NTclustered gi|833207511|gb|KP729178.1| 58824 g3504 i0 100 99.2780487804878 205 0 100 0 1 205 12812 13016 Plodia interpunctella mitochondrion, complete genome blastn 20352 379 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pyralidae Plodia Plodia interpunctella
8139742 8139742 PRJNA513467_S_NODE_367_length_497_cov_2.236957_g344_i0 PRJNA513467 367 497 2.236957 11.11767629 Longitarsus dorsalis 346795 Arthropoda Arthropoda 54.7 0.013   NTclustered gi|2918386060|emb|OZ238103.1| 346795 g344 i0 100 0.0583501006036217 29 0 6 0 110 138 20596587 20596615 Longitarsus dorsalis genome assembly, chromosome: 10 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Longitarsus Longitarsus dorsalis
8763880 8763880 PRJNA513467_S_NODE_1107_length_317_cov_2.667857_g1084_i0 PRJNA513467 1107 317 2.667857 8.45710669 root 1 Root_unresolved Root_unresolved 580 3.0599999999999993e-161   NTclustered gi|297374834|gb|BT124959.1| 7227 g1084 i0 99.685 66.9779179810726 317 1 100 0 1 317 363 47 Drosophila melanogaster MIP22856 full insert cDNA blastn 21232 580 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
10690431 10690431 PRJNA513467_S_NODE_1769_length_264_cov_3.162996_g1746_i0 PRJNA513467 1769 264 3.162996 8.35030944 Helicoverpa assulta 52344 Arthropoda Arthropoda 388 1.62e-103   NTclustered gi|2636206762|emb|OY979788.1| 52344 g1746 i0 94.118 3.03787878787879 255 15 97 0 1 255 4825344 4825598 Helicoverpa assulta genome assembly, chromosome: 14 blastn 802 388 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa assulta
10690457 10690457 PRJNA513467_S_NODE_4429_length_189_cov_1.105263_g4406_i0 PRJNA513467 4429 189 1.105263 2.08894707 Chironomus tentans 7153 Arthropoda Arthropoda 114 7.79e-28   NR AAN85117.1 7153 g4406 i0 93.3 1.9047619047619 60 4 95.2 0 10 189 298 357 AAN85117.1 HSP70 [Chironomus tentans] diamond 360 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tentans
10690481 10690481 PRJNA513467_S_NODE_6409_length_165_cov_3.632812_g6386_i0 PRJNA513467 6409 165 3.632812 5.9941398 Aphis gossypii 80765 Arthropoda Arthropoda 279 5.81e-71   NTclustered gi|2288470269|ref|XM_050197869.1| 80765 g6386 i0 97.576 36.3454545454545 165 0 100 1 1 165 4985 4825 PREDICTED: Aphis gossypii maternal protein pumilio (LOC114121075), transcript variant X12, mRNA blastn 5997 279 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis gossypii
14515640 14515640 PRJNA513467_S_NODE_6212_length_167_cov_2.023077_g6189_i0 PRJNA513467 6212 167 2.023077 3.37853859 Aphis gossypii 80765 Arthropoda Arthropoda 106 1.06e-18   NTclustered gi|2288459907|ref|XM_027993885.2| 80765 g6189 i0 80.795 4.81437125748503 151 16 83 4 9 146 1548 1698 PREDICTED: Aphis gossypii cathepsin B-like (LOC114129225), mRNA blastn 804 106 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis gossypii
15789374 15789374 PRJNA513467_S_NODE_293_length_537_cov_2.646000_g270_i0 PRJNA513467 293 537 2.646 14.20902 Spodoptera frugiperda 7108 Arthropoda Arthropoda 987 0   NTclustered gi|2306752270|ref|XM_035582592.2| 7108 g270 i0 99.814 7.25512104283054 537 1 100 0 1 537 12130 12666 PREDICTED: Spodoptera frugiperda uncharacterized LOC118268191 (LOC118268191), transcript variant X1, mRNA blastn 3896 987 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
15789391 15789391 PRJNA513467_S_NODE_4313_length_190_cov_2.712418_g4290_i0 PRJNA513467 4313 190 2.712418 5.1535942 Culex pipiens 7175 Arthropoda Arthropoda 80.5 7.49e-11   NTclustered gi|2415566954|ref|XR_005607420.2| 42434 g4290 i0 91.379 0.305263157894737 58 5 31 0 133 190 3826 3883 PREDICTED: Culex pipiens pallens uncharacterized LOC120429514 (LOC120429514), ncRNA blastn 58 80.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex pipiens
17063951 17063951 PRJNA513467_S_NODE_5674_length_173_cov_1.147059_g5651_i0 PRJNA513467 5674 173 1.147059 1.98441207 Chironomus tepperi 113505 Arthropoda Arthropoda 115 1.8300000000000003e-21   NTclustered gi|2874197127|ref|XM_070652520.1| 113505 g5651 i0 97.059 1.96531791907514 68 2 39 0 17 84 615 682 PREDICTED: Chironomus tepperi histone deacetylase 4 (HDAC4), transcript variant X5, mRNA blastn 340 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tepperi
18338328 18338328 PRJNA513467_S_NODE_3055_length_215_cov_2.550562_g3032_i0 PRJNA513467 3055 215 2.550562 5.4837083 Periplaneta americana 6978 Arthropoda Arthropoda 89.8 1.44e-13   NTclustered gi|2852142652|ref|XM_069819516.1| 6978 g3032 i0 79.104 0.623255813953488 134 24 61 4 4 135 1115 984 PREDICTED: Periplaneta americana disintegrin and metalloproteinase domain-containing protein mind-meld (mmd), mRNA blastn 134 89.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
19612760 19612760 PRJNA513467_S_NODE_7596_length_156_cov_1.226891_g7573_i0 PRJNA513467 7596 156 1.226891 1.91394996 Aedes albopictus 7160 Arthropoda Arthropoda 80.5 5.89e-11   NTclustered gi|2669907072|ref|XM_062854582.1| 7160 g7573 i0 76.786 1.07692307692308 168 23 99 8 3 156 13835 13670 PREDICTED: Aedes albopictus uncharacterized LOC134288752 (LOC134288752), mRNA blastn 168 80.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
20237336 20237336 PRJNA513467_S_NODE_2916_length_219_cov_1.500000_g2893_i0 PRJNA513467 2916 219 1.5 3.285 Tetranychidae 32262 Arthropoda Arthropoda 241 3.85e-59   NTclustered gi|1390646155|ref|XR_003082109.1| 32264 g2893 i0 100 76.8447488584475 130 0 100 0 1 130 723 852 PREDICTED: Tetranychus urticae small subunit ribosomal RNA (LOC112538762), rRNA blastn 16829 241 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
20888795 20888795 PRJNA513467_S_NODE_5697_length_172_cov_3.755556_g5674_i0 PRJNA513467 5697 172 3.755556 6.45955632 Agapeta hamana 1100904 Arthropoda Arthropoda 71.3 3.98e-8   NTclustered gi|2918369971|emb|OZ237863.1| 1100904 g5674 i0 95.455 5.52906976744186 44 2 26 0 1 44 22093233 22093190 Agapeta hamana genome assembly, chromosome: 4 blastn 951 71.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Agapeta Agapeta hamana
23439088 23439088 PRJNA513467_S_NODE_1459_length_285_cov_3.104839_g1436_i0 PRJNA513467 1459 285 3.104839 8.84879115 Aedes albopictus 7160 Arthropoda Arthropoda 279 1.11e-70   NTclustered gi|2669941564|ref|XR_009996299.1| 7160 g1436 i0 85.252 2.70526315789474 278 34 96 7 12 285 9799 10073 PREDICTED: Aedes albopictus uncharacterized LOC134285338 (LOC134285338), ncRNA blastn 771 279 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
27330149 27330149 PRJNA513467_S_NODE_2203_length_243_cov_1.466019_g2180_i0 PRJNA513467 2203 243 1.466019 3.56242617 Polyplax serrata 468196 Arthropoda Arthropoda 94.7 1.1e-20   NR KAK6633287.1 468196 g2180 i0 63.6 1.91358024691358 77 23 95.1 1 231 1 90 161 KAK6633287.1 hypothetical protein RUM44_003888 [Polyplax serrata] diamond 465 94.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
27330150 27330150 PRJNA513467_S_NODE_7103_length_159_cov_1.918033_g7080_i0 PRJNA513467 7103 159 1.918033 3.04967247 Polyplax serrata 468196 Arthropoda Arthropoda 88.6 8.25e-19   NR KAK6637229.1 468196 g7080 i0 88.5 1.9622641509434 52 6 98.1 0 3 158 837 888 KAK6637229.1 hypothetical protein RUM44_007643 [Polyplax serrata] diamond 312 88.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
28624821 28624821 PRJNA513467_S_NODE_6927_length_161_cov_1.258065_g6904_i0 PRJNA513467 6927 161 1.258065 2.02548465 Pediculus humanus corporis 121224 Arthropoda Arthropoda 98.6 2.4e-25   NR XP_002429279.1 121224 g6904 i0 86.8 0.987577639751553 53 7 98.8 0 159 1 2 54 XP_002429279.1 uncharacterized protein Phum_PHUM426160 [Pediculus humanus corporis] diamond 159 98.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Pediculidae Pediculus Pediculus humanus
28656301 28656301 PRJNA513467_S_NODE_8407_length_150_cov_1.805310_g8384_i0 PRJNA513467 8407 150 1.80531 2.707965 Cyamophila willieti 2604842 Arthropoda Arthropoda 46.6 3.19e-5   NR KAL1463159.1 2604842 g8384 i0 81.5 0.54 27 5 54 0 145 65 20 46 KAL1463159.1 hypothetical protein WDU94_014940, partial [Cyamophila willieti] diamond 81 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Cyamophila Cyamophila willieti
29887744 29887744 PRJNA513467_S_NODE_3291_length_209_cov_2.267442_g3268_i0 PRJNA513467 3291 209 2.267442 4.73895378 Trichogramma kaykai 54128 Arthropoda Arthropoda 77 2.52e-15   NR KAL3398246.1 54128 g3268 i0 73.7 1.63636363636364 57 14 80.4 1 168 1 111 167 KAL3398246.1 hypothetical protein TKK_008446 [Trichogramma kaykai] diamond 342 77 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma kaykai
30456676 30456676 PRJNA513467_S_NODE_1253_length_301_cov_3.276515_g1230_i0 PRJNA513467 1253 301 3.276515 9.86231015 Pediculus humanus corporis 121224 Arthropoda Arthropoda 112 2.56e-26   NR XP_002426469.1 121224 g1230 i0 87.9 0.578073089700997 58 7 57.8 0 50 223 778 835 XP_002426469.1 uncharacterized protein Phum_PHUM255010 [Pediculus humanus corporis] diamond 174 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Pediculidae Pediculus Pediculus humanus
30740605 30740605 PRJNA513467_S_NODE_6314_length_166_cov_2.418605_g6291_i0 PRJNA513467 6314 166 2.418605 4.0148843 Anastrepha obliqua 95512 Arthropoda Arthropoda 41.6 0.0334   NR XP_054746255.1 95512 g6291 i0 40.6 0.578313253012048 32 19 57.8 0 149 54 77 108 XP_054746255.1 uncharacterized protein K02A2.6-like [Anastrepha obliqua] diamond 96 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Anastrepha Anastrepha obliqua
31735906 31735906 PRJNA513467_S_NODE_1717_length_268_cov_2.194805_g1694_i0 PRJNA513467 1717 268 2.194805 5.8820774 Arthropoda 6656 Arthropoda Arthropoda 67.8 1.23e-11   NR KAK8371844.1 85552 g1694 i0 42.9 5.08208955223881 91 49 98.5 2 5 268 1 91 KAK8371844.1 hypothetical protein O3P69_019821 [Scylla paramamosain] diamond 1362 67.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
31847096 31847096 PRJNA513467_S_NODE_6037_length_169_cov_1.386364_g6014_i0 PRJNA513467 6037 169 1.386364 2.34295516 Polypedilum vanderplanki 319348 Arthropoda Arthropoda 63.9 2.98e-11   NR KAG5680192.1 319348 g6014 i0 100 0.568047337278107 32 0 56.8 0 169 74 90 121 KAG5680192.1 putative 30S ribosomal protein S10 [Polypedilum vanderplanki] diamond 96 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
32480188 32480188 PRJNA513467_S_NODE_1819_length_261_cov_2.714286_g1796_i0 PRJNA513467 1819 261 2.714286 7.08428646 Aphis glycines 307491 Arthropoda Arthropoda 111 2.77e-26   NR KAE9523856.1 307491 g1796 i0 90 0.689655172413793 60 6 69 0 259 80 1236 1295 KAE9523856.1 hypothetical protein AGLY_015744 [Aphis glycines] diamond 180 111 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis glycines

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