RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA641991" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA641991 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
27017950 27017950 PRJNA641991_S_NODE_12442_length_166_cov_0.871795_g12323_i0 PRJNA641991 12442 166 0.871795 1.4471797 Labilithrix sp. 1971228 Bacteria Bacteria 41.6 0.0331   NR HVJ91798.1 1971228 g12323 i0 42.2 0.813253012048193 45 26 81.3 0 27 161 169 213 HVJ91798.1 hypothetical protein [Labilithrix sp.] diamond 135 41.6 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix sp.
29701862 29701862 PRJNA641991_S_NODE_6550_length_215_cov_0.921687_g6431_i0 PRJNA641991 6550 215 0.921687 1.98162705 Pyxidicoccus sp. 3LG 3383247 Bacteria Bacteria 62 4.1e-9   NR MFP2930078.1 3383247 g6431 i0 52.8 2.73488372093023 72 30 96.3 2 3 209 317 387 MFP2930078.1 Kelch repeat-containing protein [Pyxidicoccus sp. 3LG] diamond 588 62 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Pyxidicoccus Pyxidicoccus sp. 3LG
29860042 29860042 PRJNA641991_P_NODE_2311_length_200_cov_1.271523_g2270_i0 PRJNA641991 2311 200 1.271523 2.543046 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 67.8 2.68e-13   NR MBS2028124.1 2026735 g2270 i0 63.4 2.31 41 15 61.5 0 192 70 10 50 MBS2028124.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 462 67.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
30239202 30239202 PRJNA641991_S_NODE_10652_length_175_cov_1.214286_g10533_i0 PRJNA641991 10652 175 1.214286 2.1250005 Bradymonadia bacterium 3121696 Bacteria Bacteria 44.3 0.00439   NR MFN3199056.1 3121696 g10533 i0 46.8 0.805714285714286 47 22 77.1 3 40 174 634 679 MFN3199056.1 lectin-like protein [Bradymonadia bacterium] diamond 141 44.3 1 Bacteria   Pseudomonadati Myxococcota Bradymonadia       Bradymonadia bacterium
32167896 32167896 PRJNA641991_P_NODE_3858_length_163_cov_1.342105_g3817_i0 PRJNA641991 3858 163 1.342105 2.18763115 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 73.6 1.73e-13   NR MBI5509046.1 2026735 g3817 i0 53.7 2.76073619631902 54 23 95.7 1 4 159 601 654 MBI5509046.1 fibro-slime domain-containing protein [Deltaproteobacteria bacterium] diamond 450 73.6 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);;