RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA884104" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 4 ✖

tax_phylum 1

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA884104 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
11064964 11064964 PRJNA884104_S_NODE_74209_length_248_cov_0.880000_g73466_i0 PRJNA884104 74209 248 0.88 2.1824 Haloterrigena salifodinae 2675099 Archaea Archaea 63.9 1.04e-5   NTclustered gi|1988313350|gb|CP069188.1| 2675099 g73466 i0 88.462 0.209677419354839 52 6 21 0 150 201 3075094 3075145 Haloterrigena salifodinae strain BOL5-1 chromosome, complete genome blastn 52 63.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Haloterrigena Haloterrigena salifodinae
14889635 14889635 PRJNA884104_S_NODE_87332_length_234_cov_2.409938_g86589_i0 PRJNA884104 87332 234 2.409938 5.63925492 Methanosalsum zhilinae 39669 Archaea Archaea 56.5 0.002   NTclustered gi|335929340|gb|CP002101.1| 679901 g86589 i0 100 0.376068376068376 30 0 13 0 104 133 1665138 1665167 Methanosalsum zhilinae DSM 4017, complete genome blastn 88 56.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosalsum Methanosalsum zhilinae
16163072 16163072 PRJNA884104_S_NODE_21293_length_438_cov_0.843836_g20550_i0 PRJNA884104 21293 438 0.843836 3.69600168 Halorussus limi 2938695 Archaea Archaea 52.8 0.042   NTclustered gi|2234300126|gb|CP096659.1| 2938695 g20550 i0 100 0.0639269406392694 28 0 6 0 269 296 2872344 2872317 Halorussus limi strain XZYJT49 chromosome, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haladaptataceae Halorussus Halorussus limi
16164270 16164270 PRJNA884104_S_NODE_80893_length_244_cov_0.900585_g80150_i0 PRJNA884104 80893 244 0.900585 2.1974274 Halomontanus rarus 3034020 Archaea Archaea 63.9 1.02e-5   NTclustered gi|2006565477|gb|CP071597.1| 3034020 g80150 i0 87.931 0.475409836065574 58 2 23 4 98 152 2613362 2613417 Halomontanus rarus strain KZCA124 chromosome 1, complete sequence blastn 116 63.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Halomontanus Halomontanus rarus

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