contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA950981" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 933848 | 933848 | PRJNA950981_P_NODE_1121_length_867_cov_17.719144_g982_i0 | PRJNA950981 | 1121 | 867 | 17.719144 | 153.62497848 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 1463 | 0 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g982 | i0 | 97.123 | 57.5432525951557 | 869 | 22 | 100 | 3 | 1 | 867 | 1485 | 2352 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 49890 | 1463 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 933884 | 933884 | PRJNA950981_P_NODE_3781_length_495_cov_2.213270_g3606_i0 | PRJNA950981 | 3781 | 495 | 2.21327 | 10.9556865 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 800 | 0 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g3606 | i0 | 95.943 | 61.2565656565657 | 493 | 20 | 99 | 0 | 3 | 495 | 58 | 550 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 30322 | 800 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 4762243 | 4762243 | PRJNA950981_P_NODE_18104_length_249_cov_2.812500_g17928_i0 | PRJNA950981 | 18104 | 249 | 2.8125 | 7.003125 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 1.53e-93 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g17928 | i0 | 94.737 | 0.91566265060241 | 228 | 12 | 92 | 0 | 22 | 249 | 181 | 408 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 228 | 355 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 6036983 | 6036983 | PRJNA950981_P_NODE_1885_length_686_cov_3.119086_g1714_i0 | PRJNA950981 | 1885 | 686 | 3.119086 | 21.39692996 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1013 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g1714 | i0 | 97.627 | 58.0932944606414 | 590 | 14 | 86 | 0 | 97 | 686 | 1205 | 616 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 39852 | 1013 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 12741784 | 12741784 | PRJNA950981_P_NODE_4690_length_447_cov_5.802139_g4514_i0 | PRJNA950981 | 4690 | 447 | 5.802139 | 25.93556133 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 815 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g4514 | i0 | 99.553 | 97.82774049217 | 447 | 2 | 100 | 0 | 1 | 447 | 2358 | 2804 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 43729 | 815 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 14961669 | 14961669 | PRJNA950981_P_NODE_18152_length_249_cov_1.750000_g17976_i0 | PRJNA950981 | 18152 | 249 | 1.75 | 4.3575 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 1.57e-78 | NTclustered | gi|347439299|gb|JN111998.1| | 151077 | g17976 | i0 | 88.8 | 1.00401606425703 | 250 | 26 | 100 | 2 | 1 | 249 | 118 | 366 | Chilodonella uncinata strain USA_SC2 actin gene, partial cds; macronuclear | blastn | 250 | 305 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 16236705 | 16236705 | PRJNA950981_P_NODE_5393_length_419_cov_1.803468_g5217_i0 | PRJNA950981 | 5393 | 419 | 1.803468 | 7.55653092 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 695 | 0 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g5217 | i0 | 96.651 | 58.326968973747 | 418 | 14 | 99 | 0 | 1 | 418 | 21 | 438 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 24439 | 695 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 16236711 | 16236711 | PRJNA950981_P_NODE_793_length_1018_cov_3.209524_g683_i0 | PRJNA950981 | 793 | 1018 | 3.209524 | 32.67295432 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1109 | 0 | NTclustered | gi|390195606|gb|JX112363.1| | 151077 | g683 | i0 | 91.358 | 83.5314341846758 | 810 | 70 | 80 | 0 | 1 | 810 | 122 | 931 | Chilodonella uncinata strain USA_SC2 beta-tubulin (Btub) gene, partial cds; macronuclear | blastn | 85035 | 1109 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 20388788 | 20388788 | PRJNA950981_P_NODE_5376_length_419_cov_9.997110_g5200_i0 | PRJNA950981 | 5376 | 419 | 9.99711 | 41.8878909 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 340 | 7.689999999999999e-89 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g5200 | i0 | 97.959 | 52.1073985680191 | 196 | 4 | 47 | 0 | 1 | 196 | 2887 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 21833 | 340 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 22610838 | 22610838 | PRJNA950981_P_NODE_18958_length_248_cov_0.891429_g18782_i0 | PRJNA950981 | 18958 | 248 | 0.891429 | 2.21074392 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 424 | 4.13e-114 | NTclustered | gi|110644972|gb|DQ665918.1| | 151077 | g18782 | i0 | 97.571 | 97.5362903225806 | 247 | 6 | 99 | 0 | 2 | 248 | 361 | 607 | Chilodonella uncinata clone 1 beta-tubulin gene, partial cds | blastn | 24189 | 424 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 23886198 | 23886198 | PRJNA950981_P_NODE_11019_length_308_cov_1.212766_g10843_i0 | PRJNA950981 | 11019 | 308 | 1.212766 | 3.73531928 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 4.21e-95 | NTclustered | gi|149394715|gb|EF125697.1| | 151077 | g10843 | i0 | 87.948 | 5.40584415584416 | 307 | 35 | 99 | 2 | 1 | 305 | 814 | 1120 | Chilodonella uncinata strain ATCC 50194 serine/threonine protein phosphatase-like gene, complete sequence; macronuclear | blastn | 1665 | 361 | 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);;