RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA287283" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA287283 · 7 ✖

analysis 1

  • diamond · 7 ✖

tax_clade 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
26821163 26821163 PRJNA287283_P_NODE_8441_length_183_cov_0.861538_g8217_i0 PRJNA287283 8441 183 0.861538 1.57661454 Rhodococcus sp. EPR-157 1813677 Bacteria Bacteria 120 4.03e-32   NR WP_068367966.1 1813677 g8217 i0 98.4 3 61 1 100 0 183 1 24 84 WP_068367966.1 HpcH/HpaI aldolase/citrate lyase family protein, partial [Rhodococcus sp. EPR-157] diamond 549 120 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Rhodococcus Rhodococcus sp. EPR-157
27390386 27390386 PRJNA287283_P_NODE_10403_length_175_cov_0.918033_g10179_i0 PRJNA287283 10403 175 0.918033 1.60655775 Lawsonella 1847725 Bacteria Bacteria 113 5.62e-28   NR WP_290598508.1 1847725 g10179 i0 100 0.977142857142857 57 0 97.7 0 173 3 19 75 WP_290598508.1 MULTISPECIES: MinD/ParA family ATP-binding protein [Lawsonella] diamond 171 113 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella  
28260188 28260188 PRJNA287283_P_NODE_7666_length_195_cov_0.964789_g7442_i0 PRJNA287283 7666 195 0.964789 1.88133855 root 1 Root_unresolved Root_unresolved 40.4 0.0348   NR WP_146844862.1 311234 g7442 i0 50 1.38461538461538 38 19 58.5 0 23 136 30 67 WP_146844862.1 hypothetical protein [Cellulomonas terrae] diamond 270 40.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Cellulomonadaceae Cellulomonas Cellulomonas terrae
29821181 29821181 PRJNA287283_P_NODE_9891_length_177_cov_0.903226_g9667_i0 PRJNA287283 9891 177 0.903226 1.59871002 Sediminivirga luteola 1774748 Bacteria Bacteria 87.4 1.99e-18   NR WP_229745146.1 1774748 g9667 i0 75 0.949152542372881 56 14 94.9 0 9 176 211 266 WP_229745146.1 exonuclease domain-containing protein [Sediminivirga luteola] diamond 168 87.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Brevibacteriaceae Sediminivirga Sediminivirga luteola
30471125 30471125 PRJNA287283_P_NODE_5273_length_260_cov_0.864734_g5049_i0 PRJNA287283 5273 260 0.864734 2.2483084 PVC group 1783257 Bacteria Bacteria 42.7 0.0236   NR WP_376810015.1 1337874 g5049 i0 44.1 0.992307692307692 59 26 66.9 3 67 240 62 114 WP_376810015.1 hypothetical protein [Catellatospora aurea] diamond 258 43.1 0.990719257540603 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Catellatospora Catellatospora aurea
31907434 31907434 PRJNA287283_P_NODE_4797_length_279_cov_1.451327_g4573_i0 PRJNA287283 4797 279 1.451327 4.04920233 Salinibacterium hongtaonis 2079791 Bacteria Bacteria 43.5 0.0295   NR WP_108518238.1 2079791 g4573 i0 51.1 0.483870967741935 45 20 46.2 2 187 59 205 249 WP_108518238.1 MmgE/PrpD family protein [Salinibacterium hongtaonis] diamond 135 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Homoserinimonas Homoserinimonas hongtaonis
32097257 32097257 PRJNA287283_P_NODE_9138_length_180_cov_0.881890_g8914_i0 PRJNA287283 9138 180 0.88189 1.587402 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 42 0.03   NR HZJ48322.1 2080302 g8914 i0 41.2 0.85 51 21 70 1 48 173 335 385 HZJ48322.1 isoamylase [Acidimicrobiia bacterium] diamond 153 42 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia 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);;