RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA390533", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermomicrobiota · 21 ✖

tax_kingdom 1

  • Pseudomonadati · 21 ✖

bioproject 1

  • PRJNA390533 · 21 ✖

analysis 1

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
8062982 8062982 PRJNA390533_P_NODE_25907_length_309_cov_3.829630_g24880_i0 PRJNA390533 25907 309 3.82963 11.8335567 uncultured Thermomicrobiales bacterium 1645740 Bacteria Bacteria 175 1.24e-51   NR CAA9565578.1 1645740 g24880 i0 92.5 3.79611650485437 93 7 90.3 0 10 288 156 248 CAA9565578.1 MAG: 2-keto-3-deoxy-D-arabino-heptulosonate-7-phosphate synthase I beta [uncultured Thermomicrobiales bacterium] diamond 1173 175 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     uncultured Thermomicrobiales bacterium
15712514 15712514 PRJNA390533_P_NODE_41893_length_173_cov_1.455224_g40866_i0 PRJNA390533 41893 173 1.455224 2.51753752 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 77.4 8.37e-15   NR HKG26113.1 2482790 g40866 i0 78.7 1.63005780346821 47 10 81.5 0 31 171 6 52 HKG26113.1 alpha-glucosidase/alpha-galactosidase [Thermomicrobiales bacterium] diamond 282 77.4 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
20811085 20811085 PRJNA390533_P_NODE_1057_length_1521_cov_2.872470_g871_i0 PRJNA390533 1057 1521 2.87247 43.6902687 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 685 8.049999999999999e-243   NR MCA9835038.1 2482790 g871 i0 88.7 0.749506903353057 380 39 75 1 1353 214 158 533 MCA9835038.1 peptide chain release factor 3 [Thermomicrobiales bacterium] diamond 1140 685 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
24636275 24636275 PRJNA390533_P_NODE_48820_length_153_cov_2.070175_g47793_i0 PRJNA390533 48820 153 2.070175 3.16736775 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 91.3 1.96e-20   NR HYO31158.1 2482790 g47793 i0 86 1.96078431372549 50 7 98 0 3 152 80 129 HYO31158.1 SDR family oxidoreductase [Thermomicrobiales bacterium] diamond 300 91.3 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
24636340 24636340 PRJNA390533_P_NODE_7640_length_712_cov_6.765230_g6884_i0 PRJNA390533 7640 712 6.76523 48.1684376 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 389 2.25e-128   NR MCA9835032.1 2482790 g6884 i0 92.1 0.855337078651685 203 16 85.5 0 47 655 46 248 MCA9835032.1 alpha-glucan family phosphorylase [Thermomicrobiales bacterium] diamond 609 389 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
26790541 26790541 PRJNA390533_P_NODE_16741_length_443_cov_1.732673_g15729_i0 PRJNA390533 16741 443 1.732673 7.67574139 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 45.8 0.00129   NR MCD6056546.1 2482790 g15729 i0 40.4 0.352144469525959 52 31 35.2 0 181 336 4 55 MCD6056546.1 hypothetical protein [Thermomicrobiales bacterium] diamond 156 45.8 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
27250133 27250133 PRJNA390533_P_NODE_46943_length_158_cov_1.218487_g45916_i0 PRJNA390533 46943 158 1.218487 1.92520946 Pseudomonadati 3379134 Bacteria Bacteria 61.2 3.29e-9   NR HET8631085.1 2482790 g45916 i0 71.4 4.78481012658228 42 12 79.7 0 128 3 1 42 HET8631085.1 HigA family addiction module antitoxin [Thermomicrobiales bacterium] diamond 756 61.2 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
27991400 27991400 PRJNA390533_P_NODE_46245_length_160_cov_0.909091_g45218_i0 PRJNA390533 46245 160 0.909091 1.4545456 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 84.3 2.35e-17   NR HEV2127117.1 2482790 g45218 i0 69.2 0.975 52 16 97.5 0 159 4 72 123 HEV2127117.1 NAD-dependent succinate-semialdehyde dehydrogenase [Thermomicrobiales bacterium] diamond 156 84.3 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
28875304 28875304 PRJNA390533_P_NODE_18708_length_406_cov_3.032698_g17688_i0 PRJNA390533 18708 406 3.032698 12.31275388 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 189 4.539999999999999e-54   NR HLU35656.1 2482790 g17688 i0 68 2.83004926108374 128 41 94.6 0 2 385 153 280 HLU35656.1 peptide ABC transporter substrate-binding protein [Thermomicrobiales bacterium] diamond 1149 189 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
29033417 29033417 PRJNA390533_P_NODE_25448_length_316_cov_0.898917_g24421_i0 PRJNA390533 25448 316 0.898917 2.84057772 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 54.3 7.32e-6   NR MCA9860229.1 2482790 g24421 i0 88.5 1.45253164556962 26 3 24.7 0 80 3 198 223 MCA9860229.1 peptide ABC transporter substrate-binding protein [Thermomicrobiales bacterium] diamond 459 54.3 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
29380497 29380497 PRJNA390533_P_NODE_10449_length_604_cov_9.849558_g9560_i0 PRJNA390533 10449 604 9.849558 59.49133032 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 65.5 5.7e-10   NR HEV2129377.1 2482790 g9560 i0 32.7 0.486754966887417 98 62 48.7 1 22 315 22 115 HEV2129377.1 hypothetical protein [Thermomicrobiales bacterium] diamond 294 65.5 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
29506720 29506720 PRJNA390533_P_NODE_41090_length_176_cov_1.459854_g40063_i0 PRJNA390533 41090 176 1.459854 2.56934304 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 89 4.62e-19   NR HEY8598045.1 2482790 g40063 i0 78 1.00568181818182 59 12 98.9 1 1 174 190 248 HEY8598045.1 zinc-dependent alcohol dehydrogenase [Thermomicrobiales bacterium] diamond 177 89 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
30075142 30075142 PRJNA390533_P_NODE_452_length_1966_cov_7.154645_g357_i0 PRJNA390533 452 1966 7.154645 140.6603207 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 227 1.66e-63   NR MCD6031919.1 2482790 g357 i0 46.6 0.540183112919634 354 173 52.2 5 738 1763 93 442 MCD6031919.1 hypothetical protein [Thermomicrobiales bacterium] diamond 1062 227 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
30675427 30675427 PRJNA390533_P_NODE_24913_length_316_cov_1.281588_g23886_i0 PRJNA390533 24913 316 1.281588 4.04981808 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 52 1.93e-5   NR HRA46772.1 2482790 g23886 i0 84.6 2.46835443037975 26 4 24.7 0 239 316 31 56 HRA46772.1 SRPBCC domain-containing protein [Thermomicrobiales bacterium] diamond 780 52 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
30738677 30738677 PRJNA390533_P_NODE_24674_length_316_cov_1.624549_g23647_i0 PRJNA390533 24674 316 1.624549 5.13357484 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 44.7 0.0106   NR MCC6314910.1 2482790 g23647 i0 80 0.237341772151899 25 5 23.7 0 240 314 146 170 MCC6314910.1 hypothetical protein [Thermomicrobiales bacterium] diamond 75 44.7 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
31434041 31434041 PRJNA390533_P_NODE_49016_length_153_cov_1.298246_g47989_i0 PRJNA390533 49016 153 1.298246 1.98631638 Sphaerobacter sp. 2099654 Bacteria Bacteria 50.1 1.33e-5   NR MDI3341340.1 2099654 g47989 i0 49 1 51 26 100 0 1 153 117 167 MDI3341340.1 DUF1648 domain-containing protein [Sphaerobacter sp.] diamond 153 50.1 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Sphaerobacterales Sphaerobacteraceae Sphaerobacter Sphaerobacter sp.
31813672 31813672 PRJNA390533_P_NODE_42357_length_171_cov_1.833333_g41330_i0 PRJNA390533 42357 171 1.833333 3.13499943 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 78.6 1.49e-15   NR HYO31158.1 2482790 g41330 i0 72.7 0.964912280701754 55 15 96.5 0 2 166 190 244 HYO31158.1 SDR family oxidoreductase [Thermomicrobiales bacterium] diamond 165 78.6 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
31940064 31940064 PRJNA390533_P_NODE_477_length_1936_cov_7.209278_g357_i1 PRJNA390533 477 1936 7.209278 139.57162208 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 206 1.5499999999999996e-55   NR MCD6031919.1 2482790 g357 i1 45.3 0.52995867768595 342 171 51.1 5 738 1727 93 430 MCD6031919.1 hypothetical protein [Thermomicrobiales bacterium] diamond 1026 206 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
31940066 31940066 PRJNA390533_P_NODE_48917_length_153_cov_1.578947_g47890_i0 PRJNA390533 48917 153 1.578947 2.41578891 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 60.1 7.5e-9   NR HEY8601244.1 2482790 g47890 i0 55.1 0.96078431372549 49 22 96.1 0 152 6 189 237 HEY8601244.1 YafY family protein [Thermomicrobiales bacterium] diamond 147 60.1 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
32414959 32414959 PRJNA390533_P_NODE_12459_length_546_cov_2.816568_g11517_i0 PRJNA390533 12459 546 2.816568 15.37846128 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 339 5.77e-111   NR MEJ7901825.1 2482790 g11517 i0 92.5 0.956043956043956 174 13 95.6 0 535 14 91 264 MEJ7901825.1 peptide ABC transporter substrate-binding protein [Thermomicrobiales bacterium] diamond 522 339 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
32698827 32698827 PRJNA390533_P_NODE_17440_length_429_cov_1.720513_g16424_i0 PRJNA390533 17440 429 1.720513 7.38100077 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 142 5.62e-36   NR MCC2627512.1 2482790 g16424 i0 53 2.34965034965035 168 38 88.8 1 396 16 1 168 MCC2627512.1 hypothetical protein [Thermomicrobiales bacterium] diamond 1008 142 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales 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);;