RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA438687" and tax_clade = "Opisthokonta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

tax_clade 1

  • Opisthokonta · 16 ✖

bioproject 1

  • PRJNA438687 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
435248 435248 PRJNA438687_S_NODE_121_length_657_cov_17.649518_g82_i0 PRJNA438687 121 657 17.649518 115.95733326 Daphnia pulex 6669 Arthropoda Arthropoda 360 7.52e-123   NR EFX60189.1 6669 g82 i0 89 0.995433789954338 218 1 99.5 1 657 4 122 316 EFX60189.1 hypothetical protein DAPPUDRAFT_344845, partial [Daphnia pulex] diamond 654 360 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
4919388 4919388 PRJNA438687_S_NODE_704_length_417_cov_3.743455_g615_i0 PRJNA438687 704 417 3.743455 15.61020735 Ixodidae 6939 Arthropoda Arthropoda 77.4 2.85e-15   NR KAL3212956.1 6941 g615 i0 56.7 0.863309352517986 60 26 43.2 0 328 149 57 116 KAL3212956.1 hypothetical protein MRX96_035779 [Rhipicephalus microplus] diamond 360 77.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
26632825 26632825 PRJNA438687_S_NODE_1941_length_309_cov_5.879562_g1851_i0 PRJNA438687 1941 309 5.879562 18.16784658 Zychaea mexicana 64656 Fungi Fungi 60.5 1.26e-8   NR XP_052974654.1 64656 g1851 i0 61.4 0.805825242718447 44 17 42.7 0 13 144 23 66 XP_052974654.1 uncharacterized protein BDB00DRAFT_877453 [Zychaea mexicana] diamond 249 60.5 1 Eukaryota Opisthokonta Fungi Mucoromycota Mucoromycetes Mucorales Lichtheimiaceae Zychaea Zychaea mexicana
26791275 26791275 PRJNA438687_S_NODE_7021_length_164_cov_3.813953_g6931_i0 PRJNA438687 7021 164 3.813953 6.25488292 Nowakowskiella sp. JEL 2012159 Fungi Fungi 43.5 0.00288   NR KAJ1554024.1 2732417 g6931 i0 50 1.71951219512195 46 23 84.1 0 22 159 57 102 KAJ1554024.1 hypothetical protein HK096_005307 [Nowakowskiella sp. JEL0078] diamond 282 43.5 1 Eukaryota Opisthokonta Fungi Chytridiomycota Chytridiomycetes Cladochytriales Nowakowskiellaceae Nowakowskiella Nowakowskiella sp. JEL0078
27549841 27549841 PRJNA438687_S_NODE_8164_length_151_cov_1.017241_g8074_i0 PRJNA438687 8164 151 1.017241 1.53603391 Glonium stellatum 574774 Fungi Fungi 42 0.0024   NR OCL14487.1 574774 g8074 i0 51.1 1.78807947019868 47 13 85.4 2 6 134 17 57 OCL14487.1 hypothetical protein AOQ84DRAFT_280950, partial [Glonium stellatum] diamond 270 42 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Gloniales Gloniaceae Glonium Glonium stellatum
27581451 27581451 PRJNA438687_S_NODE_5864_length_182_cov_2.557823_g5774_i0 PRJNA438687 5864 182 2.557823 4.65523786 Malassezia arunalokei 1514897 Fungi Fungi 71.6 1.07e-12   NR WFD16437.1 1514897 g5774 i0 69.4 1.02197802197802 62 7 82.4 1 182 33 952 1013 WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei] diamond 186 71.6 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia arunalokei
27644891 27644891 PRJNA438687_S_NODE_4104_length_219_cov_2.793478_g4014_i0 PRJNA438687 4104 219 2.793478 6.11771682 Gelatoporia subvermispora B 914234 Fungi Fungi 47.8 1.41e-4   NR EMD30441.1 914234 g4014 i0 48.5 1.80821917808219 66 33 90.4 1 219 22 60 124 EMD30441.1 hypothetical protein CERSUDRAFT_163835, partial [Gelatoporia subvermispora B] diamond 396 47.8 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Polyporales Gelatoporiaceae Gelatoporia Gelatoporia subvermispora
27676500 27676500 PRJNA438687_S_NODE_8044_length_152_cov_1.735043_g7954_i0 PRJNA438687 8044 152 1.735043 2.63726536 Penicillium malachiteum 1324776 Fungi Fungi 45.4 6.46e-4   NR KAJ5710222.1 1324776 g7954 i0 65.5 1.125 29 10 57.2 0 96 10 97 125 KAJ5710222.1 hypothetical protein N7493_009389 [Penicillium malachiteum] diamond 171 45.4 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Aspergillaceae Penicillium Penicillium malachiteum
29349752 29349752 PRJNA438687_S_NODE_5809_length_183_cov_2.459459_g5719_i0 PRJNA438687 5809 183 2.459459 4.50080997 Malassezia arunalokei 1514897 Fungi Fungi 50.1 4.27e-5   NR WFD16025.1 1514897 g5719 i0 60.7 1.81967213114754 56 16 88.5 3 179 18 33 84 WFD16025.1 hypothetical protein MARU1_002059 [Malassezia arunalokei] diamond 333 50.1 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia arunalokei
29681359 29681359 PRJNA438687_S_NODE_7490_length_158_cov_2.284553_g7400_i0 PRJNA438687 7490 158 2.284553 3.60959374 root 1 Root_unresolved Root_unresolved 44.7 0.00243   NR KAG9298475.1 50956 g7400 i0 84 1.10126582278481 25 4 47.5 0 149 75 250 274 KAG9298475.1 hypothetical protein G9A89_000557, partial [Geosiphon pyriformis] diamond 174 44.7 1 Eukaryota Opisthokonta Fungi Mucoromycota Glomeromycetes Archaeosporales Geosiphonaceae Geosiphon Geosiphon pyriformis
29791531 29791531 PRJNA438687_S_NODE_6191_length_176_cov_12.978723_g6101_i0 PRJNA438687 6191 176 12.978723 22.84255248 Aspergillus heteromorphus CBS 117.55 1448321 Fungi Fungi 42.7 0.0113   NR PWY62586.1 1448321 g6101 i0 68 2.98295454545455 25 8 42.6 0 76 2 51 75 PWY62586.1 hypothetical protein BO70DRAFT_375471 [Aspergillus heteromorphus CBS 117.55] diamond 525 42.7 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Aspergillaceae Aspergillus Aspergillus heteromorphus
29823052 29823052 PRJNA438687_S_NODE_6511_length_171_cov_3.875000_g6421_i0 PRJNA438687 6511 171 3.875 6.62625 Microthyrium microscopicum 703497 Fungi Fungi 39.3 0.0219   NR KAF2663089.1 703497 g6421 i0 58.6 0.508771929824561 29 12 50.9 0 34 120 1 29 KAF2663089.1 hypothetical protein BT63DRAFT_380561, partial [Microthyrium microscopicum] diamond 87 39.3 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Microthyriales Microthyriaceae Microthyrium Microthyrium microscopicum
29918195 29918195 PRJNA438687_S_NODE_6291_length_175_cov_1.342857_g6201_i0 PRJNA438687 6291 175 1.342857 2.34999975 Actinostola sp. cb2 3060491 Cnidaria other_Eukaryota 49.7 5.36e-5   NR KAK3748527.1 3060491 g6201 i0 60 0.685714285714286 40 16 68.6 0 22 141 463 502 KAK3748527.1 hypothetical protein QZH41_012374 [Actinostola sp. cb2023] diamond 120 49.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actinostolidae Actinostola Actinostola sp. cb2023
30581292 30581292 PRJNA438687_S_NODE_2553_length_278_cov_3.814815_g2463_i0 PRJNA438687 2553 278 3.814815 10.6051857 Rozella allomycis CSF55 988480 Fungi Fungi 59.7 1.95e-9   NR RKP19413.1 988480 g2463 i0 58 1.03597122302158 50 21 54 0 266 117 5 54 RKP19413.1 hypothetical protein ROZALSC1DRAFT_14008, partial [Rozella allomycis CSF55] diamond 288 59.7 1 Eukaryota Opisthokonta Fungi Cryptomycota       Rozella Rozella allomycis
30882130 30882130 PRJNA438687_S_NODE_5654_length_186_cov_1.046358_g5564_i0 PRJNA438687 5654 186 1.046358 1.94622588 Malassezia 55193 Fungi Fungi 48.5 1.57e-4   NR AYO43640.1 425264 g5564 i0 77.8 1.16129032258065 36 3 58.1 2 151 44 121 151 AYO43640.1 hypothetical protein DNF11_2690 [Malassezia restricta CBS 7877] diamond 216 48.5 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
32841785 32841785 PRJNA438687_S_NODE_1920_length_310_cov_4.690909_g1830_i0 PRJNA438687 1920 310 4.690909 14.5418179 Araneae 6893 Arthropoda Arthropoda 53.5 4.84e-6   NR KFM60918.1 407821 g1830 i0 51.7 1.21935483870968 58 28 56.1 0 25 198 98 155 KFM60918.1 hypothetical protein X975_13633, partial [Stegodyphus mimosarum] diamond 378 53.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus mimosarum

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