contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1082072" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193191 | 193191 | PRJNA1082072_P_NODE_601_length_406_cov_2.057057_g594_i0 | PRJNA1082072 | 601 | 406 | 2.057057 | 8.35165142 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 739 | 0 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g594 | i0 | 99.507 | 53.2709359605911 | 406 | 2 | 100 | 0 | 1 | 406 | 429 | 24 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 21628 | 739 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 1467759 | 1467759 | PRJNA1082072_P_NODE_242_length_616_cov_1.012891_g235_i0 | PRJNA1082072 | 242 | 616 | 1.012891 | 6.23940856 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 983 | 0 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g235 | i0 | 95.455 | 49.4107142857143 | 616 | 28 | 100 | 0 | 1 | 616 | 647 | 32 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 30437 | 983 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 2743892 | 2743892 | PRJNA1082072_P_NODE_1023_length_338_cov_1.743396_g1016_i0 | PRJNA1082072 | 1023 | 338 | 1.743396 | 5.89267848 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 547 | 3.339999999999999e-151 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g1016 | i0 | 95.858 | 43.5887573964497 | 338 | 14 | 100 | 0 | 1 | 338 | 376 | 39 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 14733 | 547 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 5295973 | 5295973 | PRJNA1082072_P_NODE_1945_length_259_cov_0.844086_g1938_i0 | PRJNA1082072 | 1945 | 259 | 0.844086 | 2.18618274 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 7.959999999999999e-47 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g1938 | i0 | 89.375 | 0.617760617760618 | 160 | 15 | 61 | 2 | 34 | 192 | 213 | 371 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 160 | 200 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 5295979 | 5295979 | PRJNA1082072_P_NODE_685_length_389_cov_1.218354_g678_i0 | PRJNA1082072 | 685 | 389 | 1.218354 | 4.73939706 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 315 | 4.29e-81 | NTclustered | gi|829100487|ref|XM_001007447.3| | 312017 | g678 | i0 | 81.378 | 73.2519280205656 | 392 | 67 | 100 | 5 | 1 | 389 | 1865 | 1477 | Tetrahymena thermophila SB210 transitional endoplasmic reticulum ATPase, putative partial mRNA | blastn | 28495 | 315 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 6571088 | 6571088 | PRJNA1082072_P_NODE_2466_length_247_cov_0.885057_g2459_i0 | PRJNA1082072 | 2466 | 247 | 0.885057 | 2.18609079 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 9.21e-86 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g2459 | i0 | 90.688 | 10.7085020242915 | 247 | 23 | 100 | 0 | 1 | 247 | 736 | 490 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 2645 | 329 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 9120812 | 9120812 | PRJNA1082072_P_NODE_568_length_414_cov_2.258065_g561_i0 | PRJNA1082072 | 568 | 414 | 2.258065 | 9.3483891 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 592 | 1.9e-164 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g561 | i0 | 97.143 | 48.012077294686 | 350 | 10 | 85 | 0 | 1 | 350 | 856 | 1205 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 19877 | 592 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 15495821 | 15495821 | PRJNA1082072_P_NODE_1853_length_265_cov_1.333333_g1846_i0 | PRJNA1082072 | 1853 | 265 | 1.333333 | 3.53333245 | Tetmemena sp. Y1 | 1640447 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 9.92e-91 | NTclustered | gi|1710560089|gb|MN207909.1| | 1640447 | g1846 | i0 | 90.189 | 1.59622641509434 | 265 | 26 | 100 | 0 | 1 | 265 | 291 | 27 | Tetmemena sp. Y1 catalase gene, partial cds; macronuclear | blastn | 423 | 346 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Tetmemena | Tetmemena sp. Y1 | ||
| 19318919 | 19318919 | PRJNA1082072_P_NODE_1796_length_269_cov_1.571429_g1789_i0 | PRJNA1082072 | 1796 | 269 | 1.571429 | 4.22714401 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 5.95e-103 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g1789 | i0 | 97.768 | 26.7955390334572 | 224 | 5 | 83 | 0 | 7 | 230 | 224 | 1 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 7208 | 387 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 19318921 | 19318921 | PRJNA1082072_P_NODE_216_length_637_cov_1.546099_g209_i0 | PRJNA1082072 | 216 | 637 | 1.546099 | 9.84865063 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1016 | 0 | NTclustered | gi|110645006|gb|DQ665938.1| | 151077 | g209 | i0 | 95.447 | 12.8147566718995 | 637 | 29 | 100 | 0 | 1 | 637 | 735 | 99 | Chilodonella uncinata actin gene, partial cds; macronuclear | blastn | 8163 | 1016 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 20594229 | 20594229 | PRJNA1082072_P_NODE_357_length_504_cov_1.440835_g350_i0 | PRJNA1082072 | 357 | 504 | 1.440835 | 7.2618084 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 854 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g350 | i0 | 97.222 | 32.2222222222222 | 504 | 14 | 100 | 0 | 1 | 504 | 897 | 394 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 16240 | 854 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 23969617 | 23969617 | PRJNA1082072_P_NODE_979_length_343_cov_0.855556_g972_i0 | PRJNA1082072 | 979 | 343 | 0.855556 | 2.93455708 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 407 | 6.0099999999999995e-109 | NTclustered | gi|759083387|gb|KM222018.1| | 200607 | g972 | i0 | 88.047 | 98.9912536443149 | 343 | 41 | 100 | 0 | 1 | 343 | 504 | 162 | Tetmemena pustulata voucher JJM2009041401 alpha-tubulin gene, partial cds | blastn | 33954 | 407 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia pustulata |
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);;