RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA751877" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA751877 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
27179011 27179011 PRJNA751877_P_NODE_30162_length_241_cov_0.916667_g30040_i0 PRJNA751877 30162 241 0.916667 2.20916747 Myxococcales bacterium 2026763 Bacteria Bacteria 79.3 1.7e-17   NR MBT9554500.1 2026763 g30040 i0 64.6 1.9792531120332 48 17 59.8 0 239 96 6 53 MBT9554500.1 hypothetical protein [Myxococcales bacterium] diamond 477 79.3 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
28820968 28820968 PRJNA751877_P_NODE_22568_length_251_cov_0.865169_g22446_i0 PRJNA751877 22568 251 0.865169 2.17157419 Polyangiaceae bacterium 2268199 Bacteria Bacteria 125 3.8800000000000005e-33   NR NOU31425.1 2268199 g22446 i0 75 0.908366533864542 76 19 90.8 0 23 250 51 126 NOU31425.1 hypothetical protein [Polyangiaceae bacterium] diamond 228 125 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
30432326 30432326 PRJNA751877_P_NODE_9613_length_352_cov_0.942652_g9491_i0 PRJNA751877 9613 352 0.942652 3.31813504 Archangium sp. 1872627 Bacteria Bacteria 77.8 6.43e-14   NR HZI02469.1 1872627 g9491 i0 40 8.73579545454546 110 66 93.8 0 350 21 482 591 HZI02469.1 ABC transporter ATP-binding protein [Archangium sp.] diamond 3075 77.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium sp.
30495240 30495240 PRJNA751877_P_NODE_29853_length_241_cov_0.916667_g29731_i0 PRJNA751877 29853 241 0.916667 2.20916747 Myxococcota bacterium 2818507 Bacteria Bacteria 122 1.04e-31   NR HRE91594.1 2818507 g29731 i0 75 0.995850622406639 80 20 99.6 0 241 2 35 114 HRE91594.1 acyl-CoA desaturase [Myxococcota bacterium] diamond 240 122 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
31095360 31095360 PRJNA751877_P_NODE_26835_length_245_cov_1.029070_g26713_i0 PRJNA751877 26835 245 1.02907 2.5212215 Haliangium sp. UPWRP_2 1931276 Bacteria Bacteria 63.5 1.75e-9   NR WP_106525676.1 1931276 g26713 i0 43.8 0.979591836734694 80 42 95.5 2 235 2 363 441 WP_106525676.1 M12 family metallopeptidase [Haliangium sp. UPWRP_2] diamond 240 63.5 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae Haliangium Haliangium sp. UPWRP_2
31390073 31390073 PRJNA751877_P_NODE_20636_length_261_cov_1.537234_g20514_i0 PRJNA751877 20636 261 1.537234 4.01218074 Pseudomonadati 3379134 Bacteria Bacteria 105 2.4399999999999997e-24   NR WP_043399270.1 83451 g20514 i0 56.1 19.0689655172414 82 36 94.3 0 3 248 310 391 WP_043399270.1 dipeptidase [Archangium violaceum] diamond 4977 106 0.990566037735849 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium violaceum
32012653 32012653 PRJNA751877_P_NODE_23418_length_250_cov_0.870056_g23296_i0 PRJNA751877 23418 250 0.870056 2.17514 Anaeromyxobacter sp. 1872521 Bacteria Bacteria 43.1 0.0214   NR HEY6100889.1 1872521 g23296 i0 43.5 0.744 62 34 74.4 1 48 233 49 109 HEY6100889.1 RNA 2',3'-cyclic phosphodiesterase [Anaeromyxobacter sp.] diamond 186 43.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Anaeromyxobacteraceae Anaeromyxobacter Anaeromyxobacter sp.

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);;