contig_metadata
21 rows where bioproject = "PRJNA177642" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 365436 | 365436 | PRJNA177642_P_NODE_15641_length_183_cov_2.012987_g14416_i0 | PRJNA177642 | 15641 | 183 | 2.012987 | 3.68376621 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 5.109999999999999e-67 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g14416 | i0 | 92.896 | 3 | 183 | 13 | 100 | 0 | 1 | 183 | 445 | 627 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 549 | 267 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 6157847 | 6157847 | PRJNA177642_P_NODE_14225_length_218_cov_1.634921_g13000_i0 | PRJNA177642 | 14225 | 218 | 1.634921 | 3.56412778 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 2.92e-70 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g13000 | i0 | 98.113 | 3.64220183486239 | 159 | 3 | 73 | 0 | 1 | 159 | 2924 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 794 | 278 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 8707891 | 8707891 | PRJNA177642_P_NODE_5527_length_604_cov_3.186087_g4450_i0 | PRJNA177642 | 5527 | 604 | 3.186087 | 19.24396548 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 575 | 2.869999999999999e-159 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g4450 | i0 | 97.067 | 54.8791390728477 | 341 | 10 | 98 | 0 | 264 | 604 | 2345 | 2005 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 33147 | 580 | 0.991379310344828 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 11843985 | 11843985 | PRJNA177642_P_NODE_13410_length_253_cov_1.250000_g12185_i0 | PRJNA177642 | 13410 | 253 | 1.25 | 3.1625 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 88.2 | 4.35e-18 | NR | OMJ89868.1 | 5963 | g12185 | i0 | 49.4 | 16.4110671936759 | 83 | 42 | 98.4 | 0 | 249 | 1 | 577 | 659 | OMJ89868.1 hypothetical protein SteCoe_7852 [Stentor coeruleus] | diamond | 4152 | 89 | 0.991011235955056 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 11844021 | 11844021 | PRJNA177642_P_NODE_15410_length_188_cov_1.169811_g14185_i0 | PRJNA177642 | 15410 | 188 | 1.169811 | 2.19924468 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 8.72e-75 | NTclustered | gi|347439295|gb|JN111996.1| | 151077 | g14185 | i0 | 94.681 | 96.8351063829787 | 188 | 10 | 100 | 0 | 1 | 188 | 556 | 369 | Chilodonella uncinata strain USA_SC2 alpha-tubulin (atub) gene, partial cds; macronuclear | blastn | 18205 | 292 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 15668434 | 15668434 | PRJNA177642_P_NODE_5193_length_629_cov_3.531667_g4136_i0 | PRJNA177642 | 5193 | 629 | 3.531667 | 22.21418543 | root | 1 | Root_unresolved | Root_unresolved | 163 | 3.2199999999999996e-45 | NR | OMJ94284.1 | 5963 | g4136 | i0 | 54 | 16.2352941176471 | 163 | 72 | 76.8 | 2 | 628 | 146 | 147 | 308 | OMJ94284.1 hypothetical protein SteCoe_2628 [Stentor coeruleus] | diamond | 10212 | 164 | 0.99390243902439 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 16357511 | 16357511 | PRJNA177642_P_NODE_13253_length_264_cov_4.123404_g12028_i0 | PRJNA177642 | 13253 | 264 | 4.123404 | 10.88578656 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 477 | 3.359999999999999e-130 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g12028 | i0 | 99.242 | 14.1931818181818 | 264 | 2 | 100 | 0 | 1 | 264 | 1775 | 1512 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 3747 | 477 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 18906585 | 18906585 | PRJNA177642_P_NODE_18595_length_162_cov_1.082707_g17370_i0 | PRJNA177642 | 18595 | 162 | 1.082707 | 1.75398534 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 4.36e-77 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g17370 | i0 | 100 | 26.962962962963 | 162 | 0 | 100 | 0 | 1 | 162 | 1209 | 1370 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 4368 | 300 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 22042309 | 22042309 | PRJNA177642_P_NODE_7558_length_459_cov_1.527907_g6371_i0 | PRJNA177642 | 7558 | 459 | 1.527907 | 7.01309313 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 2.4299999999999997e-69 | NTclustered | gi|158347525|gb|EU047814.1| | 151077 | g6371 | i0 | 93.085 | 36.7712418300654 | 188 | 13 | 41 | 0 | 271 | 458 | 97 | 284 | Chilodonella uncinata clone Shared_P1 beta-tubulin gene, partial cds; macronuclear | blastn | 16878 | 276 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24007062 | 24007062 | PRJNA177642_P_NODE_10999_length_334_cov_2.219672_g9774_i0 | PRJNA177642 | 10999 | 334 | 2.219672 | 7.41370448 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 1.36e-50 | NTclustered | gi|13194559|gb|AF300281.1|AF300281 | 151077 | g9774 | i0 | 99.16 | 55.7904191616766 | 119 | 0 | 68 | 1 | 1 | 118 | 1656 | 1538 | Chilodonella uncinata clone 1 18S small subunit ribosomal RNA gene, partial sequence | blastn | 18634 | 213 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 26662118 | 26662118 | PRJNA177642_P_NODE_3761_length_780_cov_6.478029_g2850_i0 | PRJNA177642 | 3761 | 780 | 6.478029 | 50.5286262 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 6.16e-7 | NR | CDW86772.1 | 5949 | g2850 | i0 | 37.6 | 0.480769230769231 | 125 | 68 | 45.4 | 5 | 60 | 413 | 18 | 139 | CDW86772.1 UNKNOWN [Stylonychia lemnae] | diamond | 375 | 59.3 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 27028489 | 27028489 | PRJNA177642_P_NODE_13802_length_234_cov_1.160976_g12577_i0 | PRJNA177642 | 13802 | 234 | 1.160976 | 2.71668384 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 3.07e-18 | NR | XP_001435272.1 | 5888 | g12577 | i0 | 53.8 | 4.03846153846154 | 78 | 35 | 98.7 | 1 | 1 | 231 | 189 | 266 | XP_001435272.1 uncharacterized protein GSPATT00036656001 [Paramecium tetraurelia] | diamond | 945 | 87.4 | 0.995423340961098 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 27597401 | 27597401 | PRJNA177642_P_NODE_15764_length_181_cov_1.763158_g14539_i0 | PRJNA177642 | 15764 | 181 | 1.763158 | 3.19131598 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 2.16e-17 | NR | KRW98416.1 | 266149 | g14539 | i0 | 69 | 6.7292817679558 | 58 | 18 | 96.1 | 0 | 179 | 6 | 97 | 154 | KRW98416.1 Ribosomal protein S5 domain 2-type fold [Pseudocohnilembus persalinus] | diamond | 1218 | 84 | 0.990476190476191 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 28021645 | 28021645 | PRJNA177642_P_NODE_5265_length_623_cov_2.183502_g4206_i0 | PRJNA177642 | 5265 | 623 | 2.183502 | 13.60321746 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 175 | 8.5e-52 | NR | CDW89587.1 | 5949 | g4206 | i0 | 57.4 | 0.746388443017656 | 155 | 47 | 66 | 2 | 3 | 413 | 34 | 187 | CDW89587.1 UNKNOWN [Stylonychia lemnae] | diamond | 465 | 175 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 28386547 | 28386547 | PRJNA177642_P_NODE_14686_length_204_cov_1.645714_g13461_i0 | PRJNA177642 | 14686 | 204 | 1.645714 | 3.35725656 | root | 1 | Root_unresolved | Root_unresolved | 103 | 5.9899999999999996e-24 | NR | XP_001437608.1 | 5888 | g13461 | i0 | 76.1 | 13.7647058823529 | 67 | 16 | 98.5 | 0 | 3 | 203 | 410 | 476 | XP_001437608.1 uncharacterized protein GSPATT00038313001 [Paramecium tetraurelia] | diamond | 2808 | 104 | 0.990384615384615 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 29459808 | 29459808 | PRJNA177642_P_NODE_14970_length_198_cov_1.313609_g13745_i0 | PRJNA177642 | 14970 | 198 | 1.313609 | 2.60094582 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 84.7 | 5.49e-19 | NR | CAD8050189.1 | 65129 | g13745 | i0 | 61 | 3.5 | 59 | 23 | 89.4 | 0 | 197 | 21 | 88 | 146 | CAD8050189.1 unnamed protein product [Paramecium sonneborni] | diamond | 693 | 84.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 30200092 | 30200092 | PRJNA177642_P_NODE_17172_length_168_cov_1.035971_g15947_i0 | PRJNA177642 | 17172 | 168 | 1.035971 | 1.74043128 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 9.01e-9 | NR | CAD8208970.1 | 43137 | g15947 | i0 | 52 | 3.57142857142857 | 50 | 24 | 89.3 | 0 | 18 | 167 | 37 | 86 | CAD8208970.1 unnamed protein product [Paramecium octaurelia] | diamond | 600 | 59.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 30642490 | 30642490 | PRJNA177642_P_NODE_13533_length_246_cov_1.658986_g12308_i0 | PRJNA177642 | 13533 | 246 | 1.658986 | 4.08110556 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 97.4 | 1.3899999999999998e-23 | NR | CDW86772.1 | 5949 | g12308 | i0 | 64 | 0.914634146341463 | 75 | 26 | 90.2 | 1 | 3 | 224 | 67 | 141 | CDW86772.1 UNKNOWN [Stylonychia lemnae] | diamond | 225 | 97.4 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 31021837 | 31021837 | PRJNA177642_P_NODE_14975_length_198_cov_1.278107_g13750_i0 | PRJNA177642 | 14975 | 198 | 1.278107 | 2.53065186 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.00782 | NR | KRX07275.1 | 266149 | g13750 | i0 | 37.7 | 1.04545454545455 | 69 | 35 | 92.4 | 2 | 197 | 15 | 76 | 144 | KRX07275.1 hypothetical protein PPERSA_06890 [Pseudocohnilembus persalinus] | diamond | 207 | 43.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 32223737 | 32223737 | PRJNA177642_P_NODE_17198_length_168_cov_1.035971_g15973_i0 | PRJNA177642 | 17198 | 168 | 1.035971 | 1.74043128 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 1.15e-7 | NR | XP_001027342.1 | 312017 | g15973 | i0 | 51.9 | 1.83928571428571 | 52 | 24 | 92.9 | 1 | 164 | 9 | 217 | 267 | XP_001027342.1 papain family cysteine protease [Tetrahymena thermophila SB210] | diamond | 309 | 57 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 32255669 | 32255669 | PRJNA177642_P_NODE_15538_length_185_cov_1.807692_g14313_i0 | PRJNA177642 | 15538 | 185 | 1.807692 | 3.3442302 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 83.6 | 1.36e-18 | NR | AGE89250.1 | 153251 | g14313 | i0 | 71.9 | 3.85945945945946 | 57 | 16 | 92.4 | 0 | 171 | 1 | 89 | 145 | AGE89250.1 60S ribosomal protein L27A [Cryptocaryon irritans] | diamond | 714 | 83.6 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans |
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);;