RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA879067" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 25 ✖

tax_kingdom 1

bioproject 1

  • PRJNA879067 · 25 ✖

analysis 1

  • diamond · 25 ✖

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
3405423 3405423 PRJNA879067_P_NODE_29643_length_770_cov_11.177905_g26343_i0 PRJNA879067 29643 770 11.177905 86.0698685 Spirochaetia bacterium 2053615 Bacteria Bacteria 170 2.22e-49   NR NCB03113.1 2053615 g26343 i0 89.2 0.397402597402597 102 11 39.7 0 306 1 59 160 NCB03113.1 hypothetical protein [Spirochaetia bacterium] diamond 306 170 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
14882480 14882480 PRJNA879067_P_NODE_25172_length_863_cov_11.665823_g21997_i0 PRJNA879067 25172 863 11.665823 100.67605249 Treponema 157 Bacteria Bacteria 147 2.74e-38   NR WP_253689418.1 158 g21997 i0 53.7 1.27578215527231 121 56 42.1 0 374 736 161 281 WP_253689418.1 GerMN domain-containing protein [Treponema denticola] diamond 1101 148 0.993243243243243 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
19980723 19980723 PRJNA879067_P_NODE_14036_length_1275_cov_9.971714_g11503_i0 PRJNA879067 14036 1275 9.971714 127.1393535 Leptospira saintgironsiae 2023183 Bacteria Bacteria 177 9.84e-51   NR WP_100711110.1 2023183 g11503 i0 76.7 0.282352941176471 120 28 28.2 0 1080 721 1 120 WP_100711110.1 hypothetical protein [Leptospira saintgironsiae] diamond 360 177 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira saintgironsiae
26770436 26770436 PRJNA879067_P_NODE_36181_length_669_cov_10.414430_g32771_i0 PRJNA879067 36181 669 10.41443 69.6725367 Leptospira neocaledonica 2023192 Bacteria Bacteria 209 2.8399999999999997e-61   NR WP_244283330.1 2023192 g32771 i0 79.2 0.538116591928251 120 25 53.8 0 22 381 187 306 WP_244283330.1 hypothetical protein [Leptospira neocaledonica] diamond 360 209 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira neocaledonica
26865698 26865698 PRJNA879067_P_NODE_39141_length_633_cov_4.871429_g35701_i0 PRJNA879067 39141 633 4.871429 30.83614557 Spirochaetales bacterium 2026792 Bacteria Bacteria 271 2.17e-88   NR MCI6115212.1 2026792 g35701 i0 99.2 0.630331753554502 133 1 63 0 233 631 1 133 MCI6115212.1 nucleoside triphosphate pyrophosphohydrolase [Spirochaetales bacterium] diamond 399 271 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
27339892 27339892 PRJNA879067_P_NODE_88303_length_305_cov_1.327586_g84817_i0 PRJNA879067 88303 305 1.327586 4.0491373 uncultured Treponema sp. 162155 Bacteria Bacteria 91.7 5.39e-19   NR WP_288724535.1 162155 g84817 i0 57.1 0.757377049180328 77 33 75.7 0 233 3 1710 1786 WP_288724535.1 LPD23 domain-containing protein [uncultured Treponema sp.] diamond 231 91.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema uncultured Treponema sp.
28413388 28413388 PRJNA879067_P_NODE_111326_length_239_cov_2.783133_g107840_i0 PRJNA879067 111326 239 2.783133 6.65168787 Leptospira saintgironsiae 2023183 Bacteria Bacteria 155 4.44e-44   NR WP_100711056.1 2023183 g107840 i0 93.7 0.99163179916318 79 5 99.2 0 1 237 71 149 WP_100711056.1 AI-2E family transporter [Leptospira saintgironsiae] diamond 237 155 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira saintgironsiae
28445028 28445028 PRJNA879067_P_NODE_102146_length_254_cov_1.701657_g98660_i0 PRJNA879067 102146 254 1.701657 4.32220878 Treponema denticola 158 Bacteria Bacteria 80.5 2.13e-15   NR WP_255811157.1 158 g98660 i0 66 0.625984251968504 53 18 62.6 0 159 1 1 53 WP_255811157.1 hypothetical protein [Treponema denticola] diamond 159 80.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
28760515 28760515 PRJNA879067_P_NODE_81807_length_331_cov_2.434109_g78321_i0 PRJNA879067 81807 331 2.434109 8.05690079 uncultured Treponema sp. 162155 Bacteria Bacteria 176 8.83e-53   NR WP_288515970.1 162155 g78321 i0 96.7 0.833836858006042 92 3 83.4 0 313 38 173 264 WP_288515970.1 tRNA (guanosine(37)-N1)-methyltransferase TrmD [uncultured Treponema sp.] diamond 276 176 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema uncultured Treponema sp.
28886807 28886807 PRJNA879067_P_NODE_99688_length_263_cov_2.705263_g96202_i0 PRJNA879067 99688 263 2.705263 7.11484169 Leptospira fletcheri 2484981 Bacteria Bacteria 70.9 3.6e-12   NR WP_135766764.1 2484981 g96202 i0 69 0.479087452471483 42 13 47.9 0 261 136 9 50 WP_135766764.1 IS1595 family transposase [Leptospira fletcheri] diamond 126 70.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira fletcheri
29486575 29486575 PRJNA879067_P_NODE_43990_length_580_cov_3.487179_g40529_i0 PRJNA879067 43990 580 3.487179 20.2256382 Treponema endosymbiont of Eucomonympha sp. 1580831 Bacteria Bacteria 213 5.33e-65   NR WP_228378571.1 1580831 g40529 i0 86.7 1.30344827586207 128 16 66.2 1 23 406 9 135 WP_228378571.1 HAMP domain-containing protein, partial [Treponema endosymbiont of Eucomonympha sp.] diamond 756 213 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema endosymbiont of Eucomonympha sp.
29675939 29675939 PRJNA879067_P_NODE_84510_length_320_cov_1.781377_g81024_i0 PRJNA879067 84510 320 1.781377 5.7004064 Leptospira wolffii 409998 Bacteria Bacteria 176 1.56e-53   NR WP_135699651.1 409998 g81024 i0 81.2 0.946875 101 19 94.7 0 17 319 72 172 WP_135699651.1 SOS response-associated peptidase [Leptospira wolffii] diamond 303 176 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira wolffii
30126277 30126277 PRJNA879067_P_NODE_94112_length_283_cov_2.128571_g90626_i0 PRJNA879067 94112 283 2.128571 6.02385593 Treponema 157 Bacteria Bacteria 168 4.52e-49   NR MEE1211719.1 166 g90626 i0 89.7 1.82332155477032 87 9 92.2 0 2 262 82 168 MEE1211719.1 hypothetical protein [Treponema sp.] diamond 516 169 0.994082840236686 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30403260 30403260 PRJNA879067_P_NODE_74093_length_366_cov_5.068259_g70608_i0 PRJNA879067 74093 366 5.068259 18.54982794 Leptospira licerasiae 447106 Bacteria Bacteria 204 1.4999999999999999e-58   NR WP_135665384.1 447106 g70608 i0 92.9 0.918032786885246 112 8 91.8 0 365 30 545 656 WP_135665384.1 efflux RND transporter permease subunit [Leptospira licerasiae] diamond 336 204 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira licerasiae
30442580 30442580 PRJNA879067_P_NODE_57253_length_468_cov_13.668354_g53768_i0 PRJNA879067 57253 468 13.668354 63.96789672 Leptospira 171 Bacteria Bacteria 253 1.3799999999999999e-76   NR WP_135757370.1 2484904 g53768 i0 78.8 3.73717948717949 146 31 93.6 0 468 31 245 390 WP_135757370.1 SpoIIE family protein phosphatase [Leptospira dzoumogneensis] diamond 1749 255 0.992156862745098 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira dzoumogneensis
30687076 30687076 PRJNA879067_P_NODE_93013_length_287_cov_1.869159_g89527_i0 PRJNA879067 93013 287 1.869159 5.36448633 Leptospira dzoumogneensis 2484904 Bacteria Bacteria 156 6.3e-42   NR WP_135755157.1 2484904 g89527 i0 93 0.898954703832753 86 6 89.9 0 2 259 418 503 WP_135755157.1 MMPL family transporter [Leptospira dzoumogneensis] diamond 258 156 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira dzoumogneensis
31003217 31003217 PRJNA879067_P_NODE_79914_length_339_cov_2.552632_g76428_i0 PRJNA879067 79914 339 2.552632 8.65342248 Leptospira johnsonii 1917820 Bacteria Bacteria 182 3.0499999999999995e-54   NR GBF40215.1 1917820 g76428 i0 95.2 0.920353982300885 104 5 92 0 337 26 8 111 GBF40215.1 putative membrane protein [Leptospira johnsonii] diamond 312 182 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira johnsonii
31035043 31035043 PRJNA879067_P_NODE_71355_length_381_cov_1.564935_g67870_i0 PRJNA879067 71355 381 1.564935 5.96240235 Treponema endosymbiont of Eucomonympha sp. 1580831 Bacteria Bacteria 224 2.39e-69   NR WP_202966463.1 1580831 g67870 i0 93.3 0.937007874015748 119 8 93.7 0 357 1 259 377 WP_202966463.1 response regulator [Treponema endosymbiont of Eucomonympha sp.] diamond 357 224 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema endosymbiont of Eucomonympha sp.
31382582 31382582 PRJNA879067_P_NODE_63116_length_429_cov_1.289326_g59631_i0 PRJNA879067 63116 429 1.289326 5.53120854 Leptospira licerasiae 447106 Bacteria Bacteria 198 1.5299999999999998e-60   NR WP_008594126.1 447106 g59631 i0 94.5 1.52447552447552 109 6 76.2 0 39 365 192 300 WP_008594126.1 ABC transporter permease subunit [Leptospira licerasiae] diamond 654 198 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira licerasiae
31414152 31414152 PRJNA879067_P_NODE_88716_length_303_cov_2.552174_g85230_i0 PRJNA879067 88716 303 2.552174 7.73308722 Leptospira neocaledonica 2023192 Bacteria Bacteria 172 6.219999999999999e-48   NR WP_100768953.1 2023192 g85230 i0 91.6 1.88118811881188 95 8 94.1 0 1 285 219 313 WP_100768953.1 sensor histidine kinase [Leptospira neocaledonica] diamond 570 172 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira neocaledonica
32141731 32141731 PRJNA879067_P_NODE_81678_length_332_cov_1.177606_g78192_i0 PRJNA879067 81678 332 1.177606 3.90965192 Spirochaetales bacterium 2026792 Bacteria Bacteria 191 8.539999999999998e-55   NR MCI6113922.1 2026792 g78192 i0 90 0.993975903614458 110 11 99.4 0 331 2 395 504 MCI6113922.1 response regulator [Spirochaetales bacterium] diamond 330 191 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32394926 32394926 PRJNA879067_P_NODE_79079_length_343_cov_2.007407_g75593_i0 PRJNA879067 79079 343 2.007407 6.88540601 Brevinematia bacterium 3121702 Bacteria Bacteria 48.9 9.09e-5   NR MFN4245853.1 3121702 g75593 i0 58.3 0.524781341107872 60 21 52.5 1 341 162 38 93 MFN4245853.1 hypothetical protein [Brevinematia bacterium] diamond 180 48.9 1 Bacteria   Pseudomonadati Spirochaetota Brevinematia       Brevinematia bacterium
32592667 32592667 PRJNA879067_P_NODE_63919_length_423_cov_6.308571_g60434_i0 PRJNA879067 63919 423 6.308571 26.68525533 Leptospira 171 Bacteria Bacteria 215 1.02e-61   NR WP_135679645.1 2484982 g60434 i0 95.3 1.52482269503546 107 5 75.9 0 325 5 70 176 WP_135679645.1 PD40 domain-containing protein [Leptospira selangorensis] diamond 645 215 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira selangorensis
32742156 32742156 PRJNA879067_P_NODE_22320_length_936_cov_4.427578_g19282_i0 PRJNA879067 22320 936 4.427578 41.44213008 Spirochaetes bacterium GWB1_59_5 1802176 Bacteria Bacteria 291 5.29e-92   NR OHD25442.1 1802176 g19282 i0 57 0.826923076923077 258 109 82.4 2 146 916 2 258 OHD25442.1 MAG: hypothetical protein A2Y38_12850 [Spirochaetes bacterium GWB1_59_5] diamond 774 291 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_59_5
32804919 32804919 PRJNA879067_P_NODE_33260_length_711_cov_2.855799_g29893_i0 PRJNA879067 33260 711 2.855799 20.30473089 Spirochaetota bacterium 2202144 Bacteria Bacteria 318 2.08e-103   NR MBP9024482.1 2202144 g29893 i0 84.6 0.713080168776371 169 26 71.3 0 173 679 1 169 MBP9024482.1 DDE-type integrase/transposase/recombinase [Spirochaetota bacterium] diamond 507 318 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);;