contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA906294" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2161213 | 2161213 | PRJNA906294_P_NODE_127502_length_348_cov_1.658182_g123386_i0 | PRJNA906294 | 127502 | 348 | 1.658182 | 5.77047336 | Euplotes eurystomus | 5941 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 1.12e-41 | NTclustered | gi|159037|gb|M57231.1|EUPUBQP | 5941 | g123386 | i0 | 83.938 | 56.4425287356322 | 193 | 29 | 55 | 2 | 1 | 192 | 637 | 828 | Euplotes eurystomus macronuclear polyubiquitin, complete cds | blastn | 19642 | 183 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes eurystomus | ||
| 2524559 | 2524559 | PRJNA906294_P_NODE_84222_length_473_cov_3.972500_g80108_i0 | PRJNA906294 | 84222 | 473 | 3.9725 | 18.789925 | Helicoprorodontidae | 1607782 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 1.23e-27 | NTclustered | gi|375305434|gb|JF975394.1| | 652932 | g80108 | i0 | 90.385 | 25.9577167019027 | 104 | 10 | 22 | 0 | 298 | 401 | 309 | 206 | Trachelotractus entzi isolate LWW07033111 28S ribosomal RNA gene, partial sequence | blastn | 12278 | 137 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | Trachelotractus | Trachelotractus entzi | |||
| 3438464 | 3438464 | PRJNA906294_P_NODE_205103_length_250_cov_23.350282_g200987_i0 | PRJNA906294 | 205103 | 250 | 23.350282 | 58.375705 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.85e-21 | NTclustered | gi|829192014|ref|XM_012799966.1| | 312017 | g200987 | i0 | 88.421 | 1.68 | 95 | 11 | 38 | 0 | 48 | 142 | 125 | 219 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 420 | 115 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 7263647 | 7263647 | PRJNA906294_P_NODE_111006_length_384_cov_2.099678_g106891_i0 | PRJNA906294 | 111006 | 384 | 2.099678 | 8.06276352 | uncultured ciliate | 187299 | SAR_Eukaryotes | SAR_Eukaryotes | 652 | 0 | NTclustered | gi|221185865|gb|FJ577812.1| | 187299 | g106891 | i0 | 97.396 | 82.71875 | 384 | 9 | 100 | 1 | 1 | 384 | 902 | 520 | Uncultured ciliate clone Ivry08 18S ribosomal RNA gene, partial sequence | blastn | 31764 | 652 | 1 | Eukaryota | Sar | Ciliophora | uncultured ciliate | ||||||
| 8538185 | 8538185 | PRJNA906294_P_NODE_101287_length_411_cov_7.165680_g97172_i0 | PRJNA906294 | 101287 | 411 | 7.16568 | 29.4509448 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 728 | 0 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g97172 | i0 | 98.78 | 51.6715328467153 | 410 | 4 | 99 | 1 | 3 | 411 | 450 | 41 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 21237 | 728 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 8540080 | 8540080 | PRJNA906294_P_NODE_181307_length_274_cov_1.338308_g177191_i0 | PRJNA906294 | 181307 | 274 | 1.338308 | 3.66696392 | Caryotricha minuta | 1004043 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.4e-37 | NTclustered | gi|759083508|gb|KM222125.1| | 1004043 | g177191 | i0 | 86.364 | 20.5656934306569 | 154 | 21 | 56 | 0 | 119 | 272 | 1076 | 1229 | Caryotricha minuta voucher LWW07112802 large subunit ribosomal RNA gene, partial sequence | blastn | 5635 | 169 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Kiitrichida | Kiitrichidae | Caryotricha | Caryotricha minuta | ||
| 11092614 | 11092614 | PRJNA906294_P_NODE_51589_length_688_cov_2.847154_g47599_i0 | PRJNA906294 | 51589 | 688 | 2.847154 | 19.58841952 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1107 | 0 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g47599 | i0 | 96.16 | 44.4593023255814 | 677 | 26 | 98 | 0 | 12 | 688 | 699 | 23 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 30588 | 1107 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 12364789 | 12364789 | PRJNA906294_P_NODE_120510_length_362_cov_1.667820_g116395_i0 | PRJNA906294 | 120510 | 362 | 1.66782 | 6.0375084 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 398 | 3.83e-106 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g116395 | i0 | 93.609 | 44.5138121546961 | 266 | 17 | 73 | 0 | 1 | 266 | 940 | 1205 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 16114 | 398 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 16192039 | 16192039 | PRJNA906294_P_NODE_62753_length_593_cov_4.319231_g58678_i0 | PRJNA906294 | 62753 | 593 | 4.319231 | 25.61303983 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 896 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g58678 | i0 | 93.939 | 67.5430016863406 | 594 | 34 | 100 | 2 | 1 | 593 | 18 | 610 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 40053 | 896 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 17463727 | 17463727 | PRJNA906294_P_NODE_109214_length_389_cov_1.443038_g105099_i0 | PRJNA906294 | 109214 | 389 | 1.443038 | 5.61341782 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 503 | 8.54e-138 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g105099 | i0 | 90 | 8.25964010282776 | 390 | 37 | 100 | 2 | 1 | 389 | 623 | 235 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 3213 | 503 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 17464492 | 17464492 | PRJNA906294_P_NODE_141994_length_323_cov_2.040000_g137878_i0 | PRJNA906294 | 141994 | 323 | 2.04 | 6.5892 | Stylonychia mytilus | 5950 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 3.68e-46 | NTclustered | gi|8050573|gb|AF213664.1|AF213664 | 5950 | g137878 | i0 | 81.25 | 0.792569659442725 | 256 | 38 | 78 | 9 | 67 | 317 | 1840 | 2090 | Stylonychia mytilus elongation factor 2 (EF2) gene, partial cds | blastn | 256 | 198 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia mytilus | ||
| 17826408 | 17826408 | PRJNA906294_P_NODE_81314_length_486_cov_2.537530_g77202_i0 | PRJNA906294 | 81314 | 486 | 2.53753 | 12.3323958 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 2.77e-19 | NTclustered | gi|342161082|gb|JF694047.1| | 488251 | g77202 | i0 | 93.243 | 8.83539094650206 | 74 | 5 | 15 | 0 | 413 | 486 | 85 | 12 | Diophryopsis hystrix isolate pop2 voucher PY20100625 28S ribosomal RNA gene, partial sequence | blastn | 4294 | 110 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Uronychiidae | Diophryopsis | Diophryopsis hystrix | ||
| 17826446 | 17826446 | PRJNA906294_P_NODE_91294_length_445_cov_2.193548_g87180_i0 | PRJNA906294 | 91294 | 445 | 2.193548 | 9.7612886 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 800 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g87180 | i0 | 99.101 | 97.4651685393258 | 445 | 4 | 100 | 0 | 1 | 445 | 2359 | 2803 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 43372 | 800 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 20012666 | 20012666 | PRJNA906294_P_NODE_134056_length_336_cov_1.882129_g129940_i0 | PRJNA906294 | 134056 | 336 | 1.882129 | 6.32395344 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 2.0700000000000003e-123 | NTclustered | gi|10138|emb|X01746.1| | 5949 | g129940 | i0 | 91.071 | 83.4821428571429 | 336 | 30 | 100 | 0 | 1 | 336 | 222 | 557 | Stylonychia lemnae gene for alpha-tubulin | blastn | 28050 | 455 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 21289687 | 21289687 | PRJNA906294_P_NODE_205117_length_250_cov_3.564972_g201001_i0 | PRJNA906294 | 205117 | 250 | 3.564972 | 8.91243 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 446 | 8.89e-121 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g201001 | i0 | 99.19 | 99.564 | 247 | 2 | 99 | 0 | 1 | 247 | 667 | 913 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 24891 | 446 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 21290859 | 21290859 | PRJNA906294_P_NODE_48417_length_722_cov_2.741140_g44487_i0 | PRJNA906294 | 48417 | 722 | 2.74114 | 19.7910308 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1059 | 0 | NTclustered | gi|110645006|gb|DQ665938.1| | 151077 | g44487 | i0 | 96.984 | 59.3891966759003 | 630 | 19 | 87 | 0 | 93 | 722 | 1 | 630 | Chilodonella uncinata actin gene, partial cds; macronuclear | blastn | 42879 | 1059 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 22562654 | 22562654 | PRJNA906294_P_NODE_115918_length_372_cov_4.464883_g111803_i0 | PRJNA906294 | 115918 | 372 | 4.464883 | 16.60936476 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 560 | 4.75e-155 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g111803 | i0 | 93.817 | 68.8387096774194 | 372 | 23 | 100 | 0 | 1 | 372 | 393 | 22 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 25608 | 560 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 22564512 | 22564512 | PRJNA906294_P_NODE_194918_length_260_cov_1.625668_g190802_i0 | PRJNA906294 | 194918 | 260 | 1.625668 | 4.2267368 | Euplotes focardii | 36767 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 2.2199999999999996e-47 | NTclustered | gi|18479018|gb|AF408404.1| | 36767 | g190802 | i0 | 81.061 | 95.45 | 264 | 41 | 99 | 8 | 2 | 260 | 1395 | 1136 | Euplotes focardii macronuclear alpha-tubulin gene, complete cds | blastn | 24817 | 202 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes focardii | ||
| 23838026 | 23838026 | PRJNA906294_P_NODE_125519_length_352_cov_1.394265_g121403_i0 | PRJNA906294 | 125519 | 352 | 1.394265 | 4.9078128 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 573 | 5.739999999999999e-159 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g121403 | i0 | 96.023 | 12.3778409090909 | 352 | 14 | 100 | 0 | 1 | 352 | 355 | 706 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 4357 | 573 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 23839949 | 23839949 | PRJNA906294_P_NODE_205919_length_250_cov_1.242938_g201803_i0 | PRJNA906294 | 205919 | 250 | 1.242938 | 3.107345 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 451 | 1.91e-122 | NTclustered | gi|347439295|gb|JN111996.1| | 151077 | g201803 | i0 | 99.2 | 98.632 | 250 | 2 | 100 | 0 | 1 | 250 | 64 | 313 | Chilodonella uncinata strain USA_SC2 alpha-tubulin (atub) gene, partial cds; macronuclear | blastn | 24658 | 451 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 23842128 | 23842128 | PRJNA906294_P_NODE_92059_length_442_cov_2.769648_g87945_i0 | PRJNA906294 | 92059 | 442 | 2.769648 | 12.24184416 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 737 | 0 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g87945 | i0 | 96.825 | 55.1606334841629 | 441 | 14 | 99 | 0 | 2 | 442 | 463 | 23 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 24381 | 737 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24200513 | 24200513 | PRJNA906294_P_NODE_93559_length_437_cov_1.568681_g89445_i0 | PRJNA906294 | 93559 | 437 | 1.568681 | 6.85513597 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 6.35e-75 | NTclustered | gi|10790|emb|X12767.1| | 5908 | g89445 | i0 | 79.856 | 87.7871853546911 | 417 | 73 | 95 | 9 | 21 | 433 | 965 | 556 | Tetrahymena pyriformis alpha-tubulin gene | blastn | 38363 | 294 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 25474889 | 25474889 | PRJNA906294_P_NODE_149540_length_312_cov_1.589958_g145424_i0 | PRJNA906294 | 149540 | 312 | 1.589958 | 4.96066896 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 2.7399999999999997e-47 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g145424 | i0 | 97.458 | 2 | 118 | 3 | 38 | 0 | 195 | 312 | 3082 | 2965 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 624 | 202 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola |
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);;