contig_metadata
17 rows where bioproject = "PRJNA488043", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1724604 | 1724604 | PRJNA488043_P_NODE_20102_length_170_cov_126.496454_g17860_i0 | PRJNA488043 | 20102 | 170 | 126.496454 | 215.0439718 | Tetrahymena acanthophora | 2704174 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 6.119999999999999e-56 | NTclustered | gi|2082965250|gb|MZ827090.1| | 2704174 | g17860 | i0 | 96.403 | 81.6588235294118 | 139 | 5 | 82 | 0 | 25 | 163 | 129 | 267 | Tetrahymena acanthophora isolate NB176 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 13882 | 230 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena acanthophora | ||
| 2373342 | 2373342 | PRJNA488043_P_NODE_12742_length_266_cov_8.071730_g10501_i0 | PRJNA488043 | 12742 | 266 | 8.07173 | 21.4708018 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 446 | 9.549999999999999e-121 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g10501 | i0 | 96.981 | 13.109022556391 | 265 | 8 | 99 | 0 | 1 | 265 | 1516 | 1780 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 3487 | 446 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 3000668 | 3000668 | PRJNA488043_P_NODE_22383_length_151_cov_2.647541_g20141_i0 | PRJNA488043 | 22383 | 151 | 2.647541 | 3.99778691 | Tetrahymena rostrata | 5909 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 2.4500000000000008e-59 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g20141 | i0 | 95.395 | 9.93377483443709 | 152 | 6 | 100 | 1 | 1 | 151 | 4721 | 4570 | 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 | 1500 | 241 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 7475904 | 7475904 | PRJNA488043_P_NODE_18106_length_190_cov_6.751553_g15864_i0 | PRJNA488043 | 18106 | 190 | 6.751553 | 12.8279507 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.4399999999999997e-92 | NTclustered | gi|347439265|gb|JN111978.1| | 151077 | g15864 | i0 | 100 | 72.0421052631579 | 190 | 0 | 100 | 0 | 1 | 190 | 761 | 572 | Chilodonella uncinata strain USA_WH small subunit ribosomal RNA gene, partial sequence; macronuclear | blastn | 13688 | 351 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 8750984 | 8750984 | PRJNA488043_P_NODE_7287_length_450_cov_13.926366_g5148_i0 | PRJNA488043 | 7287 | 450 | 13.926366 | 62.668647 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 630 | 4.4e-176 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g5148 | i0 | 94.621 | 92.3155555555556 | 409 | 19 | 91 | 3 | 42 | 450 | 406 | 1 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 41542 | 630 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 8751019 | 8751019 | PRJNA488043_S_NODE_827_length_207_cov_3.016854_g816_i0 | PRJNA488043 | 827 | 207 | 3.016854 | 6.24488778 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 7.96e-41 | NTclustered | gi|822093032|gb|KP313338.1| | 5911 | g816 | i0 | 82.938 | 91.9371980676328 | 211 | 24 | 99 | 10 | 1 | 205 | 82 | 286 | Tetrahymena thermophila isolate 19147-1 translation elongation factor 1 subunit alpha (TEF1a) gene, partial cds; macronuclear | blastn | 19031 | 180 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 12577027 | 12577027 | PRJNA488043_P_NODE_9050_length_372_cov_13.615160_g6826_i0 | PRJNA488043 | 9050 | 372 | 13.61516 | 50.6483952 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 5.44e-60 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g6826 | i0 | 97.222 | 1.16129032258065 | 144 | 4 | 39 | 0 | 229 | 372 | 3082 | 2939 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 432 | 244 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 13203662 | 13203662 | PRJNA488043_S_NODE_1291_length_170_cov_4.680851_g1280_i0 | PRJNA488043 | 1291 | 170 | 4.680851 | 7.9574467 | Tetrahymena foissneri | 2821798 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 2.1700000000000002e-65 | NTclustered | gi|2019294631|gb|MW827185.1| | 2821798 | g1280 | i0 | 95.21 | 78.9647058823529 | 167 | 5 | 96 | 2 | 7 | 170 | 437 | 271 | Tetrahymena foissneri isolate ST 1 AV large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 13424 | 261 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena foissneri | ||
| 14478598 | 14478598 | PRJNA488043_S_NODE_1332_length_167_cov_4.123188_g1321_i0 | PRJNA488043 | 1332 | 167 | 4.123188 | 6.88572396 | Tetrahymena sp. FN-2012 | 1217406 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 2.71e-79 | NTclustered | gi|400269896|gb|JX271898.1| | 1217406 | g1321 | i0 | 100 | 99.2874251497006 | 166 | 0 | 99 | 0 | 1 | 166 | 389 | 554 | Tetrahymena sp. FN-2012 strain HFCC700 28S large subunit ribosomal RNA gene, partial sequence | blastn | 16581 | 307 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena sp. FN-2012 | ||
| 16400427 | 16400427 | PRJNA488043_P_NODE_13093_length_259_cov_4.169565_g10852_i0 | PRJNA488043 | 13093 | 259 | 4.169565 | 10.79917335 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 477 | 3.2799999999999986e-130 | NTclustered | gi|966204127|emb|LN870015.1| | 1683281 | g10852 | i0 | 100 | 99.6177606177606 | 258 | 0 | 99 | 0 | 2 | 259 | 861 | 604 | Oligohymenophorea sp. bLPN1 partial 18S rRNA gene, isolate bLPN1 Oligohymenophorean | blastn | 25801 | 477 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Oligohymenophorea sp. bLPN1 | |||||
| 16400469 | 16400469 | PRJNA488043_P_NODE_17473_length_197_cov_4.994048_g15231_i0 | PRJNA488043 | 17473 | 197 | 4.994048 | 9.83827456 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 3.23e-94 | NTclustered | gi|966204127|emb|LN870015.1| | 1683281 | g15231 | i0 | 99.49 | 99.492385786802 | 196 | 1 | 99 | 0 | 2 | 197 | 302 | 107 | Oligohymenophorea sp. bLPN1 partial 18S rRNA gene, isolate bLPN1 Oligohymenophorean | blastn | 19600 | 357 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Oligohymenophorea sp. bLPN1 | |||||
| 16400511 | 16400511 | PRJNA488043_P_NODE_21473_length_158_cov_43.100775_g19231_i0 | PRJNA488043 | 21473 | 158 | 43.100775 | 68.0992245 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 7.07e-75 | NTclustered | gi|158147318|gb|EU047813.1| | 151077 | g19231 | i0 | 100 | 75.6582278481013 | 158 | 0 | 100 | 0 | 1 | 158 | 239 | 82 | Chilodonella uncinata strain ATCC 50194 5.8S ribosomal RNA gene and internal transcribed spacer 2, partial sequence; macronuclear | blastn | 11954 | 292 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 19575566 | 19575566 | PRJNA488043_P_NODE_13036_length_260_cov_7.567100_g10795_i0 | PRJNA488043 | 13036 | 260 | 7.5671 | 19.67446 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 481 | 2.55e-131 | NTclustered | gi|1202135013|gb|KY476314.1| | 151077 | g10795 | i0 | 100 | 100.546153846154 | 260 | 0 | 100 | 0 | 1 | 260 | 335 | 76 | Chilodonella uncinata 18S ribosomal RNA gene, partial sequence | blastn | 26142 | 481 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 19575598 | 19575598 | PRJNA488043_P_NODE_15856_length_215_cov_22.666667_g13614_i0 | PRJNA488043 | 15856 | 215 | 22.666667 | 48.73333405 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 381 | 2.1299999999999996e-101 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g13614 | i0 | 98.605 | 7.62325581395349 | 215 | 3 | 100 | 0 | 1 | 215 | 3121 | 3335 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 1639 | 381 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 22126253 | 22126253 | PRJNA488043_P_NODE_12918_length_262_cov_21.158798_g10677_i0 | PRJNA488043 | 12918 | 262 | 21.158798 | 55.43605076 | Tetrahymena rostrata | 5909 | SAR_Eukaryotes | SAR_Eukaryotes | 449 | 7.26e-122 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g10677 | i0 | 97.701 | 92.5267175572519 | 261 | 6 | 99 | 0 | 2 | 262 | 4458 | 4198 | 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 | 24242 | 449 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 23402228 | 23402228 | PRJNA488043_P_NODE_3099_length_835_cov_8.234491_g916_i1 | PRJNA488043 | 3099 | 835 | 8.234491 | 68.75799985 | Tetrahymena acanthophora | 2704174 | SAR_Eukaryotes | SAR_Eukaryotes | 632 | 2.359999999999999e-176 | NTclustered | gi|2082965250|gb|MZ827090.1| | 2704174 | g916 | i1 | 99.145 | 50.474251497006 | 351 | 3 | 71 | 0 | 485 | 835 | 869 | 519 | Tetrahymena acanthophora isolate NB176 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 42146 | 632 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena acanthophora | ||
| 27897455 | 27897455 | PRJNA488043_P_NODE_22225_length_153_cov_1.040323_g19983_i0 | PRJNA488043 | 22225 | 153 | 1.040323 | 1.59169419 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 79 | 1.55e-15 | NR | CAG9318302.1 | 1481888 | g19983 | i0 | 83.7 | 4.25490196078431 | 43 | 7 | 84.3 | 0 | 25 | 153 | 1 | 43 | CAG9318302.1 unnamed protein product [Blepharisma stoltei] | diamond | 651 | 79 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei |
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);;