RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 18 ✖

bioproject 1

  • PRJNA1068830 · 18 ✖

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
1014177 1014177 PRJNA1068830_P_NODE_43441_length_336_cov_0.885932_g42738_i0 PRJNA1068830 43441 336 0.885932 2.97673152 uncultured Brachyspira sp. 221953 Bacteria Bacteria 130 7.04e-34   NR WP_300707100.1 221953 g42738 i0 100 0.5625 63 0 56.3 0 334 146 305 367 WP_300707100.1 hypothetical protein [uncultured Brachyspira sp.] diamond 189 130 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira uncultured Brachyspira sp.
2733104 2733104 PRJNA1068830_P_NODE_33783_length_389_cov_1.481013_g33080_i0 PRJNA1068830 33783 389 1.481013 5.76114057 uncultured Brachyspira sp. 221953 Bacteria Bacteria 263 7.979999999999999e-87   NR WP_300712370.1 221953 g33080 i0 100 0.994858611825193 129 0 99.5 0 3 389 40 168 WP_300712370.1 TRM11 family SAM-dependent methyltransferase [uncultured Brachyspira sp.] diamond 387 263 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira uncultured Brachyspira sp.
11662155 11662155 PRJNA1068830_P_NODE_74330_length_252_cov_0.871508_g73627_i0 PRJNA1068830 74330 252 0.871508 2.19620016 Leptonema illini 183 Bacteria Bacteria 220 5.919999999999999e-53   NTclustered gi|2735267|gb|U90843.1|LIU90843 929563 g73627 i0 82.54 255.337301587302 252 43 99 1 2 252 554 303 Leptonema illini 23S ribosomal RNA, partial sequence blastn 64345 220 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptonema Leptonema illini
26624075 26624075 PRJNA1068830_P_NODE_23601_length_484_cov_1.214112_g22900_i0 PRJNA1068830 23601 484 1.214112 5.87630208 uncultured Brachyspira sp. 221953 Bacteria Bacteria 299 1.1299999999999999e-90   NR WP_300712037.1 221953 g22900 i0 93.2 0.997933884297521 161 11 99.8 0 484 2 1061 1221 WP_300712037.1 sacsin N-terminal ATP-binding-like domain-containing protein [uncultured Brachyspira sp.] diamond 483 299 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira uncultured Brachyspira sp.
27320290 27320290 PRJNA1068830_P_NODE_59023_length_283_cov_1.785714_g58320_i0 PRJNA1068830 59023 283 1.785714 5.05357062 uncultured Brachyspira sp. 221953 Bacteria Bacteria 184 3.7699999999999996e-52   NR WP_300707105.1 221953 g58320 i0 100 0.985865724381625 93 0 98.6 0 281 3 534 626 WP_300707105.1 polysaccharide pyruvyl transferase family protein [uncultured Brachyspira sp.] diamond 279 184 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira uncultured Brachyspira sp.
27636138 27636138 PRJNA1068830_P_NODE_71524_length_254_cov_1.723757_g70821_i0 PRJNA1068830 71524 254 1.723757 4.37834278 uncultured Brachyspira sp. 221953 Bacteria Bacteria 160 9.09e-44   NR WP_300720589.1 221953 g70821 i0 97.6 0.992125984251969 84 2 99.2 0 2 253 640 723 WP_300720589.1 helicase HerA domain-containing protein [uncultured Brachyspira sp.] diamond 252 160 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira uncultured Brachyspira sp.
27762572 27762572 PRJNA1068830_P_NODE_73944_length_252_cov_0.871508_g73241_i0 PRJNA1068830 73944 252 0.871508 2.19620016 uncultured Brachyspira sp. 221953 Bacteria Bacteria 167 5.02e-46   NR WP_300712037.1 221953 g73241 i0 97.6 1 84 2 100 0 1 252 981 1064 WP_300712037.1 sacsin N-terminal ATP-binding-like domain-containing protein [uncultured Brachyspira sp.] diamond 252 167 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira uncultured Brachyspira sp.
27920090 27920090 PRJNA1068830_P_NODE_25605_length_460_cov_2.157623_g24903_i0 PRJNA1068830 25605 460 2.157623 9.9250658 Spirochaetes bacterium GWB1_59_5 1802176 Bacteria Bacteria 192 1.4499999999999995e-55   NR OHD26699.1 1802176 g24903 i0 59.5 0.965217391304348 148 57 96.5 1 444 1 58 202 OHD26699.1 MAG: hypothetical protein A2Y38_19225 [Spirochaetes bacterium GWB1_59_5] diamond 444 192 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_59_5
27951797 27951797 PRJNA1068830_P_NODE_21465_length_512_cov_1.066059_g20764_i0 PRJNA1068830 21465 512 1.066059 5.45822208 uncultured Brachyspira sp. 221953 Bacteria Bacteria 322 7.009999999999998e-99   NR WP_300712037.1 221953 g20764 i0 93.3 0.966796875 165 10 96.1 1 2 493 1369 1533 WP_300712037.1 sacsin N-terminal ATP-binding-like domain-containing protein [uncultured Brachyspira sp.] diamond 495 322 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira uncultured Brachyspira sp.
28267284 28267284 PRJNA1068830_P_NODE_67466_length_263_cov_1.642105_g66763_i0 PRJNA1068830 67466 263 1.642105 4.31873615 uncultured Brachyspira sp. 221953 Bacteria Bacteria 110 1.11e-28   NR WP_300720594.1 221953 g66763 i0 93 0.650190114068441 57 4 65 0 91 261 1 57 WP_300720594.1 hypothetical protein [uncultured Brachyspira sp.] diamond 171 110 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira uncultured Brachyspira sp.
28835770 28835770 PRJNA1068830_P_NODE_31688_length_404_cov_1.528701_g30985_i0 PRJNA1068830 31688 404 1.528701 6.17595204 uncultured Brachyspira sp. 221953 Bacteria Bacteria 265 4.43e-79   NR WP_300712037.1 221953 g30985 i0 99.3 0.995049504950495 134 1 99.5 0 404 3 204 337 WP_300712037.1 sacsin N-terminal ATP-binding-like domain-containing protein [uncultured Brachyspira sp.] diamond 402 265 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira uncultured Brachyspira sp.
29372610 29372610 PRJNA1068830_P_NODE_64669_length_270_cov_1.187817_g63966_i0 PRJNA1068830 64669 270 1.187817 3.2071059 uncultured Brachyspira sp. 221953 Bacteria Bacteria 176 4.5499999999999996e-52   NR WP_300707088.1 221953 g63966 i0 100 1 90 0 100 0 270 1 159 248 WP_300707088.1 phosphonopyruvate decarboxylase [uncultured Brachyspira sp.] diamond 270 176 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira uncultured Brachyspira sp.
29435444 29435444 PRJNA1068830_P_NODE_87990_length_242_cov_1.331361_g87287_i0 PRJNA1068830 87990 242 1.331361 3.22189362 uncultured Brachyspira sp. 221953 Bacteria Bacteria 135 3.59e-39   NR WP_300720858.1 221953 g87287 i0 100 0.84297520661157 68 0 84.3 0 242 39 35 102 WP_300720858.1 hypothetical protein [uncultured Brachyspira sp.] diamond 204 135 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira uncultured Brachyspira sp.
29490312 29490312 PRJNA1068830_P_NODE_26710_length_448_cov_1.666667_g26007_i0 PRJNA1068830 26710 448 1.666667 7.46666816 Bacteria 2 Bacteria Bacteria 108 2.58e-24   NR OHD24263.1 1802176 g26007 i0 42.1 2.68526785714286 133 77 89.1 0 416 18 231 363 OHD24263.1 MAG: hypothetical protein A2Y38_20060 [Spirochaetes bacterium GWB1_59_5] diamond 1203 108 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_59_5
29719616 29719616 PRJNA1068830_P_NODE_42410_length_340_cov_1.752809_g41707_i0 PRJNA1068830 42410 340 1.752809 5.9595506 uncultured Brachyspira sp. 221953 Bacteria Bacteria 100 8.77e-22   NR WP_300720589.1 221953 g41707 i0 95.9 0.432352941176471 49 2 43.2 0 339 193 737 785 WP_300720589.1 helicase HerA domain-containing protein [uncultured Brachyspira sp.] diamond 147 100 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira uncultured Brachyspira sp.
30793944 30793944 PRJNA1068830_P_NODE_83854_length_245_cov_0.906977_g83151_i0 PRJNA1068830 83854 245 0.906977 2.22209365 uncultured Treponema sp. 162155 Bacteria Bacteria 127 5.42e-33   NR WP_294424737.1 162155 g83151 i0 69.1 1.97142857142857 81 25 99.2 0 1 243 259 339 WP_294424737.1 glycosyltransferase [uncultured Treponema sp.] diamond 483 127 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema uncultured Treponema sp.
31679060 31679060 PRJNA1068830_P_NODE_12777_length_694_cov_2.634461_g12112_i0 PRJNA1068830 12777 694 2.634461 18.28315934 Spirochaetales bacterium 2026792 Bacteria Bacteria 65.9 1.66e-8   NR MDA3835868.1 2026792 g12112 i0 61.5 0.168587896253602 39 15 16.9 0 157 41 37 75 MDA3835868.1 hypothetical protein [Spirochaetales bacterium] diamond 117 65.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32312272 32312272 PRJNA1068830_P_NODE_49139_length_313_cov_0.975000_g48436_i0 PRJNA1068830 49139 313 0.975 3.05175 uncultured Brachyspira sp. 221953 Bacteria Bacteria 124 1.68e-30   NR WP_300712388.1 221953 g48436 i0 59.2 0.987220447284345 103 42 98.7 0 1 309 556 658 WP_300712388.1 DUF262 domain-containing protein [uncultured Brachyspira sp.] diamond 309 124 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira uncultured Brachyspira sp.

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