contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA667863" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1910217 | 1910217 | PRJNA667863_P_NODE_3162_length_344_cov_2.221402_g3128_i0 | PRJNA667863 | 3162 | 344 | 2.221402 | 7.64162288 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 473 | 5.859999999999999e-129 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g3128 | i0 | 91.57 | 61.6598837209302 | 344 | 27 | 99 | 2 | 1 | 343 | 785 | 1127 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 21211 | 473 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 3184945 | 3184945 | PRJNA667863_P_NODE_4343_length_315_cov_2.409091_g4309_i0 | PRJNA667863 | 4343 | 315 | 2.409091 | 7.58863665 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 364 | 3.3299999999999986e-96 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g4309 | i0 | 87.619 | 25.9047619047619 | 315 | 37 | 99 | 2 | 2 | 315 | 587 | 274 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 8160 | 364 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 3715214 | 3715214 | PRJNA667863_P_NODE_17803_length_234_cov_3.080745_g17769_i0 | PRJNA667863 | 17803 | 234 | 3.080745 | 7.2089433 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 433 | 6.41e-117 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g17769 | i0 | 100 | 30.6196581196581 | 234 | 0 | 100 | 0 | 1 | 234 | 1389 | 1156 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 7165 | 433 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 4461969 | 4461969 | PRJNA667863_P_NODE_6864_length_279_cov_11.859223_g6830_i0 | PRJNA667863 | 6864 | 279 | 11.859223 | 33.08723217 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 1.05e-90 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g6830 | i0 | 93.534 | 6.76344086021505 | 232 | 15 | 83 | 0 | 48 | 279 | 1 | 232 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 1887 | 346 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 7012576 | 7012576 | PRJNA667863_P_NODE_426_length_711_cov_5.695925_g397_i0 | PRJNA667863 | 426 | 711 | 5.695925 | 40.49802675 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 651 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g397 | i0 | 84.328 | 48.2095639943741 | 670 | 99 | 94 | 5 | 45 | 711 | 1205 | 539 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 34277 | 651 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 8287305 | 8287305 | PRJNA667863_P_NODE_5447_length_295_cov_1.171171_g5413_i0 | PRJNA667863 | 5447 | 295 | 1.171171 | 3.45495445 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 7.040000000000001e-58 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g5413 | i0 | 82.182 | 33.7525423728814 | 275 | 49 | 93 | 0 | 1 | 275 | 1378 | 1104 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 9957 | 237 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 9562370 | 9562370 | PRJNA667863_P_NODE_11868_length_250_cov_0.870056_g11834_i0 | PRJNA667863 | 11868 | 250 | 0.870056 | 2.17514 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.99e-92 | NTclustered | gi|829192317|ref|XM_001031469.3| | 312017 | g11834 | i0 | 92 | 1 | 250 | 20 | 100 | 0 | 1 | 250 | 457 | 208 | Tetrahymena thermophila SB210 40S ribosomal protein S19 partial mRNA | blastn | 250 | 351 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 9562512 | 9562512 | PRJNA667863_P_NODE_4928_length_304_cov_1.333333_g4894_i0 | PRJNA667863 | 4928 | 304 | 1.333333 | 4.05333232 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 9.16e-77 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g4894 | i0 | 84.641 | 9.21381578947368 | 306 | 41 | 99 | 6 | 2 | 304 | 370 | 672 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 2801 | 300 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 13917503 | 13917503 | PRJNA667863_P_NODE_2551_length_367_cov_5.772109_g2517_i0 | PRJNA667863 | 2551 | 367 | 5.772109 | 21.18364003 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 584 | 2.779999999999999e-162 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2517 | i0 | 95.368 | 67.9509536784741 | 367 | 17 | 100 | 0 | 1 | 367 | 435 | 69 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 24938 | 584 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 18486378 | 18486378 | PRJNA667863_P_NODE_19115_length_211_cov_4.144928_g19081_i0 | PRJNA667863 | 19115 | 211 | 4.144928 | 8.74579808 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 1.2999999999999999e-73 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g19081 | i0 | 91.827 | 0.985781990521327 | 208 | 15 | 98 | 2 | 1 | 207 | 384 | 178 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 208 | 289 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 18486384 | 18486384 | PRJNA667863_P_NODE_19395_length_203_cov_4.353846_g19361_i0 | PRJNA667863 | 19395 | 203 | 4.353846 | 8.83830738 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 1.34e-18 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g19361 | i0 | 79.355 | 24.2807881773399 | 155 | 28 | 75 | 4 | 48 | 200 | 624 | 472 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 4929 | 106 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 19760895 | 19760895 | PRJNA667863_P_NODE_17296_length_240_cov_2.305389_g17262_i0 | PRJNA667863 | 17296 | 240 | 2.305389 | 5.5329336 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 6.839999999999999e-92 | NTclustered | gi|158347525|gb|EU047814.1| | 151077 | g17262 | i0 | 92.917 | 98.1333333333333 | 240 | 17 | 100 | 0 | 1 | 240 | 613 | 374 | Chilodonella uncinata clone Shared_P1 beta-tubulin gene, partial cds; macronuclear | blastn | 23552 | 350 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 21036386 | 21036386 | PRJNA667863_P_NODE_1217_length_466_cov_1.625954_g1184_i0 | PRJNA667863 | 1217 | 466 | 1.625954 | 7.57694564 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 664 | 0 | NTclustered | gi|347439291|gb|JN111994.1| | 151077 | g1184 | i0 | 92.308 | 99.8412017167382 | 468 | 34 | 100 | 1 | 1 | 466 | 677 | 210 | Chilodonella uncinata strain Pol alpha-tubulin (atub) gene, partial cds; macronuclear | blastn | 46526 | 664 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 21036555 | 21036555 | PRJNA667863_P_NODE_6817_length_280_cov_1.487923_g6783_i0 | PRJNA667863 | 6817 | 280 | 1.487923 | 4.1661844 | Sterkiella nova | 200597 | SAR_Eukaryotes | SAR_Eukaryotes | 246 | 1.1e-60 | NTclustered | gi|1051275|gb|U37280.1|ONU37280 | 200597 | g6783 | i0 | 82.734 | 37.5142857142857 | 278 | 46 | 99 | 2 | 4 | 280 | 1676 | 1952 | Oxytricha nova Hsp70 gene, complete cds | blastn | 10504 | 246 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella nova | ||
| 22311368 | 22311368 | PRJNA667863_P_NODE_5098_length_301_cov_1.675439_g5064_i0 | PRJNA667863 | 5098 | 301 | 1.675439 | 5.04307139 | Tetrahymena rostrata | 5909 | SAR_Eukaryotes | SAR_Eukaryotes | 518 | 2.3e-142 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g5064 | i0 | 97.674 | 91.3056478405316 | 301 | 7 | 100 | 0 | 1 | 301 | 4524 | 4224 | 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 | 27483 | 518 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 23586769 | 23586769 | PRJNA667863_P_NODE_3339_length_339_cov_3.180451_g3305_i0 | PRJNA667863 | 3339 | 339 | 3.180451 | 10.78172889 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 488 | 2.06e-133 | NTclustered | gi|512134942|gb|JX178901.1| | 1295638 | g3305 | i0 | 93.617 | 84.0648967551622 | 329 | 17 | 96 | 4 | 1 | 327 | 1148 | 1474 | Vorticella sp. 4 JG-2011 clone 1 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 | 28498 | 488 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 24860253 | 24860253 | PRJNA667863_P_NODE_5660_length_291_cov_2.788991_g5626_i0 | PRJNA667863 | 5660 | 291 | 2.788991 | 8.11596381 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 333 | 8.6e-87 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g5626 | i0 | 87.329 | 1.00343642611684 | 292 | 36 | 100 | 1 | 1 | 291 | 318 | 27 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 292 | 333 | 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);;