RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA1158727", tax_clade = "Sar" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 21 ✖

tax_clade 1

  • Sar · 21 ✖

bioproject 1

  • PRJNA1158727 · 21 ✖

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
304150 304150 PRJNA1158727_P_NODE_150661_length_245_cov_1.726744_g143199_i0 PRJNA1158727 150661 245 1.726744 4.2305228 Opercularia sp. ZhW-2019a 2582953 SAR_Eukaryotes SAR_Eukaryotes 337 5.45e-88   NTclustered gi|2304601486|gb|OP458307.1| 2582953 g143199 i0 91.463 61.269387755102 246 19 100 2 1 245 404 648 Opercularia sp. ZhW-2019a large subunit ribosomal RNA gene, partial sequence blastn 15011 337 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Operculariidae Opercularia Opercularia sp. ZhW-2019a
4131267 4131267 PRJNA1158727_P_NODE_161684_length_241_cov_1.833333_g154222_i0 PRJNA1158727 161684 241 1.833333 4.41833253 Chilodonella hexasticha 1938391 SAR_Eukaryotes SAR_Eukaryotes 351 1.91e-92   NTclustered gi|1389430803|gb|MH341631.1| 1938391 g154222 i0 92.946 48.4896265560166 241 17 100 0 1 241 2080 1840 Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence blastn 11686 351 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella hexasticha
6681132 6681132 PRJNA1158727_P_NODE_109146_length_280_cov_2.260870_g101685_i0 PRJNA1158727 109146 280 2.26087 6.330436 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 183 8.769999999999996e-42   NTclustered gi|829188477|ref|XM_001023087.3| 312017 g101685 i0 82.192 18.4607142857143 219 33 77 6 45 260 1050 835 Tetrahymena thermophila SB210 S-adenosyl-L-homocysteine hydrolase partial mRNA blastn 5169 183 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
10507950 10507950 PRJNA1158727_P_NODE_152389_length_245_cov_0.895349_g144927_i0 PRJNA1158727 152389 245 0.895349 2.19360505 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 453 5.1900000000000006e-123   NTclustered gi|10782|emb|X54004.1| 5908 g144927 i0 100 53.2816326530612 245 0 100 0 1 245 3257 3013 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 13054 453 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
11782240 11782240 PRJNA1158727_P_NODE_122330_length_264_cov_3.099476_g114869_i0 PRJNA1158727 122330 264 3.099476 8.1826166400000009 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 488 1.5499999999999999e-133   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g114869 i0 100 98.3825757575758 264 0 100 0 1 264 2332 2069 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 25973 488 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
12516171 12516171 PRJNA1158727_P_NODE_123650_length_263_cov_1.610526_g116189_i0 PRJNA1158727 123650 263 1.610526 4.23568338 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 220 6.22e-53   NTclustered gi|10792|emb|X12768.1| 5908 g116189 i0 85.714 75.2965779467681 210 29 80 1 8 217 334 126 Tetrahymena pyriformis beta-tubulin gene 1 (beta-TT1) blastn 19803 222 0.990990990990991 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
13059297 13059297 PRJNA1158727_P_NODE_49951_length_501_cov_1.927570_g42496_i0 PRJNA1158727 49951 501 1.92757 9.6571257 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 155 6.1099999999999985e-43   NR XP_001023521.1 312017 g42496 i0 54.9 0.850299401197605 142 58 82 2 90 500 174 314 XP_001023521.1 poly (3-hydroxybutyrate) depolymerase [Tetrahymena thermophila SB210] diamond 426 155 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
20164184 20164184 PRJNA1158727_P_NODE_87036_length_320_cov_2.360324_g79575_i0 PRJNA1158727 87036 320 2.360324 7.5530368 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 580 3.099999999999999e-161   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g79575 i0 99.375 15.7 320 2 100 0 1 320 1549 1868 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 5024 580 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
20164201 20164201 PRJNA1158727_P_NODE_93236_length_306_cov_2.948498_g85775_i0 PRJNA1158727 93236 306 2.948498 9.02240388 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 566 8.239999999999998e-157   NTclustered gi|10853|emb|X56168.1| 5912 g85775 i0 100 100 306 0 100 0 1 306 605 910 T.tropicalis gene for small subunit ribosomal RNA (16S like rRNA) blastn 30600 566 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena tropicalis
20704984 20704984 PRJNA1158727_P_NODE_125077_length_261_cov_2.414894_g117616_i0 PRJNA1158727 125077 261 2.414894 6.30287334 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 180 1.0499999999999999e-40   NTclustered gi|829100487|ref|XM_001007447.3| 312017 g117616 i0 79.31 4.90421455938697 261 50 99 4 3 261 580 838 Tetrahymena thermophila SB210 transitional endoplasmic reticulum ATPase, putative partial mRNA blastn 1280 180 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
23256320 23256320 PRJNA1158727_P_NODE_146959_length_247_cov_0.885057_g139497_i0 PRJNA1158727 146959 247 0.885057 2.18609079 Metopus es 392813 SAR_Eukaryotes SAR_Eukaryotes 346 9.14e-91   NTclustered gi|110645073|gb|DQ665935.1| 392813 g139497 i0 92.245 98.6761133603239 245 18 99 1 4 247 561 317 Metopus es clone 1 actin gene, partial cds; macronuclear blastn 24373 346 1 Eukaryota Sar   Ciliophora Armophorea Metopida Metopidae Metopus Metopus es
24529314 24529314 PRJNA1158727_P_NODE_111980_length_277_cov_1.313725_g104519_i0 PRJNA1158727 111980 277 1.313725 3.63901825 Philasterides dicentrarchi 282688 SAR_Eukaryotes SAR_Eukaryotes 207 5.14e-49   NTclustered gi|49616744|gb|AY643504.1| 282688 g104519 i0 85.222 45.3718411552347 203 29 73 1 2 203 269 67 Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence blastn 12568 207 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Philasteridae Philasterides Philasterides dicentrarchi
25263669 25263669 PRJNA1158727_P_NODE_102040_length_289_cov_2.384259_g94579_i0 PRJNA1158727 102040 289 2.384259 6.89050851 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 446 1.05e-120   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g94579 i0 94.483 79.8269896193772 290 14 100 2 1 289 177 465 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 23070 446 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
26818952 26818952 PRJNA1158727_P_NODE_166961_length_228_cov_2.341935_g159499_i0 PRJNA1158727 166961 228 2.341935 5.3396118 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 117 1.33e-30   NR TNV78266.1 5974 g159499 i0 72 1.97368421052632 75 21 98.7 0 228 4 60 134 TNV78266.1 hypothetical protein FGO68_gene9047 [Halteria grandinella] diamond 450 117 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
27229920 27229920 PRJNA1158727_P_NODE_154443_length_244_cov_0.900585_g146981_i0 PRJNA1158727 154443 244 0.900585 2.1974274 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 65.1 5.12e-11   NR KRW99836.1 266149 g146981 i0 44.9 11.0040983606557 78 41 93.4 2 9 236 23 100 KRW99836.1 hypothetical protein PPERSA_10955 [Pseudocohnilembus persalinus] diamond 2685 65.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
27324872 27324872 PRJNA1158727_P_NODE_158623_length_242_cov_2.289941_g151161_i0 PRJNA1158727 158623 242 2.289941 5.54165722 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 83.6 1.48e-16   NR CAD8048029.1 65129 g151161 i0 46.3 4.94628099173554 80 43 99.2 0 242 3 255 334 CAD8048029.1 unnamed protein product [Paramecium sonneborni] diamond 1197 83.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
28796422 28796422 PRJNA1158727_P_NODE_159807_length_242_cov_0.911243_g152345_i0 PRJNA1158727 159807 242 0.911243 2.20520806 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 74.3 1.55e-14   NR XP_004039581.1 5932 g152345 i0 50 3.63223140495868 78 38 95.5 1 232 2 7 84 XP_004039581.1 transcription factor btf3, putative [Ichthyophthirius multifiliis] diamond 879 74.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
31070900 31070900 PRJNA1158727_P_NODE_129815_length_256_cov_1.683060_g122354_i0 PRJNA1158727 129815 256 1.68306 4.3086336 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 109 8.38e-27   NR CAD8147233.1 43137 g122354 i0 65.5 13.65234375 84 28 97.3 1 3 251 213 296 CAD8147233.1 unnamed protein product [Paramecium octaurelia] diamond 3495 109 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
32082760 32082760 PRJNA1158727_P_NODE_146778_length_247_cov_0.885057_g139316_i0 PRJNA1158727 146778 247 0.885057 2.18609079 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.00173   NR KAL4454048.1 5901 g139316 i0 37.8 2.72064777327935 82 42 88.7 3 227 9 1351 1432 KAL4454048.1 hypothetical protein ABPG73_009847 [Tetrahymena malaccensis] diamond 672 46.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
32569962 32569962 PRJNA1158727_P_NODE_121559_length_265_cov_2.161458_g114098_i0 PRJNA1158727 121559 265 2.161458 5.7278637 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 143 5.7e-39   NR XP_001008438.1 312017 g114098 i0 69.3 0.99622641509434 88 27 99.6 0 264 1 124 211 XP_001008438.1 papain family cysteine protease [Tetrahymena thermophila SB210] diamond 264 143 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32758608 32758608 PRJNA1158727_P_NODE_151380_length_245_cov_0.895349_g143918_i0 PRJNA1158727 151380 245 0.895349 2.19360505 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 145 3.88e-38   NR CDW71243.1 5949 g143918 i0 100 0.83265306122449 68 0 83.3 0 5 208 71 138 CDW71243.1 iq and aaa domain-containing protein 1 [Stylonychia lemnae] diamond 204 145 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae

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