contig_metadata
23 rows where bioproject = "PRJNA599208" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 572248 | 572248 | PRJNA599208_P_NODE_4161_length_409_cov_8.287634_g3967_i0 | PRJNA599208 | 4161 | 409 | 8.287634 | 33.89642306 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 728 | 0 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g3967 | i0 | 98.778 | 99.838630806846 | 409 | 5 | 100 | 0 | 1 | 409 | 1460 | 1868 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 40834 | 728 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 4399830 | 4399830 | PRJNA599208_P_NODE_10744_length_205_cov_1.166667_g10548_i0 | PRJNA599208 | 10744 | 205 | 1.166667 | 2.39166735 | Opercularia sp. ZhW-2019a | 2582953 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 2.62e-95 | NTclustered | gi|2304601486|gb|OP458307.1| | 2582953 | g10548 | i0 | 98.529 | 95.6536585365854 | 204 | 3 | 99 | 0 | 2 | 205 | 138 | 341 | Opercularia sp. ZhW-2019a large subunit ribosomal RNA gene, partial sequence | blastn | 19609 | 361 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Operculariidae | Opercularia | Opercularia sp. ZhW-2019a | ||
| 4399839 | 4399839 | PRJNA599208_P_NODE_11564_length_193_cov_9.820513_g11368_i0 | PRJNA599208 | 11564 | 193 | 9.820513 | 18.95359009 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 246 | 7.11e-61 | NTclustered | gi|11466252|ref|NC_000862.1| | 5908 | g11368 | i0 | 90.155 | 10.8497409326425 | 193 | 13 | 99 | 6 | 3 | 193 | 32530 | 32342 | Tetrahymena pyriformis mitochondrion, complete genome | blastn | 2094 | 246 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 4399917 | 4399917 | PRJNA599208_P_NODE_3624_length_447_cov_6.080488_g3430_i0 | PRJNA599208 | 3624 | 447 | 6.080488 | 27.17978136 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 737 | 0 | NTclustered | gi|512134942|gb|JX178901.1| | 1295638 | g3430 | i0 | 96.429 | 93.1364653243848 | 448 | 15 | 100 | 1 | 1 | 447 | 1181 | 1628 | Vorticella sp. 4 JG-2011 clone 1 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 | 41632 | 737 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 5676002 | 5676002 | PRJNA599208_P_NODE_6445_length_298_cov_3.199234_g6249_i0 | PRJNA599208 | 6445 | 298 | 3.199234 | 9.53371732 | Vorticella sp. 1 | 2979179 | SAR_Eukaryotes | SAR_Eukaryotes | 545 | 1.04e-150 | NTclustered | gi|2304601489|gb|OP458310.1| | 2979179 | g6249 | i0 | 99.664 | 92.8859060402685 | 298 | 1 | 100 | 0 | 1 | 298 | 1806 | 1509 | Vorticella sp. 1 large subunit ribosomal RNA gene, partial sequence | blastn | 27680 | 545 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 1 | ||
| 6950410 | 6950410 | PRJNA599208_P_NODE_10666_length_206_cov_1.384615_g10470_i0 | PRJNA599208 | 10666 | 206 | 1.384615 | 2.8523069 | Stentor roeselii | 1703786 | SAR_Eukaryotes | SAR_Eukaryotes | 364 | 2.0399999999999993e-96 | NTclustered | gi|921061859|gb|KP970274.1| | 1703786 | g10470 | i0 | 98.544 | 66.4368932038835 | 206 | 3 | 100 | 0 | 1 | 206 | 298 | 93 | Stentor roeselii isolate STR large subunit ribosomal RNA gene, partial sequence | blastn | 13686 | 364 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor roeselii | ||
| 9500616 | 9500616 | PRJNA599208_P_NODE_10608_length_207_cov_1.388235_g10412_i0 | PRJNA599208 | 10608 | 207 | 1.388235 | 2.87364645 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 2.73e-75 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g10412 | i0 | 92.308 | 6.29468599033816 | 208 | 14 | 100 | 2 | 1 | 207 | 115 | 321 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 1303 | 294 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 9500626 | 9500626 | PRJNA599208_P_NODE_11828_length_191_cov_0.961039_g11632_i0 | PRJNA599208 | 11828 | 191 | 0.961039 | 1.83558449 | Tetrahymena nigricans | 2704176 | SAR_Eukaryotes | SAR_Eukaryotes | 353 | 4.02e-93 | NTclustered | gi|2082965251|gb|MZ827091.1| | 2704176 | g11632 | i0 | 100 | 45.0628272251309 | 191 | 0 | 100 | 0 | 1 | 191 | 714 | 524 | Tetrahymena nigricans isolate VB57 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 | 8607 | 353 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena nigricans | ||
| 11344811 | 11344811 | PRJNA599208_P_NODE_2349_length_589_cov_4.947464_g2169_i0 | PRJNA599208 | 2349 | 589 | 4.947464 | 29.14056296 | Dysteriida | 238898 | SAR_Eukaryotes | SAR_Eukaryotes | 479 | 2.249999999999999e-130 | NTclustered | gi|558697265|gb|KC832960.1| | 247150 | g2169 | i0 | 87.77 | 65.8505942275042 | 417 | 42 | 70 | 8 | 161 | 572 | 415 | 3 | Dysteria derouxi 28S ribosomal RNA gene, partial sequence | blastn | 38786 | 479 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Dysteriida | Dysteriidae | Dysteria | Dysteria derouxi | ||
| 12051463 | 12051463 | PRJNA599208_P_NODE_7170_length_277_cov_2.625000_g6974_i0 | PRJNA599208 | 7170 | 277 | 2.625 | 7.27125 | Planilamina ovata | 2684848 | SAR_Eukaryotes | SAR_Eukaryotes | 424 | 4.69e-114 | NTclustered | gi|1784308423|gb|MN830171.1| | 2684848 | g6974 | i0 | 94.224 | 7.60649819494585 | 277 | 16 | 100 | 0 | 1 | 277 | 1473 | 1749 | Planilamina ovata isolate LJ-II-20170502 large subunit ribosomal RNA gene, partial sequence | blastn | 2107 | 424 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Dysteriida | Kyaroikeidae | Planilamina | Planilamina ovata | ||
| 13326191 | 13326191 | PRJNA599208_P_NODE_2451_length_574_cov_10.696462_g2269_i0 | PRJNA599208 | 2451 | 574 | 10.696462 | 61.397691880000004 | Tetrahymena pigmentosa | 5907 | SAR_Eukaryotes | SAR_Eukaryotes | 850 | 0 | NTclustered | gi|114329902|ref|NC_008339.1| | 5907 | g2269 | i0 | 93.684 | 69.5261324041812 | 570 | 33 | 99 | 2 | 1 | 570 | 1297 | 1863 | Tetrahymena pigmentosa mitochondrion, complete genome | blastn | 39908 | 850 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pigmentosa | ||
| 13895515 | 13895515 | PRJNA599208_P_NODE_4491_length_389_cov_2.565341_g4296_i0 | PRJNA599208 | 4491 | 389 | 2.565341 | 9.97917649 | Helicoprorodontidae | 1607782 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 2.14e-29 | NTclustered | gi|375305434|gb|JF975394.1| | 652932 | g4296 | i0 | 91.346 | 28.3933161953728 | 104 | 9 | 27 | 0 | 160 | 263 | 309 | 206 | Trachelotractus entzi isolate LWW07033111 28S ribosomal RNA gene, partial sequence | blastn | 11045 | 143 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | Trachelotractus | Trachelotractus entzi | |||
| 15874916 | 15874916 | PRJNA599208_P_NODE_12493_length_183_cov_2.205479_g12297_i0 | PRJNA599208 | 12493 | 183 | 2.205479 | 4.03602657 | Epistylis cambari | 3044357 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 7e-26 | NTclustered | gi|2500396601|gb|OQ924985.1| | 3044357 | g12297 | i0 | 79.781 | 2.69398907103825 | 183 | 34 | 99 | 3 | 2 | 182 | 561 | 380 | Epistylis cambari isolate WT2021061102 large subunit ribosomal RNA gene, partial sequence | blastn | 493 | 130 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Epistylidae | Epistylis | Epistylis cambari | ||
| 15874935 | 15874935 | PRJNA599208_P_NODE_13873_length_170_cov_2.120301_g13677_i0 | PRJNA599208 | 13873 | 170 | 2.120301 | 3.6045117 | Cyclidium glaucoma | 35100 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 2.89e-44 | NTclustered | gi|111035908|emb|AJ781085.1| | 35100 | g13677 | i0 | 87.059 | 9.61176470588235 | 170 | 21 | 100 | 1 | 1 | 170 | 484 | 652 | Cyclidium glaucoma partial 23S rRNA gene, clone TH14 | blastn | 1634 | 191 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Cyclidiidae | Cyclidium | Cyclidium glaucoma | ||
| 16444227 | 16444227 | PRJNA599208_P_NODE_13613_length_172_cov_11.962963_g13417_i0 | PRJNA599208 | 13613 | 172 | 11.962963 | 20.57629636 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 7.81e-75 | NTclustered | gi|2001232597|gb|MW727190.1| | 5897 | g13417 | i0 | 98.204 | 97.3139534883721 | 167 | 3 | 97 | 0 | 5 | 171 | 148 | 314 | Tetrahymena elliotti isolate Maine201809-7-L2 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence; macronuclear | blastn | 16738 | 294 | 0.993197278911565 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena elliotti | ||
| 17149848 | 17149848 | PRJNA599208_P_NODE_1814_length_693_cov_21.024390_g1660_i0 | PRJNA599208 | 1814 | 693 | 21.02439 | 145.6990227 | Tetrahymena chironomi | 3034767 | SAR_Eukaryotes | SAR_Eukaryotes | 1214 | 0 | NTclustered | gi|2459327221|gb|OQ626840.1| | 3034767 | g1660 | i0 | 98.268 | 72.4126984126984 | 693 | 12 | 100 | 0 | 1 | 693 | 1158 | 466 | Tetrahymena chironomi isolate LLH20220320 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 | 50182 | 1214 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena chironomi | ||
| 18424238 | 18424238 | PRJNA599208_P_NODE_595_length_1342_cov_8.842146_g531_i0 | PRJNA599208 | 595 | 1342 | 8.842146 | 118.66159932 | Tetrahymena pigmentosa | 5907 | SAR_Eukaryotes | SAR_Eukaryotes | 1618 | 0 | NTclustered | gi|114329902|ref|NC_008339.1| | 5907 | g531 | i0 | 88.517 | 60.0961251862891 | 1376 | 107 | 99 | 22 | 2 | 1337 | 33651 | 32287 | Tetrahymena pigmentosa mitochondrion, complete genome | blastn | 80649 | 1618 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pigmentosa | ||
| 19698791 | 19698791 | PRJNA599208_P_NODE_6276_length_304_cov_2.475655_g6080_i0 | PRJNA599208 | 6276 | 304 | 2.475655 | 7.5259912 | Tetrahymena pigmentosa | 5907 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 2.53e-82 | NTclustered | gi|114329902|ref|NC_008339.1| | 5907 | g6080 | i0 | 97.326 | 17.3322368421053 | 187 | 5 | 97 | 0 | 1 | 187 | 1976 | 2162 | Tetrahymena pigmentosa mitochondrion, complete genome | blastn | 5269 | 318 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pigmentosa | ||
| 20267969 | 20267969 | PRJNA599208_P_NODE_6096_length_311_cov_2.408759_g5900_i0 | PRJNA599208 | 6096 | 311 | 2.408759 | 7.49124049 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 1.66e-34 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g5900 | i0 | 95.918 | 0.945337620578778 | 98 | 4 | 32 | 0 | 1 | 98 | 2985 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 294 | 159 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 20974502 | 20974502 | PRJNA599208_P_NODE_15817_length_156_cov_1.075630_g15621_i0 | PRJNA599208 | 15817 | 156 | 1.07563 | 1.6779828 | Dileptus sp. FG-2015 | 1607875 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 4.1899999999999994e-72 | NTclustered | gi|759083535|gb|KM222152.1| | 1607875 | g15621 | i0 | 99.359 | 100.237179487179 | 156 | 1 | 100 | 0 | 1 | 156 | 177 | 332 | Dileptus sp. FG-2015 voucher PHB09033001 large subunit ribosomal RNA gene, partial sequence | blastn | 15637 | 283 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | Dileptidae | Dileptus | Dileptus sp. FG-2015 | ||
| 22249334 | 22249334 | PRJNA599208_P_NODE_14118_length_168_cov_2.358779_g13922_i0 | PRJNA599208 | 14118 | 168 | 2.358779 | 3.96274872 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 3.84e-18 | NTclustered | gi|1004125725|gb|KU761582.1| | 153251 | g13922 | i0 | 91.892 | 0.880952380952381 | 74 | 6 | 44 | 0 | 7 | 80 | 120 | 47 | 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 | 148 | 104 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 22249409 | 22249409 | PRJNA599208_P_NODE_6218_length_306_cov_5.382900_g6022_i0 | PRJNA599208 | 6218 | 306 | 5.3829 | 16.471674 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 547 | 2.9899999999999992e-151 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g6022 | i0 | 99.02 | 51.7058823529412 | 306 | 2 | 100 | 1 | 1 | 306 | 2988 | 3292 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 15822 | 547 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 23524634 | 23524634 | PRJNA599208_P_NODE_3919_length_425_cov_8.729381_g3725_i0 | PRJNA599208 | 3919 | 425 | 8.729381 | 37.09986925 | Tetrahymena pigmentosa | 5907 | SAR_Eukaryotes | SAR_Eukaryotes | 684 | 0 | NTclustered | gi|114329902|ref|NC_008339.1| | 5907 | g3725 | i0 | 95.785 | 39.9317647058824 | 427 | 13 | 100 | 5 | 1 | 425 | 2442 | 2865 | Tetrahymena pigmentosa mitochondrion, complete genome | blastn | 16971 | 684 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pigmentosa |
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);;