contig_metadata
17 rows where bioproject = "PRJNA745553", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 724451 | 724451 | PRJNA745553_S_NODE_9201_length_398_cov_6.375385_g9006_i0 | PRJNA745553 | 9201 | 398 | 6.375385 | 25.3740323 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.038 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g9006 | i0 | 100 | 0.070351758793969807 | 28 | 0 | 7 | 0 | 1 | 28 | 11 | 38 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 2000457 | 2000457 | PRJNA745553_S_NODE_5482_length_488_cov_7.771084_g5288_i0 | PRJNA745553 | 5482 | 488 | 7.771084 | 37.92288992 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.048 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g5288 | i0 | 100 | 0.0573770491803279 | 28 | 0 | 6 | 0 | 1 | 28 | 12 | 39 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 3750292 | 3750292 | PRJNA745553_S_NODE_10283_length_378_cov_4.009836_g10088_i0 | PRJNA745553 | 10283 | 378 | 4.009836 | 15.15718008 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 1.51e-75 | NTclustered | gi|406718351|emb|HE819877.1| | 109352 | g10088 | i0 | 89.831 | 55.2830687830688 | 236 | 16 | 61 | 7 | 3 | 233 | 2613 | 2381 | Paramecium duboscqui genomic DNA containing 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, strain Ppd-3 | blastn | 20897 | 296 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium duboscqui | ||
| 4552667 | 4552667 | PRJNA745553_S_NODE_18764_length_285_cov_2.688679_g18569_i0 | PRJNA745553 | 18764 | 285 | 2.688679 | 7.66273515 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.026 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g18569 | i0 | 100 | 0.0982456140350877 | 28 | 0 | 10 | 0 | 1 | 28 | 12 | 39 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 5827858 | 5827858 | PRJNA745553_S_NODE_23845_length_253_cov_2.138889_g23650_i0 | PRJNA745553 | 23845 | 253 | 2.138889 | 5.41138917 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g23650 | i0 | 100 | 0.110671936758893 | 28 | 0 | 11 | 0 | 1 | 28 | 11 | 38 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 5827919 | 5827919 | PRJNA745553_S_NODE_27485_length_236_cov_3.693252_g27290_i0 | PRJNA745553 | 27485 | 236 | 3.693252 | 8.71607472 | Opercularia sp. ZhW-2019a | 2582953 | SAR_Eukaryotes | SAR_Eukaryotes | 436 | 4.999999999999999e-118 | NTclustered | gi|2304601486|gb|OP458307.1| | 2582953 | g27290 | i0 | 100 | 95.5296610169491 | 236 | 0 | 100 | 0 | 1 | 236 | 337 | 102 | Opercularia sp. ZhW-2019a large subunit ribosomal RNA gene, partial sequence | blastn | 22545 | 436 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Operculariidae | Opercularia | Opercularia sp. ZhW-2019a | ||
| 6302779 | 6302779 | PRJNA745553_S_NODE_9345_length_395_cov_9.413043_g9150_i0 | PRJNA745553 | 9345 | 395 | 9.413043 | 37.18151985 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 582 | 1.08e-161 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g9150 | i0 | 96.328 | 32.6151898734177 | 354 | 13 | 90 | 0 | 18 | 371 | 354 | 1 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 12883 | 582 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 7102995 | 7102995 | PRJNA745553_S_NODE_28126_length_232_cov_2.308176_g27931_i0 | PRJNA745553 | 28126 | 232 | 2.308176 | 5.35496832 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.021 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g27931 | i0 | 100 | 0.120689655172414 | 28 | 0 | 12 | 0 | 205 | 232 | 38 | 11 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 9652942 | 9652942 | PRJNA745553_S_NODE_9628_length_390_cov_5.331230_g9433_i0 | PRJNA745553 | 9628 | 390 | 5.33123 | 20.791797 | Remanella sp. 1 BS-2022 | 2930476 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.01 | NTclustered | gi|2261269021|emb|OX095846.1| | 2930476 | g9433 | i0 | 100 | 0.0743589743589744 | 29 | 0 | 7 | 0 | 1 | 29 | 14 | 42 | Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Loxodida | Loxodidae | Remanella | Remanella sp. 1 BS-2022 | ||
| 10928035 | 10928035 | PRJNA745553_S_NODE_13229_length_338_cov_6.588679_g13034_i0 | PRJNA745553 | 13229 | 338 | 6.588679 | 22.26973502 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.009 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g13034 | i0 | 100 | 0.440828402366864 | 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 | 149 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 10928309 | 10928309 | PRJNA745553_S_NODE_29609_length_216_cov_4.307692_g29414_i0 | PRJNA745553 | 29609 | 216 | 4.307692 | 9.30461472 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.005 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g29414 | i0 | 100 | 0.652777777777778 | 29 | 0 | 13 | 0 | 188 | 216 | 38 | 10 | 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 | ||
| 13478219 | 13478219 | PRJNA745553_S_NODE_5171_length_498_cov_7.691765_g4977_i0 | PRJNA745553 | 5171 | 498 | 7.691765 | 38.3049897 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 737 | 0 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g4977 | i0 | 97.669 | 83.0562248995984 | 429 | 10 | 86 | 0 | 23 | 451 | 988 | 1416 | Vorticella sp. 4 JG-2011 clone 2 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 | 41362 | 737 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 22401681 | 22401681 | PRJNA745553_S_NODE_24458_length_250_cov_3.259887_g24263_i0 | PRJNA745553 | 24458 | 250 | 3.259887 | 8.1497175 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g24263 | i0 | 94.444 | 0.144 | 36 | 1 | 14 | 1 | 1 | 36 | 13 | 47 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 36 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 27369162 | 27369162 | PRJNA745553_S_NODE_2203_length_638_cov_2.233628_g2029_i0 | PRJNA745553 | 2203 | 638 | 2.233628 | 14.25054664 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 146 | 1.24e-36 | NR | CAD8187874.1 | 43137 | g2029 | i0 | 42.4 | 2.83542319749216 | 198 | 108 | 92.2 | 3 | 628 | 41 | 458 | 651 | CAD8187874.1 unnamed protein product [Paramecium octaurelia] | diamond | 1809 | 146 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 29904887 | 29904887 | PRJNA745553_S_NODE_28571_length_229_cov_2.089744_g28376_i0 | PRJNA745553 | 28571 | 229 | 2.089744 | 4.78551376 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 1.3e-33 | NR | CDW72918.1 | 5949 | g28376 | i0 | 71.1 | 14.9082969432314 | 76 | 22 | 99.6 | 0 | 228 | 1 | 18 | 93 | CDW72918.1 protein mago nashi [Stylonychia lemnae] | diamond | 3414 | 123 | 0.991869918699187 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 29957921 | 29957921 | PRJNA745553_S_NODE_11411_length_362_cov_8.238754_g11216_i0 | PRJNA745553 | 11411 | 362 | 8.238754 | 29.82428948 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 1.39e-6 | NR | CDW86774.1 | 5949 | g11216 | i0 | 28.6 | 0.812154696132597 | 98 | 69 | 80.4 | 1 | 3 | 293 | 73 | 170 | CDW86774.1 UNKNOWN [Stylonychia lemnae] | diamond | 294 | 55.5 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 30495210 | 30495210 | PRJNA745553_S_NODE_17513_length_295_cov_1.765766_g17318_i0 | PRJNA745553 | 17513 | 295 | 1.765766 | 5.2090097 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 2.45e-16 | NR | CAG9319529.1 | 1481888 | g17318 | i0 | 65.4 | 1.05762711864407 | 52 | 18 | 52.9 | 0 | 293 | 138 | 307 | 358 | CAG9319529.1 unnamed protein product [Blepharisma stoltei] | diamond | 312 | 83.2 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei |
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);;