RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax_phylum = "Rhodothermota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rhodothermota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA946307 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
13680558 13680558 PRJNA946307_P_NODE_21631_length_275_cov_3.256637_g20758_i0 PRJNA946307 21631 275 3.256637 8.95575175 Rubricoccaceae bacterium 2838334 Bacteria Bacteria 86.3 5.54e-18   NR HEX8384657.1 2838334 g20758 i0 84 0.545454545454545 50 8 54.5 0 157 8 106 155 HEX8384657.1 alpha/beta hydrolase [Rubricoccaceae bacterium] diamond 150 86.3 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae   Rubricoccaceae bacterium
27214838 27214838 PRJNA946307_P_NODE_135982_length_168_cov_3.126050_g135108_i0 PRJNA946307 135982 168 3.12605 5.251764 Rhodothermales bacterium 2306054 Bacteria Bacteria 58.2 2.47e-8   NR HLA64183.1 2306054 g135108 i0 58.8 3.64285714285714 51 21 91.1 0 3 155 62 112 HLA64183.1 phosphatase PAP2 family protein [Rhodothermales bacterium] diamond 612 58.2 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales     Rhodothermales bacterium
27310133 27310133 PRJNA946307_P_NODE_54963_length_210_cov_2.900621_g54089_i0 PRJNA946307 54963 210 2.900621 6.0913041 Rubricoccaceae bacterium 2838334 Bacteria Bacteria 45.1 0.00336   NR HEX9953376.1 2838334 g54089 i0 84 0.357142857142857 25 4 35.7 0 16 90 221 245 HEX9953376.1 LytTR family DNA-binding domain-containing protein [Rubricoccaceae bacterium] diamond 75 45.1 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae   Rubricoccaceae bacterium
29141463 29141463 PRJNA946307_P_NODE_154669_length_164_cov_0.886957_g153795_i0 PRJNA946307 154669 164 0.886957 1.45460948 Rubricoccaceae bacterium 2838334 Bacteria Bacteria 83.6 1.29e-19   NR HEX8299304.1 2838334 g153795 i0 84.9 1.9390243902439 53 8 97 0 5 163 9 61 HEX8299304.1 heavy-metal-associated domain-containing protein [Rubricoccaceae bacterium] diamond 318 83.6 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae   Rubricoccaceae bacterium
29835879 29835879 PRJNA946307_P_NODE_64171_length_200_cov_8.311258_g63297_i0 PRJNA946307 64171 200 8.311258 16.622516 Rubricoccaceae bacterium 2838334 Bacteria Bacteria 57.4 5.43e-8   NR MDX1421222.1 2838334 g63297 i0 93.5 0.945 31 2 46.5 0 194 102 44 74 MDX1421222.1 hypothetical protein [Rubricoccaceae bacterium] diamond 189 57.4 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae   Rubricoccaceae bacterium
29835902 29835902 PRJNA946307_P_NODE_91211_length_188_cov_1.971223_g90337_i0 PRJNA946307 91211 188 1.971223 3.70589924 Rhodothermales bacterium 2306054 Bacteria Bacteria 83.6 4.81e-18   NR HLA62943.1 2306054 g90337 i0 71.4 1.73936170212766 56 16 89.4 0 173 6 138 193 HLA62943.1 CoA pyrophosphatase [Rhodothermales bacterium] diamond 327 83.6 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales     Rhodothermales bacterium
31732019 31732019 PRJNA946307_P_NODE_150697_length_165_cov_0.879310_g149823_i0 PRJNA946307 150697 165 0.87931 1.4508615 Rubricoccaceae bacterium 2838334 Bacteria Bacteria 68.6 9.98e-12   NR HEX9950424.1 2838334 g149823 i0 64.7 0.927272727272727 51 17 90.9 1 164 15 657 707 HEX9950424.1 delta-60 repeat domain-containing protein [Rubricoccaceae bacterium] diamond 153 68.6 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae   Rubricoccaceae 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);;