contig_metadata
20 rows where bioproject = "PRJNA429937" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1702328 | 1702328 | PRJNA429937_P_NODE_81622_length_360_cov_7.607251_g59182_i0 | PRJNA429937 | 81622 | 360 | 7.607251 | 27.3861036 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.034 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g59182 | i0 | 100 | 0.0777777777777778 | 28 | 0 | 8 | 0 | 333 | 360 | 39 | 12 | 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 | ||
| 2977800 | 2977800 | PRJNA429937_P_NODE_61143_length_441_cov_22.621359_g41230_i0 | PRJNA429937 | 61143 | 441 | 22.621359000000002 | 99.76019319 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 516 | 1.26e-141 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g41230 | i0 | 87.416 | 95.3492063492064 | 445 | 46 | 100 | 8 | 1 | 441 | 3769 | 3331 | Colpoda sp. isolate CIL1 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 | 42049 | 516 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 4252814 | 4252814 | PRJNA429937_P_NODE_127324_length_231_cov_2.202970_g104697_i0 | PRJNA429937 | 127324 | 231 | 2.20297 | 5.0888607 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 93.5 | 1.22e-14 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g104697 | i0 | 87.5 | 0.701298701298701 | 80 | 10 | 35 | 0 | 152 | 231 | 3790 | 3869 | Colpoda sp. isolate JGP15 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 | 162 | 93.5 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 4915881 | 4915881 | PRJNA429937_P_NODE_82564_length_357_cov_213.960366_g60091_i0 | PRJNA429937 | 82564 | 357 | 213.960366 | 763.83850662 | root | 1 | Root_unresolved | Root_unresolved | 494 | 4.67e-135 | NTclustered | gi|345541658|gb|JN547815.1| | 5911 | g60091 | i0 | 93.433 | 82.375350140056 | 335 | 19 | 94 | 3 | 24 | 357 | 2193 | 2525 | 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 | 29408 | 494 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 6805450 | 6805450 | PRJNA429937_P_NODE_96586_length_312_cov_4.402827_g73987_i0 | PRJNA429937 | 96586 | 312 | 4.402827 | 13.73682024 | Euplotes encysticus | 440145 | SAR_Eukaryotes | SAR_Eukaryotes | 555 | 1.8199999999999994e-153 | NTclustered | gi|759083524|gb|KM222141.1| | 440145 | g73987 | i0 | 99.67 | 93.7532051282051 | 303 | 1 | 97 | 0 | 1 | 303 | 1554 | 1856 | Euplotes encysticus voucher FXP2007122602 large subunit ribosomal RNA gene, partial sequence | blastn | 29251 | 555 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes encysticus | ||
| 8740224 | 8740224 | PRJNA429937_P_NODE_150087_length_181_cov_13.578947_g127460_i0 | PRJNA429937 | 150087 | 181 | 13.578947 | 24.57789407 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 1.08e-68 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g127460 | i0 | 95.322 | 95.0662983425414 | 171 | 8 | 94 | 0 | 4 | 174 | 2067 | 1897 | Colpoda sp. isolate JGP15 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 | 17207 | 274 | 0.992700729927007 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 9354595 | 9354595 | PRJNA429937_P_NODE_30208_length_662_cov_732.736177_g18357_i0 | PRJNA429937 | 30208 | 662 | 732.736177 | 4850.71349174 | Colpoda inflata | 5980 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 2.22e-46 | NTclustered | gi|759083543|gb|KM222160.1| | 5980 | g18357 | i0 | 98.261 | 18.6555891238671 | 115 | 1 | 17 | 1 | 1 | 114 | 1018 | 1132 | Colpoda inflata voucher SXK2011071402 large subunit ribosomal RNA gene, partial sequence | blastn | 12350 | 200 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda inflata | ||
| 10629640 | 10629640 | PRJNA429937_P_NODE_122309_length_242_cov_2861.915493_g99683_i0 | PRJNA429937 | 122309 | 242 | 2861.915493 | 6925.83549306 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 8.800000000000001e-101 | NTclustered | gi|1241841574|gb|KY273139.1| | 5908 | g99683 | i0 | 96.137 | 53.6570247933884 | 233 | 7 | 96 | 2 | 10 | 242 | 233 | 3 | Tetrahymena pyriformis isolate 1098-1 large subunit ribosomal RNA gene, partial sequence; macronuclear | blastn | 12985 | 379 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 11905696 | 11905696 | PRJNA429937_P_NODE_52290_length_487_cov_3258.561135_g34430_i0 | PRJNA429937 | 52290 | 487 | 3258.561135 | 15869.19272745 | Euplotes aediculatus | 5940 | SAR_Eukaryotes | SAR_Eukaryotes | 507 | 8.43e-139 | NTclustered | gi|6980030|gb|AF223571.1|AF223571 | 5940 | g34430 | i0 | 86.279 | 34.6611909650924 | 481 | 48 | 98 | 13 | 1 | 477 | 2296 | 2762 | Euplotes aediculatus internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 16880 | 507 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes aediculatus | ||
| 12566554 | 12566554 | PRJNA429937_P_NODE_76050_length_379_cov_1104.205714_g53891_i0 | PRJNA429937 | 76050 | 379 | 1104.205714 | 4184.93965606 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 577 | 4.8199999999999996e-160 | NTclustered | gi|220966760|gb|FJ545743.1| | 94289 | g53891 | i0 | 96.045 | 92.8759894459103 | 354 | 14 | 93 | 0 | 23 | 376 | 4016 | 4369 | Sterkiella histriomuscorum 17S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; macronuclear | blastn | 35200 | 577 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 14454634 | 14454634 | PRJNA429937_P_NODE_118232_length_253_cov_2.035714_g95606_i0 | PRJNA429937 | 118232 | 253 | 2.035714 | 5.15035642 | Tetrahymena paravorax | 5905 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 7.749999999999998e-47 | NTclustered | gi|126142780|gb|EF070253.1| | 5905 | g95606 | i0 | 100 | 71.6166007905138 | 108 | 0 | 43 | 0 | 146 | 253 | 149 | 256 | Tetrahymena paravorax strain RP 18S small subunit ribosomal RNA gene, partial sequence | blastn | 18119 | 200 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena paravorax | ||
| 15115190 | 15115190 | PRJNA429937_P_NODE_151412_length_176_cov_6.782313_g128785_i0 | PRJNA429937 | 151412 | 176 | 6.782313 | 11.93687088 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 1.7499999999999998e-66 | NTclustered | gi|759083543|gb|KM222160.1| | 5980 | g128785 | i0 | 94.318 | 97.2443181818182 | 176 | 5 | 100 | 4 | 1 | 176 | 1018 | 848 | Colpoda inflata voucher SXK2011071402 large subunit ribosomal RNA gene, partial sequence | blastn | 17115 | 265 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda inflata | ||
| 15115588 | 15115588 | PRJNA429937_P_NODE_82152_length_359_cov_2.633333_g59693_i0 | PRJNA429937 | 82152 | 359 | 2.633333 | 9.45366547 | Tintinnida | 200604 | SAR_Eukaryotes | SAR_Eukaryotes | 86.1 | 3.35e-12 | NTclustered | gi|759083534|gb|KM222151.1| | 1607860 | g59693 | i0 | 89.552 | 16.3788300835655 | 67 | 7 | 19 | 0 | 1 | 67 | 1518 | 1584 | Favella cf. campanula voucher JY08122201 large subunit ribosomal RNA gene, partial sequence | blastn | 5880 | 86.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Tintinnida | Xystonellidae | Favella | Favella cf. campanula | ||
| 17664865 | 17664865 | PRJNA429937_P_NODE_122614_length_242_cov_1.929577_g99988_i0 | PRJNA429937 | 122614 | 242 | 1.929577 | 4.66957634 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 7.46e-37 | NTclustered | gi|1802599793|gb|MT001202.1| | 41631 | g99988 | i0 | 96.97 | 49.9917355371901 | 99 | 3 | 73 | 0 | 1 | 99 | 1215 | 1313 | Colpoda sp. strain HFCC1281 small subunit ribosomal RNA gene, partial sequence | blastn | 12098 | 167 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 18278509 | 18278509 | PRJNA429937_P_NODE_50255_length_499_cov_11.355319_g32888_i0 | PRJNA429937 | 50255 | 499 | 11.355319 | 56.66304181 | Tetrahymena nigricans | 2704176 | SAR_Eukaryotes | SAR_Eukaryotes | 431 | 5.359999999999998e-116 | NTclustered | gi|2082965251|gb|MZ827091.1| | 2704176 | g32888 | i0 | 93.515 | 65.128256513026 | 293 | 13 | 86 | 5 | 185 | 476 | 789 | 502 | Tetrahymena nigricans isolate VB57 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 32499 | 431 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena nigricans | ||
| 20214031 | 20214031 | PRJNA429937_P_NODE_94216_length_319_cov_18.368966_g71626_i0 | PRJNA429937 | 94216 | 319 | 18.368966 | 58.59700154 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 525 | 1.4699999999999994e-144 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g71626 | i0 | 98.976 | 90.9341692789969 | 293 | 3 | 92 | 0 | 4 | 296 | 2958 | 2666 | 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 | 29008 | 525 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 21489056 | 21489056 | PRJNA429937_P_NODE_108897_length_277_cov_3.149194_g86276_i0 | PRJNA429937 | 108897 | 277 | 3.149194 | 8.72326738 | Tintinnida | 200604 | SAR_Eukaryotes | SAR_Eukaryotes | 86.1 | 2.51e-12 | NTclustered | gi|759083534|gb|KM222151.1| | 1607860 | g86276 | i0 | 89.552 | 21.2274368231047 | 67 | 7 | 24 | 0 | 1 | 67 | 1518 | 1584 | Favella cf. campanula voucher JY08122201 large subunit ribosomal RNA gene, partial sequence | blastn | 5880 | 86.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Tintinnida | Xystonellidae | Favella | Favella cf. campanula | ||
| 24653340 | 24653340 | PRJNA429937_P_NODE_59300_length_450_cov_7.370546_g39786_i0 | PRJNA429937 | 59300 | 450 | 7.370546 | 33.167457 | Halteria grandinella | 5974 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 2.67e-8 | NR | TNV87182.1 | 5974 | g39786 | i0 | 43.7 | 0.686666666666667 | 103 | 38 | 55.3 | 2 | 102 | 350 | 855 | 957 | TNV87182.1 hypothetical protein FGO68_gene9481 [Halteria grandinella] | diamond | 309 | 63.2 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 24653539 | 24653539 | PRJNA429937_P_NODE_69880_length_403_cov_8.304813_g48365_i0 | PRJNA429937 | 69880 | 403 | 8.304813 | 33.46839639 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.039 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g48365 | i0 | 100 | 0.0694789081885856 | 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 | |||
| 30739142 | 30739142 | PRJNA429937_P_NODE_140774_length_204_cov_2.262857_g118147_i0 | PRJNA429937 | 140774 | 204 | 2.262857 | 4.61622828 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 87.4 | 4.05e-18 | NR | XP_001030873.3 | 312017 | g118147 | i0 | 85.4 | 0.705882352941177 | 48 | 7 | 70.6 | 0 | 36 | 179 | 1023 | 1070 | XP_001030873.3 hypothetical protein TTHERM_01002750 [Tetrahymena thermophila SB210] | diamond | 144 | 87.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila |
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);;