RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJEB8827" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 17 ✖

tax_clade 1

bioproject 1

  • PRJEB8827 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
25530229 25530229 PRJEB8827g_S_NODE_217_length_509_cov_16.698312_g201_i0 PRJEB8827 217 509 16.698312 84.99440808 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 72 1.61e-12   NR KAL4494163.1 5901 g201 i0 49.3 1.67387033398821 71 36 41.8 0 486 274 62 132 KAL4494163.1 hypothetical protein ABPG73_018682 [Tetrahymena malaccensis] diamond 852 72 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
25754015 25754015 PRJEB8827g_S_NODE_1314_length_266_cov_77934.380952_g1293_i0 PRJEB8827 1314 266 77934.380952 207305.45333232 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 75.1 1.44e-13   NR CDW75879.1 5949 g1293 i0 63.8 2.65037593984962 47 17 53 0 25 165 309 355 CDW75879.1 meiotic recombination protein dmc1-like protein [Stylonychia lemnae] diamond 705 75.1 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31195630 31195630 PRJEB8827_P_NODE_115_length_411_cov_6.324607_g95_i0 PRJEB8827 115 411 6.324607 25.99413477 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 48.9 4.15e-4   NR KAL4494163.1 5901 g95 i0 47.9 2.01459854014599 48 25 35 0 6 149 85 132 KAL4494163.1 hypothetical protein ABPG73_018682 [Tetrahymena malaccensis] diamond 828 48.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
32914029 32914029 PRJEB8827f_S_NODE_14513_length_172_cov_2.364964_g14493_i0 PRJEB8827 14513 172 2.364964 4.06773808 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0178   NR XP_012653513.1 312017 g14493 i0 44.2 1.56976744186047 43 24 75 0 18 146 7 49 XP_012653513.1 MFS transporter [Tetrahymena thermophila SB210] diamond 270 42.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32914161 32914161 PRJEB8827h_S_NODE_30513_length_175_cov_2.857143_g30494_i0 PRJEB8827 30513 175 2.857143 5.00000025 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0144   NR XP_001449393.1 5888 g30494 i0 58.1 1.06285714285714 31 13 53.1 0 155 63 299 329 XP_001449393.1 uncharacterized protein GSPATT00002124001 [Paramecium tetraurelia] diamond 186 42.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
32923287 32923287 PRJEB8827h_S_NODE_905_length_302_cov_2.782772_g886_i0 PRJEB8827 905 302 2.782772 8.40397144 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.02   NR CAD8061764.1 5886 g886 i0 39.7 1.87748344370861 63 38 62.6 0 5 193 132 194 CAD8061764.1 unnamed protein product [Paramecium primaurelia] diamond 567 43.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
33033843 33033843 PRJEB8827h_S_NODE_1756_length_243_cov_2.490385_g1737_i0 PRJEB8827 1756 243 2.490385 6.05163555 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 124 7.48e-33   NR NP_149367.1 5911 g1737 i0 87.1 1.7037037037037 70 9 86.4 0 241 32 186 255 NP_149367.1 ribosomal protein S13 [Tetrahymena thermophila] diamond 414 124 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
33042912 33042912 PRJEB8827h_S_NODE_1572_length_252_cov_4.626728_g1553_i0 PRJEB8827 1572 252 4.626728 11.65935456 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 58.5 7.71e-8   NR CAD8154989.1 43138 g1553 i0 42.5 4.34523809523809 73 42 86.9 0 4 222 186 258 CAD8154989.1 unnamed protein product [Paramecium pentaurelia] diamond 1095 58.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
33050817 33050817 PRJEB8827h_S_NODE_42853_length_160_cov_1.600000_g42834_i0 PRJEB8827 42853 160 1.6 2.56 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 53.9 1.36e-7   NR XP_001026284.1 312017 g42834 i0 66.7 0.61875 33 11 61.9 0 2 100 67 99 XP_001026284.1 transmembrane protein, putative [Tetrahymena thermophila SB210] diamond 99 53.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
33059910 33059910 PRJEB8827e_S_NODE_4101_length_227_cov_1.192708_g4073_i0 PRJEB8827 4101 227 1.192708 2.70744716 root 1 Root_unresolved Root_unresolved 42.4 0.0217   NR YP_010049583.1 5974 g4073 i0 39 1.54625550660793 59 35 78 1 215 39 91 148 YP_010049583.1 ribosomal protein S8 [Halteria grandinella] diamond 351 42.4 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
33067872 33067872 PRJEB8827h_S_NODE_2941_length_215_cov_4.527778_g2922_i0 PRJEB8827 2941 215 4.527778 9.7347227 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.00108   NR KRX06822.1 266149 g2922 i0 45.9 5.07906976744186 37 20 51.6 0 201 91 189 225 KRX06822.1 hypothetical protein PPERSA_11467 [Pseudocohnilembus persalinus] diamond 1092 46.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
33119049 33119049 PRJEB8827h_S_NODE_2463_length_222_cov_3.139037_g2444_i0 PRJEB8827 2463 222 3.139037 6.96866214 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 85.1 5.51e-19   NR AGE89250.1 153251 g2444 i0 71.9 0.77027027027027 57 16 77 0 221 51 90 146 AGE89250.1 60S ribosomal protein L27A [Cryptocaryon irritans] diamond 171 85.1 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
33119054 33119054 PRJEB8827h_S_NODE_36343_length_170_cov_2.474074_g36324_i0 PRJEB8827 36343 170 2.474074 4.2059258 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 61.2 4.12e-9   NR XP_001023200.2 312017 g36324 i0 69.2 1.42941176470588 39 12 68.8 0 151 35 257 295 XP_001023200.2 ZZ-type zinc finger protein [Tetrahymena thermophila SB210] diamond 243 61.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
33136169 33136169 PRJEB8827g_S_NODE_1855_length_232_cov_2.964467_g1834_i0 PRJEB8827 1855 232 2.964467 6.87756344 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 63.2 1.55e-9   NR KRX06822.1 266149 g1834 i0 41.9 0.801724137931034 62 36 80.2 0 6 191 172 233 KRX06822.1 hypothetical protein PPERSA_11467 [Pseudocohnilembus persalinus] diamond 186 63.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
33136188 33136188 PRJEB8827h_S_NODE_1975_length_235_cov_3.195000_g1956_i0 PRJEB8827 1975 235 3.195 7.50825 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 54.7 1.79e-6   NR XP_001017729.1 312017 g1956 i0 34.4 2.46382978723404 64 42 81.7 0 220 29 89 152 XP_001017729.1 hypothetical protein TTHERM_00437330 [Tetrahymena thermophila SB210] diamond 579 54.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
33136191 33136191 PRJEB8827h_S_NODE_3679_length_208_cov_6.202312_g3660_i0 PRJEB8827 3679 208 6.202312 12.90080896 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 73.6 8.3e-15   NR CAG9313846.1 1481888 g3660 i0 67.3 0.75 52 17 75 0 206 51 65 116 CAG9313846.1 unnamed protein product [Blepharisma stoltei] diamond 156 73.6 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
33153218 33153218 PRJEB8827h_S_NODE_2520_length_221_cov_3.161290_g2501_i0 PRJEB8827 2520 221 3.16129 6.9864509 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 82.4 2.7e-18   NR KAL4469356.1 2486642 g2501 i0 69.8 0.719457013574661 53 16 71.9 0 221 63 61 113 KAL4469356.1 hypothetical protein ABPG72_005992 [Tetrahymena utriculariae] diamond 159 82.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae

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