contig_metadata
17 rows where bioproject = "PRJEB12296" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23937991 | 23937991 | PRJEB12296_P_NODE_819_length_162_cov_1.180451_g806_i0 | PRJEB12296 | 819 | 162 | 1.180451 | 1.91233062 | Sterkiella | 94288 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 1.32e-17 | NTclustered | gi|331686195|gb|HQ432921.1| | 94289 | g806 | i0 | 90.789 | 1.30864197530864 | 76 | 7 | 47 | 0 | 65 | 140 | 1472 | 1397 | Sterkiella histriomuscorum strain BA elongation factor-1 (ef-1) gene, complete cds; macronuclear | blastn | 212 | 102 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 25500798 | 25500798 | PRJEB12296_S_NODE_5113_length_210_cov_2.040000_g5081_i0 | PRJEB12296 | 5113 | 210 | 2.04 | 4.284 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 372 | 1.25e-98 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g5081 | i0 | 98.571 | 92.647619047619 | 210 | 3 | 100 | 0 | 1 | 210 | 2113 | 2322 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 19456 | 372 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 25606848 | 25606848 | PRJEB12296_S_NODE_2809_length_262_cov_4172.722467_g2777_i0 | PRJEB12296 | 2809 | 262 | 4172.722467 | 10932.53286354 | root | 1 | Root_unresolved | Root_unresolved | 322 | 1.65e-83 | NTclustered | gi|10832|emb|X54512.1| | 5911 | g2777 | i0 | 94.737 | 77.8664122137405 | 209 | 8 | 79 | 3 | 1 | 206 | 8116 | 8324 | T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA | blastn | 20401 | 322 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 25743073 | 25743073 | PRJEB12296_S_NODE_18578_length_150_cov_1.391304_g18546_i0 | PRJEB12296 | 18578 | 150 | 1.391304 | 2.086956 | root | 1 | Root_unresolved | Root_unresolved | 272 | 8.609999999999998e-69 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g18546 | i0 | 99.333 | 8 | 150 | 1 | 100 | 0 | 1 | 150 | 4076 | 3927 | Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 1200 | 272 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 25878833 | 25878833 | PRJEB12296_S_NODE_347_length_505_cov_45.802128_g320_i0 | PRJEB12296 | 347 | 505 | 45.802128 | 231.3007464 | Sessilida | 1974272 | SAR_Eukaryotes | SAR_Eukaryotes | 778 | 0 | NTclustered | gi|2304601486|gb|OP458307.1| | 2582953 | g320 | i0 | 97.174 | 82.6891089108911 | 460 | 13 | 91 | 0 | 1 | 460 | 460 | 1 | Opercularia sp. ZhW-2019a large subunit ribosomal RNA gene, partial sequence | blastn | 41758 | 780 | 0.997435897435897 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Operculariidae | Opercularia | Opercularia sp. ZhW-2019a | ||
| 26015245 | 26015245 | PRJEB12296_S_NODE_9020_length_177_cov_9.394366_g8988_i0 | PRJEB12296 | 9020 | 177 | 9.394366 | 16.62802782 | Sessilida | 1974272 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 4.799999999999999e-82 | NTclustered | gi|1251948964|gb|KY675197.1| | 155147 | g8988 | i0 | 98.87 | 99.954802259887 | 177 | 2 | 100 | 0 | 1 | 177 | 1376 | 1200 | Epistylis chrysemydis large subunit ribosomal RNA gene, partial sequence | blastn | 17692 | 316 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Epistylidae | Epistylis | Epistylis chrysemydis | ||
| 26045149 | 26045149 | PRJEB12296_S_NODE_7549_length_186_cov_1.324503_g7517_i0 | PRJEB12296 | 7549 | 186 | 1.324503 | 2.46357558 | Trithigmostoma cucullulus | 1346499 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 6.61e-81 | NTclustered | gi|759083539|gb|KM222156.1| | 1346499 | g7517 | i0 | 97.79 | 66.0967741935484 | 181 | 4 | 97 | 0 | 6 | 186 | 1366 | 1186 | Trithigmostoma cucullulus voucher CXM08110902 large subunit ribosomal RNA gene, partial sequence | blastn | 12294 | 313 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Trithigmostoma | Trithigmostoma cucullulus | ||
| 26181280 | 26181280 | PRJEB12296_S_NODE_630_length_419_cov_61.565104_g600_i0 | PRJEB12296 | 630 | 419 | 61.565104 | 257.95778576 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 521 | 2.56e-143 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g600 | i0 | 93.696 | 47.653937947494 | 349 | 20 | 83 | 2 | 41 | 388 | 15 | 362 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 19967 | 521 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 26423199 | 26423199 | PRJEB12296_S_NODE_7367_length_187_cov_6.980263_g7335_i0 | PRJEB12296 | 7367 | 187 | 6.980263 | 13.05309181 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 5.36e-52 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g7335 | i0 | 87.766 | 66.8021390374332 | 188 | 19 | 100 | 3 | 1 | 187 | 2381 | 2565 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 12492 | 217 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 26559195 | 26559195 | PRJEB12296_S_NODE_1928_length_298_cov_4248.292776_g1896_i0 | PRJEB12296 | 1928 | 298 | 4248.292776 | 12659.91247248 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 3.91e-120 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g1896 | i0 | 98.795 | 74.0234899328859 | 249 | 3 | 84 | 0 | 36 | 284 | 2719 | 2967 | Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 22059 | 444 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 26559235 | 26559235 | PRJEB12296_S_NODE_5240_length_208_cov_6.358382_g5208_i0 | PRJEB12296 | 5240 | 208 | 6.358382 | 13.22543456 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 7.409999999999998e-96 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g5208 | i0 | 98.077 | 83.9855769230769 | 208 | 4 | 100 | 0 | 1 | 208 | 2367 | 2574 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 17469 | 363 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 32925110 | 32925110 | PRJEB12296_S_NODE_12985_length_163_cov_3.164062_g12953_i0 | PRJEB12296 | 12985 | 163 | 3.164062 | 5.15742106 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 75.1 | 1.23e-14 | NR | CDW79704.1 | 5949 | g12953 | i0 | 60.4 | 1.95092024539877 | 53 | 21 | 97.5 | 0 | 163 | 5 | 188 | 240 | CDW79704.1 60s ribosomal protein l7 [Stylonychia lemnae] | diamond | 318 | 75.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 33024903 | 33024903 | PRJEB12296_S_NODE_13852_length_161_cov_1.587302_g13820_i0 | PRJEB12296 | 13852 | 161 | 1.587302 | 2.55555622 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.00546 | NR | CAD8161077.1 | 43137 | g13820 | i0 | 50 | 1.93788819875776 | 52 | 26 | 96.9 | 0 | 1 | 156 | 63 | 114 | CAD8161077.1 unnamed protein product [Paramecium octaurelia] | diamond | 312 | 42.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 33044751 | 33044751 | PRJEB12296_S_NODE_5165_length_209_cov_3.419540_g5133_i0 | PRJEB12296 | 5165 | 209 | 3.41954 | 7.1468386 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 9.88e-14 | NR | CAG9313846.1 | 1481888 | g5133 | i0 | 63 | 0.77511961722488 | 54 | 20 | 77.5 | 0 | 1 | 162 | 68 | 121 | CAG9313846.1 unnamed protein product [Blepharisma stoltei] | diamond | 162 | 70.9 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 33061747 | 33061747 | PRJEB12296_S_NODE_16773_length_154_cov_2.336134_g16741_i0 | PRJEB12296 | 16773 | 154 | 2.336134 | 3.59764636 | Paramecium pentaurelia | 43138 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 3.75e-7 | NR | CAD8150344.1 | 43138 | g16741 | i0 | 68.3 | 2.3961038961039 | 41 | 13 | 79.9 | 0 | 154 | 32 | 95 | 135 | CAD8150344.1 unnamed protein product [Paramecium pentaurelia] | diamond | 369 | 53.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium pentaurelia | ||
| 33164114 | 33164114 | PRJEB12296_S_NODE_4984_length_212_cov_2.412429_g4952_i0 | PRJEB12296 | 4984 | 212 | 2.412429 | 5.11434948 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 6.44e-9 | NR | 2XZN_5 | 5911 | g4952 | i0 | 65.3 | 0.693396226415094 | 49 | 16 | 67.9 | 1 | 10 | 153 | 66 | 114 | 2XZN_5 Chain 5, Ribosomal Protein S26e Containing Protein [Tetrahymena thermophila] | diamond | 147 | 58.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 33178471 | 33178471 | PRJEB12296_S_NODE_5488_length_205_cov_1.923529_g5456_i0 | PRJEB12296 | 5488 | 205 | 1.923529 | 3.94323445 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 7.29e-10 | NR | XP_001009414.2 | 312017 | g5456 | i0 | 51.7 | 2.54634146341463 | 58 | 28 | 84.9 | 0 | 204 | 31 | 156 | 213 | XP_001009414.2 50S ribosomal protein L1P [Tetrahymena thermophila SB210] | diamond | 522 | 62.8 | 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);;