RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA690124" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA690124 · 5 ✖

analysis 1

  • blastn · 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
5773366 5773366 PRJNA690124_P_NODE_57125_length_228_cov_2.012903_g56759_i0 PRJNA690124 57125 228 2.012903 4.5894188400000004 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 226 1.1299999999999997e-54   NTclustered gi|2431531581|ref|NC_070360.1| 153251 g56759 i0 87.129 81.8991228070175 202 22 87 3 1 198 6099 5898 Cryptocaryon irritans mitochondrion, complete genome blastn 18673 226 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
7556198 7556198 PRJNA690124_P_NODE_19606_length_366_cov_13.890785_g19240_i0 PRJNA690124 19606 366 13.890785 50.8402731 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 676 0   NTclustered gi|2065561668|gb|MZ540265.1| 44029 g19240 i0 100 99.7814207650273 366 0 100 0 1 366 1219 1584 Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence blastn 36520 676 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium jenningsi
7556634 7556634 PRJNA690124_P_NODE_57266_length_216_cov_25.650350_g56900_i0 PRJNA690124 57266 216 25.65035 55.404756 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 399 5.909999999999999e-107   NTclustered gi|1802599794|gb|MT001203.1| 41631 g56900 i0 100 100.060185185185 216 0 100 0 1 216 1349 1564 Colpoda sp. strain HFCC848 small subunit ribosomal RNA gene, partial sequence blastn 21613 399 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
15972419 15972419 PRJNA690124_P_NODE_5333_length_687_cov_4.299674_g4986_i0 PRJNA690124 5333 687 4.299674 29.53876038 Trichodina heterodentata 300408 SAR_Eukaryotes SAR_Eukaryotes 826 0   NTclustered gi|148466409|gb|EF569680.1| 300408 g4986 i0 91.376 85.5269286754003 603 52 88 0 1 603 603 1 Trichodina heterodentata alpha-tubulin gene, partial cds blastn 58757 826 1 Eukaryota Sar   Ciliophora Oligohymenophorea Mobilida Trichodinidae Trichodina Trichodina heterodentata
20305135 20305135 PRJNA690124_P_NODE_55556_length_242_cov_0.923077_g55190_i0 PRJNA690124 55556 242 0.923077 2.23384634 Sessilida 1974272 SAR_Eukaryotes SAR_Eukaryotes 448 2.3799999999999995e-121   NTclustered gi|10930|emb|X56531.1| 6026 g55190 i0 100 99.8842975206612 242 0 100 0 1 242 600 841 O.henneguyi small subunit ribosomal RNA gene blastn 24172 448 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Opisthonectidae Opisthonecta Opisthonecta henneguyi

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