contig_metadata
20 rows where bioproject = "PRJNA1245487", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 351008 | 351008 | PRJNA1245487_P_NODE_22761_length_231_cov_3.525316_g22423_i0 | PRJNA1245487 | 22761 | 231 | 3.525316 | 8.14347996 | Etoschophrya inornata | 1170431 | SAR_Eukaryotes | SAR_Eukaryotes | 412 | 8.22e-111 | NTclustered | gi|383508494|gb|JQ356867.1| | 1170431 | g22423 | i0 | 98.712 | 101.090909090909 | 233 | 1 | 100 | 2 | 1 | 231 | 145 | 377 | Etoschophrya inornata 18S ribosomal RNA gene, partial sequence; macronuclear | blastn | 23352 | 412 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Cyrtolophosidida | Woodruffiidae | Etoschophrya | Etoschophrya inornata | ||
| 2326628 | 2326628 | PRJNA1245487_P_NODE_14462_length_298_cov_3.733333_g14124_i0 | PRJNA1245487 | 14462 | 298 | 3.733333 | 11.12533234 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 551 | 2.239999999999999e-152 | NTclustered | gi|2065561668|gb|MZ540265.1| | 44029 | g14124 | i0 | 100 | 98.8355704697987 | 298 | 0 | 100 | 0 | 1 | 298 | 843 | 546 | Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence | blastn | 29453 | 551 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium jenningsi | ||
| 3602025 | 3602025 | PRJNA1245487_P_NODE_4583_length_587_cov_1.463035_g4252_i0 | PRJNA1245487 | 4583 | 587 | 1.463035 | 8.58801545 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 2.24e-86 | NR | CAG9318302.1 | 1481888 | g4252 | i0 | 72.5 | 13.0630323679727 | 182 | 48 | 93 | 1 | 40 | 585 | 1 | 180 | CAG9318302.1 unnamed protein product [Blepharisma stoltei] | diamond | 7668 | 270 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 5454491 | 5454491 | PRJNA1245487_P_NODE_12285_length_332_cov_1.343629_g11947_i0 | PRJNA1245487 | 12285 | 332 | 1.343629 | 4.4608482800000004 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 197 | 1.1000000000000004e-59 | NR | CAG9318302.1 | 1481888 | g11947 | i0 | 81.8 | 1.98795180722892 | 110 | 20 | 99.4 | 0 | 330 | 1 | 1 | 110 | CAG9318302.1 unnamed protein product [Blepharisma stoltei] | diamond | 660 | 197 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 6153983 | 6153983 | PRJNA1245487_P_NODE_15125_length_290_cov_6.244240_g14787_i0 | PRJNA1245487 | 15125 | 290 | 6.24424 | 18.108296 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 514 | 2.85e-141 | NTclustered | gi|1802599796|gb|MT001205.1| | 41631 | g14787 | i0 | 98.955 | 99.3965517241379 | 287 | 3 | 99 | 0 | 1 | 287 | 49 | 335 | Colpoda sp. strain HFCC864 small subunit ribosomal RNA gene, partial sequence | blastn | 28825 | 514 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 6154100 | 6154100 | PRJNA1245487_P_NODE_22145_length_241_cov_3.416667_g21807_i0 | PRJNA1245487 | 22145 | 241 | 3.416667 | 8.23416747 | root | 1 | Root_unresolved | Root_unresolved | 424 | 3.99e-114 | NTclustered | gi|345541658|gb|JN547815.1| | 5911 | g21807 | i0 | 98.34 | 8.38589211618257 | 241 | 4 | 100 | 0 | 1 | 241 | 3439 | 3679 | Tetrahymena thermophila strain ATCC 30382 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence | blastn | 2021 | 424 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 6728972 | 6728972 | PRJNA1245487_P_NODE_22506_length_235_cov_3.333333_g22168_i0 | PRJNA1245487 | 22506 | 235 | 3.333333 | 7.83333255 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 8.33e-116 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g22168 | i0 | 99.574 | 90.5659574468085 | 235 | 1 | 100 | 0 | 1 | 235 | 3719 | 3485 | Colpoda sp. isolate JGP15 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 | 21283 | 429 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 6728983 | 6728983 | PRJNA1245487_P_NODE_2686_length_756_cov_2.301611_g2379_i0 | PRJNA1245487 | 2686 | 756 | 2.301611 | 17.40017916 | Epispathidium amphoriforme | 114794 | SAR_Eukaryotes | SAR_Eukaryotes | 1192 | 0 | NTclustered | gi|6980029|gb|AF223570.1|AF223570 | 114794 | g2379 | i0 | 95.219 | 91.0436507936508 | 753 | 36 | 99 | 0 | 4 | 756 | 2359 | 1607 | Spathidium amphoriforme internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 68829 | 1192 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | Spathidiidae | Epispathidium | Epispathidium amphoriforme | ||
| 9279264 | 9279264 | PRJNA1245487_P_NODE_13908_length_306_cov_2.695279_g13570_i0 | PRJNA1245487 | 13908 | 306 | 2.695279 | 8.24755374 | Opercularia sp. ZhW-2019a | 2582953 | SAR_Eukaryotes | SAR_Eukaryotes | 564 | 2.96e-156 | NTclustered | gi|2304601486|gb|OP458307.1| | 2582953 | g13570 | i0 | 100 | 98.5457516339869 | 305 | 0 | 99 | 0 | 2 | 306 | 391 | 87 | Opercularia sp. ZhW-2019a large subunit ribosomal RNA gene, partial sequence | blastn | 30155 | 564 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Operculariidae | Opercularia | Opercularia sp. ZhW-2019a | ||
| 10555195 | 10555195 | PRJNA1245487_P_NODE_18589_length_257_cov_1.385870_g18251_i0 | PRJNA1245487 | 18589 | 257 | 1.38587 | 3.5616859 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 442 | 1.1899999999999995e-119 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g18251 | i0 | 97.665 | 81.1828793774319 | 257 | 6 | 100 | 0 | 1 | 257 | 3218 | 3474 | Colpoda sp. isolate JGP15 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 | 20864 | 442 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 10555234 | 10555234 | PRJNA1245487_P_NODE_21729_length_243_cov_0.917647_g21391_i0 | PRJNA1245487 | 21729 | 243 | 0.917647 | 2.22988221 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 385 | 1.8999999999999993e-102 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g21391 | i0 | 96.17 | 4.1522633744856 | 235 | 9 | 97 | 0 | 9 | 243 | 3604 | 3370 | Colpoda sp. isolate JGP15 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 | 1009 | 385 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 11829631 | 11829631 | PRJNA1245487_P_NODE_11690_length_342_cov_6.936803_g11352_i0 | PRJNA1245487 | 11690 | 342 | 6.936803 | 23.72386626 | Colpoda sp. 2-SMaurya-2022 | 3384729 | SAR_Eukaryotes | SAR_Eukaryotes | 599 | 9.21e-167 | NTclustered | gi|2178724620|gb|OM278536.1| | 3384729 | g11352 | i0 | 98.246 | 99.4853801169591 | 342 | 6 | 100 | 0 | 1 | 342 | 924 | 583 | Colpoda sp. 2-SMaurya-2022 strain J21 small subunit ribosomal RNA gene, partial sequence | blastn | 34024 | 599 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. 2-SMaurya-2022 | ||
| 12530051 | 12530051 | PRJNA1245487_P_NODE_23450_length_205_cov_5.151515_g23112_i0 | PRJNA1245487 | 23450 | 205 | 5.151515 | 10.56060575 | Litostomatea | 5988 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 3.4600000000000006e-79 | NTclustered | gi|6980029|gb|AF223570.1|AF223570 | 114794 | g23112 | i0 | 93.72 | 102.380487804878 | 207 | 10 | 100 | 3 | 1 | 205 | 2966 | 2761 | Spathidium amphoriforme internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 20988 | 307 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | Spathidiidae | Epispathidium | Epispathidium amphoriforme | ||
| 14380243 | 14380243 | PRJNA1245487_P_NODE_19092_length_253_cov_0.866667_g18754_i0 | PRJNA1245487 | 19092 | 253 | 0.866667 | 2.19266751 | Ephelota gemmipara | 398671 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 1.3e-44 | NTclustered | gi|759083541|gb|KM222158.1| | 398671 | g18754 | i0 | 84.08 | 83.4387351778656 | 201 | 31 | 79 | 1 | 53 | 253 | 1721 | 1522 | Ephelota gemmipara voucher CXR2007051101 large subunit ribosomal RNA gene, partial sequence | blastn | 21110 | 193 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Exogenida | Ephelotidae | Ephelota | Ephelota gemmipara | ||
| 15654156 | 15654156 | PRJNA1245487_P_NODE_22853_length_230_cov_2.242038_g22515_i0 | PRJNA1245487 | 22853 | 230 | 2.242038 | 5.1566874 | Pseudochilodonopsis fluviatilis | 1170556 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 5.51e-28 | NTclustered | gi|1183126452|gb|KX302663.1| | 1170556 | g22515 | i0 | 84.783 | 0.6 | 138 | 20 | 60 | 1 | 2 | 139 | 772 | 636 | Pseudochilodonopsis fluviatilis clone A378 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 138 | 137 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Pseudochilodonopsis | Pseudochilodonopsis fluviatilis | ||
| 20177431 | 20177431 | PRJNA1245487_P_NODE_14116_length_303_cov_3.456522_g13778_i0 | PRJNA1245487 | 14116 | 303 | 3.456522 | 10.47326166 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 544 | 3.82e-150 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g13778 | i0 | 99.01 | 98.1650165016502 | 303 | 3 | 100 | 0 | 1 | 303 | 2072 | 1770 | Colpoda sp. isolate JGP15 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 | 29744 | 549 | 0.990892531876138 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 21453232 | 21453232 | PRJNA1245487_P_NODE_22437_length_236_cov_2.699387_g22099_i0 | PRJNA1245487 | 22437 | 236 | 2.699387 | 6.37055332 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|390988043|gb|JN885111.1| | 35097 | g22099 | i0 | 100 | 0.978813559322034 | 29 | 0 | 12 | 0 | 42 | 70 | 1675 | 1703 | Cohnilembus verminus isolate FXP2009051101 large subunit ribsomal RNA gene, partial sequence | blastn | 231 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Cohnilembidae | Cohnilembus | Cohnilembus verminus | ||
| 24577452 | 24577452 | PRJNA1245487_P_NODE_22360_length_237_cov_4.445122_g22022_i0 | PRJNA1245487 | 22360 | 237 | 4.445122 | 10.53493914 | Sterkiella histriomuscorum | 94289 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.58e-33 | NTclustered | gi|220966760|gb|FJ545743.1| | 94289 | g22022 | i0 | 79.253 | 39.535864978903 | 241 | 37 | 98 | 11 | 1 | 232 | 7115 | 7351 | Sterkiella histriomuscorum 17S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; macronuclear | blastn | 9370 | 156 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 24577489 | 24577489 | PRJNA1245487_P_NODE_5520_length_532_cov_6.028322_g5185_i0 | PRJNA1245487 | 5520 | 532 | 6.028322 | 32.07067304 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 854 | 0 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g5185 | i0 | 95.857 | 88.5770676691729 | 531 | 17 | 99 | 5 | 4 | 532 | 3887 | 3360 | Colpoda sp. isolate CIL1 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 | 47123 | 854 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 26598467 | 26598467 | PRJNA1245487_P_NODE_8781_length_409_cov_3.297619_g8443_i0 | PRJNA1245487 | 8781 | 409 | 3.297619 | 13.48726171 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 3.07e-9 | NR | OMJ89086.1 | 5963 | g8443 | i0 | 40.5 | 0.579462102689487 | 79 | 47 | 57.9 | 0 | 247 | 11 | 5 | 83 | OMJ89086.1 hypothetical protein SteCoe_8807 [Stentor coeruleus] | diamond | 237 | 63.2 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus |
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);;