RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA564810", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 3 ✖

tax_kingdom 1

  • Bacillati · 3 ✖

bioproject 1

  • PRJNA564810 · 3 ✖

analysis 1

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
26794524 26794524 PRJNA564810_S_NODE_2881_length_302_cov_2.506329_g2859_i0 PRJNA564810 2881 302 2.506329 7.56911358 Anaerolineales bacterium 2073117 Bacteria Bacteria 73.2 8.96e-13   NR MCC7359436.1 2073117 g2859 i0 43.2 1.45033112582781 74 41 73.5 1 17 238 228 300 MCC7359436.1 patatin-like phospholipase family protein [Anaerolineales bacterium] diamond 438 73.2 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
29794845 29794845 PRJNA564810_S_NODE_1051_length_399_cov_2.721557_g1029_i0 PRJNA564810 1051 399 2.721557 10.85901243 Chloroflexota bacterium 2026724 Bacteria Bacteria 67.8 5.48e-11   NR HZR97695.1 2026724 g1029 i0 49.4 0.609022556390977 81 30 60.2 2 357 118 103 173 HZR97695.1 carboxypeptidase regulatory-like domain-containing protein [Chloroflexota bacterium] diamond 243 67.8 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
30332544 30332544 PRJNA564810_S_NODE_4572_length_261_cov_1.484694_g4550_i0 PRJNA564810 4572 261 1.484694 3.87505134 Dehalococcoidales bacterium 2026733 Bacteria Bacteria 93.6 5.94e-20   NR MBN2238498.1 2026733 g4550 i0 72.4 4.03448275862069 58 16 66.7 0 14 187 586 643 MBN2238498.1 S9 family peptidase [Dehalococcoidales bacterium] diamond 1053 93.6 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia Dehalococcoidales     Dehalococcoidales 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);;