RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA485080" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA485080 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
17675031 17675031 PRJNA485080_P_NODE_31514_length_247_cov_0.885057_g31420_i0 PRJNA485080 31514 247 0.885057 2.18609079 Kofleriaceae bacterium 2212474 Bacteria Bacteria 156 5.31e-45   NR HEX7703479.1 2212474 g31420 i0 96.3 1.9919028340081 82 3 99.6 0 247 2 59 140 HEX7703479.1 malate dehydrogenase [Kofleriaceae bacterium] diamond 492 156 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae bacterium
28339604 28339604 PRJNA485080_P_NODE_28386_length_248_cov_0.880000_g28292_i0 PRJNA485080 28386 248 0.88 2.1824 Myxococcales bacterium 2026763 Bacteria Bacteria 43.5 0.0215   NR GMV44267.1 2026763 g28292 i0 33.8 0.82258064516129 68 35 77.4 2 243 52 597 658 GMV44267.1 MAG: hypothetical protein AMXMBFR64_59830 [Myxococcales bacterium] diamond 204 43.5 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
28592281 28592281 PRJNA485080_P_NODE_18647_length_269_cov_1.112245_g18553_i0 PRJNA485080 18647 269 1.112245 2.99193905 Archangium sp. 1872627 Bacteria Bacteria 45.4 0.00566   NR WP_407755685.1 1872627 g18553 i0 47.7 0.490706319702602 44 17 43.5 2 52 168 9 51 WP_407755685.1 DUF6311 domain-containing protein [Archangium sp.] diamond 132 45.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium sp.
28812877 28812877 PRJNA485080_P_NODE_32988_length_246_cov_0.890173_g32894_i0 PRJNA485080 32988 246 0.890173 2.18982558 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 43.5 0.0198   NR MBI5827122.1 2026735 g32894 i0 34.6 0.634146341463415 52 25 52.4 1 20 148 140 191 MBI5827122.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 156 43.5 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
29113551 29113551 PRJNA485080_P_NODE_24148_length_250_cov_0.870056_g24054_i0 PRJNA485080 24148 250 0.870056 2.17514 Bacteria 2 Bacteria Bacteria 91.3 7.91e-20   NR MBS1151255.1 2484252 g24054 i0 65.2 7.608 66 23 79.2 0 53 250 9 74 MBS1151255.1 oxidoreductase [Myxococcaceae bacterium] diamond 1902 91.7 0.995637949836423 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae   Myxococcaceae bacterium
30613303 30613303 PRJNA485080_P_NODE_17453_length_276_cov_1.492611_g17359_i0 PRJNA485080 17453 276 1.492611 4.11960636 Polyangium aurulentum 2567896 Bacteria Bacteria 43.1 0.0429   NR WP_169507605.1 2567896 g17359 i0 35.2 0.58695652173913 54 24 46.7 2 10 138 868 921 WP_169507605.1 MopE-related protein [Polyangium aurulentum] diamond 162 43.1 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Polyangium Polyangium aurulentum
31403682 31403682 PRJNA485080_P_NODE_30236_length_247_cov_0.885057_g30142_i0 PRJNA485080 30236 247 0.885057 2.18609079 Myxococcaceae bacterium 2484252 Bacteria Bacteria 48.1 4.55e-4   NR HEY8206058.1 2484252 g30142 i0 37.8 0.995951417004049 82 42 92.3 2 9 236 139 217 HEY8206058.1 M35 family metallo-endopeptidase [Myxococcaceae bacterium] diamond 246 48.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae   Myxococcaceae bacterium
32258023 32258023 PRJNA485080_P_NODE_10118_length_334_cov_1.180077_g10024_i0 PRJNA485080 10118 334 1.180077 3.94145718 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 84 3.64e-16   NR MBL8787667.1 2026735 g10024 i0 40.2 1.82335329341317 102 59 90.7 2 1 303 162 262 MBL8787667.1 FAD-binding oxidoreductase [Deltaproteobacteria bacterium] diamond 609 84 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);;