contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA274362" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 370842 | 370842 | PRJNA274362_S_NODE_37381_length_162_cov_1.026549_g37261_i0 | PRJNA274362 | 37381 | 162 | 1.026549 | 1.66300938 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 233 | 4.49e-57 | NTclustered | gi|829167874|ref|XM_001030102.3| | 312017 | g37261 | i0 | 92.593 | 1 | 162 | 12 | 100 | 0 | 1 | 162 | 345 | 184 | Tetrahymena thermophila SB210 60S ribosomal protein L9 partial mRNA | blastn | 162 | 233 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 1645154 | 1645154 | PRJNA274362_S_NODE_13322_length_244_cov_1.051282_g13202_i0 | PRJNA274362 | 13322 | 244 | 1.051282 | 2.56512808 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.25e-39 | NTclustered | gi|829188477|ref|XM_001023087.3| | 312017 | g13202 | i0 | 84.971 | 54.155737704918 | 173 | 26 | 71 | 0 | 2 | 174 | 755 | 583 | Tetrahymena thermophila SB210 S-adenosyl-L-homocysteine hydrolase partial mRNA | blastn | 13214 | 176 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 1645182 | 1645182 | PRJNA274362_S_NODE_14622_length_234_cov_3.632432_g14502_i0 | PRJNA274362 | 14622 | 234 | 3.632432 | 8.49989088 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 7.07e-47 | NTclustered | gi|33327399|gb|AF527985.1| | 151077 | g14502 | i0 | 96.667 | 2.61538461538462 | 120 | 4 | 51 | 0 | 1 | 120 | 120 | 1 | Chilodonella uncinata clone 5 histone H4 (H4) gene, partial cds | blastn | 612 | 200 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 2921034 | 2921034 | PRJNA274362_S_NODE_15603_length_228_cov_1.273743_g15483_i0 | PRJNA274362 | 15603 | 228 | 1.273743 | 2.90413404 | Euplotes vannus | 5939 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 1.9099999999999998e-47 | NTclustered | gi|409187355|gb|JQ289918.1| | 5939 | g15483 | i0 | 82.819 | 142.333333333333 | 227 | 37 | 99 | 2 | 3 | 228 | 354 | 129 | Euplotes vannus clone eu568c5 polyubiquitin gene, partial cds; macronuclear | blastn | 32452 | 202 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes vannus | ||
| 6748384 | 6748384 | PRJNA274362_S_NODE_29446_length_175_cov_1.238095_g29326_i0 | PRJNA274362 | 29446 | 175 | 1.238095 | 2.16666625 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 4.84e-67 | NTclustered | gi|323500525|gb|GQ453434.1| | 151077 | g29326 | i0 | 94.737 | 79.9942857142857 | 171 | 9 | 98 | 0 | 1 | 171 | 3128 | 3298 | Chilodonella uncinata strain ATCC 50194 actin gene, partial cds; micronuclear | blastn | 13999 | 267 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 6748444 | 6748444 | PRJNA274362_S_NODE_32706_length_168_cov_1.008403_g32586_i0 | PRJNA274362 | 32706 | 168 | 1.008403 | 1.69411704 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 1.0299999999999998e-43 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g32586 | i0 | 89.933 | 1.92261904761905 | 149 | 12 | 87 | 2 | 1 | 146 | 513 | 661 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 323 | 189 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 6748547 | 6748547 | PRJNA274362_S_NODE_37706_length_162_cov_0.893805_g37586_i0 | PRJNA274362 | 37706 | 162 | 0.893805 | 1.4479641 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 9.92e-39 | NTclustered | gi|471230286|ref|XM_004036375.1| | 5932 | g37586 | i0 | 86.25 | 82.7037037037037 | 160 | 20 | 98 | 2 | 1 | 159 | 254 | 412 | Ichthyophthirius multifiliis hypothetical protein (IMG5_083250) mRNA, complete cds | blastn | 13398 | 172 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 8023979 | 8023979 | PRJNA274362_S_NODE_26367_length_184_cov_1.140741_g26247_i0 | PRJNA274362 | 26367 | 184 | 1.140741 | 2.09896344 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 3.0799999999999997e-69 | NTclustered | gi|118385632|ref|XM_001025944.1| | 312017 | g26247 | i0 | 93.514 | 1.0054347826087 | 185 | 10 | 100 | 2 | 1 | 184 | 835 | 1018 | Tetrahymena thermophila SB210 receptor of activated kinase C 1A, component of 40S small ribosomal subunit partial mRNA | blastn | 185 | 274 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 8024175 | 8024175 | PRJNA274362_S_NODE_36467_length_163_cov_1.289474_g36347_i0 | PRJNA274362 | 36467 | 163 | 1.289474 | 2.10184262 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.01e-33 | NTclustered | gi|829188944|ref|XM_001031587.2| | 312017 | g36347 | i0 | 86.525 | 0.865030674846626 | 141 | 19 | 87 | 0 | 8 | 148 | 628 | 768 | Tetrahymena thermophila SB210 60S ribosomal L7Ae-like protein partial mRNA | blastn | 141 | 156 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 9298740 | 9298740 | PRJNA274362_S_NODE_29388_length_175_cov_1.436508_g29268_i0 | PRJNA274362 | 29388 | 175 | 1.436508 | 2.513889 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 2.8500000000000004e-79 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g29268 | i0 | 98.837 | 1.38285714285714 | 172 | 2 | 98 | 0 | 4 | 175 | 224 | 53 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 242 | 307 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 11849001 | 11849001 | PRJNA274362_S_NODE_14230_length_237_cov_1.638298_g14110_i0 | PRJNA274362 | 14230 | 237 | 1.638298 | 3.88276626 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 8.71e-91 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g14110 | i0 | 93.191 | 3.42194092827004 | 235 | 16 | 99 | 0 | 1 | 235 | 1362 | 1596 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 811 | 346 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 12537103 | 12537103 | PRJNA274362_S_NODE_22390_length_197_cov_1.054054_g22270_i0 | PRJNA274362 | 22390 | 197 | 1.054054 | 2.07648638 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 326 | 9.1e-85 | NTclustered | gi|10838|emb|X04425.1| | 5911 | g22270 | i0 | 96.447 | 2 | 197 | 7 | 100 | 0 | 1 | 197 | 1399 | 1595 | Tetrahymena thermophila gene for ribosomal protein (homologous to E. coli ribosomal protein S12) | blastn | 394 | 326 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 13124211 | 13124211 | PRJNA274362_S_NODE_15231_length_230_cov_2.502762_g15111_i0 | PRJNA274362 | 15231 | 230 | 2.502762 | 5.7563526 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 414 | 2.27e-111 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g15111 | i0 | 99.13 | 50.8 | 230 | 2 | 100 | 0 | 1 | 230 | 124 | 353 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 11684 | 414 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 13124294 | 13124294 | PRJNA274362_S_NODE_18751_length_211_cov_3.092593_g18631_i0 | PRJNA274362 | 18751 | 211 | 3.092593 | 6.52537123 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.33e-21 | NTclustered | gi|829192014|ref|XM_012799966.1| | 312017 | g18631 | i0 | 88.421 | 1.99052132701422 | 95 | 11 | 45 | 0 | 32 | 126 | 125 | 219 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 420 | 115 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 13124494 | 13124494 | PRJNA274362_S_NODE_28291_length_178_cov_1.449612_g28171_i0 | PRJNA274362 | 28291 | 178 | 1.449612 | 2.58030936 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 2.91e-79 | NTclustered | gi|21632107|gb|AY041124.1| | 151077 | g28171 | i0 | 97.753 | 94.9325842696629 | 178 | 4 | 100 | 0 | 1 | 178 | 1072 | 895 | Chilodonella uncinata clone 4 alpha-tubulin gene, partial cds | blastn | 16898 | 307 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 16947831 | 16947831 | PRJNA274362_S_NODE_18594_length_212_cov_1.576687_g18474_i0 | PRJNA274362 | 18594 | 212 | 1.576687 | 3.34257644 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 381 | 2.0899999999999994e-101 | NTclustered | gi|347439301|gb|JN111999.1| | 151077 | g18474 | i0 | 99.057 | 11.688679245283 | 212 | 2 | 100 | 0 | 1 | 212 | 332 | 543 | Chilodonella uncinata strain USA_WH actin gene, partial cds; macronuclear | blastn | 2478 | 381 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 16947942 | 16947942 | PRJNA274362_S_NODE_23834_length_192_cov_1.090909_g23714_i0 | PRJNA274362 | 23834 | 192 | 1.090909 | 2.09454528 | Vorticella sp. FG-2015 | 1607899 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 1.17e-63 | NTclustered | gi|759083393|gb|KM222021.1| | 1607899 | g23714 | i0 | 90.625 | 40.9947916666667 | 192 | 18 | 100 | 0 | 1 | 192 | 417 | 226 | Vorticella sp. FG-2015 voucher SZ2010101001 alpha-tubulin gene, partial cds | blastn | 7871 | 255 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. FG-2015 | ||
| 19496400 | 19496400 | PRJNA274362_S_NODE_18096_length_215_cov_0.698795_g17976_i0 | PRJNA274362 | 18096 | 215 | 0.698795 | 1.50240925 | Isotricha intestinalis | 47897 | SAR_Eukaryotes | SAR_Eukaryotes | 231 | 2.27e-56 | NTclustered | gi|92790153|emb|AJ965262.1| | 47897 | g17976 | i0 | 86.321 | 139.009302325581 | 212 | 29 | 99 | 0 | 4 | 215 | 465 | 254 | Isotricha intestinalis partial mRNA for Polyubiqutin 2 (polyubiqutin 2 gene) | blastn | 29887 | 231 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Vestibuliferida | Isotrichidae | Isotricha | Isotricha intestinalis | ||
| 20772045 | 20772045 | PRJNA274362_S_NODE_24577_length_190_cov_0.950355_g24457_i0 | PRJNA274362 | 24577 | 190 | 0.950355 | 1.8056745 | Epidinium ecaudatum | 300017 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 1.5499999999999998e-37 | NTclustered | gi|92790181|emb|AJ965276.1| | 300017 | g24457 | i0 | 82.723 | 72.521052631579 | 191 | 31 | 100 | 2 | 1 | 190 | 920 | 1109 | Epidinium ecaudatum partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene) | blastn | 13779 | 169 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Entodiniomorphida | Ophryoscolecidae | Epidinium | Epidinium ecaudatum | ||
| 20772374 | 20772374 | PRJNA274362_S_NODE_7697_length_308_cov_1.664093_g7577_i0 | PRJNA274362 | 7697 | 308 | 1.664093 | 5.12540644 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 508 | 1.42e-139 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g7577 | i0 | 96.429 | 60.9285714285714 | 308 | 11 | 100 | 0 | 1 | 308 | 335 | 28 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 18766 | 508 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 22047039 | 22047039 | PRJNA274362_S_NODE_22238_length_197_cov_2.087838_g22118_i0 | PRJNA274362 | 22238 | 197 | 2.087838 | 4.11304086 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 4.24e-83 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g22118 | i0 | 95.939 | 2.77664974619289 | 197 | 8 | 100 | 0 | 1 | 197 | 25 | 221 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 547 | 320 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 23322561 | 23322561 | PRJNA274362_S_NODE_22839_length_195_cov_1.424658_g22719_i0 | PRJNA274362 | 22839 | 195 | 1.424658 | 2.7780831 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 339 | 1.15e-88 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g22719 | i0 | 97.949 | 4.3025641025641 | 195 | 4 | 100 | 0 | 1 | 195 | 707 | 513 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 839 | 339 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata |
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);;