RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA772154" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA772154 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
2023314 2023314 PRJNA772154_P_NODE_18202_length_252_cov_0.871508_g18017_i0 PRJNA772154 18202 252 0.871508 2.19620016 Bilophila 35832 Bacteria Bacteria 171 2.76e-49   NR WP_005028827.1 35833 g18017 i0 100 4.94047619047619 83 0 98.8 0 3 251 101 183 WP_005028827.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatB [Bilophila wadsworthia] diamond 1245 171 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Bilophila Bilophila wadsworthia
4575406 4575406 PRJNA772154_P_NODE_10764_length_345_cov_1.147059_g10579_i0 PRJNA772154 10764 345 1.147059 3.95735355 Bilophila wadsworthia 35833 Bacteria Bacteria 188 3.18e-57   NR WP_278659039.1 35833 g10579 i0 97.9 0.834782608695652 96 2 83.5 0 57 344 124 219 WP_278659039.1 ABC transporter permease [Bilophila wadsworthia] diamond 288 188 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Bilophila Bilophila wadsworthia
12227000 12227000 PRJNA772154_P_NODE_16690_length_261_cov_1.244681_g16505_i0 PRJNA772154 16690 261 1.244681 3.24861741 Bilophila wadsworthia 35833 Bacteria Bacteria 179 4.84e-50   NR WP_005026389.1 35833 g16505 i0 100 4.96551724137931 87 0 100 0 261 1 652 738 WP_005026389.1 pyruvate, phosphate dikinase [Bilophila wadsworthia] diamond 1296 179 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Bilophila Bilophila wadsworthia
29263631 29263631 PRJNA772154_P_NODE_21169_length_245_cov_0.906977_g20984_i0 PRJNA772154 21169 245 0.906977 2.22209365 Bilophila wadsworthia 35833 Bacteria Bacteria 168 6.78e-50   NR WP_005027781.1 35833 g20984 i0 97.5 0.991836734693878 81 2 99.2 0 1 243 150 230 WP_005027781.1 DUF2156 domain-containing protein [Bilophila wadsworthia] diamond 243 168 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Bilophila Bilophila wadsworthia
29809996 29809996 PRJNA772154_P_NODE_18271_length_252_cov_0.871508_g18086_i0 PRJNA772154 18271 252 0.871508 2.19620016 Bilophila 35832 Bacteria Bacteria 168 2.67e-51   NR MFR4117537.1 35833 g18086 i0 98.8 8 84 1 100 0 1 252 71 154 MFR4117537.1 tetratricopeptide repeat protein [Bilophila wadsworthia] diamond 2016 168 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Bilophila Bilophila wadsworthia
30536799 30536799 PRJNA772154_P_NODE_18613_length_251_cov_0.876404_g18428_i0 PRJNA772154 18613 251 0.876404 2.19977404 Bilophila 35832 Bacteria Bacteria 161 1.1999999999999999e-46   NR WP_279086276.1 35833 g18428 i0 100 6.69322709163347 80 0 95.6 0 249 10 263 342 WP_279086276.1 TRAP transporter large permease, partial [Bilophila wadsworthia] diamond 1680 161 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Bilophila Bilophila wadsworthia
32865941 32865941 PRJNA772154_P_NODE_20300_length_247_cov_0.896552_g20115_i0 PRJNA772154 20300 247 0.896552 2.21448344 Bilophila 35832 Bacteria Bacteria 162 6.7e-48   NR WP_005027911.1 35832 g20115 i0 100 0.995951417004049 82 0 99.6 0 2 247 81 162 WP_005027911.1 MULTISPECIES: imidazole glycerol phosphate synthase subunit HisF [Bilophila] diamond 246 162 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Bilophila  

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