contig_metadata
11 rows where bioproject = "PRJNA415636", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1083271 | 1083271 | PRJNA415636_S_NODE_5781_length_215_cov_0.910714_g5734_i0 | PRJNA415636 | 5781 | 215 | 0.910714 | 1.9580351 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 3.85e-44 | NTclustered | gi|1236613276|gb|KX785362.1| | 5894 | g5734 | i0 | 100 | 44.5302325581395 | 103 | 0 | 48 | 0 | 1 | 103 | 401 | 503 | Tetrahymena canadensis voucher 50099 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence; macronuclear | blastn | 9574 | 191 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena canadensis | ||
| 5522887 | 5522887 | PRJNA415636_S_NODE_3785_length_254_cov_2.135266_g3738_i0 | PRJNA415636 | 3785 | 254 | 2.135266 | 5.42357564 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 4.55e-28 | NR | CAD8167353.1 | 43137 | g3738 | i0 | 63.4 | 7.77165354330709 | 82 | 30 | 96.9 | 0 | 253 | 8 | 71 | 152 | CAD8167353.1 unnamed protein product [Paramecium octaurelia] | diamond | 1974 | 110 | 0.990909090909091 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 6796863 | 6796863 | PRJNA415636_S_NODE_5906_length_213_cov_1.530120_g5859_i0 | PRJNA415636 | 5906 | 213 | 1.53012 | 3.2591556 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 8.069999999999998e-56 | NTclustered | gi|829195198|ref|XM_001025389.3| | 312017 | g5859 | i0 | 97.059 | 5.60093896713615 | 136 | 4 | 64 | 0 | 17 | 152 | 321 | 456 | Tetrahymena thermophila SB210 40S ribosomal protein S14 partial mRNA | blastn | 1193 | 230 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 9347243 | 9347243 | PRJNA415636_S_NODE_1588_length_351_cov_2.088816_g1541_i0 | PRJNA415636 | 1588 | 351 | 2.088816 | 7.33174416 | Remanella sp. 1 BS-2022 | 2930476 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|2261269021|emb|OX095846.1| | 2930476 | g1541 | i0 | 100 | 0.327635327635328 | 30 | 0 | 9 | 0 | 1 | 30 | 12 | 41 | Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) | blastn | 115 | 56.5 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Loxodida | Loxodidae | Remanella | Remanella sp. 1 BS-2022 | ||
| 9347244 | 9347244 | PRJNA415636_S_NODE_1848_length_333_cov_2.632867_g1801_i0 | PRJNA415636 | 1848 | 333 | 2.632867 | 8.76744711 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.009 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g1801 | i0 | 100 | 0.423423423423423 | 29 | 0 | 9 | 0 | 1 | 29 | 10 | 38 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 141 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 10011370 | 10011370 | PRJNA415636_S_NODE_3448_length_263_cov_7.550926_g3401_i0 | PRJNA415636 | 3448 | 263 | 7.550926 | 19.85893538 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 475 | 1.2e-129 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g3401 | i0 | 99.24 | 99.2433460076046 | 263 | 2 | 100 | 0 | 1 | 263 | 2922 | 2660 | 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 | 26101 | 475 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 11286558 | 11286558 | PRJNA415636_S_NODE_6189_length_209_cov_2.191358_g6142_i0 | PRJNA415636 | 6189 | 209 | 2.191358 | 4.57993822 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 4.42e-103 | NTclustered | gi|1172880852|gb|KY864168.1| | 5909 | g6142 | i0 | 100 | 99.9712918660287 | 209 | 0 | 100 | 0 | 1 | 209 | 153 | 361 | Tetrahymena rostrata isolate TR small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 20894 | 387 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 15721786 | 15721786 | PRJNA415636_S_NODE_813_length_433_cov_3.914508_g766_i0 | PRJNA415636 | 813 | 433 | 3.914508 | 16.94981964 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.012 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g766 | i0 | 100 | 0.131639722863741 | 29 | 0 | 7 | 0 | 1 | 29 | 9 | 37 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 57 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 21485000 | 21485000 | PRJNA415636_S_NODE_2037_length_321_cov_6.153285_g1990_i0 | PRJNA415636 | 2037 | 321 | 6.153285 | 19.75204485 | root | 1 | Root_unresolved | Root_unresolved | 577 | 4.02e-160 | NTclustered | gi|345541658|gb|JN547815.1| | 5911 | g1990 | i0 | 99.065 | 73.1183800623053 | 321 | 3 | 100 | 0 | 1 | 321 | 3487 | 3807 | Tetrahymena thermophila strain ATCC 30382 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence | blastn | 23471 | 577 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 31451183 | 31451183 | PRJNA415636_S_NODE_3996_length_249_cov_1.767327_g3949_i0 | PRJNA415636 | 3996 | 249 | 1.767327 | 4.40064423 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 65.1 | 4.87e-10 | NR | XP_001026118.2 | 312017 | g3949 | i0 | 63.8 | 1.69879518072289 | 47 | 17 | 56.6 | 0 | 5 | 145 | 335 | 381 | XP_001026118.2 transmembrane protein, putative, partial [Tetrahymena thermophila SB210] | diamond | 423 | 65.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 32035435 | 32035435 | PRJNA415636_S_NODE_5278_length_223_cov_1.159091_g5231_i0 | PRJNA415636 | 5278 | 223 | 1.159091 | 2.58477293 | Tetrahymena utriculariae | 2486642 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 6.25e-25 | NR | KAL4485779.1 | 2486642 | g5231 | i0 | 75 | 2.58295964125561 | 64 | 16 | 86.1 | 0 | 192 | 1 | 116 | 179 | KAL4485779.1 hypothetical protein ABPG72_012319 [Tetrahymena utriculariae] | diamond | 576 | 107 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena utriculariae |
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);;