RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA1148190", tax_clade = "ac1 cluster" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Bacillati · 8 ✖

tax_clade 1

  • ac1 cluster · 8 ✖

bioproject 1

  • PRJNA1148190 · 8 ✖

analysis 1

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
26647896 26647896 PRJNA1148190_P_NODE_578341_length_251_cov_2.342697_g567168_i0 PRJNA1148190 578341 251 2.342697 5.88016947 Bacteria 2 Bacteria Bacteria 160 8.54e-45   NR KRO31004.1 1655568 g567168 i0 90.4 8.92828685258964 83 8 99.2 0 2 250 14 96 KRO31004.1 MAG: glucose-6-phosphate isomerase [Actinobacteria bacterium BACL2 MAG-120802-bin41] diamond 2241 160 1 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL2 MAG-120802-bin41
27059652 27059652 PRJNA1148190_P_NODE_665902_length_247_cov_0.885057_g654729_i0 PRJNA1148190 665902 247 0.885057 2.18609079 Bacteria 2 Bacteria Bacteria 119 4.779999999999999e-32   NR KRO36333.1 1655562 g654729 i0 87.5 1.74898785425101 72 9 87.4 0 3 218 99 170 KRO36333.1 MAG: hypothetical protein ABR54_04630 [Actinobacteria bacterium BACL15 MAG-120619-bin91] diamond 432 119 1 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL15 MAG-120619-bin91
27217376 27217376 PRJNA1148190_P_NODE_461722_length_274_cov_1.373134_g450549_i0 PRJNA1148190 461722 274 1.373134 3.76238716 Bacteria 2 Bacteria Bacteria 172 1.68e-50   NR KRO32910.1 1655573 g450549 i0 98.9 1.99270072992701 91 1 99.6 0 274 2 224 314 KRO32910.1 MAG: helicase, partial [Actinobacteria bacterium BACL2 MAG-121220-bin52] diamond 546 172 1 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL2 MAG-121220-bin52
27754887 27754887 PRJNA1148190_P_NODE_694244_length_245_cov_1.790698_g683071_i0 PRJNA1148190 694244 245 1.790698 4.3872101 Bacteria 2 Bacteria Bacteria 163 4.07e-49   NR KRO31622.1 1655572 g683071 i0 100 5.95102040816327 81 0 99.2 0 243 1 54 134 KRO31622.1 MAG: thymidylate kinase [Actinobacteria bacterium BACL2 MAG-121001-bin67] diamond 1458 163 1 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL2 MAG-121001-bin67
29660501 29660501 PRJNA1148190_P_NODE_619490_length_249_cov_1.380682_g608317_i0 PRJNA1148190 619490 249 1.380682 3.43789818 Actinobacteria bacterium BACL2 MAG-12 2900548 Bacteria Bacteria 164 7.5e-49   NR KRO30988.1 1655568 g608317 i0 97.6 1.97590361445783 82 2 98.8 0 3 248 77 158 KRO30988.1 MAG: ubiquinone biosynthesis methyltransferase UbiE [Actinobacteria bacterium BACL2 MAG-120802-bin41] diamond 492 164 1 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL2 MAG-120802-bin41
30577033 30577033 PRJNA1148190_P_NODE_749993_length_243_cov_0.905882_g738820_i0 PRJNA1148190 749993 243 0.905882 2.20129326 Actinobacteria bacterium BACL2 MAG-12 2900548 Bacteria Bacteria 161 1.6099999999999998e-45   NR KRO51452.1 1655570 g738820 i0 100 6.91358024691358 80 0 98.8 0 3 242 156 235 KRO51452.1 MAG: helicase, partial [Actinobacteria bacterium BACL2 MAG-120820-bin50] diamond 1680 161 1 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL2 MAG-120820-bin50
31367602 31367602 PRJNA1148190_P_NODE_785076_length_241_cov_0.916667_g773903_i0 PRJNA1148190 785076 241 0.916667 2.20916747 Actinobacteria bacterium BACL15 MAG-12 2900548 Bacteria Bacteria 154 1e-45   NR KRO34440.1 1655562 g773903 i0 96.3 1.99170124481328 80 3 99.6 0 1 240 96 175 KRO34440.1 MAG: hypothetical protein ABR54_02145, partial [Actinobacteria bacterium BACL15 MAG-120619-bin91] diamond 480 154 1 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL15 MAG-120619-bin91
32840699 32840699 PRJNA1148190_P_NODE_722660_length_244_cov_0.900585_g711487_i0 PRJNA1148190 722660 244 0.900585 2.1974274 Bacteria 2 Bacteria Bacteria 144 9.71e-38   NR KRO31092.1 1655568 g711487 i0 97.5 8.74180327868852 79 2 97.1 0 242 6 168 246 KRO31092.1 MAG: methionine synthase [Actinobacteria bacterium BACL2 MAG-120802-bin41] diamond 2133 144 1 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL2 MAG-120802-bin41

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);;