RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA857143", 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 · 9 ✖

tax_kingdom 1

  • Pseudomonadati · 9 ✖

bioproject 1

  • PRJNA857143 · 9 ✖

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
3787282 3787282 PRJNA857143_S_NODE_94363_length_320_cov_0.947368_g93270_i0 PRJNA857143 94363 320 0.947368 3.0315776 Bacteria 2 Bacteria Bacteria 52.8 0.03   NTclustered gi|116696516|gb|CP000478.1| 335543 g93270 i0 100 0.175 28 0 9 0 243 270 3505619 3505646 Syntrophobacter fumaroxidans MPOB, complete genome blastn 56 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae Syntrophobacter Syntrophobacter fumaroxidans
27189541 27189541 PRJNA857143_S_NODE_151722_length_265_cov_2.015625_g150629_i0 PRJNA857143 151722 265 2.015625 5.34140625 Pseudomonadati 3379134 Bacteria Bacteria 52 1.11e-5   NR WP_015724156.1 894 g150629 i0 52.6 2.18490566037736 38 18 43 0 96 209 141 178 WP_015724156.1 HPP family protein [Desulfobulbus propionicus] diamond 579 52.4 0.99236641221374 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus Desulfobulbus propionicus
27411161 27411161 PRJNA857143_S_NODE_129923_length_283_cov_1.842857_g128830_i0 PRJNA857143 129923 283 1.842857 5.21528531 Pseudomonadati 3379134 Bacteria Bacteria 54.7 3.51e-6   NR OQY13398.1 1971626 g128830 i0 49 3.37102473498233 51 25 54.1 1 5 157 143 192 OQY13398.1 MAG: hypothetical protein B6I31_01255 [Desulfobacteraceae bacterium 4572_19] diamond 954 55.1 0.992740471869329 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium 4572_19
28453006 28453006 PRJNA857143_S_NODE_133306_length_280_cov_1.884058_g132213_i0 PRJNA857143 133306 280 1.884058 5.2753624 Desulfovibrio 872 Bacteria Bacteria 87 1.13e-18   NR MBP3733423.1 885 g132213 i0 53.8 2.57142857142857 80 36 84.6 1 278 42 144 223 MBP3733423.1 adenylate kinase [Desulfovibrio sp.] diamond 720 87 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
28476269 28476269 PRJNA857143_S_NODE_84426_length_332_cov_3.915058_g83333_i0 PRJNA857143 84426 332 3.915058 12.99799256 Desulfomarina profundi 2772557 Bacteria Bacteria 52 5.5e-5   NR WP_228854867.1 2772557 g83333 i0 41.2 1.53614457831325 85 45 76.8 2 6 260 303 382 WP_228854867.1 TMEM43 family protein [Desulfomarina profundi] diamond 510 52 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfomarina Desulfomarina profundi
29991937 29991937 PRJNA857143_S_NODE_54111_length_386_cov_2.159744_g53018_i0 PRJNA857143 54111 386 2.159744 8.33661184 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 48.9 4.94e-4   NR MFB3885833.1 2202153 g53018 i0 40.6 0.994818652849741 64 34 49 2 1 189 111 171 MFB3885833.1 DUF4833 domain-containing protein [Thermodesulfobacteriota bacterium] diamond 384 48.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
30876533 30876533 PRJNA857143_S_NODE_161514_length_258_cov_1.264865_g160421_i0 PRJNA857143 161514 258 1.264865 3.2633517 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 42.7 0.0382   NR MDA8414032.1 2049433 g160421 i0 36 0.872093023255814 75 43 81.4 1 227 18 143 217 MDA8414032.1 flagellar basal body P-ring formation chaperone FlgA [Desulfobacteraceae bacterium] diamond 225 42.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
31327121 31327121 PRJNA857143_S_NODE_166915_length_254_cov_1.723757_g165822_i0 PRJNA857143 166915 254 1.723757 4.37834278 Pseudomonadati 3379134 Bacteria Bacteria 45.8 0.0028   NR MDO9584633.1 52017 g165822 i0 57.1 3.53149606299213 35 15 41.3 0 254 150 184 218 MDO9584633.1 metal-dependent hydrolase [Desulfomicrobium sp.] diamond 897 45.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium sp.
31382385 31382385 PRJNA857143_S_NODE_179776_length_248_cov_1.782857_g178683_i0 PRJNA857143 179776 248 1.782857 4.42148536 Syntrophorhabdus sp. 2699756 Bacteria Bacteria 68.6 3.25e-11   NR HOD77050.1 2699756 g178683 i0 54.7 5.37096774193548 53 24 64.1 0 160 2 108 160 HOD77050.1 DUF4062 domain-containing protein [Syntrophorhabdus sp.] diamond 1332 68.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophorhabdia Syntrophorhabdales Syntrophorhabdaceae Syntrophorhabdus Syntrophorhabdus sp.

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