contig_metadata
24 rows where bioproject = "PRJNA1073712", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1462185 | 1462185 | PRJNA1073712_P_NODE_8222_length_280_cov_1.304348_g8139_i0 | PRJNA1073712 | 8222 | 280 | 1.304348 | 3.6521744 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 1.79e-78 | NTclustered | gi|829196136|ref|XM_001025866.3| | 312017 | g8139 | i0 | 87.547 | 0.946428571428571 | 265 | 31 | 94 | 2 | 17 | 280 | 510 | 247 | Tetrahymena thermophila SB210 translationally-controlled tumor-like protein partial mRNA | blastn | 265 | 305 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 2291519 | 2291519 | PRJNA1073712_P_NODE_14742_length_245_cov_0.895349_g14659_i0 | PRJNA1073712 | 14742 | 245 | 0.895349 | 2.19360505 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 403 | 5.299999999999998e-108 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g14659 | i0 | 96.327 | 68.9795918367347 | 245 | 9 | 100 | 0 | 1 | 245 | 214 | 458 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 16900 | 403 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 2738179 | 2738179 | PRJNA1073712_P_NODE_16463_length_242_cov_0.911243_g16380_i0 | PRJNA1073712 | 16463 | 242 | 0.911243 | 2.20520806 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 1.23e-44 | NTclustered | gi|829185314|ref|XM_001031847.2| | 312017 | g16380 | i0 | 92.537 | 0.553719008264463 | 134 | 10 | 55 | 0 | 109 | 242 | 720 | 587 | Tetrahymena thermophila SB210 60S ribosomal protein L7 partial mRNA | blastn | 134 | 193 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 3566803 | 3566803 | PRJNA1073712_P_NODE_4223_length_351_cov_1.158273_g4140_i0 | PRJNA1073712 | 4223 | 351 | 1.158273 | 4.06553823 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 405 | 2.21e-108 | NTclustered | gi|3861467|emb|AJ012585.1| | 5911 | g4140 | i0 | 88.788 | 5.51851851851852 | 330 | 37 | 94 | 0 | 11 | 340 | 3135 | 2806 | Tetrahymena thermophila macronuclear gene encoding ribosomal protein L3, exons 1-2 | blastn | 1937 | 405 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 8669413 | 8669413 | PRJNA1073712_P_NODE_6147_length_309_cov_1.889831_g6064_i0 | PRJNA1073712 | 6147 | 309 | 1.889831 | 5.83957779 | Caryotricha | 500583 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 4.53e-45 | NTclustered | gi|759083508|gb|KM222125.1| | 1004043 | g6064 | i0 | 94.444 | 41.0453074433657 | 126 | 7 | 41 | 0 | 175 | 300 | 1281 | 1156 | Caryotricha minuta voucher LWW07112802 large subunit ribosomal RNA gene, partial sequence | blastn | 12683 | 195 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Kiitrichida | Kiitrichidae | Caryotricha | Caryotricha minuta | ||
| 9944337 | 9944337 | PRJNA1073712_P_NODE_13728_length_246_cov_1.554913_g13645_i0 | PRJNA1073712 | 13728 | 246 | 1.554913 | 3.82508598 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 1.54e-78 | NTclustered | gi|315570322|tpg|BK007923.1| | 5911 | g13645 | i0 | 89.024 | 2.99593495934959 | 246 | 27 | 100 | 0 | 1 | 246 | 183 | 428 | TPA_exp: Tetrahymena thermophila 40S ribosomal protein rpS16e mRNA, complete cds | blastn | 737 | 305 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 11666188 | 11666188 | PRJNA1073712_P_NODE_10570_length_256_cov_1.677596_g10487_i0 | PRJNA1073712 | 10570 | 256 | 1.677596 | 4.29464576 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 98.6 | 1.14e-22 | NR | XP_001017127.3 | 312017 | g10487 | i0 | 80 | 1.40625 | 60 | 10 | 68 | 1 | 69 | 242 | 6 | 65 | XP_001017127.3 40S ribosomal protein S2, putative [Tetrahymena thermophila SB210] | diamond | 360 | 99 | 0.995959595959596 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 11666264 | 11666264 | PRJNA1073712_P_NODE_17030_length_241_cov_0.916667_g16947_i0 | PRJNA1073712 | 17030 | 241 | 0.916667 | 2.20916747 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 3.38e-50 | NTclustered | gi|229594318|ref|XM_001030083.3| | 312017 | g16947 | i0 | 84.404 | 0.904564315352697 | 218 | 31 | 90 | 3 | 4 | 219 | 217 | 1 | Tetrahymena thermophila SB210 40S ribosomal protein S3 partial mRNA | blastn | 218 | 211 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 12941326 | 12941326 | PRJNA1073712_P_NODE_13811_length_246_cov_0.890173_g13728_i0 | PRJNA1073712 | 13811 | 246 | 0.890173 | 2.18982558 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 348 | 2.53e-91 | NTclustered | gi|829153590|ref|XM_001010934.3| | 312017 | g13728 | i0 | 92.245 | 0.995934959349594 | 245 | 19 | 99 | 0 | 1 | 245 | 263 | 19 | Tetrahymena thermophila SB210 transcription factor BTF3a partial mRNA | blastn | 245 | 348 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 16764585 | 16764585 | PRJNA1073712_P_NODE_9814_length_264_cov_1.209424_g9731_i0 | PRJNA1073712 | 9814 | 264 | 1.209424 | 3.19287936 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 6.24e-33 | NR | CAI2387699.1 | 5936 | g9731 | i0 | 81 | 12.6704545454545 | 79 | 15 | 89.8 | 0 | 26 | 262 | 191 | 269 | CAI2387699.1 unnamed protein product [Moneuplotes crassus] | diamond | 3345 | 131 | 0.99236641221374 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 18039323 | 18039323 | PRJNA1073712_P_NODE_7615_length_287_cov_1.014019_g7532_i0 | PRJNA1073712 | 7615 | 287 | 1.014019 | 2.91023453 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 6.7299999999999984e-68 | NTclustered | gi|829194699|ref|XM_001025224.3| | 312017 | g7532 | i0 | 84.962 | 0.926829268292683 | 266 | 40 | 93 | 0 | 15 | 280 | 1 | 266 | Tetrahymena thermophila SB210 S25 ribosomal protein partial mRNA | blastn | 266 | 270 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 19313276 | 19313276 | PRJNA1073712_P_NODE_12836_length_248_cov_0.880000_g12753_i0 | PRJNA1073712 | 12836 | 248 | 0.88 | 2.1824 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 1.23e-64 | NTclustered | gi|118385632|ref|XM_001025944.1| | 312017 | g12753 | i0 | 85.484 | 1 | 248 | 36 | 100 | 0 | 1 | 248 | 666 | 419 | Tetrahymena thermophila SB210 receptor of activated kinase C 1A, component of 40S small ribosomal subunit partial mRNA | blastn | 248 | 259 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 24413452 | 24413452 | PRJNA1073712_P_NODE_11220_length_251_cov_0.865169_g11137_i0 | PRJNA1073712 | 11220 | 251 | 0.865169 | 2.17157419 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 2.6100000000000006e-86 | NTclustered | gi|829164593|ref|XM_972055.3| | 312017 | g11137 | i0 | 90.438 | 1 | 251 | 24 | 100 | 0 | 1 | 251 | 2131 | 2381 | Tetrahymena thermophila SB210 cytoplasmic-like aconitate hydratase partial mRNA | blastn | 251 | 331 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 26814336 | 26814336 | PRJNA1073712_P_NODE_8501_length_277_cov_1.186275_g8418_i0 | PRJNA1073712 | 8501 | 277 | 1.186275 | 3.28598175 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 1.7399999999999997e-35 | NR | XP_001032943.1 | 312017 | g8418 | i0 | 79.3 | 0.888086642599278 | 82 | 17 | 88.8 | 0 | 255 | 10 | 354 | 435 | XP_001032943.1 60S ribosomal export protein NMD3, putative [Tetrahymena thermophila SB210] | diamond | 246 | 137 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 26877817 | 26877817 | PRJNA1073712_P_NODE_12561_length_249_cov_0.875000_g12478_i0 | PRJNA1073712 | 12561 | 249 | 0.875 | 2.17875 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 1.17e-5 | NR | CAG9310866.1 | 1481888 | g12478 | i0 | 47.6 | 0.759036144578313 | 63 | 25 | 75.9 | 1 | 247 | 59 | 143 | 197 | CAG9310866.1 unnamed protein product [Blepharisma stoltei] | diamond | 189 | 52.4 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 27090590 | 27090590 | PRJNA1073712_P_NODE_12422_length_249_cov_0.875000_g12339_i0 | PRJNA1073712 | 12422 | 249 | 0.875 | 2.17875 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 1.51e-36 | NR | CDW82785.1 | 5949 | g12339 | i0 | 72.8 | 6.85542168674699 | 81 | 22 | 97.6 | 0 | 243 | 1 | 21 | 101 | CDW82785.1 40s ribosomal protein [Stylonychia lemnae] | diamond | 1707 | 130 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 29309446 | 29309446 | PRJNA1073712_P_NODE_13089_length_248_cov_0.880000_g13006_i0 | PRJNA1073712 | 13089 | 248 | 0.88 | 2.1824 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 5.26e-41 | NR | XP_001023402.1 | 312017 | g13006 | i0 | 82.7 | 0.979838709677419 | 81 | 14 | 98 | 0 | 247 | 5 | 41 | 121 | XP_001023402.1 ADP-ribosylation factor(Arf)/Arf-like (Arl) small GTPase family protein [Tetrahymena thermophila SB210] | diamond | 243 | 142 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 30130238 | 30130238 | PRJNA1073712_P_NODE_11892_length_250_cov_0.870056_g11809_i0 | PRJNA1073712 | 11892 | 250 | 0.870056 | 2.17514 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 1.72e-5 | NR | CDW71704.1 | 5949 | g11809 | i0 | 36.1 | 0.996 | 83 | 45 | 98.4 | 3 | 247 | 2 | 3043 | 3118 | CDW71704.1 ef hand family protein [Stylonychia lemnae] | diamond | 249 | 52.4 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 31109884 | 31109884 | PRJNA1073712_P_NODE_16315_length_242_cov_0.911243_g16232_i0 | PRJNA1073712 | 16315 | 242 | 0.911243 | 2.20520806 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 1.52e-25 | NR | XP_001017372.1 | 312017 | g16232 | i0 | 83.6 | 0.756198347107438 | 61 | 10 | 75.6 | 0 | 58 | 240 | 22 | 82 | XP_001017372.1 60S ribosomal protein L24 [Tetrahymena thermophila SB210] | diamond | 183 | 102 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 32177151 | 32177151 | PRJNA1073712_P_NODE_16918_length_241_cov_0.916667_g16835_i0 | PRJNA1073712 | 16918 | 241 | 0.916667 | 2.20916747 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 79.7 | 3.26e-15 | NR | XP_001031431.3 | 312017 | g16835 | i0 | 60 | 1.2448132780083 | 50 | 20 | 62.2 | 0 | 215 | 66 | 55 | 104 | XP_001031431.3 hypothetical protein TTHERM_00825630 [Tetrahymena thermophila SB210] | diamond | 300 | 79.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 32650884 | 32650884 | PRJNA1073712_P_NODE_17360_length_226_cov_2.013072_g17277_i0 | PRJNA1073712 | 17360 | 226 | 2.013072 | 4.54954272 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 2.68e-27 | NR | TNV87702.1 | 5974 | g17277 | i0 | 70.3 | 29.853982300885 | 74 | 22 | 98.2 | 0 | 225 | 4 | 684 | 757 | TNV87702.1 hypothetical protein FGO68_gene9476 [Halteria grandinella] | diamond | 6747 | 114 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 32690953 | 32690953 | PRJNA1073712_P_NODE_7740_length_285_cov_1.452830_g7657_i0 | PRJNA1073712 | 7740 | 285 | 1.45283 | 4.1405655 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 133 | 3.22e-35 | NR | KRX06508.1 | 266149 | g7657 | i0 | 66.3 | 1.87368421052632 | 89 | 30 | 93.7 | 0 | 3 | 269 | 85 | 173 | KRX06508.1 ATP:guanido phosphotransferase, N-terminal [Pseudocohnilembus persalinus] | diamond | 534 | 133 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 32722645 | 32722645 | PRJNA1073712_P_NODE_4600_length_341_cov_1.436567_g4517_i0 | PRJNA1073712 | 4600 | 341 | 1.436567 | 4.89869347 | Paramecium sonneborni | 65129 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.00535 | NR | CAD8120202.1 | 65129 | g4517 | i0 | 36.8 | 0.668621700879765 | 76 | 39 | 64.2 | 5 | 276 | 58 | 380 | 449 | CAD8120202.1 unnamed protein product [Paramecium sonneborni] | diamond | 228 | 46.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 32848499 | 32848499 | PRJNA1073712_P_NODE_9480_length_267_cov_1.458763_g9397_i0 | PRJNA1073712 | 9480 | 267 | 1.458763 | 3.89489721 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 153 | 5.15e-43 | NR | KRX06508.1 | 266149 | g9397 | i0 | 85.2 | 3.86516853932584 | 88 | 13 | 98.9 | 0 | 266 | 3 | 280 | 367 | KRX06508.1 ATP:guanido phosphotransferase, N-terminal [Pseudocohnilembus persalinus] | diamond | 1032 | 153 | 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);;