RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA643700", 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 · 11 ✖

tax_clade 1

  • Sar · 11 ✖

bioproject 1

  • PRJNA643700 · 11 ✖

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
1894272 1894272 PRJNA643700_P_NODE_171842_length_306_cov_3.128405_g170286_i0 PRJNA643700 171842 306 3.128405 9.5729193 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.029   NTclustered gi|145543650|ref|XM_001457474.1| 5888 g170286 i0 100 0.0915032679738562 28 0 9 0 185 212 476 449 Paramecium tetraurelia uncharacterized protein (GSPATT00023288001), partial mRNA blastn 28 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
5721598 5721598 PRJNA643700_P_NODE_155825_length_325_cov_1.884058_g154270_i0 PRJNA643700 155825 325 1.884058 6.1231885 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.002   NTclustered gi|145521830|ref|XM_001446728.1| 5888 g154270 i0 100 0.0923076923076923 30 0 9 0 19 48 411 382 Paramecium tetraurelia uncharacterized protein (GSPATT00014314001), partial mRNA blastn 30 56.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
13372132 13372132 PRJNA643700_P_NODE_233391_length_251_cov_1.985149_g231835_i0 PRJNA643700 233391 251 1.985149 4.98272399 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.006   NTclustered gi|829194443|ref|XM_001030934.2| 312017 g231835 i0 100 1.00796812749004 29 0 12 0 82 110 252 280 Tetrahymena thermophila SB210 Serine/Threonine kinase domain protein partial mRNA blastn 253 54.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
14647255 14647255 PRJNA643700_P_NODE_95752_length_427_cov_1.875661_g94199_i0 PRJNA643700 95752 427 1.875661 8.00907247 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 676 0   NTclustered gi|512134943|gb|JX178902.1| 1295638 g94199 i0 95.316 91.8290398126464 427 19 100 1 1 427 1208 1633 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 39211 676 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
17196019 17196019 PRJNA643700_P_NODE_245574_length_242_cov_3.186528_g244018_i0 PRJNA643700 245574 242 3.186528 7.71139776 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.022   NTclustered gi|829189014|ref|XM_012799591.1| 312017 g244018 i0 100 0.115702479338843 28 0 12 0 50 77 158 131 Tetrahymena thermophila SB210 transmembrane protein, putative partial mRNA blastn 28 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
17736655 17736655 PRJNA643700_P_NODE_412814_length_164_cov_1.356522_g411258_i0 PRJNA643700 412814 164 1.356522 2.22469608 Vorticellidae 85904 SAR_Eukaryotes SAR_Eukaryotes 276 7.46e-70   NTclustered gi|363412153|gb|JN120227.1| 60850 g411258 i0 96.951 100.018292682927 164 5 100 0 1 164 543 706 Vorticella convallaria isolate 96Vorsp16 18S ribosomal RNA gene, partial sequence blastn 16403 276 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella convallaria
18470278 18470278 PRJNA643700_P_NODE_116355_length_384_cov_3.644776_g114800_i0 PRJNA643700 116355 384 3.644776 13.99593984 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.01   NTclustered gi|829186752|ref|XM_001031521.2| 312017 g114800 i0 100 0.0755208333333333 29 0 8 0 6 34 2863 2891 Tetrahymena thermophila SB210 poly (ADP-ribose) polymerase family protein partial mRNA blastn 29 54.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
18470286 18470286 PRJNA643700_P_NODE_133835_length_355_cov_3.415033_g132280_i0 PRJNA643700 133835 355 3.415033 12.12336715 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.034   NTclustered gi|145489360|ref|XM_001430646.1| 5888 g132280 i0 96.774 0.0873239436619718 31 1 9 0 6 36 3652 3622 Paramecium tetraurelia uncharacterized protein (GSPATT00033138001), partial mRNA blastn 31 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
24844400 24844400 PRJNA643700_P_NODE_170680_length_308_cov_1.196911_g169124_i0 PRJNA643700 170680 308 1.196911 3.68648588 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.029   NTclustered gi|2386266222|ref|XM_001460497.2| 5888 g169124 i0 96.875 0.103896103896104 32 0 10 1 204 235 66 36 Paramecium tetraurelia uncharacterized protein (GSPATT00004006001), partial mRNA blastn 32 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
27870844 27870844 PRJNA643700_P_NODE_329965_length_195_cov_1.068493_g328409_i0 PRJNA643700 329965 195 1.068493 2.08356135 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0266   NR CAD8161223.1 43137 g328409 i0 46.9 0.492307692307692 32 17 49.2 0 33 128 416 447 CAD8161223.1 unnamed protein product [Paramecium octaurelia] diamond 96 42.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
29777559 29777559 PRJNA643700_P_NODE_279991_length_221_cov_1.139535_g278435_i0 PRJNA643700 279991 221 1.139535 2.51837235 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 48.9 1.39e-4   NR CAI2386064.1 5936 g278435 i0 61.3 3.70588235294118 31 12 42.1 0 221 129 188 218 CAI2386064.1 unnamed protein product [Moneuplotes crassus] diamond 819 48.9 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus

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