RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA561138" 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

  • PRJNA561138 · 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
1820759 1820759 PRJNA561138_P_NODE_24742_length_251_cov_0.865169_g24547_i0 PRJNA561138 24742 251 0.865169 2.17157419 Natronomonas halophila 2747817 Archaea Archaea 414 2.52e-111   NTclustered gi|1865516082|gb|CP058334.1| 2747817 g24547 i0 96.414 1 251 9 100 0 1 251 2309370 2309620 Natronomonas halophila strain C90 chromosome, complete genome blastn 251 414 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas halophila
17122843 17122843 PRJNA561138_P_NODE_28014_length_245_cov_0.895349_g27819_i0 PRJNA561138 28014 245 0.895349 2.19360505 Natronomonas halophila 2747817 Archaea Archaea 381 2.4799999999999995e-101   NTclustered gi|1865516082|gb|CP058334.1| 2747817 g27819 i0 94.694 1.13061224489796 245 13 100 0 1 245 1623462 1623706 Natronomonas halophila strain C90 chromosome, complete genome blastn 277 381 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas halophila
18396833 18396833 PRJNA561138_P_NODE_11995_length_375_cov_1.019868_g11800_i0 PRJNA561138 11995 375 1.019868 3.824505 Halolamina sp. CBA1230 1853690 Archaea Archaea 577 4.7599999999999984e-160   NTclustered gi|1861365533|gb|CP054589.1| 1853690 g11800 i0 94.4 30.0186666666667 375 21 100 0 1 375 58554 58180 Halolamina sp. CBA1230 plasmid pCBA1230-02, complete sequence blastn 11257 577 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halolamina Halolamina sp. CBA1230
18396863 18396863 PRJNA561138_P_NODE_15295_length_335_cov_4.729008_g15100_i0 PRJNA561138 15295 335 4.729008 15.8421768 uncultured archaeon 115547 Archaea Archaea 272 2.2299999999999997e-68   NTclustered gi|533214256|gb|KF160976.1| 115547 g15100 i0 99.333 77.3791044776119 150 1 90 0 1 150 739 590 Uncultured archaeon clone NA_W250_A21 16S ribosomal RNA gene, partial sequence blastn 25922 272 1 Archaea               uncultured archaeon

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