RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA939415", tax_kingdom = "Methanobacteriati" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 4 ✖

tax_kingdom 1

  • Methanobacteriati · 4 ✖

bioproject 1

  • PRJNA939415 · 4 ✖

analysis 1

tax_clade 0

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
17493546 17493546 PRJNA939415_P_NODE_27654_length_310_cov_3.907173_g27232_i0 PRJNA939415 27654 310 3.907173 12.1122363 root 1 Root_unresolved Root_unresolved 97.8 2.1200000000000003e-21   NR NIP34583.1 1906666 g27232 i0 95.9 22.558064516129 49 2 47.4 0 308 162 169 217 NIP34583.1 adenosylhomocysteinase [Thermoplasmata archaeon] diamond 6993 98.2 0.995926680244399 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
27600941 27600941 PRJNA939415_P_NODE_59684_length_274_cov_2.029851_g59262_i0 PRJNA939415 59684 274 2.029851 5.56179174 root 1 Root_unresolved Root_unresolved 50.4 6.03e-6   NR MEE9173962.1 1906666 g59262 i0 64.9 1.5985401459854 37 13 40.5 0 114 4 2 38 MEE9173962.1 acetyl-coenzyme A synthetase N-terminal domain-containing protein [Thermoplasmata archaeon] diamond 438 50.8 0.992125984251969 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
31643681 31643681 PRJNA939415_P_NODE_42476_length_291_cov_2.811927_g42054_i0 PRJNA939415 42476 291 2.811927 8.18270757 root 1 Root_unresolved Root_unresolved 111 5.78e-26   NR MEM0354229.1 1906666 g42054 i0 56.1 2.02061855670103 98 42 100 1 291 1 211 308 MEM0354229.1 phage/plasmid primase, P4 family [Thermoplasmata archaeon] diamond 588 112 0.991071428571429 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
32427891 32427891 PRJNA939415_P_NODE_107559_length_217_cov_6.715278_g107137_i0 PRJNA939415 107559 217 6.715278 14.57215326 Thermoplasmata archaeon 1906666 Archaea Archaea 58.2 5.83e-8   NR HLE45552.1 1906666 g107137 i0 42.9 0.870967741935484 63 36 87.1 0 194 6 13 75 HLE45552.1 ankyrin repeat domain-containing protein [Thermoplasmata archaeon] diamond 189 58.2 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata 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);;