RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA436017" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA436017 · 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
20832406 20832406 PRJNA436017_P_NODE_19697_length_184_cov_1.571429_g19399_i0 PRJNA436017 19697 184 1.571429 2.89142936 Bacteria candidate phyla 1783234 Bacteria Bacteria 88.2 1.59e-18   NR KPK11730.1 1703386 g19399 i0 78 33.6847826086956 59 13 96.2 0 179 3 110 168 KPK11730.1 MAG: molecular chaperone DnaK [Anaerolineae bacterium SG8_19] diamond 6198 89 0.991011235955056 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium SG8_19
27250304 27250304 PRJNA436017_P_NODE_2903_length_550_cov_2.764133_g2631_i0 PRJNA436017 2903 550 2.764133 15.2027315 Flexilinea 1769713 Bacteria Bacteria 109 2.63e-24   NR MBQ6504680.1 2017390 g2631 i0 39.6 5.31272727272727 139 81 75.3 2 112 525 273 409 MBQ6504680.1 transporter substrate-binding domain-containing protein [Flexilinea sp.] diamond 2922 109 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Anaerolineaceae Flexilinea Flexilinea sp.
28528767 28528767 PRJNA436017_P_NODE_6907_length_339_cov_2.304636_g6610_i0 PRJNA436017 6907 339 2.304636 7.81271604 Chloroflexota bacterium 2026724 Bacteria Bacteria 134 1.18e-34   NR NOZ29649.1 2026724 g6610 i0 63.6 3.08849557522124 88 32 77.9 0 75 338 20 107 NOZ29649.1 NADP-dependent isocitrate dehydrogenase [Chloroflexota bacterium] diamond 1047 134 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
28829036 28829036 PRJNA436017_P_NODE_7788_length_317_cov_2.364286_g7491_i0 PRJNA436017 7788 317 2.364286 7.49478662 Bacteria 2 Bacteria Bacteria 53.5 2.19e-6   NR UCB43368.1 2026733 g7491 i0 39.7 1.38170347003155 73 44 69.1 0 4 222 6 78 UCB43368.1 MAG: prepilin-type N-terminal cleavage/methylation domain-containing protein [Dehalococcoidales bacterium] diamond 438 53.5 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia Dehalococcoidales     Dehalococcoidales bacterium
31212830 31212830 PRJNA436017_P_NODE_23075_length_170_cov_1.172932_g22777_i0 PRJNA436017 23075 170 1.172932 1.9939844 Chloroflexota bacterium 2026724 Bacteria Bacteria 87.8 4.58e-19   NR MER3457687.1 2026724 g22777 i0 73.2 2.96470588235294 56 15 98.8 0 2 169 196 251 MER3457687.1 elongation factor Tu [Chloroflexota bacterium] diamond 504 87.8 1 Bacteria   Bacillati Chloroflexota         Chloroflexota 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);;