RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA1145574" 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

  • PRJNA1145574 · 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
9216707 9216707 PRJNA1145574_P_NODE_14708_length_242_cov_0.923077_g14524_i0 PRJNA1145574 14708 242 0.923077 2.23384634 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 92.4 7.67e-20   NR XP_004037558.1 5932 g14524 i0 74.1 1.43801652892562 58 15 71.9 0 175 2 94 151 XP_004037558.1 hypothetical protein IMG5_049480 [Ichthyophthirius multifiliis] diamond 348 92.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
12511931 12511931 PRJNA1145574_P_NODE_11810_length_251_cov_0.876404_g11626_i0 PRJNA1145574 11810 251 0.876404 2.19977404 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 127 3.4e-33   NR XP_001016313.1 312017 g11626 i0 69.9 0.99203187250996006 83 25 99.2 0 3 251 35 117 XP_001016313.1 eukaryotic aspartyl protease [Tetrahymena thermophila SB210] diamond 249 127 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
15061036 15061036 PRJNA1145574_P_NODE_4272_length_403_cov_0.815152_g4088_i0 PRJNA1145574 4272 403 0.815152 3.28506256 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 134 3.18e-34   NR XP_001019281.3 312017 g4088 i0 69.9 1.53349875930521 103 30 75.9 1 307 2 346 448 XP_001019281.3 RNA recognition motif 1 in heterogeneous nuclear ribonucleoprotein hnRNP protein [Tetrahymena thermophila SB210] diamond 618 134 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
20690218 20690218 PRJNA1145574_P_NODE_8377_length_297_cov_2.602679_g8193_i0 PRJNA1145574 8377 297 2.602679 7.72995663 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 76.6 6.01e-14   NR KRX06560.1 266149 g8193 i0 42.4 0.929292929292929 92 53 92.9 0 278 3 208 299 KRX06560.1 hypothetical protein PPERSA_10418 [Pseudocohnilembus persalinus] diamond 276 76.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
26627378 26627378 PRJNA1145574_P_NODE_9381_length_280_cov_1.497585_g9197_i0 PRJNA1145574 9381 280 1.497585 4.193238 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 86.3 3.01e-17   NR KRX09066.1 266149 g9197 i0 46.7 1.97142857142857 92 48 98.6 1 279 4 1019 1109 KRX09066.1 hypothetical protein PPERSA_01953 [Pseudocohnilembus persalinus] diamond 552 86.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
26690674 26690674 PRJNA1145574_P_NODE_9441_length_279_cov_1.514563_g9257_i0 PRJNA1145574 9441 279 1.514563 4.22563077 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 112 1.65e-29   NR XP_012651477.1 312017 g9257 i0 81.5 0.698924731182796 65 12 69.9 0 44 238 23 87 XP_012651477.1 nucleoside diphosphate kinase [Tetrahymena thermophila SB210] diamond 195 112 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
26753713 26753713 PRJNA1145574_P_NODE_13541_length_246_cov_0.901734_g13357_i0 PRJNA1145574 13541 246 0.901734 2.21826564 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 47.8 6.72e-4   NR KAL4496783.1 5901 g13357 i0 42.9 0.853658536585366 70 39 84.1 1 6 212 778 847 KAL4496783.1 hypothetical protein ABPG73_011749 [Tetrahymena malaccensis] diamond 210 47.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
27355190 27355190 PRJNA1145574_P_NODE_12423_length_249_cov_0.886364_g12239_i0 PRJNA1145574 12423 249 0.886364 2.20704636 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 79.7 1.34e-16   NR XP_004030185.1 5932 g12239 i0 53.7 0.987951807228916 82 38 98.8 0 4 249 21 102 XP_004030185.1 hypothetical protein IMG5_166160, partial [Ichthyophthirius multifiliis] diamond 246 79.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
27375892 27375892 PRJNA1145574_P_NODE_12763_length_248_cov_0.891429_g12579_i0 PRJNA1145574 12763 248 0.891429 2.21074392 root 1 Root_unresolved Root_unresolved 115 1.1000000000000001e-30   NR CAD8059638.1 5886 g12579 i0 67.9 6.85887096774194 81 25 98 1 248 6 44 123 CAD8059638.1 unnamed protein product [Paramecium primaurelia] diamond 1701 116 0.991379310344828 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
27481352 27481352 PRJNA1145574_P_NODE_13483_length_246_cov_0.901734_g13299_i0 PRJNA1145574 13483 246 0.901734 2.21826564 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 110 5.36e-28   NR XP_977262.2 312017 g13299 i0 76.5 0.829268292682927 68 16 82.9 0 242 39 26 93 XP_977262.2 glutathione S-transferase, carboxy-terminal domain protein [Tetrahymena thermophila SB210] diamond 204 110 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27544537 27544537 PRJNA1145574_P_NODE_12864_length_248_cov_0.891429_g12680_i0 PRJNA1145574 12864 248 0.891429 2.21074392 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 125 5.2e-32   NR XP_001012657.2 312017 g12680 i0 76.8 1.98387096774194 82 19 99.2 0 1 246 304 385 XP_001012657.2 cysteine desulfurase [Tetrahymena thermophila SB210] diamond 492 125 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27639410 27639410 PRJNA1145574_P_NODE_14964_length_242_cov_0.893491_g14780_i0 PRJNA1145574 14964 242 0.893491 2.16224822 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 97.8 7.539999999999999e-23   NR XP_001014158.1 312017 g14780 i0 71.7 0.743801652892562 60 17 74.4 0 2 181 125 184 XP_001014158.1 ribonuclease T2 family protein [Tetrahymena thermophila SB210] diamond 180 97.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28112697 28112697 PRJNA1145574_P_NODE_13325_length_247_cov_0.867816_g13141_i0 PRJNA1145574 13325 247 0.867816 2.14350552 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 58.5 9.43e-8   NR XP_012655774.1 312017 g13141 i0 41.8 1.94331983805668 79 44 96 2 3 239 207 283 XP_012655774.1 cation channel family protein [Tetrahymena thermophila SB210] diamond 480 58.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28270508 28270508 PRJNA1145574_P_NODE_8666_length_292_cov_1.328767_g8482_i0 PRJNA1145574 8666 292 1.328767 3.87999964 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 50.1 1.22e-4   NR CAD8058954.1 5886 g8482 i0 41.3 0.770547945205479 75 42 76 2 71 292 15 88 CAD8058954.1 unnamed protein product [Paramecium primaurelia] diamond 225 50.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
28744326 28744326 PRJNA1145574_P_NODE_7007_length_326_cov_1.233202_g6823_i0 PRJNA1145574 7007 326 1.233202 4.02023852 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 54.7 6.04e-6   NR KAL4445467.1 5901 g6823 i0 50.9 0.506134969325153 55 25 49.7 2 319 158 450 503 KAL4445467.1 hypothetical protein ABPG74_004541 [Tetrahymena malaccensis] diamond 165 54.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
29049094 29049094 PRJNA1145574_P_NODE_12828_length_248_cov_0.891429_g12644_i0 PRJNA1145574 12828 248 0.891429 2.21074392 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 48.5 3.63e-4   NR CAD8192077.1 43138 g12644 i0 34.9 2.00806451612903 83 39 98 3 1 243 362 431 CAD8192077.1 unnamed protein product [Paramecium pentaurelia] diamond 498 48.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
29060140 29060140 PRJNA1145574_P_NODE_10068_length_268_cov_1.984615_g9884_i0 PRJNA1145574 10068 268 1.984615 5.3187682 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 67 1.39e-10   NR CAD8189322.1 43138 g9884 i0 43.7 1.6455223880597 71 40 79.5 0 228 16 238 308 CAD8189322.1 unnamed protein product [Paramecium pentaurelia] diamond 441 67 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
29881191 29881191 PRJNA1145574_P_NODE_14791_length_242_cov_0.923077_g14607_i0 PRJNA1145574 14791 242 0.923077 2.23384634 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 123 1.31e-30   NR XP_001009829.2 312017 g14607 i0 75 0.991735537190083 80 20 99.2 0 2 241 215 294 XP_001009829.2 dynamin central region family protein [Tetrahymena thermophila SB210] diamond 240 123 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30070449 30070449 PRJNA1145574_P_NODE_12192_length_250_cov_0.881356_g12008_i0 PRJNA1145574 12192 250 0.881356 2.20339 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 133 2.07e-35   NR XP_001007665.1 312017 g12008 i0 79.3 0.984 82 17 98.4 0 248 3 205 286 XP_001007665.1 AAA domain protein [Tetrahymena thermophila SB210] diamond 246 133 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30133400 30133400 PRJNA1145574_P_NODE_11532_length_252_cov_0.871508_g11348_i0 PRJNA1145574 11532 252 0.871508 2.19620016 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 138 1.04e-38   NR XP_001030083.3 312017 g11348 i0 87 0.916666666666667 77 10 91.7 0 21 251 8 84 XP_001030083.3 40S ribosomal protein S3 [Tetrahymena thermophila SB210] diamond 231 138 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30418455 30418455 PRJNA1145574_P_NODE_10713_length_256_cov_2.278689_g10529_i0 PRJNA1145574 10713 256 2.278689 5.83344384 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 107 4.29e-28   NR XP_004030095.1 5932 g10529 i0 59.5 3.9375 84 33 98.4 1 254 3 7 89 XP_004030095.1 hypothetical protein IMG5_167680 [Ichthyophthirius multifiliis] diamond 1008 107 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
30564661 30564661 PRJNA1145574_P_NODE_9653_length_275_cov_1.544554_g9469_i0 PRJNA1145574 9653 275 1.544554 4.2475235 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 82 3.02e-17   NR XP_001025866.1 312017 g9469 i0 44.4 1.76727272727273 81 40 88.4 1 11 253 1 76 XP_001025866.1 translationally-controlled tumor-like protein [Tetrahymena thermophila SB210] diamond 486 82.8 0.990338164251208 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30944273 30944273 PRJNA1145574_P_NODE_13354_length_246_cov_1.352601_g13170_i0 PRJNA1145574 13354 246 1.352601 3.32739846 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 87.4 6.48e-18   NR CAD8146100.1 43138 g13170 i0 51.9 1.97560975609756 81 39 98.8 0 3 245 404 484 CAD8146100.1 unnamed protein product [Paramecium pentaurelia] diamond 486 87.8 0.995444191343964 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
32220312 32220312 PRJNA1145574_P_NODE_6058_length_347_cov_1.708029_g5874_i0 PRJNA1145574 6058 347 1.708029 5.92686063 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 137 3.8399999999999997e-38   NR CDW89587.1 5949 g5874 i0 84.2 0.657060518731988 76 12 65.7 0 345 118 112 187 CDW89587.1 UNKNOWN [Stylonychia lemnae] diamond 228 137 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32840507 32840507 PRJNA1145574_P_NODE_8480_length_295_cov_1.756757_g8296_i0 PRJNA1145574 8480 295 1.756757 5.18243315 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 91.7 4.53e-19   NR KAL4449142.1 5901 g8296 i0 87.2 0.955932203389831 47 6 47.8 0 294 154 600 646 KAL4449142.1 hypothetical protein ABPG74_021134 [Tetrahymena malaccensis] diamond 282 91.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis

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