contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA753704" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3282345 | 3282345 | PRJNA753704_P_NODE_20443_length_269_cov_1.683673_g20082_i0 | PRJNA753704 | 20443 | 269 | 1.683673 | 4.52908037 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 453 | 5.78e-123 | NTclustered | gi|347439275|gb|JN111986.1| | 151077 | g20082 | i0 | 97.026 | 91.0594795539033 | 269 | 8 | 100 | 0 | 1 | 269 | 294 | 26 | Chilodonella uncinata strain USA_WH clone SP2 beta tubulin (btub) gene, partial cds; macronuclear | blastn | 24495 | 453 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 4559595 | 4559595 | PRJNA753704_P_NODE_30824_length_211_cov_5.115942_g30463_i0 | PRJNA753704 | 30824 | 211 | 5.115942 | 10.79463762 | Lembadion sp. FG-2015 | 1607877 | SAR_Eukaryotes | SAR_Eukaryotes | 311 | 2.77e-80 | NTclustered | gi|759083556|gb|KM222173.1| | 1607877 | g30463 | i0 | 93.333 | 19.2274881516588 | 210 | 14 | 99 | 0 | 2 | 211 | 577 | 368 | Lembadion sp. FG-2015 voucher FYB2013031305 large subunit ribosomal RNA gene, partial sequence | blastn | 4057 | 311 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Lembadionidae | Lembadion | Lembadion sp. FG-2015 | ||
| 5834800 | 5834800 | PRJNA753704_P_NODE_8085_length_409_cov_8.800595_g7724_i0 | PRJNA753704 | 8085 | 409 | 8.800595 | 35.99443355 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 669 | 0 | NTclustered | gi|512134950|gb|JX178909.1| | 1295638 | g7724 | i0 | 96.324 | 92.9804400977995 | 408 | 14 | 99 | 1 | 3 | 409 | 1549 | 1142 | Vorticella sp. 4 JG-2011 clone 9 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 | 38029 | 669 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 7109897 | 7109897 | PRJNA753704_P_NODE_666_length_1286_cov_10.092333_g468_i0 | PRJNA753704 | 666 | 1286 | 10.092333 | 129.78740238 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1315 | 0 | NTclustered | gi|347439270|gb|JN111983.1| | 151077 | g468 | i0 | 93.031 | 18.8646967340591 | 904 | 58 | 70 | 5 | 378 | 1278 | 1 | 902 | Chilodonella uncinata strain USA_SC2 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 24260 | 1315 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 10130636 | 10130636 | PRJNA753704_P_NODE_11468_length_349_cov_8.775362_g11107_i0 | PRJNA753704 | 11468 | 349 | 8.775362 | 30.62601338 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 634 | 2.5699999999999996e-177 | NTclustered | gi|2223186636|gb|MW310239.1| | 151077 | g11107 | i0 | 99.427 | 94.0343839541547 | 349 | 2 | 100 | 0 | 1 | 349 | 361 | 13 | Chilodonella uncinata isolate 20200709 small subunit ribosomal RNA gene, partial sequence | blastn | 32818 | 634 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 10935079 | 10935079 | PRJNA753704_P_NODE_21949_length_261_cov_1.031915_g21588_i0 | PRJNA753704 | 21949 | 261 | 1.031915 | 2.69329815 | Cothurnia sp. | 2932382 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 3.04e-11 | NTclustered | gi|2392033902|gb|OP962756.1| | 2932382 | g21588 | i0 | 94.444 | 19.0459770114943 | 54 | 1 | 20 | 2 | 136 | 187 | 999 | 1052 | Cothurnia sp. isolate LBR-20170302-01 large subunit ribosomal RNA gene, partial sequence | blastn | 4971 | 82.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vaginicolidae | Cothurnia | Cothurnia sp. | ||
| 11405849 | 11405849 | PRJNA753704_P_NODE_20309_length_270_cov_1.558376_g19948_i0 | PRJNA753704 | 20309 | 270 | 1.558376 | 4.2076152 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 3.7500000000000005e-70 | NTclustered | gi|2209090|gb|AF003089.1|AF003089 | 5919 | g19948 | i0 | 85.878 | 173.588888888889 | 262 | 35 | 97 | 2 | 3 | 263 | 193 | 453 | Tetrahymena vorax ubiquitin mRNA, complete cds | blastn | 46869 | 279 | 0.996415770609319 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena vorax | ||
| 13484811 | 13484811 | PRJNA753704_P_NODE_19091_length_277_cov_4.857843_g18730_i0 | PRJNA753704 | 19091 | 277 | 4.857843 | 13.45622511 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 390 | 4.749999999999999e-104 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g18730 | i0 | 96.983 | 27.3104693140794 | 232 | 7 | 84 | 0 | 1 | 232 | 232 | 1 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 7565 | 390 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 13955973 | 13955973 | PRJNA753704_P_NODE_15311_length_306_cov_4.592275_g14950_i0 | PRJNA753704 | 15311 | 306 | 4.592275 | 14.0523615 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 76.8 | 1.69e-9 | NTclustered | gi|299830252|ref|NC_014262.1| | 5885 | g14950 | i0 | 94 | 0.65359477124183 | 50 | 3 | 16 | 0 | 31 | 80 | 1441 | 1490 | Paramecium caudatum mitochondrion, complete genome | blastn | 200 | 76.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium caudatum | ||
| 14759874 | 14759874 | PRJNA753704_P_NODE_13452_length_325_cov_1.801587_g13091_i0 | PRJNA753704 | 13452 | 325 | 1.801587 | 5.85515775 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 568 | 2.4499999999999992e-157 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g13091 | i0 | 98.154 | 35.9907692307692 | 325 | 6 | 100 | 0 | 1 | 325 | 1014 | 690 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 11697 | 568 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 15230519 | 15230519 | PRJNA753704_P_NODE_12412_length_337_cov_2.268939_g12051_i0 | PRJNA753704 | 12412 | 337 | 2.268939 | 7.64632443 | Haptorida | 5989 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 4.08e-6 | NTclustered | gi|1226859313|gb|MF474356.1| | 394801 | g12051 | i0 | 74.857 | 12.4480712166172 | 175 | 29 | 51 | 12 | 1 | 172 | 1176 | 1338 | Lacrymaria marina isolate QZS2013110504 large subunit ribosomal RNA gene, partial sequence | blastn | 4195 | 65.8 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | Lacrymariidae | Lacrymaria | Lacrymaria marina | ||
| 16505021 | 16505021 | PRJNA753704_P_NODE_29773_length_231_cov_2.246835_g29412_i0 | PRJNA753704 | 29773 | 231 | 2.246835 | 5.19018885 | Lembadion | 54107 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 8.339999999999999e-101 | NTclustered | gi|7839503|gb|AF255358.1| | 54108 | g29412 | i0 | 96.522 | 90.6580086580087 | 230 | 7 | 99 | 1 | 1 | 230 | 177 | 405 | Lembadion bullinum small subunit ribosomal RNA gene, partial sequence | blastn | 20942 | 379 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Lembadionidae | Lembadion | Lembadion bullinum | ||
| 17309286 | 17309286 | PRJNA753704_P_NODE_31314_length_201_cov_4.109375_g30953_i0 | PRJNA753704 | 31314 | 201 | 4.109375 | 8.25984375 | Caryotricha minuta | 1004043 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 4.5599999999999997e-48 | NTclustered | gi|759083508|gb|KM222125.1| | 1004043 | g30953 | i0 | 93.431 | 68.2587064676617 | 137 | 9 | 68 | 0 | 3 | 139 | 1148 | 1284 | Caryotricha minuta voucher LWW07112802 large subunit ribosomal RNA gene, partial sequence | blastn | 13720 | 204 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Kiitrichida | Kiitrichidae | Caryotricha | Caryotricha minuta | ||
| 17309311 | 17309311 | PRJNA753704_P_NODE_5734_length_477_cov_32.215347_g5373_i0 | PRJNA753704 | 5734 | 477 | 32.215347 | 153.66720519 | Uronema marinum | 35107 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 1.1399999999999999e-87 | NTclustered | gi|1464314795|ref|NC_039174.1| | 35107 | g5373 | i0 | 82.338 | 51.0691823899371 | 402 | 57 | 83 | 11 | 82 | 476 | 7619 | 8013 | Uronema marinum mitochondrion, complete genome | blastn | 24360 | 337 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Uronematidae | Uronema | Uronema marinum | ||
| 17309351 | 17309351 | PRJNA753704_P_NODE_9354_length_383_cov_3.196774_g8993_i0 | PRJNA753704 | 9354 | 383 | 3.196774 | 12.24364442 | Tetrahymena paravorax | 5905 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 1.99e-69 | NTclustered | gi|114329857|ref|NC_008338.1| | 5905 | g8993 | i0 | 80.601 | 14.0992167101828 | 366 | 63 | 95 | 6 | 22 | 383 | 11131 | 11492 | Tetrahymena paravorax mitochondrion, complete genome | blastn | 5400 | 276 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena paravorax | ||
| 18583052 | 18583052 | PRJNA753704_P_NODE_6895_length_440_cov_7.667575_g6534_i0 | PRJNA753704 | 6895 | 440 | 7.667575 | 33.73733 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 616 | 1.2e-171 | NTclustered | gi|1389870282|gb|MH356267.1| | 1654720 | g6534 | i0 | 91.928 | 17.5613636363636 | 446 | 26 | 100 | 9 | 1 | 440 | 375 | 816 | Chilodonella piscicola strain SC small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 7727 | 616 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 19858217 | 19858217 | PRJNA753704_P_NODE_676_length_1280_cov_18.927920_g478_i0 | PRJNA753704 | 676 | 1280 | 18.92792 | 242.277376 | Platyophrya bromelicola | 767776 | SAR_Eukaryotes | SAR_Eukaryotes | 1081 | 0 | NTclustered | gi|296939569|gb|HM246415.1| | 767776 | g478 | i0 | 87.054 | 34.809375 | 981 | 97 | 75 | 22 | 22 | 983 | 970 | 1 | Platyophrya bromelicola isolate Plbr1 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 44556 | 1081 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Cyrtolophosidida | Platyophryidae | Platyophrya | Platyophrya bromelicola | ||
| 19858228 | 19858228 | PRJNA753704_P_NODE_8356_length_403_cov_17.739394_g7995_i0 | PRJNA753704 | 8356 | 403 | 17.739394 | 71.48975782 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 494 | 5.34e-135 | NTclustered | gi|347439269|gb|JN111982.1| | 151077 | g7995 | i0 | 88.861 | 18.1637717121588 | 404 | 41 | 100 | 3 | 1 | 403 | 416 | 16 | Chilodonella uncinata strain USA_WH small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 7320 | 494 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 20328430 | 20328430 | PRJNA753704_P_NODE_14036_length_318_cov_77.665306_g13675_i0 | PRJNA753704 | 14036 | 318 | 77.665306 | 246.97567308 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 231 | 3.57e-56 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g13675 | i0 | 97.08 | 1.29245283018868 | 137 | 4 | 43 | 0 | 1 | 137 | 2946 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 411 | 231 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 21604309 | 21604309 | PRJNA753704_P_NODE_737_length_1235_cov_608.403614_g520_i0 | PRJNA753704 | 737 | 1235 | 608.403614 | 7513.7846329 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 1498 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g520 | i0 | 95.802 | 45.119028340081 | 929 | 37 | 75 | 2 | 2 | 929 | 928 | 1 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 55722 | 1498 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 22408357 | 22408357 | PRJNA753704_P_NODE_1298_length_956_cov_22.070215_g1004_i0 | PRJNA753704 | 1298 | 956 | 22.070215 | 210.9912554 | Tetrahymena paravorax | 5905 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 1.17e-50 | NTclustered | gi|114329857|ref|NC_008338.1| | 5905 | g1004 | i0 | 78.846 | 6.99163179916318 | 364 | 43 | 36 | 22 | 553 | 896 | 2895 | 3244 | Tetrahymena paravorax mitochondrion, complete genome | blastn | 6684 | 215 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena paravorax | ||
| 23684134 | 23684134 | PRJNA753704_P_NODE_29239_length_235_cov_5.253086_g28878_i0 | PRJNA753704 | 29239 | 235 | 5.253086 | 12.3447521 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 8.33e-116 | NTclustered | gi|111035921|emb|AJ781306.1| | 5908 | g28878 | i0 | 99.574 | 90.8212765957447 | 235 | 1 | 100 | 0 | 1 | 235 | 317 | 551 | Tetrahymena pyriformis partial 23S rRNA gene, strain CCAP 1630/1W | blastn | 21343 | 429 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 23684163 | 23684163 | PRJNA753704_P_NODE_3699_length_582_cov_8.227898_g3342_i0 | PRJNA753704 | 3699 | 582 | 8.227898 | 47.88636636 | Helicoprorodon maximus | 1607784 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 1.47e-62 | NTclustered | gi|759083537|gb|KM222154.1| | 1607784 | g3342 | i0 | 77.878 | 55.3264604810997 | 443 | 75 | 75 | 18 | 144 | 581 | 698 | 1122 | Helicoprorodon maximus voucher XY10100902 large subunit ribosomal RNA gene, partial sequence | blastn | 32200 | 254 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | Helicoprorodontidae | Helicoprorodon | Helicoprorodon maximus |
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);;