RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA285816", tax_phylum = "Thermoproteota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 3 ✖

tax_phylum 1

  • Thermoproteota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA285816 · 3 ✖

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
27471148 27471148 PRJNA285816_S_NODE_7503_length_259_cov_1.442857_g7401_i0 PRJNA285816 7503 259 1.442857 3.73699963 Thermofilum 2268 Archaea Archaea 48.9 2.78e-4   NR MEM0093123.1 1961369 g7401 i0 42.9 3.52123552123552 56 31 64.9 1 72 239 230 284 MEM0093123.1 DUF3782 domain-containing protein [Thermofilum sp.] diamond 912 48.9 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermofilales Thermofilaceae Thermofilum Thermofilum sp.
29568744 29568744 PRJNA285816_S_NODE_1570_length_527_cov_1.738494_g1470_i0 PRJNA285816 1570 527 1.738494 9.16186338 Thermoproteota archaeon 2056631 Archaea Archaea 84 2.89e-15   NR MEW6587960.1 2056631 g1470 i0 31.7 1.04174573055028 183 111 99.1 5 3 524 140 317 MEW6587960.1 phosphate ABC transporter substrate-binding protein PstS [Thermoproteota archaeon] diamond 549 84 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31496449 31496449 PRJNA285816_S_NODE_2356_length_434_cov_1.366234_g2254_i0 PRJNA285816 2356 434 1.366234 5.92945556 Candidatus Methanosuratincola sp. 2495426 Archaea Archaea 87.8 2.31e-17   NR MBC7120667.1 2495426 g2254 i0 48.2 2.52304147465438 85 44 58.8 0 362 108 33 117 MBC7120667.1 phosphate ABC transporter substrate-binding protein PstS [Candidatus Methanosuratincola sp.] diamond 1095 87.8 1 Archaea   Thermoproteati Thermoproteota Methanosuratincolia Candidatus Methanomethylicales Candidatus Methanomethylicaceae Candidatus Methanosuratincola (ex Vanwonterghem et al. 2016) Candidatus Methanosuratincola sp.

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