RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJEB41113" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 12 ✖

bioproject 1

  • PRJEB41113 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
26589972 26589972 PRJEB41113_S_NODE_7041_length_174_cov_2.810219_g7032_i0 PRJEB41113 7041 174 2.810219 4.88978106 Methanoregula sp. 2052170 Archaea Archaea 42.7 0.0144   NR MDO8871794.1 2052170 g7032 i0 63.3 1.68965517241379 30 11 51.7 0 103 14 5 34 MDO8871794.1 Gfo/Idh/MocA family oxidoreductase [Methanoregula sp.] diamond 294 42.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula Methanoregula sp.
27381301 27381301 PRJEB41113_S_NODE_2543_length_215_cov_3.758427_g2534_i0 PRJEB41113 2543 215 3.758427 8.08061805 Candidatus Methanoperedens sp. 2032688 Archaea Archaea 72 1.24e-12   NR MCZ7404273.1 2032688 g2534 i0 78 0.572093023255814 41 9 57.2 0 4 126 105 145 MCZ7404273.1 DUF5666 domain-containing protein [Candidatus Methanoperedens sp.] diamond 123 72 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Candidatus Methanoperedentaceae Candidatus Methanoperedens Candidatus Methanoperedens sp.
27665494 27665494 PRJEB41113_S_NODE_6964_length_174_cov_6.788321_g6955_i0 PRJEB41113 6964 174 6.788321 11.81167854 Nanobdellota archaeon 2026764 Archaea Archaea 70.5 1.74e-12   NR MFH1134337.1 2026764 g6955 i0 66 0.810344827586207 47 16 81 0 1 141 275 321 MFH1134337.1 GDP-mannose 4,6-dehydratase [Nanoarchaeota archaeon] diamond 141 70.5 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
27854709 27854709 PRJEB41113_S_NODE_4285_length_192_cov_3.419355_g4276_i0 PRJEB41113 4285 192 3.419355 6.5651616 Candidatus Woesearchaeota archaeon 2026803 Archaea Archaea 58.9 2.26e-8   NR MBS3167746.1 2026803 g4276 i0 49 1.671875 49 25 76.6 0 155 9 129 177 MBS3167746.1 hypothetical protein [Candidatus Woesearchaeota archaeon] diamond 321 58.9 1 Archaea   Nanobdellati Candidatus Woesearchaeota         Candidatus Woesearchaeota archaeon
28132394 28132394 PRJEB41113_S_NODE_11705_length_155_cov_3.949153_g11696_i0 PRJEB41113 11705 155 3.949153 6.12118715 root 1 Root_unresolved Root_unresolved 69.7 8.18e-14   NR MBX7076462.1 2099680 g11696 i0 84 3.89032258064516 50 8 96.8 0 154 5 32 81 MBX7076462.1 NADH-quinone oxidoreductase subunit NuoK [Methanobacteriaceae archaeon] diamond 603 70.1 0.994293865905849 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae   Methanobacteriaceae archaeon
29433137 29433137 PRJEB41113_S_NODE_5850_length_182_cov_1.634483_g5841_i0 PRJEB41113 5850 182 1.634483 2.97475906 Nanobdellota archaeon 2026764 Archaea Archaea 102 2.1399999999999994e-23   NR MEK6829485.1 2026764 g5841 i0 92.7 0.906593406593407 55 4 90.7 0 2 166 316 370 MEK6829485.1 AAA family ATPase [Nanoarchaeota archaeon] diamond 165 102 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
29875593 29875593 PRJEB41113_S_NODE_2731_length_212_cov_1.714286_g2722_i0 PRJEB41113 2731 212 1.714286 3.63428632 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 131 5.33e-37   NR MCJ7636773.1 2169593 g2722 i0 100 2.54716981132075 60 0 84.9 0 33 212 48 107 MCJ7636773.1 NADH-quinone oxidoreductase subunit I [Nitrososphaeraceae archaeon] diamond 540 131 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
30222962 30222962 PRJEB41113_S_NODE_8572_length_165_cov_9.062500_g8563_i0 PRJEB41113 8572 165 9.0625 14.953125 Halobacteriales archaeon QS_1_68_2 1904752 Archaea Archaea 106 3.93e-25   NR PSP76452.1 1919169 g8563 i0 85.2 0.981818181818182 54 8 98.2 0 164 3 477 530 PSP76452.1 MAG: S9 family peptidase [Halobacteriales archaeon QS_1_68_20] diamond 162 106 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales     Halobacteriales archaeon QS_1_68_20
30886556 30886556 PRJEB41113_S_NODE_1094_length_257_cov_10.713636_g1085_i0 PRJEB41113 1094 257 10.713636 27.53404452 Nanobdellota archaeon 2026764 Archaea Archaea 125 9.91e-32   NR MDO8528780.1 2026764 g1085 i0 74.4 0.957198443579767 82 21 95.7 0 246 1 157 238 MDO8528780.1 hypothetical protein [Nanoarchaeota archaeon] diamond 246 125 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
31233934 31233934 PRJEB41113_S_NODE_6575_length_177_cov_2.192857_g6566_i0 PRJEB41113 6575 177 2.192857 3.88135689 Methanobrevibacter 2172 Archaea Archaea 64.7 5e-12   NR WP_069574170.1 2172 g6566 i0 100 0.525423728813559 31 0 52.5 0 71 163 1 31 WP_069574170.1 MULTISPECIES: hypothetical protein [Methanobrevibacter] diamond 93 64.7 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter  
31613665 31613665 PRJEB41113_S_NODE_9476_length_162_cov_1.032000_g9467_i0 PRJEB41113 9476 162 1.032 1.67184 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 48.5 1.02e-5   NR MDW0242599.1 2169593 g9467 i0 95 0.740740740740741 20 1 37 0 160 101 55 74 MDW0242599.1 4Fe-4S binding protein [Nitrososphaeraceae archaeon] diamond 120 48.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31708537 31708537 PRJEB41113_S_NODE_7177_length_173_cov_3.301471_g7168_i0 PRJEB41113 7177 173 3.301471 5.71154483 uncultured archaeon 115547 Archaea Archaea 53.1 2.89e-6   NR VVB91355.1 115547 g7168 i0 42.9 1.94219653179191 56 32 97.1 0 168 1 140 195 VVB91355.1 Uncharacterised protein [uncultured archaeon] diamond 336 53.1 1 Archaea               uncultured 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);;