RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB75230", 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

  • PRJEB75230 · 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
27090245 27090245 PRJEB75230_P_NODE_31842_length_345_cov_0.849265_g31660_i0 PRJEB75230 31842 345 0.849265 2.92996425 root 1 Root_unresolved Root_unresolved 48.5 9.06e-4   NR MDB2320089.1 2163009 g31660 i0 35.9 2.39130434782609 92 49 80 3 301 26 110 191 MDB2320089.1 hypothetical protein [Candidatus Poseidoniales archaeon] diamond 825 48.5 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     Candidatus Poseidoniales archaeon
30097287 30097287 PRJEB75230_P_NODE_157432_length_245_cov_0.895349_g157250_i0 PRJEB75230 157432 245 0.895349 2.19360505 Thermoplasmatota archaeon 2806419 Archaea Archaea 43.1 0.0286   NR MEM4257999.1 2806419 g157250 i0 38.9 0.661224489795918 54 30 66.1 1 10 171 603 653 MEM4257999.1 hypothetical protein [Thermoplasmatota archaeon] diamond 162 43.1 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
30666067 30666067 PRJEB75230_P_NODE_66633_length_292_cov_1.328767_g66451_i0 PRJEB75230 66633 292 1.328767 3.87999964 Thermoplasmata archaeon 1906666 Archaea Archaea 48.9 4.62e-4   NR UCH88004.1 1906666 g66451 i0 42 0.832191780821918 81 31 68.8 3 88 288 262 340 UCH88004.1 MAG: PQQ-binding-like beta-propeller repeat protein [Thermoplasmata archaeon] diamond 243 48.9 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
32025734 32025734 PRJEB75230_P_NODE_49578_length_313_cov_0.962500_g49396_i0 PRJEB75230 49578 313 0.9625 3.012625 Candidatus Poseidoniaceae archaeon 2666346 Archaea Archaea 43.5 0.0307   NR MDC0655692.1 2666346 g49396 i0 39.3 0.536741214057508 56 34 53.7 0 92 259 34 89 MDC0655692.1 hypothetical protein [Candidatus Poseidoniaceae archaeon] diamond 168 43.5 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales Candidatus Poseidoniaceae   Candidatus Poseidoniaceae 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);;