RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA715461" and tax_clade = "Embryophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Embryophyta · 3 ✖

bioproject 1

  • PRJNA715461 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
2467554 2467554 PRJNA715461_S_NODE_1082_length_241_cov_6.511905_g1008_i0 PRJNA715461 1082 241 6.511905 15.69369105 Platanus 4402 Plants Plants 307 4.1900000000000005e-79   NTclustered gi|290751480|emb|FM165341.1| 122832 g1008 i0 100 68.8796680497925 166 0 69 0 73 238 520 355 Platanus orientalis 18S rRNA gene (partial), ITS1, 5.8S rRNA gene, ITS2 and 25S rRNA gene (partial), clone or6903 blastn 16600 307 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Proteales Platanaceae Platanus Platanus orientalis
9633676 9633676 PRJNA715461_S_NODE_668_length_320_cov_2.060729_g594_i0 PRJNA715461 668 320 2.060729 6.5943328 Hordeum vulgare 4513 Plants Plants 126 1.74e-24   NTclustered gi|326515281|dbj|AK372356.1| 112509 g594 i0 91.304 0.853125 92 8 29 0 229 320 342 433 Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2150G20 blastn 273 126 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
16007722 16007722 PRJNA715461_S_NODE_313_length_490_cov_5788.812950_g246_i0 PRJNA715461 313 490 5788.81295 28365.183455 Cephalomitrion aterrimum 1527703 Plants Plants 119 4.65e-22   NTclustered gi|671724742|gb|KF851759.1| 1527703 g246 i0 91.765 18.8816326530612 85 7 17 0 326 410 237 321 Cephalomitrion aterrimum isolate L1226 26S large subunit ribosomal RNA gene, partial sequence blastn 9252 119 1 Eukaryota Embryophyta Viridiplantae Streptophyta Jungermanniopsida Jungermanniales Cephaloziellaceae Cephalomitrion Cephalomitrion aterrimum

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