RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA453567", 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

  • PRJNA453567 · 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
14470440 14470440 PRJNA453567_P_NODE_17952_length_210_cov_2.132948_g17715_i0 PRJNA453567 17952 210 2.132948 4.4791908 Winmispira thermophila 154 Bacteria Bacteria 76.8 1.09e-9   NTclustered gi|306531442|gb|CP001698.1| 665571 g17715 i0 92.453 0.661904761904762 53 4 25 0 123 175 2278595 2278647 Spirochaeta thermophila DSM 6192 chromosome, complete genome blastn 139 76.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Winmispirales Winmispiraceae Winmispira Winmispira thermophila
27265860 27265860 PRJNA453567_P_NODE_24103_length_179_cov_1.098592_g23866_i0 PRJNA453567 24103 179 1.098592 1.96647968 Spirochaetales bacterium 2026792 Bacteria Bacteria 57.8 5.39e-8   NR MDR2588564.1 2026792 g23866 i0 49.1 2.66480446927374 53 19 88.8 1 14 172 70 114 MDR2588564.1 NAD-dependent protein deacylase [Spirochaetales bacterium] diamond 477 57.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
27329122 27329122 PRJNA453567_P_NODE_2783_length_665_cov_3.125796_g2587_i0 PRJNA453567 2783 665 3.125796 20.7865434 Leptospiraceae bacterium 2026757 Bacteria Bacteria 46.6 0.0425   NR MBK9499321.1 2026757 g2587 i0 32.1 0.491729323308271 109 62 49.2 3 177 503 256 352 MBK9499321.1 hypothetical protein [Leptospiraceae bacterium] diamond 327 46.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28023756 28023756 PRJNA453567_P_NODE_24405_length_178_cov_0.822695_g24168_i0 PRJNA453567 24405 178 0.822695 1.4643971 Leptospira levettii 2023178 Bacteria Bacteria 75.5 2.97e-14   NR WP_238760294.1 2023178 g24168 i0 62.1 2.8314606741573 58 22 97.8 0 175 2 148 205 WP_238760294.1 zinc-binding dehydrogenase [Leptospira levettii] diamond 504 75.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira levettii
28181300 28181300 PRJNA453567_P_NODE_27966_length_166_cov_0.875969_g27729_i0 PRJNA453567 27966 166 0.875969 1.45410854 Treponema bryantii 163 Bacteria Bacteria 43.9 0.00525   NR WP_143064197.1 163 g27729 i0 46.8 3.39759036144578 47 25 84.9 0 25 165 597 643 WP_143064197.1 tetratricopeptide repeat protein [Treponema bryantii] diamond 564 43.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema bryantii
28749875 28749875 PRJNA453567_P_NODE_10607_length_288_cov_1.549801_g10370_i0 PRJNA453567 10607 288 1.549801 4.46342688 Treponema sp. 166 Bacteria Bacteria 53.1 1.37e-5   NR MCR5764051.1 166 g10370 i0 42.3 2.45833333333333 71 40 74 1 232 20 119 188 MCR5764051.1 ankyrin repeat domain-containing protein [Treponema sp.] diamond 708 53.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29192022 29192022 PRJNA453567_P_NODE_16509_length_221_cov_1.059783_g16272_i0 PRJNA453567 16509 221 1.059783 2.34212043 Leptospira kobayashii 1917830 Bacteria Bacteria 44.7 0.00544   NR WP_167837147.1 1917830 g16272 i0 53.5 1.49321266968326 43 20 58.4 0 7 135 112 154 WP_167837147.1 ankyrin repeat domain-containing protein [Leptospira kobayashii] diamond 330 44.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira kobayashii
29823173 29823173 PRJNA453567_P_NODE_29211_length_162_cov_1.248000_g28974_i0 PRJNA453567 29211 162 1.248 2.02176 Spirochaetia bacterium 2053615 Bacteria Bacteria 48.9 8.1e-5   NR MCI5522626.1 2053615 g28974 i0 45.8 0.888888888888889 48 21 88.9 1 145 2 325 367 MCI5522626.1 hypothetical protein [Spirochaetia bacterium] diamond 144 48.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29918317 29918317 PRJNA453567_P_NODE_911_length_1221_cov_3.177365_g834_i0 PRJNA453567 911 1221 3.177365 38.79562665 Spirochaetota bacterium 2202144 Bacteria Bacteria 73.2 1.49e-10   NR MCL1865074.1 2202144 g834 i0 28.8 2.09090909090909 139 94 33.9 2 1151 738 125 259 MCL1865074.1 CAP domain-containing protein [Spirochaetota bacterium] diamond 2553 73.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30265989 30265989 PRJNA453567_P_NODE_25712_length_173_cov_1.147059_g25475_i0 PRJNA453567 25712 173 1.147059 1.98441207 Spirochaetota bacterium 2202144 Bacteria Bacteria 41.6 0.0358   NR MBN8217803.1 2202144 g25475 i0 52.5 0.69364161849711 40 19 69.4 0 146 27 40 79 MBN8217803.1 tRNA pseudouridine(38-40) synthase TruA [Spirochaetota bacterium] diamond 120 41.6 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30360953 30360953 PRJNA453567_P_NODE_24472_length_177_cov_1.950000_g24235_i0 PRJNA453567 24472 177 1.95 3.4515 Spirochaetota bacterium 2202144 Bacteria Bacteria 99.8 1.33e-22   NR MCK5094250.1 2202144 g24235 i0 69.5 4 59 18 100 0 1 177 437 495 MCK5094250.1 NAD-glutamate dehydrogenase [Spirochaetota bacterium] diamond 708 99.8 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30455630 30455630 PRJNA453567_P_NODE_7613_length_355_cov_1.814465_g7376_i0 PRJNA453567 7613 355 1.814465 6.44135075 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 57.4 8.95e-7   NR MDE0228929.1 1898206 g7376 i0 56 1.35211267605634 50 22 42.3 0 188 39 369 418 MDE0228929.1 hypothetical protein [Spirochaetaceae bacterium] diamond 480 57.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30865921 30865921 PRJNA453567_P_NODE_14834_length_235_cov_1.353535_g14597_i0 PRJNA453567 14834 235 1.353535 3.18080725 Spirochaetota bacterium 2202144 Bacteria Bacteria 58.5 5.27e-8   NR MBN2322400.1 2202144 g14597 i0 37.8 0.94468085106383 74 45 94.5 1 2 223 53 125 MBN2322400.1 hypothetical protein [Spirochaetota bacterium] diamond 222 58.5 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31087197 31087197 PRJNA453567_P_NODE_32315_length_154_cov_1.333333_g32078_i0 PRJNA453567 32315 154 1.333333 2.05333282 Spirochaetota bacterium 2202144 Bacteria Bacteria 81.3 2.22e-16   NR HPI22730.1 2202144 g32078 i0 92.1 0.74025974025974 38 3 74 0 3 116 364 401 HPI22730.1 homocysteine biosynthesis protein [Spirochaetota bacterium] diamond 114 81.3 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31925597 31925597 PRJNA453567_P_NODE_24437_length_177_cov_2.507143_g24200_i0 PRJNA453567 24437 177 2.507143 4.43764311 Pseudomonadati 3379134 Bacteria Bacteria 82 2.21e-16   NR TVR33739.1 1898206 g24200 i0 62.1 19.2033898305085 58 22 98.3 0 1 174 194 251 TVR33739.1 MAG: diphosphate--fructose-6-phosphate 1-phosphotransferase [Spirochaetaceae bacterium] diamond 3399 82.4 0.995145631067961 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
32888580 32888580 PRJNA453567_P_NODE_8800_length_323_cov_2.706294_g8563_i0 PRJNA453567 8800 323 2.706294 8.74132962 Spirochaetes bacterium RBG_13_68_11 1802194 Bacteria Bacteria 45.8 0.00788   NR OHD74317.1 1802194 g8563 i0 37.9 0.613003095975232 66 35 58.5 3 132 320 505 567 OHD74317.1 MAG: hypothetical protein A2177_07705 [Spirochaetes bacterium RBG_13_68_11] diamond 198 45.8 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium RBG_13_68_11

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