RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJEB7799" 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

  • PRJEB7799 · 5 ✖

analysis 1

  • diamond · 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
32999039 32999039 PRJEB7799n_S_NODE_6443_length_190_cov_2.425806_g6406_i0 PRJEB7799 6443 190 2.425806 4.6090314 Geobacter argillaceus 345631 Bacteria Bacteria 93.6 4.3600000000000006e-21   NR WP_145026094.1 345631 g6406 i0 64.5 0.978947368421053 62 22 97.9 0 186 1 82 143 WP_145026094.1 hypothetical protein [Geobacter argillaceus] diamond 186 93.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter argillaceus
33128136 33128136 PRJEB7799l_S_NODE_3999_length_233_cov_1.338384_g3970_i0 PRJEB7799 3999 233 1.338384 3.11843472 Pseudomonadati 3379134 Bacteria Bacteria 44.7 0.00691   NR WP_027369199.1 873 g3970 i0 76.9 2.34334763948498 26 6 33.5 0 232 155 12 37 WP_027369199.1 EcoAI/FtnUII family type I restriction enzme subunit R [Desulfocurvibacter africanus] diamond 546 45.1 0.991130820399113 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfocurvibacter Desulfocurvibacter africanus
33128164 33128164 PRJEB7799n_S_NODE_8983_length_170_cov_2.829630_g8946_i0 PRJEB7799 8983 170 2.82963 4.810371 Pseudomonadati 3379134 Bacteria Bacteria 45.1 0.00214   NR WP_027369199.1 873 g8946 i0 74.1 3.33529411764706 27 7 47.6 0 169 89 11 37 WP_027369199.1 EcoAI/FtnUII family type I restriction enzme subunit R [Desulfocurvibacter africanus] diamond 567 45.4 0.993392070484582 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfocurvibacter Desulfocurvibacter africanus
33152668 33152668 PRJEB7799n_S_NODE_9864_length_164_cov_1.658915_g9827_i0 PRJEB7799 9864 164 1.658915 2.7206206 Thermodesulfatator atlanticus 501497 Bacteria Bacteria 52 6.89e-6   NR WP_169352780.1 501497 g9827 i0 61 2.26829268292683 41 16 75 0 164 42 410 450 WP_169352780.1 ATP-binding protein [Thermodesulfatator atlanticus] diamond 372 52 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Thermodesulfobacteria Thermodesulfobacteriales Thermodesulfatatoraceae Thermodesulfatator Thermodesulfatator atlanticus
33179476 33179476 PRJEB7799p_S_NODE_11368_length_187_cov_2.947368_g11345_i0 PRJEB7799 11368 187 2.947368 5.51157816 Geobacter 28231 Bacteria Bacteria 80.1 2.79e-16   NR WP_039645128.1 28231 g11345 i0 63 5.98395721925134 54 20 86.6 0 187 26 118 171 WP_039645128.1 MULTISPECIES: class I SAM-dependent DNA methyltransferase [Geobacter] diamond 1119 80.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter  

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