RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA376117 · 18 ✖

analysis 1

  • blastn · 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
399881 399881 PRJNA376117_P_NODE_2801_length_861_cov_6.590102_g2538_i0 PRJNA376117 2801 861 6.590102 56.74077822 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 1507 0   NTclustered gi|220966760|gb|FJ545743.1| 94289 g2538 i0 98.258 69.2473867595819 861 15 100 0 1 861 6162 5302 Sterkiella histriomuscorum 17S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; macronuclear blastn 59622 1507 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
4227008 4227008 PRJNA376117_P_NODE_26624_length_277_cov_1.509804_g26322_i0 PRJNA376117 26624 277 1.509804 4.18215708 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 440 4.6499999999999983e-119   NTclustered gi|229594318|ref|XM_001030083.3| 312017 g26322 i0 95.307 1 277 13 100 0 1 277 279 3 Tetrahymena thermophila SB210 40S ribosomal protein S3 partial mRNA blastn 277 440 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
4901750 4901750 PRJNA376117_P_NODE_44944_length_235_cov_3.833333_g44642_i0 PRJNA376117 44944 235 3.833333 9.00833255 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 424 3.87e-114   NTclustered gi|1837628855|gb|MN158348.1| 5909 g44642 i0 99.149 92.8085106382979 235 2 100 0 1 235 2854 2620 Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 21810 424 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
6777364 6777364 PRJNA376117_P_NODE_16546_length_338_cov_1.977358_g16244_i0 PRJNA376117 16546 338 1.977358 6.68347004 Gastrostyla steinii 99926 SAR_Eukaryotes SAR_Eukaryotes 592 1.5199999999999999e-164   NTclustered gi|21780011|gb|AF508758.1| 99926 g16244 i0 98.225 96.914201183432 338 6 100 0 1 338 2759 3096 Gastrostyla steinii 17S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence blastn 32757 592 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Gastrostyla Gastrostyla steinii
8053016 8053016 PRJNA376117_P_NODE_22267_length_293_cov_1.045455_g21965_i0 PRJNA376117 22267 293 1.045455 3.06318315 Paramecium caudatum 5885 SAR_Eukaryotes SAR_Eukaryotes 448 2.9699999999999996e-121   NTclustered gi|299830252|ref|NC_014262.1| 5885 g21965 i0 94.198 25.4744027303754 293 17 100 0 1 293 1543 1251 Paramecium caudatum mitochondrion, complete genome blastn 7464 448 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium caudatum
8053081 8053081 PRJNA376117_P_NODE_2667_length_889_cov_36.243873_g2407_i0 PRJNA376117 2667 889 36.243873 322.20803097 Paramecium multimicronucleatum 44030 SAR_Eukaryotes SAR_Eukaryotes 1587 0   NTclustered gi|1557881674|gb|MH544161.1| 44030 g2407 i0 98.875 89.0776152980877 889 10 100 0 1 889 894 6 Paramecium multimicronucleatum haplotype S1(1) 28S ribosomal RNA gene, partial sequence blastn 79190 1587 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium multimicronucleatum
8053424 8053424 PRJNA376117_P_NODE_9547_length_435_cov_2.262431_g9245_i0 PRJNA376117 9547 435 2.262431 9.84157485 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 289 2.94e-73   NTclustered gi|38520884|emb|AJ608919.1| 5888 g9245 i0 79.236 34.7885057471264 419 83 96 3 19 435 838 422 Paramecium tetraurelia bPT3 gene for beta-tubulin, allele nocR+, exons 1-3 blastn 15133 289 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
11878509 11878509 PRJNA376117_P_NODE_23370_length_288_cov_1.432558_g23068_i0 PRJNA376117 23370 288 1.432558 4.12576704 Colpoda inflata 5980 SAR_Eukaryotes SAR_Eukaryotes 318 2.3799999999999995e-82   NTclustered gi|4063575|gb|AF056098.1|AF056098 5980 g23068 i0 89.062 91.4375 256 28 89 0 33 288 1226 971 Colpoda inflata translation elongation factor 1-alpha (TEF1) gene, partial cds blastn 26334 318 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda inflata
11878858 11878858 PRJNA376117_P_NODE_4570_length_640_cov_6.966490_g4278_i0 PRJNA376117 4570 640 6.96649 44.585536 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 1033 0   NTclustered gi|512134943|gb|JX178902.1| 1295638 g4278 i0 96.063 91.3265625 635 24 99 1 1 635 992 1625 Vorticella sp. 4 JG-2011 clone 2 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 58449 1033 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
13153478 13153478 PRJNA376117_P_NODE_17671_length_328_cov_3.819608_g17369_i0 PRJNA376117 17671 328 3.819608 12.52831424 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 484 2.5699999999999996e-132   NTclustered gi|342983|gb|K00634.1|PARMTRGPL 5886 g17369 i0 93.313 37.2225609756098 329 20 100 2 1 328 930 1257 Paramecium primaurelia mt large subunit rRNA gene region encoding 5.8s-like RNA, 20s rRNA, and tyr-tRNA blastn 12209 484 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
13153737 13153737 PRJNA376117_P_NODE_35411_length_250_cov_0.870056_g35109_i0 PRJNA376117 35411 250 0.870056 2.17514 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 318 2.02e-82   NTclustered gi|2386256529|ref|XM_001454228.2| 5888 g35109 i0 89.879 1.988 247 25 99 0 4 250 263 17 Paramecium tetraurelia uncharacterized protein (GSPATT00020530001), partial mRNA blastn 497 318 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
13827310 13827310 PRJNA376117_P_NODE_8151_length_469_cov_27.161616_g7850_i0 PRJNA376117 8151 469 27.161616 127.38797904 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 845 0   NTclustered gi|21780011|gb|AF508758.1| 99926 g7850 i0 99.147 98.6673773987207 469 4 100 0 1 469 2260 2728 Gastrostyla steinii 17S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence blastn 46275 845 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Gastrostyla Gastrostyla steinii
14428844 14428844 PRJNA376117_P_NODE_42772_length_242_cov_2.426036_g42470_i0 PRJNA376117 42772 242 2.426036 5.87100712 Paramecium caudatum 5885 SAR_Eukaryotes SAR_Eukaryotes 346 8.930000000000001e-91   NTclustered gi|299830252|ref|NC_014262.1| 5885 g42470 i0 92.276 47.004132231405 246 15 100 4 1 242 964 719 Paramecium caudatum mitochondrion, complete genome blastn 11375 346 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium caudatum
15702505 15702505 PRJNA376117_P_NODE_21833_length_296_cov_1.035874_g21531_i0 PRJNA376117 21833 296 1.035874 3.06618704 Paramecium caudatum 5885 SAR_Eukaryotes SAR_Eukaryotes 407 5.089999999999999e-109   NTclustered gi|299830252|ref|NC_014262.1| 5885 g21531 i0 91.554 13.4662162162162 296 24 100 1 1 296 1963 1669 Paramecium caudatum mitochondrion, complete genome blastn 3986 407 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium caudatum
18251322 18251322 PRJNA376117_P_NODE_15215_length_351_cov_2.877698_g14913_i0 PRJNA376117 15215 351 2.877698 10.10071998 Leptopharynx costatus 502090 SAR_Eukaryotes SAR_Eukaryotes 568 2.6599999999999998e-157   NTclustered gi|558697263|gb|KC832958.1| 502090 g14913 i0 96.067 95.2250712250712 356 1 98 1 1 343 356 1 Leptopharynx costatus 28S ribosomal RNA gene, partial sequence blastn 33424 568 1 Eukaryota Sar   Ciliophora Nassophorea Microthoracida Microthoracidae Leptopharynx Leptopharynx costatus
19526008 19526008 PRJNA376117_P_NODE_5176_length_598_cov_1.352381_g4882_i0 PRJNA376117 5176 598 1.352381 8.08723838 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 911 0   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g4882 i0 94.157 67.1672240802676 599 33 100 2 1 598 16 613 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 40166 911 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
21475515 21475515 PRJNA376117_P_NODE_42717_length_243_cov_0.882353_g42415_i0 PRJNA376117 42717 243 0.882353 2.14411779 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 422 1.45e-113   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g42415 i0 97.942 93.156378600823 243 5 100 0 1 243 880 1122 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 22637 422 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
23351666 23351666 PRJNA376117_P_NODE_15839_length_345_cov_1.801471_g15537_i0 PRJNA376117 15839 345 1.801471 6.21507495 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 276 1.78e-69   NTclustered gi|471233183|ref|XM_004037588.1| 5932 g15537 i0 83.729 41.9855072463768 295 44 85 4 51 343 93 385 Ichthyophthirius multifiliis tubulin beta, putative (IMG5_047220) mRNA, complete cds blastn 14485 276 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis

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