RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA285816", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 12 ✖

tax_kingdom 1

  • Pseudomonadati · 12 ✖

bioproject 1

  • PRJNA285816 · 12 ✖

analysis 1

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
20185175 20185175 PRJNA285816_S_NODE_20076_length_180_cov_1.587786_g19974_i0 PRJNA285816 20076 180 1.587786 2.8580148 PVC group 1783257 Bacteria Bacteria 90.1 2.63e-19   NR MBG0777957.1 2049043 g19974 i0 71.9 13.45 57 16 95 0 5 175 347 403 MBG0777957.1 asparagine--tRNA ligase [Desulfovibrionaceae bacterium] diamond 2421 90.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae bacterium
27168738 27168738 PRJNA285816_S_NODE_12182_length_215_cov_1.253012_g12080_i0 PRJNA285816 12182 215 1.253012 2.6939758 Desulfobulbus sp. AH-315-M07 2814557 Bacteria Bacteria 57.4 1.73e-7   NR MBN4050221.1 2814557 g12080 i0 40 2.58139534883721 60 36 83.7 0 182 3 276 335 MBN4050221.1 trypsin-like peptidase domain-containing protein [Desulfobulbus sp. AH-315-M07] diamond 555 57.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus Desulfobulbus sp. AH-315-M07
28179324 28179324 PRJNA285816_S_NODE_7226_length_262_cov_3.849765_g7124_i0 PRJNA285816 7226 262 3.849765 10.0863843 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 73.2 9.53e-13   NR HAY38674.1 2049433 g7124 i0 49.4 0.927480916030534 81 32 91.6 3 241 2 1000 1072 HAY38674.1 sugar-binding protein [Desulfobacteraceae bacterium] diamond 243 73.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
28590193 28590193 PRJNA285816_S_NODE_1047_length_631_cov_4.475945_g965_i0 PRJNA285816 1047 631 4.475945 28.24321295 Geobacteraceae bacterium 2282154 Bacteria Bacteria 47 0.0385   NR NVN99922.1 2282154 g965 i0 28.7 0.679873217115689 143 90 62.3 3 81 473 300 442 NVN99922.1 CxxxxCH/CxxCH domain-containing protein [Geobacteraceae bacterium] diamond 429 47 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae   Geobacteraceae bacterium
28891642 28891642 PRJNA285816_S_NODE_2708_length_407_cov_5.729050_g2606_i0 PRJNA285816 2708 407 5.72905 23.3172335 Pseudomonadati 3379134 Bacteria Bacteria 87.8 3.35e-17   NR WP_022658989.1 876 g2606 i0 87.2 8.66093366093366 47 6 34.6 0 406 266 427 473 WP_022658989.1 adenosylhomocysteinase [Desulfovibrio desulfuricans] diamond 3525 88.6 0.99097065462754 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
29365518 29365518 PRJNA285816_S_NODE_21389_length_176_cov_1.228346_g21287_i0 PRJNA285816 21389 176 1.228346 2.16188896 root 1 Root_unresolved Root_unresolved 46.6 6.67e-4   NR WP_028314398.1 218208 g21287 i0 43.1 7.39772727272727 58 33 98.9 0 174 1 241 298 WP_028314398.1 insulinase family protein [Desulfatibacillum aliphaticivorans] diamond 1302 46.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfatibacillaceae Desulfatibacillum Desulfatibacillum aliphaticivorans
30579414 30579414 PRJNA285816_S_NODE_22813_length_172_cov_1.268293_g22711_i0 PRJNA285816 22813 172 1.268293 2.18146396 Candidatus Magnetomorum sp. HK-1 1509431 Bacteria Bacteria 59.7 1.49e-8   NR KPA14518.1 1509431 g22711 i0 54 0.872093023255814 50 23 87.2 0 10 159 270 319 KPA14518.1 kinesin [Candidatus Magnetomorum sp. HK-1] diamond 150 59.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Candidatus Magnetomoraceae Candidatus Magnetomorum Candidatus Magnetomorum sp. HK-1
30611139 30611139 PRJNA285816_S_NODE_6393_length_276_cov_2.220264_g6291_i0 PRJNA285816 6393 276 2.220264 6.12792864 Desulfuromonadaceae bacterium 2099677 Bacteria Bacteria 80.1 4.09e-15   NR MDD5285284.1 2099677 g6291 i0 51.8 3.57608695652174 83 38 90.2 1 4 252 394 474 MDD5285284.1 acetyl/propionyl/methylcrotonyl-CoA carboxylase subunit alpha [Desulfuromonadaceae bacterium] diamond 987 80.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae   Desulfuromonadaceae bacterium
30786894 30786894 PRJNA285816_S_NODE_7234_length_262_cov_3.018779_g7132_i0 PRJNA285816 7234 262 3.018779 7.90920098 Bacteria 2 Bacteria Bacteria 58.2 2.34e-8   NR MCU0577026.1 2202153 g7132 i0 43.7 4.88931297709924 71 39 81.3 1 259 47 47 116 MCU0577026.1 AhpC/TSA family protein [Thermodesulfobacteriota bacterium] diamond 1281 58.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
31369973 31369973 PRJNA285816_S_NODE_3956_length_341_cov_0.979452_g3854_i0 PRJNA285816 3956 341 0.979452 3.33993132 Desulfobacterales bacterium 2044940 Bacteria Bacteria 48.1 0.00143   NR MCG8615342.1 2044940 g3854 i0 37.8 0.651026392961877 74 43 63.3 2 126 341 384 456 MCG8615342.1 ankyrin repeat domain-containing protein [Desulfobacterales bacterium] diamond 222 48.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
31591330 31591330 PRJNA285816_S_NODE_6676_length_271_cov_1.567568_g6574_i0 PRJNA285816 6676 271 1.567568 4.24810928 Desulfatibacillum sp. 2794877 Bacteria Bacteria 117 4.91e-30   NR MBI9077827.1 2794877 g6574 i0 66.7 1.99261992619926 90 27 96.3 1 271 11 100 189 MBI9077827.1 SDR family oxidoreductase [Desulfatibacillum sp.] diamond 540 117 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfatibacillaceae Desulfatibacillum Desulfatibacillum sp.
31812527 31812527 PRJNA285816_S_NODE_15797_length_196_cov_1.734694_g15695_i0 PRJNA285816 15797 196 1.734694 3.40000024 Desulfobacterales bacterium 2044940 Bacteria Bacteria 77.8 8.47e-15   NR NVM22190.1 2044940 g15695 i0 54.7 6.81122448979592 64 29 98 0 3 194 472 535 NVM22190.1 NAD-dependent malic enzyme [Desulfobacterales bacterium] diamond 1335 77.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium

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