RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 20 ✖

bioproject 1

  • PRJNA390533 · 20 ✖

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
409824 409824 PRJNA390533_P_NODE_42481_length_171_cov_1.166667_g41454_i0 PRJNA390533 42481 171 1.166667 1.99500057 Geoalkalibacter halelectricus 2847045 Bacteria Bacteria 56.5 0.001   NTclustered gi|2304895958|gb|CP092109.1| 2847045 g41454 i0 100 0.175438596491228 30 0 18 0 35 64 3296750 3296721 Geoalkalibacter halelectricus strain SAP-1 chromosome blastn 30 56.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Geoalkalibacteraceae Geoalkalibacter Geoalkalibacter halelectricus
1684495 1684495 PRJNA390533_P_NODE_22082_length_353_cov_3.993631_g21058_i0 PRJNA390533 22082 353 3.993631 14.09751743 Desulfovibrio piger 901 Bacteria Bacteria 595 1.2299999999999994e-165   NTclustered gi|2548467271|emb|OX636706.1| 901 g21058 i0 98.24 162.504249291785 341 4 96 1 15 353 515370 515710 Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1 blastn 57364 595 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio piger
26726686 26726686 PRJNA390533_P_NODE_17161_length_435_cov_1.393939_g16146_i0 PRJNA390533 17161 435 1.393939 6.06363465 Candidatus Electrothrix yaqonensis 3344825 Bacteria Bacteria 75.1 7.15e-14   NR XOF33614.1 3344825 g16146 i0 58 0.475862068965517 69 29 47.6 0 435 229 76 144 XOF33614.1 MAG: hypothetical protein ACL93V_16730 [Candidatus Electrothrix sp. YB6] diamond 207 75.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix yaqonensis
27359912 27359912 PRJNA390533_P_NODE_50723_length_150_cov_1.360360_g49696_i0 PRJNA390533 50723 150 1.36036 2.04054 Desulfobulbaceae bacterium 2053307 Bacteria Bacteria 42.7 0.0107   NR HHL33362.1 2053307 g49696 i0 62.1 1.2 29 11 58 0 150 64 273 301 HHL33362.1 thermonuclease family protein [Desulfobulbaceae bacterium] diamond 180 42.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium
27580723 27580723 PRJNA390533_P_NODE_37284_length_194_cov_1.496774_g36257_i0 PRJNA390533 37284 194 1.496774 2.90374156 Desulfosarcinaceae bacterium 3036616 Bacteria Bacteria 80.5 1.98e-16   NR MEJ2038687.1 3036616 g36257 i0 65 0.927835051546392 60 21 92.8 0 181 2 189 248 MEJ2038687.1 AraC family transcriptional regulator [Desulfosarcinaceae bacterium] diamond 180 80.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfosarcinaceae   Desulfosarcinaceae bacterium
27724292 27724292 PRJNA390533_P_NODE_33924_length_216_cov_1.288136_g32897_i0 PRJNA390533 33924 216 1.288136 2.78237376 Candidatus Desulfatibia 2841680 Bacteria Bacteria 132 2.5799999999999996e-35   NR MEW6594634.1 2202153 g32897 i0 81.4 11.6527777777778 70 13 97.2 0 211 2 214 283 MEW6594634.1 peptide-methionine (R)-S-oxide reductase MsrB [Thermodesulfobacteriota bacterium] diamond 2517 132 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27739031 27739031 PRJNA390533_P_NODE_47604_length_156_cov_1.649573_g46577_i0 PRJNA390533 47604 156 1.649573 2.57333388 Candidatus Magnetoglobus multicellularis str. Araruama 890399 Bacteria Bacteria 52 9.18e-7   NR ETR73312.1 890399 g46577 i0 42.9 0.942307692307692 49 28 94.2 0 5 151 25 73 ETR73312.1 MAG: hypothetical protein OMM_07014 [Candidatus Magnetoglobus multicellularis str. Araruama] diamond 147 52 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Candidatus Magnetoglobus Candidatus Magnetoglobus multicellularis
28149248 28149248 PRJNA390533_P_NODE_38705_length_187_cov_0.878378_g37678_i0 PRJNA390533 38705 187 0.878378 1.64256686 Geomonas sp. RF6 2897342 Bacteria Bacteria 72.4 6.14e-13   NR WP_230997250.1 2897342 g37678 i0 57.4 3.83422459893048 61 26 97.9 0 187 5 271 331 WP_230997250.1 hypothetical protein [Geomonas sp. RF6] diamond 717 72.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geomonas Geomonas sp. RF6
28386912 28386912 PRJNA390533_P_NODE_34626_length_211_cov_1.395349_g33599_i0 PRJNA390533 34626 211 1.395349 2.94418639 Pseudomonadati 3379134 Bacteria Bacteria 76.3 7.81e-15   NR HBG17989.1 2053307 g33599 i0 53.8 3.75355450236967 65 21 89.6 2 21 209 31 88 HBG17989.1 FRG domain-containing protein [Desulfobulbaceae bacterium] diamond 792 76.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium
28591249 28591249 PRJNA390533_P_NODE_45727_length_161_cov_1.327869_g44700_i0 PRJNA390533 45727 161 1.327869 2.13786909 Syntrophaceae bacterium 2052184 Bacteria Bacteria 79 1.59e-15   NR MBN1472205.1 2052184 g44700 i0 66 0.987577639751553 53 18 98.8 0 161 3 217 269 MBN1472205.1 glycosyltransferase [Syntrophaceae bacterium] diamond 159 79 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Syntrophaceae   Syntrophaceae bacterium
28780452 28780452 PRJNA390533_P_NODE_49767_length_151_cov_1.919643_g48740_i0 PRJNA390533 49767 151 1.919643 2.89866093 Desulfovermiculus sp. 2821143 Bacteria Bacteria 61.6 2.3e-9   NR MDZ7760072.1 2821143 g48740 i0 59.2 6.67549668874172 49 20 97.4 0 1 147 278 326 MDZ7760072.1 flippase [Desulfovermiculus sp.] diamond 1008 61.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae Desulfovermiculus Desulfovermiculus sp.
29002034 29002034 PRJNA390533_P_NODE_34328_length_213_cov_1.741379_g33301_i0 PRJNA390533 34328 213 1.741379 3.70913727 Syntrophales bacterium 2928017 Bacteria Bacteria 50.1 1.36e-5   NR HET6460672.1 2928017 g33301 i0 38.5 1.90140845070423 65 40 91.5 0 2 196 45 109 HET6460672.1 hypothetical protein [Syntrophales bacterium] diamond 405 50.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales     Syntrophales bacterium
29870968 29870968 PRJNA390533_P_NODE_23951_length_326_cov_1.543554_g22925_i0 PRJNA390533 23951 326 1.543554 5.03198604 Bacteria 2 Bacteria Bacteria 113 2.3699999999999997e-30   NR PIU30719.1 1974095 g22925 i0 74.3 3.3680981595092 70 18 64.4 0 272 63 1 70 PIU30719.1 MAG: hypothetical protein COT06_12065 [Syntrophobacteraceae bacterium CG07_land_8_20_14_0_80_61_8] diamond 1098 113 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae   Syntrophobacteraceae bacterium CG07_land_8_20_14_0_80_61_8
31212262 31212262 PRJNA390533_P_NODE_28195_length_274_cov_12.378723_g27168_i0 PRJNA390533 28195 274 12.378723 33.91770102 Desulfovibrionaceae bacterium 2049043 Bacteria Bacteria 44.3 0.0152   NR MBQ4133630.1 2049043 g27168 i0 35.3 0.558394160583942 51 33 55.8 0 87 239 379 429 MBQ4133630.1 HDIG domain-containing protein [Desulfovibrionaceae bacterium] diamond 153 44.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae bacterium
31655332 31655332 PRJNA390533_P_NODE_33537_length_218_cov_19.547486_g32510_i0 PRJNA390533 33537 218 19.547486 42.61351948 Desulfovibrionaceae bacterium 2049043 Bacteria Bacteria 48.1 3.37e-4   NR MBQ4133630.1 2049043 g32510 i0 37.3 0.701834862385321 51 32 70.2 0 31 183 379 429 MBQ4133630.1 HDIG domain-containing protein [Desulfovibrionaceae bacterium] diamond 153 48.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae bacterium
31908587 31908587 PRJNA390533_P_NODE_48897_length_153_cov_1.675439_g47870_i0 PRJNA390533 48897 153 1.675439 2.56342167 Geobacteraceae bacterium 2282154 Bacteria Bacteria 46.2 6.35e-4   NR MCE1226612.1 2282154 g47870 i0 76 0.490196078431373 25 6 49 0 77 151 1 25 MCE1226612.1 N-acetylneuraminate synthase family protein [Geobacteraceae bacterium] diamond 75 46.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae   Geobacteraceae bacterium
31940051 31940051 PRJNA390533_P_NODE_28617_length_268_cov_18.445415_g27590_i0 PRJNA390533 28617 268 18.445415 49.4337122 Desulfovibrionaceae bacterium 2049043 Bacteria Bacteria 44.7 0.0104   NR MBQ4133630.1 2049043 g27590 i0 37.3 0.57089552238806 51 32 57.1 0 81 233 379 429 MBQ4133630.1 HDIG domain-containing protein [Desulfovibrionaceae bacterium] diamond 153 44.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae bacterium
32130266 32130266 PRJNA390533_P_NODE_46838_length_158_cov_1.605042_g45811_i0 PRJNA390533 46838 158 1.605042 2.53596636 Desulfosarcina alkanivorans 571177 Bacteria Bacteria 47.4 6.55e-5   NR BBO67033.1 571177 g45811 i0 38.6 1.67088607594937 44 27 83.5 0 149 18 4 47 BBO67033.1 hypothetical protein DSCA_09630 [Desulfosarcina alkanivorans] diamond 264 47.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfosarcinaceae Desulfosarcina Desulfosarcina alkanivorans
32604469 32604469 PRJNA390533_P_NODE_36800_length_197_cov_1.126582_g35773_i0 PRJNA390533 36800 197 1.126582 2.21936654 Syntrophobacteraceae bacterium 2052185 Bacteria Bacteria 46.2 5.03e-4   NR HBZ54646.1 2052185 g35773 i0 47.6 0.639593908629442 42 22 64 0 130 5 1 42 HBZ54646.1 hypothetical protein [Syntrophobacteraceae bacterium] diamond 126 46.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae   Syntrophobacteraceae bacterium
32698833 32698833 PRJNA390533_P_NODE_28620_length_268_cov_15.659389_g27593_i0 PRJNA390533 28620 268 15.659389 41.96716252 Desulfovibrionaceae bacterium 2049043 Bacteria Bacteria 47 0.00159   NR MBQ4133630.1 2049043 g27593 i0 37.3 0.57089552238806 51 32 57.1 0 81 233 379 429 MBQ4133630.1 HDIG domain-containing protein [Desulfovibrionaceae bacterium] diamond 153 47 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae bacterium

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