contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA944406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3475101 | 3475101 | PRJNA944406_P_NODE_25723_length_286_cov_1.375587_g24764_i0 | PRJNA944406 | 25723 | 286 | 1.375587 | 3.93417882 | root | 1 | Root_unresolved | Root_unresolved | 149 | 5.169999999999999e-42 | NR | AAK20731.1 | 5888 | g24764 | i0 | 78.7 | 14.7272727272727 | 94 | 20 | 98.6 | 0 | 5 | 286 | 127 | 220 | AAK20731.1 glyceraldehyde-3-phosphate dehydrogenase, partial [Paramecium tetraurelia] | diamond | 4212 | 149 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 25150427 | 25150427 | PRJNA944406_P_NODE_11600_length_368_cov_1.305085_g10641_i0 | PRJNA944406 | 11600 | 368 | 1.305085 | 4.8027128 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 166 | 6.65e-50 | NR | XP_001449603.1 | 5888 | g10641 | i0 | 63.9 | 13.9402173913043 | 122 | 44 | 99.5 | 0 | 1 | 366 | 16 | 137 | XP_001449603.1 uncharacterized protein GSPATT00002335001 [Paramecium tetraurelia] | diamond | 5130 | 166 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 26651936 | 26651936 | PRJNA944406_P_NODE_77581_length_248_cov_0.880000_g76622_i0 | PRJNA944406 | 77581 | 248 | 0.88 | 2.1824 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 1.4e-12 | NR | CAD8053474.1 | 5886 | g76622 | i0 | 43.8 | 1.93548387096774 | 80 | 45 | 96.8 | 0 | 8 | 247 | 358 | 437 | CAD8053474.1 unnamed protein product [Paramecium primaurelia] | diamond | 480 | 72.8 | 0.994505494505495 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 26961888 | 26961888 | PRJNA944406_P_NODE_67422_length_250_cov_1.548023_g66463_i0 | PRJNA944406 | 67422 | 250 | 1.548023 | 3.8700575 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 1.89e-12 | NR | CDW88910.1 | 5949 | g66463 | i0 | 59.1 | 0.792 | 66 | 24 | 79.2 | 1 | 1 | 198 | 22 | 84 | CDW88910.1 60s acidic ribosomal protein p1 [Stylonychia lemnae] | diamond | 198 | 68.2 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 27625767 | 27625767 | PRJNA944406_P_NODE_59864_length_254_cov_1.419890_g58905_i0 | PRJNA944406 | 59864 | 254 | 1.41989 | 3.6065206 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 9.16e-11 | NR | OMJ84036.1 | 5963 | g58905 | i0 | 47.8 | 0.791338582677165 | 67 | 30 | 79.1 | 1 | 37 | 237 | 1508 | 1569 | OMJ84036.1 hypothetical protein SteCoe_14905 [Stentor coeruleus] | diamond | 201 | 67.4 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 28351786 | 28351786 | PRJNA944406_P_NODE_71366_length_249_cov_1.750000_g70407_i0 | PRJNA944406 | 71366 | 249 | 1.75 | 4.3575 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 155 | 3.28e-46 | NR | CAG9318382.1 | 1481888 | g70407 | i0 | 82.9 | 0.987951807228916 | 82 | 14 | 98.8 | 0 | 3 | 248 | 47 | 128 | CAG9318382.1 unnamed protein product [Blepharisma stoltei] | diamond | 246 | 155 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 28415095 | 28415095 | PRJNA944406_P_NODE_51386_length_262_cov_1.343915_g50427_i0 | PRJNA944406 | 51386 | 262 | 1.343915 | 3.5210573 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 1.08e-7 | NR | CAD8191261.1 | 43137 | g50427 | i0 | 35.6 | 0.99618320610687 | 87 | 54 | 99.6 | 1 | 1 | 261 | 201 | 285 | CAD8191261.1 unnamed protein product [Paramecium octaurelia] | diamond | 261 | 58.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 28478180 | 28478180 | PRJNA944406_P_NODE_95626_length_244_cov_0.900585_g94667_i0 | PRJNA944406 | 95626 | 244 | 0.900585 | 2.1974274 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 2.56e-4 | NR | CAI2387722.1 | 5936 | g94667 | i0 | 35.1 | 0.94672131147541 | 77 | 50 | 94.7 | 0 | 235 | 5 | 613 | 689 | CAI2387722.1 unnamed protein product [Moneuplotes crassus] | diamond | 231 | 48.9 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 28642903 | 28642903 | PRJNA944406_P_NODE_103807_length_242_cov_0.911243_g102848_i0 | PRJNA944406 | 103807 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 91.7 | 1.92e-19 | NR | XP_004035000.1 | 5932 | g102848 | i0 | 56.4 | 5.86363636363636 | 78 | 33 | 96.7 | 1 | 236 | 3 | 13 | 89 | XP_004035000.1 hypothetical protein IMG5_107330 [Ichthyophthirius multifiliis] | diamond | 1419 | 91.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 29109702 | 29109702 | PRJNA944406_P_NODE_37048_length_275_cov_1.524752_g36089_i0 | PRJNA944406 | 37048 | 275 | 1.524752 | 4.193068 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 86.3 | 2.76e-17 | NR | CDW83720.1 | 5949 | g36089 | i0 | 62.1 | 0.632727272727273 | 58 | 22 | 63.3 | 0 | 100 | 273 | 233 | 290 | CDW83720.1 UNKNOWN [Stylonychia lemnae] | diamond | 174 | 86.3 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 29772483 | 29772483 | PRJNA944406_P_NODE_86191_length_246_cov_0.890173_g85232_i0 | PRJNA944406 | 86191 | 246 | 0.890173 | 2.18982558 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 3.64e-7 | NR | CAG9331673.1 | 1481888 | g85232 | i0 | 35.2 | 0.865853658536585 | 71 | 46 | 86.6 | 0 | 242 | 30 | 793 | 863 | CAG9331673.1 unnamed protein product [Blepharisma stoltei] | diamond | 213 | 57 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 29993866 | 29993866 | PRJNA944406_P_NODE_65451_length_251_cov_0.865169_g64492_i0 | PRJNA944406 | 65451 | 251 | 0.865169 | 2.17157419 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.00174 | NR | OMJ93405.1 | 5963 | g64492 | i0 | 33.3 | 1.51792828685259 | 60 | 35 | 65.7 | 1 | 85 | 249 | 102 | 161 | OMJ93405.1 hypothetical protein SteCoe_3648 [Stentor coeruleus] | diamond | 381 | 46.6 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 30530735 | 30530735 | PRJNA944406_P_NODE_26593_length_285_cov_1.452830_g25634_i0 | PRJNA944406 | 26593 | 285 | 1.45283 | 4.1405655 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 2.3e-39 | NR | AGA16550.1 | 153251 | g25634 | i0 | 68.8 | 0.978947368421053 | 93 | 29 | 97.9 | 0 | 283 | 5 | 162 | 254 | AGA16550.1 ADP/ATP carrier [Cryptocaryon irritans] | diamond | 279 | 142 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 30562218 | 30562218 | PRJNA944406_P_NODE_90913_length_245_cov_0.895349_g89954_i0 | PRJNA944406 | 90913 | 245 | 0.895349 | 2.19360505 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 1.48e-14 | NR | XP_001012276.1 | 312017 | g89954 | i0 | 46.8 | 0.96734693877551 | 79 | 42 | 96.7 | 0 | 245 | 9 | 62 | 140 | XP_001012276.1 hypothetical protein TTHERM_00105260 [Tetrahymena thermophila SB210] | diamond | 237 | 77.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 30593884 | 30593884 | PRJNA944406_P_NODE_100453_length_243_cov_0.905882_g99494_i0 | PRJNA944406 | 100453 | 243 | 0.905882 | 2.20129326 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 6.44e-4 | NR | KRX07487.1 | 266149 | g99494 | i0 | 28.7 | 6.44444444444444 | 87 | 47 | 92.6 | 5 | 238 | 14 | 1039 | 1122 | KRX07487.1 Insulin-like growth factor binding protein, N-terminal [Pseudocohnilembus persalinus] | diamond | 1566 | 47.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 30663979 | 30663979 | PRJNA944406_P_NODE_91553_length_245_cov_0.895349_g90594_i0 | PRJNA944406 | 91553 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 84 | 9.55e-17 | NR | CAI2370190.1 | 5936 | g90594 | i0 | 68.9 | 2.73061224489796 | 61 | 19 | 74.7 | 0 | 186 | 4 | 340 | 400 | CAI2370190.1 unnamed protein product [Moneuplotes crassus] | diamond | 669 | 84.3 | 0.99644128113879 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 30815218 | 30815218 | PRJNA944406_P_NODE_90354_length_245_cov_0.895349_g89395_i0 | PRJNA944406 | 90354 | 245 | 0.895349 | 2.19360505 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 2.1e-18 | NR | CDW82456.1 | 5949 | g89395 | i0 | 49.4 | 0.991836734693878 | 81 | 41 | 99.2 | 0 | 2 | 244 | 273 | 353 | CDW82456.1 guanylate-binding n-terminal domain containing protein [Stylonychia lemnae] | diamond | 243 | 89 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 31036665 | 31036665 | PRJNA944406_P_NODE_13615_length_345_cov_1.132353_g12656_i0 | PRJNA944406 | 13615 | 345 | 1.132353 | 3.90661785 | Paramecium sonneborni | 65129 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0423 | NR | CAD8117217.1 | 65129 | g12656 | i0 | 27 | 0.773913043478261 | 89 | 50 | 75.7 | 2 | 339 | 79 | 25 | 100 | CAD8117217.1 unnamed protein product [Paramecium sonneborni] | diamond | 267 | 43.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 31200680 | 31200680 | PRJNA944406_P_NODE_109315_length_241_cov_0.916667_g108356_i0 | PRJNA944406 | 109315 | 241 | 0.916667 | 2.20916747 | root | 1 | Root_unresolved | Root_unresolved | 48.9 | 2.4e-4 | NR | XP_004039001.1 | 5932 | g108356 | i0 | 46 | 2.68879668049793 | 63 | 30 | 78.4 | 2 | 207 | 19 | 117 | 175 | XP_004039001.1 scp-like extracellular, putative [Ichthyophthirius multifiliis] | diamond | 648 | 48.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 31225868 | 31225868 | PRJNA944406_P_NODE_83555_length_247_cov_0.885057_g82596_i0 | PRJNA944406 | 83555 | 247 | 0.885057 | 2.18609079 | Paramecium pentaurelia | 43138 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00598 | NR | CAD8201809.1 | 43138 | g82596 | i0 | 36.5 | 5.69635627530364 | 74 | 45 | 88.7 | 2 | 222 | 4 | 422 | 494 | CAD8201809.1 unnamed protein product [Paramecium pentaurelia] | diamond | 1407 | 45.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium pentaurelia | ||
| 31549301 | 31549301 | PRJNA944406_P_NODE_105036_length_242_cov_0.911243_g104077_i0 | PRJNA944406 | 105036 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0274 | NR | CDW90197.1 | 5949 | g104077 | i0 | 46 | 3.44628099173554 | 50 | 26 | 60.7 | 1 | 149 | 3 | 641 | 690 | CDW90197.1 ef hand domain containing protein [Stylonychia lemnae] | diamond | 834 | 43.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 31928577 | 31928577 | PRJNA944406_P_NODE_89597_length_245_cov_0.895349_g88638_i0 | PRJNA944406 | 89597 | 245 | 0.895349 | 2.19360505 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 1.1500000000000002e-27 | NR | CAD8060455.1 | 5886 | g88638 | i0 | 63 | 4.97142857142857 | 81 | 30 | 99.2 | 0 | 245 | 3 | 178 | 258 | CAD8060455.1 unnamed protein product [Paramecium primaurelia] | diamond | 1218 | 112 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 32181869 | 32181869 | PRJNA944406_P_NODE_82778_length_247_cov_0.885057_g81819_i0 | PRJNA944406 | 82778 | 247 | 0.885057 | 2.18609079 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 47 | 7.76e-4 | NR | CAD8208077.1 | 43138 | g81819 | i0 | 36.4 | 2.34412955465587 | 99 | 46 | 99.6 | 3 | 246 | 1 | 56 | 154 | CAD8208077.1 unnamed protein product [Paramecium pentaurelia] | diamond | 579 | 47 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium pentaurelia | ||
| 32491544 | 32491544 | PRJNA944406_P_NODE_108779_length_241_cov_0.916667_g107820_i0 | PRJNA944406 | 108779 | 241 | 0.916667 | 2.20916747 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 41.2 | 0.0373 | NR | XP_004032405.1 | 5932 | g107820 | i0 | 37.5 | 0.597510373443983 | 48 | 30 | 59.8 | 0 | 148 | 5 | 38 | 85 | XP_004032405.1 hypothetical protein IMG5_122900 [Ichthyophthirius multifiliis] | diamond | 144 | 41.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 32523313 | 32523313 | PRJNA944406_P_NODE_64459_length_251_cov_0.865169_g63500_i0 | PRJNA944406 | 64459 | 251 | 0.865169 | 2.17157419 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 2.28e-13 | NR | XP_001442604.1 | 5888 | g63500 | i0 | 49.4 | 0.920318725099602 | 77 | 39 | 92 | 0 | 16 | 246 | 3 | 79 | XP_001442604.1 uncharacterized protein GSPATT00001410001 [Paramecium tetraurelia] | diamond | 231 | 74.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia |
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);;