contig_metadata
24 rows where bioproject = "PRJEB25583", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 986432 | 986432 | PRJEB25583_P_NODE_5121_length_181_cov_73.486111_g4944_i0 | PRJEB25583 | 5121 | 181 | 73.486111 | 133.00986091 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 3.82e-83 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g4944 | i0 | 99.432 | 95.5635359116022 | 176 | 1 | 97 | 0 | 6 | 181 | 3129 | 2954 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 17297 | 320 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 1297196 | 1297196 | PRJEB25583_P_NODE_3702_length_210_cov_3.497110_g3525_i0 | PRJEB25583 | 3702 | 210 | 3.49711 | 7.343931 | Pseudovorticella sp. 1 LZ54 | 2042499 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 1.8e-17 | NTclustered | gi|1251948967|gb|KY675200.1| | 2042499 | g3525 | i0 | 91.781 | 34.9714285714286 | 73 | 6 | 35 | 0 | 138 | 210 | 229 | 301 | Pseudovorticella sp. 1 LZ54 large subunit ribosomal RNA gene, partial sequence | blastn | 7344 | 102 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Pseudovorticella | Pseudovorticella sp. 1 LZ54 | ||
| 1297210 | 1297210 | PRJEB25583_P_NODE_5942_length_170_cov_4.308271_g5765_i0 | PRJEB25583 | 5942 | 170 | 4.308271 | 7.3240607 | Lamtostyla gui | 2678605 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 6.16e-51 | NTclustered | gi|1778223994|gb|MN733822.1| | 2678605 | g5765 | i0 | 90.625 | 73.3 | 160 | 15 | 94 | 0 | 4 | 163 | 4953 | 4794 | Lamtostyla gui isolate LWY2015111409 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 12461 | 213 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Stichotrichida | Amphisiellidae | Lamtostyla | Lamtostyla gui | ||
| 2572853 | 2572853 | PRJEB25583_P_NODE_1603_length_338_cov_24.458472_g1426_i0 | PRJEB25583 | 1603 | 338 | 24.458472 | 82.66963536 | Uronema marinum | 35107 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 6.12e-84 | NTclustered | gi|111035919|emb|AJ781304.1| | 35107 | g1426 | i0 | 85.806 | 91.896449704142 | 310 | 39 | 91 | 5 | 21 | 326 | 51 | 359 | Uronema marinum partial 23S rRNA gene, strain CCAP 1686/1 | blastn | 31061 | 324 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Uronematidae | Uronema | Uronema marinum | ||
| 4814274 | 4814274 | PRJEB25583_P_NODE_5544_length_175_cov_4.362319_g5367_i0 | PRJEB25583 | 5544 | 175 | 4.362319 | 7.63405825 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 3.71e-73 | NTclustered | gi|651208247|gb|KJ028501.1| | 2814637 | g5367 | i0 | 100 | 88.6171428571429 | 155 | 0 | 89 | 0 | 1 | 155 | 237 | 83 | Tetrahymena frigidoflumine clone 20149-1 18S small subunit ribosomal RNA gene, partial sequence; macronuclear | blastn | 15508 | 287 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena frigidoflumine | ||
| 5125374 | 5125374 | PRJEB25583_P_NODE_2125_length_284_cov_8.364372_g1948_i0 | PRJEB25583 | 2125 | 284 | 8.364372 | 23.75481648 | Tetrahymena chironomi | 3034767 | SAR_Eukaryotes | SAR_Eukaryotes | 460 | 3.68e-125 | NTclustered | gi|2459327221|gb|OQ626840.1| | 3034767 | g1948 | i0 | 95.848 | 91.9683098591549 | 289 | 4 | 99 | 2 | 1 | 281 | 538 | 826 | Tetrahymena chironomi isolate LLH20220320 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 26119 | 460 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena chironomi | ||
| 7364106 | 7364106 | PRJEB25583_P_NODE_2026_length_293_cov_29.234375_g1849_i0 | PRJEB25583 | 2026 | 293 | 29.234375 | 85.65671875 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 529 | 1.0299999999999996e-145 | NTclustered | gi|363412163|gb|JN120237.1| | 1126580 | g1849 | i0 | 100 | 97.6075085324232 | 286 | 0 | 98 | 0 | 8 | 293 | 1256 | 1541 | Vorticella similis isolate 991130906vorspp 18S ribosomal RNA gene, partial sequence | blastn | 28599 | 529 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella similis | ||
| 8639533 | 8639533 | PRJEB25583_P_NODE_6127_length_168_cov_2.038168_g5950_i0 | PRJEB25583 | 6127 | 168 | 2.038168 | 3.42412224 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 2.79e-64 | NTclustered | gi|840836|emb|X65149.1| | 40328 | g5950 | i0 | 95.625 | 96.4821428571429 | 160 | 7 | 95 | 0 | 9 | 168 | 6 | 165 | O.georgiana 17S ribosomal DNA | blastn | 16209 | 257 | 1 | Eukaryota | Sar | Ciliophora | Nassophorea | Nassulida | Nassulidae | Obertrumia | Obertrumia georgiana | ||
| 8949982 | 8949982 | PRJEB25583_P_NODE_3308_length_222_cov_3.508108_g3131_i0 | PRJEB25583 | 3308 | 222 | 3.508108 | 7.78799976 | Pleuronema marinum | 31280 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 5.03e-63 | NTclustered | gi|402491|gb|M98047.1|PUIRR28S | 31280 | g3131 | i0 | 94.41 | 57.6081081081081 | 161 | 9 | 73 | 0 | 4 | 164 | 359 | 199 | Pleuronema marinum 28S ribosomal RNA (28S rRNA) fragment | blastn | 12789 | 254 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Pleuronematidae | Pleuronema | Pleuronema marinum | ||
| 10225743 | 10225743 | PRJEB25583_P_NODE_3389_length_219_cov_283.802198_g3212_i0 | PRJEB25583 | 3389 | 219 | 283.802198 | 621.52681362 | uncultured Peniculida | 765896 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 4.9800000000000006e-58 | NTclustered | gi|1354561752|gb|MH023121.1| | 765896 | g3212 | i0 | 97.143 | 65.3059360730594 | 140 | 4 | 64 | 0 | 60 | 199 | 167 | 28 | Uncultured Peniculida clone OTU739 small subunit ribosomal RNA gene, partial sequence | blastn | 14302 | 237 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | uncultured Peniculida | ||||
| 10225760 | 10225760 | PRJEB25583_P_NODE_5389_length_177_cov_3.185714_g5212_i0 | PRJEB25583 | 5389 | 177 | 3.185714 | 5.63871378 | Philasterides dicentrarchi | 282688 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 3.0799999999999998e-34 | NTclustered | gi|49616744|gb|AY643504.1| | 282688 | g5212 | i0 | 85.35 | 6.86440677966102 | 157 | 17 | 86 | 6 | 24 | 176 | 275 | 121 | Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence | blastn | 1215 | 158 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 11501029 | 11501029 | PRJEB25583_P_NODE_7670_length_155_cov_1.271186_g7493_i0 | PRJEB25583 | 7670 | 155 | 1.271186 | 1.9703383 | Philasterides dicentrarchi | 282688 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 7.62e-5 | NTclustered | gi|1583998227|gb|MH444694.1| | 282688 | g7493 | i0 | 97.143 | 0.225806451612903 | 35 | 1 | 23 | 0 | 121 | 155 | 1347 | 1313 | Philasterides dicentrarchi I1 alpha-tubulin 1 mRNA, complete cds | blastn | 35 | 60.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 15325140 | 15325140 | PRJEB25583_P_NODE_3253_length_224_cov_4.754011_g3076_i0 | PRJEB25583 | 3253 | 224 | 4.754011 | 10.64898464 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 5.229999999999998e-43 | NTclustered | gi|1004125725|gb|KU761582.1| | 153251 | g3076 | i0 | 83.412 | 66.3883928571429 | 211 | 25 | 92 | 9 | 19 | 224 | 6845 | 7050 | Cryptocaryon irritans isolate ND1410 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence | blastn | 14871 | 187 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 15325145 | 15325145 | PRJEB25583_P_NODE_3693_length_210_cov_14.838150_g3516_i0 | PRJEB25583 | 3693 | 210 | 14.83815 | 31.160115 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 2.11e-86 | NTclustered | gi|1083263100|gb|KX982500.1| | 5963 | g3516 | i0 | 98.404 | 54.0476190476191 | 188 | 3 | 90 | 0 | 22 | 209 | 2239 | 2426 | Stentor coeruleus strain MSU large subunit ribosomal RNA gene, partial sequence | blastn | 11350 | 331 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 16289114 | 16289114 | PRJEB25583_P_NODE_3173_length_226_cov_57.941799_g2996_i0 | PRJEB25583 | 3173 | 226 | 57.941799 | 130.94846574 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 8.36e-81 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g2996 | i0 | 100 | 78.287610619469 | 169 | 0 | 75 | 0 | 1 | 169 | 2954 | 3122 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 17693 | 313 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 17874585 | 17874585 | PRJEB25583_P_NODE_3075_length_231_cov_3.494845_g2898_i0 | PRJEB25583 | 3075 | 231 | 3.494845 | 8.07309195 | Mesodinium pulex | 283647 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 8.45e-91 | NTclustered | gi|359744455|gb|JN412740.1| | 283647 | g2898 | i0 | 94.619 | 67.8658008658009 | 223 | 12 | 97 | 0 | 1 | 223 | 2113 | 1891 | Mesodinium pulex strain HHJ 18S small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer and 5.8S ribosomal RNA gene, complete sequence; and 28S large subunit ribosomal RNA gene, partial sequence | blastn | 15677 | 346 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Cyclotrichida | Mesodiniidae | Mesodinium | Mesodinium pulex | ||
| 19148489 | 19148489 | PRJEB25583_P_NODE_756_length_561_cov_46.272901_g587_i0 | PRJEB25583 | 756 | 561 | 46.272901 | 259.59097461 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 743 | 0 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g587 | i0 | 97.902 | 73.445632798574 | 429 | 9 | 76 | 0 | 101 | 529 | 1419 | 991 | Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 41203 | 743 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 20423683 | 20423683 | PRJEB25583_P_NODE_3137_length_228_cov_20.418848_g2960_i0 | PRJEB25583 | 3137 | 228 | 20.418848 | 46.55497344 | Cyclidium glaucoma | 35100 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 2.909999999999999e-110 | NTclustered | gi|90657141|gb|DQ442799.1| | 35100 | g2960 | i0 | 100 | 98.2719298245614 | 222 | 0 | 97 | 0 | 1 | 222 | 99 | 320 | Cyclidium glaucoma isolate ES18 28S ribosomal RNA gene, partial sequence | blastn | 22406 | 411 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Cyclidiidae | Cyclidium | Cyclidium glaucoma | ||
| 20423700 | 20423700 | PRJEB25583_P_NODE_5317_length_178_cov_9.730496_g5140_i0 | PRJEB25583 | 5317 | 178 | 9.730496 | 17.32028288 | Stentor roeselii | 1703786 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 8.15e-75 | NTclustered | gi|1700451376|gb|MN160214.1| | 1703786 | g5140 | i0 | 100 | 60.0393258426966 | 158 | 0 | 89 | 0 | 21 | 178 | 572 | 729 | Stentor roeselii strain OK 6 small subunit ribosomal RNA gene, partial sequence | blastn | 10687 | 292 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor roeselii | ||
| 21699703 | 21699703 | PRJEB25583_P_NODE_3278_length_223_cov_26.774194_g3101_i0 | PRJEB25583 | 3278 | 223 | 26.774194 | 59.70645262 | Stentor roeselii | 1703786 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 8.049999999999997e-96 | NTclustered | gi|921061859|gb|KP970274.1| | 1703786 | g3101 | i0 | 99.01 | 65.7847533632287 | 202 | 2 | 91 | 0 | 1 | 202 | 306 | 105 | Stentor roeselii isolate STR large subunit ribosomal RNA gene, partial sequence | blastn | 14670 | 363 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor roeselii | ||
| 24248800 | 24248800 | PRJEB25583_P_NODE_2060_length_290_cov_9.138340_g1883_i0 | PRJEB25583 | 2060 | 290 | 9.13834 | 26.501186 | Lembadion sp. FG-2015 | 1607877 | SAR_Eukaryotes | SAR_Eukaryotes | 436 | 6.349999999999999e-118 | NTclustered | gi|759083556|gb|KM222173.1| | 1607877 | g1883 | i0 | 96.241 | 88.5413793103448 | 266 | 10 | 92 | 0 | 22 | 287 | 75 | 340 | Lembadion sp. FG-2015 voucher FYB2013031305 large subunit ribosomal RNA gene, partial sequence | blastn | 25677 | 436 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Lembadionidae | Lembadion | Lembadion sp. FG-2015 | ||
| 25212544 | 25212544 | PRJEB25583_P_NODE_4880_length_185_cov_9.439189_g4703_i0 | PRJEB25583 | 4880 | 185 | 9.439189 | 17.46249965 | Plagiocampa | 1348341 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 8.73e-60 | NTclustered | gi|643012177|gb|KF541344.1| | 187299 | g4703 | i0 | 90.659 | 67.0108108108108 | 182 | 17 | 98 | 0 | 4 | 185 | 915 | 734 | Uncultured ciliate clone E06_757_MCM2_1_LSU internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 12397 | 243 | 1 | Eukaryota | Sar | Ciliophora | uncultured ciliate | ||||||
| 28896295 | 28896295 | PRJEB25583_P_NODE_6068_length_169_cov_1.469697_g5891_i0 | PRJEB25583 | 6068 | 169 | 1.469697 | 2.48378793 | Paramecium sonneborni | 65129 | SAR_Eukaryotes | SAR_Eukaryotes | 96.7 | 7.53e-24 | NR | CAD8103391.1 | 65129 | g5891 | i0 | 90.7 | 1.91715976331361 | 54 | 5 | 95.9 | 0 | 6 | 167 | 89 | 142 | CAD8103391.1 unnamed protein product [Paramecium sonneborni] | diamond | 324 | 96.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 29647357 | 29647357 | PRJEB25583_P_NODE_7390_length_157_cov_1.291667_g7213_i0 | PRJEB25583 | 7390 | 157 | 1.291667 | 2.02791719 | Tetrahymenidae | 291294 | SAR_Eukaryotes | SAR_Eukaryotes | 94.4 | 4.2e-22 | NR | XP_004037237.1 | 5932 | g7213 | i0 | 86.5 | 7.94904458598726 | 52 | 7 | 99.4 | 0 | 157 | 2 | 158 | 209 | XP_004037237.1 hypothetical protein IMG5_058070 [Ichthyophthirius multifiliis] | diamond | 1248 | 94.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis |
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);;