RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 11 ✖

bioproject 1

  • PRJNA694770 · 11 ✖

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
5778920 5778920 PRJNA694770_P_NODE_76565_length_253_cov_1.283333_g76271_i0 PRJNA694770 76565 253 1.283333 3.24683249 Geobacteraceae bacterium 2282154 Bacteria Bacteria 114 4.0199999999999998e-28   NR HZV81672.1 2282154 g76271 i0 59 1.96837944664032 83 34 98.4 0 251 3 279 361 HZV81672.1 IS3 family transposase [Geobacteraceae bacterium] diamond 498 114 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae   Geobacteraceae bacterium
11384721 11384721 PRJNA694770_P_NODE_79249_length_251_cov_0.865169_g78955_i0 PRJNA694770 79249 251 0.865169 2.17157419 Bacteria 2 Bacteria Bacteria 71.3 6.28e-8   NTclustered gi|2621703419|emb|OY762510.1| 228671 g78955 i0 92.157 9.8804780876494 51 3 20 1 177 226 3642175 3642125 MAG: uncultured Syntrophus sp. isolate ce8641d8-6ba7-4885-b5ca-0195441cf687 genome assembly, chromosome: 1 blastn 2480 71.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Syntrophaceae Syntrophus uncultured Syntrophus sp.
18525763 18525763 PRJNA694770_P_NODE_17335_length_452_cov_1.218997_g17041_i0 PRJNA694770 17335 452 1.218997 5.50986644 Pseudomonadati 3379134 Bacteria Bacteria 144 1.75e-37   NR WP_010942368.1 35554 g17041 i0 59.3 8.72787610619469 108 44 71.7 0 451 128 433 540 WP_010942368.1 mechanosensitive ion channel family protein [Geobacter sulfurreducens] diamond 3945 145 0.993103448275862 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sulfurreducens
27524973 27524973 PRJNA694770_P_NODE_71663_length_261_cov_1.638298_g71369_i0 PRJNA694770 71663 261 1.638298 4.27595778 Desulfobacterales bacterium 2044940 Bacteria Bacteria 59.3 6.6e-8   NR MBF0101627.1 2044940 g71369 i0 82.8 0.333333333333333 29 5 33.3 0 259 173 415 443 MBF0101627.1 CotH kinase family protein [Desulfobacterales bacterium] diamond 87 59.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
28219359 28219359 PRJNA694770_P_NODE_65506_length_271_cov_1.555556_g65212_i0 PRJNA694770 65506 271 1.555556 4.21555676 Syntrophales bacterium 2928017 Bacteria Bacteria 47.4 6.88e-4   NR HPQ44705.1 2928017 g65212 i0 46.3 2.62361623616236 41 22 45.4 0 107 229 15 55 HPQ44705.1 cupin domain-containing protein [Syntrophales bacterium] diamond 711 47.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales     Syntrophales bacterium
28503782 28503782 PRJNA694770_P_NODE_887_length_2011_cov_2.484520_g783_i0 PRJNA694770 887 2011 2.48452 49.9636972 Geomesophilobacter sediminis 2798584 Bacteria Bacteria 95.1 2.82e-19   NR WP_199386728.1 2798584 g783 i0 50.5 0.156638488314272 105 49 15.2 1 1526 1221 8 112 WP_199386728.1 YbbC/YhhH family protein [Geomesophilobacter sediminis] diamond 315 95.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geomesophilobacter Geomesophilobacter sediminis
29608468 29608468 PRJNA694770_P_NODE_20470_length_421_cov_1.206897_g20176_i0 PRJNA694770 20470 421 1.206897 5.08103637 Desulfamplus sp. 2006184 Bacteria Bacteria 52.8 6.98e-6   NR MBF0203794.1 2006184 g20176 i0 52.2 0.327790973871734 46 22 32.8 0 175 38 9 54 MBF0203794.1 RepB family plasmid replication initiator protein [Desulfamplus sp.] diamond 138 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfamplus Desulfamplus sp.
29798156 29798156 PRJNA694770_P_NODE_28391_length_371_cov_0.758389_g28097_i0 PRJNA694770 28391 371 0.758389 2.81362319 Desulfobulbaceae bacterium 2053307 Bacteria Bacteria 44.3 0.0435   NR MCK9294914.1 2053307 g28097 i0 34.9 0.695417789757412 86 51 66.3 2 283 38 165 249 MCK9294914.1 tetratricopeptide repeat protein [Desulfobulbaceae bacterium] diamond 258 44.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium
29872820 29872820 PRJNA694770_P_NODE_97711_length_242_cov_0.911243_g97417_i0 PRJNA694770 97711 242 0.911243 2.20520806 Pseudomonadati 3379134 Bacteria Bacteria 62 5.99e-9   NR MDH3329035.1 2053307 g97417 i0 59.3 3.85537190082645 54 22 66.9 0 1 162 91 144 MDH3329035.1 delta-60 repeat domain-containing protein [Desulfobulbaceae bacterium] diamond 933 62 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium
30240610 30240610 PRJNA694770_P_NODE_11812_length_544_cov_0.980892_g11520_i0 PRJNA694770 11812 544 0.980892 5.33605248 uncultured Desulfosarcina sp. 218289 Bacteria Bacteria 99 1.65e-20   NR WP_319406305.1 218289 g11520 i0 32.7 3.36948529411765 211 111 99.3 2 3 542 44 254 WP_319406305.1 sensor histidine kinase [uncultured Desulfosarcina sp.] diamond 1833 99 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfosarcinaceae Desulfosarcina uncultured Desulfosarcina sp.
30777765 30777765 PRJNA694770_P_NODE_44914_length_311_cov_2.235294_g44620_i0 PRJNA694770 44914 311 2.235294 6.95176434 Nitratidesulfovibrio liaohensis 2604158 Bacteria Bacteria 194 5.7999999999999986e-55   NR WP_167124353.1 2604158 g44620 i0 100 0.993569131832797 103 0 99.4 0 3 311 492 594 WP_167124353.1 phage tail tape measure protein [Nitratidesulfovibrio liaohensis] diamond 309 194 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio liaohensis

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