RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1245487" and tax_clade = "Bacteria candidate phyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Bacteria candidate phyla · 6 ✖

bioproject 1

  • PRJNA1245487 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
2901888 2901888 PRJNA1245487_P_NODE_14623_length_296_cov_2.582960_g14285_i0 PRJNA1245487 14623 296 2.58296 7.6455616 Candidatus Dojkabacteria bacterium 2099670 Bacteria Bacteria 189 1.26e-60   NR HRN86952.1 2099670 g14285 i0 100 0.932432432432432 92 0 93.2 0 21 296 1 92 HRN86952.1 hypothetical protein [Candidatus Dojkabacteria bacterium] diamond 276 189 1 Bacteria Bacteria candidate phyla             Candidatus Dojkabacteria bacterium
18202929 18202929 PRJNA1245487_P_NODE_9495_length_390_cov_4.678233_g9157_i0 PRJNA1245487 9495 390 4.678233 18.2451087 Candidatus Dojkabacteria bacterium 2099670 Bacteria Bacteria 171 2.16e-52   NR HRN86953.1 2099670 g9157 i0 98.8 0.653846153846154 85 1 65.4 0 389 135 25 109 HRN86953.1 hypothetical protein [Candidatus Dojkabacteria bacterium] diamond 255 171 1 Bacteria Bacteria candidate phyla             Candidatus Dojkabacteria bacterium
28084195 28084195 PRJNA1245487_P_NODE_19645_length_251_cov_0.876404_g19307_i0 PRJNA1245487 19645 251 0.876404 2.19977404 Patescibacteria group bacterium 2052139 Bacteria Bacteria 45.4 0.00314   NR MDE1946233.1 2052139 g19307 i0 40 1.07569721115538 45 27 53.8 0 241 107 16 60 MDE1946233.1 hypothetical protein [Patescibacteria group bacterium] diamond 270 45.4 1 Bacteria Bacteria candidate phyla             Patescibacteria group bacterium
28936856 28936856 PRJNA1245487_P_NODE_23568_length_199_cov_9.087302_g23230_i0 PRJNA1245487 23568 199 9.087302 18.08373098 Candidatus Methylomirabilota bacterium 2072417 Bacteria Bacteria 42.7 0.00708   NR HEX9819910.1 2072417 g23230 i0 40 1.05527638190955 70 29 93.5 3 9 194 2 66 HEX9819910.1 hypothetical protein [Candidatus Methylomirabilota bacterium] diamond 210 42.7 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota         Candidatus Methylomirabilota bacterium
31622104 31622104 PRJNA1245487_P_NODE_19636_length_251_cov_0.876404_g19298_i0 PRJNA1245487 19636 251 0.876404 2.19977404 Candidatus Binatia bacterium 2838779 Bacteria Bacteria 90.1 5e-19   NR HEX9146665.1 2838779 g19298 i0 72.2 0.645418326693227 54 15 64.5 0 167 6 2 55 HEX9146665.1 alpha/beta fold hydrolase [Candidatus Binatia bacterium] diamond 162 90.1 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia       Candidatus Binatia bacterium
31875100 31875100 PRJNA1245487_P_NODE_18137_length_261_cov_1.244681_g17799_i0 PRJNA1245487 18137 261 1.244681 3.24861741 Minisyncoccota bacterium 2053589 Bacteria Bacteria 125 1.04e-34   NR MDR3570669.1 2053589 g17799 i0 87.5 0.827586206896552 72 9 82.8 0 260 45 42 113 MDR3570669.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 216 125 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota 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);;