RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1034994", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermomicrobiota · 4 ✖

tax_kingdom 1

  • Pseudomonadati · 4 ✖

bioproject 1

  • PRJNA1034994 · 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
7385309 7385309 PRJNA1034994_P_NODE_3726_length_284_cov_1.459716_g3642_i0 PRJNA1034994 3726 284 1.459716 4.14559344 Sphaerobacter 2056 Bacteria Bacteria 134 9.1e-27   NTclustered gi|470485500|ref|NR_076704.1| 2057 g3642 i0 93.407 108.197183098592 91 5 32 1 33 123 179 268 Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence blastn 30728 134 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Sphaerobacterales Sphaerobacteraceae Sphaerobacter Sphaerobacter thermophilus
15471123 15471123 PRJNA1034994_P_NODE_5933_length_258_cov_1.664865_g5849_i0 PRJNA1034994 5933 258 1.664865 4.2953517 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 139 4.31e-36   NR HLU37375.1 2482790 g5849 i0 82.1 0.976744186046512 84 15 97.7 0 257 6 32 115 HLU37375.1 arginine--tRNA ligase [Thermomicrobiales bacterium] diamond 252 139 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
16309979 16309979 PRJNA1034994_P_NODE_5353_length_264_cov_3.214660_g5269_i0 PRJNA1034994 5353 264 3.21466 8.4867024 Sphaerobacter 2056 Bacteria Bacteria 156 1.7900000000000002e-33   NTclustered gi|470485500|ref|NR_076704.1| 2057 g5269 i0 80.93 116.056818181818 215 25 76 8 1 201 88 300 Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence blastn 30639 156 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Sphaerobacterales Sphaerobacteraceae Sphaerobacter Sphaerobacter thermophilus
28961772 28961772 PRJNA1034994_P_NODE_4448_length_275_cov_1.524752_g4364_i0 PRJNA1034994 4448 275 1.524752 4.193068 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 124 1.6e-30   NR HWV24490.1 2482790 g4364 i0 62.6 2.00727272727273 91 34 99.3 0 273 1 822 912 HWV24490.1 sortase [Thermomicrobiales bacterium] diamond 552 124 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales 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);;