RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA690234" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA690234 · 5 ✖

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
3221206 3221206 PRJNA690234_P_NODE_30903_length_243_cov_1.376471_g30536_i0 PRJNA690234 30903 243 1.376471 3.34482453 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.022   NTclustered gi|829187266|ref|XM_001033288.2| 312017 g30536 i0 100 0.11522633744856 28 0 12 0 129 156 1611 1584 Tetrahymena thermophila SB210 hypothetical protein partial mRNA blastn 28 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
7048712 7048712 PRJNA690234_P_NODE_21026_length_276_cov_2.729064_g20659_i0 PRJNA690234 21026 276 2.729064 7.53221664 Philasterides dicentrarchi 282688 SAR_Eukaryotes SAR_Eukaryotes 143 1.46e-29   NTclustered gi|49616744|gb|AY643504.1| 282688 g20659 i0 84.459 1.68840579710145 148 20 53 3 1 146 247 101 Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence blastn 466 143 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Philasteridae Philasterides Philasterides dicentrarchi
8831831 8831831 PRJNA690234_P_NODE_33047_length_201_cov_11.632812_g32680_i0 PRJNA690234 33047 201 11.632812 23.38195212 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 372 1.18e-98   NTclustered gi|2065561668|gb|MZ540265.1| 44029 g32680 i0 100 99.9950248756219 201 0 100 0 1 201 1380 1580 Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence blastn 20099 372 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium jenningsi
24130740 24130740 PRJNA690234_P_NODE_15599_length_321_cov_7.629032_g15232_i0 PRJNA690234 15599 321 7.629032 24.48919272 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 588 1.8599999999999994e-163   NTclustered gi|2065561668|gb|MZ540265.1| 44029 g15232 i0 99.688 99.595015576324 321 1 100 0 1 321 332 12 Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence blastn 31970 593 0.991568296795953 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium jenningsi
27788902 27788902 PRJNA690234_P_NODE_31764_length_242_cov_0.923077_g31397_i0 PRJNA690234 31764 242 0.923077 2.23384634 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 101 5.0299999999999995e-25   NR CAD8123542.1 65129 g31397 i0 56.3 1.95867768595041 80 35 99.2 0 242 3 60 139 CAD8123542.1 unnamed protein product [Paramecium sonneborni] diamond 474 101 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni

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