RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA870096", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 15 ✖

tax_phylum 1

  • Myxococcota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA870096 · 15 ✖

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
7228144 7228144 PRJNA870096_S_NODE_28306_length_337_cov_3.591837_g26642_i0 PRJNA870096 28306 337 3.591837 12.10449069 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 60.8 3.83e-8   NR MBS2029232.1 2026735 g26642 i0 47.8 0.801186943620178 90 42 79.2 5 17 283 223 308 MBS2029232.1 SDR family oxidoreductase [Deltaproteobacteria bacterium] diamond 270 60.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
26801935 26801935 PRJNA870096_S_NODE_39601_length_282_cov_2.849372_g37937_i0 PRJNA870096 39601 282 2.849372 8.03522904 Sandaracinaceae bacterium 2510337 Bacteria Bacteria 104 1.22e-24   NR MEQ9075168.1 2510337 g37937 i0 63.8 1 94 33 100 1 282 1 222 314 MEQ9075168.1 malate dehydrogenase [Sandaracinaceae bacterium] diamond 282 104 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Sandaracinaceae   Sandaracinaceae bacterium
26991702 26991702 PRJNA870096_S_NODE_70582_length_208_cov_2.581818_g68918_i0 PRJNA870096 70582 208 2.581818 5.37018144 Myxococcaceae bacterium 2484252 Bacteria Bacteria 91.7 1.13e-19   NR MFL5322420.1 2484252 g68918 i0 55.1 3.85096153846154 69 31 99.5 0 2 208 141 209 MFL5322420.1 carboxypeptidase regulatory-like domain-containing protein [Myxococcaceae bacterium] diamond 801 91.7 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae   Myxococcaceae bacterium
28065871 28065871 PRJNA870096_S_NODE_135585_length_153_cov_1.745455_g133921_i0 PRJNA870096 135585 153 1.745455 2.67054615 Kofleriaceae bacterium 2212474 Bacteria Bacteria 81.6 2.16e-16   NR HEU0030656.1 2212474 g133921 i0 72.5 1 51 14 100 0 1 153 733 783 HEU0030656.1 FAD-dependent oxidoreductase [Kofleriaceae bacterium] diamond 153 81.6 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae bacterium
28097430 28097430 PRJNA870096_S_NODE_53425_length_240_cov_3.279188_g51761_i0 PRJNA870096 53425 240 3.279188 7.8700512 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 77.4 2.15e-14   NR RJR33228.1 2026735 g51761 i0 55.1 2.65 69 31 86.3 0 209 3 516 584 RJR33228.1 MAG: NAD-dependent malic enzyme [Deltaproteobacteria bacterium] diamond 636 77.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
28791923 28791923 PRJNA870096_S_NODE_38347_length_287_cov_2.557377_g36683_i0 PRJNA870096 38347 287 2.557377 7.33967199 Polyangiales bacterium 3034171 Bacteria Bacteria 70.1 6.36e-12   NR HTU62081.1 3034171 g36683 i0 38.9 2.68641114982578 95 50 92 3 1 264 61 154 HTU62081.1 hypothetical protein [Polyangiales bacterium] diamond 771 70.1 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales     Polyangiales bacterium
30371589 30371589 PRJNA870096_S_NODE_95052_length_181_cov_1.043478_g93388_i0 PRJNA870096 95052 181 1.043478 1.88869518 Myxococcota bacterium 2818507 Bacteria Bacteria 87 2.18e-18   NR MEE2752009.1 2818507 g93388 i0 75.9 1.79005524861878 54 13 89.5 0 20 181 262 315 MEE2752009.1 tryptophan 2,3-dioxygenase family protein [Myxococcota bacterium] diamond 324 87 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
30434672 30434672 PRJNA870096_S_NODE_118413_length_163_cov_3.200000_g116749_i0 PRJNA870096 118413 163 3.2 5.216 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 56.2 9.74e-8   NR TMB05855.1 2026735 g116749 i0 63 4.91411042944785 54 18 97.5 2 160 2 136 188 TMB05855.1 MAG: peptidyl-prolyl cis-trans isomerase [Deltaproteobacteria bacterium] diamond 801 56.2 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
30781876 30781876 PRJNA870096_S_NODE_90494_length_185_cov_1.338028_g88830_i0 PRJNA870096 90494 185 1.338028 2.4753518 Polyangiales bacterium 3034171 Bacteria Bacteria 99.4 1.68e-23   NR MFO0625344.1 3034171 g88830 i0 72.1 0.989189189189189 61 17 98.9 0 185 3 170 230 MFO0625344.1 S-methyl-5-thioribose-1-phosphate isomerase [Polyangiales bacterium] diamond 183 99.4 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales     Polyangiales bacterium
31129073 31129073 PRJNA870096_S_NODE_141635_length_151_cov_1.777778_g139971_i0 PRJNA870096 141635 151 1.777778 2.68444478 Myxococcales bacterium 2026763 Bacteria Bacteria 54.7 6.02e-7   NR NNL67352.1 2026763 g139971 i0 52.1 3.75496688741722 48 23 95.4 0 149 6 241 288 NNL67352.1 Gfo/Idh/MocA family oxidoreductase [Myxococcales bacterium] diamond 567 54.7 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
31319079 31319079 PRJNA870096_S_NODE_78115_length_198_cov_2.167742_g76451_i0 PRJNA870096 78115 198 2.167742 4.29212916 Myxococcota bacterium 2818507 Bacteria Bacteria 43.1 0.014   NR MDG1481743.1 2818507 g76451 i0 45.2 0.636363636363636 42 23 63.6 0 128 3 190 231 MDG1481743.1 1-acyl-sn-glycerol-3-phosphate acyltransferase [Myxococcota bacterium] diamond 126 43.1 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
31666953 31666953 PRJNA870096_S_NODE_46537_length_259_cov_1.458333_g44873_i0 PRJNA870096 46537 259 1.458333 3.77708247 Myxococcales bacterium 2026763 Bacteria Bacteria 70.9 3.76e-12   NR MCA9719987.1 2026763 g44873 i0 38.2 4.07722007722008 89 50 97.3 2 3 254 219 307 MCA9719987.1 homogentisate 1,2-dioxygenase [Myxococcales bacterium] diamond 1056 70.9 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
32647094 32647094 PRJNA870096_S_NODE_37800_length_289_cov_4.097561_g36136_i0 PRJNA870096 37800 289 4.097561 11.84195129 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 120 4.13e-29   NR MAA80499.1 2026735 g36136 i0 63.6 13.1522491349481 88 32 91.3 0 3 266 703 790 MAA80499.1 glutamate-5-semialdehyde dehydrogenase [Deltaproteobacteria bacterium] diamond 3801 120 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
32867805 32867805 PRJNA870096_S_NODE_73740_length_204_cov_1.347826_g72076_i0 PRJNA870096 73740 204 1.347826 2.74956504 Myxococcota bacterium 2818507 Bacteria Bacteria 42.7 0.0225   NR HEV8325446.1 2818507 g72076 i0 50 0.588235294117647 40 17 54.4 1 135 25 308 347 HEV8325446.1 DUF2804 domain-containing protein [Myxococcota bacterium] diamond 120 42.7 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
32899212 32899212 PRJNA870096_S_NODE_77300_length_199_cov_2.115385_g75636_i0 PRJNA870096 77300 199 2.115385 4.20961615 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 50.1 5.21e-5   NR MBS2029232.1 2026735 g75636 i0 45.5 3.97989949748744 66 27 96.5 3 1 192 223 281 MBS2029232.1 SDR family oxidoreductase [Deltaproteobacteria bacterium] diamond 792 50.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria 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);;