RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA744060" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA744060 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
7101981 7101981 PRJNA744060_P_NODE_30926_length_295_cov_1.369369_g30597_i0 PRJNA744060 30926 295 1.369369 4.03963855 Desulfococcus multivorans 897 Bacteria Bacteria 219 2.55e-52   NTclustered gi|1092202713|gb|CP015381.1| 897 g30597 i0 80.13 13.0779661016949 307 49 100 8 1 295 3504500 3504806 Desulfococcus multivorans strain DSM 2059 chromosome, complete genome blastn 3858 219 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfococcaceae Desulfococcus Desulfococcus multivorans
7102233 7102233 PRJNA744060_P_NODE_46526_length_249_cov_0.886364_g46197_i0 PRJNA744060 46526 249 0.886364 2.20704636 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 183 7.659999999999998e-42   NTclustered gi|2556892445|gb|CP129479.1| 2202153 g46197 i0 80.478 156.140562248996 251 40 99 7 3 249 887073 887318 MAG: Thermodesulfobacteriota bacterium isolate cMAG.17 chromosome, complete genome blastn 38879 183 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
8376691 8376691 PRJNA744060_P_NODE_36547_length_274_cov_1.164179_g36218_i0 PRJNA744060 36547 274 1.164179 3.18985046 Desulfolutivibrio sulfoxidireducens 2773299 Bacteria Bacteria 75 5.37e-9   NTclustered gi|1863426051|gb|CP045506.1| 2773299 g36218 i0 85.714 0.737226277372263 70 10 26 0 120 189 1225291 1225222 Desulfolutivibrio sulfoxidireducens strain DSM 106783 chromosome, complete genome blastn 202 75 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfolutivibrio Desulfolutivibrio sulfoxidireducens
8851538 8851538 PRJNA744060_P_NODE_47367_length_247_cov_3.068966_g47038_i0 PRJNA744060 47367 247 3.068966 7.58034602 Desulfosudis 2904716 Bacteria Bacteria 132 2.79e-26   NTclustered gi|158508843|gb|CP000859.1| 96561 g47038 i0 77.419 37.0445344129555 248 39 98 16 6 246 683136 683373 Desulfococcus oleovorans Hxd3, complete genome blastn 9150 132 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfosudaceae Desulfosudis Desulfosudis oleivorans
16025882 16025882 PRJNA744060_P_NODE_30573_length_296_cov_2.080717_g30244_i0 PRJNA744060 30573 296 2.080717 6.15892232 Pseudodesulfovibrio mercurii 641491 Bacteria Bacteria 220 7.12e-53   NTclustered gi|365906293|gb|CP003220.1| 641491 g30244 i0 80.556 82.0236486486486 288 54 97 2 7 293 3782196 3781910 Pseudodesulfovibrio mercurii strain ND132 chromosome, complete genome blastn 24279 220 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio mercurii

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