RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA814235" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA814235 · 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
28160083 28160083 PRJNA814235_P_NODE_98425_length_203_cov_2.524096_g97030_i0 PRJNA814235 98425 203 2.524096 5.12391488 Chthonomonadaceae bacterium 2739509 Bacteria Bacteria 45.4 0.00242   NR HLJ56217.1 2739509 g97030 i0 91.7 0.724137931034483 24 2 35.5 0 73 2 204 227 HLJ56217.1 ABC transporter permease [Chthonomonadaceae bacterium] diamond 147 45.4 1 Bacteria   Bacillati Armatimonadota Chthonomonadia Chthonomonadales Chthonomonadaceae   Chthonomonadaceae bacterium
28452847 28452847 PRJNA814235_P_NODE_108606_length_203_cov_2.108434_g107211_i0 PRJNA814235 108606 203 2.108434 4.28012102 Bacteria 2 Bacteria Bacteria 48.1 1.09e-4   NR HLK14675.1 2682144 g107211 i0 87 0.679802955665025 23 3 34 0 134 202 26 48 HLK14675.1 DinB family protein [Fimbriimonadaceae bacterium] diamond 138 48.1 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
29391340 29391340 PRJNA814235_P_NODE_190549_length_151_cov_2.982456_g189154_i0 PRJNA814235 190549 151 2.982456 4.50350856 Armatimonadota bacterium 2033014 Bacteria Bacteria 86.3 4.9e-18   NR MBV9850834.1 2033014 g189154 i0 77.8 1.0728476821192101 54 8 99.3 1 2 151 518 571 MBV9850834.1 alpha-mannosidase [Armatimonadota bacterium] diamond 162 86.3 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
31034117 31034117 PRJNA814235_P_NODE_104475_length_203_cov_2.253012_g103080_i0 PRJNA814235 104475 203 2.253012 4.57361436 Armatimonadota bacterium 2033014 Bacteria Bacteria 47 6.88e-4   NR GIV16289.1 2033014 g103080 i0 41.8 1.96551724137931 67 35 99 1 203 3 309 371 GIV16289.1 MAG: serine protease MucD [Armatimonadota bacterium] diamond 399 47 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
32045936 32045936 PRJNA814235_P_NODE_103978_length_203_cov_2.271084_g102583_i0 PRJNA814235 103978 203 2.271084 4.61030052 Armatimonadota bacterium 2033014 Bacteria Bacteria 42 0.0406   NR MER3496253.1 2033014 g102583 i0 72 0.369458128078818 25 7 36.9 0 128 202 68 92 MER3496253.1 hypothetical protein [Armatimonadota bacterium] diamond 75 42 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
32709604 32709604 PRJNA814235_P_NODE_93480_length_203_cov_2.897590_g92085_i0 PRJNA814235 93480 203 2.89759 5.8821077 Armatimonadota bacterium 2033014 Bacteria Bacteria 47.8 3.63e-4   NR MDQ3814230.1 2033014 g92085 i0 42.9 0.931034482758621 63 25 93.1 1 15 203 272 323 MDQ3814230.1 Gfo/Idh/MocA family oxidoreductase [Armatimonadota bacterium] diamond 189 47.8 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
32772451 32772451 PRJNA814235_P_NODE_105160_length_203_cov_2.222892_g103765_i0 PRJNA814235 105160 203 2.222892 4.51247076 Chthonomonadales bacterium 2282151 Bacteria Bacteria 46.2 0.0013   NR MEP6755997.1 2282151 g103765 i0 88 0.369458128078818 25 3 36.9 0 2 76 234 258 MEP6755997.1 group II intron reverse transcriptase/maturase [Chthonomonadales bacterium] diamond 75 46.2 1 Bacteria   Bacillati Armatimonadota Chthonomonadia Chthonomonadales     Chthonomonadales 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);;