RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA929952" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 4 ✖

bioproject 1

  • PRJNA929952 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
4737531 4737531 PRJNA929952_P_NODE_3124_length_699_cov_35.552239_g2339_i0 PRJNA929952 3124 699 35.552239 248.51015061 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 1175 0   NTclustered gi|821341785|gb|CP011389.1| 1309411 g2339 i0 97.009 276.836909871245 702 16 100 5 1 699 1637939 1637240 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 193509 1175 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
7632930 7632930 PRJNA929952_P_NODE_1766_length_882_cov_459.468933_g1266_i0 PRJNA929952 1766 882 459.468933 4052.51598906 Deinococcus 1298 Bacteria Bacteria 898 0   NTclustered gi|2113031129|gb|OK500351.1| 47478 g1266 i0 91.018 74.1077097505669 668 57 76 3 216 882 150 815 Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence blastn 65363 898 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
11458539 11458539 PRJNA929952_P_NODE_21909_length_182_cov_1.980392_g20615_i0 PRJNA929952 21909 182 1.980392 3.60431344 Thermotoga 2335 Bacteria Bacteria 158 3.19e-34   NTclustered gi|806984312|ref|NG_042010.1| 93929 g20615 i0 83.626 96.6978021978022 171 24 93 4 10 178 1004 1172 Thermotoga petrophila strain RKU-1 23S ribosomal RNA gene, complete sequence blastn 17599 158 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga petrophila
21657087 21657087 PRJNA929952_P_NODE_23877_length_159_cov_2.346154_g22583_i0 PRJNA929952 23877 159 2.346154 3.73038486 Deinococcus 1298 Bacteria Bacteria 294 1.98e-75   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g22583 i0 100 208.339622641509 159 0 100 0 1 159 74353 74195 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 33126 294 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis

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