RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1047321" 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

  • PRJNA1047321 · 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
1009803 1009803 PRJNA1047321_P_NODE_8181_length_243_cov_0.905882_g8010_i0 PRJNA1047321 8181 243 0.905882 2.20129326 Chloroflexota bacterium 2026724 Bacteria Bacteria 126 1.84e-32   NR MDQ3656562.1 2026724 g8010 i0 70.4 1 81 24 100 0 243 1 166 246 MDQ3656562.1 alkaline phosphatase D family protein [Chloroflexota bacterium] diamond 243 126 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
5277262 5277262 PRJNA1047321_P_NODE_7905_length_245_cov_0.866279_g7734_i0 PRJNA1047321 7905 245 0.866279 2.12238355 Chloroflexia bacterium SDU3-3 2651839 Bacteria Bacteria 156 4.8499999999999995e-45   NR KAB8140233.1 2651839 g7734 i0 91.4 0.991836734693878 81 7 99.2 0 245 3 29 109 KAB8140233.1 ABC transporter ATP-binding protein [Chloroflexia bacterium SDU3-3] diamond 243 156 1 Bacteria   Bacillati Chloroflexota Chloroflexia       Chloroflexia bacterium SDU3-3
26749958 26749958 PRJNA1047321_P_NODE_6401_length_252_cov_1.156425_g6230_i0 PRJNA1047321 6401 252 1.156425 2.914191 Chloroflexota bacterium 2026724 Bacteria Bacteria 58.9 8.31e-8   NR MBI2780836.1 2026724 g6230 i0 70.5 1.04761904761905 44 13 52.4 0 250 119 1086 1129 MBI2780836.1 AAA family ATPase [Chloroflexota bacterium] diamond 264 58.9 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
26940194 26940194 PRJNA1047321_P_NODE_7682_length_246_cov_0.890173_g7511_i0 PRJNA1047321 7682 246 0.890173 2.18982558 Thermoflexus sp. 1969742 Bacteria Bacteria 119 6.02e-29   NR MBO9362732.1 1969742 g7511 i0 72.2 4.86585365853659 79 22 96.3 0 9 245 757 835 MBO9362732.1 DUF1998 domain-containing protein [Thermoflexus sp.] diamond 1197 119 1 Bacteria   Bacillati Chloroflexota Thermoflexia Thermoflexales Thermoflexaceae Thermoflexus Thermoflexus sp.
30406689 30406689 PRJNA1047321_P_NODE_7893_length_245_cov_0.895349_g7722_i0 PRJNA1047321 7893 245 0.895349 2.19360505 Bacteria 2 Bacteria Bacteria 113 2.25e-28   NR HEY7702898.1 2952938 g7722 i0 70.9 4.83673469387755 79 23 96.7 0 237 1 25 103 HEY7702898.1 FAD binding domain-containing protein [Candidatus Limnocylindrales bacterium] diamond 1185 114 0.991228070175439 Bacteria   Bacillati Chloroflexota Candidatus Limnocylindria Candidatus Limnocylindrales     Candidatus Limnocylindrales bacterium
32784912 32784912 PRJNA1047321_P_NODE_7660_length_246_cov_0.890173_g7489_i0 PRJNA1047321 7660 246 0.890173 2.18982558 Aggregatilineales bacterium 2952883 Bacteria Bacteria 165 1.29e-47   NR HOA24177.1 2952883 g7489 i0 100 1.97560975609756 81 0 98.8 0 244 2 176 256 HOA24177.1 glycosyltransferase family 1 protein [Aggregatilineales bacterium] diamond 486 165 1 Bacteria   Bacillati Chloroflexota Anaerolineae Aggregatilineales     Aggregatilineales 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);;