RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where tax_clade = "candidate division MSBL1" and tax_phylum = "Methanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Methanobacteriota · 14 ✖

tax_kingdom 1

tax_clade 1

  • candidate division MSBL1 · 14 ✖

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
26744839 26744839 PRJNA615351_P_NODE_185421_length_151_cov_2.370690_g171321_i0 PRJNA615351 185421 151 2.37069 3.5797419 Archaea 2157 Archaea Archaea 44.3 0.00291   NR KXA91279.1 1698259 g171321 i0 66.7 1.19205298013245 30 10 59.6 0 54 143 142 171 KXA91279.1 hypothetical protein AKJ57_01805 [candidate division MSBL1 archaeon SCGC-AAA259A05] diamond 180 44.3 1 Archaea candidate division MSBL1 Methanobacteriati Methanobacteriota         candidate division MSBL1 archaeon SCGC-AAA259A05
27201955 27201955 PRJNA429937_P_NODE_5622_length_1464_cov_13.577700_g3308_i0 PRJNA429937 5622 1464 13.5777 198.777528 candidate division MSBL1 archaeon SCGC-AAA385M11 1698288 Archaea Archaea 162 1.16e-44   NR KXB09026.1 1698288 g3308 i0 94 0.172131147540984 84 5 17.2 0 878 1129 1 84 KXB09026.1 hypothetical protein AKJ60_01160 [candidate division MSBL1 archaeon SCGC-AAA385M11] diamond 252 162 1 Archaea candidate division MSBL1 Methanobacteriati Methanobacteriota         candidate division MSBL1 archaeon SCGC-AAA385M11
27446713 27446713 PRJNA1067370_P_NODE_73843_length_259_cov_1.241935_g73294_i0 PRJNA1067370 73843 259 1.241935 3.21661165 candidate division MSBL1 archaeon SCGC-AAA382C18 1698281 Archaea Archaea 102 1.4399999999999994e-23   NR KXB07166.1 1698281 g73294 i0 60.8 1.65637065637066 79 29 89.2 1 234 4 1 79 KXB07166.1 methionine sulfoxide reductase [candidate division MSBL1 archaeon SCGC-AAA382C18] diamond 429 102 1 Archaea candidate division MSBL1 Methanobacteriati Methanobacteriota         candidate division MSBL1 archaeon SCGC-AAA382C18
27504193 27504193 PRJNA599026_S_NODE_48143_length_170_cov_1.264463_g47687_i0 PRJNA599026 48143 170 1.264463 2.1495871 Archaea 2157 Archaea Archaea 51.2 2.8e-6   NR KXA91153.1 1698259 g47687 i0 57.6 1.16470588235294 33 14 58.2 0 6 104 72 104 KXA91153.1 hypothetical protein AKJ57_02325 [candidate division MSBL1 archaeon SCGC-AAA259A05] diamond 198 51.2 1 Archaea candidate division MSBL1 Methanobacteriati Methanobacteriota         candidate division MSBL1 archaeon SCGC-AAA259A05
29475332 29475332 PRJNA429937_P_NODE_104930_length_288_cov_2.486486_g82312_i0 PRJNA429937 104930 288 2.486486 7.16107968 candidate division MSBL1 archaeon SCGC-AAA385M11 1698288 Archaea Archaea 115 3.62e-29   NR KXB09022.1 1698288 g82312 i0 85.7 0.65625 63 9 65.6 0 2 190 162 224 KXB09022.1 hypothetical protein AKJ60_01185 [candidate division MSBL1 archaeon SCGC-AAA385M11] diamond 189 115 1 Archaea candidate division MSBL1 Methanobacteriati Methanobacteriota         candidate division MSBL1 archaeon SCGC-AAA385M11
29730112 29730112 PRJNA534016_P_NODE_8570_length_290_cov_2.829493_g8480_i0 PRJNA534016 8570 290 2.829493 8.2055297 candidate division MSBL1 archaeon SCGC-AAA259I 215777 Archaea Archaea 42.7 0.0294   NR KXA95608.1 1698266 g8480 i0 32.3 0.672413793103448 65 40 65.2 2 34 222 83 145 KXA95608.1 hypothetical protein AKJ36_00120 [candidate division MSBL1 archaeon SCGC-AAA259I07] diamond 195 42.7 1 Archaea candidate division MSBL1 Methanobacteriati Methanobacteriota         candidate division MSBL1 archaeon SCGC-AAA259I07
29906850 29906850 PRJEB14803_P_NODE_1211_length_1280_cov_8.338153_g1029_i0 PRJEB14803 1211 1280 8.338153 106.7283584 candidate division MSBL1 archaeon SCGC-AAA261O19 1698277 Archaea Archaea 58.2 2.76e-5   NR KXB04061.1 1698277 g1029 i0 35.9 0.4828125 103 65 24.1 1 531 839 89 190 KXB04061.1 hypothetical protein AKJ48_03430, partial [candidate division MSBL1 archaeon SCGC-AAA261O19] diamond 618 58.2 1 Archaea candidate division MSBL1 Methanobacteriati Methanobacteriota         candidate division MSBL1 archaeon SCGC-AAA261O19
30191062 30191062 PRJEB28062_P_NODE_136092_length_216_cov_4.314685_g133728_i0 PRJEB28062 136092 216 4.314685 9.3197196 candidate division MSBL1 archaeon SCGC-AAA261F17 1698274 Archaea Archaea 56.2 1.4e-7   NR KXB02143.1 1698274 g133728 i0 47.3 1.38888888888889 55 27 76.4 1 43 207 12 64 KXB02143.1 hypothetical protein AKJ44_01275 [candidate division MSBL1 archaeon SCGC-AAA261F17] diamond 300 56.2 1 Archaea candidate division MSBL1 Methanobacteriati Methanobacteriota         candidate division MSBL1 archaeon SCGC-AAA261F17
30593026 30593026 PRJNA908278_P_NODE_1993_length_784_cov_1.298172_g1902_i0 PRJNA908278 1993 784 1.298172 10.17766848 candidate division MSBL1 archaeon SCGC-AAA259I 215777 Archaea Archaea 71.6 3.24e-10   NR KXA97759.1 1698267 g1902 i0 25.3 1.39285714285714 182 126 67.7 5 784 254 185 361 KXA97759.1 elongation factor 1-alpha [candidate division MSBL1 archaeon SCGC-AAA259I09] diamond 1092 71.6 1 Archaea candidate division MSBL1 Methanobacteriati Methanobacteriota         candidate division MSBL1 archaeon SCGC-AAA259I09
30988490 30988490 PRJNA1166865_P_NODE_88874_length_244_cov_0.900585_g88633_i0 PRJNA1166865 88874 244 0.900585 2.1974274 candidate division MSBL1 archaeon SCGC-AAA259A 215777 Archaea Archaea 46.6 0.00162   NR KXA91433.1 1698259 g88633 i0 30.7 0.922131147540984 75 40 83.6 2 230 27 277 346 KXA91433.1 hypothetical protein AKJ57_01350 [candidate division MSBL1 archaeon SCGC-AAA259A05] diamond 225 46.6 1 Archaea candidate division MSBL1 Methanobacteriati Methanobacteriota         candidate division MSBL1 archaeon SCGC-AAA259A05
31433455 31433455 PRJNA340009_P_NODE_25616_length_243_cov_2.365979_g25309_i0 PRJNA340009 25616 243 2.365979 5.74932897 candidate division MSBL1 archaeon SCGC-AAA382N 215777 Archaea Archaea 72.4 1.2e-12   NR KXB08558.1 1698285 g25309 i0 75 0.54320987654321 44 11 54.3 0 98 229 194 237 KXB08558.1 hypothetical protein AKJ56_01010 [candidate division MSBL1 archaeon SCGC-AAA382N08] diamond 132 72.4 1 Archaea candidate division MSBL1 Methanobacteriati Methanobacteriota         candidate division MSBL1 archaeon SCGC-AAA382N08
32048506 32048506 PRJNA946307_P_NODE_143218_length_166_cov_2.452991_g142344_i0 PRJNA946307 143218 166 2.452991 4.07196506 candidate division MSBL1 archaeon SCGC-AAA385M 215777 Archaea Archaea 75.9 2.27e-14   NR KXB08977.1 1698287 g142344 i0 65.4 1.87951807228916 52 18 94 0 9 164 123 174 KXB08977.1 hypothetical protein AKJ59_00035 [candidate division MSBL1 archaeon SCGC-AAA385M02] diamond 312 75.9 1 Archaea candidate division MSBL1 Methanobacteriati Methanobacteriota         candidate division MSBL1 archaeon SCGC-AAA385M02
32124243 32124243 PRJNA1120060_P_NODE_2765898_length_247_cov_0.890805_g2747814_i0 PRJNA1120060 2765898 247 0.890805 2.20028835 candidate division MSBL1 archaeon SCGC-AAA259J 215777 Archaea Archaea 43.5 0.0164   NR KXA98807.1 1698269 g2747814 i0 43.3 0.728744939271255 60 33 72.9 1 15 194 29 87 KXA98807.1 50S ribosomal protein L1 [candidate division MSBL1 archaeon SCGC-AAA259J03] diamond 180 43.5 1 Archaea candidate division MSBL1 Methanobacteriati Methanobacteriota         candidate division MSBL1 archaeon SCGC-AAA259J03
32683201 32683201 PRJNA1148190_P_NODE_593120_length_251_cov_0.865169_g581947_i0 PRJNA1148190 593120 251 0.865169 2.17157419 Archaea 2157 Archaea Archaea 45.4 0.00437   NR KXA99252.1 1698272 g581947 i0 38.6 2.09163346613546 57 32 68.1 1 179 9 247 300 KXA99252.1 hypothetical protein AKJ42_03485 [candidate division MSBL1 archaeon SCGC-AAA261C02] diamond 525 45.4 1 Archaea candidate division MSBL1 Methanobacteriati Methanobacteriota         candidate division MSBL1 archaeon SCGC-AAA261C02

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