RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA488043" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJNA488043 · 19 ✖

analysis 1

  • diamond · 19 ✖

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
22126356 22126356 PRJNA488043_P_NODE_21318_length_160_cov_1.587786_g19076_i0 PRJNA488043 21318 160 1.587786 2.5404576 Myxococcales bacterium 2026763 Bacteria Bacteria 98.6 1.22e-22   NR MBL0198546.1 2026763 g19076 i0 88.7 0.99375 53 6 99.4 0 160 2 7 59 MBL0198546.1 hypothetical protein [Myxococcales bacterium] diamond 159 98.6 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
26696387 26696387 PRJNA488043_P_NODE_18501_length_187_cov_1.905063_g16259_i0 PRJNA488043 18501 187 1.905063 3.56246781 Myxococcales bacterium 2026763 Bacteria Bacteria 85.5 1.69e-19   NR MBL0220001.1 2026763 g16259 i0 83.3 0.770053475935829 48 8 77 0 186 43 83 130 MBL0220001.1 hypothetical protein [Myxococcales bacterium] diamond 144 85.5 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
26759699 26759699 PRJNA488043_P_NODE_6501_length_496_cov_1.974304_g4436_i0 PRJNA488043 6501 496 1.974304 9.79254784 Nannocystaceae bacterium 2545255 Bacteria Bacteria 59.7 2.18e-7   NR MEE9382825.1 2545255 g4436 i0 56.9 0.86491935483871 51 19 29 1 27 170 136 186 MEE9382825.1 ASCH domain-containing protein [Nannocystaceae bacterium] diamond 429 59.7 1 Bacteria   Pseudomonadati Myxococcota   Nannocystales Nannocystaceae   Nannocystaceae bacterium
26791596 26791596 PRJNA488043_P_NODE_18801_length_184_cov_1.709677_g16559_i0 PRJNA488043 18801 184 1.709677 3.14580568 Polyangiaceae bacterium 2268199 Bacteria Bacteria 94.7 1.23e-22   NR HQY59798.1 2268199 g16559 i0 73.3 0.978260869565217 60 16 97.8 0 182 3 61 120 HQY59798.1 hypothetical protein [Polyangiaceae bacterium] diamond 180 94.7 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
26823330 26823330 PRJNA488043_P_NODE_8741_length_383_cov_2.079096_g6524_i0 PRJNA488043 8741 383 2.079096 7.96293768 Polyangiaceae bacterium 2268199 Bacteria Bacteria 57.8 9.36e-7   NR MDF3069182.1 2268199 g6524 i0 28.3 0.939947780678851 120 79 90.9 2 10 357 122 238 MDF3069182.1 hypothetical protein [Polyangiaceae bacterium] diamond 360 57.8 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
27044742 27044742 PRJNA488043_P_NODE_4902_length_607_cov_2.065744_g3015_i0 PRJNA488043 4902 607 2.065744 12.53906608 Myxococcales bacterium 2026763 Bacteria Bacteria 239 4.13e-76   NR MBL0198569.1 2026763 g3015 i0 74.5 1.59143327841845 161 37 77.6 1 471 1 18 178 MBL0198569.1 PD-(D/E)XK nuclease family protein [Myxococcales bacterium] diamond 966 239 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
27266047 27266047 PRJNA488043_P_NODE_21203_length_161_cov_1.409091_g18961_i0 PRJNA488043 21203 161 1.409091 2.26863651 Polyangiales bacterium 3034171 Bacteria Bacteria 62.8 8.66e-10   NR MEZ4391981.1 3034171 g18961 i0 70.2 0.875776397515528 47 14 87.6 0 20 160 1 47 MEZ4391981.1 hypothetical protein [Polyangiales bacterium] diamond 141 62.8 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales     Polyangiales bacterium
27929218 27929218 PRJNA488043_P_NODE_12885_length_263_cov_2.974359_g10644_i0 PRJNA488043 12885 263 2.974359 7.82256417 Polyangia bacterium 3058050 Bacteria Bacteria 65.1 7.35e-11   NR MFO0578713.1 3058050 g10644 i0 43.9 0.935361216730038 82 46 93.5 0 253 8 53 134 MFO0578713.1 hypothetical protein [Polyangia bacterium] diamond 246 65.1 1 Bacteria   Pseudomonadati Myxococcota         Polyangia bacterium
28402803 28402803 PRJNA488043_P_NODE_5866_length_534_cov_1.661386_g3870_i0 PRJNA488043 5866 534 1.661386 8.87180124 Kofleriaceae bacterium 2212474 Bacteria Bacteria 87.8 1.12e-16   NR HPH70271.1 2212474 g3870 i0 32.5 1.10674157303371 197 95 89.3 3 529 53 237 433 HPH70271.1 hypothetical protein [Kofleriaceae bacterium] diamond 591 87.8 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae bacterium
28971143 28971143 PRJNA488043_P_NODE_21768_length_156_cov_2.070866_g19526_i0 PRJNA488043 21768 156 2.070866 3.23055096 Myxococcales bacterium 2026763 Bacteria Bacteria 49.7 4.73e-6   NR MBK6463560.1 2026763 g19526 i0 69 0.557692307692308 29 9 55.8 0 155 69 62 90 MBK6463560.1 hypothetical protein [Myxococcales bacterium] diamond 87 49.7 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
29397617 29397617 PRJNA488043_P_NODE_6069_length_521_cov_2.004065_g4043_i0 PRJNA488043 6069 521 2.004065 10.44117865 root 1 Root_unresolved Root_unresolved 63.2 1.05e-8   NR MBU6163091.1 2026763 g4043 i0 45.9 1.09404990403071 98 49 56.4 2 296 3 78 171 MBU6163091.1 hypothetical protein [Myxococcales bacterium] diamond 570 63.2 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
29665366 29665366 PRJNA488043_P_NODE_21270_length_160_cov_2.274809_g19028_i0 PRJNA488043 21270 160 2.274809 3.6396944 Myxococcales bacterium 2026763 Bacteria Bacteria 88.2 1.01e-20   NR MBL0220001.1 2026763 g19028 i0 86.3 0.95625 51 7 95.6 0 1 153 17 67 MBL0220001.1 hypothetical protein [Myxococcales bacterium] diamond 153 88.2 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
29665371 29665371 PRJNA488043_P_NODE_6350_length_505_cov_2.397059_g4302_i0 PRJNA488043 6350 505 2.397059 12.10514795 Polyangia bacterium 3058050 Bacteria Bacteria 135 5.679999999999999e-37   NR MFO0578693.1 3058050 g4302 i0 48.1 1.74653465346535 156 78 92.1 2 38 502 1 154 MFO0578693.1 hypothetical protein [Polyangia bacterium] diamond 882 135 1 Bacteria   Pseudomonadati Myxococcota         Polyangia bacterium
29886922 29886922 PRJNA488043_P_NODE_7871_length_421_cov_2.441327_g5689_i0 PRJNA488043 7871 421 2.441327 10.27798667 Polyangia bacterium 3058050 Bacteria Bacteria 118 4.76e-28   NR MFO0578686.1 3058050 g5689 i0 46.8 0.990498812351544 139 73 98.3 1 419 6 329 467 MFO0578686.1 DUF935 family protein [Polyangia bacterium] diamond 417 118 1 Bacteria   Pseudomonadati Myxococcota         Polyangia bacterium
30455846 30455846 PRJNA488043_P_NODE_18053_length_191_cov_2.450617_g15811_i0 PRJNA488043 18053 191 2.450617 4.68067847 Polyangia bacterium 3058050 Bacteria Bacteria 51.6 6.45e-6   NR MFO0578675.1 3058050 g15811 i0 46.2 1.02094240837696 65 30 94.2 2 190 11 81 145 MFO0578675.1 hypothetical protein [Polyangia bacterium] diamond 195 51.6 1 Bacteria   Pseudomonadati Myxococcota         Polyangia bacterium
30455857 30455857 PRJNA488043_P_NODE_6553_length_492_cov_2.622030_g4480_i0 PRJNA488043 6553 492 2.62203 12.9003876 Polyangia bacterium 3058050 Bacteria Bacteria 109 8.01e-25   NR MFO0578695.1 3058050 g4480 i0 47.5 0.719512195121951 118 62 72 0 1 354 283 400 MFO0578695.1 phage protein Gp37 [Polyangia bacterium] diamond 354 109 1 Bacteria   Pseudomonadati Myxococcota         Polyangia bacterium
31213346 31213346 PRJNA488043_P_NODE_18575_length_186_cov_2.458599_g16333_i0 PRJNA488043 18575 186 2.458599 4.57299414 Kofleriaceae bacterium 2212474 Bacteria Bacteria 114 9e-31   NR HPH68572.1 2212474 g16333 i0 90.2 0.983870967741935 61 6 98.4 0 185 3 86 146 HPH68572.1 hypothetical protein [Kofleriaceae bacterium] diamond 183 114 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae bacterium
32511151 32511151 PRJNA488043_P_NODE_20939_length_163_cov_1.835821_g18697_i0 PRJNA488043 20939 163 1.835821 2.99238823 Myxococcales bacterium 2026763 Bacteria Bacteria 105 9.82e-26   NR MBL0197628.1 2026763 g18697 i0 100 0.993865030674847 54 0 99.4 0 2 163 107 160 MBL0197628.1 Mu-like prophage major head subunit gpT family protein [Myxococcales bacterium] diamond 162 105 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
32762961 32762961 PRJNA488043_P_NODE_8940_length_376_cov_2.184438_g6720_i0 PRJNA488043 8940 376 2.184438 8.21348688 Nannocystaceae bacterium 2545255 Bacteria Bacteria 59.7 7.44e-8   NR MEE9382825.1 2545255 g6720 i0 56.9 1.71542553191489 51 19 38.3 1 27 170 136 186 MEE9382825.1 ASCH domain-containing protein [Nannocystaceae bacterium] diamond 645 59.7 1 Bacteria   Pseudomonadati Myxococcota   Nannocystales Nannocystaceae   Nannocystaceae 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);;