RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA937226", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_phylum 1

  • Acidobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA937226 · 4 ✖

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
3462831 3462831 PRJNA937226_S_NODE_6543_length_281_cov_3.202586_g6416_i0 PRJNA937226 6543 281 3.202586 8.99926666 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 375 1.3499999999999995e-99   NTclustered gi|2874254027|emb|OY970352.1| 171953 g6416 i0 91.273 107.572953736655 275 24 98 0 7 281 2366991 2367265 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 blastn 30228 375 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
7290010 7290010 PRJNA937226_S_NODE_12386_length_224_cov_4.097143_g12259_i0 PRJNA937226 12386 224 4.097143 9.17760032 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 270 5.05e-68   NTclustered gi|2874253692|emb|OY969418.1| 171953 g12259 i0 88.393 93.5446428571429 224 26 100 0 1 224 4233515 4233738 MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 blastn 20954 270 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
9839957 9839957 PRJNA937226_S_NODE_9948_length_243_cov_5.644330_g9821_i0 PRJNA937226 9948 243 5.64433 13.7157219 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 84.2 7.77e-12   NTclustered gi|112980875|gb|DQ829679.1| 171953 g9821 i0 94.444 5.87242798353909 54 3 22 0 188 241 319 266 Uncultured Acidobacteria bacterium clone DON5 23S ribosomal RNA gene, partial sequence blastn 1427 84.2 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
27214452 27214452 PRJNA937226_S_NODE_20062_length_185_cov_3.235294_g19935_i0 PRJNA937226 20062 185 3.235294 5.9852939 Acidobacteriota bacterium 1978231 Bacteria Bacteria 42 0.0314   NR MBM3765365.1 1978231 g19935 i0 42 0.810810810810811 50 25 81.1 1 31 180 163 208 MBM3765365.1 hypothetical protein [Acidobacteriota bacterium] diamond 150 42 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota 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);;