RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJEB25789", tax_clade = "Sar" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 7 ✖

tax_clade 1

bioproject 1

  • PRJEB25789 · 7 ✖

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
3849235 3849235 PRJEB25789_S_NODE_10444_length_300_cov_2.378855_g10365_i0 PRJEB25789 10444 300 2.378855 7.136565 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 144 7.57e-41   NR CAD8051385.1 5886 g10365 i0 70.4 25.26 98 29 98 0 296 3 1 98 CAD8051385.1 unnamed protein product [Paramecium primaurelia] diamond 7578 144 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
5125531 5125531 PRJEB25789_S_NODE_15245_length_259_cov_2.064516_g15166_i0 PRJEB25789 15245 259 2.064516 5.34709644 Epistylis sp. FG-2015 1607876 SAR_Eukaryotes SAR_Eukaryotes 479 9.13e-131   NTclustered gi|759083557|gb|KM222174.1| 1607876 g15166 i0 100 67.1969111969112 259 0 100 0 1 259 576 318 Epistylis sp. FG-2015 voucher SZ2011052302 large subunit ribosomal RNA gene, partial sequence blastn 17404 479 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Epistylidae Epistylis Epistylis sp. FG-2015
6401355 6401355 PRJEB25789_S_NODE_19886_length_241_cov_1.488095_g19807_i0 PRJEB25789 19886 241 1.488095 3.58630895 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 189 1.58e-43   NTclustered gi|220966760|gb|FJ545743.1| 94289 g19807 i0 97.297 39.4771784232365 111 3 46 0 131 241 6001 5891 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 9514 189 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
6401369 6401369 PRJEB25789_S_NODE_20566_length_229_cov_2.961538_g20487_i0 PRJEB25789 20566 229 2.961538 6.78192202 Lamtostyla gui 2678605 SAR_Eukaryotes SAR_Eukaryotes 143 1.18e-29   NTclustered gi|1778223994|gb|MN733822.1| 2678605 g20487 i0 91.346 30.2576419213974 104 9 45 0 1 104 4443 4340 Lamtostyla gui isolate LWY2015111409 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 6929 143 1 Eukaryota Sar   Ciliophora Spirotrichea Stichotrichida Amphisiellidae Lamtostyla Lamtostyla gui
26969775 26969775 PRJEB25789_S_NODE_4582_length_414_cov_2.730205_g4503_i0 PRJEB25789 4582 414 2.730205 11.3030487 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 97.8 2.68e-23   NR CDW83169.1 5949 g4503 i0 49.5 0.789855072463768 109 54 79 1 44 370 8 115 CDW83169.1 UNKNOWN [Stylonychia lemnae] diamond 327 97.8 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29300458 29300458 PRJEB25789_S_NODE_9289_length_314_cov_0.958506_g9210_i0 PRJEB25789 9289 314 0.958506 3.00970884 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 82.4 8.28e-17   NR XP_001014308.1 312017 g9210 i0 46.4 3.19108280254777 84 41 80.3 1 2 253 127 206 XP_001014308.1 eukaryotic translation initiation factor 5A [Tetrahymena thermophila SB210] diamond 1002 83.2 0.990384615384615 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31575461 31575461 PRJEB25789_S_NODE_17576_length_248_cov_0.880000_g17497_i0 PRJEB25789 17576 248 0.88 2.1824 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 51.6 1.83e-5   NR CDW74496.1 5949 g17497 i0 64.1 1.5241935483871 39 14 47.2 0 122 238 4 42 CDW74496.1 glutathione s-pi 1 [Stylonychia lemnae] diamond 378 51.6 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae

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