RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB50332" 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

  • PRJEB50332 · 6 ✖

analysis 1

  • diamond · 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
1393903 1393903 PRJEB50332_P_NODE_7102_length_241_cov_1.272222_g7020_i0 PRJEB50332 7102 241 1.272222 3.06605502 Deinococcus 1298 Bacteria Bacteria 115 4.54e-31   NR CAM3848666.1 249406 g7020 i0 83.6 1.59336099585062 67 11 83.4 0 202 2 4 70 CAM3848666.1 HTH hxlR-type domain-containing protein [Deinococcus saxicola] diamond 384 115 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus saxicola
11597724 11597724 PRJEB50332_P_NODE_15250_length_206_cov_1.593103_g15168_i0 PRJEB50332 15250 206 1.593103 3.28179218 Thermus composti 532059 Bacteria Bacteria 135 9.92e-37   NR WP_188846282.1 532059 g15168 i0 100 0.990291262135922 68 0 99 0 205 2 25 92 WP_188846282.1 S1C family serine protease [Thermus composti] diamond 204 135 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus composti
27381382 27381382 PRJEB50332_P_NODE_8423_length_233_cov_1.941860_g8341_i0 PRJEB50332 8423 233 1.94186 4.5245338 Thermus composti 532059 Bacteria Bacteria 154 3.69e-43   NR WP_188847238.1 532059 g8341 i0 100 0.991416309012876 77 0 99.1 0 1 231 134 210 WP_188847238.1 MFS transporter [Thermus composti] diamond 231 154 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus composti
28707438 28707438 PRJEB50332_P_NODE_10067_length_224_cov_1.558282_g9985_i0 PRJEB50332 10067 224 1.558282 3.49055168 Thermus composti 532059 Bacteria Bacteria 147 3.61e-42   NR WP_188847676.1 532059 g9985 i0 98.6 0.991071428571429 74 1 99.1 0 224 3 3 76 WP_188847676.1 ABC transporter ATP-binding protein [Thermus composti] diamond 222 147 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus composti
31044943 31044943 PRJEB50332_P_NODE_16355_length_204_cov_1.818182_g16273_i0 PRJEB50332 16355 204 1.818182 3.70909128 uncultured Truepera sp. 543023 Bacteria Bacteria 132 1.12e-35   NR CAA9583804.1 543023 g16273 i0 97 0.985294117647059 67 2 98.5 0 2 202 155 221 CAA9583804.1 MAG: Ribose ABC transport system, permease protein RbsC [uncultured Truepera sp.] diamond 201 132 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
31076324 31076324 PRJEB50332_P_NODE_9015_length_230_cov_1.402367_g8933_i0 PRJEB50332 9015 230 1.402367 3.2254441 Deinococcus aquatilis 519440 Bacteria Bacteria 149 3.77e-44   NR WP_019010945.1 519440 g8933 i0 100 0.860869565217391 66 0 86.1 0 229 32 92 157 WP_019010945.1 DUF4262 domain-containing protein [Deinococcus aquatilis] diamond 198 149 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquatilis

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