RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA914897", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 20 ✖

tax_kingdom 1

  • Pseudomonadati · 20 ✖

bioproject 1

  • PRJNA914897 · 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
16553461 16553461 PRJNA914897_P_NODE_26033_length_318_cov_1.424490_g25609_i0 PRJNA914897 26033 318 1.42449 4.5298782 Entomospira 2834378 Bacteria Bacteria 577 3.9799999999999996e-160   NTclustered gi|2446641004|gb|CP118168.1| 2719987 g25609 i0 99.371 238.380503144654 318 2 100 0 1 318 324809 324492 Entomospira nematocerorum strain BR208 chromosome blastn 75805 582 0.991408934707904 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Entomospira Entomospira nematocerorum
20021508 20021508 PRJNA914897_P_NODE_23376_length_341_cov_2.261194_g22952_i0 PRJNA914897 23376 341 2.261194 7.71067154 Entomospira entomophila 2719988 Bacteria Bacteria 503 7.4e-138   NTclustered gi|2446642546|gb|CP118174.1| 2719988 g22952 i0 93.255 110.680351906158 341 23 100 0 1 341 286985 287325 Entomospira entomophila strain BR193 chromosome blastn 37742 503 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Entomospira Entomospira entomophila
27024490 27024490 PRJNA914897_P_NODE_24002_length_336_cov_1.167300_g23578_i0 PRJNA914897 24002 336 1.1673 3.922128 Spirochaetota bacterium 2202144 Bacteria Bacteria 57 3.4e-7   NR HNW27793.1 2202144 g23578 i0 34.3 0.9375 105 65 91.1 3 324 19 5 108 HNW27793.1 GyrI-like domain-containing protein [Spirochaetota bacterium] diamond 315 57 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28035402 28035402 PRJNA914897_P_NODE_41405_length_243_cov_0.905882_g40981_i0 PRJNA914897 41405 243 0.905882 2.20129326 Spirochaetota bacterium 2202144 Bacteria Bacteria 68.2 1.62e-11   NR MBN1534804.1 2202144 g40981 i0 56.4 7.59259259259259 55 24 67.9 0 78 242 188 242 MBN1534804.1 AMP-binding protein [Spirochaetota bacterium] diamond 1845 68.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28477362 28477362 PRJNA914897_P_NODE_6006_length_809_cov_1.817935_g5645_i0 PRJNA914897 6006 809 1.817935 14.70709415 Leptospiraceae bacterium 2026757 Bacteria Bacteria 49.7 0.00883   NR HMV43514.1 2026757 g5645 i0 57.1 0.296662546353523 42 14 14.1 1 502 389 500 541 HMV43514.1 protein kinase [Leptospiraceae bacterium] diamond 240 49.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28508972 28508972 PRJNA914897_P_NODE_6527_length_772_cov_1.640916_g6152_i0 PRJNA914897 6527 772 1.640916 12.66787152 Treponema primitia 88058 Bacteria Bacteria 219 5.4600000000000005e-64   NR WP_010253189.1 88058 g6152 i0 46.7 3.91321243523316 244 124 93.3 4 52 771 268 509 WP_010253189.1 glycoside hydrolase family 13 protein [Treponema primitia] diamond 3021 219 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema primitia
29108960 29108960 PRJNA914897_P_NODE_42048_length_242_cov_0.911243_g41624_i0 PRJNA914897 42048 242 0.911243 2.20520806 Treponema denticola 158 Bacteria Bacteria 107 3.09e-25   NR WP_002691875.1 158 g41624 i0 59.5 0.979338842975207 79 32 97.9 0 242 6 67 145 WP_002691875.1 formylglycine-generating enzyme family protein [Treponema denticola] diamond 237 107 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
29329807 29329807 PRJNA914897_P_NODE_34509_length_262_cov_1.343915_g34085_i0 PRJNA914897 34509 262 1.343915 3.5210573 Spirochaetia bacterium 2053615 Bacteria Bacteria 80.9 1.74e-15   NR HUX49804.1 2053615 g34085 i0 44.6 0.950381679389313 83 45 95 1 254 6 367 448 HUX49804.1 cyclic nucleotide-binding domain-containing protein [Spirochaetia bacterium] diamond 249 80.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29431641 29431641 PRJNA914897_P_NODE_6149_length_798_cov_10.297931_g5781_i0 PRJNA914897 6149 798 10.297931 82.17748938 Treponema 157 Bacteria Bacteria 68.9 6.81e-10   NR WP_206182382.1 58231 g5781 i0 40 1.7556390977443601 110 57 39.8 5 28 345 113 217 WP_206182382.1 CAP domain-containing protein [Treponema medium] diamond 1401 68.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
29526717 29526717 PRJNA914897_P_NODE_8530_length_657_cov_10.799658_g8123_i0 PRJNA914897 8530 657 10.799658 70.95375306 Treponema 157 Bacteria Bacteria 68.9 3.09e-10   NR WP_206182382.1 58231 g8123 i0 40 2.1324200913242 110 57 48.4 5 630 313 113 217 WP_206182382.1 CAP domain-containing protein [Treponema medium] diamond 1401 68.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
29582082 29582082 PRJNA914897_P_NODE_35650_length_255_cov_1.994505_g35226_i0 PRJNA914897 35650 255 1.994505 5.08598775 Leptospira sp. 178 Bacteria Bacteria 129 3.39e-36   NR MCU0824711.1 178 g35226 i0 70.6 1 85 25 100 0 1 255 28 112 MCU0824711.1 MFS transporter [Leptospira sp.] diamond 255 129 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
29898274 29898274 PRJNA914897_P_NODE_10531_length_577_cov_3.351190_g10113_i0 PRJNA914897 10531 577 3.35119 19.3363663 Spirochaetales bacterium 2026792 Bacteria Bacteria 117 5.569999999999999e-28   NR MCF7929180.1 2026792 g10113 i0 34.9 3.93067590987868 192 117 96.7 2 1 558 134 323 MCF7929180.1 ADP-ribosylglycohydrolase family protein [Spirochaetales bacterium] diamond 2268 117 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
30182477 30182477 PRJNA914897_P_NODE_35272_length_258_cov_1.043243_g34848_i0 PRJNA914897 35272 258 1.043243 2.69156694 Treponema sp. 166 Bacteria Bacteria 59.7 4.68e-8   NR MCR5763801.1 166 g34848 i0 52.7 2.61627906976744 55 21 64 1 167 3 503 552 MCR5763801.1 response regulator [Treponema sp.] diamond 675 59.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31106047 31106047 PRJNA914897_P_NODE_17695_length_411_cov_1.328402_g17273_i0 PRJNA914897 17695 411 1.328402 5.45973222 root 1 Root_unresolved Root_unresolved 155 4.74e-41   NR WP_014623997.1 154 g17273 i0 48.5 17.7591240875912 136 70 99.3 0 409 2 96 231 WP_014623997.1 methionine--tRNA ligase [Spirochaeta thermophila] diamond 7299 156 0.993589743589744 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Winmispirales Winmispiraceae Winmispira Winmispira thermophila
31510064 31510064 PRJNA914897_P_NODE_7436_length_715_cov_3.104361_g7043_i0 PRJNA914897 7436 715 3.104361 22.19618115 Spirochaetia bacterium 2053615 Bacteria Bacteria 82.8 2.76e-15   NR NBU97663.1 2053615 g7043 i0 35.2 2.41678321678322 216 107 85.2 9 618 10 6 201 NBU97663.1 lysoplasmalogenase [Spirochaetia bacterium] diamond 1728 82.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32142623 32142623 PRJNA914897_P_NODE_18298_length_402_cov_8.133739_g17876_i0 PRJNA914897 18298 402 8.133739 32.69763078 Leptospiraceae bacterium 2026757 Bacteria Bacteria 62.4 4.19e-10   NR MCB1177358.1 2026757 g17876 i0 46.7 0.447761194029851 60 31 44 1 217 393 1 60 MCB1177358.1 hypothetical protein [Leptospiraceae bacterium] diamond 180 62.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32205877 32205877 PRJNA914897_P_NODE_22818_length_347_cov_1.686131_g22394_i0 PRJNA914897 22818 347 1.686131 5.85087457 Spirochaetia bacterium 2053615 Bacteria Bacteria 43.5 0.0474   NR HUX14577.1 2053615 g22394 i0 34.9 0.544668587896254 63 38 51.9 1 285 106 6 68 HUX14577.1 DnaJ domain-containing protein [Spirochaetia bacterium] diamond 189 43.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32213325 32213325 PRJNA914897_P_NODE_27198_length_309_cov_0.843220_g26774_i0 PRJNA914897 27198 309 0.84322 2.6055498 Pseudomonadati 3379134 Bacteria Bacteria 45.4 0.00736   NR MCR5401868.1 166 g26774 i0 44.4 1.33009708737864 72 39 68.9 1 214 2 71 142 MCR5401868.1 CAP domain-containing protein [Treponema sp.] diamond 411 45.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32554184 32554184 PRJNA914897_P_NODE_12459_length_518_cov_2.080899_g12039_i0 PRJNA914897 12459 518 2.080899 10.77905682 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 75.9 9.22e-13   NR MCL2791478.1 1898206 g12039 i0 70.5 1.58108108108108 44 13 25.5 0 501 370 14 57 MCL2791478.1 NAD(P)-dependent oxidoreductase [Spirochaetaceae bacterium] diamond 819 75.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
32837258 32837258 PRJNA914897_P_NODE_30080_length_288_cov_1.065116_g29656_i0 PRJNA914897 30080 288 1.065116 3.06753408 Spirochaetota bacterium 2202144 Bacteria Bacteria 86.3 3.21e-17   NR MFA5517935.1 2202144 g29656 i0 48.2 1.92708333333333 85 42 88.5 1 260 6 571 653 MFA5517935.1 valine--tRNA ligase [Spirochaetota bacterium] diamond 555 86.3 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota 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);;