RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA681822", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_clade 1

  • delta/epsilon subdivisions · 4 ✖

bioproject 1

  • PRJNA681822 · 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
27871638 27871638 PRJNA681822_P_NODE_299645_length_274_cov_1.532338_g298156_i0 PRJNA681822 299645 274 1.532338 4.19860612 Olavius algarvensis Delta 1 endosymbiont 334747 Bacteria Bacteria 107 3.78e-26   NR CAB1084392.1 334747 g298156 i0 65.5 0.952554744525547 87 27 93.1 2 3 257 34 119 CAB1084392.1 hypothetical protein D1AOALGA4SA_11917 [Olavius algarvensis Delta 1 endosymbiont] diamond 261 107 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Olavius algarvensis Delta 1 endosymbiont
28218768 28218768 PRJNA681822_P_NODE_464846_length_243_cov_0.905882_g463356_i0 PRJNA681822 464846 243 0.905882 2.20129326 Deltaproteobacteria bacterium RBG_13_61_14 1797834 Bacteria Bacteria 42 0.0494   NR OGP60345.1 1797834 g463356 i0 38.5 0.641975308641975 52 21 64.2 1 63 218 43 83 OGP60345.1 MAG: hypothetical protein A2V67_09750 [Deltaproteobacteria bacterium RBG_13_61_14] diamond 156 42 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RBG_13_61_14
28262128 28262128 PRJNA681822_P_NODE_261386_length_284_cov_1.094787_g259897_i0 PRJNA681822 261386 284 1.094787 3.10919508 Bacteria 2 Bacteria Bacteria 72.8 1.04e-12   NR MBF0279729.1 2024889 g259897 i0 47.3 2.29225352112676 74 39 78.2 0 277 56 53 126 MBF0279729.1 response regulator [SAR324 cluster bacterium] diamond 651 72.8 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       SAR324 cluster bacterium
30871856 30871856 PRJNA681822_P_NODE_376394_length_252_cov_2.581006_g374905_i0 PRJNA681822 376394 252 2.581006 6.50413512 Deltaproteobacteria bacterium HGW-Deltaproteobacteria-1 2013736 Bacteria Bacteria 43.1 0.0312   NR PKN73438.1 2013737 g374905 i0 32.8 0.69047619047619 58 37 66.7 1 249 82 200 257 PKN73438.1 MAG: hypothetical protein CVU52_07115 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-10] diamond 174 43.1 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium HGW-Deltaproteobacteria-10

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