RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA1218816" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 25 ✖

tax_clade 1

bioproject 1

  • PRJNA1218816 · 25 ✖

analysis 1

  • diamond · 25 ✖

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
26724069 26724069 PRJNA1218816_P_NODE_46101_length_279_cov_1.422330_g45668_i0 PRJNA1218816 46101 279 1.42233 3.9683007 Thuricola similis 2784598 SAR_Eukaryotes SAR_Eukaryotes 105 2.64e-24   NR YP_010147311.1 2784598 g45668 i0 72.7 0.709677419354839 66 18 71 0 258 61 145 210 YP_010147311.1 NADH dehydrogenase subunit 7 [Thuricola similis] diamond 198 105 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vaginicolidae Thuricola Thuricola similis
27186120 27186120 PRJNA1218816_P_NODE_59342_length_245_cov_0.895349_g58909_i0 PRJNA1218816 59342 245 0.895349 2.19360505 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 97.8 1.3400000000000002e-21   NR XP_001437384.1 5888 g58909 i0 57.9 6.62448979591837 76 32 93.1 0 236 9 204 279 XP_001437384.1 uncharacterized protein GSPATT00007427001 [Paramecium tetraurelia] diamond 1623 97.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
27736420 27736420 PRJNA1218816_P_NODE_54204_length_251_cov_0.865169_g53771_i0 PRJNA1218816 54204 251 0.865169 2.17157419 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 63.2 2.65e-9   NR KRX02223.1 266149 g53771 i0 49.4 1.0398406374502 87 35 93.2 2 234 1 419 505 KRX02223.1 hypothetical protein PPERSA_04845 [Pseudocohnilembus persalinus] diamond 261 63.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
27830780 27830780 PRJNA1218816_P_NODE_63024_length_241_cov_0.916667_g62591_i0 PRJNA1218816 63024 241 0.916667 2.20916747 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 74.3 1.25e-13   NR XP_001020563.1 312017 g62591 i0 48.1 0.983402489626556 79 38 95.9 2 6 236 38 115 XP_001020563.1 sperm-tail PG-rich repeat protein [Tetrahymena thermophila SB210] diamond 237 74.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28070581 28070581 PRJNA1218816_P_NODE_52905_length_253_cov_2.483333_g52472_i0 PRJNA1218816 52905 253 2.483333 6.28283249 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 68.9 1.12e-12   NR CAD8063884.1 65129 g52472 i0 41 1.89723320158103 83 47 98.4 1 3 251 28 108 CAD8063884.1 unnamed protein product [Paramecium sonneborni] diamond 480 68.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
28083328 28083328 PRJNA1218816_P_NODE_42925_length_292_cov_1.401826_g42492_i0 PRJNA1218816 42925 292 1.401826 4.09333192 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 55.5 2.4e-6   NR KAL4429409.1 5901 g42492 i0 32.7 1.03767123287671 101 55 98.6 5 5 292 321 413 KAL4429409.1 hypothetical protein ABPG74_020996 [Tetrahymena malaccensis] diamond 303 55.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
28367464 28367464 PRJNA1218816_P_NODE_43506_length_289_cov_2.504630_g43073_i0 PRJNA1218816 43506 289 2.50463 7.2383807 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0495   NR XP_001022724.2 312017 g43073 i0 37.2 0.809688581314879 78 35 81 2 244 11 320 383 XP_001022724.2 hypothetical protein TTHERM_00629910 [Tetrahymena thermophila SB210] diamond 234 43.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28620340 28620340 PRJNA1218816_P_NODE_58667_length_246_cov_0.890173_g58234_i0 PRJNA1218816 58667 246 0.890173 2.18982558 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 97.1 2.48e-21   NR KAL4506734.1 2486642 g58234 i0 64.9 2.81707317073171 77 25 93.9 1 246 16 156 230 KAL4506734.1 hypothetical protein ABPG72_001155 [Tetrahymena utriculariae] diamond 693 97.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
28714972 28714972 PRJNA1218816_P_NODE_55707_length_249_cov_0.875000_g55274_i0 PRJNA1218816 55707 249 0.875 2.17875 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 49.7 1.21e-4   NR CAD8175774.1 43137 g55274 i0 32.9 0.987951807228916 82 52 95.2 2 10 246 170 251 CAD8175774.1 unnamed protein product [Paramecium octaurelia] diamond 246 49.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
28841075 28841075 PRJNA1218816_P_NODE_55348_length_249_cov_1.426136_g54915_i0 PRJNA1218816 55348 249 1.426136 3.55107864 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 66.6 1.45e-10   NR CAD8187499.1 43138 g54915 i0 70 2.40963855421687 40 12 48.2 0 84 203 366 405 CAD8187499.1 unnamed protein product [Paramecium pentaurelia] diamond 600 66.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
29365235 29365235 PRJNA1218816_P_NODE_59369_length_245_cov_0.895349_g58936_i0 PRJNA1218816 59369 245 0.895349 2.19360505 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 47.8 6.65e-4   NR KRX09892.1 266149 g58936 i0 44.1 1.40816326530612 59 33 72.2 0 244 68 691 749 KRX09892.1 hypothetical protein PPERSA_05284 [Pseudocohnilembus persalinus] diamond 345 47.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
29756710 29756710 PRJNA1218816_P_NODE_53951_length_251_cov_0.865169_g53518_i0 PRJNA1218816 53951 251 0.865169 2.17157419 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0224   NR CAD8169422.1 43137 g53518 i0 27.4 0.872509960159363 73 53 87.3 0 250 32 6 78 CAD8169422.1 unnamed protein product [Paramecium octaurelia] diamond 219 43.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
29807071 29807071 PRJNA1218816_P_NODE_36951_length_321_cov_1.548387_g36518_i0 PRJNA1218816 36951 321 1.548387 4.97032227 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 112 4.31e-27   NR XP_004030022.1 5932 g36518 i0 60.9 2.51401869158878 87 31 80.4 2 321 64 31 115 XP_004030022.1 receptor of activated protein kinase c component of 40s small ribosomal subunit, putative [Ichthyophthirius multifiliis] diamond 807 112 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
29965181 29965181 PRJNA1218816_P_NODE_61951_length_242_cov_0.911243_g61518_i0 PRJNA1218816 61951 242 0.911243 2.20520806 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 58.2 1.16e-7   NR CAD8148271.1 43137 g61518 i0 49.2 4.22727272727273 59 29 73.1 1 207 31 33 90 CAD8148271.1 unnamed protein product [Paramecium octaurelia] diamond 1023 58.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
30294275 30294275 PRJNA1218816_P_NODE_60052_length_244_cov_0.900585_g59619_i0 PRJNA1218816 60052 244 0.900585 2.1974274 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 57.8 5.22e-8   NR CAD8205893.1 43137 g59619 i0 45.1 3.33196721311475 51 28 62.7 0 1 153 93 143 CAD8205893.1 unnamed protein product [Paramecium octaurelia] diamond 813 57.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
30755062 30755062 PRJNA1218816_P_NODE_59214_length_245_cov_0.895349_g58781_i0 PRJNA1218816 59214 245 0.895349 2.19360505 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 96.7 4.15e-21   NR ABS11086.1 5911 g58781 i0 55.8 2.82857142857143 77 34 94.3 0 232 2 560 636 ABS11086.1 dynein heavy chain 9, partial [Tetrahymena thermophila] diamond 693 97.1 0.995880535530381 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30767843 30767843 PRJNA1218816_P_NODE_30034_length_368_cov_1.044068_g29601_i0 PRJNA1218816 30034 368 1.044068 3.84217024 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 116 1.02e-27   NR XP_001022292.2 312017 g29601 i0 44.5 0.970108695652174 119 66 97 0 364 8 387 505 XP_001022292.2 peptidase M16 inactive domain protein [Tetrahymena thermophila SB210] diamond 357 116 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31273420 31273420 PRJNA1218816_P_NODE_26915_length_397_cov_2.166667_g26482_i0 PRJNA1218816 26915 397 2.166667 8.60166799 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 164 6.64e-47   NR CAD8086774.1 5886 g26482 i0 62.8 1.94962216624685 129 48 97.5 0 9 395 9 137 CAD8086774.1 unnamed protein product [Paramecium primaurelia] diamond 774 164 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
31400079 31400079 PRJNA1218816_P_NODE_23396_length_439_cov_2.311475_g22963_i0 PRJNA1218816 23396 439 2.311475 10.14737525 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 132 7.77e-34   NR CAD8203193.1 43138 g22963 i0 53 3.1503416856492 115 54 78.6 0 345 1 246 360 CAD8203193.1 unnamed protein product [Paramecium pentaurelia] diamond 1383 132 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
31608514 31608514 PRJNA1218816_P_NODE_50136_length_263_cov_1.621053_g49703_i0 PRJNA1218816 50136 263 1.621053 4.26336939 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 172 1.14e-47   NR XP_001454496.1 5888 g49703 i0 94.3 4.96197718631179 87 5 99.2 0 262 2 461 547 XP_001454496.1 uncharacterized protein GSPATT00020752001 [Paramecium tetraurelia] diamond 1305 172 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
31779333 31779333 PRJNA1218816_P_NODE_54077_length_251_cov_0.865169_g53644_i0 PRJNA1218816 54077 251 0.865169 2.17157419 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 89.7 1.12e-18   NR KRW99411.1 266149 g53644 i0 47 0.99203187250996006 83 44 99.2 0 1 249 257 339 KRW99411.1 Six-hairpin glycosidase-like protein [Pseudocohnilembus persalinus] diamond 249 89.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
32178120 32178120 PRJNA1218816_P_NODE_44038_length_287_cov_1.869159_g43605_i0 PRJNA1218816 44038 287 1.869159 5.36448633 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 130 5.31e-33   NR KAL4460894.1 5901 g43605 i0 58.9 2.97909407665505 95 39 99.3 0 287 3 339 433 KAL4460894.1 hypothetical protein ABPG74_016366 [Tetrahymena malaccensis] diamond 855 130 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
32222461 32222461 PRJNA1218816_P_NODE_54118_length_251_cov_0.865169_g53685_i0 PRJNA1218816 54118 251 0.865169 2.17157419 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 95.1 3.1900000000000003e-21   NR XP_012653036.1 312017 g53685 i0 64.3 1.9840637450199201 84 25 98 2 249 4 92 172 XP_012653036.1 papain family cysteine protease [Tetrahymena thermophila SB210] diamond 498 95.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32840915 32840915 PRJNA1218816_P_NODE_35420_length_330_cov_1.198444_g34987_i0 PRJNA1218816 35420 330 1.198444 3.9548652 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 84.3 1.26e-17   NR XP_004027191.1 5932 g34987 i0 60 2.23636363636364 65 26 59.1 0 136 330 102 166 XP_004027191.1 protein kinase domain protein [Ichthyophthirius multifiliis] diamond 738 84.7 0.995277449822904 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
32885177 32885177 PRJNA1218816_P_NODE_55860_length_249_cov_0.875000_g55427_i0 PRJNA1218816 55860 249 0.875 2.17875 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 70.5 7.07e-12   NR XP_001032224.3 312017 g55427 i0 37.5 1.92771084337349 80 50 96.4 0 7 246 228 307 XP_001032224.3 kelch motif protein [Tetrahymena thermophila SB210] diamond 480 70.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila

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