RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA358490 · 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
26599743 26599743 PRJNA358490_P_NODE_13501_length_209_cov_0.947059_g13157_i0 PRJNA358490 13501 209 0.947059 1.97935331 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 57.4 1.54e-7   NR XP_001011163.2 312017 g13157 i0 73.7 0.545454545454545 38 9 53.1 1 209 99 318 355 XP_001011163.2 zinc-binding dehydrogenase family oxidoreductase [Tetrahymena thermophila SB210] diamond 114 57.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
26758238 26758238 PRJNA358490_P_NODE_9861_length_339_cov_5.970000_g9519_i0 PRJNA358490 9861 339 5.97 20.2383 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 55.1 5.31e-6   NR KAL4470289.1 5901 g9519 i0 65.7 0.619469026548673 35 12 31 0 25 129 515 549 KAL4470289.1 hypothetical protein ABPG74_011900 [Tetrahymena malaccensis] diamond 210 55.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
27201089 27201089 PRJNA358490_P_NODE_16302_length_167_cov_1.562500_g15958_i0 PRJNA358490 16302 167 1.5625 2.609375 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 81.3 1.7e-16   NR XP_001022070.3 312017 g15958 i0 86.8 1.36526946107784 38 5 68.3 0 2 115 288 325 XP_001022070.3 glycoside hydrolase family 18 protein [Tetrahymena thermophila SB210] diamond 228 81.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28274900 28274900 PRJNA358490_P_NODE_17006_length_161_cov_0.877049_g16662_i0 PRJNA358490 17006 161 0.877049 1.41204889 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 73.2 5.25e-14   NR XP_976941.1 312017 g16662 i0 92.3 0.726708074534162 39 3 72.7 0 118 2 150 188 XP_976941.1 proteasome subunit beta type protein [Tetrahymena thermophila SB210] diamond 117 73.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28338209 28338209 PRJNA358490_P_NODE_17806_length_154_cov_1.773913_g17462_i0 PRJNA358490 17806 154 1.773913 2.73182602 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 47 3.54e-4   NR XP_001024076.2 312017 g17462 i0 79.3 1.12987012987013 29 6 56.5 0 1 87 134 162 XP_001024076.2 RNA recognition motif protein [Tetrahymena thermophila SB210] diamond 174 47 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28338210 28338210 PRJNA358490_P_NODE_18146_length_152_cov_1.283186_g17802_i0 PRJNA358490 18146 152 1.283186 1.95044272 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00222   NR KAL4440766.1 5901 g17802 i0 84 0.493421052631579 25 4 49.3 0 151 77 301 325 KAL4440766.1 hypothetical protein ABPG74_013747 [Tetrahymena malaccensis] diamond 75 44.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
28843171 28843171 PRJNA358490_P_NODE_15028_length_182_cov_1.713287_g14684_i0 PRJNA358490 15028 182 1.713287 3.11818234 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 67 4.52e-11   NR KAL4454299.1 5901 g14684 i0 79.5 1.28571428571429 39 8 64.3 0 21 137 581 619 KAL4454299.1 hypothetical protein ABPG74_012256 [Tetrahymena malaccensis] diamond 234 67 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
29001614 29001614 PRJNA358490_P_NODE_18448_length_150_cov_1.477477_g18104_i0 PRJNA358490 18448 150 1.477477 2.2162155 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 71.2 6.12e-13   NR XP_012653036.1 312017 g18104 i0 69.4 0.98 49 15 98 0 2 148 213 261 XP_012653036.1 papain family cysteine protease [Tetrahymena thermophila SB210] diamond 147 71.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29018625 29018625 PRJNA358490_P_NODE_6528_length_513_cov_3.740506_g6200_i0 PRJNA358490 6528 513 3.740506 19.18879578 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 120 7.5e-28   NR KAL4434517.1 5901 g6200 i0 54 1.43859649122807 126 58 73.7 0 465 88 1 126 KAL4434517.1 hypothetical protein ABPG74_007301 [Tetrahymena malaccensis] diamond 738 120 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
29176387 29176387 PRJNA358490_P_NODE_9_length_3899_cov_5.781088_g7_i0 PRJNA358490 9 3899 5.781088 225.40462112 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 449 3.08e-131   NR KAL4441904.1 5901 g7 i0 59.9 1.13952295460374 464 169 35 2 97 1461 22 477 KAL4441904.1 hypothetical protein ABPG74_003655 [Tetrahymena malaccensis] diamond 4443 449 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
29190778 29190778 PRJNA358490_P_NODE_14349_length_192_cov_2.503268_g14005_i0 PRJNA358490 14349 192 2.503268 4.80627456 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 88.2 1.81e-18   NR XP_001033223.2 312017 g14005 i0 76.8 0.875 56 13 87.5 0 23 190 600 655 XP_001033223.2 eukaryotic translation initiation factor 3 subunit B, putative [Tetrahymena thermophila SB210] diamond 168 88.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29253556 29253556 PRJNA358490_P_NODE_1109_length_1247_cov_5.080298_g1025_i0 PRJNA358490 1109 1247 5.080298 63.35131606 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 148 9.49e-39   NR KAL4502306.1 2486642 g1025 i0 81.6 0.209302325581395 87 16 20.9 0 838 578 89 175 KAL4502306.1 hypothetical protein ABPG72_011893 [Tetrahymena utriculariae] diamond 261 148 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
29727136 29727136 PRJNA358490_P_NODE_7290_length_469_cov_5.411628_g6956_i0 PRJNA358490 7290 469 5.411628 25.38053532 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 99.4 3.46e-21   NR KRX05667.1 266149 g6956 i0 83.9 0.358208955223881 56 9 35.8 0 449 282 360 415 KRX05667.1 Pyridoxal phosphate-dependent transferase [Pseudocohnilembus persalinus] diamond 168 99.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
29948542 29948542 PRJNA358490_P_NODE_18531_length_150_cov_1.090090_g18187_i0 PRJNA358490 18531 150 1.09009 1.635135 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 99.4 1.5099999999999998e-23   NR KAL4438788.1 5901 g18187 i0 95.9 2.94 49 2 98 0 149 3 137 185 KAL4438788.1 hypothetical protein ABPG74_013461 [Tetrahymena malaccensis] diamond 441 99.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
30328142 30328142 PRJNA358490_P_NODE_5052_length_612_cov_20.218150_g4772_i0 PRJNA358490 5052 612 20.21815 123.735078 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 205 2.5500000000000003e-64   NR CAD8150344.1 43138 g4772 i0 73.5 0.666666666666667 136 36 66.7 0 552 145 1 136 CAD8150344.1 unnamed protein product [Paramecium pentaurelia] diamond 408 205 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
31275519 31275519 PRJNA358490_P_NODE_9215_length_375_cov_1.616071_g8874_i0 PRJNA358490 9215 375 1.616071 6.06026625 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 170 2.9799999999999998e-46   NR XP_001009172.1 312017 g8874 i0 81.5 0.864 108 20 86.4 0 4 327 881 988 XP_001009172.1 hypothetical protein TTHERM_00550810 [Tetrahymena thermophila SB210] diamond 324 170 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31338746 31338746 PRJNA358490_P_NODE_17956_length_153_cov_1.429825_g17612_i0 PRJNA358490 17956 153 1.429825 2.18763225 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 91.7 3.2e-21   NR XP_001027141.1 312017 g17612 i0 80 0.980392156862745 50 10 98 0 151 2 55 104 XP_001027141.1 Mpv17/PMP22 family protein [Tetrahymena thermophila SB210] diamond 150 91.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32698422 32698422 PRJNA358490_P_NODE_9080_length_382_cov_3.320700_g8739_i0 PRJNA358490 9080 382 3.3207 12.685074 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 96.7 1.85e-20   NR XP_001014580.2 312017 g8739 i0 88.5 0.408376963350785 52 6 40.8 0 363 208 436 487 XP_001014580.2 dihydrolipoyl dehydrogenase [Tetrahymena thermophila SB210] diamond 156 96.7 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);;