RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA326068" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA326068 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
27769804 27769804 PRJNA326068_P_NODE_18564_length_171_cov_3.366197_g17601_i0 PRJNA326068 18564 171 3.366197 5.75619687 Odoribacter splanchnicus 28118 Bacteria Bacteria 49.7 2.91e-5   NR SPY22707.1 28118 g17601 i0 50.9 0.929824561403509 53 26 93 0 10 168 65 117 SPY22707.1 Uncharacterised protein [Odoribacter splanchnicus] diamond 159 49.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Odoribacteraceae Odoribacter Odoribacter splanchnicus
28811163 28811163 PRJNA326068_P_NODE_18148_length_178_cov_2.691275_g17185_i0 PRJNA326068 18148 178 2.691275 4.7904695 Catalinimonas alkaloidigena 1075417 Bacteria Bacteria 58.5 9.59e-9   NR MDF9794741.1 1075417 g17185 i0 69.6 0.775280898876405 46 14 77.5 0 10 147 63 108 MDF9794741.1 hypothetical protein [Catalinimonas alkaloidigena] diamond 138 58.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Catalimonadaceae Catalinimonas Catalinimonas alkaloidigena
30674813 30674813 PRJNA326068_P_NODE_10133_length_314_cov_2.066667_g9174_i0 PRJNA326068 10133 314 2.066667 6.48933438 Ferruginibacter sp. 1940288 Bacteria Bacteria 169 2.08e-51   NR MEO6719837.1 1940288 g9174 i0 79.6 3.9171974522293 103 21 98.4 0 312 4 10 112 MEO6719837.1 PA2169 family four-helix-bundle protein [Ferruginibacter sp.] diamond 1230 169 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Ferruginibacter Ferruginibacter sp.
31148395 31148395 PRJNA326068_P_NODE_1215_length_954_cov_3.841081_g869_i0 PRJNA326068 1215 954 3.841081 36.64391274 Bacteroidota bacterium 1898104 Bacteria Bacteria 91.3 1.33e-19   NR MES2647110.1 1898104 g869 i0 95.5 0.138364779874214 44 2 13.8 0 460 329 4 47 MES2647110.1 hypothetical protein [Bacteroidota bacterium] diamond 132 91.3 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota 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);;