RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA940501", tax_kingdom = "Nanobdellati" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 6 ✖

tax_kingdom 1

  • Nanobdellati · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA940501 · 6 ✖

analysis 1

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
26739838 26739838 PRJNA940501_S_NODE_116301_length_228_cov_1.524324_g115483_i0 PRJNA940501 116301 228 1.524324 3.47545872 Candidatus Pacearchaeota archaeon 2026773 Archaea Archaea 41.6 0.0232   NR MBS3078950.1 2026773 g115483 i0 29 0.815789473684211 62 39 75 1 180 10 18 79 MBS3078950.1 DUF4234 domain-containing protein [Candidatus Pacearchaeota archaeon] diamond 186 41.6 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota archaeon
27025178 27025178 PRJNA940501_S_NODE_268842_length_174_cov_1.435115_g268024_i0 PRJNA940501 268842 174 1.435115 2.4971001 Candidatus Pacearchaeota archaeon 2026773 Archaea Archaea 41.6 0.0341   NR MBS3091199.1 2026773 g268024 i0 29.4 0.879310344827586 51 36 87.9 0 3 155 174 224 MBS3091199.1 TFIIB-type zinc ribbon-containing protein [Candidatus Pacearchaeota archaeon] diamond 153 41.6 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota archaeon
29582716 29582716 PRJNA940501_S_NODE_150030_length_211_cov_2.232143_g149212_i0 PRJNA940501 150030 211 2.232143 4.70982173 Candidatus Micrarchaeia archaeon 3018267 Archaea Archaea 42 0.021   NR MFA4946467.1 3018267 g149212 i0 50 0.483412322274882 34 17 48.3 0 90 191 11 44 MFA4946467.1 PIN domain-containing protein [Candidatus Micrarchaeia archaeon] diamond 102 42 1 Archaea   Nanobdellati Candidatus Micrarchaeota Candidatus Micrarchaeia       Candidatus Micrarchaeia archaeon
31485984 31485984 PRJNA940501_S_NODE_5816_length_623_cov_2.891379_g5163_i0 PRJNA940501 5816 623 2.891379 18.01329117 Archaea 2157 Archaea Archaea 86.3 6.72e-17   NR MEK6891065.1 2026764 g5163 i0 67.9 0.54414125200642 56 18 27 0 1 168 155 210 MEK6891065.1 uracil phosphoribosyltransferase [Nanoarchaeota archaeon] diamond 339 87 0.991954022988506 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
31763542 31763542 PRJNA940501_S_NODE_27037_length_333_cov_12.424138_g26219_i0 PRJNA940501 27037 333 12.424138 41.37237954 Candidatus Pacearchaeota archaeon 2026773 Archaea Archaea 117 3.19e-31   NR MCK5603540.1 2026773 g26219 i0 51.4 0.963963963963964 107 47 96.4 1 12 332 1 102 MCK5603540.1 DUF1367 family protein [Candidatus Pacearchaeota archaeon] diamond 321 117 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota archaeon
32680271 32680271 PRJNA940501_S_NODE_214660_length_188_cov_2.268966_g213842_i0 PRJNA940501 214660 188 2.268966 4.26565608 Candidatus Pacearchaeota archaeon 2026773 Archaea Archaea 80.1 8.6e-16   NR MAG26912.1 2026773 g213842 i0 61.3 0.98936170212766 62 24 98.9 0 186 1 294 355 MAG26912.1 phosphonopyruvate decarboxylase [Candidatus Pacearchaeota archaeon] diamond 186 80.1 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota 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);;