RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1073005" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA1073005 · 7 ✖

analysis 1

  • blastn · 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
186991 186991 PRJNA1073005_P_NODE_7021_length_322_cov_1.855422_g6902_i0 PRJNA1073005 7021 322 1.855422 5.97445884 Strongylidium orientale 1286065 SAR_Eukaryotes SAR_Eukaryotes 424 5.56e-114   NTclustered gi|759083295|gb|KM221972.1| 1286065 g6902 i0 90.402 94.3447204968944 323 29 100 2 1 322 352 31 Strongylidium orientale voucher CXM2009120301 alpha-tubulin gene, partial cds blastn 30379 424 1 Eukaryota Sar   Ciliophora Spirotrichea Stichotrichida Spirofilidae Strongylidium Strongylidium orientale
6564946 6564946 PRJNA1073005_P_NODE_7086_length_319_cov_1.565041_g6967_i0 PRJNA1073005 7086 319 1.565041 4.99248079 Euplotes vannus 5939 SAR_Eukaryotes SAR_Eukaryotes 296 1.25e-75   NTclustered gi|409187347|gb|JQ289914.1| 5939 g6967 i0 84.211 153.736677115987 304 48 99 0 2 305 515 212 Euplotes vannus clone eu568c1 polyubiquitin gene, partial cds; macronuclear blastn 49042 296 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes vannus
7393756 7393756 PRJNA1073005_P_NODE_9546_length_247_cov_0.885057_g9427_i0 PRJNA1073005 9546 247 0.885057 2.18609079 Vorticella 60849 SAR_Eukaryotes SAR_Eukaryotes 364 2.519999999999999e-96   NTclustered gi|530758434|gb|KF524393.1| 60850 g9427 i0 92.509 101.914979757085 267 0 100 1 1 247 179 445 Vorticella convallaria isolate Gzpop 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 25173 364 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella convallaria
11665634 11665634 PRJNA1073005_P_NODE_6270_length_357_cov_1.897887_g6151_i0 PRJNA1073005 6270 357 1.897887 6.77545659 Aspidisca lynceus 2035364 SAR_Eukaryotes SAR_Eukaryotes 514 3.59e-141   NTclustered gi|2328859120|gb|OP828525.1| 2035364 g6151 i0 97.659 36.8543417366947 299 7 84 0 59 357 1750 1452 Aspidisca lynceus isolate LCY2015101602 large subunit ribosomal RNA gene, partial sequence blastn 13157 514 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Aspidiscidae Aspidisca Aspidisca lynceus
11665637 11665637 PRJNA1073005_P_NODE_7110_length_318_cov_1.240816_g6991_i0 PRJNA1073005 7110 318 1.240816 3.94579488 Entodinium caudatum 47911 SAR_Eukaryotes SAR_Eukaryotes 363 1.2099999999999999e-95   NTclustered gi|92790163|emb|AJ965267.1| 47911 g6991 i0 87.54 175.424528301887 313 39 98 0 6 318 449 137 Entodinium caudatum partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene) blastn 55785 363 1 Eukaryota Sar   Ciliophora Litostomatea Entodiniomorphida Ophryoscolecidae Entodinium Entodinium caudatum
16318523 16318523 PRJNA1073005_P_NODE_9513_length_247_cov_0.885057_g9394_i0 PRJNA1073005 9513 247 0.885057 2.18609079 Euplotida 33831 SAR_Eukaryotes SAR_Eukaryotes 268 2.04e-67   NTclustered gi|399146186|gb|JQ736722.1| 577312 g9394 i0 86.235 64.3198380566802 247 34 100 0 1 247 296 50 Aspidisca magna isolate B272 alpha-tubulin gene, partial cds; macronuclear blastn 15887 268 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Aspidiscidae Aspidisca Aspidisca magna
20588035 20588035 PRJNA1073005_P_NODE_2637_length_672_cov_15.874791_g2523_i0 PRJNA1073005 2637 672 15.874791 106.67859552 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 1085 0   NTclustered gi|512134943|gb|JX178902.1| 1295638 g2523 i0 95.833 91.8616071428571 672 27 100 1 1 672 1000 1670 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 61731 1085 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011

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