RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA505329" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 20 ✖

tax_clade 1

bioproject 1

  • PRJNA505329 · 20 ✖

analysis 1

  • blastn · 20 ✖

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
2385819 2385819 PRJNA505329_P_NODE_2502_length_605_cov_2.102518_g2088_i0 PRJNA505329 2502 605 2.102518 12.7202339 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 730 0   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g2088 i0 94.503 36.7107438016529 473 26 94 0 133 605 98 570 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 22210 730 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
2385822 2385822 PRJNA505329_P_NODE_25522_length_194_cov_1.841379_g25051_i0 PRJNA505329 25522 194 1.841379 3.57227526 Pseudocohnilembus 35103 SAR_Eukaryotes SAR_Eukaryotes 350 5.3e-92   NTclustered gi|390988054|gb|JN885122.1| 223571 g25051 i0 99.479 88.8711340206186 192 1 99 0 3 194 162 353 Pseudocohnilembus hargisi isolate JJM2010031301 large subunit ribsomal RNA gene, partial sequence blastn 17241 350 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus hargisi
2385872 2385872 PRJNA505329_P_NODE_35362_length_179_cov_1.584615_g34891_i0 PRJNA505329 35362 179 1.584615 2.83646085 Euplotes 5935 SAR_Eukaryotes SAR_Eukaryotes 320 3.76e-83   NTclustered gi|1516250946|gb|MK177633.1| 343864 g34891 i0 99.432 98.608938547486 176 1 98 0 1 176 653 828 Uncultured Euplotes sp. clone DDI217.fa small subunit ribosomal RNA gene, partial sequence blastn 17651 320 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes uncultured Euplotes sp.
5587045 5587045 PRJNA505329_P_NODE_24445_length_195_cov_5.287671_g23974_i0 PRJNA505329 24445 195 5.287671 10.31095845 Euplotes aediculatus 5940 SAR_Eukaryotes SAR_Eukaryotes 228 2.609999999999999e-55   NTclustered gi|6980030|gb|AF223571.1|AF223571 5940 g23974 i0 88.205 5.8 195 17 98 6 5 195 3704 3896 Euplotes aediculatus internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 1131 228 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes aediculatus
8136609 8136609 PRJNA505329_P_NODE_3927_length_419_cov_4.724324_g3463_i0 PRJNA505329 3927 419 4.724324 19.79491756 Tetrahymena sp. KGE15 1200497 SAR_Eukaryotes SAR_Eukaryotes 734 0   NTclustered gi|523704203|emb|HE861887.1| 1200497 g3463 i0 98.786 72.744630071599 412 5 98 0 3 414 106 517 Tetrahymena sp. KGE15 partial 28S rRNA gene, strain KGE15 blastn 30480 734 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena sp. KGE15
11313399 11313399 PRJNA505329_P_NODE_17129_length_226_cov_3.214689_g16658_i0 PRJNA505329 17129 226 3.214689 7.26519714 Euplotes 5935 SAR_Eukaryotes SAR_Eukaryotes 405 1.34e-108   NTclustered gi|1233819925|gb|KX516617.1| 440145 g16658 i0 100 95.0530973451327 219 0 97 0 5 223 304 86 Euplotes encysticus isolate B555 large subunit ribosomal RNA gene, partial sequence blastn 21482 405 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes encysticus
11313649 11313649 PRJNA505329_P_NODE_8629_length_246_cov_3.309645_g8158_i0 PRJNA505329 8629 246 3.309645 8.1417267 root 1 Root_unresolved Root_unresolved 446 8.719999999999999e-121   NTclustered gi|1621572405|gb|MH051920.1| 5893 g8158 i0 99.59 99.1869918699187 244 1 99 0 1 244 1014 771 Tetrahymena borealis strain 1630/5A small subunit ribosomal RNA gene, partial sequence blastn 24400 446 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena borealis
12589389 12589389 PRJNA505329_P_NODE_5230_length_336_cov_3.616725_g4760_i0 PRJNA505329 5230 336 3.616725 12.152196 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 577 4.229999999999999e-160   NTclustered gi|10782|emb|X54004.1| 5908 g4760 i0 97.898 86.3392857142857 333 7 99 0 4 336 1586 1918 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 29010 582 0.991408934707904 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
13864047 13864047 PRJNA505329_P_NODE_24831_length_195_cov_1.020548_g24360_i0 PRJNA505329 24831 195 1.020548 1.9900686 Euplotes 5935 SAR_Eukaryotes SAR_Eukaryotes 346 6.9e-91   NTclustered gi|1233819925|gb|KX516617.1| 440145 g24360 i0 98.969 81.8153846153846 194 0 98 2 4 195 1572 1765 Euplotes encysticus isolate B555 large subunit ribosomal RNA gene, partial sequence blastn 15954 346 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes encysticus
17060770 17060770 PRJNA505329_P_NODE_34974_length_179_cov_4.453846_g34503_i0 PRJNA505329 34974 179 4.453846 7.97238434 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 324 2.91e-84   NTclustered gi|2651357791|gb|PP174306.1| 41631 g34503 i0 100 28 175 0 98 0 2 176 3855 3681 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 5012 324 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
18335024 18335024 PRJNA505329_P_NODE_30375_length_186_cov_4.474453_g29904_i0 PRJNA505329 30375 186 4.474453 8.32248258 Opisthonecta sp. FG-2015 1607889 SAR_Eukaryotes SAR_Eukaryotes 320 3.95e-83   NTclustered gi|759083562|gb|KM222179.1| 1607889 g29904 i0 98.352 92.8172043010753 182 3 98 0 3 184 1652 1471 Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence blastn 17264 320 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Opisthonectidae Opisthonecta Opisthonecta sp. FG-2015
18335341 18335341 PRJNA505329_P_NODE_7975_length_257_cov_3.716346_g7504_i0 PRJNA505329 7975 257 3.716346 9.55100922 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 252 2.15e-62   NTclustered gi|10782|emb|X54004.1| 5908 g7504 i0 100 85.715953307393 136 0 93 0 3 138 967 1102 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 22029 252 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
19609527 19609527 PRJNA505329_P_NODE_42556_length_168_cov_3.428571_g42085_i0 PRJNA505329 42556 168 3.428571 5.75999928 Rimostrombidium veniliae 702563 SAR_Eukaryotes SAR_Eukaryotes 267 4.63e-67   NTclustered gi|759083533|gb|KM222150.1| 702563 g42085 i0 96.296 96.3035714285714 162 6 96 0 4 165 1428 1267 Rimostrombidium veniliae voucher LWW07042901 large subunit ribosomal RNA gene, partial sequence blastn 16179 267 1 Eukaryota Sar   Ciliophora Spirotrichea Choreotrichida Strobilidiidae Rimostrombidium Rimostrombidium veniliae
19609614 19609614 PRJNA505329_P_NODE_50256_length_161_cov_5.232143_g49785_i0 PRJNA505329 50256 161 5.232143 8.42375023 uncultured Peritrichia 282477 SAR_Eukaryotes SAR_Eukaryotes 291 2.6e-74   NTclustered gi|1151071409|gb|KX926086.1| 282477 g49785 i0 100 92.6211180124224 157 0 98 0 4 160 574 730 Uncultured Peritrichia clone Peri1370F_S_39 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 14912 291 1 Eukaryota Sar   Ciliophora Oligohymenophorea       uncultured Peritrichia
20885701 20885701 PRJNA505329_P_NODE_7337_length_270_cov_2.733032_g6866_i0 PRJNA505329 7337 270 2.733032 7.3791864 Chilodonella hexasticha 1938391 SAR_Eukaryotes SAR_Eukaryotes 318 2.21e-82   NTclustered gi|1389430805|gb|MH341633.1| 1938391 g6866 i0 88.235 3.42592592592593 272 24 99 6 2 269 1931 2198 Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence blastn 925 318 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella hexasticha
20885724 20885724 PRJNA505329_P_NODE_9397_length_236_cov_2.449198_g8926_i0 PRJNA505329 9397 236 2.449198 5.78010728 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 407 3.92e-109   NTclustered gi|10782|emb|X54004.1| 5908 g8926 i0 97.872 24.4237288135593 235 5 99 0 2 236 1945 2179 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 5764 407 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
21512332 21512332 PRJNA505329_P_NODE_42717_length_168_cov_2.571429_g42246_i0 PRJNA505329 42717 168 2.571429 4.32000072 root 1 Root_unresolved Root_unresolved 305 9.81e-79   NTclustered gi|1837628855|gb|MN158348.1| 5909 g42246 i0 100 99.6607142857143 165 0 98 0 4 168 5238 5402 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 16743 305 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
21512361 21512361 PRJNA505329_P_NODE_47537_length_164_cov_1.173913_g47066_i0 PRJNA505329 47537 164 1.173913 1.92521732 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 287 3.45e-73   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g47066 i0 98.758 25.3658536585366 161 2 98 0 1 161 1888 1728 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 4160 287 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
22160339 22160339 PRJNA505329_P_NODE_5538_length_323_cov_2.740876_g5067_i0 PRJNA505329 5538 323 2.740876 8.85302948 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 553 6.819999999999998e-153   NTclustered gi|10782|emb|X54004.1| 5908 g5067 i0 98.119 52.7801857585139 319 2 99 1 4 322 2979 3293 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 17048 553 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
24709469 24709469 PRJNA505329_P_NODE_42900_length_168_cov_1.722689_g42429_i0 PRJNA505329 42900 168 1.722689 2.89411752 Opercularia sp. ZhW-2019a 2582953 SAR_Eukaryotes SAR_Eukaryotes 294 2.12e-75   NTclustered gi|2304601486|gb|OP458307.1| 2582953 g42429 i0 98.788 93.1011904761905 165 2 98 0 1 165 272 108 Opercularia sp. ZhW-2019a large subunit ribosomal RNA gene, partial sequence blastn 15641 294 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Operculariidae Opercularia Opercularia sp. ZhW-2019a

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