contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA1108009" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 212818 | 212818 | PRJNA1108009_P_NODE_16341_length_324_cov_1.378486_g16023_i0 | PRJNA1108009 | 16341 | 324 | 1.378486 | 4.46629464 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 4.33e-115 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g16023 | i0 | 90.654 | 9.02777777777778 | 321 | 30 | 99 | 0 | 4 | 324 | 821 | 501 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 2925 | 427 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 1487457 | 1487457 | PRJNA1108009_P_NODE_14502_length_347_cov_0.996350_g14184_i0 | PRJNA1108009 | 14502 | 347 | 0.99635 | 3.4573345 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 407 | 6.09e-109 | NTclustered | gi|298497487|gb|GQ465330.1| | 151077 | g14184 | i0 | 96.735 | 84.0432276657061 | 245 | 7 | 96 | 1 | 1 | 245 | 428 | 671 | Chilodonella uncinata strain Poland clone shared_p1 beta-tubulin gene, partial cds; micronuclear | blastn | 29163 | 407 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 1487838 | 1487838 | PRJNA1108009_P_NODE_30162_length_243_cov_0.905882_g29844_i0 | PRJNA1108009 | 30162 | 243 | 0.905882 | 2.20129326 | Parafurgasonia sp. FG-2015 | 1607891 | SAR_Eukaryotes | SAR_Eukaryotes | 233 | 7.289999999999999e-57 | NTclustered | gi|759083542|gb|KM222159.1| | 1607891 | g29844 | i0 | 85.903 | 94.2469135802469 | 227 | 23 | 92 | 7 | 20 | 243 | 1738 | 1518 | Parafurgasonia sp. FG-2015 voucher FXP_S011 large subunit ribosomal RNA gene, partial sequence | blastn | 22902 | 233 | 1 | Eukaryota | Sar | Ciliophora | Nassophorea | Nassulida | Furgasoniidae | Parafurgasonia | Parafurgasonia sp. FG-2015 | ||
| 1488051 | 1488051 | PRJNA1108009_P_NODE_962_length_1282_cov_5.093466_g685_i2 | PRJNA1108009 | 962 | 1282 | 5.093466 | 65.29823412 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1910 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g685 | i2 | 95.274 | 45.792511700468 | 1206 | 55 | 94 | 2 | 50 | 1254 | 1 | 1205 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 58706 | 1910 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 1488054 | 1488054 | PRJNA1108009_P_NODE_9702_length_435_cov_2.179558_g9384_i0 | PRJNA1108009 | 9702 | 435 | 2.179558 | 9.4810773 | Tetmemena sp. Y1 | 1640447 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 1.02e-97 | NTclustered | gi|1227052606|gb|KY038460.1| | 1640447 | g9384 | i0 | 82.892 | 89.4597701149425 | 415 | 67 | 95 | 3 | 9 | 421 | 413 | 1 | Tetmemena sp. Y1 heat shock protein 70 (hsp70) gene, partial cds; macronuclear | blastn | 38915 | 370 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Tetmemena | Tetmemena sp. Y1 | ||
| 4040013 | 4040013 | PRJNA1108009_P_NODE_3484_length_747_cov_1.415430_g3194_i0 | PRJNA1108009 | 3484 | 747 | 1.41543 | 10.573262100000001 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 684 | 0 | NTclustered | gi|829160170|ref|XM_001012263.3| | 312017 | g3194 | i0 | 83.333 | 89.7804551539491 | 750 | 115 | 99 | 10 | 1 | 745 | 1324 | 580 | Tetrahymena thermophila SB210 heat shock 70 kDa protein partial mRNA | blastn | 67066 | 684 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 5316030 | 5316030 | PRJNA1108009_P_NODE_2825_length_822_cov_1.769025_g2556_i0 | PRJNA1108009 | 2825 | 822 | 1.769025 | 14.5413855 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 1408 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2556 | i0 | 97.567 | 57.2980535279805 | 822 | 20 | 100 | 0 | 1 | 822 | 2318 | 1497 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 47099 | 1408 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 11691676 | 11691676 | PRJNA1108009_P_NODE_22190_length_270_cov_1.172589_g21872_i0 | PRJNA1108009 | 22190 | 270 | 1.172589 | 3.1659903 | Colpoda inflata | 5980 | SAR_Eukaryotes | SAR_Eukaryotes | 383 | 7.73e-102 | NTclustered | gi|4063575|gb|AF056098.1|AF056098 | 5980 | g21872 | i0 | 92.222 | 77.5185185185185 | 270 | 21 | 100 | 0 | 1 | 270 | 750 | 481 | Colpoda inflata translation elongation factor 1-alpha (TEF1) gene, partial cds | blastn | 20930 | 383 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda inflata | ||
| 12499304 | 12499304 | PRJNA1108009_P_NODE_16590_length_321_cov_1.806452_g16272_i0 | PRJNA1108009 | 16590 | 321 | 1.806452 | 5.79871092 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 2.26e-23 | NTclustered | gi|315570348|tpg|BK007936.1| | 5911 | g16272 | i0 | 83.459 | 0.828660436137072 | 133 | 20 | 41 | 2 | 157 | 288 | 132 | 1 | TPA_exp: Tetrahymena thermophila 40S ribosomal protein rpS29e mRNA, complete cds | blastn | 266 | 122 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 12966892 | 12966892 | PRJNA1108009_P_NODE_24711_length_251_cov_0.865169_g24393_i0 | PRJNA1108009 | 24711 | 251 | 0.865169 | 2.17157419 | Isotricha intestinalis | 47897 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 1.62e-63 | NTclustered | gi|92790151|emb|AJ965261.1| | 47897 | g24393 | i0 | 87.963 | 125.091633466135 | 216 | 26 | 86 | 0 | 36 | 251 | 916 | 701 | Isotricha intestinalis partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene) | blastn | 31398 | 255 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Vestibuliferida | Isotrichidae | Isotricha | Isotricha intestinalis | ||
| 12967219 | 12967219 | PRJNA1108009_P_NODE_911_length_1305_cov_5.115260_g685_i1 | PRJNA1108009 | 911 | 1305 | 5.11526 | 66.754143 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 2021 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g685 | i1 | 96.929 | 43.8 | 1205 | 37 | 92 | 0 | 50 | 1254 | 1 | 1205 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 57159 | 2021 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 14241598 | 14241598 | PRJNA1108009_P_NODE_15052_length_340_cov_0.902622_g14734_i0 | PRJNA1108009 | 15052 | 340 | 0.902622 | 3.0689148 | Sterkiella nova | 200597 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 8.38e-48 | NTclustered | gi|1051275|gb|U37280.1|ONU37280 | 200597 | g14734 | i0 | 77.778 | 62.1117647058824 | 342 | 68 | 99 | 8 | 2 | 339 | 1977 | 1640 | Oxytricha nova Hsp70 gene, complete cds | blastn | 21118 | 204 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella nova | ||
| 14242147 | 14242147 | PRJNA1108009_P_NODE_852_length_1338_cov_6.203162_g685_i0 | PRJNA1108009 | 852 | 1338 | 6.203162 | 82.99830756 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1871 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g685 | i0 | 94.689 | 43.3916292974589 | 1205 | 64 | 90 | 0 | 50 | 1254 | 1 | 1205 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 58058 | 1871 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 15515397 | 15515397 | PRJNA1108009_P_NODE_14713_length_344_cov_1.339483_g14395_i0 | PRJNA1108009 | 14713 | 344 | 1.339483 | 4.60782152 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 486 | 7.529999999999999e-133 | NTclustered | gi|110645006|gb|DQ665938.1| | 151077 | g14395 | i0 | 92.151 | 11.4796511627907 | 344 | 27 | 100 | 0 | 1 | 344 | 757 | 414 | Chilodonella uncinata actin gene, partial cds; macronuclear | blastn | 3949 | 486 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 21889573 | 21889573 | PRJNA1108009_P_NODE_14878_length_342_cov_1.115242_g14560_i0 | PRJNA1108009 | 14878 | 342 | 1.115242 | 3.81412764 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 1.8e-54 | NTclustered | gi|584458848|gb|KJ159074.1| | 5949 | g14560 | i0 | 80.259 | 113.526315789474 | 309 | 53 | 89 | 8 | 2 | 306 | 853 | 1157 | Stylonychia lemnae histone variant H3.1 (HIS31) gene, complete cds; macronuclear | blastn | 38826 | 226 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 21889690 | 21889690 | PRJNA1108009_P_NODE_19578_length_291_cov_1.091743_g19260_i0 | PRJNA1108009 | 19578 | 291 | 1.091743 | 3.17697213 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 3.8099999999999997e-120 | NTclustered | gi|158347525|gb|EU047814.1| | 151077 | g19260 | i0 | 94.158 | 99.0721649484536 | 291 | 17 | 100 | 0 | 1 | 291 | 689 | 399 | Chilodonella uncinata clone Shared_P1 beta-tubulin gene, partial cds; macronuclear | blastn | 28830 | 444 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 22697446 | 22697446 | PRJNA1108009_P_NODE_20378_length_284_cov_2.137441_g20060_i0 | PRJNA1108009 | 20378 | 284 | 2.137441 | 6.07033244 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 1.1299999999999995e-55 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g20060 | i0 | 97.059 | 1.43661971830986 | 136 | 4 | 48 | 0 | 1 | 136 | 2947 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 408 | 230 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 23164975 | 23164975 | PRJNA1108009_P_NODE_11539_length_394_cov_1.386293_g11221_i0 | PRJNA1108009 | 11539 | 394 | 1.386293 | 5.46199442 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 645 | 1.3599999999999996e-180 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g11221 | i0 | 96.193 | 59.7969543147208 | 394 | 15 | 100 | 0 | 1 | 394 | 1475 | 1082 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 23560 | 645 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 23165035 | 23165035 | PRJNA1108009_P_NODE_13379_length_362_cov_2.128028_g13061_i0 | PRJNA1108009 | 13379 | 362 | 2.128028 | 7.70346136 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 592 | 1.6399999999999999e-164 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g13061 | i0 | 96.133 | 13.1187845303867 | 362 | 14 | 100 | 0 | 1 | 362 | 383 | 22 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 4749 | 592 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 23165038 | 23165038 | PRJNA1108009_P_NODE_13499_length_361_cov_0.795139_g13181_i0 | PRJNA1108009 | 13499 | 361 | 0.795139 | 2.87045179 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 2.46e-53 | NTclustered | gi|829192616|ref|XM_001029813.3| | 312017 | g13181 | i0 | 78.056 | 2.64819944598338 | 360 | 73 | 99 | 6 | 1 | 357 | 357 | 1 | Tetrahymena thermophila SB210 60S ribosomal protein L15 partial mRNA | blastn | 956 | 222 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 23165496 | 23165496 | PRJNA1108009_P_NODE_31279_length_241_cov_1.839286_g30961_i0 | PRJNA1108009 | 31279 | 241 | 1.839286 | 4.43267926 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 446 | 8.519999999999999e-121 | NTclustered | gi|13194559|gb|AF300281.1|AF300281 | 151077 | g30961 | i0 | 100 | 98.8340248962656 | 241 | 0 | 100 | 0 | 1 | 241 | 17 | 257 | Chilodonella uncinata clone 1 18S small subunit ribosomal RNA gene, partial sequence | blastn | 23819 | 446 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24438911 | 24438911 | PRJNA1108009_P_NODE_23000_length_263_cov_3.326316_g22682_i0 | PRJNA1108009 | 23000 | 263 | 3.326316 | 8.74821108 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 475 | 1.2e-129 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g22682 | i0 | 99.24 | 100.532319391635 | 263 | 2 | 100 | 0 | 1 | 263 | 670 | 932 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 26440 | 475 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 24438938 | 24438938 | PRJNA1108009_P_NODE_24140_length_254_cov_2.320442_g23822_i0 | PRJNA1108009 | 24140 | 254 | 2.320442 | 5.89392268 | Sorogena stoianovitchae | 164621 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 5.73e-83 | NTclustered | gi|169659247|dbj|AB325967.1| | 164621 | g23822 | i0 | 90.496 | 96.4763779527559 | 242 | 23 | 95 | 0 | 3 | 244 | 699 | 458 | Sorogena stoianovitchae sbt mRNA for putative beta-tubulin, partial cds | blastn | 24505 | 320 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Sorogenida | Sorogenidae | Sorogena | Sorogena stoianovitchae | ||
| 24439293 | 24439293 | PRJNA1108009_P_NODE_9780_length_433_cov_4.902778_g9462_i0 | PRJNA1108009 | 9780 | 433 | 4.902778 | 21.22902874 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 617 | 3.29e-172 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g9462 | i0 | 92.379 | 58.6836027713626 | 433 | 33 | 100 | 0 | 1 | 433 | 60 | 492 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 25410 | 617 | 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);;