contig_metadata
18 rows where bioproject = "PRJNA326068" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1069219 | 1069219 | PRJNA326068_P_NODE_7521_length_387_cov_2.142458_g6581_i0 | PRJNA326068 | 7521 | 387 | 2.142458 | 8.29131246 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 4.33e-71 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g6581 | i0 | 97.561 | 48.3772609819121 | 164 | 4 | 42 | 0 | 224 | 387 | 3082 | 2919 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 18722 | 281 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 1664142 | 1664142 | PRJNA326068_P_NODE_18842_length_167_cov_1.673913_g17879_i0 | PRJNA326068 | 18842 | 167 | 1.673913 | 2.79543471 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 1.66e-61 | NTclustered | gi|146181944|ref|XM_001023662.2| | 312017 | g17879 | i0 | 93.413 | 1 | 167 | 11 | 100 | 0 | 1 | 167 | 346 | 180 | Tetrahymena thermophila SB210 60S ribosomal protein L13/L16 partial mRNA | blastn | 167 | 248 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 6767065 | 6767065 | PRJNA326068_P_NODE_9726_length_324_cov_2.444068_g8767_i0 | PRJNA326068 | 9726 | 324 | 2.444068 | 7.91878032 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 233 | 1.01e-56 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g8767 | i0 | 95.833 | 31.1203703703704 | 144 | 6 | 63 | 0 | 181 | 324 | 1141 | 998 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 10083 | 233 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 10593131 | 10593131 | PRJNA326068_P_NODE_19489_length_158_cov_1.573643_g18526_i0 | PRJNA326068 | 19489 | 158 | 1.573643 | 2.48635594 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 86.1 | 1.29e-12 | NTclustered | gi|829188944|ref|XM_001031587.2| | 312017 | g18526 | i0 | 81.731 | 0.658227848101266 | 104 | 17 | 65 | 2 | 1 | 103 | 178 | 76 | Tetrahymena thermophila SB210 60S ribosomal L7Ae-like protein partial mRNA | blastn | 104 | 86.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 13822634 | 13822634 | PRJNA326068_P_NODE_19031_length_164_cov_2.214815_g18068_i0 | PRJNA326068 | 19031 | 164 | 2.214815 | 3.6322966 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 3.42e-78 | NTclustered | gi|158147318|gb|EU047813.1| | 151077 | g18068 | i0 | 100 | 75.4573170731707 | 164 | 0 | 100 | 0 | 1 | 164 | 75 | 238 | Chilodonella uncinata strain ATCC 50194 5.8S ribosomal RNA gene and internal transcribed spacer 2, partial sequence; macronuclear | blastn | 12375 | 303 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 14418269 | 14418269 | PRJNA326068_P_NODE_17692_length_186_cov_2.624204_g16729_i0 | PRJNA326068 | 17692 | 186 | 2.624204 | 4.88101944 | Philasterida sp. | 2006707 | SAR_Eukaryotes | SAR_Eukaryotes | 93.5 | 9.37e-15 | NTclustered | gi|2354193480|gb|OP896969.1| | 2006707 | g16729 | i0 | 87.5 | 40.8172043010753 | 80 | 10 | 43 | 0 | 107 | 186 | 1136 | 1215 | Philasterida sp. strain tDaCF9_52 large subunit ribosomal RNA gene, partial sequence | blastn | 7592 | 93.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasterida sp. | ||||
| 15692119 | 15692119 | PRJNA326068_P_NODE_4693_length_510_cov_6.334719_g3897_i0 | PRJNA326068 | 4693 | 510 | 6.334719 | 32.3070669 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 518 | 4.09e-142 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g3897 | i0 | 94.118 | 27.2823529411765 | 340 | 20 | 67 | 0 | 170 | 509 | 312 | 651 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 13914 | 518 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 15692140 | 15692140 | PRJNA326068_P_NODE_9473_length_330_cov_47.262458_g8516_i0 | PRJNA326068 | 9473 | 330 | 47.262458 | 155.9661114 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.59e-114 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g8516 | i0 | 91.374 | 84.2090909090909 | 313 | 24 | 95 | 3 | 1 | 313 | 97 | 406 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 27789 | 425 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 16966799 | 16966799 | PRJNA326068_P_NODE_4854_length_501_cov_2.542373_g4046_i0 | PRJNA326068 | 4854 | 501 | 2.542373 | 12.73728873 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 859 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g4046 | i0 | 97.605 | 86.0499001996008 | 501 | 12 | 100 | 0 | 1 | 501 | 2024 | 2524 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 43111 | 859 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 19515269 | 19515269 | PRJNA326068_P_NODE_10076_length_315_cov_1.723776_g9117_i0 | PRJNA326068 | 10076 | 315 | 1.723776 | 5.4298944 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 523 | 5.199999999999998e-144 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g9117 | i0 | 95.873 | 98.584126984127 | 315 | 11 | 100 | 1 | 1 | 315 | 1035 | 1347 | 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 | 31054 | 523 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 21470913 | 21470913 | PRJNA326068_P_NODE_20037_length_151_cov_1.704918_g19074_i0 | PRJNA326068 | 20037 | 151 | 1.704918 | 2.57442618 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 2.42e-69 | NTclustered | gi|13194559|gb|AF300281.1|AF300281 | 151077 | g19074 | i0 | 99.338 | 99.1192052980132 | 151 | 1 | 100 | 0 | 1 | 151 | 1542 | 1392 | Chilodonella uncinata clone 1 18S small subunit ribosomal RNA gene, partial sequence | blastn | 14967 | 274 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 28401022 | 28401022 | PRJNA326068_P_NODE_12206_length_267_cov_1.819328_g11243_i0 | PRJNA326068 | 12206 | 267 | 1.819328 | 4.85760576 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 5.4e-9 | NR | CDW74504.1 | 5949 | g11243 | i0 | 64.1 | 0.876404494382023 | 39 | 14 | 43.8 | 0 | 119 | 3 | 70 | 108 | CDW74504.1 histone h2b [Stylonychia lemnae] | diamond | 234 | 59.7 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 28559078 | 28559078 | PRJNA326068_P_NODE_6047_length_446_cov_2.007194_g5168_i0 | PRJNA326068 | 6047 | 446 | 2.007194 | 8.95208524 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 1.01e-29 | NR | KRX01081.1 | 266149 | g5168 | i0 | 45.8 | 1.76233183856502 | 142 | 74 | 95.5 | 1 | 441 | 16 | 1 | 139 | KRX01081.1 hypothetical protein PPERSA_02177 [Pseudocohnilembus persalinus] | diamond | 786 | 115 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 29790117 | 29790117 | PRJNA326068_P_NODE_6731_length_417_cov_1.773196_g5812_i0 | PRJNA326068 | 6731 | 417 | 1.773196 | 7.39422732 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 2.21e-25 | NR | CAI2382183.1 | 5936 | g5812 | i0 | 71.8 | 1 | 71 | 20 | 51.1 | 0 | 214 | 2 | 57 | 127 | CAI2382183.1 unnamed protein product [Moneuplotes crassus] | diamond | 417 | 104 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 30264483 | 30264483 | PRJNA326068_P_NODE_14572_length_225_cov_2.714286_g13609_i0 | PRJNA326068 | 14572 | 225 | 2.714286 | 6.1071435 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 1.11e-12 | NR | CAD8206115.1 | 43137 | g13609 | i0 | 54.1 | 1.97333333333333 | 74 | 33 | 97.3 | 1 | 219 | 1 | 1 | 74 | CAD8206115.1 unnamed protein product [Paramecium octaurelia] | diamond | 444 | 68.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 31703771 | 31703771 | PRJNA326068_P_NODE_10577_length_303_cov_1.835766_g9616_i0 | PRJNA326068 | 10577 | 303 | 1.835766 | 5.56237098 | Spirotrichea | 33829 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 6.369999999999998e-42 | NR | CAI2382183.1 | 5936 | g9616 | i0 | 73 | 50.4950495049505 | 100 | 26 | 99 | 1 | 301 | 2 | 45 | 143 | CAI2382183.1 unnamed protein product [Moneuplotes crassus] | diamond | 15300 | 144 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 32477617 | 32477617 | PRJNA326068_P_NODE_16939_length_199_cov_1.723529_g15976_i0 | PRJNA326068 | 16939 | 199 | 1.723529 | 3.42982271 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 47 | 2.81e-4 | NR | KRW99836.1 | 266149 | g15976 | i0 | 43.6 | 0.829145728643216 | 55 | 30 | 81.4 | 1 | 196 | 35 | 56 | 110 | KRW99836.1 hypothetical protein PPERSA_10955 [Pseudocohnilembus persalinus] | diamond | 165 | 47 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 32683902 | 32683902 | PRJNA326068_P_NODE_14640_length_224_cov_4.030769_g13677_i0 | PRJNA326068 | 14640 | 224 | 4.030769 | 9.02892256 | Spirotrichea | 33829 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 4.41e-29 | NR | O97484.1 | 5936 | g13677 | i0 | 63.5 | 14.8660714285714 | 74 | 27 | 99.1 | 0 | 224 | 3 | 20 | 93 | O97484.1 RecName: Full=Histone H2B [Moneuplotes crassus] | diamond | 3330 | 109 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus |
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);;