contig_metadata
26 rows where analysis = "blastn", bioproject = "PRJNA1108487" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2296035 | 2296035 | PRJNA1108487_P_NODE_2022_length_478_cov_8.817284_g1956_i0 | PRJNA1108487 | 2022 | 478 | 8.817284 | 42.14661752 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 6.619999999999998e-115 | NTclustered | gi|10805|emb|X52242.1| | 5911 | g1956 | i0 | 84.127 | 90.0690376569038 | 441 | 70 | 92 | 0 | 1 | 441 | 38 | 478 | T.thermophila mRNA for calmodulin | blastn | 43053 | 427 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 5316309 | 5316309 | PRJNA1108487_P_NODE_3225_length_379_cov_3.787582_g3159_i0 | PRJNA1108487 | 3225 | 379 | 3.787582 | 14.35493578 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 645 | 1.3e-180 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g3159 | i0 | 97.361 | 64.1662269129288 | 379 | 10 | 100 | 0 | 1 | 379 | 393 | 15 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 24319 | 645 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 6591517 | 6591517 | PRJNA1108487_P_NODE_3186_length_382_cov_1.245955_g3120_i0 | PRJNA1108487 | 3186 | 382 | 1.245955 | 4.7595481 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 492 | 1.81e-134 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g3120 | i0 | 90.026 | 7.36125654450262 | 381 | 36 | 99 | 2 | 3 | 382 | 246 | 625 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 2812 | 492 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 7398380 | 7398380 | PRJNA1108487_P_NODE_1966_length_484_cov_3.245742_g1900_i0 | PRJNA1108487 | 1966 | 484 | 3.245742 | 15.70939128 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 894 | 0 | NTclustered | gi|363412153|gb|JN120227.1| | 60850 | g1900 | i0 | 100 | 100.010330578512 | 484 | 0 | 100 | 0 | 1 | 484 | 950 | 467 | Vorticella convallaria isolate 96Vorsp16 18S ribosomal RNA gene, partial sequence | blastn | 48405 | 894 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella convallaria | ||
| 9141030 | 9141030 | PRJNA1108487_P_NODE_2328_length_445_cov_1.655914_g2262_i0 | PRJNA1108487 | 2328 | 445 | 1.655914 | 7.3688173 | Tetmemena sp. Y1 | 1640447 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 6.08e-120 | NTclustered | gi|1710560089|gb|MN207909.1| | 1640447 | g2262 | i0 | 94.158 | 2.69887640449438 | 291 | 17 | 65 | 0 | 146 | 436 | 400 | 110 | Tetmemena sp. Y1 catalase gene, partial cds; macronuclear | blastn | 1201 | 444 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Tetmemena | Tetmemena sp. Y1 | ||
| 9141034 | 9141034 | PRJNA1108487_P_NODE_2568_length_423_cov_1.697143_g2502_i0 | PRJNA1108487 | 2568 | 423 | 1.697143 | 7.17891489 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 756 | 0 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g2502 | i0 | 99.052 | 53.0118203309693 | 422 | 3 | 99 | 1 | 3 | 423 | 450 | 29 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 22424 | 756 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 9141068 | 9141068 | PRJNA1108487_P_NODE_5788_length_296_cov_2.080717_g5722_i0 | PRJNA1108487 | 5788 | 296 | 2.080717 | 6.15892232 | Tetmemena sp. Y1 | 1640447 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 3.27e-61 | NTclustered | gi|1227052606|gb|KY038460.1| | 1640447 | g5722 | i0 | 81.879 | 11.7567567567568 | 298 | 50 | 100 | 3 | 1 | 296 | 321 | 26 | Tetmemena sp. Y1 heat shock protein 70 (hsp70) gene, partial cds; macronuclear | blastn | 3480 | 248 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Tetmemena | Tetmemena sp. Y1 | ||
| 9141076 | 9141076 | PRJNA1108487_P_NODE_7748_length_261_cov_1.659574_g7682_i0 | PRJNA1108487 | 7748 | 261 | 1.659574 | 4.33148814 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 6.2499999999999984e-43 | NTclustered | gi|347439289|gb|JN111993.1| | 151077 | g7682 | i0 | 82.11 | 1.67049808429119 | 218 | 39 | 84 | 0 | 44 | 261 | 541 | 758 | Chilodonella uncinata strain USA_WH clone P3 beta tubulin (btub) gene, partial cds; macronuclear | blastn | 436 | 187 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 9141077 | 9141077 | PRJNA1108487_P_NODE_7768_length_261_cov_1.441489_g7702_i0 | PRJNA1108487 | 7768 | 261 | 1.441489 | 3.76228629 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 2.1e-92 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g7702 | i0 | 90.909 | 15.9578544061303 | 264 | 21 | 100 | 2 | 1 | 261 | 646 | 383 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 4165 | 351 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 10416863 | 10416863 | PRJNA1108487_P_NODE_449_length_939_cov_4.836028_g382_i1 | PRJNA1108487 | 449 | 939 | 4.836028 | 45.41030292 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1555 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g382 | i1 | 96.976 | 13.8764643237487 | 926 | 28 | 99 | 0 | 12 | 937 | 1205 | 280 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 13030 | 1555 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 11692083 | 11692083 | PRJNA1108487_P_NODE_10270_length_245_cov_2.680233_g10204_i0 | PRJNA1108487 | 10270 | 245 | 2.680233 | 6.56657085 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.7800000000000003e-21 | NTclustered | gi|829192014|ref|XM_012799966.1| | 312017 | g10204 | i0 | 88.421 | 1.71428571428571 | 95 | 11 | 39 | 0 | 109 | 203 | 219 | 125 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 420 | 115 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 11692088 | 11692088 | PRJNA1108487_P_NODE_1490_length_545_cov_6.438559_g1425_i0 | PRJNA1108487 | 1490 | 545 | 6.438559 | 35.09014655 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 963 | 0 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g1425 | i0 | 98.532 | 94.4422018348624 | 545 | 8 | 100 | 0 | 1 | 545 | 1544 | 1000 | Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 51471 | 963 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 12967272 | 12967272 | PRJNA1108487_P_NODE_431_length_953_cov_3.479545_g382_i0 | PRJNA1108487 | 431 | 953 | 3.479545 | 33.16006385 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1472 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g382 | i0 | 95.361 | 14.386149003148 | 927 | 41 | 97 | 2 | 26 | 951 | 1205 | 280 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 13710 | 1472 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 12967273 | 12967273 | PRJNA1108487_P_NODE_4691_length_323_cov_3.036000_g4625_i0 | PRJNA1108487 | 4691 | 323 | 3.036 | 9.80628 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 490 | 5.42e-134 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g4625 | i0 | 98.556 | 95.343653250774 | 277 | 4 | 86 | 0 | 47 | 323 | 1 | 277 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 30796 | 490 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 12967293 | 12967293 | PRJNA1108487_P_NODE_7791_length_260_cov_3.491979_g7725_i0 | PRJNA1108487 | 7791 | 260 | 3.491979 | 9.0791454 | Tetmemena sp. Y1 | 1640447 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 1.06e-30 | NTclustered | gi|1710560089|gb|MN207909.1| | 1640447 | g7725 | i0 | 95.604 | 0.461538461538462 | 91 | 4 | 35 | 0 | 13 | 103 | 101 | 11 | Tetmemena sp. Y1 catalase gene, partial cds; macronuclear | blastn | 120 | 147 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Tetmemena | Tetmemena sp. Y1 | ||
| 12967294 | 12967294 | PRJNA1108487_P_NODE_791_length_726_cov_3.111792_g730_i0 | PRJNA1108487 | 791 | 726 | 3.111792 | 22.59160992 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 974 | 0 | NTclustered | gi|390195606|gb|JX112363.1| | 151077 | g730 | i0 | 91.942 | 99.2589531680441 | 695 | 56 | 96 | 0 | 1 | 695 | 695 | 1 | Chilodonella uncinata strain USA_SC2 beta-tubulin (Btub) gene, partial cds; macronuclear | blastn | 72062 | 974 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 14242198 | 14242198 | PRJNA1108487_P_NODE_1232_length_597_cov_4.946565_g1167_i0 | PRJNA1108487 | 1232 | 597 | 4.946565 | 29.53099305 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 944 | 0 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g1167 | i0 | 95.586 | 14.820770519263 | 589 | 26 | 99 | 0 | 9 | 597 | 181 | 769 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 8848 | 944 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 16323117 | 16323117 | PRJNA1108487_P_NODE_8673_length_252_cov_0.871508_g8607_i0 | PRJNA1108487 | 8673 | 252 | 0.871508 | 2.19620016 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 1.31e-34 | NTclustered | gi|151384832|gb|EF672110.1| | 5911 | g8607 | i0 | 78.4 | 10.2222222222222 | 250 | 50 | 98 | 3 | 4 | 251 | 689 | 442 | Tetrahymena thermophila dynein heavy chain 9 (DYH9) gene, partial cds; macronuclear | blastn | 2576 | 159 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 16790579 | 16790579 | PRJNA1108487_P_NODE_5514_length_303_cov_1.230435_g5448_i0 | PRJNA1108487 | 5514 | 303 | 1.230435 | 3.72821805 | Telotrochidium matiense | 455295 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 4.3399999999999997e-60 | NTclustered | gi|21898545|gb|AY101355.1| | 455295 | g5448 | i0 | 84.836 | 18.3300330033003 | 244 | 35 | 80 | 1 | 8 | 249 | 255 | 12 | Opisthonecta matiensis actin II gene, partial cds | blastn | 5554 | 244 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Telotrochidium | Telotrochidium matiense | ||
| 16790582 | 16790582 | PRJNA1108487_P_NODE_594_length_836_cov_11.608126_g537_i0 | PRJNA1108487 | 594 | 836 | 11.608126 | 97.04393336 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 1406 | 0 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g537 | i0 | 97.017 | 56.1722488038277 | 838 | 22 | 100 | 3 | 1 | 836 | 1500 | 2336 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 46960 | 1406 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 19339306 | 19339306 | PRJNA1108487_P_NODE_5956_length_292_cov_2.621005_g5890_i0 | PRJNA1108487 | 5956 | 292 | 2.621005 | 7.6533346 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 335 | 2.4e-87 | NTclustered | gi|390195606|gb|JX112363.1| | 151077 | g5890 | i0 | 87.329 | 34.9006849315069 | 292 | 37 | 100 | 0 | 1 | 292 | 188 | 479 | Chilodonella uncinata strain USA_SC2 beta-tubulin (Btub) gene, partial cds; macronuclear | blastn | 10191 | 335 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 20614532 | 20614532 | PRJNA1108487_P_NODE_10557_length_244_cov_1.824561_g10491_i0 | PRJNA1108487 | 10557 | 244 | 1.824561 | 4.45192884 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 1.17e-89 | NTclustered | gi|149394715|gb|EF125697.1| | 151077 | g10491 | i0 | 92.469 | 4.36885245901639 | 239 | 18 | 98 | 0 | 1 | 239 | 676 | 438 | Chilodonella uncinata strain ATCC 50194 serine/threonine protein phosphatase-like gene, complete sequence; macronuclear | blastn | 1066 | 342 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 21890247 | 21890247 | PRJNA1108487_P_NODE_4278_length_336_cov_2.604563_g4212_i0 | PRJNA1108487 | 4278 | 336 | 2.604563 | 8.75133168 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 1e-91 | NTclustered | gi|390195606|gb|JX112363.1| | 151077 | g4212 | i0 | 91.373 | 87.2440476190476 | 255 | 22 | 76 | 0 | 3 | 257 | 677 | 931 | Chilodonella uncinata strain USA_SC2 beta-tubulin (Btub) gene, partial cds; macronuclear | blastn | 29314 | 350 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24439338 | 24439338 | PRJNA1108487_P_NODE_4200_length_339_cov_1.172932_g4134_i0 | PRJNA1108487 | 4200 | 339 | 1.172932 | 3.97623948 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 472 | 2.07e-128 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g4134 | i0 | 91.74 | 2.88495575221239 | 339 | 28 | 100 | 0 | 1 | 339 | 1312 | 1650 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 978 | 472 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24439352 | 24439352 | PRJNA1108487_P_NODE_6860_length_275_cov_1.544554_g6794_i0 | PRJNA1108487 | 6860 | 275 | 1.544554 | 4.2475235 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 6.41e-68 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g6794 | i0 | 84.532 | 13.8909090909091 | 278 | 37 | 100 | 3 | 1 | 275 | 558 | 284 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 3820 | 270 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 25246967 | 25246967 | PRJNA1108487_P_NODE_3020_length_390_cov_6.675079_g2954_i0 | PRJNA1108487 | 3020 | 390 | 6.675079 | 26.0328081 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 693 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2954 | i0 | 98.718 | 79.7333333333333 | 390 | 5 | 100 | 0 | 1 | 390 | 2403 | 2792 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 31096 | 693 | 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);;