contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA561212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 545440 | 545440 | PRJNA561212_P_NODE_341_length_1643_cov_14.349045_g267_i0 | PRJNA561212 | 341 | 1643 | 14.349045 | 235.75480935 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.013 | NTclustered | gi|829195282|ref|XM_001029383.2| | 312017 | g267 | i0 | 100 | 0.0359099208764455 | 30 | 0 | 2 | 0 | 1115 | 1144 | 6026 | 5997 | Tetrahymena thermophila SB210 SNF2 family amine-terminal protein partial mRNA | blastn | 59 | 56.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 1821086 | 1821086 | PRJNA561212_P_NODE_21722_length_250_cov_0.881356_g21511_i0 | PRJNA561212 | 21722 | 250 | 0.881356 | 2.20339 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 2.1900000000000003e-27 | NTclustered | gi|8050575|gb|AF213665.1|AF213665 | 5908 | g21511 | i0 | 84.559 | 0.544 | 136 | 21 | 54 | 0 | 9 | 144 | 1411 | 1276 | Tetrahymena pyriformis elongation factor 2 (EF2) gene, partial cds | blastn | 136 | 135 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 1821269 | 1821269 | PRJNA561212_P_NODE_9482_length_358_cov_0.754386_g9271_i0 | PRJNA561212 | 9482 | 358 | 0.754386 | 2.70070188 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 9.16e-23 | NTclustered | gi|229593638|ref|XM_001027526.3| | 312017 | g9271 | i0 | 73.088 | 1.75977653631285 | 353 | 89 | 98 | 6 | 9 | 358 | 913 | 564 | Tetrahymena thermophila SB210 Ndc1 protein partial mRNA | blastn | 630 | 121 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 2406092 | 2406092 | PRJNA561212_P_NODE_16522_length_279_cov_1.048544_g16311_i0 | PRJNA561212 | 16522 | 279 | 1.048544 | 2.92543776 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 436 | 6.069999999999999e-118 | NTclustered | gi|822092996|gb|KP313320.1| | 5911 | g16311 | i0 | 95.911 | 91.7777777777778 | 269 | 11 | 96 | 0 | 1 | 269 | 725 | 457 | Tetrahymena thermophila isolate 19869-1 alpha-tubulin (ATU1) gene, partial cds; macronuclear | blastn | 25606 | 436 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 3682022 | 3682022 | PRJNA561212_P_NODE_4683_length_511_cov_2.899543_g4474_i0 | PRJNA561212 | 4683 | 511 | 2.899543 | 14.81666473 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 902 | 0 | NTclustered | gi|363412153|gb|JN120227.1| | 60850 | g4474 | i0 | 99.595 | 96.6829745596869 | 494 | 2 | 97 | 0 | 9 | 502 | 440 | 933 | Vorticella convallaria isolate 96Vorsp16 18S ribosomal RNA gene, partial sequence | blastn | 49405 | 902 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella convallaria | ||
| 5649327 | 5649327 | PRJNA561212_P_NODE_5025_length_493_cov_5.695238_g4814_i0 | PRJNA561212 | 5025 | 493 | 5.695238 | 28.07752334 | Tetrahymena chironomi | 3034767 | SAR_Eukaryotes | SAR_Eukaryotes | 856 | 0 | NTclustered | gi|2459327221|gb|OQ626840.1| | 3034767 | g4814 | i0 | 99.158 | 88.3022312373225 | 475 | 4 | 96 | 0 | 10 | 484 | 951 | 477 | 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 | 43533 | 856 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena chironomi | ||
| 6234253 | 6234253 | PRJNA561212_P_NODE_10405_length_342_cov_1.687732_g10194_i0 | PRJNA561212 | 10405 | 342 | 1.687732 | 5.77204344 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 595 | 1.1899999999999999e-165 | NTclustered | gi|1389430796|gb|MH341624.1| | 1654720 | g10194 | i0 | 99.692 | 90.4853801169591 | 325 | 1 | 95 | 0 | 9 | 333 | 12 | 336 | Chilodonella piscicola strain C.piscicola SC small subunit ribosomal RNA gene, partial sequence | blastn | 30946 | 595 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 6923294 | 6923294 | PRJNA561212_P_NODE_12986_length_309_cov_6.072034_g12775_i0 | PRJNA561212 | 12986 | 309 | 6.072034 | 18.76258506 | Planilamina ovata | 2684848 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 1.5599999999999999e-74 | NTclustered | gi|1784308423|gb|MN830171.1| | 2684848 | g12775 | i0 | 86.517 | 54.7766990291262 | 267 | 34 | 86 | 2 | 14 | 279 | 149 | 414 | Planilamina ovata isolate LJ-II-20170502 large subunit ribosomal RNA gene, partial sequence | blastn | 16926 | 292 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Dysteriida | Kyaroikeidae | Planilamina | Planilamina ovata | ||
| 10749794 | 10749794 | PRJNA561212_P_NODE_3169_length_618_cov_1.917431_g2964_i0 | PRJNA561212 | 3169 | 618 | 1.917431 | 11.84972358 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 915 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2964 | i0 | 94.176 | 65.173139158576 | 601 | 33 | 97 | 2 | 10 | 609 | 609 | 10 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 40277 | 915 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 13299411 | 13299411 | PRJNA561212_P_NODE_16891_length_276_cov_1.108374_g16680_i0 | PRJNA561212 | 16891 | 276 | 1.108374 | 3.05911224 | Tetrahymena acanthophora | 2704174 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 3.61e-115 | NTclustered | gi|1802471988|gb|MN994476.1| | 2704174 | g16680 | i0 | 96.525 | 55.3913043478261 | 259 | 8 | 93 | 1 | 10 | 267 | 115 | 373 | Tetrahymena acanthophora isolate ZP61 large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 15288 | 427 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena acanthophora | ||
| 13299453 | 13299453 | PRJNA561212_P_NODE_19131_length_260_cov_1.272727_g18920_i0 | PRJNA561212 | 19131 | 260 | 1.272727 | 3.3090902 | Stylonychia mytilus | 5950 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 1.65e-78 | NTclustered | gi|6007455|gb|AF188162.1|AF188162 | 5950 | g18920 | i0 | 88.843 | 87.6846153846154 | 242 | 27 | 93 | 0 | 10 | 251 | 1100 | 859 | Stylonychia mytilus beta tubulin gene, complete cds | blastn | 22798 | 305 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia mytilus | ||
| 14574481 | 14574481 | PRJNA561212_P_NODE_2672_length_671_cov_13.138796_g2335_i1 | PRJNA561212 | 2672 | 671 | 13.138796 | 88.16132116 | Pseudovorticella sp. FG-2015 | 1607895 | SAR_Eukaryotes | SAR_Eukaryotes | 1123 | 0 | NTclustered | gi|759083559|gb|KM222176.1| | 1607895 | g2335 | i1 | 98.145 | 85.7868852459016 | 647 | 6 | 96 | 4 | 11 | 654 | 644 | 1 | Pseudovorticella sp. FG-2015 voucher SZ2010032108 large subunit ribosomal RNA gene, partial sequence | blastn | 57563 | 1123 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Pseudovorticella | Pseudovorticella sp. FG-2015 | ||
| 17708668 | 17708668 | PRJNA561212_P_NODE_7814_length_392_cov_1.789969_g7603_i0 | PRJNA561212 | 7814 | 392 | 1.789969 | 7.01667848 | root | 1 | Root_unresolved | Root_unresolved | 682 | 0 | NTclustered | gi|1621572405|gb|MH051920.1| | 5893 | g7603 | i0 | 98.95 | 97.1989795918367 | 381 | 4 | 97 | 0 | 6 | 386 | 992 | 612 | Tetrahymena borealis strain 1630/5A small subunit ribosomal RNA gene, partial sequence | blastn | 38102 | 688 | 0.991279069767442 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena borealis | ||
| 18397148 | 18397148 | PRJNA561212_P_NODE_12215_length_318_cov_1.204082_g12004_i0 | PRJNA561212 | 12215 | 318 | 1.204082 | 3.82898076 | Philasterides dicentrarchi | 282688 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 3.67e-36 | NTclustered | gi|49616744|gb|AY643504.1| | 282688 | g12004 | i0 | 85.987 | 2.15723270440252 | 157 | 18 | 49 | 4 | 35 | 189 | 251 | 97 | Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence | blastn | 686 | 165 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 18397396 | 18397396 | PRJNA561212_P_NODE_3955_length_557_cov_1.590909_g3748_i0 | PRJNA561212 | 3955 | 557 | 1.590909 | 8.86136313 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 918 | 0 | NTclustered | gi|1389430805|gb|MH341633.1| | 1938391 | g3748 | i0 | 96.898 | 65.7271095152603 | 548 | 17 | 98 | 0 | 1 | 548 | 1785 | 2332 | Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence | blastn | 36610 | 918 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 20257218 | 20257218 | PRJNA561212_P_NODE_2696_length_669_cov_3.736577_g2491_i0 | PRJNA561212 | 2696 | 669 | 3.736577 | 24.99770013 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 7.64e-86 | NTclustered | gi|161789|gb|M87504.1|TETHIS32A | 5911 | g2491 | i0 | 81.327 | 58.9955156950673 | 407 | 76 | 61 | 0 | 37 | 443 | 210 | 616 | Tetrahymena thermophila histone H3 (HHT2) gene, complete cds | blastn | 39468 | 333 | 0.993993993993994 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 20947554 | 20947554 | PRJNA561212_P_NODE_21857_length_250_cov_0.881356_g21646_i0 | PRJNA561212 | 21857 | 250 | 0.881356 | 2.20339 | Philasterides dicentrarchi | 282688 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 7.75e-37 | NTclustered | gi|1574038607|gb|MH427332.1| | 282688 | g21646 | i0 | 80.841 | 1.78 | 214 | 39 | 85 | 2 | 31 | 242 | 424 | 637 | Philasterides dicentrarchi cytochrome c1 mRNA, complete cds | blastn | 445 | 167 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 20947600 | 20947600 | PRJNA561212_P_NODE_24937_length_244_cov_0.912281_g24726_i0 | PRJNA561212 | 24937 | 244 | 0.912281 | 2.22596564 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 5.74e-48 | NTclustered | gi|829166462|ref|XM_001014441.3| | 312017 | g24726 | i0 | 86.082 | 0.795081967213115 | 194 | 22 | 79 | 5 | 43 | 234 | 1 | 191 | Tetrahymena thermophila SB210 40S ribosomal protein S0 partial mRNA | blastn | 194 | 204 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 21532729 | 21532729 | PRJNA561212_P_NODE_6657_length_427_cov_1.596045_g6446_i0 | PRJNA561212 | 6657 | 427 | 1.596045 | 6.81511215 | root | 1 | Root_unresolved | Root_unresolved | 728 | 0 | NTclustered | gi|345541658|gb|JN547815.1| | 5911 | g6446 | i0 | 98.778 | 79.6651053864169 | 409 | 5 | 96 | 0 | 10 | 418 | 3401 | 3809 | Tetrahymena thermophila strain ATCC 30382 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence | blastn | 34017 | 728 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 23497818 | 23497818 | PRJNA561212_P_NODE_2539_length_688_cov_13.287805_g2335_i0 | PRJNA561212 | 2539 | 688 | 13.287805 | 91.4200984 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 1051 | 0 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g2335 | i0 | 94.94 | 89.6831395348837 | 672 | 33 | 98 | 1 | 8 | 679 | 1672 | 1002 | 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 | 61702 | 1051 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 23497944 | 23497944 | PRJNA561212_P_NODE_9379_length_359_cov_8.020979_g9168_i0 | PRJNA561212 | 9379 | 359 | 8.020979 | 28.79531461 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 610 | 4.47e-170 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g9168 | i0 | 99.407 | 55.7047353760446 | 337 | 1 | 94 | 1 | 14 | 350 | 3284 | 2949 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 19998 | 610 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 25357020 | 25357020 | PRJNA561212_P_NODE_16000_length_282_cov_1.976077_g15789_i0 | PRJNA561212 | 16000 | 282 | 1.976077 | 5.57253714 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 481 | 2.799999999999999e-131 | NTclustered | gi|13194559|gb|AF300281.1|AF300281 | 151077 | g15789 | i0 | 99.248 | 91.5212765957447 | 266 | 2 | 94 | 0 | 8 | 273 | 1260 | 1525 | Chilodonella uncinata clone 1 18S small subunit ribosomal RNA gene, partial sequence | blastn | 25809 | 481 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata |
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);;