RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA874604" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 3 ✖

bioproject 1

  • PRJNA874604 · 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
2127510 2127510 PRJNA874604_P_NODE_59362_length_267_cov_1.407216_g59010_i0 PRJNA874604 59362 267 1.407216 3.75726672 Haladaptatus halobius 2884875 Archaea Archaea 195 3.84e-45   NTclustered gi|2124335437|gb|CP085336.1| 2884875 g59010 i0 80.075 8.8689138576779 266 49 99 4 4 267 751820 752083 Haladaptatus halobius strain PSR5 chromosome 2, complete sequence blastn 2368 195 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haladaptataceae Haladaptatus Haladaptatus halobius
13991989 13991989 PRJNA874604_P_NODE_62711_length_261_cov_1.569149_g62359_i0 PRJNA874604 62711 261 1.569149 4.09547889 Methanocaldococcus 196118 Archaea Archaea 60.2 1.42e-4   NTclustered gi|103488854|gb|DQ516907.1| 2190 g62359 i0 100 0.245210727969349 32 0 12 0 230 261 69 38 Methanocaldococcus jannaschii spike-in control MJ-8000-191 genomic sequence blastn 64 60.2 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanococci Methanococcales Methanocaldococcaceae Methanocaldococcus Methanocaldococcus jannaschii
19978182 19978182 PRJNA874604_P_NODE_25136_length_369_cov_0.966216_g24784_i0 PRJNA874604 25136 369 0.966216 3.56533704 Nitrosopumilus oxyclinae 1959104 Archaea Archaea 58.4 7.54e-4   NTclustered gi|1869222960|gb|CP026994.1| 1959104 g24784 i0 97.059 0.0921409214092141 34 1 9 0 148 181 704691 704724 Nitrosopumilus oxyclinae strain HCE1 chromosome, complete genome blastn 34 58.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus oxyclinae

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