contig_metadata
16 rows where bioproject = "PRJNA784979", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1213375 | 1213375 | PRJNA784979_S_NODE_7261_length_188_cov_2.035971_g7219_i0 | PRJNA784979 | 7261 | 188 | 2.035971 | 3.82762548 | root | 1 | Root_unresolved | Root_unresolved | 237 | 4.14e-58 | NTclustered | gi|10832|emb|X54512.1| | 5911 | g7219 | i0 | 89.73 | 21.9095744680851 | 185 | 19 | 98 | 0 | 1 | 185 | 6925 | 6741 | T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA | blastn | 4119 | 237 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 4593820 | 4593820 | PRJNA784979_S_NODE_3544_length_246_cov_1.964467_g3502_i0 | PRJNA784979 | 3544 | 246 | 1.964467 | 4.83258882 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 401 | 1.9199999999999992e-107 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g3502 | i0 | 97.458 | 73.0040650406504 | 236 | 4 | 95 | 2 | 1 | 234 | 2952 | 3187 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 17959 | 401 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 5869063 | 5869063 | PRJNA784979_S_NODE_4525_length_223_cov_1.649425_g4483_i0 | PRJNA784979 | 4525 | 223 | 1.649425 | 3.67821775 | uncultured Peritrichia | 282477 | SAR_Eukaryotes | SAR_Eukaryotes | 383 | 6.18e-102 | NTclustered | gi|1002824186|gb|KU363289.1| | 282477 | g4483 | i0 | 98.618 | 97.1345291479821 | 217 | 2 | 97 | 1 | 7 | 223 | 301 | 86 | Uncultured Peritrichia clone OTU71lengt small subunit ribosomal RNA gene, partial sequence | blastn | 21661 | 383 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | uncultured Peritrichia | |||||
| 7591500 | 7591500 | PRJNA784979_S_NODE_9266_length_172_cov_6.756098_g9224_i0 | PRJNA784979 | 9266 | 172 | 6.756098 | 11.62048856 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 302 | 1.3e-77 | NTclustered | gi|2001232452|gb|MW727123.1| | 5893 | g9224 | i0 | 100 | 94.7674418604651 | 163 | 0 | 95 | 0 | 5 | 167 | 130 | 292 | Tetrahymena borealis isolate 20766-1 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence; macronuclear | blastn | 16300 | 302 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena borealis | ||
| 8418687 | 8418687 | PRJNA784979_S_NODE_6207_length_199_cov_1.666667_g6165_i0 | PRJNA784979 | 6207 | 199 | 1.666667 | 3.31666733 | Tetrahymena rostrata | 5909 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 1.2e-78 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g6165 | i0 | 95.312 | 7.90452261306533 | 192 | 9 | 96 | 0 | 8 | 199 | 5211 | 5020 | 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 | 1573 | 305 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 9693918 | 9693918 | PRJNA784979_S_NODE_3508_length_247_cov_1.929293_g3466_i0 | PRJNA784979 | 3508 | 247 | 1.929293 | 4.76535371 | Planilamina ovata | 2684848 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 4.35e-74 | NTclustered | gi|1784308423|gb|MN830171.1| | 2684848 | g3466 | i0 | 92.271 | 5.2914979757085 | 207 | 13 | 83 | 3 | 42 | 247 | 514 | 718 | Planilamina ovata isolate LJ-II-20170502 large subunit ribosomal RNA gene, partial sequence | blastn | 1307 | 291 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Dysteriida | Kyaroikeidae | Planilamina | Planilamina ovata | ||
| 15241757 | 15241757 | PRJNA784979_S_NODE_10092_length_167_cov_2.474576_g10050_i0 | PRJNA784979 | 10092 | 167 | 2.474576 | 4.13254192 | Hymenostomatida | 31277 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 7.58e-75 | NTclustered | gi|2624665746|gb|OR878271.1| | 210825 | g10050 | i0 | 100 | 61.4850299401198 | 158 | 0 | 95 | 0 | 10 | 167 | 1168 | 1325 | Glaucoma scintillans isolate LLH20220320 large subunit ribosomal RNA gene, partial sequence | blastn | 10268 | 292 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Glaucomidae | Glaucoma | Glaucoma scintillans | ||
| 16068058 | 16068058 | PRJNA784979_S_NODE_3133_length_261_cov_2.452830_g3091_i0 | PRJNA784979 | 3133 | 261 | 2.45283 | 6.4018863 | Philasterides dicentrarchi | 282688 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 2.3e-27 | NTclustered | gi|49616744|gb|AY643504.1| | 282688 | g3091 | i0 | 86.4 | 1.79693486590038 | 125 | 16 | 48 | 1 | 134 | 257 | 101 | 225 | Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence | blastn | 469 | 135 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 18617144 | 18617144 | PRJNA784979_S_NODE_9895_length_169_cov_0.716667_g9853_i0 | PRJNA784979 | 9895 | 169 | 0.716667 | 1.21116723 | Homalozoon vermiculare | 39461 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 4.66e-62 | NTclustered | gi|1226859312|gb|MF474355.1| | 39461 | g9853 | i0 | 95.513 | 29.8757396449704 | 156 | 7 | 92 | 0 | 6 | 161 | 1515 | 1360 | Homalozoon vermiculare isolate LXT2013110507 large subunit ribosomal RNA gene, partial sequence | blastn | 5049 | 250 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | Homalozoonidae | Homalozoon | Homalozoon vermiculare | ||
| 19065090 | 19065090 | PRJNA784979_S_NODE_5475_length_208_cov_1.427673_g5433_i0 | PRJNA784979 | 5475 | 208 | 1.427673 | 2.96955984 | Philaster | 669199 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 2.0900000000000002e-86 | NTclustered | gi|390988051|gb|JN885119.1| | 1198315 | g5433 | i0 | 96.954 | 87.6923076923077 | 197 | 6 | 95 | 0 | 8 | 204 | 1831 | 1635 | Philaster apodigitiformis isolate WYG2007053101 large subunit ribsomal RNA gene, partial sequence | blastn | 18240 | 331 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philaster | Philaster apodigitiformis | ||
| 19892376 | 19892376 | PRJNA784979_S_NODE_4416_length_225_cov_1.471591_g4374_i0 | PRJNA784979 | 4416 | 225 | 1.471591 | 3.31107975 | Tetrahymena rostrata | 5909 | SAR_Eukaryotes | SAR_Eukaryotes | 335 | 1.7699999999999994e-87 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g4374 | i0 | 97.462 | 83.0533333333333 | 197 | 4 | 88 | 1 | 1 | 197 | 4485 | 4290 | 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 | 18687 | 335 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 21168069 | 21168069 | PRJNA784979_S_NODE_13777_length_157_cov_2.231481_g13735_i0 | PRJNA784979 | 13777 | 157 | 2.231481 | 3.50342517 | Philaster apodigitiformis | 1198315 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 7.159999999999999e-60 | NTclustered | gi|390988051|gb|JN885119.1| | 1198315 | g13735 | i0 | 96.575 | 42.1464968152866 | 146 | 5 | 93 | 0 | 7 | 152 | 804 | 659 | Philaster apodigitiformis isolate WYG2007053101 large subunit ribsomal RNA gene, partial sequence | blastn | 6617 | 243 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philaster | Philaster apodigitiformis | ||
| 21615556 | 21615556 | PRJNA784979_S_NODE_10977_length_165_cov_4.482759_g10935_i0 | PRJNA784979 | 10977 | 165 | 4.482759 | 7.39655235 | root | 1 | Root_unresolved | Root_unresolved | 289 | 9.66e-74 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g10935 | i0 | 100 | 94.0424242424242 | 156 | 0 | 95 | 0 | 4 | 159 | 5185 | 5340 | 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 | 15517 | 289 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 22891021 | 22891021 | PRJNA784979_S_NODE_14158_length_151_cov_2.862745_g14116_i0 | PRJNA784979 | 14158 | 151 | 2.862745 | 4.32274495 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 2.43e-64 | NTclustered | gi|2624665746|gb|OR878271.1| | 210825 | g14116 | i0 | 98.621 | 96 | 145 | 2 | 96 | 0 | 1 | 145 | 700 | 844 | Glaucoma scintillans isolate LLH20220320 large subunit ribosomal RNA gene, partial sequence | blastn | 14496 | 257 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Glaucomidae | Glaucoma | Glaucoma scintillans | ||
| 22891063 | 22891063 | PRJNA784979_S_NODE_5938_length_202_cov_1.764706_g5896_i0 | PRJNA784979 | 5938 | 202 | 1.764706 | 3.56470612 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 348 | 2e-91 | NTclustered | gi|363412153|gb|JN120227.1| | 60850 | g5896 | i0 | 99.476 | 94.5544554455445 | 191 | 1 | 95 | 0 | 7 | 197 | 1460 | 1270 | Vorticella convallaria isolate 96Vorsp16 18S ribosomal RNA gene, partial sequence | blastn | 19100 | 348 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella convallaria | ||
| 24992003 | 24992003 | PRJNA784979_S_NODE_4080_length_232_cov_1.278689_g4038_i0 | PRJNA784979 | 4080 | 232 | 1.278689 | 2.96655848 | Kyaroikeus paracetarius | 2684852 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 1.5199999999999996e-43 | NTclustered | gi|1784308422|gb|MN830170.1| | 2684852 | g4038 | i0 | 87.349 | 4.81896551724138 | 166 | 19 | 71 | 2 | 68 | 232 | 1 | 165 | Kyaroikeus paracetarius isolate LJ-I-20170502 large subunit ribosomal RNA gene, partial sequence | blastn | 1118 | 189 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Dysteriida | Kyaroikeidae | Kyaroikeus | Kyaroikeus paracetarius |
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);;