contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA1192965" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 320559 | 320559 | PRJNA1192965_P_NODE_2081_length_296_cov_1.381166_g2062_i0 | PRJNA1192965 | 2081 | 296 | 1.381166 | 4.08825136 | Sterkiella histriomuscorum | 94289 | SAR_Eukaryotes | SAR_Eukaryotes | 394 | 3.96e-105 | NTclustered | gi|47175724|gb|AY617304.1| | 94289 | g2062 | i0 | 90.816 | 65.722972972973 | 294 | 27 | 99 | 0 | 3 | 296 | 178 | 471 | Sterkiella histriomuscorum clone UGC1O0001_L01_F genomic sequence | blastn | 19454 | 394 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 320564 | 320564 | PRJNA1192965_P_NODE_281_length_669_cov_4.815436_g263_i0 | PRJNA1192965 | 281 | 669 | 4.815436 | 32.21526684 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1086 | 0 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g263 | i0 | 95.964 | 45.7130044843049 | 669 | 27 | 100 | 0 | 1 | 669 | 690 | 22 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 30582 | 1086 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 1595173 | 1595173 | PRJNA1192965_P_NODE_82_length_1065_cov_6.269153_g72_i0 | PRJNA1192965 | 82 | 1065 | 6.269153 | 66.76647945 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1646 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g72 | i0 | 97.222 | 21.3380281690141 | 972 | 27 | 91 | 0 | 1 | 972 | 234 | 1205 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 22725 | 1646 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 2871279 | 2871279 | PRJNA1192965_P_NODE_183_length_803_cov_2.636986_g169_i0 | PRJNA1192965 | 183 | 803 | 2.636986 | 21.17499758 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1131 | 0 | NTclustered | gi|110645006|gb|DQ665938.1| | 151077 | g169 | i0 | 95 | 54.8829389788294 | 720 | 36 | 90 | 0 | 84 | 803 | 792 | 73 | Chilodonella uncinata actin gene, partial cds; macronuclear | blastn | 44071 | 1131 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 2871286 | 2871286 | PRJNA1192965_P_NODE_363_length_595_cov_3.865900_g345_i0 | PRJNA1192965 | 363 | 595 | 3.8659 | 23.002105 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 928 | 0 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g345 | i0 | 94.79 | 84.8773109243698 | 595 | 31 | 100 | 0 | 1 | 595 | 1055 | 1649 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 50502 | 928 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 4870459 | 4870459 | PRJNA1192965_P_NODE_1384_length_344_cov_2.273063_g1365_i0 | PRJNA1192965 | 1384 | 344 | 2.273063 | 7.81933672 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 628 | 1.1799999999999997e-175 | NTclustered | gi|13194559|gb|AF300281.1|AF300281 | 151077 | g1365 | i0 | 99.708 | 99.4883720930233 | 343 | 1 | 99 | 0 | 2 | 344 | 1546 | 1204 | Chilodonella uncinata clone 1 18S small subunit ribosomal RNA gene, partial sequence | blastn | 34224 | 628 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 7420276 | 7420276 | PRJNA1192965_P_NODE_1946_length_304_cov_1.333333_g1927_i0 | PRJNA1192965 | 1946 | 304 | 1.333333 | 4.05333232 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 374 | 5.319999999999998e-99 | NTclustered | gi|21215206|gb|AF510205.1| | 5947 | g1927 | i0 | 88.816 | 95.3421052631579 | 304 | 34 | 100 | 0 | 1 | 304 | 1279 | 976 | Oxytricha granulifera beta-tubulin gene, complete cds | blastn | 28984 | 375 | 0.997333333333333 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Oxytricha | Oxytricha granulifera | ||
| 9248445 | 9248445 | PRJNA1192965_P_NODE_848_length_413_cov_4.085294_g829_i0 | PRJNA1192965 | 848 | 413 | 4.085294 | 16.87226422 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 691 | 0 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g829 | i0 | 96.852 | 58.9661016949153 | 413 | 13 | 100 | 0 | 1 | 413 | 435 | 23 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 24353 | 691 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 10524215 | 10524215 | PRJNA1192965_P_NODE_5249_length_237_cov_2.451220_g5230_i0 | PRJNA1192965 | 5249 | 237 | 2.45122 | 5.8093914 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 1.4e-118 | NTclustered | gi|13194559|gb|AF300281.1|AF300281 | 151077 | g5230 | i0 | 100 | 98.2278481012658 | 237 | 0 | 100 | 0 | 1 | 237 | 885 | 649 | Chilodonella uncinata clone 1 18S small subunit ribosomal RNA gene, partial sequence | blastn | 23280 | 438 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 11799063 | 11799063 | PRJNA1192965_P_NODE_10_length_1929_cov_3.641703_g7_i0 | PRJNA1192965 | 10 | 1929 | 3.641703 | 70.24845087 | Tetmemena sp. Y1 | 1640447 | SAR_Eukaryotes | SAR_Eukaryotes | 1315 | 0 | NTclustered | gi|1227052606|gb|KY038460.1| | 1640447 | g7 | i0 | 81.423 | 63.4945567651633 | 1658 | 265 | 85 | 36 | 68 | 1702 | 1 | 1638 | Tetmemena sp. Y1 heat shock protein 70 (hsp70) gene, partial cds; macronuclear | blastn | 122481 | 1315 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Tetmemena | Tetmemena sp. Y1 | ||
| 11799091 | 11799091 | PRJNA1192965_P_NODE_4870_length_242_cov_1.366864_g4851_i0 | PRJNA1192965 | 4870 | 242 | 1.366864 | 3.30781088 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.11e-114 | NTclustered | gi|110644972|gb|DQ665918.1| | 151077 | g4851 | i0 | 98.347 | 92.9338842975207 | 242 | 4 | 100 | 0 | 1 | 242 | 412 | 653 | Chilodonella uncinata clone 1 beta-tubulin gene, partial cds | blastn | 22490 | 425 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 14349563 | 14349563 | PRJNA1192965_P_NODE_2892_length_263_cov_1.368421_g2873_i0 | PRJNA1192965 | 2892 | 263 | 1.368421 | 3.59894723 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 1.25e-104 | NTclustered | gi|662862630|gb|KJ000270.1| | 151077 | g2873 | i0 | 93.536 | 1 | 263 | 17 | 100 | 0 | 1 | 263 | 88 | 350 | Chilodonella uncinata strain ATCC PRA-256 clone P7 protein kinase domain containing protein gene, partial cds; macronuclear | blastn | 263 | 392 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 16897645 | 16897645 | PRJNA1192965_P_NODE_4834_length_243_cov_0.905882_g4815_i0 | PRJNA1192965 | 4834 | 243 | 0.905882 | 2.20129326 | Opisthonecta henneguyi | 6026 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 1.49e-93 | NTclustered | gi|4063597|gb|AF056109.1| | 6026 | g4815 | i0 | 93.004 | 47.156378600823 | 243 | 17 | 100 | 0 | 1 | 243 | 1219 | 977 | Telotrochidium henneguyii translation elongation factor 1-alpha (TEF1) gene, partial cds | blastn | 11459 | 355 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta henneguyi | ||
| 19446550 | 19446550 | PRJNA1192965_P_NODE_4156_length_246_cov_0.890173_g4137_i0 | PRJNA1192965 | 4156 | 246 | 0.890173 | 2.18982558 | Opisthonecta henneguyi | 6026 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 3.27e-90 | NTclustered | gi|4063597|gb|AF056109.1| | 6026 | g4137 | i0 | 92.181 | 43.2764227642276 | 243 | 19 | 99 | 0 | 1 | 243 | 275 | 517 | Telotrochidium henneguyii translation elongation factor 1-alpha (TEF1) gene, partial cds | blastn | 10646 | 344 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta henneguyi | ||
| 20721861 | 20721861 | PRJNA1192965_P_NODE_1497_length_334_cov_1.850575_g1478_i0 | PRJNA1192965 | 1497 | 334 | 1.850575 | 6.1809205 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 579 | 1.1699999999999997e-160 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g1478 | i0 | 97.904 | 1 | 334 | 7 | 100 | 0 | 1 | 334 | 513 | 180 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 334 | 579 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 21997218 | 21997218 | PRJNA1192965_P_NODE_1258_length_357_cov_5.302817_g1239_i0 | PRJNA1192965 | 1258 | 357 | 5.302817 | 18.93105669 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 641 | 1.5799999999999994e-179 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g1239 | i0 | 99.157 | 47.1204481792717 | 356 | 3 | 99 | 0 | 1 | 356 | 23 | 378 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 16822 | 641 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 23272674 | 23272674 | PRJNA1192965_P_NODE_2019_length_299_cov_2.637168_g2000_i0 | PRJNA1192965 | 2019 | 299 | 2.637168 | 7.88513232 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 553 | 6.25e-153 | NTclustered | gi|1202135013|gb|KY476314.1| | 151077 | g2000 | i0 | 100 | 95.8160535117057 | 299 | 0 | 100 | 0 | 1 | 299 | 19 | 317 | Chilodonella uncinata 18S ribosomal RNA gene, partial sequence | blastn | 28649 | 553 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24546551 | 24546551 | PRJNA1192965_P_NODE_2220_length_288_cov_9.948837_g2201_i0 | PRJNA1192965 | 2220 | 288 | 9.948837 | 28.65265056 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 416 | 8.2e-112 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g2201 | i0 | 97.154 | 80.0694444444444 | 246 | 7 | 85 | 0 | 43 | 288 | 1 | 246 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 23060 | 416 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24546572 | 24546572 | PRJNA1192965_P_NODE_5260_length_236_cov_2.079755_g5241_i0 | PRJNA1192965 | 5260 | 236 | 2.079755 | 4.9082218 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.66e-21 | NTclustered | gi|829192014|ref|XM_012799966.1| | 312017 | g5241 | i0 | 88.421 | 1.77966101694915 | 95 | 11 | 40 | 0 | 48 | 142 | 125 | 219 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 420 | 115 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 25268587 | 25268587 | PRJNA1192965_P_NODE_440_length_547_cov_1.352321_g422_i0 | PRJNA1192965 | 440 | 547 | 1.352321 | 7.39719587 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 937 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g422 | i0 | 97.619 | 67.0402193784278 | 546 | 13 | 99 | 0 | 1 | 546 | 364 | 909 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 36671 | 937 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola |
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);;