RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA827593" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA827593 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
2096408 2096408 PRJNA827593_P_NODE_20422_length_470_cov_1.707809_g20124_i0 PRJNA827593 20422 470 1.707809 8.0267023 Dermacentor silvarum 543639 Arthropoda Arthropoda 63.2 3.91e-9   NR KAH7974023.1 543639 g20124 i0 43.6 0.702127659574468 110 54 70.2 4 403 74 7 108 KAH7974023.1 hypothetical protein HPB49_008418 [Dermacentor silvarum] diamond 330 63.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Dermacentor Dermacentor silvarum
2096924 2096924 PRJNA827593_P_NODE_50022_length_283_cov_1.457143_g49723_i0 PRJNA827593 50022 283 1.457143 4.12371469 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 128 5.81e-32   NR XP_030763388.1 7048 g49723 i0 64.1 15.5936395759717 92 33 97.5 0 280 5 568 659 XP_030763388.1 3-hydroxy-3-methylglutaryl-coenzyme A reductase-like [Sitophilus oryzae] diamond 4413 128 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Sitophilus Sitophilus oryzae
11024581 11024581 PRJNA827593_P_NODE_19269_length_486_cov_1.878935_g18971_i0 PRJNA827593 19269 486 1.878935 9.1316241 Darwinula stevensoni 69355 Arthropoda Arthropoda 188 3.95e-52   NR CAD7252569.1 69355 g18971 i0 58.9 2.02469135802469 168 60 98.8 2 482 3 543 709 CAD7252569.1 unnamed protein product [Darwinula stevensoni] diamond 984 188 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Darwinulidae Darwinula Darwinula stevensoni
26928001 26928001 PRJNA827593_P_NODE_9842_length_706_cov_1.785150_g9553_i0 PRJNA827593 9842 706 1.78515 12.603159 Asbolus verrucosus 1661398 Arthropoda Arthropoda 179 2.57e-49   NR RZB39694.1 1661398 g9553 i0 45.6 2.87677053824363 226 113 94.8 6 38 706 132 350 RZB39694.1 sphingosine-1-phosphate lyase [Asbolus verrucosus] diamond 2031 179 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Asbolus Asbolus verrucosus
27465487 27465487 PRJNA827593_P_NODE_44283_length_303_cov_2.221739_g43984_i0 PRJNA827593 44283 303 2.221739 6.73186917 Cyprideis torosa 163714 Arthropoda Arthropoda 120 8.33e-30   NR CAD7237479.1 163714 g43984 i0 59.8 1.00990099009901 102 36 99 3 301 2 147 245 CAD7237479.1 unnamed protein product [Cyprideis torosa] diamond 306 120 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cytherideidae Cyprideis Cyprideis torosa
27875701 27875701 PRJNA827593_P_NODE_35685_length_342_cov_4.144981_g35386_i0 PRJNA827593 35685 342 4.144981 14.17583502 Aphis craccivora 307492 Arthropoda Arthropoda 60.8 1.16e-9   NR KAF0691860.1 307492 g35386 i0 75 0.315789473684211 36 9 31.6 0 36 143 1 36 KAF0691860.1 hypothetical protein FWK35_00030517, partial [Aphis craccivora] diamond 108 60.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis craccivora
28160131 28160131 PRJNA827593_P_NODE_31105_length_370_cov_2.420875_g30806_i0 PRJNA827593 31105 370 2.420875 8.9572375 Artemia franciscana 6661 Arthropoda Arthropoda 79 3.24e-14   NR XP_065570311.1 6661 g30806 i0 33.9 1.02972972972973 127 70 98.9 2 5 370 92 209 XP_065570311.1 uncharacterized protein LOC136033493 [Artemia franciscana] diamond 381 79 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28160157 28160157 PRJNA827593_P_NODE_48125_length_289_cov_1.782407_g47826_i0 PRJNA827593 48125 289 1.782407 5.15115623 Ctenocephalides felis 7515 Arthropoda Arthropoda 65.1 9.49e-10   NR XP_026474972.1 7515 g47826 i0 38.8 3.32179930795848 85 50 88.2 2 10 264 1250 1332 XP_026474972.1 LOW QUALITY PROTEIN: E3 ubiquitin-protein ligase highwire-like [Ctenocephalides felis] diamond 960 65.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Siphonaptera Pulicidae Ctenocephalides Ctenocephalides felis
28579129 28579129 PRJNA827593_P_NODE_31747_length_366_cov_1.709898_g31448_i0 PRJNA827593 31747 366 1.709898 6.25822668 Opisthokonta 33154 Arthropoda Arthropoda 47.8 0.00265   NR KAK7082954.1 373956 g31448 i0 32.5 3.5655737704918 83 50 65.6 3 1 240 662 741 KAK7082954.1 Gamma-aminobutyric acid type B receptor subunit 1 [Halocaridina rubra] diamond 1305 48.1 0.993762993762994 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Atyidae Halocaridina Halocaridina rubra
28696925 28696925 PRJNA827593_P_NODE_42767_length_309_cov_1.957627_g42468_i0 PRJNA827593 42767 309 1.957627 6.04906743 Contarinia nasturtii 265458 Arthropoda Arthropoda 155 1.13e-43   NR XP_031638888.1 265458 g42468 i0 91.4 4.71844660194175 81 7 78.6 0 308 66 43 123 XP_031638888.1 L-threonine 3-dehydrogenase, mitochondrial [Contarinia nasturtii] diamond 1458 155 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Contarinia Contarinia nasturtii
30054299 30054299 PRJNA827593_P_NODE_12711_length_613_cov_1.375926_g12419_i0 PRJNA827593 12711 613 1.375926 8.43442638 Parnassius apollo 110799 Arthropoda Arthropoda 65.1 1.7e-9   NR CAG5035473.1 110799 g12419 i0 53.6 0.274061990212072 56 24 27.4 2 135 302 36 89 CAG5035473.1 unnamed protein product [Parnassius apollo] diamond 168 65.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Parnassius Parnassius apollo
30149092 30149092 PRJNA827593_P_NODE_25452_length_415_cov_2.672515_g25153_i0 PRJNA827593 25452 415 2.672515 11.09093725 Pogonomyrmex barbatus 144034 Arthropoda Arthropoda 50.4 4.25e-4   NR XP_011644586.1 144034 g25153 i0 43.4 0.383132530120482 53 30 38.3 0 392 234 148 200 XP_011644586.1 leucine-rich repeat-containing protein 74B-like [Pogonomyrmex barbatus] diamond 159 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Pogonomyrmex Pogonomyrmex barbatus
30442390 30442390 PRJNA827593_P_NODE_24113_length_428_cov_1.864789_g23814_i0 PRJNA827593 24113 428 1.864789 7.98129692 Insecta 50557 Arthropoda Arthropoda 49.3 0.00106   NR XP_037040566.1 38358 g23814 i0 34.4 1.21261682242991 90 49 63.1 4 4 273 33 112 XP_037040566.1 poly [ADP-ribose] polymerase tankyrase-2-like [Bradysia coprophila] diamond 519 49.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
31603237 31603237 PRJNA827593_P_NODE_52156_length_276_cov_1.211823_g51857_i0 PRJNA827593 52156 276 1.211823 3.34463148 Scylla paramamosain 85552 Arthropoda Arthropoda 63.2 3.48e-9   NR XP_063883706.1 85552 g51857 i0 38 3.08695652173913 71 44 77.2 0 220 8 56 126 XP_063883706.1 sphingomyelin phosphodiesterase-like isoform X4 [Scylla paramamosain] diamond 852 63.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
31634630 31634630 PRJNA827593_P_NODE_23696_length_432_cov_2.278552_g23397_i0 PRJNA827593 23696 432 2.278552 9.84334464 Tenebrio molitor 7067 Arthropoda Arthropoda 68.2 4.04e-10   NR XP_068913168.1 7067 g23397 i0 31.1 0.847222222222222 122 84 84.7 0 62 427 1147 1268 XP_068913168.1 uncharacterized protein [Tenebrio molitor] diamond 366 68.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
31982605 31982605 PRJNA827593_P_NODE_3818_length_1180_cov_3.975610_g3604_i0 PRJNA827593 3818 1180 3.97561 46.912198 Daphnia pulicaria 35523 Arthropoda Arthropoda 87.8 1.74e-14   NR XP_046639621.1 35523 g3604 i0 34.8 0.460169491525424 181 111 44.7 5 203 730 1192 1370 XP_046639621.1 serine/threonine-protein phosphatase 6 regulatory ankyrin repeat subunit A-like [Daphnia pulicaria] diamond 543 87.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulicaria
32181339 32181339 PRJNA827593_P_NODE_68158_length_241_cov_0.910714_g67859_i0 PRJNA827593 68158 241 0.910714 2.19482074 Insecta 50557 Arthropoda Arthropoda 116 5.05e-28   NR XP_008204800.1 7425 g67859 i0 70.5 20.5767634854772 78 23 97.1 0 235 2 738 815 XP_008204800.1 3-hydroxy-3-methylglutaryl-coenzyme A reductase [Nasonia vitripennis] diamond 4959 117 0.991452991452991 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Nasonia Nasonia vitripennis
32615282 32615282 PRJNA827593_P_NODE_14440_length_571_cov_1.178715_g14145_i0 PRJNA827593 14440 571 1.178715 6.73046265 Eurytemora carolleeae 1294199 Arthropoda Arthropoda 93.6 2.59e-18   NR XP_023340105.1 1294199 g14145 i0 29.6 2.92119089316988 186 124 97.7 3 10 567 334 512 XP_023340105.1 uncharacterized protein LOC111710282 [Eurytemora carolleeae] diamond 1668 93.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Temoridae Eurytemora Eurytemora carolleeae
32677995 32677995 PRJNA827593_P_NODE_30080_length_377_cov_2.582237_g29781_i0 PRJNA827593 30080 377 2.582237 9.73503349 Nasonia vitripennis 7425 Arthropoda Arthropoda 53.1 3.63e-5   NR XP_003428184.1 7425 g29781 i0 38.8 0.676392572944297 85 40 67.6 3 321 67 27 99 XP_003428184.1 putative ankyrin repeat protein RF_0381 [Nasonia vitripennis] diamond 255 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Nasonia Nasonia vitripennis

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