contig_metadata
27 rows where bioproject = "PRJNA312107" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1652326 | 1652326 | PRJNA312107_P_NODE_1142_length_653_cov_9.293046_g993_i0 | PRJNA312107 | 1142 | 653 | 9.293046 | 60.68359038 | Aspidisca lynceus | 2035364 | SAR_Eukaryotes | SAR_Eukaryotes | 1027 | 0 | NTclustered | gi|2328859120|gb|OP828525.1| | 2035364 | g993 | i0 | 99.469 | 88.490045941807 | 565 | 3 | 87 | 0 | 89 | 653 | 1750 | 1186 | Aspidisca lynceus isolate LCY2015101602 large subunit ribosomal RNA gene, partial sequence | blastn | 57784 | 1027 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Aspidiscidae | Aspidisca | Aspidisca lynceus | ||
| 2928274 | 2928274 | PRJNA312107_P_NODE_25283_length_162_cov_2.442478_g25117_i0 | PRJNA312107 | 25283 | 162 | 2.442478 | 3.95681436 | Cyclidium glaucoma | 35100 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 2.03e-75 | NTclustered | gi|90657133|gb|DQ442791.1| | 35100 | g25117 | i0 | 99.383 | 12.4444444444444 | 162 | 1 | 100 | 0 | 1 | 162 | 467 | 628 | Cyclidium glaucoma isolate ES4 28S ribosomal RNA gene, partial sequence | blastn | 2016 | 294 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Cyclidiidae | Cyclidium | Cyclidium glaucoma | ||
| 3614215 | 3614215 | PRJNA312107_P_NODE_23343_length_164_cov_1.808696_g23177_i0 | PRJNA312107 | 23343 | 164 | 1.808696 | 2.96626144 | Spirostomum | 37867 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 3.42e-78 | NTclustered | gi|1859549041|gb|MT640277.1| | 60926 | g23177 | i0 | 100 | 100.15243902439 | 164 | 0 | 100 | 0 | 1 | 164 | 586 | 749 | Spirostomum sp. isolate 3S.teres-18S small subunit ribosomal RNA gene, partial sequence | blastn | 16425 | 303 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Spirostomidae | Spirostomum | Spirostomum sp. | ||
| 4204856 | 4204856 | PRJNA312107_P_NODE_3184_length_392_cov_18.335277_g3018_i0 | PRJNA312107 | 3184 | 392 | 18.335277 | 71.87428584 | uncultured ciliate | 187299 | SAR_Eukaryotes | SAR_Eukaryotes | 643 | 4.859999999999999e-180 | NTclustered | gi|221185880|gb|FJ577827.1| | 187299 | g3018 | i0 | 99.715 | 102.387755102041 | 351 | 1 | 90 | 0 | 42 | 392 | 1 | 351 | Uncultured ciliate clone Joinv03 18S ribosomal RNA gene, partial sequence | blastn | 40136 | 643 | 1 | Eukaryota | Sar | Ciliophora | uncultured ciliate | ||||||
| 6755203 | 6755203 | PRJNA312107_P_NODE_1246_length_626_cov_18.649913_g1093_i0 | PRJNA312107 | 1246 | 626 | 18.649913 | 116.74845538 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 758 | 0 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g1093 | i0 | 95.208 | 74.5063897763578 | 480 | 22 | 77 | 1 | 147 | 626 | 3849 | 3371 | 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 | 46641 | 758 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 7441549 | 7441549 | PRJNA312107_P_NODE_11626_length_213_cov_1.079268_g11460_i0 | PRJNA312107 | 11626 | 213 | 1.079268 | 2.29884084 | Cyclidium | 35099 | SAR_Eukaryotes | SAR_Eukaryotes | 383 | 5.8499999999999996e-102 | NTclustered | gi|1150566195|gb|KX578216.1| | 35100 | g11460 | i0 | 99.061 | 100.737089201878 | 213 | 2 | 100 | 0 | 1 | 213 | 378 | 590 | Cyclidium glaucoma isolate SUVRK07 18S ribosomal RNA gene, partial sequence | blastn | 21457 | 383 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Cyclidiidae | Cyclidium | Cyclidium glaucoma | ||
| 7441577 | 7441577 | PRJNA312107_P_NODE_3266_length_388_cov_1.784661_g3100_i0 | PRJNA312107 | 3266 | 388 | 1.784661 | 6.92448468 | Vorticellidae | 85904 | SAR_Eukaryotes | SAR_Eukaryotes | 497 | 3.96e-136 | NTclustered | gi|363412153|gb|JN120227.1| | 60850 | g3100 | i0 | 90.722 | 100.005154639175 | 388 | 15 | 100 | 9 | 1 | 388 | 598 | 964 | Vorticella convallaria isolate 96Vorsp16 18S ribosomal RNA gene, partial sequence | blastn | 38802 | 497 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella convallaria | ||
| 9305710 | 9305710 | PRJNA312107_P_NODE_6968_length_270_cov_1.597285_g6802_i0 | PRJNA312107 | 6968 | 270 | 1.597285 | 4.3126695 | Boveria subcylindrica | 693871 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 4.6799999999999997e-94 | NTclustered | gi|514076836|gb|KF256826.1| | 693871 | g6802 | i0 | 90.58 | 84.6740740740741 | 276 | 16 | 100 | 8 | 1 | 270 | 1102 | 1373 | Boveria subcylindrica isolate FXP2009030301 large subunit ribosomal RNA gene, partial sequence | blastn | 22862 | 357 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Thigmotrichida | Hemispeiridae | Boveria | Boveria subcylindrica | ||
| 11266834 | 11266834 | PRJNA312107_P_NODE_17689_length_173_cov_1.677419_g17523_i0 | PRJNA312107 | 17689 | 173 | 1.677419 | 2.90193487 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 1.03e-63 | NTclustered | gi|759083543|gb|KM222160.1| | 5980 | g17523 | i0 | 93.182 | 8.61271676300578 | 176 | 9 | 100 | 2 | 1 | 173 | 710 | 535 | Colpoda inflata voucher SXK2011071402 large subunit ribosomal RNA gene, partial sequence | blastn | 1490 | 255 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda inflata | ||
| 11856175 | 11856175 | PRJNA312107_P_NODE_11730_length_212_cov_1.239264_g11564_i0 | PRJNA312107 | 11730 | 212 | 1.239264 | 2.62723968 | Dexiostoma campyla | 5927 | SAR_Eukaryotes | SAR_Eukaryotes | 375 | 9.74e-100 | NTclustered | gi|174196|gb|M98366.1|CPDRRLSA | 5927 | g11564 | i0 | 98.585 | 87.3679245283019 | 212 | 3 | 100 | 0 | 1 | 212 | 95 | 306 | Colpidium campylum large subunit ribosomal RNA, 5' end | blastn | 18522 | 375 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Turaniellidae | Dexiostoma | Dexiostoma campyla | ||
| 13131310 | 13131310 | PRJNA312107_P_NODE_14391_length_192_cov_1.846154_g14225_i0 | PRJNA312107 | 14391 | 192 | 1.846154 | 3.54461568 | uncultured Scuticociliatia | 547477 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 1.15e-78 | NTclustered | gi|299778449|gb|GQ330629.1| | 547477 | g14225 | i0 | 96.237 | 94.2135416666667 | 186 | 7 | 97 | 0 | 7 | 192 | 294 | 109 | Uncultured Scuticociliatia clone PRS2c_4E_17 18S ribosomal RNA gene, partial sequence | blastn | 18089 | 305 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | uncultured Scuticociliatia | |||||
| 13131400 | 13131400 | PRJNA312107_P_NODE_25351_length_162_cov_1.637168_g25185_i0 | PRJNA312107 | 25351 | 162 | 1.637168 | 2.65221216 | Chaenea sp. FG-2015 | 1607874 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 1.64e-46 | NTclustered | gi|759083536|gb|KM222153.1| | 1607874 | g25185 | i0 | 88.889 | 101.283950617284 | 162 | 16 | 99 | 2 | 1 | 161 | 860 | 1020 | Chaenea sp. FG-2015 voucher FXP07122006 large subunit ribosomal RNA gene, partial sequence | blastn | 16408 | 198 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | Trachelophyllidae | Chaenea | Chaenea sp. FG-2015 | ||
| 13817018 | 13817018 | PRJNA312107_P_NODE_12791_length_204_cov_1.206452_g12625_i0 | PRJNA312107 | 12791 | 204 | 1.206452 | 2.46116208 | Spirotrichea | 33829 | SAR_Eukaryotes | SAR_Eukaryotes | 231 | 2.13e-56 | NTclustered | gi|1216628416|gb|KX099210.1| | 1560366 | g12625 | i0 | 88.205 | 95.5294117647059 | 195 | 21 | 95 | 2 | 11 | 204 | 409 | 216 | Pseudocyrtohymena koreana clone PK4 28S ribosomal RNA gene, partial sequence | blastn | 19488 | 231 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Pseudocyrtohymena | Pseudocyrtohymena koreana | ||
| 14406464 | 14406464 | PRJNA312107_P_NODE_11352_length_215_cov_1.819277_g11186_i0 | PRJNA312107 | 11352 | 215 | 1.819277 | 3.91144555 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 4.84e-63 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g11186 | i0 | 87.963 | 49.5116279069767 | 216 | 25 | 100 | 1 | 1 | 215 | 3930 | 3715 | 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 | 10645 | 254 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 15091359 | 15091359 | PRJNA312107_P_NODE_7732_length_257_cov_1.653846_g7566_i0 | PRJNA312107 | 7732 | 257 | 1.653846 | 4.25038422 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 9.24e-116 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g7566 | i0 | 96.875 | 59.0428015564202 | 256 | 8 | 99 | 0 | 1 | 256 | 3251 | 2996 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 15174 | 429 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 15680298 | 15680298 | PRJNA312107_P_NODE_11473_length_214_cov_1.539394_g11307_i0 | PRJNA312107 | 11473 | 214 | 1.539394 | 3.29430316 | Frontonia depressa | 3042678 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 4.9499999999999984e-43 | NTclustered | gi|2496410941|gb|OQ869833.1| | 3042678 | g11307 | i0 | 82.727 | 100.490654205607 | 220 | 28 | 100 | 8 | 1 | 214 | 1677 | 1462 | Frontonia depressa isolate S225 large subunit ribosomal RNA gene, partial sequence | blastn | 21505 | 187 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Frontoniidae | Frontonia | Frontonia depressa | ||
| 15680409 | 15680409 | PRJNA312107_P_NODE_2453_length_445_cov_2.181818_g2287_i0 | PRJNA312107 | 2453 | 445 | 2.181818 | 9.7090901 | Cyclidium glaucoma | 35100 | SAR_Eukaryotes | SAR_Eukaryotes | 695 | 0 | NTclustered | gi|90657161|gb|DQ442819.1| | 35100 | g2287 | i0 | 98.477 | 89.8516853932584 | 394 | 6 | 89 | 0 | 52 | 445 | 418 | 25 | Cyclidium glaucoma isolate ES45 28S ribosomal RNA gene, partial sequence | blastn | 39984 | 695 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Cyclidiidae | Cyclidium | Cyclidium glaucoma | ||
| 16366095 | 16366095 | PRJNA312107_P_NODE_18033_length_171_cov_2.557377_g17867_i0 | PRJNA312107 | 18033 | 171 | 2.557377 | 4.37311467 | Cyclidium | 35099 | SAR_Eukaryotes | SAR_Eukaryotes | 315 | 1.65e-81 | NTclustered | gi|91093110|gb|DQ442828.1| | 35100 | g17867 | i0 | 100 | 95.8304093567251 | 170 | 0 | 99 | 0 | 1 | 170 | 388 | 557 | Cyclidium glaucoma isolate ES4 18S ribosomal RNA gene, partial sequence | blastn | 16387 | 315 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Cyclidiidae | Cyclidium | Cyclidium glaucoma | ||
| 18229346 | 18229346 | PRJNA312107_P_NODE_4375_length_337_cov_1.177083_g4209_i0 | PRJNA312107 | 4375 | 337 | 1.177083 | 3.96676971 | Chaenea sp. FG-2015 | 1607874 | SAR_Eukaryotes | SAR_Eukaryotes | 501 | 2.63e-137 | NTclustered | gi|759083536|gb|KM222153.1| | 1607874 | g4209 | i0 | 93.472 | 99.9436201780415 | 337 | 22 | 100 | 0 | 1 | 337 | 1086 | 1422 | Chaenea sp. FG-2015 voucher FXP07122006 large subunit ribosomal RNA gene, partial sequence | blastn | 33681 | 501 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | Trachelophyllidae | Chaenea | Chaenea sp. FG-2015 | ||
| 18914962 | 18914962 | PRJNA312107_P_NODE_16995_length_177_cov_1.617188_g16829_i0 | PRJNA312107 | 16995 | 177 | 1.617188 | 2.86242276 | Hymenostomatida | 31277 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 4.799999999999999e-82 | NTclustered | gi|126142793|gb|EF070266.1| | 5928 | g16829 | i0 | 98.87 | 100.158192090395 | 177 | 2 | 100 | 0 | 1 | 177 | 749 | 573 | Colpidium colpoda 18S small subunit ribosomal RNA gene, partial sequence | blastn | 17728 | 316 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Turaniellidae | Colpidium | Colpidium colpoda | ||
| 20189709 | 20189709 | PRJNA312107_P_NODE_19956_length_168_cov_0.873950_g19790_i0 | PRJNA312107 | 19956 | 168 | 0.87395 | 1.468236 | root | 1 | Root_unresolved | Root_unresolved | 110 | 8.26e-20 | NTclustered | gi|2386226614|ref|XM_001430267.2| | 5888 | g19790 | i0 | 84.071 | 10.2083333333333 | 113 | 18 | 67 | 0 | 23 | 135 | 809 | 697 | Paramecium tetraurelia uncharacterized protein (GSPATT00032758001), partial mRNA | blastn | 1715 | 111 | 0.990990990990991 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 20779109 | 20779109 | PRJNA312107_P_NODE_19797_length_168_cov_0.873950_g19631_i0 | PRJNA312107 | 19797 | 168 | 0.87395 | 1.468236 | Cardiostomatella vermiformis | 311390 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 2.3e-20 | NTclustered | gi|404425895|gb|JX310024.1| | 311390 | g19631 | i0 | 86.667 | 2.44047619047619 | 105 | 9 | 63 | 2 | 1 | 105 | 2167 | 2266 | Cardiostomatella vermiformis voucher FXP2007101002 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 410 | 111 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Loxocephalidae | Cardiostomatella | Cardiostomatella vermiformis | ||
| 20779186 | 20779186 | PRJNA312107_P_NODE_4937_length_317_cov_7.182836_g4771_i0 | PRJNA312107 | 4937 | 317 | 7.182836 | 22.76959012 | Aspidisca lynceus | 2035364 | SAR_Eukaryotes | SAR_Eukaryotes | 534 | 2.42e-147 | NTclustered | gi|2328859120|gb|OP828525.1| | 2035364 | g4771 | i0 | 97.161 | 99.6750788643533 | 317 | 8 | 100 | 1 | 1 | 317 | 1152 | 837 | Aspidisca lynceus isolate LCY2015101602 large subunit ribosomal RNA gene, partial sequence | blastn | 31597 | 534 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Aspidiscidae | Aspidisca | Aspidisca lynceus | ||
| 22054110 | 22054110 | PRJNA312107_P_NODE_18338_length_170_cov_1.396694_g18172_i0 | PRJNA312107 | 18338 | 170 | 1.396694 | 2.3743798 | Prorodon ovum | 1348332 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 1.02e-53 | NTclustered | gi|514076796|gb|KC771340.1| | 1348332 | g18172 | i0 | 99.187 | 70.6294117647059 | 123 | 1 | 72 | 0 | 1 | 123 | 351 | 229 | Prorodon ovum isolate XY09022601 large subunit ribosomal RNA gene, partial sequence | blastn | 12007 | 222 | 1 | Eukaryota | Sar | Ciliophora | Prostomatea | Prorodontida | Prorodontidae | Prorodon | Prorodon ovum | ||
| 23329586 | 23329586 | PRJNA312107_P_NODE_11559_length_213_cov_2.304878_g11393_i0 | PRJNA312107 | 11559 | 213 | 2.304878 | 4.90939014 | Carchesium polypinum | 168244 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 2.76e-90 | NTclustered | gi|2304601474|gb|OP458295.1| | 168244 | g11393 | i0 | 95.775 | 96.3521126760563 | 213 | 9 | 100 | 0 | 1 | 213 | 1652 | 1440 | Carchesium polypinum large subunit ribosomal RNA gene, partial sequence | blastn | 20523 | 344 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Carchesium | Carchesium polypinum | ||
| 28481432 | 28481432 | PRJNA312107_P_NODE_18786_length_169_cov_0.866667_g18620_i0 | PRJNA312107 | 18786 | 169 | 0.866667 | 1.46466723 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 74.3 | 9.69e-14 | NR | KAL4453236.1 | 5901 | g18620 | i0 | 81.8 | 1.56213017751479 | 44 | 8 | 78.1 | 0 | 164 | 33 | 492 | 535 | KAL4453236.1 hypothetical protein ABPG73_022091 [Tetrahymena malaccensis] | diamond | 264 | 74.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 28905666 | 28905666 | PRJNA312107_P_NODE_19708_length_168_cov_0.873950_g19542_i0 | PRJNA312107 | 19708 | 168 | 0.87395 | 1.468236 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 3.67e-29 | NR | CDW71673.1 | 5949 | g19542 | i0 | 94.5 | 0.982142857142857 | 55 | 3 | 98.2 | 0 | 2 | 166 | 538 | 592 | CDW71673.1 ubiquitin-activating enzyme e1 family protein [Stylonychia lemnae] | diamond | 165 | 118 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae |
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);;