RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA1115053" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1115053 · 11 ✖

analysis 1

  • diamond · 11 ✖
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
26719436 26719436 PRJNA1115053_S_NODE_148521_length_220_cov_2.440678_g146704_i0 PRJNA1115053 148521 220 2.440678 5.3694916 Phycisphaerales bacterium 2052180 Bacteria Bacteria 42.7 0.0266   NR MCH2162800.1 2052180 g146704 i0 39.5 0.518181818181818 38 23 51.8 0 63 176 270 307 MCH2162800.1 hypothetical protein [Phycisphaerales bacterium] diamond 114 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
26878428 26878428 PRJNA1115053_S_NODE_124221_length_237_cov_3.051546_g122404_i0 PRJNA1115053 124221 237 3.051546 7.23216402 Planctomycetota bacterium 2026780 Bacteria Bacteria 41.6 0.0443   NR REJ79784.1 2026780 g122404 i0 46.3 0.518987341772152 41 22 51.9 0 13 135 99 139 REJ79784.1 MAG: YkgJ family cysteine cluster protein [Planctomycetota bacterium] diamond 123 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27004612 27004612 PRJNA1115053_S_NODE_198722_length_194_cov_2.543046_g196905_i0 PRJNA1115053 198722 194 2.543046 4.93350924 Planctomycetia bacterium 2052181 Bacteria Bacteria 41.6 0.0498   NR MDO4571097.1 2052181 g196905 i0 37.5 0.865979381443299 56 34 86.6 1 174 7 190 244 MDO4571097.1 PmoA family protein [Planctomycetia bacterium] diamond 168 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
27185348 27185348 PRJNA1115053_S_NODE_60822_length_313_cov_3.833333_g59005_i0 PRJNA1115053 60822 313 3.833333 11.99833229 PVC group 1783257 Bacteria Bacteria 43.9 0.03   NR MCC6406572.1 2026780 g59005 i0 41.8 1.53354632587859 67 33 62.3 4 114 308 1 63 MCC6406572.1 hypothetical protein [Planctomycetota bacterium] diamond 480 43.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28394393 28394393 PRJNA1115053_S_NODE_215306_length_188_cov_0.875862_g213489_i0 PRJNA1115053 215306 188 0.875862 1.64662056 Planctomycetota bacterium 2026780 Bacteria Bacteria 39.3 0.0482   NR HKB15928.1 2026780 g213489 i0 56.3 0.51063829787234 32 13 49.5 1 28 120 10 41 HKB15928.1 hypothetical protein [Planctomycetota bacterium] diamond 96 39.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30636557 30636557 PRJNA1115053_S_NODE_129413_length_233_cov_2.857895_g127596_i0 PRJNA1115053 129413 233 2.857895 6.65889535 Rhodopirellula sp. 2024855 Bacteria Bacteria 43.1 0.0216   NR MAQ91336.1 2024855 g127596 i0 43.5 0.592274678111588 46 21 52.8 1 189 67 206 251 MAQ91336.1 hypothetical protein [Rhodopirellula sp.] diamond 138 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rhodopirellula Rhodopirellula sp.
30889564 30889564 PRJNA1115053_S_NODE_360574_length_150_cov_0.897196_g358757_i0 PRJNA1115053 360574 150 0.897196 1.345794 Planctomycetota bacterium 2026780 Bacteria Bacteria 42 0.0195   NR MEZ6194240.1 2026780 g358757 i0 48.9 0.94 47 24 94 0 3 143 176 222 MEZ6194240.1 hypothetical protein [Planctomycetota bacterium] diamond 141 42 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31395364 31395364 PRJNA1115053_S_NODE_291576_length_163_cov_2.400000_g289759_i0 PRJNA1115053 291576 163 2.4 3.912 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 42 0.0228   NR MEZ6058101.1 2026779 g289759 i0 50 0.552147239263804 30 15 55.2 0 63 152 245 274 MEZ6058101.1 formylglycine-generating enzyme family protein [Planctomycetaceae bacterium] diamond 90 42 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
32376035 32376035 PRJNA1115053_S_NODE_206879_length_191_cov_1.459459_g205062_i0 PRJNA1115053 206879 191 1.459459 2.78756669 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.4 0.0261   NR MDG1983274.1 2026780 g205062 i0 42.6 0.848167539267016 54 29 84.8 1 11 172 714 765 MDG1983274.1 PSD1 and planctomycete cytochrome C domain-containing protein [Planctomycetota bacterium] diamond 162 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32471078 32471078 PRJNA1115053_S_NODE_63119_length_309_cov_2.165414_g61302_i0 PRJNA1115053 63119 309 2.165414 6.69112926 Planctomycetota bacterium 2026780 Bacteria Bacteria 48.5 5.88e-4   NR MEM1329189.1 2026780 g61302 i0 32.9 1.36893203883495 70 47 68 0 305 96 136 205 MEM1329189.1 hypothetical protein [Planctomycetota bacterium] diamond 423 48.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32597361 32597361 PRJNA1115053_S_NODE_210740_length_189_cov_2.630137_g208923_i0 PRJNA1115053 210740 189 2.630137 4.97095893 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.4 0.0243   NR MCC6406572.1 2026780 g208923 i0 43.1 0.920634920634921 58 28 88.9 3 181 14 1 55 MCC6406572.1 hypothetical protein [Planctomycetota bacterium] diamond 174 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota 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);;