RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA358049", tax_clade = "Opisthokonta" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 12 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 12 ✖

bioproject 1

  • PRJNA358049 · 12 ✖
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
1673234 1673234 PRJNA358049_S_NODE_1542_length_464_cov_4.214458_g1498_i0 PRJNA358049 1542 464 4.214458 19.55508512 Bombyx mori 7091 Arthropoda Arthropoda 54.7 0.013   NTclustered gi|1237088976|dbj|LC316987.1| 7091 g1498 i0 100 0.0625 29 0 6 0 436 464 58 30 Bombyx mori BmSfp53 mRNA for seminal fluid protein 53, complete cds blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
5502000 5502000 PRJNA358049_S_NODE_10125_length_203_cov_1.000000_g10077_i0 PRJNA358049 10125 203 1 2.03 Oppiella nova 334625 Arthropoda Arthropoda 276 9.64e-70   NTclustered gi|1962626269|emb|OC945852.1| 334625 g10077 i0 93.514 1.85714285714286 185 12 91 0 19 203 2 186 Oppiella nova blastn 377 276 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
10602502 10602502 PRJNA358049_S_NODE_5509_length_260_cov_2.246445_g5461_i0 PRJNA358049 5509 260 2.246445 5.840757 Oppiella nova 334625 Arthropoda Arthropoda 320 5.88e-83   NTclustered gi|1962591659|emb|OC920949.1| 334625 g5461 i0 89.147 0.992307692307692 258 26 99 2 1 257 4014 4270 Oppiella nova blastn 258 320 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
11877194 11877194 PRJNA358049_S_NODE_14930_length_174_cov_1.216000_g14882_i0 PRJNA358049 14930 174 1.216 2.11584 Oppiella nova 334625 Arthropoda Arthropoda 183 4.969999999999999e-42   NTclustered gi|1962591659|emb|OC920949.1| 334625 g14882 i0 87.117 0.936781609195402 163 20 94 1 11 173 3498 3337 Oppiella nova blastn 163 183 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
13152482 13152482 PRJNA358049_S_NODE_6271_length_246_cov_7.989848_g6223_i0 PRJNA358049 6271 246 7.989848 19.65502608 Drosophila mauritiana 7226 Arthropoda Arthropoda 111 3.61e-20   NTclustered gi|1829491759|ref|XM_033301759.1| 7226 g6223 i0 94.444 47.9837398373984 72 4 30 0 1 72 526 597 PREDICTED: Drosophila mauritiana polyubiquitin-C (LOC117139451), transcript variant X1, mRNA blastn 11804 111 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila mauritiana
13152516 13152516 PRJNA358049_S_NODE_7391_length_229_cov_3.311111_g7343_i0 PRJNA358049 7391 229 3.311111 7.58244419 Oppiella nova 334625 Arthropoda Arthropoda 169 1.9399999999999997e-37   NTclustered gi|1962591659|emb|OC920949.1| 334625 g7343 i0 90 1.0174672489083 130 13 100 0 1 130 3737 3866 Oppiella nova blastn 233 169 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
23350677 23350677 PRJNA358049_S_NODE_3319_length_327_cov_2.010791_g3271_i0 PRJNA358049 3319 327 2.010791 6.57528657 Cydia splendana 1100963 Arthropoda Arthropoda 99 3.89e-16   NTclustered gi|2695926074|ref|XM_063765129.1| 1100963 g3271 i0 82.301 1.58409785932722 113 20 35 0 29 141 1361 1473 PREDICTED: Cydia splendana methionine aminopeptidase 2 (LOC134793530), mRNA blastn 518 99 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia splendana
24624890 24624890 PRJNA358049_S_NODE_240_length_959_cov_3.150549_g217_i0 PRJNA358049 240 959 3.150549 30.21376491 Oppiella nova 334625 Arthropoda Arthropoda 409 4.999999999999999e-109   NTclustered gi|1962641464|emb|OC958385.1| 334625 g217 i0 86.921 0.382690302398332 367 44 38 4 578 942 197 561 Oppiella nova blastn 367 409 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
24624933 24624933 PRJNA358049_S_NODE_3940_length_301_cov_2.186508_g3892_i0 PRJNA358049 3940 301 2.186508 6.58138908 Coptotermes formosanus 36987 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|506965362|gb|KC632258.1| 36987 g3892 i0 100 0.18936877076412 29 0 10 0 273 301 33 5 Coptotermes formosanus clone CFSNI2475 hypothetical protein mRNA, complete cds blastn 57 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
24624937 24624937 PRJNA358049_S_NODE_4120_length_295_cov_459.308943_g4072_i0 PRJNA358049 4120 295 459.308943 1354.96138185 Aedes aegypti 7159 Arthropoda Arthropoda 460 3.84e-125   NTclustered gi|42740775|gb|AY432810.1| 7159 g4072 i0 97.436 551.498305084746 273 1 91 2 6 272 501 229 Aedes aegypti ASAP ID: 38495 conserved unknown mRNA sequence blastn 162692 460 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes aegypti
31528708 31528708 PRJNA358049_S_NODE_15716_length_169_cov_2.216667_g15668_i0 PRJNA358049 15716 169 2.216667 3.74616723 Galendromus occidentalis 34638 Arthropoda Arthropoda 105 1.41e-24   NR XP_003747941.1 34638 g15668 i0 100 0.869822485207101 49 0 87 0 159 13 18 66 XP_003747941.1 membralin [Galendromus occidentalis] diamond 147 105 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
31908152 31908152 PRJNA358049_S_NODE_4217_length_293_cov_1.754098_g4169_i0 PRJNA358049 4217 293 1.754098 5.13950714 Chironomus riparius 315576 Arthropoda Arthropoda 90.1 6.92e-20   NR CAG9809115.1 315576 g4169 i0 59.8 1.60750853242321 87 30 84 1 16 261 125 211 CAG9809115.1 unnamed protein product [Chironomus riparius] diamond 471 90.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus riparius

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