RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1093008", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 6 ✖

tax_kingdom 1

  • Pseudomonadati · 6 ✖

bioproject 1

  • PRJNA1093008 · 6 ✖

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
21875555 21875555 PRJNA1093008_S_NODE_59878_length_278_cov_2.253659_g59551_i0 PRJNA1093008 59878 278 2.253659 6.26517202 Desulfobacterales bacterium 2044940 Bacteria Bacteria 52.8 0.026   NTclustered gi|2108238081|gb|CP070694.1| 2044940 g59551 i0 100 0.100719424460432 28 0 10 0 160 187 3395982 3396009 MAG: Desulfobacterales bacterium isolate bin60 chromosome blastn 28 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
27288836 27288836 PRJNA1093008_S_NODE_60323_length_278_cov_1.107317_g59996_i0 PRJNA1093008 60323 278 1.107317 3.07834126 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 43.9 0.0209   NR MBC2737085.1 2049433 g59996 i0 29.7 0.798561151079137 74 46 73.4 2 215 12 34 107 MBC2737085.1 ABC transporter permease [Desulfobacteraceae bacterium] diamond 222 43.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
30320900 30320900 PRJNA1093008_S_NODE_80532_length_252_cov_1.290503_g80205_i0 PRJNA1093008 80532 252 1.290503 3.25206756 Solidesulfovibrio sp. 2910990 Bacteria Bacteria 43.1 0.0128   NR WP_300162223.1 2910990 g80205 i0 35.2 0.642857142857143 54 35 64.3 0 74 235 78 131 WP_300162223.1 hypothetical protein [Solidesulfovibrio sp.] diamond 162 43.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Solidesulfovibrio Solidesulfovibrio sp.
31394943 31394943 PRJNA1093008_S_NODE_59016_length_280_cov_0.990338_g58689_i0 PRJNA1093008 59016 280 0.990338 2.7729464 Geobacteraceae bacterium 2282154 Bacteria Bacteria 42.7 0.0479   NR MBP1753171.1 2282154 g58689 i0 31 0.760714285714286 71 45 76.1 1 225 13 143 209 MBP1753171.1 pyruvate radical-activating enzyme [Geobacteraceae bacterium] diamond 213 42.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae   Geobacteraceae bacterium
32439048 32439048 PRJNA1093008_S_NODE_56239_length_284_cov_1.094787_g55912_i0 PRJNA1093008 56239 284 1.094787 3.10919508 Desulfobacterales bacterium 2044940 Bacteria Bacteria 44.7 0.0113   NR MCG8640234.1 2044940 g55912 i0 30.9 0.855633802816901 81 50 83.5 2 34 270 21 97 MCG8640234.1 class II fructose-bisphosphate aldolase family protein [Desulfobacterales bacterium] diamond 243 44.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
32502311 32502311 PRJNA1093008_S_NODE_32119_length_332_cov_1.903475_g31792_i0 PRJNA1093008 32119 332 1.903475 6.319537 Desulfofustis limnaeus 2740163 Bacteria Bacteria 43.9 0.0375   NR WP_284152076.1 2740163 g31792 i0 30 0.813253012048193 90 46 66 1 288 70 141 230 WP_284152076.1 aminotransferase class V-fold PLP-dependent enzyme [Desulfofustis limnaeus] diamond 270 43.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfofustis Desulfofustis limnaeus

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