RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJEB39269", tax_clade = "Sar" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 14 ✖

tax_clade 1

  • Sar · 14 ✖

bioproject 1

  • PRJEB39269 · 14 ✖

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
1331346 1331346 PRJEB39269_P_NODE_42582_length_210_cov_2.660819_g42177_i0 PRJEB39269 42582 210 2.660819 5.5877199 Tetrahymena rostrata 5909 SAR_Eukaryotes SAR_Eukaryotes 346 7.55e-91   NTclustered gi|1837628855|gb|MN158348.1| 5909 g42177 i0 97.073 93.9095238095238 205 6 98 0 1 205 4413 4209 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 19721 346 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
2606981 2606981 PRJEB39269_P_NODE_51483_length_191_cov_2.302632_g51078_i0 PRJEB39269 51483 191 2.302632 4.39802712 Dexiostoma campyla 5927 SAR_Eukaryotes SAR_Eukaryotes 353 4.02e-93   NTclustered gi|174196|gb|M98366.1|CPDRRLSA 5927 g51078 i0 100 64.6387434554974 191 0 100 0 1 191 81 271 Colpidium campylum large subunit ribosomal RNA, 5' end blastn 12346 353 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Turaniellidae Dexiostoma Dexiostoma campyla
3883209 3883209 PRJEB39269_P_NODE_72244_length_165_cov_5.936508_g71839_i0 PRJEB39269 72244 165 5.936508 9.7952382 Suctoria sp. 2006708 SAR_Eukaryotes SAR_Eukaryotes 268 1.26e-67   NTclustered gi|1200166538|gb|MF188934.1| 2006708 g71839 i0 96.341 89.6181818181818 164 5 99 1 2 165 280 442 Suctoria sp. isolate p_comp77811_c0_seq7 small subunit ribosomal RNA gene, partial sequence blastn 14787 268 1 Eukaryota Sar   Ciliophora Phyllopharyngea       Suctoria sp.
3883239 3883239 PRJEB39269_P_NODE_88624_length_152_cov_1.451327_g88219_i0 PRJEB39269 88624 152 1.451327 2.20601704 Aspidisca lynceus 2035364 SAR_Eukaryotes SAR_Eukaryotes 281 1.46e-71   NTclustered gi|2328859120|gb|OP828525.1| 2035364 g88219 i0 100 6.06578947368421 152 0 100 0 1 152 63 214 Aspidisca lynceus isolate LCY2015101602 large subunit ribosomal RNA gene, partial sequence blastn 922 281 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Aspidiscidae Aspidisca Aspidisca lynceus
5159412 5159412 PRJEB39269_P_NODE_69625_length_168_cov_3.077519_g69220_i0 PRJEB39269 69625 168 3.077519 5.17023192 Trithigmostoma cucullulus 1346499 SAR_Eukaryotes SAR_Eukaryotes 267 4.63e-67   NTclustered gi|759083539|gb|KM222156.1| 1346499 g69220 i0 95.238 1 168 8 100 0 1 168 378 545 Trithigmostoma cucullulus voucher CXM08110902 large subunit ribosomal RNA gene, partial sequence blastn 168 267 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Trithigmostoma Trithigmostoma cucullulus
7709426 7709426 PRJEB39269_P_NODE_31727_length_245_cov_6.509709_g31322_i0 PRJEB39269 31727 245 6.509709 15.94878705 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 409 1.1399999999999998e-109   NTclustered gi|512134950|gb|JX178909.1| 1295638 g31322 i0 96.735 86.5183673469388 245 8 100 0 1 245 1626 1382 Vorticella sp. 4 JG-2011 clone 9 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 21197 409 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
10259825 10259825 PRJEB39269_P_NODE_37169_length_226_cov_1.433155_g36764_i0 PRJEB39269 37169 226 1.433155 3.2389303 Philasterides dicentrarchi 282688 SAR_Eukaryotes SAR_Eukaryotes 191 4.09e-44   NTclustered gi|49616744|gb|AY643504.1| 282688 g36764 i0 85.484 31.3495575221239 186 24 82 3 42 226 1 184 Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence blastn 7085 191 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Philasteridae Philasterides Philasterides dicentrarchi
11535275 11535275 PRJEB39269_P_NODE_75250_length_162_cov_2.910569_g74845_i0 PRJEB39269 75250 162 2.910569 4.71512178 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 224 2.7e-54   NTclustered gi|10782|emb|X54004.1| 5908 g74845 i0 91.463 16.5308641975309 164 12 100 2 1 162 3260 3097 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 2678 224 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
12810563 12810563 PRJEB39269_P_NODE_19491_length_317_cov_15.838129_g19086_i0 PRJEB39269 19491 317 15.838129 50.20686893 Vorticella sp. 1 2979179 SAR_Eukaryotes SAR_Eukaryotes 575 1.4299999999999996e-159   NTclustered gi|2304601489|gb|OP458310.1| 2979179 g19086 i0 99.369 94.1261829652997 317 2 100 0 1 317 1482 1798 Vorticella sp. 1 large subunit ribosomal RNA gene, partial sequence blastn 29838 575 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 1
12810594 12810594 PRJEB39269_P_NODE_56411_length_183_cov_2.270833_g56006_i0 PRJEB39269 56411 183 2.270833 4.15562439 Carchesium polypinum 168244 SAR_Eukaryotes SAR_Eukaryotes 248 1.85e-61   NTclustered gi|237502287|gb|FJ810383.1| 168244 g56006 i0 97.902 7.27322404371585 143 3 78 0 1 143 869 1011 Carchesium polypinum isolate NR18 internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 1331 248 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Carchesium Carchesium polypinum
19182546 19182546 PRJEB39269_P_NODE_49276_length_195_cov_4.025641_g48871_i0 PRJEB39269 49276 195 4.025641 7.84999995 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 331 1.93e-86   NTclustered gi|512134943|gb|JX178902.1| 1295638 g48871 i0 97.436 100.117948717949 195 4 100 1 1 195 1094 1287 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 19523 331 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
19182578 19182578 PRJEB39269_P_NODE_78596_length_159_cov_4.133333_g78191_i0 PRJEB39269 78596 159 4.133333 6.57199947 Glaucoma scintillans 210825 SAR_Eukaryotes SAR_Eukaryotes 219 1.23e-52   NTclustered gi|2624665746|gb|OR878271.1| 210825 g78191 i0 92.208 20.5283018867925 154 12 97 0 6 159 1069 916 Glaucoma scintillans isolate LLH20220320 large subunit ribosomal RNA gene, partial sequence blastn 3264 219 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Glaucomidae Glaucoma Glaucoma scintillans
23009108 23009108 PRJEB39269_P_NODE_51519_length_191_cov_2.144737_g51114_i0 PRJEB39269 51519 191 2.144737 4.09644767 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 270 4.17e-68   NTclustered gi|194245783|gb|EU828456.1| 5888 g51114 i0 92.147 100.65445026178 191 15 100 0 1 191 1734 1544 Paramecium tetraurelia large subunit ribosomal RNA gene, complete sequence blastn 19225 270 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
24282847 24282847 PRJEB39269_P_NODE_60920_length_177_cov_1.188406_g60515_i0 PRJEB39269 60920 177 1.188406 2.10347862 Trithigmostoma cucullulus 1346499 SAR_Eukaryotes SAR_Eukaryotes 261 2.28e-65   NTclustered gi|759083539|gb|KM222156.1| 1346499 g60515 i0 93.22 5.98305084745763 177 12 100 0 1 177 27 203 Trithigmostoma cucullulus voucher CXM08110902 large subunit ribosomal RNA gene, partial sequence blastn 1059 261 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Trithigmostoma Trithigmostoma cucullulus

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