RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA846486" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 18 ✖

tax_clade 1

bioproject 1

  • PRJNA846486 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
8486191 8486191 PRJNA846486_P_NODE_92127_length_162_cov_2.318584_g92031_i0 PRJNA846486 92127 162 2.318584 3.75610608 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 97.1 2.7e-23   NR XP_001012497.1 312017 g92031 i0 87 1 54 7 100 0 1 162 140 193 XP_001012497.1 60S ribosomal protein L10 [Tetrahymena thermophila SB210] diamond 162 97.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27497243 27497243 PRJNA846486_P_NODE_59743_length_185_cov_1.529412_g59647_i0 PRJNA846486 59743 185 1.529412 2.8294122 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 61.6 3.75e-9   NR XP_001032240.2 312017 g59647 i0 62.5 0.778378378378378 48 18 77.8 0 42 185 303 350 XP_001032240.2 B-box zinc finger protein [Tetrahymena thermophila SB210] diamond 144 61.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27844272 27844272 PRJNA846486_P_NODE_63104_length_181_cov_1.946970_g63008_i0 PRJNA846486 63104 181 1.94697 3.5240157 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 112 5.37e-28   NR XP_001027934.1 312017 g63008 i0 91.1 0.92817679558011 56 5 92.8 0 2 169 271 326 XP_001027934.1 30S ribosomal protein S5 [Tetrahymena thermophila SB210] diamond 168 112 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27970723 27970723 PRJNA846486_P_NODE_76525_length_169_cov_0.866667_g76429_i0 PRJNA846486 76525 169 0.866667 1.46466723 Oxytricha granulifera 5947 SAR_Eukaryotes SAR_Eukaryotes 60.1 7.24e-9   NR AAN62565.1 5947 g76429 i0 51.8 1.93491124260355 56 25 95.9 2 7 168 166 221 AAN62565.1 macronuclear ERF1 protein, partial [Oxytricha granulifera] diamond 327 60.1 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Oxytricha Oxytricha granulifera
28002519 28002519 PRJNA846486_P_NODE_77985_length_168_cov_1.478992_g77889_i0 PRJNA846486 77985 168 1.478992 2.48470656 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00208   NR XP_001021554.2 312017 g77889 i0 75 0.428571428571429 24 6 42.9 0 95 166 883 906 XP_001021554.2 ubiquitin-activating enzyme E1 [Tetrahymena thermophila SB210] diamond 72 45.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28484404 28484404 PRJNA846486_P_NODE_71926_length_172_cov_2.821138_g71830_i0 PRJNA846486 71926 172 2.821138 4.85235736 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 94.4 9.44e-21   NR CAD8094506.1 5886 g71830 i0 87.8 5.12790697674419 49 6 85.5 0 150 4 173 221 CAD8094506.1 unnamed protein product [Paramecium primaurelia] diamond 882 94.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
28515995 28515995 PRJNA846486_P_NODE_26507_length_254_cov_1.419512_g26411_i0 PRJNA846486 26507 254 1.419512 3.60556048 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 103 1.2399999999999999e-23   NR KAL4435663.1 5901 g26411 i0 57.5 2.58661417322835 73 31 86.2 0 254 36 67 139 KAL4435663.1 hypothetical protein ABPG74_018214 [Tetrahymena malaccensis] diamond 657 103 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
28854654 28854654 PRJNA846486_P_NODE_35088_length_227_cov_1.174157_g34992_i0 PRJNA846486 35088 227 1.174157 2.6653363900000002 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 47.4 6.87e-4   NR CAI2370092.1 5936 g34992 i0 95 0.26431718061674 20 1 26.4 0 21 80 370 389 CAI2370092.1 unnamed protein product [Moneuplotes crassus] diamond 60 47.4 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
29675414 29675414 PRJNA846486_P_NODE_93390_length_162_cov_0.920354_g93294_i0 PRJNA846486 93390 162 0.920354 1.49097348 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 54.7 7.34e-7   NR OMJ87693.1 5963 g93294 i0 96 0.462962962962963 25 1 46.3 0 87 161 1 25 OMJ87693.1 hypothetical protein SteCoe_10537 [Stentor coeruleus] diamond 75 54.7 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
29842020 29842020 PRJNA846486_P_NODE_44751_length_206_cov_1.961783_g44655_i0 PRJNA846486 44751 206 1.961783 4.04127298 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0125   NR CDW79699.1 5949 g44655 i0 31.9 4.00485436893204 69 46 99 1 206 3 510 578 CDW79699.1 armadillo beta-catenin-like repeat-containing protein [Stylonychia lemnae] diamond 825 43.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
30600168 30600168 PRJNA846486_P_NODE_77273_length_169_cov_0.866667_g77177_i0 PRJNA846486 77273 169 0.866667 1.46466723 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 50.1 3.43e-5   NR AAS55115.1 5911 g77177 i0 67.6 1.20710059171598 34 11 60.4 0 51 152 244 277 AAS55115.1 mitogen activated protein kinase 4 [Tetrahymena thermophila] diamond 204 50.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30844732 30844732 PRJNA846486_P_NODE_61534_length_183_cov_1.402985_g61438_i0 PRJNA846486 61534 183 1.402985 2.56746255 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 95.9 4.029999999999999e-23   NR CAG9318382.1 1481888 g61438 i0 72 0.819672131147541 50 14 82 0 3 152 85 134 CAG9318382.1 unnamed protein product [Blepharisma stoltei] diamond 150 95.9 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
31255430 31255430 PRJNA846486_P_NODE_83535_length_166_cov_0.888889_g83439_i0 PRJNA846486 83535 166 0.888889 1.47555574 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 47 4.02e-4   NR CDW79631.1 5949 g83439 i0 77.8 0.487951807228916 27 6 48.8 0 104 24 264 290 CDW79631.1 mir domain protein [Stylonychia lemnae] diamond 81 47 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31382088 31382088 PRJNA846486_P_NODE_62456_length_182_cov_1.428571_g62360_i0 PRJNA846486 62456 182 1.428571 2.59999922 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 119 1.9e-32   NR CAI2381673.1 5936 g62360 i0 91.7 0.989010989010989 60 5 98.9 0 181 2 91 150 CAI2381673.1 unnamed protein product [Moneuplotes crassus] diamond 180 119 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
31856345 31856345 PRJNA846486_P_NODE_82097_length_167_cov_0.881356_g82001_i0 PRJNA846486 82097 167 0.881356 1.47186452 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 72 6.26e-13   NR TNV82522.1 5974 g82001 i0 73.5 0.880239520958084 49 13 88 0 167 21 645 693 TNV82522.1 hypothetical protein FGO68_gene14042 [Halteria grandinella] diamond 147 72 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
32457751 32457751 PRJNA846486_P_NODE_52199_length_195_cov_1.068493_g52103_i0 PRJNA846486 52199 195 1.068493 2.08356135 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 64.3 4.99e-10   NR XP_001008632.2 312017 g52103 i0 63.5 0.969230769230769 63 16 87.7 4 1 171 838 899 XP_001008632.2 PCI-domain protein [Tetrahymena thermophila SB210] diamond 189 64.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32592533 32592533 PRJNA846486_P_NODE_34959_length_227_cov_1.674157_g34863_i0 PRJNA846486 34959 227 1.674157 3.80033639 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 140 2.21e-39   NR XP_001013149.2 312017 g34863 i0 94.1 1.79735682819383 68 4 89.9 0 206 3 195 262 XP_001013149.2 thioredoxin-dependent peroxide reductase [Tetrahymena thermophila SB210] diamond 408 140 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32835858 32835858 PRJNA846486_P_NODE_79600_length_168_cov_0.873950_g79504_i0 PRJNA846486 79600 168 0.87395 1.468236 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 68.2 1.41e-11   NR CAI2363963.1 5936 g79504 i0 65.3 0.875 49 14 82.1 1 29 166 378 426 CAI2363963.1 unnamed protein product [Moneuplotes crassus] diamond 147 68.2 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus

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