RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA459724" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 6 ✖

bioproject 1

  • PRJNA459724 · 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
1093997 1093997 PRJNA459724_P_NODE_4021_length_214_cov_3.367568_g3629_i0 PRJNA459724 4021 214 3.367568 7.20659552 Deinococcus 1298 Bacteria Bacteria 226 1.0499999999999999e-54   NTclustered gi|1435316362|gb|CP031158.1| 980427 g3629 i0 85.774 199.38785046729 239 5 98 1 4 213 1793406 1793644 Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome blastn 42669 226 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
7471948 7471948 PRJNA459724_S_NODE_1906_length_170_cov_10.096296_g1903_i0 PRJNA459724 1906 170 10.096296 17.1637032 Truepera 332248 Bacteria Bacteria 239 1.02e-58   NTclustered gi|2573973991|gb|CP133611.1| 332249 g1903 i0 94.231 523.717647058824 156 9 92 0 15 170 762247 762092 Truepera radiovictrix strain CIP 108686 chromosome, complete genome blastn 89032 239 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
15745708 15745708 PRJNA459724_P_NODE_5873_length_152_cov_1.699187_g5481_i0 PRJNA459724 5873 152 1.699187 2.58276424 Deinococcus actinosclerus 1768108 Bacteria Bacteria 276 6.770000000000001e-70   NTclustered gi|972944657|gb|CP013910.1| 1768108 g5481 i0 99.342 113.565789473684 152 1 100 0 1 152 74352 74503 Deinococcus actinosclerus strain BM2 chromosome, complete genome blastn 17262 276 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus actinosclerus
19568823 19568823 PRJNA459724_S_NODE_776_length_213_cov_3.719101_g773_i0 PRJNA459724 776 213 3.719101 7.92168513 Deinococcus grandis 57498 Bacteria Bacteria 333 5.979999999999998e-87   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g773 i0 94.836 3.018779342723 213 11 100 0 1 213 2868512 2868724 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 643 333 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
24045885 24045885 PRJNA459724_P_NODE_3799_length_225_cov_3.056122_g3407_i0 PRJNA459724 3799 225 3.056122 6.8762745 Deinococcus 1298 Bacteria Bacteria 405 1.33e-108   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g3407 i0 99.111 262.924444444444 225 2 100 0 1 225 73756 73532 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 59158 405 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
24669174 24669174 PRJNA459724_P_NODE_3160_length_264_cov_2.400000_g2769_i0 PRJNA459724 3160 264 2.4 6.336 Deinococcus actinosclerus 1768108 Bacteria Bacteria 483 7.219999999999998e-132   NTclustered gi|972944657|gb|CP013910.1| 1768108 g2769 i0 99.621 212.875 264 1 100 0 1 264 73842 74105 Deinococcus actinosclerus strain BM2 chromosome, complete genome blastn 56199 483 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus actinosclerus

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