RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1074408" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 6 ✖

bioproject 1

  • PRJNA1074408 · 6 ✖

analysis 1

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
4017547 4017547 PRJNA1074408_S_NODE_9484_length_153_cov_1.745455_g9354_i0 PRJNA1074408 9484 153 1.745455 2.67054615 Oceanotoga sp. DSM 15011 2984951 Bacteria Bacteria 52.8 0.013   NTclustered gi|2321114327|gb|CP107547.1| 2984951 g9354 i0 100 0.183006535947712 28 0 18 0 63 90 1063664 1063637 Oceanotoga sp. DSM 15011 chromosome, complete genome blastn 28 52.8 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Oceanotoga Oceanotoga sp. DSM 15011
14219700 14219700 PRJNA1074408_S_NODE_1792_length_339_cov_2.057432_g1662_i0 PRJNA1074408 1792 339 2.057432 6.97469448 Deinococcus sp. AJ005 2652443 Bacteria Bacteria 497 3.42e-136   NTclustered gi|1761809830|gb|CP044990.1| 2652443 g1662 i0 94.984 259.345132743363 319 12 94 4 23 339 201657 201341 Deinococcus sp. AJ005 chromosome, complete genome blastn 87918 497 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. AJ005
14219703 14219703 PRJNA1074408_S_NODE_2652_length_282_cov_3.949791_g2522_i0 PRJNA1074408 2652 282 3.949791 11.13841062 Deinococcus ficus 317577 Bacteria Bacteria 346 1.07e-90   NTclustered gi|1220362168|gb|CP021081.1| 317577 g2522 i0 89.247 165.893617021277 279 27 98 2 1 277 2342589 2342866 Deinococcus ficus strain CC-FR2-10, complete genome blastn 46782 346 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
15493643 15493643 PRJNA1074408_S_NODE_4993_length_207_cov_1.091463_g4863_i0 PRJNA1074408 4993 207 1.091463 2.25932841 Deinococcus metallilatus 1211322 Bacteria Bacteria 315 2.09e-81   NTclustered gi|1609451317|gb|CP038512.1| 1211322 g4863 i0 94.203 201.072463768116 207 11 100 1 1 207 329327 329532 Deinococcus metallilatus strain MA1002 chromosome blastn 41622 315 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus metallilatus
20592047 20592047 PRJNA1074408_S_NODE_4857_length_210_cov_1.892216_g4727_i0 PRJNA1074408 4857 210 1.892216 3.9736536 Deinococcus aquaticus 328692 Bacteria Bacteria 344 2.7199999999999998e-90   NTclustered gi|2444120906|gb|CP115165.1| 328692 g4727 i0 96.19 32.0571428571429 210 8 100 0 1 210 714804 715013 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 6732 344 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
21867796 21867796 PRJNA1074408_S_NODE_5818_length_193_cov_0.940000_g5688_i0 PRJNA1074408 5818 193 0.94 1.8142 Deinococcus actinosclerus 1768108 Bacteria Bacteria 346 6.82e-91   NTclustered gi|972944657|gb|CP013910.1| 1768108 g5688 i0 98.964 128.663212435233 193 2 100 0 1 193 73424 73616 Deinococcus actinosclerus strain BM2 chromosome, complete genome blastn 24832 346 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);;