RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA859990", 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 · 23 ✖

tax_kingdom 1

  • Metazoa · 23 ✖

tax_clade 1

bioproject 1

  • PRJNA859990 · 23 ✖
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
845760 845760 PRJNA859990_S_NODE_10141_length_319_cov_0.939024_g9880_i0 PRJNA859990 10141 319 0.939024 2.99548656 Notodromas monacha 399045 Arthropoda Arthropoda 579 1.1099999999999996e-160   NTclustered gi|1938042149|emb|OA887576.1| 399045 g9880 i0 99.373 36.7868338557994 319 2 100 0 1 319 6107 6425 Notodromas monacha blastn 11735 579 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
3396598 3396598 PRJNA859990_S_NODE_18963_length_248_cov_1.022857_g18702_i0 PRJNA859990 18963 248 1.022857 2.53668536 Aphis gossypii 80765 Arthropoda Arthropoda 193 1.27e-44   NTclustered gi|2288461614|ref|XM_050199667.1| 80765 g18702 i0 96.552 2.35483870967742 116 4 47 0 1 116 1002 1117 PREDICTED: Aphis gossypii peroxidase-like (LOC114123417), transcript variant X2, mRNA blastn 584 193 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis gossypii
4674310 4674310 PRJNA859990_S_NODE_16664_length_258_cov_0.891892_g16403_i0 PRJNA859990 16664 258 0.891892 2.30108136 Gammarus fossarum 52638 Arthropoda Arthropoda 305 1.63e-78   NTclustered gi|1494245712|gb|MF940257.1| 52638 g16403 i0 89.831 78.3643410852713 236 24 91 0 15 250 236 1 Gammarus fossarum beta-actin mRNA, partial cds blastn 20218 305 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Gammaridae Gammarus Gammarus fossarum
5064083 5064083 PRJNA859990_S_NODE_13544_length_282_cov_2.215311_g13283_i0 PRJNA859990 13544 282 2.215311 6.24717702 Metazoa 33208 Arthropoda Arthropoda 494 3.6e-135   NTclustered gi|291010557|gb|GQ131934.1| 79674 g13283 i0 98.227 100.248226950355 282 5 100 0 1 282 82 363 Macrobrachium rosenbergii 18S ribosomal RNA gene, partial sequence blastn 28270 494 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium rosenbergii
6340010 6340010 PRJNA859990_S_NODE_14045_length_278_cov_1.629268_g13784_i0 PRJNA859990 14045 278 1.629268 4.52936504 Palaemon 117982 Arthropoda Arthropoda 287 6.44e-73   NTclustered gi|9367094|gb|AF169742.1| 117983 g13784 i0 85.813 45.8057553956835 289 17 100 13 1 278 115 390 Palaemon serenus large subunit ribosomal RNA gene, partial sequence blastn 12734 287 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Palaemon Palaemon serenus
7224121 7224121 PRJNA859990_S_NODE_22666_length_235_cov_3.074074_g22405_i0 PRJNA859990 22666 235 3.074074 7.2240739 Medioppia subpectinata 1979941 Arthropoda Arthropoda 60.2 1.26e-4   NTclustered gi|1962536607|emb|OC867504.1| 1979941 g22405 i0 100 0.136170212765957 32 0 14 0 140 171 744 713 Medioppia subpectinata blastn 32 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
10164573 10164573 PRJNA859990_S_NODE_14288_length_276_cov_1.541872_g14027_i0 PRJNA859990 14288 276 1.541872 4.25556672 Macrobrachium 6696 Arthropoda Arthropoda 510 3.48e-140   NTclustered gi|1824641322|gb|MT248204.1| 79674 g14027 i0 100 99.9927536231884 276 0 100 0 1 276 498 223 Macrobrachium rosenbergii voucher MP00045_M115 small subunit ribosomal RNA gene, partial sequence blastn 27598 510 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium rosenbergii
11049466 11049466 PRJNA859990_S_NODE_1309_length_762_cov_32.780842_g410_i1 PRJNA859990 1309 762 32.780842 249.79001604 Diuraphis noxia 143948 Arthropoda Arthropoda 56.5 0.006   NTclustered gi|985399333|ref|XM_015511795.1| 143948 g410 i1 100 0.204724409448819 30 0 4 0 175 204 868 839 PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA blastn 156 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
11049517 11049517 PRJNA859990_S_NODE_17709_length_251_cov_2.078652_g17448_i0 PRJNA859990 17709 251 2.078652 5.21741652 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|1964523603|emb|OE844453.1| 629358 g17448 i0 96.875 0.127490039840637 32 0 12 1 49 79 437 406 5_Tge_b3v08 blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
13599598 13599598 PRJNA859990_S_NODE_19671_length_246_cov_1.526012_g19410_i0 PRJNA859990 19671 246 1.526012 3.75398952 Procambarus clarkii 6728 Arthropoda Arthropoda 278 3.37e-70   NTclustered gi|854959472|gb|KM624016.1| 6728 g19410 i0 87.764 73.8292682926829 237 29 96 0 8 244 894 1130 Procambarus clarkii elongation factor 1-alpha mRNA, partial cds blastn 18162 278 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
14873971 14873971 PRJNA859990_S_NODE_6452_length_389_cov_24.465190_g6191_i0 PRJNA859990 6452 389 24.46519 95.1695891 Diuraphis noxia 143948 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|985399333|ref|XM_015511795.1| 143948 g6191 i0 100 3.55526992287918 30 0 8 0 186 215 839 868 PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA blastn 1383 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
16148531 16148531 PRJNA859990_S_NODE_13673_length_281_cov_1.629808_g13412_i0 PRJNA859990 13673 281 1.629808 4.57976048 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.026   NTclustered gi|1964503389|emb|OE840646.1| 629358 g13412 i0 100 0.099644128113879 28 0 10 0 119 146 115171 115144 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
16538706 16538706 PRJNA859990_S_NODE_20033_length_245_cov_2.459302_g19772_i0 PRJNA859990 20033 245 2.459302 6.0252899 Timema 61471 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1946939045|emb|OD823215.1| 61472 g19772 i0 100 0.236734693877551 29 0 12 0 195 223 150 122 4_Tbi_b3v08 blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
17424051 17424051 PRJNA859990_S_NODE_21034_length_243_cov_1.482353_g20773_i0 PRJNA859990 21034 243 1.482353 3.60211779 Palaemon carinicauda 392227 Arthropoda Arthropoda 327 3.25e-85   NTclustered gi|2805007537|ref|XR_011042538.1| 392227 g20773 i0 91.02 6.14814814814815 245 19 99 2 1 242 3907 4151 PREDICTED: Palaemon carinicauda large subunit ribosomal RNA (LOC137634595), rRNA blastn 1494 327 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Palaemon Palaemon carinicauda
19972408 19972408 PRJNA859990_S_NODE_15836_length_263_cov_2.200000_g15575_i0 PRJNA859990 15836 263 2.2 5.786 Palaemon carinicauda 392227 Arthropoda Arthropoda 364 2.719999999999999e-96   NTclustered gi|2804932739|ref|XR_011045434.1| 392227 g15575 i0 92.015 10.0076045627376 263 15 100 6 1 263 2244 2500 PREDICTED: Palaemon carinicauda large subunit ribosomal RNA (LOC137646180), rRNA blastn 2632 364 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Palaemon Palaemon carinicauda
19972570 19972570 PRJNA859990_S_NODE_7256_length_369_cov_15.314189_g6995_i0 PRJNA859990 7256 369 15.314189 56.50935741 Chelidurella thaleri 2546182 Arthropoda Arthropoda 52.8 0.035   NTclustered gi|2919610158|emb|OZ238415.1| 2546182 g6995 i0 100 0.0758807588075881 28 0 8 0 299 326 2961648 2961675 Chelidura thaleri genome assembly, chromosome: 16 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
20362415 20362415 PRJNA859990_S_NODE_13756_length_280_cov_2.091787_g13495_i0 PRJNA859990 13756 280 2.091787 5.8570036 Aphididae 27482 Arthropoda Arthropoda 488 1.6599999999999998e-133   NTclustered gi|2620630428|ref|XR_009661998.1| 40932 g13495 i0 98.208 94.2 279 5 99 0 1 279 2229 1951 PREDICTED: Rhopalosiphum padi large subunit ribosomal RNA (LOC132928126), rRNA blastn 26376 488 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Rhopalosiphum Rhopalosiphum padi
21248008 21248008 PRJNA859990_S_NODE_18717_length_249_cov_0.875000_g18456_i0 PRJNA859990 18717 249 0.875 2.17875 Aphis gossypii 80765 Arthropoda Arthropoda 287 5.670000000000001e-73   NTclustered gi|2288445760|ref|XM_027983295.2| 80765 g18456 i0 95.531 4.30120481927711 179 8 72 0 43 221 561 739 PREDICTED: Aphis gossypii uncharacterized LOC114121125 (LOC114121125), mRNA blastn 1071 287 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis gossypii
25072103 25072103 PRJNA859990_S_NODE_4660_length_447_cov_8.114973_g4399_i0 PRJNA859990 4660 447 8.114973 36.27392931 Cymothoe herminia 1210388 Arthropoda Arthropoda 817 0   NTclustered gi|2307882115|gb|MW186585.1| 1210388 g4399 i0 99.775 106.261744966443 445 1 99 0 2 446 6256 5812 Cymothoe herminia voucher 17LW02125 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence blastn 47499 817 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Cymothoe Cymothoe herminia
25462701 25462701 PRJNA859990_S_NODE_14280_length_276_cov_1.773399_g14019_i0 PRJNA859990 14280 276 1.773399 4.89458124 Aphididae 27482 Arthropoda Arthropoda 499 7.54e-137   NTclustered gi|2620630428|ref|XR_009661998.1| 40932 g14019 i0 99.275 96.3442028985507 276 2 100 0 1 276 3730 4005 PREDICTED: Rhopalosiphum padi large subunit ribosomal RNA (LOC132928126), rRNA blastn 26591 499 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Rhopalosiphum Rhopalosiphum padi
25462799 25462799 PRJNA859990_S_NODE_21480_length_242_cov_1.680473_g21219_i0 PRJNA859990 21480 242 1.680473 4.06674466 Metazoa 33208 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|1964700418|emb|OE185876.1| 61474 g21219 i0 100 0.694214876033058 28 0 12 0 117 144 15161 15134 2_Tcm_b3v08 blastn 168 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
26706631 26706631 PRJNA859990_S_NODE_22201_length_241_cov_0.916667_g21940_i0 PRJNA859990 22201 241 0.916667 2.20916747 Pseudolycoriella hygida 35572 Arthropoda Arthropoda 115 7.29e-28   NR KAJ6646900.1 35572 g21940 i0 78.8 1.9792531120332 80 17 99.6 0 241 2 349 428 KAJ6646900.1 Lamin Dm0 [Pseudolycoriella hygida] diamond 477 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
27276459 27276459 PRJNA859990_S_NODE_20303_length_245_cov_0.895349_g20042_i0 PRJNA859990 20303 245 0.895349 2.19360505 Portunus trituberculatus 210409 Arthropoda Arthropoda 90.5 1.69e-21   NR MPC07756.1 210409 g20042 i0 79.2 0.648979591836735 53 11 64.9 0 76 234 19 71 MPC07756.1 hypothetical protein [Portunus trituberculatus] diamond 159 90.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus

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