RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA1123436", tax_clade = "Sar" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 17 ✖

tax_clade 1

  • Sar · 17 ✖

bioproject 1

  • PRJNA1123436 · 17 ✖

analysis 1

tax_kingdom 0

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
279872 279872 PRJNA1123436_P_NODE_48561_length_359_cov_1.716783_g47347_i0 PRJNA1123436 48561 359 1.716783 6.16325097 Askenasia sp. LWW2010032604 1348343 SAR_Eukaryotes SAR_Eukaryotes 571 2.1099999999999993e-158   NTclustered gi|514076794|gb|KC771338.1| 1348343 g47347 i0 98.754 86.1782729805014 321 4 89 0 39 359 1858 1538 Askenasia sp. LWW2010032604 large subunit ribosomal RNA gene, partial sequence blastn 30938 571 1 Eukaryota Sar   Ciliophora Litostomatea Cyclotrichida Mesodiniidae Askenasia Askenasia sp. LWW2010032604
1029403 1029403 PRJNA1123436_P_NODE_29901_length_470_cov_2.503778_g28691_i0 PRJNA1123436 29901 470 2.503778 11.7677566 Spirotrichea 33829 SAR_Eukaryotes SAR_Eukaryotes 778 0   NTclustered gi|220966760|gb|FJ545743.1| 94289 g28691 i0 96.596 79.8042553191489 470 15 100 1 1 470 5985 5517 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 37508 778 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
1029682 1029682 PRJNA1123436_P_NODE_57241_length_329_cov_6.750000_g56027_i0 PRJNA1123436 57241 329 6.75 22.2075 Sporadotrichida 693921 SAR_Eukaryotes SAR_Eukaryotes 274 6.069999999999998e-69   NTclustered gi|984294594|gb|KT390055.1| 5949 g56027 i0 99.338 85.0851063829787 151 1 92 0 166 316 353 203 Stylonychia lemnae clone ZX28-0.2-32 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 27993 274 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
1554626 1554626 PRJNA1123436_P_NODE_57102_length_330_cov_1.182879_g55888_i0 PRJNA1123436 57102 330 1.182879 3.9035007 Askenasia sp. LWW2010032604 1348343 SAR_Eukaryotes SAR_Eukaryotes 468 2.6e-127   NTclustered gi|514076794|gb|KC771338.1| 1348343 g55888 i0 95.254 78.5181818181818 295 14 89 0 36 330 1858 1564 Askenasia sp. LWW2010032604 large subunit ribosomal RNA gene, partial sequence blastn 25911 468 1 Eukaryota Sar   Ciliophora Litostomatea Cyclotrichida Mesodiniidae Askenasia Askenasia sp. LWW2010032604
1554670 1554670 PRJNA1123436_P_NODE_59062_length_324_cov_3.131474_g57848_i0 PRJNA1123436 59062 324 3.131474 10.14597576 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 263 1.29e-65   NTclustered gi|984294524|gb|KT389985.1| 5949 g57848 i0 98.649 57.5030864197531 148 2 88 0 3 150 557 410 Stylonychia lemnae clone KJ47-0.2-34 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 18631 263 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
2304999 2304999 PRJNA1123436_P_NODE_57962_length_327_cov_6.964567_g56748_i0 PRJNA1123436 57962 327 6.964567 22.77413409 Codonellopsidae 211020 SAR_Eukaryotes SAR_Eukaryotes 274 6.03e-69   NTclustered gi|388540847|gb|JQ408174.1| 513285 g56748 i0 98.701 91.743119266055 154 2 93 0 13 166 1531 1684 Stenosemella ventricosa isolate CB73 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 30000 274 1 Eukaryota Sar   Ciliophora Spirotrichea Tintinnida Codonellopsidae Stenosemella Stenosemella ventricosa
3580199 3580199 PRJNA1123436_P_NODE_49723_length_354_cov_5.220641_g48509_i0 PRJNA1123436 49723 354 5.220641 18.48106914 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 309 1.8e-79   NTclustered gi|984294503|gb|KT389964.1| 5949 g48509 i0 98.295 89.3361581920904 176 3 92 0 163 338 378 203 Stylonychia lemnae clone KJ34-3-06 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 31625 309 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
4106810 4106810 PRJNA1123436_P_NODE_44224_length_378_cov_1.242623_g43010_i0 PRJNA1123436 44224 378 1.242623 4.69711494 Rimostrombidium veniliae 702563 SAR_Eukaryotes SAR_Eukaryotes 584 2.8699999999999987e-162   NTclustered gi|759083533|gb|KM222150.1| 702563 g43010 i0 97.929 87.5899470899471 338 6 89 1 1 338 1467 1803 Rimostrombidium veniliae voucher LWW07042901 large subunit ribosomal RNA gene, partial sequence blastn 33109 584 1 Eukaryota Sar   Ciliophora Spirotrichea Choreotrichida Strobilidiidae Rimostrombidium Rimostrombidium veniliae
6657679 6657679 PRJNA1123436_P_NODE_49826_length_354_cov_1.473310_g48612_i0 PRJNA1123436 49826 354 1.47331 5.2155174 Euplotes raikovi 5938 SAR_Eukaryotes SAR_Eukaryotes 95.3 5.49e-15   NTclustered gi|1233819906|gb|KX516598.1| 5938 g48612 i0 89.474 0.782485875706215 76 7 21 1 112 186 1488 1563 Euplotes raikovi isolate A305 large subunit ribosomal RNA gene, partial sequence blastn 277 95.3 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes raikovi
6657866 6657866 PRJNA1123436_P_NODE_59766_length_322_cov_5.562249_g58552_i0 PRJNA1123436 59766 322 5.5622490000000004 17.91044178 uncultured Spirotrichea 315739 SAR_Eukaryotes SAR_Eukaryotes 274 5.929999999999998e-69   NTclustered gi|724028125|gb|KP099784.1| 315739 g58552 i0 99.338 81.9658385093168 151 1 92 0 3 153 555 405 Uncultured spirotrich clone a39 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 26393 274 1 Eukaryota Sar   Ciliophora Spirotrichea       uncultured Spirotrichea
7407668 7407668 PRJNA1123436_P_NODE_68266_length_301_cov_6.157895_g67052_i0 PRJNA1123436 68266 301 6.157895 18.53526395 Laackmanniella 1229647 SAR_Eukaryotes SAR_Eukaryotes 268 2.56e-67   NTclustered gi|984294539|gb|KT390000.1| 1229648 g67052 i0 98.675 96.2691029900332 151 2 95 0 149 299 400 550 Laackmanniella prolongata clone KJ47-3-63 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 28977 268 1 Eukaryota Sar   Ciliophora Spirotrichea Tintinnida Codonellopsidae Laackmanniella Laackmanniella prolongata
9208170 9208170 PRJNA1123436_P_NODE_66988_length_304_cov_4.722944_g65774_i0 PRJNA1123436 66988 304 4.722944 14.35774976 Tintinnopsis hemispiralis 1891249 SAR_Eukaryotes SAR_Eukaryotes 274 5.55e-69   NTclustered gi|1838233079|gb|MT435060.1| 1891249 g65774 i0 99.338 96.3914473684211 151 1 81 0 141 291 245 95 Tintinnopsis hemispiralis isolate BY2018052801 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence. blastn 29303 274 1 Eukaryota Sar   Ciliophora Spirotrichea Tintinnida Codonellidae Tintinnopsis Tintinnopsis hemispiralis
11233177 11233177 PRJNA1123436_P_NODE_68269_length_301_cov_5.276316_g67055_i0 PRJNA1123436 68269 301 5.276316 15.88171116 Leprotintinnus 1050069 SAR_Eukaryotes SAR_Eukaryotes 274 5.49e-69   NTclustered gi|1057446256|gb|KX158685.1| 1572338 g67055 i0 99.338 95.0365448504983 151 1 96 0 2 152 372 222 Uncultured Tintinnida clone J39 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 28606 274 1 Eukaryota Sar   Ciliophora Spirotrichea Tintinnida     uncultured Tintinnida
14309003 14309003 PRJNA1123436_P_NODE_63012_length_314_cov_2.614108_g61798_i0 PRJNA1123436 63012 314 2.614108 8.20829912 uncultured Peritrichia 282477 SAR_Eukaryotes SAR_Eukaryotes 255 2.09e-63   NTclustered gi|1151071352|gb|KX926029.1| 282477 g61798 i0 97.959 56.2356687898089 147 3 95 0 154 300 840 694 Uncultured Peritrichia clone Peri974F_S_35 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 17658 255 1 Eukaryota Sar   Ciliophora Oligohymenophorea       uncultured Peritrichia
20681563 20681563 PRJNA1123436_P_NODE_60537_length_320_cov_12.068826_g59323_i0 PRJNA1123436 60537 320 12.068826 38.6202432 uncultured ciliate 187299 SAR_Eukaryotes SAR_Eukaryotes 171 7.94e-38   NTclustered gi|643012177|gb|KF541344.1| 187299 g59323 i0 90.698 40.696875 129 10 40 2 185 311 369 241 Uncultured ciliate clone E06_757_MCM2_1_LSU 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 13023 171 1 Eukaryota Sar   Ciliophora         uncultured ciliate
21431662 21431662 PRJNA1123436_P_NODE_61157_length_319_cov_2.272358_g59943_i0 PRJNA1123436 61157 319 2.272358 7.24882202 Vorticellidae 85904 SAR_Eukaryotes SAR_Eukaryotes 228 4.6299999999999985e-55   NTclustered gi|1151071366|gb|KX926043.1| 282477 g59943 i0 96.377 61.1504702194357 138 5 43 0 170 307 829 692 Uncultured Peritrichia clone Peri974F_S_42 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 19507 228 1 Eukaryota Sar   Ciliophora Oligohymenophorea       uncultured Peritrichia
24505895 24505895 PRJNA1123436_P_NODE_54260_length_338_cov_15.354717_g53046_i0 PRJNA1123436 54260 338 15.354717 51.89894346 Uroleptus gallina 57513 SAR_Eukaryotes SAR_Eukaryotes 287 8.040000000000001e-73   NTclustered gi|984294573|gb|KT390034.1| 57513 g53046 i0 97.605 83.103550295858 167 4 93 0 159 325 371 205 Uroleptus gallina clone ZX14-3-64 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 28089 287 1 Eukaryota Sar   Ciliophora Spirotrichea Urostylida Urostylidae Uroleptus Uroleptus gallina

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;