RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax_phylum = "Candidatus Binatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Binatota · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA630162 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
2426731 2426731 PRJNA630162_P_NODE_51602_length_245_cov_3.142857_g50079_i0 PRJNA630162 51602 245 3.142857 7.69999965 Bacteria 2 Bacteria Bacteria 270 5.609999999999999e-68   NTclustered gi|2575803556|emb|OY729432.1| 2838779 g50079 i0 90.686 154.612244897959 204 17 82 2 23 224 2239348 2239551 MAG: Candidatus Binatia bacterium isolate b65fbbe8-1638-4b94-9072-1473f084fbf4 genome assembly, chromosome: 1 blastn 37880 270 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia       Candidatus Binatia bacterium
3152445 3152445 PRJNA630162_P_NODE_123663_length_172_cov_2.682927_g122140_i0 PRJNA630162 123663 172 2.682927 4.61463444 uncultured Candidatus Binatia bacterium 3036252 Bacteria Bacteria 185 1.3599999999999999e-42   NTclustered gi|2546137839|emb|OY282432.1| 3036252 g122140 i0 86.592 289.005813953488 179 10 97 9 7 172 2261596 2261773 MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1 blastn 49709 185 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia       uncultured Candidatus Binatia bacterium
8255907 8255907 PRJNA630162_P_NODE_86067_length_195_cov_1.534247_g84544_i0 PRJNA630162 86067 195 1.534247 2.99178165 uncultured Candidatus Binatia bacterium 3036252 Bacteria Bacteria 206 1.22e-48   NTclustered gi|2891481979|emb|OZ219754.1| 3036252 g84544 i0 90.85 49.6717948717949 153 14 78 0 7 159 2069157 2069005 MAG: uncultured Candidatus Binatia bacterium isolate 58a26a4a-5c73-4e1d-804e-87f8126ae6b7 genome assembly, chromosome: 1 blastn 9686 206 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia       uncultured Candidatus Binatia bacterium
12082280 12082280 PRJNA630162_P_NODE_97070_length_187_cov_2.231884_g95547_i0 PRJNA630162 97070 187 2.231884 4.17362308 uncultured Candidatus Binatia bacterium 3036252 Bacteria Bacteria 289 1.1199999999999998e-73   NTclustered gi|2546137839|emb|OY282432.1| 3036252 g95547 i0 94.624 152.909090909091 186 10 99 0 1 186 2261770 2261955 MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1 blastn 28594 289 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia       uncultured Candidatus Binatia bacterium
21004387 21004387 PRJNA630162_P_NODE_170797_length_153_cov_3.894231_g169274_i0 PRJNA630162 170797 153 3.894231 5.95817343 uncultured Candidatus Binatia bacterium 3036252 Bacteria Bacteria 191 2.55e-44   NTclustered gi|2891481979|emb|OZ219754.1| 3036252 g169274 i0 90.476 278.660130718954 147 10 95 3 2 146 2070456 2070312 MAG: uncultured Candidatus Binatia bacterium isolate 58a26a4a-5c73-4e1d-804e-87f8126ae6b7 genome assembly, chromosome: 1 blastn 42635 191 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia       uncultured Candidatus Binatia 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);;