contig_metadata
21 rows where bioproject = "PRJNA771359" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1206719 | 1206719 | PRJNA771359_S_NODE_2341_length_219_cov_3.923077_g2258_i0 | PRJNA771359 | 2341 | 219 | 3.923077 | 8.59153863 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 403 | 4.64e-108 | NTclustered | gi|219812771|gb|FJ552985.1| | 282477 | g2258 | i0 | 100 | 99.0639269406393 | 218 | 0 | 99 | 0 | 1 | 218 | 80 | 297 | Uncultured peritrich clone LTSP_EUKA_P1P06 18S ribosomal RNA, 18S-25/28S ribosomal RNA intergenic spacer, partial sequence | blastn | 21695 | 403 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | uncultured Peritrichia | |||||
| 1206721 | 1206721 | PRJNA771359_S_NODE_2481_length_212_cov_11.685714_g2398_i0 | PRJNA771359 | 2481 | 212 | 11.685714 | 24.77371368 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 4.5e-103 | NTclustered | gi|297664831|gb|GU586177.1| | 768686 | g2398 | i0 | 99.528 | 98.1556603773585 | 212 | 1 | 100 | 0 | 1 | 212 | 551 | 340 | Vorticella sp. 8 PPS-2010 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 | 20809 | 387 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 8 PPS-2010 | ||
| 2023051 | 2023051 | PRJNA771359_S_NODE_3382_length_182_cov_7.613793_g3299_i0 | PRJNA771359 | 3382 | 182 | 7.613793 | 13.85710326 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 6.48e-76 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g3299 | i0 | 96.154 | 99.6153846153846 | 182 | 5 | 100 | 2 | 1 | 182 | 1827 | 1648 | 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 | 18130 | 296 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 5850545 | 5850545 | PRJNA771359_S_NODE_1365_length_290_cov_29.079051_g1282_i0 | PRJNA771359 | 1365 | 290 | 29.079051 | 84.3292479 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 494 | 3.71e-135 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g1282 | i0 | 98.913 | 93.0034482758621 | 276 | 3 | 95 | 0 | 15 | 290 | 1450 | 1175 | 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 | 26971 | 494 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 7125801 | 7125801 | PRJNA771359_S_NODE_5166_length_151_cov_1.649123_g5083_i0 | PRJNA771359 | 5166 | 151 | 1.649123 | 2.49017573 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 1.12e-67 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g5083 | i0 | 98.675 | 61.3708609271523 | 151 | 2 | 100 | 0 | 1 | 151 | 692 | 842 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 9267 | 268 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 10135329 | 10135329 | PRJNA771359_S_NODE_1828_length_247_cov_4.895238_g1745_i0 | PRJNA771359 | 1828 | 247 | 4.895238 | 12.09123786 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.4600000000000002e-123 | NTclustered | gi|363412151|gb|JN120225.1| | 1126581 | g1745 | i0 | 100 | 98.8623481781377 | 246 | 0 | 99 | 0 | 2 | 247 | 760 | 515 | Vorticella citrina isolate 78vor5253c1wh6S1S2 18S ribosomal RNA gene, partial sequence | blastn | 24419 | 455 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella citrina | ||
| 12226735 | 12226735 | PRJNA771359_S_NODE_2550_length_209_cov_16.482558_g2467_i0 | PRJNA771359 | 2550 | 209 | 16.482558 | 34.44854622 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 2.22e-46 | NTclustered | gi|512134965|gb|JX178924.1| | 1295638 | g2467 | i0 | 88.889 | 54.7177033492823 | 162 | 17 | 77 | 1 | 1 | 161 | 1646 | 1485 | Vorticella sp. 4 JG-2011 clone 24 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 | 11436 | 198 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 12686382 | 12686382 | PRJNA771359_S_NODE_4250_length_164_cov_1.543307_g4167_i0 | PRJNA771359 | 4250 | 164 | 1.543307 | 2.53102348 | Peniculida | 33825 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 3.67e-28 | NTclustered | gi|2496410955|gb|OQ869837.1| | 2706568 | g4167 | i0 | 86.992 | 63.3536585365854 | 123 | 15 | 74 | 1 | 7 | 128 | 1642 | 1520 | Frontonia atra isolate S240 large subunit ribosomal RNA gene, partial sequence | blastn | 10390 | 137 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Frontoniidae | Frontonia | Frontonia atra | ||
| 16049672 | 16049672 | PRJNA771359_S_NODE_4993_length_153_cov_1.318966_g4910_i0 | PRJNA771359 | 4993 | 153 | 1.318966 | 2.01801798 | Carchesium polypinum | 168244 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 1.93e-60 | NTclustered | gi|281192505|gb|FJ883553.1| | 168244 | g4910 | i0 | 95.425 | 41.4183006535948 | 153 | 7 | 100 | 0 | 1 | 153 | 532 | 684 | Carchesium polypinum alpha-tubulin gene, partial cds | blastn | 6337 | 244 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Carchesium | Carchesium polypinum | ||
| 21149658 | 21149658 | PRJNA771359_S_NODE_637_length_389_cov_16.204545_g554_i0 | PRJNA771359 | 637 | 389 | 16.204545 | 63.03568005 | Vorticella sp. 1 | 2979179 | SAR_Eukaryotes | SAR_Eukaryotes | 636 | 8.069999999999999e-178 | NTclustered | gi|2304601489|gb|OP458310.1| | 2979179 | g554 | i0 | 100 | 84.1156812339332 | 344 | 0 | 88 | 0 | 46 | 389 | 1839 | 1496 | Vorticella sp. 1 large subunit ribosomal RNA gene, partial sequence | blastn | 32721 | 636 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 1 | ||
| 24158412 | 24158412 | PRJNA771359_S_NODE_3859_length_171_cov_2.350746_g3776_i0 | PRJNA771359 | 3859 | 171 | 2.350746 | 4.01977566 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 4.6e-82 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g3776 | i0 | 100 | 85.5146198830409 | 171 | 0 | 100 | 0 | 1 | 171 | 1927 | 1757 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 14623 | 316 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 27053363 | 27053363 | PRJNA771359_S_NODE_1642_length_264_cov_1.894273_g1559_i0 | PRJNA771359 | 1642 | 264 | 1.894273 | 5.00088072 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 64.3 | 3.1e-11 | NR | XP_012651983.1 | 312017 | g1559 | i0 | 50.7 | 0.806818181818182 | 71 | 35 | 80.7 | 0 | 6 | 218 | 15 | 85 | XP_012651983.1 hypothetical protein TTHERM_000784569 [Tetrahymena thermophila SB210] | diamond | 213 | 64.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 27189140 | 27189140 | PRJNA771359_S_NODE_3782_length_173_cov_1.419118_g3699_i0 | PRJNA771359 | 3782 | 173 | 1.419118 | 2.45507414 | Tetrahymenidae | 291294 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00221 | NR | NP_049598.1 | 5908 | g3699 | i0 | 81.8 | 0.763005780346821 | 22 | 4 | 38.2 | 0 | 172 | 107 | 185 | 206 | NP_049598.1 apocytochrome b [Tetrahymena pyriformis] | diamond | 132 | 45.4 | 0.993392070484582 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 27685426 | 27685426 | PRJNA771359_S_NODE_2384_length_217_cov_1.577778_g2301_i0 | PRJNA771359 | 2384 | 217 | 1.577778 | 3.42377826 | Paramecium pentaurelia | 43138 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 2.59e-12 | NR | CAD8155930.1 | 43138 | g2301 | i0 | 55.4 | 0.898617511520737 | 65 | 28 | 89.9 | 1 | 215 | 21 | 16 | 79 | CAD8155930.1 unnamed protein product [Paramecium pentaurelia] | diamond | 195 | 68.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium pentaurelia | ||
| 28158966 | 28158966 | PRJNA771359_S_NODE_4145_length_166_cov_1.744186_g4062_i0 | PRJNA771359 | 4145 | 166 | 1.744186 | 2.89534876 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 2.62e-22 | NR | CAG9318382.1 | 1481888 | g4062 | i0 | 75.9 | 0.975903614457831 | 54 | 13 | 97.6 | 0 | 162 | 1 | 52 | 105 | CAG9318382.1 unnamed protein product [Blepharisma stoltei] | diamond | 162 | 93.6 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 28853151 | 28853151 | PRJNA771359_S_NODE_2668_length_205_cov_1.428571_g2585_i0 | PRJNA771359 | 2668 | 205 | 1.428571 | 2.92857055 | Paramecium sonneborni | 65129 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 1.21e-10 | NR | CAD8069000.1 | 65129 | g2585 | i0 | 61.9 | 2.75121951219512 | 63 | 24 | 92.2 | 0 | 204 | 16 | 250 | 312 | CAD8069000.1 unnamed protein product [Paramecium sonneborni] | diamond | 564 | 65.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 28979834 | 28979834 | PRJNA771359_S_NODE_4268_length_164_cov_1.204724_g4185_i0 | PRJNA771359 | 4268 | 164 | 1.204724 | 1.97574736 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00145 | NR | CAD8135162.1 | 43137 | g4185 | i0 | 38.5 | 0.951219512195122 | 52 | 30 | 95.1 | 1 | 2 | 157 | 736 | 785 | CAD8135162.1 unnamed protein product [Paramecium octaurelia] | diamond | 156 | 45.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 29074573 | 29074573 | PRJNA771359_S_NODE_3228_length_187_cov_1.033333_g3145_i0 | PRJNA771359 | 3228 | 187 | 1.033333 | 1.93233271 | Thuricola similis | 2784598 | SAR_Eukaryotes | SAR_Eukaryotes | 78.2 | 5.5e-15 | NR | YP_010147331.1 | 2784598 | g3145 | i0 | 83.3 | 0.770053475935829 | 48 | 8 | 77 | 0 | 3 | 146 | 335 | 382 | YP_010147331.1 cytochrome c oxidase subunit 1 [Thuricola similis] | diamond | 144 | 78.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vaginicolidae | Thuricola | Thuricola similis | ||
| 29494405 | 29494405 | PRJNA771359_S_NODE_3450_length_181_cov_1.340278_g3367_i0 | PRJNA771359 | 3450 | 181 | 1.340278 | 2.42590318 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 40.8 | 0.0283 | NR | XP_012652362.1 | 312017 | g3367 | i0 | 56.8 | 1.83977900552486 | 37 | 16 | 61.3 | 0 | 137 | 27 | 17 | 53 | XP_012652362.1 hypothetical protein TTHERM_000294739 [Tetrahymena thermophila SB210] | diamond | 333 | 40.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 29999817 | 29999817 | PRJNA771359_S_NODE_4271_length_164_cov_1.181102_g4188_i0 | PRJNA771359 | 4271 | 164 | 1.181102 | 1.93700728 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 1.16e-8 | NR | CAD8084070.1 | 65129 | g4188 | i0 | 52.9 | 15.1646341463415 | 51 | 24 | 93.3 | 0 | 164 | 12 | 206 | 256 | CAD8084070.1 unnamed protein product [Paramecium sonneborni] | diamond | 2487 | 60.1 | 0.993344425956739 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 30401312 | 30401312 | PRJNA771359_S_NODE_3453_length_181_cov_1.340278_g3370_i0 | PRJNA771359 | 3453 | 181 | 1.340278 | 2.42590318 | Paramecium primaurelia | 5886 | SAR_Eukaryotes | SAR_Eukaryotes | 71.6 | 1.06e-12 | NR | CAD8044685.1 | 5886 | g3370 | i0 | 61.8 | 1.8232044198895 | 55 | 21 | 91.2 | 0 | 180 | 16 | 214 | 268 | CAD8044685.1 unnamed protein product, partial [Paramecium primaurelia] | diamond | 330 | 71.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia |
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);;