RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA799842" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 13 ✖

tax_clade 1

bioproject 1

  • PRJNA799842 · 13 ✖

analysis 1

  • diamond · 13 ✖

tax_kingdom 0

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
14821805 14821805 PRJNA799842_P_NODE_139532_length_250_cov_1.305085_g137959_i0 PRJNA799842 139532 250 1.305085 3.2627125 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 145 1.4e-42   NR KAL4468593.1 5901 g137959 i0 83.8 2.904 80 13 96 0 9 248 60 139 KAL4468593.1 hypothetical protein ABPG74_005096 [Tetrahymena malaccensis] diamond 726 145 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
26841725 26841725 PRJNA799842_P_NODE_37221_length_470_cov_1.163728_g35650_i0 PRJNA799842 37221 470 1.163728 5.4695216 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 146 5.44e-39   NR TNV79671.1 5974 g35650 i0 54.5 8.68723404255319 134 61 85.5 0 59 460 249 382 TNV79671.1 hypothetical protein FGO68_gene6240 [Halteria grandinella] diamond 4083 147 0.993197278911565 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
27527915 27527915 PRJNA799842_P_NODE_151403_length_248_cov_0.880000_g149830_i0 PRJNA799842 151403 248 0.88 2.1824 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0292   NR KRX02482.1 266149 g149830 i0 60 0.423387096774194 35 14 42.3 0 129 25 733 767 KRX02482.1 P-loop containing nucleoside triphosphate hydrolase [Pseudocohnilembus persalinus] diamond 105 43.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
27591329 27591329 PRJNA799842_P_NODE_138224_length_251_cov_0.865169_g136651_i0 PRJNA799842 138224 251 0.865169 2.17157419 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 69.3 1.25e-11   NR KAL4508206.1 2486642 g136651 i0 38.6 2.41434262948207 101 44 99.2 2 3 251 163 263 KAL4508206.1 hypothetical protein ABPG72_021579 [Tetrahymena utriculariae] diamond 606 69.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
28822216 28822216 PRJNA799842_P_NODE_166748_length_245_cov_0.895349_g165175_i0 PRJNA799842 166748 245 0.895349 2.19360505 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 57.4 2.19e-7   NR XP_001027167.2 312017 g165175 i0 37.5 0.783673469387755 64 40 78.4 0 244 53 230 293 XP_001027167.2 carrier protein [Tetrahymena thermophila SB210] diamond 192 57.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29233095 29233095 PRJNA799842_P_NODE_11949_length_907_cov_1.780576_g10710_i0 PRJNA799842 11949 907 1.780576 16.14982432 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 257 1.66e-81   NR CAD8068969.1 5886 g10710 i0 50.2 1.83241455347299 277 130 91.3 4 851 24 2 271 CAD8068969.1 unnamed protein product [Paramecium primaurelia] diamond 1662 257 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
29832856 29832856 PRJNA799842_P_NODE_108691_length_281_cov_0.879808_g107118_i0 PRJNA799842 108691 281 0.879808 2.47226048 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 55.5 1.86e-6   NR OMJ69762.1 5963 g107118 i0 38.2 1.65480427046263 76 40 75.8 3 57 269 182 255 OMJ69762.1 hypothetical protein SteCoe_32427 [Stentor coeruleus] diamond 465 55.5 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
30085527 30085527 PRJNA799842_P_NODE_177472_length_243_cov_0.905882_g175899_i0 PRJNA799842 177472 243 0.905882 2.20129326 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 74.3 2.72e-13   NR KRX01196.1 266149 g175899 i0 57.4 0.839506172839506 68 29 84 0 237 34 128 195 KRX01196.1 hypothetical protein PPERSA_03700 [Pseudocohnilembus persalinus] diamond 204 74.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
30117069 30117069 PRJNA799842_P_NODE_153292_length_248_cov_0.880000_g151719_i0 PRJNA799842 153292 248 0.88 2.1824 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 117 1.34e-28   NR XP_001025237.2 312017 g151719 i0 62.2 0.991935483870968 82 31 99.2 0 248 3 511 592 XP_001025237.2 WD repeat protein [Tetrahymena thermophila SB210] diamond 246 117 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31159464 31159464 PRJNA799842_P_NODE_135195_length_251_cov_0.865169_g133622_i0 PRJNA799842 135195 251 0.865169 2.17157419 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 127 9.18e-32   NR XP_004030488.1 5932 g133622 i0 84.6 11.6294820717131 65 10 77.7 0 230 36 514 578 XP_004030488.1 snf2 family n-terminal domain protein [Ichthyophthirius multifiliis] diamond 2919 127 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
31159519 31159519 PRJNA799842_P_NODE_81735_length_319_cov_1.252033_g80162_i0 PRJNA799842 81735 319 1.252033 3.99398527 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 50.4 1.88e-4   NR CAD8169680.1 43137 g80162 i0 36 0.705329153605016 75 38 67.7 3 318 103 867 934 CAD8169680.1 unnamed protein product [Paramecium octaurelia] diamond 225 50.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
31665777 31665777 PRJNA799842_P_NODE_171257_length_244_cov_0.900585_g169684_i0 PRJNA799842 171257 244 0.900585 2.1974274 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 64.3 9.79e-10   NR KRX05725.1 266149 g169684 i0 54.4 0.700819672131147 57 26 70.1 0 244 74 657 713 KRX05725.1 WD40-repeat-containing domain [Pseudocohnilembus persalinus] diamond 171 64.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
32645920 32645920 PRJNA799842_P_NODE_108420_length_281_cov_1.110577_g106847_i0 PRJNA799842 108420 281 1.110577 3.12072137 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 53.9 6.88e-6   NR CDW79198.1 5949 g106847 i0 28 0.875444839857651 82 59 87.5 0 276 31 484 565 CDW79198.1 cullin c [Stylonychia lemnae] diamond 246 53.9 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae

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