RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA492280" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA492280 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
26633195 26633195 PRJNA492280_P_NODE_21881_length_164_cov_3.000000_g21774_i0 PRJNA492280 21881 164 3 4.92 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 49.7 1.18e-5   NR MSP37504.1 2026735 g21774 i0 95.8 0.439024390243902 24 1 43.9 0 73 2 22 45 MSP37504.1 30S ribosomal protein S9 [Deltaproteobacteria bacterium] diamond 72 49.7 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
26680786 26680786 PRJNA492280_P_NODE_13021_length_164_cov_5.779528_g12914_i0 PRJNA492280 13021 164 5.779528 9.47842592 Pseudomonadati 3379134 Bacteria Bacteria 52 6.82e-6   NR TMA91203.1 2026735 g12914 i0 91.7 1.31707317073171 24 2 43.9 0 76 5 67 90 TMA91203.1 MAG: ABC transporter substrate-binding protein [Deltaproteobacteria bacterium] diamond 216 52.4 0.99236641221374 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
26743841 26743841 PRJNA492280_P_NODE_23741_length_164_cov_2.763780_g23634_i0 PRJNA492280 23741 164 2.76378 4.5325992 Pseudomonadati 3379134 Bacteria Bacteria 51.6 9.34e-6   NR TMA88567.1 2026735 g23634 i0 95.8 1.75609756097561 24 1 43.9 0 91 162 82 105 TMA88567.1 MAG: extracellular solute-binding protein [Deltaproteobacteria bacterium] diamond 288 51.6 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
26839501 26839501 PRJNA492280_P_NODE_31661_length_151_cov_2.912281_g31554_i0 PRJNA492280 31661 151 2.912281 4.39754431 Bacteria 2 Bacteria Bacteria 45.8 2.27e-4   NR MCC7382713.1 2026735 g31554 i0 42.4 6.37748344370861 66 17 89.4 1 135 1 2 67 MCC7382713.1 RNA-binding protein [Deltaproteobacteria bacterium] diamond 963 45.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
27740111 27740111 PRJNA492280_P_NODE_11404_length_164_cov_12.078740_g11297_i0 PRJNA492280 11404 164 12.07874 19.8091336 Labilithrix sp. 1971228 Bacteria Bacteria 43.5 0.00686   NR MBX3230791.1 1971228 g11297 i0 79.2 1.31707317073171 24 5 43.9 0 5 76 145 168 MBX3230791.1 glycerol-3-phosphate dehydrogenase/oxidase [Labilithrix sp.] diamond 216 43.5 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix sp.
28150422 28150422 PRJNA492280_P_NODE_30305_length_151_cov_4.500000_g30198_i0 PRJNA492280 30305 151 4.5 6.795 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 43.9 0.00378   NR MDP2605378.1 2026735 g30198 i0 87.5 0.47682119205298 24 3 47.7 0 78 149 25 48 MDP2605378.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 72 43.9 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
28308214 28308214 PRJNA492280_P_NODE_27006_length_163_cov_2.976190_g26899_i0 PRJNA492280 27006 163 2.97619 4.8511897 Archangium sp. 1872627 Bacteria Bacteria 52 6.63e-6   NR HZI03825.1 1872627 g26899 i0 92 10.1226993865031 25 2 46 0 3 77 327 351 HZI03825.1 hypothetical protein [Archangium sp.] diamond 1650 52 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium sp.
28419043 28419043 PRJNA492280_P_NODE_21006_length_164_cov_3.165354_g20899_i0 PRJNA492280 21006 164 3.165354 5.19118056 Pseudomonadati 3379134 Bacteria Bacteria 46.6 5.62e-4   NR MBM2803281.1 2026735 g20899 i0 69 1.0609756097561 29 9 53 0 160 74 95 123 MBM2803281.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 174 46.6 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
28529333 28529333 PRJNA492280_P_NODE_31087_length_151_cov_3.456140_g30980_i0 PRJNA492280 31087 151 3.45614 5.2187714 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 40 0.0201   NR TMQ07108.1 2026735 g30980 i0 68.2 0.437086092715232 22 7 43.7 0 151 86 33 54 TMQ07108.1 MAG: hypothetical protein E6J91_36475 [Deltaproteobacteria bacterium] diamond 66 40 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
28687285 28687285 PRJNA492280_P_NODE_19227_length_164_cov_3.464567_g19120_i0 PRJNA492280 19227 164 3.464567 5.68188988 Archangiaceae bacterium 2684409 Bacteria Bacteria 42.4 0.0178   NR MBK7862874.1 2684409 g19120 i0 83.3 0.439024390243902 24 4 43.9 0 4 75 910 933 MBK7862874.1 error-prone DNA polymerase [Archangiaceae bacterium] diamond 72 42.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae   Archangiaceae bacterium
28687293 28687293 PRJNA492280_P_NODE_34807_length_150_cov_2.539823_g34700_i0 PRJNA492280 34807 150 2.539823 3.8097345 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 50.8 4.49e-6   NR MDP2344456.1 2026735 g34700 i0 77.3 0.44 22 5 44 0 11 76 35 56 MDP2344456.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 66 50.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
29097582 29097582 PRJNA492280_P_NODE_21688_length_164_cov_3.023622_g21581_i0 PRJNA492280 21688 164 3.023622 4.95874008 Myxococcota bacterium 2818507 Bacteria Bacteria 49.7 4.51e-5   NR HEY1098488.1 2818507 g21581 i0 95.8 0.439024390243902 24 1 43.9 0 4 75 424 447 HEY1098488.1 sigma-54 dependent transcriptional regulator [Myxococcota bacterium] diamond 72 49.7 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
29476060 29476060 PRJNA492280_P_NODE_34290_length_150_cov_3.168142_g34183_i0 PRJNA492280 34290 150 3.168142 4.752213 Myxococcales bacterium 2026763 Bacteria Bacteria 42 0.0193   NR MCA9648726.1 2026763 g34183 i0 66.7 2.06 24 8 48 0 74 3 320 343 MCA9648726.1 cytochrome P450 [Myxococcales bacterium] diamond 309 42 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
30076276 30076276 PRJNA492280_P_NODE_21452_length_164_cov_3.070866_g21345_i0 PRJNA492280 21452 164 3.070866 5.03622024 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 48.1 1.58e-4   NR MBM4254918.1 2026735 g21345 i0 95.2 1.53658536585366 21 1 38.4 0 66 4 69 89 MBM4254918.1 hydantoinase/carbamoylase family amidase [Deltaproteobacteria bacterium] diamond 252 48.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
30897991 30897991 PRJNA492280_P_NODE_11694_length_164_cov_8.755906_g11587_i0 PRJNA492280 11694 164 8.755906 14.35968584 Myxococcales bacterium 2026763 Bacteria Bacteria 77.4 7.61e-15   NR NMB74746.1 2026763 g11587 i0 66.7 0.98780487804878 54 18 98.8 0 162 1 505 558 NMB74746.1 DUF1156 domain-containing protein [Myxococcales bacterium] diamond 162 77.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
31040562 31040562 PRJNA492280_P_NODE_30035_length_151_cov_5.026316_g29928_i0 PRJNA492280 30035 151 5.026316 7.58973716 Bacteria candidate phyla 1783234 Bacteria Bacteria 51.6 6.02e-6   NR TMA67379.1 2026735 g29928 i0 100 3.97350993377483 25 0 49.7 0 148 74 24 48 TMA67379.1 MAG: ABC transporter substrate-binding protein [Deltaproteobacteria bacterium] diamond 600 51.6 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
31134728 31134728 PRJNA492280_P_NODE_16335_length_164_cov_4.133858_g16228_i0 PRJNA492280 16335 164 4.133858 6.77952712 Bacteria candidate phyla 1783234 Bacteria Bacteria 55.1 5.62e-7   NR TMA56753.1 2026735 g16228 i0 100 3.27439024390244 24 0 43.9 0 75 4 488 511 TMA56753.1 MAG: thiamine pyrophosphate-requiring protein [Deltaproteobacteria bacterium] diamond 537 55.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);;