contig_metadata
9 rows where bioproject = "PRJNA1226487" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1609709 | 1609709 | PRJNA1226487_P_NODE_73422_length_244_cov_2.385965_g73320_i0 | PRJNA1226487 | 73422 | 244 | 2.385965 | 5.8217546 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 5.429999999999998e-88 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g73320 | i0 | 92.083 | 6.00409836065574 | 240 | 17 | 98 | 2 | 1 | 239 | 308 | 70 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 1465 | 337 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 2885849 | 2885849 | PRJNA1226487_P_NODE_38383_length_291_cov_11.403670_g38281_i0 | PRJNA1226487 | 38383 | 291 | 11.40367 | 33.1846797 | Wilbertia typica | 655661 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 4.42e-15 | NTclustered | gi|1418575077|gb|MH577585.1| | 655661 | g38281 | i0 | 90.411 | 19.9553264604811 | 73 | 5 | 25 | 2 | 70 | 141 | 112 | 183 | Wilbertia typica isolate PXM100628 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 5807 | 95.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Eurystomatellidae | Wilbertia | Wilbertia typica | ||
| 8699833 | 8699833 | PRJNA1226487_P_NODE_42027_length_285_cov_1.452830_g41925_i0 | PRJNA1226487 | 42027 | 285 | 1.45283 | 4.1405655 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.026 | NTclustered | gi|2558939|gb|AF025312.1|AF025312 | 5911 | g41925 | i0 | 96.667 | 0.645614035087719 | 30 | 1 | 11 | 0 | 239 | 268 | 2810 | 2839 | Tetrahymena thermophila cytoplasmic dynein heavy chain 1a gene, partial cds | blastn | 184 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 27830820 | 27830820 | PRJNA1226487_P_NODE_74984_length_243_cov_1.811765_g74882_i0 | PRJNA1226487 | 74984 | 243 | 1.811765 | 4.40258895 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 78.6 | 9.43e-15 | NR | CDW83970.1 | 5949 | g74882 | i0 | 66.1 | 0.691358024691358 | 56 | 19 | 69.1 | 0 | 1 | 168 | 210 | 265 | CDW83970.1 snf2 family dna-dependent atpase [Stylonychia lemnae] | diamond | 168 | 78.6 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 28083371 | 28083371 | PRJNA1226487_P_NODE_81465_length_227_cov_3.961039_g81363_i0 | PRJNA1226487 | 81465 | 227 | 3.961039 | 8.99155853 | Paramecium sonneborni | 65129 | SAR_Eukaryotes | SAR_Eukaryotes | 57.4 | 2.09e-7 | NR | CAD8058350.1 | 65129 | g81363 | i0 | 39.1 | 1.62555066079295 | 64 | 39 | 84.6 | 0 | 9 | 200 | 806 | 869 | CAD8058350.1 unnamed protein product [Paramecium sonneborni] | diamond | 369 | 57.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 28133935 | 28133935 | PRJNA1226487_P_NODE_4065_length_597_cov_7.368321_g3973_i0 | PRJNA1226487 | 4065 | 597 | 7.368321 | 43.98887637 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 1.51e-43 | NR | CAD8061965.1 | 5886 | g3973 | i0 | 60.2 | 2.47738693467337 | 128 | 49 | 63.3 | 1 | 40 | 417 | 1 | 128 | CAD8061965.1 unnamed protein product [Paramecium primaurelia] | diamond | 1479 | 153 | 0.993464052287582 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 28430883 | 28430883 | PRJNA1226487_P_NODE_43306_length_283_cov_1.466667_g43204_i0 | PRJNA1226487 | 43306 | 283 | 1.466667 | 4.15066761 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 2.26e-34 | NR | CDW75137.1 | 5949 | g43204 | i0 | 77.7 | 0.996466431095406 | 94 | 21 | 99.6 | 0 | 282 | 1 | 1843 | 1936 | CDW75137.1 dynein heavy chain axonemal [Stylonychia lemnae] | diamond | 282 | 135 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 30389121 | 30389121 | PRJNA1226487_P_NODE_73633_length_244_cov_1.801170_g73531_i0 | PRJNA1226487 | 73633 | 244 | 1.80117 | 4.3948548 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 80.9 | 1.41e-15 | NR | CDW86533.1 | 5949 | g73531 | i0 | 71.2 | 0.639344262295082 | 52 | 15 | 63.9 | 0 | 242 | 87 | 3390 | 3441 | CDW86533.1 UNKNOWN [Stylonychia lemnae] | diamond | 156 | 80.9 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 31400122 | 31400122 | PRJNA1226487_P_NODE_49096_length_274_cov_1.532338_g48994_i0 | PRJNA1226487 | 49096 | 274 | 1.532338 | 4.19860612 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 1.62e-5 | NR | CDW84829.1 | 5949 | g48994 | i0 | 63.2 | 0.416058394160584 | 38 | 14 | 41.6 | 0 | 18 | 131 | 147 | 184 | CDW84829.1 UNKNOWN [Stylonychia lemnae] | diamond | 114 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae |
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);;