RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA285816", tax_kingdom = "Methanobacteriati" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 6 ✖

tax_kingdom 1

  • Methanobacteriati · 6 ✖

bioproject 1

  • PRJNA285816 · 6 ✖

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
26979195 26979195 PRJNA285816_S_NODE_9022_length_240_cov_1.465969_g8920_i0 PRJNA285816 9022 240 1.465969 3.5183256 Thermoplasmatota archaeon 2806419 Archaea Archaea 44.7 0.0076   NR MEK6987388.1 2806419 g8920 i0 44.2 0.65 52 29 65 0 210 55 205 256 MEK6987388.1 Ig-like domain-containing protein [Thermoplasmatota archaeon] diamond 156 44.7 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
27706330 27706330 PRJNA285816_S_NODE_12124_length_215_cov_2.186747_g12022_i0 PRJNA285816 12124 215 2.186747 4.70150605 Thermoplasmata archaeon 1906666 Archaea Archaea 42.7 0.0264   NR HYS99079.1 1906666 g12022 i0 42 0.697674418604651 50 29 69.8 0 193 44 908 957 HYS99079.1 leucine--tRNA ligase [Thermoplasmata archaeon] diamond 150 42.7 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
29095351 29095351 PRJNA285816_S_NODE_26048_length_166_cov_1.324786_g25946_i0 PRJNA285816 26048 166 1.324786 2.19914476 Thermoplasmatota archaeon 2806419 Archaea Archaea 61.2 2.76e-9   NR MEF8879996.1 2806419 g25946 i0 58.8 0.921686746987952 51 21 92.2 0 164 12 142 192 MEF8879996.1 class I SAM-dependent methyltransferase family protein [Thermoplasmatota archaeon] diamond 153 61.2 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
29884749 29884749 PRJNA285816_S_NODE_21031_length_177_cov_1.218750_g20929_i0 PRJNA285816 21031 177 1.21875 2.1571875 Candidatus Poseidoniales archaeon 2163009 Archaea Archaea 51.6 1.11e-5   NR MFL2940038.1 2163009 g20929 i0 42.9 0.711864406779661 42 24 71.2 0 148 23 372 413 MFL2940038.1 purple acid phosphatase family protein [Candidatus Poseidoniales archaeon] diamond 126 51.6 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     Candidatus Poseidoniales archaeon
32508906 32508906 PRJNA285816_S_NODE_6919_length_267_cov_1.655963_g6817_i0 PRJNA285816 6919 267 1.655963 4.42142121 Thermoplasmatota archaeon 2806419 Archaea Archaea 77.4 1.73e-15   NR HWH08748.1 2806419 g6817 i0 58.1 0.831460674157303 74 26 83.1 2 244 23 96 164 HWH08748.1 AMP-dependent synthetase [Thermoplasmatota archaeon] diamond 222 77.4 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
32792069 32792069 PRJNA285816_S_NODE_28780_length_163_cov_0.912281_g28678_i0 PRJNA285816 28780 163 0.912281 1.48701803 Thermoplasmataceae archaeon 2953047 Archaea Archaea 41.6 0.0313   NR MFG1460913.1 2953047 g28678 i0 40 0.920245398773006 50 29 92 1 161 12 159 207 MFG1460913.1 BadF/BadG/BcrA/BcrD ATPase family protein [Thermoplasmataceae archaeon] diamond 150 41.6 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales Thermoplasmataceae   Thermoplasmataceae 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);;