RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA753704" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 5 ✖

bioproject 1

  • PRJNA753704 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
18582970 18582970 PRJNA753704_P_NODE_26935_length_245_cov_0.906977_g26574_i0 PRJNA753704 26935 245 0.906977 2.22209365 Meiothermus 65551 Bacteria Bacteria 154 2.54e-45   NR WP_299430933.1 157471 g26574 i0 93.8 7.93469387755102 81 5 99.2 0 243 1 74 154 WP_299430933.1 dihydrolipoyllysine-residue succinyltransferase, partial [uncultured Meiothermus sp.] diamond 1944 155 0.993548387096774 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus uncultured Meiothermus sp.
27147285 27147285 PRJNA753704_P_NODE_26162_length_247_cov_0.896552_g25801_i0 PRJNA753704 26162 247 0.896552 2.21448344 Deinococcus misasensis 392413 Bacteria Bacteria 149 1.85e-39   NR WP_034341935.1 392413 g25801 i0 100 2.69635627530364 74 0 89.9 0 246 25 915 988 WP_034341935.1 FtsK/SpoIIIE family DNA translocase [Deinococcus misasensis] diamond 666 149 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus misasensis
28189673 28189673 PRJNA753704_P_NODE_13926_length_320_cov_1.263158_g13565_i0 PRJNA753704 13926 320 1.263158 4.0421056 Deinococcus misasensis 392413 Bacteria Bacteria 203 3.64e-63   NR WP_034334846.1 392413 g13565 i0 99.1 0.99375 106 1 99.4 0 318 1 56 161 WP_034334846.1 MerR family transcriptional regulator [Deinococcus misasensis] diamond 318 203 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus misasensis
31295031 31295031 PRJNA753704_P_NODE_28055_length_243_cov_0.917647_g27694_i0 PRJNA753704 28055 243 0.917647 2.22988221 Deinococcus 1298 Bacteria Bacteria 164 6.92e-45   NR WP_051963750.1 392413 g27694 i0 100 2.96296296296296 80 0 98.8 0 242 3 1100 1179 WP_051963750.1 ribonuclease R [Deinococcus misasensis] diamond 720 164 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus misasensis
31380246 31380246 PRJNA753704_P_NODE_25496_length_248_cov_1.748571_g25135_i0 PRJNA753704 25496 248 1.748571 4.33645608 Deinococcus cellulosilyticus 401558 Bacteria Bacteria 152 8.269999999999998e-41   NR WP_146889961.1 401558 g25135 i0 97.6 0.991935483870968 82 2 99.2 0 1 246 344 425 WP_146889961.1 tetratricopeptide repeat protein [Deinococcus cellulosilyticus] diamond 246 152 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus cellulosilyticus

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