RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA745553", 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

  • PRJNA745553 · 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
1198589 1198589 PRJNA745553_S_NODE_16961_length_300_cov_1.356828_g16766_i0 PRJNA745553 16961 300 1.356828 4.070484 Desulfobulbus 893 Bacteria Bacteria 499 8.29e-137   NTclustered gi|470487339|ref|NR_076814.1| 894 g16766 i0 96.667 216.113333333333 300 10 100 0 1 300 612 911 Desulfobulbus propionicus strain 1pr3 23S ribosomal RNA gene, complete sequence blastn 64834 499 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus Desulfobulbus propionicus
2000366 2000366 PRJNA745553_S_NODE_28342_length_230_cov_4.509554_g28147_i0 PRJNA745553 28342 230 4.509554 10.3719742 uncultured Desulfobulbus sp. 239745 Bacteria Bacteria 361 3e-95   NTclustered gi|2621704320|emb|OY760916.1| 239745 g28147 i0 96.364 276.752173913043 220 7 95 1 12 230 395387 395168 MAG: uncultured Desulfobulbus sp. isolate 7a05128d-adad-4d17-beb6-ff3d102eb21b genome assembly, chromosome: 1 blastn 63653 361 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus uncultured Desulfobulbus sp.
4552698 4552698 PRJNA745553_S_NODE_20244_length_275_cov_1.524752_g20049_i0 PRJNA745553 20244 275 1.524752 4.193068 Desulfovibrio sp. 86 2666132 Bacteria Bacteria 303 6.32e-78   NTclustered gi|1862956133|emb|LR738849.1| 2666132 g20049 i0 87.218 10.8436363636364 266 34 97 0 1 266 1483812 1484077 Desulfovibrio sp. 86 genome assembly, chromosome: DESU86 blastn 2982 303 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp. 86
5026874 5026874 PRJNA745553_S_NODE_18004_length_291_cov_1.733945_g17809_i0 PRJNA745553 18004 291 1.733945 5.04577995 Desulfovibrio 872 Bacteria Bacteria 185 2.5499999999999994e-42   NTclustered gi|559114142|tpe|HG525931.1| 525146 g17809 i0 80.46 16.9896907216495 261 36 87 12 17 270 253 1 TPA: Desulfovibrio desulfuricans subsp. desulfuricans str. ATCC 27774 tmRNA gene Desul_desul_27774 blastn 4944 185 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
18575888 18575888 PRJNA745553_S_NODE_22495_length_261_cov_1.686170_g22300_i0 PRJNA745553 22495 261 1.68617 4.4009037 Candidatus Electrothrix sp. GW3-4 3126740 Bacteria Bacteria 52.8 0.024   NTclustered gi|2706403704|gb|CP147990.1| 3126740 g22300 i0 100 0.10727969348659 28 0 11 0 5 32 2955193 2955220 MAG: Candidatus Electrothrix sp. GW3-4 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix sp. GW3-4
19851246 19851246 PRJNA745553_S_NODE_23076_length_257_cov_5.483696_g22881_i0 PRJNA745553 23076 257 5.483696 14.09309872 uncultured Mailhella sp. 1981031 Bacteria Bacteria 302 2.1e-77   NTclustered gi|2729058701|emb|OZ007001.1| 1981031 g22881 i0 91.364 136.887159533074 220 19 86 0 19 238 1893664 1893883 MAG: uncultured Mailhella sp. isolate metabat2_pooled_hifiasm.920 MAG genome assembly, chromosome: 1 blastn 35180 302 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Mailhella uncultured Mailhella sp.
21126745 21126745 PRJNA745553_S_NODE_1997_length_655_cov_6.013746_g1827_i0 PRJNA745553 1997 655 6.013746 39.3900363 Desulfovibrio piger 901 Bacteria Bacteria 1188 0   NTclustered gi|2548467271|emb|OX636706.1| 901 g1827 i0 99.39 85.0564885496183 656 2 99 1 1 654 1638569 1639224 Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1 blastn 55712 1188 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio piger
22401701 22401701 PRJNA745553_S_NODE_25678_length_245_cov_3.337209_g25483_i0 PRJNA745553 25678 245 3.337209 8.17616205 Desulfolutivibrio sulfodismutans 63561 Bacteria Bacteria 135 2.13e-27   NTclustered gi|1863422180|gb|CP045504.1| 1121464 g25483 i0 79.592 54.2816326530612 196 34 78 6 28 219 1155193 1155000 Desulfolutivibrio sulfodismutans DSM 3696 chromosome, complete genome blastn 13299 135 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfolutivibrio Desulfolutivibrio sulfodismutans
23677322 23677322 PRJNA745553_S_NODE_28779_length_227_cov_3.701299_g28584_i0 PRJNA745553 28779 227 3.701299 8.40194873 uncultured Desulfovibrio sp. 167968 Bacteria Bacteria 152 1.94e-32   NTclustered gi|1133590960|gb|KY480240.1| 167968 g28584 i0 94.118 39.1674008810573 102 2 43 3 9 106 141 242 Uncultured Desulfovibrio sp. clone CCB7487 16S ribosomal RNA gene, partial sequence blastn 8891 152 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio uncultured Desulfovibrio sp.
25425271 25425271 PRJNA745553_S_NODE_23060_length_257_cov_6.875000_g22865_i0 PRJNA745553 23060 257 6.875 17.66875 Pseudomonadati 3379134 Bacteria Bacteria 117 8.17e-22   NTclustered gi|2893358420|emb|OZ220712.1| 2202153 g22865 i0 76.856 40.9299610894942 229 39 86 12 11 232 1713385 1713606 MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1 blastn 10519 117 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27242334 27242334 PRJNA745553_S_NODE_19243_length_282_cov_1.416268_g19048_i0 PRJNA745553 19243 282 1.416268 3.99387576 Desulfovibrio sp. 885 Bacteria Bacteria 112 5.77e-28   NR MCX4309192.1 885 g19048 i0 100 1.14893617021277 54 0 57.4 0 21 182 244 297 MCX4309192.1 PHP domain-containing protein [Desulfovibrio sp.] diamond 324 112 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
27968712 27968712 PRJNA745553_S_NODE_17945_length_291_cov_4.417431_g17750_i0 PRJNA745553 17945 291 4.417431 12.85472421 Desulfovibrio sp. 885 Bacteria Bacteria 144 6.2999999999999986e-43   NR MCX4310619.1 885 g17750 i0 100 1.44329896907216 70 0 72.2 0 270 61 14 83 MCX4310619.1 KOW motif-containing protein [Desulfovibrio sp.] diamond 420 144 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
28221181 28221181 PRJNA745553_S_NODE_886_length_797_cov_23.262431_g774_i0 PRJNA745553 886 797 23.262431 185.40157507 Desulfovibrio sp. 885 Bacteria Bacteria 481 2.15e-167   NR MCX4310245.1 885 g774 i0 99.6 0.895859473023839 238 1 89.6 0 21 734 82 319 MCX4310245.1 aminopeptidase [Desulfovibrio sp.] diamond 714 481 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
29989610 29989610 PRJNA745553_S_NODE_29711_length_214_cov_5.517730_g29516_i0 PRJNA745553 29711 214 5.51773 11.8079422 Desulfovibrio sp. 885 Bacteria Bacteria 122 3.1000000000000003e-30   NR MCX4309225.1 885 g29516 i0 100 0.883177570093458 63 0 88.3 0 24 212 508 570 MCX4309225.1 homocysteine S-methyltransferase family protein [Desulfovibrio sp.] diamond 189 122 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
30306001 30306001 PRJNA745553_S_NODE_27712_length_235_cov_2.191358_g27517_i0 PRJNA745553 27712 235 2.191358 5.1496913 Desulfarculus baarsii 453230 Bacteria Bacteria 62.8 2.77e-9   NR WP_013257361.1 453230 g27517 i0 65.2 2.60425531914894 46 16 58.7 0 3 140 435 480 WP_013257361.1 cysteine--tRNA ligase [Desulfarculus baarsii] diamond 612 62.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfarculia Desulfarculales Desulfarculaceae Desulfarculus Desulfarculus baarsii
30379051 30379051 PRJNA745553_S_NODE_6332_length_463_cov_3.602564_g6138_i0 PRJNA745553 6332 463 3.602564 16.67987132 Bacteria 2 Bacteria Bacteria 45.8 0.0248   NR MBF0222522.1 2053307 g6138 i0 37.4 1.08207343412527 99 54 64.1 4 39 335 250 340 MBF0222522.1 NADH:ubiquinone reductase (Na(+)-transporting) subunit B [Desulfobulbaceae bacterium] diamond 501 45.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium
31632915 31632915 PRJNA745553_S_NODE_3396_length_568_cov_3.555556_g3212_i0 PRJNA745553 3396 568 3.555556 20.19555808 Desulfovibrio sp. 885 Bacteria Bacteria 203 2.04e-64   NR MCX4310708.1 885 g3212 i0 99 0.538732394366197 102 1 53.9 0 567 262 2 103 MCX4310708.1 STAS-like domain-containing protein [Desulfovibrio sp.] diamond 306 203 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
31759448 31759448 PRJNA745553_S_NODE_21917_length_264_cov_3.026178_g21722_i0 PRJNA745553 21917 264 3.026178 7.98910992 uncultured Desulfobacterales bacterium HF 246132 Bacteria Bacteria 46.6 5.88e-4   NR ADI17936.1 710741 g21722 i0 71 0.704545454545455 31 9 35.2 0 11 103 81 111 ADI17936.1 hypothetical protein [uncultured Desulfobacterales bacterium HF0200_07G10] diamond 186 46.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     uncultured Desulfobacterales bacterium HF0200_07G10

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