contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA1164198" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 312045 | 312045 | PRJNA1164198_P_NODE_4381_length_602_cov_1.574669_g4133_i0 | PRJNA1164198 | 4381 | 602 | 1.574669 | 9.47950738 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 747 | 0 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g4133 | i0 | 89.149 | 7.77574750830565 | 599 | 65 | 99 | 0 | 1 | 599 | 8 | 606 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 4681 | 747 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 1039486 | 1039486 | PRJNA1164198_P_NODE_2001_length_875_cov_5.339152_g1818_i0 | PRJNA1164198 | 2001 | 875 | 5.339152 | 46.71758 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 1400 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g1818 | i0 | 95.568 | 55.2662857142857 | 880 | 29 | 100 | 8 | 1 | 875 | 2366 | 1492 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 48358 | 1400 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 2862787 | 2862787 | PRJNA1164198_P_NODE_18323_length_289_cov_1.805556_g18054_i0 | PRJNA1164198 | 18323 | 289 | 1.805556 | 5.21805684 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 396 | 1.0699999999999997e-105 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g18054 | i0 | 91.349 | 1.36678200692042 | 289 | 25 | 100 | 0 | 1 | 289 | 912 | 624 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 395 | 396 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 2862882 | 2862882 | PRJNA1164198_P_NODE_7683_length_451_cov_3.711640_g7422_i0 | PRJNA1164198 | 7683 | 451 | 3.71164 | 16.7394964 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 671 | 0 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g7422 | i0 | 93.57 | 55.8314855875831 | 451 | 28 | 100 | 1 | 1 | 451 | 22 | 471 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 25180 | 671 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 4138819 | 4138819 | PRJNA1164198_P_NODE_24784_length_252_cov_0.871508_g24515_i0 | PRJNA1164198 | 24784 | 252 | 0.871508 | 2.19620016 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 1.6099999999999999e-68 | NTclustered | gi|829160572|ref|XM_001012497.3| | 312017 | g24515 | i0 | 89.041 | 1.01984126984127 | 219 | 24 | 87 | 0 | 34 | 252 | 641 | 423 | Tetrahymena thermophila SB210 60S ribosomal protein L10 partial mRNA | blastn | 257 | 272 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 4138838 | 4138838 | PRJNA1164198_P_NODE_27544_length_247_cov_1.344828_g27275_i0 | PRJNA1164198 | 27544 | 247 | 1.344828 | 3.32172516 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 2.05e-62 | NTclustered | gi|149394715|gb|EF125697.1| | 151077 | g27275 | i0 | 85.02 | 4.417004048583 | 247 | 37 | 100 | 0 | 1 | 247 | 695 | 941 | Chilodonella uncinata strain ATCC 50194 serine/threonine protein phosphatase-like gene, complete sequence; macronuclear | blastn | 1091 | 252 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 5415105 | 5415105 | PRJNA1164198_P_NODE_7805_length_448_cov_2.266667_g7543_i0 | PRJNA1164198 | 7805 | 448 | 2.266667 | 10.15466816 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 773 | 0 | NTclustered | gi|1389430741|gb|MH341591.1| | 1938391 | g7543 | i0 | 97.773 | 96.453125 | 449 | 9 | 100 | 1 | 1 | 448 | 526 | 974 | Chilodonella hexasticha isolate C.hexasticha CA small subunit ribosomal RNA gene, partial sequence | blastn | 43211 | 773 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 7417387 | 7417387 | PRJNA1164198_P_NODE_22086_length_264_cov_2.670157_g21817_i0 | PRJNA1164198 | 22086 | 264 | 2.670157 | 7.04921448 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 424 | 4.44e-114 | NTclustered | gi|693735214|gb|KJ509197.1| | 1552886 | g21817 | i0 | 95.506 | 99.0037878787879 | 267 | 9 | 100 | 3 | 1 | 264 | 280 | 14 | Chilodonella parauncinata isolate QZS2013052301 small subunit ribosomal RNA gene, partial sequence | blastn | 26137 | 424 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella parauncinata | ||
| 7417404 | 7417404 | PRJNA1164198_P_NODE_7486_length_457_cov_2.893229_g7225_i0 | PRJNA1164198 | 7486 | 457 | 2.893229 | 13.22205653 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 822 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g7225 | i0 | 99.127 | 91.5010940919037 | 458 | 3 | 100 | 1 | 1 | 457 | 2361 | 2818 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 41816 | 824 | 0.997572815533981 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 7965169 | 7965169 | PRJNA1164198_P_NODE_13007_length_343_cov_3.303704_g12738_i0 | PRJNA1164198 | 13007 | 343 | 3.303704 | 11.33170472 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 523 | 5.719999999999999e-144 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g12738 | i0 | 94.412 | 5.3002915451895 | 340 | 19 | 99 | 0 | 1 | 340 | 26 | 365 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 1818 | 523 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 9239848 | 9239848 | PRJNA1164198_P_NODE_13728_length_334_cov_1.666667_g13459_i0 | PRJNA1164198 | 13728 | 334 | 1.666667 | 5.56666778 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 477 | 4.38e-130 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g13459 | i0 | 92.727 | 1.09281437125748 | 330 | 24 | 99 | 0 | 2 | 331 | 511 | 182 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 365 | 477 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 9967600 | 9967600 | PRJNA1164198_P_NODE_10468_length_384_cov_4.003215_g10200_i0 | PRJNA1164198 | 10468 | 384 | 4.003215 | 15.3723456 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 1.5400000000000002e-70 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g10200 | i0 | 98.125 | 2.27864583333333 | 160 | 3 | 42 | 0 | 225 | 384 | 3082 | 2923 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 875 | 279 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 13792805 | 13792805 | PRJNA1164198_P_NODE_1831_length_908_cov_10.370060_g1654_i0 | PRJNA1164198 | 1831 | 908 | 10.37006 | 94.1601448 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 1483 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g1654 | i0 | 96.154 | 66.4724669603524 | 910 | 31 | 100 | 3 | 1 | 908 | 917 | 10 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 60357 | 1483 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 23264180 | 23264180 | PRJNA1164198_P_NODE_17479_length_295_cov_3.864865_g17210_i0 | PRJNA1164198 | 17479 | 295 | 3.864865 | 11.40135175 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.3999999999999999e-114 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g17210 | i0 | 97.581 | 88.7491525423729 | 248 | 6 | 84 | 0 | 1 | 248 | 248 | 1 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 26181 | 425 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 23264193 | 23264193 | PRJNA1164198_P_NODE_21079_length_270_cov_2.588832_g20810_i0 | PRJNA1164198 | 21079 | 270 | 2.588832 | 6.9898464 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 7.84e-92 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g20810 | i0 | 90 | 39.4148148148148 | 270 | 27 | 100 | 0 | 1 | 270 | 368 | 637 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 10642 | 350 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24537861 | 24537861 | PRJNA1164198_P_NODE_1340_length_1040_cov_5.483971_g1191_i0 | PRJNA1164198 | 1340 | 1040 | 5.483971 | 57.0332984 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1487 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g1191 | i0 | 94.676 | 24.6355769230769 | 958 | 51 | 92 | 0 | 1 | 958 | 248 | 1205 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 25621 | 1487 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24537880 | 24537880 | PRJNA1164198_P_NODE_20160_length_276_cov_1.536946_g19891_i0 | PRJNA1164198 | 20160 | 276 | 1.536946 | 4.24197096 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 460 | 3.5599999999999997e-125 | NTclustered | gi|21632109|gb|AY041125.1| | 151077 | g19891 | i0 | 96.739 | 98.3768115942029 | 276 | 9 | 100 | 0 | 1 | 276 | 788 | 1063 | Chilodonella uncinata clone 5 alpha-tubulin gene, partial cds | blastn | 27152 | 460 | 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);;