RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax_phylum = "Thermotogota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermotogota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJEB11748 · 13 ✖

analysis 1

  • diamond · 13 ✖

tax_clade 0

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
14044956 14044956 PRJEB11748_P_NODE_252772_length_245_cov_2.793478_g250589_i0 PRJEB11748 252772 245 2.793478 6.8440211 Fervidobacterium sp. 1871331 Bacteria Bacteria 104 6.87e-26   NR MDM7321178.1 1871331 g250589 i0 85.2 0.661224489795918 54 8 66.1 0 54 215 154 207 MDM7321178.1 hypothetical protein [Fervidobacterium sp.] diamond 162 104 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
26779776 26779776 PRJEB11748_P_NODE_304161_length_217_cov_9.025641_g301978_i0 PRJEB11748 304161 217 9.025641 19.58564097 Fervidobacterium sp. 1871331 Bacteria Bacteria 59.7 2.66e-8   NR HUM41557.1 1871331 g301978 i0 36.8 0.940092165898618 68 39 88.5 1 195 4 95 162 HUM41557.1 hypothetical protein [Fervidobacterium sp.] diamond 204 59.7 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
26900171 26900171 PRJEB11748_P_NODE_259021_length_241_cov_5.511111_g256838_i0 PRJEB11748 259021 241 5.511111 13.28177751 Bacteria 2 Bacteria Bacteria 64.3 9.17e-10   NR HOJ89182.1 2033661 g256838 i0 63.6 3.47302904564315 44 16 54.8 0 154 23 72 115 HOJ89182.1 ATP-binding protein [Pseudothermotoga sp.] diamond 837 64.3 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
28106717 28106717 PRJEB11748_P_NODE_35285_length_739_cov_26.361357_g33355_i0 PRJEB11748 35285 739 26.361357 194.81042823 Thermotogota bacterium 2053689 Bacteria Bacteria 78.6 4.44e-13   NR HPM21465.1 2053689 g33355 i0 35.6 0.81190798376184 101 62 41 2 516 214 1 98 HPM21465.1 hypothetical protein [Thermotogota bacterium] diamond 600 78.6 1 Bacteria   Thermotogati Thermotogota         Thermotogota bacterium
28169783 28169783 PRJEB11748_P_NODE_103866_length_409_cov_11.281609_g101694_i0 PRJEB11748 103866 409 11.281609 46.14178081 Fervidobacterium sp. 1871331 Bacteria Bacteria 96.7 3.42e-20   NR HUM44121.1 1871331 g101694 i0 61.4 0.60880195599022 83 31 60.1 1 142 387 136 218 HUM44121.1 N-6 DNA methylase [Fervidobacterium sp.] diamond 249 96.7 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
28517399 28517399 PRJEB11748_P_NODE_44327_length_649_cov_10.685374_g42252_i0 PRJEB11748 44327 649 10.685374 69.34807726 Fervidobacterium sp. 1871331 Bacteria Bacteria 154 2.8199999999999992e-43   NR MDM7321176.1 1871331 g42252 i0 86 0.397534668721109 86 12 39.8 0 6 263 42 127 MDM7321176.1 hypothetical protein [Fervidobacterium sp.] diamond 258 154 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
28643646 28643646 PRJEB11748_P_NODE_202727_length_281_cov_7.027273_g200544_i0 PRJEB11748 202727 281 7.027273 19.74663713 Fervidobacterium sp. 1871331 Bacteria Bacteria 83.6 1.45e-17   NR HUM43789.1 1871331 g200544 i0 54.5 0.939501779359431 88 34 92.9 3 269 9 32 114 HUM43789.1 DUF6011 domain-containing protein [Fervidobacterium sp.] diamond 264 83.6 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
28801297 28801297 PRJEB11748_P_NODE_374808_length_183_cov_13.090164_g372625_i0 PRJEB11748 374808 183 13.090164 23.95500012 Thermosipho africanus 2421 Bacteria Bacteria 74.3 8.53e-14   NR WP_004101232.1 2421 g372625 i0 69.6 2.32786885245902 46 14 75.4 0 46 183 113 158 WP_004101232.1 pyridoxal-phosphate-dependent aminotransferase family protein [Thermosipho africanus] diamond 426 74.3 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Thermosipho Thermosipho africanus
30248058 30248058 PRJEB11748_P_NODE_244492_length_250_cov_6.089947_g242309_i0 PRJEB11748 244492 250 6.0899470000000004 15.2248675 Bacteria 2 Bacteria Bacteria 57.4 2.69e-7   NR HUM44606.1 1871331 g242309 i0 83.9 1.86 31 5 37.2 0 135 227 468 498 HUM44606.1 DEAD/DEAH box helicase [Fervidobacterium sp.] diamond 465 57.8 0.993079584775087 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
30917703 30917703 PRJEB11748_P_NODE_232874_length_258_cov_3.350254_g230691_i0 PRJEB11748 232874 258 3.350254 8.64365532 Fervidobacterium sp. 1871331 Bacteria Bacteria 93.6 1.66e-20   NR HQE49614.1 1871331 g230691 i0 66.7 0.767441860465116 66 20 74.4 1 213 22 3 68 HQE49614.1 Mu-like prophage major head subunit gpT family protein [Fervidobacterium sp.] diamond 198 93.6 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
31670057 31670057 PRJEB11748_P_NODE_167657_length_314_cov_19.134387_g165474_i0 PRJEB11748 167657 314 19.134387 60.08197518 Defluviitoga 1511648 Bacteria Bacteria 135 4.5e-36   NR MDY0379706.1 1006576 g165474 i0 70.8 5.09235668789809 89 26 85 0 25 291 124 212 MDY0379706.1 tryptophanase [Defluviitoga tunisiensis] diamond 1599 135 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Defluviitoga Defluviitoga tunisiensis
32087689 32087689 PRJEB11748_P_NODE_365898_length_189_cov_12.617188_g363715_i0 PRJEB11748 365898 189 12.617188 23.84648532 Fervidobacterium sp. 1871331 Bacteria Bacteria 81.3 1.16e-16   NR MDM7321175.1 1871331 g363715 i0 87 0.73015873015873 46 6 73 0 170 33 112 157 MDM7321175.1 hypothetical protein [Fervidobacterium sp.] diamond 138 81.3 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
32845615 32845615 PRJEB11748_P_NODE_281120_length_229_cov_1.857143_g278937_i0 PRJEB11748 281120 229 1.857143 4.25285747 Fervidobacterium sp. 1871331 Bacteria Bacteria 58.5 8.02e-8   NR HPC25222.1 1871331 g278937 i0 45.9 3.14410480349345 61 33 79.9 0 206 24 421 481 HPC25222.1 DEAD/DEAH box helicase [Fervidobacterium sp.] diamond 720 58.5 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.

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