contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA1120771" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15579400 | 15579400 | PRJNA1120771_S_NODE_10773_length_327_cov_5.746479_g10373_i0 | PRJNA1120771 | 10773 | 327 | 5.746479 | 18.79098633 | root | 1 | Root_unresolved | Root_unresolved | 94.4 | 7.46e-22 | NR | NP_049576.1 | 5908 | g10373 | i0 | 85.1 | 90.1743119266055 | 47 | 7 | 43.1 | 0 | 3 | 143 | 97 | 143 | NP_049576.1 NADH dehydrogenase subunit 10 [Tetrahymena pyriformis] | diamond | 29487 | 95.1 | 0.992639327024185 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 26690230 | 26690230 | PRJNA1120771_S_NODE_33041_length_213_cov_2.005882_g32641_i0 | PRJNA1120771 | 33041 | 213 | 2.005882 | 4.27252866 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0131 | NR | OMJ80457.1 | 5963 | g32641 | i0 | 41.1 | 0.788732394366197 | 56 | 32 | 78.9 | 1 | 170 | 3 | 33 | 87 | OMJ80457.1 hypothetical protein SteCoe_19257 [Stentor coeruleus] | diamond | 168 | 43.5 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 26837996 | 26837996 | PRJNA1120771_S_NODE_12221_length_313_cov_2.959259_g11821_i0 | PRJNA1120771 | 12221 | 313 | 2.959259 | 9.26248067 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 1.36e-31 | NR | OMJ80436.1 | 5963 | g11821 | i0 | 56.4 | 1.8019169329073501 | 94 | 41 | 90.1 | 0 | 3 | 284 | 46 | 139 | OMJ80436.1 hypothetical protein SteCoe_19283 [Stentor coeruleus] | diamond | 564 | 118 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 27059383 | 27059383 | PRJNA1120771_S_NODE_31282_length_218_cov_1.468571_g30882_i0 | PRJNA1120771 | 31282 | 218 | 1.468571 | 3.20148478 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 4.84e-16 | NR | CDW79191.1 | 5949 | g30882 | i0 | 49.3 | 1.92660550458716 | 69 | 35 | 95 | 0 | 212 | 6 | 285 | 353 | CDW79191.1 protein kinase 2 [Stylonychia lemnae] | diamond | 420 | 81.6 | 0.996323529411765 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 27291411 | 27291411 | PRJNA1120771_S_NODE_10143_length_334_cov_2.326460_g9743_i0 | PRJNA1120771 | 10143 | 334 | 2.32646 | 7.7703764 | Halteria grandinella | 5974 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 1.61e-19 | NR | TNV87755.1 | 5974 | g9743 | i0 | 57 | 0.772455089820359 | 86 | 37 | 77.2 | 0 | 2 | 259 | 797 | 882 | TNV87755.1 hypothetical protein FGO68_gene17119 [Halteria grandinella] | diamond | 258 | 93.6 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 27544105 | 27544105 | PRJNA1120771_S_NODE_34704_length_209_cov_1.048193_g34304_i0 | PRJNA1120771 | 34704 | 209 | 1.048193 | 2.19072337 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.0069 | NR | KRW98301.1 | 266149 | g34304 | i0 | 33.3 | 0.904306220095694 | 63 | 35 | 90.4 | 2 | 9 | 197 | 314 | 369 | KRW98301.1 Aspartic peptidase domain [Pseudocohnilembus persalinus] | diamond | 189 | 44.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 28985967 | 28985967 | PRJNA1120771_S_NODE_22188_length_251_cov_2.091346_g21788_i0 | PRJNA1120771 | 22188 | 251 | 2.091346 | 5.24927846 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 2.43e-8 | NR | KRX03964.1 | 266149 | g21788 | i0 | 71.8 | 1.31474103585657 | 39 | 11 | 46.6 | 0 | 1 | 117 | 4343 | 4381 | KRX03964.1 P-loop containing nucleoside triphosphate hydrolase [Pseudocohnilembus persalinus] | diamond | 330 | 60.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 29754074 | 29754074 | PRJNA1120771_S_NODE_14051_length_297_cov_4.354331_g13651_i0 | PRJNA1120771 | 14051 | 297 | 4.354331 | 12.93236307 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 8.36e-8 | NR | KRX11001.1 | 266149 | g13651 | i0 | 39.2 | 0.97979797979798 | 97 | 50 | 96 | 2 | 4 | 288 | 58 | 147 | KRX11001.1 hypothetical protein PPERSA_03059 [Pseudocohnilembus persalinus] | diamond | 291 | 59.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 29785712 | 29785712 | PRJNA1120771_S_NODE_10991_length_325_cov_2.035461_g10591_i0 | PRJNA1120771 | 10991 | 325 | 2.035461 | 6.61524825 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 136 | 1.56e-37 | NR | KRX04779.1 | 266149 | g10591 | i0 | 61.6 | 0.913846153846154 | 99 | 37 | 90.5 | 1 | 12 | 305 | 145 | 243 | KRX04779.1 CAP Gly-rich domain [Pseudocohnilembus persalinus] | diamond | 297 | 136 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 29817216 | 29817216 | PRJNA1120771_S_NODE_16951_length_278_cov_2.778723_g16551_i0 | PRJNA1120771 | 16951 | 278 | 2.778723 | 7.72484994 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 84.3 | 2.15e-17 | NR | KRW99552.1 | 266149 | g16551 | i0 | 48.4 | 0.982014388489209 | 91 | 47 | 98.2 | 0 | 277 | 5 | 158 | 248 | KRW99552.1 hypothetical protein PPERSA_01198 [Pseudocohnilembus persalinus] | diamond | 273 | 84.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 29817222 | 29817222 | PRJNA1120771_S_NODE_7891_length_365_cov_2.027950_g7491_i0 | PRJNA1120771 | 7891 | 365 | 2.02795 | 7.4020175 | Paramecium gigas | 2709424 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 0.00237 | NR | YP_010183548.1 | 2709424 | g7491 | i0 | 44.1 | 0.920547945205479 | 59 | 32 | 48.5 | 1 | 263 | 87 | 246 | 303 | YP_010183548.1 Ymf66-like protein [Paramecium gigas] | diamond | 336 | 47.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium gigas | ||
| 29849043 | 29849043 | PRJNA1120771_S_NODE_15391_length_288_cov_2.126531_g14991_i0 | PRJNA1120771 | 15391 | 288 | 2.126531 | 6.12440928 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 3.84e-4 | NR | CAG9317093.1 | 1481888 | g14991 | i0 | 27.9 | 2.61458333333333 | 86 | 61 | 89.6 | 1 | 287 | 30 | 204 | 288 | CAG9317093.1 unnamed protein product [Blepharisma stoltei] | diamond | 753 | 48.9 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 29869815 | 29869815 | PRJNA1120771_S_NODE_12051_length_315_cov_1.599265_g11651_i0 | PRJNA1120771 | 12051 | 315 | 1.599265 | 5.03768475 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 4.53e-11 | NR | XP_001457064.1 | 5888 | g11651 | i0 | 45.5 | 3.27619047619048 | 88 | 48 | 83.8 | 0 | 310 | 47 | 213 | 300 | XP_001457064.1 uncharacterized protein GSPATT00022840001 [Paramecium tetraurelia] | diamond | 1032 | 68.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 30070028 | 30070028 | PRJNA1120771_S_NODE_11092_length_324_cov_2.167260_g10692_i0 | PRJNA1120771 | 11092 | 324 | 2.16726 | 7.0219224 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 8.57e-26 | NR | CAI2383594.1 | 5936 | g10692 | i0 | 62 | 3.18518518518519 | 79 | 29 | 73.1 | 1 | 296 | 60 | 84 | 161 | CAI2383594.1 unnamed protein product [Moneuplotes crassus] | diamond | 1032 | 104 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 30544061 | 30544061 | PRJNA1120771_S_NODE_17333_length_276_cov_1.493562_g16933_i0 | PRJNA1120771 | 17333 | 276 | 1.493562 | 4.12223112 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 8.26e-8 | NR | XP_004024159.1 | 5932 | g16933 | i0 | 48.1 | 0.565217391304348 | 52 | 27 | 56.5 | 0 | 1 | 156 | 482 | 533 | XP_004024159.1 hypothetical protein IMG5_199550 [Ichthyophthirius multifiliis] | diamond | 156 | 59.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 30701963 | 30701963 | PRJNA1120771_S_NODE_9314_length_344_cov_3.571429_g8914_i0 | PRJNA1120771 | 9314 | 344 | 3.571429 | 12.28571576 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 7.42e-5 | NR | CAG9317662.1 | 1481888 | g8914 | i0 | 54.3 | 0.401162790697674 | 46 | 21 | 40.1 | 0 | 327 | 190 | 227 | 272 | CAG9317662.1 unnamed protein product [Blepharisma stoltei] | diamond | 138 | 51.6 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 30849227 | 30849227 | PRJNA1120771_S_NODE_27094_length_231_cov_1.851064_g26694_i0 | PRJNA1120771 | 27094 | 231 | 1.851064 | 4.27595784 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 5.45e-5 | NR | KAL4464655.1 | 5901 | g26694 | i0 | 35.4 | 3.27272727272727 | 65 | 42 | 84.4 | 0 | 211 | 17 | 92 | 156 | KAL4464655.1 hypothetical protein ABPG74_011216 [Tetrahymena malaccensis] | diamond | 756 | 50.8 | 0.992125984251969 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 30975768 | 30975768 | PRJNA1120771_S_NODE_23874_length_244_cov_1.298507_g23474_i0 | PRJNA1120771 | 23874 | 244 | 1.298507 | 3.16835708 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 91.3 | 4e-20 | NR | XP_001448522.1 | 5888 | g23474 | i0 | 74.2 | 4.00819672131148 | 62 | 16 | 76.2 | 0 | 232 | 47 | 199 | 260 | XP_001448522.1 uncharacterized protein GSPATT00039432001 [Paramecium tetraurelia] | diamond | 978 | 91.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 31007231 | 31007231 | PRJNA1120771_S_NODE_9254_length_345_cov_2.016556_g8854_i0 | PRJNA1120771 | 9254 | 345 | 2.016556 | 6.9571182 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 79.7 | 1.41e-15 | NR | XP_001009414.2 | 312017 | g8854 | i0 | 43.2 | 6.50434782608696 | 95 | 54 | 82.6 | 0 | 343 | 59 | 119 | 213 | XP_001009414.2 50S ribosomal protein L1P [Tetrahymena thermophila SB210] | diamond | 2244 | 79.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 31018027 | 31018027 | PRJNA1120771_S_NODE_13955_length_298_cov_2.388235_g13555_i0 | PRJNA1120771 | 13955 | 298 | 2.388235 | 7.1169403 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 86.7 | 2.77e-17 | NR | KRX07411.1 | 266149 | g13555 | i0 | 53.1 | 0.815436241610738 | 81 | 38 | 81.5 | 0 | 291 | 49 | 888 | 968 | KRX07411.1 P-loop containing nucleoside triphosphate hydrolase [Pseudocohnilembus persalinus] | diamond | 243 | 86.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 31049858 | 31049858 | PRJNA1120771_S_NODE_25635_length_237_cov_1.345361_g25235_i0 | PRJNA1120771 | 25635 | 237 | 1.345361 | 3.18850557 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 67.8 | 5.26e-11 | NR | CAG9329529.1 | 1481888 | g25235 | i0 | 46.1 | 4.83544303797468 | 76 | 41 | 96.2 | 0 | 228 | 1 | 74 | 149 | CAG9329529.1 unnamed protein product [Blepharisma stoltei] | diamond | 1146 | 67.8 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 31428887 | 31428887 | PRJNA1120771_S_NODE_30796_length_219_cov_2.840909_g30396_i0 | PRJNA1120771 | 30796 | 219 | 2.840909 | 6.22159071 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.0255 | NR | CDW80593.1 | 5949 | g30396 | i0 | 52.6 | 1.02739726027397 | 38 | 17 | 52.1 | 1 | 187 | 74 | 233 | 269 | CDW80593.1 UNKNOWN [Stylonychia lemnae] | diamond | 225 | 42.7 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 31555709 | 31555709 | PRJNA1120771_S_NODE_34136_length_210_cov_2.532934_g33736_i0 | PRJNA1120771 | 34136 | 210 | 2.532934 | 5.3191614 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 4.88e-5 | NR | XP_001026650.1 | 312017 | g33736 | i0 | 38 | 1.41428571428571 | 50 | 31 | 71.4 | 0 | 209 | 60 | 45 | 94 | XP_001026650.1 40S ribosomal protein S10, putative [Tetrahymena thermophila SB210] | diamond | 297 | 49.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 31587271 | 31587271 | PRJNA1120771_S_NODE_26316_length_234_cov_1.821990_g25916_i0 | PRJNA1120771 | 26316 | 234 | 1.82199 | 4.2634566 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 2.06e-6 | NR | KRX09304.1 | 266149 | g25916 | i0 | 35.5 | 1.43589743589744 | 62 | 38 | 76.9 | 1 | 7 | 186 | 194 | 255 | KRX09304.1 Thioredoxin-like fold [Pseudocohnilembus persalinus] | diamond | 336 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 31650128 | 31650128 | PRJNA1120771_S_NODE_18637_length_268_cov_3.475556_g18237_i0 | PRJNA1120771 | 18637 | 268 | 3.475556 | 9.31449008 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 6.55e-10 | NR | KRX01081.1 | 266149 | g18237 | i0 | 49.3 | 0.772388059701492 | 69 | 35 | 77.2 | 0 | 264 | 58 | 53 | 121 | KRX01081.1 hypothetical protein PPERSA_02177 [Pseudocohnilembus persalinus] | diamond | 207 | 62.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 32346626 | 32346626 | PRJNA1120771_S_NODE_10439_length_331_cov_1.506944_g10039_i0 | PRJNA1120771 | 10439 | 331 | 1.506944 | 4.98798464 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 1.5e-13 | NR | CAG9314398.1 | 1481888 | g10039 | i0 | 38.5 | 0.870090634441088 | 96 | 54 | 86.1 | 2 | 3 | 287 | 150 | 241 | CAG9314398.1 unnamed protein product [Blepharisma stoltei] | diamond | 288 | 74.7 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei |
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);;