contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA753112" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004842 | 2004842 | PRJNA753112_P_NODE_1382_length_1187_cov_5.905745_g1165_i0 | PRJNA753112 | 1382 | 1187 | 5.905745 | 70.10119315 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 1125 | 0 | NTclustered | gi|1389870231|gb|MH356268.1| | 1654720 | g1165 | i0 | 88.665 | 21.2257792754844 | 944 | 79 | 78 | 21 | 259 | 1187 | 1 | 931 | Chilodonella piscicola strain PR small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 25195 | 1125 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 9657250 | 9657250 | PRJNA753112_P_NODE_1128_length_1334_cov_3.076130_g937_i0 | PRJNA753112 | 1128 | 1334 | 3.07613 | 41.0355742 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1927 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g937 | i0 | 95.522 | 38.328335832084 | 1206 | 52 | 90 | 2 | 48 | 1252 | 1 | 1205 | 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 | ||
| 11405515 | 11405515 | PRJNA753112_P_NODE_3269_length_756_cov_15.693997_g2952_i0 | PRJNA753112 | 3269 | 756 | 15.693997 | 118.64661732 | Helicoprorodontidae | 1607782 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 2.03e-27 | NTclustered | gi|375305434|gb|JF975394.1| | 652932 | g2952 | i0 | 90.385 | 15.0066137566138 | 104 | 10 | 18 | 0 | 293 | 396 | 206 | 309 | Trachelotractus entzi isolate LWW07033111 28S ribosomal RNA gene, partial sequence | blastn | 11345 | 137 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | Trachelotractus | Trachelotractus entzi | |||
| 12208758 | 12208758 | PRJNA753112_P_NODE_9910_length_431_cov_2.122905_g9568_i0 | PRJNA753112 | 9910 | 431 | 2.122905 | 9.14972055 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 568 | 3.34e-157 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g9568 | i0 | 90.465 | 26.5638051044084 | 430 | 41 | 99 | 0 | 2 | 431 | 290 | 719 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 11449 | 568 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 15230083 | 15230083 | PRJNA753112_P_NODE_18772_length_313_cov_2.537500_g18430_i0 | PRJNA753112 | 18772 | 313 | 2.5375 | 7.942375 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 553 | 6.579999999999998e-153 | NTclustered | gi|13194559|gb|AF300281.1|AF300281 | 151077 | g18430 | i0 | 98.413 | 98.1182108626198 | 315 | 3 | 100 | 1 | 1 | 313 | 319 | 5 | Chilodonella uncinata clone 1 18S small subunit ribosomal RNA gene, partial sequence | blastn | 30711 | 558 | 0.991039426523297 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 16031861 | 16031861 | PRJNA753112_P_NODE_4833_length_621_cov_1.846715_g4497_i0 | PRJNA753112 | 4833 | 621 | 1.846715 | 11.46810015 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 876 | 0 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g4497 | i0 | 92.11 | 94.5024154589372 | 621 | 49 | 100 | 0 | 1 | 621 | 1512 | 892 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 58686 | 876 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 19856164 | 19856164 | PRJNA753112_P_NODE_3156_length_771_cov_7.598854_g2842_i0 | PRJNA753112 | 3156 | 771 | 7.598854 | 58.58716434 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 1319 | 0 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g2842 | i0 | 97.539 | 52.5849546044099 | 772 | 17 | 100 | 2 | 1 | 771 | 1506 | 2276 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 40543 | 1319 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 21603583 | 21603583 | PRJNA753112_P_NODE_10457_length_419_cov_17.684971_g10115_i0 | PRJNA753112 | 10457 | 419 | 17.684971 | 74.10002849 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 5.94e-90 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g10115 | i0 | 98.462 | 51.9355608591885 | 195 | 3 | 47 | 0 | 1 | 195 | 2888 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 21761 | 344 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 22406171 | 22406171 | PRJNA753112_P_NODE_11118_length_407_cov_1.634731_g10776_i0 | PRJNA753112 | 11118 | 407 | 1.634731 | 6.65335517 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 525 | 1.9099999999999998e-144 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g10776 | i0 | 90.099 | 11.8108108108108 | 404 | 40 | 99 | 0 | 1 | 404 | 510 | 913 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 4807 | 525 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24955425 | 24955425 | PRJNA753112_P_NODE_18340_length_317_cov_0.959016_g17998_i0 | PRJNA753112 | 18340 | 317 | 0.959016 | 3.04008072 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 475 | 1.49e-129 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g17998 | i0 | 93.691 | 1.09148264984227 | 317 | 20 | 100 | 0 | 1 | 317 | 487 | 171 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 346 | 475 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24955482 | 24955482 | PRJNA753112_P_NODE_21500_length_293_cov_1.418182_g21158_i0 | PRJNA753112 | 21500 | 293 | 1.418182 | 4.15527326 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 420 | 6.469999999999998e-113 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g21158 | i0 | 92.491 | 12.7815699658703 | 293 | 22 | 100 | 0 | 1 | 293 | 406 | 114 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 3745 | 420 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 25428149 | 25428149 | PRJNA753112_P_NODE_16260_length_336_cov_4.152091_g15918_i0 | PRJNA753112 | 16260 | 336 | 4.152091 | 13.95102576 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 599 | 9.029999999999998e-167 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g15918 | i0 | 98.81 | 102.080357142857 | 336 | 4 | 100 | 0 | 1 | 336 | 2693 | 2358 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 34299 | 599 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola |
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);;