RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA557436" and tax_clade = "delta/epsilon subdivisions"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • delta/epsilon subdivisions · 4 ✖

bioproject 1

  • PRJNA557436 · 4 ✖

analysis 1

tax_phylum 0

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
27503934 27503934 PRJNA557436_S_NODE_2683_length_233_cov_1.752525_g2635_i0 PRJNA557436 2683 233 1.752525 4.08338325 root 1 Root_unresolved Root_unresolved 87 7.79e-18   NR OQB75644.1 1852867 g2635 i0 47.2 2.85836909871245 72 38 92.7 0 2 217 161 232 OQB75644.1 MAG: Glycosyl transferase family 2 [Deltaproteobacteria bacterium ADurb.Bin135] diamond 666 87.4 0.995423340961098 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium ADurb.Bin135
29776943 29776943 PRJNA557436_S_NODE_5011_length_184_cov_1.805369_g4963_i0 PRJNA557436 5011 184 1.805369 3.32187896 Bacteria 2 Bacteria Bacteria 80.1 1.15e-15   NR OQB75645.1 1852867 g4963 i0 60.3 2.82065217391304 58 23 94.6 0 180 7 74 131 OQB75645.1 MAG: hypothetical protein BWX92_02520 [Deltaproteobacteria bacterium ADurb.Bin135] diamond 519 80.1 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium ADurb.Bin135
30236807 30236807 PRJNA557436_S_NODE_7352_length_162_cov_1.259843_g7304_i0 PRJNA557436 7352 162 1.259843 2.04094566 Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_ 2026735 Bacteria Bacteria 78.2 4.07e-15   NR PIR25616.1 1973973 g7304 i0 68 0.925925925925926 50 16 92.6 0 162 13 419 468 PIR25616.1 MAG: phage tail protein [Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_42_23] diamond 150 78.2 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_42_23
32323826 32323826 PRJNA557436_S_NODE_1119_length_342_cov_2.423453_g1071_i0 PRJNA557436 1119 342 2.423453 8.28820926 Deltaproteobacteria bacterium ADurb.Bin135 1852867 Bacteria Bacteria 149 2.65e-39   NR OQB75650.1 1852867 g1071 i0 65.5 2.97368421052632 113 39 99.1 0 3 341 328 440 OQB75650.1 MAG: hypothetical protein BWX92_02525 [Deltaproteobacteria bacterium ADurb.Bin135] diamond 1017 149 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium ADurb.Bin135

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);;