contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA715462" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3257061 | 3257061 | PRJNA715462_P_NODE_30263_length_324_cov_1.533865_g29467_i0 | PRJNA715462 | 30263 | 324 | 1.533865 | 4.9697226 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 532 | 8.92e-147 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g29467 | i0 | 96.308 | 52.108024691358 | 325 | 10 | 100 | 2 | 1 | 324 | 225 | 548 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 16883 | 532 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 5809078 | 5809078 | PRJNA715462_P_NODE_18605_length_434_cov_8.855956_g17809_i0 | PRJNA715462 | 18605 | 434 | 8.855956 | 38.43484904 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 695 | 0 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g17809 | i0 | 95.612 | 9.47926267281106 | 433 | 19 | 99 | 0 | 2 | 434 | 450 | 18 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 4114 | 695 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 7085284 | 7085284 | PRJNA715462_P_NODE_9666_length_690_cov_2.119935_g8904_i0 | PRJNA715462 | 9666 | 690 | 2.119935 | 14.6275515 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 717 | 0 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g8904 | i0 | 85.507 | 21.0666666666667 | 690 | 96 | 99 | 4 | 1 | 688 | 224 | 911 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 14536 | 717 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 8845201 | 8845201 | PRJNA715462_P_NODE_17287_length_456_cov_3.994778_g16491_i0 | PRJNA715462 | 17287 | 456 | 3.994778 | 18.21618768 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 424 | 8.14e-114 | NTclustered | gi|10805|emb|X52242.1| | 5911 | g16491 | i0 | 84.296 | 93.0657894736842 | 433 | 68 | 95 | 0 | 23 | 455 | 478 | 46 | T.thermophila mRNA for calmodulin | blastn | 42438 | 424 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 8845231 | 8845231 | PRJNA715462_P_NODE_36107_length_293_cov_1.631818_g35311_i0 | PRJNA715462 | 36107 | 293 | 1.631818 | 4.78122674 | Oxytrichidae | 57506 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 1.5e-59 | NTclustered | gi|331686220|gb|HQ432924.1| | 94289 | g35311 | i0 | 85.169 | 46.8327645051195 | 236 | 35 | 81 | 0 | 41 | 276 | 1112 | 877 | Sterkiella histriomuscorum strain 310 heat shock protein 70 (hsp70) gene, complete cds; macronuclear | blastn | 13722 | 243 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 10120808 | 10120808 | PRJNA715462_P_NODE_28788_length_333_cov_1.776923_g27992_i0 | PRJNA715462 | 28788 | 333 | 1.776923 | 5.91715359 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 1.31e-75 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g27992 | i0 | 98.225 | 57.1471471471471 | 169 | 3 | 51 | 0 | 1 | 169 | 2914 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 19030 | 296 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 12185885 | 12185885 | PRJNA715462_P_NODE_8790_length_739_cov_4.157658_g8044_i0 | PRJNA715462 | 8790 | 739 | 4.157658 | 30.72509262 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1033 | 0 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g8044 | i0 | 91.881 | 7.44925575101488 | 739 | 60 | 100 | 0 | 1 | 739 | 914 | 176 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 5505 | 1033 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 13458901 | 13458901 | PRJNA715462_P_NODE_11611_length_605_cov_2.597744_g10827_i0 | PRJNA715462 | 11611 | 605 | 2.597744 | 15.7163512 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 573 | 1.03e-158 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g10827 | i0 | 86.538 | 13.7355371900826 | 520 | 70 | 86 | 0 | 86 | 605 | 539 | 20 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 8310 | 573 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 13459585 | 13459585 | PRJNA715462_P_NODE_3711_length_1335_cov_22.799525_g3234_i0 | PRJNA715462 | 3711 | 1335 | 22.799525 | 304.37365875 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1927 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g3234 | i0 | 95.522 | 38.2996254681648 | 1206 | 52 | 90 | 2 | 83 | 1287 | 1205 | 1 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 51130 | 1927 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 14734123 | 14734123 | PRJNA715462_P_NODE_10152_length_666_cov_7.672850_g9381_i0 | PRJNA715462 | 10152 | 666 | 7.67285 | 51.101181 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 900 | 0 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g9381 | i0 | 91.128 | 8.62912912912913 | 665 | 57 | 99 | 2 | 3 | 666 | 15 | 678 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 5747 | 900 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 16495173 | 16495173 | PRJNA715462_P_NODE_39553_length_282_cov_1.473684_g38757_i0 | PRJNA715462 | 39553 | 282 | 1.473684 | 4.15578888 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 521 | 1.6499999999999996e-143 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g38757 | i0 | 100 | 97.8829787234042 | 282 | 0 | 100 | 0 | 1 | 282 | 2055 | 2336 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 27603 | 521 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 18557988 | 18557988 | PRJNA715462_P_NODE_51295_length_251_cov_0.865169_g50499_i0 | PRJNA715462 | 51295 | 251 | 0.865169 | 2.17157419 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 2.92e-6 | NTclustered | gi|662862610|gb|KJ626299.1| | 151077 | g50499 | i0 | 95.122 | 0.163346613545817 | 41 | 2 | 16 | 0 | 73 | 113 | 336 | 296 | Chilodonella uncinata protein kinase domain containing protein-like gene, complete sequence; micronuclear | blastn | 41 | 65.8 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 18558117 | 18558117 | PRJNA715462_P_NODE_57855_length_247_cov_0.885057_g57059_i0 | PRJNA715462 | 57855 | 247 | 0.885057 | 2.18609079 | uncultured Oligohymenophorea | 300673 | SAR_Eukaryotes | SAR_Eukaryotes | 449 | 6.78e-122 | NTclustered | gi|2006881151|emb|HG996107.1| | 300673 | g57059 | i0 | 99.593 | 97.82995951417 | 246 | 1 | 99 | 0 | 1 | 246 | 677 | 922 | uncultured Oligohymenophorea genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, clone abb336d6 | blastn | 24164 | 449 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | uncultured Oligohymenophorea | |||||
| 19832299 | 19832299 | PRJNA715462_P_NODE_16356_length_474_cov_13.446384_g15560_i0 | PRJNA715462 | 16356 | 474 | 13.446384 | 63.73586016 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 664 | 0 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g15560 | i0 | 92.982 | 54.2025316455696 | 456 | 31 | 96 | 1 | 19 | 474 | 469 | 15 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 25692 | 664 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 19832359 | 19832359 | PRJNA715462_P_NODE_18356_length_439_cov_1.606557_g17560_i0 | PRJNA715462 | 18356 | 439 | 1.606557 | 7.05278523 | Pseudomicrothorax dubius | 39564 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 2.54e-4 | NTclustered | gi|1204322226|gb|AF039086.2| | 39564 | g17560 | i0 | 100 | 0.0728929384965831 | 32 | 0 | 7 | 0 | 220 | 251 | 869 | 900 | Pseudomicrothorax dubius articulin 1 mRNA, complete cds | blastn | 32 | 60.2 | 1 | Eukaryota | Sar | Ciliophora | Nassophorea | Microthoracida | Pseudomicrothoracidae | Pseudomicrothorax | Pseudomicrothorax dubius | ||
| 19832429 | 19832429 | PRJNA715462_P_NODE_20816_length_404_cov_1.664653_g20020_i0 | PRJNA715462 | 20816 | 404 | 1.664653 | 6.72519812 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 483 | 1.16e-131 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g20020 | i0 | 88.471 | 64.9678217821782 | 399 | 46 | 99 | 0 | 6 | 404 | 22 | 420 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 26247 | 483 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 19832828 | 19832828 | PRJNA715462_P_NODE_3836_length_1306_cov_10.985401_g3234_i1 | PRJNA715462 | 3836 | 1306 | 10.985401 | 143.46933706 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1539 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g3234 | i1 | 89.735 | 39.3384379785605 | 1208 | 118 | 92 | 5 | 54 | 1258 | 1205 | 1 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 51376 | 1539 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 23658700 | 23658700 | PRJNA715462_P_NODE_28119_length_338_cov_1.162264_g27323_i0 | PRJNA715462 | 28119 | 338 | 1.162264 | 3.92845232 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 1.69e-89 | NTclustered | gi|662862630|gb|KJ000270.1| | 151077 | g27323 | i0 | 85.119 | 6.11834319526627 | 336 | 48 | 99 | 2 | 1 | 335 | 218 | 552 | Chilodonella uncinata strain ATCC PRA-256 clone P7 protein kinase domain containing protein gene, partial cds; macronuclear | blastn | 2068 | 342 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 23659586 | 23659586 | PRJNA715462_P_NODE_7699_length_815_cov_2.424528_g6989_i0 | PRJNA715462 | 7699 | 815 | 2.424528 | 19.7599032 | Sterkiella nova | 200597 | SAR_Eukaryotes | SAR_Eukaryotes | 645 | 2.949999999999999e-180 | NTclustered | gi|331686226|gb|HQ432927.1| | 200597 | g6989 | i0 | 81.421 | 83.5116564417178 | 802 | 137 | 98 | 11 | 20 | 815 | 399 | 1194 | Sterkiella nova heat shock protein 70 (hsp70) gene, complete cds; macronuclear | blastn | 68062 | 645 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella nova |
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);;