RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 18 ✖

bioproject 1

  • PRJNA867519 · 18 ✖

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
11051898 11051898 PRJNA867519_P_NODE_3789_length_539_cov_2.263948_g3637_i0 PRJNA867519 3789 539 2.263948 12.20267972 Pseudomonadati 3379134 Bacteria Bacteria 298 1.23e-93   NR WP_136513786.1 2570226 g3637 i0 77.7 9.95176252319109 179 40 99.6 0 539 3 468 646 WP_136513786.1 5-methyltetrahydropteroyltriglutamate--homocysteine S-methyltransferase [Geomonas edaphica] diamond 5364 298 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geomonas Geomonas edaphica
13601923 13601923 PRJNA867519_P_NODE_8631_length_380_cov_1.270358_g8477_i0 PRJNA867519 8631 380 1.270358 4.8273604 Desulfuromonas thiophila 57664 Bacteria Bacteria 52.8 0.036   NTclustered gi|2621701248|emb|OY759968.1| 57664 g8477 i0 100 0.0736842105263158 28 0 7 0 169 196 1674291 1674318 MAG: Desulfuromonas thiophila isolate 5d13b52e-9f0b-4035-9b75-2cca1ad4870f genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas thiophila
26770330 26770330 PRJNA867519_P_NODE_7401_length_405_cov_2.114458_g7247_i0 PRJNA867519 7401 405 2.114458 8.5635549 Syntrophales bacterium 2928017 Bacteria Bacteria 59.3 1.78e-7   NR HOI73644.1 2928017 g7247 i0 54.7 2.57777777777778 53 23 38.5 1 28 183 141 193 HOI73644.1 hemopexin repeat-containing protein [Syntrophales bacterium] diamond 1044 59.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales     Syntrophales bacterium
27687352 27687352 PRJNA867519_P_NODE_24464_length_255_cov_1.670330_g24310_i0 PRJNA867519 24464 255 1.67033 4.2593415 Desulfamplus sp. 2006184 Bacteria Bacteria 43.5 0.0234   NR MBF0257844.1 2006184 g24310 i0 44 0.588235294117647 50 28 58.8 0 190 41 387 436 MBF0257844.1 DUF1566 domain-containing protein [Desulfamplus sp.] diamond 150 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfamplus Desulfamplus sp.
28255211 28255211 PRJNA867519_P_NODE_8186_length_388_cov_2.568254_g8032_i0 PRJNA867519 8186 388 2.568254 9.96482552 Candidatus Electrothrix sp. AR5 2202843 Bacteria Bacteria 95.5 4.1100000000000006e-21   NR MCI5125321.1 2202843 g8032 i0 39.7 4.65463917525773 121 71 92 2 27 383 130 250 MCI5125321.1 hypothetical protein [Candidatus Electrothrix sp. AR5] diamond 1806 95.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix sp. AR5
28602732 28602732 PRJNA867519_P_NODE_22607_length_264_cov_1.335079_g22453_i0 PRJNA867519 22607 264 1.335079 3.52460856 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 72.4 1.36e-12   NR MCX8042667.1 2202153 g22453 i0 68.6 0.579545454545455 51 16 58 0 3 155 314 364 MCX8042667.1 aspartate kinase [Thermodesulfobacteriota bacterium] diamond 153 72.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
29265476 29265476 PRJNA867519_P_NODE_27869_length_248_cov_0.880000_g27715_i0 PRJNA867519 27869 248 0.88 2.1824 Desulfobacterales bacterium 2044940 Bacteria Bacteria 43.5 0.0195   NR HID59507.1 2044940 g27715 i0 32.9 3.60483870967742 73 45 85.9 3 33 245 42 112 HID59507.1 pyrroline-5-carboxylate reductase [Desulfobacterales bacterium] diamond 894 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
30094710 30094710 PRJNA867519_P_NODE_31672_length_243_cov_2.894118_g31518_i0 PRJNA867519 31672 243 2.894118 7.03270674 Pseudomonadati 3379134 Bacteria Bacteria 99.8 5.39e-24   NR WP_144303854.1 54767 g31518 i0 61.3 21.5925925925926 80 31 98.8 0 242 3 74 153 WP_144303854.1 NAD(P)H:quinone oxidoreductase [Oceanidesulfovibrio indonesiensis] diamond 5247 99.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Oceanidesulfovibrio Oceanidesulfovibrio indonesiensis
30403120 30403120 PRJNA867519_P_NODE_16193_length_294_cov_1.393665_g16039_i0 PRJNA867519 16193 294 1.393665 4.0973751 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 81.3 1.94e-15   NR HAO22905.1 2049433 g16039 i0 38.1 0.989795918367347 97 59 98 1 6 293 345 441 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 291 81.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
30434641 30434641 PRJNA867519_P_NODE_29053_length_247_cov_0.885057_g28899_i0 PRJNA867519 29053 247 0.885057 2.18609079 Desulfosalsimonadaceae bacterium 3060584 Bacteria Bacteria 52.8 1.13e-5   NR MDO9263437.1 3060584 g28899 i0 37 8.11336032388664 73 45 88.7 1 1 219 379 450 MDO9263437.1 polya polymerase [Desulfosalsimonadaceae bacterium] diamond 2004 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfosalsimonadaceae   Desulfosalsimonadaceae bacterium
30560437 30560437 PRJNA867519_P_NODE_27153_length_249_cov_0.875000_g26999_i0 PRJNA867519 27153 249 0.875 2.17875 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 62 3.82e-9   NR HLC18656.1 2202153 g26999 i0 51.7 0.72289156626506 60 29 72.3 0 1 180 179 238 HLC18656.1 slipin family protein [Thermodesulfobacteriota bacterium] diamond 180 62 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
30908381 30908381 PRJNA867519_P_NODE_4494_length_501_cov_3.406542_g4341_i0 PRJNA867519 4494 501 3.406542 17.06677542 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 89 4.31e-17   NR HAO22905.1 2049433 g4341 i0 34.4 0.784431137724551 131 86 78.4 0 499 107 442 572 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 393 89 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
31043085 31043085 PRJNA867519_P_NODE_25015_length_252_cov_1.720670_g24861_i0 PRJNA867519 25015 252 1.72067 4.3360884 Pseudomonadati 3379134 Bacteria Bacteria 104 5.83e-24   NR WLE97067.1 1859133 g24861 i0 64.5 12.0357142857143 76 27 90.5 0 17 244 364 439 WLE97067.1 MAG: group 1 truncated hemoglobin [Candidatus Electrothrix communis] diamond 3033 104 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix communis
31287312 31287312 PRJNA867519_P_NODE_14075_length_312_cov_4.410042_g13921_i0 PRJNA867519 14075 312 4.410042 13.75933104 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 91.7 3e-19   NR MDH3723783.1 2049433 g13921 i0 47.4 1.85576923076923 97 48 91.3 2 311 27 142 237 MDH3723783.1 beta-lactamase family protein [Desulfobacteraceae bacterium] diamond 579 91.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
31888324 31888324 PRJNA867519_P_NODE_22237_length_266_cov_0.911917_g22083_i0 PRJNA867519 22237 266 0.911917 2.42569922 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 132 9.26e-38   NR GJM17744.1 2202153 g22083 i0 70.5 1.98496240601504 88 26 99.2 0 1 264 1 88 GJM17744.1 MAG: hypothetical protein DHS20C13_30710 [Thermodesulfobacteriota bacterium] diamond 528 132 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
32204904 32204904 PRJNA867519_P_NODE_23398_length_260_cov_2.133690_g23244_i0 PRJNA867519 23398 260 2.13369 5.547594 Desulfacinum infernum 35837 Bacteria Bacteria 122 5.2400000000000005e-33   NR WP_073038868.1 35837 g23244 i0 64.3 0.969230769230769 84 30 96.9 0 1 252 32 115 WP_073038868.1 3'-5' exonuclease [Desulfacinum infernum] diamond 252 122 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae Desulfacinum Desulfacinum infernum
32236843 32236843 PRJNA867519_P_NODE_14798_length_306_cov_1.321888_g14644_i0 PRJNA867519 14798 306 1.321888 4.04497728 Thermodesulfatator atlanticus 501497 Bacteria Bacteria 43.5 0.0394   NR WP_022854346.1 501497 g14644 i0 28.4 0.725490196078431 74 53 72.5 0 56 277 191 264 WP_022854346.1 replication-associated recombination protein A [Thermodesulfatator atlanticus] diamond 222 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Thermodesulfobacteria Thermodesulfobacteriales Thermodesulfatatoraceae Thermodesulfatator Thermodesulfatator atlanticus
32236858 32236858 PRJNA867519_P_NODE_25718_length_251_cov_0.865169_g25564_i0 PRJNA867519 25718 251 0.865169 2.17157419 Desulfarculaceae bacterium 2528248 Bacteria Bacteria 46.6 0.00123   NR MCF8035073.1 2528248 g25564 i0 31.6 0.908366533864542 76 46 84.9 2 39 251 24 98 MCF8035073.1 CVNH domain-containing protein [Desulfarculaceae bacterium] diamond 228 46.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfarculia Desulfarculales Desulfarculaceae   Desulfarculaceae 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);;