RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA725806" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 6 ✖

bioproject 1

  • PRJNA725806 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27589507 27589507 PRJNA725806_P_NODE_103224_length_195_cov_2.481013_g102922_i0 PRJNA725806 103224 195 2.481013 4.83797535 Deinococcus altitudinis 468914 Bacteria Bacteria 72.8 4.9e-13   NR WP_407568778.1 468914 g102922 i0 61.4 2.6 57 22 87.7 0 3 173 270 326 WP_407568778.1 PRC-barrel domain-containing protein [Deinococcus altitudinis] diamond 507 72.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus altitudinis
28599895 28599895 PRJNA725806_P_NODE_138727_length_174_cov_2.649635_g138425_i0 PRJNA725806 138727 174 2.649635 4.6103649 Deinococcus antarcticus 1298767 Bacteria Bacteria 115 2.05e-28   NR WP_380079338.1 1298767 g138425 i0 100 0.982758620689655 57 0 98.3 0 2 172 52 108 WP_380079338.1 sensor histidine kinase [Deinococcus antarcticus] diamond 171 115 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
31252935 31252935 PRJNA725806_P_NODE_184835_length_154_cov_1.931624_g184533_i0 PRJNA725806 184835 154 1.931624 2.97470096 Deinococcus cavernae 2320857 Bacteria Bacteria 99.8 2.8e-25   NR WP_119763139.1 2320857 g184533 i0 88 2.96103896103896 50 6 97.4 0 154 5 13 62 WP_119763139.1 IS200/IS605 family transposase [Deinococcus cavernae] diamond 456 99.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus cavernae
31316212 31316212 PRJNA725806_P_NODE_24895_length_301_cov_2.037879_g24598_i0 PRJNA725806 24895 301 2.037879 6.13401579 Deinococcus 1298 Bacteria Bacteria 190 3.4799999999999996e-56   NR WP_135230441.1 1298 g24598 i0 100 0.926910299003322 93 0 92.7 0 1 279 230 322 WP_135230441.1 MULTISPECIES: apolipoprotein N-acyltransferase [Deinococcus] diamond 279 190 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus  
31980402 31980402 PRJNA725806_P_NODE_38198_length_269_cov_2.245690_g37901_i0 PRJNA725806 38198 269 2.24569 6.0409061 uncultured Meiothermus sp. 157471 Bacteria Bacteria 43.5 0.018   NR WP_299430388.1 157471 g37901 i0 38.6 0.95910780669145 44 27 49.1 0 132 1 71 114 WP_299430388.1 YIP1 family protein [uncultured Meiothermus sp.] diamond 258 43.5 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus uncultured Meiothermus sp.
32043746 32043746 PRJNA725806_P_NODE_143398_length_172_cov_1.259259_g143096_i0 PRJNA725806 143398 172 1.259259 2.16592548 Deinococcus altitudinis 468914 Bacteria Bacteria 74.3 1.04e-13   NR WP_407572892.1 468914 g143096 i0 68.4 0.994186046511628 57 18 99.4 0 1 171 221 277 WP_407572892.1 PRC-barrel domain-containing protein [Deinococcus altitudinis] diamond 171 74.3 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus altitudinis

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