RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1139127", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 4 ✖

tax_kingdom 1

  • Bacillati · 4 ✖

bioproject 1

  • PRJNA1139127 · 4 ✖

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
27355041 27355041 PRJNA1139127_P_NODE_26663_length_347_cov_1.167883_g26171_i0 PRJNA1139127 26663 347 1.167883 4.05255401 Anaerolineae bacterium 2052143 Bacteria Bacteria 118 3.12e-28   NR MBN1964023.1 2052143 g26171 i0 67.9 0.70028818443804 81 26 70 0 12 254 355 435 MBN1964023.1 hypothetical protein [Anaerolineae bacterium] diamond 243 118 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
27512838 27512838 PRJNA1139127_P_NODE_48223_length_243_cov_0.917647_g47730_i0 PRJNA1139127 48223 243 0.917647 2.22988221 Anaerolineae bacterium 2052143 Bacteria Bacteria 144 7.92e-39   NR MBA3871063.1 2052143 g47730 i0 90.1 1 81 6 97.5 1 7 243 362 442 MBA3871063.1 2-oxo acid dehydrogenase subunit E2 [Anaerolineae bacterium] diamond 243 144 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
30027992 30027992 PRJNA1139127_P_NODE_41791_length_253_cov_1.700000_g41298_i0 PRJNA1139127 41791 253 1.7 4.301 Caldilinea 233191 Bacteria Bacteria 139 4.71e-36   NR WP_343402601.1 2293560 g41298 i0 76.5 2.88142292490119 81 19 96 0 252 10 655 735 WP_343402601.1 glycosyltransferase family 39 protein [Caldilinea sp.] diamond 729 140 0.992857142857143 Bacteria   Bacillati Chloroflexota Caldilineae Caldilineales Caldilineaceae Caldilinea Caldilinea sp.
32315371 32315371 PRJNA1139127_P_NODE_44479_length_249_cov_0.875000_g43986_i0 PRJNA1139127 44479 249 0.875 2.17875 Chloroflexota bacterium 2026724 Bacteria Bacteria 42.4 0.033   NR MFM2309540.1 2026724 g43986 i0 42.6 0.650602409638554 54 27 65.1 1 220 59 70 119 MFM2309540.1 hypothetical protein [Chloroflexota bacterium] diamond 162 42.4 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);;