RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA849172" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 28 ✖

tax_clade 1

bioproject 1

  • PRJNA849172 · 28 ✖

analysis 1

  • diamond · 28 ✖

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
8488877 8488877 PRJNA849172_P_NODE_3427_length_1201_cov_13.394504_g3202_i0 PRJNA849172 3427 1201 13.394504 160.86799304 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 284 2.24e-89   NR CAG9334855.1 1481888 g3202 i0 46.9 3.85678601165695 320 168 79.4 2 27 980 2 321 CAG9334855.1 unnamed protein product [Blepharisma stoltei] diamond 4632 284 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
24184669 24184669 PRJNA849172_P_NODE_91779_length_250_cov_8.491525_g91419_i0 PRJNA849172 91779 250 8.491525 21.2288125 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 94.4 2.88e-20   NR CDW74717.1 5949 g91419 i0 82.1 1.356 56 10 67.2 0 246 79 867 922 CDW74717.1 ribosomal protein l22 [Stylonychia lemnae] diamond 339 94.4 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
26746293 26746293 PRJNA849172_P_NODE_138321_length_209_cov_8.617647_g137961_i0 PRJNA849172 138321 209 8.617647 18.01088223 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 47.8 4e-4   NR XP_001434420.1 5888 g137961 i0 75 2.41148325358852 28 7 40.2 0 208 125 398 425 XP_001434420.1 uncharacterized protein GSPATT00036155001 [Paramecium tetraurelia] diamond 504 48.1 0.993762993762994 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
27276205 27276205 PRJNA849172_P_NODE_46443_length_306_cov_9.025751_g46083_i0 PRJNA849172 46443 306 9.025751 27.61879806 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 80.1 6.1e-15   NR CAD8083832.1 5886 g46083 i0 63.2 1.12745098039216 57 21 55.9 0 306 136 790 846 CAD8083832.1 unnamed protein product [Paramecium primaurelia] diamond 345 80.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
27623677 27623677 PRJNA849172_P_NODE_126144_length_227_cov_3.025974_g125784_i0 PRJNA849172 126144 227 3.025974 6.86896098 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 49.7 1.06e-4   NR CAI2365457.1 5936 g125784 i0 33.8 2.14096916299559 71 47 93.8 0 213 1 238 308 CAI2365457.1 unnamed protein product [Moneuplotes crassus] diamond 486 49.7 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
27789861 27789861 PRJNA849172_P_NODE_133864_length_215_cov_7.542254_g133504_i0 PRJNA849172 133864 215 7.542254 16.2158461 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 52.8 6.93e-6   NR XP_004039409.1 5932 g133504 i0 52.6 1.57674418604651 38 18 53 0 3 116 256 293 XP_004039409.1 hypothetical protein IMG5_023830 [Ichthyophthirius multifiliis] diamond 339 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
27939359 27939359 PRJNA849172_P_NODE_11225_length_636_cov_4.644760_g10873_i0 PRJNA849172 11225 636 4.64476 29.5406736 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 208 7.200000000000001e-65   NR XP_001020556.3 312017 g10873 i0 62.6 0.820754716981132 174 65 82.1 0 619 98 1 174 XP_001020556.3 hypothetical protein TTHERM_00218840 [Tetrahymena thermophila SB210] diamond 522 208 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28223254 28223254 PRJNA849172_P_NODE_3886_length_1129_cov_21.334280_g3640_i0 PRJNA849172 3886 1129 21.33428 240.8640212 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 66.6 2.41e-8   NR CAG9316286.1 1481888 g3640 i0 33.8 0.534100974313552 130 75 33.2 5 39 413 75 198 CAG9316286.1 unnamed protein product [Blepharisma stoltei] diamond 603 66.6 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
28854775 28854775 PRJNA849172_P_NODE_8148_length_762_cov_31.764877_g7811_i0 PRJNA849172 8148 762 31.764877 242.04836274 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 219 3.669999999999999e-68   NR KRX02789.1 266149 g7811 i0 51.5 1.51968503937008 196 94 77.2 1 724 137 1 195 KRX02789.1 hypothetical protein PPERSA_02279 [Pseudocohnilembus persalinus] diamond 1158 219 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
29170744 29170744 PRJNA849172_P_NODE_127829_length_225_cov_4.467105_g127469_i0 PRJNA849172 127829 225 4.467105 10.05098625 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 124 5.989999999999999e-31   NR CDW77112.1 5949 g127469 i0 92.1 0.84 63 5 84 0 204 16 405 467 CDW77112.1 UNKNOWN [Stylonychia lemnae] diamond 189 124 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29265208 29265208 PRJNA849172_P_NODE_87609_length_253_cov_2.150000_g87249_i0 PRJNA849172 87609 253 2.15 5.4395 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 55.5 1.36e-6   NR CAG9329613.1 1481888 g87249 i0 58.3 2.14624505928854 36 15 42.7 0 144 251 162 197 CAG9329613.1 unnamed protein product [Blepharisma stoltei] diamond 543 55.5 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
29928637 29928637 PRJNA849172_P_NODE_146671_length_200_cov_5.661417_g146311_i0 PRJNA849172 146671 200 5.661417 11.322834 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 69.3 1.29e-13   NR TNV72263.1 5974 g146311 i0 84.2 0.57 38 6 57 0 1 114 44 81 TNV72263.1 hypothetical protein FGO68_gene9707 [Halteria grandinella] diamond 114 69.3 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
30339656 30339656 PRJNA849172_P_NODE_102552_length_245_cov_0.906977_g102192_i0 PRJNA849172 102552 245 0.906977 2.22209365 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 55.8 9.37e-7   NR XP_001028029.3 312017 g102192 i0 71.1 0.46530612244898 38 11 46.5 0 130 243 1159 1196 XP_001028029.3 ABC transporter family protein [Tetrahymena thermophila SB210] diamond 114 55.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30411065 30411065 PRJNA849172_P_NODE_10533_length_659_cov_25.310580_g10181_i0 PRJNA849172 10533 659 25.31058 166.7967222 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 250 2.79e-77   NR CAD8146100.1 43138 g10181 i0 72.7 1.49317147192716 172 47 78.3 0 656 141 321 492 CAD8146100.1 unnamed protein product [Paramecium pentaurelia] diamond 984 251 0.99601593625498 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
30686637 30686637 PRJNA849172_P_NODE_73573_length_266_cov_1.606218_g73213_i0 PRJNA849172 73573 266 1.606218 4.27253988 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 63.2 1.56e-10   NR CDW72914.1 5949 g73213 i0 57.7 0.586466165413534 52 22 58.6 0 255 100 1 52 CDW72914.1 UNKNOWN [Stylonychia lemnae] diamond 156 63.2 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31128757 31128757 PRJNA849172_P_NODE_69195_length_270_cov_4.182741_g68835_i0 PRJNA849172 69195 270 4.182741 11.2934007 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 63.5 2.39e-9   NR CAD8161227.1 43137 g68835 i0 41.9 1.3 62 36 68.9 0 1 186 355 416 CAD8161227.1 unnamed protein product [Paramecium octaurelia] diamond 351 63.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
31168803 31168803 PRJNA849172_P_NODE_7595_length_793_cov_6.887500_g7264_i0 PRJNA849172 7595 793 6.8875 54.617875 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 122 1.2200000000000002e-27   NR KAL4459424.1 5901 g7264 i0 37.4 1.55863808322825 206 129 77.9 0 777 160 414 619 KAL4459424.1 hypothetical protein ABPG74_018037 [Tetrahymena malaccensis] diamond 1236 122 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
31263910 31263910 PRJNA849172_P_NODE_73515_length_266_cov_1.658031_g73155_i0 PRJNA849172 73515 266 1.658031 4.41036246 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 59.3 7.33e-8   NR KAL4504887.1 5901 g73155 i0 57.1 1.52255639097744 42 18 47.4 0 178 53 414 455 KAL4504887.1 hypothetical protein ABPG73_021734 [Tetrahymena malaccensis] diamond 405 59.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
31286974 31286974 PRJNA849172_P_NODE_100855_length_246_cov_0.895954_g100495_i0 PRJNA849172 100855 246 0.895954 2.20404684 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 48.5 3.55e-4   NR KAL4503018.1 2486642 g100495 i0 33.8 1.8780487804878 77 50 93.9 1 244 14 110 185 KAL4503018.1 hypothetical protein ABPG72_014247 [Tetrahymena utriculariae] diamond 462 48.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
31729864 31729864 PRJNA849172_P_NODE_139937_length_207_cov_12.388060_g139577_i0 PRJNA849172 139937 207 12.38806 25.6432842 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 105 1.56e-24   NR XP_001015450.1 312017 g139577 i0 94.1 0.739130434782609 51 3 73.9 0 207 55 423 473 XP_001015450.1 M20/M25/M40 family peptidase [Tetrahymena thermophila SB210] diamond 153 105 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31738110 31738110 PRJNA849172_P_NODE_115597_length_235_cov_6.734568_g115237_i0 PRJNA849172 115597 235 6.734568 15.8262348 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0418   NR XP_004039470.1 5932 g115237 i0 39.5 1.46808510638298 43 26 54.9 0 188 60 219 261 XP_004039470.1 protein kinase domain protein [Ichthyophthirius multifiliis] diamond 345 42.7 0.992974238875878 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
31824680 31824680 PRJNA849172_P_NODE_20017_length_461_cov_13.043814_g19658_i0 PRJNA849172 20017 461 13.043814 60.13198254 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 120 3.8299999999999996e-32   NR XP_004032297.1 5932 g19658 i0 61.8 0.663774403470716 102 39 66.4 0 11 316 3 104 XP_004032297.1 hypothetical protein IMG5_125120 [Ichthyophthirius multifiliis] diamond 306 120 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
31991299 31991299 PRJNA849172_P_NODE_1918_length_1572_cov_56.415610_g1772_i0 PRJNA849172 1918 1572 56.41561 886.8533892 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 105 1.19e-19   NR CAD8091521.1 5886 g1772 i0 36.2 1.00954198473282 174 78 33 4 539 21 139 280 CAD8091521.1 unnamed protein product [Paramecium primaurelia] diamond 1587 105 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
32077972 32077972 PRJNA849172_P_NODE_64478_length_275_cov_17.316832_g64118_i0 PRJNA849172 64478 275 17.316832 47.621288 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 82 8.2e-16   NR CDW81161.1 5949 g64118 i0 48.6 1.51636363636364 70 36 76.4 0 14 223 512 581 CDW81161.1 UNKNOWN [Stylonychia lemnae] diamond 417 82 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32402804 32402804 PRJNA849172_P_NODE_3979_length_1116_cov_33.911793_g3729_i0 PRJNA849172 3979 1116 33.911793 378.45560988 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 201 5.829999999999998e-55   NR CAD8165236.1 43138 g3729 i0 55 2.41935483870968 180 80 48.4 1 749 210 357 535 CAD8165236.1 unnamed protein product [Paramecium pentaurelia] diamond 2700 201 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
32457822 32457822 PRJNA849172_P_NODE_17019_length_503_cov_22.709302_g16660_i0 PRJNA849172 17019 503 22.709302 114.22778906 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 89.7 4.65e-18   NR XP_004035244.1 5932 g16660 i0 42.1 2.44532803180915 133 62 71.6 5 111 470 85 215 XP_004035244.1 hypothetical protein IMG5_102580 [Ichthyophthirius multifiliis] diamond 1230 89.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
32741746 32741746 PRJNA849172_P_NODE_6000_length_897_cov_33.584951_g5703_i0 PRJNA849172 6000 897 33.584951 301.25701047 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 102 2.57e-20   NR CDW83010.1 5949 g5703 i0 32.1 0.88628762541806 265 146 80.6 7 3 725 271 525 CDW83010.1 UNKNOWN [Stylonychia lemnae] diamond 795 102 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32867454 32867454 PRJNA849172_P_NODE_70560_length_269_cov_1.928571_g70200_i0 PRJNA849172 70560 269 1.928571 5.18785599 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0176   NR YP_010632200.1 153251 g70200 i0 85.7 0.234200743494424 21 3 23.4 0 1 63 240 260 YP_010632200.1 ribosomal protein L2 [Cryptocaryon irritans] diamond 63 43.9 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans

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