RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 17 ✖

bioproject 1

  • PRJNA796753 · 17 ✖

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
13534374 13534374 PRJNA796753_P_NODE_33511_length_268_cov_1.974359_g33199_i0 PRJNA796753 33511 268 1.974359 5.29128212 Desulfofustis limnaeus 2740163 Bacteria Bacteria 219 2.2899999999999998e-52   NTclustered gi|2211518257|dbj|AP025516.1| 2740163 g33199 i0 81.716 394 268 43 99 5 3 268 1952284 1952021 Desulfobulbaceae bacterium PPLL DNA, complete genome blastn 105592 219 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfofustis Desulfofustis limnaeus
15245102 15245102 PRJNA796753_P_NODE_27492_length_288_cov_1.432558_g27180_i0 PRJNA796753 27492 288 1.432558 4.12576704 Pseudomonadati 3379134 Bacteria Bacteria 100 5.2599999999999997e-23   NR WP_020879673.1 941449 g27180 i0 73.8 4.64583333333333 65 17 67.7 0 86 280 234 298 WP_020879673.1 magnesium transporter CorA family protein [Desulfovibrio sp. X2] diamond 1338 101 0.99009900990099 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp. X2
25007149 25007149 PRJNA796753_P_NODE_38020_length_253_cov_1.677778_g37708_i0 PRJNA796753 38020 253 1.677778 4.24477834 Candidatus Electrothrix scaldis 3082418 Bacteria Bacteria 52.8 0.023   NTclustered gi|2620278315|gb|CP138355.1| 3082418 g37708 i0 100 0.110671936758893 28 0 11 0 55 82 3887930 3887957 MAG: Candidatus Electrothrix scaldis isolate GW3-3 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix scaldis
26990352 26990352 PRJNA796753_P_NODE_7202_length_507_cov_1.412442_g6893_i0 PRJNA796753 7202 507 1.412442 7.16108094 Candidatus Electrothrix sp. AUS1_2 2249218 Bacteria Bacteria 73.2 8.94e-12   NR MCI5159556.1 2249218 g6893 i0 39.8 2.06508875739645 93 50 52.1 4 287 24 36 127 MCI5159556.1 hypothetical protein [Candidatus Electrothrix sp. AUS1_2] diamond 1047 73.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix sp. AUS1_2
27464808 27464808 PRJNA796753_P_NODE_24023_length_306_cov_0.991416_g23711_i0 PRJNA796753 24023 306 0.991416 3.03373296 Desulfobacterales bacterium 2044940 Bacteria Bacteria 72.4 1.76e-13   NR HEA68917.1 2044940 g23711 i0 51.6 2.48039215686275 62 30 60.8 0 186 1 4 65 HEA68917.1 RidA family protein [Desulfobacterales bacterium] diamond 759 72.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
27505553 27505553 PRJNA796753_P_NODE_15463_length_364_cov_0.848797_g15151_i0 PRJNA796753 15463 364 0.848797 3.08962108 Bacteria 2 Bacteria Bacteria 107 2.67e-27   NR UCG05442.1 2044940 g15151 i0 48.1 3.54395604395604 104 49 85.7 1 9 320 10 108 UCG05442.1 MAG: gamma carbonic anhydrase family protein [Desulfobacterales bacterium] diamond 1290 107 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
27884239 27884239 PRJNA796753_P_NODE_4345_length_644_cov_1.073555_g4043_i0 PRJNA796753 4345 644 1.073555 6.9136942 Bacteria 2 Bacteria Bacteria 62 3.43e-7   NR WP_306532627.1 46610 g4043 i0 31.5 2.81832298136646 200 114 92.7 6 6 602 664 841 WP_306532627.1 thrombospondin type 3 repeat-containing protein [Geobacter sp.] diamond 1815 62 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
28547546 28547546 PRJNA796753_P_NODE_18687_length_338_cov_1.162264_g18375_i0 PRJNA796753 18687 338 1.162264 3.92845232 root 1 Root_unresolved Root_unresolved 135 1.42e-38   NR MEW6669911.1 2202153 g18375 i0 55 4.96153846153846 111 50 98.5 0 333 1 2 112 MEW6669911.1 RidA family protein [Thermodesulfobacteriota bacterium] diamond 1677 136 0.992647058823529 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
28601438 28601438 PRJNA796753_P_NODE_41327_length_250_cov_0.870056_g41015_i0 PRJNA796753 41327 250 0.870056 2.17514 Candidatus Dadabacteria bacterium 2080303 Bacteria Bacteria 58.9 7.87e-8   NR RMD83363.1 2080303 g41015 i0 70 0.48 40 12 48 0 1 120 254 293 RMD83363.1 MAG: hypothetical protein D6815_06795, partial [Candidatus Dadabacteria bacterium] diamond 120 58.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Candidatus Dadabacteria       Candidatus Dadabacteria bacterium
28633132 28633132 PRJNA796753_P_NODE_36667_length_258_cov_1.248649_g36355_i0 PRJNA796753 36667 258 1.248649 3.22151442 Candidatus Electrothrix gigas 2202844 Bacteria Bacteria 49.7 1.67e-4   NR MCI5197535.1 2202844 g36355 i0 40.3 0.779069767441861 67 39 77.9 1 7 207 350 415 MCI5197535.1 hypothetical protein [Candidatus Electrothrix gigas] diamond 201 49.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix gigas
28664562 28664562 PRJNA796753_P_NODE_4587_length_627_cov_5.490975_g4283_i0 PRJNA796753 4587 627 5.490975 34.42841325 Desulfocurvus vexinensis 399548 Bacteria Bacteria 114 5.56e-29   NR WP_028587017.1 399548 g4283 i0 71.4 0.368421052631579 77 22 36.8 0 443 213 2 78 WP_028587017.1 RNA recognition motif domain-containing protein [Desulfocurvus vexinensis] diamond 231 114 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfocurvus Desulfocurvus vexinensis
29075150 29075150 PRJNA796753_P_NODE_32728_length_271_cov_1.535354_g32416_i0 PRJNA796753 32728 271 1.535354 4.16080934 Desulfovibrio aminophilus 81425 Bacteria Bacteria 44.7 0.00921   NR WP_250783553.1 81425 g32416 i0 41 1.8929889298893 78 36 76.4 3 42 248 42 118 WP_250783553.1 L,D-transpeptidase family protein [Desulfovibrio aminophilus] diamond 513 44.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio aminophilus
29746843 29746843 PRJNA796753_P_NODE_54970_length_235_cov_2.283951_g54658_i0 PRJNA796753 54970 235 2.283951 5.36728485 Pseudomonadati 3379134 Bacteria Bacteria 69.7 5.37e-12   NR RNC66705.1 2099678 g54658 i0 58.1 1.69787234042553 62 24 76.6 1 180 1 162 223 RNC66705.1 MAG: caspase family protein [Desulfuromonadales bacterium] diamond 399 69.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales     Desulfuromonadales bacterium
31412684 31412684 PRJNA796753_P_NODE_18456_length_340_cov_0.730337_g18144_i0 PRJNA796753 18456 340 0.730337 2.4831458 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 55.8 5.3e-7   NR MCK4782570.1 2049433 g18144 i0 44.6 0.732352941176471 83 39 71.5 3 4 246 58 135 MCK4782570.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 249 55.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
31697347 31697347 PRJNA796753_P_NODE_23297_length_310_cov_0.974684_g22985_i0 PRJNA796753 23297 310 0.974684 3.0215204 Desulfobacterales bacterium 2044940 Bacteria Bacteria 45.4 0.00247   NR MCU0599456.1 2044940 g22985 i0 27.8 0.870967741935484 90 47 87.1 2 32 301 6 77 MCU0599456.1 hypothetical protein [Desulfobacterales bacterium] diamond 270 45.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
32362031 32362031 PRJNA796753_P_NODE_30299_length_279_cov_1.359223_g29987_i0 PRJNA796753 30299 279 1.359223 3.79223217 Desulfobacca sp. 2067990 Bacteria Bacteria 45.8 0.00497   NR MDD3581387.1 2067990 g29987 i0 35.2 0.946236559139785 88 53 90.3 2 25 276 748 835 MDD3581387.1 PAS domain S-box protein [Desulfobacca sp.] diamond 264 45.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobaccia Desulfobaccales Desulfobaccaceae Desulfobacca Desulfobacca sp.
32551907 32551907 PRJNA796753_P_NODE_43379_length_248_cov_0.880000_g43067_i0 PRJNA796753 43379 248 0.88 2.1824 Thermodesulfobacterium geofontis 1295609 Bacteria Bacteria 44.3 0.008   NR PMP68112.1 1295609 g43067 i0 50 1.71774193548387 38 19 46 0 248 135 159 196 PMP68112.1 MAG: 50S rRNA methyltransferase [Thermodesulfobacterium geofontis] diamond 426 44.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Thermodesulfobacteria Thermodesulfobacteriales Thermodesulfobacteriaceae Thermodesulfobacterium Thermodesulfobacterium geofontis

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