contig_metadata
8 rows where bioproject = "PRJNA408129" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1082736 | 1082736 | PRJNA408129_S_NODE_34741_length_151_cov_5.491228_g34723_i0 | PRJNA408129 | 34741 | 151 | 5.4912280000000004 | 8.29175428 | Oxytricha | 5943 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 1.89e-60 | NTclustered | gi|1859609462|gb|MT640772.1| | 305490 | g34723 | i0 | 97.872 | 93.3774834437086 | 141 | 3 | 93 | 0 | 11 | 151 | 11 | 151 | Uncultured Hypotrichia clone OTU55.1 large subunit ribosomal RNA gene, partial sequence | blastn | 14100 | 244 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | uncultured Hypotrichia | |||||
| 6796211 | 6796211 | PRJNA408129_S_NODE_2746_length_311_cov_3.791971_g2728_i0 | PRJNA408129 | 2746 | 311 | 3.791971 | 11.79302981 | Sterkiella histriomuscorum | 94289 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 2.1799999999999999e-23 | NTclustered | gi|47176510|gb|AY618090.1| | 94289 | g2728 | i0 | 88.889 | 12.1736334405145 | 99 | 11 | 32 | 0 | 24 | 122 | 385 | 287 | Sterkiella histriomuscorum clone UGC1O0004_I02_R genomic sequence | blastn | 3786 | 122 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 11286077 | 11286077 | PRJNA408129_S_NODE_6229_length_251_cov_43.733645_g6211_i0 | PRJNA408129 | 6229 | 251 | 43.733645 | 109.77144895 | root | 1 | Root_unresolved | Root_unresolved | 388 | 1.5299999999999998e-103 | NTclustered | gi|10832|emb|X54512.1| | 5911 | g6211 | i0 | 99.078 | 77.2231075697211 | 217 | 1 | 86 | 1 | 28 | 243 | 8330 | 8114 | T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA | blastn | 19383 | 388 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 11897160 | 11897160 | PRJNA408129_S_NODE_10550_length_218_cov_4.348066_g10532_i0 | PRJNA408129 | 10550 | 218 | 4.348066 | 9.47878388 | Platyophryides magnus | 1003332 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 4.7499999999999994e-88 | NTclustered | gi|328684914|gb|HM122030.1| | 1003332 | g10532 | i0 | 94.954 | 98.8348623853211 | 218 | 6 | 99 | 5 | 3 | 218 | 49 | 263 | Platyophryides magnus isolate SNK09112401 macronuclear | blastn | 21546 | 337 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Cyrtolophosidida | Platyophryidae | Platyophryides | Platyophryides magnus | ||
| 14447467 | 14447467 | PRJNA408129_S_NODE_8332_length_233_cov_4.168367_g8314_i0 | PRJNA408129 | 8332 | 233 | 4.168367 | 9.71229511 | Paramecium polycaryum | 109354 | SAR_Eukaryotes | SAR_Eukaryotes | 374 | 3.9199999999999994e-99 | NTclustered | gi|1409630804|gb|MG953266.1| | 109354 | g8314 | i0 | 98.14 | 90.2231759656652 | 215 | 2 | 91 | 1 | 15 | 227 | 586 | 800 | Paramecium polycaryum isolate ChY12-6 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 21022 | 374 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium polycaryum | ||
| 16995924 | 16995924 | PRJNA408129_S_NODE_3034_length_303_cov_29.409774_g3016_i0 | PRJNA408129 | 3034 | 303 | 29.409774 | 89.11161522 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.44e-114 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g3016 | i0 | 94.565 | 8.42904290429043 | 276 | 13 | 91 | 2 | 17 | 291 | 362 | 88 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 2554 | 425 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 17660313 | 17660313 | PRJNA408129_S_NODE_32414_length_154_cov_9.333333_g32396_i0 | PRJNA408129 | 32414 | 154 | 9.333333 | 14.37333282 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 2.48e-69 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g32396 | i0 | 98.701 | 97.8701298701299 | 154 | 2 | 100 | 0 | 1 | 154 | 2782 | 2935 | Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 15072 | 274 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 30960274 | 30960274 | PRJNA408129_S_NODE_11194_length_214_cov_5.971751_g11176_i0 | PRJNA408129 | 11194 | 214 | 5.971751 | 12.77954714 | Sterkiella histriomuscorum | 94289 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 1.58e-9 | NR | ABU80576.1 | 94289 | g11176 | i0 | 79.4 | 1.00934579439252 | 34 | 7 | 47.7 | 0 | 203 | 102 | 60 | 93 | ABU80576.1 ribosomal protein L44 [Sterkiella histriomuscorum] | diamond | 216 | 59.7 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum |
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);;