RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA399711" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 10 ✖

bioproject 1

  • PRJNA399711 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
25307106 25307106 PRJNA399711_P_NODE_17060_length_170_cov_8.857143_g16994_i0 PRJNA399711 17060 170 8.857143 15.0571431 Deinococcus 1298 Bacteria Bacteria 292 7.69e-75   NTclustered gi|1214784344|gb|KY476423.1| 47478 g16994 i0 98.214 102.776470588235 168 1 98 1 1 166 482 649 Deinococcus sp. strain A3-4 16S ribosomal RNA gene, partial sequence blastn 17472 292 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
25699033 25699033 PRJNA399711_S_NODE_28794_length_242_cov_5.853659_g28652_i0 PRJNA399711 28794 242 5.853659 14.16585478 Deinococcus sp. QL22 2939437 Bacteria Bacteria 309 1.17e-79   NTclustered gi|2238960682|gb|CP097150.1| 2939437 g28652 i0 89.669 1 242 25 100 0 1 242 508014 508255 Deinococcus sp. QL22 plasmid unnamed5, complete sequence blastn 242 309 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. QL22
25700840 25700840 PRJNA399711_S_NODE_74714_length_172_cov_2.681481_g74572_i0 PRJNA399711 74714 172 2.681481 4.61214732 Deinococcus geothermalis DSM 113 68909 Bacteria Bacteria 315 1.6699999999999996e-81   NTclustered gi|94554390|gb|CP000359.1| 319795 g74572 i0 100 2.12209302325581 170 0 99 0 3 172 1001377 1001546 Deinococcus geothermalis DSM 11300, complete genome blastn 365 315 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus geothermalis
25836530 25836530 PRJNA399711_S_NODE_64483_length_181_cov_6.819444_g64341_i0 PRJNA399711 64483 181 6.819444 12.34319364 Deinococcus sp. R-36685 875297 Bacteria Bacteria 82.4 1.96e-11   NTclustered gi|308814839|emb|FR682760.1| 875297 g64341 i0 100 23.8176795580111 44 0 24 0 138 181 1375 1332 Deinococcus sp. R-36685 partial 16S rRNA gene, strain R-36685 blastn 4311 82.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. R-36685
26168991 26168991 PRJNA399711_S_NODE_19749_length_276_cov_275.627615_g19607_i0 PRJNA399711 19749 276 275.627615 760.7322174 Truepera 332248 Bacteria Bacteria 316 8.149999999999999e-82   NTclustered gi|2573973991|gb|CP133611.1| 332249 g19607 i0 91.703 365.115942028986 229 18 83 1 18 245 762020 762248 Truepera radiovictrix strain CIP 108686 chromosome, complete genome blastn 100772 316 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
26169091 26169091 PRJNA399711_S_NODE_43333_length_210_cov_1.583815_g43191_i0 PRJNA399711 43333 210 1.583815 3.3260115 Truepera 332248 Bacteria Bacteria 200 6.22e-47   NTclustered gi|2573973991|gb|CP133611.1| 332249 g43191 i0 83.886 1.96666666666667 211 32 100 2 1 210 274081 274290 Truepera radiovictrix strain CIP 108686 chromosome, complete genome blastn 413 200 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
26244936 26244936 PRJNA399711_S_NODE_62886_length_183_cov_3.671233_g62744_i0 PRJNA399711 62886 183 3.671233 6.71835639 Allomeiothermus silvanus DSM 9946 526227 Bacteria Bacteria 322 1.08e-83   NTclustered gi|296848933|gb|CP002042.1| 526227 g62744 i0 98.361 1 183 3 100 0 1 183 2875020 2875202 Meiothermus silvanus DSM 9946, complete genome blastn 183 322 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Allomeiothermus Allomeiothermus silvanus
26246073 26246073 PRJNA399711_S_NODE_96286_length_157_cov_2.700000_g96144_i0 PRJNA399711 96286 157 2.7 4.239 Allomeiothermus silvanus DSM 9946 526227 Bacteria Bacteria 230 5.58e-56   NTclustered gi|296848933|gb|CP002042.1| 526227 g96144 i0 96.429 0.89171974522293 140 3 89 2 13 151 1602699 1602837 Meiothermus silvanus DSM 9946, complete genome blastn 140 230 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Allomeiothermus Allomeiothermus silvanus
26381496 26381496 PRJNA399711_S_NODE_85695_length_164_cov_1.582677_g85553_i0 PRJNA399711 85695 164 1.582677 2.59559028 Deinococcus sp. QL22 2939437 Bacteria Bacteria 161 2.1799999999999997e-35   NTclustered gi|2238962615|gb|CP097154.1| 2939437 g85553 i0 85.621 0.932926829268293 153 22 93 0 4 156 49679 49831 Deinococcus sp. QL22 plasmid unnamed6, complete sequence blastn 153 161 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. QL22
26381779 26381779 PRJNA399711_S_NODE_94551_length_158_cov_2.826446_g94409_i0 PRJNA399711 94551 158 2.826446 4.46578468 Allomeiothermus silvanus DSM 9946 526227 Bacteria Bacteria 287 3.29e-73   NTclustered gi|296848933|gb|CP002042.1| 526227 g94409 i0 99.367 1 158 1 100 0 1 158 2269859 2270016 Meiothermus silvanus DSM 9946, complete genome blastn 158 287 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Allomeiothermus Allomeiothermus silvanus

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