RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB65099" 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 · 4 ✖

bioproject 1

  • PRJEB65099 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
8646958 8646958 PRJEB65099_P_NODE_6487_length_244_cov_0.912281_g6382_i0 PRJEB65099 6487 244 0.912281 2.22596564 Candidatus Parcubacteria bacterium 2762014 Bacteria Bacteria 122 2.24e-33   NR MCX6740316.1 2762014 g6382 i0 80 3.44262295081967 70 14 86.1 0 33 242 78 147 MCX6740316.1 peptide-methionine (S)-S-oxide reductase MsrA [Candidatus Parcubacteria bacterium] diamond 840 122 1 Bacteria Bacteria candidate phyla   Candidatus Parcubacteria         Candidatus Parcubacteria bacterium
27097059 27097059 PRJEB65099_P_NODE_4562_length_262_cov_1.507937_g4457_i0 PRJEB65099 4562 262 1.507937 3.95079494 Candidatus Levyibacteriota bacterium 2052151 Bacteria Bacteria 67.4 2.72e-11   NR MBI2074652.1 2052151 g4457 i0 62.8 1.96946564885496 43 16 49.2 0 130 2 1 43 MBI2074652.1 transposase [Candidatus Levyibacteriota bacterium] diamond 516 67.4 1 Bacteria Bacteria candidate phyla   Candidatus Levyibacteriota         Candidatus Levyibacteriota bacterium
28233807 28233807 PRJEB65099_P_NODE_2166_length_401_cov_1.015244_g2061_i0 PRJEB65099 2166 401 1.015244 4.07112844 Candidatus Methylomirabilota bacterium 2072417 Bacteria Bacteria 45.4 0.0224   NR HET7343429.1 2072417 g2061 i0 37.2 0.845386533665835 113 56 76.3 5 368 63 380 488 HET7343429.1 tetratricopeptide repeat protein [Candidatus Methylomirabilota bacterium] diamond 339 45.4 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota         Candidatus Methylomirabilota bacterium
29433610 29433610 PRJEB65099_P_NODE_5150_length_252_cov_0.871508_g5045_i0 PRJEB65099 5150 252 0.871508 2.19620016 Candidatus Saccharimonadales bacterium 2973664 Bacteria Bacteria 93.6 2.43e-22   NR MFI5212538.1 2973664 g5045 i0 84.6 0.619047619047619 52 8 61.9 0 1 156 76 127 MFI5212538.1 metallopeptidase family protein [Candidatus Saccharimonadales bacterium] diamond 156 93.6 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Saccharimonadia Candidatus Saccharimonadales     Candidatus Saccharimonadales 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);;