RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJEB83711", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermomicrobiota · 18 ✖

tax_kingdom 1

  • Pseudomonadati · 18 ✖

bioproject 1

  • PRJEB83711 · 18 ✖

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
144325 144325 PRJEB83711_P_NODE_57441_length_253_cov_1.300000_g57175_i0 PRJEB83711 57441 253 1.3 3.289 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 133 4.899999999999998e-35   NR HEV2067028.1 2482790 g57175 i0 78.6 0.99604743083004 84 18 99.6 0 252 1 54 137 HEV2067028.1 erythromycin esterase family protein [Thermomicrobiales bacterium] diamond 252 133 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
7796668 7796668 PRJEB83711_P_NODE_52507_length_262_cov_1.439153_g52241_i0 PRJEB83711 52507 262 1.439153 3.77058086 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 115 3.1699999999999998e-28   NR HEV2129342.1 2482790 g52241 i0 60.9 1.99236641221374 87 34 99.6 0 262 2 112 198 HEV2129342.1 alanine racemase [Thermomicrobiales bacterium] diamond 522 115 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
15447314 15447314 PRJEB83711_P_NODE_71593_length_246_cov_0.890173_g71327_i0 PRJEB83711 71593 246 0.890173 2.18982558 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 147 3.17e-41   NR HLU36542.1 2482790 g71327 i0 82.9 1 82 14 100 0 1 246 104 185 HLU36542.1 PstS family phosphate ABC transporter substrate-binding protein [Thermomicrobiales bacterium] diamond 246 147 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
26876423 26876423 PRJEB83711_P_NODE_77221_length_243_cov_0.917647_g76955_i0 PRJEB83711 77221 243 0.917647 2.22988221 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 86.3 1.79e-19   NR MCO5227262.1 2482790 g76955 i0 69.4 0.765432098765432 62 19 76.5 0 6 191 68 129 MCO5227262.1 hypothetical protein [Thermomicrobiales bacterium] diamond 186 86.3 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
27918709 27918709 PRJEB83711_P_NODE_65665_length_249_cov_0.886364_g65399_i0 PRJEB83711 65665 249 0.886364 2.20704636 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 102 3.88e-23   NR HEV2074167.1 2482790 g65399 i0 54.9 1.97590361445783 82 37 98.8 0 3 248 148 229 HEV2074167.1 2-oxoglutarate dehydrogenase E1 component [Thermomicrobiales bacterium] diamond 492 102 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
28329179 28329179 PRJEB83711_P_NODE_74466_length_244_cov_0.912281_g74200_i0 PRJEB83711 74466 244 0.912281 2.22596564 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 69.7 1.18e-11   NR HYH12856.1 2482790 g74200 i0 74.4 0.479508196721311 39 10 48 0 244 128 151 189 HYH12856.1 peptide ABC transporter substrate-binding protein [Thermomicrobiales bacterium] diamond 117 69.7 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
29118858 29118858 PRJEB83711_P_NODE_65829_length_249_cov_0.886364_g65563_i0 PRJEB83711 65829 249 0.886364 2.20704636 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 151 1.4199999999999999e-42   NR MCO5225605.1 2482790 g65563 i0 85.4 1.97590361445783 82 12 98.8 0 2 247 145 226 MCO5225605.1 hypothetical protein [Thermomicrobiales bacterium] diamond 492 151 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
29276322 29276322 PRJEB83711_P_NODE_51989_length_263_cov_1.400000_g51723_i0 PRJEB83711 51989 263 1.4 3.682 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 54.7 6.73e-7   NR HWV36637.1 2482790 g51723 i0 80 0.342205323193916 30 6 34.2 0 2 91 120 149 HWV36637.1 MFS transporter [Thermomicrobiales bacterium] diamond 90 54.7 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
29529157 29529157 PRJEB83711_P_NODE_57110_length_253_cov_2.394444_g56844_i0 PRJEB83711 57110 253 2.394444 6.05794332 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 96.7 2.09e-21   NR HLU36551.1 2482790 g56844 i0 71.8 1.83794466403162 78 22 92.5 0 20 253 11 88 HLU36551.1 serine hydrolase [Thermomicrobiales bacterium] diamond 465 96.7 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
29686631 29686631 PRJEB83711_P_NODE_58730_length_253_cov_0.866667_g58464_i0 PRJEB83711 58730 253 0.866667 2.19266751 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 133 2.26e-37   NR HYI15163.1 2482790 g58464 i0 72.5 0.948616600790514 80 22 94.9 0 12 251 1 80 HYI15163.1 PaaI family thioesterase [Thermomicrobiales bacterium] diamond 240 133 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
30002919 30002919 PRJEB83711_P_NODE_78611_length_242_cov_0.923077_g78345_i0 PRJEB83711 78611 242 0.923077 2.23384634 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 120 1.14e-29   NR HEV2073583.1 2482790 g78345 i0 73.7 0.942148760330578 76 20 94.2 0 241 14 229 304 HEV2073583.1 serine/threonine protein kinase [Thermomicrobiales bacterium] diamond 228 120 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
30634489 30634489 PRJEB83711_P_NODE_70873_length_246_cov_0.901734_g70607_i0 PRJEB83711 70873 246 0.901734 2.21826564 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 118 9.71e-29   NR HLU37621.1 2482790 g70607 i0 61.4 1.01219512195122 83 31 100 1 246 1 238 320 HLU37621.1 ABC transporter substrate-binding protein [Thermomicrobiales bacterium] diamond 249 118 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
31298215 31298215 PRJEB83711_P_NODE_60475_length_252_cov_0.871508_g60209_i0 PRJEB83711 60475 252 0.871508 2.19620016 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 80.5 2.06e-15   NR HEV2128896.1 2482790 g60209 i0 85.1 0.55952380952381 47 7 56 0 1 141 167 213 HEV2128896.1 peptidylprolyl isomerase [Thermomicrobiales bacterium] diamond 141 80.5 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
31614539 31614539 PRJEB83711_P_NODE_72916_length_245_cov_0.906977_g72650_i0 PRJEB83711 72916 245 0.906977 2.22209365 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 125 4.71e-34   NR HYJ12010.1 2482790 g72650 i0 71.6 1.98367346938776 81 23 99.2 0 1 243 40 120 HYJ12010.1 hypothetical protein [Thermomicrobiales bacterium] diamond 486 125 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
31702076 31702076 PRJEB83711_P_NODE_63057_length_250_cov_0.881356_g62791_i0 PRJEB83711 63057 250 0.881356 2.20339 Pseudomonadati 3379134 Bacteria Bacteria 121 1.01e-31   NR HEV2073339.1 2482790 g62791 i0 68.7 7.824 83 26 99.6 0 250 2 61 143 HEV2073339.1 type IIL restriction-modification enzyme MmeI [Thermomicrobiales bacterium] diamond 1956 121 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
31772645 31772645 PRJEB83711_P_NODE_78377_length_242_cov_0.923077_g78111_i0 PRJEB83711 78377 242 0.923077 2.23384634 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 94 1.38e-20   NR MCA9834809.1 2482790 g78111 i0 58.2 2.98760330578512 79 33 97.9 0 5 241 151 229 MCA9834809.1 glycosyltransferase family 4 protein [Thermomicrobiales bacterium] diamond 723 94 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
31962486 31962486 PRJEB83711_P_NODE_67618_length_248_cov_0.891429_g67352_i0 PRJEB83711 67618 248 0.891429 2.21074392 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 103 6.85e-24   NR MCO5226039.1 2482790 g67352 i0 84.9 1.28225806451613 53 8 64.1 0 160 2 1 53 MCO5226039.1 Fe-S cluster assembly protein SufB [Thermomicrobiales bacterium] diamond 318 103 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
32025867 32025867 PRJEB83711_P_NODE_73478_length_245_cov_0.906977_g73212_i0 PRJEB83711 73478 245 0.906977 2.22209365 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 135 1.3e-35   NR MCA9832407.1 2482790 g73212 i0 79 1.98367346938776 81 17 99.2 0 2 244 257 337 MCA9832407.1 3-isopropylmalate dehydratase large subunit [Thermomicrobiales bacterium] diamond 486 135 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);;