contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA436017" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3640033 | 3640033 | PRJNA436017_P_NODE_13503_length_228_cov_1.429319_g13205_i0 | PRJNA436017 | 13503 | 228 | 1.429319 | 3.25884732 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 71.2 | 9.14e-13 | NR | CAG9310866.1 | 1481888 | g13205 | i0 | 53.9 | 2 | 76 | 26 | 100 | 1 | 1 | 228 | 126 | 192 | CAG9310866.1 unnamed protein product [Blepharisma stoltei] | diamond | 456 | 71.2 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 8741992 | 8741992 | PRJNA436017_P_NODE_5967_length_367_cov_2.127273_g5671_i0 | PRJNA436017 | 5967 | 367 | 2.127273 | 7.80709191 | Tetmemena sp. Y1 | 1640447 | SAR_Eukaryotes | SAR_Eukaryotes | 185 | 6.72e-53 | NR | ASQ41026.1 | 1640447 | g5671 | i0 | 73.6 | 2.96730245231608 | 121 | 32 | 98.9 | 0 | 365 | 3 | 426 | 546 | ASQ41026.1 heat shock protein 70, partial [Tetmemena sp. Y1] | diamond | 1089 | 185 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Tetmemena | Tetmemena sp. Y1 | ||
| 11909518 | 11909518 | PRJNA436017_P_NODE_18590_length_190_cov_1.267974_g18292_i0 | PRJNA436017 | 18590 | 190 | 1.267974 | 2.4091506 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 2.59e-24 | NR | CAG9319666.1 | 1481888 | g18292 | i0 | 77.6 | 7.67368421052632 | 58 | 13 | 91.6 | 0 | 15 | 188 | 46 | 103 | CAG9319666.1 unnamed protein product [Blepharisma stoltei] | diamond | 1458 | 99 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 15733530 | 15733530 | PRJNA436017_P_NODE_28673_length_152_cov_1.695652_g28375_i0 | PRJNA436017 | 28673 | 152 | 1.695652 | 2.57739104 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 1.63e-14 | NR | CDW79386.1 | 5949 | g28375 | i0 | 76 | 1.97368421052632 | 50 | 11 | 98.7 | 1 | 2 | 151 | 908 | 956 | CDW79386.1 related to ssf1-nucleolar protein involved in the assembly of the large ribosomal subunit [Stylonychia lemnae] | diamond | 300 | 77 | 0.990909090909091 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 26791096 | 26791096 | PRJNA436017_P_NODE_10421_length_267_cov_1.121739_g10123_i0 | PRJNA436017 | 10421 | 267 | 1.121739 | 2.99504313 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 6.18e-6 | NR | CDW86772.1 | 5949 | g10123 | i0 | 39.3 | 1 | 89 | 45 | 97.8 | 4 | 1 | 261 | 29 | 110 | CDW86772.1 UNKNOWN [Stylonychia lemnae] | diamond | 267 | 52.4 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 26822830 | 26822830 | PRJNA436017_P_NODE_26981_length_157_cov_1.300000_g26683_i0 | PRJNA436017 | 26981 | 157 | 1.3 | 2.041 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 78.6 | 2.61e-15 | NR | XP_004030363.1 | 5932 | g26683 | i0 | 66.7 | 0.974522292993631 | 51 | 17 | 97.5 | 0 | 3 | 155 | 390 | 440 | XP_004030363.1 hypothetical protein IMG5_162300 [Ichthyophthirius multifiliis] | diamond | 153 | 78.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 26839354 | 26839354 | PRJNA436017_P_NODE_11781_length_248_cov_1.611374_g11483_i0 | PRJNA436017 | 11781 | 248 | 1.611374 | 3.99620752 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 1.39e-27 | NR | OMJ89868.1 | 5963 | g11483 | i0 | 67.1 | 36.6774193548387 | 82 | 27 | 99.2 | 0 | 246 | 1 | 430 | 511 | OMJ89868.1 hypothetical protein SteCoe_7852 [Stentor coeruleus] | diamond | 9096 | 116 | 0.991379310344828 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 26839359 | 26839359 | PRJNA436017_P_NODE_27341_length_156_cov_1.310924_g27043_i0 | PRJNA436017 | 27341 | 156 | 1.310924 | 2.04504144 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 3.53e-10 | NR | CAD8132732.1 | 43138 | g27043 | i0 | 55.6 | 5.03846153846154 | 54 | 21 | 98.1 | 1 | 153 | 1 | 67 | 120 | CAD8132732.1 unnamed protein product [Paramecium pentaurelia] | diamond | 786 | 63.5 | 0.995275590551181 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium pentaurelia | ||
| 26917642 | 26917642 | PRJNA436017_P_NODE_18982_length_188_cov_1.264901_g18684_i0 | PRJNA436017 | 18982 | 188 | 1.264901 | 2.37801388 | Halteria grandinella | 5974 | SAR_Eukaryotes | SAR_Eukaryotes | 54.3 | 1.46e-6 | NR | TNV78145.1 | 5974 | g18684 | i0 | 41.1 | 0.893617021276596 | 56 | 33 | 89.4 | 0 | 188 | 21 | 71 | 126 | TNV78145.1 hypothetical protein FGO68_gene15947 [Halteria grandinella] | diamond | 168 | 54.3 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 26980874 | 26980874 | PRJNA436017_P_NODE_24562_length_165_cov_0.890625_g24264_i0 | PRJNA436017 | 24562 | 165 | 0.890625 | 1.46953125 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 9.21e-17 | NR | XP_001019547.3 | 312017 | g24264 | i0 | 72.5 | 0.927272727272727 | 51 | 14 | 92.7 | 0 | 153 | 1 | 23 | 73 | XP_001019547.3 papain family cysteine protease [Tetrahymena thermophila SB210] | diamond | 153 | 82.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 27518214 | 27518214 | PRJNA436017_P_NODE_14143_length_222_cov_1.216216_g13845_i0 | PRJNA436017 | 14143 | 222 | 1.216216 | 2.69999952 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 2.45e-14 | NR | CAI2370622.1 | 5936 | g13845 | i0 | 48.6 | 1 | 74 | 37 | 100 | 1 | 1 | 222 | 223 | 295 | CAI2370622.1 unnamed protein product [Moneuplotes crassus] | diamond | 222 | 76.3 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 27534658 | 27534658 | PRJNA436017_P_NODE_20043_length_182_cov_3.482759_g19745_i0 | PRJNA436017 | 20043 | 182 | 3.482759 | 6.33862138 | Tetrahymenidae | 291294 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00101 | NR | XP_004030209.1 | 5932 | g19745 | i0 | 55.3 | 4.02197802197802 | 47 | 15 | 77.5 | 1 | 40 | 180 | 1 | 41 | XP_004030209.1 hypothetical protein IMG5_165690 [Ichthyophthirius multifiliis] | diamond | 732 | 45.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 28402277 | 28402277 | PRJNA436017_P_NODE_18786_length_189_cov_1.282895_g18488_i0 | PRJNA436017 | 18786 | 189 | 1.282895 | 2.42467155 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 58.2 | 1.52e-8 | NR | XP_004037566.1 | 5932 | g18488 | i0 | 51.7 | 0.952380952380952 | 60 | 28 | 93.7 | 1 | 3 | 179 | 6 | 65 | XP_004037566.1 transcription factor btf3, putative [Ichthyophthirius multifiliis] | diamond | 180 | 58.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 28844145 | 28844145 | PRJNA436017_P_NODE_2688_length_573_cov_2.800373_g2425_i0 | PRJNA436017 | 2688 | 573 | 2.800373 | 16.04613729 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 1.43e-24 | NR | CDW83682.1 | 5949 | g2425 | i0 | 51.5 | 0.518324607329843 | 99 | 47 | 51.8 | 1 | 22 | 318 | 1 | 98 | CDW83682.1 60s ribosomal protein [Stylonychia lemnae] | diamond | 297 | 104 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 28892100 | 28892100 | PRJNA436017_P_NODE_20328_length_181_cov_1.625000_g20030_i0 | PRJNA436017 | 20328 | 181 | 1.625 | 2.94125 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 91.7 | 7.31e-20 | NR | ADU54553.1 | 5885 | g20030 | i0 | 79.7 | 28.3259668508287 | 59 | 12 | 97.8 | 0 | 3 | 179 | 362 | 420 | ADU54553.1 cytosol-type hsp70 3, partial [Paramecium caudatum] | diamond | 5127 | 91.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium caudatum | ||
| 29286238 | 29286238 | PRJNA436017_P_NODE_28549_length_153_cov_1.008621_g28251_i0 | PRJNA436017 | 28549 | 153 | 1.008621 | 1.54319013 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 6.42e-4 | NR | XP_001007780.1 | 312017 | g28251 | i0 | 43.8 | 1.96078431372549 | 48 | 26 | 92.2 | 1 | 152 | 12 | 234 | 281 | XP_001007780.1 DNA replication licensing factor MCM4 [Tetrahymena thermophila SB210] | diamond | 300 | 46.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 29570385 | 29570385 | PRJNA436017_P_NODE_16010_length_206_cov_1.751479_g15712_i0 | PRJNA436017 | 16010 | 206 | 1.751479 | 3.60804674 | Paramecium sonneborni | 65129 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 5.33e-11 | NR | CAD8127098.1 | 65129 | g15712 | i0 | 52.2 | 0.975728155339806 | 67 | 32 | 97.6 | 0 | 205 | 5 | 70 | 136 | CAD8127098.1 unnamed protein product [Paramecium sonneborni] | diamond | 201 | 64.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 29871159 | 29871159 | PRJNA436017_P_NODE_20911_length_179_cov_1.098592_g20613_i0 | PRJNA436017 | 20911 | 179 | 1.098592 | 1.96647968 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 9.54e-26 | NR | XP_001013149.2 | 312017 | g20613 | i0 | 76.3 | 1.97765363128492 | 59 | 14 | 98.9 | 0 | 2 | 178 | 198 | 256 | XP_001013149.2 thioredoxin-dependent peroxide reductase [Tetrahymena thermophila SB210] | diamond | 354 | 104 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 29981106 | 29981106 | PRJNA436017_P_NODE_27691_length_155_cov_1.406780_g27393_i0 | PRJNA436017 | 27691 | 155 | 1.40678 | 2.180509 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 6.61e-7 | NR | CAG9328718.1 | 1481888 | g27393 | i0 | 47.1 | 0.987096774193548 | 51 | 26 | 96.8 | 1 | 155 | 6 | 71 | 121 | CAG9328718.1 unnamed protein product [Blepharisma stoltei] | diamond | 153 | 53.1 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 30075711 | 30075711 | PRJNA436017_P_NODE_21032_length_178_cov_1.936170_g20734_i0 | PRJNA436017 | 21032 | 178 | 1.93617 | 3.4463826 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 1.23e-9 | NR | XP_004034584.1 | 5932 | g20734 | i0 | 51.9 | 1.82022471910112 | 54 | 26 | 91 | 0 | 15 | 176 | 1 | 54 | XP_004034584.1 hypothetical protein IMG5_118230 [Ichthyophthirius multifiliis] | diamond | 324 | 62 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 30423767 | 30423767 | PRJNA436017_P_NODE_7273_length_330_cov_1.583618_g6976_i0 | PRJNA436017 | 7273 | 330 | 1.583618 | 5.2259394 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 90.9 | 8.36e-20 | NR | CAD8181559.1 | 43137 | g6976 | i0 | 44.1 | 1.00909090909091 | 111 | 56 | 99.1 | 2 | 330 | 4 | 17 | 123 | CAD8181559.1 unnamed protein product [Paramecium octaurelia] | diamond | 333 | 90.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 31008548 | 31008548 | PRJNA436017_P_NODE_11294_length_254_cov_2.156682_g10996_i0 | PRJNA436017 | 11294 | 254 | 2.156682 | 5.47797228 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 5.279999999999999e-28 | NR | CAI2383002.1 | 5936 | g10996 | i0 | 62.7 | 3.92125984251969 | 83 | 31 | 98 | 0 | 6 | 254 | 57 | 139 | CAI2383002.1 unnamed protein product [Moneuplotes crassus] | diamond | 996 | 108 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 32888288 | 32888288 | PRJNA436017_P_NODE_17840_length_194_cov_1.560510_g17542_i0 | PRJNA436017 | 17840 | 194 | 1.56051 | 3.0273894 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 77.4 | 1.01e-14 | NR | XP_001017488.2 | 312017 | g17542 | i0 | 65.6 | 0.943298969072165 | 61 | 21 | 94.3 | 0 | 187 | 5 | 183 | 243 | XP_001017488.2 60S ribosomal protein L4 [Tetrahymena thermophila SB210] | diamond | 183 | 77.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila |
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);;