RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA316313" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA316313 · 14 ✖

analysis 1

  • blastn · 14 ✖

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
386305 386305 PRJNA316313_P_NODE_156801_length_187_cov_4.420000_g155415_i0 PRJNA316313 156801 187 4.42 8.2654 Nitratidesulfovibrio sp. HK-II 2009266 Bacteria Bacteria 93.5 9.43e-15   NTclustered gi|2791413552|dbj|AP036014.1| 2009266 g155415 i0 89.189 3.5668449197861 74 8 40 0 3 76 2030826 2030753 Nitratidesulfovibrio sp. HK-II DNA, complete genome blastn 667 93.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio sp. HK-II
387936 387936 PRJNA316313_P_NODE_438641_length_151_cov_4.000000_g437255_i0 PRJNA316313 438641 151 4 6.04 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 62.1 2.05e-5   NTclustered gi|2893358418|emb|OZ220710.1| 2202153 g437255 i0 94.872 0.443708609271523 39 2 26 0 108 146 101462 101424 MAG: Thermodesulfobacteriota bacterium isolate dce1034a-8f23-488c-aa07-39e6c80a0035 genome assembly, chromosome: 1 blastn 67 62.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
1067554 1067554 PRJNA316313_P_NODE_190681_length_187_cov_3.593333_g189295_i0 PRJNA316313 190681 187 3.593333 6.71953271 Desulfovibrio 872 Bacteria Bacteria 102 1.57e-17   NTclustered gi|1894914451|emb|LT984798.1| 631220 g189295 i0 90.789 1.2192513368984 76 7 41 0 112 187 2913897 2913972 Desulfovibrio sp. G11 isolate G11PacBio genome assembly, chromosome: 1 blastn 228 102 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp. G11
2936701 2936701 PRJNA316313_P_NODE_128823_length_187_cov_8.833333_g127437_i0 PRJNA316313 128823 187 8.833333 16.51833271 Desulfomicrobium orale 132132 Bacteria Bacteria 141 3.32e-29   NTclustered gi|987456218|gb|CP014230.1| 888061 g127437 i0 100 0.812834224598931 76 0 81 0 112 187 321371 321446 Desulfomicrobium orale DSM 12838 chromosome, complete genome blastn 152 141 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium orale
2938851 2938851 PRJNA316313_P_NODE_485243_length_150_cov_5.097345_g483857_i0 PRJNA316313 485243 150 5.097345 7.6460175 Geomonas paludis 2740185 Bacteria Bacteria 87.9 3.35e-13   NTclustered gi|2233265061|gb|CP096574.1| 2740185 g483857 i0 88 0.5 75 7 49 2 77 150 4280349 4280276 Geomonas paludis strain RG22 chromosome, complete genome blastn 75 87.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geomonas Geomonas paludis
3619274 3619274 PRJNA316313_P_NODE_507683_length_150_cov_2.884956_g506297_i0 PRJNA316313 507683 150 2.884956 4.327434 Pseudomonadati 3379134 Bacteria Bacteria 278 1.85e-70   NTclustered gi|2045533567|gb|CP074693.1| 35554 g506297 i0 100 55.12 150 0 100 0 1 150 81591 81442 Geobacter sulfurreducens strain YM35 chromosome, complete genome blastn 8268 278 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sulfurreducens
8040951 8040951 PRJNA316313_P_NODE_389747_length_155_cov_4.406780_g388361_i0 PRJNA316313 389747 155 4.40678 6.830509 Citrifermentans bemidjiense 225194 Bacteria Bacteria 110 7.46e-20   NTclustered gi|197085762|gb|CP001124.1| 404380 g388361 i0 89.655 52.1548387096774 87 8 56 1 69 155 2088963 2089048 Geobacter bemidjiensis Bem, complete genome blastn 8084 110 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Citrifermentans Citrifermentans bemidjiense
9315157 9315157 PRJNA316313_P_NODE_310348_length_187_cov_2.360000_g308962_i0 PRJNA316313 310348 187 2.36 4.4132 Pseudodesulfovibrio portus 231439 Bacteria Bacteria 60.2 9.57e-5   NTclustered gi|2296712847|dbj|AP026708.1| 231439 g308962 i0 100 0.171122994652406 32 0 17 0 117 148 2164233 2164202 Pseudodesulfovibrio portus JCM 14722 DNA, complete genome blastn 32 60.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio portus
9315403 9315403 PRJNA316313_P_NODE_349488_length_179_cov_2.746479_g348102_i0 PRJNA316313 349488 179 2.746479 4.91619741 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 100 5.34e-17   NTclustered gi|2556892445|gb|CP129479.1| 2202153 g348102 i0 85.714 323.860335195531 98 10 56 4 40 135 1898904 1898999 MAG: Thermodesulfobacteriota bacterium isolate cMAG.17 chromosome, complete genome blastn 57971 100 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
11864926 11864926 PRJNA316313_P_NODE_151890_length_187_cov_4.606667_g150504_i0 PRJNA316313 151890 187 4.606667 8.61446729 Megalodesulfovibrio gigas 879 Bacteria Bacteria 54.7 0.004   NTclustered gi|544197442|gb|CP006585.1| 1121448 g150504 i0 100 0.155080213903743 29 0 16 0 137 165 2725983 2725955 Desulfovibrio gigas DSM 1382 = ATCC 19364 genome blastn 29 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Megalodesulfovibrio Megalodesulfovibrio gigas
15689343 15689343 PRJNA316313_P_NODE_22593_length_355_cov_10.553459_g21224_i0 PRJNA316313 22593 355 10.553459 37.46477945 Geobacter sp. SVR 2495594 Bacteria Bacteria 219 3.13e-52   NTclustered gi|1976315905|dbj|AP024469.1| 2495594 g21224 i0 82.308 67.3211267605634 260 38 72 8 87 342 3337298 3337553 Geobacter sp. SVR DNA, complete genome blastn 23899 219 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp. SVR
15690624 15690624 PRJNA316313_P_NODE_439913_length_151_cov_3.956140_g438527_i0 PRJNA316313 439913 151 3.95614 5.9737714 Desulfovibrio piger 901 Bacteria Bacteria 60.2 7.36e-5   NTclustered gi|1102127722|emb|LT630450.1| 901 g438527 i0 94.737 0.251655629139073 38 2 25 0 12 49 1348438 1348401 Desulfovibrio piger isolate FI11049 genome assembly, chromosome: I blastn 38 60.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio piger
18238559 18238559 PRJNA316313_P_NODE_274435_length_187_cov_2.593333_g273049_i0 PRJNA316313 274435 187 2.593333 4.84953271 Desulfovibrio ferrophilus 241368 Bacteria Bacteria 52.8 0.016   NTclustered gi|1352279194|dbj|AP017378.1| 241368 g273049 i0 100 0.149732620320856 28 0 15 0 34 61 592829 592802 Desulfovibrio ferrophilus DNA, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio ferrophilus
22064281 22064281 PRJNA316313_P_NODE_424718_length_151_cov_4.649123_g423332_i0 PRJNA316313 424718 151 4.649123 7.02017573 Desulfomicrobium sp. ZS1 2952228 Bacteria Bacteria 62.1 2.05e-5   NTclustered gi|2269306666|gb|CP100351.1| 2952228 g423332 i0 92.857 0.278145695364238 42 3 28 0 33 74 3719120 3719079 Desulfomicrobium sp. ZS1 chromosome, complete genome blastn 42 62.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium sp. ZS1

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