RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA922890" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA922890 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
9825825 9825825 PRJNA922890_P_NODE_42688_length_297_cov_2.039474_g42278_i0 PRJNA922890 42688 297 2.039474 6.05723778 Isotricha intestinalis 47897 SAR_Eukaryotes SAR_Eukaryotes 364 3.119999999999999e-96   NTclustered gi|92790153|emb|AJ965262.1| 47897 g42278 i0 88.889 125.659932659933 297 31 99 2 2 297 461 166 Isotricha intestinalis partial mRNA for Polyubiqutin 2 (polyubiqutin 2 gene) blastn 37321 364 1 Eukaryota Sar   Ciliophora Litostomatea Vestibuliferida Isotrichidae Isotricha Isotricha intestinalis
12377234 12377234 PRJNA922890_P_NODE_46730_length_285_cov_1.342593_g46320_i0 PRJNA922890 46730 285 1.342593 3.82639005 Spathidium sp. 35110 SAR_Eukaryotes SAR_Eukaryotes 150 9.08e-32   NTclustered gi|4107502|gb|AF056105.1|AF056105 35110 g46320 i0 77.068 4.67017543859649 266 58 93 3 14 278 640 903 Spathidium sp. translation elongation factor 1-alpha (TEF2) gene, partial cds blastn 1331 150 1 Eukaryota Sar   Ciliophora Litostomatea Haptorida Spathidiidae Spathidium Spathidium sp.
13651765 13651765 PRJNA922890_P_NODE_46951_length_284_cov_2.218605_g46541_i0 PRJNA922890 46951 284 2.218605 6.3008382 Spathidium sp. 35110 SAR_Eukaryotes SAR_Eukaryotes 370 6.37e-98   NTclustered gi|861141|emb|Z49848.1| 35110 g46541 i0 90.714 97.6549295774648 280 22 98 4 5 282 1109 832 Spathidium sp. gene for alpha-tubulin (partial) blastn 27734 370 1 Eukaryota Sar   Ciliophora Litostomatea Haptorida Spathidiidae Spathidium Spathidium sp.
22575299 22575299 PRJNA922890_P_NODE_55238_length_263_cov_1.211340_g54828_i0 PRJNA922890 55238 263 1.21134 3.1858242 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 420 5.71e-113   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g54828 i0 95.437 9.35361216730038 263 12 100 0 1 263 52 314 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 2460 420 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
23850687 23850687 PRJNA922890_P_NODE_64359_length_242_cov_1.410405_g63949_i0 PRJNA922890 64359 242 1.410405 3.4131801 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 442 1.1099999999999995e-119   NTclustered gi|300676714|gb|GQ377691.1| 151077 g63949 i0 99.587 48.9917355371901 242 1 100 0 1 242 385 144 Chilodonella uncinata rps22a (rps22a) mRNA, complete cds blastn 11856 442 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
25124543 25124543 PRJNA922890_P_NODE_67860_length_236_cov_0.874251_g67450_i0 PRJNA922890 67860 236 0.874251 2.06323236 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 174 4.33e-39   NTclustered gi|829188477|ref|XM_001023087.3| 312017 g67450 i0 81.776 2.21186440677966 214 33 89 6 1 211 1045 835 Tetrahymena thermophila SB210 S-adenosyl-L-homocysteine hydrolase partial mRNA blastn 522 174 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila

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