contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA1129273" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 283239 | 283239 | PRJNA1129273_P_NODE_1601_length_645_cov_10.473776_g1336_i0 | PRJNA1129273 | 1601 | 645 | 10.473776 | 67.5558552 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 989 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g1336 | i0 | 94.41 | 63.0186046511628 | 644 | 34 | 99 | 2 | 2 | 644 | 651 | 9 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 40647 | 989 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 1557828 | 1557828 | PRJNA1129273_P_NODE_2002_length_564_cov_5.482688_g1729_i0 | PRJNA1129273 | 2002 | 564 | 5.482688 | 30.92236032 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 822 | 0 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g1729 | i0 | 93.06 | 8.25709219858156 | 562 | 39 | 99 | 0 | 2 | 563 | 733 | 172 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 4657 | 822 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 6661096 | 6661096 | PRJNA1129273_P_NODE_10886_length_235_cov_2.561728_g10606_i0 | PRJNA1129273 | 10886 | 235 | 2.561728 | 6.0200608 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 1.8799999999999998e-82 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g10606 | i0 | 91.379 | 0.987234042553191 | 232 | 20 | 99 | 0 | 4 | 235 | 1575 | 1344 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 232 | 318 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 7409568 | 7409568 | PRJNA1129273_P_NODE_3886_length_367_cov_7.608844_g3606_i0 | PRJNA1129273 | 3886 | 367 | 7.608844 | 27.92445748 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 1.47e-70 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g3606 | i0 | 98.125 | 2.3841961852861 | 160 | 3 | 44 | 0 | 207 | 366 | 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 | ||
| 7409585 | 7409585 | PRJNA1129273_P_NODE_7086_length_271_cov_1.535354_g6806_i0 | PRJNA1129273 | 7086 | 271 | 1.535354 | 4.16080934 | root | 1 | Root_unresolved | Root_unresolved | 220 | 6.44e-53 | NTclustered | gi|159993|gb|M34540.1|PARCAM | 5888 | g6806 | i0 | 81.481 | 94.2509225092251 | 270 | 48 | 99 | 2 | 1 | 269 | 542 | 274 | P.tetraurelia calmodulin gene, complete cds | blastn | 25542 | 220 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 9211242 | 9211242 | PRJNA1129273_P_NODE_1428_length_698_cov_8.916800_g1168_i0 | PRJNA1129273 | 1428 | 698 | 8.9168 | 62.239264 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 907 | 0 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g1168 | i0 | 90.657 | 8.2621776504298 | 685 | 60 | 98 | 4 | 14 | 695 | 698 | 15 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 5767 | 907 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 9959779 | 9959779 | PRJNA1129273_P_NODE_4408_length_342_cov_2.750929_g4128_i0 | PRJNA1129273 | 4408 | 342 | 2.750929 | 9.40817718 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 616 | 9.139999999999999e-172 | NTclustered | gi|2223186636|gb|MW310239.1| | 151077 | g4128 | i0 | 99.123 | 94.6754385964912 | 342 | 3 | 100 | 0 | 1 | 342 | 12 | 353 | Chilodonella uncinata isolate 20200709 small subunit ribosomal RNA gene, partial sequence | blastn | 32379 | 621 | 0.99194847020934 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 10486774 | 10486774 | PRJNA1129273_P_NODE_5329_length_307_cov_0.978632_g5049_i0 | PRJNA1129273 | 5329 | 307 | 0.978632 | 3.00440024 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 472 | 1.86e-128 | NTclustered | gi|347439271|gb|JN111984.1| | 151077 | g5049 | i0 | 94.719 | 100.628664495114 | 303 | 16 | 99 | 0 | 5 | 307 | 914 | 612 | Chilodonella uncinata strain USA_SC2 clone SP1 beta tubulin (btub) gene, partial cds; macronuclear | blastn | 30893 | 472 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 11761842 | 11761842 | PRJNA1129273_P_NODE_11170_length_227_cov_2.006494_g10890_i0 | PRJNA1129273 | 11170 | 227 | 2.006494 | 4.55474138 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 6.269999999999998e-107 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g10890 | i0 | 98.667 | 58.2907488986784 | 225 | 3 | 99 | 0 | 2 | 226 | 247 | 23 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 13232 | 399 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 11761848 | 11761848 | PRJNA1129273_P_NODE_2330_length_512_cov_1.895216_g2054_i0 | PRJNA1129273 | 2330 | 512 | 1.895216 | 9.70350592 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 630 | 5.0599999999999985e-176 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g2054 | i0 | 88.998 | 44.6015625 | 509 | 56 | 99 | 0 | 3 | 511 | 648 | 140 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 22836 | 630 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 11761888 | 11761888 | PRJNA1129273_P_NODE_7990_length_258_cov_9.789189_g7710_i0 | PRJNA1129273 | 7990 | 258 | 9.789189 | 25.25610762 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 460 | 3.29e-125 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g7710 | i0 | 99.216 | 99.5930232558139 | 255 | 2 | 99 | 0 | 3 | 257 | 920 | 666 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 25695 | 460 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 13036959 | 13036959 | PRJNA1129273_P_NODE_3571_length_387_cov_1.703822_g3291_i0 | PRJNA1129273 | 3571 | 387 | 1.703822 | 6.59379114 | Tetmemena sp. Y1 | 1640447 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 2.64e-58 | NTclustered | gi|1227052606|gb|KY038460.1| | 1640447 | g3291 | i0 | 78.036 | 72.7312661498708 | 387 | 79 | 99 | 6 | 3 | 386 | 1625 | 1242 | Tetmemena sp. Y1 heat shock protein 70 (hsp70) gene, partial cds; macronuclear | blastn | 28147 | 239 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Tetmemena | Tetmemena sp. Y1 | ||
| 13036965 | 13036965 | PRJNA1129273_P_NODE_4911_length_322_cov_1.236948_g4631_i0 | PRJNA1129273 | 4911 | 322 | 1.236948 | 3.98297256 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 472 | 1.96e-128 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g4631 | i0 | 93.396 | 93.0869565217391 | 318 | 21 | 99 | 0 | 5 | 322 | 1044 | 727 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 29974 | 472 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 15586171 | 15586171 | PRJNA1129273_P_NODE_2993_length_433_cov_10.436111_g2714_i0 | PRJNA1129273 | 2993 | 433 | 10.436111 | 45.18836063 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 693 | 0 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g2714 | i0 | 95.804 | 9.4919168591224 | 429 | 18 | 99 | 0 | 4 | 432 | 22 | 450 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 4110 | 693 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 15586180 | 15586180 | PRJNA1129273_P_NODE_433_length_1340_cov_11.306235_g297_i0 | PRJNA1129273 | 433 | 1340 | 11.306235 | 151.503549 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1921 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g297 | i0 | 95.439 | 38.0716417910448 | 1206 | 53 | 90 | 2 | 50 | 1254 | 1 | 1205 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 51016 | 1921 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 19409127 | 19409127 | PRJNA1129273_P_NODE_3076_length_425_cov_8.059659_g2797_i0 | PRJNA1129273 | 3076 | 425 | 8.059659 | 34.25355075 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 623 | 6.919999999999998e-174 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g2797 | i0 | 93.16 | 60.3764705882353 | 424 | 29 | 99 | 0 | 1 | 424 | 14 | 437 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 25660 | 623 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 19409137 | 19409137 | PRJNA1129273_P_NODE_4436_length_341_cov_1.813433_g4156_i0 | PRJNA1129273 | 4436 | 341 | 1.813433 | 6.18380653 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 8.41e-48 | NTclustered | gi|662862628|gb|KJ000269.1| | 151077 | g4156 | i0 | 83.482 | 1.61876832844575 | 224 | 31 | 65 | 6 | 93 | 313 | 797 | 577 | Chilodonella uncinata strain ATCC PRA-256 clone P6 protein kinase domain containing protein gene, partial cds; macronuclear | blastn | 552 | 204 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 23983978 | 23983978 | PRJNA1129273_P_NODE_3079_length_425_cov_4.082386_g2800_i0 | PRJNA1129273 | 3079 | 425 | 4.082386 | 17.3501405 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 763 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2800 | i0 | 99.059 | 94.5905882352941 | 425 | 4 | 100 | 0 | 1 | 425 | 2373 | 2797 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 40201 | 763 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 25257996 | 25257996 | PRJNA1129273_P_NODE_6900_length_274_cov_1.512438_g6620_i0 | PRJNA1129273 | 6900 | 274 | 1.512438 | 4.14408012 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 1.77e-68 | NTclustered | gi|2386258192|ref|XM_001455088.2| | 5888 | g6620 | i0 | 85.24 | 80.6386861313869 | 271 | 33 | 98 | 5 | 1 | 269 | 1109 | 1374 | Paramecium tetraurelia uncharacterized protein (GSPATT00021361001), mRNA | blastn | 22095 | 274 | 0.992700729927007 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia |
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);;