RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA825466" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 6 ✖

bioproject 1

  • PRJNA825466 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
820409 820409 PRJNA825466_P_NODE_15101_length_257_cov_1.673913_g15000_i0 PRJNA825466 15101 257 1.673913 4.30195641 Natronomonas salina 1710540 Archaea Archaea 287 5.890000000000001e-73   NTclustered gi|1865519430|gb|CP058335.1| 1710540 g15000 i0 87.059 18.2607003891051 255 31 99 2 3 256 1897200 1896947 Natronomonas salina strain YPL13 chromosome, complete genome blastn 4693 287 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas salina
4648803 4648803 PRJNA825466_P_NODE_19244_length_249_cov_0.875000_g19143_i0 PRJNA825466 19244 249 0.875 2.17875 Salinirarus marinus 3068310 Archaea Archaea 255 1.6e-63   NTclustered gi|2563036160|gb|CP132292.1| 3068310 g19143 i0 85.2 1.00401606425703 250 35 100 2 1 249 755404 755652 Haloferacaceae archaeon XH8 chromosome, complete genome blastn 250 255 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Salinirarus Salinirarus marinus
4648808 4648808 PRJNA825466_P_NODE_20004_length_248_cov_0.880000_g19903_i0 PRJNA825466 20004 248 0.88 2.1824 Salinirarus marinus 3068310 Archaea Archaea 307 4.34e-79   NTclustered gi|2563036160|gb|CP132292.1| 3068310 g19903 i0 89.069 4.54032258064516 247 27 99 0 2 248 360370 360124 Haloferacaceae archaeon XH8 chromosome, complete genome blastn 1126 307 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Salinirarus Salinirarus marinus
16123078 16123078 PRJNA825466_S_NODE_1493_length_249_cov_1.409091_g1487_i0 PRJNA825466 1493 249 1.409091 3.50863659 Natronomonas moolapensis 416273 Archaea Archaea 339 1.5399999999999998e-88   NTclustered gi|452081962|emb|HF582854.1| 268739 g1487 i0 91.463 11.2610441767068 246 21 99 0 1 246 1978822 1978577 Natronomonas moolapensis 8.8.11 complete genome blastn 2804 339 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas moolapensis
17398793 17398793 PRJNA825466_P_NODE_25994_length_243_cov_0.905882_g25893_i0 PRJNA825466 25994 243 0.905882 2.20129326 Salinirarus marinus 3068310 Archaea Archaea 189 1.6e-43   NTclustered gi|2563036160|gb|CP132292.1| 3068310 g25893 i0 80.894 1.01234567901235 246 42 100 5 1 243 1925097 1924854 Haloferacaceae archaeon XH8 chromosome, complete genome blastn 246 189 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Salinirarus Salinirarus marinus
25046760 25046760 PRJNA825466_P_NODE_27240_length_242_cov_0.911243_g27139_i0 PRJNA825466 27240 242 0.911243 2.20520806 Halorientalis marina 2931976 Archaea Archaea 311 3.26e-80   NTclustered gi|2225350890|gb|CP095488.1| 2931976 g27139 i0 92.627 29.1157024793388 217 15 89 1 2 217 320686 320902 Halorientalis marina strain GDY88 plasmid unnamed1, complete sequence blastn 7046 311 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Halorientalis Halorientalis marina

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