RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA561138" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA561138 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
12024157 12024157 PRJNA561138_P_NODE_22050_length_272_cov_1.261307_g21855_i0 PRJNA561138 22050 272 1.261307 3.43075504 Poterioochromonas malhamensis 88167 SAR_Eukaryotes SAR_Eukaryotes 503 5.729999999999998e-138   NTclustered gi|323690576|gb|GU935635.1| 88167 g21855 i0 100 99.9889705882353 272 0 100 0 1 272 1799 1528 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 27197 503 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
14574077 14574077 PRJNA561138_P_NODE_25272_length_250_cov_0.870056_g25077_i0 PRJNA561138 25272 250 0.870056 2.17514 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 161 3.61e-35   NTclustered gi|669150047|ref|XM_008612364.1| 1156394 g25077 i0 78.776 74.124 245 48 97 3 1 243 300 58 Saprolegnia diclina VS20 hypothetical protein partial mRNA blastn 18531 161 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
17122856 17122856 PRJNA561138_P_NODE_28854_length_243_cov_0.905882_g28659_i0 PRJNA561138 28854 243 0.905882 2.20129326 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 411 3.14e-110   NTclustered gi|10935|emb|X56693.1| 5908 g28659 i0 97.119 101.20987654321 243 7 100 0 1 243 645 403 Tetrahymena pyriformis TUF11 gene for ubiquitin-ribosomal protein fusion protein blastn 24594 411 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
23497575 23497575 PRJNA561138_P_NODE_9179_length_417_cov_1.654070_g8984_i0 PRJNA561138 9179 417 1.65407 6.8974719 Poterioochromonas malhamensis 88167 SAR_Eukaryotes SAR_Eukaryotes 737 0   NTclustered gi|323690576|gb|GU935635.1| 88167 g8984 i0 99.751 90.8848920863309 402 1 96 0 15 416 1 402 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 37899 737 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis

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