contig_metadata
22 rows where bioproject = "PRJNA1111448" and tax_phylum = "Ciliophora"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1492131 | 1492131 | PRJNA1111448_S_NODE_12482_length_545_cov_2.379237_g11682_i0 | PRJNA1111448 | 12482 | 545 | 2.379237 | 12.96684165 | Opercularia sp. ZhW-2019a | 2582953 | SAR_Eukaryotes | SAR_Eukaryotes | 752 | 0 | NTclustered | gi|2304601486|gb|OP458307.1| | 2582953 | g11682 | i0 | 91.621 | 75.6036697247706 | 549 | 39 | 100 | 5 | 1 | 545 | 583 | 38 | Opercularia sp. ZhW-2019a large subunit ribosomal RNA gene, partial sequence | blastn | 41204 | 752 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Operculariidae | Opercularia | Opercularia sp. ZhW-2019a | ||
| 2298026 | 2298026 | PRJNA1111448_S_NODE_142562_length_229_cov_3.032051_g141739_i0 | PRJNA1111448 | 142562 | 229 | 3.032051 | 6.94339679 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 424 | 3.76e-114 | NTclustered | gi|363412153|gb|JN120227.1| | 60850 | g141739 | i0 | 100 | 100 | 229 | 0 | 100 | 0 | 1 | 229 | 1480 | 1252 | Vorticella convallaria isolate 96Vorsp16 18S ribosomal RNA gene, partial sequence | blastn | 22900 | 424 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella convallaria | ||
| 2298048 | 2298048 | PRJNA1111448_S_NODE_16402_length_497_cov_18.224057_g15587_i0 | PRJNA1111448 | 16402 | 497 | 18.224057 | 90.57356329 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 913 | 0 | NTclustered | gi|10662|emb|X56170.1| | 5894 | g15587 | i0 | 99.799 | 99.215291750503 | 497 | 1 | 100 | 0 | 1 | 497 | 575 | 79 | T.canadensis gene for small subunit ribosomal RNA (16S like rRNA) | blastn | 49310 | 918 | 0.994553376906318 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena canadensis | ||
| 2298379 | 2298379 | PRJNA1111448_S_NODE_80162_length_295_cov_7.049550_g79339_i0 | PRJNA1111448 | 80162 | 295 | 7.04955 | 20.7961725 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 545 | 1.03e-150 | NTclustered | gi|1621572405|gb|MH051920.1| | 5893 | g79339 | i0 | 100 | 99.9830508474576 | 295 | 0 | 100 | 0 | 1 | 295 | 1506 | 1212 | Tetrahymena borealis strain 1630/5A small subunit ribosomal RNA gene, partial sequence | blastn | 29495 | 545 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena borealis | ||
| 2767989 | 2767989 | PRJNA1111448_S_NODE_114403_length_256_cov_17.628415_g113580_i0 | PRJNA1111448 | 114403 | 256 | 17.628415 | 45.1287424 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 446 | 9.139999999999999e-121 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g113580 | i0 | 98.047 | 59.6796875 | 256 | 5 | 100 | 0 | 1 | 256 | 2182 | 1927 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 15278 | 446 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 2768562 | 2768562 | PRJNA1111448_S_NODE_40023_length_374_cov_1.717608_g39200_i0 | PRJNA1111448 | 40023 | 374 | 1.717608 | 6.42385392 | Vorticella sp. 1 | 2979179 | SAR_Eukaryotes | SAR_Eukaryotes | 614 | 3.619999999999999e-171 | NTclustered | gi|2304601489|gb|OP458310.1| | 2979179 | g39200 | i0 | 96.267 | 92.8983957219251 | 375 | 13 | 100 | 1 | 1 | 374 | 1838 | 1464 | Vorticella sp. 1 large subunit ribosomal RNA gene, partial sequence | blastn | 34744 | 614 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 1 | ||
| 4850882 | 4850882 | PRJNA1111448_S_NODE_63024_length_322_cov_1.855422_g62201_i0 | PRJNA1111448 | 63024 | 322 | 1.855422 | 5.97445884 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 525 | 1.4799999999999995e-144 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g62201 | i0 | 96.25 | 38.6521739130435 | 320 | 12 | 99 | 0 | 1 | 320 | 329 | 10 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 12446 | 525 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 7870116 | 7870116 | PRJNA1111448_S_NODE_10907_length_570_cov_2.356137_g10120_i0 | PRJNA1111448 | 10907 | 570 | 2.356137 | 13.4299809 | Opercularia sp. ZhW-2019a | 2582953 | SAR_Eukaryotes | SAR_Eukaryotes | 1018 | 0 | NTclustered | gi|2304601486|gb|OP458307.1| | 2582953 | g10120 | i0 | 99.117 | 78.3087719298246 | 566 | 5 | 99 | 0 | 5 | 570 | 18 | 583 | Opercularia sp. ZhW-2019a large subunit ribosomal RNA gene, partial sequence | blastn | 44636 | 1018 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Operculariidae | Opercularia | Opercularia sp. ZhW-2019a | ||
| 7870886 | 7870886 | PRJNA1111448_S_NODE_50747_length_346_cov_2.263736_g49924_i0 | PRJNA1111448 | 50747 | 346 | 2.263736 | 7.83252656 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 592 | 1.5599999999999996e-164 | NTclustered | gi|1389430805|gb|MH341633.1| | 1938391 | g49924 | i0 | 97.674 | 79.1156069364162 | 344 | 8 | 99 | 0 | 3 | 346 | 1982 | 2325 | Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence | blastn | 27374 | 592 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 8675962 | 8675962 | PRJNA1111448_S_NODE_30947_length_405_cov_19.400602_g30124_i0 | PRJNA1111448 | 30947 | 405 | 19.400602 | 78.5724381 | root | 1 | Root_unresolved | Root_unresolved | 726 | 0 | NTclustered | gi|345541658|gb|JN547815.1| | 5911 | g30124 | i0 | 99.012 | 84.6123456790123 | 405 | 4 | 100 | 0 | 1 | 405 | 3402 | 3806 | Tetrahymena thermophila strain ATCC 30382 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence | blastn | 34268 | 726 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 9145445 | 9145445 | PRJNA1111448_S_NODE_21368_length_457_cov_2.018229_g20546_i0 | PRJNA1111448 | 21368 | 457 | 2.018229 | 9.22330653 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 717 | 0 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g20546 | i0 | 94.989 | 71.2844638949672 | 459 | 19 | 100 | 2 | 1 | 457 | 2083 | 1627 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 32577 | 717 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 9145886 | 9145886 | PRJNA1111448_S_NODE_65228_length_318_cov_2.542857_g64405_i0 | PRJNA1111448 | 65228 | 318 | 2.542857 | 8.08628526 | Euplotes aediculatus | 5940 | SAR_Eukaryotes | SAR_Eukaryotes | 556 | 5.18e-154 | NTclustered | gi|6980030|gb|AF223571.1|AF223571 | 5940 | g64405 | i0 | 100 | 92.6603773584906 | 301 | 0 | 95 | 0 | 18 | 318 | 561 | 861 | Euplotes aediculatus internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 29466 | 556 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes aediculatus | ||
| 9950823 | 9950823 | PRJNA1111448_S_NODE_24768_length_435_cov_6.500000_g23945_i0 | PRJNA1111448 | 24768 | 435 | 6.5 | 28.275 | root | 1 | Root_unresolved | Root_unresolved | 761 | 0 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g23945 | i0 | 98.174 | 86.5310344827586 | 438 | 5 | 100 | 3 | 1 | 435 | 1943 | 1506 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 37641 | 761 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 13776058 | 13776058 | PRJNA1111448_S_NODE_47551_length_353_cov_22.910714_g46728_i0 | PRJNA1111448 | 47551 | 353 | 22.910714 | 80.87482042 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 647 | 0 | NTclustered | gi|1172880852|gb|KY864168.1| | 5909 | g46728 | i0 | 99.717 | 99.9773371104816 | 353 | 1 | 100 | 0 | 1 | 353 | 596 | 948 | Tetrahymena rostrata isolate TR 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 | 35292 | 652 | 0.992331288343558 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 14246331 | 14246331 | PRJNA1111448_S_NODE_117012_length_254_cov_1.475138_g116189_i0 | PRJNA1111448 | 117012 | 254 | 1.475138 | 3.74685052 | Plagiopyla sp. QZ-2012 | 1143721 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.18e-114 | NTclustered | gi|375305427|gb|JF975387.1| | 1143721 | g116189 | i0 | 97.244 | 87.8346456692913 | 254 | 2 | 100 | 3 | 1 | 254 | 617 | 865 | Plagiopyla sp. QZ-2012 28S ribosomal RNA gene, partial sequence | blastn | 22310 | 425 | 1 | Eukaryota | Sar | Ciliophora | Plagiopylea | Plagiopylida | Plagiopylidae | Plagiopyla | Plagiopyla sp. QZ-2012 | ||
| 14246610 | 14246610 | PRJNA1111448_S_NODE_141352_length_234_cov_2.391304_g140529_i0 | PRJNA1111448 | 141352 | 234 | 2.391304 | 5.59565136 | uncultured Chilodonella | 1284377 | SAR_Eukaryotes | SAR_Eukaryotes | 368 | 1.8299999999999999e-97 | NTclustered | gi|1354561575|gb|MH022944.1| | 1284377 | g140529 | i0 | 94.915 | 77.6752136752137 | 236 | 10 | 100 | 2 | 1 | 234 | 62 | 297 | Uncultured Chilodonella clone OTU163 small subunit ribosomal RNA gene, partial sequence | blastn | 18176 | 368 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | uncultured Chilodonella | |||||
| 15520075 | 15520075 | PRJNA1111448_S_NODE_11753_length_556_cov_17.598344_g10962_i0 | PRJNA1111448 | 11753 | 556 | 17.598344 | 97.84679264 | Tetrahymena sp. KGE15 | 1200497 | SAR_Eukaryotes | SAR_Eukaryotes | 1002 | 0 | NTclustered | gi|523704203|emb|HE861887.1| | 1200497 | g10962 | i0 | 99.457 | 71.5467625899281 | 552 | 2 | 99 | 1 | 1 | 551 | 552 | 1 | Tetrahymena sp. KGE15 partial 28S rRNA gene, strain KGE15 | blastn | 39780 | 1002 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena sp. KGE15 | ||
| 18069252 | 18069252 | PRJNA1111448_S_NODE_136095_length_242_cov_2.248521_g135272_i0 | PRJNA1111448 | 136095 | 242 | 2.248521 | 5.44142082 | Tetrahymena acanthophora | 2704174 | SAR_Eukaryotes | SAR_Eukaryotes | 431 | 2.4e-116 | NTclustered | gi|2082965250|gb|MZ827090.1| | 2704174 | g135272 | i0 | 98.76 | 99.198347107438 | 242 | 3 | 100 | 0 | 1 | 242 | 750 | 509 | Tetrahymena acanthophora isolate NB176 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 | 24006 | 431 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena acanthophora | ||
| 18069438 | 18069438 | PRJNA1111448_S_NODE_27255_length_422_cov_2.401146_g26432_i0 | PRJNA1111448 | 27255 | 422 | 2.401146 | 10.13283612 | Opercularia sp. ZhW-2019a | 2582953 | SAR_Eukaryotes | SAR_Eukaryotes | 682 | 0 | NTclustered | gi|2304601486|gb|OP458307.1| | 2582953 | g26432 | i0 | 99.731 | 82.8838862559242 | 372 | 1 | 88 | 0 | 51 | 422 | 1843 | 1472 | Opercularia sp. ZhW-2019a large subunit ribosomal RNA gene, partial sequence | blastn | 34977 | 682 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Operculariidae | Opercularia | Opercularia sp. ZhW-2019a | ||
| 18069534 | 18069534 | PRJNA1111448_S_NODE_36655_length_384_cov_8.909968_g35832_i0 | PRJNA1111448 | 36655 | 384 | 8.909968 | 34.21427712 | Colpoda sp. 2-SMaurya-2022 | 3384729 | SAR_Eukaryotes | SAR_Eukaryotes | 688 | 0 | NTclustered | gi|2178724620|gb|OM278536.1| | 3384729 | g35832 | i0 | 98.958 | 98.6927083333333 | 384 | 4 | 100 | 0 | 1 | 384 | 551 | 934 | Colpoda sp. 2-SMaurya-2022 strain J21 small subunit ribosomal RNA gene, partial sequence | blastn | 37898 | 688 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. 2-SMaurya-2022 | ||
| 20618885 | 20618885 | PRJNA1111448_S_NODE_19277_length_472_cov_3.197995_g18456_i0 | PRJNA1111448 | 19277 | 472 | 3.197995 | 15.0945364 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 723 | 0 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g18456 | i0 | 94.48 | 67.3283898305085 | 471 | 22 | 99 | 4 | 4 | 472 | 3980 | 3512 | Colpoda sp. isolate CIL1 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 | 31779 | 723 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 22699404 | 22699404 | PRJNA1111448_S_NODE_116518_length_254_cov_5.558011_g115695_i0 | PRJNA1111448 | 116518 | 254 | 5.558011 | 14.11734794 | Colpodida | 88566 | SAR_Eukaryotes | SAR_Eukaryotes | 459 | 1.1599999999999999e-124 | NTclustered | gi|329754432|gb|HM140394.1| | 459237 | g115695 | i0 | 99.213 | 99.4094488188976 | 254 | 2 | 100 | 0 | 1 | 254 | 132 | 385 | Bresslauides discoideus isolate KR-09091401 small subunit ribosomal RNA gene, partial sequence; macronuclear | blastn | 25250 | 459 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Hausmanniellidae | Bresslauides | Bresslauides discoideus |
Advanced export
JSON shape: default, array, newline-delimited
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);;