RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Thermomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermomicrobiota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1148190 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
2843508 2843508 PRJNA1148190_P_NODE_231323_length_354_cov_1.451957_g220153_i0 PRJNA1148190 231323 354 1.451957 5.13992778 Sphaerobacter thermophilus 2057 Bacteria Bacteria 241 6.660000000000001e-59   NTclustered gi|269785296|gb|CP001823.1| 479434 g220153 i0 79.651 104.985875706215 344 62 96 7 2 341 1224742 1224403 Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence blastn 37165 241 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Sphaerobacterales Sphaerobacteraceae Sphaerobacter Sphaerobacter thermophilus
6677377 6677377 PRJNA1148190_P_NODE_72886_length_649_cov_1.838542_g61790_i0 PRJNA1148190 72886 649 1.838542 11.93213758 Sphaerobacter thermophilus 2057 Bacteria Bacteria 433 1.9699999999999998e-116   NTclustered gi|269785296|gb|CP001823.1| 479434 g61790 i0 79.833 1.81510015408321 600 116 92 5 3 599 169717 169120 Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence blastn 1178 433 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Sphaerobacterales Sphaerobacteraceae Sphaerobacter Sphaerobacter thermophilus
11774780 11774780 PRJNA1148190_P_NODE_466150_length_273_cov_1.510000_g454977_i0 PRJNA1148190 466150 273 1.51 4.1223 Sphaerobacter thermophilus 2057 Bacteria Bacteria 198 3.0399999999999993e-46   NTclustered gi|269785296|gb|CP001823.1| 479434 g454977 i0 81.377 9.57509157509157 247 42 90 4 1 245 1218388 1218632 Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence blastn 2614 198 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Sphaerobacterales Sphaerobacteraceae Sphaerobacter Sphaerobacter thermophilus
14328619 14328619 PRJNA1148190_P_NODE_738732_length_243_cov_0.905882_g727559_i0 PRJNA1148190 738732 243 0.905882 2.20129326 Sphaerobacter thermophilus 2057 Bacteria Bacteria 191 4.45e-44   NTclustered gi|269787736|gb|CP001824.1| 479434 g727559 i0 81.328 0.991769547325103 241 39 98 5 6 243 1117400 1117637 Sphaerobacter thermophilus DSM 20745 chromosome 2, complete sequence blastn 241 191 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Sphaerobacterales Sphaerobacteraceae Sphaerobacter Sphaerobacter thermophilus
18150010 18150010 PRJNA1148190_P_NODE_632715_length_249_cov_0.875000_g621542_i0 PRJNA1148190 632715 249 0.875 2.17875 Sphaerobacter thermophilus 2057 Bacteria Bacteria 152 2.1599999999999998e-32   NTclustered gi|269787736|gb|CP001824.1| 479434 g621542 i0 85.517 1.32931726907631 145 21 58 0 11 155 76730 76586 Sphaerobacter thermophilus DSM 20745 chromosome 2, complete sequence blastn 331 152 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Sphaerobacterales Sphaerobacteraceae Sphaerobacter Sphaerobacter thermophilus
20700336 20700336 PRJNA1148190_P_NODE_679417_length_246_cov_0.890173_g668244_i0 PRJNA1148190 679417 246 0.890173 2.18982558 Sphaerobacter thermophilus 2057 Bacteria Bacteria 163 9.84e-36   NTclustered gi|269785296|gb|CP001823.1| 479434 g668244 i0 82.967 45.219512195122 182 29 74 2 1 181 1784252 1784432 Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence blastn 11124 163 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Sphaerobacterales Sphaerobacteraceae Sphaerobacter Sphaerobacter thermophilus

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