contig_metadata
9 rows where bioproject = "PRJNA482207", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6825531 | 6825531 | PRJNA482207_P_NODE_21306_length_249_cov_1.619318_g21196_i0 | PRJNA482207 | 21306 | 249 | 1.619318 | 4.03210182 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|149394719|gb|EF125701.1| | 151077 | g21196 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 222 | 249 | 49 | 22 | Chilodonella uncinata strain ATCC 50194 amidase-like gene, complete sequence; macronuclear | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 20849583 | 20849583 | PRJNA482207_P_NODE_22917_length_248_cov_0.880000_g22807_i0 | PRJNA482207 | 22917 | 248 | 0.88 | 2.1824 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|74039759|gb|DQ114962.1| | 5936 | g22807 | i0 | 100 | 0.116935483870968 | 29 | 0 | 12 | 0 | 220 | 248 | 37 | 9 | Moneuplotes crassus clone pEC14 putative MORN repeat protein (pEC14) gene, complete cds; macronuclear | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 22124475 | 22124475 | PRJNA482207_P_NODE_22918_length_248_cov_0.880000_g22808_i0 | PRJNA482207 | 22918 | 248 | 0.88 | 2.1824 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 86.7 | 1.41e-17 | NR | CDW73426.1 | 5949 | g22808 | i0 | 71.6 | 0.810483870967742 | 67 | 19 | 81 | 0 | 203 | 3 | 543 | 609 | CDW73426.1 abc transporter family protein [Stylonychia lemnae] | diamond | 201 | 86.7 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 28086869 | 28086869 | PRJNA482207_P_NODE_28485_length_243_cov_0.905882_g28375_i0 | PRJNA482207 | 28485 | 243 | 0.905882 | 2.20129326 | Paramecium primaurelia | 5886 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 8.49e-12 | NR | CAD8057762.1 | 5886 | g28375 | i0 | 45.5 | 1.90123456790123 | 77 | 38 | 92.6 | 3 | 17 | 241 | 504 | 578 | CAD8057762.1 unnamed protein product [Paramecium primaurelia] | diamond | 462 | 70.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 29050428 | 29050428 | PRJNA482207_P_NODE_20508_length_250_cov_0.870056_g20398_i0 | PRJNA482207 | 20508 | 250 | 0.870056 | 2.17514 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 87.4 | 6.98e-18 | NR | CAD8068133.1 | 65129 | g20398 | i0 | 56.8 | 5.388 | 74 | 30 | 88.8 | 1 | 9 | 230 | 213 | 284 | CAD8068133.1 unnamed protein product [Paramecium sonneborni] | diamond | 1347 | 87.8 | 0.995444191343964 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 29791817 | 29791817 | PRJNA482207_P_NODE_26471_length_245_cov_0.895349_g26361_i0 | PRJNA482207 | 26471 | 245 | 0.895349 | 2.19360505 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 4.78e-4 | NR | CDW76837.1 | 5949 | g26361 | i0 | 81.5 | 0.330612244897959 | 27 | 5 | 33.1 | 0 | 85 | 5 | 162 | 188 | CDW76837.1 UNKNOWN [Stylonychia lemnae] | diamond | 81 | 48.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 30581590 | 30581590 | PRJNA482207_P_NODE_29893_length_241_cov_0.916667_g29783_i0 | PRJNA482207 | 29893 | 241 | 0.916667 | 2.20916747 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0199 | NR | KRX07088.1 | 266149 | g29783 | i0 | 38.3 | 1.00829875518672 | 81 | 49 | 99.6 | 1 | 240 | 1 | 493 | 573 | KRX07088.1 hypothetical protein PPERSA_05252 [Pseudocohnilembus persalinus] | diamond | 243 | 43.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 30834553 | 30834553 | PRJNA482207_P_NODE_20514_length_250_cov_0.870056_g20404_i0 | PRJNA482207 | 20514 | 250 | 0.870056 | 2.17514 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 1.85e-7 | NR | CAG9313763.1 | 1481888 | g20404 | i0 | 47.5 | 0.708 | 59 | 28 | 68.4 | 3 | 243 | 73 | 66 | 123 | CAG9313763.1 unnamed protein product [Blepharisma stoltei] | diamond | 177 | 57.8 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 30866091 | 30866091 | PRJNA482207_P_NODE_25134_length_246_cov_0.890173_g25024_i0 | PRJNA482207 | 25134 | 246 | 0.890173 | 2.18982558 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 6.55e-16 | NR | XP_004037034.1 | 5932 | g25024 | i0 | 65.5 | 1.31707317073171 | 55 | 19 | 67.1 | 0 | 61 | 225 | 321 | 375 | XP_004037034.1 hypothetical protein IMG5_063030 [Ichthyophthirius multifiliis] | diamond | 324 | 81.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis |
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);;