contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA853194" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2115396 | 2115396 | PRJNA853194_S_NODE_2222_length_1123_cov_84.848571_g1708_i0 | PRJNA853194 | 2222 | 1123 | 84.848571 | 952.84945233 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.032 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g1708 | i0 | 100 | 0.0258236865538736 | 29 | 0 | 3 | 0 | 1095 | 1123 | 37 | 9 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 2115419 | 2115419 | PRJNA853194_S_NODE_23222_length_422_cov_2.292264_g22131_i0 | PRJNA853194 | 23222 | 422 | 2.292264 | 9.67335408 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g22131 | i0 | 96.97 | 0.353080568720379 | 33 | 1 | 8 | 0 | 390 | 422 | 42 | 10 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 149 | 56.5 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 5943200 | 5943200 | PRJNA853194_S_NODE_2385_length_1091_cov_93.768173_g1708_i1 | PRJNA853194 | 2385 | 1091 | 93.768173 | 1023.01076743 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.031 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g1708 | i1 | 100 | 0.0265811182401467 | 29 | 0 | 3 | 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 | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 5943216 | 5943216 | PRJNA853194_S_NODE_24365_length_414_cov_6.032258_g23274_i0 | PRJNA853194 | 24365 | 414 | 6.032258 | 24.97354812 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.011 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g23274 | i0 | 100 | 0.13768115942029 | 29 | 0 | 7 | 0 | 386 | 414 | 37 | 9 | 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 | |||
| 8494035 | 8494035 | PRJNA853194_S_NODE_79827_length_247_cov_1.419540_g78736_i0 | PRJNA853194 | 79827 | 247 | 1.41954 | 3.5062638 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g78736 | i0 | 100 | 0.57085020242915 | 29 | 0 | 12 | 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 | ||
| 11044920 | 11044920 | PRJNA853194_S_NODE_9249_length_616_cov_114.622468_g8225_i0 | PRJNA853194 | 9249 | 616 | 114.622468 | 706.07440288 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.017 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g8225 | i0 | 100 | 0.0470779220779221 | 29 | 0 | 5 | 0 | 588 | 616 | 37 | 9 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 12319353 | 12319353 | PRJNA853194_S_NODE_28790_length_387_cov_8.627389_g27699_i0 | PRJNA853194 | 28790 | 387 | 8.627389 | 33.38799543 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.01 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g27699 | i0 | 100 | 0.364341085271318 | 29 | 0 | 7 | 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 | ||
| 12320484 | 12320484 | PRJNA853194_S_NODE_8710_length_632_cov_18.957066_g7699_i0 | PRJNA853194 | 8710 | 632 | 18.957066 | 119.80865712 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.017 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g7699 | i0 | 100 | 0.0458860759493671 | 29 | 0 | 5 | 0 | 604 | 632 | 37 | 9 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 13594070 | 13594070 | PRJNA853194_S_NODE_38631_length_344_cov_1.092251_g37540_i0 | PRJNA853194 | 38631 | 344 | 1.092251 | 3.75734344 | Remanella sp. 1 BS-2022 | 2930476 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.009 | NTclustered | gi|2261269021|emb|OX095846.1| | 2930476 | g37540 | i0 | 94.444 | 0.348837209302326 | 36 | 0 | 10 | 2 | 310 | 344 | 46 | 12 | Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) | blastn | 120 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Loxodida | Loxodidae | Remanella | Remanella sp. 1 BS-2022 | ||
| 14868228 | 14868228 | PRJNA853194_S_NODE_3572_length_921_cov_162.852594_g2864_i0 | PRJNA853194 | 3572 | 921 | 162.852594 | 1499.87239074 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.026 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g2864 | i0 | 100 | 0.0694896851248643 | 29 | 0 | 3 | 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 | 64 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 16143481 | 16143481 | PRJNA853194_S_NODE_5713_length_761_cov_158.324128_g4832_i0 | PRJNA853194 | 5713 | 761 | 158.324128 | 1204.84661408 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.021 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g4832 | i0 | 100 | 0.038107752956636 | 29 | 0 | 4 | 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 | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 18691023 | 18691023 | PRJNA853194_S_NODE_10815_length_576_cov_5.614314_g9766_i0 | PRJNA853194 | 10815 | 576 | 5.614314 | 32.33844864 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.016 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g9766 | i0 | 100 | 0.0503472222222222 | 29 | 0 | 5 | 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 | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 19966253 | 19966253 | PRJNA853194_S_NODE_12916_length_535_cov_3.417749_g11841_i0 | PRJNA853194 | 12916 | 535 | 3.417749 | 18.28495715 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.015 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g11841 | i0 | 100 | 0.0542056074766355 | 29 | 0 | 5 | 0 | 507 | 535 | 37 | 9 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 22516786 | 22516786 | PRJNA853194_S_NODE_2618_length_1051_cov_6.383436_g2028_i0 | PRJNA853194 | 2618 | 1051 | 6.383436 | 67.08991236 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.03 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g2028 | i0 | 100 | 0.027592768791627 | 29 | 0 | 3 | 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 | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 22517089 | 22517089 | PRJNA853194_S_NODE_40578_length_336_cov_32.604563_g39487_i0 | PRJNA853194 | 40578 | 336 | 32.604563 | 109.55133168 | Aspidisca cf. leptaspis | 2994701 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 6.58e-29 | NTclustered | gi|2328859117|gb|OP828522.1| | 2994701 | g39487 | i0 | 88.696 | 27.1220238095238 | 115 | 13 | 34 | 0 | 222 | 336 | 662 | 776 | Aspidisca cf. leptaspis isolate LCY2018040104 large subunit ribosomal RNA gene, partial sequence | blastn | 9113 | 141 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Aspidiscidae | Aspidisca | Aspidisca cf. leptaspis | ||
| 22517485 | 22517485 | PRJNA853194_S_NODE_61518_length_279_cov_2.504854_g60427_i0 | PRJNA853194 | 61518 | 279 | 2.504854 | 6.98854266 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.026 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g60427 | i0 | 100 | 0.100358422939068 | 28 | 0 | 10 | 0 | 1 | 28 | 10 | 37 | 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 | |||
| 23793467 | 23793467 | PRJNA853194_S_NODE_86499_length_235_cov_80.481481_g85408_i0 | PRJNA853194 | 86499 | 235 | 80.481481 | 189.13148035 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g85408 | i0 | 100 | 0.6 | 29 | 0 | 12 | 0 | 207 | 235 | 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 | ||
| 23793504 | 23793504 | PRJNA853194_S_NODE_9619_length_605_cov_68.394737_g8587_i0 | PRJNA853194 | 9619 | 605 | 68.394737 | 413.78815885 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.017 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g8587 | i0 | 100 | 0.0479338842975207 | 29 | 0 | 5 | 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 | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 |
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);;