RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1059246 · 25 ✖

analysis 1

  • blastn · 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
176764 176764 PRJNA1059246_P_NODE_15061_length_604_cov_1.653484_g14463_i0 PRJNA1059246 15061 604 1.653484 9.98704336 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 318 5.34e-82   NTclustered gi|146185323|ref|XM_001031586.2| 312017 g14463 i0 83.285 10.4221854304636 347 56 57 2 45 390 46 391 Tetrahymena thermophila SB210 40S ribosomal protein S13 partial mRNA blastn 6295 318 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
176818 176818 PRJNA1059246_P_NODE_1861_length_1788_cov_4.193003_g1673_i0 PRJNA1059246 1861 1788 4.193003 74.97089364 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 1338 0   NTclustered gi|9837417|gb|AF287229.1| 5908 g1673 i0 81.101 57.6073825503356 1725 281 95 33 1 1701 334 2037 Tetrahymena pyriformis heat shock protein 90 (HSP81) gene, partial cds blastn 103002 1338 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
1451841 1451841 PRJNA1059246_P_NODE_48782_length_294_cov_1.393665_g48156_i0 PRJNA1059246 48782 294 1.393665 4.0973751 Colpoda cucullus 63137 SAR_Eukaryotes SAR_Eukaryotes 499 8.099999999999998e-137   NTclustered gi|597439380|dbj|AB918921.1| 63137 g48156 i0 97.279 94.4897959183673 294 8 100 0 1 294 303 10 Colpoda cucullus gene for elongation factor 1-alpha, complete cds, strain: Nag-1 blastn 27780 499 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda cucullus
6555311 6555311 PRJNA1059246_P_NODE_64186_length_249_cov_0.875000_g63560_i0 PRJNA1059246 64186 249 0.875 2.17875 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 231 2.7e-56   NTclustered gi|10789|emb|X61053.1| 5908 g63560 i0 93.548 99.0361445783133 155 10 62 0 95 249 646 492 T.pyriformis TU20 gene for ubiquitin blastn 24660 231 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
9104648 9104648 PRJNA1059246_P_NODE_36468_length_356_cov_1.431095_g35842_i0 PRJNA1059246 36468 356 1.431095 5.0946982 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 276 1.84e-69   NTclustered gi|47175616|gb|AY617196.1| 94289 g35842 i0 81.073 85.4578651685393 354 60 98 6 7 355 234 585 Sterkiella histriomuscorum clone UGC1O0001_D01_R genomic sequence blastn 30423 276 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
11214910 11214910 PRJNA1059246_P_NODE_41949_length_326_cov_2.454545_g41323_i0 PRJNA1059246 41949 326 2.454545 8.0018167 Colpoda 5979 SAR_Eukaryotes SAR_Eukaryotes 603 6.749999999999998e-168   NTclustered gi|1202134875|gb|KY454454.1| 63136 g41323 i0 100 98.2116564417178 326 0 100 0 1 326 4 329 Colpoda steinii 18S ribosomal RNA gene, partial sequence blastn 32017 603 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda steini
11655376 11655376 PRJNA1059246_P_NODE_21270_length_491_cov_1.375598_g20651_i0 PRJNA1059246 21270 491 1.375598 6.75418618 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 481 5.16e-131   NTclustered gi|829160170|ref|XM_001012263.3| 312017 g20651 i0 84.426 73.5580448065173 488 76 99 0 3 490 1409 922 Tetrahymena thermophila SB210 heat shock 70 kDa protein partial mRNA blastn 36117 481 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
11655407 11655407 PRJNA1059246_P_NODE_23310_length_466_cov_1.096692_g22687_i0 PRJNA1059246 23310 466 1.096692 5.11058472 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 267 1.4899999999999998e-66   NTclustered gi|471232598|ref|XM_004037339.1| 5932 g22687 i0 80.87 3.24678111587983 345 60 73 5 6 347 392 51 Ichthyophthirius multifiliis hypothetical protein (IMG5_054290) mRNA, complete cds blastn 1513 267 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
11655547 11655547 PRJNA1059246_P_NODE_34870_length_366_cov_1.088737_g34244_i0 PRJNA1059246 34870 366 1.088737 3.98477742 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 427 4.94e-115   NTclustered gi|829160170|ref|XM_001012263.3| 312017 g34244 i0 87.705 86.8469945355191 366 45 100 0 1 366 740 375 Tetrahymena thermophila SB210 heat shock 70 kDa protein partial mRNA blastn 31786 427 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
12930886 12930886 PRJNA1059246_P_NODE_50091_length_289_cov_1.180556_g49465_i0 PRJNA1059246 50091 289 1.180556 3.41180684 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 183 9.089999999999997e-42   NTclustered gi|9837421|gb|AF287231.1| 5888 g49465 i0 79.554 22.636678200692 269 45 92 7 22 288 1027 767 Paramecium tetraurelia heat shock protein 90 (HSP90-2) gene, partial cds blastn 6542 183 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
12931218 12931218 PRJNA1059246_P_NODE_9611_length_779_cov_2.369688_g9080_i0 PRJNA1059246 9611 779 2.369688 18.45986952 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 313 3.2500000000000003e-80   NTclustered gi|829160572|ref|XM_001012497.3| 312017 g9080 i0 77.076 5.8408215661104 554 119 71 8 230 779 553 4 Tetrahymena thermophila SB210 60S ribosomal protein L10 partial mRNA blastn 4550 313 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
14206116 14206116 PRJNA1059246_P_NODE_70932_length_242_cov_1.366864_g70306_i0 PRJNA1059246 70932 242 1.366864 3.30781088 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 198 2.6499999999999997e-46   NTclustered gi|331686193|gb|HQ432920.1| 5949 g70306 i0 84.135 82.6115702479339 208 29 85 4 35 240 653 448 Stylonychia lemnae strain 2x8 elongation factor-1 (ef-1) gene, complete cds; macronuclear blastn 19992 198 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
15479829 15479829 PRJNA1059246_P_NODE_34593_length_367_cov_3.391156_g33967_i0 PRJNA1059246 34593 367 3.391156 12.44554252 Philasterides dicentrarchi 282688 SAR_Eukaryotes SAR_Eukaryotes 215 4.2e-51   NTclustered gi|1750940686|gb|MK601892.1| 282688 g33967 i0 79.114 11.1907356948229 316 63 86 3 26 339 1995 1681 Philasterides dicentrarchi heat shock 70 kDa protein mRNA, complete cds blastn 4107 215 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Philasteridae Philasterides Philasterides dicentrarchi
16754004 16754004 PRJNA1059246_P_NODE_39754_length_338_cov_1.162264_g39128_i0 PRJNA1059246 39754 338 1.162264 3.92845232 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 296 1.34e-75   NTclustered gi|118347624|ref|XM_001007289.1| 312017 g39128 i0 84.797 59.5177514792899 296 43 87 2 1 295 1367 1661 Tetrahymena thermophila SB210 ATP-dependent metalloprotease FtsH partial mRNA blastn 20117 296 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
18028709 18028709 PRJNA1059246_P_NODE_28815_length_411_cov_0.872781_g28190_i0 PRJNA1059246 28815 411 0.872781 3.58712991 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 255 2.7999999999999997e-63   NTclustered gi|47176538|gb|AY618118.1| 94289 g28190 i0 78.272 26.8102189781022 405 82 98 6 10 411 238 639 Sterkiella histriomuscorum clone UGC1O0005_M17_R genomic sequence blastn 11019 255 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
18028790 18028790 PRJNA1059246_P_NODE_35555_length_361_cov_2.618056_g34929_i0 PRJNA1059246 35555 361 2.618056 9.45118216 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 379 1.38e-100   NTclustered gi|10790|emb|X12767.1| 5908 g34929 i0 93.676 66.7534626038781 253 16 70 0 1 253 1391 1643 Tetrahymena pyriformis alpha-tubulin gene blastn 24098 379 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
19302409 19302409 PRJNA1059246_P_NODE_10756_length_733_cov_1.728788_g10203_i0 PRJNA1059246 10756 733 1.728788 12.67201604 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 747 0   NTclustered gi|3550265|gb|AF079840.1|AF079840 5963 g10203 i0 97.291 6.44338335607094 443 7 60 4 66 504 442 1 Stentor coeruleus G protein alpha GS-like subunit mRNA, partial cds blastn 4723 747 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
19302571 19302571 PRJNA1059246_P_NODE_21376_length_489_cov_2.925481_g20757_i0 PRJNA1059246 21376 489 2.925481 14.30560209 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 846 0   NTclustered gi|2651357791|gb|PP174306.1| 41631 g20757 i0 97.955 73.7055214723926 489 9 100 1 1 489 3851 3364 Colpoda sp. isolate JGP15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 36042 846 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
20578202 20578202 PRJNA1059246_P_NODE_44237_length_315_cov_2.471074_g43611_i0 PRJNA1059246 44237 315 2.471074 7.7838831 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 169 2.81e-37   NTclustered gi|47176078|gb|AY617658.1| 94289 g43611 i0 82.143 3.6031746031746 196 35 62 0 56 251 639 444 Sterkiella histriomuscorum clone UGC1O0004_A14_R genomic sequence blastn 1135 169 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
20578239 20578239 PRJNA1059246_P_NODE_47497_length_300_cov_1.572687_g46871_i0 PRJNA1059246 47497 300 1.572687 4.718061 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 154 7.44e-33   NTclustered gi|829188944|ref|XM_001031587.2| 312017 g46871 i0 84.516 0.516666666666667 155 24 52 0 132 286 203 49 Tetrahymena thermophila SB210 60S ribosomal L7Ae-like protein partial mRNA blastn 155 154 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
20578254 20578254 PRJNA1059246_P_NODE_48837_length_294_cov_1.131222_g48211_i0 PRJNA1059246 48837 294 1.131222 3.32579268 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 267 8.95e-67   NTclustered gi|829100487|ref|XM_001007447.3| 312017 g48211 i0 83.108 23.3061224489796 296 46 100 4 1 294 1152 859 Tetrahymena thermophila SB210 transitional endoplasmic reticulum ATPase, putative partial mRNA blastn 6852 267 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
21853847 21853847 PRJNA1059246_P_NODE_32938_length_378_cov_1.603279_g32312_i0 PRJNA1059246 32938 378 1.603279 6.06039462 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 198 4.37e-46   NTclustered gi|47175615|gb|AY617195.1| 94289 g32312 i0 79.927 28.7513227513227 274 51 72 4 107 378 245 516 Sterkiella histriomuscorum clone UGC1O0001_D01_F genomic sequence blastn 10868 198 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
23129570 23129570 PRJNA1059246_P_NODE_54659_length_275_cov_1.168317_g54033_i0 PRJNA1059246 54659 275 1.168317 3.21287175 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 126 1.4699999999999999e-24   NTclustered gi|471223259|ref|XM_004030364.1| 5932 g54033 i0 82.313 2.94545454545455 147 25 53 1 129 274 1640 1494 Ichthyophthirius multifiliis inorganic pyrophosphatase, putative (IMG5_161260) mRNA, complete cds blastn 810 126 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
23963821 23963821 PRJNA1059246_P_NODE_16159_length_579_cov_1.328063_g15551_i0 PRJNA1059246 16159 579 1.328063 7.68948477 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 625 2.6899999999999996e-174   NTclustered gi|10805|emb|X52242.1| 5911 g15551 i0 91.759 74.2193436960276 449 37 78 0 23 471 30 478 T.thermophila mRNA for calmodulin blastn 42973 625 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
25237696 25237696 PRJNA1059246_P_NODE_28240_length_415_cov_2.254386_g27615_i0 PRJNA1059246 28240 415 2.254386 9.3557019 Colpoda 5979 SAR_Eukaryotes SAR_Eukaryotes 767 0   NTclustered gi|1802599797|gb|MT001206.1| 41631 g27615 i0 100 99.5036144578313 415 0 100 0 1 415 508 922 Colpoda sp. strain HFCC1227 small subunit ribosomal RNA gene, partial sequence blastn 41294 767 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.

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