RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB39269" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB39269 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
3883167 3883167 PRJEB39269_P_NODE_12124_length_402_cov_1.206612_g11719_i0 PRJEB39269 12124 402 1.206612 4.85058024 Bacteria 2 Bacteria Bacteria 154 6.26e-44   NR HEX9785044.1 2006848 g11719 i0 73.2 2.8955223880597 97 25 72.4 1 401 111 169 264 HEX9785044.1 DUF1080 domain-containing protein [Opitutaceae bacterium] diamond 1164 154 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
26748016 26748016 PRJEB39269_P_NODE_41141_length_214_cov_1.657143_g40736_i0 PRJEB39269 41141 214 1.657143 3.54628602 Chthoniobacterales bacterium 2201154 Bacteria Bacteria 94.7 1.28e-20   NR HET9374130.1 2201154 g40736 i0 58 0.967289719626168 69 29 96.7 0 208 2 155 223 HET9374130.1 two-component regulator propeller domain-containing protein [Chthoniobacterales bacterium] diamond 207 94.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales     Chthoniobacterales bacterium
27570440 27570440 PRJEB39269_P_NODE_87124_length_153_cov_1.649123_g86719_i0 PRJEB39269 87124 153 1.649123 2.52315819 Opitutaceae bacterium 2006848 Bacteria Bacteria 43.1 0.00794   NR HEX9783952.1 2006848 g86719 i0 48.9 0.882352941176471 45 23 88.2 0 8 142 704 748 HEX9783952.1 TonB-dependent receptor [Opitutaceae bacterium] diamond 135 43.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
27879651 27879651 PRJEB39269_P_NODE_49165_length_196_cov_1.044586_g48760_i0 PRJEB39269 49165 196 1.044586 2.04738856 Bacteria 2 Bacteria Bacteria 122 2.9499999999999997e-32   NR MBV8413705.1 2026799 g48760 i0 84.6 3.97959183673469 65 10 99.5 0 1 195 169 233 MBV8413705.1 5-deoxy-glucuronate isomerase [Verrucomicrobiota bacterium] diamond 780 122 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28549479 28549479 PRJEB39269_P_NODE_82147_length_157_cov_1.525424_g81742_i0 PRJEB39269 82147 157 1.525424 2.39491568 Candidatus Udaeobacter sp. 2665650 Bacteria Bacteria 86.3 5.35e-18   NR HEV3098604.1 2665650 g81742 i0 80.4 0.974522292993631 51 10 97.5 0 1 153 777 827 HEV3098604.1 CusA/CzcA family heavy metal efflux RND transporter [Candidatus Udaeobacter sp.] diamond 153 86.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales Chthoniobacteraceae Candidatus Udaeobacter Candidatus Udaeobacter sp.
29622334 29622334 PRJEB39269_P_NODE_68710_length_169_cov_2.784615_g68305_i0 PRJEB39269 68710 169 2.784615 4.70599935 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 80.1 8.94e-16   NR MBI5691970.1 2026799 g68305 i0 74.1 1.02958579881657 58 12 97.6 1 3 167 15 72 MBI5691970.1 NADP-dependent isocitrate dehydrogenase [Verrucomicrobiota bacterium] diamond 174 80.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota 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);;