RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA879314" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA879314 · 20 ✖

analysis 1

  • blastn · 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
857844 857844 PRJNA879314_P_NODE_10101_length_244_cov_0.912281_g10051_i0 PRJNA879314 10101 244 0.912281 2.22596564 Nitratidesulfovibrio sp. HK-II 2009266 Bacteria Bacteria 403 5.27e-108   NTclustered gi|2791413552|dbj|AP036014.1| 2009266 g10051 i0 96.694 5.91803278688525 242 8 99 0 1 242 1543364 1543605 Nitratidesulfovibrio sp. HK-II DNA, complete genome blastn 1444 403 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio sp. HK-II
857847 857847 PRJNA879314_P_NODE_10321_length_243_cov_0.917647_g10271_i0 PRJNA879314 10321 243 0.917647 2.22988221 Pelobacter propionicus 29543 Bacteria Bacteria 315 2.5299999999999998e-81   NTclustered gi|118501159|gb|CP000482.1| 338966 g10271 i0 95 3.66255144032922 200 10 82 0 44 243 278038 277839 Pelobacter propionicus DSM 2379, complete genome blastn 890 315 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Pelobacter Pelobacter propionicus
2133280 2133280 PRJNA879314_P_NODE_9742_length_244_cov_0.912281_g9692_i0 PRJNA879314 9742 244 0.912281 2.22596564 Desulfomicrobium sp. ZS1 2952228 Bacteria Bacteria 357 4.16e-94   NTclustered gi|2269306666|gb|CP100351.1| 2952228 g9692 i0 93.033 26.8811475409836 244 17 100 0 1 244 3411905 3412148 Desulfomicrobium sp. ZS1 chromosome, complete genome blastn 6559 357 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium sp. ZS1
4686203 4686203 PRJNA879314_P_NODE_10184_length_244_cov_0.912281_g10134_i0 PRJNA879314 10184 244 0.912281 2.22596564 Desulfobulbus propionicus 894 Bacteria Bacteria 451 1.86e-122   NTclustered gi|320120648|gb|CP002364.1| 577650 g10134 i0 100 1 244 0 100 0 1 244 502730 502487 Desulfobulbus propionicus DSM 2032, complete genome blastn 244 451 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus Desulfobulbus propionicus
4686274 4686274 PRJNA879314_P_NODE_6004_length_251_cov_0.876404_g5954_i0 PRJNA879314 6004 251 0.876404 2.19977404 Pelobacter propionicus 29543 Bacteria Bacteria 370 5.53e-98   NTclustered gi|118501159|gb|CP000482.1| 338966 g5954 i0 93.227 1 251 17 100 0 1 251 2901895 2902145 Pelobacter propionicus DSM 2379, complete genome blastn 251 370 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Pelobacter Pelobacter propionicus
5961145 5961145 PRJNA879314_P_NODE_8245_length_247_cov_0.896552_g8195_i0 PRJNA879314 8245 247 0.896552 2.21448344 Desulfomicrobium sp. ZS1 2952228 Bacteria Bacteria 335 1.9799999999999992e-87   NTclustered gi|2269306666|gb|CP100351.1| 2952228 g8195 i0 91.093 6.08097165991903 247 22 100 0 1 247 1512367 1512613 Desulfomicrobium sp. ZS1 chromosome, complete genome blastn 1502 335 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium sp. ZS1
7236034 7236034 PRJNA879314_P_NODE_6586_length_250_cov_0.881356_g6536_i0 PRJNA879314 6586 250 0.881356 2.20339 Desulfomicrobium baculatum 899 Bacteria Bacteria 333 7.219999999999999e-87   NTclustered gi|256576994|gb|CP001629.1| 525897 g6536 i0 91.057 0.984 246 22 98 0 5 250 1992358 1992113 Desulfomicrobium baculatum DSM 4028, complete genome blastn 246 333 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium baculatum
9785673 9785673 PRJNA879314_P_NODE_11088_length_242_cov_0.923077_g11038_i0 PRJNA879314 11088 242 0.923077 2.23384634 Desulfomicrobium sp. ZS1 2952228 Bacteria Bacteria 87.9 5.98e-13   NTclustered gi|2269306666|gb|CP100351.1| 2952228 g11038 i0 86.905 0.694214876033058 84 4 34 4 2 84 3259545 3259468 Desulfomicrobium sp. ZS1 chromosome, complete genome blastn 168 87.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium sp. ZS1
13611549 13611549 PRJNA879314_P_NODE_8331_length_247_cov_0.896552_g8281_i0 PRJNA879314 8331 247 0.896552 2.21448344 Desulfuromonas soudanensis 1603606 Bacteria Bacteria 219 2.08e-52   NTclustered gi|924528553|gb|CP010802.1| 1603606 g8281 i0 82.731 118.441295546559 249 39 100 3 1 247 75276 75030 Desulfuromonas soudanensis strain WTL chromosome, complete genome blastn 29255 219 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas soudanensis
13994225 13994225 PRJNA879314_P_NODE_10571_length_243_cov_0.917647_g10521_i0 PRJNA879314 10571 243 0.917647 2.22988221 Desulfomicrobium 898 Bacteria Bacteria 228 3.389999999999999e-55   NTclustered gi|256576994|gb|CP001629.1| 525897 g10521 i0 83.673 3.22222222222222 245 36 100 3 1 243 3802895 3803137 Desulfomicrobium baculatum DSM 4028, complete genome blastn 783 228 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium baculatum
13994230 13994230 PRJNA879314_P_NODE_2811_length_292_cov_1.369863_g2761_i0 PRJNA879314 2811 292 1.369863 3.99999996 Geobacter 28231 Bacteria Bacteria 540 4.74e-149   NTclustered gi|779731694|gb|CP010430.1| 35554 g2761 i0 100 28.8150684931507 292 0 100 0 1 292 3807543 3807834 Geobacter sulfurreducens strain AM-1 genome blastn 8414 540 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sulfurreducens
16160529 16160529 PRJNA879314_P_NODE_4973_length_252_cov_0.871508_g4923_i0 PRJNA879314 4973 252 0.871508 2.19620016 Desulfomicrobium sp. ZS1 2952228 Bacteria Bacteria 250 7.55e-62   NTclustered gi|2269306666|gb|CP100351.1| 2952228 g4923 i0 84.706 3.48015873015873 255 33 100 3 1 252 3832922 3833173 Desulfomicrobium sp. ZS1 chromosome, complete genome blastn 877 250 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium sp. ZS1
17436041 17436041 PRJNA879314_P_NODE_4794_length_253_cov_0.866667_g4744_i0 PRJNA879314 4794 253 0.866667 2.19266751 uncultured Desulfobulbus sp. 239745 Bacteria Bacteria 207 4.63e-49   NTclustered gi|2621704989|emb|OY762276.1| 239745 g4744 i0 81.569 38.0474308300395 255 43 100 4 1 253 3783926 3783674 MAG: uncultured Desulfobulbus sp. isolate 57af8870-89a5-447c-908d-f2db64e05d28 genome assembly, chromosome: 1 blastn 9626 207 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus uncultured Desulfobulbus sp.
17817871 17817871 PRJNA879314_P_NODE_10014_length_244_cov_0.912281_g9964_i0 PRJNA879314 10014 244 0.912281 2.22596564 Geobacter 28231 Bacteria Bacteria 451 1.86e-122   NTclustered gi|779731694|gb|CP010430.1| 35554 g9964 i0 100 9 244 0 100 0 1 244 2233196 2233439 Geobacter sulfurreducens strain AM-1 genome blastn 2196 451 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sulfurreducens
18709216 18709216 PRJNA879314_P_NODE_2815_length_292_cov_1.237443_g2765_i0 PRJNA879314 2815 292 1.237443 3.61333356 Desulfomicrobium sp. ZS1 2952228 Bacteria Bacteria 387 6.53e-103   NTclustered gi|2269306666|gb|CP100351.1| 2952228 g2765 i0 90.69 3.56506849315068 290 27 99 0 1 290 3058756 3059045 Desulfomicrobium sp. ZS1 chromosome, complete genome blastn 1041 387 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium sp. ZS1
19091899 19091899 PRJNA879314_P_NODE_8375_length_247_cov_0.896552_g8325_i0 PRJNA879314 8375 247 0.896552 2.21448344 root 1 Root_unresolved Root_unresolved 69.4 2.22e-7   NTclustered gi|1102127722|emb|LT630450.1| 901 g8325 i0 100 0.449392712550607 37 0 15 0 211 247 1334639 1334603 Desulfovibrio piger isolate FI11049 genome assembly, chromosome: I blastn 111 69.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio piger
20366721 20366721 PRJNA879314_P_NODE_9716_length_244_cov_0.912281_g9666_i0 PRJNA879314 9716 244 0.912281 2.22596564 Bacteria 2 Bacteria Bacteria 451 1.86e-122   NTclustered gi|779731694|gb|CP010430.1| 35554 g9666 i0 100 9 244 0 100 0 1 244 272746 272989 Geobacter sulfurreducens strain AM-1 genome blastn 2196 451 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sulfurreducens
21259867 21259867 PRJNA879314_P_NODE_10717_length_243_cov_0.917647_g10667_i0 PRJNA879314 10717 243 0.917647 2.22988221 Nitratidesulfovibrio sp. HK-II 2009266 Bacteria Bacteria 316 7.03e-82   NTclustered gi|2791413552|dbj|AP036014.1| 2009266 g10667 i0 90.496 2.19341563786008 242 19 99 3 2 241 1636734 1636973 Nitratidesulfovibrio sp. HK-II DNA, complete genome blastn 533 316 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio sp. HK-II
25084017 25084017 PRJNA879314_P_NODE_9380_length_245_cov_0.906977_g9330_i0 PRJNA879314 9380 245 0.906977 2.22209365 Desulfomicrobium baculatum 899 Bacteria Bacteria 289 1.55e-73   NTclustered gi|256576994|gb|CP001629.1| 525897 g9330 i0 88.115 1.9265306122449 244 28 99 1 2 244 2669976 2669733 Desulfomicrobium baculatum DSM 4028, complete genome blastn 472 289 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium baculatum
25467086 25467086 PRJNA879314_P_NODE_6440_length_250_cov_0.881356_g6390_i0 PRJNA879314 6440 250 0.881356 2.20339 Geobacter 28231 Bacteria Bacteria 462 8.83e-126   NTclustered gi|779731694|gb|CP010430.1| 35554 g6390 i0 100 9 250 0 100 0 1 250 2394716 2394965 Geobacter sulfurreducens strain AM-1 genome blastn 2250 462 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sulfurreducens

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