RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA846486" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA846486 · 11 ✖

analysis 1

  • diamond · 11 ✖
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
13586830 13586830 PRJNA846486_P_NODE_10471_length_383_cov_0.934132_g10376_i0 PRJNA846486 10471 383 0.934132 3.57772556 root 1 Root_unresolved Root_unresolved 130 4.639999999999999e-32   NR XP_003395843.2 30195 g10376 i0 61.4 9.7597911227154 101 37 79.1 1 383 81 430 528 XP_003395843.2 luciferin 4-monooxygenase [Bombus terrestris] diamond 3738 131 0.99236641221374 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus terrestris
19959689 19959689 PRJNA846486_P_NODE_53356_length_193_cov_1.583333_g53260_i0 PRJNA846486 53356 193 1.583333 3.05583269 Arachnida 6854 Arthropoda Arthropoda 100 1.19e-22   NR XP_027195369.1 6956 g53260 i0 67.2 7.81865284974093 64 21 99.5 0 193 2 404 467 XP_027195369.1 cathepsin B-like isoform X2 [Dermatophagoides pteronyssinus] diamond 1509 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
23785564 23785564 PRJNA846486_P_NODE_52659_length_194_cov_1.434483_g52563_i0 PRJNA846486 52659 194 1.434483 2.78289702 Allacma fusca 39272 Arthropoda Arthropoda 125 1.4799999999999998e-31   NR CAG7724477.1 39272 g52563 i0 95.3 0.989690721649485 64 3 99 0 192 1 2648 2711 CAG7724477.1 unnamed protein product [Allacma fusca] diamond 192 125 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
27054855 27054855 PRJNA846486_P_NODE_27002_length_252_cov_1.536946_g26906_i0 PRJNA846486 27002 252 1.536946 3.87310392 Allacma fusca 39272 Arthropoda Arthropoda 178 8.13e-50   NR CAG7724477.1 39272 g26906 i0 95.2 1.97619047619048 83 4 98.8 0 2 250 2801 2883 CAG7724477.1 unnamed protein product [Allacma fusca] diamond 498 178 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
28570594 28570594 PRJNA846486_P_NODE_47127_length_202_cov_2.039216_g47031_i0 PRJNA846486 47127 202 2.039216 4.11921632 Allacma fusca 39272 Arthropoda Arthropoda 132 4.5899999999999996e-34   NR CAG7724477.1 39272 g47031 i0 79.1 0.995049504950495 67 14 99.5 0 202 2 2914 2980 CAG7724477.1 unnamed protein product [Allacma fusca] diamond 201 132 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
28736959 28736959 PRJNA846486_P_NODE_82327_length_166_cov_3.111111_g82231_i0 PRJNA846486 82327 166 3.111111 5.16444426 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 47 3.92e-4   NR XP_014238573.1 7493 g82231 i0 59.4 4.28313253012048 32 13 57.8 0 2 97 228 259 XP_014238573.1 40S ribosomal protein S4 [Trichogramma pretiosum] diamond 711 47.4 0.991561181434599 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma pretiosum
29139287 29139287 PRJNA846486_P_NODE_72269_length_172_cov_1.560976_g72173_i0 PRJNA846486 72269 172 1.560976 2.68487872 Polyplax serrata 468196 Arthropoda Arthropoda 82.4 9.23e-17   NR KAK6622394.1 468196 g72173 i0 78.9 1.98837209302326 57 10 99.4 1 172 2 60 114 KAK6622394.1 hypothetical protein RUM44_002205 [Polyplax serrata] diamond 342 82.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
30497220 30497220 PRJNA846486_P_NODE_93213_length_162_cov_0.955752_g93117_i0 PRJNA846486 93213 162 0.955752 1.54831824 Idotea baltica 82763 Arthropoda Arthropoda 97.1 4.2299999999999997e-23   NR MCL4112850.1 82763 g93117 i0 75.9 1 54 13 100 0 162 1 182 235 MCL4112850.1 hypothetical protein [Idotea baltica] diamond 162 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
30560049 30560049 PRJNA846486_P_NODE_26713_length_253_cov_1.686275_g26617_i0 PRJNA846486 26713 253 1.686275 4.26627575 Portunus trituberculatus 210409 Arthropoda Arthropoda 47.8 5.25e-4   NR MPC69193.1 210409 g26617 i0 42.2 0.533596837944664 45 25 53.4 1 95 229 135 178 MPC69193.1 hypothetical protein [Portunus trituberculatus] diamond 135 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
31002717 31002717 PRJNA846486_P_NODE_70334_length_174_cov_1.272000_g70238_i0 PRJNA846486 70334 174 1.272 2.21328 Daphnia pulex 6669 Arthropoda Arthropoda 63.5 6.94e-10   NR EFX63089.1 6669 g70238 i0 56.9 1 58 22 100 1 1 174 85 139 EFX63089.1 hypothetical protein DAPPUDRAFT_119545 [Daphnia pulex] diamond 174 63.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
32867359 32867359 PRJNA846486_P_NODE_75500_length_169_cov_1.766667_g75404_i0 PRJNA846486 75500 169 1.766667 2.98566723 Lasius niger 67767 Arthropoda Arthropoda 43.9 0.00499   NR KMQ86303.1 67767 g75404 i0 53.3 0.532544378698225 30 14 53.3 0 15 104 216 245 KMQ86303.1 copia protein [Lasius niger] diamond 90 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Lasius Lasius niger

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