RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJEB20058" and tax_phylum = "Candidatus Microgenomatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Microgenomatota · 6 ✖

tax_clade 1

bioproject 1

  • PRJEB20058 · 6 ✖

analysis 1

tax_kingdom 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
32945068 32945068 PRJEB20058_P_NODE_17442_length_990_cov_46.815931_g15479_i0 PRJEB20058 17442 990 46.815931 463.4777169 Candidatus Microgenomates bacterium 2093373 Bacteria Bacteria 296 2.9999999999999997e-97   NR NMC09097.1 2093373 g15479 i0 96.6 0.448484848484848 148 5 44.8 0 943 500 54 201 NMC09097.1 sortase [Candidatus Microgenomates bacterium] diamond 444 296 1 Bacteria Bacteria candidate phyla   Candidatus Microgenomatota         Candidatus Microgenomates bacterium
32945142 32945142 PRJEB20058_P_NODE_187050_length_268_cov_2.898551_g184227_i0 PRJEB20058 187050 268 2.898551 7.76811668 Candidatus Microgenomates bacterium CPR3 2293638 Bacteria Bacteria 135 1.02e-36   NR MCE7897914.1 2293638 g184227 i0 73.5 0.92910447761194 83 22 92.9 0 3 251 196 278 MCE7897914.1 hypothetical protein [Candidatus Microgenomates bacterium CPR3] diamond 249 135 1 Bacteria Bacteria candidate phyla   Candidatus Microgenomatota         Candidatus Microgenomates bacterium CPR3
32996118 32996118 PRJEB20058_P_NODE_148563_length_316_cov_1.200000_g145741_i0 PRJEB20058 148563 316 1.2 3.792 Candidatus Microgenomates bacterium 2093373 Bacteria Bacteria 161 2.9e-46   NR NMC09040.1 2093373 g145741 i0 100 0.721518987341772 76 0 72.2 0 315 88 266 341 NMC09040.1 tRNA guanosine(34) transglycosylase Tgt [Candidatus Microgenomates bacterium] diamond 228 161 1 Bacteria Bacteria candidate phyla   Candidatus Microgenomatota         Candidatus Microgenomates bacterium
33099378 33099378 PRJEB20058_P_NODE_82966_length_453_cov_496.109694_g80182_i0 PRJEB20058 82966 453 496.109694 2247.37691382 Candidatus Microgenomates bacterium 2093373 Bacteria Bacteria 121 1.23e-28   NR NMC09063.1 2093373 g80182 i0 79.7 0.52317880794702 79 16 52.3 0 193 429 58 136 NMC09063.1 hypothetical protein [Candidatus Microgenomates bacterium] diamond 237 121 1 Bacteria Bacteria candidate phyla   Candidatus Microgenomatota         Candidatus Microgenomates bacterium
33116355 33116355 PRJEB20058_P_NODE_73255_length_486_cov_3.352941_g70479_i0 PRJEB20058 73255 486 3.352941 16.29529326 Candidatus Microgenomates bacterium CPR3 2293638 Bacteria Bacteria 170 2.75e-49   NR MCE7897914.1 2293638 g70479 i0 73.3 0.716049382716049 116 31 71.6 0 472 125 176 291 MCE7897914.1 hypothetical protein [Candidatus Microgenomates bacterium CPR3] diamond 348 170 1 Bacteria Bacteria candidate phyla   Candidatus Microgenomatota         Candidatus Microgenomates bacterium CPR3
33133519 33133519 PRJEB20058_P_NODE_72079_length_490_cov_7.317016_g69304_i0 PRJEB20058 72079 490 7.317016 35.8533784 Candidatus Microgenomates bacterium 2093373 Bacteria Bacteria 301 1.5199999999999996e-96   NR NMC09211.1 2093373 g69304 i0 98.1 0.96734693877551 158 3 96.7 0 481 8 288 445 NMC09211.1 penicillin-binding protein 2 [Candidatus Microgenomates bacterium] diamond 474 301 1 Bacteria Bacteria candidate phyla   Candidatus Microgenomatota         Candidatus Microgenomates 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);;