contig_metadata
13 rows where bioproject = "PRJNA1093380" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3569771 | 3569771 | PRJNA1093380_P_NODE_15083_length_245_cov_0.895349_g14977_i0 | PRJNA1093380 | 15083 | 245 | 0.895349 | 2.19360505 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 2.46e-34 | NR | XP_001026209.2 | 312017 | g14977 | i0 | 69.1 | 5.95102040816327 | 81 | 25 | 99.2 | 0 | 1 | 243 | 22 | 102 | XP_001026209.2 casein kinase II beta chain, putative [Tetrahymena thermophila SB210] | diamond | 1458 | 127 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 11677781 | 11677781 | PRJNA1093380_P_NODE_2530_length_368_cov_1.542373_g2424_i0 | PRJNA1093380 | 2530 | 368 | 1.542373 | 5.67593264 | Isotricha intestinalis | 47897 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 3.23e-57 | NTclustered | gi|92790151|emb|AJ965261.1| | 47897 | g2424 | i0 | 85.841 | 63.0815217391304 | 226 | 26 | 61 | 6 | 145 | 368 | 915 | 694 | Isotricha intestinalis partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene) | blastn | 23214 | 235 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Vestibuliferida | Isotrichidae | Isotricha | Isotricha intestinalis | ||
| 12952894 | 12952894 | PRJNA1093380_P_NODE_17811_length_228_cov_3.561290_g17705_i0 | PRJNA1093380 | 17811 | 228 | 3.56129 | 8.1197412 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 5.08e-78 | NTclustered | gi|158347525|gb|EU047814.1| | 151077 | g17705 | i0 | 91.071 | 97.5833333333333 | 224 | 20 | 98 | 0 | 2 | 225 | 16 | 239 | Chilodonella uncinata clone Shared_P1 beta-tubulin gene, partial cds; macronuclear | blastn | 22249 | 303 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 25245570 | 25245570 | PRJNA1093380_P_NODE_1500_length_453_cov_2.810526_g1395_i0 | PRJNA1093380 | 1500 | 453 | 2.810526 | 12.73168278 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 407 | 8.129999999999999e-109 | NTclustered | gi|161734|gb|L01415.1|TETBTUBUA | 5911 | g1395 | i0 | 83.002 | 95.9911699779249 | 453 | 73 | 99 | 4 | 3 | 453 | 950 | 1400 | Tetrahymena thermophila beta-tubulin (BTU1) gene, complete cds | blastn | 43484 | 407 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 26655856 | 26655856 | PRJNA1093380_P_NODE_8621_length_270_cov_1.248731_g8515_i0 | PRJNA1093380 | 8621 | 270 | 1.248731 | 3.3715737 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 79 | 9.6e-15 | NR | KRX10060.1 | 266149 | g8515 | i0 | 47.1 | 0.966666666666667 | 87 | 46 | 96.7 | 0 | 268 | 8 | 1383 | 1469 | KRX10060.1 P-loop containing nucleoside triphosphate hydrolase [Pseudocohnilembus persalinus] | diamond | 261 | 79 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 27004215 | 27004215 | PRJNA1093380_P_NODE_16922_length_241_cov_0.916667_g16816_i0 | PRJNA1093380 | 16922 | 241 | 0.916667 | 2.20916747 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 1.71e-37 | NR | AIE77207.1 | 151077 | g16816 | i0 | 81 | 0.983402489626556 | 79 | 15 | 98.3 | 0 | 3 | 239 | 39 | 117 | AIE77207.1 protein kinase domain containing protein, partial [Chilodonella uncinata] | diamond | 237 | 135 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 27825830 | 27825830 | PRJNA1093380_P_NODE_8424_length_271_cov_1.252525_g8318_i0 | PRJNA1093380 | 8424 | 271 | 1.252525 | 3.39434275 | Halteria grandinella | 5974 | SAR_Eukaryotes | SAR_Eukaryotes | 91.3 | 3.07e-19 | NR | TNV78929.1 | 5974 | g8318 | i0 | 47.8 | 0.996309963099631 | 90 | 43 | 99.6 | 1 | 270 | 1 | 285 | 370 | TNV78929.1 hypothetical protein FGO68_gene5820 [Halteria grandinella] | diamond | 270 | 91.3 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 28299264 | 28299264 | PRJNA1093380_P_NODE_7686_length_275_cov_1.351485_g7580_i0 | PRJNA1093380 | 7686 | 275 | 1.351485 | 3.71658375 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 78.6 | 1.65e-16 | NR | XP_004025094.1 | 5932 | g7580 | i0 | 55.3 | 3.24 | 76 | 34 | 82.9 | 0 | 253 | 26 | 1 | 76 | XP_004025094.1 hypothetical protein IMG5_192460 [Ichthyophthirius multifiliis] | diamond | 891 | 78.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 28836029 | 28836029 | PRJNA1093380_P_NODE_3428_length_331_cov_0.883721_g3322_i0 | PRJNA1093380 | 3428 | 331 | 0.883721 | 2.92511651 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 79.3 | 7.31e-15 | NR | KRX10699.1 | 266149 | g3322 | i0 | 43.6 | 0.996978851963746 | 110 | 57 | 97 | 3 | 6 | 326 | 32 | 139 | KRX10699.1 hypothetical protein PPERSA_08694 [Pseudocohnilembus persalinus] | diamond | 330 | 79.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 29972806 | 29972806 | PRJNA1093380_P_NODE_5691_length_287_cov_1.429907_g5585_i0 | PRJNA1093380 | 5691 | 287 | 1.429907 | 4.10383309 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 9.22e-37 | NR | XP_001441123.1 | 5888 | g5585 | i0 | 63.5 | 1.98606271777003 | 96 | 34 | 99.3 | 1 | 286 | 2 | 376 | 471 | XP_001441123.1 uncharacterized protein GSPATT00009998001 [Paramecium tetraurelia] | diamond | 570 | 141 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 30099039 | 30099039 | PRJNA1093380_P_NODE_17672_length_231_cov_3.835443_g17566_i0 | PRJNA1093380 | 17672 | 231 | 3.835443 | 8.85987333 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 90.5 | 1.58e-19 | NR | XP_001030010.2 | 312017 | g17566 | i0 | 57.1 | 3 | 77 | 33 | 100 | 0 | 231 | 1 | 35 | 111 | XP_001030010.2 casein kinase [Tetrahymena thermophila SB210] | diamond | 693 | 90.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 30690788 | 30690788 | PRJNA1093380_P_NODE_10113_length_261_cov_1.638298_g10007_i0 | PRJNA1093380 | 10113 | 261 | 1.638298 | 4.27595778 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 84.3 | 1.88e-17 | NR | CDW87254.1 | 5949 | g10007 | i0 | 48.8 | 13.7011494252874 | 84 | 42 | 96.6 | 1 | 254 | 3 | 14 | 96 | CDW87254.1 40s ribosomal protein s6 [Stylonychia lemnae] | diamond | 3576 | 84.3 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 32113853 | 32113853 | PRJNA1093380_P_NODE_17038_length_241_cov_0.916667_g16932_i0 | PRJNA1093380 | 17038 | 241 | 0.916667 | 2.20916747 | Tetrahymenidae | 291294 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 3.98e-11 | NR | XP_004030812.1 | 5932 | g16932 | i0 | 39.7 | 2.80082987551867 | 73 | 42 | 88.4 | 1 | 240 | 28 | 283 | 355 | XP_004030812.1 TRM1 tRNA methyltransferase 1, putative [Ichthyophthirius multifiliis] | diamond | 675 | 68.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis |
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);;