RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA399711", 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 · 16 ✖

tax_kingdom 1

  • Pseudomonadati · 16 ✖

bioproject 1

  • PRJNA399711 · 16 ✖

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
25561944 25561944 PRJNA399711_S_NODE_109225_length_150_cov_2.911504_g109083_i0 PRJNA399711 109225 150 2.911504 4.367256 Leptospira cinconiae 3235173 Bacteria Bacteria 202 1.15e-47   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g109083 i0 91.724 0.966666666666667 145 12 97 0 1 145 217965 218109 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 145 202 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
25565320 25565320 PRJNA399711_S_NODE_94177_length_158_cov_4.272727_g94035_i0 PRJNA399711 94177 158 4.272727 6.75090866 Leptospira cinconiae 3235173 Bacteria Bacteria 204 3.4099999999999996e-48   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g94035 i0 90.385 0.987341772151899 156 14 98 1 1 155 2354460 2354615 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 156 204 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
25837563 25837563 PRJNA399711_S_NODE_94627_length_158_cov_2.603306_g94485_i0 PRJNA399711 94627 158 2.603306 4.11322348 Leptospira cinconiae 3235173 Bacteria Bacteria 198 1.5899999999999999e-46   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g94485 i0 89.241 1 158 17 100 0 1 158 328631 328474 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 158 198 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
25970431 25970431 PRJNA399711_S_NODE_109076_length_150_cov_3.345133_g108934_i0 PRJNA399711 109076 150 3.345133 5.0176995 Spirochaetota bacterium 2202144 Bacteria Bacteria 60.2 7.3e-5   NTclustered gi|1869993210|dbj|AP019861.1| 2202144 g108934 i0 100 0.42 32 0 21 0 24 55 477545 477514 Spirochaetes bacterium COTS27 DNA, nearly complete genome blastn 63 60.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
26242512 26242512 PRJNA399711_S_NODE_107238_length_151_cov_2.631579_g107096_i0 PRJNA399711 107238 151 2.631579 3.97368429 Leptospira cinconiae 3235173 Bacteria Bacteria 163 5.4600000000000004e-36   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g107096 i0 88.235 0.900662251655629 136 16 90 0 1 136 1216497 1216362 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 136 163 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
26515783 26515783 PRJNA399711_S_NODE_32520_length_232_cov_2.938462_g32378_i0 PRJNA399711 32520 232 2.938462 6.81723184 Leptospira cinconiae 3235173 Bacteria Bacteria 193 1.17e-44   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g32378 i0 82.883 0.956896551724138 222 30 94 8 2 219 1383750 1383967 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 222 193 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
30360244 30360244 PRJNA399711_P_NODE_5712_length_231_cov_6.912371_g5646_i0 PRJNA399711 5712 231 6.912371 15.96757701 Treponema sp. 166 Bacteria Bacteria 90.5 1.81e-19   NR MCK9171663.1 166 g5646 i0 65.7 2.64935064935065 67 20 87 1 203 3 198 261 MCK9171663.1 hypothetical protein [Treponema sp.] diamond 612 90.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32924146 32924146 PRJNA399711_S_NODE_95225_length_158_cov_1.247934_g95083_i0 PRJNA399711 95225 158 1.247934 1.97173572 Leptospira 171 Bacteria Bacteria 110 1.68e-26   NR WP_008594231.1 447106 g95083 i0 96.2 1.9746835443038 52 2 98.7 0 2 157 206 257 WP_008594231.1 DUF3556 domain-containing protein [Leptospira licerasiae] diamond 312 110 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira licerasiae
32951776 32951776 PRJNA399711_S_NODE_109474_length_150_cov_2.336283_g109332_i0 PRJNA399711 109474 150 2.336283 3.5044245 Treponema 157 Bacteria Bacteria 71.2 1.11e-13   NR WP_002670218.1 157 g109332 i0 72.9 0.96 48 13 96 0 150 7 1 48 WP_002670218.1 MULTISPECIES: ribosome maturation factor RimM [Treponema] diamond 144 71.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema  
32952373 32952373 PRJNA399711_S_NODE_98018_length_156_cov_2.630252_g97876_i0 PRJNA399711 98018 156 2.630252 4.10319312 Spirochaetota bacterium 2202144 Bacteria Bacteria 63.9 3.87e-10   NR TXG81244.1 2202144 g97876 i0 66.7 0.865384615384615 45 14 86.5 1 16 150 185 228 TXG81244.1 MAG: DEAD/DEAH box helicase [Spirochaetota bacterium] diamond 135 63.9 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32969205 32969205 PRJNA399711_S_NODE_42026_length_212_cov_2.594286_g41884_i0 PRJNA399711 42026 212 2.594286 5.49988632 Spirochaetota bacterium 2202144 Bacteria Bacteria 43.5 0.0129   NR TXG79806.1 2202144 g41884 i0 38 1.00471698113208 71 43 99.1 1 2 211 168 238 TXG79806.1 MAG: hypothetical protein E6R13_09390 [Spirochaetota bacterium] diamond 213 43.5 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
33003296 33003296 PRJNA399711_S_NODE_65027_length_181_cov_2.312500_g64885_i0 PRJNA399711 65027 181 2.3125 4.185625 Leptospira venezuelensis 1958811 Bacteria Bacteria 99.8 2.84e-24   NR WP_086445657.1 1958811 g64885 i0 90 0.828729281767956 50 5 82.9 0 1 150 162 211 WP_086445657.1 methylthioribulose 1-phosphate dehydratase [Leptospira venezuelensis] diamond 150 99.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira venezuelensis
33037342 33037342 PRJNA399711_S_NODE_53788_length_194_cov_1.904459_g53646_i0 PRJNA399711 53788 194 1.904459 3.69465046 Spirochaetia bacterium 2053615 Bacteria Bacteria 71.2 1.28e-14   NR GHV54491.1 2053615 g53646 i0 66 0.819587628865979 53 18 82 0 4 162 10 62 GHV54491.1 hypothetical protein AGMMS49579_15160 [Spirochaetia bacterium] diamond 159 71.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
33037525 33037525 PRJNA399711_S_NODE_84052_length_165_cov_2.265625_g83910_i0 PRJNA399711 84052 165 2.265625 3.73828125 Leptospira venezuelensis 1958811 Bacteria Bacteria 111 5.01e-29   NR WP_086445657.1 1958811 g83910 i0 94.5 1 55 3 100 0 165 1 106 160 WP_086445657.1 methylthioribulose 1-phosphate dehydratase [Leptospira venezuelensis] diamond 165 111 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira venezuelensis
33054028 33054028 PRJNA399711_S_NODE_104605_length_152_cov_5.400000_g104463_i0 PRJNA399711 104605 152 5.4 8.208 Spirochaetota bacterium 2202144 Bacteria Bacteria 70.5 4.43e-13   NR TXG82272.1 2202144 g104463 i0 62.5 0.947368421052632 48 18 94.7 0 9 152 105 152 TXG82272.1 MAG: hypothetical protein E6R13_05225 [Spirochaetota bacterium] diamond 144 70.5 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
33094986 33094986 PRJNA399711_S_NODE_78878_length_169_cov_1.257576_g78736_i0 PRJNA399711 78878 169 1.257576 2.12530344 root 1 Root_unresolved Root_unresolved 65.9 8.74e-11   NR HNC57048.1 2026757 g78736 i0 59.6 1.79289940828402 52 21 92.3 0 9 164 11 62 HNC57048.1 hypothetical protein [Leptospiraceae bacterium] diamond 303 66.2 0.995468277945619 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae 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);;