RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA896554 · 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
17448364 17448364 PRJNA896554_P_NODE_136774_length_267_cov_1.190722_g129234_i0 PRJNA896554 136774 267 1.190722 3.17922774 Salinilacihabitans rarus 2961596 Archaea Archaea 54.7 0.007   NTclustered gi|2273363716|gb|CP100762.1| 2961596 g129234 i0 92.308 0.146067415730337 39 2 14 1 184 221 863981 863943 Salinilacihabitans rarus strain AD-4 chromosome, complete genome blastn 39 54.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Salinilacihabitans Salinilacihabitans rarus
17449025 17449025 PRJNA896554_P_NODE_164934_length_245_cov_0.895349_g157394_i0 PRJNA896554 164934 245 0.895349 2.19360505 Halorubrum sp. PV6 634157 Archaea Archaea 303 5.53e-78   NTclustered gi|1540603140|gb|CP030064.1| 634157 g157394 i0 90.435 77.9714285714286 230 22 94 0 16 245 2657262 2657033 Halorubrum sp. PV6 chromosome, complete genome blastn 19103 303 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum sp. PV6
18722255 18722255 PRJNA896554_P_NODE_164615_length_245_cov_0.895349_g157075_i0 PRJNA896554 164615 245 0.895349 2.19360505 Halorubrum sp. CBA1229 1853699 Archaea Archaea 339 1.5199999999999998e-88   NTclustered gi|1861358827|gb|CP054585.1| 1853699 g157075 i0 93.103 1.87755102040816 232 15 95 1 14 245 177079 177309 Halorubrum sp. CBA1229 chromosome, complete genome blastn 460 339 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum sp. CBA1229
19996707 19996707 PRJNA896554_P_NODE_130896_length_275_cov_1.198020_g123356_i0 PRJNA896554 130896 275 1.19802 3.294555 Halobacterium sp. DL1 751944 Archaea Archaea 56.5 0.002   NTclustered gi|573484043|gb|CP007060.1| 751944 g123356 i0 94.444 0.334545454545455 36 2 13 0 193 228 2499882 2499917 Halobacterium sp. DL1, complete genome blastn 92 56.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halobacterium Halobacterium sp. DL1

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