RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA853203" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA853203 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
27592300 27592300 PRJNA853203_P_NODE_19724_length_267_cov_1.216495_g19575_i0 PRJNA853203 19724 267 1.216495 3.24804165 Allacma fusca 39272 Arthropoda Arthropoda 86.7 1.89e-17   NR CAG7729172.1 39272 g19575 i0 97.7 0.48314606741573 43 1 48.3 0 22 150 675 717 CAG7729172.1 unnamed protein product, partial [Allacma fusca] diamond 129 86.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
27718864 27718864 PRJNA853203_P_NODE_27304_length_253_cov_0.866667_g27155_i0 PRJNA853203 27304 253 0.866667 2.19266751 Henosepilachna vigintioctopunctata 420089 Arthropoda Arthropoda 93.6 2.88e-21   NR KAK9878614.1 420089 g27155 i0 50.7 1.87351778656126 75 37 88.9 0 29 253 107 181 KAK9878614.1 hypothetical protein WA026_022875 [Henosepilachna vigintioctopunctata] diamond 474 93.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Henosepilachna Henosepilachna vigintioctopunctata
28191781 28191781 PRJNA853203_P_NODE_18626_length_269_cov_1.474490_g18477_i0 PRJNA853203 18626 269 1.47449 3.9663781 Caerostris darwini 1538125 Arthropoda Arthropoda 69.7 1.7e-11   NR GIY07184.1 1538125 g18477 i0 44.7 1.50557620817844 76 42 84.8 0 254 27 1556 1631 GIY07184.1 e3 ubiquitin-protein ligase ubr3 [Caerostris darwini] diamond 405 69.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Caerostris Caerostris darwini
28665768 28665768 PRJNA853203_P_NODE_16647_length_273_cov_1.640000_g16498_i0 PRJNA853203 16647 273 1.64 4.4772 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 67.4 8.73e-11   NR CAB4061479.1 72036 g16498 i0 42.7 4.26373626373626 75 43 82.4 0 44 268 202 276 CAB4061479.1 unnamed protein product [Lepeophtheirus salmonis] diamond 1164 67.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
29802237 29802237 PRJNA853203_P_NODE_34251_length_249_cov_0.886364_g34102_i0 PRJNA853203 34251 249 0.886364 2.20704636 Diabrotica virgifera virgifera 50390 Arthropoda Arthropoda 89.4 1.75e-19   NR XP_050514905.1 50390 g34102 i0 50.6 1.96385542168675 81 40 97.6 0 244 2 1 81 XP_050514905.1 uncharacterized protein LOC126890100 [Diabrotica virgifera virgifera] diamond 489 89.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Diabrotica Diabrotica virgifera
30023638 30023638 PRJNA853203_P_NODE_39671_length_246_cov_0.901734_g39522_i0 PRJNA853203 39671 246 0.901734 2.21826564 Pseudolycoriella hygida 35572 Arthropoda Arthropoda 78.6 9.02e-15   NR KAJ6627063.1 35572 g39522 i0 60 0.731707317073171 60 21 73.2 1 6 185 444 500 KAJ6627063.1 Sialin [Pseudolycoriella hygida] diamond 180 78.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
30592076 30592076 PRJNA853203_P_NODE_9333_length_291_cov_0.995413_g9184_i0 PRJNA853203 9333 291 0.995413 2.89665183 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 79.7 6.77e-15   NR KAH9425810.1 6956 g9184 i0 100 0.711340206185567 69 0 71.1 0 3 209 293 361 KAH9425810.1 hypothetical protein DERP_005028 [Dermatophagoides pteronyssinus] diamond 207 79.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
30876508 30876508 PRJNA853203_P_NODE_46354_length_243_cov_0.882353_g46205_i0 PRJNA853203 46354 243 0.882353 2.14411779 Rhipicephalus microplus 6941 Arthropoda Arthropoda 134 1.4399999999999998e-37   NR KAH8037404.1 6941 g46205 i0 83.1 10.4691358024691 77 13 95.1 0 233 3 7 83 KAH8037404.1 hypothetical protein HPB51_009959 [Rhipicephalus microplus] diamond 2544 134 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
31287209 31287209 PRJNA853203_P_NODE_11275_length_286_cov_1.225352_g11126_i0 PRJNA853203 11275 286 1.225352 3.50450672 Oppiella nova 334625 Arthropoda Arthropoda 94.7 5.77e-21   NR CAD7656711.1 334625 g11126 i0 51.1 0.965034965034965 92 22 96.5 1 10 285 195 263 CAD7656711.1 unnamed protein product, partial [Oppiella nova] diamond 276 94.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
31635193 31635193 PRJNA853203_P_NODE_35376_length_248_cov_1.371429_g35227_i0 PRJNA853203 35376 248 1.371429 3.40114392 Fragariocoptes setiger 1670756 Arthropoda Arthropoda 50.1 1.01e-4   NR KAG9510521.1 1670756 g35227 i0 51.9 0.979838709677419 81 35 98 2 5 247 175 251 KAG9510521.1 Pre-mRNA-splicing factor SLU7, partial [Fragariocoptes setiger] diamond 243 50.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Phytoptidae Fragariocoptes Fragariocoptes setiger
31698513 31698513 PRJNA853203_P_NODE_10077_length_289_cov_1.180556_g9928_i0 PRJNA853203 10077 289 1.180556 3.41180684 Periplaneta americana 6978 Arthropoda Arthropoda 82.4 7.41e-16   NR XP_069698861.1 6978 g9928 i0 51.6 0.664359861591695 64 31 66.4 0 3 194 879 942 XP_069698861.1 uncharacterized protein [Periplaneta americana] diamond 192 82.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
32204771 32204771 PRJNA853203_P_NODE_25838_length_254_cov_1.613260_g25689_i0 PRJNA853203 25838 254 1.61326 4.0976804 Panonychus citri 50023 Arthropoda Arthropoda 74.7 2.35e-13   NR XP_053202856.1 50023 g25689 i0 45.6 1.86614173228346 79 19 93.3 1 254 18 611 665 XP_053202856.1 monocarboxylate transporter 12-like [Panonychus citri] diamond 474 74.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri
32402837 32402837 PRJNA853203_P_NODE_21619_length_263_cov_1.078947_g21470_i0 PRJNA853203 21619 263 1.078947 2.83763061 Lepidoptera 7088 Arthropoda Arthropoda 42.7 0.0491   NR CAG4957617.1 110799 g21470 i0 34.4 2.01901140684411 90 53 95.8 2 261 10 316 405 CAG4957617.1 unnamed protein product [Parnassius apollo] diamond 531 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Parnassius Parnassius apollo

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