RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1005695" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1005695 · 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
26749148 26749148 PRJNA1005695_P_NODE_18341_length_353_cov_1.328571_g17489_i0 PRJNA1005695 18341 353 1.328571 4.68985563 Anaerolineaceae bacterium 2024896 Bacteria Bacteria 127 8.59e-33   NR MBP7212598.1 2024896 g17489 i0 58.8 2.90651558073654 114 47 96.9 0 353 12 133 246 MBP7212598.1 iron-containing alcohol dehydrogenase [Anaerolineaceae bacterium] diamond 1026 127 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Anaerolineaceae   Anaerolineaceae bacterium
27887245 27887245 PRJNA1005695_P_NODE_26465_length_291_cov_1.422018_g25613_i0 PRJNA1005695 26465 291 1.422018 4.13807238 Chloroflexia bacterium 2448782 Bacteria Bacteria 42.4 0.0259   NR MBA3416150.1 2448782 g25613 i0 40 0.77319587628866 75 40 72.2 2 259 50 7 81 MBA3416150.1 YnfA family protein [Chloroflexia bacterium] diamond 225 42.4 1 Bacteria   Bacillati Chloroflexota Chloroflexia       Chloroflexia bacterium
28076694 28076694 PRJNA1005695_P_NODE_35905_length_250_cov_1.757062_g35053_i0 PRJNA1005695 35905 250 1.757062 4.392655 uncultured Chloroflexi bacterium HF 710736 Bacteria Bacteria 44.3 0.00171   NR ADI17967.1 710736 g35053 i0 53.5 0.516 43 20 51.6 0 225 97 1 43 ADI17967.1 hypothetical protein [uncultured Chloroflexi bacterium HF0200_09I09] diamond 129 44.3 1 Bacteria   Bacillati Chloroflexota         uncultured Chloroflexi bacterium HF0200_09I09
28202865 28202865 PRJNA1005695_P_NODE_41246_length_232_cov_3.062893_g40394_i0 PRJNA1005695 41246 232 3.062893 7.10591176 Anaerolineae bacterium 2052143 Bacteria Bacteria 43.5 0.00287   NR NLT42736.1 2052143 g40394 i0 50 0.543103448275862 42 19 51.7 1 146 27 19 60 NLT42736.1 hypothetical protein [Anaerolineae bacterium] diamond 126 43.5 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
28802726 28802726 PRJNA1005695_P_NODE_13128_length_424_cov_1.760684_g12276_i0 PRJNA1005695 13128 424 1.760684 7.46530016 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 43.9 0.0411   NR HEY8491018.1 2026734 g12276 i0 31.8 0.601415094339623 85 52 56.6 2 19 258 5 88 HEY8491018.1 Hsp20/alpha crystallin family protein [Dehalococcoidia bacterium] diamond 255 43.9 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
30192391 30192391 PRJNA1005695_P_NODE_40952_length_235_cov_2.635802_g40100_i0 PRJNA1005695 40952 235 2.635802 6.1941347 Anaerolineae bacterium 2052143 Bacteria Bacteria 40.4 0.0472   NR NLT42736.1 2052143 g40100 i0 40.4 0.727659574468085 57 25 61.3 2 45 188 4 60 NLT42736.1 hypothetical protein [Anaerolineae bacterium] diamond 171 40.4 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae 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);;