RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA977246" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Methanobacteriati · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA977246 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
17846481 17846481 PRJNA977246_S_NODE_30334_length_224_cov_10042.610256_g29342_i0 PRJNA977246 30334 224 10042.610256 22495.44697344 root 1 Root_unresolved Root_unresolved 79 5.07e-15   NR OFV66407.1 1839936 g29342 i0 58.6 13.21875 58 24 77.7 0 51 224 190 247 OFV66407.1 MAG: Cobaltochelatase subunit [Candidatus Syntrophoarchaeum butanivorans] diamond 2961 79 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales   Candidatus Syntropharchaeum Candidatus Syntropharchaeum butanivorans
20077406 20077406 PRJNA977246_S_NODE_13096_length_412_cov_6.898172_g12117_i0 PRJNA977246 13096 412 6.898172 28.42046864 root 1 Root_unresolved Root_unresolved 73.9 9.17e-14   NR MED5485144.1 2806419 g12117 i0 44.3 4.87864077669903 79 43 57.5 1 34 270 30 107 MED5485144.1 hypothetical protein [Thermoplasmatota archaeon] diamond 2010 73.9 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
27689979 27689979 PRJNA977246_S_NODE_46564_length_162_cov_2.398496_g45572_i0 PRJNA977246 46564 162 2.398496 3.88556352 Thermoplasmatota archaeon 2806419 Archaea Archaea 49.7 4.57e-5   NR MEW5748993.1 2806419 g45572 i0 50 0.925925925925926 50 25 92.6 0 162 13 581 630 MEW5748993.1 hypothetical protein [Thermoplasmatota archaeon] diamond 150 49.7 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
30152261 30152261 PRJNA977246_S_NODE_33712_length_207_cov_3.325843_g32720_i0 PRJNA977246 33712 207 3.325843 6.88449501 Thermoplasmatota archaeon 2806419 Archaea Archaea 92.4 7.36e-20   NR MEW5748993.1 2806419 g32720 i0 65.7 0.971014492753623 67 23 97.1 0 6 206 674 740 MEW5748993.1 hypothetical protein [Thermoplasmatota archaeon] diamond 201 92.4 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota 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);;