RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Methanobacteriati · 4 ✖

bioproject 1

  • PRJNA1047749 · 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
13763548 13763548 PRJNA1047749_P_NODE_27031_length_297_cov_13.629464_g26764_i0 PRJNA1047749 27031 297 13.629464 40.47950808 root 1 Root_unresolved Root_unresolved 81.3 2.03e-15   NR MCE5214309.1 2164 g26764 i0 57.1 14.1414141414141 70 25 65.7 1 3 197 596 665 MCE5214309.1 PAS domain S-box protein [Methanobacterium sp.] diamond 4200 82 0.991463414634146 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp.
15477764 15477764 PRJNA1047749_P_NODE_24533_length_301_cov_3.188596_g24266_i0 PRJNA1047749 24533 301 3.188596 9.59767396 Thermoplasmatota archaeon 2806419 Archaea Archaea 69.7 2.54e-11   NR HUR69663.1 2806419 g24266 i0 75.6 1.92358803986711 45 11 44.9 0 286 152 868 912 HUR69663.1 PAS domain S-box protein [Thermoplasmatota archaeon] diamond 579 69.7 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
27911396 27911396 PRJNA1047749_P_NODE_50825_length_203_cov_7.061538_g50558_i0 PRJNA1047749 50825 203 7.061538 14.33492214 root 1 Root_unresolved Root_unresolved 108 2.88e-27   NR MCD4843358.1 2250255 g50558 i0 81 4.66995073891626 63 12 93.1 0 189 1 41 103 MCD4843358.1 type I restriction-modification system subunit M [Methanosarcinales archaeon] diamond 948 108 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon
30698733 30698733 PRJNA1047749_P_NODE_47234_length_226_cov_9.235294_g46967_i0 PRJNA1047749 47234 226 9.235294 20.87176444 Methanoculleus taiwanensis 1550565 Archaea Archaea 56.6 3.86e-7   NR WP_128694369.1 1550565 g46967 i0 71.8 4.18141592920354 39 11 51.8 0 2 118 586 624 WP_128694369.1 1,4-alpha-glucan branching protein GlgB [Methanoculleus taiwanensis] diamond 945 56.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus taiwanensis

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