contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA801875" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7179421 | 7179421 | PRJNA801875_P_NODE_746_length_492_cov_2.065646_g644_i0 | PRJNA801875 | 746 | 492 | 2.065646 | 10.16297832 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 3.98e-38 | NR | KRX10107.1 | 266149 | g644 | i0 | 57.9 | 0.695121951219512 | 114 | 41 | 65.2 | 1 | 476 | 156 | 219 | 332 | KRX10107.1 hypothetical protein PPERSA_08510 [Pseudocohnilembus persalinus] | diamond | 342 | 143 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 11004994 | 11004994 | PRJNA801875_P_NODE_3729_length_170_cov_0.925926_g3626_i0 | PRJNA801875 | 3729 | 170 | 0.925926 | 1.5740742 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 1.28e-21 | NR | CAD8087129.1 | 5886 | g3626 | i0 | 78.2 | 12.6176470588235 | 55 | 12 | 97.1 | 0 | 166 | 2 | 173 | 227 | CAD8087129.1 unnamed protein product [Paramecium primaurelia] | diamond | 2145 | 94 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 17379484 | 17379484 | PRJNA801875_P_NODE_4654_length_152_cov_1.008547_g4551_i0 | PRJNA801875 | 4654 | 152 | 1.008547 | 1.53299144 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 97.8 | 3.5700000000000003e-22 | NR | CDW86777.1 | 5949 | g4551 | i0 | 96 | 203.230263157895 | 50 | 2 | 98.7 | 0 | 1 | 150 | 77 | 126 | CDW86777.1 UNKNOWN [Stylonychia lemnae] | diamond | 30891 | 98.6 | 0.991886409736308 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 18652523 | 18652523 | PRJNA801875_P_NODE_1395_length_332_cov_1.952862_g1292_i0 | PRJNA801875 | 1395 | 332 | 1.952862 | 6.48350184 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 2.08e-24 | NR | XP_001015941.1 | 312017 | g1292 | i0 | 79.3 | 1.04819277108434 | 58 | 12 | 52.4 | 0 | 5 | 178 | 261 | 318 | XP_001015941.1 papain family cysteine protease [Tetrahymena thermophila SB210] | diamond | 348 | 104 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 20348114 | 20348114 | PRJNA801875_P_NODE_3356_length_180_cov_1.089655_g3253_i0 | PRJNA801875 | 3356 | 180 | 1.089655 | 1.961379 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 90.9 | 3.61e-20 | NR | CAD8046192.1 | 5886 | g3253 | i0 | 78.9 | 6.58333333333333 | 57 | 12 | 95 | 0 | 176 | 6 | 120 | 176 | CAD8046192.1 unnamed protein product [Paramecium primaurelia] | diamond | 1185 | 90.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 23753755 | 23753755 | PRJNA801875_P_NODE_3279_length_182_cov_1.591837_g3176_i0 | PRJNA801875 | 3279 | 182 | 1.591837 | 2.89714334 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 2.14e-24 | NR | XP_004031065.1 | 5932 | g3176 | i0 | 78 | 0.972527472527473 | 59 | 13 | 97.3 | 0 | 179 | 3 | 193 | 251 | XP_004031065.1 hypothetical protein IMG5_148130 [Ichthyophthirius multifiliis] | diamond | 177 | 103 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 26683070 | 26683070 | PRJNA801875_P_NODE_1561_length_306_cov_2.007380_g1458_i0 | PRJNA801875 | 1561 | 306 | 2.00738 | 6.1425828 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 2.23e-6 | NR | XP_001439300.1 | 5888 | g1458 | i0 | 42.9 | 1.23529411764706 | 63 | 36 | 61.8 | 0 | 200 | 12 | 32 | 94 | XP_001439300.1 uncharacterized protein GSPATT00008382001 [Paramecium tetraurelia] | diamond | 378 | 55.8 | 0.99462365591397806 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 27189356 | 27189356 | PRJNA801875_P_NODE_2422_length_223_cov_1.781915_g2319_i0 | PRJNA801875 | 2422 | 223 | 1.781915 | 3.97367045 | Tetrahymenidae | 291294 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 2.04e-25 | NR | Q04634.1 | 5908 | g2319 | i0 | 71.4 | 5.73094170403587 | 70 | 20 | 94.2 | 0 | 4 | 213 | 115 | 184 | Q04634.1 RecName: Full=Elongation factor 1-alpha; Short=EF-1-alpha; AltName: Full=14 nm filament-associated protein [Tetrahymena pyriformis] | diamond | 1278 | 107 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 27600339 | 27600339 | PRJNA801875_P_NODE_1004_length_412_cov_9.864721_g901_i0 | PRJNA801875 | 1004 | 412 | 9.864721 | 40.64265052 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 4.41e-11 | NR | OMJ68295.1 | 5963 | g901 | i0 | 41.3 | 4.25242718446602 | 104 | 54 | 72.1 | 3 | 311 | 15 | 28 | 129 | OMJ68295.1 hypothetical protein SteCoe_34296 [Stentor coeruleus] | diamond | 1752 | 71.2 | 0.990168539325843 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 27812499 | 27812499 | PRJNA801875_P_NODE_2804_length_201_cov_2.843373_g2701_i0 | PRJNA801875 | 2804 | 201 | 2.843373 | 5.71517973 | Euplotes octocarinatus | 2716877 | SAR_Eukaryotes | SAR_Eukaryotes | 73.9 | 2.11e-13 | NR | AGJ81126.1 | 2716877 | g2701 | i0 | 56.3 | 0.955223880597015 | 64 | 26 | 95.5 | 1 | 8 | 199 | 338 | 399 | AGJ81126.1 elongation factor 2 [Euplotes octocarinatus] | diamond | 192 | 73.9 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes octocarinatus | ||
| 28190952 | 28190952 | PRJNA801875_P_NODE_3766_length_169_cov_1.149254_g3663_i0 | PRJNA801875 | 3766 | 169 | 1.149254 | 1.94223926 | Paramecium primaurelia | 5886 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 6.56e-11 | NR | CAD8069664.1 | 5886 | g3663 | i0 | 55.4 | 3.9585798816568 | 56 | 25 | 99.4 | 0 | 169 | 2 | 59 | 114 | CAD8069664.1 unnamed protein product [Paramecium primaurelia] | diamond | 669 | 64.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 28443929 | 28443929 | PRJNA801875_P_NODE_4166_length_160_cov_1.640000_g4063_i0 | PRJNA801875 | 4166 | 160 | 1.64 | 2.624 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 2.52e-14 | NR | XP_004023838.1 | 5932 | g4063 | i0 | 77.8 | 1.65 | 45 | 7 | 78.8 | 1 | 6 | 131 | 24 | 68 | XP_004023838.1 ribosomal protein, putative [Ichthyophthirius multifiliis] | diamond | 264 | 70.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 28736829 | 28736829 | PRJNA801875_P_NODE_2507_length_217_cov_1.489011_g2404_i0 | PRJNA801875 | 2507 | 217 | 1.489011 | 3.23115387 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 84 | 3.53e-17 | NR | CAD8070579.1 | 5886 | g2404 | i0 | 61.8 | 8.46082949308756 | 68 | 26 | 94 | 0 | 209 | 6 | 163 | 230 | CAD8070579.1 unnamed protein product [Paramecium primaurelia] | diamond | 1836 | 84 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 29075422 | 29075422 | PRJNA801875_P_NODE_1848_length_274_cov_1.301255_g1745_i0 | PRJNA801875 | 1848 | 274 | 1.301255 | 3.5654387 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 64.3 | 3.16e-11 | NR | OMJ65575.1 | 5963 | g1745 | i0 | 53.7 | 1.76277372262774 | 41 | 19 | 44.9 | 0 | 273 | 151 | 41 | 81 | OMJ65575.1 hypothetical protein SteCoe_37970 [Stentor coeruleus] | diamond | 483 | 64.3 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 29170107 | 29170107 | PRJNA801875_P_NODE_2849_length_199_cov_1.012195_g2746_i0 | PRJNA801875 | 2849 | 199 | 1.012195 | 2.01426805 | Tetrahymena malaccensis | 5901 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 1.24e-11 | NR | KAL4441129.1 | 5901 | g2746 | i0 | 53.2 | 0.934673366834171 | 62 | 24 | 93.5 | 3 | 4 | 189 | 2868 | 2924 | KAL4441129.1 hypothetical protein ABPG74_002079 [Tetrahymena malaccensis] | diamond | 186 | 68.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 29706293 | 29706293 | PRJNA801875_P_NODE_3890_length_166_cov_1.458015_g3787_i0 | PRJNA801875 | 3890 | 166 | 1.458015 | 2.4203049 | Paramecium primaurelia | 5886 | SAR_Eukaryotes | SAR_Eukaryotes | 74.3 | 1.13e-14 | NR | CAD8043385.1 | 5886 | g3787 | i0 | 63 | 0.975903614457831 | 54 | 20 | 97.6 | 0 | 1 | 162 | 101 | 154 | CAD8043385.1 unnamed protein product [Paramecium primaurelia] | diamond | 162 | 74.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 29738032 | 29738032 | PRJNA801875_P_NODE_2950_length_195_cov_1.187500_g2847_i0 | PRJNA801875 | 2950 | 195 | 1.1875 | 2.315625 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 4.41e-12 | NR | KRX09932.1 | 266149 | g2847 | i0 | 59.6 | 0.8 | 52 | 21 | 80 | 0 | 32 | 187 | 818 | 869 | KRX09932.1 Ribonuclease H-like domain [Pseudocohnilembus persalinus] | diamond | 156 | 70.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 30180445 | 30180445 | PRJNA801875_P_NODE_4552_length_153_cov_1.627119_g4449_i0 | PRJNA801875 | 4552 | 153 | 1.627119 | 2.48949207 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 3.39e-13 | NR | XP_001015607.1 | 312017 | g4449 | i0 | 76.9 | 0.764705882352941 | 39 | 9 | 76.5 | 0 | 153 | 37 | 56 | 94 | XP_001015607.1 60S ribosomal protein L37a [Tetrahymena thermophila SB210] | diamond | 117 | 68.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 30275595 | 30275595 | PRJNA801875_P_NODE_4172_length_160_cov_1.456000_g4069_i0 | PRJNA801875 | 4172 | 160 | 1.456 | 2.3296 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 1.47e-7 | NR | CAI2363787.1 | 5936 | g4069 | i0 | 61.9 | 0.7875 | 42 | 16 | 78.8 | 0 | 146 | 21 | 111 | 152 | CAI2363787.1 unnamed protein product [Moneuplotes crassus] | diamond | 126 | 56.6 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 30749264 | 30749264 | PRJNA801875_P_NODE_1734_length_285_cov_10.596000_g1631_i0 | PRJNA801875 | 1734 | 285 | 10.596 | 30.1986 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 65.5 | 1.4e-11 | NR | XP_012651983.1 | 312017 | g1631 | i0 | 50.7 | 0.747368421052632 | 71 | 35 | 74.7 | 0 | 280 | 68 | 15 | 85 | XP_012651983.1 hypothetical protein TTHERM_000784569 [Tetrahymena thermophila SB210] | diamond | 213 | 65.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 31706543 | 31706543 | PRJNA801875_P_NODE_4277_length_158_cov_1.601626_g4174_i0 | PRJNA801875 | 4277 | 158 | 1.601626 | 2.53056908 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 89.4 | 1.26e-20 | NR | 4V8P_CO | 5911 | g4174 | i0 | 84.6 | 2.94303797468354 | 52 | 8 | 98.7 | 0 | 1 | 156 | 67 | 118 | 4V8P_CO Chain CO, RPL19 [Tetrahymena thermophila] | diamond | 465 | 89.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 31855735 | 31855735 | PRJNA801875_P_NODE_2597_length_211_cov_1.340909_g2494_i0 | PRJNA801875 | 2597 | 211 | 1.340909 | 2.82931799 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 65.5 | 2.42e-10 | NR | XP_001008760.1 | 312017 | g2494 | i0 | 55.7 | 0.995260663507109 | 70 | 29 | 96.7 | 1 | 207 | 4 | 380 | 449 | XP_001008760.1 fibronectin-binding protein A, amine-terminal protein [Tetrahymena thermophila SB210] | diamond | 210 | 65.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 31887353 | 31887353 | PRJNA801875_P_NODE_1677_length_292_cov_1.428016_g1574_i0 | PRJNA801875 | 1677 | 292 | 1.428016 | 4.16980672 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 85.1 | 9.23e-18 | NR | CDW90887.1 | 5949 | g1574 | i0 | 50.6 | 1.71575342465753 | 83 | 34 | 78.1 | 1 | 292 | 65 | 32 | 114 | CDW90887.1 rna binding protein [Stylonychia lemnae] | diamond | 501 | 85.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 32393739 | 32393739 | PRJNA801875_P_NODE_3959_length_165_cov_0.907692_g3856_i0 | PRJNA801875 | 3959 | 165 | 0.907692 | 1.4976918 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 75.9 | 2.63e-14 | NR | KRX07136.1 | 266149 | g3856 | i0 | 61.5 | 0.945454545454545 | 52 | 20 | 94.5 | 0 | 9 | 164 | 118 | 169 | KRX07136.1 hypothetical protein PPERSA_09350 [Pseudocohnilembus persalinus] | diamond | 156 | 75.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus |
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);;