contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA478247" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1722520 | 1722520 | PRJNA478247_P_NODE_1182_length_361_cov_1.445783_g1076_i0 | PRJNA478247 | 1182 | 361 | 1.445783 | 5.21927663 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 435 | 2.91e-117 | NTclustered | gi|829192652|ref|XM_001030092.3| | 312017 | g1076 | i0 | 88.398 | 2.34072022160665 | 362 | 31 | 99 | 6 | 3 | 361 | 403 | 50 | Tetrahymena thermophila SB210 40S ribosomal protein S8-2 partial mRNA | blastn | 845 | 435 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 2372652 | 2372652 | PRJNA478247_P_NODE_1982_length_248_cov_2.237443_g1876_i0 | PRJNA478247 | 1982 | 248 | 2.237443 | 5.54885864 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 9.519999999999998e-66 | NTclustered | gi|161736|gb|L01416.1|TETBTUBUB | 5911 | g1876 | i0 | 86.667 | 82.6088709677419 | 240 | 28 | 96 | 4 | 11 | 248 | 1460 | 1223 | Tetrahymena thermophila beta-tubulin (BTU2) gene, complete cds | blastn | 20487 | 263 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 4925286 | 4925286 | PRJNA478247_P_NODE_1324_length_335_cov_1.990196_g1218_i0 | PRJNA478247 | 1324 | 335 | 1.990196 | 6.6671566 | Loxophyllum | 39458 | SAR_Eukaryotes | SAR_Eukaryotes | 449 | 9.59e-122 | NTclustered | gi|375305433|gb|JF975393.1| | 416803 | g1218 | i0 | 90.882 | 100.573134328358 | 340 | 23 | 100 | 8 | 1 | 335 | 21 | 357 | Loxophyllum jini isolate LXF07-6-21 28S ribosomal RNA gene, partial sequence | blastn | 33692 | 449 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Pleurostomatida | Litonotidae | Loxophyllum | Loxophyllum jini | ||
| 4925287 | 4925287 | PRJNA478247_P_NODE_3264_length_164_cov_2.822222_g3158_i0 | PRJNA478247 | 3264 | 164 | 2.822222 | 4.62844408 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 1e-43 | NTclustered | gi|3366652|gb|AF031320.1|AF031320 | 5911 | g3158 | i0 | 88.961 | 1.8780487804878 | 154 | 15 | 93 | 2 | 12 | 164 | 786 | 634 | Tetrahymena thermophila granule lattice protein 4 precursor (GRL4) mRNA, complete cds | blastn | 308 | 189 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 4925288 | 4925288 | PRJNA478247_P_NODE_3564_length_153_cov_1.346774_g3458_i0 | PRJNA478247 | 3564 | 153 | 1.346774 | 2.06056422 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 185 | 1.18e-42 | NTclustered | gi|315570290|tpg|BK007907.1| | 5911 | g3458 | i0 | 90.21 | 1.86928104575163 | 143 | 12 | 93 | 2 | 12 | 153 | 786 | 645 | TPA_exp: Tetrahymena thermophila 40S ribosomal protein rpS1e mRNA, complete cds | blastn | 286 | 185 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 6825337 | 6825337 | PRJNA478247_P_NODE_1766_length_270_cov_1.788382_g1660_i0 | PRJNA478247 | 1766 | 270 | 1.788382 | 4.8286314 | Tetrahymena sp. KGE15 | 1200497 | SAR_Eukaryotes | SAR_Eukaryotes | 499 | 7.349999999999998e-137 | NTclustered | gi|523704203|emb|HE861887.1| | 1200497 | g1660 | i0 | 100 | 86.0814814814815 | 270 | 0 | 100 | 0 | 1 | 270 | 429 | 160 | Tetrahymena sp. KGE15 partial 28S rRNA gene, strain KGE15 | blastn | 23242 | 499 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena sp. KGE15 | ||
| 8100856 | 8100856 | PRJNA478247_P_NODE_3487_length_155_cov_2.000000_g3381_i0 | PRJNA478247 | 3487 | 155 | 2 | 3.1 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 4.329999999999999e-42 | NTclustered | gi|829123749|ref|XM_001008606.3| | 312017 | g3381 | i0 | 88.387 | 1 | 155 | 15 | 100 | 1 | 1 | 155 | 192 | 343 | Tetrahymena thermophila SB210 60S ribosomal protein L38 partial mRNA | blastn | 155 | 183 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 8750110 | 8750110 | PRJNA478247_P_NODE_1087_length_384_cov_2.546479_g981_i0 | PRJNA478247 | 1087 | 384 | 2.546479 | 9.77847936 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 1.27e-26 | NTclustered | gi|3366652|gb|AF031320.1|AF031320 | 5911 | g981 | i0 | 76 | 1.43229166666667 | 275 | 56 | 70 | 9 | 7 | 276 | 836 | 1105 | Tetrahymena thermophila granule lattice protein 4 precursor (GRL4) mRNA, complete cds | blastn | 550 | 134 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 11300380 | 11300380 | PRJNA478247_P_NODE_3029_length_176_cov_1.918367_g2923_i0 | PRJNA478247 | 3029 | 176 | 1.918367 | 3.37632592 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 326 | 7.92e-85 | NTclustered | gi|1621572405|gb|MH051920.1| | 5893 | g2923 | i0 | 100 | 100 | 176 | 0 | 100 | 0 | 1 | 176 | 1521 | 1346 | Tetrahymena borealis strain 1630/5A small subunit ribosomal RNA gene, partial sequence | blastn | 17600 | 326 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena borealis | ||
| 11926414 | 11926414 | PRJNA478247_P_NODE_3250_length_165_cov_1.617647_g3144_i0 | PRJNA478247 | 3250 | 165 | 1.617647 | 2.66911755 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 2.12e-60 | NTclustered | gi|829198556|ref|XM_001027330.2| | 312017 | g3144 | i0 | 93.827 | 0.981818181818182 | 162 | 10 | 98 | 0 | 1 | 162 | 5 | 166 | Tetrahymena thermophila SB210 60S ribosomal protein L29 partial mRNA | blastn | 162 | 244 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 12576130 | 12576130 | PRJNA478247_P_NODE_1490_length_308_cov_2.103943_g1384_i0 | PRJNA478247 | 1490 | 308 | 2.103943 | 6.48014444 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 7.240000000000001e-73 | NTclustered | gi|161728|gb|M86723.1|TETATUB | 5911 | g1384 | i0 | 83.946 | 36.1590909090909 | 299 | 48 | 97 | 0 | 10 | 308 | 1697 | 1399 | Tetrahymena thermophila alpha-tubulin gene, complete cds | blastn | 11137 | 287 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 13201397 | 13201397 | PRJNA478247_P_NODE_3111_length_172_cov_1.671329_g3005_i0 | PRJNA478247 | 3111 | 172 | 1.671329 | 2.87468588 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 2.91e-49 | NTclustered | gi|2386258192|ref|XM_001455088.2| | 5888 | g3005 | i0 | 88.372 | 84.9418604651163 | 172 | 20 | 100 | 0 | 1 | 172 | 202 | 373 | Paramecium tetraurelia uncharacterized protein (GSPATT00021361001), mRNA | blastn | 14610 | 207 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 14476323 | 14476323 | PRJNA478247_P_NODE_1272_length_344_cov_6.793651_g1166_i0 | PRJNA478247 | 1272 | 344 | 6.793651 | 23.37015944 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 451 | 2.75e-122 | NTclustered | gi|10789|emb|X61053.1| | 5908 | g1166 | i0 | 90.379 | 364.418604651163 | 343 | 33 | 99 | 0 | 1 | 343 | 652 | 994 | T.pyriformis TU20 gene for ubiquitin | blastn | 125360 | 451 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 14476326 | 14476326 | PRJNA478247_P_NODE_1652_length_284_cov_1.976471_g1546_i0 | PRJNA478247 | 1652 | 284 | 1.976471 | 5.61317764 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 3.16e-51 | NTclustered | gi|229593638|ref|XM_001027526.3| | 312017 | g1546 | i0 | 80.488 | 1.01056338028169 | 287 | 50 | 100 | 5 | 1 | 284 | 962 | 679 | Tetrahymena thermophila SB210 Ndc1 protein partial mRNA | blastn | 287 | 215 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 14476332 | 14476332 | PRJNA478247_P_NODE_972_length_416_cov_1.826873_g866_i0 | PRJNA478247 | 972 | 416 | 1.826873 | 7.59979168 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 4.7199999999999995e-66 | NTclustered | gi|829199633|ref|XM_001028123.4| | 312017 | g866 | i0 | 79.581 | 1.71875 | 382 | 68 | 91 | 9 | 3 | 379 | 800 | 424 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 715 | 265 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 15750418 | 15750418 | PRJNA478247_P_NODE_3493_length_155_cov_1.785714_g3387_i0 | PRJNA478247 | 3493 | 155 | 1.785714 | 2.7678567 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 185 | 1.2e-42 | NTclustered | gi|829186959|ref|XM_001022599.3| | 312017 | g3387 | i0 | 91.176 | 0.87741935483871 | 136 | 12 | 88 | 0 | 20 | 155 | 264 | 129 | Tetrahymena thermophila SB210 granule lattice protein partial mRNA | blastn | 136 | 185 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 18299344 | 18299344 | PRJNA478247_P_NODE_1935_length_252_cov_2.134529_g1829_i0 | PRJNA478247 | 1935 | 252 | 2.134529 | 5.37901308 | Euplotes octocarinatus | 2716877 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 1.6099999999999999e-68 | NTclustered | gi|112383582|gb|DQ864704.1| | 2716877 | g1829 | i0 | 90.385 | 23.1269841269841 | 208 | 18 | 82 | 2 | 45 | 251 | 1067 | 861 | Euplotes octocarinatus beta2-tubulin (BTUB2) gene, complete cds | blastn | 5828 | 272 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes octocarinatus | ||
| 19573560 | 19573560 | PRJNA478247_P_NODE_2496_length_208_cov_3.150838_g2390_i0 | PRJNA478247 | 2496 | 208 | 3.150838 | 6.55374304 | Oxytricha granulifera | 5947 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 7.729999999999999e-66 | NTclustered | gi|9756|emb|Z11763.1| | 5947 | g2390 | i0 | 89.423 | 41.5528846153846 | 208 | 22 | 100 | 0 | 1 | 208 | 862 | 1069 | O.granulifera gene for alpha-tubulin | blastn | 8643 | 263 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Oxytricha | Oxytricha granulifera | ||
| 20223496 | 20223496 | PRJNA478247_P_NODE_1456_length_312_cov_2.318021_g1350_i0 | PRJNA478247 | 1456 | 312 | 2.318021 | 7.23222552 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 566 | 8.429999999999998e-157 | NTclustered | gi|1172880852|gb|KY864168.1| | 5909 | g1350 | i0 | 99.359 | 99.9935897435897 | 312 | 2 | 100 | 0 | 1 | 312 | 887 | 576 | Tetrahymena rostrata isolate TR 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 | 31198 | 571 | 0.991243432574431 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 20223499 | 20223499 | PRJNA478247_P_NODE_3096_length_172_cov_3.230769_g2990_i0 | PRJNA478247 | 3096 | 172 | 3.230769 | 5.55692268 | Sterkiella | 94288 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 2.3e-35 | NTclustered | gi|331686195|gb|HQ432921.1| | 94289 | g2990 | i0 | 88.148 | 51.3604651162791 | 135 | 16 | 78 | 0 | 23 | 157 | 185 | 319 | Sterkiella histriomuscorum strain BA elongation factor-1 (ef-1) gene, complete cds; macronuclear | blastn | 8834 | 161 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 20849378 | 20849378 | PRJNA478247_P_NODE_2517_length_207_cov_1.904494_g2411_i0 | PRJNA478247 | 2517 | 207 | 1.904494 | 3.94230258 | Epistylis sp. FG-2015 | 1607876 | SAR_Eukaryotes | SAR_Eukaryotes | 302 | 1.63e-77 | NTclustered | gi|759083401|gb|KM222025.1| | 1607876 | g2411 | i0 | 93.171 | 64.2995169082126 | 205 | 14 | 99 | 0 | 1 | 205 | 787 | 583 | Epistylis sp. FG-2015 voucher SZ2011052302 alpha-tubulin gene, partial cds | blastn | 13310 | 302 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Epistylidae | Epistylis | Epistylis sp. FG-2015 | ||
| 21499000 | 21499000 | PRJNA478247_P_NODE_2857_length_186_cov_2.031847_g2751_i0 | PRJNA478247 | 2857 | 186 | 2.031847 | 3.77923542 | root | 1 | Root_unresolved | Root_unresolved | 344 | 2.34e-90 | NTclustered | gi|1621572405|gb|MH051920.1| | 5893 | g2751 | i0 | 100 | 99.9784946236559 | 186 | 0 | 100 | 0 | 1 | 186 | 1048 | 863 | Tetrahymena borealis strain 1630/5A small subunit ribosomal RNA gene, partial sequence | blastn | 18596 | 344 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena borealis |
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);;