RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA599026" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 14 ✖

tax_clade 1

bioproject 1

  • PRJNA599026 · 14 ✖

analysis 1

  • blastn · 14 ✖

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
1847091 1847091 PRJNA599026_S_NODE_14802_length_261_cov_8.155660_g14346_i0 PRJNA599026 14802 261 8.15566 21.2862726 Chilodonella hexasticha 1938391 SAR_Eukaryotes SAR_Eukaryotes 483 7.12e-132   NTclustered gi|1389430803|gb|MH341631.1| 1938391 g14346 i0 100 74.4137931034483 261 0 100 0 1 261 432 172 Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence blastn 19422 483 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella hexasticha
3122502 3122502 PRJNA599026_S_NODE_2503_length_603_cov_8.397112_g2088_i0 PRJNA599026 2503 603 8.397112 50.63458536 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 182 7.299999999999998e-41   NTclustered gi|829126868|ref|XM_001008743.3| 312017 g2088 i0 73.098 12.0713101160862 539 133 88 9 1 533 770 238 Tetrahymena thermophila SB210 heat shock-binding protein 70, ER luminal protein partial mRNA blastn 7279 182 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
10776033 10776033 PRJNA599026_S_NODE_43429_length_176_cov_5.622047_g42973_i0 PRJNA599026 43429 176 5.622047 9.89480272 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 89.8 1.13e-13   NTclustered gi|1004125725|gb|KU761582.1| 153251 g42973 i0 84.615 26.7215909090909 91 13 51 1 1 90 6811 6901 Cryptocaryon irritans isolate ND1410 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence blastn 4703 89.8 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
12050863 12050863 PRJNA599026_S_NODE_38310_length_184_cov_8.733333_g37854_i0 PRJNA599026 38310 184 8.733333 16.06933272 Trichodina bellottii 2294005 SAR_Eukaryotes SAR_Eukaryotes 333 5e-87   NTclustered gi|1444897107|gb|MH730162.1| 2294005 g37854 i0 99.457 100 184 0 100 1 1 184 1271 1453 Trichodina bellottii isolate A.bellotti1 small subunit ribosomal RNA gene, partial sequence blastn 18400 333 1 Eukaryota Sar   Ciliophora Oligohymenophorea Mobilida Trichodinidae Trichodina Trichodina bellottii
12050977 12050977 PRJNA599026_S_NODE_490_length_1214_cov_67.503004_g325_i0 PRJNA599026 490 1214 67.503004 819.48646856 Trichodina heterodentata 300408 SAR_Eukaryotes SAR_Eukaryotes 1602 0   NTclustered gi|148466409|gb|EF569680.1| 300408 g325 i0 92.219 90.3682042833608 1131 88 93 0 83 1213 1 1131 Trichodina heterodentata alpha-tubulin gene, partial cds blastn 109707 1602 1 Eukaryota Sar   Ciliophora Oligohymenophorea Mobilida Trichodinidae Trichodina Trichodina heterodentata
12620247 12620247 PRJNA599026_S_NODE_24390_length_216_cov_5.239521_g23934_i0 PRJNA599026 24390 216 5.239521 11.31736536 Trichodinidae 197892 SAR_Eukaryotes SAR_Eukaryotes 150 6.57e-32   NTclustered gi|1938878746|gb|MW311505.1| 197904 g23934 i0 80 58.2777777777778 220 30 100 10 1 216 333 542 Trichodinella myakkae isolate M internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 12588 150 1 Eukaryota Sar   Ciliophora Oligohymenophorea Mobilida Trichodinidae Trichodinella Trichodinella myakkae
19697983 19697983 PRJNA599026_S_NODE_22116_length_224_cov_2.040000_g21660_i0 PRJNA599026 22116 224 2.04 4.5696 Trichodina hypsilepis 437580 SAR_Eukaryotes SAR_Eukaryotes 357 3.77e-94   NTclustered gi|2210671666|gb|ON042770.1| 437580 g21660 i0 95.536 51.9955357142857 224 8 100 2 1 224 1544 1765 Trichodina hypsilepis isolate 1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 5.8S ribosomal RNA gene, partial sequence blastn 11647 357 1 Eukaryota Sar   Ciliophora Oligohymenophorea Mobilida Trichodinidae Trichodina Trichodina hypsilepis
19698100 19698100 PRJNA599026_S_NODE_3116_length_541_cov_2.796748_g2678_i0 PRJNA599026 3116 541 2.796748 15.13040668 Trichodina hypsilepis 437580 SAR_Eukaryotes SAR_Eukaryotes 643 6.899999999999998e-180   NTclustered gi|145408205|gb|EF524274.1| 437580 g2678 i0 98.361 65.0517560073937 366 6 68 0 1 366 366 1 Trichodina hypsilepis small subunit ribosomal RNA gene, complete sequence blastn 35193 643 1 Eukaryota Sar   Ciliophora Oligohymenophorea Mobilida Trichodinidae Trichodina Trichodina hypsilepis
22248742 22248742 PRJNA599026_S_NODE_33598_length_193_cov_5.215278_g33142_i0 PRJNA599026 33598 193 5.215278 10.06548654 Trichodina sp. 2070542 SAR_Eukaryotes SAR_Eukaryotes 237 4.28e-58   NTclustered gi|2501517282|gb|OQ943981.1| 2070542 g33142 i0 89.231 104.362694300518 195 14 100 6 1 193 1320 1131 Trichodina sp. strain JJ.Ps-06 large subunit ribosomal RNA gene, partial sequence blastn 20142 237 1 Eukaryota Sar   Ciliophora Oligohymenophorea Mobilida Trichodinidae Trichodina Trichodina sp.
22248959 22248959 PRJNA599026_S_NODE_5258_length_415_cov_7.226776_g4803_i0 PRJNA599026 5258 415 7.226776 29.9911204 Trichodina sp. 3 2979178 SAR_Eukaryotes SAR_Eukaryotes 475 2e-129   NTclustered gi|2304601492|gb|OP458313.1| 2979178 g4803 i0 89.84 93.1542168674699 374 32 89 4 1 371 1419 1789 Trichodina sp. 3 large subunit ribosomal RNA gene, partial sequence blastn 38659 475 1 Eukaryota Sar   Ciliophora Oligohymenophorea Mobilida Trichodinidae Trichodina Trichodina sp. 3
22818379 22818379 PRJNA599026_S_NODE_25778_length_212_cov_4.000000_g25322_i0 PRJNA599026 25778 212 4 8.48 Trichodina 197893 SAR_Eukaryotes SAR_Eukaryotes 381 2.0899999999999994e-101   NTclustered gi|2210671666|gb|ON042770.1| 437580 g25322 i0 99.522 99.0754716981132 209 1 99 0 1 209 719 927 Trichodina hypsilepis isolate 1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 5.8S ribosomal RNA gene, partial sequence blastn 21004 381 1 Eukaryota Sar   Ciliophora Oligohymenophorea Mobilida Trichodinidae Trichodina Trichodina hypsilepis
24797520 24797520 PRJNA599026_S_NODE_11340_length_292_cov_10.934156_g10884_i0 PRJNA599026 11340 292 10.934156 31.92773552 uncultured Trichodina 2108245 SAR_Eukaryotes SAR_Eukaryotes 540 4.74e-149   NTclustered gi|1354561675|gb|MH023044.1| 2108245 g10884 i0 100 102.948630136986 292 0 100 0 1 292 24 315 Uncultured Trichodina clone OTU497 small subunit ribosomal RNA gene, partial sequence blastn 30061 540 1 Eukaryota Sar   Ciliophora Oligohymenophorea Mobilida Trichodinidae   uncultured Trichodina
24797714 24797714 PRJNA599026_S_NODE_26860_length_209_cov_7.093750_g26404_i0 PRJNA599026 26860 209 7.09375 14.8259375 Trichodina sp. 1 2979176 SAR_Eukaryotes SAR_Eukaryotes 267 6.01e-67   NTclustered gi|2304601490|gb|OP458311.1| 2979176 g26404 i0 90 100.602870813397 210 16 100 3 1 209 861 1066 Trichodina sp. 1 large subunit ribosomal RNA gene, partial sequence blastn 21026 267 1 Eukaryota Sar   Ciliophora Oligohymenophorea Mobilida Trichodinidae Trichodina Trichodina sp. 1
25367448 25367448 PRJNA599026_S_NODE_10000_length_309_cov_2.203846_g9544_i0 PRJNA599026 10000 309 2.203846 6.80988414 Trichodinidae 197892 SAR_Eukaryotes SAR_Eukaryotes 215 3.48e-51   NTclustered gi|325491534|gb|HQ407392.1| 990294 g9544 i0 97.6 46.2200647249191 125 3 60 0 1 125 601 725 Trichodina sp. FT-2011a 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 14282 215 1 Eukaryota Sar   Ciliophora Oligohymenophorea Mobilida Trichodinidae Trichodina Trichodina jialingensis

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