RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJEB11523" and tax_phylum = "Candidatus Zambryskiibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Zambryskiibacteriota · 3 ✖

tax_clade 1

bioproject 1

  • PRJEB11523 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
29401147 29401147 PRJEB11523_P_NODE_4049_length_238_cov_3.301587_g3971_i0 PRJEB11523 4049 238 3.301587 7.85777706 Candidatus Zambryskiibacteriota bacterium 2053652 Bacteria Bacteria 115 2.95e-29   NR MCX6701617.1 2053652 g3971 i0 84.4 3.22689075630252 64 10 80.7 0 193 2 2 65 MCX6701617.1 tRNA (adenosine(37)-N6)-dimethylallyltransferase MiaA [Candidatus Zambryskiibacteriota bacterium] diamond 768 115 1 Bacteria Bacteria candidate phyla   Candidatus Zambryskiibacteriota         Candidatus Zambryskiibacteriota bacterium
31771072 31771072 PRJEB11523_P_NODE_1937_length_393_cov_2.229651_g1859_i0 PRJEB11523 1937 393 2.229651 8.76252843 Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_ 2053652 Bacteria Bacteria 159 3.18e-42   NR OHA93798.1 1802742 g1859 i0 62.3 0.931297709923664 122 46 93.1 0 4 369 51 172 OHA93798.1 MAG: hypothetical protein A2W58_01415 [Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_02_38_10.5] diamond 366 159 1 Bacteria Bacteria candidate phyla   Candidatus Zambryskiibacteriota         Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_02_38_10.5
32751081 32751081 PRJEB11523_P_NODE_3440_length_265_cov_2.796296_g3362_i0 PRJEB11523 3440 265 2.796296 7.4101844 Candidatus Zambryskiibacteriota bacterium 2053652 Bacteria Bacteria 88.6 6.04e-20   NR MCX6701974.1 2053652 g3362 i0 68.9 0.690566037735849 61 19 69.1 0 2 184 100 160 MCX6701974.1 hypothetical protein [Candidatus Zambryskiibacteriota bacterium] diamond 183 88.6 1 Bacteria Bacteria candidate phyla   Candidatus Zambryskiibacteriota         Candidatus Zambryskiibacteriota 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);;