RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJEB58983" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJEB58983 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
20525666 20525666 PRJEB58983_P_NODE_15617_length_324_cov_1.342629_g15202_i0 PRJEB58983 15617 324 1.342629 4.35011796 Dehalococcoidales bacterium 2026733 Bacteria Bacteria 154 1.19e-45   NR MDO9333994.1 2026733 g15202 i0 95.2 0.768518518518518 83 3 75.9 1 323 78 57 139 MDO9333994.1 30S ribosomal protein S4 [Dehalococcoidales bacterium] diamond 249 154 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia Dehalococcoidales     Dehalococcoidales bacterium
27760515 27760515 PRJEB58983_P_NODE_8784_length_420_cov_1.631124_g8370_i0 PRJEB58983 8784 420 1.631124 6.8507208 Caldilinea sp. CFX5 2293554 Bacteria Bacteria 211 4.63e-65   NR MCE7987951.1 2293554 g8370 i0 77 0.992857142857143 139 31 99.3 1 418 2 60 197 MCE7987951.1 hypothetical protein [Caldilinea sp. CFX5] diamond 417 211 1 Bacteria   Bacillati Chloroflexota Caldilineae Caldilineales Caldilineaceae Caldilinea Caldilinea sp. CFX5
27886429 27886429 PRJEB58983_P_NODE_29365_length_249_cov_1.346591_g28950_i0 PRJEB58983 29365 249 1.346591 3.35301159 Caldilineaceae bacterium 2614250 Bacteria Bacteria 50.1 2.83e-5   NR MEZ4678006.1 2614250 g28950 i0 78.1 0.385542168674699 32 7 38.6 0 247 152 39 70 MEZ4678006.1 hypothetical protein [Caldilineaceae bacterium] diamond 96 50.1 1 Bacteria   Bacillati Chloroflexota Caldilineae Caldilineales Caldilineaceae   Caldilineaceae bacterium
28012963 28012963 PRJEB58983_P_NODE_30925_length_245_cov_1.831395_g30510_i0 PRJEB58983 30925 245 1.831395 4.48691775 Anaerolineae bacterium 2052143 Bacteria Bacteria 132 7.38e-38   NR MCW1968700.1 2052143 g30510 i0 74.1 0.991836734693878 81 21 99.2 0 2 244 4 84 MCW1968700.1 DUF4288 domain-containing protein [Anaerolineae bacterium] diamond 243 132 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
29370555 29370555 PRJEB58983_P_NODE_5509_length_523_cov_3.444444_g5096_i0 PRJEB58983 5509 523 3.444444 18.014442119999998 Anaerolineae bacterium 2052143 Bacteria Bacteria 139 1.55e-38   NR HUM36519.1 2052143 g5096 i0 66.7 0.636711281070746 111 37 63.7 0 1 333 37 147 HUM36519.1 hypothetical protein [Anaerolineae bacterium] diamond 333 139 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
30255077 30255077 PRJEB58983_P_NODE_31852_length_243_cov_1.794118_g31437_i0 PRJEB58983 31852 243 1.794118 4.35970674 Dictyobacter arantiisoli 2014874 Bacteria Bacteria 65.9 2.08e-10   NR WP_149401520.1 2014874 g31437 i0 44 0.925925925925926 75 42 92.6 0 230 6 61 135 WP_149401520.1 serine/threonine protein kinase [Dictyobacter arantiisoli] diamond 225 65.9 1 Bacteria   Bacillati Chloroflexota Ktedonobacteria Ktedonobacterales Dictyobacteraceae Dictyobacter Dictyobacter arantiisoli
31993406 31993406 PRJEB58983_P_NODE_35398_length_205_cov_4.075758_g34983_i0 PRJEB58983 35398 205 4.075758 8.3553039 Anaerolineae bacterium 2052143 Bacteria Bacteria 114 1.42e-28   NR MBL8120523.1 2052143 g34983 i0 94.1 2.98536585365854 68 4 99.5 0 2 205 232 299 MBL8120523.1 permease [Anaerolineae bacterium] diamond 612 114 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);;